X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2Fdocs%2Fdesign_docs%2F3.3-schema-redesign.txt;fp=rt%2Fdocs%2Fdesign_docs%2F3.3-schema-redesign.txt;h=0000000000000000000000000000000000000000;hp=518eccd4d23f53a5dc5f19805da1ee619c0f0f9e;hb=43a06151e47d2c59b833cbd8c26d97865ee850b6;hpb=6587f6ba7d047ddc1686c080090afe7d53365bd4

diff --git a/rt/docs/design_docs/3.3-schema-redesign.txt b/rt/docs/design_docs/3.3-schema-redesign.txt
deleted file mode 100644
index 518eccd4d..000000000
--- a/rt/docs/design_docs/3.3-schema-redesign.txt
+++ /dev/null
@@ -1,57 +0,0 @@
--- --------------------------------------- --
---  RT 3.3 Schema redesign v7: 2004-11-08  --
--- --------------------------------------- --
-
-TABLE CustomFields (
-  id INTEGER NOT NULL  AUTO_INCREMENT,
-  Name varchar(200) NULL  ,
-  Type varchar(200) NULL  ,                 -- Changed: see MaxValues below
-  MaxValues integer,                        -- New: 1 = Single, 0 = Multiple
-  Pattern varchar(255) NULL  ,              -- New: regex to validate against
-  Repeated int2 NOT NULL DEFAULT 0 ,        -- New: repeated table entry
-  LookupType varchar(255) NOT NULL,         -- New: "RT::Queue-RT::Ticket"
-  Description varchar(255) NULL  ,
-  SortOrder integer NOT NULL DEFAULT 0  ,   -- only used on "pick CF" screen
-)
-
--- This table replaces the "Queue" field in CustomFields
-TABLE ObjectCustomFields (
-  id INTEGER NOT NULL  AUTO_INCREMENT,
-  CustomField int NOT NULL  ,               -- CustomField ID
-  ObjectId integer NOT NULL,                -- Final id of toplevel parent, or 
-                                            -- the object itself if ParentType
-                                            -- is empty; 0 means global as usual
-  SortOrder integer NOT NULL DEFAULT 0  ,   -- this is used to sort the CFs
-);
-
--- This table replaces TicketCustomFieldValues
-TABLE ObjectCustomFieldValues (
-  id INTEGER NOT NULL  AUTO_INCREMENT,
-  CustomField int NOT NULL  ,
-  ObjectType varchar(255) NOT NULL,         -- Final target of the Object
-  ObjectId int NOT NULL  ,                  -- New: replaces the "Ticket" field
-  SortOrder integer NOT NULL DEFAULT 0  ,   -- New: for Repeated fields
-
-  Content varchar(255) NULL  ,
-  LargeContent LONGTEXT NULL,               -- New: data longer than 255 bytes
-  ContentType varchar(80) NULL,             -- New: MIME type of LargeContent
-  ContentEncoding varchar(80) NULL  ,       -- New: for binary LargeContent
-  Disabled int2 NOT NULL DEFAULT 0 ,        -- New: whether this is deleted
-)
-
-TABLE Transactions (
-  id INTEGER NOT NULL  AUTO_INCREMENT,
-  ObjectType varchar(255) NULL,             -- Final target of the Object
-  ObjectId integer NOT NULL DEFAULT 0  ,    -- New: replaces the "Ticket" field
-  TimeTaken integer NOT NULL DEFAULT 0  ,
-  Type varchar(20) NULL  ,
-  Field varchar(40) NULL  ,
-  OldValue varchar(255) NULL  ,
-  NewValue varchar(255) NULL  ,
-  ReferenceType varchar(255) NULL,          -- NeW: Currently "RT::OCFV" only
-  OldReference integer NULL  ,              -- New: Id of ReferenceType
-  NewReference integer NULL  ,              -- New: Id of ReferenceType
-  Data varchar(255) NULL  ,
-)
-
--- vim: filetype=mysql shiftwidth=4 expandtab