[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