Gecko [ goons4good.org ]

Name	Size	Permission	Date
charsets	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
czech	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
danish	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
dutch	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
english	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
estonian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
french	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
german	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
greek	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
hindi	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
hungarian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
italian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
japanese	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
korean	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
mroonga	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
norwegian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
norwegian-ny	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
policy	[ DIR ]	drwxr-xr-x	2021-09-23 12:07
polish	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
portuguese	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
romanian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
russian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
serbian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
slovak	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
spanish	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
swedish	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
systemd	[ DIR ]	drwxr-xr-x	2021-09-23 12:07
ukrainian	[ DIR ]	drwxr-xr-x	2021-09-23 12:06
errmsg-utf8.txt	532.51 KB	-rw-r--r--	2021-08-02 06:58
fill_help_tables.sql	570.14 KB	-rw-r--r--	2021-08-02 06:58
install_spider.sql	22.77 KB	-rw-r--r--	2021-08-02 06:58
maria_add_gis_sp.sql	1.65 KB	-rw-r--r--	2021-08-09 09:53
maria_add_gis_sp_bootstrap.sql	1.63 KB	-rw-r--r--	2021-08-09 09:53
mysql_performance_tables.sql	1.91 KB	-rw-r--r--	2021-08-02 06:58
mysql_system_tables.sql	28.31 KB	-rw-r--r--	2021-08-02 06:58
mysql_system_tables_data.sql	3.56 KB	-rw-r--r--	2021-08-02 06:58
mysql_test_data_timezone.sql	10.17 KB	-rw-r--r--	2021-08-02 06:58
mysql_test_db.sql	1.63 KB	-rw-r--r--	2021-08-02 06:58
wsrep.cnf	3.39 KB	-rw-r--r--	2021-08-09 09:53
wsrep_notify	2.18 KB	-rwxr-xr-x	2021-08-09 09:53

Rename

-- Copyright (C) 2014 MariaDB Ab.
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; version 2 of the License.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA

# This part creates stored procedures required by the OpenGIS standards.
# script is prepared to be run with the --bootstrap server option

SET sql_mode='';

DROP PROCEDURE IF EXISTS AddGeometryColumn;
DROP PROCEDURE IF EXISTS DropGeometryColumn;

CREATE DEFINER=`root`@`localhost` PROCEDURE AddGeometryColumn(catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64), t_srid int) SQL SECURITY INVOKER
begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end ;

CREATE DEFINER=`root`@`localhost` PROCEDURE DropGeometryColumn(catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64)) SQL SECURITY INVOKER
begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end ;