-- Copyright 2005 The Apache Software Foundation

-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at

-- -- http://www.apache.org/licenses/LICENSE-2.0

-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

-- bricks-cms database schema, for the derby embedded database server.
-- Might need some changes to work with other databases.
-- Used by the "derby:create" build target to create the database.

-- This is needed to store the OJB HighLowSequence object state
CREATE TABLE OJB_HL_SEQ
(
    TABLENAME varchar (175) NOT NULL,
    FIELDNAME varchar (70) NOT NULL,
    MAX_KEY integer,
    GRAB_SIZE integer,
    VERSION integer,
    PRIMARY KEY (TABLENAME,FIELDNAME)
);

-- Store our documents
-- To insert a test document use:
--  insert into document values(1,1,'First document','Content of document 1',timestamp('2005-01-01 00:00:00'),timestamp('2005-01-01 00:00:00'));
--
CREATE TABLE document (
    doc_id INTEGER NOT NULL,
    ojb_version INTEGER NOT NULL,
	title CHAR(120),
	content LONG VARCHAR,
	ts_created TIMESTAMP,
	ts_modified TIMESTAMP,

	primary key(doc_id)
);