THgbUDyS

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `estados`
5-- ----------------------------
6DROP TABLE IF EXISTS `estados`;
7CREATE TABLE `estados` (
8  `idestado` int(11) NOT NULL,
9  `estado` varchar(70) NOT NULL,
10  PRIMARY KEY (`idestado`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13-- ----------------------------
14-- Records of estados
15-- ----------------------------
16INSERT INTO `estados` VALUES ('0', 'Jalisco');
17INSERT INTO `estados` VALUES ('1', 'Sinaloa');
18INSERT INTO `estados` VALUES ('2', 'Sonora');
19
20-- ----------------------------
21-- Table structure for `ciudades`
22-- ----------------------------
23DROP TABLE IF EXISTS `ciudades`;
24CREATE TABLE `ciudades` (
25  `idciudad` int(11) NOT NULL AUTO_INCREMENT,
26  `ciudad` varchar(70) NOT NULL,
27  `idestado` int(11) NOT NULL,
28  PRIMARY KEY (`idciudad`),
29  KEY `fkestado` (`idestado`),
30  CONSTRAINT `fkestado` FOREIGN KEY (`idestado`) REFERENCES `estados` (`idestado`)
31) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
32
33-- ----------------------------
34-- Records of ciudades
35-- ----------------------------
36INSERT INTO `ciudades` VALUES ('1', 'Los Mochis', '1');
37INSERT INTO `ciudades` VALUES ('2', 'Culiacan', '1');
38INSERT INTO `ciudades` VALUES ('3', 'Guadalajara', '0');
39INSERT INTO `ciudades` VALUES ('4', 'Hermosillo', '2');
40
41-- ----------------------------
42-- Table structure for `clientes`
43-- ----------------------------
44DROP TABLE IF EXISTS `clientes`;
45CREATE TABLE `clientes` (
46  `idclientes` int(11) NOT NULL AUTO_INCREMENT,
47  `nombre` varchar(50) NOT NULL,
48  `apellidomaterno` varchar(50) NOT NULL,
49  `apellidopaterno` varchar(50) NOT NULL DEFAULT '''''',
50  `email` varchar(70) NOT NULL,
51  `direccion` varchar(250) NOT NULL,
52  `idciudad` int(11) NOT NULL,
53  `idestado` int(11) NOT NULL,
54  `codigopostal` varchar(7) NOT NULL,
55  PRIMARY KEY (`idclientes`),
56  KEY `fk_clientesciudad` (`idciudad`),
57  KEY `fk_clientesestado` (`idestado`),
58  CONSTRAINT `fk_clientesestado` FOREIGN KEY (`idestado`) REFERENCES `estados` (`idestado`),
59  CONSTRAINT `fk_clientesciudad` FOREIGN KEY (`idciudad`) REFERENCES `ciudades` (`idciudad`)
60) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
61
62-- ----------------------------
63-- Records of clientes
64-- ----------------------------
65INSERT INTO `clientes` VALUES ('1', 'Jorge', 'Lopez', 'Ramirez', 'jlpr@hotmail.com', 'Calle conocida #123', '1', '1', '81200');
66INSERT INTO `clientes` VALUES ('2', 'Juan', 'Camargo', 'Salas', 'jcms@gmail.com', 'Calle delicias 1765', '2', '1', '72340');
67INSERT INTO `clientes` VALUES ('3', 'Jaime', 'Martinez', 'Lara', 'jaimemal@yahoo.com', 'Loma Plana sur #1432', '3', '0', '33456');
68INSERT INTO `clientes` VALUES ('4', 'Jesus', 'Lara', 'Nieblas', 'jlnb95@hotmail.com', 'Calle Pitaya #256', '4', '2', '93647');
69INSERT INTO `clientes` VALUES ('5', 'Miguel', 'Gastelum', 'Valdez', 'miguelgv@gmail.com', 'Calle Esmeralda # 1650', '1', '1', '81245');
70INSERT INTO `clientes` VALUES ('6', 'Daniel', 'Rodriguez', 'Campuzano', 'dnlrc@gmail.com', 'Calle Opalo #423', '2', '1', '72345');
71
72
73-- ----------------------------
74-- Table structure for `ordenes`
75-- ----------------------------
76DROP TABLE IF EXISTS `ordenes`;
77CREATE TABLE `ordenes` (
78  `idorden` int(11) NOT NULL AUTO_INCREMENT,
79  `fechaorden` date NOT NULL,
80  `total` float NOT NULL,
81  `idcliente` int(11) NOT NULL,
82  PRIMARY KEY (`idorden`),
83  KEY `fkorden_idcliente` (`idcliente`)
84) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
85
86-- ----------------------------
87-- Records of ordenes
88-- ----------------------------
89INSERT INTO `ordenes` VALUES ('1', '2016-10-23', '234.67', '1');
90INSERT INTO `ordenes` VALUES ('2', '2016-10-23', '78.5', '3');
91INSERT INTO `ordenes` VALUES ('3', '2016-10-25', '224', '2');
92INSERT INTO `ordenes` VALUES ('4', '2016-10-26', '65.5', '3');
93INSERT INTO `ordenes` VALUES ('5', '2016-10-27', '25.5', '5');
94INSERT INTO `ordenes` VALUES ('6', '2016-10-28', '14.4', '4');
95INSERT INTO `ordenes` VALUES ('8', '2016-10-29', '123.6', '7');
96INSERT INTO `ordenes` VALUES ('9', '2016-10-30', '45.5', '9');