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;