install.sql

来自「本程序采用Struts结构开发一个小型的BBS论坛 ,论坛包括用户注册与登陆,主」· SQL 代码 · 共 48 行

DROP Table `users`;

DROP Table `board`;

DROP Table `bbs`;

CREATE TABLE `users` (
  `ID` int(11) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  `role` varchar(50) default NULL,
  `topics` int(11) default NULL,
  `reverts` int(11) default NULL,
  `grades` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


CREATE TABLE `board` (
  `ID` int(11) NOT NULL auto_increment,
  `boardname` varchar(50) default NULL,
  `parentID` int(11) default NULL,
  `describes` varchar(100) default NULL,
  `master` varchar(50) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


CREATE TABLE `bbs` (
  `ID` int(11) NOT NULL auto_increment,
  `topicID` int(11) default NULL,
  `parentID` int(11) default NULL,
  `username` varchar(50) default NULL,
  `topic` varchar(100) default NULL,
  `body` blob,
  `datetime` datetime default NULL,
  `reverts` int(11) default NULL,
  `hits` int(11) default NULL,
  `child` int(11) default NULL,
  `IP` varchar(40) default NULL,
  `image` varchar(100) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


INSERT INTO users VALUES (0,"admin","21232F297A57A5A743894A0E4A801FC3","[e-mail]","system;guest",0,0,0);