Commits

Anonymous committed 56b383b

fix 268 migration and odd thing with 96

Comments (0)

Files changed (3)

migrations/storage/268/aclDown.sql

 (13, 'user', '/images/dashboard/moduleBar/magic-user.gif', 1, '2010-08-20 17:05:42', '2010-12-25 21:00:25'),
 (14, 'email', NULL, 0, '2010-10-17 13:01:53', NULL),
 (15, 'prospects', '/images/dashboard/moduleBar/magic-prospect.png', 1, '2011-02-13 15:03:36', NULL);
-SET FOREIGN_KEY_CHECKS=1;
-
-ALTER TABLE `prospects` CHANGE `occupants` `occupants` int(11) NOT NULL;
-
+SET FOREIGN_KEY_CHECKS=1;

migrations/storage/268/aclUp.sql

 ALTER TABLE reports ADD CONSTRAINT reports_ibfk_1 FOREIGN KEY ( moduleId ) REFERENCES modules (id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE permission ADD CONSTRAINT permission_ibfk_1 FOREIGN KEY ( moduleId ) REFERENCES modules (id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE rolePermission ADD CONSTRAINT rolePermission_ibfk_1 FOREIGN KEY ( roleId ) REFERENCES role (id) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE rolePermission ADD CONSTRAINT rolePermission_ibfk_2 FOREIGN KEY ( permissionId ) REFERENCES permission (id) ON DELETE CASCADE ON UPDATE CASCADE;
-
-ALTER TABLE `prospects` CHANGE `occupants` `occupants` TEXT NOT NULL; 
+ALTER TABLE rolePermission ADD CONSTRAINT rolePermission_ibfk_2 FOREIGN KEY ( permissionId ) REFERENCES permission (id) ON DELETE CASCADE ON UPDATE CASCADE;

migrations/storage/96/tableFixesUp.sql

---	Collection of tables that I find with errors
--- Just in case ...
-TRUNCATE TABLE `deposit`;
+/*	Collection of tables that I find with errors
+ Just in case ...
+ TRUNCATE TABLE `deposit`;
+*/ 
 ALTER TABLE `deposit` 
 DROP COLUMN `debitAccountId`,
 DROP COLUMN `creditAccountId`;