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