[rt-users] a drop/schema error for oracle

Craig Stevenson stevensc at nsuok.edu
Wed Nov 16 14:51:42 EST 2005


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 at nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399





More information about the rt-users mailing list