forked from science-ation/science-ation
46b39f81e0
Add code in create conference and copy conference to set copyoriginal and copyparent Add missing json_decode to API (we expect ALL arrays being POSTED to be json encoded)
7 lines
237 B
SQL
7 lines
237 B
SQL
ALTER TABLE `conferences`
|
|
ADD `copyoriginal` INT NOT NULL AFTER `status` ,
|
|
ADD `copyparent` INT NOT NULL AFTER `copyoriginal` ,
|
|
ADD `notes` TEXT NOT NULL AFTER `copyparent`;
|
|
|
|
UPDATE `conferences` SET copyoriginal=id, copyparent=id;
|