From 971e96137cdb6728c16baf53909355f6fbae20e3 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 4 May 2005 03:11:47 +0000 Subject: [PATCH] fixing field assumptions git-svn-id: svn://svn.open-ils.org/ILS/trunk@629 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/002.schema.config.sql | 3 +++ Open-ILS/src/sql/Postgres/090.schema.action.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Postgres/002.schema.config.sql b/Open-ILS/src/sql/Postgres/002.schema.config.sql index 0495ec5a23..b05658cd12 100644 --- a/Open-ILS/src/sql/Postgres/002.schema.config.sql +++ b/Open-ILS/src/sql/Postgres/002.schema.config.sql @@ -104,6 +104,9 @@ INSERT INTO config.copy_status (name) VALUES ('Cataloging'); INSERT INTO config.copy_status (name) VALUES ('Reserves'); INSERT INTO config.copy_status (name) VALUES ('Discard/Weed'); +SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100); + + CREATE TABLE config.net_access_level ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE diff --git a/Open-ILS/src/sql/Postgres/090.schema.action.sql b/Open-ILS/src/sql/Postgres/090.schema.action.sql index c7f76d79fc..8618edc6d4 100644 --- a/Open-ILS/src/sql/Postgres/090.schema.action.sql +++ b/Open-ILS/src/sql/Postgres/090.schema.action.sql @@ -32,7 +32,7 @@ CREATE TABLE action.survey_answer ( CREATE TABLE action.survey_response ( id BIGSERIAL PRIMARY KEY, - usr INT NOT NULL, -- REFERENCES actor.usr + usr INT, -- REFERENCES actor.usr survey INT NOT NULL REFERENCES action.survey, question INT NOT NULL REFERENCES action.survey_question, answer INT NOT NULL REFERENCES action.survey_answer, -- 2.43.2