hsqldb.sakai_content.sql Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of sakai-kernel-impl Show documentation
There is a newer version: 23.3
-----------------------------------------------------------------------------
-- CONTENT_COLLECTION
-----------------------------------------------------------------------------

CREATE TABLE CONTENT_COLLECTION
(
    COLLECTION_ID VARCHAR (255) NOT NULL,
	IN_COLLECTION VARCHAR (255),
    XML LONGVARCHAR,
    BINARY_ENTITY VARBINARY,
    CONSTRAINT CONTENT_COLLECTION_INDEX UNIQUE (COLLECTION_ID)
 );

CREATE INDEX CONTENT_IN_COLLECTION_INDEX ON CONTENT_COLLECTION
(
	IN_COLLECTION
);

INSERT INTO CONTENT_COLLECTION VALUES ('/','',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/group/','/',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/public/','/',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/attachment/','/',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/private/','/',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/user/','/',
'

	
		
		
		
		
		
		
	

',NULL);

INSERT INTO CONTENT_COLLECTION VALUES ('/group-user/','/',
'
	
		
			
			
			
			
			
			
		
	
',NULL);

-----------------------------------------------------------------------------
-- CONTENT_RESOURCE
-----------------------------------------------------------------------------

CREATE TABLE CONTENT_RESOURCE
(
    RESOURCE_ID VARCHAR (255) NOT NULL,
    RESOURCE_UUID VARCHAR (36),
	IN_COLLECTION VARCHAR (255),
	CONTEXT VARCHAR (99),
	FILE_PATH VARCHAR (128),
	FILE_SIZE BIGINT,
	RESOURCE_TYPE_ID VARCHAR (255),
    XML LONGVARCHAR,
    BINARY_ENTITY VARBINARY,
    CONSTRAINT CONTENT_RESOURCE_INDEX UNIQUE (RESOURCE_ID)
-- for BINARY body, add BODY BINARY -- and drop the content_resource_body_binary tables -ggolden
);

CREATE INDEX CONTENT_IN_RESOURCE_INDEX ON CONTENT_RESOURCE
(
	IN_COLLECTION
);

CREATE INDEX CONTENT_UUID_RESOURCE_INDEX ON CONTENT_RESOURCE
(
	RESOURCE_UUID
);

CREATE INDEX CONTENT_RESOURCE_CONTEXT_INDEX ON CONTENT_RESOURCE
(
	CONTEXT
);

-----------------------------------------------------------------------------
-- CONTENT_RESOURCE_BODY_BINARY
-----------------------------------------------------------------------------

CREATE TABLE CONTENT_RESOURCE_BODY_BINARY
(
    RESOURCE_ID VARCHAR (255) NOT NULL,
    BODY BINARY,
    CONSTRAINT CONTENT_RESOURCE_BB_INDEX UNIQUE (RESOURCE_ID)
);

-----------------------------------------------------------------------------
-- CONTENT_DROPBOX_CHANGES
-----------------------------------------------------------------------------

CREATE TABLE CONTENT_DROPBOX_CHANGES
(
    DROPBOX_ID VARCHAR (255) NOT NULL,
    IN_COLLECTION VARCHAR (255),
    LAST_UPDATE VARCHAR (24)
);

CREATE UNIQUE INDEX CONTENT_DROPBOX_CHANGES_INDEX ON CONTENT_DROPBOX_CHANGES
(
	DROPBOX_ID
);

CREATE INDEX CONTENT_DROPBOX_INCOLL_INDEX ON CONTENT_DROPBOX_CHANGES
(
	IN_COLLECTION
);