X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fschema.Pg;h=32c5e872dd05e3bf382e9ad94cc4738d54c27c0b;hb=781e1d52be20355e1e9d57102d6ae44a3f1cbeeb;hp=6beb19d9cd850464402ebdccd3371992945ab4aa;hpb=7fd9cc184b77a6aafb3bb431d84ae835359646a3;p=freeside.git

diff --git a/rt/etc/schema.Pg b/rt/etc/schema.Pg
index 6beb19d9c..32c5e872d 100755
--- a/rt/etc/schema.Pg
+++ b/rt/etc/schema.Pg
@@ -3,12 +3,6 @@
 --
 ------------------------------------------------------------------
 
---
--- Deal with changed defaults of Pg 8.x
---
-SELECT CASE WHEN version() like '%PostgreSQL 8%" THEN
-  set_config('default_with_oids','on','f')
-END;
 
 
 --
@@ -289,6 +283,8 @@ CREATE TABLE GroupMembers (
 
 );
 
+CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers(GroupId, MemberId);
+
 -- }}}
 
 -- {{{ GroupMembersCache
@@ -370,7 +366,6 @@ CREATE TABLE Users (
 
 
 CREATE UNIQUE INDEX Users1 ON Users (Name) ;
-CREATE INDEX Users2 ON Users (Name);
 CREATE INDEX Users3 ON Users (id, EmailAddress);
 CREATE INDEX Users4 ON Users (EmailAddress);
 
@@ -409,6 +404,7 @@ CREATE TABLE Tickets (
   Due TIMESTAMP NULL  ,
   Resolved TIMESTAMP NULL  ,
 
+  WillResolve TIMESTAMP NULL  ,
 
   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
   LastUpdated TIMESTAMP NULL  ,
@@ -534,7 +530,7 @@ CREATE TABLE CustomFields (
   Type varchar(200) NULL  ,
   MaxValues integer NOT NULL DEFAULT 0  ,
   Repeated integer NOT NULL DEFAULT 0 , 
-  Pattern varchar(255) NULL  ,
+  Pattern varchar(65536) NULL  ,
   LookupType varchar(255) NOT NULL  ,
   Description varchar(255) NULL  ,
   SortOrder integer NOT NULL DEFAULT 0  ,
@@ -544,6 +540,7 @@ CREATE TABLE CustomFields (
   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
   LastUpdated TIMESTAMP NULL  ,
   Disabled integer NOT NULL DEFAULT 0 ,
+  Required integer NOT NULL DEFAULT 0 ,
   PRIMARY KEY (id)
 
 );