2010-06-03 19:21:27 +00:00
|
|
|
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;
|
2010-06-03 19:29:31 +00:00
|
|
|
ALTER TABLE `dates` ADD `conferences_id` INT NULL DEFAULT NULL;
|
