4KxYhKUz

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
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for costo
22-- ----------------------------
23DROP TABLE IF EXISTS `costo`;
24CREATE 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
35SET 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
54SET NAMES utf8mb4;
55SET FOREIGN_KEY_CHECKS = 0;
56
57-- ----------------------------
58-- Table structure for asignacion_costo
59-- ----------------------------
60DROP TABLE IF EXISTS `asignacion_costo`;
61CREATE 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
75SET 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
93SET NAMES utf8mb4;
94SET FOREIGN_KEY_CHECKS = 0;
95
96-- ----------------------------
97-- Table structure for tipo_costo
98-- ----------------------------
99DROP TABLE IF EXISTS `tipo_costo`;
100CREATE 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-- ----------------------------
109INSERT INTO `tipo_costo` VALUES (1, 'Llamada');
110INSERT INTO `tipo_costo` VALUES (2, 'Google');
111INSERT INTO `tipo_costo` VALUES (3, 'Movil');
112
113SET FOREIGN_KEY_CHECKS = 1;