File: templates.sql

# --------------------------------------------------------

CREATE TABLE `tpl_authors` (
  `id` int(11) NOT NULL auto_increment,
  `nickname` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Returns a table of all authors';

# --------------------------------------------------------

CREATE TABLE `tpl_categorie_links` (
  `tpl_id` int(11) NOT NULL default '0',
  `category` int(11) NOT NULL default '0',
  KEY `tpl_id` (`tpl_id`)
) TYPE=MyISAM COMMENT='Returns a table of links between templates and categories.';

# --------------------------------------------------------

CREATE TABLE `tpl_categorie_list` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(35) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Returns a table of all templates categories';

# --------------------------------------------------------

CREATE TABLE `tpl_keywords` (
  `tpl_id` int(11) NOT NULL default '0',
  `keywords` text NOT NULL,
  PRIMARY KEY  (`tpl_id`)
) TYPE=MyISAM COMMENT='Returns a table of search keywords defined for templates';

# --------------------------------------------------------

CREATE TABLE `tpl_log` (
  `id` int(11) NOT NULL auto_increment,
  `last_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `success` enum('1','0') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Tabel with data about the updates';

# --------------------------------------------------------

CREATE TABLE `tpl_screenshots4` (
  `id` int(11) NOT NULL auto_increment,
  `price` decimal(6,2) NOT NULL default '0.00',
  `excl_price` decimal(6,2) NOT NULL default '0.00',
  `date_added` date NOT NULL default '0000-00-00',
  `num_downloads` int(11) NOT NULL default '0',
  `hosting` tinyint(1) NOT NULL default '0',
  `flash` tinyint(1) NOT NULL default '0',
  `adult` tinyint(1) NOT NULL default '0',
  `unique_logo` tinyint(1) NOT NULL default '0',
  `non_unique_logo` tinyint(1) NOT NULL default '0',
  `unique_corp` tinyint(1) NOT NULL default '0',
  `non_unique_corp` tinyint(1) NOT NULL default '0',
  `author_id` int(11) NOT NULL default '0',
  `full_site_tpl` tinyint(1) NOT NULL default '0',
  `num_pages` int(11) NOT NULL default '0',
  `screenshots` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='	Returns a simple properties of selected templates';