Sample data for cakephp/cakephp#12752

sample-data.sql

/*
SQLyog Ultimate v12.15 (64 bit)
MySQL - 5.7.24-0ubuntu0.18.04.1 : Database - pim_cake
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`pim_cake` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `pim_cake`;

/*Table structure for table `attribute_categories` */

CREATE TABLE `attribute_categories` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_bin NOT NULL,
  `super` int(11) DEFAULT NULL,
  PRIMARY KEY (`unique_id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `attribute_categories_super_idx` (`super`),
  CONSTRAINT `attribute_categories_super` FOREIGN KEY (`super`) REFERENCES `attribute_categories` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `attribute_categories` */

insert  into `attribute_categories`(`unique_id`,`name`,`super`) values 

(1,'Aussehen',12),

(2,'Hardware',NULL),

(3,'Energie',2),

(5,'Schnittstelle',2),

(6,'Software',NULL),

(7,'Zubehör',NULL),

(8,'Dimension',1),

(9,'WLAN',2),

(10,'Stromversorgung',2),

(11,'Protokoll',6),

(12,'Allgemein',NULL),

(13,'Management',6);

/*Table structure for table `attributes` */

CREATE TABLE `attributes` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(45) COLLATE utf8_bin NOT NULL,
  `allow_value` tinyint(1) NOT NULL DEFAULT '0',
  `allow_amount` tinyint(1) NOT NULL DEFAULT '0',
  `unit` varchar(45) COLLATE utf8_bin DEFAULT NULL,
  `data_type` enum('integer','double','string') COLLATE utf8_bin DEFAULT NULL,
  `filter_appearance` char(1) COLLATE utf8_bin DEFAULT '0',
  PRIMARY KEY (`unique_id`),
  KEY `attributes_category_idx` (`category_id`),
  KEY `attribute_parent_idx` (`parent_id`),
  CONSTRAINT `attribute_parent` FOREIGN KEY (`parent_id`) REFERENCES `attributes` (`unique_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `attributes` */

insert  into `attributes`(`unique_id`,`category_id`,`parent_id`,`name`,`allow_value`,`allow_amount`,`unit`,`data_type`,`filter_appearance`) values 

(3,8,NULL,'Tiefe',1,0,'cm','double','0'),

(4,1,NULL,'Farbe',1,0,'','string','0'),

(5,5,NULL,'Ethernet Port',1,1,'Mbit','integer','3'),

(8,5,NULL,'SFP Port (1G)',0,1,'Mbit','integer','0'),

(9,5,NULL,'SFP+ Port',0,1,'Mbit','integer','0'),

(10,5,NULL,'Combo Port (GE/SFP)',0,1,'','','0'),

(11,9,NULL,'IEEE 802.11a',0,0,'','','0'),

(12,9,NULL,'IEEE 802.11b',0,0,'','','0'),

(13,9,NULL,'IEEE 802.11g',0,0,'','','0'),

(23,9,NULL,'IEEE 802.11n',0,0,NULL,'','0'),

(24,6,NULL,'IEEE 802.1x Access Control',0,0,'','','0'),

(25,6,NULL,'TACACS+',0,0,'','','0'),

(26,6,NULL,'VLAN',0,0,NULL,'','0'),

(27,6,NULL,'LACP',0,0,NULL,'','0'),

(28,6,NULL,'QoS',0,0,NULL,'','0'),

(29,6,NULL,'SSL/SSH',0,0,NULL,'','0'),

(30,12,NULL,'SNMPv3',0,0,NULL,'','0'),

(34,13,NULL,'Management über LMC',0,0,'','','0'),

(35,12,NULL,'Einsatzzweck',1,0,'','','0'),

(36,5,NULL,'Maximaler Durchsatz',1,0,'GBit/s','integer','0'),

(37,12,NULL,'Herstellergarantie',1,0,'Jahre','integer','0'),

(38,11,NULL,'IPv6 & IPv4 Dual Stack',0,0,NULL,'','0'),

(167,9,12,'Frequenzband',1,1,'ghz','double','0'),

(168,12,12,'Durchsatz',1,0,'Mbit','integer','0'),

(169,9,11,'Frequenzband',1,1,'Ghz','double','0'),

(170,5,11,'Durchsatz',1,1,'Mbit','','0'),

(172,6,NULL,'VLAN, LACP, QoS, SSL/SSH, SNMPv3',0,0,'','','0'),

(174,3,NULL,'root',0,0,'','','0'),

(175,8,174,'1. Kind',1,1,'Jahre','integer','0'),

(176,1,175,'kind kind',1,1,'','','0'),

(177,2,174,'2. Kind',1,1,'Kbit/s','double','0'),

(181,10,5,'PoE',0,0,'','','0'),

(182,8,NULL,'Breite',1,0,'cm','double','0'),

(183,8,NULL,'Länge',1,0,'cm','double','0'),

(184,10,5,'PoE+',0,0,'','','0'),

(186,12,177,'kind des anderen kindes',0,0,'','','0'),

(188,10,184,'Spannung',1,0,'Volt','integer','0'),

(195,12,NULL,'Integrierte Antenne',0,1,NULL,NULL,'0'),

(197,3,174,'3. Kind',1,1,'','','0'),

(198,5,197,'adoptiv kind',1,1,'Hi','double','0'),

(199,5,NULL,'USB Port',1,1,'Mbit','integer','0'),

(200,9,NULL,'WLAN Funkmodul',0,0,'','','0'),

(202,9,200,'2,4 Ghz',0,0,'','','0'),

(203,9,200,'5 Ghz',0,0,'','','0'),

(204,11,NULL,'WAN',0,0,NULL,NULL,'0'),

(205,11,204,'Ethernet',0,0,'','','0'),

(206,11,204,'VDSL',0,0,'','','0'),

(207,11,204,'ADSL',0,0,'','','0'),

(208,11,204,'LTE',0,0,'','','0'),

(209,11,204,'SFP',0,0,'','','0');

/*Table structure for table `products` */

CREATE TABLE `products` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_bin NOT NULL,
  `type_id` int(11) NOT NULL,
  `EAN` bigint(20) DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `filter` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`unique_id`),
  KEY `products_types_idx` (`type_id`),
  CONSTRAINT `products_types` FOREIGN KEY (`type_id`) REFERENCES `types` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `products` */

