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) - (1,1) -> tm_details-- tm_index <- (1,1) - (0,n) -> tm_types-- tm_index <- (1,1) - (0,n) -> tm_authors-- tm_index <- (0,n) - (0,n) -> tm_styles_index WITH :-- tm_index <- (0,n) - (1,1) -> tm_styles-- tm_index <- (0,n) - (0,n) -> tm_keywords_index WITH :-- tm_index <- (0,n) - (1,1) -> tm_keywords-- tm_index <- (0,n) - (0,n) -> tm_cats_index WITH :-- tm_index <- (0,n) - (1,1) -> tm_cats-- tm_index <- (0,n) - (1,1) -> tm_pages-- tm_index <- (0,n) - (1,1) -> tm_screenshotsCREATE TABLE IF NOT EXISTS `tm_index` (`id_tm` int (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_site` tinyint (1) default 0 NULL,`is_real_size` tinyint (1) default 0 NULL,`id_author` int (3) default 0 NULL,`id_type` int (2) default 0 NULL,`owner_id` int (4) default 0 NOT NULL,`price` int (4) default 0 NULL,PRIMARY KEY (`id_tm`),KEY `id_author` (`id_author`),KEY `id_type` (`id_type`),KEY `owner_id` (`owner_id`)) ENGINE=InnoDB AUTO_INCREMENT=1;---- 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,`software_required` varchar (255) default 0 NULL,KEY (`id_tm`),KEY `software_required` (`software_required`)) ENGINE=InnoDB AUTO_INCREMENT=1 ;---- TABLE tm_types-- DESCRIPTION one row per type-- CARDINALITY-- tm_types <- (0,n) - (1,1) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_types_index` (`id_type` int (3) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,UNIQUE `label_en` (`label_en`), UNIQUE `label_fr` (`label_fr`), PRIMARY KEY (`id_type`) ) 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_index` (`id_author` int (3) default NULL,`label` varchar (60) default NULL,PRIMARY KEY (`id_author`),UNIQUE `label` (`label`)) 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_style` int (3) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,UNIQUE `label_en` (`label_en`), UNIQUE `label_fr` (`label_fr`), PRIMARY KEY (`id_style`)) 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` int (2) default NULL,`id_tm` int (6) default NULL,KEY `id_style` (`id_style`),KEY `id_tm` (`id_tm`)) ENGINE=InnoDB ;---- TABLE tm_keywords_index-- DESCRIPTION one row per unique keyword.-- CARDINALITY-- tm_keywords_index<- (1,1) - (0,n) -> tm_keywords-- tm_keywords_index<- (0,n) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_keywords_index` (`id_keyword` int (3) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,UNIQUE `label_en` (`label_en`), UNIQUE `label_fr` (`label_fr`), PRIMARY KEY (`id_keyword`)) ENGINE=InnoDB ;---- TABLE tm_keywords-- DESCRIPTION one row per keyword of one template-- CARDINALITY-- tm_keywords <- (1,1) - (0,n) -> tm_keywords_index-- tm_keywords <- (1,1) - (0,n) -> tm_indexCREATE TABLE IF NOT EXISTS `tm_keywords` (`id_keyword` int (2) default NULL,`id_tm` int (6) default NULL,KEY `id_keyword` (`id_keyword`),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_page` int (10) default NULL auto_increment,`id_tm` int (6) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,UNIQUE `label_en` (`label_en`), UNIQUE `label_fr` (`label_fr`), KEY (`id_tm`),PRIMARY KEY `id_page` (`id_page`)) 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_screenshot` int (6) NOT NULL auto_increment,`id_tm` int (6) default NULL,`id_page` int (10) default NULL,`scr_type_id` int (1) default 0 NULL,`width` int (4) default 0 NULL,`height` int (4) default 0 NULL,`uri` varchar (50) default NULL,`filemtime` int (10) default NULL,`href` varchar (100) default NULL,`description` varchar (200) default NULL,PRIMARY KEY `id_screenshot` (`id_screenshot`),KEY `id_tm` (`id_tm`),KEY `id_page` (`id_page`),UNIQUE `uri` (`uri`)) ENGINE=InnoDB;---- 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_cat` int (3) default NULL,`label_en` varchar (60) default NULL,`label_fr` varchar (60) default NULL,UNIQUE `label_en` (`label_en`), UNIQUE `label_fr` (`label_fr`), PRIMARY KEY `id_cat` (`id_cat`)) 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` int (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 ;---- TABLE tm_translate-- DESCRIPTION one row per config varCREATE TABLE IF NOT EXISTS `tm_translate` (`tbl` varchar (30) default NULL,`fld` varchar (30) default NULL) ENGINE=InnoDB ;