projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
so Search.tsf and Search.rdf work
[freeside.git]
/
rt
/
etc
/
schema.Pg
diff --git
a/rt/etc/schema.Pg
b/rt/etc/schema.Pg
index
085c615
..
ba0d6fc
100755
(executable)
--- a/
rt/etc/schema.Pg
+++ b/
rt/etc/schema.Pg
@@
-3,6
+3,9
@@
--
------------------------------------------------------------------
--
------------------------------------------------------------------
+BEGIN;
+
+
--
--
@@
-90,7
+93,6
@@
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);
-- }}}
-- }}}
@@
-134,7
+136,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
integer
,
+ Instance
varchar(64)
,
PRIMARY KEY (id)
);
PRIMARY KEY (id)
);
@@
-190,7
+192,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(
255
) NULL ,
+ Data varchar(
100
) NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created TIMESTAMP NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created TIMESTAMP NULL ,
@@
-498,9
+500,6
@@
CREATE TABLE TicketCustomFieldValues (
);
);
-CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content);
-CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket);
-
-- }}}
-- {{{ CustomFields
-- }}}
-- {{{ CustomFields
@@
-557,8
+556,6
@@
CREATE TABLE CustomFieldValues (
);
);
-CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
-
-- }}}
-- {{{ Sessions
-- }}}
-- {{{ Sessions
@@
-576,3
+573,6
@@
CREATE TABLE sessions (
-- }}}
-- }}}
+
+
+COMMIT;