BasicCMS - Docs - SQL Dump

-- phpMyAdmin SQL Dump
-- http://www.phpmyadmin.net

-- --------------------------------------------------------

-- 
-- Table structure for table `content`
-- 

DROP TABLE IF EXISTS `content`;
CREATE TABLE `content` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pageid` int(10) unsigned NOT NULL default '0',
  `sectionid` int(10) unsigned NOT NULL default '0',
  `isphp` tinyint(1) unsigned NOT NULL default '0',
  `isdynamic` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `content_cache`
-- 

DROP TABLE IF EXISTS `content_cache`;
CREATE TABLE `content_cache` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `contentid` int(10) unsigned NOT NULL default '0',
  `cache` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `content_text`
-- 

DROP TABLE IF EXISTS `content_text`;
CREATE TABLE `content_text` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `contentid` int(10) unsigned NOT NULL default '0',
  `content` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `page`
-- 

DROP TABLE IF EXISTS `page`;
CREATE TABLE `page` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parentid` int(10) unsigned NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  `title` varchar(40) NOT NULL default '',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `page_cache`
-- 

DROP TABLE IF EXISTS `page_cache`;
CREATE TABLE `page_cache` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pageid` int(10) unsigned NOT NULL default '0',
  `cache` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `rel_page_template`
-- 

DROP TABLE IF EXISTS `rel_page_template`;
CREATE TABLE `rel_page_template` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pageid` int(10) unsigned NOT NULL default '0',
  `templateid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `template`
-- 

DROP TABLE IF EXISTS `template`;
CREATE TABLE `template` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(40) NOT NULL default '',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `template_section`
-- 

DROP TABLE IF EXISTS `template_section`;
CREATE TABLE `template_section` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `templateid` int(10) unsigned NOT NULL default '0',
  `sectionid` int(10) unsigned NOT NULL default '0',
  `replacetext` varchar(255) NOT NULL default '',
  `title` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `template_text`
-- 

DROP TABLE IF EXISTS `template_text`;
CREATE TABLE `template_text` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `templateid` int(10) unsigned NOT NULL default '0',
  `template` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

BasicCMS