projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
update address standardization for cust_location changes
[freeside.git]
/
rt
/
etc
/
upgrade
/
3.1.0
/
schema.mysql
diff --git
a/rt/etc/upgrade/3.1.0/schema.mysql
b/rt/etc/upgrade/3.1.0/schema.mysql
index
c4a345d
..
e4f02c2
100755
(executable)
--- a/
rt/etc/upgrade/3.1.0/schema.mysql
+++ b/
rt/etc/upgrade/3.1.0/schema.mysql
@@
-1,4
+1,3
@@
-# {{{ Attributes
CREATE TABLE Attributes (
id INTEGER NOT NULL AUTO_INCREMENT,
CREATE TABLE Attributes (
id INTEGER NOT NULL AUTO_INCREMENT,
@@
-13,9
+12,8
@@
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;
+)
ENGIN
E=InnoDB;
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);
-# }}}