数据库结构能否给一份

[tawen]

No description provided.

[william-xue]

对哒 最好给个sql

[ahnuchen]

/*

Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50718
Source Host : localhost
Source Database : zygg8007596

Target Server Type : MySQL
Target Server Version : 50718
File Encoding : utf-8

Date: 11/11/2017 16:24:49 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

---

-- Table structure for comment

---

DROP TABLE IF EXISTS comment;
CREATE TABLE comment (
id int(11) NOT NULL AUTO_INCREMENT,
userid int(11) DEFAULT NULL,
msg_id int(11) DEFAULT NULL,
comment_message varchar(255) DEFAULT NULL,
create_time datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Table structure for diary_board

---

DROP TABLE IF EXISTS diary_board;
CREATE TABLE diary_board (
diary_list varchar(255) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
date datetime DEFAULT NULL,
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Table structure for message_board

---

DROP TABLE IF EXISTS message_board;
CREATE TABLE message_board (
message_list varchar(255) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
date datetime DEFAULT NULL,
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

-- Table structure for user_info

---

DROP TABLE IF EXISTS user_info;
CREATE TABLE user_info (
user_name varchar(255) DEFAULT NULL,
user_pwd varchar(255) DEFAULT NULL,
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;

[william-xue]

谢谢楼上