From da8ea44b30327aab8bae9bdd7c9eff2fb90b1e99 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 20 Mar 2009 18:40:33 +0000 Subject: [PATCH] --- sql/base/base.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 9e7e22a..0882711 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -30,6 +30,7 @@ CREATE OR REPLACE FUNCTION migration_tools.init (TEXT) RETURNS VOID AS $$ DECLARE migration_schema ALIAS FOR $1; BEGIN + EXECUTE 'CREATE SCHEMA ' || migration_schema || ';'; EXECUTE 'CREATE TABLE ' || migration_schema || '.config ( key TEXT UNIQUE, value TEXT);'; EXECUTE 'INSERT INTO ' || migration_schema || '.config (key,value) VALUES ( ''production_tables'', ''asset.call_number,asset.copy_location,asset.copy,asset.stat_cat,asset.stat_cat_entry,asset.stat_cat_entry_copy_map,asset.copy_note,actor.usr,actor.card,actor.usr_address,actor.stat_cat,actor.stat_cat_entry,actor.stat_cat_entry_usr_map,actor.usr_note,action.circulation,action.hold_request,money.grocery,money.billing,money.cash_payment,money.forgive_payment'' );'; EXECUTE 'DROP TABLE IF EXISTS ' || migration_schema || '.fields_requiring_mapping;'; -- 1.7.2.5