science-ation/db/db.update.177.sql
2010-06-10 20:37:49 +00:00

11 lines
354 B
SQL

CREATE TABLE `events` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`conferences_id` INT NOT NULL ,
`name` VARCHAR( 64 ) NOT NULL ,
`summary` TEXT NULL ,
`description_link` VARCHAR( 256 ) NULL ,
`suggested_grades` VARCHAR( 64 ) NULL ,
`min_judges` INT NULL ,
`max_judges` INT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;