CREATE TABLE planificateur (
  id_planificateur int(11) unsigned NOT NULL AUTO_INCREMENT,
  num_type_tache int(11) NOT NULL,
  libelle_tache varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  desc_tache varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  num_user int(11) NOT NULL,
  param mediumtext COLLATE utf8_unicode_ci,
  statut tinyint(1) unsigned DEFAULT '0',
  rep_upload int(8) DEFAULT NULL,
  path_upload mediumtext COLLATE utf8_unicode_ci,
  perio_heure varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  perio_minute varchar(28) COLLATE utf8_unicode_ci DEFAULT '01',
  perio_jour_mois varchar(128) COLLATE utf8_unicode_ci DEFAULT '*',
  perio_jour varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  perio_mois varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  calc_next_heure_deb varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  calc_next_date_deb date DEFAULT NULL,
  PRIMARY KEY (id_planificateur)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `planificateur`
--


--
-- Table structure for table `pret`
--

CREATE TABLE pret (
  pret_idempr int(10) unsigned NOT NULL DEFAULT '0',
  pret_idexpl int(10) unsigned NOT NULL DEFAULT '0',
  pret_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  pret_retour date DEFAULT NULL,
  pret_arc_id int(10) unsigned NOT NULL DEFAULT '0',
  niveau_relance int(1) NOT NULL DEFAULT '0',
  date_relance date DEFAULT '0000-00-00',
  printed int(1) NOT NULL DEFAULT '0',
  retour_initial date DEFAULT '0000-00-00',
  cpt_prolongation int(1) NOT NULL DEFAULT '0',
  pret_temp varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  short_loan_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (pret_idexpl),
  KEY i_pret_idempr (pret_idempr),
  KEY i_pret_arc_id (pret_arc_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret`
--

INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (10,50,'2012-11-20 09:32:13','2013-01-22',2,0,'0000-00-00',0,'2012-12-11',2,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (10,65,'2012-11-20 09:32:31','2013-01-01',3,0,'0000-00-00',0,'2012-12-11',1,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (7,94,'2012-11-20 09:33:31','2013-01-01',4,0,'0000-00-00',0,'2012-12-11',1,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (7,90,'2012-11-20 09:34:17','2012-12-11',5,0,'0000-00-00',0,'2012-12-11',0,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (1,53,'2012-11-20 09:34:36','2012-12-11',6,0,'0000-00-00',0,'2012-12-11',0,'',0);

--
-- Table structure for table `pret_archive`
--

CREATE TABLE pret_archive (
  arc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  arc_debut datetime DEFAULT '0000-00-00 00:00:00',
  arc_fin datetime DEFAULT NULL,
  arc_id_empr int(10) unsigned NOT NULL DEFAULT '0',
  arc_empr_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_ville varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_prof varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_year int(4) unsigned DEFAULT '0',
  arc_empr_categ smallint(5) unsigned DEFAULT '0',
  arc_empr_codestat smallint(5) unsigned DEFAULT '0',
  arc_empr_sexe tinyint(3) unsigned DEFAULT '0',
  arc_empr_statut int(10) unsigned NOT NULL DEFAULT '1',
  arc_empr_location int(6) unsigned NOT NULL DEFAULT '0',
  arc_type_abt int(6) unsigned NOT NULL DEFAULT '0',
  arc_expl_typdoc int(5) unsigned DEFAULT '0',
  arc_expl_cote varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_expl_statut smallint(5) unsigned DEFAULT '0',
  arc_expl_location smallint(5) unsigned DEFAULT '0',
  arc_expl_location_origine int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_location_retour int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_codestat smallint(5) unsigned DEFAULT '0',
  arc_expl_owner mediumint(8) unsigned DEFAULT '0',
  arc_expl_section int(5) unsigned NOT NULL DEFAULT '0',
  arc_expl_id int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_notice int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  arc_groupe varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_niveau_relance int(1) unsigned DEFAULT '0',
  arc_date_relance date NOT NULL DEFAULT '0000-00-00',
  arc_printed int(1) unsigned DEFAULT '0',
  arc_cpt_prolongation int(1) unsigned DEFAULT '0',
  arc_short_loan_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (arc_id),
  KEY i_pa_expl_id (arc_expl_id),
  KEY i_pa_idempr (arc_id_empr),
  KEY i_pa_expl_notice (arc_expl_notice),
  KEY i_pa_expl_bulletin (arc_expl_bulletin),
  KEY i_pa_arc_fin (arc_fin),
  KEY i_pa_arc_empr_categ (arc_empr_categ),
  KEY i_pa_arc_expl_location (arc_expl_location)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_archive`
--

INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (1,'2012-08-05 16:00:57','2012-10-24 10:47:37',0,'','','',0,7,2,0,1,1,0,1,'RK ROB',1,1,0,0,12,2,10,30,53,0,'',0,'0000-00-00',0,1,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (2,'2012-11-20 09:32:13','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Formatrice',1985,7,3,2,1,1,0,1,'P BUR',1,1,0,0,12,2,10,50,106,0,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (3,'2012-11-20 09:32:31','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Formatrice',1985,7,3,2,1,1,0,1,'BD J GUE',1,1,0,0,11,1,20,65,92,0,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (4,'2012-11-20 09:33:31','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Développeur PMB',1972,7,3,1,1,1,0,18,'PER GEO',1,1,0,0,12,2,31,94,0,5,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (5,'2012-11-20 09:34:17','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Développeur PMB',1972,7,3,1,1,1,0,1,'960 DEP',1,1,0,0,12,1,10,90,71,0,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (6,'2012-11-20 09:34:36','2012-12-11 00:00:00',0,'01000','StarwarsTown','Pilote',1900,8,4,1,1,1,0,1,'RX BRA',1,1,0,0,12,2,24,53,103,0,'',0,'0000-00-00',0,0,0);

--
-- Table structure for table `pret_custom`
--

CREATE TABLE pret_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  filters int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom`
--


--
-- Table structure for table `pret_custom_lists`
--

CREATE TABLE pret_custom_lists (
  pret_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  pret_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY i_pret_custom_champ (pret_custom_champ),
  KEY i_pret_champ_list_value (pret_custom_champ,pret_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom_lists`
--


--
-- Table structure for table `pret_custom_values`
--

CREATE TABLE pret_custom_values (
  pret_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  pret_custom_text text COLLATE utf8_unicode_ci,
  pret_custom_integer int(11) DEFAULT NULL,
  pret_custom_date date DEFAULT NULL,
  pret_custom_float float DEFAULT NULL,
  KEY i_pret_custom_champ (pret_custom_champ),
  KEY i_pret_custom_origine (pret_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom_values`
--


--
-- Table structure for table `procs`
--

CREATE TABLE procs (
  idproc smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  autorisations longtext COLLATE utf8_unicode_ci,
  parameters mediumtext COLLATE utf8_unicode_ci,
  num_classement int(5) unsigned NOT NULL DEFAULT '0',
  proc_notice_tpl int(2) unsigned NOT NULL DEFAULT '0',
  proc_notice_tpl_field varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idproc),
  KEY idproc (idproc)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `procs`
--


--
-- Table structure for table `procs_classements`
--

CREATE TABLE procs_classements (
  idproc_classement smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  libproc_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idproc_classement)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `procs_classements`
--

INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (1,'Statistiques collections');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (2,'Statistiques lecteurs');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (3,'Statistiques prêts');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (4,'Listes');

--
-- Table structure for table `publisher_custom`
--

CREATE TABLE publisher_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_type int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom`
--


--
-- Table structure for table `publisher_custom_lists`
--

CREATE TABLE publisher_custom_lists (
  publisher_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  publisher_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (publisher_custom_champ),
  KEY editorial_champ_list_value (publisher_custom_champ,publisher_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom_lists`
--


--
-- Table structure for table `publisher_custom_values`
--

CREATE TABLE publisher_custom_values (
  publisher_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  publisher_custom_text text COLLATE utf8_unicode_ci,
  publisher_custom_integer int(11) DEFAULT NULL,
  publisher_custom_date date DEFAULT NULL,
  publisher_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (publisher_custom_champ),
  KEY editorial_custom_origine (publisher_custom_origine),
  KEY i_pcv_st (publisher_custom_small_text),
  KEY i_pcv_t (publisher_custom_text(255)),
  KEY i_pcv_i (publisher_custom_integer),
  KEY i_pcv_d (publisher_custom_date),
  KEY i_pcv_f (publisher_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom_values`
--


--
-- Table structure for table `publishers`
--

CREATE TABLE publishers (
  ed_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  ed_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_ville varchar(96) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_pays varchar(96) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_web varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  index_publisher mediumtext COLLATE utf8_unicode_ci,
  ed_comment mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (ed_id),
  KEY ed_name (ed_name),
  KEY ed_ville (ed_ville)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publishers`
--

INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (6,'Seuil','','','','Paris','','',' seuil paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (7,'les Éd. du Toucan','','','','[Issy-les-Moulineaux]','','',' les ed du toucan issy les moulineaux ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (8,'Hazan','','','','[Vanves]','','',' hazan vanves ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (9,'Didier jeunesse','','','','Paris','','',' didier jeunesse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (11,'Pastel','','','','[Bruxelles]','','',' pastel bruxelles ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (12,'l\'école des loisirs','','','','Paris','','',' l ecole des loisirs paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (13,'Gallimard','','','','Paris','','',' gallimard paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (14,'Serpent à plumes','','','','Paris','','',' serpent a plumes paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (15,'Vents d\'ailleurs','','','','La Roque-d\'Anthéron','','',' vents d ailleurs la roque d antheron ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (16,'Kaléidoscope','','','','Paris','','',' kaleidoscope paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (17,'Hachette Jeunesse','','','','','','',' hachette jeunesse ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (18,'Circonflexe','','','','[Paris]','','',' circonflexe paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (19,'l\'Oeil neuf éd.','','','','Paris','','',' l oeil neuf ed paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (20,'Éd. du Cercle de la librairie','','','','[Paris]','','',' ed du cercle de la librairie paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (21,'Presses universitaires de France','','','','Paris','','',' presses universitaires de france paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (22,'Casterman','','','','','','',' casterman ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (23,'Gallimard jeunesse','','','','[Paris]','','',' gallimard jeunesse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (24,'Denoël','','','','[Paris]','','',' denoel paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (25,'Éd. First','','','','Paris','','',' ed first paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (26,'Milan','','','','Toulouse','','',' milan toulouse ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (27,'Éd. du Rouergue','','','','Rodez','','',' ed du rouergue rodez ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (28,'Gallimard jeunesse - Giboulées','','','','[Paris]','','',' gallimard jeunesse giboulees paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (29,'Nathan','','','','','','',' nathan ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (30,'Éd. Lito','','','','Champigny-sur-Marne','','',' ed lito champigny sur marne ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (31,'Rue du monde','','','','[Voisins-le-Bretonneux]','','',' rue du monde voisins le bretonneux ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (32,'Mila éd.','','','','[Paris]','','',' mila ed paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (33,'l\'École des loisirs-Loulou & Cie','','','','Paris','','',' l ecole des loisirs loulou cie paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (34,'l\'Atalante','','','','Nantes','','',' l atalante nantes ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (35,'10-18','','','','','','',' 10 18 ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (36,'Arola','','','','','','',' arola ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (37,'Cah cinema','','','','','','',' cah cinema ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (38,'Gallimard Jeunesse Musique','','','','','','',' gallimard jeunesse musique ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (39,'Twentieth century Fox','','','','Paris','','',' twentieth century fox paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (40,'Warner home video','','','','Neuilly-sur-Seine','','',' warner home video neuilly sur seine ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (41,'Columbia Tristar home video','','','','Boulogne-Billancourt','','',' columbia tristar home video boulogne billancourt ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (42,'Manteca','','','','','','',' manteca ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (43,'AZ','','','','Paris','','',' az paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (44,'Universal music jazz France','','','','','','',' universal music jazz france ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (45,'Universal Polydor','','','','','','',' universal polydor ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (46,'Because music','','','','Paris','','',' because music paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (47,'Participations éditions presse','','','','Paris','','',' participations editions presse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (48,'ENSSIB','','','','Villeurbanne','','',' enssib villeurbanne ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (49,'Éd. Grains de sel','','','','Lyon','','',' ed grains de sel lyon ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (50,'Studio magazine','','','','Paris','','',' studio magazine paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (51,'Garnier frères','','','','Paris','','',' garnier freres paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (52,'Poulet-Malassis et De Broise','','','','Paris','','',' poulet malassis et de broise paris ','');

--
-- Table structure for table `quotas`
--

CREATE TABLE quotas (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` float DEFAULT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas`
--

INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MAX',0,10);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'DEFAULT',0,5);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'DEFAULT',0,21);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'DEFAULT',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'DEFAULT',0,21);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MAX',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'DEFAULT',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',20,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',6,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',4,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'DEFAULT',0,7);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',20,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',6,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',4,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MAX',0,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'DEFAULT',0,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',24,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',10,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',8,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'DEFAULT',0,7);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',24,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',10,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',8,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',2,4);

--
-- Table structure for table `quotas_finance`
--

CREATE TABLE quotas_finance (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` float DEFAULT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas_finance`
--


--
-- Table structure for table `quotas_opac_views`
--

CREATE TABLE quotas_opac_views (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas_opac_views`
--


--
-- Table structure for table `rapport_demandes`
--

CREATE TABLE rapport_demandes (
  id_item int(10) unsigned NOT NULL AUTO_INCREMENT,
  contenu mediumtext COLLATE utf8_unicode_ci NOT NULL,
  num_note int(10) NOT NULL DEFAULT '0',
  num_demande int(10) NOT NULL DEFAULT '0',
  ordre mediumint(3) NOT NULL DEFAULT '0',
  `type` mediumint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_item)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rapport_demandes`
--


--
-- Table structure for table `rdfstore_index`
--

CREATE TABLE rdfstore_index (
  num_triple int(10) unsigned NOT NULL DEFAULT '0',
  subject_uri text CHARACTER SET utf8 NOT NULL,
  subject_type text COLLATE utf8_unicode_ci NOT NULL,
  predicat_uri text CHARACTER SET utf8 NOT NULL,
  num_object int(10) unsigned NOT NULL DEFAULT '0',
  object_val text CHARACTER SET utf8 NOT NULL,
  object_index text CHARACTER SET utf8 NOT NULL,
  object_lang char(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (num_object)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rdfstore_index`
--


--
-- Table structure for table `recouvrements`
--

CREATE TABLE recouvrements (
  recouvr_id int(16) unsigned NOT NULL AUTO_INCREMENT,
  empr_id int(10) unsigned NOT NULL DEFAULT '0',
  id_expl int(10) unsigned NOT NULL DEFAULT '0',
  date_rec date NOT NULL DEFAULT '0000-00-00',
  libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  montant decimal(16,2) DEFAULT '0.00',
  recouvr_type int(2) unsigned NOT NULL DEFAULT '0',
  date_pret datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance1 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance2 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance3 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (recouvr_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `recouvrements`
--


--
-- Table structure for table `resa`
--

CREATE TABLE resa (
  id_resa mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  resa_idempr int(10) unsigned NOT NULL DEFAULT '0',
  resa_idnotice mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idbulletin int(8) unsigned NOT NULL DEFAULT '0',
  resa_date datetime DEFAULT NULL,
  resa_date_debut date NOT NULL DEFAULT '0000-00-00',
  resa_date_fin date NOT NULL DEFAULT '0000-00-00',
  resa_cb varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resa_confirmee int(1) unsigned NOT NULL DEFAULT '0',
  resa_loc_retrait smallint(5) unsigned NOT NULL DEFAULT '0',
  resa_arc int(10) unsigned NOT NULL DEFAULT '0',
  resa_planning_id_resa int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_resa),
  KEY resa_date_fin (resa_date_fin),
  KEY resa_date (resa_date),
  KEY resa_cb (resa_cb),
  KEY i_idbulletin (resa_idbulletin),
  KEY i_idnotice (resa_idnotice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa`
--


--
-- Table structure for table `resa_archive`
--

CREATE TABLE resa_archive (
  resarc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  resarc_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  resarc_debut date NOT NULL DEFAULT '0000-00-00',
  resarc_fin date NOT NULL DEFAULT '0000-00-00',
  resarc_idnotice int(10) unsigned NOT NULL DEFAULT '0',
  resarc_idbulletin int(10) unsigned NOT NULL DEFAULT '0',
  resarc_confirmee int(1) unsigned DEFAULT '0',
  resarc_cb varchar(14) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_loc_retrait smallint(5) unsigned DEFAULT '0',
  resarc_from_opac int(1) unsigned DEFAULT '0',
  resarc_anulee int(1) unsigned DEFAULT '0',
  resarc_pretee int(1) unsigned DEFAULT '0',
  resarc_arcpretid int(10) unsigned NOT NULL DEFAULT '0',
  resarc_id_empr int(10) unsigned NOT NULL DEFAULT '0',
  resarc_empr_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_ville varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_prof varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_year int(4) unsigned DEFAULT '0',
  resarc_empr_categ smallint(5) unsigned DEFAULT '0',
  resarc_empr_codestat smallint(5) unsigned DEFAULT '0',
  resarc_empr_sexe tinyint(3) unsigned DEFAULT '0',
  resarc_empr_location int(6) unsigned NOT NULL DEFAULT '1',
  resarc_expl_nb int(5) unsigned DEFAULT '0',
  resarc_expl_typdoc int(5) unsigned DEFAULT '0',
  resarc_expl_cote varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_expl_statut smallint(5) unsigned DEFAULT '0',
  resarc_expl_location smallint(5) unsigned DEFAULT '0',
  resarc_expl_codestat smallint(5) unsigned DEFAULT '0',
  resarc_expl_owner mediumint(8) unsigned DEFAULT '0',
  resarc_expl_section int(5) unsigned NOT NULL DEFAULT '0',
  resarc_resa_planning_id_resa int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (resarc_id),
  KEY i_pa_idempr (resarc_id_empr),
  KEY i_pa_notice (resarc_idnotice),
  KEY i_pa_bulletin (resarc_idbulletin),
  KEY i_pa_resarc_date (resarc_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_archive`
--


--
-- Table structure for table `resa_loc`
--

CREATE TABLE resa_loc (
  resa_loc int(8) unsigned NOT NULL DEFAULT '0',
  resa_emprloc int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (resa_loc,resa_emprloc),
  KEY i_resa_emprloc (resa_emprloc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_loc`
--


--
-- Table structure for table `resa_planning`
--

CREATE TABLE resa_planning (
  id_resa mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  resa_idempr mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idnotice mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idbulletin int(8) unsigned NOT NULL DEFAULT '0',
  resa_date datetime DEFAULT NULL,
  resa_date_debut date NOT NULL DEFAULT '0000-00-00',
  resa_date_fin date NOT NULL DEFAULT '0000-00-00',
  resa_validee int(1) unsigned NOT NULL DEFAULT '0',
  resa_confirmee int(1) unsigned NOT NULL DEFAULT '0',
  resa_loc_retrait int(5) unsigned NOT NULL DEFAULT '0',
  resa_qty int(5) unsigned NOT NULL DEFAULT '1',
  resa_remaining_qty int(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (id_resa),
  KEY resa_date_fin (resa_date_fin),
  KEY resa_date (resa_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_planning`
--


--
-- Table structure for table `resa_ranger`
--

CREATE TABLE resa_ranger (
  resa_cb varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (resa_cb)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_ranger`
--


--
-- Table structure for table `responsability`
--

CREATE TABLE responsability (
  responsability_author mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_notice mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_fonction varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  responsability_type mediumint(1) unsigned NOT NULL DEFAULT '0',
  responsability_ordre smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (responsability_author,responsability_notice,responsability_fonction),
  KEY responsability_notice (responsability_notice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `responsability`
--

INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (19,73,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (15,71,'440',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (18,72,'250',2,2);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (17,72,'440',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (16,72,'070',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (13,69,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (12,68,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (14,70,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (11,68,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (20,74,'440',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (22,75,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (21,75,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (22,76,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (21,76,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (23,77,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (26,78,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (25,78,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (24,78,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (27,79,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (29,80,'',1,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (28,80,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (30,81,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (31,82,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (33,83,'651',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (32,83,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (34,84,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (35,85,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (37,86,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (36,86,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (41,87,'730',2,2);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (40,87,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (39,87,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (38,87,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (42,88,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (45,89,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (44,89,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (43,89,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (46,90,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (47,91,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (48,92,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (50,93,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (49,93,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (51,94,'',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (52,95,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (53,96,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (55,97,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (54,97,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (57,98,'651',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (56,98,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (59,99,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (58,99,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (59,100,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (58,100,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (60,101,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (27,102,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (63,103,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (62,103,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (61,103,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (65,104,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (64,104,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (65,105,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (64,105,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,106,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (68,108,'',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (69,109,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (71,110,'',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (70,110,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,110,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (72,111,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,111,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (73,112,'0',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,112,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,113,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (70,114,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,114,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (74,115,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (75,116,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (76,117,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (77,118,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (78,119,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (79,124,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (80,125,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (81,126,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (82,127,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (83,128,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (84,132,'651',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (88,135,'070',2,2);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (87,135,'440',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (86,135,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (85,135,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (89,136,'070',0,0);

--
-- Table structure for table `responsability_tu`
--

CREATE TABLE responsability_tu (
  responsability_tu_author_num int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_num int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_fonction char(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  responsability_tu_type int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_ordre smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (responsability_tu_author_num,responsability_tu_num,responsability_tu_fonction),
  KEY responsability_tu_author (responsability_tu_author_num),
  KEY responsability_tu_num (responsability_tu_num)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `responsability_tu`
--


--
-- Table structure for table `rss_content`
--

CREATE TABLE rss_content (
  rss_id int(10) unsigned NOT NULL DEFAULT '0',
  rss_content longblob NOT NULL,
  rss_content_parse longblob NOT NULL,
  rss_last timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (rss_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_content`
--

INSERT INTO rss_content (rss_id, rss_content, rss_content_parse, rss_last) VALUES (120,0x[encoded data, 38494 characters],0x[encoded data, 32478 characters],'2012-10-25 07:29:11');

--
-- Table structure for table `rss_flux`
--

CREATE TABLE rss_flux (
  id_rss_flux int(9) unsigned NOT NULL AUTO_INCREMENT,
  nom_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  link_rss_flux blob NOT NULL,
  descr_rss_flux blob NOT NULL,
  lang_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr',
  copy_rss_flux blob NOT NULL,
  editor_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  webmaster_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ttl_rss_flux int(9) unsigned NOT NULL DEFAULT '60',
  img_url_rss_flux blob NOT NULL,
  img_title_rss_flux blob NOT NULL,
  img_link_rss_flux blob NOT NULL,
  format_flux blob NOT NULL,
  rss_flux_content longblob NOT NULL,
  rss_flux_last timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  export_court_flux tinyint(1) unsigned NOT NULL DEFAULT '0',
  tpl_rss_flux int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_rss_flux)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_flux`
--


--
-- Table structure for table `rss_flux_content`
--

CREATE TABLE rss_flux_content (
  num_rss_flux int(9) unsigned NOT NULL DEFAULT '0',
  type_contenant char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'BAN',
  num_contenant int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (num_rss_flux,type_contenant,num_contenant)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_flux_content`
--


--
-- Table structure for table `rubriques`
--

CREATE TABLE rubriques (
  id_rubrique int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_budget int(8) unsigned NOT NULL DEFAULT '0',
  num_parent int(8) unsigned NOT NULL DEFAULT '0',
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  commentaires mediumtext COLLATE utf8_unicode_ci NOT NULL,
  montant float(8,2) unsigned NOT NULL DEFAULT '0.00',
  num_cp_compta varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  autorisations longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_rubrique)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rubriques`
--


--
-- Table structure for table `sauv_lieux`
--

CREATE TABLE sauv_lieux (
  sauv_lieu_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_lieu_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_url varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_protocol varchar(10) COLLATE utf8_unicode_ci DEFAULT 'file',
  sauv_lieu_host varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_login varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_password varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (sauv_lieu_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_lieux`
--


--
-- Table structure for table `sauv_log`
--

CREATE TABLE sauv_log (
  sauv_log_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_log_start_date date DEFAULT NULL,
  sauv_log_file varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_log_succeed int(11) DEFAULT '0',
  sauv_log_messages longtext COLLATE utf8_unicode_ci,
  sauv_log_userid int(11) DEFAULT NULL,
  PRIMARY KEY (sauv_log_id)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_log`
--


--
-- Table structure for table `sauv_sauvegardes`
--

CREATE TABLE sauv_sauvegardes (
  sauv_sauvegarde_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_sauvegarde_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_file_prefix varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_tables longtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_lieux longtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_users longtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_compress int(11) DEFAULT '0',
  sauv_sauvegarde_compress_command longtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_crypt int(11) DEFAULT '0',
  sauv_sauvegarde_key1 varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_key2 varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (sauv_sauvegarde_id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_sauvegardes`
--

INSERT INTO sauv_sauvegardes (sauv_sauvegarde_id, sauv_sauvegarde_nom, sauv_sauvegarde_file_prefix, sauv_sauvegarde_tables, sauv_sauvegarde_lieux, sauv_sauvegarde_users, sauv_sauvegarde_compress, sauv_sauvegarde_compress_command, sauv_sauvegarde_crypt, sauv_sauvegarde_key1, sauv_sauvegarde_key2) VALUES (1,'tout','full','1','','1',0,'internal::',0,'','');

--
-- Table structure for table `sauv_tables`
--

CREATE TABLE sauv_tables (
  sauv_table_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_table_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_table_tables mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (sauv_table_id),
  UNIQUE KEY sauv_table_nom (sauv_table_nom)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_tables`
--

INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (1,'TOUT','abo_liste_lecture,abts_abts,abts_abts_modeles,abts_grille_abt,abts_grille_modele,abts_modeles,abts_periodicites,acces_profiles,acces_rights,actes,admin_session,analysis,arch_emplacement,arch_statut,arch_type,audit,aut_link,author_custom,author_custom_lists,author_custom_values,authorities_sources,authors,authperso,authperso_authorities,authperso_custom,authperso_custom_lists,authperso_custom_values,avis,bannette_abon,bannette_contenu,bannette_equation,bannette_exports,bannette_facettes,bannette_tpl,bannettes,bannettes_descriptors,budgets,bulletins,cache_amendes,caddie,caddie_content,caddie_procs,cashdesk,cashdesk_locations,cashdesk_sections,categ_custom,categ_custom_lists,categ_custom_values,categories,classements,cms,cms_articles,cms_articles_descriptors,cms_build,cms_cache_cadres,cms_cadre_content,cms_cadres,cms_collections,cms_documents,cms_documents_links,cms_editorial_custom,cms_editorial_custom_lists,cms_editorial_custom_values,cms_editorial_fields_global_index,cms_editorial_publications_states,cms_editorial_types,cms_editorial_words_global_index,cms_hash,cms_managed_modules,cms_modules_extensions_datas,cms_pages,cms_pages_env,cms_sections,cms_sections_descriptors,cms_vars,cms_version,collection_custom,collection_custom_lists,collection_custom_values,collections,collections_state,collstate_custom,collstate_custom_lists,collstate_custom_values,comptes,connectors,connectors_categ,connectors_categ_sources,connectors_out,connectors_out_oai_deleted_records,connectors_out_oai_tokens,connectors_out_setcache_values,connectors_out_setcaches,connectors_out_setcateg_sets,connectors_out_setcategs,connectors_out_sets,connectors_out_sources,connectors_out_sources_esgroups,connectors_sources,coordonnees,demandes,demandes_actions,demandes_custom,demandes_custom_lists,demandes_custom_values,demandes_notes,demandes_theme,demandes_type,demandes_users,docs_codestat,docs_location,docs_section,docs_statut,docs_type,docsloc_section,docwatch_categories,docwatch_datasources,docwatch_items,docwatch_items_descriptors,docwatch_items_tags,docwatch_selectors,docwatch_tags,docwatch_watches,dsi_archive,editions_states,empr,empr_caddie,empr_caddie_content,empr_caddie_procs,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_grilles,empr_groupe,empr_statut,empty_words_calculs,entites,entrepot_source_1,entrepot_source_2,entrepot_source_3,entrepot_source_4,entrepot_source_5,entrepot_source_6,entrepot_source_7,entrepot_source_8,entrepots_localisations,equations,error_log,es_cache,es_cache_blob,es_cache_int,es_converted_cache,es_esgroup_esusers,es_esgroups,es_esusers,es_methods,es_methods_users,es_searchcache,es_searchsessions,etagere,etagere_caddie,exemplaires,exemplaires_temp,exercices,expl_custom,expl_custom_lists,expl_custom_values,explnum,explnum_doc,explnum_doc_actions,explnum_doc_sugg,explnum_location,explnum_segments,explnum_speakers,explnum_statut,external_count,facettes,faq_questions,faq_questions_categories,faq_questions_fields_global_index,faq_questions_words_global_index,faq_themes,faq_types,fiche,frais,gestfic0_custom,gestfic0_custom_lists,gestfic0_custom_values,grilles,groupe,groupexpl,groupexpl_expl,harvest_field,harvest_profil,harvest_profil_import,harvest_profil_import_field,harvest_search_field,harvest_src,import_marc,index_concept,indexint,indexint_custom,indexint_custom_lists,indexint_custom_values,infopages,lenders,liens_actes,lignes_actes,lignes_actes_relances,lignes_actes_statuts,linked_mots,log_expl_retard,log_retard,logopac,mailtpl,map_echelles,map_emprises,map_hold_areas,map_projections,map_refs,mots,noeuds,nomenclature_children_records,nomenclature_exotic_instruments,nomenclature_exotic_other_instruments,nomenclature_families,nomenclature_formations,nomenclature_instruments,nomenclature_musicstands,nomenclature_notices_nomenclatures,nomenclature_types,nomenclature_voices,nomenclature_workshops,nomenclature_workshops_instruments,notice_onglet,notice_statut,notice_tpl,notice_tplcode,notices,notices_authorities_sources,notices_authperso,notices_categories,notices_custom,notices_custom_lists,notices_custom_values,notices_externes,notices_fields_global_index,notices_global_index,notices_langues,notices_mots_global_index,notices_relations,notices_titres_uniformes,offres_remises,onto_uri,opac_filters,opac_liste_lecture,opac_sessions,opac_view_notices_1,opac_views,opac_views_empr,origin_authorities,origine_notice,ouvertures,paiements,param_subst,parametres,pclassement,perio_relance,planificateur,pret,pret_archive,pret_custom,pret_custom_lists,pret_custom_values,procs,procs_classements,publisher_custom,publisher_custom_lists,publisher_custom_values,publishers,quotas,quotas_finance,quotas_opac_views,rapport_demandes,rdfstore_index,recouvrements,resa,resa_archive,resa_loc,resa_planning,resa_ranger,responsability,responsability_tu,rss_content,rss_flux,rss_flux_content,rubriques,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,search_cache,search_perso,search_persopac,search_persopac_empr_categ,serialcirc,serialcirc_ask,serialcirc_circ,serialcirc_copy,serialcirc_diff,serialcirc_expl,serialcirc_group,serialcirc_tpl,serie_custom,serie_custom_lists,serie_custom_values,series,sessions,shorturls,skos_fields_global_index,skos_words_global_index,source_sync,sources_enrichment,statopac,statopac_request,statopac_vues,statopac_vues_col,storages,sub_collections,subcollection_custom,subcollection_custom_lists,subcollection_custom_values,suggestions,suggestions_categ,suggestions_origine,suggestions_source,sur_location,taches,taches_docnum,taches_type,tags,thesaurus,titres_uniformes,transacash,transactions,transactype,transferts,transferts_demande,transferts_source,translation,tris,tu_custom,tu_custom_lists,tu_custom_values,tu_distrib,tu_ref,tu_subdiv,tva_achats,type_abts,type_comptes,types_produits,upload_repertoire,users,users_groups,vedette,vedette_link,vedette_object,visionneuse_params,voir_aussi,words,z_attr,z_bib,z_notices,z_query');

--
-- Table structure for table `search_cache`
--

CREATE TABLE search_cache (
  object_id varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  delete_on_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `value` mediumblob NOT NULL,
  PRIMARY KEY (object_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_cache`
--


--
-- Table structure for table `search_perso`
--

CREATE TABLE search_perso (
  search_id int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_user int(8) unsigned NOT NULL DEFAULT '0',
  search_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_shortname varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_query mediumtext COLLATE utf8_unicode_ci NOT NULL,
  search_human mediumtext COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  autorisations mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (search_id)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_perso`
--

INSERT INTO search_perso (search_id, num_user, search_name, search_shortname, search_query, search_human, search_directlink, autorisations) VALUES (12,3,'Champignons','Champi','a:2:{s:6:\"SEARCH\";a:1:{i:0;s:4:\"f_42\";}i:0;a:5:{s:6:\"SEARCH\";s:4:\"f_42\";s:2:\"OP\";s:7:\"BOOLEAN\";s:5:\"FIELD\";a:1:{i:0;s:11:\"champignon*\";}s:5:\"INTER\";N;s:8:\"FIELDVAR\";N;}}',' <i><strong>Tous les champs</strong> Expression bool&eacute;enne (champignon*)</i> ',1,'3');

--
-- Table structure for table `search_persopac`
--

CREATE TABLE search_persopac (
  search_id int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_empr int(8) unsigned NOT NULL DEFAULT '0',
  search_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_shortname varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_query mediumtext COLLATE utf8_unicode_ci NOT NULL,
  search_human mediumtext COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  search_limitsearch tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (search_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_persopac`
--


--
-- Table structure for table `search_persopac_empr_categ`
--

CREATE TABLE search_persopac_empr_categ (
  id_categ_empr int(11) NOT NULL DEFAULT '0',
  id_search_persopac int(11) NOT NULL DEFAULT '0',
  KEY i_id_s_persopac (id_search_persopac),
  KEY i_id_categ_empr (id_categ_empr)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_persopac_empr_categ`
--


--
-- Table structure for table `serialcirc`
--

CREATE TABLE serialcirc (
  id_serialcirc int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_abt int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_virtual int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_duration int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_checked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_retard_mode int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_resa int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_copy int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_send_ask int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_subscription int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_duration_before_send int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_statut_circ int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_statut_circ_after int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_state int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_tpl mediumtext COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_piedpage text COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_no_ret int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_sort_diff text COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_simple int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc`
--


--
-- Table structure for table `serialcirc_ask`
--

CREATE TABLE serialcirc_ask (
  id_serialcirc_ask int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_ask_perio int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_ask_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_ask_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_statut int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_ask_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_ask)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_ask`
--


--
-- Table structure for table `serialcirc_circ`
--

CREATE TABLE serialcirc_circ (
  id_serialcirc_circ int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_circ_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_expl int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_empr int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_order int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_subscription int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_hold_asked int(11) NOT NULL DEFAULT '0',
  serialcirc_circ_ret_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_trans_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_trans_doc_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_expected_date datetime DEFAULT NULL,
  serialcirc_circ_pointed_date datetime DEFAULT NULL,
  PRIMARY KEY (id_serialcirc_circ)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_circ`
--


--
-- Table structure for table `serialcirc_copy`
--

CREATE TABLE serialcirc_copy (
  id_serialcirc_copy int(11) NOT NULL AUTO_INCREMENT,
  num_serialcirc_copy_empr int(11) NOT NULL DEFAULT '0',
  num_serialcirc_copy_bulletin int(11) NOT NULL DEFAULT '0',
  serialcirc_copy_analysis mediumtext COLLATE utf8_unicode_ci,
  serialcirc_copy_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_copy_state int(11) NOT NULL DEFAULT '0',
  serialcirc_copy_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_copy)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_copy`
--


--
-- Table structure for table `serialcirc_diff`
--

CREATE TABLE serialcirc_diff (
  id_serialcirc_diff int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_diff_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_empr_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_type_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_diff_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_group_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirc_diff_duration int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_order int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc_diff)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_diff`
--


--
-- Table structure for table `serialcirc_expl`
--

CREATE TABLE serialcirc_expl (
  id_serialcirc_expl int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_expl_id int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_bulletine_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_expl_state_circ int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_serialcirc_diff int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_ret_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_trans_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_trans_doc_asked int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_current_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_start_date date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (id_serialcirc_expl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_expl`
--


--
-- Table structure for table `serialcirc_group`
--

CREATE TABLE serialcirc_group (
  id_serialcirc_group int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_group_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_group_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_group_responsable int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_group_order int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc_group)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_group`
--


--
-- Table structure for table `serialcirc_tpl`
--

CREATE TABLE serialcirc_tpl (
  serialcirctpl_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  serialcirctpl_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirctpl_comment varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirctpl_tpl text COLLATE utf8_unicode_ci NOT NULL,
  serialcirctpl_piedpage text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (serialcirctpl_id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_tpl`
--

INSERT INTO serialcirc_tpl (serialcirctpl_id, serialcirctpl_name, serialcirctpl_comment, serialcirctpl_tpl, serialcirctpl_piedpage) VALUES (1,'Template PMB','','a:3:{i:0;a:3:{s:4:\"type\";s:4:\"name\";s:2:\"id\";s:1:\"0\";s:5:\"label\";N;}i:1;a:3:{s:4:\"type\";s:5:\"ville\";s:2:\"id\";s:1:\"0\";s:5:\"label\";N;}i:2;a:3:{s:4:\"type\";s:5:\"libre\";s:2:\"id\";s:1:\"0\";s:5:\"label\";s:9:\"SIGNATURE\";}}','');

--
-- Table structure for table `serie_custom`
--

CREATE TABLE serie_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_type int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom`
--


--
-- Table structure for table `serie_custom_lists`
--

CREATE TABLE serie_custom_lists (
  serie_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  serie_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (serie_custom_champ),
  KEY editorial_champ_list_value (serie_custom_champ,serie_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom_lists`
--


--
-- Table structure for table `serie_custom_values`
--

CREATE TABLE serie_custom_values (
  serie_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  serie_custom_text text COLLATE utf8_unicode_ci,
  serie_custom_integer int(11) DEFAULT NULL,
  serie_custom_date date DEFAULT NULL,
  serie_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (serie_custom_champ),
  KEY editorial_custom_origine (serie_custom_origine),
  KEY i_scv_st (serie_custom_small_text),
  KEY i_scv_t (serie_custom_text(255)),
  KEY i_scv_i (serie_custom_integer),
  KEY i_scv_d (serie_custom_date),
  KEY i_scv_f (serie_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom_values`
--


--
-- Table structure for table `series`
--

CREATE TABLE series (
  serie_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  serie_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serie_index mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (serie_id)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `series`
--

INSERT INTO series (serie_id, serie_name, serie_index) VALUES (1,'Aya de Yopougon',' aya yopougon ');
INSERT INTO series (serie_id, serie_name, serie_index) VALUES (2,'Jojo',' jojo ');
INSERT INTO series (serie_id, serie_name, serie_index) VALUES (3,'Les annales du disque-monde',' annales disque monde ');

--
-- Table structure for table `sessions`
--

CREATE TABLE sessions (
  SESSID varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  login varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  IP varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  SESSstart varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  LastOn varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  SESSNAME varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  notifications text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `shorturls`
--

CREATE TABLE shorturls (
  id_shorturl int(10) unsigned NOT NULL AUTO_INCREMENT,
  shorturl_hash varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  shorturl_last_access datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  shorturl_context text COLLATE utf8_unicode_ci NOT NULL,
  shorturl_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  shorturl_action varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_shorturl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `shorturls`
--


--
-- Table structure for table `skos_fields_global_index`
--

CREATE TABLE skos_fields_global_index (
  id_item int(10) unsigned NOT NULL DEFAULT '0',
  code_champ int(3) unsigned NOT NULL DEFAULT '0',
  code_ss_champ int(3) unsigned NOT NULL DEFAULT '0',
  ordre int(4) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  pond int(4) unsigned NOT NULL DEFAULT '100',
  lang varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  authority_num varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (id_item,code_champ,code_ss_champ,lang,ordre),
  KEY i_value (`value`(300)),
  KEY i_code_champ_code_ss_champ (code_champ,code_ss_champ)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_fields_global_index`
--


--
-- Table structure for table `skos_words_global_index`
--

CREATE TABLE skos_words_global_index (
  id_item int(10) unsigned NOT NULL DEFAULT '0',
  code_champ int(10) unsigned NOT NULL DEFAULT '0',
  code_ss_champ int(10) unsigned NOT NULL DEFAULT '0',
  num_word int(10) unsigned NOT NULL DEFAULT '0',
  pond int(10) unsigned NOT NULL DEFAULT '100',
  position int(10) unsigned NOT NULL DEFAULT '1',
  field_position int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (id_item,code_champ,num_word,position,code_ss_champ),
  KEY code_champ (code_champ),
  KEY i_id_mot (num_word,id_item),
  KEY i_code_champ_code_ss_champ_num_word (code_champ,code_ss_champ,num_word)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_words_global_index`
--


--
-- Table structure for table `source_sync`
--

CREATE TABLE source_sync (
  source_id int(10) unsigned NOT NULL DEFAULT '0',
  nrecu varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ntotal varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  message varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  date_sync datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  percent int(10) unsigned NOT NULL DEFAULT '0',
  env mediumtext COLLATE utf8_unicode_ci NOT NULL,
  cancel int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (source_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `source_sync`
--

INSERT INTO source_sync (source_id, nrecu, ntotal, message, date_sync, percent, env, cancel) VALUES (5,'','','','2012-12-11 18:55:08',0,'',2);

--
-- Table structure for table `sources_enrichment`
--

CREATE TABLE sources_enrichment (
  source_enrichment_num int(11) NOT NULL DEFAULT '0',
  source_enrichment_typnotice varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  source_enrichment_typdoc varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  source_enrichment_params mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (source_enrichment_num,source_enrichment_typnotice,source_enrichment_typdoc),
  KEY i_s_enrichment_typnoti (source_enrichment_typnotice),
  KEY i_s_enrichment_typdoc (source_enrichment_typdoc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sources_enrichment`
--

INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (2,'m','','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','g','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (4,'m','g','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','j','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (4,'m','j','');

--
-- Table structure for table `statopac`
--

CREATE TABLE statopac (
  id_log int(8) unsigned NOT NULL AUTO_INCREMENT,
  date_log timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  url_demandee varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  url_referente varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  get_log blob NOT NULL,
  post_log blob NOT NULL,
  num_session varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  server_log blob NOT NULL,
  empr_carac blob NOT NULL,
  empr_doc blob NOT NULL,
  empr_expl blob NOT NULL,
  nb_result blob NOT NULL,
  gen_stat blob NOT NULL,
  PRIMARY KEY (id_log),
  KEY sopac_date_log (date_log)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac`
--


--
-- Table structure for table `statopac_request`
--

CREATE TABLE statopac_request (
  idproc int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  num_vue mediumint(8) NOT NULL DEFAULT '0',
  autorisations longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (idproc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_request`
--


--
-- Table structure for table `statopac_vues`
--

CREATE TABLE statopac_vues (
  id_vue int(8) unsigned NOT NULL AUTO_INCREMENT,
  date_consolidation datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  nom_vue varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  date_debut_log datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_fin_log datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (id_vue)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_vues`
--


--
-- Table structure for table `statopac_vues_col`
--

CREATE TABLE statopac_vues_col (
  id_col int(8) unsigned NOT NULL AUTO_INCREMENT,
  nom_col varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  expression varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_vue mediumint(8) NOT NULL DEFAULT '0',
  ordre mediumint(8) NOT NULL DEFAULT '0',
  filtre varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  maj_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_col)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_vues_col`
--


--
-- Table structure for table `storages`
--

CREATE TABLE storages (
  id_storage int(10) unsigned NOT NULL AUTO_INCREMENT,
  storage_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  storage_class varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  storage_params text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_storage),
  KEY i_storage_class (storage_class)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `storages`
--


--
-- Table structure for table `sub_collections`
--

CREATE TABLE sub_collections (
  sub_coll_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  sub_coll_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sub_coll_parent mediumint(9) unsigned NOT NULL DEFAULT '0',
  sub_coll_issn varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  index_sub_coll mediumtext COLLATE utf8_unicode_ci,
  subcollection_web mediumtext COLLATE utf8_unicode_ci NOT NULL,
  subcollection_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  authority_import_denied int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (sub_coll_id),
  KEY sub_coll_name (sub_coll_name)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sub_collections`
--

INSERT INTO sub_collections (sub_coll_id, sub_coll_name, sub_coll_parent, sub_coll_issn, index_sub_coll, subcollection_web, subcollection_comment, authority_import_denied) VALUES (1,'Science-fiction',21,'',' science fiction ','','',0);
INSERT INTO sub_collections (sub_coll_id, sub_coll_name, sub_coll_parent, sub_coll_issn, index_sub_coll, subcollection_web, subcollection_comment, authority_import_denied) VALUES (2,'Fantastique',28,'',' fantastique ','','',0);

--
-- Table structure for table `subcollection_custom`
--

CREATE TABLE subcollection_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_type int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom`
--


--
-- Table structure for table `subcollection_custom_lists`
--

CREATE TABLE subcollection_custom_lists (
  subcollection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  subcollection_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (subcollection_custom_champ),
  KEY editorial_champ_list_value (subcollection_custom_champ,subcollection_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom_lists`
--


--
-- Table structure for table `subcollection_custom_values`
--

CREATE TABLE subcollection_custom_values (
  subcollection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  subcollection_custom_text text COLLATE utf8_unicode_ci,
  subcollection_custom_integer int(11) DEFAULT NULL,
  subcollection_custom_date date DEFAULT NULL,
  subcollection_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (subcollection_custom_champ),
  KEY editorial_custom_origine (subcollection_custom_origine),
  KEY i_scv_st (subcollection_custom_small_text),
  KEY i_scv_t (subcollection_custom_text(255)),
  KEY i_scv_i (subcollection_custom_integer),
  KEY i_scv_d (subcollection_custom_date),
  KEY i_scv_f (subcollection_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom_values`
--


--
-- Table structure for table `suggestions`
--

CREATE TABLE suggestions (
  id_suggestion int(12) unsigned NOT NULL AUTO_INCREMENT,
  titre text COLLATE utf8_unicode_ci NOT NULL,
  editeur varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  auteur varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  prix float(8,2) unsigned NOT NULL DEFAULT '0.00',
  commentaires mediumtext COLLATE utf8_unicode_ci,
  commentaires_gestion text COLLATE utf8_unicode_ci,
  statut int(3) unsigned NOT NULL DEFAULT '0',
  num_produit int(8) NOT NULL DEFAULT '0',
  num_entite int(5) NOT NULL DEFAULT '0',
  index_suggestion mediumtext COLLATE utf8_unicode_ci NOT NULL,
  nb int(5) unsigned NOT NULL DEFAULT '1',
  date_creation date NOT NULL DEFAULT '0000-00-00',
  date_decision date NOT NULL DEFAULT '0000-00-00',
  num_rubrique int(8) unsigned NOT NULL DEFAULT '0',
  num_fournisseur int(5) unsigned NOT NULL DEFAULT '0',
  num_notice int(8) unsigned NOT NULL DEFAULT '0',
  url_suggestion varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_categ int(12) NOT NULL DEFAULT '1',
  sugg_location smallint(5) unsigned NOT NULL DEFAULT '0',
  sugg_source int(8) NOT NULL DEFAULT '0',
  date_publication varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  notice_unimarc blob NOT NULL,
  PRIMARY KEY (id_suggestion)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions`
--


--
-- Table structure for table `suggestions_categ`
--

CREATE TABLE suggestions_categ (
  id_categ int(12) NOT NULL AUTO_INCREMENT,
  libelle_categ varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_categ)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_categ`
--

INSERT INTO suggestions_categ (id_categ, libelle_categ) VALUES (1,'catégorie par défaut');

--
-- Table structure for table `suggestions_origine`
--

CREATE TABLE suggestions_origine (
  origine varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_suggestion int(12) unsigned NOT NULL DEFAULT '0',
  type_origine int(3) unsigned NOT NULL DEFAULT '0',
  date_suggestion date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (origine,num_suggestion,type_origine),
  KEY i_origine (origine,type_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_origine`
--


--
-- Table structure for table `suggestions_source`
--

CREATE TABLE suggestions_source (
  id_source int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle_source varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_source)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_source`
--


--
-- Table structure for table `sur_location`
--

CREATE TABLE sur_location (
  surloc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  surloc_libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_pic varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_visible_opac tinyint(1) unsigned NOT NULL DEFAULT '1',
  surloc_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_cp varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_town varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_state varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_country varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_phone varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_email varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_website varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_logo varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  surloc_num_infopage int(6) unsigned NOT NULL DEFAULT '0',
  surloc_css_style varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (surloc_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sur_location`
--


--
-- Table structure for table `taches`
--

CREATE TABLE taches (
  id_tache int(11) unsigned NOT NULL AUTO_INCREMENT,
  num_planificateur int(11) DEFAULT NULL,
  start_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  end_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  msg_statut blob,
  commande int(8) NOT NULL DEFAULT '0',
  next_state int(8) NOT NULL DEFAULT '0',
  msg_commande blob,
  indicat_progress int(3) DEFAULT NULL,
  rapport mediumtext COLLATE utf8_unicode_ci,
  id_process int(8) DEFAULT NULL,
  PRIMARY KEY (id_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches`
--


--
-- Table structure for table `taches_docnum`
--

CREATE TABLE taches_docnum (
  id_tache_docnum int(11) unsigned NOT NULL AUTO_INCREMENT,
  tache_docnum_nomfichier varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  tache_docnum_mimetype varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  tache_docnum_data mediumblob NOT NULL,
  tache_docnum_extfichier varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  tache_docnum_repertoire int(8) DEFAULT NULL,
  tache_docnum_path mediumtext COLLATE utf8_unicode_ci NOT NULL,
  num_tache int(11) NOT NULL,
  PRIMARY KEY (id_tache_docnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches_docnum`
--


--
-- Table structure for table `taches_type`
--

CREATE TABLE taches_type (
  id_type_tache int(11) unsigned NOT NULL,
  parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  timeout int(11) NOT NULL DEFAULT '5',
  histo_day int(11) NOT NULL DEFAULT '7',
  histo_number int(11) NOT NULL DEFAULT '3',
  restart_on_failure int(1) unsigned NOT NULL DEFAULT '0',
  alert_mail_on_failure varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (id_type_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches_type`
--


--
-- Table structure for table `tags`
--

CREATE TABLE tags (
  id_tag mediumint(8) NOT NULL AUTO_INCREMENT,
  libelle varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_notice mediumint(8) NOT NULL DEFAULT '0',
  user_code varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  dateajout timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id_tag)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tags`
--


--
-- Table structure for table `thesaurus`
--

CREATE TABLE thesaurus (
  id_thesaurus int(3) unsigned NOT NULL AUTO_INCREMENT,
  libelle_thesaurus varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  langue_defaut varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  active char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  opac_active char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  num_noeud_racine int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_thesaurus),
  UNIQUE KEY libelle_thesaurus (libelle_thesaurus)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `thesaurus`
--

INSERT INTO thesaurus (id_thesaurus, libelle_thesaurus, langue_defaut, active, opac_active, num_noeud_racine) VALUES (1,'Agneaux','fr_FR','1','1',1);

--
-- Table structure for table `titres_uniformes`
--

CREATE TABLE titres_uniformes (
  tu_id int(9) unsigned NOT NULL AUTO_INCREMENT,
  tu_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_tonalite varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  index_tu mediumtext COLLATE utf8_unicode_ci NOT NULL,
  tu_import_denied int(10) unsigned NOT NULL DEFAULT '0',
  tu_num_author bigint(11) unsigned NOT NULL DEFAULT '0',
  tu_forme varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_date varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_date_date date NOT NULL DEFAULT '0000-00-00',
  tu_sujet text COLLATE utf8_unicode_ci NOT NULL,
  tu_lieu varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_histoire text COLLATE utf8_unicode_ci,
  tu_caracteristique text COLLATE utf8_unicode_ci,
  tu_public varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_contexte text COLLATE utf8_unicode_ci,
  tu_coordonnees varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_equinoxe varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_completude int(2) unsigned NOT NULL DEFAULT '0',
  tu_tonalite_marclist varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_forme_marclist varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (tu_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `titres_uniformes`
--


--
-- Table structure for table `transacash`
--

CREATE TABLE transacash (
  transacash_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  transacash_empr_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_desk_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_user_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  transacash_sold float NOT NULL DEFAULT '0',
  transacash_collected float NOT NULL DEFAULT '0',
  transacash_rendering float NOT NULL DEFAULT '0',
  PRIMARY KEY (transacash_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transacash`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE transactions (
  id_transaction int(10) unsigned NOT NULL AUTO_INCREMENT,
  compte_id int(8) unsigned NOT NULL DEFAULT '0',
  user_id int(10) unsigned NOT NULL DEFAULT '0',
  user_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  machine varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  date_enrgt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_prevue date DEFAULT NULL,
  date_effective date DEFAULT NULL,
  montant decimal(16,2) NOT NULL DEFAULT '0.00',
  sens int(1) NOT NULL DEFAULT '0',
  realisee int(1) NOT NULL DEFAULT '0',
  commentaire mediumtext COLLATE utf8_unicode_ci,
  encaissement int(1) NOT NULL DEFAULT '0',
  transactype_num int(10) unsigned NOT NULL DEFAULT '0',
  cashdesk_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_num int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_transaction)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO transactions (id_transaction, compte_id, user_id, user_name, machine, date_enrgt, date_prevue, date_effective, montant, sens, realisee, commentaire, encaissement, transactype_num, cashdesk_num, transacash_num) VALUES (1,1,1,'admin','127.0.0.1','2012-10-24 10:47:37','2012-10-24',NULL,2.85,-1,0,'Amende exemplaire 30',0,0,0,0);

--
-- Table structure for table `transactype`
--

CREATE TABLE transactype (
  transactype_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  transactype_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  transactype_quick_allowed int(10) unsigned NOT NULL DEFAULT '0',
  transactype_unit_price float NOT NULL DEFAULT '0',
  PRIMARY KEY (transactype_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transactype`
--


--
-- Table structure for table `transferts`
--

CREATE TABLE transferts (
  id_transfert int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_notice int(10) unsigned NOT NULL DEFAULT '0',
  num_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  date_creation date NOT NULL,
  type_transfert int(5) unsigned NOT NULL DEFAULT '0',
  etat_transfert tinyint(3) unsigned NOT NULL DEFAULT '0',
  origine int(5) unsigned NOT NULL DEFAULT '0',
  origine_comp varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source` smallint(5) unsigned DEFAULT NULL,
  destinations varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  date_retour date DEFAULT NULL,
  motif varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_transfert),
  KEY etat_transfert (etat_transfert)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts`
--


--
-- Table structure for table `transferts_demande`
--

CREATE TABLE transferts_demande (
  id_transfert_demande int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_transfert int(10) unsigned NOT NULL DEFAULT '0',
  date_creation date NOT NULL,
  sens_transfert tinyint(3) unsigned NOT NULL DEFAULT '0',
  num_location_source smallint(5) unsigned NOT NULL DEFAULT '0',
  num_location_dest smallint(5) unsigned NOT NULL DEFAULT '0',
  num_expl int(10) unsigned NOT NULL DEFAULT '0',
  etat_demande tinyint(3) unsigned NOT NULL DEFAULT '0',
  date_visualisee date DEFAULT NULL,
  date_envoyee date DEFAULT NULL,
  date_reception date DEFAULT NULL,
  motif_refus varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  statut_origine int(10) unsigned NOT NULL DEFAULT '0',
  section_origine int(10) unsigned NOT NULL DEFAULT '0',
  resa_trans int(8) unsigned NOT NULL DEFAULT '0',
  resa_arc_trans int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_transfert_demande),
  KEY num_transfert (num_transfert),
  KEY num_location_source (num_location_source),
  KEY num_location_dest (num_location_dest),
  KEY num_expl (num_expl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts_demande`
--


--
-- Table structure for table `transferts_source`
--

CREATE TABLE transferts_source (
  trans_source_numexpl int(10) unsigned NOT NULL DEFAULT '0',
  trans_source_numloc int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (trans_source_numexpl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts_source`
--


--
-- Table structure for table `translation`
--

CREATE TABLE translation (
  trans_table varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_field varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_lang varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_num int(8) unsigned NOT NULL DEFAULT '0',
  trans_text varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (trans_table,trans_field,trans_lang,trans_num),
  KEY i_lang (trans_lang)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `translation`
--


--
-- Table structure for table `tris`
--

CREATE TABLE tris (
  id_tri int(4) NOT NULL AUTO_INCREMENT,
  tri_par varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  nom_tri varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tri_reference varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'notices',
  PRIMARY KEY (id_tri)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tris`
--

INSERT INTO tris (id_tri, tri_par, nom_tri, tri_reference) VALUES (1,'d_num_19','Date de publication d&eacute;croissante','notices');

--
-- Table structure for table `tu_custom`
--

CREATE TABLE tu_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_type int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_custom`
--


--
-- Table structure for table `tu_custom_lists`
--

CREATE TABLE tu_custom_lists (
  tu_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  tu_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  tu_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (tu_custom_champ),
  KEY editorial_champ_list_value (tu_custom_champ,tu_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_custom_lists`
--


--
-- Table structure for table `tu_custom_values`
--

CREATE TABLE tu_custom_values (
  tu_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  tu_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  tu_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  tu_custom_text text COLLATE utf8_unicode_ci,
  tu_custom_integer int(11) DEFAULT NULL,
  tu_custom_date date DEFAULT NULL,
  tu_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (tu_custom_champ),
  KEY editorial_custom_origine (tu_custom_origine),
  KEY i_tcv_st (tu_custom_small_text),
  KEY i_tcv_t (tu_custom_text(255)),
  KEY i_tcv_i (tu_custom_integer),
  KEY i_tcv_d (tu_custom_date),
  KEY i_tcv_f (tu_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_custom_values`
--


--
-- Table structure for table `tu_distrib`
--

CREATE TABLE tu_distrib (
  distrib_num_tu int(9) unsigned NOT NULL DEFAULT '0',
  distrib_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  distrib_ordre smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (distrib_num_tu,distrib_ordre)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_distrib`
--


--
-- Table structure for table `tu_ref`
--

CREATE TABLE tu_ref (
  ref_num_tu int(9) unsigned NOT NULL DEFAULT '0',
  ref_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ref_ordre smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (ref_num_tu,ref_ordre)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_ref`
--


--
-- Table structure for table `tu_subdiv`
--

CREATE TABLE tu_subdiv (
  subdiv_num_tu int(9) unsigned NOT NULL DEFAULT '0',
  subdiv_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  subdiv_ordre smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (subdiv_num_tu,subdiv_ordre)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_subdiv`
--


--
-- Table structure for table `tva_achats`
--

CREATE TABLE tva_achats (
  id_tva int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  taux_tva float(4,2) unsigned NOT NULL DEFAULT '0.00',
  num_cp_compta varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (id_tva)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tva_achats`
--

INSERT INTO tva_achats (id_tva, libelle, taux_tva, num_cp_compta) VALUES (1,'7',7.00,'');

--
-- Table structure for table `type_abts`
--

CREATE TABLE type_abts (
  id_type_abt int(5) unsigned NOT NULL AUTO_INCREMENT,
  type_abt_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  prepay int(1) unsigned NOT NULL DEFAULT '0',
  prepay_deflt_mnt decimal(16,2) NOT NULL DEFAULT '0.00',
  tarif decimal(16,2) NOT NULL DEFAULT '0.00',
  commentaire mediumtext COLLATE utf8_unicode_ci NOT NULL,
  caution decimal(16,2) NOT NULL DEFAULT '0.00',
  localisations varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_type_abt)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `type_abts`
--


--
-- Table structure for table `type_comptes`
--

CREATE TABLE type_comptes (
  id_type_compte int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  type_acces int(8) unsigned NOT NULL DEFAULT '0',
  acces_id mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_type_compte)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `type_comptes`
--


--
-- Table structure for table `types_produits`
--

CREATE TABLE types_produits (
  id_produit int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_cp_compta varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  num_tva_achat varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (id_produit),
  KEY libelle (libelle)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `types_produits`
--


--
-- Table structure for table `upload_repertoire`
--

CREATE TABLE upload_repertoire (
  repertoire_id int(8) unsigned NOT NULL AUTO_INCREMENT,
  repertoire_nom varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  repertoire_url mediumtext COLLATE utf8_unicode_ci NOT NULL,
  repertoire_path mediumtext COLLATE utf8_unicode_ci NOT NULL,
  repertoire_navigation int(1) NOT NULL DEFAULT '0',
  repertoire_hachage int(1) NOT NULL DEFAULT '0',
  repertoire_subfolder int(8) NOT NULL DEFAULT '0',
  repertoire_utf8 int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (repertoire_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `upload_repertoire`
--


--
-- Table structure for table `users`
--

CREATE TABLE users (
  userid int(5) NOT NULL AUTO_INCREMENT,
  create_dt date NOT NULL DEFAULT '0000-00-00',
  last_updated_dt date NOT NULL DEFAULT '0000-00-00',
  username varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  pwd varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  user_digest varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  nom varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  prenom varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  rights int(8) unsigned NOT NULL DEFAULT '0',
  user_lang varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  nb_per_page_search int(10) unsigned NOT NULL DEFAULT '4',
  nb_per_page_select int(10) unsigned NOT NULL DEFAULT '10',
  nb_per_page_gestion int(10) unsigned NOT NULL DEFAULT '20',
  param_popup_ticket smallint(1) unsigned NOT NULL DEFAULT '0',
  param_sounds smallint(1) unsigned NOT NULL DEFAULT '1',
  param_rfid_activate int(1) NOT NULL DEFAULT '1',
  param_licence int(1) unsigned NOT NULL DEFAULT '0',
  deflt_notice_statut int(6) unsigned NOT NULL DEFAULT '1',
  deflt_integration_notice_statut int(6) NOT NULL DEFAULT '1',
  xmlta_indexation_lang varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  deflt_docs_type int(6) unsigned NOT NULL DEFAULT '1',
  deflt_lenders int(6) unsigned NOT NULL DEFAULT '0',
  deflt_styles varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  deflt_docs_statut int(6) unsigned DEFAULT '0',
  deflt_docs_codestat int(6) unsigned DEFAULT '0',
  value_deflt_lang varchar(20) COLLATE utf8_unicode_ci DEFAULT 'fre',
  value_deflt_fonction varchar(20) COLLATE utf8_unicode_ci DEFAULT '070',
  value_deflt_relation varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  value_deflt_relation_serial varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  value_deflt_relation_bulletin varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  value_deflt_relation_analysis varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  deflt_docs_location int(6) unsigned DEFAULT '0',
  deflt_collstate_location int(6) unsigned DEFAULT '0',
  deflt_bulletinage_location int(6) unsigned NOT NULL DEFAULT '0',
  deflt_resas_location int(6) unsigned DEFAULT '0',
  deflt_docs_section int(6) unsigned DEFAULT '0',
  value_deflt_module varchar(30) COLLATE utf8_unicode_ci DEFAULT 'circu',
  user_email varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  user_alert_resamail int(1) unsigned NOT NULL DEFAULT '0',
  user_alert_demandesmail int(1) unsigned NOT NULL DEFAULT '0',
  user_alert_subscribemail int(1) unsigned NOT NULL DEFAULT '0',
  deflt2docs_location int(6) unsigned NOT NULL DEFAULT '0',
  deflt_empr_statut bigint(20) unsigned NOT NULL DEFAULT '1',
  deflt_thesaurus int(3) unsigned NOT NULL DEFAULT '1',
  deflt_concept_scheme int(3) NOT NULL DEFAULT '-1',
  deflt_import_thesaurus int(11) NOT NULL DEFAULT '1',
  value_prefix_cote tinyblob NOT NULL,
  xmlta_doctype char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  xmlta_doctype_serial varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  xmlta_doctype_bulletin varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  xmlta_doctype_analysis varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  speci_coordonnees_etab longtext COLLATE utf8_unicode_ci NOT NULL,
  value_email_bcc varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  value_deflt_antivol varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  explr_invisible mediumtext COLLATE utf8_unicode_ci,
  explr_visible_mod mediumtext COLLATE utf8_unicode_ci,
  explr_visible_unmod mediumtext COLLATE utf8_unicode_ci,
  deflt3bibli int(5) unsigned NOT NULL DEFAULT '0',
  deflt3exercice int(8) unsigned NOT NULL DEFAULT '0',
  deflt3rubrique int(8) unsigned NOT NULL DEFAULT '0',
  deflt3dev_statut int(3) NOT NULL DEFAULT '-1',
  deflt3cde_statut int(3) NOT NULL DEFAULT '-1',
  deflt3liv_statut int(3) NOT NULL DEFAULT '-1',
  deflt3fac_statut int(3) NOT NULL DEFAULT '-1',
  deflt3sug_statut int(3) NOT NULL DEFAULT '-1',
  environnement mediumblob NOT NULL,
  param_allloc int(1) unsigned NOT NULL DEFAULT '0',
  grp_num int(10) unsigned DEFAULT '0',
  deflt_arch_statut int(6) unsigned NOT NULL DEFAULT '0',
  deflt_arch_emplacement int(6) unsigned NOT NULL DEFAULT '0',
  deflt_arch_type int(6) unsigned NOT NULL DEFAULT '0',
  deflt_upload_repertoire int(8) NOT NULL DEFAULT '0',
  deflt3lgstatdev int(3) NOT NULL DEFAULT '1',
  deflt3lgstatcde int(3) NOT NULL DEFAULT '1',
  deflt3receptsugstat int(3) NOT NULL DEFAULT '32',
  deflt_short_loan_activate int(1) unsigned NOT NULL DEFAULT '0',
  deflt_cashdesk int(11) NOT NULL DEFAULT '0',
  deflt_explnum_statut int(6) unsigned NOT NULL DEFAULT '1',
  user_alert_suggmail int(1) unsigned NOT NULL DEFAULT '0',
  deflt_notice_replace_keep_categories int(1) NOT NULL DEFAULT '0',
  deflt_notice_is_new int(1) unsigned NOT NULL DEFAULT '0',
  deflt_agnostic_warehouse int(6) unsigned NOT NULL DEFAULT '0',
  deflt_cms_article_statut int(6) unsigned NOT NULL DEFAULT '0',
  deflt_cms_article_type int(6) unsigned NOT NULL DEFAULT '0',
  deflt_cms_section_type int(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (userid)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO users (userid, create_dt, last_updated_dt, username, pwd, user_digest, nom, prenom, rights, user_lang, nb_per_page_search, nb_per_page_select, nb_per_page_gestion, param_popup_ticket, param_sounds, param_rfid_activate, param_licence, deflt_notice_statut, deflt_integration_notice_statut, xmlta_indexation_lang, deflt_docs_type, deflt_lenders, deflt_styles, deflt_docs_statut, deflt_docs_codestat, value_deflt_lang, value_deflt_fonction, value_deflt_relation, value_deflt_relation_serial, value_deflt_relation_bulletin, value_deflt_relation_analysis, deflt_docs_location, deflt_collstate_location, deflt_bulletinage_location, deflt_resas_location, deflt_docs_section, value_deflt_module, user_email, user_alert_resamail, user_alert_demandesmail, user_alert_subscribemail, deflt2docs_location, deflt_empr_statut, deflt_thesaurus, deflt_concept_scheme, deflt_import_thesaurus, value_prefix_cote, xmlta_doctype, xmlta_doctype_serial, xmlta_doctype_bulletin, xmlta_doctype_analysis, speci_coordonnees_etab, value_email_bcc, value_deflt_antivol, explr_invisible, explr_visible_mod, explr_visible_unmod, deflt3bibli, deflt3exercice, deflt3rubrique, deflt3dev_statut, deflt3cde_statut, deflt3liv_statut, deflt3fac_statut, deflt3sug_statut, environnement, param_allloc, grp_num, deflt_arch_statut, deflt_arch_emplacement, deflt_arch_type, deflt_upload_repertoire, deflt3lgstatdev, deflt3lgstatcde, deflt3receptsugstat, deflt_short_loan_activate, deflt_cashdesk, deflt_explnum_statut, user_alert_suggmail, deflt_notice_replace_keep_categories, deflt_notice_is_new, deflt_agnostic_warehouse, deflt_cms_article_statut, deflt_cms_article_type, deflt_cms_section_type) VALUES (1,'2002-07-28','2012-12-14','admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441','028262ca7d82187e983fa4a9937891e2','Super User','',198911,'fr_FR',20,20,50,0,0,0,0,1,1,'',1,2,'enjoy',1,12,'fre','070','a-up','a-up','a-up','a-up',1,0,1,0,10,'admin','pmb@sigb.net',0,0,0,1,1,1,0,1,'','a','a','a','a','','','0','0','0','0',0,0,0,-1,-1,-1,-1,-1,'',1,0,1,1,1,0,1,1,64,0,0,1,0,0,0,0,0,0,0);

--
-- Table structure for table `users_groups`
--

CREATE TABLE users_groups (
  grp_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  grp_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (grp_id),
  KEY i_users_groups_grp_name (grp_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users_groups`
--


--
-- Table structure for table `vedette`
--

CREATE TABLE vedette (
  id_vedette int(11) unsigned NOT NULL AUTO_INCREMENT,
  label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  grammar varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'rameau',
  PRIMARY KEY (id_vedette)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vedette`
--


--
-- Table structure for table `vedette_link`
--

CREATE TABLE vedette_link (
  num_vedette int(10) unsigned NOT NULL,
  num_object int(10) unsigned NOT NULL,
  type_object int(10) unsigned NOT NULL,
  PRIMARY KEY (num_vedette,num_object,type_object)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vedette_link`
--


--
-- Table structure for table `vedette_object`
--

CREATE TABLE vedette_object (
  object_type int(3) unsigned NOT NULL DEFAULT '0',
  object_id int(11) unsigned NOT NULL DEFAULT '0',
  num_vedette int(11) unsigned NOT NULL DEFAULT '0',
  subdivision varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  position int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (object_type,object_id,num_vedette,subdivision,position),
  KEY i_vedette_object_object (object_type,object_id),
  KEY i_vedette_object_vedette (num_vedette)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vedette_object`
--


--
-- Table structure for table `visionneuse_params`
--

CREATE TABLE visionneuse_params (
  visionneuse_params_id int(11) NOT NULL AUTO_INCREMENT,
  visionneuse_params_class varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  visionneuse_params_parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (visionneuse_params_id),
  UNIQUE KEY visionneuse_params_class (visionneuse_params_class)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `visionneuse_params`
--

INSERT INTO visionneuse_params (visionneuse_params_id, visionneuse_params_class, visionneuse_params_parameters) VALUES (1,'epub','a:2:{s:6:&quot;size_x&quot;;s:2:&quot;95&quot;;s:6:&quot;size_y&quot;;s:2:&quot;95&quot;;}');

--
-- Table structure for table `voir_aussi`
--

CREATE TABLE voir_aussi (
  num_noeud_orig int(9) unsigned NOT NULL DEFAULT '0',
  num_noeud_dest int(9) unsigned NOT NULL DEFAULT '0',
  langue varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  comment_voir_aussi mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (num_noeud_orig,num_noeud_dest,langue),
  KEY num_noeud_dest (num_noeud_dest)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `voir_aussi`
--

INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1390,1602,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1391,1599,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1392,1600,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1394,2166,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1395,1596,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1398,1597,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1399,1592,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1400,1601,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1401,1592,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1411,2105,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1413,2106,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1414,2104,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1415,2103,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1416,2102,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1417,2101,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1431,2058,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1435,2060,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1545,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1553,1612,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1563,2493,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1592,1399,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1592,1401,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1595,2479,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1596,1395,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1597,1398,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1598,2200,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1599,1391,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1600,1392,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1601,1400,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1602,1390,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1607,2407,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1612,1553,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1623,1795,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1623,1796,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1628,1737,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1670,2494,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1672,2494,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1726,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1729,2496,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1737,1628,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1760,2280,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1795,1623,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (1796,1623,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2057,2112,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2058,1431,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2060,1435,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2101,1417,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2102,1416,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2103,1415,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2104,1414,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2105,1411,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2106,1413,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2112,2057,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2166,1394,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2184,2485,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2184,2486,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2200,1598,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2280,1760,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2407,1607,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2467,2510,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2479,1595,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2485,2184,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2486,2184,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2490,2495,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2491,1545,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2491,1726,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2491,2496,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2491,2499,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2491,2500,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2492,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2493,2490,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2493,2495,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2494,1670,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2494,1672,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2494,2490,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2495,2493,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2496,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2496,2497,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2497,2496,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2499,2496,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2499,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2499,1689,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2500,2492,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2500,2491,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2500,1689,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2502,2492,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2504,2503,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2507,2509,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2508,1764,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2509,2507,'fr_FR','');
INSERT INTO voir_aussi (num_noeud_orig, num_noeud_dest, langue, comment_voir_aussi) VALUES (2510,1672,'fr_FR','');

--
-- Table structure for table `words`
--

CREATE TABLE words (
  id_word int(10) unsigned NOT NULL AUTO_INCREMENT,
  word varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  lang varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  double_metaphone varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  stem varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_word),
  UNIQUE KEY i_word_lang (word,lang),
  KEY i_stem_lang (stem,lang)
) ENGINE=MyISAM AUTO_INCREMENT=3934 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `words`
--

INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1,'039125','','','039125');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (2,'07','','','07');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (3,'1','','','1');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (4,'125','','','125');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (5,'126','','','126');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (6,'140','','','140');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (7,'18','','','18');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (8,'1820','','','1820');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (9,'1865','','','1865');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (10,'1867','','','1867');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (11,'1897','','','1897');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (12,'1985','','','1985');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (13,'1996','','','1996');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (14,'1997','','','1997');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (15,'1998','','','1998');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (16,'1999','','','1999');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (17,'2','','','2');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (18,'2004','','','2004');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (19,'2062','','','2062');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (20,'20sf','','SF SF','20sf');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (21,'3','','','3');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (22,'330','','','330');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (23,'33700003470461','','','33700003470461');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (24,'33700003868672','','','33700003868672');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (25,'33700004243164','','','33700004243164');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (26,'3370000451296','','','3370000451296');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (27,'3370000451300','','','3370000451300');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (28,'3370000451301','','','3370000451301');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (29,'38','','','38');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (30,'4','','','4');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (31,'47','','','47');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (32,'48','','','48');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (33,'547','','','547');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (34,'551','','','551');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (35,'58','','','58');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (36,'590','','','590');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (37,'62','','','62');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (38,'7','','','7');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (39,'70','','','70');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (40,'7234','','','7234');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (41,'760','','','760');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (42,'780','','','780');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (43,'840','','','840');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (44,'86274','','','86274');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (45,'86967','','','86967');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (46,'910','','','910');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (47,'978','','','978');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (48,'aborigenes','','APRJ APRK','aborigen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (49,'actant','','AKTN AKTN','actant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (50,'acteur','','AKTR AKTR','acteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (51,'adagio','','ATJ ATK','adagio');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (52,'admis','','ATMS ATMS','admis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (53,'adultes','','ATLT ATLT','adult');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (54,'affectueusement','','AFKT AFKT','affectu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (55,'africain','','AFRK AFRK','africain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (56,'afrique','fr_FR','AFRK AFRK','afriqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (57,'aise','','AS AS','ais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (58,'ajouter','','AJTR AHTR','ajout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (59,'albinoni','','ALPN ALPN','albinon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (60,'allie','','AL AL','alli');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (61,'ami','','AM AM','ami');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (62,'andante','','ANTN ANTN','andant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (63,'andreae','','ANTR ANTR','andrea');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (64,'animaux','','ANM ANM','animal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (65,'annees','','ANS ANS','anne');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (66,'anthropologie','','AN0R ANTR','anthropolog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (67,'archeologiques','','ARXL ARKL','archeolog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (68,'argentine','','ARJN ARKN','argentin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (69,'argentine','fr_FR','ARJN ARKN','argentin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (70,'arrondissements','','ARNT ARNT','arrond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (71,'artiodactyles','','ARTT ARTT','artiodactyl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (72,'arts','','ARTS ARTS','art');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (73,'associe','','ASS ASX','assoc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (74,'assure','','ASR ASR','assur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (75,'atlantique','','ATLN ATLN','atlant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (76,'aube','','AP AP','aub');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (77,'audio','','AT AT','audio');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (78,'audios','','ATS ATS','audios');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (79,'australie','','ASTR ASTR','austral');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (80,'australie','fr_FR','ASTR ASTR','austral');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (81,'authentifier','','A0NT ATNT','authentifi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (82,'autour','','ATR ATR','autour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (83,'autres','','ATRS ATRS','autr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (84,'avant','','AFNT AFNT','avant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (85,'aventure','','AFNT AFNT','aventur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (86,'avoir','','AFR AFR','avoir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (87,'ayant','','ANT ANT','ayant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (88,'bach','','PK PK','bach');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (89,'balzac','','PLSK PLSK','balzac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (90,'bande','','PNT PNT','band');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (91,'bande','fr_FR','PNT PNT','band');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (92,'baptiste','','PPTS PPTS','baptist');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (93,'baroques','','PRKS PRKS','baroqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (94,'bdp','','PTP PTP','bdp');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (95,'benard','','PNRT PNRT','benard');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (96,'benjamin','','PNJM PNJM','benjamin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (97,'betises','','PTSS PTSS','betis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (98,'bibliobus','','PPLP PPLP','bibliobus');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (99,'bibliotheque','','PPL0 PPLT','bibliothequ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (100,'bien','','PN PN','bien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (101,'boccherini','','PXRN PXRN','boccherin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (102,'bon','','PN PN','bon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (103,'bonne','','PN PN','bon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (104,'boos','','PS PS','boos');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (105,'bouts','','PTS PTS','bout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (106,'bri','','PR PR','bri');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (107,'brillant','','PRLN PRLN','brill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (108,'bruit','','PRT PRT','bruit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (109,'bruitage','','PRTJ PRTK','bruitag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (110,'bruitages','','PRTJ PRTK','bruitag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (111,'camille','','KML KML','camill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (112,'canon','','KNN KNN','canon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (113,'cantilene','','KNTL KNTL','cantilen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (114,'carte','','KRT KRT','cart');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (115,'cartonne','','KRTN KRTN','carton');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (116,'casimir','','KSMR KSMR','casim');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (117,'cd','','KT KT','cd');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (118,'ce','','S S','ce');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (119,'celebre','','SLPR SLPR','celebr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (120,'central','','SNTR SNTR','central');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (121,'ces','','SS SS','ce');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (122,'cet','','ST ST','cet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (123,'cette','','ST ST','cet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (124,'chainon','','XNN XNN','chainon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (125,'chainons','','XNNS XNNS','chainon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (126,'chateaux','','XT XT','chateau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (127,'cherche','','XRX XRK','cherch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (128,'chirurgien','','XRRJ XRRK','chirurgien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (129,'christian','','KRSX KRSX','christian');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (130,'chrysalide','','KRSL KRSL','chrysalid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (131,'ciel','','SL XL','ciel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (132,'cinema','','SNM SNM','cinem');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (133,'clowns','','KLNS KLNS','clown');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (134,'coc','','KK KK','coc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (135,'cochette','','KXT KKT','cochet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (136,'cochon','','KXN KKN','cochon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (137,'cochons','','KXNS KKNS','cochon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (138,'comme','','KM KM','comm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (139,'compagnon','','KMPN KMPK','compagnon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (140,'compositeur','','KMPS KMPS','compositeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (141,'concerto','','KNSR KNSR','concerto');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (142,'confirme','','KNFR KNFR','confirm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (143,'conjugent','','KNJJ KNJK','conjugent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (144,'connait','','KNT KNT','con');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (145,'conscience','','KNSN KNSN','conscienc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (146,'consommation','','KNSM KNSM','consomm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (147,'consultation','','KNSL KNSL','consult');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (148,'conte','','KNT KNT','cont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (149,'contemporain','','KNTM KNTM','contemporain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (150,'convaincu','','KNFN KNFN','convaincu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (151,'cordes','','KRTS KRTS','cord');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (152,'coul','','KL KL','coul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (153,'couleurs','','KLRS KLRS','couleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (154,'courts','','KRTS KRTS','court');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (155,'couv','','KF KF','couv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (156,'crane','','KRN KRN','cran');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (157,'crimee','','KRM KRM','crime');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (158,'crise','','KRS KRS','cris');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (159,'cruels','','KRLS KRLS','cruel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (160,'dangereusement','','TNJR TNKR','danger');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (161,'dans','','TNS TNS','dan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (162,'debout','','TPT TPT','debout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (163,'decide','','TST TST','decid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (164,'decor','','TKR TKR','decor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (165,'decouvert','','TKFR TKFR','decouvert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (166,'decouverte','','TKFR TKFR','decouvert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (167,'delires','','TLRS TLRS','delir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (168,'demeure','','TMR TMR','demeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (169,'deroule','','TRL TRL','deroul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (170,'desert','','TSRT TSRT','desert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (171,'dessin','fr_FR','TSN TSN','dessin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (172,'dessinee','','TSN TSN','dessine');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (173,'deux','','TKS TKS','deux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (174,'devenu','','TFN TFN','devenu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (175,'diapree','','TPR TPR','diapre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (176,'dieu','','T T','dieu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (177,'document','','TKMN TKMN','docu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (178,'documentaires','','TKMN TKMN','documentair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (179,'doit','','TT TT','doit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (180,'dont','','TNT TNT','dont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (181,'drame','','TRM TRM','dram');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (182,'economie','','AKNM AKNM','econom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (183,'economie','fr_FR','AKNM AKNM','econom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (184,'efficace','','AFKS AFKS','efficac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (185,'enfants','','ANFN ANFN','enfant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (186,'enfin','','ANFN ANFN','enfin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (187,'engluer','','ANKL ANKL','englu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (188,'enregistrement','','ANRJ ANRK','enregistr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (189,'enterrement','','ANTR ANTR','enterr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (190,'entre','','ANTR ANTR','entre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (191,'eploree','','APLR APLR','eplore');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (192,'espoirs','','ASPR ASPR','espoir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (193,'est','','AST AST','est');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (194,'etait','','ATT ATT','etait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (195,'etat','','ATT ATT','etat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (196,'etrangers','','ATRN ATRN','etranger');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (197,'etudes','','ATTS ATTS','etud');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (198,'exactement','','AKSK AKSK','exact');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (199,'exotique','','AKST AKST','exot');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (200,'extrait','','AKST AKST','extrait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (201,'faire','','FR FR','fair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (202,'fait','','FT FT','fait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (203,'fameux','','FMKS FMKS','fameux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (204,'femme','','FM FM','femm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (205,'ferrero','','FRR FRR','ferrero');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (206,'fete','','FT FT','fet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (207,'fichier','','FX FKR','fichi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (208,'fiction','','FKXN FKXN','fiction');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (209,'film','','FLM FLM','film');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (210,'finances','','FNNS FNNS','financ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (211,'fins','','FNS FNS','fin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (212,'fond','','FNT FNT','fond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (213,'fonds','','FNTS FNTS','fond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (214,'foraine','','FRN FRN','forain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (215,'fossiles','','FSLS FSLS','fossil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (216,'fr','','FR FR','fr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (217,'fran','','FRN FRN','fran');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (218,'fuite','','FT FT','fuit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (219,'funeste','','FNST FNST','funest');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (220,'g','','K K','g');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (221,'gal','','KL KL','gal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (222,'gallie','','KL KL','gall');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (223,'garnison','','KRNS KRNS','garnison');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (224,'geo','','J K','geo');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (225,'goret','','KRT KRT','goret');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (226,'grand','','KRNT KRNT','grand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (227,'graphiques','','KRFK KRFK','graphiqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (228,'graphisme','','KRFS KRFS','graphism');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (229,'grave','','KRF KRF','grav');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (230,'groin','','KRN KRN','groin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (231,'guenon','','KNN KNN','guenon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (232,'habilement','','HPLM HPLM','habil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (233,'haut','','HT HT','haut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (234,'heure','','HR HR','heur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (235,'histoire','','HSTR HSTR','histoir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (236,'historique','','HSTR HSTR','histor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (237,'hollandais','','HLNT HLNT','holland');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (238,'hollywood','','HLT HLT','hollywood');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (239,'homme','','HM HM','homm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (240,'http','','TP TP','http');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (241,'hugo','','HK HK','hugo');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (242,'il','','AL AL','il');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (243,'ile','','AL AL','ile');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (244,'ill','','AL AL','ill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (245,'indetermine','','ANTT ANTT','indetermin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (246,'inferieure','','ANFR ANFR','inferieur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (247,'interet','','ANTR ANTR','interet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (248,'intrigue','','ANTR ANTR','intrigu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (249,'investit','','ANFS ANFS','invest');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (250,'ironie','','ARN ARN','iron');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (251,'j','','J A','j');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (252,'jacob','','JKP AKP','jacob');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (253,'java','','JF AF','jav');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (254,'jbd','','JPT APT','jbd');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (255,'jean','','JN AN','jean');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (256,'jesus','','JSS ASS','jesus');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (257,'jeunes','','JNS ANS','jeun');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (258,'jexiste','','JKSS AKSS','jexist');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (259,'joie','','J A','joi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (260,'jour','','JR AR','jour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (261,'journaliste','','JRNL ARNL','journal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (262,'jr','','JR AR','jr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (263,'laisse','','LS LS','laiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (264,'lam','','LM LM','lam');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (265,'lamartine','','LMRT LMRT','lamartin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (266,'lamquet','','LMKT LMKT','lamquet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (267,'lecteur','','LKTR LKTR','lecteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (268,'les','','LS LS','le');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (269,'leur','','LR LR','leur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (270,'leurs','','LRS LRS','leur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (271,'litt','','LT LT','litt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (272,'livre','','LFR LFR','livr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (273,'livre','fr_FR','LFR LFR','livr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (274,'livret','','LFRT LFRT','livret');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (275,'loire','','LR LR','loir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (276,'loire','fr_FR','LR LR','loir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (277,'longue','','LNK LNK','longu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (278,'louables','','LPLS LPLS','louabl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (279,'lucy','','LS LS','lucy');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (280,'lui','','L L','lui');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (281,'ma','','M M','ma');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (282,'machoire','','MKR MKR','machoir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (283,'magie','','MJ MK','mag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (284,'mais','','M MS','mais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (285,'maitres','','MTRS MTRS','maitr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (286,'majeur','','MJR MJR','majeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (287,'mal','','ML ML','mal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (288,'malheurs','','MLRS MLRS','malheur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (289,'malicieux','','MLSK MLXK','malici');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (290,'mammif','fr_FR','MMF MMF','mammif');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (291,'mandoline','','MNTL MNTL','mandolin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (292,'mangecoeur','','MNJK MNKK','mangecoeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (293,'manquant','','MNKN MNKN','manqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (294,'mariages','','MRJS MRKS','mariag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (295,'marigot','','MRKT MRKT','marigot');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (296,'maternite','','MTRN MTRN','maternit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (297,'mathieu','','M0 MT','mathieu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (298,'melange','','MLNJ MLNK','melang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (299,'meme','','MM MM','mem');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (300,'menuet','','MNT MNT','menuet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (301,'merveilleux','','MRFL MRFL','merveil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (302,'meurt','','MRT MRT','meurt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (303,'millions','','MLNS MLNS','million');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (304,'mis','','MS MS','mis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (305,'monde','','MNT MNT','mond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (306,'mondialisation','fr_FR','MNTL MNTL','mondialis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (307,'morceau','','MRS MRS','morceau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (308,'mozart','','MSRT MSRT','mozart');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (309,'mp3','','MP MP','mp3');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (310,'multimedia','','MLTM MLTM','multimedi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (311,'musique','','MSK MSK','musiqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (312,'musset','','MST MST','musset');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (313,'nantes','','NNTS NNTS','nant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (314,'ne','','N N','ne');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (315,'nomment','','NMNT NMNT','nomment');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (316,'notoriete','','NTRT NTRT','notoriet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (317,'nouvelle','','NFL NFL','nouvel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (318,'nouvelles','','NFLS NFLS','nouvel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (319,'nouvelles','fr_FR','NFLS NFLS','nouvel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (320,'occultisme','','AKLT AKLT','occult');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (321,'ocean','','ASN ASN','ocean');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (322,'ographie','','AKRF AKRF','ograph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (323,'on','','AN AN','on');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (324,'ou','','A A','ou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (325,'p','','P P','p');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (326,'pachelbel','','PXLP PKLP','pachelbel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (327,'pages','','PJS PKS','pag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (328,'paimboeuf','','PMPF PMPF','paimboeuf');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (329,'pantagas','','PNTK PNTK','pantag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (330,'papillon','','PPLN PPLN','papillon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (331,'par','','PR PR','par');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (332,'parce','','PRS PRS','parc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (333,'parcourant','','PRKR PRKR','parcour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (334,'passions','','PSNS PSNS','passion');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (335,'pays','fr_FR','PS PS','pay');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (336,'perdu','','PRT PRT','perdu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (337,'pere','','PR PR','per');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (338,'personnage','','PRSN PRSN','personnag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (339,'personnages','','PRSN PRSN','personnag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (340,'pete','','PT PT','pet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (341,'petit','','PTT PTT','pet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (342,'peu','','P P','peu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (343,'peuple','','PPL PPL','peupl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (344,'pistes','','PSTS PSTS','pist');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (345,'pl','','PL PL','pl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (346,'place','','PLS PLS','plac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (347,'plaintive','','PLNT PLNT','plaintiv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (348,'plus','','PLS PLS','plus');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (349,'pmb','','PMP PMP','pmb');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (350,'poisse','','PS PS','poiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (351,'porc','','PRK PRK','porc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (352,'porcelet','','PRSL PRSL','porcelet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (353,'porterait','','PRTR PRTR','port');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (354,'pour','','PR PR','pour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (355,'poursuivi','','PRSF PRSF','poursuiv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (356,'pourtant','','PRTN PRTN','pourt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (357,'precieuses','','PRSS PRXS','precieux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (358,'premier','','PRM PRMR','premi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (359,'principale','','PRNS PRNS','principal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (360,'production','','PRTK PRTK','product');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (361,'propre','','PRPR PRPR','propr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (362,'prouver','','PRFR PRFR','prouv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (363,'puis','','PS PS','puis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (364,'qu','','K K','qu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (365,'qualite','','KLT KLT','qualit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (366,'quatorze','','KTRS KTRS','quatorz');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (367,'quatre','','KTR KTR','quatr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (368,'que','','K K','que');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (369,'quelques','','KLKS KLKS','quelqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (370,'qui','','K K','qui');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (371,'r','','R R','r');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (372,'ramener','','RMNR RMNR','ramen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (373,'rature','','RTR RTR','ratur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (374,'re','','R R','re');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (375,'realite','','RLT RLT','realit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (376,'rebondissements','','RPNT RPNT','rebond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (377,'recit','','RST RST','rec');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (378,'recueil','','RKL RKL','recueil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (379,'region','','RJN RKN','region');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (380,'regional','','RJNL RKNL','regional');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (381,'regnent','','RNNT RKNN','regnent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (382,'reliques','','RLKS RLKS','reliqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (383,'remuer','','RMR RMR','remu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (384,'rencontre','','RNKN RNKN','rencontr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (385,'renon','','RNN RNN','renon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (386,'res','fr_FR','RS RS','re');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (387,'reserve','','RSRF RSRF','reserv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (388,'reve','','RF RF','rev');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (389,'riche','','RX RK','rich');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (390,'rififi','','RFF RFF','rifif');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (391,'roman','','RMN RMN','roman');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (392,'romans','','RMNS RMNS','roman');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (393,'s','','S S','s');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (394,'sa','','S S','sa');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (395,'sauver','','SFR SFR','sauv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (396,'savane','','SFN SFN','savan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (397,'savants','','SFNT SFNT','sav');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (398,'scenario','','SNR SNR','scenario');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (399,'se','','S S','se');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (400,'semarang','','SMRN SMRN','semarang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (401,'serie','','SR SR','ser');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (402,'servi','','SRF SRF','serv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (403,'services','','SRFS SRFS','servic');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (404,'ses','','SS SS','se');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (405,'seul','','SL SL','seul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (406,'seule','','SL SL','seul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (407,'seuls','','SLS SLS','seul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (408,'si','','S S','si');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (409,'singe','','SNJ SNK','sing');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (410,'sommeille','','SML SML','sommeil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (411,'son','','SN SN','son');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (412,'sont','','SNT SNT','sont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (413,'soundfishing','','SNTF SNTF','soundfishing');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (414,'spiritisme','','SPRT SPRT','spirit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (415,'studio','','STT STT','studio');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (416,'succedent','','SXTN SXTN','succedent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (417,'suides','','STS STS','suid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (418,'sur','','SR SR','sur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (419,'surnomme','','SRNM SRNM','surnomm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (420,'talent','','TLNT TLNT','talent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (421,'tatars','','TTRS TTRS','tatar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (422,'terre','','TR TR','terr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (423,'theosophie','','0SF TSF','theosoph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (424,'thomas','','TMS TMS','thom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (425,'tome','','TM TM','tom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (426,'tous','','TS TS','tous');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (427,'trait','','TRT TRT','trait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (428,'truie','','TR TR','trui');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (429,'uns','','ANS ANS','un');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (430,'utilisant','','ATLS ATLS','utilis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (431,'utilisent','','ATLS ATLS','utilisent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (432,'utopies','','ATPS ATPS','utop');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (433,'uvre','','AFR AFR','uvre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (434,'valise','','FLS FLS','valis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (435,'venitien','','FNTN FNTN','venitien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (436,'verrat','','FRT FRT','verrat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (437,'vertebres','','FRTP FRTP','vertebr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (438,'veuve','','FF FF','veuv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (439,'vigny','','FN FKN','vigny');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (440,'vivaldi','','FFLT FFLT','vivald');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (441,'voici','','FS FS','voic');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (442,'vont','','FNT FNT','vont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (443,'voyage','fr_FR','FJ FK','voyag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (444,'voyages','','FJS FKS','voyag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (445,'vraiment','','FRMN FRMN','vrai');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (446,'vue','','F F','vu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (447,'y','','A A','y');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (448,'zele','','SL SL','zel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (449,'zim','','SM SM','zim');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (450,'zoologie','','SLJ SLK','zoolog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (451,'test','','TST TST','test');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (452,'lgt','','LKT LKT','lgt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (453,'editeur','','ATTR ATTR','editeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (454,'collection','','KLKX KLKX','collect');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (455,'pyongyan','','PNKN PNJN','pyongyan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (456,'delisle','','TLL TLL','delisl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (457,'guy','','K K','guy');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (458,'278','','','278');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (459,'voyage','','FJ FK','voyag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (460,'inde','','ANT ANT','inde');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (461,'bac','','PK PK','bac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (462,'poche','','PX PK','poch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (463,'7e','','','7e');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (464,'ed','','AT AT','ed');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (465,'166','','','166');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (466,'devenue','','TFN TFN','devenu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (467,'plate','','PLT PLT','plat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (468,'imaginait','','AMJN AMKN','imagin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (469,'moyen','','MN MN','moyen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (470,'age','','AJ AK','age');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (471,'faut','','FT FT','faut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (472,'pas','','PS PS','pas');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (473,'trop','','TRP TRP','trop');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (474,'approcher','','APRX APRK','approch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (475,'bord','','PRT PRT','bord');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (476,'c','','K K','c');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (477,'evidemment','','AFTM AFTM','evident');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (478,'journee','','JRN ARN','journe');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (479,'magnifique','','MNFK MKNF','magnif');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (480,'catalogue','','KTLK KTLK','catalogu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (481,'compagnie','','KMPN KMPK','compagn');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (482,'moment','','MMNT MMNT','moment');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (483,'bureau','','PR PR','bureau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (484,'kin','','KN KN','kin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (485,'donnait','','TNT TNT','don');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (486,'lagon','','LKN LKN','lagon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (487,'frange','','FRNJ FRNK','frang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (488,'palmiers','','PLMR PLMR','palmi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (489,'rouleaux','','RL RL','rouleau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (490,'brisaient','','PRSN PRSN','bris');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (491,'contre','','KNTR KNTR','contr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (492,'recifs','','RSFS RSFS','recif');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (493,'211','','','211');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (494,'04459','','','04459');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (495,'roman','fr_FR','RMN RMN','roman');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (496,'aventure','fr_FR','AFNT AFNT','aventur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (497,'33700004388761','','','33700004388761');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (498,'sou','','S S','sou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (499,'pyongyang','','PNKN PNJN','pyongyang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (500,'germinal','','KRMN JRMN','germinal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (501,'1995','','','1995');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (502,'nouveau','','NF NF','nouveau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (503,'g','fr_FR','K K','g');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (504,'ographie','fr_FR','AKRF AKRF','ograph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (505,'3370000451293','','','3370000451293');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (506,'3370000451294','','','3370000451294');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (507,'pmb0006','','PMP PMP','pmb0006');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (508,'mag','','MK MK','mag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (509,'periodique','','PRTK PRTK','period');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (510,'chateau','','XT XT','chateau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (511,'du','','T T','du');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (512,'loir','','LR LR','loir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (513,'guide','','KT KT','guid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (514,'elections','','ALKX ALKX','elect');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (515,'americaines','','AMRK AMRK','americain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (516,'impr','','AMPR AMPR','impr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (517,'2012','','','2012');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (518,'vol','','FL FL','vol');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (519,'250','','','250');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (520,'porte','','PRT PRT','port');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (521,'duel','','TL TL','duel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (522,'obama','','APM APM','obam');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (523,'romney','','RMN RMN','romney');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (524,'presidents','','PRST PRST','president');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (525,'election','','ALKX ALKX','elect');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (526,'etats','','ATTS ATTS','etat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (527,'unis','','ANS ANS','unis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (528,'262','','','262');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (529,'04066','','','04066');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (530,'6','','','6');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (531,'perrin','','PRN PRN','perrin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (532,'paris','','PRS PRS','paris');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (533,'324','','','324');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (534,'973','','','973');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (535,'0093','','','0093');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (536,'tempus','','TMPS TMPS','tempus');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (537,'bacharan','','PKRN PKRN','bacharan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (538,'nicole','','NKL NKL','nicol');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (539,'simonnet','','SMNT SMNT','simonnet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (540,'dominique','','TMNK TMNK','domin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (541,'1951','','','1951');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (542,'traite','','TRT TRT','trait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (543,'abandon','','APNT APNT','abandon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (544,'pensees','','PNSS PNSS','pense');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (545,'160','','','160');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (546,'alexandre','','ALKS ALKS','alexandr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (547,'jollien','','JLN ALN','jollien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (548,'poursuit','','PRST PRST','poursuit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (549,'quete','','KT KT','quet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (550,'philosophique','','FLSF FLSF','philosoph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (551,'dune','','TN TN','dun');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (552,'sagesse','','SJS SKS','sagess');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (553,'nous','','NS NS','nous');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (554,'apporte','','APRT APRT','apport');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (555,'paix','','PKS PKS','paix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (556,'interieure','','ANTR ANTR','interieur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (557,'but','','PT PT','but');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (558,'voie','','F F','voi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (559,'royale','','RL RL','royal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (560,'vivre','','FFR FFR','vivr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (561,'theme','','0M TM','them');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (562,'directeur','','TRKT TRKT','directeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (563,'labandon','','LPNT LPNT','labandon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (564,'termes','','TRMS TRMS','term');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (565,'bouddhistes','','PTST PTST','bouddhist');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (566,'non','','NN NN','non');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (567,'fixation','','FKSX FKSX','fixat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (568,'fixer','','FKSR FKSR','fix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (569,'cest','','SST SST','cest');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (570,'debarrasser','','TPRS TPRS','debarrass');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (571,'representations','','RPRS RPRS','represent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (572,'etiquettes','','ATKT ATKT','etiquet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (573,'figent','','FJNT FKNT','figent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (574,'identites','','ATNT ATNT','identit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (575,'immuables','','AMPL AMPL','immuabl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (576,'laisser','','LSR LSR','laiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (577,'vie','','F F','vi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (578,'etre','','ATR ATR','etre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (579,'quelle','','KL KL','quel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (580,'rien','','RN RN','rien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (581,'vouloir','','FLR FLR','vouloir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (582,'changer','','XNKR XNJR','chang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (583,'sobstiner','','SPST SPST','sobstin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (584,'ouvert','','AFRT AFRT','ouvert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (585,'changement','','XNJM XNKM','chang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (586,'cela','','SL SL','cel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (587,'rend','','RNT RNT','rend');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (588,'perte','','PRT PRT','pert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (589,'vivable','','FFPL FFPL','vivabl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (590,'lautre','','LTR LTR','lautr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (591,'aussi','','AS AS','auss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (592,'chemin','','KMN KMN','chemin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (593,'determinant','','TTRM TTRM','determin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (594,'saccepter','','SXPT SXPT','saccept');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (595,'soi','','S S','soi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (596,'tel','','TL TL','tel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (597,'lon','','LN LN','lon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (598,'handicape','','HNTK HNTK','handicap');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (599,'travail','','TRFL TRFL','travail');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (600,'permanent','','PRMN PRMN','permanent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (601,'dalexandre','','TLKS TLKS','dalexandr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (602,'source','','SRS SRS','sourc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (603,'livres','','LFRS LFRS','livr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (604,'chacune','','XKN XKN','chacun');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (605,'20','','','20');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (606,'reunies','','RNS RNS','reun');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (607,'celui','','SL SL','celui');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (608,'ci','','S S','ci');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (609,'fois','','F FS','fois');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (610,'remede','','RMT RMT','remed');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (611,'meditation','','MTTX MTTX','medit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (612,'vivante','','FFNT FFNT','viv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (613,'obstacles','','APST APST','obstacl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (614,'ecartent','','AKRT AKRT','ecartent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (615,'chemins','','KMNS KMNS','chemin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (616,'conduisent','','KNTS KNTS','conduisent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (617,'lamitie','','LMT LMT','lamit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (618,'determination','','TTRM TTRM','determin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (619,'fragilite','','FRJL FRKL','fragilit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (620,'gratuite','','KRTT KRTT','gratuit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (621,'etc','','ATK ATK','etc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (622,'autant','','ATNT ATNT','aut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (623,'voies','','FS FS','voi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (624,'qualexandre','','KLKS KLKS','qualexandr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (625,'sefforce','','SFRS SFRS','sefforc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (626,'dexperimenter','','TKSP TKSP','dexperiment');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (627,'quotidien','','KTTN KTTN','quotidien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (628,'puisant','','PSNT PSNT','puis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (629,'petits','','PTTS PTTS','petit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (630,'evenements','','AFNM AFNM','even');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (631,'heureux','','HRKS HRKS','heureux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (632,'malheureux','','MLRK MLRK','malheur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (633,'ponctuent','','PNKT PNKT','ponctuent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (634,'reflexion','','RFLK RFLK','reflexion');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (635,'querelle','','KRL KRL','querel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (636,'impatience','','AMPT AMPT','impatient');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (637,'angoisse','','ANKS ANKS','angoiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (638,'ressources','','RSRS RSRS','ressourc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (639,'accueillir','','AKLR AKLR','accueil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (640,'sans','','SNS SNS','san');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (641,'souffrance','','SFRN SFRN','souffranc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (642,'esquisse','','ASKS ASKS','esquiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (643,'ainsi','','ANS ANS','ains');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (644,'art','','ART ART','art');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (645,'depouille','','TPL TPL','depouill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (646,'aide','','AT AT','aid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (647,'trouver','','TRFR TRFR','trouv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (648,'laudace','','LTS LTS','laudac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (649,'danser','','TNSR TNSR','dans');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (650,'joyeusement','','JSMN ASMN','joyeux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (651,'ronde','','RNT RNT','rond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (652,'lexistence','','LKSS LKSS','lexistent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (653,'passe','','PS PS','pass');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (654,'dix','','TKS TKS','dix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (655,'sept','','SPT SPT','sept');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (656,'ans','','ANS ANS','an');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (657,'institution','','ANST ANST','institu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (658,'personnes','','PRSN PRSN','person');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (659,'handicapees','','HNTK HNTK','handicape');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (660,'philosophe','','FLSF FLSF','philosoph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (661,'formation','','FRMX FRMX','format');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (662,'auteur','','ATR ATR','auteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (663,'eloge','','ALJ ALK','elog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (664,'faiblesse','','FPLS FPLS','faibless');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (665,'cerf','','SRF SRF','cerf');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (666,'marabout','','MRPT MRPT','marabout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (667,'2011','','','2011');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (668,'ouvrage','','AFRJ AFRK','ouvrag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (669,'couronne','','KRN KRN','couron');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (670,'academie','','AKTM AKTM','academ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (671,'francaise','','FRNK FRNK','francais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (672,'seuil','','SL SL','seuil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (673,'metier','','MT MTR','meti');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (674,'2002','','','2002');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (675,'construction','','KNST KNST','construct');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (676,'2006','','','2006');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (677,'nu','','N N','nu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (678,'2010','','','2010');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (679,'ont','','ANT ANT','ont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (680,'ete','','AT AT','ete');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (681,'grands','','KRNT KRNT','grand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (682,'succes','','SKSS SKSS','succ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (683,'www','','','www');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (684,'librairiedialogues','','LPRR LPRR','librairiedialogu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (685,'ws','','S S','w');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (686,'book','','PK PK','book');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (687,'9782021079418','','','9782021079418');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (688,'unimarc','','ANMR ANMR','unimarc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (689,'marc','','MRK MRK','marc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (690,'8','','','8');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (691,'religion','','RLJN RLKN','religion');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (692,'philosophie','','FLSF FLSF','philosoph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (693,'religions','','RLJN RLKN','relig');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (694,'02','','','02');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (695,'107941','','','107941');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (696,'barack','','PRK PRK','barack');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (697,'grande','','KRNT KRNT','grand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (698,'desillusion','','TSLS TSLX','desillu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (699,'222','','','222');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (700,'bibliogr','','PPLK PPLK','bibliogr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (701,'219','','','219');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (702,'220','','','220');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (703,'n','','N N','n');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (704,'realise','','RLS RLS','realis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (705,'programme','','PRKR PRKR','programm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (706,'partiellement','','PRTL PRTL','partiel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (707,'imparfaitement','','AMPR AMPR','imparfait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (708,'terme','','TRM TRM','term');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (709,'economique','','AKNM AKNM','econom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (710,'financiere','','FNNS FNNX','financier');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (711,'sociale','','SSL SXL','social');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (712,'toujours','','TJRS THRS','toujour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (713,'retrouve','','RTRF RTRF','retrouv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (714,'croissance','','KRSN KRSN','croissanc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (715,'plein','','PLN PLN','plein');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (716,'emploi','','AMPL AMPL','emploi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (717,'reforme','','RFRM RFRM','reform');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (718,'systeme','','SSTM SSTM','system');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (719,'sante','','SNT SNT','sant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (720,'encore','','ANKR ANKR','encor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (721,'appliquee','','APLK APLK','applique');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (722,'cour','','KR KR','cour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (723,'supreme','','SPRM SPRM','suprem');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (724,'validee','','FLT FLT','valide');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (725,'cinq','','SNK SNK','cinq');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (726,'voix','','FKS FKS','voix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (727,'opinion','','APNN APNN','opinion');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (728,'publique','','PPLK PPLK','publiqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (729,'profondement','','PRFN PRFN','profond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (730,'divisee','','TFS TFS','divise');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (731,'domaine','','TMN TMN','domain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (732,'politique','','PLTK PLTK','polit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (733,'etrangere','','ATRN ATRN','etranger');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (734,'spectaculaires','','SPKT SPKT','spectaculair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (735,'execution','','AKSK AKSK','execu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (736,'oussama','','ASM ASM','oussam');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (737,'ben','','PN PN','ben');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (738,'laden','','LTN LTN','laden');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (739,'dissimulent','','TSML TSML','dissimulent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (740,'echecs','','AXKS AKKS','echec');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (741,'complets','','KMPL KMPL','complet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (742,'partiels','','PRTL PRTL','partiel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (743,'andre','','ANTR ANTR','andre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (744,'kaspi','','KSP KSP','kasp');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (745,'explications','','AKSP AKSP','expliqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (746,'manquent','','MNKN MNKN','manquent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (747,'conjoncture','','KNJN KNJN','conjonctur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (748,'diront','','TRNT TRNT','diront');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (749,'defavorable','','TFFR TFFR','defavor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (750,'amerique','','AMRK AMRK','amer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (751,'ajouteront','','AJTR AHTR','ajout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (752,'inexorablement','','ANKS ANKS','inexor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (753,'confrontee','','KNFR KNFR','confronte');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (754,'declin','','TKLN TKLN','declin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (755,'moins','','MNS MNS','moin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (756,'promesses','','PRMS PRMS','promess');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (757,'aient','','ANT ANT','aient');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (758,'inconsiderees','','ANKN ANKN','inconsidere');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (759,'personnalite','','PRSN PRSN','personnalit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (760,'tout','','TT TT','tout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (761,'compte','','KMPT KMPT','compt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (762,'doute','','TT TT','dout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (763,'exceptionnelle','','AKSP AKSP','exceptionnel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (764,'cru','','KR KR','cru');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (765,'electeurs','','ALKT ALKT','electeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (766,'americains','','AMRK AMRK','americain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (767,'trancheront','','TRNX TRNK','tranch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (768,'novembre','','NFMP NFMP','novembr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (769,'ils','','ALS ALS','il');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (770,'compareront','','KMPR KMPR','compar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (771,'candidat','','KNTT KNTT','candidat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (772,'republicain','','RPPL RPPL','republicain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (773,'avec','','AFK AFK','avec');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (774,'bilan','','PLN PLN','bilan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (775,'president','','PRST PRST','president');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (776,'sortant','','SRTN SRTN','sort');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (777,'accorderont','','AKRT AKRT','accord');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (778,'second','','SKNT SKNT','second');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (779,'mandat','','MNTT MNTT','mandat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (780,'concession','','KNSS KNSS','concess');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (781,'presidence','','PRST PRST','president');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (782,'meilleurs','','MLRS MLRS','meilleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (783,'specialistes','','SPSL SPXL','special');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (784,'francais','','FRNK FRNK','franc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (785,'professeur','','PRFS PRFS','professeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (786,'emerite','','AMRT AMRT','emerit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (787,'sorbonne','','SRPN SRPN','sorbon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (788,'beaucoup','','PKP PKP','beaucoup');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (789,'publie','','PPL PPL','publ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (790,'civilisation','','SFLS SFLS','civilis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (791,'parmi','','PRM PRM','parm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (792,'ouvrages','','AFRJ AFRK','ouvrag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (793,'john','','JN AN','john');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (794,'f','','F F','f');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (795,'kennedy','','KNT KNT','kennedy');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (796,'famille','','FML FML','famill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (797,'mythe','','M0 MT','myth');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (798,'complexe','','KMPL KMPL','complex');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (799,'2007','','','2007');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (800,'juifs','','JFS AFS','juif');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (801,'plon','','PLN PLN','plon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (802,'2008','','','2008');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (803,'franklin','','FRNK FRNK','franklin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (804,'roosevelt','','RSFL RSFL','roosevelt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (805,'coll','','KL KL','coll');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (806,'helene','','HLN HLN','helen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (807,'harter','','HRTR HRTR','hart');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (808,'tallandier','','TLNT TLNT','tallandi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (809,'gouvernement','','KFRN KFRN','gouvern');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (810,'2009','','','2009');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (811,'259','','','259');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (812,'21063','','','21063');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (813,'320','','','320');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (814,'09051','','','09051');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (815,'1937','','','1937');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (816,'qergr','','KRKR KRKR','qergr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (817,'zr','','SR SR','zr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (818,'rgaz','','RKS RKS','rgaz');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (819,'8192','','','8192');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (820,'qer','','KR KR','qer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (821,'catfish','','KTFX KTFX','catfish');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (822,'blues','','PLS PLS','blu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (823,'154','','','154');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (824,'discogr','','TSKK TSKK','discogr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (825,'oeuvres','','AFRS AFRS','oeuvr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (826,'12','','','12');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (827,'idee','','AT AT','ide');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (828,'tete','','TT TT','tet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (829,'fuir','','FR FR','fuir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (830,'plantation','','PLNT PLNT','plantat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (831,'coton','','KTN KTN','coton');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (832,'travaillent','','TRFL TRFL','travaillent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (833,'freres','','FRRS FRRS','frer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (834,'soeurs','','SRS SRS','soeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (835,'suivre','','SFR SFR','suivr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (836,'oncle','','ANKL ANKL','oncle');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (837,'eddie','','AT AT','eddi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (838,'devenir','','TFNR TFNR','deven');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (839,'chanteur','','XNTR XNTR','chanteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (840,'chicago','','XKK XKK','chicago');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (841,'chronique','','KRNK KRNK','chroniqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (842,'noir','','NR NR','noir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (843,'prises','','PRSS PRSS','pris');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (844,'escrocs','','ASKK ASKK','escroc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (845,'poil','','PL PL','poil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (846,'compris','','KMPR KMPR','compr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (847,'ku','','K K','ku');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (848,'klux','','KLKS KLKS','klux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (849,'klan','','KLN KLN','klan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (850,'vaut','','FT FT','vaut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (851,'vivacite','','FFST FFST','vivacit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (852,'ecriture','','AKRT AKRT','ecritur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (853,'beau','','P P','beau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (854,'portrait','','PRTR PRTR','portr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (855,'epoque','','APK APK','epoqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (856,'laurence','','LRNS LRNS','laurenc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (857,'liban','','LPN LPN','liban');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (858,'lire','','LR LR','lir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (859,'racisme','','RSSM RSSM','racism');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (860,'029506','','','029506');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (861,'litt','fr_FR','LT LT','litt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (862,'rature','fr_FR','RTR RTR','ratur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (863,'fran','fr_FR','FRN FRN','fran');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (864,'aise','fr_FR','AS AS','ais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (865,'22020295067','','','22020295067');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (866,'6438646236','','','6438646236');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (867,'her','','HR HR','her');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (868,'trois','','TR TRS','trois');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (869,'feles','','FLS FLS','fel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (870,'pendu','','PNT PNT','pendu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (871,'29','','','29');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (872,'lucien','','LSN LXN','lucien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (873,'trouve','','TRF TRF','trouv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (874,'tresor','','TRSR TRSR','tresor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (875,'grange','','KRNJ KRNK','grang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (876,'abandonnee','','APNT APNT','abandonne');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (877,'lorsqu','','LRSK LRSK','lorsqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (878,'retourne','','RTRN RTRN','retourn');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (879,'copains','','KPNS KPNS','copain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (880,'centre','','SNTR SNTR','centr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (881,'batiment','','PTMN PTMN','bat');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (882,'subterfuge','','SPTR SPTR','subterfug');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (883,'mort','','MRT MRT','mort');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (884,'sien','','SN SN','sien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (885,'grace','','KRS KRS','grac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (886,'dede','','TT TT','ded');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (887,'sauve','','SF SF','sauv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (888,'chercher','','XRXR XRKR','cherch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (889,'secours','','SKRS SKRS','secour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (890,'criminel','','KRMN KRMN','criminel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (891,'ecroue','','AKR AKR','ecrou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (892,'84146','','','84146');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (893,'554','','','554');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (894,'800','','','800');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (895,'33700003413727','','','33700003413727');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (896,'er','','AR AR','er');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (897,'opp','','AP AP','opp');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (898,'sarah','','SR SR','sarah');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (899,'cordoue','','KRT KRT','cordou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (900,'136','','','136');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (901,'defaut','','TFT TFT','defaut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (902,'fils','','FLS FLS','fil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (903,'vieux','','FKS FKS','vieux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (904,'savant','','SFNT SFNT','sav');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (905,'point','','PNT PNT','point');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (906,'fille','','FL FL','fill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (907,'ainee','','AN AN','aine');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (908,'disciple','','TSPL TSPL','discipl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (909,'interdite','','ANTR ANTR','interdit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (910,'femmes','','FMS FMS','femm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (911,'accomplir','','AKMP AKMP','accompl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (912,'voeux','','FKS FKS','voeux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (913,'accepte','','AKSP AKSP','accept');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (914,'travestir','','TRFS TRFS','travest');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (915,'samuel','','SML SML','samuel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (916,'elle','','AL AL','elle');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (917,'recoit','','RKT RKT','recoit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (918,'poeme','','PM PM','poem');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (919,'galant','','KLNT KLNT','gal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (920,'jeune','','JN AN','jeun');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (921,'etudiant','','ATTN ATTN','etudi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (922,'musulman','','MSLM MSLM','musulman');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (923,'aime','','AM AM','aim');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (924,'belle','','PL PL','bel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (925,'amour','','AMR AMR','amour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (926,'toile','','TL TL','toil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (927,'fresque','','FRSK FRSK','fresqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (928,'12e','','','12e');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (929,'siecle','','SKL SKL','siecl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (930,'452','','','452');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (931,'espagne','fr_FR','ASPN ASPK','espagn');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (932,'33700003719453','','','33700003719453');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (933,'cau','','K K','cau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (934,'mille','','ML ML','mill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (935,'pattes','','PTS PTS','patt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (936,'233','','','233');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (937,'titre','','TTR TTR','titr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (938,'crypte','','KRPT KRPT','crypt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (939,'designe','','TSN TSKN','design');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (940,'onze','','ANS ANS','onze');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (941,'joueurs','','JRS ARS','joueur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (942,'equipe','','AKP AKP','equip');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (943,'france','','FRNS FRNS','franc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (944,'football','','FTPL FTPL','football');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (945,'impliques','','AMPL AMPL','impliqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (946,'alternative','','ALTR ALTR','altern');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (947,'rapport','','RPRT RPRT','rapport');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (948,'evenement','','AFNM AFNM','even');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (949,'bleus','','PLS PLS','bleus');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (950,'champions','','XMPN XMPN','champion');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (951,'ballon','','PLN PLN','ballon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (952,'rond','','RNT RNT','rond');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (953,'207','','','207');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (954,'24700','','','24700');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (955,'football','fr_FR','FTPL FTPL','football');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (956,'33700003550072','','','33700003550072');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (957,'rx','','RKS RKS','rx');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (958,'rio','','R R','rio');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (959,'policiers','','PLSR PLXR','polici');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (960,'deteriore','','TTRR TTRR','deterior');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (961,'puits','','PTS PTS','puit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (962,'110','','','110');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (963,'secheresse','','SXRS SKRS','secheress');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (964,'tari','','TR TR','tar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (965,'sauf','','SF SF','sauf');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (966,'logan','','LKN LKN','logan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (967,'fermiers','','FRMR FRMR','fermi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (968,'noirs','','NRS NRS','noir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (969,'aisee','','AS AS','aise');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (970,'partagent','','PRTJ PRTK','partagent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (971,'eau','','A A','eau');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (972,'precieuse','','PRSS PRXS','precieux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (973,'ur','','AR AR','ur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (974,'1910','','','1910');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (975,'sud','','ST ST','sud');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (976,'americain','','AMRK AMRK','americain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (977,'ranc','','RNK RNK','ranc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (978,'urs','','ARS ARS','ur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (979,'tenaces','','TNSS TNSS','tenac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (980,'long','','LNK LNK','long');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (981,'tension','','TNSN TNXN','tension');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (982,'monte','','MNT MNT','mont');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (983,'accablante','','AKPL AKPL','accabl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (984,'chaleur','','XLR XLR','chaleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (985,'08','','','08');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (986,'164155','','','164155');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (987,'810','','','810');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (988,'am','','AM AM','am');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (989,'ricaine','','RKN RKN','ricain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (990,'am','fr_FR','AM AM','am');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (991,'ricaine','fr_FR','RKN RKN','ricain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (992,'33700004389030','','','33700004389030');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (993,'33700004389026','','','33700004389026');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (994,'jrk','','JRK ARK','jrk');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (995,'tay','','T T','tay');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (996,'ghetto','','KT KT','ghetto');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (997,'9','','','9');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (998,'1993','','','1993');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (999,'afrique','','AFRK AFRK','afriqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1000,'futuriste','','FTRS FTRS','futur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1001,'consortium','','KNSR KNSR','consortium');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1002,'exploite','','AKSP AKSP','exploit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1003,'outrance','','ATRN ATRN','outranc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1004,'continent','','KNTN KNTN','continent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1005,'quand','','KNT KNT','quand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1006,'dayak','','TK TK','dayak');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1007,'decouvre','','TKFR TKFR','decouvr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1008,'dirige','','TRJ TRK','dirig');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1009,'empire','','AMPR AMPR','empir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1010,'technologique','','TKNL TKNL','technolog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1011,'autre','','ATR ATR','autr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1012,'frere','','FRR FRR','frer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1013,'lutte','','LT LT','lutt');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1014,'prend','','PRNT PRNT','prend');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1015,'dimension','','TMNS TMNX','dimens');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1016,'fascinante','','FSNN FSNN','fascin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1017,'possede','','PST PST','possed');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1018,'energie','','ANRJ ANRK','energ');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1019,'force','','FRS FRS','forc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1020,'meilleures','','MLRS MLRS','meilleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1021,'sagas','','SKS SKS','sag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1022,'visionnaire','','FSNR FXNR','visionnair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1023,'dessin','','TSN TSN','dessin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1024,'adamov','','ATMF ATMF','adamov');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1025,'signe','','SN SKN','sign');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1026,'1542','','','1542');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1027,'science','fr_FR','SNS SNS','scienc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1028,'fiction','fr_FR','FKXN FKXN','fiction');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1029,'33700003669468','','','33700003669468');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1030,'bd','','PT PT','bd');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1031,'ada','','AT AT','ada');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1032,'zaks','','SKS SKS','zak');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1033,'ville','','FL FL','vill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1034,'mere','','MR MR','mer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1035,'detruite','','TTRT TTRT','detruit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1036,'implosee','','AMPL AMPL','implose');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1037,'reussi','','RS RS','reuss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1038,'echapper','','AXPR AKPR','echapp');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1039,'intercepteurs','','ANTR ANTR','intercepteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1040,'fidele','','FTL FTL','fidel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1041,'tit','','TT TT','tit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1042,'caille','','KL KL','caill');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1043,'voila','','FL FL','voil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1044,'coeur','','KR KR','coeur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1045,'pret','','PRT PRT','pret');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1046,'fondre','','FNTR FNTR','fondr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1047,'univers','','ANFR ANFR','univer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1048,'inhospitalier','','ANSP ANSP','inhospitali');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1049,'suivi','','SF SF','suiv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1050,'quelque','','KLK KLK','quelqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1051,'distance','','TSTN TSTN','distanc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1052,'simon','','SMN SMN','simon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1053,'jamais','','JM AMS','jam');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1054,'rattraper','','RTRP RTRP','rattrap');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1055,'or','','AR AR','or');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1056,'hommes','','HMS HMS','homm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1057,'masques','','MSKS MSKS','masqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1058,'yeux','','AKS AKS','yeux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1059,'sanguins','','SNKN SNKN','sanguin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1060,'legende','','LJNT LKNT','legend');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1061,'caches','','KXS KKS','cach');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1062,'dedale','','TTL TTL','dedal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1063,'galeries','','KLRS KLRS','galer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1064,'souterraines','','STRN STRN','souterrain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1065,'labyrinthiques','','LPRN LPRN','labyrinth');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1066,'tardera','','TRTR TRTR','tard');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1067,'fixe','','FKS FKS','fix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1068,'bientot','','PNTT PNTT','bientot');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1069,'resonneront','','RSNR RSNR','reson');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1070,'tambours','','TMPR TMPR','tambour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1071,'traditions','','TRTX TRTX','tradit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1072,'humaines','','HMNS HMNS','humain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1073,'anciennes','','ANSN ANXN','ancien');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1074,'ombres','','AMPR AMPR','ombre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1075,'demesurees','','TMSR TMSR','demesure');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1076,'silhouettes','','SLTS SLTS','silhouet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1077,'primitives','','PRMT PRMT','primit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1078,'viendront','','FNTR FNTR','viendront');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1079,'allonger','','ALNK ALNJ','allong');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1080,'aupres','','APRS APRS','aupr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1081,'intervention','','ANTR ANTR','intervent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1082,'parviendra','','PRFN PRFN','parviendr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1083,'triompher','','TRMF TRMF','triomph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1084,'definitivement','','TFNT TFNT','definit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1085,'tant','','TNT TNT','tant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1086,'gens','','JNS KNS','gen');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1087,'espece','','ASPS ASPS','espec');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1088,'soit','','ST ST','soit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1089,'fin','','FN FN','fin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1090,'alors','','ALRS ALRS','alor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1091,'juste','','JST AST','just');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1092,'expriment','','AKSP AKSP','expriment');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1093,'lieux','','LKS LKS','lieux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1094,'desertiques','','TSRT TSRT','desert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1095,'certaine','','SRTN SRTN','certain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1096,'facon','','FKN FKN','facon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1097,'finissait','','FNST FNST','fin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1098,'2083','','','2083');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1099,'33700003669484','','','33700003669484');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1100,'chambre','','XMPR XMPR','chambr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1101,'verte','','FRT FRT','vert');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1102,'1994','','','1994');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1103,'addis','','ATS ATS','addis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1104,'abeba','','APP APP','abeb');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1105,'nee','','N N','ne');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1106,'fini','','FN FN','fin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1107,'misere','','MSR MSR','miser');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1108,'crasse','','KRS KRS','crass');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1109,'colbius','','KLPS KLPS','colbius');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1110,'leader','','LTR LTR','lead');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1111,'m','','M M','m');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1112,'surgir','','SRJR SRKR','surg');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1113,'megalopole','','MKLP MKLP','megalopol');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1114,'techniques','','TKNK TKNK','techniqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1115,'sophistiquees','','SFST SFST','sophistique');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1116,'cotoient','','KTNT KTNT','cotoient');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1117,'valet','','FLT FLT','valet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1118,'despote','','TSPT TSPT','despot');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1119,'cori','','KR KR','cor');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1120,'courtisane','','KRTS KRTS','courtisan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1121,'comportement','','KMPR KMPR','comport');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1122,'trouble','','TRPL TRPL','troubl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1123,'peine','','PN PN','pein');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1124,'car','','KR KR','car');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1125,'sait','','ST ST','sait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1126,'maintenant','','MNTN MNTN','mainten');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1127,'lointains','','LNTN LNTN','lointain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1128,'souvenirs','','SFNR SFNR','souvenir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1129,'vision','','FSN FXN','vision');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1130,'fugace','','FKS FKS','fugac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1131,'percevaient','','PRSF PRSF','percev');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1132,'formidables','','FRMT FRMT','formid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1133,'changements','','XNJM XNKM','chang');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1134,'orchestrait','','ARKS ARKS','orchestr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1135,'clone','','KLN KLN','clon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1136,'briser','','PRSR PRSR','bris');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1137,'chaines','','XNS XNS','chain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1138,'relient','','RLNT RLNT','relient');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1139,'maitre','','MTR MTR','maitr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1140,'empereur','','AMPR AMPR','empereur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1141,'nouvel','','NFL NFL','nouvel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1142,'1727','','','1727');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1143,'33700003669485','','','33700003669485');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1144,'pmb0002','','PMP PMP','pmb0002');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1145,'2ch','','X K','2ch');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1146,'albums','','ALPM ALPM','album');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1147,'monsieur','','MNSR MNSR','monsieur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1148,'je','','J A','je');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1149,'sais','','S SS','sais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1150,'8001','','','8001');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1151,'2334','','','2334');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1152,'33700004243347','','','33700004243347');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1153,'ebd','','APT APT','ebd');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1154,'gee','','J K','ge');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1155,'paroles','','PRLS PRLS','parol');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1156,'bonheur','','PNR PNR','bonheur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1157,'pagine','','PJN PKN','pagin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1158,'59','','','59');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1159,'anthologique','','AN0L ANTL','antholog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1160,'textes','','TKST TKST','text');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1161,'temps','','TMPS TMPS','temp');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1162,'pays','','PS PS','pay');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1163,'donne','','TN TN','don');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1164,'presentation','','PRSN PRSN','present');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1165,'originale','','ARJN ARKN','original');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1166,'ecrits','','AKRT AKRT','ecrit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1167,'enclaves','','ANKL ANKL','enclav');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1168,'illustrations','','ALST ALST','illustr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1169,'226','','','226');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1170,'09017','','','09017');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1171,'psychologie','fr_FR','SXLJ SKLK','psycholog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1172,'psychanalyse','fr_FR','SXNL SKNL','psychanalys');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1173,'33700003453202','','','33700003453202');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1174,'808','','','808');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1175,'metamorphose','','MTMR MTMR','metamorphos');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1176,'fleurs','','FLRS FLRS','fleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1177,'143','','','143');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1178,'depl','','TPL TPL','depl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1179,'jaquette','','JKT AKT','jaquet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1180,'microcosmos','','MKRK MKRK','microcosmos');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1181,'milliers','','MLRS MLRS','milli');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1182,'lecteurs','','LKTR LKTR','lecteur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1183,'emerveilles','','AMRF AMRF','emerveil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1184,'devant','','TFNT TFNT','dev');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1185,'prodiges','','PRTJ PRTK','prodig');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1186,'insoupconnes','','ANSP ANSP','insoupcon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1187,'carre','','KR KR','carr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1188,'herbes','','HRPS HRPS','herb');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1189,'folles','','FLS FLS','foll');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1190,'claude','','KLT KLT','claud');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1191,'nuridsany','','NRTS NRTS','nuridsany');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1192,'marie','','MR MR','mar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1193,'perennou','','PRN PRN','perennou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1194,'sillonnent','','SLNN SLNN','sillonnent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1195,'prairies','','PRRS PRRS','prair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1196,'jardins','','JRTN ARTN','jardin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1197,'invitent','','ANFT ANFT','invitent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1198,'nos','','NS NS','nos');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1199,'inattentifs','','ANTN ANTN','inattent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1200,'poser','','PSR PSR','pos');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1201,'bouton','','PTN PTN','bouton');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1202,'gorge','','KRJ KRK','gorg');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1203,'seve','','SF SF','sev');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1204,'petale','','PTL PTL','petal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1205,'entrouvre','','ANTR ANTR','entrouvr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1206,'chute','','XT XT','chut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1207,'corolle','','KRL KRL','coroll');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1208,'moments','','MMNT MMNT','moment');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1209,'phares','','FRS FRS','phar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1210,'flamboyante','','FLMP FLMP','flamboi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1211,'fleur','','FLR FLR','fleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1212,'architecture','','ARKT ARKT','architectur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1213,'construite','','KNST KNST','construit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1214,'defaite','','TFT TFT','defait');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1215,'jours','','JRS ARS','jour');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1216,'transfigurees','','TRNS TRNS','transfigure');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1217,'macrophotographie','','MKRF MKRF','macrophotograph');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1218,'vingtaine','','FNKT FNKT','vingtain');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1219,'especes','','ASPS ASPS','espec');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1220,'florales','','FLRL FLRL','floral');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1221,'naissent','','NSNT NSNT','naissent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1222,'vivent','','FFNT FFNT','vivent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1223,'meurent','','MRNT MRNT','meurent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1224,'sous','','SS SS','sous');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1225,'invente','','ANFN ANFN','invent');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1226,'notre','','NTR NTR','notr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1227,'plaisir','','PLSR PLSR','plais');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1228,'regard','','RKRT RKRT','regard');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1229,'nature','','NTR NTR','natur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1230,'mi','','M M','mi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1231,'biologie','','PLJ PLK','biolog');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1232,'poesie','','PS PS','poes');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1233,'pistil','','PSTL PSTL','pistil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1234,'etamine','','ATMN ATMN','etamin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1235,'7324','','','7324');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1236,'2351','','','2351');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1237,'580','','','580');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1238,'botanique','','PTNK PTNK','botan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1239,'plantes','','PLNT PLNT','plant');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1240,'fleurs','fr_FR','FLRS FLRS','fleur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1241,'33700004118010','','','33700004118010');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1242,'582','','','582');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1243,'nur','','NR NR','nur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1244,'rwanda','','RNT RNT','rwand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1245,'271','','','271');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1246,'appendice','','APNT APNT','appendic');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1247,'choix','','XKS XKS','choix');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1248,'documents','','TKMN TKMN','docu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1249,'franchophone','','FRNX FRNK','franchophon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1250,'colonisation','','KLNS KLNS','colonis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1251,'7384','','','7384');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1252,'5292','','','5292');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1253,'960','','','960');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1254,'de','','T T','de');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1255,'l','','L L','l');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1256,'rwanda','fr_FR','RNT RNT','rwand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1257,'33700003286792','','','33700003286792');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1258,'967','','','967');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1259,'ove','','AF AF','ove');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1260,'routiere','','RTR RTR','routier');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1261,'ardeche','','ARTX ARTK','ardech');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1262,'haute','','HT HT','haut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1263,'11331','','','11331');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1264,'touristique','','TRST TRST','tourist');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1265,'25','','','25');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1266,'x','','S S','x');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1267,'16','','','16');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1268,'generation','','JNRX KNRX','gener');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1269,'cartes','','KRTS KRTS','cart');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1270,'routieres','','RTRS RTRS','routier');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1271,'michelin','','MXLN MKLN','michelin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1272,'toutes','','TTS TTS','tout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1273,'informations','','ANFR ANFR','inform');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1274,'decouvrir','','TKFR TKFR','decouvr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1275,'departements','','TPRT TPRT','depart');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1276,'reperer','','RPRR RPRR','reper');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1277,'facilement','','FSLM FSLM','facil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1278,'voiture','','FTR FTR','voitur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1279,'nombreuses','','NMPR NMPR','nombreux');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1280,'nouveautes','','NFTS NFTS','nouveaut');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1281,'integrees','','ANTK ANTK','integre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1282,'local','','LKL LKL','local');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1283,'lisible','','LSPL LSPL','lisibl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1284,'echelle','','AXL AKL','echel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1285,'agrandie','','AKRN AKRN','agrand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1286,'150','','','150');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1287,'000e','','','000e');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1288,'175','','','175');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1289,'index','','ANTK ANTK','index');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1290,'complet','','KMPL KMPL','complet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1291,'localites','','LKLT LKLT','localit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1292,'acceder','','AKST AKST','acced');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1293,'rapidement','','RPTM RPTM','rapid');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1294,'information','','ANFR ANFR','inform');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1295,'plans','','PLNS PLNS','plan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1296,'circuler','','SRKL SRKL','circul');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1297,'grandes','','KRNT KRNT','grand');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1298,'agglomerations','','AKLM AKLM','agglomer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1299,'image','','AMJ AMK','imag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1300,'comprendre','','KMPR KMPR','comprendr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1301,'symboles','','SMPL SMPL','symbol');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1302,'terroirs','','TRRS TRRS','terroir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1303,'centrees','','SNTR SNTR','centre');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1304,'route','','RT RT','rout');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1305,'autrement','','ATRM ATRM','autr');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1306,'pixel','','PKSL PKSL','pixel');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1307,'bas','','PS PS','bas');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1308,'vivarais','','FFR FFRS','vivar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1309,'boutieres','','PTRS PTRS','boutier');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1310,'brisadois','','PRST PRST','brisadois');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1311,'cevennes','','SFNS SFNS','ceven');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1312,'margeriche','','MRKR MRJR','margerich');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1313,'velay','','FL FL','velay');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1314,'06','','','06');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1315,'100392','','','100392');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1316,'3370000451291','','','3370000451291');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1317,'mic','','MK MK','mic');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1318,'chili','','XL XL','chil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1319,'glace','','KLS KLS','glac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1320,'feu','','F F','feu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1321,'dl','','TL TL','dl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1322,'dvd','','TFT TFT','dvd');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1323,'video','','FT FT','video');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1324,'monoface','','MNFS MNFS','monofac');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1325,'zone','','SN SN','zon');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1326,'h','','','h');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1327,'21','','','21');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1328,'min','','MN MN','min');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1329,'pal','','PL PL','pal');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1330,'brochure','','PRXR PRKR','brochur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1331,'14','','','14');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1332,'cm','','KM KM','cm');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1333,'contient','','KNTN KNTN','contient');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1334,'making','','MKNK MKNK','making');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1335,'of','','AF AF','of');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1336,'vu','','F F','vu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1337,'sites','','STS STS','sit');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1338,'fetes','','FTS FTS','fet');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1339,'paques','','PKS PKS','paqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1340,'chili','fr_FR','XL XL','chil');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1341,'3370000451290','','','3370000451290');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1342,'tf1','','TF TF','tf1');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1343,'angevine','','ANJF ANKF','angevin');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1344,'joachim','','JXM AKM','joachim');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1345,'bellay','','PL PL','bellay');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1346,'2001','','','2001');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1347,'disque','','TSK TSK','disqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1348,'optique','','APTK APTK','optiqu');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1349,'numerique','','NMRK NMRK','numer');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1350,'rom','','RM RM','rom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1351,'glossaire','','KLSR KLSR','glossair');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1352,'configuration','','KNFK KNFK','configur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1353,'requise','','RKS RKS','requis');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1354,'pc','','PK PK','pc');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1355,'mo','','M M','mo');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1356,'memoire','','MMR MMR','memoir');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1357,'vive','','FF FF','viv');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1358,'windows','','ANTS FNTS','window');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1359,'95','','','95');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1360,'ulterieur','','ALTR ALTR','ulterieur');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1361,'octuple','','AKTP AKTP','octupl');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1362,'vitesse','','FTS FTS','vitess');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1363,'affichage','','AFXJ AFKK','affichag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1364,'65','','','65');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1365,'000','','','000');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1366,'macintosh','','MSNT MSNT','macintosh');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1367,'5','','','5');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1368,'renaissance','','RNSN RNSN','renaiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1369,'anjou','','ANJ ANJ','anjou');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1370,'renaissance','fr_FR','RNSN RNSN','renaiss');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1371,'po','fr_FR','P P','po');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1372,'sie','fr_FR','S S','si');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1373,'3370000451292','','','3370000451292');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1374,'cdrom','','KTRM KTRM','cdrom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1375,'loi','','L L','loi');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1376,'cederoms','','STRM STRM','cederom');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1377,'bagnes','','PNS PKNS','bagn');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1378,'madagascar','','MTKS MTKS','madagascar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1379,'49','','','49');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1380,'madagascar','fr_FR','MTKS MTKS','madagascar');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1381,'paysages','','PSJS PSKS','paysag');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1382,'afghans','','AFKN AFKN','afghan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1383,'26','','','26');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1384,'afghanistan','fr_FR','AFKN AFKN','afghanistan');
INSERT INTO words (id_word, word, lang, double_metaphone, stem) VALUES (1385,'peuples','','PPLS PPLS','peupl');
