FCRpF3uF

1/*
2
3https://stackoverflow.com/questions/47224428/multiple-shared-lists-of-the-same-bean-redbean
4
5Navicat MySQL Data Transfer
6
7Source Server         : qtestdb
8Source Server Version : 50539
9Source Host           : localhost:3306
10Source Database       : qtestdb
11
12Target Server Type    : MYSQL
13Target Server Version : 50539
14File Encoding         : 65001
15
16Date: 2017-11-16 12:51:21
17*/
18
19SET FOREIGN_KEY_CHECKS=0;
20
21-- ----------------------------
22-- Table structure for `image`
23-- ----------------------------
24DROP TABLE IF EXISTS `image`;
25CREATE TABLE `image` (
26  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
27  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
28  `targets` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
31
32-- ----------------------------
33-- Records of image
34-- ----------------------------
35INSERT INTO `image` VALUES ('1', 'image1', 'product1');
36INSERT INTO `image` VALUES ('2', 'image2', 'product2');
37INSERT INTO `image` VALUES ('3', 'imageCommon', 'product1,product2');
38
39-- ----------------------------
40-- Table structure for `image_product`
41-- ----------------------------
42DROP TABLE IF EXISTS `image_product`;
43CREATE TABLE `image_product` (
44  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
45  `image_id` int(11) unsigned DEFAULT NULL,
46  `product_id` int(11) unsigned DEFAULT NULL,
47  PRIMARY KEY (`id`),
48  UNIQUE KEY `UQ_d73dae8015163caa678a9afae16e1d7825673979` (`image_id`,`product_id`),
49  KEY `index_foreignkey_image_product_image` (`image_id`),
50  KEY `index_foreignkey_image_product_product` (`product_id`),
51  CONSTRAINT `c_fk_image_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
52  CONSTRAINT `c_fk_image_product_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
53) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
54
55-- ----------------------------
56-- Records of image_product
57-- ----------------------------
58INSERT INTO `image_product` VALUES ('1', '1', '1');
59INSERT INTO `image_product` VALUES ('2', '2', '2');
60INSERT INTO `image_product` VALUES ('3', '3', '1');
61INSERT INTO `image_product` VALUES ('4', '3', '2');
62
63-- ----------------------------
64-- Table structure for `manual`
65-- ----------------------------
66DROP TABLE IF EXISTS `manual`;
67CREATE TABLE `manual` (
68  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
69  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
70  `targets` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
71  PRIMARY KEY (`id`)
72) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
73
74-- ----------------------------
75-- Records of manual
76-- ----------------------------
77INSERT INTO `manual` VALUES ('1', 'manual1', 'product1');
78INSERT INTO `manual` VALUES ('2', 'manual2', 'product2');
79
80-- ----------------------------
81-- Table structure for `manual_product`
82-- ----------------------------
83DROP TABLE IF EXISTS `manual_product`;
84CREATE TABLE `manual_product` (
85  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
86  `manual_id` int(11) unsigned DEFAULT NULL,
87  `product_id` int(11) unsigned DEFAULT NULL,
88  PRIMARY KEY (`id`),
89  UNIQUE KEY `UQ_17a5897e32d5b615a4fff941fd78c5d91045e2c1` (`manual_id`,`product_id`),
90  KEY `index_foreignkey_manual_product_manual` (`manual_id`),
91  KEY `index_foreignkey_manual_product_product` (`product_id`),
92  CONSTRAINT `c_fk_manual_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
93  CONSTRAINT `c_fk_manual_product_manual_id` FOREIGN KEY (`manual_id`) REFERENCES `manual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
94) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
95
96-- ----------------------------
97-- Records of manual_product
98-- ----------------------------
99INSERT INTO `manual_product` VALUES ('1', '1', '1');
100INSERT INTO `manual_product` VALUES ('2', '2', '2');
101
102-- ----------------------------
103-- Table structure for `product`
104-- ----------------------------
105DROP TABLE IF EXISTS `product`;
106CREATE TABLE `product` (
107  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
108  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
109  PRIMARY KEY (`id`)
110) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
111
112-- ----------------------------
113-- Records of product
114-- ----------------------------
115INSERT INTO `product` VALUES ('1', 'product1');
116INSERT INTO `product` VALUES ('2', 'product2');