## **2) 數據庫創建** - 表`RouteData`: 保存了所有mod路由信息. | 字段 | 數據類型 | 是否可以為空 | 主鍵 | 默認 | 附加 | 說明 | | ---------- | ---------------- | ------------ | ---- | ---- | ------ | ------------ | | id | int(10) unsigned | No | 是 | NULL | 自增長 | 該條數據ID | | modid | int(10) unsigned | No | | NULL | | 模塊ID | | cmdid | int(10) unsigned | No | | NULL | | 指令ID | | serverip | int(10) unsigned | No | | NULL | | 服務器IP地址 | | serverport | int(10) unsigned | No | | NULL | | 服務器端口 | - 表`RouteVersion`: 當前`RouteData`路由版本號，每次管理端修改某mod的路由，`RouteVersion`表中的版本號都被更新為當前時間戳 | 字段 | 數據類型 | 是否可以為空 | 主鍵 | 默認 | 附加 | | ------- | ---------------- | ------------ | ---- | ---- | ------ | | id | int(10) unsigned | No | 是 | NULL | 自增長 | | version | int(10) unsigned | No | | NULL | | - 表`RouteChange`: 每次管理端修改某mod的路由，會記錄本次對哪個mod進行修改（增、刪、改），以便指示最新的`RouteData`路由有哪些mod變更了。 | 字段 | 數據類型 | 是否可以為空 | 主鍵 | 默認 | 附加 | | ------- | ------------------- | ------------ | ---- | ---- | ------ | | id | int(10) unsigned | No | 是 | NULL | 自增長 | | modid | int(10) unsigned | No | | NULL | | | cmdid | int(10) unsigned | No | | NULL | | | version | bigint(20) unsigned | No | | NULL | | 相關創建表格的sql語句如下`lars_dns.sql` ```sql DROP DATABASE if exists lars_dns; CREATE DATABASE lars_dns; USE lars_dns; DROP TABLE IF EXISTS `RouteData`; CREATE TABLE `RouteData` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `modid` int(10) unsigned NOT NULL, `cmdid` int(10) unsigned NOT NULL, `serverip` int(10) unsigned NOT NULL, `serverport` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=116064 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `RouteVersion`; CREATE TABLE RouteVersion ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `version` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ); INSERT INTO RouteVersion(version) VALUES(0); DROP TABLE IF EXISTS `RouteChange`; CREATE TABLE RouteChange ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `modid` int(10) unsigned NOT NULL, `cmdid` int(10) unsigned NOT NULL, `version` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`) ); ``` ? 我們創建一個基礎目錄`Lars/base`來存放一些公共的工具和資源. cd到`Lars/base`, 我們`mkdir sql`， 然后將`lars_dns.sql`拷貝到`sql/`文件夾下。 然后執行創建表格 ```sql $mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \. lars_dns.sql Query OK, 0 rows affected, 1 warning (0.01 sec) Query OK, 1 row affected (0.00 sec) Database changed Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected, 1 warning (0.01 sec) Query OK, 0 rows affected (0.06 sec) Query OK, 1 row affected (0.01 sec) Query OK, 0 rows affected, 1 warning (0.01 sec) Query OK, 0 rows affected (0.13 sec) ``` --- ### 關于作者： 作者：`Aceld(劉丹冰)` mail: [danbing.at@gmail.com](mailto:danbing.at@gmail.com) github: [https://github.com/aceld](https://github.com/aceld) 原創書籍: [http://www.hmoore.net/@aceld](http://www.hmoore.net/@aceld)  >**原創聲明:未經作者允許請勿轉載, 如果轉載請注明出處**