Navigation

012.schema.vandelay.sql

Timestamp:

05/14/08 12:57:04 (5 months ago)

Author:

miker

Message:

moving purpose to record instead of queue

Files:

r9542	r9600
11	11	complete BOOL NOT NULL DEFAULT FALSE,
12	12	queue_type TEXT NOT NULL DEFAULT 'bib' CHECK (queue_type IN ('bib','authority')),
13		~~queue_purpose TEXT NOT NULL DEFAULT 'import' CHECK (queue_purpose IN ('import','overlay')),~~
14	13	CONSTRAINT vand_queue_name_once_per_owner_const UNIQUE (owner,name,queue_type)
15	14	);
16	15
17	16	CREATE TABLE vandelay.queued_record (
18		id BIGSERIAL PRIMARY KEY,
19		create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
20		import_time TIMESTAMP WITH TIME ZONE,
21		marc TEXT NOT NULL
	17	id BIGSERIAL PRIMARY KEY,
	18	create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
	19	import_time TIMESTAMP WITH TIME ZONE,
	20	purpose TEXT NOT NULL DEFAULT 'import' CHECK (queue_purpose IN ('import','overlay')),
	21	marc TEXT NOT NULL
22	22	);
23	23
…	…
58	58
59	59	CREATE TABLE vandelay.queued_bib_record (
60		queue INT NOT NULL REFERENCES vandelay.bib_queue (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
61		bib_source INT REFERENCES config.bib_source (id) DEFERRABLE INITIALLY DEFERRED,
62		imported_as INT REFERENCES biblio.record_entry (id) DEFERRABLE INITIALLY DEFERRED
	60	queue INT NOT NULL REFERENCES vandelay.bib_queue (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
	61	bib_source INT REFERENCES config.bib_source (id) DEFERRABLE INITIALLY DEFERRED,
	62	imported_as INT REFERENCES biblio.record_entry (id) DEFERRABLE INITIALLY DEFERRED
63	63	) INHERITS (vandelay.queued_record);
64	64	ALTER TABLE vandelay.queued_bib_record ADD PRIMARY KEY (id);