[otrs-cvs] CVS: otrs/scripts DBUpdate-to-1.0.mysql.sql,1.4,1.5 DBUpdate-to-1.0.postgresql.sql,1.4,1.5 DBUpdate-to-1.1.mysql.sql,1.9,1.10

cvs-log at otrs.org cvs-log at otrs.org
Tue Oct 3 17:36:04 CEST 2006 

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

Modified Files:
	DBUpdate-to-1.0.mysql.sql DBUpdate-to-1.0.postgresql.sql 
	DBUpdate-to-1.1.mysql.sql 
Log Message:
change copyright

Index: DBUpdate-to-1.0.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-1.0.mysql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** DBUpdate-to-1.0.mysql.sql	9 Feb 2003 20:52:17 -0000	1.4
--- DBUpdate-to-1.0.mysql.sql	3 Oct 2006 14:36:02 -0000	1.5
***************
*** 1,5 ****
  -- --
! -- Update an existing OTRS database from 0.5 to 1.0 
! -- Copyright (C) 2001-2003 Martin Edenhofer <martin+code at otrs.org>
  -- --
  -- $Id$
--- 1,5 ----
  -- --
! -- Update an existing OTRS database from 0.5 to 1.0
! -- Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/
  -- --
  -- $Id$
***************
*** 21,25 ****
  -- standard_attachment
  CREATE TABLE standard_attachment
! (   
      id INTEGER NOT NULL AUTO_INCREMENT,
      name varchar (150) NOT NULL,
--- 21,25 ----
  -- standard_attachment
  CREATE TABLE standard_attachment
! (
      id INTEGER NOT NULL AUTO_INCREMENT,
      name varchar (150) NOT NULL,
***************
*** 36,42 ****
      UNIQUE (name)
  );
! -- standard_response_attachment 
  CREATE TABLE standard_response_attachment
! (   
      id INTEGER NOT NULL AUTO_INCREMENT,
      standard_attachment_id integer NOT NULL,
--- 36,42 ----
      UNIQUE (name)
  );
! -- standard_response_attachment
  CREATE TABLE standard_response_attachment
! (
      id INTEGER NOT NULL AUTO_INCREMENT,
      standard_attachment_id integer NOT NULL,
***************
*** 103,109 ****
  );
  -- charset for bulgarian translation
! ALTER TABLE charset 
!     MODIFY name VARCHAR (200) NOT NULL, 
!     MODIFY charset VARCHAR (50) NOT NULL, 
      MODIFY comment VARCHAR (250)
  ;
--- 103,109 ----
  );
  -- charset for bulgarian translation
! ALTER TABLE charset
!     MODIFY name VARCHAR (200) NOT NULL,
!     MODIFY charset VARCHAR (50) NOT NULL,
      MODIFY comment VARCHAR (250)
  ;
***************
*** 119,123 ****
      filename VARCHAR (250),
      content_type VARCHAR (250),
!     content LONGBLOB, 
      create_time DATETIME NOT NULL,
      create_by INTEGER NOT NULL,
--- 119,123 ----
      filename VARCHAR (250),
      content_type VARCHAR (250),
!     content LONGBLOB,
      create_time DATETIME NOT NULL,
      create_by INTEGER NOT NULL,
***************
*** 126,130 ****
      PRIMARY KEY(id),
      INDEX article_id (article_id)
!   
  );
  -- table for plain emails in db
--- 126,130 ----
      PRIMARY KEY(id),
      INDEX article_id (article_id)
! 
  );
  -- table for plain emails in db
***************
*** 262,266 ****
      (name, valid_id, create_by, change_by, change_time)
  VALUES
!     ('SendAgentNotification', 1, 1, 1, current_timestamp); 
  
  -- add article_type
--- 262,266 ----
      (name, valid_id, create_by, change_by, change_time)
  VALUES
!     ('SendAgentNotification', 1, 1, 1, current_timestamp);
  
  -- add article_type
***************
*** 280,285 ****
      preferences_key VARCHAR (100) NOT NULL,
      preferences_value VARCHAR (250),
