6hE9YShe

1#
2# SQL Export
3# Created by Querious (201024)
4# Created: 2 april 2018 17:35:24 CEST
5# Encoding: Unicode (UTF-8)
6#
7
8
9SET @PREVIOUS_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS;
10SET FOREIGN_KEY_CHECKS = 0;
11
12
13DROP TABLE IF EXISTS `products`;
14DROP TABLE IF EXISTS `exclude_products`;
15DROP TABLE IF EXISTS `customergroups`;
16
17
18CREATE TABLE `customergroups` (
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  `name` varchar(128) DEFAULT NULL,
21  PRIMARY KEY (`id`)
22) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
23
24
25CREATE TABLE `exclude_products` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `products_id` int(11) DEFAULT '0',
28  `customergroups_id` int(11) DEFAULT '0',
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
31
32
33CREATE TABLE `products` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `name` varchar(128) DEFAULT NULL,
36  PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
38
39
40
41
42SET FOREIGN_KEY_CHECKS = @PREVIOUS_FOREIGN_KEY_CHECKS;
43
44
45SET @PREVIOUS_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS;
46SET FOREIGN_KEY_CHECKS = 0;
47
48
49LOCK TABLES `customergroups` WRITE;
50ALTER TABLE `customergroups` DISABLE KEYS;
51INSERT INTO `customergroups` (`id`, `name`) VALUES 
52	(1,'customers < 18'),
53	(2,'customers >= 18'),
54	(3,'some other customer group');
55ALTER TABLE `customergroups` ENABLE KEYS;
56UNLOCK TABLES;
57
58
59LOCK TABLES `exclude_products` WRITE;
60ALTER TABLE `exclude_products` DISABLE KEYS;
61INSERT INTO `exclude_products` (`id`, `products_id`, `customergroups_id`) VALUES 
62	(1,1,1),
63	(2,2,1),
64	(3,4,1),
65	(5,5,3),
66	(6,6,3);
67ALTER TABLE `exclude_products` ENABLE KEYS;
68UNLOCK TABLES;
69
70
71LOCK TABLES `products` WRITE;
72ALTER TABLE `products` DISABLE KEYS;
73INSERT INTO `products` (`id`, `name`) VALUES 
74	(1,'beer'),
75	(2,'wine'),
76	(3,'water'),
77	(4,'vodka'),
78	(5,'coke'),
79	(6,'root beer');
80ALTER TABLE `products` ENABLE KEYS;
81UNLOCK TABLES;
82
83
84
85
86SET FOREIGN_KEY_CHECKS = @PREVIOUS_FOREIGN_KEY_CHECKS;