forked from science-ation/science-ation
e9d3d4ce03
- Load/Save feeder fair awards in the award editor - Fix all the POSTs in the award editor. .load automatically does a POST if the data is an array, so we need to call .serializeArray() when we want a post to happen.
11 lines
308 B
SQL
11 lines
308 B
SQL
ALTER TABLE `fairs` DROP `award_awards_ids` ;
|
|
|
|
CREATE TABLE `fairs_awards_link` (
|
|
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
|
|
`fairs_id` INT NOT NULL ,
|
|
`award_awards_id` INT NOT NULL ,
|
|
`download_award` ENUM( 'no', 'yes' ) NOT NULL ,
|
|
`upload_winners` ENUM( 'no', 'yes' ) NOT NULL
|
|
) ENGINE = MYISAM ;
|
|
|