combine ticket notification scrips, #15353

[freeside.git] / rt / etc / schema.Pg

diff --git a/rt/etc/schema.Pg b/rt/etc/schema.Pg
index 48525c8..32c5e87 100755 (executable)
--- a/rt/etc/schema.Pg
+++ b/rt/etc/schema.Pg
@@ -404,6 +404,7 @@ CREATE TABLE Tickets (
   Due TIMESTAMP NULL  ,
   Resolved TIMESTAMP NULL  ,
 
+  WillResolve TIMESTAMP NULL  ,
 
   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
   LastUpdated TIMESTAMP NULL  ,
@@ -539,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)
 
 );