Kh1Wmptn

1# ************************************************************
2# Sequel Pro SQL dump
3# Versión 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.6.38)
9# Base de datos: c_guerrero_db1
10# Tiempo de Generación: 2019-08-03 19:18:02 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Volcado de tabla father_table
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `father_table`;
27
28CREATE TABLE `father_table` (
29  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30  `manifest_number` varchar(10) DEFAULT NULL,
31  `shipper` varchar(250) DEFAULT NULL,
32  `consignee` varchar(250) DEFAULT NULL,
33  `country_destination` varchar(250) DEFAULT NULL,
34  `airlines` varchar(250) DEFAULT NULL,
35  `manifest_date` date DEFAULT NULL,
36  `manifest_status` varchar(250) DEFAULT '',
37  `total_weight` float DEFAULT NULL,
38  `total_items` int(11) DEFAULT NULL,
39  `awb` varchar(200) DEFAULT NULL,
40  PRIMARY KEY (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8;
42
43
44
45# Volcado de tabla son_table
46# ------------------------------------------------------------
47
48DROP TABLE IF EXISTS `son_table`;
49
50CREATE TABLE `son_table` (
51  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
52  `father_id` int(11) unsigned DEFAULT NULL,
53  `dni` varchar(255) DEFAULT NULL,
54  `consignee` varchar(255) DEFAULT NULL,
55  `address` varchar(255) DEFAULT NULL,
56  PRIMARY KEY (`id`),
57  KEY `fk_father` (`father_id`),
58  CONSTRAINT `fk_father` FOREIGN KEY (`father_id`) REFERENCES `father_table` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61
62
63
64/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
65/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
66/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
67/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
68/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
69/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;