science-ation/db/db.update.209.sql
james 4f42407073 migrate categories/divisions/subdivisions from FAIRYEAR to conferences_id
rename API call /config to /config/variables
update API with /config members for divisions/subdivisions/categories
2010-10-05 19:43:30 +00:00

5 lines
283 B
SQL

ALTER TABLE `projectdivisions` ADD `conferences_id` INT NOT NULL;
ALTER TABLE `projectcategories` ADD `conferences_id` INT NOT NULL;
ALTER TABLE `projectsubdivisions` ADD `conferences_id` INT NOT NULL;
ALTER TABLE `projectcategoriesdivisions_link` ADD `conferences_id` INT NOT NULL;