From cbd35b21d19b32f728853b45a7729c77a01780f9 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 8 Jul 2006 19:27:55 +0000 Subject: [PATCH] bug fixes for the schema git-svn-id: svn://svn.open-ils.org/ILS/trunk@4945 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 3 ++- Open-ILS/src/sql/Pg/080.schema.money.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index c3c4919384..f7ac53fa88 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -104,7 +104,8 @@ CREATE TABLE config.metabib_field ( field_class TEXT NOT NULL CHECK (lower(field_class) IN ('title','author','subject','keyword','series')), name TEXT NOT NULL UNIQUE, xpath TEXT NOT NULL, - weight INT NOT NULL DEFUALT 1, + weight INT NOT NULL DEFAULT 1, + format TEXT NOT NULL DEFAULT 'mods' ); COMMENT ON TABLE config.metabib_field IS $$ /* diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index d11432ab56..e7bf053e09 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -11,6 +11,7 @@ CREATE TABLE money.collections_tracker ( location INT NOT NULL REFERENCES actor.org_unit (id), enter_time TIMESTAMP WITH TIME ZONE ); +CREATE UNIQUE INDEX m_c_t_usr_collector_location_once_idx ON money.collections_tracker (usr, collector, location); CREATE TABLE money.billable_xact ( id BIGSERIAL PRIMARY KEY, @@ -18,7 +19,7 @@ CREATE TABLE money.billable_xact ( xact_start TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), xact_finish TIMESTAMP WITH TIME ZONE ); -CREATE INDEX m_b_x_open_xacts_idx ON money.billable_xact (usr) WHERE xact_finish IS NULL; +CREATE INDEX m_b_x_open_xacts_idx ON money.billable_xact (usr); CREATE TABLE money.grocery ( -- Catchall table for local billing billing_location INT NOT NULL, -- library creating transaction -- 2.11.0