insert  into `products`(`unique_id`,`name`,`type_id`,`EAN`,`image`,`filter`) values 

(49,'LANCOM GS-2352',5,NULL,'284194092381870527.jpg',1),

(50,'LANCOM GS-2352P',5,NULL,'1012655434110372376.jpg',1),

(51,'LANCOM GS-2328',5,NULL,'1865322483477447056.jpg',0),

(52,'LANCOM GS-2328P',5,NULL,'1716730436322432679.jpg',1),

(54,'LANCOM GS-2328F',5,NULL,'17263853292025075906.jpg',0),

(55,'LANCOM GS-2326+',5,NULL,'1625847500286134806.jpg',1),

(56,'LANCOM GS-2326P+',5,NULL,'2140891891606305599.jpeg',1),

(57,'LANCOM GS-2310',5,NULL,'520353715173614682.jpg',1),

(58,'LANCOM GS-2310P+',5,NULL,'11473363891833027031.jpg',1),

(59,'LANCOM GS-1326',6,NULL,'46775057474275532.jpg',1),

(60,'LANCOM GS-1108',7,NULL,'4240747581520641799.jpg',1),

(61,'LANCOM GS-1108P',7,NULL,'1936595352056351902.jpg',1),

(66,'LANCOM 1793VA',10,NULL,'1667981309679268696.jpg',1),

(67,'LANCOM 1793VAW',18,NULL,'',1);

/*Table structure for table `products_attributes` */

