[xoops-svn] SF.net SVN: xoops-svn:[11121] ThirdParty

[<wis...@us...>]

Revision: 11121
          http://sourceforge.net/p/xoops/svn/11121
Author:   wishcraft
Date:     2013-02-28 06:21:34 +0000 (Thu, 28 Feb 2013)
Log Message:
-----------
debauchosity.sql - Relaying of the core osity group nanotech grid (Good for geospatial)

Added Paths:
-----------
    ThirdParty/geospatial/
    ThirdParty/geospatial/Nanotech System (Chronolabs)/
    ThirdParty/geospatial/Nanotech System (Chronolabs)/debauchosity.sql

Added: ThirdParty/geospatial/Nanotech System (Chronolabs)/debauchosity.sql
===================================================================
--- ThirdParty/geospatial/Nanotech System (Chronolabs)/debauchosity.sql	                        (rev 0)
+++ ThirdParty/geospatial/Nanotech System (Chronolabs)/debauchosity.sql	2013-02-28 06:21:34 UTC (rev 11121)
@@ -0,0 +1,6140 @@
+/*
+SQLyog Community v10.51 
+MySQL - 5.1.67-community : Database - debauchosity
+*********************************************************************
+*/
+
+
+/*!40101 SET NAMES utf8 */;
+
+/*!40101 SET SQL_MODE=''*/;
+
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/`debauchosity` /*!40100 DEFAULT CHARACTER SET utf8 */;
+
+/*Table structure for table `albania` */
+
+DROP TABLE IF EXISTS `albania`;
+
+CREATE TABLE `albania` (
+  `CordID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `CountryID` int(11) DEFAULT NULL,
+  `RegionName` char(44) DEFAULT NULL,
+  `mapref_latitude` char(4) DEFAULT NULL,
+  `mapref_longitude` char(4) DEFAULT NULL,
+  `Latitude_Float` float DEFAULT NULL,
+  `Longitude_Float` float DEFAULT NULL,
+  `Altitude_Feet` int(11) DEFAULT NULL,
+  `Altitude_Meters` int(11) DEFAULT NULL,
+  PRIMARY KEY (`CordID`),
+  KEY `SEARCH` (`CountryID`,`RegionName`(22),`mapref_latitude`(3),`mapref_longitude`(3),`Latitude_Float`,`Longitude_Float`),
+  KEY `NUMBERS` (`Latitude_Float`,`Longitude_Float`,`Altitude_Feet`,`Altitude_Meters`)
+) ENGINE=InnoDB AUTO_INCREMENT=13052 DEFAULT CHARSET=utf8;
+
+/*Data for the table `albania` */
+
+LOCK TABLES `albania` WRITE;
+

@@ Diff output truncated at 100000 characters. @@