scripts/cql/dhcpdb_drop.cql

18 DROP TABLE IF EXISTS lease4;
19 DROP TABLE IF EXISTS lease6;
20 DROP TABLE IF EXISTS lease6_types;
21 DROP TABLE IF EXISTS lease_hwaddr_source;
22 DROP TABLE IF EXISTS lease_state;
23 DROP TABLE IF EXISTS schema_version;
24 DROP TABLE IF EXISTS host_reservations;
25 DROP TABLE IF EXISTS hosts;
26 DROP TABLE IF EXISTS dhcp4_options;
27 DROP TABLE IF EXISTS dhcp6_options;
28 DROP TABLE IF EXISTS host_identifier_type;
29 DROP TABLE IF EXISTS dhcp_option_scope;
30 DROP TABLE IF EXISTS logs;
32 DROP INDEX IF EXISTS lease4index1;
33 DROP INDEX IF EXISTS lease4index2;
34 DROP INDEX IF EXISTS lease4index3;
35 DROP INDEX IF EXISTS lease4index4;
36 DROP INDEX IF EXISTS lease4index5;
37 DROP INDEX IF EXISTS lease4index6;
39 DROP INDEX IF EXISTS lease6index1;
40 DROP INDEX IF EXISTS lease6index2;
41 DROP INDEX IF EXISTS lease6index3;
42 DROP INDEX IF EXISTS lease6index4;
43 DROP INDEX IF EXISTS lease6index5;
44 DROP INDEX IF EXISTS lease6index6;
45 DROP INDEX IF EXISTS lease6index7;
47 DROP INDEX IF EXISTS host_reservationsindex1;
48 DROP INDEX IF EXISTS host_reservationsindex2;
49 DROP INDEX IF EXISTS host_reservationsindex3;
50 DROP INDEX IF EXISTS host_reservationsindex4;
51 DROP INDEX IF EXISTS host_reservationsindex5;
52 DROP INDEX IF EXISTS host_reservationsindex6;
53 DROP INDEX IF EXISTS host_reservationsindex7;
55 DROP INDEX IF EXISTS hostsindex1;
56 DROP INDEX IF EXISTS hostsindex2;
57 DROP INDEX IF EXISTS hostsindex3;
58 DROP INDEX IF EXISTS hostsindex4;
59 DROP INDEX IF EXISTS hostsindex5;
60 DROP INDEX IF EXISTS hostsindex6;
61 DROP INDEX IF EXISTS hostsindex7;
62 DROP INDEX IF EXISTS hostsindex8;
64 DROP INDEX IF EXISTS logsindex;