1-- Copyright (C) 2018-2020 Internet Systems Consortium, Inc. ("ISC")
2-- Copyright (C) 2015-2017 Deutsche Telekom AG.
3
4-- Author: Razvan Becheriu <razvan.becheriu@qualitance.com>
5
6-- Licensed under the Apache License, Version 2.0 (the "License");
7-- you may not use this file except in compliance with the License.
8-- You may obtain a copy of the License at
9
10--           http://www.apache.org/licenses/LICENSE-2.0
11
12-- Unless required by applicable law or agreed to in writing, software
13-- distributed under the License is distributed on an "AS IS" BASIS,
14-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15-- See the License for the specific language governing permissions and
16-- limitations under the License.
17
18DROP TABLE IF EXISTS lease4;
19DROP TABLE IF EXISTS lease6;
20DROP TABLE IF EXISTS lease6_types;
21DROP TABLE IF EXISTS lease_hwaddr_source;
22DROP TABLE IF EXISTS lease_state;
23DROP TABLE IF EXISTS schema_version;
24DROP TABLE IF EXISTS host_reservations;
25DROP TABLE IF EXISTS hosts;
26DROP TABLE IF EXISTS dhcp4_options;
27DROP TABLE IF EXISTS dhcp6_options;
28DROP TABLE IF EXISTS host_identifier_type;
29DROP TABLE IF EXISTS dhcp_option_scope;
30DROP TABLE IF EXISTS logs;
31
32DROP INDEX IF EXISTS lease4index1;
33DROP INDEX IF EXISTS lease4index2;
34DROP INDEX IF EXISTS lease4index3;
35DROP INDEX IF EXISTS lease4index4;
36DROP INDEX IF EXISTS lease4index5;
37DROP INDEX IF EXISTS lease4index6;
38
39DROP INDEX IF EXISTS lease6index1;
40DROP INDEX IF EXISTS lease6index2;
41DROP INDEX IF EXISTS lease6index3;
42DROP INDEX IF EXISTS lease6index4;
43DROP INDEX IF EXISTS lease6index5;
44DROP INDEX IF EXISTS lease6index6;
45DROP INDEX IF EXISTS lease6index7;
46
47DROP INDEX IF EXISTS host_reservationsindex1;
48DROP INDEX IF EXISTS host_reservationsindex2;
49DROP INDEX IF EXISTS host_reservationsindex3;
50DROP INDEX IF EXISTS host_reservationsindex4;
51DROP INDEX IF EXISTS host_reservationsindex5;
52DROP INDEX IF EXISTS host_reservationsindex6;
53DROP INDEX IF EXISTS host_reservationsindex7;
54
55DROP INDEX IF EXISTS hostsindex1;
56DROP INDEX IF EXISTS hostsindex2;
57DROP INDEX IF EXISTS hostsindex3;
58DROP INDEX IF EXISTS hostsindex4;
59DROP INDEX IF EXISTS hostsindex5;
60DROP INDEX IF EXISTS hostsindex6;
61DROP INDEX IF EXISTS hostsindex7;
62DROP INDEX IF EXISTS hostsindex8;
63
64DROP INDEX IF EXISTS logsindex;
65