portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r426175 - /portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
Date Thu, 27 Jul 2006 18:08:09 GMT
Author: taylor
Date: Thu Jul 27 11:08:08 2006
New Revision: 426175

URL: http://svn.apache.org/viewvc?rev=426175&view=rev
Log:
tweaking db2 ddl
testing against DB2 AS/400 with JTOpen JS4000 driver

Modified:
    portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql

Modified: portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql?rev=426175&r1=426174&r2=426175&view=diff
==============================================================================
--- portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql (original)
+++ portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql Thu Jul 27 11:08:08 2006
@@ -21,19 +21,19 @@
 
 CREATE TABLE TURBINE_USER
 (
-            USER_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            LOGIN_NAME VARCHAR (32) NOT NULL,
-            PASSWORD_VALUE VARCHAR (32) NOT NULL,
-            FIRST_NAME VARCHAR (99) NOT NULL,
-            LAST_NAME VARCHAR (99) NOT NULL,
-            EMAIL VARCHAR (99),
-            CONFIRM_VALUE VARCHAR (99),
-            MODIFIED TIMESTAMP,
-            CREATED TIMESTAMP,
-            LAST_LOGIN TIMESTAMP,
-            DISABLED VARCHAR (1),
-            OBJECTDATA CHAR(1) FOR BIT DATA CHAR(n) FOR BIT DATA,
-            PASSWORD_CHANGED TIMESTAMP,
+    USER_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    LOGIN_NAME VARCHAR (32) NOT NULL,
+    PASSWORD_VALUE VARCHAR (32) NOT NULL,
+    FIRST_NAME VARCHAR (99) NOT NULL,
+    LAST_NAME VARCHAR (99) NOT NULL,
+    EMAIL VARCHAR (99),
+    CONFIRM_VALUE VARCHAR (99),
+    MODIFIED TIMESTAMP,
+    CREATED TIMESTAMP,
+    LAST_LOGIN TIMESTAMP,
+    DISABLED VARCHAR (1),
+    OBJECTDATA BLOB,            
+    PASSWORD_CHANGED TIMESTAMP,
     UNIQUE (LOGIN_NAME)
 );
 
@@ -41,8 +41,6 @@
     ADD PRIMARY KEY (USER_ID);
 
 
-
-
 -----------------------------------------------------------------------------
 -- TURBINE_ROLE
 -----------------------------------------------------------------------------
@@ -50,9 +48,9 @@
 
 CREATE TABLE TURBINE_ROLE
 (
-            ROLE_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            ROLE_NAME VARCHAR (99) NOT NULL,
-            OBJECTDATA CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
+    ROLE_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    ROLE_NAME VARCHAR (99) NOT NULL,
+    OBJECTDATA BLOB,
     UNIQUE (ROLE_NAME)
 );
 
@@ -69,10 +67,10 @@
 
 CREATE TABLE TURBINE_GROUP
 (
-            GROUP_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            GROUP_NAME VARCHAR (99) NOT NULL,
-            OBJECTDATA CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
-    UNIQUE (GROUP_NAME)
+    GROUP_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    GROUP_NAME VARCHAR (99) NOT NULL,
+    OBJECTDATA BLOB,
+	UNIQUE (GROUP_NAME)
 );
 
 ALTER TABLE TURBINE_GROUP
@@ -88,9 +86,9 @@
 
 CREATE TABLE TURBINE_PERMISSION
 (
-            PERMISSION_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            PERMISSION_NAME VARCHAR (99) NOT NULL,
-            OBJECTDATA CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
+    PERMISSION_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    PERMISSION_NAME VARCHAR (99) NOT NULL,
+    OBJECTDATA BLOB,
     UNIQUE (PERMISSION_NAME)
 );
 
@@ -107,8 +105,8 @@
 
 CREATE TABLE TURBINE_ROLE_PERMISSION
 (
-            ROLE_ID INTEGER NOT NULL,
-            PERMISSION_ID INTEGER NOT NULL
+    ROLE_ID INTEGER NOT NULL,
+    PERMISSION_ID INTEGER NOT NULL
 );
 
 ALTER TABLE TURBINE_ROLE_PERMISSION
