adding x_shelf and x_org to the shelving location init 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..c414c17 100644 (file)
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -8,6 +8,8 @@ CREATE TABLE map_create_shelving_location (
     ,l_circulate          TEXT
     ,l_note               TEXT
     ,x_migrate            BOOLEAN NOT NULL DEFAULT TRUE
+    ,x_shelf              INTEGER
+    ,x_org                INTEGER
 ) INHERITS (asset_copy_location);
 
 INSERT INTO gsheet_tracked_table