-- MySQL dump 10.13  Distrib 8.0.15, for Win64 (x86_64)
--
-- Host: localhost    Database: quimperle
-- ------------------------------------------------------
-- Server version	8.0.15

/*!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 */;
 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 `f_adr`
--

DROP TABLE IF EXISTS `f_adr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_adr` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_adr` varchar(19) DEFAULT '',
  `x_etat` varchar(1) DEFAULT '',
  `x_format` varchar(10) DEFAULT '',
  `x_nb_div` int(11) DEFAULT '0',
  `x_classe` varchar(1) DEFAULT '',
  `x_dim_x` int(11) DEFAULT '0',
  `x_dim_y` int(11) DEFAULT '0',
  `x_princ` tinyint(1) DEFAULT '0',
  `x_adr_topo` varchar(19) DEFAULT '',
  `x_mag` varchar(3) DEFAULT '',
  `x_contenant` varchar(20) NOT NULL DEFAULT '',
  `x_serial` varchar(20) NOT NULL DEFAULT '',
  `x_bloque` tinyint(1) NOT NULL DEFAULT '0',
  `x_emplacement` varchar(20) DEFAULT '',
  `x_service` tinyint(1) DEFAULT '0',
  `x_qte_posage` int(11) DEFAULT '0',
  `x_nouv_qte_posage` int(11) DEFAULT '0',
  `x_nouv_emplacement` varchar(20) DEFAULT '',
  `x_stup` tinyint(1) DEFAULT '0',
  `x_bloque_reappro` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_adr` (`x_adr`),
  KEY `x_mag` (`x_mag`),
  KEY `x_contenant` (`x_contenant`),
  KEY `x_serial` (`x_serial`)
) ENGINE=InnoDB AUTO_INCREMENT=24415 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_annuaire`
--

DROP TABLE IF EXISTS `f_annuaire`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_annuaire` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_server` varchar(128) DEFAULT NULL,
  `x_port` int(11) DEFAULT NULL,
  `x_dn` varchar(256) DEFAULT NULL,
  `x_user` varchar(64) DEFAULT NULL,
  `x_pass` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Annuaire LDAP ou active directory';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_badge`
--

DROP TABLE IF EXISTS `f_badge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_badge` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_machine` varchar(20) NOT NULL DEFAULT '',
  `x_message` varchar(100) NOT NULL DEFAULT '',
  `x_etat` tinyint(1) NOT NULL DEFAULT '0',
  `x_transmis` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_user` (`x_user`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_machine` (`x_machine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_badge_message`
--

DROP TABLE IF EXISTS `f_badge_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_badge_message` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_message` varchar(100) NOT NULL DEFAULT '',
  `x_actif` tinyint(1) NOT NULL DEFAULT '1',
  `x_ordre` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_compteur`
--

DROP TABLE IF EXISTS `f_compteur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_compteur` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_cle` varchar(20) NOT NULL DEFAULT '',
  `x_val` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_cle` (`x_cle`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_config`
--

DROP TABLE IF EXISTS `f_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_config` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_id` varchar(10) DEFAULT '',
  `x_poste` varchar(20) DEFAULT '',
  `x_cle` varchar(100) DEFAULT '',
  `x_prop` varchar(100) DEFAULT '',
  `x_type` varchar(1) DEFAULT '',
  `x_val` varchar(200) DEFAULT '',
  `x_lib_tree` varchar(100) DEFAULT '',
  `x_chp_type` varchar(5) DEFAULT '',
  `x_chp_info` varchar(50) DEFAULT '',
  `x_ordre` int(11) DEFAULT '0',
  `x_prive` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_poste` (`x_poste`,`x_cle`,`x_prop`)
) ENGINE=InnoDB AUTO_INCREMENT=1373 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_config_aff`
--

DROP TABLE IF EXISTS `f_config_aff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_config_aff` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_id` varchar(10) NOT NULL DEFAULT '',
  `x_poste` varchar(20) NOT NULL DEFAULT '',
  `x_cle` varchar(100) NOT NULL DEFAULT '',
  `x_prop` varchar(100) NOT NULL DEFAULT '',
  `x_type` varchar(1) NOT NULL DEFAULT '',
  `x_val` varchar(200) NOT NULL DEFAULT '',
  `x_lib_tree` varchar(100) NOT NULL DEFAULT '',
  `x_chp_type` varchar(5) NOT NULL DEFAULT '',
  `x_chp_info` varchar(50) NOT NULL DEFAULT '',
  `x_ordre` int(11) NOT NULL DEFAULT '0',
  `x_prive` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_poste` (`x_poste`,`x_cle`,`x_prop`)
) ENGINE=InnoDB AUTO_INCREMENT=1893 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_defaut`
--

DROP TABLE IF EXISTS `f_defaut`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_defaut` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_valeur` int(11) NOT NULL DEFAULT '0',
  `x_libelle` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_valeur` (`x_valeur`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_dest`
--

