blog.sql

个人论坛的一个java程序

#
# Dumping data for table 'boardinfo'
#

INSERT INTO boardinfo VALUES("1", "test", "test", NULL, "0");
INSERT INTO boardinfo VALUES("4", "myblog", "学习笔记,文摘", "gutou9", "0");


#
# Table structure for table 'foruminfo'
#

CREATE TABLE foruminfo (
  msgID int(4) NOT NULL auto_increment,
  title varchar(50) default NULL,
  content text,
  firstTime datetime default NULL,
  lastTime datetime default NULL,
  author varchar(20) default NULL,