# SQL Manager 2007 for MySQL 4.0.0.3
# ---------------------------------------
# Host : localhost
# Port : 3306
# Database : tennis_db
SET FOREIGN_KEY_CHECKS=0;
DROP DATABASE IF EXISTS `tennis_db`;
CREATE DATABASE `tennis_db`
CHARACTER SET 'latin1'
COLLATE 'latin1_swedish_ci';
USE `tennis_db`;
#
# Structure for the `accesorio` table :
#
CREATE TABLE `accesorio` (
`IdAccesorio` int(5) NOT NULL auto_increment,
`IdTipoServicio` decimal(3,0) default NULL,
`Descripcion` varchar(30) default NULL,
`Cantidad` int(5) default NULL,
`Marca` varchar(20) default NULL,
PRIMARY KEY (`IdAccesorio`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tiposervicio` table :
#
CREATE TABLE `tiposervicio` (
`IdTipoServicio` int(3) NOT NULL,
`Descripcion` varchar(20) default NULL,
PRIMARY KEY (`IdTipoServicio`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `instalacion` table :
#
CREATE TABLE `instalacion` (
`IdInstalacion` int(5) NOT NULL auto_increment,
`Descripcion` varchar(20) default NULL,
`IdTipoServicio` int(3) default NULL,
PRIMARY KEY (`IdInstalacion`),
KEY `IdTipoServicio` (`IdTipoServicio`),
CONSTRAINT `instalacion_ibfk_1` FOREIGN KEY (`IdTipoServicio`) REFERENCES `tiposervicio` (`IdTipoServicio`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `departamento` table :
#
CREATE TABLE `departamento` (
`IdDepartamento` int(8) NOT NULL,
`Descripcion` varchar(30) default NULL,
PRIMARY KEY (`IdDepartamento`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `provincia` table :
#
CREATE TABLE `provincia` (
`IdProvincia` int(8) NOT NULL,
`Descripcion` varchar(30) default NULL,
`IdDepartamento` int(8) default NULL,
PRIMARY KEY (`IdProvincia`),
KEY `IdDepartamento` (`IdDepartamento`),
CONSTRAINT `provincia_ibfk_1` FOREIGN KEY (`IdDepartamento`) REFERENCES `departamento` (`IdDepartamento`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `distrito` table :
#
CREATE TABLE `distrito` (
`IdDistrito` int(8) NOT NULL,
`Descripcion` varchar(30) default NULL,
`IdProvincia` int(8) default NULL,
PRIMARY KEY (`IdDistrito`),
KEY `IdProvincia` (`IdProvincia`),
CONSTRAINT `distrito_ibfk_1` FOREIGN KEY (`IdProvincia`) REFERENCES `provincia` (`IdProvincia`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tipopersona` table :
#
CREATE TABLE `tipopersona` (
`IdTipoPersona` int(2) NOT NULL,
`Descripcion` varchar(20) default NULL,
PRIMARY KEY (`IdTipoPersona`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tipoestado` table :
#
CREATE TABLE `tipoestado` (
`IdTipoEstado` int(1) NOT NULL,
`Descripcion` char(18) default NULL,
PRIMARY KEY (`IdTipoEstado`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tipoestadocivil` table :
#
CREATE TABLE `tipoestadocivil` (
`IdEstadoCivil` int(1) NOT NULL,
`Descripcion` char(18) default NULL,
PRIMARY KEY (`IdEstadoCivil`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tipodocumento` table :
#
CREATE TABLE `tipodocumento` (
`IdTipoDocumento` int(1) NOT NULL,
`Descripcion` varchar(10) default NULL,
PRIMARY KEY (`IdTipoDocumento`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `persona` table :
#
CREATE TABLE `persona` (
`IdPersona` int(8) NOT NULL auto_increment,
`Nombre` varchar(20) default NULL,
`ApPaterno` varchar(20) default NULL,
`ApMaterno` varchar(20) default NULL,
`Telefono` char(8) default NULL,
`Direccion` varchar(50) default NULL,
`Celular` char(8) default NULL,
`Nacionalidad` varchar(20) default NULL,
`Email` varchar(40) default NULL,
`IdDistrito` int(8) default NULL,
`IdTipoDocumento` int(1) default NULL,
`IdEstadoCivil` int(1) default NULL,
`FechaNacimiento` date default NULL,
`IdTipoEstado` int(1) default NULL,
`NumeroDocumentoID` char(12) default NULL,
`Cuenta` char(8) default NULL,
`Contrasenia` char(10) default NULL,
`IdTipoPersona` int(2) default NULL,
PRIMARY KEY (`IdPersona`),
KEY `IdTipoPersona` (`IdTipoPersona`),
KEY `IdTipoEstado` (`IdTipoEstado`),
KEY `IdEstadoCivil` (`IdEstadoCivil`),
KEY `IdTipoDocumento` (`IdTipoDocumento`),
KEY `IdDistrito` (`IdDistrito`),
CONSTRAINT `persona_ibfk_5` FOREIGN KEY (`IdDistrito`) REFERENCES `distrito` (`IdDistrito`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `persona_ibfk_1` FOREIGN KEY (`IdTipoPersona`) REFERENCES `tipopersona` (`IdTipoPersona`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `persona_ibfk_2` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `persona_ibfk_3` FOREIGN KEY (`IdEstadoCivil`) REFERENCES `tipoestadocivil` (`IdEstadoCivil`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `persona_ibfk_4` FOREIGN KEY (`IdTipoDocumento`) REFERENCES `tipodocumento` (`IdTipoDocumento`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `empleado` table :
#
CREATE TABLE `empleado` (
`IdEmpleado` int(8) NOT NULL auto_increment,
`IdPersona` int(8) default NULL,
PRIMARY KEY (`IdEmpleado`),
KEY `IdPersona` (`IdPersona`),
CONSTRAINT `empleado_ibfk_1` FOREIGN KEY (`IdPersona`) REFERENCES `persona` (`IdPersona`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `curso` table :
#
CREATE TABLE `curso` (
`IdCurso` int(8) NOT NULL auto_increment,
`IdTipoServicio` decimal(3,0) default NULL,
`Nombre` varchar(20) default NULL,
`IdTipoEstado` int(1) default NULL,
`FechaIni` date default NULL,
`FechaFin` date default NULL,
`Costo` double default NULL,
PRIMARY KEY (`IdCurso`),
KEY `IdTipoEstado` (`IdTipoEstado`),
CONSTRAINT `curso_ibfk_1` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `horario` table :
#
CREATE TABLE `horario` (
`IdHorario` int(8) NOT NULL auto_increment,
`NumVancantes` char(18) default NULL,
`IdInstalacion` int(5) default NULL,
`IdCurso` int(8) default NULL,
`IdEmpleado` int(8) default NULL,
PRIMARY KEY (`IdHorario`),
KEY `IdEmpleado` (`IdEmpleado`),
KEY `IdCurso` (`IdCurso`),
KEY `IdInstalacion` (`IdInstalacion`),
CONSTRAINT `horario_ibfk_3` FOREIGN KEY (`IdInstalacion`) REFERENCES `instalacion` (`IdInstalacion`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `horario_ibfk_1` FOREIGN KEY (`IdEmpleado`) REFERENCES `empleado` (`IdEmpleado`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `horario_ibfk_2` FOREIGN KEY (`IdCurso`) REFERENCES `curso` (`IdCurso`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `tipoparentesco` table :
#
CREATE TABLE `tipoparentesco` (
`IdTipoParentesco` int(2) NOT NULL,
`Descripcion` varchar(20) default NULL,
PRIMARY KEY (`IdTipoParentesco`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `socio` table :
#
CREATE TABLE `socio` (
`IdSocio` int(8) NOT NULL auto_increment,
`NombreEmpresa` varchar(40) default NULL,
`DirecEmpresa` varchar(50) default NULL,
`TelEmpresa` char(8) default NULL,
`IdPersona` int(8) default NULL,
`IdTitular` int(8) default NULL,
`IdTipoParentesco` int(2) default NULL,
PRIMARY KEY (`IdSocio`),
KEY `IdTipoParentesco` (`IdTipoParentesco`),
KEY `IdPersona` (`IdPersona`),
CONSTRAINT `socio_ibfk_2` FOREIGN KEY (`IdPersona`) REFERENCES `persona` (`IdPersona`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `socio_ibfk_1` FOREIGN KEY (`IdTipoParentesco`) REFERENCES `tipoparentesco` (`IdTipoParentesco`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `socio_x_curso` table :
#
CREATE TABLE `socio_x_curso` (
`IdHorario` int(8) NOT NULL,
`IdSocio` int(8) NOT NULL,
PRIMARY KEY (`IdHorario`,`IdSocio`),
KEY `IdSocio` (`IdSocio`),
CONSTRAINT `socio_x_curso_ibfk_2` FOREIGN KEY (`IdHorario`) REFERENCES `horario` (`IdHorario`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `socio_x_curso_ibfk_1` FOREIGN KEY (`IdSocio`) REFERENCES `socio` (`IdSocio`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `accesorio_x_curso` table :
#
CREATE TABLE `accesorio_x_curso` (
`IdHorario` int(8) NOT NULL,
`IdAccesorio` int(5) NOT NULL,
`Cantidad` int(11) default NULL,
`IdSocio` int(8) NOT NULL,
PRIMARY KEY (`IdHorario`,`IdAccesorio`,`IdSocio`),
KEY `IdAccesorio` (`IdAccesorio`),
KEY `IdHorario` (`IdHorario`,`IdSocio`),
CONSTRAINT `accesorio_x_curso_ibfk_2` FOREIGN KEY (`IdHorario`, `IdSocio`) REFERENCES `socio_x_curso` (`IdHorario`, `IdSocio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `accesorio_x_curso_ibfk_1` FOREIGN KEY (`IdAccesorio`) REFERENCES `accesorio` (`IdAccesorio`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `reserva` table :
#
CREATE TABLE `reserva` (
`IdReserva` int(8) NOT NULL auto_increment,
`IdInstalacion` int(5) default NULL,
`Fecha` date default NULL,
`IdTipoEstado` int(1) default NULL,
`IdSocio` int(8) default NULL,
`HoraIni` time default NULL,
`HoraFin` time default NULL,
PRIMARY KEY (`IdReserva`),
KEY `IdTipoEstado` (`IdTipoEstado`),
KEY `IdInstalacion` (`IdInstalacion`),
KEY `IdSocio` (`IdSocio`),
CONSTRAINT `reserva_ibfk_3` FOREIGN KEY (`IdSocio`) REFERENCES `socio` (`IdSocio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `reserva_ibfk_1` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `reserva_ibfk_2` FOREIGN KEY (`IdInstalacion`) REFERENCES `instalacion` (`IdInstalacion`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `accesorio_x_reserva` table :
#
CREATE TABLE `accesorio_x_reserva` (
`IdReserva` int(8) NOT NULL,
`IdAccesorio` int(5) NOT NULL,
`Cantidad` int(11) default NULL,
PRIMARY KEY (`IdReserva`,`IdAccesorio`),
KEY `IdAccesorio` (`IdAccesorio`),
CONSTRAINT `accesorio_x_reserva_ibfk_2` FOREIGN KEY (`IdReserva`) REFERENCES `reserva` (`IdReserva`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `accesorio_x_reserva_ibfk_1` FOREIGN KEY (`IdAccesorio`) REFERENCES `accesorio` (`IdAccesorio`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `cuentasocio` table :
#
CREATE TABLE `cuentasocio` (
`IdCuenta` int(8) NOT NULL auto_increment,
`IdTipoEstado` int(1) default NULL,
`IdSocio` int(8) default NULL,
PRIMARY KEY (`IdCuenta`),
KEY `IdTipoEstado` (`IdTipoEstado`),
KEY `IdSocio` (`IdSocio`),
CONSTRAINT `cuentasocio_ibfk_2` FOREIGN KEY (`IdSocio`) REFERENCES `socio` (`IdSocio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `cuentasocio_ibfk_1` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `detallecuenta` table :
#
CREATE TABLE `detallecuenta` (
`IdDetalle` int(8) NOT NULL auto_increment,
`IdTipoEstado` int(1) default NULL,
`Detalle` varchar(50) default NULL,
`IdCuenta` int(8) default NULL,
`Monto` double default NULL,
`FechaEmision` date default NULL,
`FechaVcto` date default NULL,
PRIMARY KEY (`IdDetalle`),
KEY `IdCuenta` (`IdCuenta`),
CONSTRAINT `detallecuenta_ibfk_2` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `detallecuenta_ibfk_1` FOREIGN KEY (`IdCuenta`) REFERENCES `cuentasocio` (`IdCuenta`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `diahorario` table :
#
CREATE TABLE `diahorario` (
`Dia` varchar(10) default NULL,
`HoraIni` time default NULL,
`IdDiaHorario` int(8) NOT NULL,
`HoraFin` time default NULL,
`IdHorario` int(8) default NULL,
PRIMARY KEY (`IdDiaHorario`),
KEY `IdHorario` (`IdHorario`),
CONSTRAINT `diahorario_ibfk_1` FOREIGN KEY (`IdHorario`) REFERENCES `horario` (`IdHorario`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `logadministrativo` table :
#
CREATE TABLE `logadministrativo` (
`IdLogAdmin` int(8) NOT NULL auto_increment,
`Descripcion` varchar(100) default NULL,
`Fecha` date default NULL,
`IdPersona` int(8) default NULL,
PRIMARY KEY (`IdLogAdmin`),
KEY `IdPersona` (`IdPersona`),
CONSTRAINT `logadministrativo_ibfk_1` FOREIGN KEY (`IdPersona`) REFERENCES `persona` (`IdPersona`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `solicitud` table :
#
CREATE TABLE `solicitud` (
`IdSolicitud` int(1) NOT NULL auto_increment,
`IdTipoEstado` int(1) default NULL,
`IdSocio` int(8) default NULL,
PRIMARY KEY (`IdSolicitud`),
KEY `IdTipoEstado` (`IdTipoEstado`),
KEY `IdSocio` (`IdSocio`),
CONSTRAINT `solicitud_ibfk_2` FOREIGN KEY (`IdSocio`) REFERENCES `socio` (`IdSocio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `solicitud_ibfk_1` FOREIGN KEY (`IdTipoEstado`) REFERENCES `tipoestado` (`IdTipoEstado`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Data for the `accesorio` table (LIMIT 0,500)
#
INSERT INTO `accesorio` (`IdAccesorio`, `IdTipoServicio`, `Descripcion`, `Cantidad`, `Marca`) VALUES
(1,1,'Raquetas',20,'Head'),
(2,1,'Pelotas',100,'Penn'),
(3,2,'Paletas',20,'Wilson'),
(4,2,'Raquetas',100,'Babolat'),
(5,3,'Paletas',20,'Dunlop'),
(6,3,'Pelotas',100,'Head'),
(7,4,'Lentes',50,'Speedo'),
(8,4,'Gorras de goma',50,'Speedo'),
(9,5,'Fajas de cuero',30,'BH Fitness'),
(10,5,'Caja de Step',50,'BH Fitness');
COMMIT;
#
# Data for the `tiposervicio` table (LIMIT 0,500)
#
INSERT INTO `tiposervicio` (`IdTipoServicio`, `Descripcion`) VALUES
(1,'Tennis'),
(2,'Fronton'),
(3,'Tenis de Mesa'),
(4,'Natacion'),
(5,'Gimnasio');
COMMIT;
#
# Data for the `instalacion` table (LIMIT 0,500)
#
INSERT INTO `instalacion` (`IdInstalacion`, `Descripcion`, `IdTipoServicio`) VALUES
(1,'Cancha Arcilla 1',1),
(2,'Cancha Arcilla 2',1),
(3,'Cancha Arcilla 3',1),
(4,'Cancha Arcilla 4',1),
(5,'Cancha Arcilla 5',1),
(6,'Cancha Sintetica 1',1),
(7,'Cancha Sintetica 2',1),
(8,'Cancha Sintetica 3',1),
(9,'Cancha Sintetica 4',1),
(10,'Cancha Sintetica 5',1),
(11,'Cancha 1',2),
(12,'Cancha 2',2),
(13,'Cancha 3',2),
(14,'Cancha 4',2),
(15,'Cancha 5',2),
(16,'Cancha 6',2),
(17,'Tablero 1',3),
(18,'Tablero 2',3),
(19,'Tablero 3',3),
(20,'Tablero 4',3),
(21,'Tablero 5',3),
(22,'Tablero 6',3),
(23,'Piscina 1',4),
(24,'Piscina 2',4),
(25,'Piscina 3',4),
(26,'Piscina 4',4),
(27,'Piscina 5',4),
(28,'Gimnasio 1',5),
(29,'Gimnasio 2',5),
(30,'Gimnasio 3',5);
COMMIT;
#
# Data for the `departamento` table (LIMIT 0,500)
#
INSERT INTO `departamento` (`IdDepartamento`, `Descripcion`) VALUES
(1,'AMAZONAS'),
(2,'ANCASH'),
(3,'APURIMAC'),
(4,'AREQUIPA'),
(5,'AYACUCHO'),
(6,'CAJAMARCA'),
(7,'CUSCO'),
(8,'HUANCAVELICA'),
(9,'HUANUCO'),
(10,'ICA'),
(11,'JUNIN'),
(12,'LA LIBERTAD'),
(13,'LAMBAYEQUE'),
(14,'LIMA'),
(15,'LORETO'),
(16,'MADRE DE DIOS'),
(17,'MOQUEGUA'),
(18,'PASCO'),
(19,'PIURA'),
(20,'PUNO'),
(21,'SAN MARTIN'),
(22,'TACNA'),
(23,'TUMBES'),
(24,'UCAYALI');
COMMIT;
#
# Data for the `provincia` table (LIMIT 0,500)
#
INSERT INTO `provincia` (`IdProvincia`, `Descripcion`, `IdDepartamento`) VALUES
(135,'LIMA',14);
COMMIT;
#
# Data for the `distrito` table (LIMIT 0,500)
#
INSERT INTO `distrito` (`IdDistrito`, `Descripcion`, `IdProvincia`) VALUES
(1,'CERCADO DE LIMA',135),
(2,'ANCON',135),
(3,'ATE',135),
(4,'BARRANCO',135),
(5,'BREŅA',135),
(6,'CARABAYLLO',135),
(7,'CHACLACAYO',135),
(8,'CHORRILLOS',135),
(9,'CIENEGUILLA',135),
(10,'COMAS',135),
(11,'EL AGUSTINO',135),
(12,'INDEPENDENCIA',135),
(13,'JESUS MARIA',135),
(14,'LA MOLINA',135),
(15,'LA VICTORIA',135),
(16,'LINCE',135),
(17,'LOS OLIVOS',135),
(18,'LURIGANCHO - CHOSICA',135),
(19,'LURIN',135),
(20,'MAGDALENA DEL MAR',135),
(21,'MIRAFLORES',135),
(22,'PACHACAMAC',135),
(23,'PUCUSANA',135),
(24,'PUEBLO LIBRE',135),
(25,'PUENTE PIEDRA',135),
(26,'PUNTA HERMOSA',135),
(27,'PUNTA NEGRA',135),
(28,'RIMAC',135),
(29,'SAN BARTOLO',135),
(30,'SAM BORJA',135),
(31,'SAN ISIDRO',135),
(32,'SAN JUAN DE LURIGANCHO',135),
(33,'SAN JUAN DE MIRAFLORES',135),
(34,'SAN LUIS',135),
(35,'SAN MARTIN DE PORRES',135),
(36,'SAN MIGUEL',135),
(37,'SANTA ANITA',135),
(38,'SANTA MARIA DEL MAR',135),
(39,'SANTA ROSA',135),
(40,'SANTIAGO DE SURCO',135),
(41,'SURQUILLO',135),
(42,'VILLA EL SALVADOR',135),
(43,'VILLA MARIA DEL TRIUNFO',135);
COMMIT;
#
# Data for the `tipopersona` table (LIMIT 0,500)
#
INSERT INTO `tipopersona` (`IdTipoPersona`, `Descripcion`) VALUES
(1,'SOCIO'),
(2,'ADMINISTRADOR'),
(3,'PERSONAL');
COMMIT;
#
# Data for the `tipoestado` table (LIMIT 0,500)
#
INSERT INTO `tipoestado` (`IdTipoEstado`, `Descripcion`) VALUES
(1,'ACTIVO'),
(2,'PENDIENTE'),
(3,'MOROSO'),
(4,'SUSPENDIDO'),
(5,'DE BAJA'),
(6,'CANCELADO');
COMMIT;
#
# Data for the `tipoestadocivil` table (LIMIT 0,500)
#
INSERT INTO `tipoestadocivil` (`IdEstadoCivil`, `Descripcion`) VALUES
(1,'SOLTERO'),
(2,'CASADO'),
(3,'VIUDO'),
(4,'DIVORCIADO');
COMMIT;
#
# Data for the `tipodocumento` table (LIMIT 0,500)
#
INSERT INTO `tipodocumento` (`IdTipoDocumento`, `Descripcion`) VALUES
(1,'DNI'),
(2,'PASAPORTE');
COMMIT;
#
# Data for the `persona` table (LIMIT 0,500)
#
INSERT INTO `persona` (`IdPersona`, `Nombre`, `ApPaterno`, `ApMaterno`, `Telefono`, `Direccion`, `Celular`, `Nacionalidad`, `Email`, `IdDistrito`, `IdTipoDocumento`, `IdEstadoCivil`, `FechaNacimiento`, `IdTipoEstado`, `NumeroDocumentoID`, `Cuenta`, `Contrasenia`, `IdTipoPersona`) VALUES
(1,'JULIO CESAR','POVIS','MATOS','4501669','CALLE ESTEBAN TUERTEN 228','99155514','PERUANA','jpovis@hotmail.com',33,1,1,'1981-09-17',1,'41148381','JULIO','POVIS',1);
COMMIT;
#
# Data for the `tipoparentesco` table (LIMIT 0,500)
#
INSERT INTO `tipoparentesco` (`IdTipoParentesco`, `Descripcion`) VALUES
(1,'TITULAR'),
(2,'CONYUGUE'),
(3,'HIJO(A)'),
(4,'FAMILIAR'),
(5,'AMIGO(A)');
COMMIT;