-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.13-rc-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema dbistag20112012
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ dbistag20112012;
USE dbistag20112012;

--
-- Table structure for table `dbistag20112012`.`departement`
--

DROP TABLE IF EXISTS `departement`;
CREATE TABLE `departement` (
  `CodeDepartement` varchar(10) NOT NULL default '',
  `CodeRegion` varchar(10) NOT NULL default '',
  `LibDepartement` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`CodeDepartement`,`CodeRegion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 75776 kB';

--
-- Dumping data for table `dbistag20112012`.`departement`
--

/*!40000 ALTER TABLE `departement` DISABLE KEYS */;
INSERT INTO `departement` (`CodeDepartement`,`CodeRegion`,`LibDepartement`) VALUES 
 ('BAMB','OU','BAMBOUTOS'),
 ('BEN','NO','BENOUE'),
 ('BOUM','EST','BOUMBA & GOKO'),
 ('BOY','EN','BOYO'),
 ('BUI','NOU','BUI'),
 ('DIAM','NO','DIAMARE'),
 ('DJA','SUD','DJA ET LOBO'),
 ('DJE','ADM','DJEREM'),
 ('DONG','NO','DONGA MANTUNG'),
 ('FAKO','SU','FAKO'),
 ('FAR','EN','FARO'),
 ('FARD','EN','FARO ET DEO'),
 ('HANY','EST','HAUT NYONG'),
 ('HAUSAN','CEN','HAUTE-SANAGA'),
 ('HAUTKAM','OU','HAUT-NKAM'),
 ('HAUTPLA','OU','HAUTS-PLATEAUX'),
 ('KAD','EN','KADEI'),
 ('KKHI','OU','KOUNG-KHI'),
 ('KOUPM','LT','KOUPE MANENGOUBA'),
 ('LEBIA','SU','LEBIALEM'),
 ('LEKIE','CE','LEKIE'),
 ('LOCH','EN','LOGONE ET CHARI'),
 ('LODJ','NO','LOM ET DJEREM'),
 ('MADAN','AD','MAYO DANAY'),
 ('MANYU','SU','MANYU'),
 ('MASA','EN','MAYO SAVA'),
 ('MAYK','NO','MAYO-KANI'),
 ('MAYLO','NO','MAYO-LOUTI'),
 ('MAYR','NO','MAYO-REY'),
 ('MAYT','EN','MAYO TSANAGA'),
 ('MBAMIN','CE','MBAM ET INOUBOU'),
 ('MBAMKEM','CE','MBAM ET KIM'),
 ('MBAN','AD','MAYO BANYO');
INSERT INTO `departement` (`CodeDepartement`,`CodeRegion`,`LibDepartement`) VALUES 
 ('MBE','AD','MBERE'),
 ('MEA','CE','MEFOU A KONO'),
 ('MEM','NO','MEME'),
 ('MEN','NO','MENTCHUM'),
 ('MENOUA','OU','MENOUA'),
 ('MEZ','NO','MEZAM'),
 ('MFA','CE','MEFOU ET  A FAMBA'),
 ('MFOUN','CE','MFOUNDI'),
 ('MIFI','OU','MIFI'),
 ('MOM','NO','MOMO'),
 ('MOUNG','LT','MOUNGO'),
 ('MVI','SU','MVILA'),
 ('NDE','OU','NDE'),
 ('NDIAN','NO','NDIAN'),
 ('NGOK','SUD','NGO-KETUNJIA'),
 ('NKAM','LT','NKAM'),
 ('NOUN','OU','NOUN'),
 ('NYOFOU','CE','NYONG ET FOUMOU'),
 ('NYOKE','CE','NYONG ET KELE'),
 ('NYOSO','CE','NYONG ET SOO'),
 ('OCE','SUD','OCEAN'),
 ('SANAGA','LT','SANAGA MARITIME'),
 ('VIN','AD','VINA'),
 ('VNTEM','SUD','VALLEE DU NTEM'),
 ('WOURI','LT','WOURI');
/*!40000 ALTER TABLE `departement` ENABLE KEYS */;


--
-- Table structure for table `dbistag20112012`.`region`
--

DROP TABLE IF EXISTS `region`;
CREATE TABLE `region` (
  `CodeRegion` varchar(10) NOT NULL default '',
  `LibRegion` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`CodeRegion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 6144 kB';

--
-- Dumping data for table `dbistag20112012`.`region`
--

/*!40000 ALTER TABLE `region` DISABLE KEYS */;
INSERT INTO `region` (`CodeRegion`,`LibRegion`) VALUES 
 ('AD','ADAMAOUA'),
 ('CE','CENTRE'),
 ('EN','EXTREME NORD'),
 ('ES','EST'),
 ('LT','LITTORAL'),
 ('NO','NORD'),
 ('NW','NORD OUEST'),
 ('OU','OUEST'),
 ('SU','SUD'),
 ('SW','SUD OUEST');
/*!40000 ALTER TABLE `region` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
