sql 20070718 1751.sql

jsp实现的论坛 使用jsp+servlet+mysql 开发环境是myeclipes

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.19-beta-community-nt-debug


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema forum
--

CREATE DATABASE IF NOT EXISTS forum;
USE forum;

--
-- Definition of table `back_info`
--

DROP TABLE IF EXISTS `back_info`;
CREATE TABLE `back_info` (
  `back_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `back_fromid` varchar(45) NOT NULL,
  `back_tomessageno` int(10) unsigned NOT NULL,
  `back_sub` varchar(45) NOT NULL,
  `back_content` varchar(500) NOT NULL,
  `back_sendtime` timestamp NOT NULL DEFAULT '2007-07-17 08:47:03',
  `back_modifytime` timestamp NOT NULL DEFAULT '2007-07-17 08:47:03',
  PRIMARY KEY (`back_no`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `back_info`
--

/*!40000 ALTER TABLE `back_info` DISABLE KEYS */;
INSERT INTO `back_info` (`back_no`,`back_fromid`,`back_tomessageno`,`back_sub`,`back_content`,`back_sendtime`,`back_modifytime`) VALUES 
 (18,'cctv',14,'我有个','F1的车玩具。','2007-07-17 17:22:38','2007-07-18 13:43:38'),
 (24,'game',34,'你等着！','我找人来','2007-07-18 13:53:18','2007-07-18 13:53:18'),
 (27,'game',32,'认真','认真','2007-07-18 16:41:02','2007-07-18 16:41:02');
/*!40000 ALTER TABLE `back_info` ENABLE KEYS */;


--
-- Definition of table `group_info`
--

DROP TABLE IF EXISTS `group_info`;
CREATE TABLE `group_info` (
  `group_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(45) NOT NULL,
  PRIMARY KEY (`group_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `group_info`
--

/*!40000 ALTER TABLE `group_info` DISABLE KEYS */;
INSERT INTO `group_info` (`group_no`,`group_name`) VALUES 
 (1,'sports'),
 (2,'movie'),
 (3,'game'),
 (4,'pc'),
 (5,'足球');
/*!40000 ALTER TABLE `group_info` ENABLE KEYS */;


--
-- Definition of table `message_info`
--

DROP TABLE IF EXISTS `message_info`;
CREATE TABLE `message_info` (
  `message_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `message_sendid` varchar(45) NOT NULL,
  `message_sub` varchar(45) NOT NULL,
  `message_content` varchar(500) NOT NULL,
  `message_sendtime` timestamp NOT NULL DEFAULT '2007-07-17 08:47:03',
  `message_modifytime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `message_groupno` int(10) unsigned NOT NULL,
  PRIMARY KEY (`message_no`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `message_info`
--

/*!40000 ALTER TABLE `message_info` DISABLE KEYS */;
INSERT INTO `message_info` (`message_no`,`message_sendid`,`message_sub`,`message_content`,`message_sendtime`,`message_modifytime`,`message_groupno`) VALUES 
 (14,'cctv','F1中国','法拉利的车模谁有？','2007-07-17 17:09:05','2007-07-18 13:43:03',1),
 (31,'game','我要看世界杯！','谁和我去南非？','2007-07-18 10:19:19','2007-07-18 10:19:19',5),
 (32,'nba','最新DVD变形金刚！','  有谁想买？','2007-07-18 13:46:53','2007-07-18 13:46:53',2),
 (33,'nba','我不看电影了！！！！！！','不看了','2007-07-18 13:47:06','2007-07-18 13:47:43',2),
 (34,'nba','WOW最新战报','就是不说','2007-07-18 13:48:13','2007-07-18 13:48:13',3),
 (37,'game','gedg','dsgds','2007-07-18 15:43:20','2007-07-18 15:43:20',1);
/*!40000 ALTER TABLE `message_info` ENABLE KEYS */;


--
-- Definition of table `notice_info`
--

DROP TABLE IF EXISTS `notice_info`;
CREATE TABLE `notice_info` (
  `notice_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `notice_title` varchar(45) NOT NULL,
  `notice_content` varchar(500) NOT NULL,
  `notice_sendtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`notice_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `notice_info`
--

/*!40000 ALTER TABLE `notice_info` DISABLE KEYS */;
INSERT INTO `notice_info` (`notice_no`,`notice_title`,`notice_content`,`notice_sendtime`) VALUES 
 (4,'二手房市场已“骚动”','        南京将对非普通住房征收土地增值税的消息一出，市场一片哗然。到底这个土地增值税怎么缴才划算？对未来的二手房市场影响大不大？……昨天记者就此又做了一番调查，在土地增值税“风雨”来临之前，二手房市场已经出现“骚动”，挂牌量激增。\r\n\r\n','2007-07-18 13:32:45'),
 (5,'测试123','角动量杀风景劳动','2007-07-18 14:15:53');
/*!40000 ALTER TABLE `notice_info` ENABLE KEYS */;


--
-- Definition of table `user_info`
--

DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `user_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(45) NOT NULL,
  `user_password` varchar(45) NOT NULL,
  `user_authority` varchar(45) NOT NULL DEFAULT '0',
  `user_age` int(10) unsigned NOT NULL,
  `user_sex` varchar(45) NOT NULL,
  `user_qq` varchar(45) NOT NULL,
  `user_name` varchar(45) NOT NULL,
  PRIMARY KEY (`user_no`) USING BTREE,
  UNIQUE KEY `user_id` (`user_id`) USING BTREE,
  KEY `user_id_2` (`user_id`),
  KEY `user_id_3` (`user_id`),
  KEY `user_id_4` (`user_id`),
  KEY `user_id_5` (`user_id`),
  KEY `user_id_6` (`user_id`),
  KEY `user_id_7` (`user_id`),
  KEY `user_id_8` (`user_id`),
  KEY `user_id_9` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `user_info`
--

/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
INSERT INTO `user_info` (`user_no`,`user_id`,`user_password`,`user_authority`,`user_age`,`user_sex`,`user_qq`,`user_name`) VALUES 
 (1,'game','123456','0',34,'M','1231566','陈浩'),
 (2,'nba','123456','1',12,'F','123',''),
 (3,'cctv','123','0',12,'M','fsa','nba'),
 (4,'\'\'','123456','0',12,'F','32546','\'\'');
/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;