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

Jesse Vincent jesse at bestpractical.com
Wed Nov 16 15:03:15 EST 2005




On Wed, Nov 16, 2005 at 01:51:42PM -0600, Craig Stevenson wrote:
> Hi:
> 
> I have been working on an oracle install of rt.
> 
> I found a problem creating the table:

What version of oracle?

> 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
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at 
> http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html
> 

-- 



More information about the rt-users mailing list