topical media & game development

talk show tell print

#mobile-ar-8-1.txt / txt



  CREATE TABLE IF NOT EXISTS `POI_RealEstate_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’,
  `Radiolist` enum(‘sale’,’rent’) default ‘sale’,
  `Checkbox` enum(‘1’,’2’) default NULL,
  `Custom_Slider` int(7) default NULL,
  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.