sC7mk8GC

1CREATE TABLE IF NOT EXISTS `media_categories` (
2  `category_id` int(11) NOT NULL,
3  `media_id` int(11) NOT NULL,
4  KEY `fk_media_categories_1` (`category_id`),
5  KEY `fk_media_categories_2` (`media_id`)
6) ENGINE=InnoDB
7
8CREATE TABLE IF NOT EXISTS `categories` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `category_name` tinytext CHARACTER SET utf8 NOT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=InnoDB
13
14
15CREATE TABLE IF NOT EXISTS `media` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `name` tinyblob NOT NULL,
18  `folder` blob,
19  `filename` blob,
20  `url` blob,
21  `size` int(11) DEFAULT NULL,
22  `type` tinyblob,
23  `info` blob,
24  `date` timestamp NULL DEFAULT NULL,
25  `private` tinyint(1) DEFAULT '1',
26  `product_id` int(11) DEFAULT NULL,
27  PRIMARY KEY (`id`),
28  UNIQUE KEY `id_UNIQUE` (`id`),
29  KEY `fk_media_1` (`product_id`)
30) ENGINE=InnoDB