CREATE TABLE IF NOT EXISTS `ACTION_Table` (
`poiID` varchar(255) NOT NULL,
`label` varchar(30) NOT NULL,
`uri` varchar(255) NOT NULL,
`autoTriggerRange` int(10) default NULL,
`autoTriggerOnly` tinyint(1) default NULL,
`ID` int(10) NOT NULL,
`contentType` varchar(255) default ‘application/vnd.layar.internal’,
`method` enum(‘GET’,’POST’) default ‘GET’,
`activityType` int(2) default NULL,
`params` varchar(255) default NULL,
`closeBiw` tinyint(1) default ‘0’,
`showActivity` tinyint(1) default ‘1’,
`activityMessage` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;