Changes between Version 29 and Version 30 of mark_deduction


Ignore:
Timestamp:
2012-02-25T07:32:25Z (12 years ago)
Author:
Pan Luo
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • mark_deduction

    v29 v30  
    1010* Two new tables have been added : Penalty, and User_grade_penalty.
    1111* Run the attached SQL queries to update your current database.
     12{{{
     13#!sql
     14CREATE TABLE `penalties` (
     15  `id` int(11) NOT NULL AUTO_INCREMENT,
     16  `event_id` int(11) DEFAULT NULL,
     17  `days_late` int(11) NOT NULL,
     18  `percent_penalty` int(11) NOT NULL,
     19  PRIMARY KEY (`id`),
     20  KEY `fk_events` (`event_id`)
     21) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
     22
     23ALTER TABLE `penalties`
     24  ADD CONSTRAINT `fk_events` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;
     25}}}
    1226== Implementation ==
    1327* An instructor or admin can choose to apply ONE late penalty scale to an event.