Changes between Version 30 and Version 31 of mark_deduction

Timestamp:

2012-02-25T07:33:33Z (12 years ago)

Author:

Pan Luo

Comment:

--

mark_deduction

@@ -23 +23 @@
 ALTER TABLE `penalties`
   ADD CONSTRAINT `fk_events` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;
+
+CREATE TABLE `user_grade_penalties` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `penalty_id` int(11) DEFAULT NULL,
+  `grp_event_id` int(11) NOT NULL,
+  `user_id` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_penalties` (`penalty_id`),
+  KEY `fk_users` (`user_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+
+ALTER TABLE `user_grade_penalties`
+  ADD CONSTRAINT `fk_penalties` FOREIGN KEY (`penalty_id`) REFERENCES `penalties` (`id`) ON DELETE CASCADE,
+  ADD CONSTRAINT `fk_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
 }}}
+
 == Implementation ==
 * An instructor or admin can choose to apply ONE late penalty scale to an event.