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 +++++++-------
 1 files changed, 7 insertions(+), 7 deletions(-)

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.3