strutsbbs.sql

java论坛代码。 mvc模式下的bbs论坛程序

use bbs;
# MySQL dump 8.14
#
# Host: localhost    Database: bbs
#--------------------------------------------------------
# Server version	3.23.41-nt

#
# Table structure for table 'admin'
#

CREATE TABLE admin (
  id int(2) NOT NULL auto_increment,
  username varchar(20) default NULL,
  password varchar(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'admin'
#

INSERT INTO admin VALUES (1,'kiki','21sjzjr');

#
# Table structure for table 'bbsuser'
#

CREATE TABLE bbsuser (
  id int(5) NOT NULL auto_increment,
  username varchar(15) default NULL,
  password varchar(15) default NULL,
  confirmpassword varchar(15) default NULL,
  question varchar(15) default NULL,
  answer varchar(15) default NULL,
  fullname varchar(10) default NULL,
  gender char(2) default NULL,
  year varchar(5) default NULL,
  month varchar(5) default NULL,
  day varchar(5) default NULL,
  email varchar(20) default NULL,
  ison int(2) default '0',
  number int(5) default '0',
  topicnum int(5) default '0',
  logintime varchar(20) default NULL,
  loginmin bigint(20) default NULL,
  logouttime varchar(20) default NULL,
  logoutmin bigint(20) default NULL,
  ip varchar(16) default NULL,
  rannum varchar(20) default NULL,
  jingyan double(6,3) default '0.000',
  biaoxian int(5) default '0',
  shengming int(5) default '0',
  zhiwu varchar(6) default NULL,
  instru varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'bbsuser'
#

INSERT INTO bbsuser VALUES (1,'kiki','21sjzjr','null','a','ab','a','男','','01','a','a',1,120,49,'2003年08月02日',1059799939502,'2003年08月02日',1059800116647,'127.0.0.1',NULL,519.204,0,0,NULL,'aaccc');
INSERT INTO bbsuser VALUES (2,'a','aaaaaa','aaaaaa','a','a','an','男','19','01','','a',0,9,0,'2003年08月01日',1059711367654,'2003年08月01日',1059711459506,'127.0.0.1',NULL,17.836,0,0,NULL,'a');

#
# Table structure for table 'board'
#

CREATE TABLE board (
  id int(3) NOT NULL auto_increment,
  name varchar(15) default NULL,
  ctype varchar(10) default NULL,
  cname varchar(15) default NULL,
  admin varchar(15) default '0',
  topicnum int(5) default '0',
  type varchar(10) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'board'
#

INSERT INTO board VALUES (17,'Linux','电脑技术','开源操作系统','0',1,'computer');
INSERT INTO board VALUES (16,'java','电脑技术','编程语言','kiki',14,'computer');

#
# Table structure for table 'friend'
#

CREATE TABLE friend (
  id int(5) NOT NULL auto_increment,
  username varchar(15) default NULL,
  friend varchar(15) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'friend'
#

INSERT INTO friend VALUES (5,'hpq852','hpq852');
INSERT INTO friend VALUES (17,'a','kiki');

#
# Table structure for table 'mail'
#

CREATE TABLE mail (
  id int(5) NOT NULL auto_increment,
  fromuser varchar(15) default NULL,
  touser varchar(15) default NULL,
  subject varchar(50) default NULL,
  content blob,
  isnew int(2) default '1',
  mailtime varchar(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'mail'
#

INSERT INTO mail VALUES (16,'kiki','hpq852','Re: 你好呀','你呢，我还好了。',0,'08月23日 07:55');
INSERT INTO mail VALUES (15,'kiki','hpq852','Re: 你好呀','你呢，我还好了。',0,'08月23日 07:55');
INSERT INTO mail VALUES (14,'kiki','hpq852','Re: 你好呀','你呢，我还好了。',0,'08月23日 07:54');
INSERT INTO mail VALUES (13,'hpq852','kiki','你好呀','好久不见了，你还好吗？',0,'08月23日 07:53');
INSERT INTO mail VALUES (22,'kiki','a','Re: hello','s',1,'2003年08月01日');
INSERT INTO mail VALUES (21,'a','kiki','hello','hello',0,'2003年08月01日');
INSERT INTO mail VALUES (18,'kiki','hpq852','Re: 你好呀','你也好呀\r\n',1,'2003年07月26日');
INSERT INTO mail VALUES (19,'kiki','kiki','Re: hello','你好呀',0,'2003年07月26日');
INSERT INTO mail VALUES (20,'kiki','kiki','Re: Re: hello','hhhhhhhhhh',0,'2003年07月28日');

#
# Table structure for table 'message'
#

CREATE TABLE message (
  id int(5) NOT NULL auto_increment,
  fromuser varchar(15) default NULL,
  touser varchar(15) default NULL,
  content varchar(30) default NULL,
  isnew int(2) default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'message'
#

INSERT INTO message VALUES (1,'kiki','kiki','你好',0);
INSERT INTO message VALUES (2,'kiki','kiki','你好呀',0);
INSERT INTO message VALUES (3,'kiki','hpq852','你好呀',0);
INSERT INTO message VALUES (4,'kiki','kiki','你好呀',0);
INSERT INTO message VALUES (5,'kiki','hpq852','你好',0);
INSERT INTO message VALUES (6,'kiki','hpq852','hello',0);
INSERT INTO message VALUES (7,'kiki','hpq852','是吗',0);
INSERT INTO message VALUES (8,'kiki','hpq852','你好',0);
INSERT INTO message VALUES (9,'hpq852','kiki','hao ya',0);
INSERT INTO message VALUES (10,'kiki','hpq852','在哪呀\r\n',0);
INSERT INTO message VALUES (11,'kiki','hpq852','你好呀',0);
INSERT INTO message VALUES (12,'hpq852','kiki','yibanle',0);
INSERT INTO message VALUES (13,'kiki','kiki','和和',0);
INSERT INTO message VALUES (14,'kiki','kiki','好呀',0);
INSERT INTO message VALUES (15,'kiki','kiki','hello',0);
INSERT INTO message VALUES (16,'kiki','kiki','你在哪呀',0);
INSERT INTO message VALUES (17,'kiki','kiki','我在西大啊，你呢',0);
INSERT INTO message VALUES (18,'kiki','kiki','hello',0);
INSERT INTO message VALUES (19,'kiki','kiki','nihao',0);
INSERT INTO message VALUES (20,'kiki','kiki','f',0);
INSERT INTO message VALUES (21,'kiki','kiki','呵呵',0);
INSERT INTO message VALUES (22,'kiki','kiki','笑什么啊\r\n',0);
INSERT INTO message VALUES (23,'kiki','kiki','',0);
INSERT INTO message VALUES (24,'kiki','hpq','ff',1);
INSERT INTO message VALUES (25,'kiki','kiki','jhgjghjfg',0);
INSERT INTO message VALUES (26,'kiki','kiki','jjkj',0);
INSERT INTO message VALUES (27,'kiki','kiki','',0);
INSERT INTO message VALUES (28,'kiki','kiki','uiy',0);
INSERT INTO message VALUES (29,'kiki','kiki','hy',0);
INSERT INTO message VALUES (30,'kiki','kiki','hg',0);
INSERT INTO message VALUES (31,'kiki','kiki','sssssssss',0);
INSERT INTO message VALUES (32,'kiki','kiki','ssssssssss',0);
INSERT INTO message VALUES (33,'a','kiki','aaaaaaaaa',0);
INSERT INTO message VALUES (34,'kiki','a','ffffffffffffffffff',0);
INSERT INTO message VALUES (35,'kiki','a','aaaaaaaaaaaaa',0);
INSERT INTO message VALUES (36,'a','kiki','hello',0);
INSERT INTO message VALUES (37,'kiki','kiki','tttttttttttttttttttttttttttttt',0);
INSERT INTO message VALUES (38,'kiki','a','ffffffffff',0);
INSERT INTO message VALUES (39,'a','kiki','aaaaaaaaa',0);
INSERT INTO message VALUES (40,'kiki','a','ffff',0);
INSERT INTO message VALUES (41,'a','kiki','你好呀',0);
INSERT INTO message VALUES (42,'kiki','a','好呀',0);
INSERT INTO message VALUES (43,'kiki','kiki','饿额',0);
INSERT INTO message VALUES (44,'a','kiki','o',0);
INSERT INTO message VALUES (45,'a','kiki','dddd',0);
INSERT INTO message VALUES (46,'a','kiki','怎么样呀',0);
INSERT INTO message VALUES (47,'kiki','a','还可以了',0);
INSERT INTO message VALUES (48,'kiki','a','方法方法方法方法',0);
INSERT INTO message VALUES (49,'kiki','a','fffffffff',0);
INSERT INTO message VALUES (50,'a','kiki','e',0);
INSERT INTO message VALUES (51,'kiki','a','f',0);
INSERT INTO message VALUES (52,'a','kiki','gggg',0);
INSERT INTO message VALUES (53,'kiki','a','sssssssssss',0);
INSERT INTO message VALUES (54,'a','kiki','vvvvvvvvvvvvvvvvvv',0);

#
# Table structure for table 'mylove'
#

CREATE TABLE mylove (
  id int(5) NOT NULL auto_increment,
  username varchar(15) default NULL,
  contentid int(5) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'mylove'
#

INSERT INTO mylove VALUES (2,'kiki',10);

#
# Table structure for table 'topic'
#

CREATE TABLE topic (
  id int(10) NOT NULL auto_increment,
  fid varchar(10) default NULL,
  number int(5) default NULL,
  username varchar(15) default NULL,
  writetime varchar(20) default NULL,
  type varchar(10) default NULL,
  topicid varchar(5) default NULL,
  topic varchar(50) default NULL,
  content blob,
  renqi int(3) default '0',
  renum int(5) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'topic'
#

INSERT INTO topic VALUES (24,'10',NULL,'kiki','2003年08月02日','computer','16','re','hhhhhhhhh',0,0);
INSERT INTO topic VALUES (5,NULL,1,'kiki','08月01日 10:06','computer','16','s','s',0,0);
INSERT INTO topic VALUES (8,NULL,NULL,'kiki','2003年08月01日','computer','16','d','d',0,0);
INSERT INTO topic VALUES (9,NULL,NULL,'kiki','2003年08月01日','computer','16','c','c',0,0);
INSERT INTO topic VALUES (10,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,2);
INSERT INTO topic VALUES (11,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (12,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (13,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (14,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (15,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (16,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (17,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (18,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (19,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (20,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (21,NULL,NULL,'kiki','2003年08月01日','computer','16','ffffffff','f',0,0);
INSERT INTO topic VALUES (25,'10',NULL,'kiki','2003年08月02日','computer','16','re','fffff',0,0);