Z2C6E1GQ

1CREATE TABLE IF NOT EXISTS `acciones` (
2  `id` bigint(20) NOT NULL AUTO_INCREMENT,
3  `por` bigint(20) NOT NULL,
4  `fecha` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
5  `ip` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
6  `accion` text COLLATE utf8_spanish_ci NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
9CREATE TABLE IF NOT EXISTS `clientes` (
10  `id` bigint(20) NOT NULL AUTO_INCREMENT,
11  `secret_id` text COLLATE utf8_spanish_ci NOT NULL,
12  `nombre` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
13  `apellido` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
14  `telefono` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
15  `email` varchar(120) COLLATE utf8_spanish_ci NOT NULL,
16  `password` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
17  `ip` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
18  `eliminado` tinyint(2) NOT NULL DEFAULT '0',
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=2 ;
21CREATE TABLE IF NOT EXISTS `contacto` (
22  `id` bigint(20) NOT NULL AUTO_INCREMENT,
23  `leido` tinyint(2) NOT NULL DEFAULT '0',
24  `leido_por` bigint(20) NOT NULL DEFAULT '0',
25  `nombre` varchar(60) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
26  `email` varchar(120) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
27  `asunto` varchar(60) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
28  `mensaje` text CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
29  `fecha` varchar(60) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
30  `ip` varchar(60) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
31  `user_agent` varchar(250) CHARACTER SET utf32 COLLATE utf32_spanish_ci NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
34CREATE TABLE IF NOT EXISTS `sesiones` (
35  `id` bigint(20) NOT NULL AUTO_INCREMENT,
36  `id_secret` text COLLATE utf8_spanish_ci NOT NULL,
37  `id_cliente` bigint(20) NOT NULL,
38  `atendido_por` bigint(20) NOT NULL,
39  `reserva_para` bigint(20) NOT NULL DEFAULT '0',
40  `fecha_reserva` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
41  `fecha_sesion` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
42  `reserva_via` tinyint(2) NOT NULL DEFAULT '0',
43  `tipo_consulta` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
44  `atendido` tinyint(2) NOT NULL DEFAULT '0',
45  `cobrado` tinyint(2) NOT NULL DEFAULT '0',
46  `cliente_calificacion` tinyint(2) NOT NULL DEFAULT '0',
47  PRIMARY KEY (`id`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
49CREATE TABLE IF NOT EXISTS `user_admin` (
50  `id` bigint(20) NOT NULL AUTO_INCREMENT,
51  `user` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
52  `email` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
53  `nombre` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
54  `apellido` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
55  `password` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
56  `ip` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
57  `rango` tinyint(2) NOT NULL DEFAULT '1',
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;