david
28b02db2ea
git-svn-id: https://192.168.0.254/svn/Proyectos.Incam_SGD/tags/3.7.0.2_original@1 eb19766c-00d9-a042-a3a0-45cb8ec72764
9 lines
486 B
SQL
9 lines
486 B
SQL
SET FOREIGN_KEY_CHECKS=0;
|
|
ALTER TABLE `groups_lookup` ADD COLUMN `unit_id` int(11) default NULL;
|
|
ALTER TABLE `groups_lookup` ADD INDEX `unit_id` (`unit_id`);
|
|
ALTER TABLE `units_lookup` ADD COLUMN `folder_id` int(11) default NULL;
|
|
ALTER TABLE `units_lookup` ADD UNIQUE `folder_id` (`folder_id`);
|
|
ALTER TABLE `groups_lookup` TYPE=InnoDB;
|
|
ALTER TABLE `groups_lookup` ADD CONSTRAINT `groups_lookup_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `units_lookup` (`id`);
|
|
SET FOREIGN_KEY_CHECKS=1;
|