projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
new 4.x style for quick payment entry
[freeside.git]
/
rt
/
etc
/
schema.mysql-4.1
diff --git
a/rt/etc/schema.mysql-4.1
b/rt/etc/schema.mysql-4.1
index
edd3ded
..
bfa8516
100755
(executable)
--- a/
rt/etc/schema.mysql-4.1
+++ b/
rt/etc/schema.mysql-4.1
@@
-14,7
+14,7
@@
CREATE TABLE Attachments (
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
@@
-36,7
+36,7
@@
CREATE TABLE Queues (
LastUpdated DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
LastUpdated DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE UNIQUE INDEX Queues1 ON Queues (Name) ;
CREATE INDEX Queues2 ON Queues (Disabled) ;
CREATE UNIQUE INDEX Queues1 ON Queues (Name) ;
CREATE INDEX Queues2 ON Queues (Disabled) ;
@@
-57,7
+57,7
@@
CREATE TABLE Links (
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET ascii;
+)
ENGIN
E=InnoDB CHARACTER SET ascii;
CREATE INDEX Links2 ON Links (Base, Type) ;
CREATE INDEX Links3 ON Links (Target, Type) ;
CREATE INDEX Links2 ON Links (Base, Type) ;
CREATE INDEX Links3 ON Links (Target, Type) ;
@@
-73,7
+73,7
@@
CREATE TABLE Principals (
ObjectId integer, # foreign key to Users or Groups, depending
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
ObjectId integer, # foreign key to Users or Groups, depending
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET ascii;
+)
ENGIN
E=InnoDB CHARACTER SET ascii;
CREATE INDEX Principals2 ON Principals (ObjectId);
CREATE INDEX Principals2 ON Principals (ObjectId);
@@
-89,7
+89,7
@@
CREATE TABLE Groups (
Type varchar(64) CHARACTER SET ascii NULL,
Instance integer,
PRIMARY KEY (id)
Type varchar(64) CHARACTER SET ascii NULL,
Instance integer,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX Groups1 ON Groups (Domain,Instance,Type,id);
CREATE INDEX Groups2 On Groups (Type, Instance);
CREATE INDEX Groups1 ON Groups (Domain,Instance,Type,id);
CREATE INDEX Groups2 On Groups (Type, Instance);
@@
-111,7
+111,7
@@
CREATE TABLE ScripConditions (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-133,7
+133,7
@@
CREATE TABLE Transactions (
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
@@
-159,7
+159,7
@@
CREATE TABLE Scrips (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-175,7
+175,7
@@
CREATE TABLE ACL (
DelegatedBy integer NOT NULL default 0, #foreign key to principals with a userid
DelegatedFrom integer NOT NULL default 0, #foreign key to ACL
PRIMARY KEY (id)
DelegatedBy integer NOT NULL default 0, #foreign key to principals with a userid
DelegatedFrom integer NOT NULL default 0, #foreign key to ACL
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX ACL1 on ACL(RightName, ObjectType, ObjectId,PrincipalType,PrincipalId);
CREATE INDEX ACL1 on ACL(RightName, ObjectType, ObjectId,PrincipalType,PrincipalId);
@@
-188,7
+188,7
@@
CREATE TABLE GroupMembers (
GroupId integer NOT NULL DEFAULT 0,
MemberId integer NOT NULL DEFAULT 0, #Foreign key to Principals
PRIMARY KEY (id)
GroupId integer NOT NULL DEFAULT 0,
MemberId integer NOT NULL DEFAULT 0, #Foreign key to Principals
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE UNIQUE INDEX GroupMembers1 on GroupMembers (GroupId, MemberId);
CREATE UNIQUE INDEX GroupMembers1 on GroupMembers (GroupId, MemberId);
@@
-210,7
+210,7
@@
create table CachedGroupMembers (
# group members recursively.
# Also, this allows us to have the ACL system elide members of disabled groups
PRIMARY KEY (id)
# group members recursively.
# Also, this allows us to have the ACL system elide members of disabled groups
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX DisGrouMem on CachedGroupMembers (GroupId,MemberId,Disabled);
CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
CREATE INDEX DisGrouMem on CachedGroupMembers (GroupId,MemberId,Disabled);
CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
@@
-256,7
+256,7
@@
CREATE TABLE Users (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE UNIQUE INDEX Users1 ON Users (Name) ;
CREATE UNIQUE INDEX Users1 ON Users (Name) ;
@@
-297,7
+297,7
@@
CREATE TABLE Tickets (
Created DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
Created DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
CREATE INDEX Tickets2 ON Tickets (Owner) ;
CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
CREATE INDEX Tickets2 ON Tickets (Owner) ;
@@
-318,7
+318,7
@@
CREATE TABLE ScripActions (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-338,7
+338,7
@@
CREATE TABLE Templates (
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-362,7
+362,7
@@
CREATE TABLE ObjectCustomFieldValues (
LastUpdated DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 , # New -- whether the value was current
PRIMARY KEY (id)
LastUpdated DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 , # New -- whether the value was current
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (Content);
CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId);
CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (Content);
CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId);
@@
-389,7
+389,7
@@
CREATE TABLE CustomFields (
Disabled int2 NOT NULL DEFAULT 0 ,
Required int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
Disabled int2 NOT NULL DEFAULT 0 ,
Required int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-406,7
+406,7
@@
CREATE TABLE ObjectCustomFields (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
# }}}
# }}}
@@
-424,7
+424,7
@@
CREATE TABLE CustomFieldValues (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
@@
-446,7
+446,7
@@
CREATE TABLE Attributes (
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
-)
TYP
E=InnoDB CHARACTER SET utf8;
+)
ENGIN
E=InnoDB CHARACTER SET utf8;
CREATE INDEX Attributes1 on Attributes(Name);
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
CREATE INDEX Attributes1 on Attributes(Name);
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);