rendered paste body---- TABLE tm_index-- DESCRIPTION one row per template, fields are described in http://www.templatemonster.com/webapi/doc/html/ch02s04.html#id2882345-- owner_id is 0 for tm.-- CARDINALITY-- tm_index <- (1,1) - (0,n) -> tm_types-- tm_index <- (1,1) - (1,1) -> tm_details-- tm_index <- (1,1) - (0,n) -> tm_authors-- tm_index <- (0,n) - (0,n) -> tm_styles_index WITH :-- tm_index <- (1,1) - (1,1) -> tm_styles-- tm_index <- (0,n) - (1,1) -> tm_pages-- tm_index <- (0,n) - (1,1) -> tm_screenshotsCREATE TABLE IF NOT EXISTS `tm_index` (`id` tinyint (6) NOT NULL auto_increment,`state` tinyint (1) default 0 NULL,`is_hosting` tinyint (1) default 0 NULL,`is_flash` tinyint (1) default 0 NULL,`is_unique` tinyint (1) default 0 NULL,`is_non_unique` tinyint (1) default 0 NULL,`is_unique_corporate` tinyint (1) default 0 NULL,`is_non_unique_corporate` tinyint (1) default 0 NULL,`is_full_size` tinyint (1) default 0 NULL,`is_real_size` tinyint (1) default 0 NULL,`author_id` tinyint (2) default 0 NULL,`type` tinyint (2) default 0 NULL,`owner_id` tinyint (4) default 0 NOT NULL,`price` tinyint (4) default 0 NULL,PRIMARY KEY (`id`),KEY `author_id` (`author_id`),KEY `type` (`type`),KEY `owner_id` (`owner_id`)) ENGINE=InnoDB AUTO_INCREMENT=1 PARTITION BY RANGE(id)( PARTITION p1 VALUES LESS THAN(1001), PARTITION p2 VALUES LESS THAN(2001), PARTITION p3 VALUES LESS THAN(3001), PARTITION p4 VALUES LESS THAN(4001), PARTITION p5 VALUES LESS THAN(5001), PARTITION p6 VALUES LESS THAN(6001), PARTITION p7 VALUES LESS THAN(7001), PARTITION p8 VALUES LESS THAN(8001), PARTITION p9 VALUES LESS THAN(8001), PARTITION p10 VALUES LESS THAN(9001), PARTITION p11 VALUES LESS THAN(10001), PARTITION p12 VALUES LESS THAN(11001), PARTITION p13 VALUES LESS THAN(12001), PARTITION p14 VALUES LESS THAN MAXVALUE)---- TABLE tm_details-- DESCRIPTION one row per tm details, this is vertical partionning-- CARDINALITY-- tm_details <- (1,1) - (1,1) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_details` (`id_tm` int (6) default 0 NULL,`exc_price` int (6) default 0 NULL,`downloads` int (6) default 0 NULL,`inserted_date` int (10) default 0 NULL,`keywords` varchar (255) default 0 NULL,`software_required` varchar (255) default 0 NULL,KEY (`id_tm`),KEY `keywords` (`keywords`),KEY `software_required` (`software_required`)) ENGINE=InnoDB AUTO_INCREMENT=1 PARTITION BY RANGE(id)( PARTITION p1 VALUES LESS THAN(1001), PARTITION p2 VALUES LESS THAN(2001), PARTITION p3 VALUES LESS THAN(3001), PARTITION p4 VALUES LESS THAN(4001), PARTITION p5 VALUES LESS THAN(5001), PARTITION p6 VALUES LESS THAN(6001), PARTITION p7 VALUES LESS THAN(7001), PARTITION p8 VALUES LESS THAN(8001), PARTITION p9 VALUES LESS THAN(8001), PARTITION p10 VALUES LESS THAN(9001), PARTITION p11 VALUES LESS THAN(10001), PARTITION p12 VALUES LESS THAN(11001), PARTITION p13 VALUES LESS THAN(12001), PARTITION p14 VALUES LESS THAN MAXVALUE);---- TABLE tm_types-- DESCRIPTION one row per type-- CARDINALITY-- tm_types <- (0,n) - (1,1) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_types` (`id` tinyint (3) default NULL,`label` varchar (60) default NULL,PRIMARY KEY (`id`),UNIQUE `label` (`label`)) ENGINE=InnoDB ;---- TABLE tm_authors-- DESCRIPTION one row per author-- CARDINALITY-- tm_authors <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_authors` (`id` tinyint (3) default NULL,`tm_author` varchar (60) default NULL,PRIMARY KEY (`id`),UNIQUE `tm_authors` (`tm_authors`)) ENGINE=InnoDB ;---- TABLE tm_styles_index-- DESCRIPTION one row per unique style.-- CARDINALITY-- tm_styles_index <- (1,1) - (0,n) -> tm_styles-- tm_styles_index <- (0,n) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_styles_index` (`id` tinyint (3) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,PRIMARY KEY (`id`),UNIQUE `label` (`label`)) ENGINE=InnoDB ;---- TABLE tm_styles-- DESCRIPTION one row per style of one template-- CARDINALITY-- tm_styles <- (1,1) - (0,n) -> tm_styles_index-- tm_styles <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_styles` (`id_style` tinyint (2) default NULL,`id_tm` int (6) default NULL,KEY `id_style` (`id_style`),KEY `id_tm` (`id_tm`)) ENGINE=InnoDB ;---- TABLE tm_pages-- DESCRIPTION one row per unique page.-- CARDINALITY-- tm_page <- (0,n) - (1,1) -> tm_screenshots-- tm_page <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_pages` (`id` tinyint (10) default NULL,`id_tm` tinyint (6) default NULL,`label` varchar (60) default NULL,PRIMARY KEY (`id`),KEY (`id_tm`),UNIQUE `label` (`label`)) ENGINE=InnoDB ;---- TABLE tm_screenshots-- DESCRIPTION one row per screenshot-- CARDINALITY-- tm_screenshoots <- (0,1) - (0,n) -> tm_page-- tm_screenshoots <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_screenshots` (`id_tm` tinyint (6) default NULL,`id_page` tinyint (10) default NULL,`uri` varchar (50) default NULL,`filetime` int (10) default NULL,KEY `id_tm` (`id_tm`),KEY `id_page` (`id_page`),UNIQUE `uri` (`uri`)) ENGINE=InnoDB PARTITION BY RANGE(id_tm)( PARTITION p1 VALUES LESS THAN(1001), PARTITION p2 VALUES LESS THAN(2001), PARTITION p3 VALUES LESS THAN(3001), PARTITION p4 VALUES LESS THAN(4001), PARTITION p5 VALUES LESS THAN(5001), PARTITION p6 VALUES LESS THAN(6001), PARTITION p7 VALUES LESS THAN(7001), PARTITION p8 VALUES LESS THAN(8001), PARTITION p9 VALUES LESS THAN(8001), PARTITION p10 VALUES LESS THAN(9001), PARTITION p11 VALUES LESS THAN(10001), PARTITION p12 VALUES LESS THAN(11001), PARTITION p13 VALUES LESS THAN(12001), PARTITION p14 VALUES LESS THAN MAXVALUE);---- TABLE tm_categories_index-- DESCRIPTION one row per unique category.-- CARDINALITY-- tm_categories_index <- (1,1) - (0,n) -> tm_categories-- tm_categories_index <- (0,n) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_cats_index` (`id` tinyint (3) default NULL,`label_fr` varchar (60) default NULL,`label_en` varchar (60) default NULL,PRIMARY KEY (`id`),UNIQUE `label` (`label`)) ENGINE=InnoDB ;---- TABLE tm_categories-- DESCRIPTION one row per category of one template-- CARDINALITY-- tm_categories <- (1,1) - (0,n) -> tm_categories_index-- tm_categories <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_cats` (`id_cat` tinyint (2) default NULL,`id_tm` int (6) default NULL,KEY `id_cat` (`id_cat`),KEY `id_tm` (`id_tm`)) ENGINE=InnoDB ;---- TABLE tm_config-- DESCRIPTION one row per config varCREATE TABLE IF NOT EXISTS `tm_config` (`label` varchar (20) default NULL,`val` varchar (20) default NULL,) ENGINE=InnoDB ;