PermissionSeeder.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843
  1. <?php
  2. use Illuminate\Database\Seeder;
  3. class PermissionSeeder extends Seeder
  4. {
  5. /**
  6. * 权限相关数据填充
  7. *
  8. * Run the database seeds
  9. *
  10. * @return void
  11. */
  12. // 执行命令 php artisan db:seed --class=PermissionSeeder
  13. public function run()
  14. {
  15. /*添加默认权限组*/
  16. DB::table('roles')->insert([
  17. [
  18. 'id' => '1',
  19. 'name' => '系统管理员',
  20. 'slug' => 'admin',
  21. 'description' => '后台管理员,具有最高权限',
  22. 'level' => 1,
  23. 'sort' => 1,
  24. 'created_at' => '2016-02-16 09:52:13',
  25. 'updated_at' => '2016-02-16 09:52:13'
  26. ],
  27. [
  28. 'id' => '2',
  29. 'name' => '会员',
  30. 'slug' => 'member',
  31. 'description' => '普通会员,不可管理后台',
  32. 'level' => 1,
  33. 'sort' => 2,
  34. 'created_at' => '2016-02-16 09:52:13',
  35. 'updated_at' => '2016-02-16 09:52:13'
  36. ],
  37. [
  38. 'id' => '3',
  39. 'name' => '管理员',
  40. 'slug' => 'manager',
  41. 'description' => '管理员可以管理除全局、第三方以外所有模块',
  42. 'sort' => 3,
  43. 'level' => 1,
  44. 'created_at' => '2016-02-16 09:52:13',
  45. 'updated_at' => '2016-02-16 09:52:13'
  46. ],
  47. [
  48. 'id' => '4',
  49. 'name' => '后台运营',
  50. 'slug' => 'operator',
  51. 'description' => '运营可以管理内容、运营模块',
  52. 'level' => 1,
  53. 'sort' => 4,
  54. 'created_at' => '2016-02-16 09:52:13',
  55. 'updated_at' => '2016-02-16 09:52:13'
  56. ],
  57. ]);
  58. DB::table('permissions')->insert([
  59. [
  60. 'id' => '1',
  61. 'name' => '后台管理首页',
  62. 'slug' => 'admin.index.index',
  63. 'description' => '后台管理首页',
  64. 'created_at' => '2016-02-16 17:57:51',
  65. 'updated_at' => '2016-02-16 17:57:51'
  66. ],
  67. [
  68. 'id' => '2',
  69. 'name' => '后台用户管理',
  70. 'slug' => 'admin.user.index',
  71. 'description' => '后台用户管理',
  72. 'created_at' => '2016-02-16 17:57:51',
  73. 'updated_at' => '2016-02-16 17:57:51'
  74. ],
  75. [
  76. 'id' => '3',
  77. 'name' => '后台专家管理',
  78. 'slug' => 'admin.authentication.index',
  79. 'description' => '后台专家管理',
  80. 'created_at' => '2016-02-16 17:57:51',
  81. 'updated_at' => '2016-02-16 17:57:51'
  82. ],
  83. [
  84. 'id' => '4',
  85. 'name' => '后台讲师管理',
  86. 'slug' => 'admin.lecturer.index',
  87. 'description' => '后台讲师管理',
  88. 'created_at' => '2016-02-16 17:57:51',
  89. 'updated_at' => '2016-02-16 17:57:51'
  90. ],
  91. [
  92. 'id' => '5',
  93. 'name' => '后台问题管理',
  94. 'slug' => 'admin.question.index',
  95. 'description' => '后台问题管理',
  96. 'created_at' => '2016-02-16 17:57:51',
  97. 'updated_at' => '2016-02-16 17:57:51'
  98. ],
  99. [
  100. 'id' => '6',
  101. 'name' => '后台回答管理',
  102. 'slug' => 'admin.answer.index',
  103. 'description' => '后台回答管理',
  104. 'created_at' => '2016-02-16 17:57:51',
  105. 'updated_at' => '2016-02-16 17:57:51'
  106. ],
  107. [
  108. 'id' => '7',
  109. 'name' => '后台文章管理',
  110. 'slug' => 'admin.article.index',
  111. 'description' => '后台文章管理',
  112. 'created_at' => '2016-02-16 17:57:51',
  113. 'updated_at' => '2016-02-16 17:57:51'
  114. ],
  115. [
  116. 'id' => '8',
  117. 'name' => '后台评论管理',
  118. 'slug' => 'admin.comment.index',
  119. 'description' => '后台评论管理',
  120. 'created_at' => '2016-02-16 17:57:51',
  121. 'updated_at' => '2016-02-16 17:57:51'
  122. ],
  123. [
  124. 'id' => '9',
  125. 'name' => '后台标签管理',
  126. 'slug' => 'admin.tag.index',
  127. 'description' => '后台标签管理',
  128. 'created_at' => '2016-02-16 17:57:51',
  129. 'updated_at' => '2016-02-16 17:57:51'
  130. ],
  131. [
  132. 'id' => '10',
  133. 'name' => '后台分类管理',
  134. 'slug' => 'admin.category.index',
  135. 'description' => '后台分类管理',
  136. 'created_at' => '2016-02-16 17:57:51',
  137. 'updated_at' => '2016-02-16 17:57:51'
  138. ],
  139. [
  140. 'id' => '11',
  141. 'name' => '后台公告管理',
  142. 'slug' => 'admin.notice.index',
  143. 'description' => '后台公告管理',
  144. 'created_at' => '2016-02-16 17:57:51',
  145. 'updated_at' => '2016-02-16 17:57:51'
  146. ],
  147. [
  148. 'id' => '12',
  149. 'name' => '后台首页推荐管理',
  150. 'slug' => 'admin.recommendation.index',
  151. 'description' => '后台首页推荐管理',
  152. 'created_at' => '2016-02-16 17:57:51',
  153. 'updated_at' => '2016-02-16 17:57:51'
  154. ],
  155. [
  156. 'id' => '13',
  157. 'name' => '后台积分商城管理',
  158. 'slug' => 'admin.goods.index',
  159. 'description' => '后台积分商城管理',
  160. 'created_at' => '2016-02-16 17:57:51',
  161. 'updated_at' => '2016-02-16 17:57:51'
  162. ],
  163. [
  164. 'id' => '14',
  165. 'name' => '后台兑换记录管理',
  166. 'slug' => 'admin.exchange.index',
  167. 'description' => '后台兑换记录管理',
  168. 'created_at' => '2016-02-16 17:57:51',
  169. 'updated_at' => '2016-02-16 17:57:51'
  170. ],
  171. [
  172. 'id' => '15',
  173. 'name' => '后台友情链接管理',
  174. 'slug' => 'admin.friendshipLink.index',
  175. 'description' => '后台友情链接管理',
  176. 'created_at' => '2016-02-16 17:57:51',
  177. 'updated_at' => '2016-02-16 17:57:51'
  178. ],
  179. [
  180. 'id' => '16',
  181. 'name' => '后台积分管理',
  182. 'slug' => 'admin.credit.index',
  183. 'description' => '后台积分管理',
  184. 'created_at' => '2016-02-16 17:57:51',
  185. 'updated_at' => '2016-02-16 17:57:51'
  186. ],
  187. [
  188. 'id' => '18',
  189. 'name' => '后台站点设置',
  190. 'slug' => 'admin.setting.website',
  191. 'description' => '后台站点设置',
  192. 'created_at' => '2016-02-16 17:57:51',
  193. 'updated_at' => '2016-02-16 17:57:51'
  194. ],
  195. [
  196. 'id' => '19',
  197. 'name' => '后台邮箱设置',
  198. 'slug' => 'admin.setting.email',
  199. 'description' => '后台邮箱设置',
  200. 'created_at' => '2016-02-16 17:57:51',
  201. 'updated_at' => '2016-02-16 17:57:51'
  202. ],
  203. [
  204. 'id' => '20',
  205. 'name' => '后台注册设置',
  206. 'slug' => 'admin.setting.register',
  207. 'description' => '后台注册设置',
  208. 'created_at' => '2016-02-16 17:57:51',
  209. 'updated_at' => '2016-02-16 17:57:51'
  210. ],
  211. [
  212. 'id' => '21',
  213. 'name' => '后台时间设置',
  214. 'slug' => 'admin.setting.time',
  215. 'description' => '后台时间设置',
  216. 'created_at' => '2016-02-16 17:57:51',
  217. 'updated_at' => '2016-02-16 17:57:51'
  218. ],
  219. [
  220. 'id' => '22',
  221. 'name' => '后台防灌水设置',
  222. 'slug' => 'admin.setting.irrigation',
  223. 'description' => '后台防灌水设置',
  224. 'created_at' => '2016-02-16 17:57:51',
  225. 'updated_at' => '2016-02-16 17:57:51'
  226. ],
  227. [
  228. 'id' => '23',
  229. 'name' => '后台积分设置',
  230. 'slug' => 'admin.setting.credits',
  231. 'description' => '后台积分设置',
  232. 'created_at' => '2016-02-16 17:57:51',
  233. 'updated_at' => '2016-02-16 17:57:51'
  234. ],
  235. [
  236. 'id' => '24',
  237. 'name' => '后台SEO设置',
  238. 'slug' => 'admin.setting.seo',
  239. 'description' => '后台SEO设置',
  240. 'created_at' => '2016-02-16 17:57:51',
  241. 'updated_at' => '2016-02-16 17:57:51'
  242. ],
  243. [
  244. 'id' => '25',
  245. 'name' => '后台功能定制',
  246. 'slug' => 'admin.setting.custom',
  247. 'description' => '后台功能定制',
  248. 'created_at' => '2016-02-16 17:57:51',
  249. 'updated_at' => '2016-02-16 17:57:51'
  250. ],
  251. [
  252. 'id' => '26',
  253. 'name' => '后台附件设置',
  254. 'slug' => 'admin.setting.attach',
  255. 'description' => '后台附件设置',
  256. 'created_at' => '2016-02-16 17:57:51',
  257. 'updated_at' => '2016-02-16 17:57:51'
  258. ],
  259. [
  260. 'id' => '27',
  261. 'name' => '后台系统工具',
  262. 'slug' => 'admin.system.index',
  263. 'description' => '后台系统工具',
  264. 'created_at' => '2016-02-16 17:57:51',
  265. 'updated_at' => '2016-02-16 17:57:51'
  266. ],
  267. [
  268. 'id' => '28',
  269. 'name' => '后台xunSearch',
  270. 'slug' => 'admin.setting.xunSearch',
  271. 'description' => '后台xunSearch',
  272. 'created_at' => '2016-02-16 17:57:51',
  273. 'updated_at' => '2016-02-16 17:57:51'
  274. ],
  275. [
  276. 'id' => '29',
  277. 'name' => '后台一键登录',
  278. 'slug' => 'admin.setting.oauth',
  279. 'description' => '后台一键登录',
  280. 'created_at' => '2016-02-16 17:57:51',
  281. 'updated_at' => '2016-02-16 17:57:51'
  282. ],
  283. [
  284. 'id' => '31',
  285. 'name' => '后台极验证',
  286. 'slug' => 'admin.setting.geetest',
  287. 'description' => '后台极验证',
  288. 'created_at' => '2016-02-16 17:57:51',
  289. 'updated_at' => '2016-02-16 17:57:51'
  290. ],
  291. [
  292. 'id' => '32',
  293. 'name' => '后台短信整合',
  294. 'slug' => 'admin.setting.sms',
  295. 'description' => '后台短信整合',
  296. 'created_at' => '2016-02-16 17:57:51',
  297. 'updated_at' => '2016-02-16 17:57:51'
  298. ],
  299. [
  300. 'id' => '33',
  301. 'name' => '后台IP黑名单管理',
  302. 'slug' => 'admin.banIp.index',
  303. 'description' => '网站IP黑名单管理',
  304. 'created_at' => '2016-02-16 17:57:51',
  305. 'updated_at' => '2016-02-16 17:57:51'
  306. ],
  307. [
  308. 'id' => '35',
  309. 'name' => '后台操作日志',
  310. 'slug' => 'admin.operationLog.index',
  311. 'description' => '后台操作日志',
  312. 'created_at' => '2016-02-16 17:57:51',
  313. 'updated_at' => '2016-02-16 17:57:51'
  314. ],
  315. ]);
  316. DB::table('permission_role')->insert([
  317. // 超级管理员权限
  318. [
  319. 'id' => '1',
  320. 'permission_id' => '1',
  321. 'role_id' => '1',
  322. 'created_at' => '2016-02-16 17:37:51',
  323. 'updated_at' => '2016-04-16 17:57:51'
  324. ],
  325. [
  326. 'id' => '2',
  327. 'permission_id' => '2',
  328. 'role_id' => '1',
  329. 'created_at' => '2016-02-16 17:37:51',
  330. 'updated_at' => '2016-04-16 17:57:51'
  331. ],
  332. [
  333. 'id' => '3',
  334. 'permission_id' => '3',
  335. 'role_id' => '1',
  336. 'created_at' => '2016-02-16 17:37:51',
  337. 'updated_at' => '2016-04-16 17:57:51'
  338. ],
  339. [
  340. 'id' => '4',
  341. 'permission_id' => '4',
  342. 'role_id' => '1',
  343. 'created_at' => '2016-02-16 17:37:51',
  344. 'updated_at' => '2016-04-16 17:57:51'
  345. ],
  346. [
  347. 'id' => '5',
  348. 'permission_id' => '5',
  349. 'role_id' => '1',
  350. 'created_at' => '2016-02-16 17:37:51',
  351. 'updated_at' => '2016-04-16 17:57:51'
  352. ],
  353. [
  354. 'id' => '6',
  355. 'permission_id' => '6',
  356. 'role_id' => '1',
  357. 'created_at' => '2016-02-16 17:37:51',
  358. 'updated_at' => '2016-04-16 17:57:51'
  359. ],
  360. [
  361. 'id' => '7',
  362. 'permission_id' => '7',
  363. 'role_id' => '1',
  364. 'created_at' => '2016-02-16 17:37:51',
  365. 'updated_at' => '2016-04-16 17:57:51'
  366. ],
  367. [
  368. 'id' => '8',
  369. 'permission_id' => '8',
  370. 'role_id' => '1',
  371. 'created_at' => '2016-02-16 17:37:51',
  372. 'updated_at' => '2016-04-16 17:57:51'
  373. ],
  374. [
  375. 'id' => '9',
  376. 'permission_id' => '9',
  377. 'role_id' => '1',
  378. 'created_at' => '2016-02-16 17:37:51',
  379. 'updated_at' => '2016-04-16 17:57:51'
  380. ],
  381. [
  382. 'id' => '10',
  383. 'permission_id' => '10',
  384. 'role_id' => '1',
  385. 'created_at' => '2016-02-16 17:37:51',
  386. 'updated_at' => '2016-04-16 17:57:51'
  387. ],
  388. [
  389. 'id' => '11',
  390. 'permission_id' => '11',
  391. 'role_id' => '1',
  392. 'created_at' => '2016-02-16 17:37:51',
  393. 'updated_at' => '2016-04-16 17:57:51'
  394. ],
  395. [
  396. 'id' => '12',
  397. 'permission_id' => '12',
  398. 'role_id' => '1',
  399. 'created_at' => '2016-02-16 17:37:51',
  400. 'updated_at' => '2016-04-16 17:57:51'
  401. ],
  402. [
  403. 'id' => '13',
  404. 'permission_id' => '13',
  405. 'role_id' => '1',
  406. 'created_at' => '2016-02-16 17:37:51',
  407. 'updated_at' => '2016-04-16 17:57:51'
  408. ],
  409. [
  410. 'id' => '14',
  411. 'permission_id' => '14',
  412. 'role_id' => '1',
  413. 'created_at' => '2016-02-16 17:37:51',
  414. 'updated_at' => '2016-04-16 17:57:51'
  415. ],
  416. [
  417. 'id' => '15',
  418. 'permission_id' => '15',
  419. 'role_id' => '1',
  420. 'created_at' => '2016-02-16 17:37:51',
  421. 'updated_at' => '2016-04-16 17:57:51'
  422. ],
  423. [
  424. 'id' => '16',
  425. 'permission_id' => '16',
  426. 'role_id' => '1',
  427. 'created_at' => '2016-02-16 17:37:51',
  428. 'updated_at' => '2016-04-16 17:57:51'
  429. ],
  430. [
  431. 'id' => '17',
  432. 'permission_id' => '17',
  433. 'role_id' => '1',
  434. 'created_at' => '2016-02-16 17:37:51',
  435. 'updated_at' => '2016-04-16 17:57:51'
  436. ],
  437. [
  438. 'id' => '18',
  439. 'permission_id' => '18',
  440. 'role_id' => '1',
  441. 'created_at' => '2016-02-16 17:37:51',
  442. 'updated_at' => '2016-04-16 17:57:51'
  443. ],
  444. [
  445. 'id' => '19',
  446. 'permission_id' => '19',
  447. 'role_id' => '1',
  448. 'created_at' => '2016-02-16 17:37:51',
  449. 'updated_at' => '2016-04-16 17:57:51'
  450. ],
  451. [
  452. 'id' => '20',
  453. 'permission_id' => '20',
  454. 'role_id' => '1',
  455. 'created_at' => '2016-02-16 17:37:51',
  456. 'updated_at' => '2016-04-16 17:57:51'
  457. ],
  458. [
  459. 'id' => '21',
  460. 'permission_id' => '21',
  461. 'role_id' => '1',
  462. 'created_at' => '2016-02-16 17:37:51',
  463. 'updated_at' => '2016-04-16 17:57:51'
  464. ],
  465. [
  466. 'id' => '22',
  467. 'permission_id' => '22',
  468. 'role_id' => '1',
  469. 'created_at' => '2016-02-16 17:37:51',
  470. 'updated_at' => '2016-04-16 17:57:51'
  471. ],
  472. [
  473. 'id' => '23',
  474. 'permission_id' => '23',
  475. 'role_id' => '1',
  476. 'created_at' => '2016-02-16 17:37:51',
  477. 'updated_at' => '2016-04-16 17:57:51'
  478. ],
  479. [
  480. 'id' => '24',
  481. 'permission_id' => '24',
  482. 'role_id' => '1',
  483. 'created_at' => '2016-02-16 17:37:51',
  484. 'updated_at' => '2016-04-16 17:57:51'
  485. ],
  486. [
  487. 'id' => '25',
  488. 'permission_id' => '25',
  489. 'role_id' => '1',
  490. 'created_at' => '2016-02-16 17:37:51',
  491. 'updated_at' => '2016-04-16 17:57:51'
  492. ],
  493. [
  494. 'id' => '26',
  495. 'permission_id' => '26',
  496. 'role_id' => '1',
  497. 'created_at' => '2016-02-16 17:37:51',
  498. 'updated_at' => '2016-04-16 17:57:51'
  499. ],
  500. [
  501. 'id' => '27',
  502. 'permission_id' => '27',
  503. 'role_id' => '1',
  504. 'created_at' => '2016-02-16 17:37:51',
  505. 'updated_at' => '2016-04-16 17:57:51'
  506. ],
  507. [
  508. 'id' => '28',
  509. 'permission_id' => '28',
  510. 'role_id' => '1',
  511. 'created_at' => '2016-02-16 17:37:51',
  512. 'updated_at' => '2016-04-16 17:57:51'
  513. ],
  514. [
  515. 'id' => '29',
  516. 'permission_id' => '29',
  517. 'role_id' => '1',
  518. 'created_at' => '2016-02-16 17:37:51',
  519. 'updated_at' => '2016-04-16 17:57:51'
  520. ],
  521. [
  522. 'id' => '30',
  523. 'permission_id' => '30',
  524. 'role_id' => '1',
  525. 'created_at' => '2016-02-16 17:37:51',
  526. 'updated_at' => '2016-04-16 17:57:51'
  527. ],
  528. [
  529. 'id' => '31',
  530. 'permission_id' => '31',
  531. 'role_id' => '1',
  532. 'created_at' => '2016-02-16 17:37:51',
  533. 'updated_at' => '2016-04-16 17:57:51'
  534. ],
  535. [
  536. 'id' => '32',
  537. 'permission_id' => '32',
  538. 'role_id' => '1',
  539. 'created_at' => '2016-02-16 17:37:51',
  540. 'updated_at' => '2016-04-16 17:57:51'
  541. ],
  542. // 管理员权限
  543. [
  544. 'id' => '33',
  545. 'permission_id' => '1',
  546. 'role_id' => '3',
  547. 'created_at' => '2016-02-16 17:37:51',
  548. 'updated_at' => '2016-04-16 17:57:51'
  549. ],
  550. [
  551. 'id' => '34',
  552. 'permission_id' => '2',
  553. 'role_id' => '3',
  554. 'created_at' => '2016-02-16 17:37:51',
  555. 'updated_at' => '2016-04-16 17:57:51'
  556. ],
  557. [
  558. 'id' => '35',
  559. 'permission_id' => '3',
  560. 'role_id' => '3',
  561. 'created_at' => '2016-02-16 17:37:51',
  562. 'updated_at' => '2016-04-16 17:57:51'
  563. ],
  564. [
  565. 'id' => '36',
  566. 'permission_id' => '4',
  567. 'role_id' => '3',
  568. 'created_at' => '2016-02-16 17:37:51',
  569. 'updated_at' => '2016-04-16 17:57:51'
  570. ],
  571. [
  572. 'id' => '37',
  573. 'permission_id' => '5',
  574. 'role_id' => '3',
  575. 'created_at' => '2016-02-16 17:37:51',
  576. 'updated_at' => '2016-04-16 17:57:51'
  577. ],
  578. [
  579. 'id' => '38',
  580. 'permission_id' => '6',
  581. 'role_id' => '3',
  582. 'created_at' => '2016-02-16 17:37:51',
  583. 'updated_at' => '2016-04-16 17:57:51'
  584. ],
  585. [
  586. 'id' => '39',
  587. 'permission_id' => '7',
  588. 'role_id' => '3',
  589. 'created_at' => '2016-02-16 17:37:51',
  590. 'updated_at' => '2016-04-16 17:57:51'
  591. ],
  592. [
  593. 'id' => '40',
  594. 'permission_id' => '8',
  595. 'role_id' => '3',
  596. 'created_at' => '2016-02-16 17:37:51',
  597. 'updated_at' => '2016-04-16 17:57:51'
  598. ],
  599. [
  600. 'id' => '41',
  601. 'permission_id' => '9',
  602. 'role_id' => '3',
  603. 'created_at' => '2016-02-16 17:37:51',
  604. 'updated_at' => '2016-04-16 17:57:51'
  605. ],
  606. [
  607. 'id' => '42',
  608. 'permission_id' => '10',
  609. 'role_id' => '3',
  610. 'created_at' => '2016-02-16 17:37:51',
  611. 'updated_at' => '2016-04-16 17:57:51'
  612. ],
  613. [
  614. 'id' => '43',
  615. 'permission_id' => '11',
  616. 'role_id' => '3',
  617. 'created_at' => '2016-02-16 17:37:51',
  618. 'updated_at' => '2016-04-16 17:57:51'
  619. ],
  620. [
  621. 'id' => '44',
  622. 'permission_id' => '12',
  623. 'role_id' => '3',
  624. 'created_at' => '2016-02-16 17:37:51',
  625. 'updated_at' => '2016-04-16 17:57:51'
  626. ],
  627. [
  628. 'id' => '45',
  629. 'permission_id' => '13',
  630. 'role_id' => '3',
  631. 'created_at' => '2016-02-16 17:37:51',
  632. 'updated_at' => '2016-04-16 17:57:51'
  633. ],
  634. [
  635. 'id' => '46',
  636. 'permission_id' => '14',
  637. 'role_id' => '3',
  638. 'created_at' => '2016-02-16 17:37:51',
  639. 'updated_at' => '2016-04-16 17:57:51'
  640. ],
  641. [
  642. 'id' => '47',
  643. 'permission_id' => '15',
  644. 'role_id' => '3',
  645. 'created_at' => '2016-02-16 17:37:51',
  646. 'updated_at' => '2016-04-16 17:57:51'
  647. ],
  648. [
  649. 'id' => '48',
  650. 'permission_id' => '16',
  651. 'role_id' => '3',
  652. 'created_at' => '2016-02-16 17:37:51',
  653. 'updated_at' => '2016-04-16 17:57:51'
  654. ],
  655. [
  656. 'id' => '49',
  657. 'permission_id' => '17',
  658. 'role_id' => '3',
  659. 'created_at' => '2016-02-16 17:37:51',
  660. 'updated_at' => '2016-04-16 17:57:51'
  661. ],
  662. // 运营人员权限
  663. [
  664. 'id' => '50',
  665. 'permission_id' => '1',
  666. 'role_id' => '4',
  667. 'created_at' => '2016-02-16 17:37:51',
  668. 'updated_at' => '2016-04-16 17:57:51'
  669. ],
  670. [
  671. 'id' => '51',
  672. 'permission_id' => '5',
  673. 'role_id' => '4',
  674. 'created_at' => '2016-02-16 17:37:51',
  675. 'updated_at' => '2016-04-16 17:57:51'
  676. ],
  677. [
  678. 'id' => '52',
  679. 'permission_id' => '6',
  680. 'role_id' => '4',
  681. 'created_at' => '2016-02-16 17:37:51',
  682. 'updated_at' => '2016-04-16 17:57:51'
  683. ],
  684. [
  685. 'id' => '53',
  686. 'permission_id' => '7',
  687. 'role_id' => '4',
  688. 'created_at' => '2016-02-16 17:37:51',
  689. 'updated_at' => '2016-04-16 17:57:51'
  690. ],
  691. [
  692. 'id' => '54',
  693. 'permission_id' => '8',
  694. 'role_id' => '4',
  695. 'created_at' => '2016-02-16 17:37:51',
  696. 'updated_at' => '2016-04-16 17:57:51'
  697. ],
  698. [
  699. 'id' => '55',
  700. 'permission_id' => '9',
  701. 'role_id' => '4',
  702. 'created_at' => '2016-02-16 17:37:51',
  703. 'updated_at' => '2016-04-16 17:57:51'
  704. ],
  705. [
  706. 'id' => '56',
  707. 'permission_id' => '10',
  708. 'role_id' => '4',
  709. 'created_at' => '2016-02-16 17:37:51',
  710. 'updated_at' => '2016-04-16 17:57:51'
  711. ],
  712. [
  713. 'id' => '57',
  714. 'permission_id' => '11',
  715. 'role_id' => '4',
  716. 'created_at' => '2016-02-16 17:37:51',
  717. 'updated_at' => '2016-04-16 17:57:51'
  718. ],
  719. [
  720. 'id' => '58',
  721. 'permission_id' => '12',
  722. 'role_id' => '4',
  723. 'created_at' => '2016-02-16 17:37:51',
  724. 'updated_at' => '2016-04-16 17:57:51'
  725. ],
  726. [
  727. 'id' => '59',
  728. 'permission_id' => '13',
  729. 'role_id' => '4',
  730. 'created_at' => '2016-02-16 17:37:51',
  731. 'updated_at' => '2016-04-16 17:57:51'
  732. ],
  733. [
  734. 'id' => '60',
  735. 'permission_id' => '14',
  736. 'role_id' => '4',
  737. 'created_at' => '2016-02-16 17:37:51',
  738. 'updated_at' => '2016-04-16 17:57:51'
  739. ],
  740. [
  741. 'id' => '61',
  742. 'permission_id' => '15',
  743. 'role_id' => '4',
  744. 'created_at' => '2016-02-16 17:37:51',
  745. 'updated_at' => '2016-04-16 17:57:51'
  746. ],
  747. // 超级管理员权限
  748. [
  749. 'id' => '62',
  750. 'permission_id' => '33',
  751. 'role_id' => '1',
  752. 'created_at' => '2016-02-16 17:37:51',
  753. 'updated_at' => '2016-04-16 17:57:51'
  754. ],
  755. [
  756. 'id' => '63',
  757. 'permission_id' => '34',
  758. 'role_id' => '1',
  759. 'created_at' => '2016-02-16 17:37:51',
  760. 'updated_at' => '2016-04-16 17:57:51'
  761. ],
  762. [
  763. 'id' => '64',
  764. 'permission_id' => '35',
  765. 'role_id' => '1',
  766. 'created_at' => '2016-02-16 17:37:51',
  767. 'updated_at' => '2016-04-16 17:57:51'
  768. ],
  769. ]);
  770. // 权限表中新增后台草稿管理
  771. DB::table('permissions')->insert([
  772. [
  773. 'id' => '36',
  774. 'name' => '后台草稿管理',
  775. 'slug' => 'admin.draft.index',
  776. 'description' => '后台草稿管理',
  777. 'created_at' => '2016-02-16 17:57:51',
  778. 'updated_at' => '2016-02-16 17:57:51'
  779. ],
  780. [
  781. 'id' => '37',
  782. 'name' => '后台举报管理',
  783. 'slug' => 'admin.report.index',
  784. 'description' => '后台举报管理',
  785. 'created_at' => '2016-02-16 17:57:51',
  786. 'updated_at' => '2016-02-16 17:57:51'
  787. ]
  788. ]);
  789. // 添加超级管理员、管理员、运营人员草稿管理权限
  790. DB::table('permission_role')->insert([
  791. [
  792. 'id' => '65',
  793. 'permission_id' => '36',
  794. 'role_id' => '1',
  795. 'created_at' => '2016-02-16 17:37:51',
  796. 'updated_at' => '2016-04-16 17:57:51'
  797. ],
  798. [
  799. 'id' => '66',
  800. 'permission_id' => '36',
  801. 'role_id' => '3',
  802. 'created_at' => '2016-02-16 17:37:51',
  803. 'updated_at' => '2016-04-16 17:57:51'
  804. ],
  805. [
  806. 'id' => '67',
  807. 'permission_id' => '36',
  808. 'role_id' => '4',
  809. 'created_at' => '2016-02-16 17:37:51',
  810. 'updated_at' => '2016-04-16 17:57:51'
  811. ],
  812. [
  813. 'id' => '68',
  814. 'permission_id' => '37',
  815. 'role_id' => '1',
  816. 'created_at' => '2016-02-16 17:37:51',
  817. 'updated_at' => '2016-04-16 17:57:51'
  818. ],
  819. [
  820. 'id' => '69',
  821. 'permission_id' => '37',
  822. 'role_id' => '3',
  823. 'created_at' => '2016-02-16 17:37:51',
  824. 'updated_at' => '2016-04-16 17:57:51'
  825. ],
  826. [
  827. 'id' => '70',
  828. 'permission_id' => '37',
  829. 'role_id' => '4',
  830. 'created_at' => '2016-02-16 17:37:51',
  831. 'updated_at' => '2016-04-16 17:57:51'
  832. ]
  833. ]);
  834. }
  835. }