· 7 years ago · Feb 25, 2019, 04:20 PM
1 /*
2 Navicat Premium Data Transfer
3
4 Source Server : NovaContact
5 Source Server Type : MySQL
6 Source Server Version : 50723
7 Source Host : 191.102.35.101:3306
8 Source Schema : sigma
9
10 Target Server Type : MySQL
11 Target Server Version : 50723
12 File Encoding : 65001
13
14 Date: 25/02/2019 11:11:42
15 */
16
17 SET NAMES utf8mb4;
18 SET FOREIGN_KEY_CHECKS = 0;
19
20 -- ----------------------------
21 -- Table structure for costo
22 -- ----------------------------
23 DROP TABLE IF EXISTS `costo`;
24 CREATE TABLE `costo` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `costo` float(20, 6) NOT NULL,
27 `tipo_costo` int(11) NOT NULL,
28 `fecha` date NOT NULL,
29 `fecha_creacion` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
30 `fecha_modificacion` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
31 `status` int(11) NOT NULL DEFAULT 1,
32 PRIMARY KEY (`id`) USING BTREE
33 ) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
34
35 SET FOREIGN_KEY_CHECKS = 1;
36
37
38 /*
39 Navicat Premium Data Transfer
40
41 Source Server : NovaContact
42 Source Server Type : MySQL
43 Source Server Version : 50723
44 Source Host : 191.102.35.101:3306
45 Source Schema : sigma
46
47 Target Server Type : MySQL
48 Target Server Version : 50723
49 File Encoding : 65001
50
51 Date: 25/02/2019 11:11:53
52 */
53
54 SET NAMES utf8mb4;
55 SET FOREIGN_KEY_CHECKS = 0;
56
57 -- ----------------------------
58 -- Table structure for asignacion_costo
59 -- ----------------------------
60 DROP TABLE IF EXISTS `asignacion_costo`;
61 CREATE TABLE `asignacion_costo` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `id_asignacion` int(11) NOT NULL,
64 `id_costo` int(11) NOT NULL,
65 `fecha_creacion` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
66 `fecha_modificacion` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
67 `status` int(1) NOT NULL DEFAULT 1,
68 PRIMARY KEY (`id`) USING BTREE,
69 INDEX `fk1`(`id_asignacion`) USING BTREE,
70 INDEX `fk2`(`id_costo`) USING BTREE,
71 CONSTRAINT `fk1` FOREIGN KEY (`id_asignacion`) REFERENCES `asignacion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
72 CONSTRAINT `fk2` FOREIGN KEY (`id_costo`) REFERENCES `costo` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
73 ) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
74
75 SET FOREIGN_KEY_CHECKS = 1;
76
77 /*
78 Navicat Premium Data Transfer
79
80 Source Server : NovaContact
81 Source Server Type : MySQL
82 Source Server Version : 50723
83 Source Host : 191.102.35.101:3306
84 Source Schema : sigma
85
86 Target Server Type : MySQL
87 Target Server Version : 50723
88 File Encoding : 65001
89
90 Date: 25/02/2019 11:11:24
91 */
92
93 SET NAMES utf8mb4;
94 SET FOREIGN_KEY_CHECKS = 0;
95
96 -- ----------------------------
97 -- Table structure for tipo_costo
98 -- ----------------------------
99 DROP TABLE IF EXISTS `tipo_costo`;
100 CREATE TABLE `tipo_costo` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `descripcion` varchar(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
103 PRIMARY KEY (`id`) USING BTREE
104 ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
105
106 -- ----------------------------
107 -- Records of tipo_costo
108 -- ----------------------------
109 INSERT INTO `tipo_costo` VALUES (1, 'Llamada');
110 INSERT INTO `tipo_costo` VALUES (2, 'Google');
111 INSERT INTO `tipo_costo` VALUES (3, 'Movil');
112
113 SET FOREIGN_KEY_CHECKS = 1;