CREATE TABLE `products_attributes` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT '1',
  `value` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `information` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`unique_id`),
  KEY `products_attributes_product_idx` (`product_id`),
  KEY `products_attributes_attribute_idx` (`attribute_id`),
  KEY `products_attributes_parent_id_idx` (`parent_id`),
  CONSTRAINT `products_attributes_attribute` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `products_attributes_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `products_attributes` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `products_attributes_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=838 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `products_attributes` */

insert  into `products_attributes`(`unique_id`,`product_id`,`attribute_id`,`parent_id`,`amount`,`value`,`information`) values 

(220,54,9,NULL,4,NULL,''),

(221,54,8,NULL,20,NULL,''),

(222,54,10,NULL,4,NULL,''),

(223,54,36,NULL,1,'128',''),

(224,54,24,NULL,1,NULL,''),

(225,54,25,NULL,1,NULL,''),

(226,54,172,NULL,1,NULL,''),

(227,54,34,NULL,1,NULL,''),

(480,50,5,NULL,48,'1000',''),

(481,50,181,480,1,NULL,''),

(482,50,24,NULL,1,NULL,''),

(483,50,36,NULL,1,'176',''),

(484,50,9,NULL,4,NULL,''),

(485,50,172,NULL,1,NULL,''),

(486,50,25,NULL,1,NULL,''),

(487,50,34,NULL,1,NULL,''),

(488,51,25,NULL,1,NULL,''),

(489,51,36,NULL,1,'128',''),

(490,51,24,NULL,1,NULL,''),

(491,51,172,NULL,1,NULL,''),

(492,51,5,NULL,24,'1000',''),

(493,51,34,NULL,1,NULL,''),

(494,51,9,NULL,4,NULL,''),

(495,52,172,NULL,1,NULL,''),

(496,52,9,NULL,4,NULL,''),

(497,52,25,NULL,1,NULL,''),

(498,52,24,NULL,1,NULL,''),

(499,52,5,NULL,24,'1000',''),

(501,52,36,NULL,1,'128',''),

(502,52,34,NULL,1,NULL,''),

(503,55,5,NULL,24,'1000',''),

(504,55,25,NULL,1,NULL,''),

(505,55,172,NULL,1,NULL,''),

(506,55,10,NULL,2,NULL,''),

(507,55,24,NULL,1,NULL,''),

(508,55,36,NULL,1,'52',''),

(509,55,34,NULL,1,NULL,''),

(510,56,5,NULL,24,'1000',''),

(511,56,181,510,1,NULL,''),

(512,56,172,NULL,1,NULL,''),

(513,56,36,NULL,1,'52',''),

(514,56,24,NULL,1,NULL,''),

(515,56,25,NULL,1,NULL,''),

(516,56,10,NULL,2,NULL,''),

(517,56,34,NULL,1,NULL,''),

(518,57,25,NULL,1,NULL,''),

(519,57,24,NULL,1,NULL,''),

(520,57,5,NULL,8,'1000',''),

(521,57,10,NULL,2,NULL,''),

(522,57,172,NULL,1,NULL,''),

(523,57,36,NULL,1,'20',''),

(524,57,34,NULL,1,NULL,''),

(525,58,10,NULL,2,NULL,''),

(526,58,5,NULL,8,'1000',''),

(527,58,181,526,1,NULL,''),

(528,58,25,NULL,1,NULL,''),

(529,58,172,NULL,1,NULL,''),

(530,58,24,NULL,1,NULL,''),

(531,58,34,NULL,1,NULL,''),

(532,58,36,NULL,1,'20',''),

(533,59,5,NULL,24,'1000',''),

(534,59,34,NULL,1,NULL,''),

(535,59,10,NULL,2,NULL,''),

(536,59,172,NULL,1,NULL,''),

(537,59,36,NULL,1,'52',''),

(538,60,36,NULL,1,'16',''),

(539,60,5,NULL,8,'1000',''),

(540,61,5,NULL,8,'1000',''),

(541,61,181,540,1,NULL,''),

