forked from science-ation/science-ation
9 lines
377 B
SQL
9 lines
377 B
SQL
CREATE TABLE `conferences` (
|
|
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
|
|
`name` VARCHAR( 128 ) NOT NULL ,
|
|
`type` ENUM( 'sciencefair', 'scienceolympics' ) NOT NULL ,
|
|
`status` ENUM( 'pending', 'running', 'ended' ) NOT NULL
|
|
) ENGINE = MYISAM ;
|
|
ALTER TABLE `config` ADD `conferences_id` INT NULL DEFAULT NULL;
|
|
ALTER TABLE `dates` ADD `conferences_id` INT NULL DEFAULT NULL;
|