DROP TABLE IF EXISTS `f_dest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_dest` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_dest` varchar(30) DEFAULT '',
  `x_lib_dest` varchar(50) DEFAULT '',
  `x_ordre` int(11) DEFAULT '0',
  `x_ug` varchar(10) DEFAULT '',
  `x_resp_serv` varchar(30) DEFAULT '',
  `x_cadre_sup` varchar(30) DEFAULT '',
  `x_cr` varchar(10) DEFAULT '',
  `x_lib_cr` varchar(60) DEFAULT '',
  `x_pole` varchar(30) NOT NULL DEFAULT '',
  `x_nb_cde` int(11) NOT NULL DEFAULT '0',
  `x_nb_bu` int(11) NOT NULL DEFAULT '0',
  `x_nb_item_bu` int(11) NOT NULL DEFAULT '0',
  `x_type_peigne` int(11) NOT NULL DEFAULT '0',
  `x_moment_deb` varchar(35) NOT NULL DEFAULT '0',
  `x_deb_matin` int(11) NOT NULL DEFAULT '6',
  `x_deb_midi` int(11) NOT NULL DEFAULT '11',
  `x_deb_soir` int(11) NOT NULL DEFAULT '14',
  `x_deb_coucher` int(11) NOT NULL DEFAULT '20',
  `x_type_dest` varchar(10) NOT NULL DEFAULT 'SERVICE',
  `x_tri` varchar(20) NOT NULL DEFAULT '',
  `x_optim_peigne` tinyint(1) NOT NULL DEFAULT '0',
  `x_nb_jour` smallint(6) DEFAULT '0',
  `x_tri_jour` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_dest` (`x_dest`)
) ENGINE=InnoDB AUTO_INCREMENT=828 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_domaine`
--

DROP TABLE IF EXISTS `f_domaine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_domaine` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_domaine` varchar(10) NOT NULL DEFAULT '',
  `x_lib_domaine` varchar(160) NOT NULL DEFAULT '',
  `x_fact` varchar(30) NOT NULL DEFAULT '',
  `x_g_controle` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_dot`
--

DROP TABLE IF EXISTS `f_dot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_dot` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_dest` varchar(30) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte` float(15,3) DEFAULT '0.000',
  `x_id` int(11) DEFAULT '0',
  `x_local` varchar(19) DEFAULT '',
  `x_dot` varchar(35) DEFAULT '',
  `x_fam_ref` varchar(10) DEFAULT '',
  `x_fusion` varchar(35) NOT NULL DEFAULT '',
  `x_comment` varchar(150) DEFAULT '',
  `x_g_plein_vide` tinyint(1) NOT NULL DEFAULT '0',
  `x_type_bac` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_dest` (`x_dest`),
  KEY `x_dot` (`x_dot`),
  KEY `x_ref` (`x_ref`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_dot_dem`
--

DROP TABLE IF EXISTS `f_dot_dem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_dot_dem` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_dot` varchar(45) NOT NULL DEFAULT '',
  `x_pk_dot` int(11) NOT NULL DEFAULT '0',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_qte_dem` float(15,3) NOT NULL DEFAULT '0.000',
  `x_cor` tinyint(4) NOT NULL DEFAULT '0',
  `x_commentaire_web` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `user_dot` (`x_user`,`x_dot`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_dotechu`
--

DROP TABLE IF EXISTS `f_dotechu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_dotechu` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_dest` varchar(30) DEFAULT '',
  `x_jour` int(11) DEFAULT '0',
  `x_heure` time DEFAULT '00:00:00',
  `x_dot` varchar(35) DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM AUTO_INCREMENT=204 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_espace`
--

DROP TABLE IF EXISTS `f_espace`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_espace` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_poste` varchar(20) DEFAULT '',
  `x_mag` varchar(3) DEFAULT '',
  `x_alloc` tinyint(1) DEFAULT '0',
  `x_service` tinyint(1) DEFAULT '0',
  `x_gest` varchar(20) DEFAULT '',
  `x_sub_gest` varchar(1) DEFAULT '',
  `x_pos_aff` int(11) DEFAULT '0',
  `x_id_mag` varchar(3) DEFAULT '',
  `x_bouche` varchar(1) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_poste` (`x_poste`,`x_mag`),
  KEY `x_mag` (`x_mag`)
) ENGINE=InnoDB AUTO_INCREMENT=1490 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_etat_al`
--

DROP TABLE IF EXISTS `f_etat_al`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_etat_al` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_code` varchar(50) NOT NULL DEFAULT '',
  `x_etat_courant` int(11) NOT NULL DEFAULT '0',
  `x_etat_etablis` int(11) NOT NULL DEFAULT '0',
  `x_ack` tinyint(1) NOT NULL DEFAULT '0',
  `x_user_ack` varchar(20) NOT NULL DEFAULT '',
  `x_type_al` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_code` (`x_code`),
  KEY `x_etat_etablis` (`x_etat_etablis`),
  KEY `x_etat_courant` (`x_etat_courant`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_fam`
--

DROP TABLE IF EXISTS `f_fam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_fam` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_fam` varchar(10) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_fam` (`x_fam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_famfor`
--

DROP TABLE IF EXISTS `f_famfor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_famfor` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_fam` varchar(10) DEFAULT '',
  `x_format` varchar(10) DEFAULT '',
  `x_ordre` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_fam` (`x_fam`,`x_format`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_format`
--

DROP TABLE IF EXISTS `f_format`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_format` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_format` varchar(10) DEFAULT '',
  `x_dim_x` int(11) DEFAULT '0',
  `x_dim_y` int(11) DEFAULT '0',
  `x_orient` varchar(1) DEFAULT '',
  `x_nb_div` int(11) DEFAULT '0',
  `x_couleur` int(11) DEFAULT '0',
  `x_mm_x` int(11) DEFAULT '0',
  `x_mm_y` int(11) DEFAULT '0',
  `x_type_bac` varchar(10) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_format` (`x_format`)
) ENGINE=InnoDB AUTO_INCREMENT=425 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_four`
--

DROP TABLE IF EXISTS `f_four`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_four` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_four` varchar(20) DEFAULT '',
  `x_societe` varchar(30) DEFAULT '',
  `x_adresse` varchar(50) DEFAULT '',
  `x_cp` varchar(5) DEFAULT '',
  `x_ville` varchar(20) DEFAULT '',
  `x_pays` varchar(20) DEFAULT '',
  `x_pers_1` varchar(30) DEFAULT '',
  `x_pers_2` varchar(30) DEFAULT '',
  `x_tel_1` varchar(20) DEFAULT '',
  `x_fax_1` varchar(20) DEFAULT '',
  `x_port_1` varchar(20) DEFAULT '',
  `x_email_1` varchar(10) DEFAULT '',
  `x_siren` varchar(25) DEFAULT '',
  `x_siret` varchar(25) DEFAULT '',
  `x_code_cli` varchar(20) DEFAULT '',
  `x_delai` int(10) unsigned DEFAULT '0',
  `x_mini_cde` float(15,3) DEFAULT '0.000',
  `x_franco` float(15,3) DEFAULT '0.000',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_four` (`x_four`),
  KEY `x_four_2` (`x_four`)
) ENGINE=InnoDB AUTO_INCREMENT=4584 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_gpao`
--

DROP TABLE IF EXISTS `f_gpao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_gpao` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  `x_poste` varchar(20) DEFAULT '',
  `x_etat` varchar(1) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte` float(15,3) DEFAULT '0.000',
  `x_admin` varchar(10) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_qte_avant` float(15,3) DEFAULT '0.000',
  `x_qte_apres` float(15,3) DEFAULT '0.000',
  `x_type_mvt` varchar(1) DEFAULT '',
  `x_liste` varchar(60) DEFAULT '',
  `x_dest` varchar(30) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_item` varchar(40) DEFAULT '',
  `x_indice` int(11) DEFAULT '0',
  `x_sequence` varchar(25) DEFAULT '',
  `x_num_mag` varchar(5) DEFAULT '',
  `x_interface` varchar(15) NOT NULL DEFAULT '',
  `x_demandeur` varchar(1) DEFAULT '',
  `x_info` varchar(80) DEFAULT '',
  `x_exporte` tinyint(1) DEFAULT '0',
  `x_date_dem` varchar(8) DEFAULT '',
  `x_heure_dem` varchar(8) DEFAULT '',
  `x_num_dem` float(12,0) DEFAULT '0',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_cip` varchar(20) NOT NULL DEFAULT '',
  `x_desig` varchar(100) DEFAULT '',
  `x_qte_dem` float(15,3) DEFAULT '0.000',
  `x_qte_disp` float(15,3) DEFAULT '0.000',
  `x_unite` varchar(5) DEFAULT '',
  `x_lib_unite` varchar(20) DEFAULT '',
  `x_typ_dem` varchar(2) DEFAULT '',
  `x_id_pilulier` varchar(40) NOT NULL DEFAULT '',
  `x_case` int(11) NOT NULL DEFAULT '0',
  `x_solde` int(11) NOT NULL DEFAULT '0',
  `x_tperemp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_item_wms` int(11) DEFAULT '0',
  `x_tenvoi` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_serial` varchar(20) NOT NULL DEFAULT '',
  `xx_type_mvt_bte` varchar(3) NOT NULL DEFAULT '',
  `x_contenant` varchar(20) NOT NULL DEFAULT '',
  `x_tentree` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_pk_item` int(11) NOT NULL DEFAULT '0',
  `x_ipp` varchar(35) NOT NULL DEFAULT '',
  `x_sejour` varchar(35) NOT NULL DEFAULT '',
  `x_id_zone` varchar(35) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_etat` (`x_etat`),
  KEY `x_item_wms` (`x_item_wms`),
  KEY `x_type_mvt` (`x_type_mvt`),
  KEY `xx_type_mvt_bte` (`xx_type_mvt_bte`),
  KEY `x_solde` (`x_solde`)
) ENGINE=InnoDB AUTO_INCREMENT=344 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_his_al`
--

DROP TABLE IF EXISTS `f_his_al`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_his_al` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_code` varchar(50) NOT NULL DEFAULT '',
  `x_type` varchar(1) NOT NULL DEFAULT '',
  `x_etat` int(11) NOT NULL DEFAULT '0',
  `x_ack` tinyint(1) NOT NULL DEFAULT '0',
  `x_user_ack` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_code` (`x_code`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_etat` (`x_etat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo`
--

DROP TABLE IF EXISTS `f_histo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) DEFAULT '',
  `x_adr` varchar(19) DEFAULT '',
  `x_qte_mvt` float(15,3) DEFAULT '0.000',
  `x_qte_tot` float(15,3) DEFAULT '0.000',
  `x_info` varchar(100) NOT NULL DEFAULT '',
  `x_liste` varchar(60) DEFAULT '',
  `x_dest` varchar(30) DEFAULT '',
  `x_type_mvt` varchar(3) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_adr_from` varchar(19) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_comment` varchar(50) DEFAULT '',
  `x_admin` varchar(10) DEFAULT '',
  `x_kit` varchar(35) DEFAULT '',
  `x_emprunt` varchar(20) DEFAULT '',
  `x_pmp` float(15,3) DEFAULT '0.000',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tquarant` datetime DEFAULT '0000-00-00 00:00:00',
  `x_prix_u` float(15,3) DEFAULT '0.000',
  `x_sequence` varchar(25) DEFAULT '',
  `x_interface` varchar(15) NOT NULL DEFAULT '',
  `x_num_mag` varchar(5) DEFAULT '',
  `x_item` varchar(40) DEFAULT '',
  `x_demandeur` varchar(1) DEFAULT '',
  `x_date_dem` varchar(8) DEFAULT '',
  `x_heure_dem` varchar(8) DEFAULT '',
  `x_lib_unite` varchar(20) DEFAULT '',
  `x_qte_dem` float(15,3) DEFAULT '0.000',
  `x_num_dem` float(12,0) DEFAULT '0',
  `x_qte_disp` float(12,3) DEFAULT '0.000',
  `x_contenant` varchar(20) DEFAULT '',
  `x_cpt_budg` varchar(10) DEFAULT '',
  `x_four` varchar(20) DEFAULT '',
  `x_fusion` varchar(35) DEFAULT '',
  `x_qte_pick` float(15,3) DEFAULT '0.000',
  `x_qte_res` float(15,3) DEFAULT '0.000',
  `x_refour` varchar(35) DEFAULT '',
  `x_magh2` tinyint(1) NOT NULL DEFAULT '0',
  `x_num_ipp` varchar(15) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_tservice` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_poste` varchar(20) DEFAULT '',
  `x_type_liste_web` int(11) NOT NULL DEFAULT '0',
  `x_createur` varchar(20) NOT NULL DEFAULT '',
  `x_dot` varchar(35) NOT NULL DEFAULT '',
  `x_qte_tot_adr_lot_peremp` float(15,3) NOT NULL DEFAULT '0.000',
  `x_t_inv_term` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_pk_liste` int(11) NOT NULL DEFAULT '0',
  `x_serial` varchar(35) NOT NULL DEFAULT '',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `xx_dtprise` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `xx_id_pilulier` varchar(40) NOT NULL DEFAULT '',
  `xx_moment` varchar(35) NOT NULL DEFAULT '',
  `xx_heure` varchar(4) NOT NULL DEFAULT '',
  `xx_id_presc` int(11) NOT NULL DEFAULT '0',
  `x_readonly` tinyint(1) NOT NULL DEFAULT '0',
  `xx_ddeb` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_qte_prescrite` float(13,3) NOT NULL DEFAULT '0.000',
  `x_pk_item` int(11) NOT NULL DEFAULT '0',
  `x_item_wms` int(11) NOT NULL DEFAULT '0',
  `xx_sous_secteur` varchar(100) NOT NULL DEFAULT '',
  `xx_id_plateau` varchar(40) NOT NULL DEFAULT '',
  `xx_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `xx_id_peigne` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref` (`x_ref`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_type_mvt` (`x_type_mvt`),
  KEY `x_item` (`x_item`),
  KEY `x_liste` (`x_liste`),
  KEY `x_dest` (`x_dest`),
  KEY `idx_inv_term` (`x_t_inv_term`,`x_ref`,`x_adr`,`x_lot`,`x_tperemp`),
  KEY `x_pk_liste` (`x_pk_liste`),
  KEY `x_serial` (`x_serial`),
  KEY `x_ucd` (`x_ucd`),
  KEY `xx_id_presc` (`xx_id_presc`),
  KEY `x_item_wms` (`x_item_wms`),
  KEY `xx_id_pilulier` (`xx_id_pilulier`),
  KEY `xx_id_plateau` (`xx_id_plateau`)
) ENGINE=InnoDB AUTO_INCREMENT=522 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_blocage`
--

DROP TABLE IF EXISTS `f_histo_blocage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_blocage` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_adr` varchar(19) NOT NULL DEFAULT '',
  `x_bloque` tinyint(1) NOT NULL DEFAULT '0',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_lot` varchar(20) NOT NULL DEFAULT '',
  `x_tperemp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_fraction` int(11) NOT NULL DEFAULT '0',
  `x_datalu` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_bloque` (`x_bloque`),
  KEY `x_adr` (`x_adr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_coupe`
--

DROP TABLE IF EXISTS `f_histo_coupe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_coupe` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) DEFAULT '',
  `x_desig` varchar(100) DEFAULT '',
  `x_qte_mvt` int(11) DEFAULT '0',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref` (`x_ref`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_fraction` (`x_fraction`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_identification`
--

DROP TABLE IF EXISTS `f_histo_identification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_identification` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_demande` varchar(20) NOT NULL DEFAULT '',
  `x_liste` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_chrono` (`x_chrono`),
  KEY `x_user` (`x_user`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_multidoses`
--

DROP TABLE IF EXISTS `f_histo_multidoses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_multidoses` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_qte_serv` float(15,3) NOT NULL DEFAULT '0.000',
  `x_qte_dem` float(15,3) NOT NULL DEFAULT '0.000',
  `x_dest` varchar(30) NOT NULL DEFAULT '',
  `x_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_sejour` varchar(35) NOT NULL DEFAULT '',
  `x_liste` varchar(35) NOT NULL DEFAULT '',
  `x_coef_conv` float(15,3) NOT NULL DEFAULT '0.000',
  `x_unit_gest` varchar(20) NOT NULL DEFAULT '',
  `x_unit_admin` varchar(20) NOT NULL DEFAULT '',
  `x_delai_peremp` int(11) NOT NULL DEFAULT '0',
  `x_dtprise` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `f_histo_pilulier`
--

DROP TABLE IF EXISTS `f_histo_pilulier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_pilulier` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_poste` varchar(20) NOT NULL DEFAULT '',
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_pilulier` varchar(20) NOT NULL DEFAULT '',
  `x_liste` varchar(60) NOT NULL DEFAULT '',
  `x_peigne` varchar(20) NOT NULL DEFAULT '',
  `x_erreur_pricer` tinyint(1) NOT NULL DEFAULT '0',
  `x_conf_pricer` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_pilulier` (`x_pilulier`),
  KEY `x_liste` (`x_liste`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_plateau`
--

DROP TABLE IF EXISTS `f_histo_plateau`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_plateau` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_id_plateau` int(11) DEFAULT '0',
  `x_adr_plateau` varchar(19) DEFAULT '',
  `x_compte_rendu` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_prise`
--

DROP TABLE IF EXISTS `f_histo_prise`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_prise` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_qte_serv` float(15,3) NOT NULL DEFAULT '0.000',
  `x_qte_dem` float(15,3) NOT NULL DEFAULT '0.000',
  `x_dest` varchar(30) NOT NULL DEFAULT '',
  `x_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_sejour` varchar(35) NOT NULL DEFAULT '',
  `x_liste` varchar(35) NOT NULL DEFAULT '',
  `x_coef_conv` float(15,3) NOT NULL DEFAULT '0.000',
  `x_unit_gest` varchar(20) NOT NULL DEFAULT '',
  `x_unit_admin` varchar(20) NOT NULL DEFAULT '',
  `x_delai_peremp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_histo_sachet`
--

DROP TABLE IF EXISTS `f_histo_sachet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_histo_sachet` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_serial` varchar(20) DEFAULT NULL,
  `x_contenant` varchar(20) DEFAULT NULL,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_type_mvt` varchar(1) DEFAULT NULL,
  `x_pk_item` int(11) NOT NULL DEFAULT '0',
  `x_id_plateau` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_serial` (`x_serial`),
  KEY `x_contenant` (`x_contenant`),
  KEY `x_type_mvt` (`x_type_mvt`),
  KEY `x_id_plateau` (`x_id_plateau`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_item`
--

DROP TABLE IF EXISTS `f_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_item` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_liste` varchar(60) DEFAULT '',
  `x_mode` varchar(1) DEFAULT '',
  `x_item` varchar(40) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte_dem` float(15,3) DEFAULT '0.000',
  `x_qte_serv` float(15,3) DEFAULT '0.000',
  `x_lot` varchar(20) DEFAULT '',
  `x_admin` varchar(10) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_is_kit` tinyint(1) DEFAULT '0',
  `x_deroule` tinyint(1) DEFAULT '0',
  `x_kit` varchar(35) DEFAULT '',
  `x_adr_pref` varchar(19) DEFAULT '',
  `x_go_libre` tinyint(1) DEFAULT '0',
  `x_dest` varchar(30) DEFAULT '',
  `x_tquarant` datetime DEFAULT '0000-00-00 00:00:00',
  `x_user` varchar(20) DEFAULT '',
  `x_format_p` varchar(10) DEFAULT '',
  `x_nb_div` int(11) DEFAULT '0',
  `x_etat` varchar(1) DEFAULT '',
  `x_prix_u` float(15,3) DEFAULT '0.000',
  `x_ret_outi` tinyint(1) DEFAULT '0',
  `x_info` varchar(20) DEFAULT '',
  `x_urgent` tinyint(1) DEFAULT '0',
  `x_cde_hs` int(11) DEFAULT '0',
  `x_interface` varchar(15) NOT NULL DEFAULT '',
  `x_date_dem` varchar(8) DEFAULT '',
  `x_heure_dem` varchar(8) DEFAULT '',
  `x_lib_unite` varchar(20) DEFAULT '',
  `x_typ_dem` varchar(2) DEFAULT '',
  `x_num_mag` varchar(5) DEFAULT '',
  `x_dt_trait` varchar(8) DEFAULT '',
  `x_h_trait` varchar(8) DEFAULT '',
  `x_num_dem` float(12,0) DEFAULT '0',
  `x_qte_disp` float(12,3) DEFAULT '0.000',
  `x_d_recep` date DEFAULT '0000-00-00',
  `x_four` char(20) DEFAULT '',
  `x_contenant` varchar(20) DEFAULT '',
  `x_magh2` tinyint(1) NOT NULL DEFAULT '0',
  `x_num_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_cause_non_delivrance` varchar(80) DEFAULT '',
  `x_adr_tampon` varchar(19) DEFAULT '',
  `x_dotitemadd` tinyint(1) DEFAULT '0',
  `x_mode_mds` varchar(1) DEFAULT '',
  `x_commentaire_web` varchar(100) NOT NULL DEFAULT '',
  `x_id_presc` int(11) DEFAULT '0',
  `x_liste_pat` varchar(60) DEFAULT '',
  `x_code_liv` varchar(30) NOT NULL DEFAULT '',
  `x_dtprise` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_moment` varchar(35) NOT NULL DEFAULT '',
  `x_comment` varchar(80) NOT NULL DEFAULT '',
  `x_id_pilulier` varchar(40) DEFAULT '',
  `x_pos_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_tiroir` int(11) NOT NULL DEFAULT '0',
  `x_alveole` int(11) DEFAULT '0',
  `x_alveole_theo` int(11) NOT NULL DEFAULT '0',
  `x_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_id_peigne` int(11) NOT NULL DEFAULT '0',
  `x_pilulier_theo` int(11) NOT NULL DEFAULT '0',
  `x_item_wms` int(11) NOT NULL DEFAULT '0',
  `x_pk_item` int(11) NOT NULL DEFAULT '0',
  `x_heure` varchar(4) NOT NULL DEFAULT '',
  `x_readonly` tinyint(1) NOT NULL DEFAULT '0',
  `x_qte_prescrite` float(13,3) NOT NULL DEFAULT '0.000',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_type_servi` varchar(10) NOT NULL DEFAULT 'GLOBAL_BTE',
  `x_id_servi` int(11) NOT NULL DEFAULT '2',
  `xx_sous_secteur` varchar(100) NOT NULL DEFAULT '',
  `x_id_plateau` varchar(40) NOT NULL DEFAULT '',
  `x_complement_envoye` tinyint(1) NOT NULL DEFAULT '0',
  `x_liste_orig` varchar(60) DEFAULT '',
  `x_posologie` varchar(200) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_mode` (`x_mode`,`x_liste`,`x_item`),
  KEY `x_item` (`x_item`),
  KEY `x_ref` (`x_ref`),
  KEY `x_liste` (`x_liste`),
  KEY `x_item_wms` (`x_item_wms`),
  KEY `x_pk_item` (`x_pk_item`),
  KEY `x_id_pilulier` (`x_id_pilulier`),
  KEY `x_id_peigne` (`x_id_peigne`),
  KEY `xx_sous_secteur` (`xx_sous_secteur`),
  KEY `x_id_plateau` (`x_id_plateau`)
) ENGINE=MyISAM AUTO_INCREMENT=99582 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_item_ord`
--

DROP TABLE IF EXISTS `f_item_ord`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_item_ord` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_pk_item` int(11) DEFAULT '0',
  `x_ref` varchar(35) DEFAULT '',
  `x_dtprise` datetime DEFAULT '0000-00-00 00:00:00',
  `x_moment` varchar(35) DEFAULT '',
  `x_qte` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_pk_item` (`x_pk_item`),
  KEY `x_ref` (`x_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_item_preco`
--

DROP TABLE IF EXISTS `f_item_preco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_item_preco` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_preco` varchar(30) NOT NULL DEFAULT '',
  `x_item` varchar(45) NOT NULL DEFAULT '',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_stock` int(11) NOT NULL DEFAULT '0',
  `x_conso` int(11) NOT NULL DEFAULT '0',
  `x_couverture` int(11) NOT NULL DEFAULT '0',
  `x_four` varchar(45) NOT NULL DEFAULT '',
  `x_societe` varchar(45) NOT NULL DEFAULT '',
  `x_qte_preco` int(11) NOT NULL DEFAULT '0',
  `x_qte_commande` int(11) NOT NULL DEFAULT '0',
  `x_ageps` varchar(10) NOT NULL DEFAULT '',
  `x_refour` varchar(35) NOT NULL DEFAULT '',
  `x_marche` varchar(10) NOT NULL DEFAULT '',
  `x_ref_bis` varchar(35) DEFAULT '',
  `x_sel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_preco` (`x_preco`),
  KEY `x_ref` (`x_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_item_valide`
--

DROP TABLE IF EXISTS `f_item_valide`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_item_valide` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_pk_liste` int(11) DEFAULT '0',
  `x_item` varchar(40) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_desig` varchar(100) DEFAULT '',
  `x_qte_dem` float(15,3) DEFAULT '0.000',
  `x_qte_serv` float(15,3) DEFAULT '0.000',
  `x_lot` varchar(20) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dtprise` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_moment` varchar(35) NOT NULL DEFAULT '',
  `x_id_pilulier` varchar(40) DEFAULT '',
  `x_pos_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_tiroir` int(11) NOT NULL DEFAULT '0',
  `x_alveole` int(11) DEFAULT '0',
  `x_alveole_theo` int(11) NOT NULL DEFAULT '0',
  `x_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_id_plateau` int(11) NOT NULL DEFAULT '0',
  `x_pilulier_theo` int(11) NOT NULL DEFAULT '0',
  `x_readonly` tinyint(1) NOT NULL DEFAULT '0',
  `x_pk_item` int(11) NOT NULL DEFAULT '0',
  `x_heure` varchar(4) NOT NULL DEFAULT '',
  `x_item_wms` int(11) NOT NULL DEFAULT '0',
  `x_qte_prescrite` float(13,3) NOT NULL DEFAULT '0.000',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_type_servi` varchar(10) NOT NULL DEFAULT 'GLOBAL_BTE',
  `xx_sous_secteur` varchar(100) DEFAULT '',
  `x_doublon` tinyint(1) NOT NULL DEFAULT '0',
  `x_nom` varchar(35) DEFAULT '',
  `x_prenom` varchar(35) DEFAULT '',
  `x_dtnaiss` datetime DEFAULT '0000-00-00 00:00:00',
  `x_sexe` varchar(1) DEFAULT '',
  `x_chambre` varchar(30) DEFAULT '',
  `x_lit` varchar(30) DEFAULT '',
  `x_id_presc` int(11) DEFAULT '0',
  `x_nom_jf` varchar(35) DEFAULT '',
  `x_num_ipp` varchar(35) DEFAULT '',
  `x_sejour` varchar(35) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_item` (`x_item`),
  KEY `x_ref` (`x_ref`),
  KEY `x_pk_liste` (`x_pk_liste`),
  KEY `x_pk_item` (`x_pk_item`),
  KEY `x_id_pilulier` (`x_id_pilulier`),
  KEY `x_id_plateau` (`x_id_plateau`),
  KEY `x_item_wms` (`x_item_wms`),
  KEY `xx_sous_secteur` (`xx_sous_secteur`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_item_w`
--

DROP TABLE IF EXISTS `f_item_w`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_item_w` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_liste` varchar(60) DEFAULT '',
  `x_mode` varchar(1) DEFAULT '',
  `x_item` varchar(40) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte_dem` float(15,3) DEFAULT '0.000',
  `x_qte_serv` float(15,3) DEFAULT '0.000',
  `x_adr` varchar(19) DEFAULT '',
  `x_adr_from` varchar(19) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_admin` varchar(10) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_id_fifo` int(11) DEFAULT '0',
  `x_ordre` varchar(10) DEFAULT '',
  `x_item_w` int(11) DEFAULT '0',
  `x_tquarant` datetime DEFAULT '0000-00-00 00:00:00',
  `x_info` varchar(20) DEFAULT '',
  `x_dest` varchar(30) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_kit` varchar(35) DEFAULT '',
  `x_prix_u` float(15,3) DEFAULT '0.000',
  `x_urgent` tinyint(1) DEFAULT '0',
  `x_interface` varchar(15) NOT NULL DEFAULT '',
  `x_contenant` varchar(20) DEFAULT '',
  `x_num_ipp` varchar(15) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_adr_tampon` varchar(19) DEFAULT '',
  `x_mode_mds` varchar(1) DEFAULT '',
  `x_poste` varchar(20) DEFAULT '',
  `x_user_alloc` varchar(30) NOT NULL DEFAULT '',
  `x_talloc` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_id_pilulier` varchar(40) DEFAULT '',
  `x_pos_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_tiroir` int(11) NOT NULL DEFAULT '0',
  `x_alveole` int(11) DEFAULT '0',
  `x_alveole_theo` int(11) NOT NULL DEFAULT '0',
  `x_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_id_peigne` int(11) NOT NULL DEFAULT '0',
  `x_pilulier_theo` int(11) NOT NULL DEFAULT '0',
  `x_item_wms` int(11) NOT NULL DEFAULT '0',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_zone_fin` varchar(20) NOT NULL DEFAULT '',
  `x_goulotte` int(11) NOT NULL DEFAULT '1',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `xx_sous_secteur` varchar(100) NOT NULL DEFAULT '',
  `x_pk_item` int(11) DEFAULT '0',
  `x_id_plateau` int(11) DEFAULT '0',
  `x_pk_pilulier` int(11) DEFAULT '0',
  `x_codebac` varchar(20) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_mode_2` (`x_mode`),
  KEY `x_adr` (`x_adr`),
  KEY `x_ucd` (`x_ucd`)
) ENGINE=MyISAM AUTO_INCREMENT=286481 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_kit`
--

DROP TABLE IF EXISTS `f_kit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_kit` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_kit` varchar(35) DEFAULT '',
  `x_tcreat` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_kit` (`x_kit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_kit_it`
--

DROP TABLE IF EXISTS `f_kit_it`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_kit_it` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_kit` varchar(35) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte` float(15,3) DEFAULT '0.000',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_kit` (`x_kit`,`x_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_langue`
--

DROP TABLE IF EXISTS `f_langue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_langue` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_francais` varchar(100) DEFAULT '',
  `x_anglais` varchar(100) DEFAULT '',
  `x_allemand` varchar(100) DEFAULT '',
  `x_espagnol` varchar(100) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_francais` (`x_francais`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_lib_domaine`
--

DROP TABLE IF EXISTS `f_lib_domaine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_lib_domaine` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_domaine` varchar(10) DEFAULT '',
  `x_lib_domaine` varchar(160) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_domaine` (`x_domaine`),
  KEY `x_lib_domaine` (`x_lib_domaine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_libelles`
--

DROP TABLE IF EXISTS `f_libelles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_libelles` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_code` varchar(19) NOT NULL DEFAULT '',
  `x_libelle` varchar(200) NOT NULL DEFAULT '',
  `x_libelle_0` varchar(200) NOT NULL DEFAULT '',
  `x_libelle_1` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_code` (`x_code`),
  KEY `x_libelle_0` (`x_libelle_0`),
  KEY `x_libelle_1` (`x_libelle_1`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_liste`
--

DROP TABLE IF EXISTS `f_liste`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_liste` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_liste` varchar(60) DEFAULT '',
  `x_tcreat` datetime DEFAULT '0000-00-00 00:00:00',
  `x_etat` varchar(1) DEFAULT '',
  `x_mode` varchar(1) DEFAULT '',
  `x_fusion` varchar(60) DEFAULT '',
  `x_nb_item` int(11) DEFAULT '0',
  `x_dest` varchar(30) DEFAULT '',
  `x_tmodif` datetime DEFAULT '0000-00-00 00:00:00',
  `x_sequence` varchar(25) DEFAULT '',
  `x_interface` varchar(15) NOT NULL DEFAULT '',
  `x_num_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_zone_deb` varchar(20) DEFAULT '',
  `x_zone_fin` varchar(20) DEFAULT '',
  `x_dot` varchar(35) DEFAULT '',
  `x_date_rece` datetime DEFAULT '0000-00-00 00:00:00',
  `x_imp_transfert` tinyint(1) DEFAULT '0',
  `x_type_liste_web` int(11) NOT NULL DEFAULT '0',
  `x_createur` varchar(20) NOT NULL DEFAULT '',
  `x_ddeb` datetime DEFAULT '0000-00-00 00:00:00',
  `x_moment` varchar(35) DEFAULT '',
  `x_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_id_presc` int(11) DEFAULT '0',
  `x_liste_pat` varchar(60) DEFAULT '',
  `x_code_liv` varchar(30) NOT NULL DEFAULT '',
  `x_type_servi` varchar(10) NOT NULL DEFAULT 'GLOBAL_BTE',
  `x_id_servi` int(11) NOT NULL DEFAULT '2',
  `x_robot` varchar(20) NOT NULL DEFAULT '',
  `xx_sous_secteur` varchar(100) NOT NULL DEFAULT '',
  `x_selectionne` int(11) NOT NULL DEFAULT '0',
  `x_origine_sel` varchar(20) NOT NULL DEFAULT '',
  `x_valide_sel` tinyint(1) NOT NULL DEFAULT '0',
  `x_id_pilulier` varchar(40) NOT NULL DEFAULT '',
  `x_id_plateau` varchar(40) NOT NULL DEFAULT '',
  `x_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_id_peigne` int(11) NOT NULL DEFAULT '0',
  `x_tiroir` int(11) NOT NULL DEFAULT '0',
  `x_pos_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_id_chargement` varchar(19) DEFAULT '',
  `x_id_chariot` int(11) DEFAULT '0',
  `x_adr_pilulier` varchar(19) DEFAULT '',
  `x_pk_pilulier` varchar(40) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_mode` (`x_mode`,`x_liste`),
  KEY `x_liste` (`x_liste`),
  KEY `x_mode_2` (`x_mode`),
  KEY `xx_sous_secteur` (`xx_sous_secteur`),
  KEY `x_id_plateau` (`x_id_plateau`)
) ENGINE=MyISAM AUTO_INCREMENT=20202 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_liste_valide`
--

DROP TABLE IF EXISTS `f_liste_valide`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_liste_valide` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_liste` varchar(35) DEFAULT '',
  `x_ddeb` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dest` varchar(30) DEFAULT '',
  `x_lib_dest` varchar(50) DEFAULT '',
  `x_num_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_id_presc` int(11) DEFAULT '0',
  `x_nom` varchar(35) DEFAULT '',
  `x_prenom` varchar(35) DEFAULT '',
  `x_dtnaiss` datetime DEFAULT '0000-00-00 00:00:00',
  `x_chambre` varchar(10) DEFAULT '',
  `x_lit` varchar(10) DEFAULT '',
  `x_type_servi` varchar(10) NOT NULL DEFAULT 'GLOBAL_BTE',
  `xx_sous_secteur` varchar(100) NOT NULL DEFAULT '',
  `x_id_chariot` int(11) DEFAULT '0',
  `x_id_plateau` int(11) DEFAULT '0',
  `x_id_pilulier` int(11) DEFAULT '0',
  `x_adr_pilulier` varchar(19) DEFAULT '',
  `x_id_chargement` varchar(19) DEFAULT '',
  `x_pos_pilulier` int(11) DEFAULT '0',
  `x_pk_pilulier` varchar(40) DEFAULT '',
  `x_imprimer` tinyint(1) DEFAULT '0',
  `x_cr_imprimer` int(11) DEFAULT '0',
  `x_mode_sache` int(11) DEFAULT '0',
  `x_nom_jf` varchar(35) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_liste` (`x_liste`),
  KEY `x_id_pilulier` (`x_id_pilulier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_lock`
--

DROP TABLE IF EXISTS `f_lock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_lock` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_cle` varchar(25) DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_log_astus`
--

DROP TABLE IF EXISTS `f_log_astus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_log_astus` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_mag` varchar(3) DEFAULT '',
  `x_code_erreur` int(3) NOT NULL,
  `x_utilisateur` varchar(50) DEFAULT '',
  `x_adresse` varchar(19) DEFAULT '',
  `x_ref_produit` varchar(35) DEFAULT '',
  `x_lot_produit` varchar(20) DEFAULT '',
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_descriptif` text,
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_log_data`
--

DROP TABLE IF EXISTS `f_log_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_log_data` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_data` varchar(70) DEFAULT '0',
  `x_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `x_etape` varchar(50) DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_log_douchette`
--

DROP TABLE IF EXISTS `f_log_douchette`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_log_douchette` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_nb` int(11) DEFAULT '0',
  `x_valeur` longtext,
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_log_echange_automate`
--

DROP TABLE IF EXISTS `f_log_echange_automate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_log_echange_automate` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `x_variable` varchar(35) DEFAULT '',
  `x_valeur` longtext,
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_mag`
--

DROP TABLE IF EXISTS `f_mag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_mag` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_mag` varchar(3) DEFAULT '',
  `x_type_mag` varchar(15) DEFAULT '',
  `x_dim_2` int(11) DEFAULT '0',
  `x_dim_3` int(11) DEFAULT '0',
  `x_dim_4` int(11) DEFAULT '0',
  `x_dim_5` int(11) DEFAULT '0',
  `x_lib_2` varchar(20) DEFAULT '',
  `x_lib_3` varchar(20) DEFAULT '',
  `x_lib_4` varchar(20) DEFAULT '',
  `x_lib_5` varchar(20) DEFAULT '',
  `x_nb_dim` int(11) DEFAULT '0',
  `x_bmp` varchar(100) DEFAULT '',
  `x_compo_x` int(11) DEFAULT '0',
  `x_compo_y` int(11) DEFAULT '0',
  `x_emp_res` tinyint(1) DEFAULT '0',
  `x_statique` tinyint(1) DEFAULT '0',
  `x_pds_max` int(11) DEFAULT '0',
  `x_dim_pds` int(11) DEFAULT '0',
  `x_multiref` tinyint(1) DEFAULT '0',
  `x_parcours` varchar(1) DEFAULT '',
  `x_palettier` tinyint(1) DEFAULT '0',
  `x_armoire` varchar(15) NOT NULL DEFAULT '',
  `x_dest` varchar(30) NOT NULL DEFAULT '',
  `x_tampon` tinyint(1) NOT NULL DEFAULT '0',
  `x_adr_tampon` varchar(19) DEFAULT '',
  `x_coef_aut` int(11) NOT NULL DEFAULT '1',
  `x_eco_type` varchar(1) NOT NULL DEFAULT '',
  `x_id_zone` varchar(35) NOT NULL DEFAULT '',
  `x_type_assist` int(2) DEFAULT '0',
  `x_inhiber` int(11) DEFAULT '0',
  `x_split_liste` tinyint(1) DEFAULT '0',
  `x_id_robot`varchar(35) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_mag` (`x_mag`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_mag_dest`
--

DROP TABLE IF EXISTS `f_mag_dest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_mag_dest` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_mag` varchar(3) DEFAULT '',
  `x_dest` varchar(30) DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_miss`
--

DROP TABLE IF EXISTS `f_miss`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_miss` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_contenant` varchar(20) DEFAULT '',
  `x_tk` int(11) DEFAULT '0',
  `x_mvt` varchar(3) DEFAULT '',
  `x_etape` varchar(4) DEFAULT '',
  `x_adr_from` varchar(19) DEFAULT '',
  `x_adr_to` varchar(19) DEFAULT '',
  `x_adr_actu` varchar(19) DEFAULT '',
  `x_etat` varchar(1) DEFAULT '',
  `x_date_cre` datetime DEFAULT '0000-00-00 00:00:00',
  `x_prio` int(11) DEFAULT '0',
  `x_date_upd` datetime DEFAULT '0000-00-00 00:00:00',
  `x_format` varchar(10) DEFAULT NULL,
  `x_id_m_tk` int(11) DEFAULT '0',
  `x_es` varchar(1) DEFAULT '',
  `x_gabarit` varchar(4) DEFAULT '',
  `x_liste` varchar(35) DEFAULT '',
  `x_item` varchar(40) DEFAULT '',
  `x_item_w` int(11) DEFAULT '0',
  `x_prise` int(11) NOT NULL DEFAULT '0',
  `x_pose` varchar(19) NOT NULL DEFAULT '',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_lot` varchar(20) NOT NULL DEFAULT '',
  `x_dtper` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_id_pilulier` varchar(40) DEFAULT '',
  `x_pos_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_tiroir` int(11) NOT NULL DEFAULT '0',
  `x_alveole` int(11) DEFAULT '0',
  `x_alveole_theo` int(11) NOT NULL DEFAULT '0',
  `x_no_pilulier` int(11) NOT NULL DEFAULT '0',
  `x_codeData` varchar(60) NOT NULL DEFAULT '0',
  `x_id_peigne` int(11) NOT NULL DEFAULT '0',
  `x_pilulier_theo` int(11) NOT NULL DEFAULT '0',
  `x_reprise` tinyint(1) NOT NULL DEFAULT '0',
  `x_crNav` int(11) NOT NULL DEFAULT '0',
  `x_nb_essais` int(11) NOT NULL DEFAULT '0',
  `x_mag` varchar(3) NOT NULL DEFAULT '',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_ctrl_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_ctrl_fraction` int(11) NOT NULL DEFAULT '0',
  `x_ctrl_force` tinyint(1) NOT NULL DEFAULT '0',
  `x_id_plateau` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_id_plateau` (`x_id_plateau`)
) ENGINE=MyISAM AUTO_INCREMENT=153444 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_moment`
--

DROP TABLE IF EXISTS `f_moment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_moment` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_id_moment` int(11) DEFAULT '0',
  `x_moment` varchar(10) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_moment` (`x_moment`),
  KEY `x_id_moment` (`x_id_moment`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_patient`
--

DROP TABLE IF EXISTS `f_patient`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_patient` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_num_ipp` varchar(15) DEFAULT '',
  `x_nom_pat` varchar(60) DEFAULT '',
  `x_prenom_pat` varchar(60) DEFAULT '',
  `x_date_maj` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dnaiss` date DEFAULT '0000-00-00',
  `x_sexe` varchar(1) DEFAULT '',
  `x_nom_jf` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_num_ipp` (`x_num_ipp`),
  KEY `x_nom_pat` (`x_nom_pat`)
) ENGINE=MyISAM AUTO_INCREMENT=1756 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_peigne`
--

DROP TABLE IF EXISTS `f_peigne`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_peigne` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_type_peigne` int(11) NOT NULL DEFAULT '0',
  `x_nb_pilulier` int(11) NOT NULL DEFAULT '1',
  `x_taille` int(11) NOT NULL DEFAULT '1',
  `x_alveole` int(11) DEFAULT '4',
  PRIMARY KEY (`x_pk`),
  KEY `x_type_peigne` (`x_type_peigne`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_pile`
--

DROP TABLE IF EXISTS `f_pile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_pile` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_pile` varchar(10) DEFAULT '',
  `x_cree` datetime DEFAULT '0000-00-00 00:00:00',
  `x_id` int(11) DEFAULT '0',
  `x_taille` int(11) DEFAULT '0',
  `x_data` varchar(254) DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_plat`
--

DROP TABLE IF EXISTS `f_plat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_plat` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_profil` varchar(20) DEFAULT '',
  `x_adr` varchar(19) DEFAULT '',
  `x_accede` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_profil` (`x_profil`,`x_adr`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_posage`
--

DROP TABLE IF EXISTS `f_posage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_posage` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_codeBac` varchar(20) NOT NULL,
  `x_ucd` varchar(20) NOT NULL,
  `x_quantite` int(11) NOT NULL,
  `x_image1` longblob NOT NULL,
  `x_image2` longblob NOT NULL,
  `x_image_posage` longblob NOT NULL,
  `x_format` varchar(10) DEFAULT NULL,
  `x_nb_retour` int(11) DEFAULT NULL,
  `x_version` int(11) DEFAULT NULL,
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_poseur`
--

DROP TABLE IF EXISTS `f_poseur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_poseur` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_poseur` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_poste`
--

DROP TABLE IF EXISTS `f_poste`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_poste` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_poste` varchar(20) DEFAULT '',
  `x_pc` varchar(20) DEFAULT '',
  `x_tdepuis` datetime DEFAULT '0000-00-00 00:00:00',
  `x_ecr` varchar(20) DEFAULT '',
  `x_tostop` tinyint(1) DEFAULT '0',
  `x_tversion` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_proc_pid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_poste` (`x_poste`,`x_pc`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_poste_domaine`
--

DROP TABLE IF EXISTS `f_poste_domaine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_poste_domaine` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_domaine` varchar(10) DEFAULT '',
  `x_poste` varchar(20) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_domaine` (`x_domaine`),
  KEY `x_poste` (`x_poste`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_preco`
--

DROP TABLE IF EXISTS `f_preco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_preco` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_preco` varchar(30) NOT NULL DEFAULT '',
  `x_tcreat` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_commande` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_preco` (`x_preco`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_prescription`
--

DROP TABLE IF EXISTS `f_prescription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_prescription` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ordre` varchar(35) DEFAULT '',
  `x_ipp` varchar(30) NOT NULL DEFAULT '',
  `x_sejour` varchar(35) DEFAULT '',
  `x_nom` varchar(35) DEFAULT '',
  `x_prenom` varchar(35) DEFAULT '',
  `x_dtnaiss` datetime DEFAULT '0000-00-00 00:00:00',
  `x_sexe` varchar(1) DEFAULT '',
  `x_chambre` varchar(30) DEFAULT '',
  `x_lit` varchar(30) DEFAULT '',
  `x_nomjf` varchar(35) DEFAULT '',
  `x_demande` int(1) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_ipp` (`x_ipp`),
  KEY `x_sejour` (`x_sejour`),
  KEY `x_nom` (`x_nom`),
  KEY `x_ordre` (`x_ordre`)
) ENGINE=MyISAM AUTO_INCREMENT=4515 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_prescription_item`
--

DROP TABLE IF EXISTS `f_prescription_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_prescription_item` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ordre` varchar(35) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `x_ipp` varchar(30) NOT NULL,
  `x_sejour` varchar(35) NOT NULL,
  `x_dest` varchar(30) DEFAULT NULL,
  `x_sequence` int(11) NOT NULL DEFAULT '0',
  `x_sub_sequence` int(11) NOT NULL DEFAULT '1',
  `x_ref` varchar(35) DEFAULT NULL,
  `x_date_debut` datetime DEFAULT '0000-00-00 00:00:00',
  `x_date_fin` datetime DEFAULT '0000-00-00 00:00:00',
  `x_posologie` text,
  PRIMARY KEY (`x_pk`),
  KEY `x_ipp_x_sejour` (`x_ipp`,`x_sejour`)
) ENGINE=InnoDB AUTO_INCREMENT=6613 DEFAULT CHARSET=utf8 COMMENT='ligne de prescription';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_profil`
--

DROP TABLE IF EXISTS `f_profil`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_profil` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_profil` varchar(20) DEFAULT '',
  `x_resrc` varchar(50) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_profil` (`x_profil`,`x_resrc`)
) ENGINE=MyISAM AUTO_INCREMENT=468 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_radical`
--

DROP TABLE IF EXISTS `f_radical`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_radical` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_adr` varchar(19) DEFAULT '',
  `x_pos_x` int(11) DEFAULT '0',
  `x_pos_y` int(11) DEFAULT '0',
  `x_dim_x` int(11) DEFAULT '0',
  `x_dim_y` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_adr` (`x_adr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_ref`
--

DROP TABLE IF EXISTS `f_ref`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_ref` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) DEFAULT '',
  `x_desig` varchar(100) DEFAULT '',
  `x_lib_court` varchar(40) DEFAULT '',
  `x_ref_bis` varchar(35) DEFAULT '',
  `x_domaine` varchar(10) DEFAULT '',
  `x_tmodif` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tsortie` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tentree` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tinvent` datetime DEFAULT '0000-00-00 00:00:00',
  `x_fam_ref` varchar(10) DEFAULT '',
  `x_adr_pref` varchar(19) DEFAULT '',
  `x_classe` varchar(1) DEFAULT '',
  `x_emp_res` tinyint(1) DEFAULT '0',
  `x_mono_emp` tinyint(1) DEFAULT '0',
  `x_outil` tinyint(1) DEFAULT '0',
  `x_s_chrono` tinyint(1) DEFAULT '0',
  `x_s_libmax` tinyint(1) DEFAULT '0',
  `x_s_minmvt` tinyint(1) DEFAULT '0',
  `x_e_chrono` tinyint(1) DEFAULT '0',
  `x_e_stricte` tinyint(1) DEFAULT '0',
  `x_e_minmvt` tinyint(1) DEFAULT '0',
  `x_g_lot` tinyint(1) DEFAULT '0',
  `x_s_lot_f` tinyint(1) DEFAULT '0',
  `x_e_lot_f` tinyint(1) DEFAULT '0',
  `x_e_lot_str` tinyint(1) DEFAULT '0',
  `x_g_peremp` tinyint(1) DEFAULT '0',
  `x_s_peremp_f` tinyint(1) DEFAULT '0',
  `x_e_peremp_f` tinyint(1) DEFAULT '0',
  `x_e_peremp_str` tinyint(1) DEFAULT '0',
  `x_g_quarant` tinyint(1) DEFAULT '0',
  `x_e_quarant_f` tinyint(1) DEFAULT '0',
  `x_e_quarant_str` tinyint(1) DEFAULT '0',
  `x_s_quarant_f` tinyint(1) DEFAULT '0',
  `x_g_admin` tinyint(1) DEFAULT '0',
  `x_e_admin_str` tinyint(1) DEFAULT '0',
  `x_g_condi` tinyint(1) DEFAULT '0',
  `x_condi` float(15,3) DEFAULT '0.000',
  `x_e_condi` tinyint(1) DEFAULT '0',
  `x_s_lieu` varchar(2) DEFAULT '',
  `x_e_lieu` varchar(2) DEFAULT '',
  `x_alpha_1` varchar(20) DEFAULT '',
  `x_alpha_2` varchar(20) DEFAULT '',
  `x_num_1` float(13,3) DEFAULT '0.000',
  `x_num_2` float(13,3) DEFAULT '0.000',
  `x_e_admin_f` tinyint(1) DEFAULT '0',
  `x_s_admin_f` tinyint(1) DEFAULT '0',
  `x_old_ref` varchar(35) DEFAULT '',
  `x_stk_mini` float(15,3) DEFAULT '0.000',
  `x_stk_maxi` int(11) DEFAULT '0',
  `x_stk_reap` float(15,3) DEFAULT '0.000',
  `x_cycle_reap` int(11) DEFAULT '0',
  `x_reap_mode` varchar(1) DEFAULT '',
  `x_prix_u` float(15,3) DEFAULT '0.000',
  `x_pds_u` float(15,3) DEFAULT '0.000',
  `x_treap` datetime DEFAULT '0000-00-00 00:00:00',
  `x_unite` varchar(15) DEFAULT '',
  `x_pmp` float(15,3) DEFAULT '0.000',
  `x_g_pmp` tinyint(1) DEFAULT '0',
  `x_image` varchar(75) DEFAULT '',
  `x_val_mag` varchar(10) DEFAULT '',
  `x_dcreat` date DEFAULT '0000-00-00',
  `x_qml_cde` int(11) DEFAULT '0',
  `x_qml_serv` int(11) DEFAULT '0',
  `x_marche` varchar(10) DEFAULT '',
  `x_ageps` varchar(10) DEFAULT '',
  `x_deb_marche` date DEFAULT '0000-00-00',
  `x_fin_marche` date DEFAULT '0000-00-00',
  `x_t2a` tinyint(1) DEFAULT '0',
  `x_tva` float(12,2) DEFAULT '0.00',
  `x_cpt_budg` varchar(10) DEFAULT '',
  `x_indic_gest` varchar(5) DEFAULT '',
  `x_couv_min` int(10) unsigned NOT NULL DEFAULT '0',
  `x_couv_max` int(10) unsigned NOT NULL DEFAULT '0',
  `x_rupture` varchar(254) NOT NULL DEFAULT '',
  `x_g_traca` tinyint(1) DEFAULT '0',
  `x_actif` tinyint(1) DEFAULT '0',
  `x_cache_web` tinyint(1) DEFAULT '0',
  `x_delivrance` tinyint(1) DEFAULT '0',
  `x_depot` varchar(10) DEFAULT '',
  `x_lppr` varchar(10) DEFAULT '',
  `x_type_marche` varchar(10) DEFAULT '',
  `x_g_traca_mds` tinyint(1) DEFAULT '0',
  `x_cip` varchar(20) DEFAULT '',
  `x_atc` varchar(20) DEFAULT '',
  `x_ucd` varchar(20) DEFAULT '',
  `x_liste_med` varchar(20) NOT NULL DEFAULT '',
  `x_info_web` varchar(254) NOT NULL DEFAULT '',
  `x_dci` varchar(100) NOT NULL DEFAULT '',
  `x_forme` varchar(20) NOT NULL DEFAULT '',
  `x_dose` varchar(20) NOT NULL DEFAULT '',
  `x_fraction` float(15,3) NOT NULL DEFAULT '0.000',
  `x_ref_parent` varchar(35) NOT NULL DEFAULT '',
  `x_adr_ext` varchar(19) NOT NULL DEFAULT '',
  `x_desig_bis` varchar(100) NOT NULL DEFAULT '',
  `x_volume` varchar(20) NOT NULL DEFAULT '',
  `x_robot` tinyint(1) NOT NULL DEFAULT '0',
  `x_unit_gest` varchar(20) NOT NULL DEFAULT '',
  `x_unit_admin` varchar(20) NOT NULL DEFAULT '',
  `x_coef_conv` float(15,3) NOT NULL DEFAULT '0.000',
  `x_delai_peremp` int(11) NOT NULL DEFAULT '0',
  `x_externe` tinyint(1) DEFAULT '0',
  `x_conversion_ucd` tinyint(1) DEFAULT '0',
  `x_multidose_par_uf` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_ref` (`x_ref`),
  KEY `x_desig` (`x_desig`),
  KEY `x_domaine` (`x_domaine`),
  KEY `x_ref_parent` (`x_ref_parent`),
  KEY `ucd` (`x_ucd`)
) ENGINE=InnoDB AUTO_INCREMENT=48940 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_ref_ucd`
--

DROP TABLE IF EXISTS `f_ref_ucd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_ref_ucd` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref` (`x_ref`),
  KEY `x_ucd` (`x_ucd`)
) ENGINE=InnoDB AUTO_INCREMENT=8325 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_ref_wms`
--

DROP TABLE IF EXISTS `f_ref_wms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_ref_wms` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) DEFAULT '',
  `x_desig` varchar(200) NOT NULL DEFAULT '',
  `x_ref_bis` varchar(35) DEFAULT '',
  `x_tmodif` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tsortie` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tentree` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tinvent` datetime DEFAULT '0000-00-00 00:00:00',
  `x_fam_ref` varchar(10) DEFAULT '',
  `x_adr_pref` varchar(19) DEFAULT '',
  `x_classe` varchar(1) DEFAULT '',
  `x_emp_res` tinyint(1) DEFAULT '0',
  `x_mono_emp` tinyint(1) DEFAULT '0',
  `x_outil` tinyint(1) DEFAULT '0',
  `x_s_chrono` tinyint(1) DEFAULT '0',
  `x_s_libmax` tinyint(1) DEFAULT '0',
  `x_s_minmvt` tinyint(1) DEFAULT '0',
  `x_e_chrono` tinyint(1) DEFAULT '0',
  `x_e_stricte` tinyint(1) DEFAULT '0',
  `x_e_minmvt` tinyint(1) DEFAULT '0',
  `x_g_lot` tinyint(1) DEFAULT '0',
  `x_s_lot_f` tinyint(1) DEFAULT '0',
  `x_e_lot_f` tinyint(1) DEFAULT '0',
  `x_e_lot_str` tinyint(1) DEFAULT '0',
  `x_g_peremp` tinyint(1) DEFAULT '0',
  `x_s_peremp_f` tinyint(1) DEFAULT '0',
  `x_e_peremp_f` tinyint(1) DEFAULT '0',
  `x_e_peremp_str` tinyint(1) DEFAULT '0',
  `x_g_quarant` tinyint(1) DEFAULT '0',
  `x_e_quarant_f` tinyint(1) DEFAULT '0',
  `x_e_quarant_str` tinyint(1) DEFAULT '0',
  `x_s_quarant_f` tinyint(1) DEFAULT '0',
  `x_g_admin` tinyint(1) DEFAULT '0',
  `x_g_condi` tinyint(1) DEFAULT '0',
  `x_condi` float(15,3) NOT NULL DEFAULT '0.000',
  `x_e_condi` tinyint(1) DEFAULT '0',
  `x_s_lieu` varchar(2) DEFAULT '',
  `x_e_lieu` varchar(2) DEFAULT '',
  `x_alpha_1` varchar(20) DEFAULT '',
  `x_alpha_2` varchar(20) DEFAULT '',
  `x_num_1` float(13,3) DEFAULT '0.000',
  `x_num_2` float(13,3) DEFAULT '0.000',
  `x_e_admin_f` tinyint(1) DEFAULT '0',
  `x_s_admin_f` tinyint(1) DEFAULT '0',
  `x_old_ref` varchar(35) DEFAULT '',
  `x_stk_mini` float(15,3) DEFAULT '0.000',
  `x_stk_maxi` int(11) DEFAULT '0',
  `x_stk_reap` float(15,3) DEFAULT '0.000',
  `x_cycle_reap` int(11) DEFAULT '0',
  `x_reap_mode` varchar(1) DEFAULT '',
  `x_prix_u` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `x_pds_u` float(15,6) NOT NULL DEFAULT '0.000000',
  `x_treap` datetime DEFAULT '0000-00-00 00:00:00',
  `x_unite` varchar(5) NOT NULL DEFAULT '',
  `x_pmp` float(15,4) NOT NULL DEFAULT '0.0000',
  `x_g_pmp` tinyint(1) DEFAULT '0',
  `x_image` varchar(75) DEFAULT '',
  `x_val_mag` varchar(10) DEFAULT '',
  `x_qml_cde` int(11) DEFAULT '0',
  `x_qml_serv` int(11) DEFAULT '0',
  `x_marche` varchar(10) DEFAULT '',
  `x_ageps` varchar(10) DEFAULT '',
  `x_deb_marche` date DEFAULT '0000-00-00',
  `x_fin_marche` date DEFAULT '0000-00-00',
  `x_t2a` tinyint(1) DEFAULT '0',
  `x_tva` float(12,2) NOT NULL DEFAULT '0.00',
  `x_cpt_budg` varchar(10) DEFAULT '',
  `x_indic_gest` varchar(5) DEFAULT '',
  `x_dcreat` date DEFAULT '0000-00-00',
  `x_couv_min` int(10) unsigned NOT NULL DEFAULT '0',
  `x_couv_max` int(10) unsigned NOT NULL DEFAULT '0',
  `x_rupture` varchar(254) NOT NULL DEFAULT '',
  `x_g_traca` tinyint(1) DEFAULT '0',
  `x_depot` tinyint(1) NOT NULL DEFAULT '0',
  `x_lppr` varchar(35) NOT NULL DEFAULT '',
  `x_actif` tinyint(1) NOT NULL DEFAULT '1',
  `x_cache_web` tinyint(1) DEFAULT '0',
  `x_delivrance` tinyint(1) NOT NULL DEFAULT '0',
  `x_type_marche` varchar(10) DEFAULT '',
  `x_commentaire` varchar(80) DEFAULT '',
  `x_h_stock` tinyint(1) NOT NULL DEFAULT '0',
  `x_type_prep` varchar(1) NOT NULL DEFAULT '2',
  `x_condi_reap` int(11) NOT NULL DEFAULT '1',
  `x_edi` varchar(35) NOT NULL DEFAULT '',
  `x_ref_gef` varchar(35) NOT NULL DEFAULT '',
  `x_ref_cle` varchar(35) NOT NULL DEFAULT '',
  `x_dci` varchar(250) NOT NULL DEFAULT '',
  `x_atc` varchar(35) NOT NULL DEFAULT '',
  `x_dmodif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_ddeb_exploit` date NOT NULL DEFAULT '0000-00-00',
  `x_dfin_exploit` date NOT NULL DEFAULT '0000-00-00',
  `x_famille` varchar(35) NOT NULL DEFAULT '',
  `x_g_nogpao` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `x_intranet` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `x_classe_gef` varchar(10) NOT NULL DEFAULT '',
  `x_code_tva` varchar(1) NOT NULL DEFAULT '',
  `x_g_range` tinyint(1) NOT NULL DEFAULT '1',
  `x_g_range_libre` tinyint(4) NOT NULL DEFAULT '0',
  `x_pmp_gef` float(12,4) NOT NULL DEFAULT '0.0000',
  `x_zone_retour` varchar(50) NOT NULL DEFAULT '',
  `x_prio` tinyint(2) NOT NULL DEFAULT '50',
  `x_prio_qte` int(11) NOT NULL DEFAULT '0',
  `x_g_prio` tinyint(1) NOT NULL DEFAULT '0',
  `x_lib_marche` varchar(50) NOT NULL DEFAULT '',
  `x_pmp_gpao` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `x_lettre_budg` varchar(35) NOT NULL DEFAULT '',
  `x_desig_bis` varchar(150) NOT NULL DEFAULT '',
  `x_uniha` varchar(35) NOT NULL DEFAULT '',
  `x_domaine` varchar(10) NOT NULL DEFAULT '',
  `x_ref_cpage` varchar(10) NOT NULL DEFAULT '',
  `x_classe_th` varchar(10) NOT NULL DEFAULT '',
  `x_ucd` varchar(35) NOT NULL DEFAULT '',
  `x_cip` varchar(35) NOT NULL DEFAULT '',
  `x_dmi` varchar(35) NOT NULL DEFAULT '',
  `x_ean` varchar(35) NOT NULL DEFAULT '',
  `x_unite_achat` varchar(35) NOT NULL DEFAULT '',
  `x_unite_sortie` varchar(35) NOT NULL DEFAULT '',
  `x_site` varchar(4) NOT NULL DEFAULT '',
  `x_preco_mode` varchar(1) NOT NULL DEFAULT '',
  `x_preco_mini` float(15,3) NOT NULL DEFAULT '0.000',
  `x_preco_maxi` float(15,3) NOT NULL DEFAULT '0.000',
  `x_preco_frequence` int(11) NOT NULL DEFAULT '0',
  `x_preco_abo_qte` float(15,3) NOT NULL DEFAULT '0.000',
  `x_dtcommande` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_g_reliquat` tinyint(1) NOT NULL DEFAULT '0',
  `x_g_penu_manuel` tinyint(1) NOT NULL DEFAULT '0',
  `x_g_penu_mode` tinyint(1) NOT NULL DEFAULT '0',
  `x_g_range_direct` tinyint(1) NOT NULL DEFAULT '0',
  `x_range_condi` int(11) NOT NULL DEFAULT '0',
  `x_recep_urgent` tinyint(1) NOT NULL DEFAULT '0',
  `x_recep_habilit` tinyint(1) NOT NULL DEFAULT '0',
  `xx_domaine` varchar(10) NOT NULL DEFAULT '',
  `x_g_controle` tinyint(1) NOT NULL DEFAULT '0',
  `x_user_cde` varchar(35) NOT NULL DEFAULT '',
  `x_fact` varchar(4) NOT NULL DEFAULT '',
  `x_max_emp_prep` int(11) NOT NULL DEFAULT '0',
  `x_dimport` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_lib_unite` varchar(50) NOT NULL DEFAULT '',
  `x_lib_fam` varchar(50) NOT NULL DEFAULT '',
  `x_ref_gpao` varchar(50) NOT NULL DEFAULT '',
  `x_texport` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_ref_gpao2` varchar(50) NOT NULL DEFAULT '',
  `x_g_range_imp` tinyint(1) NOT NULL DEFAULT '1',
  `x_lib_tva` varchar(10) NOT NULL DEFAULT '',
  `x_qte_max` int(11) NOT NULL DEFAULT '0',
  `x_origine` varchar(10) NOT NULL DEFAULT '',
  `x_catalogue` varchar(30) NOT NULL DEFAULT '',
  `x_qml_gpao` int(11) NOT NULL DEFAULT '0',
  `x_g_comment` tinyint(1) NOT NULL DEFAULT '0',
  `x_g_site` tinyint(1) NOT NULL DEFAULT '0',
  `x_zone_prep` varchar(50) NOT NULL DEFAULT '',
  `x_temp` tinyint(1) NOT NULL DEFAULT '0',
  `x_hs_condi` int(11) NOT NULL DEFAULT '0',
  `x_cmj` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `x_web_masquer` tinyint(1) NOT NULL DEFAULT '0',
  `x_info_web` varchar(254) NOT NULL DEFAULT '',
  `x_traca_dmi` tinyint(1) NOT NULL DEFAULT '0',
  `x_traca_mds` tinyint(1) NOT NULL DEFAULT '0',
  `x_non_sterile` tinyint(1) NOT NULL DEFAULT '0',
  `x_g_temperature` tinyint(1) NOT NULL DEFAULT '0',
  `x_e_temperature_f` tinyint(1) NOT NULL DEFAULT '0',
  `x_is_kit` tinyint(1) NOT NULL DEFAULT '0',
  `x_pk_kit` int(11) NOT NULL DEFAULT '0',
  `x_alpha_03` varchar(100) NOT NULL DEFAULT '',
  `x_alpha_04` varchar(100) NOT NULL DEFAULT '',
  `x_alpha_05` varchar(100) NOT NULL DEFAULT '',
  `x_liste_med` varchar(20) NOT NULL DEFAULT '',
  `x_cab` varchar(35) NOT NULL DEFAULT '',
  `xx_fraction` varchar(35) NOT NULL DEFAULT '',
  `xx_conserv` varchar(35) NOT NULL DEFAULT '',
  `x_presta` tinyint(1) NOT NULL DEFAULT '0',
  `x_forme` varchar(35) NOT NULL DEFAULT '',
  `x_dosage` varchar(35) NOT NULL DEFAULT '',
  `x_volume` varchar(35) NOT NULL DEFAULT '',
  `x_g_ecodex` tinyint(1) NOT NULL DEFAULT '0',
  `x_nomin_complete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_ref` (`x_ref`),
  KEY `x_desig` (`x_desig`),
  KEY `x_ref_bis` (`x_ref_bis`),
  KEY `x_domaine` (`x_domaine`),
  KEY `x_ref_gpao` (`x_ref_gpao`),
  KEY `x_ref_gpao2` (`x_ref_gpao2`),
  KEY `x_h_stock` (`x_h_stock`),
  KEY `x_ref_h_stock` (`x_ref`,`x_h_stock`),
  KEY `x_ucd` (`x_ucd`)
) ENGINE=MyISAM AUTO_INCREMENT=14698 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_refcondi`
--

DROP TABLE IF EXISTS `f_refcondi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_refcondi` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_id_condi` varchar(35) NOT NULL DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_condi` float(15,3) DEFAULT NULL,
  `x_zone` varchar(20) DEFAULT '',
  `x_g_complet` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_id_condi` (`x_id_condi`,`x_ref`,`x_zone`),
  KEY `x_ref` (`x_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_refemp`
--

DROP TABLE IF EXISTS `f_refemp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_refemp` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tquarant` datetime DEFAULT '0000-00-00 00:00:00',
  `x_qte` float(15,3) DEFAULT '0.000',
  `x_admin` varchar(10) DEFAULT '',
  `x_tempr` datetime DEFAULT '0000-00-00 00:00:00',
  `x_info` varchar(10) DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_reform`
--

DROP TABLE IF EXISTS `f_reform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_reform` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) DEFAULT '',
  `x_format` varchar(10) DEFAULT '',
  `x_nb_div` int(11) DEFAULT '0',
  `x_capa` float(15,3) DEFAULT '0.000',
  `x_ordre` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_ref` (`x_ref`,`x_format`,`x_nb_div`),
  KEY `x_format` (`x_format`)
) ENGINE=InnoDB AUTO_INCREMENT=3622 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_refour`
--