!     PRIMARY KEY(user_id) 
! );  
  
  -- create session table
--- 280,285 ----
      preferences_key VARCHAR (100) NOT NULL,
      preferences_value VARCHAR (250),
!     PRIMARY KEY(user_id)
! );
  
  -- create session table

Index: DBUpdate-to-1.0.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-1.0.postgresql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** DBUpdate-to-1.0.postgresql.sql	9 Feb 2003 20:52:17 -0000	1.4
--- DBUpdate-to-1.0.postgresql.sql	3 Oct 2006 14:36:02 -0000	1.5
***************
*** 1,10 ****
  -- --
  -- Update an existing OTRS database from 0.5 to 1.0
! -- Copyright (C) 2001-2003 Martin Edenhofer <martin+code at otrs.org>
  -- --
  -- $Id$
  -- --
  --
! -- usage: cat DBUpdate-to-1.0.postgresql.sql | psql otrs 
  --
  -- --
--- 1,10 ----
  -- --
  -- Update an existing OTRS database from 0.5 to 1.0
! -- Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/
  -- --
  -- $Id$
  -- --
  --
! -- usage: cat DBUpdate-to-1.0.postgresql.sql | psql otrs
  --
  -- --
***************
*** 21,25 ****
  -- standard_attachment
  CREATE TABLE standard_attachment
