HSAdmin Backend Domains, E-Mail, Datenbanken
Peter Hormanns
2014-05-17 c3f5a5b24843b960955dc4e5d092736b1de705fd
Spalten technical_contact, business_contact
2 files modified
13 ■■■■ changed files
hsarback/database/data.sql 5 ●●●●● patch | view | raw | blame | history
hsarback/database/schema.sql 8 ●●●● patch | view | raw | blame | history
hsarback/database/data.sql
@@ -90,8 +90,9 @@
-- table: bank_account 
--
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;
                bank_customer, bank_account, bank_code, bank_name, mandat_ref, mandat_signed, mandat_since)
    SELECT bp_id, false, false, false, '', '', '', '', member_id, current_date, current_date
        FROM business_partner WHERE member_id=10000;
--
-- Table: inet_addr 
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))
);