# --------------------------------------------------------
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';
|