📄 messageboard_backup.sql
字号:
/*
SQLyog v3.71
Host - localhost : Database - messageboard
**************************************************************
Server version 4.1.7-nt
*/
create database if not exists `messageboard`;
use `messageboard`;
/*
Table structure for guestbook
*/
drop table if exists `guestbook`;
CREATE TABLE `guestbook` ( `MesID` int(6) NOT NULL auto_increment, `username` varchar(20) default NULL, `password` varchar(50) default NULL, `gender` varchar(10) default NULL, `email` varchar(50) default NULL, `title` varchar(50) default NULL, `content` text, `posttime` datetime default NULL, `ip` varchar(20) default NULL, `hideIP` char(2) default NULL, `firstMesID` int(6) default NULL, `lastMesID` int(6) default NULL, PRIMARY KEY (`MesID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*
Table data for messageboard.guestbook
*/
INSERT INTO `guestbook` VALUES
(9,'sd','sd','帅哥','s@k.r','测试','Good! OK! 这是留言测试! ','2005-01-02 14:01:52','127.0.0.1','Y',9,NULL),
(12,'sd','6226f7cbe59e99a90b5cef6f94f966fd','不告诉你','sd@t.k','测试','这是留言测试','2005-01-02 15:58:53','127.0.0.1','Y',12,NULL),
(15,'hai','42810cb02db3bb2cbb428af0d8b0376e','不告诉你','hai@t.r','[回复]测试','Good! \r\n \r\n \r\n---------------------------------\r\n 原主题:\r\n 这是留言测试','2005-01-02 20:50:24','127.0.0.1','',12,12),
(16,'hai','42810cb02db3bb2cbb428af0d8b0376e','不告诉你','hai@t.r','[回复]测试','Good! \r\n \r\n \r\n---------------------------------\r\n 原主题:\r\n 这是留言测试','2005-01-02 20:52:50','127.0.0.1','',12,12),
(21,'王刚','e08392bb89dedb8ed6fb298f8e729c15','不告诉你','wang@tom.com','为印度洋海啸受灾地区捐款','为印度洋海啸受灾地区捐款,奉献爱心!','2005-01-03 11:29:14','127.0.0.1','',21,NULL);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -