ibarticle.sql

套中小型企业网站建设

# phpMyAdmin SQL Dump
# version 2.5.5
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2004 年 11 月 07 日 12:30
# 服务器版本: 4.1.6
# PHP 版本: 5.0.2
# 
# 数据库 : `IB_NEWS`
# 

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

#
# 表的结构 `ib_album`
#

CREATE TABLE `ib_album` (
  `catID` int(11) unsigned NOT NULL auto_increment,
  `catPath` varchar(100) NOT NULL default '',
  `catTitle` varchar(100) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  `catImage` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`catID`),
  KEY `catPath` (`catPath`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

#
# 表的结构 `ib_article`
#

CREATE TABLE `ib_article` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `summary` varchar(200) NOT NULL default '',
  `postTime` date NOT NULL default '0000-00-00',
  `author` varchar(30) NOT NULL default '',
  `comeFrom` varchar(50) NOT NULL default '',
  `content` text NOT NULL,
  `keyword` varchar(20) NOT NULL default '',
  `catPath` varchar(200) NOT NULL default '',
  `isImg` int(1) unsigned NOT NULL default '0',
  `imgName` varchar(50) NOT NULL default '',
  `linkPath` varchar(100) NOT NULL default '',
  `audit` int(1) unsigned NOT NULL default '0',
  `recommend` mediumint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `catPath` (`catPath`),
  KEY `keyword` (`keyword`),
  KEY `isImg` (`isImg`),
  KEY `recommend` (`recommend`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

#
# 表的结构 `ib_cat`
#

CREATE TABLE `ib_cat` (
  `catID` int(11) unsigned NOT NULL auto_increment,
  `catPath` varchar(100) NOT NULL default '',
  `catTitle` varchar(100) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  `catImage` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`catID`),
  KEY `catPath` (`catPath`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

#
# 表的结构 `ib_picture`
#

CREATE TABLE `ib_picture` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `picTitle` varchar(30) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  `picName` varchar(50) NOT NULL default '',
  `catPath` varchar(200) NOT NULL default '',
  `hasThumb` int(1) NOT NULL default '0',
  `hasMark` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `catPath` (`catPath`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

#
# 表的结构 `ib_user`
#

CREATE TABLE `ib_user` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `pwd` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `ib_album` VALUES('', '0', '相册集', '相册根目录', '');
INSERT INTO `ib_cat` VALUES('', '0', '首页', '分类根目录', '');