| | |
| | | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free, basepacket_id) |
| | | SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true, basepacket.basepacket_id |
| | | FROM business_partner, hive, inet_addr, basepacket |
| | | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000 AND basepacket.basepacket_code='PAC/DW'; |
| | | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000 AND basepacket.basepacket_code='PAC/WEB'; |
| | | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free, basepacket_id) |
| | | SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true, basepacket.basepacket_id |
| | | FROM business_partner, hive, inet_addr, basepacket |
| | | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000 AND basepacket.basepacket_code='PAC/DW'; |
| | | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000 AND basepacket.basepacket_code='PAC/WEB'; |
| | | |
| | | -- |
| | | -- table: packet_component |
| | |
| | | DROP SEQUENCE queue_task_id_seq ; |
| | | DROP TABLE unixuser CASCADE ; |
| | | DROP SEQUENCE unixuser_unixuser_id_seq ; |
| | | DROP TABLE pac_administration CASCADE ; |
| | | DROP TABLE packet_component ; |
| | | DROP TABLE component ; |
| | | DROP TABLE basecomponent ; |
| | |
| | | domain_since date, |
| | | domain_dns_master character varying(64), |
| | | domain_id integer DEFAULT nextval('domain_domain_id_seq'::regclass) NOT NULL, |
| | | domain_owner integer NOT NULL |
| | | domain_owner integer NOT NULL, |
| | | valid_subdomain_names character varying(256) DEFAULT 'www' NOT NULL |
| | | ); |
| | | |
| | | |