On Mon, 4 Dec 2000, Andre Schild wrote:
> In the sybase sql script there are still two problems:
>
> 1. In the following code, the alter-statement of the constraints, must be wrapped in
>BEGIN ... END statements, just as in the drop table sequences.
>
> IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
>name='TURBINE_ROLE_PERMISSION_FK_1')
> ALTER TABLE TURBINE_ROLE_PERMISSION DROP CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1
> GO
Ok, I'll fix the torque template for sybase. Thanks.
> 2. On line 172 we see the following text:
>
> ALTER TABLE TURBINE_USER_GROUP_ROLE
> ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
> REFERENCES TURBINE_USER_ROLE (ROLE_ID)
> GO
>
> It references the TURBINE_USER_ROLE table.... but this one just doesn't exist...
> The same reference exists in: turbine-db2.sql , turbine-mysql.sql turbine-oracle.sql
>and turbine-postgres.sql !!!!!!
Yes, well the SQL is generated from an XML schema so that's not really
that surprising :-) Look at the conf/master/turbine-schema.xml if you
want to see the source
jvz.
> Andr�.
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
