[TOC]
## 數據庫設計
~~~
DROP DATABASE IF EXISTS lost;
CREATE DATABASE lost;
use lost;
DROP TABLE IF EXISTS `think_event`;
CREATE TABLE `think_event`
(
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`user_id` int(11) COMMENT '用戶ID',
`type` varchar(10) NOT NULL COMMENT '事件類型：lost|found',
`title` varchar(50) NOT NULL COMMENT '事件標題',
`linkman` varchar(50) NOT NULL COMMENT '聯系人',
`mobile` varchar(50) NOT NULL COMMENT '聯系電話',
`create_time` int(11) COMMENT '事件發生時間',
`image_ids` varchar(500) COMMENT '關聯的圖片ID串',
`tags` varchar(500) COMMENT 'tags',
`address` varchar(500) COMMENT '事件發生的地點',
`description` TEXT COMMENT '簡要描述',
`status` int(11) COMMENT '狀態',
`delete_time` int(11) DEFAULT 0 COMMENT '刪除時間'
) ENGINE = InnoDB
DEFAULT CHARSET = utf8 COMMENT ='失物招領事件表';
DROP TABLE IF EXISTS `think_image`;
CREATE TABLE IF NOT EXISTS `think_image`
(
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主鍵id自增',
`storage` varchar(50) NOT NULL,
`path` varchar(255) NOT NULL DEFAULT '' COMMENT '路徑',
`base_url` varchar(255) NOT NULL DEFAULT '' COMMENT '圖片鏈接',
`md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '創建時間',
PRIMARY KEY (`id`)
) ENGINE = MyISAM
DEFAULT CHARSET = utf8
AUTO_INCREMENT = 1;
--
-- 表的結構 `think_user`
--
/*用戶基礎信息，記錄登陸賬號信息*/
DROP TABLE IF EXISTS `think_user`;
CREATE TABLE `think_user`
(
`id` int(10) AUTO_INCREMENT PRIMARY KEY NOT NULL,
`username` varchar(50) NOT NULL,
`user_type` varchar(50) NOT NULL DEFAULT 'user', #注冊用戶的類型，user,school,student,teacher,company
`mobile` varchar(11) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`password` varchar(32) NOT NULL,
`encrypt` varchar(10) NOT NULL,
`avator_id` int DEFAULT 0 COMMENT '頭像在image庫中的ID',
`last_login_time` int DEFAULT 0,
`last_login_ip` varchar(50) DEFAULT '',
`login_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '登錄次數',
`login_fail_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '登錄失敗次數',
`deletable` tinyint(2) NOT NULL DEFAULT 0 COMMENT '可刪除，默認不可刪除',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態，默認激活',
`delete_time` int NOT NULL DEFAULT 0,
`create_time` int NOT NULL DEFAULT 0,
`create_ip` varchar(50) NOT NULL DEFAULT ''
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;
--
-- 轉存表中的數據 `think_user`
-- password:123456
--
INSERT INTO `think_user` (`id`, `username`, `password`, `encrypt`)
VALUES (1, 'admin', 'ce9ac4724c59b5167ae89ecc345a57c9', 'Cc6bSCcc3N'),
(2, 'guest', 'ce9ac4724c59b5167ae89ecc345a57c9', 'Cc6bSCcc3N'),
(3, 'user', 'ce9ac4724c59b5167ae89ecc345a57c9', 'Cc6bSCcc3N');
~~~
## 配置數據庫連接
修改項目更目錄下的.env文件，設置DATABASE節的內容，設置正確的數據庫名和賬號、密碼信息。
> 添加一行，設置表的前綴：think_
~~~
PREFIX = think_
~~~
> 完整的.env文件如下：
```
APP_DEBUG = true
[APP]
DEFAULT_TIMEZONE = Asia/Shanghai
[DATABASE]
TYPE = mysql
HOSTNAME = 127.0.0.1
DATABASE = lost
PREFIX = think_
USERNAME = root
PASSWORD = root
HOSTPORT = 3306
CHARSET = utf8
DEBUG = true
[LANG]
default_lang = zh-cn
```