DROP TABLE IF EXISTS `f_refour`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_refour` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) DEFAULT '',
  `x_four` varchar(20) DEFAULT '',
  `x_ordre` int(11) DEFAULT '0',
  `x_prix` float(15,3) NOT NULL DEFAULT '0.000',
  `x_remise` float(8,2) DEFAULT '0.00',
  `x_refour` varchar(35) DEFAULT '',
  `x_net` float(14,2) DEFAULT '0.00',
  `x_desfour` varchar(60) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref` (`x_ref`),
  KEY `x_refour` (`x_refour`),
  KEY `x_four` (`x_four`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_reprise`
--

DROP TABLE IF EXISTS `f_reprise`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_reprise` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_action` varchar(30) NOT NULL DEFAULT '',
  `x_etape_arret` int(11) NOT NULL DEFAULT '0',
  `x_etape_reprise` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_action` (`x_action`,`x_etape_arret`),
  KEY `x_etape_arret` (`x_etape_arret`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_resrc`
--

DROP TABLE IF EXISTS `f_resrc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_resrc` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_resrc` varchar(50) DEFAULT '',
  `x_lib` varchar(75) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_resrc` (`x_resrc`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_robot`
--

DROP TABLE IF EXISTS `f_robot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_robot` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_organe` varchar(10) NOT NULL DEFAULT '',
  `x_etat` varchar(1) NOT NULL DEFAULT '',
  `x_on` tinyint(1) NOT NULL DEFAULT '0',
  `x_mess_err` varchar(250) NOT NULL DEFAULT '',
  `x_id_peigne` int(11) NOT NULL DEFAULT '0',
  `x_erreur` int(11) NOT NULL DEFAULT '0',
  `x_type_peigne` int(11) NOT NULL DEFAULT '0',
  `x_nb_case` int(11) NOT NULL DEFAULT '1',
  `x_user` varchar(20) DEFAULT '',
  `x_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_mag` varchar(3) NOT NULL DEFAULT '',
  `x_etat_sav` varchar(1) NOT NULL DEFAULT '',
  `x_plateau` int(11) NOT NULL DEFAULT '0',
  `x_facade` int(11) NOT NULL DEFAULT '0',
  `x_id_plateau` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_type_peigne` (`x_type_peigne`),
  KEY `x_organe` (`x_organe`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_sachet`
--

DROP TABLE IF EXISTS `f_sachet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_sachet` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_serial` varchar(20) DEFAULT NULL,
  `x_contenant` varchar(20) DEFAULT NULL,
  `x_chrono` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`x_pk`),
  KEY `x_serial` (`x_serial`),
  KEY `x_contenant` (`x_contenant`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_sejour`
--

DROP TABLE IF EXISTS `f_sejour`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_sejour` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_num_ipp` varchar(15) NOT NULL DEFAULT '',
  `x_num_sej` varchar(15) NOT NULL DEFAULT '',
  `x_tentree` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_uf_hosp` varchar(30) NOT NULL DEFAULT '',
  `x_uf_alit` varchar(30) NOT NULL DEFAULT '',
  `x_tsortie` datetime DEFAULT '0000-00-00 00:00:00',
  `x_chambre` varchar(30) NOT NULL DEFAULT '',
  `x_lit` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_num_ipp` (`x_num_ipp`),
  KEY `x_num_sej` (`x_num_sej`)
) ENGINE=MyISAM AUTO_INCREMENT=1399 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_semaph`
--

DROP TABLE IF EXISTS `f_semaph`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_semaph` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_table` varchar(20) DEFAULT '',
  `x_poste` varchar(20) DEFAULT '',
  `x_rec_pk` int(11) DEFAULT '0',
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`x_pk`),
  KEY `x_rec_pk` (`x_rec_pk`)
) ENGINE=MyISAM AUTO_INCREMENT=19483 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_seuil`
--

DROP TABLE IF EXISTS `f_seuil`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_seuil` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_zone` varchar(20) NOT NULL DEFAULT '',
  `x_stk_mini` float(15,3) NOT NULL DEFAULT '0.000',
  `x_stk_maxi` float(15,3) NOT NULL DEFAULT '0.000',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_refzone` (`x_zone`,`x_ref`,`x_fraction`),
  KEY `x_ref` (`x_ref`),
  KEY `x_zone` (`x_zone`)
) ENGINE=MyISAM AUTO_INCREMENT=1952 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_stock`
--

DROP TABLE IF EXISTS `f_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_stock` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_adr` varchar(19) DEFAULT '',
  `x_ref` varchar(35) DEFAULT '',
  `x_qte` float(15,3) DEFAULT '0.000',
  `x_id_fifo` int(11) DEFAULT '0',
  `x_lot` varchar(20) DEFAULT '',
  `x_admin` varchar(10) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tquarant` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tentree` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tsortie` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tinvent` datetime DEFAULT '0000-00-00 00:00:00',
  `x_info` varchar(20) DEFAULT '',
  `x_condi` float(15,3) DEFAULT '0.000',
  `x_bloque` tinyint(1) DEFAULT '0',
  `x_contenant` varchar(20) DEFAULT '',
  `x_cycleVie` int(2) DEFAULT '0',
  `x_mag` varchar(3) DEFAULT '',
  `x_reinteg` tinyint(1) DEFAULT '0',
  `x_manquant` tinyint(1) NOT NULL DEFAULT '0',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_etat` varchar(1) NOT NULL DEFAULT '',
  `x_serial` varchar(20) NOT NULL DEFAULT '',
  `x_zone_admin` varchar(20) NOT NULL DEFAULT '',
  `x_fraction` int(11) NOT NULL DEFAULT '100',
  `x_capa` smallint(6) DEFAULT '0',
  `x_indexprise` smallint(6) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref` (`x_ref`),
  KEY `x_adr` (`x_adr`),
  KEY `x_mag` (`x_mag`),
  KEY `x_contenant` (`x_contenant`),
  KEY `x_ucd` (`x_ucd`),
  KEY `x_serial` (`x_serial`),
  KEY `x_zone_admin` (`x_zone_admin`)
) ENGINE=InnoDB AUTO_INCREMENT=11996 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_tache`
--

DROP TABLE IF EXISTS `f_tache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_tache` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_nom_tache` varchar(45) DEFAULT NULL,
  `x_etat` varchar(45) DEFAULT NULL,
  `x_ordre` int(11) DEFAULT NULL,
  `x_poste` varchar(45) DEFAULT NULL,
  `x_id_zone` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_terminal`
--

DROP TABLE IF EXISTS `f_terminal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_terminal` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_poste_scan` varchar(20) NOT NULL DEFAULT '',
  `x_dest_mag_scan` varchar(30) NOT NULL DEFAULT '',
  `x_dest_scan` varchar(30) NOT NULL DEFAULT '',
  `x_dot_id_scan` varchar(30) NOT NULL DEFAULT '',
  `x_ref_scan` varchar(35) NOT NULL DEFAULT '',
  `x_qte_scan` varchar(15) NOT NULL DEFAULT '',
  `x_adr_scan` varchar(19) NOT NULL DEFAULT '',
  `x_lot_scan` varchar(20) NOT NULL DEFAULT '',
  `x_peremp_scan` varchar(19) NOT NULL DEFAULT '',
  `x_nom_fic` varchar(100) NOT NULL DEFAULT '',
  `x_d_fic` date NOT NULL DEFAULT '0000-00-00',
  `x_h_fic` varchar(8) NOT NULL DEFAULT '',
  `x_mask` varchar(10) NOT NULL DEFAULT '',
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_etat` varchar(1) NOT NULL DEFAULT '',
  `x_message` varchar(200) NOT NULL DEFAULT '',
  `x_mode` varchar(1) NOT NULL DEFAULT '',
  `x_traite` tinyint(1) NOT NULL DEFAULT '0',
  `x_ref` varchar(35) NOT NULL DEFAULT '',
  `x_ref_desig` varchar(100) NOT NULL DEFAULT '',
  `x_qml_serv` int(11) NOT NULL DEFAULT '0',
  `x_dot` varchar(35) NOT NULL DEFAULT '',
  `x_id_dot` int(11) NOT NULL DEFAULT '0',
  `x_dest_dot` varchar(30) NOT NULL DEFAULT '',
  `x_lib_dest` varchar(30) NOT NULL DEFAULT '',
  `x_qte_calc` float(15,3) NOT NULL DEFAULT '0.000',
  `x_qte_stk` float(15,3) NOT NULL DEFAULT '0.000',
  `x_qte_ecart` float(15,3) NOT NULL DEFAULT '0.000',
  `x_tperemp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_fusion` varchar(35) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_ref_scan` (`x_ref_scan`),
  KEY `x_dest_scan` (`x_dest_scan`),
  KEY `x_dot_id_scan` (`x_dot_id_scan`),
  KEY `x_etat` (`x_etat`),
  KEY `x_mask` (`x_mask`),
  KEY `x_chrono` (`x_chrono`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_text`
--

DROP TABLE IF EXISTS `f_text`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_text` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_id` varchar(10) NOT NULL DEFAULT '',
  `x_cle` varchar(100) NOT NULL DEFAULT '',
  `x_val` text NOT NULL,
  PRIMARY KEY (`x_pk`),
  KEY `id_cle` (`x_id`,`x_cle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_theme`
--

DROP TABLE IF EXISTS `f_theme`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_theme` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_libelle` varchar(50) NOT NULL DEFAULT '',
  `x_bgcolor0` int(11) NOT NULL DEFAULT '0',
  `x_bgcolor1` int(11) NOT NULL DEFAULT '0',
  `x_bgcolor2` int(11) NOT NULL DEFAULT '0',
  `x_fgfcolor0` int(11) NOT NULL DEFAULT '0',
  `x_fgfcolor1` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_libelle` (`x_libelle`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_tk`
--

DROP TABLE IF EXISTS `f_tk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_tk` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_tk` int(11) DEFAULT '0',
  `x_etat` varchar(1) DEFAULT '',
  `x_on` tinyint(1) DEFAULT '0',
  `x_on_e` tinyint(1) DEFAULT '0',
  `x_mess_err` varchar(250) DEFAULT '',
  `x_der_adr` varchar(11) DEFAULT '',
  `x_type` varchar(3) DEFAULT '',
  `x_enabled` tinyint(1) DEFAULT '0',
  `x_on_s` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_top5`
--

DROP TABLE IF EXISTS `f_top5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_top5` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_cle` varchar(10) NOT NULL DEFAULT '',
  `x_val` varchar(20) NOT NULL DEFAULT '',
  `x_poste` varchar(20) NOT NULL DEFAULT '',
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_mode` tinyint(1) NOT NULL DEFAULT '0',
  `x_nb` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_cle_mode_val_poste` (`x_cle`,`x_mode`,`x_val`,`x_poste`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_topo`
--

DROP TABLE IF EXISTS `f_topo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_topo` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_adr_topo` varchar(19) DEFAULT '',
  `x_orient` varchar(1) DEFAULT '',
  `x_fam` varchar(10) DEFAULT '',
  `x_dim_x` int(11) DEFAULT '0',
  `x_dim_y` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_adr_topo` (`x_adr_topo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_traca`
--

DROP TABLE IF EXISTS `f_traca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_traca` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dest` varchar(30) DEFAULT '',
  `x_four` varchar(20) DEFAULT '',
  `x_societe` varchar(30) DEFAULT '',
  `x_no_serie` varchar(30) DEFAULT '',
  `x_refour` varchar(35) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_poseur` varchar(20) DEFAULT '',
  `x_id_traca` varchar(20) DEFAULT '',
  `x_nip` varchar(20) DEFAULT '',
  `x_nda` varchar(20) DEFAULT '',
  `x_nom` varchar(60) DEFAULT '',
  `x_secu` varchar(20) DEFAULT '',
  `x_prenom` varchar(60) DEFAULT '',
  `x_dnaiss` date DEFAULT '0000-00-00',
  `x_tpose` datetime DEFAULT '0000-00-00 00:00:00',
  `x_etat` varchar(3) DEFAULT '',
  `x_type_indic` varchar(1) DEFAULT '1',
  `x_comment` varchar(250) DEFAULT '',
  `x_journal` text,
  `x_dvalid` datetime DEFAULT '0000-00-00 00:00:00',
  `x_user_valid` varchar(20) DEFAULT '',
  `x_dcde` datetime DEFAULT '0000-00-00 00:00:00',
  `x_treport` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dest_pose` varchar(35) DEFAULT '',
  `x_no_cde` tinyint(1) DEFAULT '0',
  `x_no_liv` tinyint(1) DEFAULT '0',
  `x_indic_gest` varchar(5) DEFAULT '',
  `x_depot` varchar(10) DEFAULT '',
  `x_prix_u` float(15,3) DEFAULT '0.000',
  `x_tva` float(12,2) DEFAULT '0.00',
  `x_t2a` tinyint(1) DEFAULT '0',
  `x_cpt_budg` varchar(10) DEFAULT '',
  `x_marche` varchar(10) DEFAULT '',
  `x_lppr` varchar(10) DEFAULT '',
  `x_sexe` varchar(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_traca_mds`
--

DROP TABLE IF EXISTS `f_traca_mds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_traca_mds` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tdisp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_ref` varchar(35) DEFAULT '',
  `x_lot` varchar(20) DEFAULT '',
  `x_tperemp` datetime DEFAULT '0000-00-00 00:00:00',
  `x_dest` varchar(30) DEFAULT '',
  `x_four` varchar(20) DEFAULT '',
  `x_societe` varchar(30) DEFAULT '',
  `x_refour` varchar(35) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  `x_poseur` varchar(20) DEFAULT '',
  `x_id_traca` varchar(20) DEFAULT '',
  `x_nip` varchar(20) DEFAULT '',
  `x_nda` varchar(20) DEFAULT '',
  `x_nom` varchar(60) DEFAULT '',
  `x_prenom` varchar(60) DEFAULT '',
  `x_dnaiss` date DEFAULT '0000-00-00',
  `x_tpose` datetime DEFAULT '0000-00-00 00:00:00',
  `x_etat` varchar(3) DEFAULT '',
  `x_type_indic` varchar(1) DEFAULT '1',
  `x_comment` varchar(250) DEFAULT '',
  `x_journal` text,
  `x_dvalid` datetime DEFAULT '0000-00-00 00:00:00',
  `x_user_valid` varchar(20) DEFAULT '',
  `x_dcde` datetime DEFAULT '0000-00-00 00:00:00',
  `x_mode_mds` varchar(1) DEFAULT '',
  `x_qte_serv` float(15,3) DEFAULT '0.000',
  `x_nb_sortie` int(4) DEFAULT '1',
  `x_dest_pose` varchar(30) DEFAULT '',
  `x_sexe` varchar(1) NOT NULL DEFAULT '',
  `x_desfour` varchar(60) DEFAULT '',
  `x_pk_liste` int(11) DEFAULT '0',
  PRIMARY KEY (`x_pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_type_mag`
--

DROP TABLE IF EXISTS `f_type_mag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_type_mag` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_type_mag` varchar(15) DEFAULT '',
  `x_dim_2` int(11) DEFAULT '0',
  `x_dim_3` int(11) DEFAULT '0',
  `x_dim_4` int(11) DEFAULT '0',
  `x_dim_5` int(11) DEFAULT '0',
  `x_lib_2` varchar(20) DEFAULT '',
  `x_lib_3` varchar(20) DEFAULT '',
  `x_lib_4` varchar(20) DEFAULT '',
  `x_lib_5` varchar(20) DEFAULT '',
  `x_nb_dim` int(11) DEFAULT '0',
  `x_bmp` varchar(100) DEFAULT '',
  `x_compo_x` int(11) DEFAULT '0',
  `x_compo_y` int(11) DEFAULT '0',
  `x_emp_res` tinyint(1) DEFAULT '0',
  `x_statique` tinyint(1) DEFAULT '0',
  `x_pds_max` int(11) DEFAULT '0',
  `x_dim_pds` int(11) DEFAULT '0',
  `x_multiref` tinyint(1) DEFAULT '0',
  `x_parcours` varchar(1) DEFAULT '',
  `x_palettier` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_type_mag` (`x_type_mag`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_ucd_cip`
--

DROP TABLE IF EXISTS `f_ucd_cip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_ucd_cip` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_cip` varchar(20) NOT NULL DEFAULT '',
  `x_ucd` varchar(20) NOT NULL DEFAULT '',
  `x_qt_blister` int(11) NOT NULL DEFAULT '0',
  `x_qt_boite` int(11) NOT NULL DEFAULT '0',
  `x_index_dossier` varchar(20) NOT NULL DEFAULT '',
  `x_qt_pass` int(11) NOT NULL DEFAULT '0',
  `x_qt_coupe` int(11) NOT NULL DEFAULT '0',
  `x_date_der_coupe` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_delai_peremption` smallint(6) DEFAULT '0',
  `x_delai_a_saisir` smallint(6) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  KEY `x_cip` (`x_cip`),
  KEY `x_ucd` (`x_ucd`)
) ENGINE=InnoDB AUTO_INCREMENT=104607 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_unite`
--

DROP TABLE IF EXISTS `f_unite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_unite` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_unite` varchar(10) DEFAULT '',
  `x_lib_unit` varchar(20) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_unite` (`x_unite`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_user`
--

DROP TABLE IF EXISTS `f_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_user` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_user` varchar(60) DEFAULT '',
  `x_passwd` varchar(20) DEFAULT '',
  `x_profil` varchar(20) DEFAULT '',
  `x_desc` varchar(20) DEFAULT '',
  `x_service` varchar(20) DEFAULT '',
  `x_tcreat` datetime DEFAULT '0000-00-00 00:00:00',
  `x_tlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_badge` varchar(16) DEFAULT '',
  `x_login` varchar(30) DEFAULT NULL,
  `x_inventaire` tinyint(1) DEFAULT '0',
  `x_astup` tinyint(1) DEFAULT '0',
  `x_email` varchar(320) DEFAULT '',
  `x_import_flag` tinyint(1) DEFAULT '0',
  `x_maintenance` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_user` (`x_user`)
) ENGINE=InnoDB AUTO_INCREMENT=1415 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_user_ad`
--

DROP TABLE IF EXISTS `f_user_ad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_user_ad` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_profil` varchar(20) DEFAULT NULL,
  `x_dn` varchar(256) DEFAULT NULL,
  `x_astup` tinyint(1) DEFAULT NULL,
  `x_annuaire` int(11) DEFAULT NULL,
  PRIMARY KEY (`x_pk`),
  KEY `f_annuaire_fk1` (`x_annuaire`),
  CONSTRAINT `f_annuaire_fk1` FOREIGN KEY (`x_annuaire`) REFERENCES `f_annuaire` (`x_pk`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Table gestion active directory et profil';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_user_domaine`
--

DROP TABLE IF EXISTS `f_user_domaine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_user_domaine` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_domaine` varchar(10) DEFAULT '',
  `x_user` varchar(20) DEFAULT '',
  PRIMARY KEY (`x_pk`),
  KEY `x_domaine` (`x_domaine`),
  KEY `x_user` (`x_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_wsclient_erreur`
--

DROP TABLE IF EXISTS `f_wsclient_erreur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_wsclient_erreur` (
  `x_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x_url` varchar(50) NOT NULL DEFAULT '',
  `x_wsdl` varchar(50) NOT NULL DEFAULT '',
  `x_fonction` varchar(50) NOT NULL DEFAULT '',
  `x_param` longtext,
  `x_msg_erreur` text,
  `x_supp` tinyint(1) NOT NULL DEFAULT '0',
  `x_nb_retry` int(11) NOT NULL DEFAULT '0',
  `x_poste` varchar(20) NOT NULL DEFAULT '',
  `x_user` varchar(20) NOT NULL DEFAULT '',
  `x_dtretry` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`x_pk`)
) ENGINE=InnoDB AUTO_INCREMENT=14476 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_zone`
--

DROP TABLE IF EXISTS `f_zone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_zone` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_zone` varchar(20) NOT NULL DEFAULT '',
  `x_appro` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_zone` (`x_zone`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `f_zonemag`
--

DROP TABLE IF EXISTS `f_zonemag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `f_zonemag` (
  `x_pk` int(11) NOT NULL AUTO_INCREMENT,
  `x_zone` varchar(20) NOT NULL DEFAULT '  ',
  `x_mag` varchar(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`x_pk`),
  UNIQUE KEY `x_mag` (`x_mag`,`x_zone`),
  UNIQUE KEY `x_zone` (`x_zone`,`x_mag`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_nombre`
--

DROP TABLE IF EXISTS `t_nombre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8;
CREATE TABLE `t_nombre` (
  `n` bigint(23) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

-- manuel dans Median

/*!40101 SET @saved_cs_client     = @@character_set_client */;
ALTER TABLE f_ref ADD x_com_med TEXT NULL COMMENT 'Commentaire median';
ALTER TABLE f_ref ADD x_bac INT DEFAULT 0 NOT NULL COMMENT 'Bac';
ALTER TABLE f_item ADD x_id_chargement INT DEFAULT 0 NOT NULL COMMENT 'ID Chargement';
ALTER TABLE f_item ADD x_id_chariot INT DEFAULT 0 NOT NULL COMMENT 'ID Chariot';
ALTER TABLE f_item ADD x_num_face INT DEFAULT 0 NOT NULL COMMENT 'Numero de face';
ALTER TABLE f_gpao ADD column x_id_robot VARCHAR(35) DEFAULT '' NULL COMMENT 'ID Robot';
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Dumping routines for database 'quimperle'
--
/*!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 2019-10-13  8:50:59
