<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>

                ![![](https://box.kancloud.cn/b898913d174861a4df73406f08689ceb_1242x1070.png)](images/screenshot_1547888775645.png) # 第一步創建三個表 創建權限表 : privilege CREATE TABLE `zuche`.`privileges` ( `id` MEDIUMINT NOT NULL AUTO_INCREMENT , `p_name` VARCHAR(30) NOT NULL COMMENT '權限名稱' , `m_name` VARCHAR(30) NOT NULL COMMENT '模塊' , `c_name` VARCHAR(15) NOT NULL COMMENT '控制器' , `a_name` VARCHAR(15) NOT NULL COMMENT '方法' , `pid` INT NOT NULL COMMENT '上級id' , `create_time` INT NOT NULL COMMENT '創建時間' , `update_time` INT NOT NULL COMMENT '修改實際' , PRIMARY KEY (`id`)) ENGINE = InnoDB; # 第二步創建角色表 創建角色表:role CREATE TABLE `zuche`.`role` ( `id` MEDIUMINT NOT NULL AUTO_INCREMENT , `role_name` VARCHAR(15) NOT NULL COMMENT '角色名字' , `privilege_id` INT NOT NULL COMMENT '權限id' , `create_time` INT NOT NULL COMMENT '創建時間' , `update_time` INT NOT NULL COMMENT '修改時間' , PRIMARY KEY (`id`), INDEX (`privilege_id`), UNIQUE (`role_name`)) ENGINE = InnoDB; # 創建用戶表 user 因為用戶表涉及每個人的邏輯,我就不寫創建Mysql代碼了 ![](https://box.kancloud.cn/0aea045add28a1d35e371a48c6a1b598_2054x458.png) ![](https://box.kancloud.cn/453a55ff968628ab0e3ae789e66269b8_1486x664.png) ![](https://box.kancloud.cn/28e4f786f300ee0b17b7fd613b2ff98b_2500x630.png) ![](https://box.kancloud.cn/e7438206057f44244cfde7199d3e84e5_1382x626.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>

                              哎呀哎呀视频在线观看