From c3f5a5b24843b960955dc4e5d092736b1de705fd Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Sat, 17 May 2014 20:17:50 +0200
Subject: [PATCH] Spalten technical_contact, business_contact

---
 hsarback/database/schema.sql |    8 +++++++-
 1 files changed, 7 insertions(+), 1 deletions(-)

diff --git a/hsarback/database/schema.sql b/hsarback/database/schema.sql
index 3f0a4f5..b4a4d19 100644
--- a/hsarback/database/schema.sql
+++ b/hsarback/database/schema.sql
@@ -14,7 +14,11 @@
     bank_name character varying(50),
     bank_iban character varying(30),
     bank_bic character varying(15),
-    mandat_ref character varying(10)
+    mandat_ref character varying(10) NOT NULL,
+    mandat_signed date,
+    mandat_since date,
+    mandat_until date,
+    mandat_used date
 );
 
 
@@ -169,6 +173,8 @@
     phone_mobile character varying(30),
     fax character varying(30),
     email character varying(100) NOT NULL,
+    business_contact boolean DEFAULT TRUE,
+    technical_contact boolean DEFAULT TRUE,
     CONSTRAINT ckc_email_contact CHECK (((email)::text ~~ '%@%.%'::text))
 );
 

--
Gitblit v1.9.0-SNAPSHOT