Hi,
I took a look at turbine-oracle.sql and changed some stuff to get it
working.
The diff is below.
Jason van Zyl wrote:
>
> Hi,
>
> The following SQL files are now in CVS:
>
> turbine-mysql.sql
> turbine-postgres.sql
> turbine-db2.sql
> turbine-sybase.sql
> turbine-hypersonic.sql
> turbine-oracle.sql
>
> These files are in the src/sql directory. There are more then
> likely problems with all so I if any can spare a moment
> to look at any of the files it would be appreciated.
>
> --
> jvz.
>
> Jason van Zyl
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
--
------------------------------------------------------------------------
Svante S�rmark | Chalmers University IT systems & services | 031-7728665
------------------------------------------------------------------------
--- turbine-oracle.sql.orig Mon Nov 20 22:45:13 2000
+++ turbine-oracle.sql Tue Nov 21 01:45:05 2000
@@ -2,8 +2,8 @@
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
-drop table if exists TURBINE_PERMISSION;
-drop sequence if exists TURBINE_PERMISSION_SEQ;
+drop table TURBINE_PERMISSION cascade constraints;
+drop sequence TURBINE_PERMISSION_SEQ;
CREATE TABLE TURBINE_PERMISSION
(
@@ -25,8 +25,8 @@
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
-drop table if exists TURBINE_ROLE;
-drop sequence if exists TURBINE_ROLE_SEQ;
+drop table TURBINE_ROLE cascade constraints;
+drop sequence TURBINE_ROLE_SEQ;
CREATE TABLE TURBINE_ROLE
(
@@ -48,13 +48,13 @@
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
-drop table if exists TURBINE_GROUP;
-drop sequence if exists TURBINE_GROUP_SEQ;
+drop table TURBINE_GROUP cascade constraints;
+drop sequence TURBINE_GROUP_SEQ;
CREATE TABLE TURBINE_GROUP
(
GROUPID INT NOT NULL,
- GROUPNAME INT (99) NOT NULL,
+ GROUPNAME INT NOT NULL,
OBJECTDATA LONG RAW,
UNIQUE (GROUPNAME)
);
@@ -71,7 +71,7 @@
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
-drop table if exists TURBINE_ROLE_PERMISSION;
+drop table TURBINE_ROLE_PERMISSION;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
@@ -86,23 +86,22 @@
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLEID)
REFERENCES TURBINE_ROLE (ROLEID)
-USING INDEX;
+;
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY
(PERMISSIONID)
REFERENCES TURBINE_PERMISSION (PERMISSIONID)
-USING INDEX;
+;
-CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLEID,
PERMISSIONID);
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
-drop table if exists TURBINE_USER;
-drop sequence if exists TURBINE_USER_SEQ;
+drop table TURBINE_USER cascade constraints;
+drop sequence TURBINE_USER_SEQ;
CREATE TABLE TURBINE_USER
(
@@ -143,7 +142,7 @@
ALTER TABLE TURBINE_USER
ADD CONSTRAINT TURBINE_USER_FK_1 FOREIGN KEY (USERID)
REFERENCES TURBINE_USER (USERID)
-USING INDEX;
+;
@@ -153,7 +152,7 @@
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
-drop table if exists TURBINE_USER_GROUP_ROLE;
+drop table TURBINE_USER_GROUP_ROLE;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
@@ -169,27 +168,27 @@
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USERID)
REFERENCES TURBINE_USER (USERID)
-USING INDEX;
+;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUPID)
REFERENCES TURBINE_GROUP (GROUPID)
-USING INDEX;
-
-ALTER TABLE TURBINE_USER_GROUP_ROLE
- ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLEID)
- REFERENCES TURBINE_USER_ROLE (ROLEID)
-USING INDEX;
-
+;
-CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USERID,
GROUPID, ROLEID);
+-- where is TURBINE_USER_ROLE? typo?
+--ALTER TABLE TURBINE_USER_GROUP_ROLE
+-- ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLEID)
+-- REFERENCES TURBINE_USER_ROLE (ROLEID)
+--;
+-- same as TURBINE_USER_GROUP_ROLE_PK
+--CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE
(USERID, GROUPID, ROLEID);
-----------------------------------------------------------------------------
-- TURBINE_JOBENTRY
-----------------------------------------------------------------------------
-drop table if exists TURBINE_JOBENTRY;
+drop table TURBINE_JOBENTRY;
CREATE TABLE TURBINE_JOBENTRY
(
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
