Scarab commit: svn commit: r10209 - branches/release/b21/src/sql/mysql/upgrade

Author: dabbous
Date: 2006-07-19 02:06:40-0700
New Revision: 10209

Modified:
   branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql
   branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql

Log:
mysql problem during upgrade: if the default database engine is NOT MyISAM,
upgrade would fail with foreign key constraints, because new tables are
generated in the migration scripts. these tables MUST be created with the
same engine as the already existing tables. a quick workaround (not working for
every case) is to fix table creation to engine=MyISAM

we need a better solution here, because it may be WANTED to have all tables
beenm created with engine=INNODB



Modified: branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql?view=diff&rev=10209&p1=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql&p2=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql&r1=10208&r2=10209
==============================================================================
--- branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql	(original)
+++ branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql	2006-07-19 02:06:40-0700
@@ -24,7 +24,7 @@
     FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
     FOREIGN KEY (ACTIVITY_ID) REFERENCES SCARAB_ACTIVITY (ACTIVITY_ID),
     INDEX IX_NOTIF_STATUS (STATUS)
-);
+)ENGINE=MyISAM;
 
 --
 -- SCARAB_NOTIFICATION_FILTER
@@ -42,7 +42,7 @@
     PRIMARY KEY(MODULE_ID,USER_ID,ACTIVITY_TYPE,MANAGER_ID),
     FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
     FOREIGN KEY (MODULE_ID) REFERENCES SCARAB_MODULE (MODULE_ID)
-);
+)ENGINE=MyISAM;
 
 --
 -- SCARAB_DEFAULT_NOTIFICATION_FILTER
@@ -56,6 +56,6 @@
   FILTER_STATE int(1) NOT NULL default '0',
   MODIFYABlE int(1) NOT NULL default '1',
   PRIMARY KEY  (MODULE_ID,ROLE_ID,ACTIVITY_TYPE,MANAGER_ID)
-);
+)ENGINE=MyISAM;
 
 SET FOREIGN_KEY_CHECKS = 1; 

Modified: branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql?view=diff&rev=10209&p1=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql&p2=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql&r1=10208&r2=10209
==============================================================================
--- branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql	(original)
+++ branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-3.sql	2006-07-19 02:06:40-0700
@@ -33,8 +33,6 @@
 
 DROP TABLE SCARAB_ISSUE;
 
--- SET FOREIGN_KEY_CHECKS = 0; 
-
 CREATE TABLE SCARAB_ISSUE
 (
     PRIMARY KEY(ISSUE_ID),
@@ -44,7 +42,7 @@
 (TRANSACTION_ID),
     INDEX IX_TYPE_MODULE (TYPE_ID, MODULE_ID),
     INDEX IX_COUNT_PREFIX (ID_COUNT, ID_PREFIX)
-)
+)ENGINE=MyISAM
 SELECT i.ISSUE_ID, i.ID_PREFIX, i.ID_COUNT, i.ID_DOMAIN, i.TYPE_ID,
        i.MODULE_ID, i.CREATED_TRANS_ID,
        max(a.transaction_id) LAST_TRANS_ID, 
@@ -52,5 +50,3 @@
 FROM SCARAB_ISSUE_BACKUP_b20_b21 i LEFT OUTER JOIN SCARAB_ACTIVITY a ON
        (i.ISSUE_ID = a.ISSUE_ID)
 GROUP BY i.ISSUE_ID;
-
--- SET FOREIGN_KEY_CHECKS = 1;