@@ -132,9 +130,9 @@
 
 CREATE TABLE TURBINE_USER_GROUP_ROLE
 (
-            USER_ID INTEGER NOT NULL,
-            GROUP_ID INTEGER NOT NULL,
-            ROLE_ID INTEGER NOT NULL
+    USER_ID INTEGER NOT NULL,
+    GROUP_ID INTEGER NOT NULL,
+    ROLE_ID INTEGER NOT NULL
 );
 
 ALTER TABLE TURBINE_USER_GROUP_ROLE
@@ -160,22 +158,19 @@
 
 CREATE TABLE JETSPEED_USER_PROFILE
 (
-            PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            USER_NAME VARCHAR (32) NOT NULL,
-            MEDIA_TYPE VARCHAR (99),
-            LANGUAGE VARCHAR (2),
-            COUNTRY VARCHAR (2),
-            PAGE VARCHAR (99),
-            PROFILE CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
+    PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    USER_NAME VARCHAR (32) NOT NULL,
+    MEDIA_TYPE VARCHAR (99),
+    LANGUAGE VARCHAR (2),
+    COUNTRY VARCHAR (2),
+    PAGE VARCHAR (99),
+    PROFILE BLOB,
     UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
 );
 
 ALTER TABLE JETSPEED_USER_PROFILE
     ADD PRIMARY KEY (PSML_ID);
 
-
-
-
 -----------------------------------------------------------------------------
 -- JETSPEED_GROUP_PROFILE
 -----------------------------------------------------------------------------
@@ -183,22 +178,19 @@
 
 CREATE TABLE JETSPEED_GROUP_PROFILE
 (
-            PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            GROUP_NAME VARCHAR (99) NOT NULL,
-            MEDIA_TYPE VARCHAR (99),
-            LANGUAGE VARCHAR (2),
-            COUNTRY VARCHAR (2),
-            PAGE VARCHAR (99),
-            PROFILE CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
+    PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    GROUP_NAME VARCHAR (99) NOT NULL,
+    MEDIA_TYPE VARCHAR (99),
+    LANGUAGE VARCHAR (2),
+    COUNTRY VARCHAR (2),
+    PAGE VARCHAR (99),
+    PROFILE BLOB,
     UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
 );
 
 ALTER TABLE JETSPEED_GROUP_PROFILE
     ADD PRIMARY KEY (PSML_ID);
 
-
-
-
 -----------------------------------------------------------------------------
 -- JETSPEED_ROLE_PROFILE
 -----------------------------------------------------------------------------
@@ -206,13 +198,13 @@
 
 CREATE TABLE JETSPEED_ROLE_PROFILE
 (
-            PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            ROLE_NAME VARCHAR (99) NOT NULL,
-            MEDIA_TYPE VARCHAR (99),
-            LANGUAGE VARCHAR (2),
-            COUNTRY VARCHAR (2),
-            PAGE VARCHAR (99),
-            PROFILE CHAR(99) FOR BIT DATA CHAR(n) FOR BIT DATA,
+    PSML_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    ROLE_NAME VARCHAR (99) NOT NULL,
+    MEDIA_TYPE VARCHAR (99),
+    LANGUAGE VARCHAR (2),
+    COUNTRY VARCHAR (2),
+    PAGE VARCHAR (99),
+    PROFILE BLOB,
     UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
 );
 
@@ -227,12 +219,12 @@
 
 CREATE TABLE COFFEES
 (
-            COFFEE_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-            COFFEE_NAME VARCHAR (50),
-            SUPPLIER_ID INTEGER,
-            PRICE FLOAT,
-            SALES INTEGER,
-            TOTAL INTEGER
+    COFFEE_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    COFFEE_NAME VARCHAR (50),
+    SUPPLIER_ID INTEGER,
+    PRICE FLOAT,
+    SALES INTEGER,
+    TOTAL INTEGER
 );
 
 ALTER TABLE COFFEES
@@ -247,11 +239,11 @@
 drop table EMAIL_INBOX;
 
 CREATE TABLE EMAIL_INBOX (
-  EMAIL_INBOX_ID INTEGER(11) NOT NULL AUTO_INCREMENT,
+  EMAIL_INBOX_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
   MESSAGE_ID VARCHAR(255),
   FILENAME VARCHAR(255),
   ATTACHMENT BLOB,
-  READFLAG INTEGER(11)
+  READFLAG INTEGER
 );
 
 ALTER TABLE EMAIL_INBOX



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message