From 694e5f12d91e4052dd9a1dc729c1c77b0d88f8ee Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 2 Aug 2010 17:17:55 +0000 Subject: [PATCH] create correct primary key constraints for some view-based / inheritted tables git-svn-id: svn://svn.open-ils.org/ILS/trunk@17062 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/015.schema.staging.sql | 2 ++ Open-ILS/src/sql/Pg/080.schema.money.sql | 3 ++- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 +- .../0356.schema.missing-pkey-constraints.sql | 14 ++++++++++++++ 5 files changed, 20 insertions(+), 3 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0356.schema.missing-pkey-constraints.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ec7dbf0149..17839a59a1 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,7 +68,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0355'); -- phasefx +INSERT INTO config.upgrade_log (version) VALUES ('0356'); -- miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/015.schema.staging.sql b/Open-ILS/src/sql/Pg/015.schema.staging.sql index 7543a772f0..f85b56d93b 100644 --- a/Open-ILS/src/sql/Pg/015.schema.staging.sql +++ b/Open-ILS/src/sql/Pg/015.schema.staging.sql @@ -47,6 +47,8 @@ CREATE TABLE staging.billing_address_stage ( LIKE staging.mailing_address_stage INCLUDING DEFAULTS ); +ALTER TABLE staging.billing_address_stage ADD CONSTRAINT PRIMARY KEY (row_id); + CREATE TABLE staging.statcat_stage ( row_id BIGSERIAL PRIMARY KEY, row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(), diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index f54c46c554..9dcf8ef787 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -259,7 +259,8 @@ CREATE TABLE money.materialized_billable_xact_summary AS CREATE OR REPLACE VIEW money.billable_xact_summary AS SELECT * FROM money.materialized_billable_xact_summary; -CREATE INDEX money_mat_summary_id_idx ON money.materialized_billable_xact_summary (id); +ALTER TABLE money.materialized_billable_xact_summary ADD CONSTRAINT PRIMARY KEY (id); + CREATE INDEX money_mat_summary_usr_idx ON money.materialized_billable_xact_summary (usr); CREATE INDEX money_mat_summary_xact_start_idx ON money.materialized_billable_xact_summary (xact_start); diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 34abbc5689..0b892e178d 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -759,7 +759,7 @@ CREATE TABLE acq.edi_account ( -- similar tables can extend remote_account ) INHERITS (config.remote_account); -- We need a UNIQUE constraint here also, to support the FK from acq.provider.edi_default -ALTER TABLE acq.edi_account ADD CONSTRAINT acq_edi_account_id_unique UNIQUE (id); +ALTER TABLE acq.edi_account ADD CONSTRAINT PRIMARY KEY (id); CREATE TABLE acq.edi_message ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0356.schema.missing-pkey-constraints.sql b/Open-ILS/src/sql/Pg/upgrade/0356.schema.missing-pkey-constraints.sql new file mode 100644 index 0000000000..e1e53ca187 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0356.schema.missing-pkey-constraints.sql @@ -0,0 +1,14 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0356'); -- miker + +ALTER TABLE acq.edi_account DROP CONSTRAINT acq_edi_account_id_unique; +ALTER TABLE acq.edi_account ADD CONSTRAINT PRIMARY KEY (id); + +DROP INDEX money.money_mat_summary_id_idx; +ALTER TABLE money.materialized_billable_xact_summary ADD CONSTRAINT PRIMARY KEY (id); + +ALTER TABLE staging.billing_address_stage ADD CONSTRAINT PRIMARY KEY (row_id); + +COMMIT; + -- 2.43.2