tested with oracle8i
can someone explain how the generation of the sql-files works??
Index: ./src/sql/turbine-oracle.sql
===================================================================
RCS file: /products/cvs/turbine/turbine/src/sql/turbine-oracle.sql,v
retrieving revision 1.3
diff -r1.3 turbine-oracle.sql
88,89c88
< REFERENCES TURBINE_ROLE (ROLEID)
< USING INDEX;
---
> REFERENCES TURBINE_ROLE (ROLEID);
93,99c92
< REFERENCES TURBINE_PERMISSION (PERMISSIONID)
< USING INDEX;
<
<
< CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION
(ROLEID, PERMISSIONID);
<
<
---
> REFERENCES TURBINE_PERMISSION (PERMISSIONID);
145,148c138
< REFERENCES TURBINE_USER (USERID)
< USING INDEX;
<
<
---
> REFERENCES TURBINE_USER (USERID);
171,172c161
< REFERENCES TURBINE_USER (USERID)
< USING INDEX;
---
> REFERENCES TURBINE_USER (USERID);
176,177c165
< REFERENCES TURBINE_GROUP (GROUPID)
< USING INDEX;
---
> REFERENCES TURBINE_GROUP (GROUPID);
181,186c169
< REFERENCES TURBINE_USER_ROLE (ROLEID)
< USING INDEX;
<
<
< CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE
(USERID, GROUPID, ROLEID);
<
---
> REFERENCES TURBINE_ROLE (ROLEID);
209d191
<
The command completed successfully.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
