【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:ch10.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
-- MySQL dump 9.09
--
-- Host: localhost Database: ch10
-- ------------------------------------------------------
-- 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`
--
--
-- Table structure for table `chat`
--
CREATE TABLE chat (
ID bigint(20) NOT NULL auto_increment,
ChatRoom varchar(50) default NULL,
ChatFrom varchar(50) default NULL,
ChatTo varchar(50) default NULL,
ChatTime datetime default '0000-00-00 00:00:00',
ChatAction varchar(50) default NULL,
ChatContent varchar(200) default NULL,
Secret tinyint(1) default '0',
PRIMARY KEY (ID),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
--
-- Dumping data for table `chat`
--
--
-- 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 `userlist`
--
CREATE TABLE userlist (
ID bigint(20) NOT NULL auto_increment,
ChatRoom varchar(50) default NULL,
UserName varchar(50) default NULL,
ChatTime bigint(20) default NULL,
DenyRoom varchar(50) default NULL,
DenyTime bigint(20) default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
--
-- Dumping data for table `userlist`
--
--
-- 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',
LoginTime bigint(20) default NULL,
PRIMARY KEY (UserID),
UNIQUE KEY UserID (UserID)
) TYPE=MyISAM;
--
-- Dumping data for table `users`
--
INSERT INTO users VALUES (1,'WebMaster','111111','1',NULL,NULL,'1','0000-00-00 00:00:00',NULL);
--
-- Table structure for table `words`
--
CREATE TABLE
words (
WordsID bigint(20) NOT NULL auto_increment,
WordsTitle varchar(100) default NULL,
WordsContent text,
WordsTime datetime default '0000-00-00 00:00:00',
UserID bigint(20) NOT NULL default '0',
PRIMARY KEY (WordsID),
UNIQUE KEY WordsID (WordsID)
) TYPE=MyISAM;
--
-- Dumping data for table `words`
--