You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2006/07/27 20:08:09 UTC
svn commit: r426175 -
/portals/jetspeed-1/trunk/src/sql/external/turbine-db2.sql
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