[otrs-cvs] otrs/scripts DBUpdate-to-3.2.postgresql.sql, 1.18, 1.19 DBUpdate-to-3.2.ingres.sql, 1.18, 1.19 DBUpdate-to-3.2.db2.sql, 1.18, 1.19 DBUpdate-to-3.2.postgresql_before_8_2.sql, 1.18, 1.19 DBUpdate-to-3.2.mssql.sql, 1.18, 1.19 DBUpdate-to-3.2.mysql.sql, 1.18, 1.19 DBUpdate-to-3.2.oracle.sql, 1.18, 1.19

"CVS commits notifications of OTRS.org" <[email protected]>
Newsgroups gmane.comp.otrs.cvs
Message-ID <[email protected]> 
Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv28498/scripts

Modified Files:
	DBUpdate-to-3.2.postgresql.sql DBUpdate-to-3.2.ingres.sql 
	DBUpdate-to-3.2.db2.sql 
	DBUpdate-to-3.2.postgresql_before_8_2.sql 
	DBUpdate-to-3.2.mssql.sql DBUpdate-to-3.2.mysql.sql 
	DBUpdate-to-3.2.oracle.sql 
Log Message:
Fixed bug#9092 - Problem running DBUpdate-to-3.2.mysql.sql on InnoDB.

Author: mg

Index: DBUpdate-to-3.2.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.postgresql.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.postgresql.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.postgresql.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: postgresql, generated: 2012-11-07 17:20:55
+--  driver: postgresql, generated: 2013-01-29 10:07:16
 -- ----------------------------------------------------------
 SET standard_conforming_strings TO ON;
@@ -24,6 +24,10 @@
 -- ----------------------------------------------------------
 ALTER TABLE ticket DROP ticket_answered;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_article_id_id;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_create_by_id;
 DROP INDEX article_flag_create_by;
 DROP INDEX article_flag_article_id_article_key;
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
 DROP INDEX ticket_queue_view;
 -- ----------------------------------------------------------

Author: mg

Index: DBUpdate-to-3.2.ingres.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.ingres.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.ingres.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.ingres.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: ingres, generated: 2012-11-07 17:20:55
+--  driver: ingres, generated: 2013-01-29 10:07:15
 -- ----------------------------------------------------------
 -- ----------------------------------------------------------
@@ -26,7 +26,7 @@
 -- ----------------------------------------------------------
 ALTER TABLE ticket DROP COLUMN group_id RESTRICT;\g
