topical media & game development

talk show tell print

#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.