hs.hsadmin/hsarback/database/dropschema.sql

46 lines
1.4 KiB
MySQL
Raw Permalink Normal View History

2014-10-14 16:34:42 +02:00
DROP TABLE pricelist_ref ;
2013-04-18 11:57:16 +02:00
DROP TABLE price ;
2014-10-14 16:47:51 +02:00
DROP TABLE price_list CASCADE ;
2023-06-22 22:12:06 +02:00
DROP VIEW IF EXISTS business_partner_ticket ;
DROP VIEW IF EXISTS ipconfig ;
2014-10-14 16:34:42 +02:00
DROP TABLE sepa_mandat ;
DROP SEQUENCE sepa_mandat_id_seq ;
2011-03-25 18:37:16 +01:00
DROP SEQUENCE contact_contact_id_seq ;
2014-10-14 16:47:51 +02:00
DROP TABLE contact CASCADE ;
2011-03-25 18:37:16 +01:00
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 ;
2011-03-25 18:37:16 +01:00
DROP TABLE domain ;
DROP SEQUENCE domain_domain_id_seq ;
2017-03-31 18:24:27 +02:00
DROP TABLE queue_task ;
DROP SEQUENCE queue_task_id_seq ;
DROP TABLE unixuser CASCADE ;
2011-03-25 18:37:16 +01:00
DROP SEQUENCE unixuser_unixuser_id_seq ;
DROP TABLE packet_component ;
DROP TABLE component ;
DROP TABLE basecomponent ;
DROP TABLE basepacket CASCADE ;
2011-03-25 18:37:16 +01:00
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 ;
2013-04-30 13:29:33 +02:00
DROP TABLE business_partner CASCADE ;
2011-03-25 18:37:16 +01:00
DROP SEQUENCE business_partner_bp_id_seq ;
2013-05-13 20:56:28 +02:00
DROP SEQUENCE packet_component_id_seq ;
DROP SEQUENCE component_id_seq ;
2014-11-25 14:40:23 +01:00
DROP TABLE contactrole_ref CASCADE ;
2017-03-31 18:24:27 +02:00
DROP TABLE role CASCADE ;
2017-04-12 19:21:12 +02:00