-- MySQL dump 10.13  Distrib 5.5.31, for Win64 (x86)
--
-- Host: localhost    Database: diatag3
-- ------------------------------------------------------
-- Server version	5.5.31-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `abreviation`
--

DROP TABLE IF EXISTS `abreviation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abreviation` (
  `nom` varchar(50) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abreviation`
--

LOCK TABLES `abreviation` WRITE;
/*!40000 ALTER TABLE `abreviation` DISABLE KEYS */;
INSERT INTO `abreviation` VALUES ('dr\r'),('m\r'),('mm\r'),('p\r'),('pp\r'),('pr\r');
/*!40000 ALTER TABLE `abreviation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `elide`
--

DROP TABLE IF EXISTS `elide`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `elide` (
  `nom` varchar(50) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `elide`
--

LOCK TABLES `elide` WRITE;
/*!40000 ALTER TABLE `elide` DISABLE KEYS */;
INSERT INTO `elide` VALUES ('d'),('j'),('jusqu'),('l'),('lorsqu'),('m'),('n'),('puisqu'),('qu'),('quoiqu'),('s'),('t');
/*!40000 ALTER TABLE `elide` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `extension_domaine_url`
--

DROP TABLE IF EXISTS `extension_domaine_url`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `extension_domaine_url` (
  `nom` varchar(10) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `extension_domaine_url`
--

LOCK TABLES `extension_domaine_url` WRITE;
/*!40000 ALTER TABLE `extension_domaine_url` DISABLE KEYS */;
INSERT INTO `extension_domaine_url` VALUES ('ac'),('ad'),('ae'),('aero'),('af'),('ag'),('ai'),('al'),('am'),('an'),('ao'),('aq'),('ar'),('as'),('at'),('au'),('aw'),('ax'),('az'),('ba'),('bb'),('bd'),('be'),('bf'),('bg'),('bh'),('bi'),('biz'),('bj'),('bm'),('bn'),('bo'),('br'),('bs'),('bt'),('bv'),('bw'),('by'),('bz'),('ca'),('cc'),('cd'),('cf'),('cg'),('ch'),('ci'),('ck'),('cl'),('cm'),('cn'),('co'),('com'),('coop'),('cr'),('cs'),('cu'),('cv'),('cx'),('cy'),('cz'),('de'),('dj'),('dk'),('dm'),('do'),('dz'),('ec'),('edu'),('ee'),('eg'),('eh'),('er'),('es'),('et'),('eu'),('fi'),('fj'),('fk'),('fm'),('fo'),('fr'),('ga'),('gb'),('gd'),('ge'),('gf'),('gg'),('gh'),('gi'),('gl'),('gm'),('gn'),('gov'),('gp'),('gq'),('gr'),('gs'),('gt'),('gu'),('gw'),('gy'),('hk'),('hm'),('hn'),('hr'),('ht'),('hu'),('id'),('ie'),('il'),('im'),('in'),('info'),('int'),('io'),('iq'),('ir'),('is'),('it'),('je'),('jm'),('jo'),('jp'),('ke'),('kg'),('kh'),('ki'),('km'),('kn'),('kp'),('kr'),('kw'),('ky'),('kz'),('la'),('lb'),('lc'),('li'),('lk'),('lr'),('ls'),('lt'),('lu'),('lv'),('ly'),('ma'),('mc'),('md'),('mg'),('mh'),('mil'),('mk'),('ml'),('mm'),('mn'),('mo'),('mp'),('mq'),('mr'),('ms'),('mt'),('mu'),('museum'),('mv'),('mw'),('mx'),('my'),('mz'),('na'),('name'),('nc'),('ne'),('net'),('nf'),('ng'),('ni'),('nl'),('no'),('np'),('nr'),('nu'),('nz'),('om'),('org'),('pa'),('pe'),('pf'),('pg'),('ph'),('pk'),('pl'),('pm'),('pn'),('pr'),('pro'),('ps'),('pt'),('pw'),('py'),('qa'),('re'),('ro'),('ru'),('rw'),('sa'),('sb'),('sc'),('sd'),('se'),('sg'),('sh'),('si'),('sj'),('sk'),('sl'),('sm'),('sn'),('so'),('sr'),('st'),('sv'),('sy'),('sz'),('tc'),('td'),('tf'),('tg'),('th'),('tj'),('tk'),('tl'),('tm'),('tn'),('to'),('tp'),('tr'),('tt'),('tv'),('tw'),('tz'),('ua'),('ug'),('uk'),('um'),('us'),('uy'),('uz'),('va'),('vc'),('ve'),('vg'),('vi'),('vn'),('vu'),('wf'),('ws'),('ye'),('yt'),('yu'),('za'),('zm'),('zw');
/*!40000 ALTER TABLE `extension_domaine_url` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `postclit`
--

DROP TABLE IF EXISTS `postclit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `postclit` (
  `nom` varchar(50) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `postclit`
--

LOCK TABLES `postclit` WRITE;
/*!40000 ALTER TABLE `postclit` DISABLE KEYS */;
INSERT INTO `postclit` VALUES ('ci\r'),('elle\r'),('elles\r'),('en\r'),('il\r'),('ils\r'),('je\r'),('l\'en\r'),('l-en\r'),('la\r'),('la-leur\r'),('la-lui\r'),('la-moi\r'),('la-nous\r'),('la-vous\r'),('là \r'),('le\r'),('le-leur\r'),('le-lui\r'),('le-moi\r'),('le-nous\r'),('le-vous\r'),('les\r'),('les-en\r'),('les-leur\r'),('les-lui\r'),('les-moi\r'),('les-nous\r'),('les-vous\r'),('leur\r'),('lui\r'),('m\'en\r'),('m-en\r'),('moi\r'),('nous\r'),('nous-en\r'),('on\r'),('t\'elle\r'),('t\'en\r'),('t\'il\r'),('t\'on\r'),('t-elle\r'),('t-en\r'),('t-il\r'),('t-on\r'),('toi\r'),('tu\r'),('vous\r'),('vous-en\r'),('y\r');
/*!40000 ALTER TABLE `postclit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projets`
--

DROP TABLE IF EXISTS `projets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projets` (
  `proj_cle` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `proj_nom` varchar(45) COLLATE latin1_general_cs NOT NULL,
  `proj_adr_abs` varchar(255) COLLATE latin1_general_cs DEFAULT NULL,
  `proj_type_date` tinyint(2) NOT NULL,
  `proj_etat` tinyint(2) NOT NULL,
  PRIMARY KEY (`proj_cle`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projets`
--

LOCK TABLES `projets` WRITE;
/*!40000 ALTER TABLE `projets` DISABLE KEYS */;
INSERT INTO `projets` VALUES (35,'fables','fichier',0,1);
/*!40000 ALTER TABLE `projets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uta_type`
--

DROP TABLE IF EXISTS `uta_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uta_type` (
  `uta_t_cle` int(3) NOT NULL,
  `uta_t_long` varchar(45) COLLATE latin1_general_cs NOT NULL,
  `uta_t_court` varchar(20) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`uta_t_cle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uta_type`
--

LOCK TABLES `uta_type` WRITE;
/*!40000 ALTER TABLE `uta_type` DISABLE KEYS */;
INSERT INTO `uta_type` VALUES (0,'UTA_MOT_COMM_MAJ','\r'),(1,'UTA_MOT_COMM_MIN','\r'),(2,'UTA_ESPACE','\r'),(3,'UTA_TAB','\r'),(4,'UTA_FIN_LIGNE','\r'),(5,'UTA_NON_IDENTIFIE','\r'),(6,'UTA_PONCTUATION','\r'),(7,'UTA_SIGLE','\r'),(8,'UTA_MAIL','\r'),(9,'UTA_URL','\r'),(10,'UTA_MATH','\r'),(11,'UTA_NON_ISO','\r'),(12,'UTA_MOT_SPECIAL','\r'),(13,'UTA_ABREVIATION','\r'),(14,'UTA_DATE','\r'),(15,'UTA_COMMENTAIRE','\r'),(16,'UTA_NOMBRE','\r'),(17,'UTA_NUMERO','\r');
/*!40000 ALTER TABLE `uta_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2013-05-29 14:01:27
