45 lines
1.4 KiB
SQL
45 lines
1.4 KiB
SQL
DROP TABLE pricelist_ref ;
|
|
DROP TABLE price ;
|
|
DROP TABLE price_list CASCADE ;
|
|
-- DROP VIEW business_partner_ticket ;
|
|
DROP TABLE sepa_mandat ;
|
|
DROP SEQUENCE sepa_mandat_id_seq ;
|
|
DROP SEQUENCE contact_contact_id_seq ;
|
|
DROP TABLE contact CASCADE ;
|
|
DROP TABLE database ;
|
|
DROP TABLE database_user ;
|
|
DROP SEQUENCE database_database_id_seq ;
|
|
DROP SEQUENCE dbuser_dbuser_id_seq ;
|
|
DROP TABLE emailaddr ;
|
|
DROP SEQUENCE emailaddr_emailaddr_id_seq ;
|
|
DROP TABLE emailalias ;
|
|
DROP SEQUENCE emailalias_emailalias_id_seq ;
|
|
DROP TABLE domain__domain_option ;
|
|
DROP TABLE domain_option ;
|
|
DROP SEQUENCE domain_option_id_seq ;
|
|
DROP TABLE domain ;
|
|
DROP SEQUENCE domain_domain_id_seq ;
|
|
DROP TABLE queue_task ;
|
|
DROP SEQUENCE queue_task_id_seq ;
|
|
DROP TABLE unixuser CASCADE ;
|
|
DROP SEQUENCE unixuser_unixuser_id_seq ;
|
|
DROP TABLE packet_component ;
|
|
DROP TABLE component ;
|
|
DROP TABLE basecomponent ;
|
|
DROP TABLE basepacket CASCADE ;
|
|
DROP SEQUENCE basecomponent_basecomponent_seq ;
|
|
DROP SEQUENCE basepacket_basepacket_id_seq ;
|
|
DROP TABLE packet ;
|
|
DROP SEQUENCE packet_packet_id_seq ;
|
|
DROP TABLE hive ;
|
|
DROP SEQUENCE hive_hive_id_seq ;
|
|
DROP TABLE inet_addr ;
|
|
DROP SEQUENCE inet_addr_inet_addr_id_seq ;
|
|
DROP TABLE business_partner CASCADE ;
|
|
DROP SEQUENCE business_partner_bp_id_seq ;
|
|
DROP SEQUENCE packet_component_id_seq ;
|
|
DROP SEQUENCE component_id_seq ;
|
|
DROP TABLE contactrole_ref CASCADE ;
|
|
DROP TABLE role CASCADE ;
|
|
|