portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kimp...@apache.org
Subject cvs commit: jakarta-jetspeed/src/sql/external turbine-sqlserver.sql
Date Mon, 10 Jun 2002 15:56:54 GMT
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:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message