! (   
      id serial,
      name varchar (150) NOT NULL,
--- 21,25 ----
  -- standard_attachment
  CREATE TABLE standard_attachment
! (
      id serial,
      name varchar (150) NOT NULL,
***************
*** 38,42 ****
  -- standard_response_attachment
  CREATE TABLE standard_response_attachment
! (   
      id serial,
      standard_attachment_id integer NOT NULL,
--- 38,42 ----
  -- standard_response_attachment
  CREATE TABLE standard_response_attachment
! (
      id serial,
      standard_attachment_id integer NOT NULL,
***************
*** 129,134 ****
       create_by,
       change_time,
!      change_by) 
! SELECT  
       name,
       charset,
--- 129,134 ----
       create_by,
       change_time,
!      change_by)
! SELECT
       name,
       charset,
***************
*** 148,152 ****
  CREATE TABLE article_attachment
  (
!     id serial, 
      article_id BIGINT NOT NULL,
      filename VARCHAR (250),
--- 148,152 ----
  CREATE TABLE article_attachment
  (
!     id serial,
      article_id BIGINT NOT NULL,
      filename VARCHAR (250),
***************
*** 234,238 ****
  -- --
  CREATE TABLE ticket_index
! (   
      ticket_id bigint NOT NULL,
      queue_id integer NOT NULL,
--- 234,238 ----
  -- --
  CREATE TABLE ticket_index
! (
      ticket_id bigint NOT NULL,
      queue_id integer NOT NULL,
***************
*** 246,250 ****
  -- new time accounting table
  CREATE TABLE time_accounting
! (   
      id serial8,
      ticket_id bigint NOT NULL,
--- 246,250 ----
  -- new time accounting table
  CREATE TABLE time_accounting
! (
      id serial8,
      ticket_id bigint NOT NULL,

Index: DBUpdate-to-1.1.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-1.1.mysql.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** DBUpdate-to-1.1.mysql.sql	12 Apr 2003 22:06:21 -0000	1.9
--- DBUpdate-to-1.1.mysql.sql	3 Oct 2006 14:36:02 -0000	1.10
***************
*** 1,5 ****
  -- --
! -- Update an existing OTRS database from 1.0 to 1.1 
! -- Copyright (C) 2001-2003 Martin Edenhofer <martin+code at otrs.org>
  -- --
  -- $Id$
--- 1,5 ----
  -- --
! -- Update an existing OTRS database from 1.0 to 1.1
! -- Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/
  -- --
  -- $Id$
***************
*** 21,34 ****
  DELETE FROM ticket_history_type WHERE name = 'Close successful';
  --DELETE FROM ticket_history_type WHERE name = '';
! -- 
  -- add ticket state update log type
! -- 
  INSERT INTO ticket_history_type
      (name, valid_id, create_by, create_time, change_by, change_time)
      VALUES
      ('StateUpdate', 1, 1, current_timestamp, 1, current_timestamp);
! -- 
  -- add ticket free text update log type
! -- 
  INSERT INTO ticket_history_type
      (name, valid_id, create_by, create_time, change_by, change_time)
--- 21,34 ----
  DELETE FROM ticket_history_type WHERE name = 'Close successful';
  --DELETE FROM ticket_history_type WHERE name = '';
! --
  -- add ticket state update log type
! --
  INSERT INTO ticket_history_type
      (name, valid_id, create_by, create_time, change_by, change_time)
      VALUES
      ('StateUpdate', 1, 1, current_timestamp, 1, current_timestamp);
! --
  -- add ticket free text update log type
! --
  INSERT INTO ticket_history_type
      (name, valid_id, create_by, create_time, change_by, change_time)
***************
*** 43,47 ****
  ALTER TABLE queue ADD owner_notify SMALLINT NOT NULL;
  --
! -- added for customer notifications 
  --
  INSERT INTO ticket_history_type
--- 43,47 ----
  ALTER TABLE queue ADD owner_notify SMALLINT NOT NULL;
  --
! -- added for customer notifications
  --
  INSERT INTO ticket_history_type
***************
*** 57,61 ****
  UPDATE group_user SET permission_read = 1, permission_write = 1 WHERE permission_read = 0 AND permission_write = 0;
  
! -- 
  -- add ticket_state_type table
  --
--- 57,61 ----
  UPDATE group_user SET permission_read = 1, permission_write = 1 WHERE permission_read = 0 AND permission_write = 0;
  
! --
  -- add ticket_state_type table
  --
***************
*** 71,84 ****
      PRIMARY KEY(id),
      UNIQUE (name)
! );  
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('new', 'all new state types (default: viewable)', 1, current_timestamp, 1, current_timestamp); 
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('open', 'all open state types (default: viewable)', 1, current_timestamp, 1, current_timestamp); 
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('closed', 'all closed state types (default: not viewable)', 1, current_timestamp, 1, current_timestamp); 
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
--- 71,84 ----
      PRIMARY KEY(id),
      UNIQUE (name)
! );
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('new', 'all new state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('open', 'all open state types (default: viewable)', 1, current_timestamp, 1, current_timestamp);
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
!     ('closed', 'all closed state types (default: not viewable)', 1, current_timestamp, 1, current_timestamp);
  INSERT INTO ticket_state_type (name, comment, create_by, create_time, change_by, change_time)
      VALUES
***************
*** 94,98 ****
  --
  ALTER TABLE ticket_state ADD type_id SMALLINT NOT NULL;
! -- 
  -- update ticket_state table
  --
--- 94,98 ----
  --
  ALTER TABLE ticket_state ADD type_id SMALLINT NOT NULL;
! --
  -- update ticket_state table
  --
***************
*** 105,109 ****
  UPDATE ticket_state SET type_id = 5 WHERE name = 'pending auto close+';
  UPDATE ticket_state SET type_id = 5 WHERE name = 'pending auto close-';
! -- 
  -- delete not needed queue (important for sub queue)
  --
--- 105,109 ----
  UPDATE ticket_state SET type_id = 5 WHERE name = 'pending auto close+';
  UPDATE ticket_state SET type_id = 5 WHERE name = 'pending auto close-';
! --
  -- delete not needed queue (important for sub queue)
  --
***************
*** 112,117 ****
  -- modify table ticket
  --
! ALTER TABLE ticket ADD customer_user_id VARCHAR (250); 
! -- 
  -- updated priority states
  --
--- 112,117 ----
  -- modify table ticket
  --
! ALTER TABLE ticket ADD customer_user_id VARCHAR (250);
! --
  -- updated priority states
  --

More information about the cvs-log mailing list