All pastes #125938 Raw Edit

Something

public sql v1 · immutable
·published 2006-08-11 01:21 UTC
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) - (0,n) ->         tm_authorsCREATE 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,`exc_price`                 tinyint     (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,PRIMARY KEY  (`id`),KEY `author_id` (`author_id`),KEY `type` (`type`),KEY `owner_id` (`owner_id`)) 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` (`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_authors`                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`                     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 ;