Sample table dump:
---
CREATE TABLE `sector` (
`ID` int(11) NOT NULL auto_increment,
`Code` varchar(50) collate utf8_bin NOT NULL default '',
`Location` varchar(250) collate utf8_bin NOT NULL default '',
`Tel` varchar(50) collate utf8_bin NOT NULL default '',
UNIQUE KEY `ID` (`ID`),
UNIQUE KEY `Code` (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16 ;
---
mi.ini file is in attachment
|