Changes between Version 29 and Version 30 of mark_deduction

Timestamp:

2012-02-25T07:32:25Z (13 years ago)

Author:

Pan Luo

Comment:

--

mark_deduction

@@ -10 +10 @@
 * Two new tables have been added : Penalty, and User_grade_penalty.
 * Run the attached SQL queries to update your current database.
+{{{
+#!sql
+CREATE TABLE `penalties` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `event_id` int(11) DEFAULT NULL,
+  `days_late` int(11) NOT NULL,
+  `percent_penalty` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_events` (`event_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+
+ALTER TABLE `penalties`
+  ADD CONSTRAINT `fk_events` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;
+}}}
 == Implementation ==
 * An instructor or admin can choose to apply ONE late penalty scale to an event.