· 5 years ago · Mar 21, 2020, 06:18 PM
1-- --------------------------------------------------------
2-- Host: 163.172.16.225
3-- Versión del servidor: 10.1.44-MariaDB-0+deb9u1 - Debian 9.11
4-- SO del servidor: debian-linux-gnu
5-- HeidiSQL Versión: 10.3.0.5771
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14DROP TABLE 'CAMISETAS';
15DROP TABLE 'POLOS MANGA LARGA';
16
17-- Volcando estructura para tabla guille.camisetas
18CREATE TABLE IF NOT EXISTS `camisetas` (
19 `id` int(11) NOT NULL AUTO_INCREMENT,
20 `color` varchar(11) COLLATE utf8mb4_spanish_ci NOT NULL,
21 `tamano` varchar(225) COLLATE utf8mb4_spanish_ci NOT NULL,
22 `diseno` varchar(225) COLLATE utf8mb4_spanish_ci NOT NULL,
23 `units` int(11) NOT NULL,
24 PRIMARY KEY (`id`)
25) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;
26
27-- Volcando datos para la tabla guille.camisetas: ~12 rows (aproximadamente)
28DELETE FROM `camisetas`;
29/*!40000 ALTER TABLE `camisetas` DISABLE KEYS */;
30INSERT INTO `camisetas` (`id`, `color`, `tamano`, `diseno`, `units`) VALUES
31 (1, 'GRIS', 'L', 'FLYING TIGERS', 0),
32 (2, 'GRIS', 'XL', 'FLYING TIGERS', 0),
33 (5, 'GRIS', 'M', 'FLYING TIGERS', 0),
34 (6, 'WHITE', 'L', 'MR HUMPIER DUCK', 0),
35 (7, 'WHITE', 'XL', 'MR HUMPIER DUCK', 0),
36 (8, 'WHITE', 'M', 'MR HUMPIER DUCK', 0),
37 (9, 'WHITE', 'L', 'RACE WINNERS', 0),
38 (10, 'WHITE', 'XL', 'RACE WINNERS', 0),
39 (11, 'WHITE', 'M', 'RACE WINNERS', 0),
40 (13, 'BLUE', 'M', 'LONG-SLEEVE', 0),
41 (16, 'BLUE', 'L', 'LONG-SLEEVE', 0),
42 (18, 'BLUE', 'XL', 'LONG-SLEEVE', 0);
43/*!40000 ALTER TABLE `camisetas` ENABLE KEYS */;
44
45-- Volcando estructura para tabla guille.pedidos
46CREATE TABLE IF NOT EXISTS `pedidos` (
47 `id` int(11) NOT NULL,
48 `producto` int(11) DEFAULT NULL,
49 `tipo` tinyint(3) DEFAULT NULL,
50 PRIMARY KEY (`id`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
52
53-- Volcando datos para la tabla guille.pedidos: ~0 rows (aproximadamente)
54DELETE FROM `pedidos`;
55/*!40000 ALTER TABLE `pedidos` DISABLE KEYS */;
56/*!40000 ALTER TABLE `pedidos` ENABLE KEYS */;
57
58-- Volcando estructura para tabla guille.polos_manga_larga
59CREATE TABLE IF NOT EXISTS `polos_manga_larga` (
60 `id` int(11) NOT NULL AUTO_INCREMENT,
61 `color` varchar(225) COLLATE utf8mb4_spanish_ci NOT NULL,
62 `tamano` varchar(225) COLLATE utf8mb4_spanish_ci NOT NULL,
63 `diseno` varchar(225) COLLATE utf8mb4_spanish_ci NOT NULL,
64 `units` int(11) NOT NULL,
65 PRIMARY KEY (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;
67
68-- Volcando datos para la tabla guille.polos_manga_larga: ~8 rows (aproximadamente)
69DELETE FROM `polos_manga_larga`;
70/*!40000 ALTER TABLE `polos_manga_larga` DISABLE KEYS */;
71INSERT INTO `polos_manga_larga` (`id`, `color`, `tamano`, `diseno`, `units`) VALUES
72 (1, 'GREEN', 'L', 'AGLET', 0),
73 (2, 'GREEN', 'XL', 'AGLET', 0),
74 (3, 'GREEN', 'L', 'POCKET', 0),
75 (4, 'GREEN ', 'XL', 'POCKET', 0),
76 (5, 'BLUE', 'L', 'AGLET', 0),
77 (6, 'BLUE', 'XL', 'AGLET', 0),
78 (7, 'BLUE', 'L', 'POCKET', 0),
79 (8, 'BLUE', 'XL', 'POCKET', 0);
80/*!40000 ALTER TABLE `polos_manga_larga` ENABLE KEYS */;
81
82/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
83/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
84/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;