【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-ch9.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
-- 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,
UserPass
word 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','男','webmaster@
webmaster.cn','管理员','你好\r\n\r\n你好','2006-08-09 21:52:42');