?? install.sql
字號(hào):
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","admin@163.com","system;guest",0,0,0);
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -