1 DROP SCHEMA biblio CASCADE;
6 CREATE SEQUENCE biblio.autogen_tcn_value_seq;
7 CREATE FUNCTION biblio.next_autogen_tcn_value () RETURNS TEXT AS $$
8 BEGIN RETURN nextval('biblio.autogen_tcn_value_seq'::TEXT); END;
11 CREATE TABLE biblio.record_entry (
12 id BIGSERIAL PRIMARY KEY,
13 tcn_source TEXT NOT NULL DEFAULT 'AUTOGEN',
14 tcn_value TEXT NOT NULL DEFAULT biblio.next_autogen_tcn_value(),
15 creator INT NOT NULL DEFAULT 1,
16 editor INT NOT NULL DEFAULT 1,
17 create_date TIMESTAMP NOT NULL DEFAULT now(),
18 edit_date TIMESTAMP NOT NULL DEFAULT now(),
19 active BOOL NOT NULL DEFAULT TRUE,
20 deleted BOOL NOT NULL DEFAULT FALSE,
22 last_xact_id TEXT NOT NULL DEFAULT 'none',
23 CONSTRAINT unique_tcn UNIQUE (tcn_source,tcn_value)
26 CREATE TABLE biblio.record_data (
27 id BIGSERIAL PRIMARY KEY,
28 owner_doc BIGINT NOT NULL,
29 intra_doc_id INT NOT NULL,
31 node_type INT NOT NULL,
35 last_xact_id TEXT NOT NULL DEFAULT 'none',
36 CONSTRAINT unique_doc_and_id UNIQUE (owner_doc,intra_doc_id)
39 CREATE TABLE biblio.record_note (
40 id BIGSERIAL PRIMARY KEY,
41 record BIGINT NOT NULL,
43 creator INT NOT NULL DEFAULT 1,
44 editor INT NOT NULL DEFAULT 1,
45 create_date TIMESTAMP NOT NULL DEFAULT now(),
46 edit_date TIMESTAMP NOT NULL DEFAULT now()