projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
import of rt 3.0.9
[freeside.git]
/
rt
/
etc
/
schema.Pg
diff --git
a/rt/etc/schema.Pg
b/rt/etc/schema.Pg
index
ba0d6fc
..
085c615
100755
(executable)
--- a/
rt/etc/schema.Pg
+++ b/
rt/etc/schema.Pg
@@
-3,9
+3,6
@@
--
------------------------------------------------------------------
--
------------------------------------------------------------------
-BEGIN;
-
-
--
--
@@
-93,6
+90,7
@@
CREATE TABLE Links (
);
CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type) ;
);
CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type) ;
+CREATE INDEX Links4 ON Links(Type,LocalBase);
-- }}}
-- }}}
@@
-136,7
+134,7
@@
CREATE TABLE Groups (
Description varchar(255) NULL ,
Domain varchar(64),
Type varchar(64),
Description varchar(255) NULL ,
Domain varchar(64),
Type varchar(64),
- Instance
varchar(64)
,
+ Instance
integer
,
PRIMARY KEY (id)
);
PRIMARY KEY (id)
);
@@
-192,7
+190,7
@@
CREATE TABLE Transactions (
Field varchar(40) NULL ,
OldValue varchar(255) NULL ,
NewValue varchar(255) NULL ,
Field varchar(40) NULL ,
OldValue varchar(255) NULL ,
NewValue varchar(255) NULL ,
- Data varchar(
100
) NULL ,
+ Data varchar(
255
) NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created TIMESTAMP NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created TIMESTAMP NULL ,
@@
-500,6
+498,9
@@
CREATE TABLE TicketCustomFieldValues (
);
);
+CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content);
+CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket);
+
-- }}}
-- {{{ CustomFields
-- }}}
-- {{{ CustomFields
@@
-556,6
+557,8
@@
CREATE TABLE CustomFieldValues (
);
);
+CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
+
-- }}}
-- {{{ Sessions
-- }}}
-- {{{ Sessions
@@
-573,6
+576,3
@@
CREATE TABLE sessions (
-- }}}
-- }}}
-
-
-COMMIT;