[otrs-cvs] otrs/scripts DBUpdate-to-2.2.mysql.sql, 1.10, 1.11 DBUpdate-to-2.2.oracle.sql, 1.8, 1.9 DBUpdate-to-2.2.postgresql.sql, 1.9, 1.10

[cvs-log at otrs.org]

Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv20528/scripts

Modified Files:
	DBUpdate-to-2.2.mysql.sql DBUpdate-to-2.2.oracle.sql 
	DBUpdate-to-2.2.postgresql.sql 
Log Message:
Fixed bug# 1739 - Unable to insert new SLA via admin-web after upgrade to 2.2.0 beta1.

Author: martin

Index: DBUpdate-to-2.2.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.mysql.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** DBUpdate-to-2.2.mysql.sql	2 Apr 2007 14:53:39 -0000	1.10
--- DBUpdate-to-2.2.mysql.sql	12 Apr 2007 08:28:31 -0000	1.11
***************
*** 121,127 ****
      name VARCHAR (200) NOT NULL,
      calendar_name VARCHAR (100),
!     response_time INTEGER NOT NULL,
!     max_time_to_repair INTEGER NOT NULL,
!     min_time_between_incidents INTEGER NOT NULL,
      valid_id SMALLINT NOT NULL,
      comments VARCHAR (200) NOT NULL,
--- 121,127 ----
      name VARCHAR (200) NOT NULL,
      calendar_name VARCHAR (100),
!     first_response_time INTEGER NOT NULL,
!     update_time INTEGER NOT NULL,
!     solution_time INTEGER NOT NULL,
      valid_id SMALLINT NOT NULL,
      comments VARCHAR (200) NOT NULL,
***************
*** 130,134 ****
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     PRIMARY KEY(id)
  );
  ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
--- 130,135 ----
      change_time DATETIME NOT NULL,
      change_by INTEGER NOT NULL,
!     PRIMARY KEY(id),
!     UNIQUE (name)
  );
  ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;

Author: martin

Index: DBUpdate-to-2.2.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.oracle.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** DBUpdate-to-2.2.oracle.sql	2 Apr 2007 14:53:39 -0000	1.8
--- DBUpdate-to-2.2.oracle.sql	12 Apr 2007 08:28:31 -0000	1.9
***************
*** 138,144 ****
      name VARCHAR2 (200) NOT NULL,
      calendar_name VARCHAR2 (100),
!     response_time NUMBER NOT NULL,
!     max_time_to_repair NUMBER NOT NULL,
!     min_time_between_incidents NUMBER NOT NULL,
      valid_id NUMBER (5, 0) NOT NULL,
      comments VARCHAR2 (200) NOT NULL,
--- 138,144 ----
      name VARCHAR2 (200) NOT NULL,
      calendar_name VARCHAR2 (100),
!     first_response_time NUMBER NOT NULL,
!     update_time NUMBER NOT NULL,
!     solution_time NUMBER NOT NULL,
      valid_id NUMBER (5, 0) NOT NULL,
      comments VARCHAR2 (200) NOT NULL,
***************
*** 146,150 ****
      create_by NUMBER NOT NULL,
      change_time DATE NOT NULL,
!     change_by NUMBER NOT NULL
  );
  ALTER TABLE sla ADD CONSTRAINT sla_PK PRIMARY KEY (id);
--- 146,151 ----
      create_by NUMBER NOT NULL,
      change_time DATE NOT NULL,
!     change_by NUMBER NOT NULL,
!     CONSTRAINT sla_U_1 UNIQUE (name)
  );
  ALTER TABLE sla ADD CONSTRAINT sla_PK PRIMARY KEY (id);

Author: martin

Index: DBUpdate-to-2.2.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.postgresql.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** DBUpdate-to-2.2.postgresql.sql	2 Apr 2007 14:53:39 -0000	1.9
--- DBUpdate-to-2.2.postgresql.sql	12 Apr 2007 08:28:31 -0000	1.10
***************
*** 114,120 ****
      name VARCHAR (200) NOT NULL,
      calendar_name VARCHAR (100),
!     response_time INTEGER NOT NULL,
!     max_time_to_repair INTEGER NOT NULL,
!     min_time_between_incidents INTEGER NOT NULL,
      valid_id INTEGER NOT NULL,
      comments VARCHAR (200) NOT NULL,
--- 114,120 ----
      name VARCHAR (200) NOT NULL,
      calendar_name VARCHAR (100),
!     first_response_time INTEGER NOT NULL,
!     update_time INTEGER NOT NULL,
!     solution_time INTEGER NOT NULL,
      valid_id INTEGER NOT NULL,
      comments VARCHAR (200) NOT NULL,
***************
*** 123,127 ****
      change_time timestamp(0) NOT NULL,
      change_by INTEGER NOT NULL,
!     PRIMARY KEY(id)
  );
  ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES system_user(id);
--- 123,128 ----
      change_time timestamp(0) NOT NULL,
      change_by INTEGER NOT NULL,
!     PRIMARY KEY(id),
!     UNIQUE (name)
  );
  ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES system_user(id);