Hi:
I have been working on an oracle install of rt.
I found a problem creating the table:
CREATE TABLE ObjectCustomFieldValues (
id NUMBER(11,0)
CONSTRAINT ObjectCustomFieldValues_Key PRIMARY KEY,
CustomField NUMBER(11,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),
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE,
Disabled NUMBER(11,0) DEFAULT 0 NOT NULL
);
There were blank lines in the prior command. This causes sqlplus to be
ill-bahaved.
There was also a problem in drop.Oracle. It had a useless table
definition, and was missing others… Here is the diff:
19c17
< --DROP TABLE TICKETCUSTOMFIELDVALUES;
DROP TABLE TICKETCUSTOMFIELDVALUES;
32,33d29
< drop sequence objectcustomfields_seq;
< drop sequence objectcustomfieldvalues_seq;
40c36
< --DROP SEQUENCE TICKETCUSTOMFIELDVALUES_seq;
DROP SEQUENCE TICKETCUSTOMFIELDVALUES_seq;
Thanks.
Craig Stevenson
|| stevensc@nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399