-- Table structure for table `publisher_custom_dates`
--

CREATE TABLE publisher_custom_dates (
  publisher_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_date_type int(11) DEFAULT NULL,
  publisher_custom_date_start int(11) NOT NULL DEFAULT '0',
  publisher_custom_date_end int(11) NOT NULL DEFAULT '0',
  publisher_custom_order int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (publisher_custom_champ,publisher_custom_origine,publisher_custom_order),
  KEY publisher_custom_champ (publisher_custom_champ),
  KEY publisher_custom_origine (publisher_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom_dates`
--


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

--
-- 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,'PRIORITY',17,0);
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,'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 (64,'MAX_QUOTA',0,0);
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,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'MAX_QUOTA',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 (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,'MAX',0,0);
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 (128,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'MAX_QUOTA',0,0);
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 (4,'PRIORITY',20,0);
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,'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 (8,'PRIORITY',20,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'MAX_QUOTA',0,0);
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 (16,'PRIORITY',24,0);
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,'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 (32,'PRIORITY',24,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'MAX_QUOTA',0,0);
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 (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 (1,'PRIORITY',32,5);
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 (2,'PRIORITY',32,5);
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 (64,'PRIORITY',32,5);
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 (128,'PRIORITY',32,5);
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 (4,'PRIORITY',32,5);
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 (8,'PRIORITY',32,5);
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 (16,'PRIORITY',32,5);
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);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',32,5);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'DEFAULT',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'MAX_QUOTA',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',32,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',17,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',16,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',3,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',1,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1024,'PRIORITY',2,5);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'DEFAULT',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'FORCE_LEND',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'MAX_QUOTA',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',32,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',17,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',16,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',3,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',1,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2048,'PRIORITY',2,5);

--
-- 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` text 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 text 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_g2t`
--

CREATE TABLE rdfstore_g2t (
  g mediumint(8) unsigned NOT NULL,
  t mediumint(8) unsigned NOT NULL,
  UNIQUE KEY gt (g,t),
  KEY tg (t,g)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_g2t`
--


--
-- Table structure for table `rdfstore_id2val`
--

CREATE TABLE rdfstore_id2val (
  `id` mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val text COLLATE utf8_unicode_ci NOT NULL,
  val_type tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`,val_type),
  KEY v (val(64))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_id2val`
--


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

CREATE TABLE rdfstore_index (
  num_triple int(10) unsigned NOT NULL DEFAULT '0',
  subject_uri text COLLATE utf8_unicode_ci NOT NULL,
  subject_type text COLLATE utf8_unicode_ci NOT NULL,
  predicat_uri text COLLATE utf8_unicode_ci NOT NULL,
  num_object int(10) unsigned NOT NULL DEFAULT '0',
  object_val text COLLATE utf8_unicode_ci NOT NULL,
  object_index text COLLATE utf8_unicode_ci NOT NULL,
  object_lang char(5) COLLATE utf8_unicode_ci 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 `rdfstore_o2val`
--

CREATE TABLE rdfstore_o2val (
  `id` mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val_hash char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY vh (val_hash),
  KEY v (val(64))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_o2val`
--


--
-- Table structure for table `rdfstore_s2val`
--

CREATE TABLE rdfstore_s2val (
  `id` mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val_hash char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY vh (val_hash)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_s2val`
--


--
-- Table structure for table `rdfstore_setting`
--

CREATE TABLE rdfstore_setting (
  k char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY k (k)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_setting`
--


--
-- Table structure for table `rdfstore_triple`
--

CREATE TABLE rdfstore_triple (
  t mediumint(8) unsigned NOT NULL,
  s mediumint(8) unsigned NOT NULL,
  p mediumint(8) unsigned NOT NULL,
  o mediumint(8) unsigned NOT NULL,
  o_lang_dt mediumint(8) unsigned NOT NULL,
  o_comp char(35) COLLATE utf8_unicode_ci NOT NULL,
  s_type tinyint(1) NOT NULL DEFAULT '0',
  o_type tinyint(1) NOT NULL DEFAULT '0',
  misc tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY t (t),
  KEY sp (s,p),
  KEY os (o,s),
  KEY po (p,o),
  KEY misc (misc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_triple`
--


--
-- 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 `rent_account_types_sections`
--

CREATE TABLE rent_account_types_sections (
  account_type_num_exercice int(10) unsigned NOT NULL DEFAULT '0',
  account_type_num_section int(10) unsigned NOT NULL DEFAULT '0',
  account_type_marclist varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (account_type_num_section,account_type_marclist)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_account_types_sections`
--


--
-- Table structure for table `rent_accounts`
--

CREATE TABLE rent_accounts (
  id_account int(10) unsigned NOT NULL AUTO_INCREMENT,
  account_num_user int(10) unsigned NOT NULL DEFAULT '0',
  account_num_exercice int(10) unsigned NOT NULL DEFAULT '0',
  account_request_type varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_type varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_desc text COLLATE utf8_unicode_ci,
  account_date datetime DEFAULT NULL,
  account_receipt_limit_date datetime DEFAULT NULL,
  account_receipt_effective_date datetime DEFAULT NULL,
  account_return_date datetime DEFAULT NULL,
  account_num_uniform_title int(10) unsigned NOT NULL DEFAULT '0',
  account_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_event_date datetime DEFAULT NULL,
  account_event_formation varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_event_orchestra varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_event_place varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  account_num_publisher int(10) unsigned NOT NULL DEFAULT '0',
  account_num_supplier int(10) unsigned NOT NULL DEFAULT '0',
  account_num_author int(10) unsigned NOT NULL DEFAULT '0',
  account_num_pricing_system int(10) unsigned NOT NULL DEFAULT '0',
  account_time int(10) unsigned NOT NULL DEFAULT '0',
  account_percent float(8,2) unsigned NOT NULL DEFAULT '0.00',
  account_price float(12,2) unsigned NOT NULL DEFAULT '0.00',
  account_web int(1) unsigned NOT NULL DEFAULT '0',
  account_web_percent float(8,2) unsigned NOT NULL DEFAULT '0.00',
  account_web_price float(12,2) unsigned NOT NULL DEFAULT '0.00',
  account_comment text COLLATE utf8_unicode_ci,
  account_request_status int(1) unsigned NOT NULL DEFAULT '1',
  account_num_acte int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_account)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_accounts`
--


--
-- Table structure for table `rent_accounts_invoices`
--

CREATE TABLE rent_accounts_invoices (
  account_invoice_num_account int(10) unsigned NOT NULL DEFAULT '0',
  account_invoice_num_invoice int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (account_invoice_num_account,account_invoice_num_invoice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_accounts_invoices`
--


--
-- Table structure for table `rent_invoices`
--

CREATE TABLE rent_invoices (
  id_invoice int(10) unsigned NOT NULL AUTO_INCREMENT,
  invoice_num_user int(10) unsigned NOT NULL DEFAULT '0',
  invoice_date datetime DEFAULT NULL,
  invoice_status int(10) unsigned NOT NULL DEFAULT '1',
  invoice_valid_date datetime DEFAULT NULL,
  invoice_destination varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  invoice_num_acte int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_invoice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_invoices`
--


--
-- Table structure for table `rent_pricing_system_grids`
--

CREATE TABLE rent_pricing_system_grids (
  id_pricing_system_grid int(10) unsigned NOT NULL AUTO_INCREMENT,
  pricing_system_grid_num_system int(10) unsigned NOT NULL DEFAULT '0',
  pricing_system_grid_time_start int(10) unsigned NOT NULL DEFAULT '0',
  pricing_system_grid_time_end int(10) unsigned NOT NULL DEFAULT '0',
  pricing_system_grid_price float(12,2) unsigned NOT NULL DEFAULT '0.00',
  pricing_system_grid_type int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_pricing_system_grid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_pricing_system_grids`
--


--
-- Table structure for table `rent_pricing_systems`
--

CREATE TABLE rent_pricing_systems (
  id_pricing_system int(10) unsigned NOT NULL AUTO_INCREMENT,
  pricing_system_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  pricing_system_desc text COLLATE utf8_unicode_ci,
  pricing_system_percents text COLLATE utf8_unicode_ci,
  pricing_system_num_exercice int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_pricing_system)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rent_pricing_systems`
--


--
-- 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',
  resa_pnb_flag int(1) 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),
  KEY i_resa_idempr (resa_idempr)
) 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',
  resarc_pnb_flag int(1) 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO resa_archive (resarc_id, resarc_date, resarc_debut, resarc_fin, resarc_idnotice, resarc_idbulletin, resarc_confirmee, resarc_cb, resarc_loc_retrait, resarc_from_opac, resarc_anulee, resarc_pretee, resarc_arcpretid, resarc_id_empr, resarc_empr_cp, resarc_empr_ville, resarc_empr_prof, resarc_empr_year, resarc_empr_categ, resarc_empr_codestat, resarc_empr_sexe, resarc_empr_location, resarc_expl_nb, resarc_expl_typdoc, resarc_expl_cote, resarc_expl_statut, resarc_expl_location, resarc_expl_codestat, resarc_expl_owner, resarc_expl_section, resarc_resa_planning_id_resa, resarc_pnb_flag) VALUES (1,'2016-02-10 16:16:40','0000-00-00','0000-00-00',90,0,0,'',0,1,1,0,0,11,'','','',0,10,3,0,1,1,0,'',0,0,0,0,0,0,0);

--
-- 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 (
  id_responsability int(10) unsigned NOT NULL AUTO_INCREMENT,
  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 (id_responsability,responsability_author,responsability_notice,responsability_fonction),
  KEY responsability_notice (responsability_notice),
  KEY i_responsability_author (responsability_author)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

--
-- Table structure for table `responsability_authperso`
--

CREATE TABLE responsability_authperso (
  id_responsability_authperso int(10) unsigned NOT NULL AUTO_INCREMENT,
  responsability_authperso_author mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_authperso_num mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_authperso_fonction varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  responsability_authperso_type mediumint(1) unsigned NOT NULL DEFAULT '0',
  responsability_authperso_ordre smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_responsability_authperso,responsability_authperso_author,responsability_authperso_num,responsability_authperso_fonction),
  KEY responsability_authperso_num (responsability_authperso_num),
  KEY responsability_authperso_author (responsability_authperso_author)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `responsability_authperso`
--


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

CREATE TABLE responsability_tu (
  id_responsability_tu int(10) unsigned NOT NULL AUTO_INCREMENT,
  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 (id_responsability_tu,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,
  metadata_rss_flux int(1) unsigned NOT NULL DEFAULT '1',
  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_title_rss_flux varchar(255) COLLATE utf8_unicode_ci DEFAULT '0',
  tpl_rss_flux varchar(255) COLLATE utf8_unicode_ci DEFAULT '0',
  id_tri_rss_flux int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_rss_flux),
  KEY i_id_tri_rss_flux (id_tri_rss_flux)
) ENGINE=MyISAM AUTO_INCREMENT=3 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 text 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 mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_rubrique)
) ENGINE=MyISAM 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 mediumtext COLLATE utf8_unicode_ci,
  sauv_log_userid int(11) DEFAULT NULL,
  PRIMARY KEY (sauv_log_id)
) ENGINE=MyISAM 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 mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_lieux mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_users mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_compress int(11) DEFAULT '0',
  sauv_sauvegarde_compress_command mediumtext 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=3 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 text COLLATE utf8_unicode_ci,
  PRIMARY KEY (sauv_table_id),
  UNIQUE KEY sauv_table_nom (sauv_table_nom)
) ENGINE=MyISAM AUTO_INCREMENT=3 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_passwords,empr_statut,empty_words_calculs,entites,entrepot_source_1,entrepot_source_3,entrepot_source_4,entrepot_source_5,entrepot_source_6,entrepot_source_7,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,ontology_g2t,ontology_id2val,ontology_o2val,ontology_s2val,ontology_setting,ontology_triple,opac_filters,opac_liste_lecture,opac_sessions,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_g2t,rdfstore_id2val,rdfstore_index,rdfstore_o2val,rdfstore_s2val,rdfstore_setting,rdfstore_triple,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 `scan_request_explnum`
--

CREATE TABLE scan_request_explnum (
  scan_request_explnum_num_request int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_explnum_num_notice int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_explnum_num_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_explnum_num_explnum int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (scan_request_explnum_num_request,scan_request_explnum_num_explnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_request_explnum`
--


--
-- Table structure for table `scan_request_linked_records`
--

CREATE TABLE scan_request_linked_records (
  scan_request_linked_record_num_request int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_linked_record_num_notice int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_linked_record_num_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_linked_record_comment text COLLATE utf8_unicode_ci,
  scan_request_linked_record_order int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (scan_request_linked_record_num_request,scan_request_linked_record_num_notice,scan_request_linked_record_num_bulletin)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_request_linked_records`
--


--
-- Table structure for table `scan_request_priorities`
--

CREATE TABLE scan_request_priorities (
  id_scan_request_priority int(10) unsigned NOT NULL AUTO_INCREMENT,
  scan_request_priority_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  scan_request_priority_weight int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_scan_request_priority)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_request_priorities`
--


--
-- Table structure for table `scan_request_status`
--

CREATE TABLE scan_request_status (
  id_scan_request_status int(10) unsigned NOT NULL AUTO_INCREMENT,
  scan_request_status_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  scan_request_status_opac_show int(1) NOT NULL DEFAULT '0',
  scan_request_status_cancelable int(1) NOT NULL DEFAULT '0',
  scan_request_status_infos_editable int(1) NOT NULL DEFAULT '0',
  scan_request_status_class_html varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  scan_request_status_is_closed int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_scan_request_status)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_request_status`
--

INSERT INTO scan_request_status (id_scan_request_status, scan_request_status_label, scan_request_status_opac_show, scan_request_status_cancelable, scan_request_status_infos_editable, scan_request_status_class_html, scan_request_status_is_closed) VALUES (1,'Sans statut particulier',1,0,0,'',0);

--
-- Table structure for table `scan_request_status_workflow`
--

CREATE TABLE scan_request_status_workflow (
  scan_request_status_workflow_from_num int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_status_workflow_to_num int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (scan_request_status_workflow_from_num,scan_request_status_workflow_to_num)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_request_status_workflow`
--


--
-- Table structure for table `scan_requests`
--

CREATE TABLE scan_requests (
  id_scan_request int(10) unsigned NOT NULL AUTO_INCREMENT,
  scan_request_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  scan_request_desc text COLLATE utf8_unicode_ci,
  scan_request_num_status int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_num_priority int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_create_date datetime DEFAULT NULL,
  scan_request_update_date datetime DEFAULT NULL,
  scan_request_date datetime DEFAULT NULL,
  scan_request_wish_date datetime DEFAULT NULL,
  scan_request_deadline_date datetime DEFAULT NULL,
  scan_request_comment text COLLATE utf8_unicode_ci,
  scan_request_elapsed_time int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_num_dest_empr int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_num_creator int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_type_creator int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_num_last_user int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_state int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_as_folder int(1) unsigned NOT NULL DEFAULT '0',
  scan_request_folder_num_notice int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_concept_uri varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  scan_request_nb_scanned_pages int(10) unsigned NOT NULL DEFAULT '0',
  scan_request_num_location int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_scan_request)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scan_requests`
--


--
-- 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,
  search_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECORDS',
  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 text COLLATE utf8_unicode_ci NOT NULL,
  search_human text COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  autorisations mediumtext COLLATE utf8_unicode_ci,
  search_order int(11) NOT NULL DEFAULT '0',
  search_comment text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (search_id)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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 text COLLATE utf8_unicode_ci NOT NULL,
  search_human text COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  search_limitsearch tinyint(1) unsigned NOT NULL DEFAULT '0',
  search_order int(11) NOT NULL DEFAULT '0',
  search_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'record',
  search_opac_views_num text COLLATE utf8_unicode_ci NOT NULL,
  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 `search_segments`
--

CREATE TABLE search_segments (
  id_search_segment int(10) unsigned NOT NULL AUTO_INCREMENT,
  search_segment_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_segment_description varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_segment_template_directory varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_segment_num_universe int(11) NOT NULL DEFAULT '0',
  search_segment_type int(11) NOT NULL DEFAULT '0',
  search_segment_order int(11) NOT NULL DEFAULT '0',
  search_segment_set text COLLATE utf8_unicode_ci,
  search_segment_logo varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_segment_sort text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_search_segment)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_segments`
--


--
-- Table structure for table `search_segments_facets`
--

CREATE TABLE search_segments_facets (
  num_search_segment int(11) NOT NULL DEFAULT '0',
  num_facet int(11) NOT NULL DEFAULT '0',
  search_segment_facet_order int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (num_search_segment,num_facet)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_segments_facets`
--


--
-- Table structure for table `search_segments_search_perso`
--

CREATE TABLE search_segments_search_perso (
  num_search_segment int(10) unsigned NOT NULL DEFAULT '0',
  num_search_perso int(10) unsigned NOT NULL DEFAULT '0',
  search_segment_search_perso_opac int(10) unsigned NOT NULL DEFAULT '0',
  search_segment_search_perso_order int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (num_search_segment,num_search_perso)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_segments_search_perso`
--


--
-- Table structure for table `search_universes`
--

CREATE TABLE search_universes (
  id_search_universe int(10) unsigned NOT NULL AUTO_INCREMENT,
  search_universe_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_universe_description varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_universe_template_directory varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_universe_opac_views varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_universe_default_segment int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_search_universe)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_universes`
--


--
-- 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 text 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),
  KEY i_num_serialcirc_abt (num_serialcirc_abt)
) 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 text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_ask),
  KEY i_num_serialcirc_ask_perio (num_serialcirc_ask_perio),
  KEY i_num_serialcirc_ask_serialcirc (num_serialcirc_ask_serialcirc),
  KEY i_num_serialcirc_ask_empr (num_serialcirc_ask_empr),
  KEY i_serialcirc_ask_type (serialcirc_ask_type),
  KEY i_serialcirc_ask_statut (serialcirc_ask_statut)
) 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,
  serialcirc_circ_group_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_serialcirc_circ),
  KEY i_num_serialcirc_circ_diff (num_serialcirc_circ_diff),
  KEY i_num_serialcirc_circ_expl (num_serialcirc_circ_expl),
  KEY i_num_serialcirc_circ_empr (num_serialcirc_circ_empr),
  KEY i_num_serialcirc_circ_serialcirc (num_serialcirc_circ_serialcirc)
) 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 text 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 text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_copy),
  KEY i_num_serialcirc_copy_empr (num_serialcirc_copy_empr),
  KEY i_num_serialcirc_copy_bulletin (num_serialcirc_copy_bulletin)
) 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),
  KEY i_num_serialcirc_diff_serialcirc (num_serialcirc_diff_serialcirc),
  KEY i_serialcirc_diff_empr_type (serialcirc_diff_empr_type),
  KEY i_serialcirc_diff_type_diff (serialcirc_diff_type_diff),
  KEY i_num_serialcirc_diff_empr (num_serialcirc_diff_empr)
) 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),
  KEY i_num_serialcirc_expl_id (num_serialcirc_expl_id),
  KEY i_num_serialcirc_expl_serialcirc (num_serialcirc_expl_serialcirc),
  KEY i_num_serialcirc_expl_serialcirc_diff (num_serialcirc_expl_serialcirc_diff),
  KEY i_num_serialcirc_expl_current_empr (num_serialcirc_expl_current_empr)
) 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),
  KEY i_num_serialcirc_group_diff (num_serialcirc_group_diff),
  KEY i_num_serialcirc_group_empr (num_serialcirc_group_empr)
) 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',
  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',
  `comment` blob NOT NULL,
  custom_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `serie_custom_dates`
