[rt-devel] Re: [rt-users] rt3 with oracle

[Brook Schofield]

At 03:47 PM 17/04/2003 +1000, Brook Schofield wrote:
>For some reason I haven't thought of changing the schema for that table 
>and just trying to get the import working - but I'm making slow/steady 
>progress hunting down the problem.

[Thread crossed from rt-users]

The install process gets heaps further when I changed the database schema 
for GroupMembers:

CREATE TABLE GroupMembers (
         id              NUMBER(11,0) PRIMARY KEY,
         GroupId         NUMBER(11,0) DEFAULT 0,
--      GroupId         NUMBER(11,0) DEFAULT 0 NOT NULL,
         MemberId        NUMBER(11,0) DEFAULT 0 NOT NULL
);

the only problem is that it really shouldn't be setup like this. I'm going 
to look at the initialize-database under MySQL in some detail. And workout 
what it is doing under those circumstances - and see how/if the change to 
Oracle is breaking it.

-Brook

=========================================================================
=     _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/  _/ Brook Schofield                =
=    _/  _/ _/  _/ _/  _/ _/  _/ _/ _/   B.Schofield at griffith.edu.au    =
=   _/_/   _/_/_/ _/  _/ _/  _/ _/_/     Ph: +61 7 387 53779 - WCN 0.28 =
=  _/  _/ _/ _/  _/  _/ _/  _/ _/ _/     Directory Services Integration =
= _/_/_/ _/  _/ _/_/_/ _/_/_/ _/  _/     Griffith University QLD 4111   =
=========================================================================