HSAdmin Backend Domains, E-Mail, Datenbanken
Peter Hormanns
2013-04-25 b4ba1159878d2ca155be86e8e3b39c94c5c5ee14
add attribute free to packet definition
2 files modified
11 ■■■■ changed files
hsarback/database/data.sql 8 ●●●● patch | view | raw | blame | history
hsarback/database/schema.sql 3 ●●●● patch | view | raw | blame | history
hsarback/database/data.sql
@@ -112,11 +112,11 @@
--
-- table: packet 
--
INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id)
    SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr
INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free)
    SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true FROM business_partner, hive, inet_addr
        WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000; 
INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id)
    SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr
INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free)
    SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true FROM business_partner, hive, inet_addr
        WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000;
        
--
hsarback/database/schema.sql
@@ -411,8 +411,7 @@
    hive_id integer NOT NULL,
    created date NOT NULL,
    cancelled date,
    order_number character varying(20),
    webserver_group character varying(10),
    free boolean NOT NULL,
    cur_inet_addr_id integer,
    old_inet_addr_id integer,
    CONSTRAINT ckt_packet CHECK (((cancelled IS NULL) OR (cancelled > created)))