forked from science-ation/science-ation
4eea632521
For a feeder fair specifying the upstream fair, this means the feeder fair will request to download stats, download awards, and upload winners. For the upstream fair specifying feeder fairs, this means the feeder fair is allowed to upload stats, download awards, and upload winners. --This line, and those below, will be ignored-- M db/db.update.128.sql
13 lines
903 B
SQL
13 lines
903 B
SQL
INSERT INTO `config` (`var`, `val`, `category`, `type`, `type_values`, `ord`, `description`, `year`) VALUES
|
|
('fair_stats_info', 'yes', 'Science Fairs', 'yesno', '', 600, 'Gather Stats: Information about the fair (date, location, budget, charity info).', -1),
|
|
('fair_stats_next_chair', 'yes', 'Science Fairs', 'yesno', '', 700, 'Gather Stats: Chairperson name and contact info for the next year', -1),
|
|
('fair_stats_scholarships', 'yes', 'Science Fairs', 'yesno', '', 800, 'Gather Stats: Scholarships given out by the fair', -1),
|
|
('fair_stats_delegates', 'yes', 'Science Fairs', 'yesno', '', '900', 'Gather Stats: CWSF Delegate names/email/jacket size', '-1');
|
|
|
|
|
|
ALTER TABLE `fairs` ADD `website` TINYTEXT NOT NULL AFTER `url` ;
|
|
|
|
ALTER TABLE `fairs` ADD `enable_stats` ENUM( 'no', 'yes' ) NOT NULL ,
|
|
ADD `enable_awards` ENUM( 'no', 'yes' ) NOT NULL ,
|
|
ADD `enable_winners` ENUM( 'no', 'yes' ) NOT NULL ;
|