From b124bda5b14f1459d194e0cb3e3cef29533a1f11 Mon Sep 17 00:00:00 2001 From: Dan Pearl Date: Wed, 6 Feb 2013 16:21:47 -0500 Subject: [PATCH] Database change to support sorting of parts labels --- Open-ILS/src/sql/Pg/parts-sorting.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/parts-sorting.sql diff --git a/Open-ILS/src/sql/Pg/parts-sorting.sql b/Open-ILS/src/sql/Pg/parts-sorting.sql new file mode 100644 index 0000000000..b0858c0910 --- /dev/null +++ b/Open-ILS/src/sql/Pg/parts-sorting.sql @@ -0,0 +1,19 @@ +/* + * Copyright (C) 2012 C/W MARS Inc. + * Daniel Pearl + * + * This program is free software; you can redistribute it and/or + * modify it under the terms of the GNU General Public License + * as published by the Free Software Foundation; either version 2 + * of the License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + */ +BEGIN; + ALTER TABLE biblio.monograph_part ADD COLUMN sort_order INTEGER DEFAULT 0; +COMMIT; + -- 2.11.0