science-ation/db/db.update.225.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;
Add copyoriginal, copyparent, and notes(currently unused) to conferences table 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) 2010-11-25 20:45:44 +00:00			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;