forked from science-ation/science-ation
12 lines
634 B
SQL
12 lines
634 B
SQL
CREATE TABLE `judges_availability` (
|
|
`id` INT NOT NULL AUTO_INCREMENT ,
|
|
`users_id` INT NOT NULL ,
|
|
`date` DATE NOT NULL ,
|
|
`start` TIME NOT NULL ,
|
|
`end` TIME NOT NULL ,
|
|
PRIMARY KEY ( `id` )
|
|
) ENGINE = MYISAM ;
|
|
|
|
INSERT INTO `config` ( `var` , `val` , `category` , `type` , `type_values` , `ord` , `description` , `year`)
|
|
VALUES ( 'judges_availability_enable', 'no', 'Judge Registration', 'yesno', '', '950', 'Allow judges to specify their time availability on the fair day based on the defined judging rounds/timeslots. The scheduler will then use this judge availability data when assigning judges to teams and projects.', '-1');
|