File: sql/structure.sql

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 01, 2004 at 07:24 PM
# Server version: 4.0.20
# PHP Version: 4.3.7
# 
# Database : `portfolio`
# 

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

#
# Table structure for table `content_category`
#

CREATE TABLE `content_category` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `category_name` varchar(32) NOT NULL default '',
  `description` varchar(150) default NULL,
  `template_title` varchar(150) NOT NULL default '',
  `template_content` varchar(150) NOT NULL default '',
  `template_print` varchar(150) NOT NULL default '',
  `create_time` varchar(255) NOT NULL default '',
  `last_update` varchar(255) NOT NULL default '',
  `status` enum('1','2','3','4') NOT NULL default '2',
  PRIMARY KEY  (`oid`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `category_name` (`category_name`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

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

#
# Table structure for table `content_category_metadata`
#

CREATE TABLE `content_category_metadata` (
  `category_id` int(10) unsigned NOT NULL default '0',
  `metadata_id` int(10) unsigned NOT NULL default '0',
  KEY `category_id` (`category_id`,`metadata_id`)
) TYPE=MyISAM;

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

#
# Table structure for table `content_category_user`
#

CREATE TABLE `content_category_user` (
  `category_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Table structure for table `content_metadata`
#

CREATE TABLE `content_metadata` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `main_title` varchar(150) NOT NULL default '',
  `sub_title` varchar(150) default NULL,
  `summary` varchar(255) default NULL,
  `create_time` varchar(255) NOT NULL default '',
  `last_update` varchar(255) default NULL,
  `rating_total` bigint(20) unsigned NOT NULL default '0',
  `rating_times` bigint(20) unsigned NOT NULL default '0',
  `hits` bigint(20) unsigned NOT NULL default '0',
  `status` enum('1','2','3','4') NOT NULL default '2',
  PRIMARY KEY  (`oid`),
  FULLTEXT KEY `main_title` (`main_title`),
  FULLTEXT KEY `sub_title` (`sub_title`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

#
# Table structure for table `content_metadata_page`
#

CREATE TABLE `content_metadata_page` (
  `metadata_id` int(10) unsigned NOT NULL default '0',
  `page_id` int(10) unsigned NOT NULL default '0',
  KEY `title_id` (`metadata_id`,`page_id`)
) TYPE=MyISAM;

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

#
# Table structure for table `content_metadata_review`
#

CREATE TABLE `content_metadata_review` (
  `metadata_id` bigint(20) unsigned NOT NULL default '0',
  `review_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Table structure for table `content_metadata_user`
#

CREATE TABLE `content_metadata_user` (
  `metadata_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Table structure for table `content_page`
#

CREATE TABLE `content_page` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `page_title` varchar(150) NOT NULL default '',
  `page_content` mediumtext,
  `create_time` varchar(255) NOT NULL default '',
  `last_update` varchar(255) default NULL,
  `rating_total` bigint(20) unsigned NOT NULL default '0',
  `rating_times` bigint(20) unsigned NOT NULL default '0',
  `hits` bigint(20) unsigned NOT NULL default '0',
  `status` enum('1','2','3','4') NOT NULL default '1',
  PRIMARY KEY  (`oid`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_content` (`page_content`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

#
# Table structure for table `content_page_review`
#

CREATE TABLE `content_page_review` (
  `page_id` bigint(20) unsigned NOT NULL default '0',
  `review_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Table structure for table `content_page_user`
#

CREATE TABLE `content_page_user` (
  `page_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Table structure for table `content_review`
#

CREATE TABLE `content_review` (
  `oid` bigint(20) unsigned NOT NULL auto_increment,
  `review_title` varchar(150) NOT NULL default '',
  `review_comments` tinytext NOT NULL,
  `create_time` varchar(255) NOT NULL default '',
  `last_update` varchar(255) NOT NULL default '',
  `rating_total` bigint(20) unsigned NOT NULL default '0',
  `rating_times` bigint(20) unsigned NOT NULL default '0',
  `hits` bigint(20) unsigned NOT NULL default '0',
  `status` enum('1','2','3','4') NOT NULL default '4',
  PRIMARY KEY  (`oid`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

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

#
# Table structure for table `content_review_user`
#

CREATE TABLE `content_review_user` (
  `review_id` bigint(20) unsigned NOT NULL default '0',
  `user_id` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;