moving org to the holding code table

[migration-tools.git] / mig-sql / init / 020_common_tables.sql

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index a8e6b98..ab1b011 100644 (file)
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -8,6 +8,7 @@ CREATE TABLE map_create_shelving_location (
     ,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