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

Author: ronvoe122
Date: 2006-12-23 03:13:57-0800
New Revision: 10394

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:
[SCB2257] fixed incompatibilities with mysql5 in upgrade scripts:
- changed all mediumint columns to integer columns
- switched off fk checking in migration of scarab_issue

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=10394&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=10393&r2=10394
==============================================================================
--- 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-12-23 03:13:57-0800
@@ -13,9 +13,9 @@
 CREATE TABLE SCARAB_NOTIFICATION_STATUS
 (
     ACTIVITY_ID BIGINT NOT NULL,
-    CREATOR_ID MEDIUMINT NOT NULL,
-    RECEIVER_ID MEDIUMINT NOT NULL,
-    STATUS MEDIUMINT NOT NULL,
+    CREATOR_ID INTEGER NOT NULL,
+    RECEIVER_ID INTEGER NOT NULL,
+    STATUS INTEGER NOT NULL,
     CREATION_DATE DATETIME,
     CHANGE_DATE DATETIME,
     STATUS_COMMENT VARCHAR(255),
@@ -35,10 +35,10 @@
 
 CREATE TABLE SCARAB_NOTIFICATION_FILTER
 (
-    MODULE_ID MEDIUMINT NOT NULL,
-    USER_ID MEDIUMINT NOT NULL,
+    MODULE_ID INTEGER NOT NULL,
+    USER_ID INTEGER NOT NULL,
     ACTIVITY_TYPE VARCHAR(30) NOT NULL,
-    MANAGER_ID MEDIUMINT default 0 NOT NULL,
+    MANAGER_ID INTEGER default 0 NOT NULL,
     FILTER_STATE INTEGER(1) default 0 NOT NULL,
     SEND_SELF INTEGER(1) default 0 NOT NULL,
     SEND_FAILURES INTEGER(1) default 0 NOT NULL,
@@ -52,12 +52,12 @@
 --
 
 CREATE TABLE SCARAB_DEFAULT_NOTIFICATION_FILTER (
-  MODULE_ID mediumint(9) NOT NULL,
-  ROLE_ID mediumint(9) NOT NULL,
+  MODULE_ID INTEGER NOT NULL,
+  ROLE_ID INTEGER NOT NULL,
   ACTIVITY_TYPE varchar(30) NOT NULL,
-  MANAGER_ID mediumint(9) NOT NULL,
-  FILTER_STATE int(1) NOT NULL default '0',
-  MODIFYABlE int(1) NOT NULL default '1',
+  MANAGER_ID INTEGER NOT NULL,
+  FILTER_STATE INTEGER(1) NOT NULL default 0,
+  MODIFYABlE INTEGER(1) NOT NULL default 1,
   PRIMARY KEY  (MODULE_ID,ROLE_ID,ACTIVITY_TYPE,MANAGER_ID)
 );
 

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=10394&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=10393&r2=10394
==============================================================================
--- 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-12-23 03:13:57-0800
@@ -33,6 +33,8 @@
 
 DROP TABLE SCARAB_ISSUE;
 
+SET FOREIGN_KEY_CHECKS = 0; 
+
 CREATE TABLE SCARAB_ISSUE
 (
     PRIMARY KEY(ISSUE_ID),
@@ -50,3 +52,5 @@
 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;