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