[Nmrshiftdb-devel] CVS: nmrshiftdb/src/conf/jetspeed/WEB-INF/db turbine-schema.sql,1.1,1.2

[Stefan K. <sk...@us...>]

Update of /cvsroot/nmrshiftdb/nmrshiftdb/src/conf/jetspeed/WEB-INF/db
In directory usw-pr-cvs1:/tmp/cvs-serv21745

Modified Files:
	turbine-schema.sql 
Log Message:
errors corrected


Index: turbine-schema.sql
===================================================================
RCS file: /cvsroot/nmrshiftdb/nmrshiftdb/src/conf/jetspeed/WEB-INF/db/turbine-schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** turbine-schema.sql	27 Feb 2002 13:30:45 -0000	1.1
--- turbine-schema.sql	1 Mar 2002 10:10:12 -0000	1.2
***************
*** 1,3 ****
! 
  # -----------------------------------------------------------------------
  # TURBINE_PERMISSION
--- 1,3 ----
! 
  # -----------------------------------------------------------------------
  # TURBINE_PERMISSION
***************
*** 11,15 ****
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(PERMISSION_ID),
!     UNIQUE (PERMISSION_NAME),
  );
  
--- 11,15 ----
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(PERMISSION_ID),
!     UNIQUE (PERMISSION_NAME)
  );
  
***************
*** 25,29 ****
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(ROLE_ID),
!     UNIQUE (ROLE_NAME),
  );
  
--- 25,29 ----
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(ROLE_ID),
!     UNIQUE (ROLE_NAME)
  );
  
***************
*** 39,43 ****
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(GROUP_ID),
!     UNIQUE (GROUP_NAME),
  );
  
--- 39,43 ----
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(GROUP_ID),
!     UNIQUE (GROUP_NAME)
  );
  
***************
*** 54,58 ****
      INDEX(PERMISSION_ID),
      FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
!     FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID),
  );
  
--- 54,58 ----
      INDEX(PERMISSION_ID),
      FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
!     FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
  );
  
***************
*** 84,88 ****
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(USER_ID),
!     UNIQUE (LOGIN_NAME),
  );
  
--- 84,88 ----
      OBJECTDATA MEDIUMBLOB,
      PRIMARY KEY(USER_ID),
!     UNIQUE (LOGIN_NAME)
  );
  
***************
*** 102,106 ****
      FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
      FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
!     FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
  );
  
--- 102,106 ----
      FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
      FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
!     FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
  );
  
***************
*** 110,114 ****
  drop table if exists TURBINE_SCHEDULED_JOB;
  
! CREATE TABLE TURBINE_SCHEDULED_JOB
  (
      JOB_ID INTEGER NOT NULL,
--- 110,114 ----
  drop table if exists TURBINE_SCHEDULED_JOB;
  
! CREATE TABLE TURBINE_SCHEDULED_JOB
  (
      JOB_ID INTEGER NOT NULL,
***************
*** 121,126 ****
      EMAIL VARCHAR (99),
      PROPERTY MEDIUMBLOB,
!     PRIMARY KEY(JOB_ID),
! );
  
  # -----------------------------------------------------------------------
--- 121,126 ----
      EMAIL VARCHAR (99),
      PROPERTY MEDIUMBLOB,
!     PRIMARY KEY(JOB_ID)
! );
  
  # -----------------------------------------------------------------------
***************
*** 136,140 ****
      QUANTITY INTEGER,
      PRIMARY KEY(ID_TABLE_ID),
!     UNIQUE (TABLE_NAME),
  );
    
--- 136,140 ----
      QUANTITY INTEGER,
      PRIMARY KEY(ID_TABLE_ID),
!     UNIQUE (TABLE_NAME)
  );