<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                # 20. 數據庫文件導入 ## 安裝數據庫 在開發完成后,導出需要用到的數據表,保存插件所在文件夾根目錄,命名為`install.sql`,在安裝的時候導入數據庫表。 你需要把表的前綴替換成 `@prefix@`,如下所示 ``` <pre class="calibre16">``` CREATE TABLE IF NOT EXISTS `@prefix@tablename` <span class="token1">(</span> <span class="token1">.</span><span class="token1">.</span><span class="token1">.</span><span class="token1">.</span><span class="token1">.</span> <span class="token1">)</span> ENGINE<span class="token">=</span>InnoDB DEFAULT CHARSET<span class="token">=</span>utf8mb4<span class="token1">;</span> ``` ``` - 手動導入方式 ``` <pre class="calibre16">``` <span class="token5">// 文件絕對路徑</span> $sql <span class="token">=</span> $this<span class="token">-</span><span class="token">></span>addon_path<span class="token1">.</span><span class="token4">'data'</span><span class="token1">.</span>DIRECTORY_SEPARATOR<span class="token1">.</span><span class="token4">'install.sql'</span><span class="token1">;</span> <span class="token5">// 寫入數據庫</span> <span class="token6">create_sql</span><span class="token1">(</span>$sql<span class="token1">)</span><span class="token1">;</span> ``` ``` ## 升級數據庫 插件所在文件夾根目錄,命名為`upgrade.sql`,在更新的時候會執行該文件。 同樣你需要把表的前綴替換成 `@prefix@` ## 演示數據數據庫文件 插件根目錄命名為:`demodata.sql`,在安裝的時候用戶勾選演示數據,即可導入演示數據。 數據庫里面的表前綴使用`@prefix@` 代替,如下 ``` <pre class="calibre16">``` insert into `@prefix@archives` values <span class="token1">(</span><span class="token3">75</span><span class="token1">,</span><span class="token3">20</span><span class="token1">,</span><span class="token3">1</span><span class="token1">,</span><span class="token3">2</span><span class="token1">,</span><span class="token4">'測試'</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">'show.html'</span><span class="token1">,</span><span class="token3">1637382374</span><span class="token1">,</span><span class="token3">1637382417</span><span class="token1">,</span><span class="token3">1637382417</span><span class="token1">,</span>NULL<span class="token1">,</span><span class="token3">0</span><span class="token1">,</span><span class="token4">'default'</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token3">0</span><span class="token1">,</span><span class="token4">'zh-cn'</span><span class="token1">,</span><span class="token4">'normal'</span><span class="token1">)</span><span class="token1">;</span> ``` ``` 效果 ![](https://img.kancloud.cn/a8/62/a862577c15d82029eec038a799b99758_799x595.png)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看