projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
import rt 3.6.6
[freeside.git]
/
rt
/
etc
/
schema.Oracle
diff --git
a/rt/etc/schema.Oracle
b/rt/etc/schema.Oracle
index
40238b5
..
569d80c
100644
(file)
--- a/
rt/etc/schema.Oracle
+++ b/
rt/etc/schema.Oracle
@@
-36,7
+36,7
@@
CREATE TABLE Queues (
LastUpdated DATE,
Disabled NUMBER(11,0) DEFAULT 0 NOT NULL
);
LastUpdated DATE,
Disabled NUMBER(11,0) DEFAULT 0 NOT NULL
);
- CREATE INDEX Queues1 ON Queues (
lower(Name
));
+ CREATE INDEX Queues1 ON Queues (
LOWER('Name'
));
CREATE INDEX Queues2 ON Queues (Disabled);
CREATE INDEX Queues2 ON Queues (Disabled);
@@
-82,8
+82,8
@@
CREATE TABLE Groups (
Instance NUMBER(11,0) DEFAULT 0 -- NOT NULL
-- Instance VARCHAR2(64)
);
Instance NUMBER(11,0) DEFAULT 0 -- NOT NULL
-- Instance VARCHAR2(64)
);
-CREATE INDEX Groups1 ON Groups (
lower( Domain), Instance, lower(Type
), id);
-CREATE INDEX Groups2 ON Groups (
lower(Type), Instance, lower(Domain
));
+CREATE INDEX Groups1 ON Groups (
LOWER('Domain'), Instance, LOWER('Type'
), id);
+CREATE INDEX Groups2 ON Groups (
LOWER('Type'), Instance, LOWER('Domain'
));
CREATE SEQUENCE SCRIPCONDITIONS_seq;
CREATE SEQUENCE SCRIPCONDITIONS_seq;
@@
-225,8
+225,8
@@
CREATE TABLE Users (
);
-- CREATE UNIQUE INDEX Users1 ON Users (Name);
);
-- CREATE UNIQUE INDEX Users1 ON Users (Name);
-CREATE INDEX Users2 ON Users( LOWER(
name
));
-CREATE INDEX Users4 ON Users (
lower(EmailAddress
));
+CREATE INDEX Users2 ON Users( LOWER(
'Name'
));
+CREATE INDEX Users4 ON Users (
LOWER('EmailAddress'
));
CREATE SEQUENCE TICKETS_seq;
CREATE SEQUENCE TICKETS_seq;
@@
-320,12
+320,10
@@
CREATE TABLE ObjectCustomFieldValues (
ObjectType VARCHAR2(25) NOT NULL,
ObjectId NUMBER(11,0) DEFAULT 0 NOT NULL,
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
ObjectType VARCHAR2(25) NOT NULL,
ObjectId NUMBER(11,0) DEFAULT 0 NOT NULL,
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
-
Content VARCHAR2(255),
LargeContent CLOB,
ContentType VARCHAR2(80),
ContentEncoding VARCHAR2(80),
Content VARCHAR2(255),
LargeContent CLOB,
ContentType VARCHAR2(80),
ContentEncoding VARCHAR2(80),
-
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,