From f2fd2de1b4b7f12ed8409f1bfd3c30b09bd3c3d9 Mon Sep 17 00:00:00 2001
From: peter <peter.hormanns@jalin.de>
Date: Tue, 23 Apr 2013 22:02:08 +0200
Subject: [PATCH] valid bank-Account

---
 hsarback/database/schema.sql |   14 +++++++-------
 hsarback/database/data.sql   |    5 +++--
 2 files changed, 10 insertions(+), 9 deletions(-)

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index ff35fd4..6c3822b 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -71,8 +71,9 @@
 --
 -- table: bank_account 
 --
-INSERT INTO bank_account (bp_id, autodebit_ga, autodebit_ar, autodebit_op)
-	SELECT bp_id, true, true, true FROM business_partner WHERE member_id=10000;
+INSERT INTO bank_account (bp_id, autodebit_ga, autodebit_ar, autodebit_op, 
+				bank_customer, bank_account, bank_code, bank_name)
+	SELECT bp_id, false, false, false, '', '', '', '' FROM business_partner WHERE member_id=10000;
 
 --
 -- table: billdata 
diff --git a/hsarback/database/schema.sql b/hsarback/database/schema.sql
index 6367f64..93d89e9 100644
--- a/hsarback/database/schema.sql
+++ b/hsarback/database/schema.sql
@@ -5,13 +5,13 @@
 CREATE TABLE bank_account (
     bank_account_id integer DEFAULT nextval(('"bank_account_bank_account_id_seq"'::text)::regclass) NOT NULL,
     bp_id integer NOT NULL,
-    autodebit_ga boolean NOT NULL,
-    autodebit_ar boolean NOT NULL,
-    autodebit_op boolean NOT NULL,
-    bank_customer character varying(50) NOT NULL,
-    bank_account character varying(10) NOT NULL,
-    bank_code character varying(8) NOT NULL,
-    bank_name character varying(50) NOT NULL
+    autodebit_ga boolean NOT NULL DEFAULT false,
+    autodebit_ar boolean NOT NULL DEFAULT false,
+    autodebit_op boolean NOT NULL DEFAULT false,
+    bank_customer character varying(50) NOT NULL DEFAULT '',
+    bank_account character varying(10) NOT NULL DEFAULT '',
+    bank_code character varying(8) NOT NULL DEFAULT '',
+    bank_name character varying(50) NOT NULL DEFAULT ''
 );
 
 

--
Gitblit v1.9.1