From 395d16bd5f8e2dc2df72e760620373e10cf3ebe0 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Tue, 23 Apr 2013 18:35:40 +0200
Subject: [PATCH] update contraint
---
hsarback/database/schema.sql | 9 ++++-----
1 files changed, 4 insertions(+), 5 deletions(-)
diff --git a/hsarback/database/schema.sql b/hsarback/database/schema.sql
index 093f566..6367f64 100644
--- a/hsarback/database/schema.sql
+++ b/hsarback/database/schema.sql
@@ -8,11 +8,10 @@
autodebit_ga boolean NOT NULL,
autodebit_ar boolean NOT NULL,
autodebit_op boolean NOT NULL,
- bank_customer character varying(50),
- bank_account character varying(10),
- bank_code character varying(8),
- bank_name character varying(50),
- CONSTRAINT ckt_bank_account CHECK (((((((bank_customer IS NOT NULL) AND (bank_account IS NOT NULL)) AND (bank_code IS NOT NULL)) AND (bank_name IS NOT NULL)) AND (((autodebit_ga = true) OR (autodebit_ar = true)) OR (autodebit_op = true))) OR (((autodebit_ga = false) AND (autodebit_ar = false)) AND (autodebit_op = false))))
+ 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
);
--
Gitblit v1.9.3