--
-- Host: localhost    Database: lliurexpmb
-- ------------------------------------------------------


--
-- Table structure for table `z_attr`
--

CREATE TABLE `z_attr` (
  `attr_bib_id` int(6) unsigned NOT NULL default '0',
  `attr_libelle` varchar(250) NOT NULL default '',
  `attr_attr` varchar(250) default NULL,
  PRIMARY KEY  (`attr_bib_id`,`attr_libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `z_attr`
--

INSERT INTO `z_attr` VALUES (1,'sujet','21'),(1,'auteur','1003'),(1,'isbn','7'),(1,'titre','4'),(2,'sujet','21'),(2,'auteur','1003'),(2,'isbn','7'),(2,'titre','4'),(3,'sujet','21'),(3,'auteur','1003'),(3,'isbn','7'),(3,'titre','4'),(4,'sujet','21'),(4,'auteur','1003'),(4,'isbn','7'),(4,'titre','4'),(5,'sujet','21'),(5,'auteur','1003'),(5,'isbn','7'),(5,'titre','4'),(6,'sujet','21'),(6,'auteur','1003'),(6,'isbn','7'),(6,'titre','4'),(7,'sujet','21'),(7,'auteur','1003'),(7,'isbn','7'),(7,'titre','4'),(8,'sujet','21'),(8,'auteur','1003'),(8,'isbn','7'),(8,'titre','4'),(9,'sujet','21'),(9,'auteur','1003'),(9,'isbn','7'),(9,'titre','4'),(10,'sujet','21'),(10,'auteur','1003'),(10,'isbn','7'),(10,'titre','4'),(11,'sujet','21'),(11,'auteur','1003'),(11,'isbn','7'),(11,'titre','4'),(12,'sujet','21'),(12,'auteur','1003'),(12,'isbn','7'),(12,'titre','4'),(13,'sujet','21'),(13,'auteur','1003'),(13,'isbn','7'),(13,'titre','4'),(14,'sujet','21'),(14,'auteur','1003'),(14,'isbn','7'),(14,'titre','4'),(15,'sujet','21'),(15,'auteur','1003'),(15,'isbn','7'),(15,'titre','4'),(16,'sujet','21'),(16,'auteur','1003'),(16,'isbn','7'),(16,'titre','4'),(17,'sujet','21'),(17,'auteur','1003'),(17,'isbn','7'),(17,'titre','4'),(18,'sujet','21'),(18,'auteur','1003'),(18,'isbn','7'),(18,'titre','4'),(19,'sujet','21'),(19,'auteur','1003'),(19,'isbn','7'),(19,'titre','4'),(20,'sujet','21'),(20,'auteur','1003'),(20,'isbn','7'),(20,'titre','4'),(21,'sujet','21'),(21,'auteur','1003'),(21,'isbn','7'),(21,'titre','4'),(22,'sujet','21'),(22,'auteur','1003'),(22,'isbn','7'),(22,'titre','4'),(23,'sujet','21'),(23,'auteur','1003'),(23,'isbn','7'),(23,'titre','4'),(24,'sujet','21'),(24,'auteur','1003'),(24,'isbn','7'),(24,'titre','4'),(25,'sujet','21'),(25,'auteur','1003'),(25,'isbn','7'),(25,'titre','4'),(26,'sujet','21'),(26,'auteur','1003'),(26,'isbn','7'),(26,'titre','4'),(27,'sujet','21'),(27,'auteur','1003'),(27,'isbn','7'),(27,'titre','4'),(28,'sujet','21'),(28,'auteur','1003'),(28,'isbn','7'),(28,'titre','4'),(29,'sujet','21'),(29,'auteur','1003'),(29,'isbn','7'),(29,'titre','4'),(30,'sujet','21'),(30,'auteur','1003'),(30,'isbn','7'),(30,'titre','4'),(31,'sujet','21'),(31,'auteur','1003'),(31,'isbn','7'),(31,'titre','4'),(32,'sujet','21'),(32,'auteur','1003'),(32,'isbn','7'),(32,'titre','4'),(33,'sujet','21'),(33,'auteur','1003'),(33,'isbn','7'),(33,'titre','4'),(34,'sujet','21'),(34,'auteur','1003'),(34,'isbn','7'),(34,'titre','4'),(35,'sujet','21'),(35,'auteur','1003'),(35,'isbn','7'),(35,'titre','4'),(36,'sujet','21'),(36,'auteur','1003'),(36,'isbn','7'),(36,'titre','4'),(37,'sujet','21'),(37,'auteur','1003'),(37,'isbn','7'),(37,'titre','4'),(38,'sujet','21'),(38,'auteur','1003'),(38,'isbn','7'),(38,'titre','4');

--
-- Table structure for table `z_bib`
--

CREATE TABLE `z_bib` (
  `bib_id` int(6) unsigned NOT NULL auto_increment,
  `bib_nom` varchar(250) default NULL,
  `search_type` varchar(20) default NULL,
  `url` varchar(250) default NULL,
  `port` varchar(6) default NULL,
  `base` varchar(250) default NULL,
  `format` varchar(250) default NULL,
  `auth_user` varchar(250) NOT NULL default '',
  `auth_pass` varchar(250) NOT NULL default '',
  `sutrs_lang` varchar(10) NOT NULL default '',
  `fichier_func` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`bib_id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `z_bib`
--

INSERT INTO `z_bib` VALUES (1,'Universidad de Córdoba','CATALOG','medina.uco.es','210','INNOPAC','USMARC','','','',''),(2,'Biblioteca Nacional','CATALOG','sigb.bne.es','2200','Unicorn','USMARC','','','',''),(3,'Biblioteca Valenciana','CATALOG','bv.gva.es','2102','ABSYSE','IBERMARC','','','',''),(4,'Biblioteca de Castilla y León','CATALOG','z3950.bcl.jcyl.es','210','AbsysBCL','USMARC','','','',''),(5,'Biblioteca Pública de Avila','CATALOG','bpavila.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(6,'Biblioteca Pública de Burgos','CATALOG','bpburgos.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(7,'Biblioteca Pública de León','CATALOG','bpleon.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(8,'Biblioteca Pública de Palencia','CATALOG','bppal.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(9,'Biblioteca Pública de Salamanca','CATALOG','bpsalamanca.bcl.jcyl.es','210','AbsysE','USMARC','','','',''),(10,'Biblioteca Pública de Segovia','CATALOG','bpsegovia.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(11,'Biblioteca Pública de Soria','CATALOG','bpsoria.bcl.jycl.es','210','AbsysE','USMARC','','','',''),(12,'Biblioteca Pública de Zaragoza','CATALOG','codos.aragob.es','5500','ABSYSE','USMARC','','','',''),(13,'Biblioteca Central de La Rioja','CATALOG','bcr1.larioja.org','210','AbsysE','USMARC','','','',''),(14,'Congreso de los Diputados','CATALOG','www.congreso.es','2100','absysbcd','USMARC','','','',''),(15,'REBECA (Requiere usuario y contraseña. Solicitar en http://www.mcu.es/bibliotecas/MC/Rebeca/index.html)','CATALOG','rebeca.mcu.es','210','absysrebeca','USMARC','','','',''),(16,'REBIUN','CATALOG','rebiun.crue.org','210','ABSYSREBIUN','USMARC','','','',''),(17,'Biblioteca Virtual Miguel de Cervantes','CATALOG','z.cervantesvirtual.com','2100','bimicesa','USMARC','','','',''),(18,'Universidad de Alcalá de Henares','CATALOG','biblio.uah.es','2200','unicorn','USMARC','','','',''),(19,'Universidad de Alicante','CATALOG','gaudi.ua.es','2200','unicorn','USMARC','','','',''),(20,'Universidad Autónoma de Madrid','CATALOG','biblos.uam.es','2200','unicorn','USMARC','','','',''),(21,'Universidad Carlos III de Madrid','CATALOG','biblioteca.uc3m.es','2200','unicorn','USMARC','','','',''),(22,'Universidad Complutense de Madrid','CATALOG','cisne.sim.ucm.es','210','INNOPAC','USMARC','cisne','','',''),(23,'Universidad de las Islas Baleares','CATALOG','130.206.134.239','210','INNOPAC','USMARC','','','',''),(24,'Universidad de Jaén','CATALOG','venzala.ujaen.es','210','ABSYSE','USMARC','','','',''),(25,'Universidad de La Laguna','CATALOG','193.145.120.49','210','ABSYSE','USMARC','','','',''),(26,'Universidad de La Rioja','CATALOG','merly.unirioja.es','9000','ABSYSE','USMARC','','','',''),(27,'Universidad Politécnica de Madrid','CATALOG','marte.biblioteca.upm.es','2200','unicorn','USMARC','','','',''),(28,'Universidad Rey Juan Carlos','CATALOG','centauro.urjc.es','2200','unicorn','USMARC','','','',''),(29,'Universidad de Valencia','CATALOG','mvs.ci.uv.es','3003','xxdefault','USMARC','','','',''),(30,'Universidad de Zaragoza','CATALOG','cuarzo.unizar.es','210','LIBERTAS','USMARC','libtest','catalog','',''),(31,'Library Of Congress','CATALOG','z3950.loc.gov','7090','Voyager','USMARC','','','',''),(32,'Universidad Pública de Navarra','CATALOG','brocar.unavarra.es','9999','libros','USMARC','','','',''),(33,'Universidad de Burgos','CATALOG','ubucat.ubu.es','210','INNOPAC','USMARC','','','',''),(34,'Red de Bibliotecas del CSIC','CATALOG','aleph.csic.es','9909','MAD01','USMARC','','','',''),(35,'Universidad de Sevilla','CATALOG','fama.us.es','210','INNOPAC','USMARC','','','',''),(36,'Universidad de Castilla-La Mancha','CATALOG','z3950.uclm.es','210','ABNET_DB','USMARC','','','',''),(37,'Catálogo colectivo de las Bibliotecas de Castilla y León','CATALOG','z3950.bcl.jcyl.es','210','AbsysCCCL','USMARC','','','',''),(38,'UNED','CATALOG','biblio15.uned.es','210','unicorn','USMARC','','','','');

UPDATE `empr_statut` SET `statut_libelle` = 'Activo' WHERE `idstatut` = 1 LIMIT 1;
UPDATE `empr_statut` SET `statut_libelle` = 'Inactivo' WHERE `idstatut` = 2 LIMIT 1;



