kimptoc 2002/06/10 08:56:54
Modified: src/sql/external turbine-sqlserver.sql
Log:
some tweaks to make it work - not sure if varchar is best for objectdata though, but
it seems to work
Revision Changes Path
1.2 +32 -11 jakarta-jetspeed/src/sql/external/turbine-sqlserver.sql
Index: turbine-sqlserver.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-sqlserver.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- turbine-sqlserver.sql 10 Jun 2002 15:23:56 -0000 1.1
+++ turbine-sqlserver.sql 10 Jun 2002 15:56:54 -0000 1.2
@@ -1,3 +1,9 @@
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'ID_TABLE')
+BEGIN
+ DROP TABLE ID_TABLE
+END
+;
+
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_SCHEDULED_JOB')
BEGIN
DROP TABLE TURBINE_SCHEDULED_JOB
@@ -49,7 +55,7 @@
END
;
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_PERMISSION */
/* ---------------------------------------------------------------------- */
@@ -64,14 +70,14 @@
(
PERMISSION_ID INT NOT NULL,
PERMISSION_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA CHAR(10),
+ OBJECTDATA VARCHAR(5000),
CONSTRAINT TURBINE_PERMISSION_PK PRIMARY KEY(PERMISSION_ID),
UNIQUE (PERMISSION_NAME)
);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_ROLE */
/* ---------------------------------------------------------------------- */
@@ -80,14 +86,14 @@
(
ROLE_ID INT NOT NULL,
ROLE_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA CHAR(10),
+ OBJECTDATA VARCHAR(5000),
CONSTRAINT TURBINE_ROLE_PK PRIMARY KEY(ROLE_ID),
UNIQUE (ROLE_NAME)
);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_GROUP */
/* ---------------------------------------------------------------------- */
@@ -96,14 +102,14 @@
(
GROUP_ID INT NOT NULL,
GROUP_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA CHAR(10),
+ OBJECTDATA VARCHAR(5000),
CONSTRAINT TURBINE_GROUP_PK PRIMARY KEY(GROUP_ID),
UNIQUE (GROUP_NAME)
);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_ROLE_PERMISSION */
/* ---------------------------------------------------------------------- */
@@ -128,7 +134,7 @@
CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLE_ID,
PERMISSION_ID);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_USER */
/* ---------------------------------------------------------------------- */
@@ -146,14 +152,14 @@
CREATED DATETIME,
LAST_LOGIN DATETIME,
DISABLED VARCHAR(1),
- OBJECTDATA CHAR(10),
+ OBJECTDATA VARCHAR(5000),
CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_USER_GROUP_ROLE */
/* ---------------------------------------------------------------------- */
@@ -184,7 +190,7 @@
CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID,
ROLE_ID);
-
+
/* ---------------------------------------------------------------------- */
/* TURBINE_SCHEDULED_JOB */
/* ---------------------------------------------------------------------- */
@@ -204,3 +210,18 @@
+/* ----------------------------------------------------------------------------- */
+/* -- ID_TABLE */
+/* ----------------------------------------------------------------------------- */
+
+CREATE TABLE ID_TABLE
+(
+ ID_TABLE_ID INT NOT NULL,
+ TABLE_NAME VARCHAR (255) NOT NULL,
+ NEXT_ID INT,
+ QUANTITY INT,
+ CONSTRAINT ID_TABLE_PK PRIMARY KEY(ID_TABLE_ID),
+ UNIQUE (TABLE_NAME)
+);
+
+
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