--

CREATE TABLE serie_custom_dates (
  serie_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_date_type int(11) DEFAULT NULL,
  serie_custom_date_start int(11) NOT NULL DEFAULT '0',
  serie_custom_date_end int(11) NOT NULL DEFAULT '0',
  serie_custom_order int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (serie_custom_champ,serie_custom_origine,serie_custom_order),
  KEY serie_custom_champ (serie_custom_champ),
  KEY serie_custom_origine (serie_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom_dates`
--


--
-- 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,
  serie_custom_order int(11) NOT NULL DEFAULT '0',
  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 text 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(255) 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,
  PRIMARY KEY (SESSID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('4078794012','admin','127.0.0.1','1617718207','1617723679','PhpMyBibli',NULL);
INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('2877701304','','127.0.0.1','1617791274','1617791274','PmbOpac',NULL);
INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('9339674844','admin','127.0.0.1','1617807462','1617807683','PhpMyBibli',NULL);
INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('3288686049','admin','::1','1617742693','1617742693','PhpMyBibli',NULL);
INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('5634927573','admin','127.0.0.1','1617791010','1617792012','PhpMyBibli',NULL);
INSERT INTO sessions (SESSID, login, IP, SESSstart, LastOn, SESSNAME, notifications) VALUES ('4264722076','','127.0.0.1','1617791274','1617807587','PmbOpac',NULL);

--
-- Table structure for table `sessions_tokens`
--

CREATE TABLE sessions_tokens (
  sessions_tokens_SESSID varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sessions_tokens_token varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sessions_tokens_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (sessions_tokens_SESSID,sessions_tokens_type),
  KEY i_st_sessions_tokens_type (sessions_tokens_type),
  KEY i_st_sessions_tokens_token (sessions_tokens_token)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sessions_tokens`
--


--
-- 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),
  KEY i_shorturl_hash (shorturl_hash)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `skos_custom`
--

CREATE TABLE skos_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',
  `comment` blob NOT NULL,
  custom_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_custom`
--


--
-- Table structure for table `skos_custom_dates`
--

CREATE TABLE skos_custom_dates (
  skos_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  skos_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  skos_custom_date_type int(11) DEFAULT NULL,
  skos_custom_date_start int(11) NOT NULL DEFAULT '0',
  skos_custom_date_end int(11) NOT NULL DEFAULT '0',
  skos_custom_order int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (skos_custom_champ,skos_custom_origine,skos_custom_order),
  KEY skos_custom_champ (skos_custom_champ),
  KEY skos_custom_origine (skos_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_custom_dates`
--


--
-- Table structure for table `skos_custom_lists`
--

CREATE TABLE skos_custom_lists (
  skos_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  skos_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  skos_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY skos_custom_champ (skos_custom_champ),
  KEY skos_champ_list_value (skos_custom_champ,skos_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_custom_lists`
--


--
-- Table structure for table `skos_custom_values`
--

CREATE TABLE skos_custom_values (
  skos_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  skos_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  skos_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  skos_custom_text text COLLATE utf8_unicode_ci,
  skos_custom_integer int(11) DEFAULT NULL,
  skos_custom_date date DEFAULT NULL,
  skos_custom_float float DEFAULT NULL,
  skos_custom_order int(11) NOT NULL DEFAULT '0',
  KEY skos_custom_champ (skos_custom_champ),
  KEY i_encv_st (skos_custom_small_text),
  KEY i_encv_t (skos_custom_text(255)),
  KEY i_encv_i (skos_custom_integer),
  KEY i_encv_d (skos_custom_date),
  KEY i_encv_f (skos_custom_float),
  KEY skos_custom_origine (skos_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_custom_values`
--


--
-- 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,code_ss_champ,num_word,position,field_position),
  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),
  KEY i_num_word (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 text 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`
--


--
-- 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 text 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 mediumblob 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` tinytext COLLATE utf8_unicode_ci NOT NULL,
  parameters text COLLATE utf8_unicode_ci NOT NULL,
  num_vue mediumint(8) NOT NULL DEFAULT '0',
  autorisations mediumtext 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` tinytext 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 AUTO_INCREMENT=3 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 `sticks_sheets`
--

CREATE TABLE sticks_sheets (
  id_sticks_sheet int(10) unsigned NOT NULL AUTO_INCREMENT,
  sticks_sheet_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sticks_sheet_data text COLLATE utf8_unicode_ci NOT NULL,
  sticks_sheet_order int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_sticks_sheet)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sticks_sheets`
--


--
-- 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO storages (id_storage, storage_name, storage_class, storage_params) VALUES (1,'portefolio','upload_folder_storage','a:1:{s:6:\"id_rep\";s:1:\"2\";}');

--
-- 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 text COLLATE utf8_unicode_ci,
  subcollection_web text COLLATE utf8_unicode_ci NOT NULL,
  subcollection_comment text 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',
  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',
  `comment` blob NOT NULL,
  custom_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `subcollection_custom_dates`
--

CREATE TABLE subcollection_custom_dates (
  subcollection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_date_type int(11) DEFAULT NULL,
  subcollection_custom_date_start int(11) NOT NULL DEFAULT '0',
  subcollection_custom_date_end int(11) NOT NULL DEFAULT '0',
  subcollection_custom_order int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (subcollection_custom_champ,subcollection_custom_origine,subcollection_custom_order),
  KEY subcollection_custom_champ (subcollection_custom_champ),
  KEY subcollection_custom_origine (subcollection_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom_dates`
--


--
-- 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,
  subcollection_custom_order int(11) NOT NULL DEFAULT '0',
  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 `subst_files`
--

CREATE TABLE subst_files (
  id_subst_file int(10) unsigned NOT NULL AUTO_INCREMENT,
  subst_file_path varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  subst_file_filename varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  subst_file_data mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_subst_file)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subst_files`
--


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

CREATE TABLE suggestions (
  id_suggestion int(12) unsigned NOT NULL AUTO_INCREMENT,
  titre tinytext 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 text 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 text 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 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),
  KEY i_num_suggestion (num_suggestion)
) 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 text 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 text 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 text 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 `thresholds`
--

CREATE TABLE thresholds (
  id_threshold int(10) unsigned NOT NULL AUTO_INCREMENT,
  threshold_label varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  threshold_amount float NOT NULL DEFAULT '0',
  threshold_amount_tax_included int(1) NOT NULL DEFAULT '0',
  threshold_footer text COLLATE utf8_unicode_ci NOT NULL,
  threshold_num_entity int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_threshold)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `thresholds`
--


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

CREATE TABLE titres_uniformes (
  tu_id int(9) unsigned NOT NULL AUTO_INCREMENT,
  tu_name text COLLATE utf8_unicode_ci,
  tu_tonalite varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_comment text COLLATE utf8_unicode_ci NOT NULL,
  index_tu text 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 '',
  tu_oeuvre_nature varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  tu_oeuvre_type varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  tu_oeuvre_nature_nature varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'original',
  PRIMARY KEY (tu_id),
  KEY i_tu_tu_oeuvre_type (tu_oeuvre_type),
  KEY i_tu_tu_oeuvre_nature (tu_oeuvre_nature)
) 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 `transaction_payment_methods`
--

CREATE TABLE transaction_payment_methods (
  transaction_payment_method_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  transaction_payment_method_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (transaction_payment_method_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transaction_payment_methods`
--


--
-- 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 text 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',
  transaction_payment_method_num int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_transaction),
  KEY i_realisee (realisee),
  KEY i_compte_id (compte_id)
) 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, transaction_payment_method_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,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 '',
  transfert_ask_user_num int(11) NOT NULL DEFAULT '0',
  transfert_send_user_num int(11) NOT NULL DEFAULT '0',
  transfert_ask_date date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (id_transfert),
  KEY etat_transfert (etat_transfert),
  KEY i_etat_transfert_origine (etat_transfert,origine)
) 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),
  KEY i_resa_trans (resa_trans)
) 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_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  trans_text text COLLATE utf8_unicode_ci,
  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`
--

INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('docs_section','section_libelle','fr_FR',32,'Jeux d\'assemblage',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('docs_section','section_libelle','fr_FR',33,'Jeux d\'exercice',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('docs_section','section_libelle','fr_FR',34,'Jeux de règle',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('docs_section','section_libelle','fr_FR',35,'Jeux symbolique',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('facettes','facette_name','fr_FR',6,'Années',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('facettes','facette_name','fr_FR',7,'Auteurs',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('facettes_external','facette_name','fr_FR',1,'Sources',NULL);
INSERT INTO translation (trans_table, trans_field, trans_lang, trans_num, trans_small_text, trans_text) VALUES ('contact_form_objects','object_label','fr_FR',1,'Demande de renseignement',NULL);

--
-- 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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO tris (id_tri, tri_par, nom_tri, tri_reference) VALUES (3,'d_num_6,c_text_28','','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',
  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',
  `comment` blob NOT NULL,
  custom_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `tu_custom_dates`
--

CREATE TABLE tu_custom_dates (
  tu_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  tu_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  tu_custom_date_type int(11) DEFAULT NULL,
  tu_custom_date_start int(11) NOT NULL DEFAULT '0',
  tu_custom_date_end int(11) NOT NULL DEFAULT '0',
  tu_custom_order int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (tu_custom_champ,tu_custom_origine,tu_custom_order),
  KEY tu_custom_champ (tu_custom_champ),
  KEY tu_custom_origine (tu_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_custom_dates`
--


--
-- 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,
  tu_custom_order int(11) NOT NULL DEFAULT '0',
  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_oeuvres_events`
--

CREATE TABLE tu_oeuvres_events (
  oeuvre_event_tu_num int(11) NOT NULL DEFAULT '0',
  oeuvre_event_authperso_authority_num int(11) NOT NULL DEFAULT '0',
  oeuvre_event_order int(11) NOT NULL DEFAULT '0',
  KEY i_toe_oeuvre_event_tu_num (oeuvre_event_tu_num),
  KEY i_toe_oeuvre_event_authperso_authority_num (oeuvre_event_authperso_authority_num)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_oeuvres_events`
--


--
-- Table structure for table `tu_oeuvres_links`
--

CREATE TABLE tu_oeuvres_links (
  oeuvre_link_from int(11) NOT NULL DEFAULT '0',
  oeuvre_link_to int(11) NOT NULL DEFAULT '0',
  oeuvre_link_type varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  oeuvre_link_expression int(11) NOT NULL DEFAULT '0',
  oeuvre_link_other_link int(11) NOT NULL DEFAULT '1',
  oeuvre_link_order int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (oeuvre_link_from,oeuvre_link_to,oeuvre_link_type,oeuvre_link_expression,oeuvre_link_other_link),
  KEY i_oeuvre_link_from (oeuvre_link_from),
  KEY i_oeuvre_link_to (oeuvre_link_to)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tu_oeuvres_links`
--


--
-- 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 text 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 text 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 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 text COLLATE utf8_unicode_ci NOT NULL,
  repertoire_path text 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO upload_repertoire (repertoire_id, repertoire_nom, repertoire_url, repertoire_path, repertoire_navigation, repertoire_hachage, repertoire_subfolder, repertoire_utf8) VALUES (1,'Documents numeriques','','/a_definir/pmb_documents_numeriques/',0,0,20,1);
INSERT INTO upload_repertoire (repertoire_id, repertoire_nom, repertoire_url, repertoire_path, repertoire_navigation, repertoire_hachage, repertoire_subfolder, repertoire_utf8) VALUES (2,'Portfolio','','/a_definir/pmb_portfolio/',0,0,20,1);
INSERT INTO upload_repertoire (repertoire_id, repertoire_nom, repertoire_url, repertoire_path, repertoire_navigation, repertoire_hachage, repertoire_subfolder, repertoire_utf8) VALUES (3,'Vignettes','','/a_definir/pmb_vignettes/',0,0,20,1);

--
-- 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_chat_activate int(1) NOT NULL DEFAULT '0',
  param_licence int(1) unsigned NOT NULL DEFAULT '0',
  deflt_notice_statut int(6) unsigned NOT NULL DEFAULT '1',
  deflt_notice_statut_analysis int(6) unsigned DEFAULT '0',
  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_serials_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_contribmail 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',
  user_alert_serialcircmail 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_empr_categ int(10) unsigned NOT NULL DEFAULT '1',
  deflt_empr_codestat int(10) 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 mediumtext 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 text COLLATE utf8_unicode_ci,
  explr_visible_mod text COLLATE utf8_unicode_ci,
  explr_visible_unmod text 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',
  deflt3type_produit int(8) unsigned 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',
  user_alert_suggmail int(1) unsigned NOT NULL DEFAULT '0',
  deflt_explnum_statut int(6) unsigned NOT NULL DEFAULT '1',
  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',
  deflt_scan_request_status int(1) unsigned NOT NULL DEFAULT '0',
  xmlta_doctype_scan_request_folder_record varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  deflt_camera_empr int(11) NOT NULL DEFAULT '0',
  deflt_catalog_expanded_caddies int(1) unsigned NOT NULL DEFAULT '1',
  deflt_notice_replace_links int(1) unsigned DEFAULT '0',
  deflt_printer int(3) unsigned DEFAULT '0',
  deflt_opac_visible_bulletinage int(11) NOT NULL DEFAULT '1',
  deflt_scan_request_explnum_status int(1) unsigned NOT NULL DEFAULT '0',
  deflt_type_abts int(5) unsigned NOT NULL DEFAULT '0',
  deflt_docwatch_watch_filter_deleted int(1) unsigned NOT NULL DEFAULT '0',
  deflt_pclassement int(3) unsigned NOT NULL DEFAULT '1',
  deflt_associated_campaign int(1) unsigned NOT NULL DEFAULT '0',
  deflt_bypass_isbn_page int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (userid)
) ENGINE=MyISAM AUTO_INCREMENT=2 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_chat_activate, param_licence, deflt_notice_statut, deflt_notice_statut_analysis, deflt_integration_notice_statut, xmlta_indexation_lang, deflt_docs_type, deflt_serials_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_contribmail, user_alert_demandesmail, user_alert_subscribemail, user_alert_serialcircmail, deflt2docs_location, deflt_empr_statut, deflt_empr_categ, deflt_empr_codestat, 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, deflt3type_produit, 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, user_alert_suggmail, deflt_explnum_statut, deflt_notice_replace_keep_categories, deflt_notice_is_new, deflt_agnostic_warehouse, deflt_cms_article_statut, deflt_cms_article_type, deflt_cms_section_type, deflt_scan_request_status, xmlta_doctype_scan_request_folder_record, deflt_camera_empr, deflt_catalog_expanded_caddies, deflt_notice_replace_links, deflt_printer, deflt_opac_visible_bulletinage, deflt_scan_request_explnum_status, deflt_type_abts, deflt_docwatch_watch_filter_deleted, deflt_pclassement, deflt_associated_campaign, deflt_bypass_isbn_page) VALUES (1,'2002-07-28','2021-04-06','admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441','028262ca7d82187e983fa4a9937891e2','Super User','',1247487,'fr_FR',20,20,50,0,0,0,0,0,1,0,1,'',1,1,2,'enjoy',1,12,'fre','070','a-up','a-up','a-up','a-up',1,0,0,0,10,'admin','',0,0,0,0,0,1,1,8,3,1,0,1,'','a','a','a','a','','','0','0','0','0',0,0,0,0,0,0,0,0,0,0x613A313A7B733A333A22636D73223B613A333A7B693A313B733A343A2254727565223B693A323B733A343A2254727565223B693A333B733A353A2246616C7365223B7D7D,1,0,1,1,1,1,0,0,0,0,0,0,1,1,0,0,2,0,0,0,'',0,1,0,0,1,1,0,0,1,0,0);

--
