sQXZJgEp

1DROP TABLE IF EXISTS `domicilio`;
2CREATE TABLE `domicilio` (
3  `idDomicilio` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4  `calle` varchar(100) DEFAULT NULL,
5  `numeroExterior` varchar(4) DEFAULT NULL,
6  `numeroInterior` varchar(4) DEFAULT NULL,
7  `colonia` varchar(30) DEFAULT NULL,
8  `localidad` varchar(20) DEFAULT NULL,
9  `municipio` varchar(20) DEFAULT NULL,
10  `estado` varchar(20) DEFAULT NULL,
11  `pais` varchar(20) DEFAULT NULL,
12  `cp` char(6) DEFAULT NULL,
13  `entreCalles` varchar(40) DEFAULT NULL,
14  `referencia` text,
15  `idCliente` bigint(20) NOT NULL,
16  PRIMARY KEY (`idDomicilio`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19
20DROP TABLE IF EXISTS `clientes`;
21CREATE TABLE `clientes` (
22  `idCliente` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
23  `fechaAlta` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
24  `fechaModificacion` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
25  `nombres` varchar(60) NOT NULL,
26  `apellidoPaterno` varchar(60) NOT NULL,
27  `apellidoMaterno` varchar(60) DEFAULT NULL,
28  `fechaNacimiento` date NOT NULL,
29  `rfc` char(13) DEFAULT NULL,
30  `tratamiento` char(6) NOT NULL,
31  `estadoCivil` char(10) NOT NULL,
32  `sexo` char(1) NOT NULL,
33  PRIMARY KEY (`idCliente`)
34) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;