ozeigermann 2003/11/26 08:19:47
Modified: proposals/stores/org/apache/slide/store/impl/rdbms
SQLServerSchema.sql SybaseSchema.sql
MySqlSchema.sql
Log:
Seemed to be treated as binaries. Should be ASCII now! Thanks to Chris Lenz
Revision Changes Path
1.4 +280 -280
jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SQLServerSchema.sql
Index: SQLServerSchema.sql
===================================================================
RCS file:
/home/cvs/jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SQLServerSchema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- SQLServerSchema.sql 25 Nov 2003 13:31:11 -0000 1.3
+++ SQLServerSchema.sql 26 Nov 2003 16:19:46 -0000 1.4
@@ -1,280 +1,280 @@
-/**********************************************************************/
-/****** DROP SLIDE TABLES ******/
-/**********************************************************************/
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[OBJECT]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[OBJECT]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CHILDREN]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[CHILDREN]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LINKS]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[LINKS]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LOCKS]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[LOCKS]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_CONTENT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[VERSION_CONTENT]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PROPERTIES]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[PROPERTIES]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[PERMISSIONS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[PERMISSIONS]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_PREDS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[VERSION_PREDS]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_LABELS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[VERSION_LABELS]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_HISTORY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[VERSION_HISTORY]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[VERSION]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[VERSION]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[BRANCH]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[BRANCH]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LABEL]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[LABEL]
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[URI]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
-DROP TABLE [dbo].[URI]
-GO
-
-/**********************************************************************/
-/****** DROP EXISTING USER DEFINED DATA TYPES ******/
-/**********************************************************************/
-
-sp_droptype id_type
-GO
-
-sp_droptype uri_str_type
-GO
-
-sp_droptype revision_no_type
-GO
-
-sp_droptype hash_type
-GO
-
-sp_droptype literal_str_type
-GO
-
-sp_droptype value_str_type
-GO
-
-
-/**********************************************************************/
-/****** ADD USER DEFINED DATA TYPES ******/
-/**********************************************************************/
-
-sp_addtype id_type, bigint
-GO
-
-sp_addtype uri_str_type, "varchar(800)"
-GO
-
-sp_addtype revision_no_type, "varchar(20)"
-GO
-
-sp_addtype hash_type, bigint
-GO
-
-sp_addtype literal_str_type, "varchar(3000)"
-GO
-
-sp_addtype value_str_type, "varchar(255)"
-GO
-
-/**********************************************************************/
-/****** CREATE SLIDE TABLES ******/
-/**********************************************************************/
-
-CREATE TABLE dbo.URI (
- URI_ID id_type IDENTITY UNIQUE NOT NULL,
- URI_STRING uri_str_type UNIQUE NOT NULL,
- -- UNIQUE NONCLUSTERED (URI_ID)
-)
-GO
-
-CREATE INDEX XUID
- ON URI(URI_ID)
-GO
-
-CREATE INDEX XUSTRING
- ON URI(URI_STRING)
-GO
-
-CREATE TABLE dbo.OBJECT (
- URI_ID id_type PRIMARY KEY,
- CLASS_NAME varchar(255) NOT NULL,
- CONSTRAINT FK_OBJECT_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.CHILDREN (
- URI_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- CHILD_URI_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- --UNIQUE CLUSTERED (URI_ID, CHILD_URI_ID)
-)
-GO
-
-CREATE INDEX XCHILDREN1
- ON CHILDREN(URI_ID)
-GO
-CREATE INDEX XCHILDREN2
- ON CHILDREN(CHILD_URI_ID)
-GO
-
-CREATE TABLE dbo.LINKS (
- URI_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- LINK_TO_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- --UNIQUE CLUSTERED (URI_ID, LINK_TO_ID)
-)
-GO
-
-CREATE INDEX XURI_ID
- ON LINKS(URI_ID)
-GO
-
-
-CREATE INDEX XLINK_TO_ID
- ON LINKS(LINK_TO_ID)
-GO
-
-CREATE TABLE dbo.LOCKS (
- LOCK_ID id_type PRIMARY KEY,
- OBJECT_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- SUBJECT_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- TYPE_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- EXPIRATION_DATE numeric(14, 0) NOT NULL,
- IS_INHERITABLE bit NOT NULL,
- IS_EXCLUSIVE bit NOT NULL,
- CONSTRAINT FK_LOCKS_LOCK_ID
- FOREIGN KEY (LOCK_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.BRANCH (
- BRANCH_ID id_type IDENTITY UNIQUE NOT NULL,
- BRANCH_STRING varchar(255) UNIQUE NOT NULL,
- UNIQUE NONCLUSTERED (BRANCH_ID)
-)
-GO
-
-CREATE TABLE dbo.LABEL (
- LABEL_ID id_type IDENTITY UNIQUE NOT NULL,
- LABEL_STRING varchar(255) NOT NULL,
- UNIQUE NONCLUSTERED (LABEL_ID)
-)
-GO
-
-CREATE TABLE dbo.VERSION (
- URI_ID id_type PRIMARY KEY,
- IS_VERSIONED bit NOT NULL,
- CONSTRAINT FK_VERSION_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.VERSION_HISTORY (
- VERSION_ID id_type IDENTITY UNIQUE NOT NULL,
- URI_ID id_type NOT NULL FOREIGN KEY
- REFERENCES VERSION (URI_ID),
- BRANCH_ID id_type NOT NULL FOREIGN KEY
- REFERENCES BRANCH (BRANCH_ID),
- REVISION_NO VARCHAR(20) NOT NULL,
- --UNIQUE CLUSTERED (URI_ID, BRANCH_ID, REVISION_NO)
-)
-GO
-CREATE INDEX XVERSION_HISTORY1
- ON VERSION_HISTORY(URI_ID, BRANCH_ID, REVISION_NO)
-GO
-
-CREATE TABLE dbo.VERSION_PREDS (
- VERSION_ID id_type NOT NULL FOREIGN KEY
- REFERENCES VERSION_HISTORY (VERSION_ID),
- PREDECESSOR_ID id_type NOT NULL FOREIGN KEY
- REFERENCES VERSION_HISTORY (VERSION_ID),
- UNIQUE CLUSTERED (VERSION_ID, PREDECESSOR_ID)
-)
-GO
-CREATE INDEX XVERSION_PREDS1
- ON VERSION_PREDS(VERSION_ID, PREDECESSOR_ID)
-GO
-
-CREATE TABLE dbo.VERSION_LABELS (
- VERSION_ID id_type NOT NULL FOREIGN KEY
- REFERENCES VERSION_HISTORY (VERSION_ID),
- LABEL_ID id_type NOT NULL FOREIGN KEY
- REFERENCES LABEL (LABEL_ID),
- UNIQUE CLUSTERED (VERSION_ID, LABEL_ID)
-)
-GO
-
-CREATE TABLE dbo.VERSION_CONTENT (
- VERSION_ID id_type PRIMARY KEY,
- CONTENT image NOT NULL,
- CONSTRAINT FK_VC_VERSION_ID
- FOREIGN KEY (VERSION_ID)
- REFERENCES VERSION_HISTORY (VERSION_ID),
-)
-GO
-
-CREATE TABLE dbo.PROPERTIES (
- VERSION_ID id_type NOT NULL FOREIGN KEY
- REFERENCES VERSION_HISTORY (VERSION_ID),
- PROPERTY_NAMESPACE varchar(50) NOT NULL,
- PROPERTY_NAME varchar(50) NOT NULL,
- PROPERTY_VALUE varchar(255) NOT NULL,
- PROPERTY_TYPE varchar(50) NOT NULL,
- IS_PROTECTED bit NOT NULL,
- UNIQUE CLUSTERED (VERSION_ID, PROPERTY_NAMESPACE, PROPERTY_NAME)
-)
-GO
-
-CREATE TABLE dbo.PERMISSIONS (
- OBJECT_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- SUBJECT_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- ACTION_ID id_type NOT NULL FOREIGN KEY
- REFERENCES URI (URI_ID),
- VERSION_NO VARCHAR(20) NULL,
- IS_INHERITABLE bit NOT NULL,
- IS_NEGATIVE bit NOT NULL,
- -- Both order and sequence would be more suitable, but can not be used
- SUCCESSION int NOT NULL,
- UNIQUE CLUSTERED (OBJECT_ID, SUBJECT_ID, ACTION_ID),
- UNIQUE (OBJECT_ID, SUCCESSION)
-)
-GO
-
+/**********************************************************************/
+/****** DROP SLIDE TABLES ******/
+/**********************************************************************/
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[OBJECT]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[OBJECT]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CHILDREN]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[CHILDREN]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LINKS]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[LINKS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LOCKS]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[LOCKS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_CONTENT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[VERSION_CONTENT]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PROPERTIES]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[PROPERTIES]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[PERMISSIONS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[PERMISSIONS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_PREDS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[VERSION_PREDS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_LABELS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[VERSION_LABELS]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'[dbo].[VERSION_HISTORY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[VERSION_HISTORY]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[VERSION]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[VERSION]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[BRANCH]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[BRANCH]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LABEL]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[LABEL]
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[URI]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
+DROP TABLE [dbo].[URI]
+GO
+
+/**********************************************************************/
+/****** DROP EXISTING USER DEFINED DATA TYPES ******/
+/**********************************************************************/
+
+sp_droptype id_type
+GO
+
+sp_droptype uri_str_type
+GO
+
+sp_droptype revision_no_type
+GO
+
+sp_droptype hash_type
+GO
+
+sp_droptype literal_str_type
+GO
+
+sp_droptype value_str_type
+GO
+
+
+/**********************************************************************/
+/****** ADD USER DEFINED DATA TYPES ******/
+/**********************************************************************/
+
+sp_addtype id_type, bigint
+GO
+
+sp_addtype uri_str_type, "varchar(800)"
+GO
+
+sp_addtype revision_no_type, "varchar(20)"
+GO
+
+sp_addtype hash_type, bigint
+GO
+
+sp_addtype literal_str_type, "varchar(3000)"
+GO
+
+sp_addtype value_str_type, "varchar(255)"
+GO
+
+/**********************************************************************/
+/****** CREATE SLIDE TABLES ******/
+/**********************************************************************/
+
+CREATE TABLE dbo.URI (
+ URI_ID id_type IDENTITY UNIQUE NOT NULL,
+ URI_STRING uri_str_type UNIQUE NOT NULL,
+ -- UNIQUE NONCLUSTERED (URI_ID)
+)
+GO
+
+CREATE INDEX XUID
+ ON URI(URI_ID)
+GO
+
+CREATE INDEX XUSTRING
+ ON URI(URI_STRING)
+GO
+
+CREATE TABLE dbo.OBJECT (
+ URI_ID id_type PRIMARY KEY,
+ CLASS_NAME varchar(255) NOT NULL,
+ CONSTRAINT FK_OBJECT_URI_ID
+ FOREIGN KEY (URI_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.CHILDREN (
+ URI_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ CHILD_URI_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ --UNIQUE CLUSTERED (URI_ID, CHILD_URI_ID)
+)
+GO
+
+CREATE INDEX XCHILDREN1
+ ON CHILDREN(URI_ID)
+GO
+CREATE INDEX XCHILDREN2
+ ON CHILDREN(CHILD_URI_ID)
+GO
+
+CREATE TABLE dbo.LINKS (
+ URI_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ LINK_TO_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ --UNIQUE CLUSTERED (URI_ID, LINK_TO_ID)
+)
+GO
+
+CREATE INDEX XURI_ID
+ ON LINKS(URI_ID)
+GO
+
+
+CREATE INDEX XLINK_TO_ID
+ ON LINKS(LINK_TO_ID)
+GO
+
+CREATE TABLE dbo.LOCKS (
+ LOCK_ID id_type PRIMARY KEY,
+ OBJECT_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ SUBJECT_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ TYPE_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ EXPIRATION_DATE numeric(14, 0) NOT NULL,
+ IS_INHERITABLE bit NOT NULL,
+ IS_EXCLUSIVE bit NOT NULL,
+ CONSTRAINT FK_LOCKS_LOCK_ID
+ FOREIGN KEY (LOCK_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.BRANCH (
+ BRANCH_ID id_type IDENTITY UNIQUE NOT NULL,
+ BRANCH_STRING varchar(255) UNIQUE NOT NULL,
+ UNIQUE NONCLUSTERED (BRANCH_ID)
+)
+GO
+
+CREATE TABLE dbo.LABEL (
+ LABEL_ID id_type IDENTITY UNIQUE NOT NULL,
+ LABEL_STRING varchar(255) NOT NULL,
+ UNIQUE NONCLUSTERED (LABEL_ID)
+)
+GO
+
+CREATE TABLE dbo.VERSION (
+ URI_ID id_type PRIMARY KEY,
+ IS_VERSIONED bit NOT NULL,
+ CONSTRAINT FK_VERSION_URI_ID
+ FOREIGN KEY (URI_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.VERSION_HISTORY (
+ VERSION_ID id_type IDENTITY UNIQUE NOT NULL,
+ URI_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES VERSION (URI_ID),
+ BRANCH_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES BRANCH (BRANCH_ID),
+ REVISION_NO VARCHAR(20) NOT NULL,
+ --UNIQUE CLUSTERED (URI_ID, BRANCH_ID, REVISION_NO)
+)
+GO
+CREATE INDEX XVERSION_HISTORY1
+ ON VERSION_HISTORY(URI_ID, BRANCH_ID, REVISION_NO)
+GO
+
+CREATE TABLE dbo.VERSION_PREDS (
+ VERSION_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ PREDECESSOR_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ UNIQUE CLUSTERED (VERSION_ID, PREDECESSOR_ID)
+)
+GO
+CREATE INDEX XVERSION_PREDS1
+ ON VERSION_PREDS(VERSION_ID, PREDECESSOR_ID)
+GO
+
+CREATE TABLE dbo.VERSION_LABELS (
+ VERSION_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ LABEL_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES LABEL (LABEL_ID),
+ UNIQUE CLUSTERED (VERSION_ID, LABEL_ID)
+)
+GO
+
+CREATE TABLE dbo.VERSION_CONTENT (
+ VERSION_ID id_type PRIMARY KEY,
+ CONTENT image NOT NULL,
+ CONSTRAINT FK_VC_VERSION_ID
+ FOREIGN KEY (VERSION_ID)
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+)
+GO
+
+CREATE TABLE dbo.PROPERTIES (
+ VERSION_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ PROPERTY_NAMESPACE varchar(50) NOT NULL,
+ PROPERTY_NAME varchar(50) NOT NULL,
+ PROPERTY_VALUE varchar(255) NOT NULL,
+ PROPERTY_TYPE varchar(50) NOT NULL,
+ IS_PROTECTED bit NOT NULL,
+ UNIQUE CLUSTERED (VERSION_ID, PROPERTY_NAMESPACE, PROPERTY_NAME)
+)
+GO
+
+CREATE TABLE dbo.PERMISSIONS (
+ OBJECT_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ SUBJECT_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ ACTION_ID id_type NOT NULL FOREIGN KEY
+ REFERENCES URI (URI_ID),
+ VERSION_NO VARCHAR(20) NULL,
+ IS_INHERITABLE bit NOT NULL,
+ IS_NEGATIVE bit NOT NULL,
+ -- Both order and sequence would be more suitable, but can not be used
+ SUCCESSION int NOT NULL,
+ UNIQUE CLUSTERED (OBJECT_ID, SUBJECT_ID, ACTION_ID),
+ UNIQUE (OBJECT_ID, SUCCESSION)
+)
+GO
+
1.2 +275 -275
jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SybaseSchema.sql
Index: SybaseSchema.sql
===================================================================
RCS file:
/home/cvs/jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/SybaseSchema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- SybaseSchema.sql 25 Nov 2003 13:32:34 -0000 1.1
+++ SybaseSchema.sql 26 Nov 2003 16:19:46 -0000 1.2
@@ -1,275 +1,275 @@
-/**********************************************************************/
-/****** DROP SLIDE TABLES ******/
-/**********************************************************************/
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'OBJECT')
-DROP TABLE OBJECT
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'CHILDREN')
-DROP TABLE CHILDREN
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LINKS')
-DROP TABLE LINKS
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LOCKS')
-DROP TABLE LOCKS
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_CONTENT')
-DROP TABLE VERSION_CONTENT
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'PROPERTIES')
-DROP TABLE PROPERTIES
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'PERMISSIONS')
-DROP TABLE PERMISSIONS
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_PREDS')
-DROP TABLE VERSION_PREDS
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_LABELS')
-DROP TABLE VERSION_LABELS
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_HISTORY')
-DROP TABLE VERSION_HISTORY
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION')
-DROP TABLE VERSION
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'BRANCH')
-DROP TABLE BRANCH
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LABEL')
-DROP TABLE LABEL
-GO
-
-IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'URI')
-DROP TABLE URI
-GO
-
-/**********************************************************************/
-/****** DROP EXISTING USER DEFINED DATA TYPES ******/
-/**********************************************************************/
-
-sp_droptype id_type
-GO
-
-sp_droptype uri_str_type
-GO
-
-sp_droptype revision_no_type
-GO
-
-sp_droptype hash_type
-GO
-
-sp_droptype literal_str_type
-GO
-
-sp_droptype value_str_type
-GO
-
-
-/**********************************************************************/
-/****** ADD USER DEFINED DATA TYPES ******/
-/**********************************************************************/
-
-sp_addtype id_type, "numeric(18,0)"
-GO
-
-sp_addtype uri_str_type, "varchar(255)"
-GO
-
-sp_addtype revision_no_type, "varchar(20)"
-GO
-
-sp_addtype hash_type, "numeric(18,0)"
-GO
-
-sp_addtype value_str_type, "varchar(255)"
-GO
-
-/**********************************************************************/
-/****** CREATE SLIDE TABLES ******/
-/**********************************************************************/
-
-CREATE TABLE dbo.URI (
- URI_ID id_type IDENTITY UNIQUE NOT NULL,
- URI_STRING uri_str_type UNIQUE NOT NULL,
- -- UNIQUE NONCLUSTERED (URI_ID)
-)
-GO
-
-CREATE INDEX XUID
- ON URI(URI_ID)
-GO
-
-CREATE INDEX XUSTRING
- ON URI(URI_STRING)
-GO
-
-CREATE TABLE dbo.OBJECT (
- URI_ID id_type PRIMARY KEY,
- CLASS_NAME varchar(255) NOT NULL,
- CONSTRAINT FK_OBJECT_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.CHILDREN (
- URI_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- CHILD_URI_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- --UNIQUE CLUSTERED (URI_ID, CHILD_URI_ID)
-)
-GO
-
-CREATE INDEX XCHILDREN1
- ON CHILDREN(URI_ID)
-GO
-CREATE INDEX XCHILDREN2
- ON CHILDREN(CHILD_URI_ID)
-GO
-
-CREATE TABLE dbo.LINKS (
- URI_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- LINK_TO_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- --UNIQUE CLUSTERED (URI_ID, LINK_TO_ID)
-)
-GO
-
-CREATE INDEX XURI_ID
- ON LINKS(URI_ID)
-GO
-
-
-CREATE INDEX XLINK_TO_ID
- ON LINKS(LINK_TO_ID)
-GO
-
-CREATE TABLE dbo.LOCKS (
- LOCK_ID id_type PRIMARY KEY,
- OBJECT_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- SUBJECT_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- TYPE_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- EXPIRATION_DATE numeric(14, 0) NOT NULL,
- IS_INHERITABLE bit NOT NULL,
- IS_EXCLUSIVE bit NOT NULL,
- CONSTRAINT FK_LOCKS_LOCK_ID
- FOREIGN KEY (LOCK_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.BRANCH (
- BRANCH_ID id_type IDENTITY UNIQUE NOT NULL,
- BRANCH_STRING varchar(255) UNIQUE NOT NULL
-)
-GO
-
-CREATE TABLE dbo.LABEL (
- LABEL_ID id_type IDENTITY UNIQUE NOT NULL,
- LABEL_STRING varchar(255) NOT NULL
-)
-GO
-
-CREATE TABLE dbo.VERSION (
- URI_ID id_type PRIMARY KEY,
- IS_VERSIONED bit NOT NULL,
- CONSTRAINT FK_VERSION_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
-)
-GO
-
-CREATE TABLE dbo.VERSION_HISTORY (
- VERSION_ID id_type IDENTITY UNIQUE NOT NULL,
- URI_ID id_type NOT NULL
- REFERENCES VERSION (URI_ID),
- BRANCH_ID id_type NOT NULL
- REFERENCES BRANCH (BRANCH_ID),
- REVISION_NO VARCHAR(20) NOT NULL,
- --UNIQUE CLUSTERED (URI_ID, BRANCH_ID, REVISION_NO)
-)
-GO
-CREATE INDEX XVERSION_HISTORY1
- ON VERSION_HISTORY(URI_ID, BRANCH_ID, REVISION_NO)
-GO
-
-CREATE TABLE dbo.VERSION_PREDS (
- VERSION_ID id_type NOT NULL
- REFERENCES VERSION_HISTORY (VERSION_ID),
- PREDECESSOR_ID id_type NOT NULL
- REFERENCES VERSION_HISTORY (VERSION_ID),
- UNIQUE CLUSTERED (VERSION_ID, PREDECESSOR_ID)
-)
-GO
-CREATE INDEX XVERSION_PREDS1
- ON VERSION_PREDS(VERSION_ID, PREDECESSOR_ID)
-GO
-
-CREATE TABLE dbo.VERSION_LABELS (
- VERSION_ID id_type NOT NULL
- REFERENCES VERSION_HISTORY (VERSION_ID),
- LABEL_ID id_type NOT NULL
- REFERENCES LABEL (LABEL_ID),
- UNIQUE CLUSTERED (VERSION_ID, LABEL_ID)
-)
-GO
-
-CREATE TABLE dbo.VERSION_CONTENT (
- VERSION_ID id_type PRIMARY KEY,
- CONTENT image NOT NULL,
- CONSTRAINT FK_VC_VERSION_ID
- FOREIGN KEY (VERSION_ID)
- REFERENCES VERSION_HISTORY (VERSION_ID),
-)
-GO
-
-CREATE TABLE dbo.PROPERTIES (
- VERSION_ID id_type NOT NULL
- REFERENCES VERSION_HISTORY (VERSION_ID),
- PROPERTY_NAMESPACE varchar(50) NOT NULL,
- PROPERTY_NAME varchar(50) NOT NULL,
- PROPERTY_VALUE varchar(255) NOT NULL,
- PROPERTY_TYPE varchar(50) NOT NULL,
- IS_PROTECTED bit NOT NULL,
- UNIQUE CLUSTERED (VERSION_ID, PROPERTY_NAMESPACE, PROPERTY_NAME)
-)
-GO
-
-CREATE TABLE dbo.PERMISSIONS (
- OBJECT_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- SUBJECT_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- ACTION_ID id_type NOT NULL
- REFERENCES URI (URI_ID),
- VERSION_NO VARCHAR(20) NULL,
- IS_INHERITABLE bit NOT NULL,
- IS_NEGATIVE bit NOT NULL,
- -- Both order and sequence would be more suitable, but can not be used
- SUCCESSION int NOT NULL,
- UNIQUE CLUSTERED (OBJECT_ID, SUBJECT_ID, ACTION_ID),
- UNIQUE (OBJECT_ID, SUCCESSION)
-)
-GO
-
+/**********************************************************************/
+/****** DROP SLIDE TABLES ******/
+/**********************************************************************/
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'OBJECT')
+DROP TABLE OBJECT
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'CHILDREN')
+DROP TABLE CHILDREN
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LINKS')
+DROP TABLE LINKS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LOCKS')
+DROP TABLE LOCKS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_CONTENT')
+DROP TABLE VERSION_CONTENT
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'PROPERTIES')
+DROP TABLE PROPERTIES
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'PERMISSIONS')
+DROP TABLE PERMISSIONS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_PREDS')
+DROP TABLE VERSION_PREDS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_LABELS')
+DROP TABLE VERSION_LABELS
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION_HISTORY')
+DROP TABLE VERSION_HISTORY
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'VERSION')
+DROP TABLE VERSION
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'BRANCH')
+DROP TABLE BRANCH
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'LABEL')
+DROP TABLE LABEL
+GO
+
+IF EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'URI')
+DROP TABLE URI
+GO
+
+/**********************************************************************/
+/****** DROP EXISTING USER DEFINED DATA TYPES ******/
+/**********************************************************************/
+
+sp_droptype id_type
+GO
+
+sp_droptype uri_str_type
+GO
+
+sp_droptype revision_no_type
+GO
+
+sp_droptype hash_type
+GO
+
+sp_droptype literal_str_type
+GO
+
+sp_droptype value_str_type
+GO
+
+
+/**********************************************************************/
+/****** ADD USER DEFINED DATA TYPES ******/
+/**********************************************************************/
+
+sp_addtype id_type, "numeric(18,0)"
+GO
+
+sp_addtype uri_str_type, "varchar(255)"
+GO
+
+sp_addtype revision_no_type, "varchar(20)"
+GO
+
+sp_addtype hash_type, "numeric(18,0)"
+GO
+
+sp_addtype value_str_type, "varchar(255)"
+GO
+
+/**********************************************************************/
+/****** CREATE SLIDE TABLES ******/
+/**********************************************************************/
+
+CREATE TABLE dbo.URI (
+ URI_ID id_type IDENTITY UNIQUE NOT NULL,
+ URI_STRING uri_str_type UNIQUE NOT NULL,
+ -- UNIQUE NONCLUSTERED (URI_ID)
+)
+GO
+
+CREATE INDEX XUID
+ ON URI(URI_ID)
+GO
+
+CREATE INDEX XUSTRING
+ ON URI(URI_STRING)
+GO
+
+CREATE TABLE dbo.OBJECT (
+ URI_ID id_type PRIMARY KEY,
+ CLASS_NAME varchar(255) NOT NULL,
+ CONSTRAINT FK_OBJECT_URI_ID
+ FOREIGN KEY (URI_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.CHILDREN (
+ URI_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ CHILD_URI_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ --UNIQUE CLUSTERED (URI_ID, CHILD_URI_ID)
+)
+GO
+
+CREATE INDEX XCHILDREN1
+ ON CHILDREN(URI_ID)
+GO
+CREATE INDEX XCHILDREN2
+ ON CHILDREN(CHILD_URI_ID)
+GO
+
+CREATE TABLE dbo.LINKS (
+ URI_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ LINK_TO_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ --UNIQUE CLUSTERED (URI_ID, LINK_TO_ID)
+)
+GO
+
+CREATE INDEX XURI_ID
+ ON LINKS(URI_ID)
+GO
+
+
+CREATE INDEX XLINK_TO_ID
+ ON LINKS(LINK_TO_ID)
+GO
+
+CREATE TABLE dbo.LOCKS (
+ LOCK_ID id_type PRIMARY KEY,
+ OBJECT_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ SUBJECT_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ TYPE_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ EXPIRATION_DATE numeric(14, 0) NOT NULL,
+ IS_INHERITABLE bit NOT NULL,
+ IS_EXCLUSIVE bit NOT NULL,
+ CONSTRAINT FK_LOCKS_LOCK_ID
+ FOREIGN KEY (LOCK_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.BRANCH (
+ BRANCH_ID id_type IDENTITY UNIQUE NOT NULL,
+ BRANCH_STRING varchar(255) UNIQUE NOT NULL
+)
+GO
+
+CREATE TABLE dbo.LABEL (
+ LABEL_ID id_type IDENTITY UNIQUE NOT NULL,
+ LABEL_STRING varchar(255) NOT NULL
+)
+GO
+
+CREATE TABLE dbo.VERSION (
+ URI_ID id_type PRIMARY KEY,
+ IS_VERSIONED bit NOT NULL,
+ CONSTRAINT FK_VERSION_URI_ID
+ FOREIGN KEY (URI_ID)
+ REFERENCES URI (URI_ID)
+)
+GO
+
+CREATE TABLE dbo.VERSION_HISTORY (
+ VERSION_ID id_type IDENTITY UNIQUE NOT NULL,
+ URI_ID id_type NOT NULL
+ REFERENCES VERSION (URI_ID),
+ BRANCH_ID id_type NOT NULL
+ REFERENCES BRANCH (BRANCH_ID),
+ REVISION_NO VARCHAR(20) NOT NULL,
+ --UNIQUE CLUSTERED (URI_ID, BRANCH_ID, REVISION_NO)
+)
+GO
+CREATE INDEX XVERSION_HISTORY1
+ ON VERSION_HISTORY(URI_ID, BRANCH_ID, REVISION_NO)
+GO
+
+CREATE TABLE dbo.VERSION_PREDS (
+ VERSION_ID id_type NOT NULL
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ PREDECESSOR_ID id_type NOT NULL
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ UNIQUE CLUSTERED (VERSION_ID, PREDECESSOR_ID)
+)
+GO
+CREATE INDEX XVERSION_PREDS1
+ ON VERSION_PREDS(VERSION_ID, PREDECESSOR_ID)
+GO
+
+CREATE TABLE dbo.VERSION_LABELS (
+ VERSION_ID id_type NOT NULL
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ LABEL_ID id_type NOT NULL
+ REFERENCES LABEL (LABEL_ID),
+ UNIQUE CLUSTERED (VERSION_ID, LABEL_ID)
+)
+GO
+
+CREATE TABLE dbo.VERSION_CONTENT (
+ VERSION_ID id_type PRIMARY KEY,
+ CONTENT image NOT NULL,
+ CONSTRAINT FK_VC_VERSION_ID
+ FOREIGN KEY (VERSION_ID)
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+)
+GO
+
+CREATE TABLE dbo.PROPERTIES (
+ VERSION_ID id_type NOT NULL
+ REFERENCES VERSION_HISTORY (VERSION_ID),
+ PROPERTY_NAMESPACE varchar(50) NOT NULL,
+ PROPERTY_NAME varchar(50) NOT NULL,
+ PROPERTY_VALUE varchar(255) NOT NULL,
+ PROPERTY_TYPE varchar(50) NOT NULL,
+ IS_PROTECTED bit NOT NULL,
+ UNIQUE CLUSTERED (VERSION_ID, PROPERTY_NAMESPACE, PROPERTY_NAME)
+)
+GO
+
+CREATE TABLE dbo.PERMISSIONS (
+ OBJECT_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ SUBJECT_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ ACTION_ID id_type NOT NULL
+ REFERENCES URI (URI_ID),
+ VERSION_NO VARCHAR(20) NULL,
+ IS_INHERITABLE bit NOT NULL,
+ IS_NEGATIVE bit NOT NULL,
+ -- Both order and sequence would be more suitable, but can not be used
+ SUCCESSION int NOT NULL,
+ UNIQUE CLUSTERED (OBJECT_ID, SUBJECT_ID, ACTION_ID),
+ UNIQUE (OBJECT_ID, SUCCESSION)
+)
+GO
+
1.4 +208 -208
jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/MySqlSchema.sql
Index: MySqlSchema.sql
===================================================================
RCS file:
/home/cvs/jakarta-slide/proposals/stores/org/apache/slide/store/impl/rdbms/MySqlSchema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- MySqlSchema.sql 26 Nov 2003 15:18:10 -0000 1.3
+++ MySqlSchema.sql 26 Nov 2003 16:19:46 -0000 1.4
@@ -1,209 +1,209 @@
-# --------------------------------------------------------
-
-drop table if exists OBJECT;
-drop table if exists CHILDREN;
-drop table if exists LINKS;
-drop table if exists LOCKS;
-drop table if exists VERSION_CONTENT;
-drop table if exists PROPERTIES;
-drop table if exists PERMISSIONS;
-drop table if exists VERSION_PREDS;
-drop table if exists VERSION_LABELS;
-drop table if exists VERSION_HISTORY;
-drop table if exists VERSION;
-drop table if exists BRANCH;
-drop table if exists LABEL;
-drop table if exists URI;
-
-# --------------------------------------------------------
-
-CREATE TABLE URI (
- URI_ID bigint NOT NULL auto_increment,
- URI_STRING varchar(255) NOT NULL,
- PRIMARY KEY (URI_ID),
- KEY URI_IX2 (URI_STRING)
-) TYPE=InnoDB;
-
-# --------------------------------------------------------
-
-CREATE TABLE OBJECT (
- URI_ID bigint NOT NULL,
- CLASS_NAME varchar(255) NOT NULL,
- PRIMARY KEY (URI_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID)
-REFERENCES URI (URI_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE CHILDREN (
- URI_ID bigint NOT NULL,
- CHILD_URI_ID bigint NOT NULL,
- PRIMARY KEY (URI_ID,CHILD_URI_ID),
- key CHILD_IX2 (CHILD_URI_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE CHILDREN ADD CONSTRAINT CHILDREN_FK1 FOREIGN KEY
-CHILDREN_FK1(URI_ID) REFERENCES URI (URI_ID);
-ALTER TABLE CHILDREN ADD CONSTRAINT CHILDREN_FK2 FOREIGN KEY
-CHILDREN_FK2(CHILD_URI_ID) REFERENCES URI (URI_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE LINKS (
- URI_ID bigint NOT NULL,
- LINK_TO_ID bigint NOT NULL,
- PRIMARY KEY (URI_ID,LINK_TO_ID),
- key LINK_IX2 (LINK_TO_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID)
-REFERENCES URI (URI_ID);
-ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID)
-REFERENCES URI (URI_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE LOCKS (
- LOCK_ID bigint NOT NULL,
- OBJECT_ID bigint NOT NULL,
- SUBJECT_ID bigint NOT NULL,
- TYPE_ID bigint NOT NULL,
- EXPIRATION_DATE bigint NOT NULL,
- IS_INHERITABLE tinyint(1) NOT NULL,
- IS_EXCLUSIVE tinyint(1) NOT NULL,
- PRIMARY KEY (LOCK_ID),
- KEY LOCK_IX2 (OBJECT_ID),
- KEY LOCK_IX3 (SUBJECT_ID),
- KEY LOCK_IX4 (TYPE_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID)
-REFERENCES URI (URI_ID);
-ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID)
-REFERENCES URI (URI_ID);
-ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID)
-REFERENCES URI (URI_ID);
-ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID)
-REFERENCES URI (URI_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE BRANCH (
- BRANCH_ID bigint NOT NULL auto_increment,
- BRANCH_STRING varchar(255) NOT NULL,
- PRIMARY KEY (BRANCH_ID)
-) TYPE=InnoDB;
-
-# --------------------------------------------------------
-
-CREATE TABLE LABEL (
- LABEL_ID bigint NOT NULL auto_increment,
- LABEL_STRING varchar(255) NOT NULL,
- PRIMARY KEY (LABEL_ID)
-) TYPE=InnoDB;
-
-# --------------------------------------------------------
-
-CREATE TABLE VERSION (
- URI_ID bigint NOT NULL,
- IS_VERSIONED tinyint(1) NOT NULL,
- PRIMARY KEY (URI_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
-VERSION_FK1(URI_ID) REFERENCES URI (URI_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE VERSION_HISTORY (
- VERSION_ID bigint NOT NULL auto_increment,
- URI_ID bigint NOT NULL,
- BRANCH_ID bigint NOT NULL,
- REVISION_NO varchar(20) NOT NULL,
- PRIMARY KEY (VERSION_ID),
- UNIQUE KEY URI_ID (BRANCH_ID,URI_ID,REVISION_NO),
- KEY URI_ID_IX3 (URI_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY
-VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID);
-ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY
-VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE VERSION_PREDS (
- VERSION_ID bigint NOT NULL,
- PREDECESSOR_ID bigint NOT NULL,
- PRIMARY KEY (VERSION_ID,PREDECESSOR_ID),
- KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
-VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
-ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
-VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE VERSION_LABELS (
- VERSION_ID bigint NOT NULL,
- LABEL_ID bigint NOT NULL,
- PRIMARY KEY (VERSION_ID,LABEL_ID),
- KEY LABEL_ID_IX2 (LABEL_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
-VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
-ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
-VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE VERSION_CONTENT (
- VERSION_ID bigint NOT NULL,
- CONTENT blob NOT NULL,
- PRIMARY KEY (VERSION_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
-VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE PROPERTIES (
- VERSION_ID bigint NOT NULL,
- PROPERTY_NAMESPACE varchar(50) NOT NULL,
- PROPERTY_NAME varchar(50) NOT NULL,
- PROPERTY_VALUE varchar(255) NOT NULL,
- PROPERTY_TYPE varchar(50) NOT NULL,
- IS_PROTECTED tinyint(1) NOT NULL,
- PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME)
-) TYPE=InnoDB;
-
-ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY
-PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
-
-# --------------------------------------------------------
-
-CREATE TABLE PERMISSIONS (
- OBJECT_ID bigint NOT NULL,
- SUBJECT_ID bigint NOT NULL,
- ACTION_ID bigint NOT NULL,
- VERSION_NO varchar(20),
- IS_INHERITABLE tinyint(1) NOT NULL,
- IS_NEGATIVE tinyint(1) NOT NULL,
- SUCCESSION int NOT NULL,
- PRIMARY KEY (SUBJECT_ID,OBJECT_ID,ACTION_ID),
- UNIQUE KEY OBJECT_ID_2 (OBJECT_ID,SUCCESSION),
- KEY ACTION_ID_IX3 (ACTION_ID)
-) TYPE=InnoDB;
-
-ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY
-PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID);
-ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY
-PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID);
-ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY
+# --------------------------------------------------------
+
+drop table if exists OBJECT;
+drop table if exists CHILDREN;
+drop table if exists LINKS;
+drop table if exists LOCKS;
+drop table if exists VERSION_CONTENT;
+drop table if exists PROPERTIES;
+drop table if exists PERMISSIONS;
+drop table if exists VERSION_PREDS;
+drop table if exists VERSION_LABELS;
+drop table if exists VERSION_HISTORY;
+drop table if exists VERSION;
+drop table if exists BRANCH;
+drop table if exists LABEL;
+drop table if exists URI;
+
+# --------------------------------------------------------
+
+CREATE TABLE URI (
+ URI_ID bigint NOT NULL auto_increment,
+ URI_STRING varchar(255) NOT NULL,
+ PRIMARY KEY (URI_ID),
+ KEY URI_IX2 (URI_STRING)
+) TYPE=InnoDB;
+
+# --------------------------------------------------------
+
+CREATE TABLE OBJECT (
+ URI_ID bigint NOT NULL,
+ CLASS_NAME varchar(255) NOT NULL,
+ PRIMARY KEY (URI_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID)
+REFERENCES URI (URI_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE CHILDREN (
+ URI_ID bigint NOT NULL,
+ CHILD_URI_ID bigint NOT NULL,
+ PRIMARY KEY (URI_ID,CHILD_URI_ID),
+ key CHILD_IX2 (CHILD_URI_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE CHILDREN ADD CONSTRAINT CHILDREN_FK1 FOREIGN KEY
+CHILDREN_FK1(URI_ID) REFERENCES URI (URI_ID);
+ALTER TABLE CHILDREN ADD CONSTRAINT CHILDREN_FK2 FOREIGN KEY
+CHILDREN_FK2(CHILD_URI_ID) REFERENCES URI (URI_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE LINKS (
+ URI_ID bigint NOT NULL,
+ LINK_TO_ID bigint NOT NULL,
+ PRIMARY KEY (URI_ID,LINK_TO_ID),
+ key LINK_IX2 (LINK_TO_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID)
+REFERENCES URI (URI_ID);
+ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID)
+REFERENCES URI (URI_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE LOCKS (
+ LOCK_ID bigint NOT NULL,
+ OBJECT_ID bigint NOT NULL,
+ SUBJECT_ID bigint NOT NULL,
+ TYPE_ID bigint NOT NULL,
+ EXPIRATION_DATE bigint NOT NULL,
+ IS_INHERITABLE tinyint(1) NOT NULL,
+ IS_EXCLUSIVE tinyint(1) NOT NULL,
+ PRIMARY KEY (LOCK_ID),
+ KEY LOCK_IX2 (OBJECT_ID),
+ KEY LOCK_IX3 (SUBJECT_ID),
+ KEY LOCK_IX4 (TYPE_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID)
+REFERENCES URI (URI_ID);
+ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID)
+REFERENCES URI (URI_ID);
+ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID)
+REFERENCES URI (URI_ID);
+ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID)
+REFERENCES URI (URI_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE BRANCH (
+ BRANCH_ID bigint NOT NULL auto_increment,
+ BRANCH_STRING varchar(255) NOT NULL,
+ PRIMARY KEY (BRANCH_ID)
+) TYPE=InnoDB;
+
+# --------------------------------------------------------
+
+CREATE TABLE LABEL (
+ LABEL_ID bigint NOT NULL auto_increment,
+ LABEL_STRING varchar(255) NOT NULL,
+ PRIMARY KEY (LABEL_ID)
+) TYPE=InnoDB;
+
+# --------------------------------------------------------
+
+CREATE TABLE VERSION (
+ URI_ID bigint NOT NULL,
+ IS_VERSIONED tinyint(1) NOT NULL,
+ PRIMARY KEY (URI_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
+VERSION_FK1(URI_ID) REFERENCES URI (URI_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE VERSION_HISTORY (
+ VERSION_ID bigint NOT NULL auto_increment,
+ URI_ID bigint NOT NULL,
+ BRANCH_ID bigint NOT NULL,
+ REVISION_NO varchar(20) NOT NULL,
+ PRIMARY KEY (VERSION_ID),
+ UNIQUE KEY URI_ID (BRANCH_ID,URI_ID,REVISION_NO),
+ KEY URI_ID_IX3 (URI_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY
+VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID);
+ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY
+VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE VERSION_PREDS (
+ VERSION_ID bigint NOT NULL,
+ PREDECESSOR_ID bigint NOT NULL,
+ PRIMARY KEY (VERSION_ID,PREDECESSOR_ID),
+ KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
+VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
+ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
+VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE VERSION_LABELS (
+ VERSION_ID bigint NOT NULL,
+ LABEL_ID bigint NOT NULL,
+ PRIMARY KEY (VERSION_ID,LABEL_ID),
+ KEY LABEL_ID_IX2 (LABEL_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
+VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
+ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
+VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE VERSION_CONTENT (
+ VERSION_ID bigint NOT NULL,
+ CONTENT blob NOT NULL,
+ PRIMARY KEY (VERSION_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
+VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE PROPERTIES (
+ VERSION_ID bigint NOT NULL,
+ PROPERTY_NAMESPACE varchar(50) NOT NULL,
+ PROPERTY_NAME varchar(50) NOT NULL,
+ PROPERTY_VALUE varchar(255) NOT NULL,
+ PROPERTY_TYPE varchar(50) NOT NULL,
+ IS_PROTECTED tinyint(1) NOT NULL,
+ PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME)
+) TYPE=InnoDB;
+
+ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY
+PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
+
+# --------------------------------------------------------
+
+CREATE TABLE PERMISSIONS (
+ OBJECT_ID bigint NOT NULL,
+ SUBJECT_ID bigint NOT NULL,
+ ACTION_ID bigint NOT NULL,
+ VERSION_NO varchar(20),
+ IS_INHERITABLE tinyint(1) NOT NULL,
+ IS_NEGATIVE tinyint(1) NOT NULL,
+ SUCCESSION int NOT NULL,
+ PRIMARY KEY (SUBJECT_ID,OBJECT_ID,ACTION_ID),
+ UNIQUE KEY OBJECT_ID_2 (OBJECT_ID,SUCCESSION),
+ KEY ACTION_ID_IX3 (ACTION_ID)
+) TYPE=InnoDB;
+
+ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY
+PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID);
+ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY
+PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID);
+ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY
PERMISSIONS_FK3(ACTION_ID) REFERENCES URI (URI_ID);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
