|
From: <wis...@us...> - 2013-02-28 06:21:40
|
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. @@
|