topical media & game development
#mobile-ar-7-1.txt / txt
CREATE TABLE IF NOT EXISTS `POI_Table` (
`id` varchar(255) NOT NULL,
`attribution` varchar(150) default NULL,
`title` varchar(150) NOT NULL,
`lat` decimal(20,10) NOT NULL,
`lon` decimal(20,10) NOT NULL,
`imageURL` varchar(255) default NULL,
`line4` varchar(150) default NULL,
`line3` varchar(150) default NULL,
`line2` varchar(150) default NULL,
`type` int(11) default '0',
`dimension` int(1) default '1',
`alt` int(10) default NULL,
`relativeAlt` int(10) default NULL,
`distance` decimal(20,10) NOT NULL,
`inFocus` tinyint(1) default '0',
`doNotIndex` tinyint(1) default '0',
`showSmallBiw` tinyint(1) default '1',
`showBiwOnClick` tinyint(1) default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
(C) Æliens
04/09/2009
You may not copy or print any of this material without explicit permission of the author or the publisher.
In case of other copyright issues, contact the author.