HSAdmin Backend Domains, E-Mail, Datenbanken
Peter Hormanns
2011-05-19 c464f55e9a53e10fe2d0cc25238b9d7ef1f94ab1
complete test packages
2 files modified
37 ■■■■■ changed files
hsarback/build.xml 2 ●●● patch | view | raw | blame | history
hsarback/database/data.sql 35 ●●●●● patch | view | raw | blame | history
hsarback/build.xml
@@ -37,7 +37,7 @@
    <target name="deploy" depends="war">
        <delete dir="${hsar.deploy.dir}/hsar" />
        <copy file="build/hsar.war" todir="${hsar.deploy.dir}" />
        <sleep minutes="2"/>
        <sleep minutes="5"/>
    </target>
    <target name="war" depends="enhance">
hsarback/database/data.sql
@@ -109,6 +109,41 @@
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 
        WHERE hive_name='h81' AND inet_addr = inet '192.168.108.202' AND member_id = 10000; 
--
-- table: packet_component
--
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 1, packet.packet_id, 2, current_date FROM packet
        WHERE packet.packet_name = 'hsh00';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 2, packet.packet_id, 128, current_date FROM packet
        WHERE packet.packet_name = 'hsh00';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 3, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh00';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 4, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh00';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 5, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh00';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 1, packet.packet_id, 2, current_date FROM packet
        WHERE packet.packet_name = 'hsh01';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 2, packet.packet_id, 128, current_date FROM packet
        WHERE packet.packet_name = 'hsh01';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 3, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh01';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 4, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh01';
INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
    SELECT 1, 5, packet.packet_id, 0, current_date FROM packet
        WHERE packet.packet_name = 'hsh01';
--
-- table: unixuser 
--