# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 127.0.0.1
# Database:             cie
# Server version:       5.0.24a-community-nt-log
# Server OS:            Win32
# Target-Compatibility: Standard ANSI SQL
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'cie'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "cie" /*!40100 DEFAULT CHARACTER SET utf8 */;

USE "cie";


#
# Table structure for table 'caracteristicas'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "caracteristicas" (
  "id" int(5) unsigned NOT NULL,
  "biblioteca" int(5) unsigned default NULL,
  "estanteria" int(5) unsigned default NULL,
  "personal" int(5) unsigned default NULL,
  "lectura" int(5) unsigned default NULL,
  "asientos" int(4) unsigned default NULL,
  "lunes" int(1) unsigned default NULL,
  "lunes1" int(2) unsigned default NULL,
  "lunes2" int(2) unsigned default NULL,
  "lunes3" int(2) unsigned default NULL,
  "lunes4" int(2) unsigned default NULL,
  "lunes5" int(2) unsigned default NULL,
  "lunes6" int(2) unsigned default NULL,
  "sabado" int(1) unsigned default NULL,
  "sabado1" int(2) unsigned default NULL,
  "sabado2" int(2) unsigned default NULL,
  "sabado3" int(2) unsigned default NULL,
  "sabado4" int(2) unsigned default NULL,
  "sabado5" int(2) unsigned default NULL,
  "sabado6" int(2) unsigned default NULL,
  "domingo" int(1) unsigned default NULL,
  "domingo1" int(2) unsigned default NULL,
  "domingo2" int(2) unsigned default NULL,
  "domingo3" int(2) unsigned default NULL,
  "domingo4" int(2) unsigned default NULL,
  "domingo5" int(2) unsigned default NULL,
  "domingo6" int(2) unsigned default NULL,
  "dias" int(3) unsigned default NULL,
  "clasificacion" int(1) unsigned default NULL,
  "especifique" varchar(15) default NULL,
  "catalogo" int(1) unsigned default NULL,
  "estantes" int(4) unsigned default NULL,
  "metros" int(5) unsigned default NULL,
  "usuarios" int(7) unsigned default NULL,
  "inscritos" int(7) unsigned default NULL
) /*!40100 DEFAULT CHARSET=utf8*/;



#
# Dumping data for table 'caracteristicas'
#

LOCK TABLES "caracteristicas" WRITE;
/*!40000 ALTER TABLE "caracteristicas" DISABLE KEYS;*/
INSERT INTO "caracteristicas" ("id", "biblioteca", "estanteria", "personal", "lectura", "asientos", "lunes", "lunes1", "lunes2", "lunes3", "lunes4", "lunes5", "lunes6", "sabado", "sabado1", "sabado2", "sabado3", "sabado4", "sabado5", "sabado6", "domingo", "domingo1", "domingo2", "domingo3", "domingo4", "domingo5", "domingo6", "dias", "clasificacion", "especifique", "catalogo", "estantes", "metros", "usuarios", "inscritos") VALUES
	('0',NULL,'1','2','3','4',NULL,'5','6','7','8','9','10',NULL,'11','12','13','14','15','16',NULL,'17','18','19','20','21','22','23','24','25',NULL,'26','27','28','29');
INSERT INTO "caracteristicas" ("id", "biblioteca", "estanteria", "personal", "lectura", "asientos", "lunes", "lunes1", "lunes2", "lunes3", "lunes4", "lunes5", "lunes6", "sabado", "sabado1", "sabado2", "sabado3", "sabado4", "sabado5", "sabado6", "domingo", "domingo1", "domingo2", "domingo3", "domingo4", "domingo5", "domingo6", "dias", "clasificacion", "especifique", "catalogo", "estantes", "metros", "usuarios", "inscritos") VALUES
	('51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "caracteristicas" ("id", "biblioteca", "estanteria", "personal", "lectura", "asientos", "lunes", "lunes1", "lunes2", "lunes3", "lunes4", "lunes5", "lunes6", "sabado", "sabado1", "sabado2", "sabado3", "sabado4", "sabado5", "sabado6", "domingo", "domingo1", "domingo2", "domingo3", "domingo4", "domingo5", "domingo6", "dias", "clasificacion", "especifique", "catalogo", "estantes", "metros", "usuarios", "inscritos") VALUES
	('51',NULL,'23423','23142','0','0',NULL,'0','0','0','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0','0','0','0','0','0','0','0','',NULL,'0','0','0','0');
/*!40000 ALTER TABLE "caracteristicas" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'cie_cct'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "cie_cct" (
  "row_id" int(11) NOT NULL,
  "cveinm" char(8) default NULL,
  "clavecct" char(10) default NULL,
  "nombrect" char(80) default NULL,
  "domicilio" char(80) default NULL,
  "nombrecol" char(60) default NULL,
  "localidad" char(4) default NULL,
  "nombreloc" char(45) default NULL,
  "municipio" char(3) default NULL,
  "nombremun" char(45) default NULL,
  "codpost" char(5) default NULL,
  "telefono" char(12) default NULL,
  "fax" char(12) default NULL,
  "turno" char(1) default NULL,
  "zonaescola" char(3) default NULL,
  "cct_zona" char(10) default NULL,
  "sector" char(2) default NULL,
  "cct_sector" char(10) default NULL,
  "serreg" char(4) default NULL,
  "cct_serreg" char(10) default NULL,
  "depadmva" char(1) default NULL,
  "adm_des" char(60) default NULL,
  "depnormtva" char(2) default NULL,
  "nor_des" char(60) default NULL,
  "servicio" char(2) default NULL,
  "ser_des" char(60) default NULL,
  "sostenimie" char(2) default NULL,
  "sos_des" char(60) default NULL,
  PRIMARY KEY  ("row_id")
) /*!40100 DEFAULT CHARSET=utf8*/;



#
# Dumping data for table 'cie_cct'
#

LOCK TABLES "cie_cct" WRITE;
/*!40000 ALTER TABLE "cie_cct" DISABLE KEYS;*/
INSERT INTO "cie_cct" ("row_id", "cveinm", "clavecct", "nombrect", "domicilio", "nombrecol", "localidad", "nombreloc", "municipio", "nombremun", "codpost", "telefono", "fax", "turno", "zonaescola", "cct_zona", "sector", "cct_sector", "serreg", "cct_serreg", "depadmva", "adm_des", "depnormtva", "nor_des", "servicio", "ser_des", "sostenimie", "sos_des") VALUES
	(1,NULL,'26BBE1663M','BIBLIOTECA DON QUIJOTE DE LA MANCHA','COMPA','CIA MINERA LAMPAZOS','9800',NULL,'063',NULL,'84750','60022','0060022','1','003','','','','012','26ADG0012B','7',NULL,'NP',NULL,'02',NULL,'61',NULL);
/*!40000 ALTER TABLE "cie_cct" ENABLE KEYS;*/
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
