From 64332df4df5edcf14fa79f307b60c523440fa3ab Mon Sep 17 00:00:00 2001 From: garyhgohoos Date: Fri, 1 Aug 2014 11:11:21 -0400 Subject: [PATCH] Issue #23225:create table --- foundation-database/public/tables/bankrecimport.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 foundation-database/public/tables/bankrecimport.sql diff --git a/foundation-database/public/tables/bankrecimport.sql b/foundation-database/public/tables/bankrecimport.sql new file mode 100644 index 000000000..9fee6f526 --- /dev/null +++ b/foundation-database/public/tables/bankrecimport.sql @@ -0,0 +1,9 @@ +select xt.create_table('bankrecimport', 'public'); +select xt.add_column('bankrecimport','bankrecimport_id', 'SERIAL', 'PRIMARY KEY', 'public'); +select xt.add_column('bankrecimport','bankrecimport_reference', 'TEXT', 'NOT NULL' 'public'); +select xt.add_column('bankrecimport','bankrecimport_descrip', 'TEXT', 'NOT NULL' 'public'); +select xt.add_column('bankrecimport','bankrecimport_comment', 'TEXT', 'NOT NULL' 'public'); +select xt.add_column('bankrecimport','bankrecimport_debit_amount', 'NUMERIC', 'NOT NULL', 'public'); +select xt.add_column('bankrecimport','bankrecimport_credit_amount', 'NUMERIC', 'NOT NULL', 'public'); +select xt.add_column('bankrecimport','bankrecimport_effdate', 'DATE', 'NOT NULL', 'public'); +select xt.add_column('bankrecimport','bankrecimport_curr_rate', 'NUMERIC', 'NOT NULL', 'public'); -- 2.39.2