PHP Classes

File: templates.sql

Recommend this page to a friend!
  Classes of Olaf Lederer   Import templates   templates.sql   Download  
File: templates.sql
Role: Auxiliary data
Content type: text/plain
Description: the database (sql data)
Class: Import templates
Import data about TemplateMonster.com templates
Author: By
Last change:
Date: 18 years ago
Size: 2,399 bytes
 

Contents

Class file image Download
# -------------------------------------------------------- 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';