2017-03-20.sql 245 B

1234567
  1. ALTER TABLE `role_permission`
  2. ADD PRIMARY KEY (`rid`, `pid`);
  3. ALTER TABLE `role`
  4. CHANGE COLUMN `role_type` `role_type` INT(6) NOT NULL DEFAULT 1 ;
  5. INSERT INTO `role` (`id`, `role_name`, `role_type`) VALUES ('1', '超级管理员', '999999');