CREATE TABLE `articles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `sub_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `articles` (`id`, `title`, `sub_title`) VALUES
(10,	'1557638afd1cfd51f39d',	'5e470fb2db748e2b964b'),
(6,	'2048b8f618e457c93563',	'cc9316a8de9421ada5d0'),
(8,	'3e533a34ecf2b9080f7a',	'7fc14d48aac91026fa32'),
(3,	'7671de9c44cce1e504c5',	'26739d02a7a1325c94c3'),
(4,	'9e8e885c8d79124fc042',	'ce57b9d951a7276109cd'),
(9,	'9f5aedaaa996c90136af',	'bccf7141985e547d587b'),
(1,	'a2cf0d12061ff31135c4',	'c2df639bc560a5818b61'),
(7,	'beebeabb205148e1f3ad',	'b12ab17b444cb1ec93bf'),
(5,	'da93d49173ee015a8613',	'69a415433ed5e5e2d128'),
(2,	'dbdec43ca1df1d19202d',	'42ee9eb00e824bcc78e7');

CREATE TABLE `articles_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `articles_id` int(10) unsigned NOT NULL,
  `item_name` enum('theme','author','status') COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `articles_id` (`articles_id`),
  KEY `articles_id_item_name_value` (`articles_id`,`item_name`,`value`),
  KEY `item_name` (`item_name`),
  CONSTRAINT `articles_data_ibfk_1` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `articles_data` (`id`, `articles_id`, `item_name`, `value`) VALUES
(1,	1,	'theme',	'theme3'),
(2,	1,	'author',	'Ivan'),
(3,	1,	'status',	'show'),
(4,	2,	'theme',	'theme2'),
(5,	2,	'author',	'Ivan'),
(6,	2,	'status',	'show'),
(7,	3,	'theme',	'theme2'),
(8,	3,	'author',	'Peter'),
(9,	3,	'status',	'hide'),
(10,	4,	'theme',	'theme3'),
(11,	4,	'author',	'Ivan'),
(12,	4,	'status',	'show'),
(13,	5,	'theme',	'theme3'),
(14,	5,	'author',	'Peter'),
(15,	5,	'status',	'hide'),
(16,	6,	'theme',	'theme3'),
(17,	6,	'author',	'Peter'),
(18,	6,	'status',	'show'),
(19,	7,	'theme',	'theme3'),
(20,	7,	'author',	'Jose'),
(21,	7,	'status',	'hide'),
(22,	8,	'theme',	'theme1'),
(23,	8,	'author',	'Peter'),
(24,	8,	'status',	'show'),
(25,	9,	'theme',	'theme3'),
(26,	9,	'author',	'Jose'),
(27,	9,	'status',	'hide'),
(28,	10,	'theme',	'theme2'),
(29,	10,	'author',	'Jose'),
(30,	10,	'status',	'show');