CREATE TABLE `s_desc2` (
 `d2_code` int(2) NOT NULL,
 `d2_desc1` int(2) NOT NULL,
 `d2_desi` varchar(255) NOT NULL,
 PRIMARY KEY (`d2_code`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 
CREATE TABLE `s_refsanction` (
 `r_reflistid` int(11) NOT NULL,
 `r_codelist` int(4) NOT NULL,
 `r_year` int(4) NOT NULL,
 `r_month` varchar(3) NOT NULL,
 `r_day` int(2) NOT NULL,
 KEY `i_refsanction` (`r_reflistid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 
CREATE TABLE `s_idnumber` (
 `i_reflistid` int(11) NOT NULL,
 `i_code` varchar(5) CHARACTER SET utf8 NOT NULL,
 `i_desi` varchar(255) CHARACTER SET utf8 NOT NULL,
 `i_refnumber` varchar(20) CHARACTER SET utf8 NOT NULL,
 `i_datentlist` date NOT NULL,
 PRIMARY KEY (`i_reflistid`,`i_desi`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1