-
Notifications
You must be signed in to change notification settings - Fork 2
/
uninstall_sphere.sql
299 lines (287 loc) · 12.8 KB
/
uninstall_sphere.sql
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
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
DROP FUNCTION IF EXISTS sdist;
DROP FUNCTION IF EXISTS sarea;
DROP FUNCTION IF EXISTS scenter;
DROP FUNCTION IF EXISTS scircum;
DROP FUNCTION IF EXISTS slength;
DROP FUNCTION IF EXISTS sswap;
DROP FUNCTION IF EXISTS snpoints;
DROP FUNCTION IF EXISTS sstr;
DROP FUNCTION IF EXISTS mysql_sphere_version;
DROP FUNCTION IF EXISTS srcontainsl;
DROP FUNCTION IF EXISTS slcontainsr;
DROP FUNCTION IF EXISTS srnotcontainsl;
DROP FUNCTION IF EXISTS slnotcontainsr;
DROP FUNCTION IF EXISTS soverlaps;
DROP FUNCTION IF EXISTS snotoverlaps;
DROP FUNCTION IF EXISTS sequal;
DROP FUNCTION IF EXISTS snotequal;
DROP FUNCTION IF EXISTS stransform;
DROP FUNCTION IF EXISTS sinverse;
DROP FUNCTION IF EXISTS spoint;
DROP FUNCTION IF EXISTS spoint_long;
DROP FUNCTION IF EXISTS spoint_lat;
DROP FUNCTION IF EXISTS spoint_x;
DROP FUNCTION IF EXISTS spoint_y;
DROP FUNCTION IF EXISTS spoint_z;
DROP FUNCTION IF EXISTS spoint_equal;
DROP FUNCTION IF EXISTS strans;
DROP FUNCTION IF EXISTS strans_point;
DROP FUNCTION IF EXISTS strans_point_inverse;
DROP FUNCTION IF EXISTS strans_equal;
DROP FUNCTION IF EXISTS strans_equal_neg;
DROP FUNCTION IF EXISTS strans_phi;
DROP FUNCTION IF EXISTS strans_theta;
DROP FUNCTION IF EXISTS strans_psi;
DROP FUNCTION IF EXISTS strans_axes;
DROP FUNCTION IF EXISTS strans_invert;
DROP FUNCTION IF EXISTS strans_zxz;
DROP FUNCTION IF EXISTS strans_trans;
DROP FUNCTION IF EXISTS strans_trans_inv;
DROP FUNCTION IF EXISTS scircle;
DROP FUNCTION IF EXISTS scircle_radius;
DROP FUNCTION IF EXISTS scircle_equal;
DROP FUNCTION IF EXISTS scircle_equal_neg;
DROP FUNCTION IF EXISTS scircle_overlap;
DROP FUNCTION IF EXISTS scircle_overlap_neg;
DROP FUNCTION IF EXISTS scircle_contained_by_circle;
DROP FUNCTION IF EXISTS scircle_contained_by_circle_neg;
DROP FUNCTION IF EXISTS scircle_contains_circle;
DROP FUNCTION IF EXISTS scircle_contains_circle_neg;
DROP FUNCTION IF EXISTS spoint_contained_by_circle;
DROP FUNCTION IF EXISTS spoint_contained_by_circle_neg;
DROP FUNCTION IF EXISTS spoint_contained_by_circle_com;
DROP FUNCTION IF EXISTS spoint_contained_by_circle_com_neg;
DROP FUNCTION IF EXISTS strans_circle;
DROP FUNCTION IF EXISTS strans_circle_inverse;
DROP FUNCTION IF EXISTS sline;
DROP FUNCTION IF EXISTS smeridian;
DROP FUNCTION IF EXISTS sline_beg;
DROP FUNCTION IF EXISTS sline_end;
DROP FUNCTION IF EXISTS sline_equal;
DROP FUNCTION IF EXISTS sline_equal_neg;
DROP FUNCTION IF EXISTS sline_turn;
DROP FUNCTION IF EXISTS sline_crosses;
DROP FUNCTION IF EXISTS sline_crosses_neg;
DROP FUNCTION IF EXISTS sline_overlap;
DROP FUNCTION IF EXISTS sline_contains_point;
DROP FUNCTION IF EXISTS sline_contains_point_com;
DROP FUNCTION IF EXISTS sline_contains_point_neg;
DROP FUNCTION IF EXISTS sline_contains_point_com_neg;
DROP FUNCTION IF EXISTS strans_line;
DROP FUNCTION IF EXISTS strans_line_inverse;
DROP FUNCTION IF EXISTS sline_overlap_circle;
DROP FUNCTION IF EXISTS sline_overlap_circle_com;
DROP FUNCTION IF EXISTS sline_overlap_circle_neg;
DROP FUNCTION IF EXISTS sline_overlap_circle_com_neg;
DROP FUNCTION IF EXISTS scircle_contains_line;
DROP FUNCTION IF EXISTS scircle_contains_line_com;
DROP FUNCTION IF EXISTS scircle_contains_line_neg;
DROP FUNCTION IF EXISTS scircle_contains_line_com_neg;
DROP FUNCTION IF EXISTS sellipse;
DROP FUNCTION IF EXISTS sellipse_inc;
DROP FUNCTION IF EXISTS sellipse_lrad;
DROP FUNCTION IF EXISTS sellipse_srad;
DROP FUNCTION IF EXISTS sellipse_equal;
DROP FUNCTION IF EXISTS sellipse_equal_neg;
DROP FUNCTION IF EXISTS sellipse_contains_ellipse;
DROP FUNCTION IF EXISTS sellipse_contains_ellipse_neg;
DROP FUNCTION IF EXISTS sellipse_contains_ellipse_com;
DROP FUNCTION IF EXISTS sellipse_contains_ellipse_com_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_ellipse;
DROP FUNCTION IF EXISTS sellipse_overlap_ellipse_neg;
DROP FUNCTION IF EXISTS sellipse_contains_point;
DROP FUNCTION IF EXISTS sellipse_contains_point_neg;
DROP FUNCTION IF EXISTS sellipse_contains_point_com;
DROP FUNCTION IF EXISTS sellipse_contains_point_com_neg;
DROP FUNCTION IF EXISTS sellipse_contains_circle;
DROP FUNCTION IF EXISTS sellipse_contains_circle_neg;
DROP FUNCTION IF EXISTS sellipse_contains_circle_com;
DROP FUNCTION IF EXISTS sellipse_contains_circle_com_neg;
DROP FUNCTION IF EXISTS scircle_contains_ellipse;
DROP FUNCTION IF EXISTS scircle_contains_ellipse_neg;
DROP FUNCTION IF EXISTS scircle_contains_ellipse_com;
DROP FUNCTION IF EXISTS scircle_contains_ellipse_com_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_circle;
DROP FUNCTION IF EXISTS sellipse_overlap_circle_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_circle_com;
DROP FUNCTION IF EXISTS sellipse_overlap_circle_com_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_line;
DROP FUNCTION IF EXISTS sellipse_overlap_line_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_line_com;
DROP FUNCTION IF EXISTS sellipse_overlap_line_com_neg;
DROP FUNCTION IF EXISTS sellipse_contains_line;
DROP FUNCTION IF EXISTS sellipse_contains_line_neg;
DROP FUNCTION IF EXISTS sellipse_contains_line_com;
DROP FUNCTION IF EXISTS sellipse_contains_line_com_neg;
DROP FUNCTION IF EXISTS strans_ellipse;
DROP FUNCTION IF EXISTS strans_ellipse_inverse;
DROP FUNCTION IF EXISTS spoly;
DROP FUNCTION IF EXISTS spoly_equal;
DROP FUNCTION IF EXISTS spoly_equal_neg;
DROP FUNCTION IF EXISTS spoly_contains_polygon;
DROP FUNCTION IF EXISTS spoly_contains_polygon_neg;
DROP FUNCTION IF EXISTS spoly_contains_polygon_com;
DROP FUNCTION IF EXISTS spoly_contains_polygon_com_neg;
DROP FUNCTION IF EXISTS spoly_overlap_polygon;
DROP FUNCTION IF EXISTS spoly_overlap_polygon_neg;
DROP FUNCTION IF EXISTS spoly_contains_point;
DROP FUNCTION IF EXISTS spoly_contains_point_neg;
DROP FUNCTION IF EXISTS spoly_contains_point_com;
DROP FUNCTION IF EXISTS spoly_contains_point_com_neg;
DROP FUNCTION IF EXISTS spoly_contains_circle;
DROP FUNCTION IF EXISTS spoly_contains_circle_neg;
DROP FUNCTION IF EXISTS spoly_contains_circle_com;
DROP FUNCTION IF EXISTS spoly_contains_circle_com_neg;
DROP FUNCTION IF EXISTS scircle_contains_polygon;
DROP FUNCTION IF EXISTS scircle_contains_polygon_neg;
DROP FUNCTION IF EXISTS scircle_contains_polygon_com;
DROP FUNCTION IF EXISTS scircle_contains_polygon_com_neg;
DROP FUNCTION IF EXISTS spoly_overlap_circle;
DROP FUNCTION IF EXISTS spoly_overlap_circle_neg;
DROP FUNCTION IF EXISTS spoly_overlap_circle_com;
DROP FUNCTION IF EXISTS spoly_overlap_circle_com_neg;
DROP FUNCTION IF EXISTS spoly_contains_line;
DROP FUNCTION IF EXISTS spoly_contains_line_neg;
DROP FUNCTION IF EXISTS spoly_contains_line_com;
DROP FUNCTION IF EXISTS spoly_contains_line_com_neg;
DROP FUNCTION IF EXISTS spoly_overlap_line;
DROP FUNCTION IF EXISTS spoly_overlap_line_neg;
DROP FUNCTION IF EXISTS spoly_overlap_line_com;
DROP FUNCTION IF EXISTS spoly_overlap_line_com_neg;
DROP FUNCTION IF EXISTS spoly_contains_ellipse;
DROP FUNCTION IF EXISTS spoly_contains_ellipse_neg;
DROP FUNCTION IF EXISTS spoly_contains_ellipse_com;
DROP FUNCTION IF EXISTS spoly_contains_ellipse_com_neg;
DROP FUNCTION IF EXISTS sellipse_contains_polygon;
DROP FUNCTION IF EXISTS sellipse_contains_polygon_neg;
DROP FUNCTION IF EXISTS sellipse_contains_polygon_com;
DROP FUNCTION IF EXISTS sellipse_contains_polygon_com_neg;
DROP FUNCTION IF EXISTS spoly_overlap_ellipse;
DROP FUNCTION IF EXISTS spoly_overlap_ellipse_neg;
DROP FUNCTION IF EXISTS spoly_overlap_ellipse_com;
DROP FUNCTION IF EXISTS spoly_overlap_ellipse_com_neg;
DROP FUNCTION IF EXISTS strans_poly;
DROP FUNCTION IF EXISTS strans_poly_inverse;
DROP FUNCTION IF EXISTS spoly_add_point_aggr;
DROP FUNCTION IF EXISTS spoly_aggr;
DROP FUNCTION IF EXISTS spath;
DROP FUNCTION IF EXISTS spath_equal;
DROP FUNCTION IF EXISTS spath_equal_neg;
DROP FUNCTION IF EXISTS spath_overlap_path;
DROP FUNCTION IF EXISTS spath_overlap_path_neg;
DROP FUNCTION IF EXISTS spath_contains_point;
DROP FUNCTION IF EXISTS spath_contains_point_neg;
DROP FUNCTION IF EXISTS spath_contains_point_com;
DROP FUNCTION IF EXISTS spath_contains_point_com_neg;
DROP FUNCTION IF EXISTS scircle_contains_path;
DROP FUNCTION IF EXISTS scircle_contains_path_neg;
DROP FUNCTION IF EXISTS scircle_contains_path_com;
DROP FUNCTION IF EXISTS scircle_contains_path_com_neg;
DROP FUNCTION IF EXISTS scircle_overlap_path;
DROP FUNCTION IF EXISTS scircle_overlap_path_neg;
DROP FUNCTION IF EXISTS scircle_overlap_path_com;
DROP FUNCTION IF EXISTS scircle_overlap_path_com_neg;
DROP FUNCTION IF EXISTS spath_overlap_line;
DROP FUNCTION IF EXISTS spath_overlap_line_neg;
DROP FUNCTION IF EXISTS spath_overlap_line_com;
DROP FUNCTION IF EXISTS spath_overlap_line_com_neg;
DROP FUNCTION IF EXISTS sellipse_contains_path;
DROP FUNCTION IF EXISTS sellipse_contains_path_neg;
DROP FUNCTION IF EXISTS sellipse_contains_path_com;
DROP FUNCTION IF EXISTS sellipse_contains_path_com_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_path;
DROP FUNCTION IF EXISTS sellipse_overlap_path_neg;
DROP FUNCTION IF EXISTS sellipse_overlap_path_com;
DROP FUNCTION IF EXISTS sellipse_overlap_path_com_neg;
DROP FUNCTION IF EXISTS spoly_contains_path;
DROP FUNCTION IF EXISTS spoly_contains_path_neg;
DROP FUNCTION IF EXISTS spoly_contains_path_com;
DROP FUNCTION IF EXISTS spoly_contains_path_com_neg;
DROP FUNCTION IF EXISTS spoly_overlap_path;
DROP FUNCTION IF EXISTS spoly_overlap_path_neg;
DROP FUNCTION IF EXISTS spoly_overlap_path_com;
DROP FUNCTION IF EXISTS spoly_overlap_path_com_neg;
DROP FUNCTION IF EXISTS strans_path;
DROP FUNCTION IF EXISTS strans_path_inverse;
DROP FUNCTION IF EXISTS spath_add_point_aggr;
DROP FUNCTION IF EXISTS spath_aggr;
DROP FUNCTION IF EXISTS sbox;
DROP FUNCTION IF EXISTS sbox_sw;
DROP FUNCTION IF EXISTS sbox_se;
DROP FUNCTION IF EXISTS sbox_nw;
DROP FUNCTION IF EXISTS sbox_ne;
DROP FUNCTION IF EXISTS sbox_equal;
DROP FUNCTION IF EXISTS sbox_equal_neg;
DROP FUNCTION IF EXISTS sbox_contains_box;
DROP FUNCTION IF EXISTS sbox_contains_box_neg;
DROP FUNCTION IF EXISTS sbox_contains_box_com;
DROP FUNCTION IF EXISTS sbox_contains_box_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_box;
DROP FUNCTION IF EXISTS sbox_overlap_box_neg;
DROP FUNCTION IF EXISTS sbox_contains_point;
DROP FUNCTION IF EXISTS sbox_contains_point_neg;
DROP FUNCTION IF EXISTS sbox_contains_point_com;
DROP FUNCTION IF EXISTS sbox_contains_point_com_neg;
DROP FUNCTION IF EXISTS sbox_contains_circle;
DROP FUNCTION IF EXISTS sbox_contains_circle_neg;
DROP FUNCTION IF EXISTS sbox_contains_circle_com;
DROP FUNCTION IF EXISTS sbox_contains_circle_com_neg;
DROP FUNCTION IF EXISTS scircle_contains_box;
DROP FUNCTION IF EXISTS scircle_contains_box_neg;
DROP FUNCTION IF EXISTS scircle_contains_box_com;
DROP FUNCTION IF EXISTS scircle_contains_box_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_circle;
DROP FUNCTION IF EXISTS sbox_overlap_circle_neg;
DROP FUNCTION IF EXISTS sbox_overlap_circle_com;
DROP FUNCTION IF EXISTS sbox_overlap_circle_com_neg;
DROP FUNCTION IF EXISTS sbox_contains_line;
DROP FUNCTION IF EXISTS sbox_contains_line_neg;
DROP FUNCTION IF EXISTS sbox_contains_line_com;
DROP FUNCTION IF EXISTS sbox_contains_line_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_line;
DROP FUNCTION IF EXISTS sbox_overlap_line_neg;
DROP FUNCTION IF EXISTS sbox_overlap_line_com;
DROP FUNCTION IF EXISTS sbox_overlap_line_com_neg;
DROP FUNCTION IF EXISTS sbox_contains_ellipse;
DROP FUNCTION IF EXISTS sbox_contains_ellipse_neg;
DROP FUNCTION IF EXISTS sbox_contains_ellipse_com;
DROP FUNCTION IF EXISTS sbox_contains_ellipse_com_neg;
DROP FUNCTION IF EXISTS sellipse_contains_box;
DROP FUNCTION IF EXISTS sellipse_contains_box_neg;
DROP FUNCTION IF EXISTS sellipse_contains_box_com;
DROP FUNCTION IF EXISTS sellipse_contains_box_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_ellipse;
DROP FUNCTION IF EXISTS sbox_overlap_ellipse_neg;
DROP FUNCTION IF EXISTS sbox_overlap_ellipse_com;
DROP FUNCTION IF EXISTS sbox_overlap_ellipse_com_neg;
DROP FUNCTION IF EXISTS sbox_contains_poly;
DROP FUNCTION IF EXISTS sbox_contains_poly_neg;
DROP FUNCTION IF EXISTS sbox_contains_poly_com;
DROP FUNCTION IF EXISTS sbox_contains_poly_com_neg;
DROP FUNCTION IF EXISTS spoly_contains_box;
DROP FUNCTION IF EXISTS spoly_contains_box_neg;
DROP FUNCTION IF EXISTS spoly_contains_box_com;
DROP FUNCTION IF EXISTS spoly_contains_box_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_poly;
DROP FUNCTION IF EXISTS sbox_overlap_poly_neg;
DROP FUNCTION IF EXISTS sbox_overlap_poly_com;
DROP FUNCTION IF EXISTS sbox_overlap_poly_com_neg;
DROP FUNCTION IF EXISTS sbox_contains_path;
DROP FUNCTION IF EXISTS sbox_contains_path_neg;
DROP FUNCTION IF EXISTS sbox_contains_path_com;
DROP FUNCTION IF EXISTS sbox_contains_path_com_neg;
DROP FUNCTION IF EXISTS sbox_overlap_path;
DROP FUNCTION IF EXISTS sbox_overlap_path_neg;
DROP FUNCTION IF EXISTS sbox_overlap_path_com;
DROP FUNCTION IF EXISTS sbox_overlap_path_com_neg;
USE mysql;
DELIMITER //
DROP PROCEDURE IF EXISTS UninstallPlugin;
CREATE PROCEDURE UninstallPlugin()
BEGIN
IF (SELECT 1 = 1 FROM mysql.plugin WHERE `name`='sphere') THEN UNINSTALL PLUGIN sphere;
END IF;
END //
DELIMITER ;
CALL UninstallPlugin();
DROP PROCEDURE UninstallPlugin;