GDN DATA SQL TABLE SCHEMA

gdn_datapoint_schema.sql

CREATE TABLE `datapoints` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `lineid` varchar(255) DEFAULT NULL,
  `geolocation` point DEFAULT NULL,
  `price` float NOT NULL,
  `currency` varchar(20) NOT NULL DEFAULT '',
  `locname` text DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;