--
-- 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_screenshots
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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_index
CREATE 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 var
CREATE 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 var
CREATE TABLE IF NOT EXISTS `tm_translate` (
`tbl`                     varchar     (30)   default NULL,
`fld`                     varchar     (30)   default NULL
) ENGINE=InnoDB ;