xinli.sql

心理咨询网站

# MySQL-Front 3.2  (Build 14.3)

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: xinli
# ------------------------------------------------------
# Server version 5.0.45-community-nt

DROP DATABASE IF EXISTS `xinli`;
CREATE DATABASE `xinli` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `xinli`;

#
# 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`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

#
# Dumping data for table articles
#

INSERT INTO `articles` VALUES (1,'ff','sd\tsd\tfese',1,'2008-03-30 03:46:27',1,0,0,17,3,0,'','');

#
# 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`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

#
# Dumping data for table boards
#

INSERT INTO `boards` VALUES (1,'心理咨询类别1','admin',' ','');
INSERT INTO `boards` VALUES (2,'心理咨询类别2','admin','','');
INSERT INTO `boards` VALUES (3,'心理咨询类别3','admin','','');
INSERT INTO `boards` VALUES (4,'心理咨询类别4','admin','','');

#
# 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Dumping data for table email
#


#
# Table structure for table newsusers
#

CREATE TABLE `newsusers` (
  `UserID` bigint(20) NOT NULL auto_increment,
  `UserName` varchar(50) default NULL,
  `UserPassword` varchar(50) default NULL,
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `UserID` (`UserID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

#
# Dumping data for table newsusers
#

INSERT INTO `newsusers` VALUES (1,'admin','admin');

#
# 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`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

#
# Dumping data for table users
#

INSERT INTO `users` VALUES (1,'admin','admin','男','[e-mail]','管理员','你好\r\n\r\n你好','2006-08-09 21:52:42');
INSERT INTO `users` VALUES (3,'123','123','男','[e-mail]','123','123','2008-03-30 14:00:36');
INSERT INTO `users` VALUES (5,'啊','1','男','1','1','1','2008-03-30 14:16:07');

#
# 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`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

#
# Dumping data for table words
#

INSERT INTO `words` VALUES (1,'测试测试吧，呵呵','OK不？？？','2008-03-30 20:06:15',1);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;