source: subversion/sites/other/places/database.sql @ 3986

Last change on this file since 3986 was 1441, checked in by ojw, 13 years ago

Add SQL for creating the database

File size: 559 bytes
Line 
1CREATE TABLE `places2` (
2  `id` int(11) NOT NULL auto_increment,
3  `name` varchar(50) NOT NULL default '',
4  `type` varchar(20) NOT NULL default '',
5  `lat` float NOT NULL default '0',
6  `lon` float NOT NULL default '0',
7  `osm_size` float NOT NULL default '0' COMMENT 'KiB',
8  `osm_date` int(11) NOT NULL default '0' COMMENT 'days since epoch',
9  `img_exists` tinyint(4) NOT NULL default '0',
10  `renderer` varchar(20) NOT NULL default '' COMMENT 'username of person who last rendered the image',
11  PRIMARY KEY  (`id`)
12) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Note: See TracBrowser for help on using the repository browser.