From e42e714015849821a4a22d20a17d3a6e124ccf04 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 6 Feb 2008 06:24:56 +0000 Subject: [PATCH] use serial instead of plain INT for pkey on circ_mod_test table git-svn-id: svn://svn.open-ils.org/ILS/trunk@8656 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/100.circ_matrix.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/100.circ_matrix.sql b/Open-ILS/src/sql/Pg/100.circ_matrix.sql index b07aceb39e..6e7f0883c6 100644 --- a/Open-ILS/src/sql/Pg/100.circ_matrix.sql +++ b/Open-ILS/src/sql/Pg/100.circ_matrix.sql @@ -120,10 +120,10 @@ CREATE TABLE config.circ_matrix_test ( -- Tests for max items out by circ_modifier CREATE TABLE config.circ_matrix_circ_mod_test ( - id INT PRIMARY KEY, + id SERIAL PRIMARY KEY, matchpoint INT NOT NULL REFERENCES config.circ_matrix_matchpoint (id) ON DELETE CASCADE, items_out INT NOT NULL, -- Total current active circulations must be less than this, NULL means skip (always pass) - circ_mod TEXT NOT NULL REFERENCES config.circ_modifier (code) ON DELETE CASCADE ON UPDATE CASCADE -- circ_modifier type that the max out applies to + circ_mod TEXT NOT NULL REFERENCES config.circ_modifier (code) ON DELETE CASCADE ON UPDATE CASCADE -- circ_modifier type that the max out applies to ); -- 2.43.2