1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
-- Copyright (C) 2016-2022 Internet Systems Consortium.
-- This Source Code Form is subject to the terms of the Mozilla Public
-- License, v. 2.0. If a copy of the MPL was not distributed with this
-- file, You can obtain one at http://mozilla.org/MPL/2.0/.
DROP TABLE IF EXISTS lease4 CASCADE;
DROP TABLE IF EXISTS lease6 CASCADE;
DROP TABLE IF EXISTS lease6_types CASCADE;
DROP TABLE IF EXISTS schema_version CASCADE;
DROP TABLE IF EXISTS lease_state CASCADE;
DROP TABLE IF EXISTS dhcp4_options CASCADE;
DROP TABLE IF EXISTS dhcp6_options CASCADE;
DROP TABLE IF EXISTS ipv6_reservations CASCADE;
DROP TABLE IF EXISTS lease_hwaddr_source CASCADE;
DROP TABLE IF EXISTS host_identifier_type CASCADE;
DROP TABLE IF EXISTS dhcp_option_scope CASCADE;
DROP TABLE IF EXISTS hosts CASCADE;
DROP FUNCTION IF EXISTS lease4DumpHeader();
DROP FUNCTION IF EXISTS lease4DumpData();
DROP FUNCTION IF EXISTS lease6DumpHeader();
DROP FUNCTION IF EXISTS lease6DumpData();
DROP TABLE IF EXISTS lease4_stat CASCADE;
DROP FUNCTION IF EXISTS proc_stat_lease4_insert ();
DROP FUNCTION IF EXISTS proc_stat_lease4_update ();
DROP FUNCTION IF EXISTS proc_stat_lease4_delete ();
DROP TABLE IF EXISTS lease6_stat CASCADE;
DROP FUNCTION IF EXISTS proc_stat_lease6_insert ();
DROP FUNCTION IF EXISTS proc_stat_lease6_update ();
DROP FUNCTION IF EXISTS proc_stat_lease6_delete ();
DROP TABLE IF EXISTS logs CASCADE;
-- config backend procedures for DHCPv6
DROP FUNCTION IF EXISTS createAuditRevisionDHCP6(audit_ts TIMESTAMP WITH TIME ZONE, server_tag VARCHAR(64),
audit_log_message TEXT, cascade_transaction BOOLEAN);
DROP FUNCTION IF EXISTS createAuditEntryDHCP6(object_type_val VARCHAR(256), object_id_val BIGINT,
modification_type_val VARCHAR(32));
DROP FUNCTION IF EXISTS createOptionAuditDHCP6(modification_type VARCHAR, scope_id SMALLINT,
option_id INT, subnet_id BIGINT, host_id INT,
network_name VARCHAR, pool_id BIGINT, pd_pool_id BIGINT,
modification_ts TIMESTAMP WITH TIME ZONE);
DROP FUNCTION IF EXISTS createOptionAuditDHCP6(modification_type VARCHAR, scope_id SMALLINT,
option_id INT, p_subnet_id BIGINT, host_id INT,
network_name VARCHAR, pool_id BIGINT, pd_pool_id BIGINT,
p_modification_ts TIMESTAMP WITH TIME ZONE);
DROP FUNCTION IF EXISTS setClientClass6Order(id BIGINT, follow_class_name VARCHAR(128),
old_follow_class_name VARCHAR(128));
DROP FUNCTION IF EXISTS checkDHCPv6ClientClassDependency(class_id BIGINT, dependency_id BIGINT);
DROP FUNCTION IF EXISTS updateDHCPv6ClientClassKnownDependency(client_class_id BIGINT,
dependency_id BIGINT);
DROP FUNCTION IF EXISTS checkDHCPv6ClientClassKnownDependencyChange();
-- config backend tables for DHCPv6
DROP TABLE IF EXISTS dhcp6_audit CASCADE;
DROP TABLE IF EXISTS dhcp6_option_def_server CASCADE;
DROP TABLE IF EXISTS dhcp6_option_def CASCADE;
DROP TABLE IF EXISTS dhcp6_options_server CASCADE;
DROP TABLE IF EXISTS dhcp6_pool CASCADE;
DROP TABLE IF EXISTS dhcp6_pd_pool CASCADE;
DROP TABLE IF EXISTS dhcp6_subnet_server CASCADE;
DROP TABLE IF EXISTS dhcp6_subnet CASCADE;
DROP TABLE IF EXISTS dhcp6_shared_network_server CASCADE;
DROP TABLE IF EXISTS dhcp6_shared_network CASCADE;
DROP TABLE IF EXISTS dhcp6_global_parameter_server CASCADE;
DROP TABLE IF EXISTS dhcp6_global_parameter CASCADE;
DROP TABLE IF EXISTS dhcp6_server CASCADE;
DROP TABLE IF EXISTS dhcp6_audit_revision CASCADE;
DROP TABLE IF EXISTS dhcp6_client_class_server CASCADE;
DROP TABLE IF EXISTS dhcp6_client_class_dependency CASCADE;
DROP TABLE IF EXISTS dhcp6_client_class_order CASCADE;
DROP TABLE IF EXISTS dhcp6_client_class CASCADE;
-- drop trigger functions for DHCPv6
DROP FUNCTION IF EXISTS func_dhcp6_client_class_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_client_class_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_client_class_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_client_class_check_dependency_BINS();
DROP FUNCTION IF EXISTS func_dhcp6_client_class_dependency_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_pool_BDEL();
DROP FUNCTION IF EXISTS func_dhcp6_global_parameter_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_global_parameter_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_global_parameter_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_subnet_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_subnet_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_shared_network_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_shared_network_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_shared_network_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_option_def_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_option_def_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_option_def_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_options_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_options_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_options_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_server_AINS();
DROP FUNCTION IF EXISTS func_dhcp6_server_AUPD();
DROP FUNCTION IF EXISTS func_dhcp6_server_ADEL();
DROP FUNCTION IF EXISTS func_dhcp6_shared_network_BDEL();
DROP FUNCTION IF EXISTS func_dhcp6_subnet_BDEL();
DROP FUNCTION IF EXISTS func_dhcp6_pd_pool_BDEL();
-- config backend procedures for DHCPv4
DROP FUNCTION IF EXISTS createAuditRevisionDHCP4(audit_ts TIMESTAMP WITH TIME ZONE, server_tag VARCHAR(64),
audit_log_message TEXT, cascade_transaction BOOLEAN);
DROP FUNCTION IF EXISTS createAuditEntryDHCP4(object_type_val VARCHAR(256), object_id_val BIGINT,
modification_type_val VARCHAR(32));
DROP FUNCTION IF EXISTS createOptionAuditDHCP4(modification_type VARCHAR, scope_id SMALLINT,
option_id INT, subnet_id BIGINT, host_id INT,
network_name VARCHAR, pool_id BIGINT,
modification_ts TIMESTAMP WITH TIME ZONE);
DROP FUNCTION IF EXISTS setClientClass4Order(id BIGINT, follow_class_name VARCHAR(128),
old_follow_class_name VARCHAR(128));
DROP FUNCTION IF EXISTS checkDHCPv4ClientClassDependency(class_id BIGINT, dependency_id BIGINT);
DROP FUNCTION IF EXISTS updateDHCPv4ClientClassKnownDependency(client_class_id BIGINT,
dependency_id BIGINT);
DROP FUNCTION IF EXISTS checkDHCPv4ClientClassKnownDependencyChange();
-- config backend tables for DHCPv4
DROP TABLE IF EXISTS dhcp4_audit CASCADE;
DROP TABLE IF EXISTS dhcp4_option_def_server CASCADE;
DROP TABLE IF EXISTS dhcp4_option_def CASCADE;
DROP TABLE IF EXISTS dhcp4_options_server CASCADE;
DROP TABLE IF EXISTS dhcp4_pool CASCADE;
DROP TABLE IF EXISTS dhcp4_pd_pool CASCADE;
DROP TABLE IF EXISTS dhcp4_subnet_server CASCADE;
DROP TABLE IF EXISTS dhcp4_subnet CASCADE;
DROP TABLE IF EXISTS dhcp4_shared_network_server CASCADE;
DROP TABLE IF EXISTS dhcp4_shared_network CASCADE;
DROP TABLE IF EXISTS dhcp4_global_parameter_server CASCADE;
DROP TABLE IF EXISTS dhcp4_global_parameter CASCADE;
DROP TABLE IF EXISTS dhcp4_server CASCADE;
DROP TABLE IF EXISTS dhcp4_audit_revision CASCADE;
DROP TABLE IF EXISTS dhcp4_client_class_server CASCADE;
DROP TABLE IF EXISTS dhcp4_client_class_dependency CASCADE;
DROP TABLE IF EXISTS dhcp4_client_class_order CASCADE;
DROP TABLE IF EXISTS dhcp4_client_class CASCADE;
-- drop trigger functions for DHCPv4
DROP FUNCTION IF EXISTS func_dhcp4_client_class_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_client_class_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_client_class_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_client_class_check_dependency_BINS();
DROP FUNCTION IF EXISTS func_dhcp4_client_class_dependency_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_pool_BDEL();
DROP FUNCTION IF EXISTS func_dhcp4_global_parameter_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_global_parameter_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_global_parameter_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_subnet_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_subnet_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_shared_network_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_shared_network_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_shared_network_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_option_def_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_option_def_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_option_def_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_options_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_options_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_options_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_server_AINS();
DROP FUNCTION IF EXISTS func_dhcp4_server_AUPD();
DROP FUNCTION IF EXISTS func_dhcp4_server_ADEL();
DROP FUNCTION IF EXISTS func_dhcp4_shared_network_BDEL();
DROP FUNCTION IF EXISTS func_dhcp4_subnet_BDEL();
-- common tables for config backend
DROP TABLE IF EXISTS modification CASCADE;
DROP TABLE IF EXISTS parameter_data_type CASCADE;
DROP TABLE IF EXISTS ddns_replace_client_name_types CASCADE;
DROP FUNCTION IF EXISTS modification_ts_update();
DROP FUNCTION IF EXISTS get_session_boolean(name text);
DROP FUNCTION IF EXISTS get_session_big_int(name text);
DROP FUNCTION IF EXISTS get_session_value(name text);
DROP FUNCTION IF EXISTS set_session_value(name text, value TEXT);
DROP FUNCTION IF EXISTS set_session_value(name text, value BIGINT);
DROP FUNCTION IF EXISTS set_session_value(name text, value BOOLEAN);
DROP FUNCTION IF EXISTS lease4Upload(address VARCHAR, hwaddr VARCHAR,
client_id VARCHAR, valid_lifetime BIGINT, expire BIGINT, subnet_id BIGINT,
fqdn_fwd INT, fqdn_rev INT, hostname VARCHAR, state INT8,
user_context VARCHAR);
DROP FUNCTION IF EXISTS lease6Upload(address VARCHAR, duid VARCHAR,
valid_lifetime BIGINT, expire BIGINT, subnet_id BIGINT,
pref_lifetime BIGINT, lease_type INT, iaid INT, prefix_len INT,
fqdn_fwd INT, fqdn_rev INT, hostname VARCHAR, hwaddr VARCHAR,
state INT8, user_context VARCHAR, hwtype INT, hwaddr_source INT);
DROP FUNCTION IF EXISTS colonSeparatedHex(TEXT);
DROP FUNCTION IF EXISTS gmt_epoch(input_time TIMESTAMP WITH TIME ZONE);
-- lease limiting tables and functions
DROP TABLE IF EXISTS lease4_stat_by_client_class;
DROP TABLE IF EXISTS lease6_stat_by_client_class;
DROP FUNCTION IF EXISTS lease4_AINS_lease4_stat(new_state BIGINT,
new_subnet_id BIGINT);
DROP FUNCTION IF EXISTS lease4_AUPD_lease4_stat(old_state BIGINT,
old_subnet_id BIGINT, new_state BIGINT, new_subnet_id BIGINT);
DROP FUNCTION IF EXISTS lease4_ADEL_lease4_stat(old_state BIGINT,
old_subnet_id BIGINT);
DROP FUNCTION IF EXISTS lease6_AINS_lease6_stat(new_state BIGINT,
new_subnet_id BIGINT, new_lease_type SMALLINT);
DROP FUNCTION IF EXISTS lease6_AUPD_lease6_stat(old_state BIGINT,
old_subnet_id BIGINT, old_lease_type SMALLINT, new_state BIGINT,
new_subnet_id BIGINT, new_lease_type SMALLINT);
DROP FUNCTION IF EXISTS lease6_ADEL_lease6_stat(old_state BIGINT,
old_subnet_id BIGINT, old_lease_type SMALLINT);
DROP FUNCTION IF EXISTS lease4_AINS_lease4_stat_by_client_class(
new_state BIGINT, new_user_context TEXT);
DROP FUNCTION IF EXISTS lease4_AUPD_lease4_stat_by_client_class(
old_state BIGINT, old_user_context TEXT,
new_state BIGINT, new_user_context TEXT);
DROP FUNCTION IF EXISTS lease4_ADEL_lease4_stat_by_client_class(
old_state BIGINT, old_user_context TEXT);
DROP FUNCTION IF EXISTS lease6_AINS_lease6_stat_by_client_class(
new_state BIGINT, new_user_context TEXT, new_lease_type SMALLINT);
DROP FUNCTION IF EXISTS lease6_AUPD_lease6_stat_by_client_class(
old_state BIGINT, old_user_context TEXT, old_lease_type SMALLINT,
new_state BIGINT, new_user_context TEXT, new_lease_type SMALLINT);
DROP FUNCTION IF EXISTS lease6_ADEL_lease6_stat_by_client_class(
old_state BIGINT, old_user_context TEXT, old_lease_type SMALLINT);
DROP FUNCTION IF EXISTS func_lease4_AINS();
DROP FUNCTION IF EXISTS func_lease4_AUPD();
DROP FUNCTION IF EXISTS func_lease4_ADEL();
DROP FUNCTION IF EXISTS func_lease6_AINS();
DROP FUNCTION IF EXISTS func_lease6_AUPD();
DROP FUNCTION IF EXISTS func_lease6_ADEL();
DROP FUNCTION IF EXISTS checkLease4Limits(user_context TEXT);
DROP FUNCTION IF EXISTS checkLease6Limits(user_context TEXT);
DROP FUNCTION IF EXISTS isJsonSupported();
DROP FUNCTION IF EXISTS json_cast(json_candidate TEXT);
|
