From e548ce09fd7e95c519a90302deb2791255fc3180 Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 16 Dec 2007 21:18:56 +0000 Subject: [PATCH] nail down the IDs of statuses git-svn-id: svn://svn.open-ils.org/ILS/trunk@8228 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 30 ++++++++++---------- 1 file changed, 15 insertions(+), 15 deletions(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 3406dfa71b..b43a7cee59 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -64,25 +64,25 @@ INSERT INTO config.rule_recuring_fine VALUES INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, oils_i18n_gettext('3month'), '3 months', 0); INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, oils_i18n_gettext('6month'), '6 months', 2); -INSERT INTO config.copy_status (id,name,holdable) VALUES (0,oils_i18n_gettext('Available'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (0,oils_i18n_gettext('Available'),'t'); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('Checked out'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (1,oils_i18n_gettext('Checked out'),'t'); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Bindery')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Lost')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Missing')); +INSERT INTO config.copy_status (id,name) VALUES (2,oils_i18n_gettext('Bindery')); +INSERT INTO config.copy_status (id,name) VALUES (3,oils_i18n_gettext('Lost')); +INSERT INTO config.copy_status (id,name) VALUES (4,oils_i18n_gettext('Missing')); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('In process'),'t'); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('In transit'),'t'); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('Reshelving'),'t'); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('On holds shelf'),'t'); -INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('On order'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (5,oils_i18n_gettext('In process'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (6,oils_i18n_gettext('In transit'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (7,oils_i18n_gettext('Reshelving'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (8,oils_i18n_gettext('On holds shelf'),'t'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (9,oils_i18n_gettext('On order'),'t'); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('ILL')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Cataloging')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Reserves')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Discard/Weed')); -INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Damaged')); +INSERT INTO config.copy_status (id,name) VALUES (10,oils_i18n_gettext('ILL')); +INSERT INTO config.copy_status (id,name) VALUES (11,oils_i18n_gettext('Cataloging')); +INSERT INTO config.copy_status (id,name) VALUES (12,oils_i18n_gettext('Reserves')); +INSERT INTO config.copy_status (id,name) VALUES (13,oils_i18n_gettext('Discard/Weed')); +INSERT INTO config.copy_status (id,name) VALUES (14,oils_i18n_gettext('Damaged')); SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100); -- 2.43.2