[otrs-cvs] otrs/scripts/database otrs-schema.db2.sql, 1.14,
1.15 otrs-schema.maxdb.sql, 1.15, 1.16 otrs-schema.mssql.sql,
1.10, 1.11 otrs-schema.mysql.sql, 1.56,
1.57 otrs-schema.oracle.sql, 1.21,
1.22 otrs-schema.postgresql.sql, 1.55, 1.56 otrs-schema.xml,
1.63, 1.64
cvs-log at otrs.org
cvs-log at otrs.org
Mon Apr 2 14:53:44 GMT 2007
Comments:
Update of /home/cvs/otrs/scripts/database
In directory lancelot:/tmp/cvs-serv5474/scripts/database
Modified Files:
otrs-schema.db2.sql otrs-schema.maxdb.sql
otrs-schema.mssql.sql otrs-schema.mysql.sql
otrs-schema.oracle.sql otrs-schema.postgresql.sql
otrs-schema.xml
Log Message:
Added customer_company.
Author: martin
Index: otrs-schema.db2.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.db2.sql,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** otrs-schema.db2.sql 2 Apr 2007 13:41:36 -0000 1.14
--- otrs-schema.db2.sql 2 Apr 2007 14:53:39 -0000 1.15
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 15:40:20
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: db2, generated: 2007-04-02 16:52:36
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 89,93 ****
);
! CREATE INDEX index_user_prefe16 ON user_preferences (user_id);
-- ----------------------------------------------------------
--- 89,93 ----
);
! CREATE INDEX index_user_prefe58 ON user_preferences (user_id);
-- ----------------------------------------------------------
***************
*** 408,418 ****
);
! CREATE INDEX index_ticket_use85 ON ticket (user_id);
CREATE INDEX index_ticket_typ13 ON ticket (type_id);
! CREATE INDEX index_ticket_que94 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans66 ON ticket (ticket_answered);
-- ----------------------------------------------------------
--- 408,418 ----
);
! CREATE INDEX index_ticket_use76 ON ticket (user_id);
CREATE INDEX index_ticket_typ13 ON ticket (type_id);
! CREATE INDEX index_ticket_que66 ON ticket (ticket_state_id, ticket_lock_id, group_id);
! CREATE INDEX index_ticket_ans13 ON ticket (ticket_answered);
-- ----------------------------------------------------------
***************
*** 449,455 ****
);
! CREATE INDEX ticket_history_t38 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c57 ON ticket_history (create_time);
-- ----------------------------------------------------------
--- 449,455 ----
);
! CREATE INDEX ticket_history_t62 ON ticket_history (ticket_id);
! CREATE INDEX ticket_history_c6 ON ticket_history (create_time);
-- ----------------------------------------------------------
***************
*** 511,515 ****
);
! CREATE INDEX article_flag_cre35 ON article_flag (create_by);
CREATE INDEX article_flag_art23 ON article_flag (article_id);
--- 511,515 ----
);
! CREATE INDEX article_flag_cre9 ON article_flag (create_by);
CREATE INDEX article_flag_art23 ON article_flag (article_id);
***************
*** 547,553 ****
);
! CREATE INDEX article_ticket_i0 ON article (ticket_id);
! CREATE INDEX article_message_21 ON article (a_message_id);
-- ----------------------------------------------------------
--- 547,553 ----
);
! CREATE INDEX article_ticket_i51 ON article (ticket_id);
! CREATE INDEX article_message_28 ON article (a_message_id);
-- ----------------------------------------------------------
***************
*** 565,569 ****
);
! CREATE INDEX article_plain_ar71 ON article_plain (article_id);
-- ----------------------------------------------------------
--- 565,569 ----
);
! CREATE INDEX article_plain_ar27 ON article_plain (article_id);
-- ----------------------------------------------------------
***************
*** 584,588 ****
);
! CREATE INDEX article_attachme96 ON article_attachment (article_id);
-- ----------------------------------------------------------
--- 584,588 ----
);
! CREATE INDEX article_attachme16 ON article_attachment (article_id);
-- ----------------------------------------------------------
***************
*** 715,719 ****
);
! CREATE INDEX index_time_accou2 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
--- 715,719 ----
);
! CREATE INDEX index_time_accou3 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
***************
*** 770,774 ****
);
! CREATE INDEX index_session_id80 ON sessions (session_id);
-- ----------------------------------------------------------
--- 770,774 ----
);
! CREATE INDEX index_session_id13 ON sessions (session_id);
-- ----------------------------------------------------------
***************
*** 785,789 ****
);
! CREATE INDEX index_ticket_ind67 ON ticket_index (ticket_id);
-- ----------------------------------------------------------
--- 785,789 ----
);
! CREATE INDEX index_ticket_ind12 ON ticket_index (ticket_id);
-- ----------------------------------------------------------
***************
*** 794,798 ****
);
! CREATE INDEX index_ticket_loc30 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
--- 794,798 ----
);
! CREATE INDEX index_ticket_loc97 ON ticket_lock_index (ticket_id);
-- ----------------------------------------------------------
***************
*** 827,831 ****
);
! CREATE INDEX index_customer_p89 ON customer_preferences (user_id);
-- ----------------------------------------------------------
--- 827,852 ----
);
! CREATE INDEX index_customer_p55 ON customer_preferences (user_id);
!
! -- ----------------------------------------------------------
! -- create table customer_company
! -- ----------------------------------------------------------
! CREATE TABLE customer_company (
! customer_id VARCHAR (100) NOT NULL,
! name VARCHAR (100) NOT NULL,
! street VARCHAR (200),
! zip VARCHAR (200),
! city VARCHAR (200),
! country VARCHAR (200),
! url VARCHAR (200),
! comments VARCHAR (250),
! valid_id SMALLINT NOT NULL,
! create_time TIMESTAMP NOT NULL,
! create_by INTEGER NOT NULL,
! change_time TIMESTAMP NOT NULL,
! change_by INTEGER NOT NULL,
! UNIQUE (customer_id),
! UNIQUE (name)
! );
-- ----------------------------------------------------------
***************
*** 839,843 ****
CREATE INDEX index_ticket_loo61 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo17 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
--- 860,864 ----
CREATE INDEX index_ticket_loo61 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loo18 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
Author: martin
Index: otrs-schema.maxdb.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.maxdb.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** otrs-schema.maxdb.sql 2 Apr 2007 13:41:36 -0000 1.15
--- otrs-schema.maxdb.sql 2 Apr 2007 14:53:39 -0000 1.16
***************
*** 1,4 ****
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 15:40:29
// ----------------------------------------------------------
// ----------------------------------------------------------
--- 1,4 ----
// ----------------------------------------------------------
! // driver: maxdb, generated: 2007-04-02 16:52:36
// ----------------------------------------------------------
// ----------------------------------------------------------
***************
*** 89,93 ****
)
//
! CREATE INDEX index_user_preferenc77 ON user_preferences (user_id)
//
// ----------------------------------------------------------
--- 89,93 ----
)
//
! CREATE INDEX index_user_preferenc11 ON user_preferences (user_id)
//
// ----------------------------------------------------------
***************
*** 412,418 ****
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v7 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere56 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
--- 412,418 ----
CREATE INDEX index_ticket_type ON ticket (type_id)
//
! CREATE INDEX index_ticket_queue_v61 ON ticket (ticket_state_id, ticket_lock_id, group_id)
//
! CREATE INDEX index_ticket_answere38 ON ticket (ticket_answered)
//
// ----------------------------------------------------------
***************
*** 449,455 ****
)
//
! CREATE INDEX ticket_history_ticke30 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat68 ON ticket_history (create_time)
//
// ----------------------------------------------------------
--- 449,455 ----
)
//
! CREATE INDEX ticket_history_ticke77 ON ticket_history (ticket_id)
//
! CREATE INDEX ticket_history_creat39 ON ticket_history (create_time)
//
// ----------------------------------------------------------
***************
*** 511,517 ****
)
//
! CREATE INDEX article_flag_create_57 ON article_flag (create_by)
//
! CREATE INDEX article_flag_article46 ON article_flag (article_id)
//
// ----------------------------------------------------------
--- 511,517 ----
)
//
! CREATE INDEX article_flag_create_27 ON article_flag (create_by)
//
! CREATE INDEX article_flag_article60 ON article_flag (article_id)
//
// ----------------------------------------------------------
***************
*** 565,569 ****
)
//
! CREATE INDEX article_plain_articl55 ON article_plain (article_id)
//
// ----------------------------------------------------------
--- 565,569 ----
)
//
! CREATE INDEX article_plain_articl29 ON article_plain (article_id)
//
// ----------------------------------------------------------
***************
*** 584,588 ****
)
//
! CREATE INDEX article_attachment_a37 ON article_attachment (article_id)
//
// ----------------------------------------------------------
--- 584,588 ----
)
//
! CREATE INDEX article_attachment_a40 ON article_attachment (article_id)
//
// ----------------------------------------------------------
***************
*** 715,719 ****
)
//
! CREATE INDEX index_time_accountin7 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
--- 715,719 ----
)
//
! CREATE INDEX index_time_accountin10 ON time_accounting (ticket_id)
//
// ----------------------------------------------------------
***************
*** 785,789 ****
)
//
! CREATE INDEX index_ticket_index_t24 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
--- 785,789 ----
)
//
! CREATE INDEX index_ticket_index_t61 ON ticket_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 794,798 ****
)
//
! CREATE INDEX index_ticket_lock_ti55 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
--- 794,798 ----
)
//
! CREATE INDEX index_ticket_lock_ti98 ON ticket_lock_index (ticket_id)
//
// ----------------------------------------------------------
***************
*** 827,831 ****
)
//
! CREATE INDEX index_customer_prefe59 ON customer_preferences (user_id)
//
// ----------------------------------------------------------
--- 827,852 ----
)
//
! CREATE INDEX index_customer_prefe52 ON customer_preferences (user_id)
! //
! // ----------------------------------------------------------
! // create table customer_company
! // ----------------------------------------------------------
! CREATE TABLE customer_company (
! customer_id VARCHAR (100) NOT NULL,
! name VARCHAR (100) NOT NULL,
! street VARCHAR (200),
! zip VARCHAR (200),
! city VARCHAR (200),
! country VARCHAR (200),
! url VARCHAR (200),
! comments VARCHAR (250),
! valid_id SMALLINT NOT NULL,
! create_time timestamp NOT NULL,
! create_by INTEGER NOT NULL,
! change_time timestamp NOT NULL,
! change_by INTEGER NOT NULL,
! UNIQUE (name),
! UNIQUE (customer_id)
! )
//
// ----------------------------------------------------------
***************
*** 837,843 ****
)
//
! CREATE INDEX index_ticket_loop_pr15 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr51 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
--- 858,864 ----
)
//
! CREATE INDEX index_ticket_loop_pr58 ON ticket_loop_protection (sent_to)
//
! CREATE INDEX index_ticket_loop_pr93 ON ticket_loop_protection (sent_date)
//
// ----------------------------------------------------------
Author: martin
Index: otrs-schema.mssql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mssql.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** otrs-schema.mssql.sql 2 Apr 2007 13:41:36 -0000 1.10
--- otrs-schema.mssql.sql 2 Apr 2007 14:53:39 -0000 1.11
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 15:40:38
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: mssql, generated: 2007-04-02 16:52:36
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 764,767 ****
--- 764,787 ----
CREATE INDEX index_customer_preferences_user_id ON customer_preferences (user_id);
-- ----------------------------------------------------------
+ -- create table customer_company
+ -- ----------------------------------------------------------
+ CREATE TABLE customer_company (
+ customer_id VARCHAR (100) NOT NULL,
+ name VARCHAR (100) NOT NULL,
+ street VARCHAR (200),
+ zip VARCHAR (200),
+ city VARCHAR (200),
+ country VARCHAR (200),
+ url VARCHAR (200),
+ comments VARCHAR (250),
+ valid_id SMALLINT NOT NULL,
+ create_time DATETIME NOT NULL,
+ create_by INTEGER NOT NULL,
+ change_time DATETIME NOT NULL,
+ change_by INTEGER NOT NULL,
+ UNIQUE (name),
+ UNIQUE (customer_id)
+ );
+ -- ----------------------------------------------------------
-- create table ticket_loop_protection
-- ----------------------------------------------------------
Author: martin
Index: otrs-schema.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.mysql.sql,v
retrieving revision 1.56
retrieving revision 1.57
diff -C2 -d -r1.56 -r1.57
*** otrs-schema.mysql.sql 2 Apr 2007 13:41:36 -0000 1.56
--- otrs-schema.mysql.sql 2 Apr 2007 14:53:39 -0000 1.57
***************
*** 1,4 ****
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 15:39:21
# ----------------------------------------------------------
# ----------------------------------------------------------
--- 1,4 ----
# ----------------------------------------------------------
! # driver: mysql, generated: 2007-04-02 16:52:37
# ----------------------------------------------------------
# ----------------------------------------------------------
***************
*** 764,767 ****
--- 764,787 ----
);
# ----------------------------------------------------------
+ # create table customer_company
+ # ----------------------------------------------------------
+ CREATE TABLE customer_company (
+ customer_id VARCHAR (100) NOT NULL,
+ name VARCHAR (100) NOT NULL,
+ street VARCHAR (200),
+ zip VARCHAR (200),
+ city VARCHAR (200),
+ country VARCHAR (200),
+ url VARCHAR (200),
+ comments VARCHAR (250),
+ valid_id SMALLINT NOT NULL,
+ create_time DATETIME NOT NULL,
+ create_by INTEGER NOT NULL,
+ change_time DATETIME NOT NULL,
+ change_by INTEGER NOT NULL,
+ UNIQUE (customer_id),
+ UNIQUE (name)
+ );
+ # ----------------------------------------------------------
# create table ticket_loop_protection
# ----------------------------------------------------------
Author: martin
Index: otrs-schema.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.oracle.sql,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** otrs-schema.oracle.sql 2 Apr 2007 13:41:36 -0000 1.21
--- otrs-schema.oracle.sql 2 Apr 2007 14:53:39 -0000 1.22
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-02 15:40:47
-- ----------------------------------------------------------
SET DEFINE OFF;
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: oracle, generated: 2007-04-02 16:52:37
-- ----------------------------------------------------------
SET DEFINE OFF;
***************
*** 900,911 ****
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach78_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach78_seq;
! CREATE SEQUENCE standard_response_attach78_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach78_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach78_seq.nextval
into :new.id
from dual;
--- 900,911 ----
change_by NUMBER NOT NULL
);
! ALTER TABLE standard_response_attachment ADD CONSTRAINT standard_response_attach42_PK PRIMARY KEY (id);
! DROP SEQUENCE standard_response_attach42_seq;
! CREATE SEQUENCE standard_response_attach42_seq;
! CREATE OR REPLACE TRIGGER standard_response_attach42_s_t
before insert on standard_response_attachment
for each row
begin
! select standard_response_attach42_seq.nextval
into :new.id
from dual;
***************
*** 1024,1028 ****
/
--;
! CREATE INDEX index_time_accounting_ticket33 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
--- 1024,1028 ----
/
--;
! CREATE INDEX index_time_accounting_ticket66 ON time_accounting (ticket_id);
-- ----------------------------------------------------------
-- create table ticket_watcher
***************
*** 1159,1163 ****
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u23 ON customer_preferences (user_id);
-- ----------------------------------------------------------
-- create table ticket_loop_protection
--- 1159,1183 ----
preferences_value VARCHAR2 (250)
);
! CREATE INDEX index_customer_preferences_u10 ON customer_preferences (user_id);
! -- ----------------------------------------------------------
! -- create table customer_company
! -- ----------------------------------------------------------
! CREATE TABLE customer_company (
! customer_id VARCHAR2 (100) NOT NULL,
! name VARCHAR2 (100) NOT NULL,
! street VARCHAR2 (200),
! zip VARCHAR2 (200),
! city VARCHAR2 (200),
! country VARCHAR2 (200),
! url VARCHAR2 (200),
! comments VARCHAR2 (250),
! valid_id NUMBER (5, 0) NOT NULL,
! create_time DATE NOT NULL,
! create_by NUMBER NOT NULL,
! change_time DATE NOT NULL,
! change_by NUMBER NOT NULL,
! CONSTRAINT customer_company_U_1 UNIQUE (customer_id),
! CONSTRAINT customer_company_U_2 UNIQUE (name)
! );
-- ----------------------------------------------------------
-- create table ticket_loop_protection
***************
*** 1167,1172 ****
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection11 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection32 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
--- 1187,1192 ----
sent_date VARCHAR2 (150) NOT NULL
);
! CREATE INDEX index_ticket_loop_protection27 ON ticket_loop_protection (sent_to);
! CREATE INDEX index_ticket_loop_protection23 ON ticket_loop_protection (sent_date);
-- ----------------------------------------------------------
-- create table pop3_account
Author: martin
Index: otrs-schema.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.postgresql.sql,v
retrieving revision 1.55
retrieving revision 1.56
diff -C2 -d -r1.55 -r1.56
*** otrs-schema.postgresql.sql 2 Apr 2007 13:41:36 -0000 1.55
--- otrs-schema.postgresql.sql 2 Apr 2007 14:53:39 -0000 1.56
***************
*** 1,4 ****
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 15:40:55
-- ----------------------------------------------------------
-- ----------------------------------------------------------
--- 1,4 ----
-- ----------------------------------------------------------
! -- driver: postgresql, generated: 2007-04-02 16:52:38
-- ----------------------------------------------------------
-- ----------------------------------------------------------
***************
*** 764,767 ****
--- 764,787 ----
CREATE INDEX index_customer_preferences_user_id ON customer_preferences (user_id);
-- ----------------------------------------------------------
+ -- create table customer_company
+ -- ----------------------------------------------------------
+ CREATE TABLE customer_company (
+ customer_id VARCHAR (100) NOT NULL,
+ name VARCHAR (100) NOT NULL,
+ street VARCHAR (200),
+ zip VARCHAR (200),
+ city VARCHAR (200),
+ country VARCHAR (200),
+ url VARCHAR (200),
+ comments VARCHAR (250),
+ valid_id INTEGER NOT NULL,
+ create_time timestamp(0) NOT NULL,
+ create_by INTEGER NOT NULL,
+ change_time timestamp(0) NOT NULL,
+ change_by INTEGER NOT NULL,
+ UNIQUE (customer_id),
+ UNIQUE (name)
+ );
+ -- ----------------------------------------------------------
-- create table ticket_loop_protection
-- ----------------------------------------------------------
Author: martin
Index: otrs-schema.xml
===================================================================
RCS file: /home/cvs/otrs/scripts/database/otrs-schema.xml,v
retrieving revision 1.63
retrieving revision 1.64
diff -C2 -d -r1.63 -r1.64
*** otrs-schema.xml 2 Apr 2007 13:41:36 -0000 1.63
--- otrs-schema.xml 2 Apr 2007 14:53:39 -0000 1.64
***************
*** 9,12 ****
--- 9,15 ----
$Log$
+ Revision 1.64 2007/04/02 14:53:39 martin
+ Added customer_company.
+
Revision 1.63 2007/04/02 13:41:36 mh
Improved indexes of xml_storage table
***************
*** 1423,1426 ****
--- 1426,1452 ----
</Table>
+ <!-- customer company -->
+ <Table Name="customer_company">
+ <Column Name="customer_id" Required="true" Size="100" Type="VARCHAR"/>
+ <Column Name="name" Required="true" Size="100" Type="VARCHAR"/>
+ <Column Name="street" Required="false" Size="200" Type="VARCHAR"/>
+ <Column Name="zip" Required="false" Size="200" Type="VARCHAR"/>
+ <Column Name="city" Required="false" Size="200" Type="VARCHAR"/>
+ <Column Name="country" Required="false" Size="200" Type="VARCHAR"/>
+ <Column Name="url" Required="false" Size="200" Type="VARCHAR"/>
+ <Column Name="comments" Required="false" Size="250" Type="VARCHAR"/>
+ <Column Name="valid_id" Required="true" Type="SMALLINT"/>
+ <Column Name="create_time" Required="true" Type="DATE"/>
+ <Column Name="create_by" Required="true" Type="INTEGER"/>
+ <Column Name="change_time" Required="true" Type="DATE"/>
+ <Column Name="change_by" Required="true" Type="INTEGER"/>
+ <Unique>
+ <UniqueColumn Name="name"/>
+ </Unique>
+ <Unique>
+ <UniqueColumn Name="customer_id"/>
+ </Unique>
+ </Table>
+
<!-- ticket_loop_protection -->
<Table Name="ticket_loop_protection">
More information about the cvs-log
mailing list