cWZ8Pvny

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: 05/03/2019 18:09:42
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for cliente
22-- ----------------------------
23DROP TABLE IF EXISTS `cliente`;
24CREATE TABLE `cliente`  (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `nombre` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
27  `observaciones` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
28  `status` int(11) NOT NULL DEFAULT 1,
29  `fecha_creacion` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
30  `fecha_modificacion` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
31  PRIMARY KEY (`id`) USING BTREE,
32  UNIQUE INDEX `nombreUnico`(`nombre`) USING BTREE COMMENT 'unico Nombre'
33) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
34
35-- ----------------------------
36-- Records of cliente
37-- ----------------------------
38INSERT INTO `cliente` VALUES (1, 'Hites', NULL, 1, '2019-03-05 19:23:58', '2019-03-05 19:27:58');
39INSERT INTO `cliente` VALUES (2, 'Callsouth', NULL, 1, '2019-03-05 19:24:34', '2019-03-05 19:27:58');
40INSERT INTO `cliente` VALUES (3, 'Cobranding', NULL, 1, '2019-03-05 19:24:44', '2019-03-05 19:27:58');
41INSERT INTO `cliente` VALUES (4, 'Colatam', NULL, 1, '2019-03-05 19:24:52', '2019-03-05 19:27:58');
42INSERT INTO `cliente` VALUES (5, 'Gesticom', NULL, 1, '2019-03-05 19:25:03', '2019-03-05 19:27:59');
43INSERT INTO `cliente` VALUES (6, 'Gys', NULL, 1, '2019-03-05 19:26:46', '2019-03-05 19:27:59');
44INSERT INTO `cliente` VALUES (7, 'MultiCob', NULL, 1, '2019-03-05 19:27:10', '2019-03-05 19:27:59');
45INSERT INTO `cliente` VALUES (8, 'Pruebas', NULL, 1, '2019-03-05 19:27:14', '2019-03-05 19:27:59');
46INSERT INTO `cliente` VALUES (9, 'Asercob', NULL, 1, '2019-03-05 19:27:39', '2019-03-05 19:27:59');
47INSERT INTO `cliente` VALUES (11, 'NovaContact', NULL, 1, '2019-03-05 19:27:50', '2019-03-05 19:27:59');
48
49SET FOREIGN_KEY_CHECKS = 1;
50
51
52ALTER TABLE `sigma`.`asignacion` 
53ADD COLUMN `id_cliente` int(11) NULL AFTER `nombre`,
54ADD CONSTRAINT `cliente_fk` FOREIGN KEY (`id_cliente`) REFERENCES `sigma`.`cliente` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;