PHP Classes

File: sql/structure.sql

Recommend this page to a friend!
  Classes of invitro   Navelo CMS   sql/structure.sql   Download  
File: sql/structure.sql
Role: Auxiliary data
Content type: text/plain
Description: Table structure
Class: Navelo CMS
A complete Content Management System
Author: By
Last change:
Date: 19 years ago
Size: 5,674 bytes
 

Contents

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