This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
download_example_schema [2012/12/31 12:59] cruisefactory |
download_example_schema [2014/09/02 14:07] (current) cruisefactory |
||
---|---|---|---|
Line 482: | Line 482: | ||
`name` varchar(100) NOT NULL DEFAULT '', | `name` varchar(100) NOT NULL DEFAULT '', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | |||
+ | |||
+ | # Dump of table latlong | ||
+ | # ------------------------------------------------------------ | ||
+ | |||
+ | DROP TABLE IF EXISTS `latlong`; | ||
+ | |||
+ | CREATE TABLE `latlong` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `port_id` int(11) DEFAULT NULL, | ||
+ | `lat` float(10,6) DEFAULT NULL, | ||
+ | `long` float(10,6) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY `uniqueport` (`port_id`) | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||