(542,61,36,NULL,1,'16',''),

(823,66,34,NULL,1,NULL,''),

(825,66,200,NULL,1,NULL,''),

(828,52,181,499,1,NULL,''),

(831,49,5,NULL,48,'1000',''),

(832,49,9,NULL,4,NULL,''),

(833,49,36,NULL,1,'176',''),

(834,49,24,NULL,1,NULL,''),

(835,49,25,NULL,1,NULL,''),

(836,49,172,NULL,1,NULL,''),

(837,49,34,NULL,1,NULL,'');

/*Table structure for table `types` */

CREATE TABLE `types` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_bin NOT NULL,
  `super` int(11) DEFAULT NULL,
  `filter` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`unique_id`),
  UNIQUE KEY `unique_id_UNIQUE` (`unique_id`),
  KEY `types_super_idx` (`super`),
  CONSTRAINT `types_super` FOREIGN KEY (`super`) REFERENCES `types` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `types` */

insert  into `types`(`unique_id`,`name`,`super`,`filter`) values 

(1,'Switches',NULL,1),

(5,'Fully Managed',1,1),

(6,'Websmart',1,1),

(7,'Unmanaged',1,1),

(9,'Router',NULL,1),

(10,'Business VPN Router',9,1),

(11,'Wireless LAN',NULL,1),

(12,'Indoor Access Points',11,1),

(13,'Outdoor Access Points',11,1),

(14,'Industrial Access Points',11,1),

(15,'R&S Unified Firewalls',16,1),

(16,'Security',NULL,1),

(18,'Business VoIP Routers',9,1);

/*Table structure for table `types_attributes` */

CREATE TABLE `types_attributes` (
  `type_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `compare` tinyint(1) DEFAULT NULL,
  `filter` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`type_id`,`attribute_id`),
  KEY `types_attributes_type_idx` (`type_id`),
  KEY `types_attributes_attribute_idx` (`attribute_id`),
  CONSTRAINT `types_attributes_attribute` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `types_attributes_type` FOREIGN KEY (`type_id`) REFERENCES `types` (`unique_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `types_attributes` */

insert  into `types_attributes`(`type_id`,`attribute_id`,`compare`,`filter`) values 

(1,3,0,0),

(1,4,0,0),

(1,5,1,1),

(1,8,1,1),

(1,9,1,1),

(1,10,0,1),

(1,24,0,1),

(1,25,0,1),

(1,34,0,1),

(1,36,1,1),

(1,172,0,1),

(1,182,0,0),

(1,183,0,0),

(5,3,0,0),

(5,4,0,0),

(5,5,NULL,NULL),

(5,8,1,1),

(5,9,1,1),

(5,10,1,1),

(5,24,1,1),

(5,25,1,1),

(5,34,1,1),

(5,36,1,1),

(5,172,1,1),

(5,182,0,0),

(5,183,0,0),

(6,5,NULL,NULL),

(6,8,NULL,NULL),

(6,9,NULL,NULL),

(6,10,NULL,NULL),

(6,24,NULL,NULL),

(6,25,NULL,NULL),

(6,34,NULL,NULL),

(6,36,NULL,NULL),

(6,172,NULL,NULL),

(7,5,NULL,NULL),

(7,8,NULL,NULL),

(7,9,NULL,NULL),

(7,10,NULL,NULL),

(7,24,NULL,NULL),

(7,25,NULL,NULL),

(7,34,NULL,NULL),

(7,36,NULL,NULL),

(7,172,NULL,NULL),

(9,3,0,0),

(9,4,0,0),

(9,5,1,1),

(9,24,0,0),

(9,25,0,0),

(9,34,1,1),

(9,182,0,0),

(9,200,1,1),

(10,3,NULL,NULL),

(10,4,NULL,NULL),

(10,5,NULL,NULL),

(10,25,NULL,NULL),

(10,34,NULL,NULL),

(10,182,NULL,NULL),

(10,200,NULL,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;