X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=ab1b01136a1eda65e5c0fb7e3075633937902415;hp=34333bcf1c99fd94f9a9b145acc33949f7a2d8c1;hb=2d416d5e39c1f6a1b32876cf66512f99817d7ee3;hpb=fc6d8ddb8ab2cc66d2fa3956e3e8b903e0ad42ee

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index 34333bc..ab1b011 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -1,13 +1,14 @@
 CREATE TABLE map_create_shelving_location (
     l_id                  SERIAL
     ,l_owning_lib         TEXT            
-    ,l_desired_shelf      TEXT
+    ,l_copy_location      TEXT
     ,l_opac_visible       TEXT
     ,l_checkin_alert      TEXT
     ,l_holdable           TEXT
     ,l_circulate          TEXT
     ,l_note               TEXT
     ,x_migrate            BOOLEAN NOT NULL DEFAULT TRUE
+    ,x_shelf              INTEGER
 ) INHERITS (asset_copy_location);
 
 INSERT INTO gsheet_tracked_table 
@@ -20,7 +21,7 @@ INSERT INTO gsheet_tracked_column
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_desired_shelf')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')