MDEV-12 OpenGIS: create required tables: GeometryColumns, related views.

        Scripts added that create OpenGIS-required views and tables they're based upon.

2 files changed, 64 insertions, 0 deletions

diff --git a/scripts/maria_spatial_tables.sql b/scripts/maria_spatial_tables.sql
new file mode 100644
index 00000000000..e4a1dfcddb7
--- /dev/null
+++ b/scripts/maria_spatial_tables.sql
@@ -0,0 +1,36 @@
+-- Copyright (c) 2014, Monty Program Ab & SkySQL 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-1301  USA
+
+--
+-- The system tables of MySQL Server
+--
+
+set sql_mode='';
+DELETE FROM mysql.db WHERE Db='mariadb_spatial';
+DROP DATABASE IF EXISTS mariadb_spatial;
+CREATE DATABASE IF NOT EXISTS mariadb_spatial character set utf8;
+USE mariadb_spatial;
+
+CREATE TABLE IF NOT EXISTS reference_systems(id INT NOT NULL, alias_code INT NOT NULL, alias_name VARCHAR(80) binary DEFAULT '' NOT NULL, authority VARCHAR(256),  proj_def TEXT, PRIMARY KEY(id)) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Reference systems';
+
+CREATE TABLE IF NOT EXISTS columns (db char(64) binary DEFAULT '' NOT NULL, table_name char(64) binary DEFAULT '' NOT NULL, column_name char(64) binary DEFAULT '' NOT NULL, ref_system INT NOT NULL, wkb_geometry_type INT, dimension INT, UNIQUE (db, table_name, column_name))  engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Spatial columns';
+
+INSERT INTO mysql.db SET Host='%', Db='mariadb_spatial', Select_priv='Y';
+FLUSH PRIVILEGES;
+
+INSERT INTO reference_systems VALUES (-1, 0, "Unbound planar coordinates", "", "");
+INSERT INTO reference_systems VALUES ( 0, 0, "Unbound planar coordinates", "", "");
+INSERT INTO reference_systems VALUES (4326,4326,'WGS 84', 'EPSG','GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]');
+
diff --git a/scripts/maria_spatial_views.sql b/scripts/maria_spatial_views.sql
new file mode 100644
index 00000000000..01371137e36
--- /dev/null
+++ b/scripts/maria_spatial_views.sql
@@ -0,0 +1,28 @@
+-- Copyright (c) 2014, Monty Program Ab & SkySQL 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-1301  USA
+
+--
+-- The system tables of MySQL Server
+--
+
+set sql_mode='';
+
+DROP VIEW IF EXISTS SPATIAL_REF_SYS;
+DROP VIEW IF EXISTS GEOMETRY_COLUMNS;
+
+CREATE VIEW SPATIAL_REF_SYS AS SELECT id as SRID, authority as AUTH_NAME, alias_code as AUTH_SRID, proj_def as SRTEXT FROM mariadb_spatial.reference_systems;
+
+CREATE VIEW GEOMETRY_COLUMNS AS SELECT '' as F_TABLE_CATALOG, db as F_TABLE_SCHEMA, table_name as F_TABLE_NAME, column_name as F_GEOMETRY_COLUMN, '' as G_TABLE_CATALOG, db as G_TABLE_SCHEMA, table_name as G_TABLE_NAME, column_name as G_GEOMETRY_COLUMN, 1 as STORAGE_TYPE, wkb_geometry_type as GEOMETRY_TYPE, dimension as COORD_DIMENSION, NULL as MAX_PPR, ref_system as SRID from mariadb_spatial.columns;
+