From 592141360e0af9df0bd0b29ad9affdc4a3691210 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 9 Mar 2005 19:06:00 +0000 Subject: [PATCH] updating SQL to have audit xact ids git-svn-id: svn://svn.open-ils.org/ILS/trunk@294 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/005.schema.actors.sql | 4 +++- Open-ILS/src/sql/Postgres/010.schema.biblio.sql | 2 ++ Open-ILS/src/sql/Postgres/810.fkeys.biblio.sql | 4 ++-- 3 files changed, 7 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Postgres/005.schema.actors.sql b/Open-ILS/src/sql/Postgres/005.schema.actors.sql index cbfaa4fa07..82c0aa465e 100644 --- a/Open-ILS/src/sql/Postgres/005.schema.actors.sql +++ b/Open-ILS/src/sql/Postgres/005.schema.actors.sql @@ -21,7 +21,9 @@ CREATE TABLE actor.usr ( active BOOL NOT NULL DEFAULT TRUE, master_account BOOL NOT NULL DEFAULT FALSE, super_user BOOL NOT NULL DEFAULT FALSE, - usrgoup SERIAL NOT NULL + usrgoup SERIAL NOT NULL, + last_xact_id TEXT NOT NULL DEFAULT 'none' + ); CREATE FUNCTION actor.crypt_pw_insert () RETURNS TRIGGER AS $$ diff --git a/Open-ILS/src/sql/Postgres/010.schema.biblio.sql b/Open-ILS/src/sql/Postgres/010.schema.biblio.sql index 87243c8906..9fc6eb061c 100644 --- a/Open-ILS/src/sql/Postgres/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Postgres/010.schema.biblio.sql @@ -19,6 +19,7 @@ CREATE TABLE biblio.record_entry ( active BOOL NOT NULL DEFAULT TRUE, deleted BOOL NOT NULL DEFAULT FALSE, source INT, + last_xact_id TEXT NOT NULL DEFAULT 'none', CONSTRAINT unique_tcn UNIQUE (tcn_source,tcn_value) ); @@ -31,6 +32,7 @@ CREATE TABLE biblio.record_data ( namespace_uri TEXT, name TEXT, value TEXT, + last_xact_id TEXT NOT NULL DEFAULT 'none', CONSTRAINT unique_doc_and_id UNIQUE (owner_doc,intra_doc_id) ); diff --git a/Open-ILS/src/sql/Postgres/810.fkeys.biblio.sql b/Open-ILS/src/sql/Postgres/810.fkeys.biblio.sql index 4097b96606..5ae2b33ef1 100644 --- a/Open-ILS/src/sql/Postgres/810.fkeys.biblio.sql +++ b/Open-ILS/src/sql/Postgres/810.fkeys.biblio.sql @@ -5,8 +5,8 @@ ALTER TABLE biblio.record_entry ADD CONSTRAINT record_entry_editor_fkey FOREIGN ALTER TABLE biblio.record_entry ADD CONSTRAINT record_entry_source_fkey FOREIGN KEY ( source ) REFERENCES config.bib_source (id) ON DELETE RESTRICT; ALTER TABLE biblio.record_data ADD CONSTRAINT record_data_owner_doc_fkey FOREIGN KEY ( owner_doc ) REFERENCES biblio.record_entry (id) ON DELETE RESTRICT; -ALTER TABLE biblio.record_data ADD CONSTRAINT record_data_parent_node_fkey FOREIGN KEY ( owner_doc,parent_node ) - REFERENCES biblio.record_data (owner_doc, intra_doc_id) ON DELETE CASCADE; +--ALTER TABLE biblio.record_data ADD CONSTRAINT record_data_parent_node_fkey FOREIGN KEY ( owner_doc,parent_node ) +-- REFERENCES biblio.record_data (owner_doc, intra_doc_id) ON DELETE CASCADE; ALTER TABLE biblio.record_note ADD CONSTRAINT record_note_record_fkey FOREIGN KEY ( record ) REFERENCES biblio.record_entry (id) ON DELETE RESTRICT; -- 2.43.2