From d08b279098bc2c7580a8fe4429a737a881ac0a11 Mon Sep 17 00:00:00 2001
From: dbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 9 Aug 2010 20:43:53 +0000
Subject: [PATCH] SQL 101: Remember to name all of the columns before you
 insert values into said columns

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17142 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index 72d3a1431b..061fa41f53 100644
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -265,7 +265,7 @@ CREATE OR REPLACE FUNCTION asset.label_normalizer_lc(TEXT) RETURNS TEXT AS $func
 
 $func$ LANGUAGE PLPERLU;
 
-INSERT INTO asset.call_number_class (name, normalizer) VALUES 
+INSERT INTO asset.call_number_class (name, normalizer, field) VALUES 
     ('Generic', 'asset.label_normalizer_generic', '050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099'),
     ('Dewey (DDC)', 'asset.label_normalizer_dewey', '080ab,082ab'),
     ('Library of Congress (LC)', 'asset.label_normalizer_lc', '050ab,055ab')
-- 
2.11.0