science-ation/db/db.update.220.sql

8 lines
375 B
SQL

ALTER TABLE `projectcategories` DROP PRIMARY KEY;
ALTER TABLE `projectcategories` ADD PRIMARY KEY (`id`, `conferences_id`);
ALTER TABLE `projectdivisions` DROP PRIMARY KEY;
ALTER TABLE `projectdivisions` ADD PRIMARY KEY (`id`, `conferences_id`);
ALTER TABLE `projectsubdivisions` DROP PRIMARY KEY;
ALTER TABLE `projectsubdivisions` ADD PRIMARY KEY (`id`, `conferences_id`);