Q47224428 - SQL Dump file

/*

https://stackoverflow.com/questions/47224428/multiple-shared-lists-of-the-same-bean-redbean

Navicat MySQL Data Transfer

Source Server         : qtestdb
Source Server Version : 50539
Source Host           : localhost:3306
Source Database       : qtestdb

Target Server Type    : MYSQL
Target Server Version : 50539
File Encoding         : 65001

Date: 2017-11-16 12:51:21
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `image`
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `targets` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of image
-- ----------------------------
INSERT INTO `image` VALUES ('1', 'image1', 'product1');
INSERT INTO `image` VALUES ('2', 'image2', 'product2');
INSERT INTO `image` VALUES ('3', 'imageCommon', 'product1,product2');

-- ----------------------------
-- Table structure for `image_product`
-- ----------------------------
DROP TABLE IF EXISTS `image_product`;
CREATE TABLE `image_product` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `image_id` INT(11) UNSIGNED DEFAULT NULL,
  `product_id` INT(11) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_d73dae8015163caa678a9afae16e1d7825673979` (`image_id`,`product_id`),
  KEY `index_foreignkey_image_product_image` (`image_id`),
  KEY `index_foreignkey_image_product_product` (`product_id`),
  CONSTRAINT `c_fk_image_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `c_fk_image_product_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of image_product
-- ----------------------------
INSERT INTO `image_product` VALUES ('1', '1', '1');
INSERT INTO `image_product` VALUES ('2', '2', '2');
INSERT INTO `image_product` VALUES ('3', '3', '1');
INSERT INTO `image_product` VALUES ('4', '3', '2');

-- ----------------------------
-- Table structure for `manual`
-- ----------------------------
DROP TABLE IF EXISTS `manual`;
CREATE TABLE `manual` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `targets` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of manual
-- ----------------------------
INSERT INTO `manual` VALUES ('1', 'manual1', 'product1');
INSERT INTO `manual` VALUES ('2', 'manual2', 'product2');

-- ----------------------------
-- Table structure for `manual_product`
-- ----------------------------
DROP TABLE IF EXISTS `manual_product`;
CREATE TABLE `manual_product` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `manual_id` INT(11) UNSIGNED DEFAULT NULL,
  `product_id` INT(11) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_17a5897e32d5b615a4fff941fd78c5d91045e2c1` (`manual_id`,`product_id`),
  KEY `index_foreignkey_manual_product_manual` (`manual_id`),
  KEY `index_foreignkey_manual_product_product` (`product_id`),
  CONSTRAINT `c_fk_manual_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `c_fk_manual_product_manual_id` FOREIGN KEY (`manual_id`) REFERENCES `manual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of manual_product
-- ----------------------------
INSERT INTO `manual_product` VALUES ('1', '1', '1');
INSERT INTO `manual_product` VALUES ('2', '2', '2');

-- ----------------------------
-- Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES ('1', 'product1');
INSERT INTO `product` VALUES ('2', 'product2');