scripts/mysql/dhcpdb_drop.mysql

9 DROP TABLE IF EXISTS lease4;
10 DROP TABLE IF EXISTS lease6;
11 DROP TABLE IF EXISTS lease6_types;
12 DROP TABLE IF EXISTS lease_hwaddr_source;
13 DROP TABLE IF EXISTS schema_version;
14 DROP TABLE IF EXISTS ipv6_reservations;
15 DROP TABLE IF EXISTS hosts;
16 DROP TABLE IF EXISTS dhcp4_options;
17 DROP TABLE IF EXISTS dhcp6_options;
18 DROP TABLE IF EXISTS host_identifier_type;
19 DROP TABLE IF EXISTS lease_state;
20 DROP TABLE IF EXISTS dhcp_option_scope;
21 DROP TRIGGER IF EXISTS host_BDEL;
22 DROP PROCEDURE IF EXISTS lease4DumpHeader;
23 DROP PROCEDURE IF EXISTS lease4DumpData;
24 DROP PROCEDURE IF EXISTS lease6DumpHeader;
25 DROP PROCEDURE IF EXISTS lease6DumpData;
26 DROP TRIGGER IF EXISTS lease4_stat_insert;
27 DROP TRIGGER IF EXISTS lease4_stat_update;
28 DROP TRIGGER IF EXISTS lease4_stat_delete;
29 DROP TABLE IF EXISTS lease4_stat;
30 DROP TRIGGER IF EXISTS lease6_stat_insert;
31 DROP TRIGGER IF EXISTS lease6_stat_update;
32 DROP TRIGGER IF EXISTS lease6_stat_delete;
33 DROP TABLE IF EXISTS lease6_stat;
34 DROP TABLE IF EXISTS logs;
35 DROP TABLE IF EXISTS dhcp4_audit;
36 DROP TABLE IF EXISTS dhcp4_audit_revision;
37 DROP TABLE IF EXISTS dhcp4_global_parameter;
38 DROP TABLE IF EXISTS dhcp4_global_parameter_server;
39 DROP TABLE IF EXISTS dhcp4_option_def;
40 DROP TABLE IF EXISTS dhcp4_option_def_server;
41 DROP TABLE IF EXISTS dhcp4_options_server;
42 DROP TABLE IF EXISTS dhcp4_pool;
43 DROP TABLE IF EXISTS dhcp4_server;
44 DROP TABLE IF EXISTS dhcp4_shared_network;
45 DROP TABLE IF EXISTS dhcp4_shared_network_server;
46 DROP TABLE IF EXISTS dhcp4_subnet;
47 DROP TABLE IF EXISTS dhcp4_subnet_server;
48 DROP TABLE IF EXISTS dhcp4_client_class;
49 DROP TABLE IF EXISTS dhcp4_client_class_order;
50 DROP TABLE IF EXISTS dhcp4_client_class_dependency;
51 DROP TABLE IF EXISTS dhcp4_client_class_server;
52 DROP TABLE IF EXISTS dhcp6_audit;
53 DROP TABLE IF EXISTS dhcp6_global_parameter;
54 DROP TABLE IF EXISTS dhcp6_global_parameter_server;
55 DROP TABLE IF EXISTS dhcp6_option_def;
56 DROP TABLE IF EXISTS dhcp6_option_def_server;
57 DROP TABLE IF EXISTS dhcp6_options_server;
58 DROP TABLE IF EXISTS dhcp6_pd_pool;
59 DROP TABLE IF EXISTS dhcp6_pool;
60 DROP TABLE IF EXISTS dhcp6_server;
61 DROP TABLE IF EXISTS dhcp6_shared_network;
62 DROP TABLE IF EXISTS dhcp6_shared_network_server;
63 DROP TABLE IF EXISTS dhcp6_subnet;
64 DROP TABLE IF EXISTS dhcp6_subnet_server;
65 DROP TABLE IF EXISTS dhcp6_client_class;
66 DROP TABLE IF EXISTS dhcp6_client_class_order;
67 DROP TABLE IF EXISTS dhcp6_client_class_dependency;
68 DROP TABLE IF EXISTS dhcp6_client_class_server;
69 DROP TABLE IF EXISTS modification;
70 DROP TABLE IF EXISTS parameter_data_type;
71 DROP PROCEDURE IF EXISTS createAuditRevisionDHCP4;
72 DROP PROCEDURE IF EXISTS createAuditEntryDHCP4;
73 DROP PROCEDURE IF EXISTS createOptionAuditDHCP4;
74 DROP PROCEDURE IF EXISTS setClientClass4Order;
75 DROP PROCEDURE IF EXISTS checkDHCPv4ClientClassDependency;
76 DROP PROCEDURE IF EXISTS updateDHCPv4ClientClassKnownDependency;
77 DROP PROCEDURE IF EXISTS checkDHCPv4ClientClassKnownDependencyChange;
78 DROP TRIGGER IF EXISTS dhcp4_global_parameter_AINS;
79 DROP TRIGGER IF EXISTS dhcp4_global_parameter_AUPD;
80 DROP TRIGGER IF EXISTS dhcp4_global_parameter_ADEL;
81 DROP TRIGGER IF EXISTS dhcp4_subnet_AINS;
82 DROP TRIGGER IF EXISTS dhcp4_subnet_AUPD;
83 DROP TRIGGER IF EXISTS dhcp4_subnet_ADEL;
84 DROP TRIGGER IF EXISTS dhcp4_shared_network_AINS;
85 DROP TRIGGER IF EXISTS dhcp4_shared_network_AUPD;
86 DROP TRIGGER IF EXISTS dhcp4_shared_network_ADEL;
87 DROP TRIGGER IF EXISTS dhcp4_option_def_AINS;
88 DROP TRIGGER IF EXISTS dhcp4_option_def_AUPD;
89 DROP TRIGGER IF EXISTS dhcp4_option_def_ADEL;
90 DROP TRIGGER IF EXISTS dhcp4_options_AINS;
91 DROP TRIGGER IF EXISTS dhcp4_options_AUPD;
92 DROP TRIGGER IF EXISTS dhcp4_options_ADEL;
93 DROP TRIGGER IF EXISTS dhcp4_client_class_AINS;
94 DROP TRIGGER IF EXISTS dhcp4_client_class_AUPD;
95 DROP TRIGGER IF EXISTS dhcp4_client_class_ADEL;
96 DROP TRIGGER IF EXISTS dhcp4_client_class_dependency_BINS;
97 DROP TRIGGER IF EXISTS dhcp4_client_class_dependency_AINS;
98 DROP TABLE IF EXISTS dhcp6_audit_revision;
99 DROP PROCEDURE IF EXISTS createAuditRevisionDHCP6;
100 DROP PROCEDURE IF EXISTS createAuditEntryDHCP6;
101 DROP PROCEDURE IF EXISTS createOptionAuditDHCP6;
102 DROP PROCEDURE IF EXISTS setClientClass6Order;
103 DROP PROCEDURE IF EXISTS checkDHCPv6ClientClassDependency;
104 DROP PROCEDURE IF EXISTS updateDHCPv6ClientClassKnownDependency;
105 DROP PROCEDURE IF EXISTS checkDHCPv6ClientClassKnownDependencyChange;
106 DROP TRIGGER IF EXISTS dhcp6_global_parameter_AINS;
107 DROP TRIGGER IF EXISTS dhcp6_global_parameter_AUPD;
108 DROP TRIGGER IF EXISTS dhcp6_global_parameter_ADEL;
109 DROP TRIGGER IF EXISTS dhcp6_subnet_AINS;
110 DROP TRIGGER IF EXISTS dhcp6_subnet_AUPD;
111 DROP TRIGGER IF EXISTS dhcp6_subnet_ADEL;
112 DROP TRIGGER IF EXISTS dhcp6_shared_network_AINS;
113 DROP TRIGGER IF EXISTS dhcp6_shared_network_AUPD;
114 DROP TRIGGER IF EXISTS dhcp6_shared_network_ADEL;
115 DROP TRIGGER IF EXISTS dhcp6_option_def_AINS;
116 DROP TRIGGER IF EXISTS dhcp6_option_def_AUPD;
117 DROP TRIGGER IF EXISTS dhcp6_option_def_ADEL;
118 DROP TRIGGER IF EXISTS dhcp6_options_AINS;
119 DROP TRIGGER IF EXISTS dhcp6_options_AUPD;
120 DROP TRIGGER IF EXISTS dhcp6_options_ADEL;
121 DROP TRIGGER IF EXISTS dhcp6_client_class_AINS;
122 DROP TRIGGER IF EXISTS dhcp6_client_class_AUPD;
123 DROP TRIGGER IF EXISTS dhcp6_client_class_ADEL;
124 DROP TRIGGER IF EXISTS dhcp6_client_class_dependency_BINS;
125 DROP TRIGGER IF EXISTS dhcp6_client_class_dependency_AINS;