· 8 years ago · Mar 06, 2018, 09:28 PM
1DROP TABLE IF EXISTS `clientes`.`accion`;
2CREATE TABLE `clientes`.`accion` (
3 `id` int(10) unsigned NOT NULL auto_increment,
4 `id_promo` int(10) unsigned NOT NULL default '0',
5 `nombre` varchar(45) NOT NULL,
6 `fecha` date default '0000-00-00',
7 PRIMARY KEY (`id`),
8 UNIQUE KEY `Nombre_unico` (`nombre`),
9 KEY `FK_promo_id` USING BTREE (`id_promo`),
10 CONSTRAINT `FK_promo_id` FOREIGN KEY (`id_promo`) REFERENCES `promo` (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1;
12
13DROP TABLE IF EXISTS `clientes`.`admin`;
14CREATE TABLE `clientes`.`admin` (
15 `id` int(10) unsigned NOT NULL auto_increment,
16 `nombre` varchar(45) NOT NULL,
17 `pass` varchar(45) NOT NULL,
18 `fecha` date NOT NULL,
19 PRIMARY KEY (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;
21
22DROP TABLE IF EXISTS `clientes`.`mailing`;
23CREATE TABLE `clientes`.`mailing` (
24 `id` int(10) unsigned NOT NULL auto_increment,
25 `id_accion` int(10) unsigned NOT NULL,
26 `nombre` varchar(45) NOT NULL,
27 `file` varchar(100) NOT NULL,
28 `fecha` date default NULL,
29 PRIMARY KEY (`id`),
30 UNIQUE KEY `unike_nombre` (`nombre`),
31 KEY `FK_id_accion` (`id_accion`),
32 CONSTRAINT `FK_id_accion` FOREIGN KEY (`id_accion`) REFERENCES `accion` (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35DROP TABLE IF EXISTS `clientes`.`mailing_imagen`;
36CREATE TABLE `clientes`.`mailing_imagen` (
37 `id` int(10) unsigned NOT NULL auto_increment,
38 `id_mailing` int(10) unsigned NOT NULL,
39 `nombre` varchar(45) default NULL,
40 `fecha` date default NULL,
41 PRIMARY KEY (`id`),
42 UNIQUE KEY `unike_id_mailing_nombre` (`id_mailing`,`nombre`),
43 CONSTRAINT `FK_ima_id_mailing` FOREIGN KEY (`id_mailing`) REFERENCES `mailing` (`id`)
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46DROP TABLE IF EXISTS `clientes`.`mailing_variable`;
47CREATE TABLE `clientes`.`mailing_variable` (
48 `id` int(10) unsigned NOT NULL auto_increment,
49 `id_mailing` int(10) unsigned NOT NULL,
50 `nombre` varchar(45) default NULL,
51 `fecha` date default NULL,
52 PRIMARY KEY (`id`),
53 UNIQUE KEY `unike_id_mailing_nombre` (`id_mailing`,`nombre`),
54 CONSTRAINT `FK_id_mailing` FOREIGN KEY (`id_mailing`) REFERENCES `mailing` (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57DROP TABLE IF EXISTS `clientes`.`origen`;
58CREATE TABLE `clientes`.`origen` (
59 `id` int(10) unsigned NOT NULL auto_increment,
60 `id_promo` int(10) unsigned NOT NULL default '0',
61 `nombre` varchar(45) NOT NULL,
62 `fecha` date default '0000-00-00',
63 PRIMARY KEY (`id`),
64 UNIQUE KEY `Nombre_unico` (`nombre`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67DROP TABLE IF EXISTS `clientes`.`participantes`;
68CREATE TABLE `clientes`.`participantes` (
69 `id` int(10) unsigned NOT NULL auto_increment,
70 `id_usuario` int(10) unsigned NOT NULL default '0',
71 `id_origen` int(10) unsigned NOT NULL default '0',
72 `id_accion` int(10) unsigned NOT NULL default '0',
73 `fecha` datetime default NULL,
74 PRIMARY KEY (`id`),
75 UNIQUE KEY `UNIQUE` (`id_usuario`,`id_accion`),
76 KEY `FK_aou_accion_id` (`id_accion`),
77 KEY `FK_aou_origen_id` (`id_origen`),
78 KEY `FK_aou_usuario_id` USING BTREE (`id_usuario`),
79 CONSTRAINT `FK_aou_accion_id` FOREIGN KEY (`id_accion`) REFERENCES `accion` (`id`),
80 CONSTRAINT `FK_aou_origen_id` FOREIGN KEY (`id_origen`) REFERENCES `origen` (`id`),
81 CONSTRAINT `FK_aou_usuario_id` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 58368 kB; (`id_user`) REFER `sal/usuarios`(`id`';
83
84DROP TABLE IF EXISTS `clientes`.`promo`;
85CREATE TABLE `clientes`.`promo` (
86 `id` int(10) unsigned NOT NULL auto_increment,
87 `nombre` varchar(45) NOT NULL,
88 `fecha` date default NULL,
89 `id_admin` int(10) unsigned default NULL,
90 PRIMARY KEY (`id`),
91 UNIQUE KEY `unike_nombre` (`nombre`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93
94DROP TABLE IF EXISTS `clientes`.`suscripcion`;
95CREATE TABLE `clientes`.`suscripcion` (
96 `id` int(10) unsigned NOT NULL auto_increment,
97 `nombre` varchar(64) NOT NULL default '',
98 `fecha` datetime NOT NULL default '0000-00-00 00:00:00',
99 PRIMARY KEY (`id`),
100 UNIQUE KEY `Nombre unico` (`nombre`)
101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102
103DROP TABLE IF EXISTS `clientes`.`suscripciones_usuarios`;
104CREATE TABLE `clientes`.`suscripciones_usuarios` (
105 `id` int(10) unsigned NOT NULL auto_increment,
106 `id_suscripcion` int(10) unsigned NOT NULL default '0',
107 `id_usuario` int(10) unsigned NOT NULL default '0',
108 `cod_md5` varchar(32) NOT NULL default '',
109 `fecha` datetime NOT NULL default '0000-00-00 00:00:00',
110 PRIMARY KEY (`id`),
111 UNIQUE KEY `UNIQUE` (`id_suscripcion`,`id_usuario`),
112 KEY `FK_su_suscripciones_id` (`id_suscripcion`),
113 KEY `FK_su_usuarios_id` USING BTREE (`id_usuario`),
114 CONSTRAINT `FK_su_suscripciones_id` FOREIGN KEY (`id_suscripcion`) REFERENCES `suscripcion` (`id`),
115 CONSTRAINT `FK_su_usuarios_id` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117
118DROP TABLE IF EXISTS `clientes`.`usuarios`;
119CREATE TABLE `clientes`.`usuarios` (
120 `id` int(10) unsigned NOT NULL auto_increment,
121 `email` varchar(255) NOT NULL default '',
122 `clave` varchar(32) NOT NULL default '',
123 `nombre` varchar(100) NOT NULL default '',
124 `apellido` varchar(100) NOT NULL default '',
125 `sexo` char(1) NOT NULL default '',
126 `nacimiento` date NOT NULL default '0000-00-00',
127 `dni` varchar(32) NOT NULL default '',
128 `telefonoArea` int(10) unsigned NOT NULL default '0',
129 `telefono` varchar(100) NOT NULL default '',
130 `celularArea` int(10) unsigned NOT NULL default '0',
131 `celular` varchar(100) NOT NULL default '',
132 `domicilio` varchar(200) NOT NULL default '',
133 `localidad` varchar(100) NOT NULL default '',
134 `provincia` varchar(100) NOT NULL default '',
135 `pais` varchar(128) NOT NULL default '',
136 `fecha` datetime NOT NULL default '0000-00-00 00:00:00',
137 PRIMARY KEY (`id`),
138 UNIQUE KEY `UNIQUE` (`email`)
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;