-CREATE SEQUENCE pm_process_774;\g
+CREATE SEQUENCE pm_process_363;\g
 CREATE TABLE pm_process (
-    id INTEGER NOT NULL DEFAULT pm_process_774.NEXTVAL,
+    id INTEGER NOT NULL DEFAULT pm_process_363.NEXTVAL,
     entity_id VARCHAR(50) NOT NULL,
     name VARCHAR(200) NOT NULL,
@@ -42,7 +42,7 @@
 MODIFY pm_process TO btree unique ON id WITH unique_scope = statement;\g
 ALTER TABLE pm_process ADD PRIMARY KEY ( id ) WITH index = base table structure;\g
-CREATE SEQUENCE pm_activity_332;\g
+CREATE SEQUENCE pm_activity_896;\g
 CREATE TABLE pm_activity (
-    id INTEGER NOT NULL DEFAULT pm_activity_332.NEXTVAL,
+    id INTEGER NOT NULL DEFAULT pm_activity_896.NEXTVAL,
     entity_id VARCHAR(50) NOT NULL,
     name VARCHAR(200) NOT NULL,
@@ -56,7 +56,7 @@
 MODIFY pm_activity TO btree unique ON id WITH unique_scope = statement;\g
 ALTER TABLE pm_activity ADD PRIMARY KEY ( id ) WITH index = base table structure;\g
-CREATE SEQUENCE pm_activity_dialog_798;\g
+CREATE SEQUENCE pm_activity_dialog_279;\g
 CREATE TABLE pm_activity_dialog (
-    id INTEGER NOT NULL DEFAULT pm_activity_dialog_798.NEXTVAL,
+    id INTEGER NOT NULL DEFAULT pm_activity_dialog_279.NEXTVAL,
     entity_id VARCHAR(50) NOT NULL,
     name VARCHAR(200) NOT NULL,
@@ -70,7 +70,7 @@
 MODIFY pm_activity_dialog TO btree unique ON id WITH unique_scope = statement;\g
 ALTER TABLE pm_activity_dialog ADD PRIMARY KEY ( id ) WITH index = base table structure;\g
-CREATE SEQUENCE pm_transition_959;\g
+CREATE SEQUENCE pm_transition_4;\g
 CREATE TABLE pm_transition (
-    id INTEGER NOT NULL DEFAULT pm_transition_959.NEXTVAL,
+    id INTEGER NOT NULL DEFAULT pm_transition_4.NEXTVAL,
     entity_id VARCHAR(50) NOT NULL,
     name VARCHAR(200) NOT NULL,
@@ -84,7 +84,7 @@
 MODIFY pm_transition TO btree unique ON id WITH unique_scope = statement;\g
 ALTER TABLE pm_transition ADD PRIMARY KEY ( id ) WITH index = base table structure;\g
-CREATE SEQUENCE pm_transition_action_839;\g
+CREATE SEQUENCE pm_transition_action_120;\g
 CREATE TABLE pm_transition_action (
-    id INTEGER NOT NULL DEFAULT pm_transition_action_839.NEXTVAL,
+    id INTEGER NOT NULL DEFAULT pm_transition_action_120.NEXTVAL,
     entity_id VARCHAR(50) NOT NULL,
     name VARCHAR(200) NOT NULL,
@@ -129,7 +129,7 @@
     (1, 'ProcessManagementActivityID', 'ProcessManagementActivityID', 1, 'Text', 'Ticket', '---
DefaultValue: ''''
', 1, 1, current_timestamp, 1, current_timestamp);\g
 DROP TABLE sessions;\g
-CREATE SEQUENCE sessions_378;\g
+CREATE SEQUENCE sessions_244;\g
 CREATE TABLE sessions (
-    id BIGINT NOT NULL DEFAULT sessions_378.NEXTVAL,
+    id BIGINT NOT NULL DEFAULT sessions_244.NEXTVAL,
     session_id VARCHAR(100) NOT NULL,
     data_key VARCHAR(100) NOT NULL,

Author: mg

Index: DBUpdate-to-3.2.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.db2.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.db2.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.db2.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: db2, generated: 2012-11-07 17:20:55
+--  driver: db2, generated: 2013-01-29 10:07:15
 -- ----------------------------------------------------------
 -- ----------------------------------------------------------
@@ -39,8 +39,16 @@
 CALL SYSPROC.ADMIN_CMD ('REORG TABLE ticket');
 
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_article_id_id;
+
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_create_by_id;
+
 DROP INDEX article_flag_create_by;
 
 DROP INDEX article_flag_article_id_articlf0;
 
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
+
 DROP INDEX ticket_queue_view;
 

Author: mg

Index: DBUpdate-to-3.2.postgresql_before_8_2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.postgresql_before_8_2.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.postgresql_before_8_2.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.postgresql_before_8_2.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: postgresql_before_8_2, generated: 2012-11-07 17:20:55
+--  driver: postgresql_before_8_2, generated: 2013-01-29 10:07:16
 -- ----------------------------------------------------------
 -- ----------------------------------------------------------
@@ -23,6 +23,10 @@
 -- ----------------------------------------------------------
 ALTER TABLE ticket DROP ticket_answered;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_article_id_id;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_create_by_id;
 DROP INDEX article_flag_create_by;
 DROP INDEX article_flag_article_id_article_key;
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
 DROP INDEX ticket_queue_view;
 -- ----------------------------------------------------------

Author: mg

Index: DBUpdate-to-3.2.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.mssql.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.mssql.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.mssql.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: mssql, generated: 2012-11-07 17:20:55
+--  driver: mssql, generated: 2013-01-29 10:07:15
 -- ----------------------------------------------------------
                 DECLARE @defnameticketgroup_read VARCHAR(200), @cmdticketgroup_read VARCHAR(2000)
@@ -133,6 +133,10 @@
 -- ----------------------------------------------------------
 ALTER TABLE ticket DROP COLUMN ticket_answered;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_article_id_id;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_create_by_id;
 DROP INDEX article_flag.article_flag_create_by;
 DROP INDEX article_flag.article_flag_article_id_article_key;
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
 DROP INDEX ticket.ticket_queue_view;
                 DECLARE @defnameticketgroup_id VARCHAR(200), @cmdticketgroup_id VARCHAR(2000)

Author: mg

Index: DBUpdate-to-3.2.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.mysql.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.mysql.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.mysql.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 # ----------------------------------------------------------
-#  driver: mysql, generated: 2012-11-07 17:20:55
+#  driver: mysql, generated: 2013-01-29 10:07:15
 # ----------------------------------------------------------
 # ----------------------------------------------------------
@@ -23,6 +23,10 @@
 # ----------------------------------------------------------
 ALTER TABLE ticket DROP ticket_answered;
+ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_article_id_id;
+ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_create_by_id;
 DROP INDEX article_flag_create_by ON article_flag;
 DROP INDEX article_flag_article_id_article_key ON article_flag;
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
 DROP INDEX ticket_queue_view ON ticket;
 # ----------------------------------------------------------

Author: mg

Index: DBUpdate-to-3.2.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-3.2.oracle.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -2 -u -d -r1.18 -r1.19
--- DBUpdate-to-3.2.oracle.sql	7 Nov 2012 16:23:40 -0000	1.18
+++ DBUpdate-to-3.2.oracle.sql	29 Jan 2013 08:55:43 -0000	1.19
@@ -1,4 +1,4 @@
 -- ----------------------------------------------------------
---  driver: oracle, generated: 2012-11-07 17:20:55
+--  driver: oracle, generated: 2013-01-29 10:07:16
 -- ----------------------------------------------------------
 SET DEFINE OFF;
@@ -24,6 +24,10 @@
 -- ----------------------------------------------------------
 ALTER TABLE ticket DROP COLUMN ticket_answered;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_article_id_id;
+ALTER TABLE article_flag DROP CONSTRAINT FK_article_flag_create_by_id;
 DROP INDEX article_flag_create_by;
 DROP INDEX article_flag_article_id_artif0;
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id);
+ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);
 DROP INDEX ticket_queue_view;
 -- ----------------------------------------------------------
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.