X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2Fetc%2Fschema.Oracle;h=77efefadb4f2d57a7b49117acc4a6937bf0fb67b;hp=569d80cc4be34f8af8d76bb4d7612a529333658f;hb=2dfda73eeb3eae2d4f894099754794ef07d060dd;hpb=8103c1fc1b2c27a6855feadf26f91b980a54bc52

diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle
index 569d80cc4..77efefadb 100644
--- 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
 );
- CREATE  INDEX Queues1 ON Queues (LOWER('Name'));
+ CREATE  INDEX Queues1 ON Queues (LOWER(Name));
 CREATE INDEX Queues2 ON Queues (Disabled);
 
 
@@ -82,8 +82,8 @@ CREATE TABLE Groups (
 	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;
@@ -225,8 +225,8 @@ CREATE TABLE Users (
 );
 -- 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;