1JCtsDXc

1CREATE TABLE IF NOT EXISTS `tb_cierre_dinamico` (
2  `id_cierre_dinamico` int(11) NOT NULL AUTO_INCREMENT,
3  `id_representante` varchar(50) NOT NULL,
4  `total` int(6) NOT NULL,
5  `total_anidados` varchar(6) NOT NULL,
6  `cod_ciclo` varchar(10) NOT NULL,
7  `cod_nivel3` varchar(8) NOT NULL,
8  `cod_nivel_geo` varchar(15) NOT NULL,
9  `tipo` int(2) NOT NULL,
10  `total_unicos` int(6) NOT NULL,
11  PRIMARY KEY (`id_cierre_dinamico`)
12) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
13
14CREATE TABLE IF NOT EXISTS `tb_cierre_contacto_dinamico` (
15  `id_cierrre_contacto_dinamico` int(11) NOT NULL AUTO_INCREMENT,
16  `id_contacto` varchar(10) NOT NULL,
17  `id_nodo` varchar(10) NOT NULL,
18  `tipo` int(6) NOT NULL,
19  `cod_ciclo` varchar(10) NOT NULL,
20  `n1` char(2) NOT NULL,
21  `n2` varchar(5) NOT NULL,
22  `n3` varchar(8) NOT NULL,
23  `n4` varchar(11) NOT NULL,
24  `id_representante` varchar(20) NOT NULL,
25  PRIMARY KEY (`id_cierrre_contacto_dinamico`)
26) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;