CREATE TABLE `tl_rado_store` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `lid` int(10) unsigned NOT NULL default '0',
  `language` varchar(2) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `level` int(1) NOT NULL default '3',
  `distributor` char(1) NOT NULL default '',
  `store` char(1) NOT NULL default '',
  `serviceCenter` char(1) NOT NULL default '',
  `official` char(1) NOT NULL default '',
  `addImage` char(1) NOT NULL default '',
  `singleSRC` varchar(255) NOT NULL default '',
  `phone` varchar(16) NOT NULL default '',
  `fax` varchar(16) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `website` varchar(255) NOT NULL default '',
  `openingHours` text NULL,
  `address` text NULL,
  `city` varchar(64) NOT NULL default '',
  `subdivision` varchar(10) NOT NULL default '',
  `country` varchar(2) NOT NULL default '',
  `longitude` varchar(10) NOT NULL default '',
  `latitude` varchar(10) NOT NULL default '',
  `featured` char(1) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `lid` (`lid`, `store`),
  KEY `published` (`published`, `lid`, `store`),
  KEY `country` (`country`, `subdivision`, `city`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;