-- MySQL dump 9.09
--
-- Host: localhost
Database: ch9
-- ------------------------------------------------------
-- Server version 4.0.16-nt
--
-- Table structure for table `articles`
--
CREATE TABLE articles (
ArticleID bigint(20) NOT NULL auto_increment,
ArticleTitle varchar(100) default NULL,
ArticleContent text,
UserID bigint(20) default '0',
CreateTime datetime default '0000-00-00 00:00:00',
BoardID bigint(20) default '0',
FatherID bigint(20) default '0',
Sign tinyint(1) default '0',
ReadCount int(11) default '0',
ReCount int(11) default '0',
GoodArticle tinyint(1) default '0',
PicUrl varchar(30) default '0',
PicName varchar(100) default NULL,
PRIMARY KEY(ArticleID),
UNIQUE KEY ArticleID (ArticleID)
) TYPE=MyISAM;
--
-- Dumping data for table `articles`
--
--
-- Table structure for table `boards`
--
CREATE TABLE boards (
BoardID bigint(20) NOT NULL auto_increment,
BoardName varchar(100) default NULL,
BoardMaster1 varchar(50) default NULL,
BoardMaster2 varchar(50) default NULL,
BoardMaster3 varchar(50) default NULL,
PRIMARY KEY(BoardID),
UNIQUE KEY BoardID (BoardID)
) TYPE=MyISAM;
--
-- Dumping data for table `boards`
--
INSERT INTO boards VALUES (1,'电脑市场','better','blackmood','');
INSERT INTO boards VALUES (2,'热点动态','jack','','');
INSERT INTO boards VALUES (3,'二手货交易','blackmood','','');
INSERT INTO boards VALUES (4,'军事','indigoblue','','');
INSERT INTO boards VALUES (5,'鹊桥','better','','');
--
-- Table structure for table `denylist`
--
CREATE TABLE denylist (
DenyID bigint(20) NOT NULL auto_increment,
UserID bigint(20) default NULL,
BoardID bigint(20) default NULL,
DenyTime datetime default NULL,
PRIMARY KEY(DenyID),
UNIQUE KEY DenyID (DenyID)
) TYPE=MyISAM;
--
-- Dumping data for table `denylist`
--
--
-- Table structure for table `email`
--
CREATE TABLE email (
EmailID bigint(20) NOT NULL auto_increment,
EmailSubject varchar(200) default NULL,
EmailContent text,
EmailSender varchar(50) NOT NULL default '',
EmailReceiver varchar(50) NOT NULL default '',
CreateTime datetime default '0000-00-00 00:00:00',
EmailType tinyint(1) default '0',
Tag tinyint(1) default '0',
PRIMARY KEY(EmailID)
) TYPE=MyISAM;
--
-- Dumping data for table `email`
--
--
-- Table structure for table `users`
--
CREATE TABLE users (
UserID bigint(20) NOT NULL auto_increment,
UserName varchar(50) default NULL,
UserPassword varchar(50) default NULL,
Sex char(2) default NULL,
Email varchar(30) default NULL,
NickName varchar(50) default NULL,
Sign text,
CreateTime datetime default '0000-00-00 00:00:00',
PRIMARY KEY(UserID),
UNIQUE KEY UserID (UserID)
) TYPE=MyISAM;
--
-- Dumping data for table `users`
--
INSERT INTO users VALUES (1,'WebMaster','1','男','[email protected]','管理员','你好\r\n\r\n你好','2006-08-09 21:52:42');
|
