CREATE TABLE IF NOT EXISTS `TRANSFORM_Table` ( `ID` int(10) NOT NULL auto_increment, `poiID` varchar(255) NOT NULL, `rel` tinyint(1) default ‘0’, `angle` decimal(5,2) default ‘0.00’, `scale` decimal(12,2) NOT NULL default ‘1.00’, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;