加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
db-data.sql 42.77 KB
一键复制 编辑 原始数据 按行查看 历史
dungang 提交于 2019-01-17 17:20 . 添加会议邮件通知
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 10.1.19-MariaDB - mariadb.org binary distribution
-- 服务器操作系统: Win32
-- HeidiSQL 版本: 9.5.0.5453
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 正在导出表 geetask.auth_assignment 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `auth_assignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_assignment` ENABLE KEYS */;
-- 正在导出表 geetask.auth_item 的数据:~227 rows (大约)
/*!40000 ALTER TABLE `auth_item` DISABLE KEYS */;
INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
('/ac-route/create', 4, 'ac route create', NULL, NULL, 1543224292, 1543224292),
('/ac-route/index', 4, 'ac route index', NULL, NULL, 1543224289, 1543224289),
('/ac-route/update', 4, 'ac route update', NULL, NULL, 1544087957, 1544087957),
('/ac-route/view', 4, 'ac route view', NULL, NULL, 1543224304, 1543224304),
('/aliyun-log/default/setting', 4, 'aliyun log default setting', NULL, NULL, 1543812158, 1543812158),
('/app-module/index', 4, 'app module index', NULL, NULL, 1543222003, 1543222003),
('/app-module/update', 4, 'app module update', NULL, NULL, 1544087093, 1544087093),
('/app-module/view', 4, 'app module view', NULL, NULL, 1544087941, 1544087941),
('/auth-permission/create', 4, 'auth permission create', NULL, NULL, 1543225416, 1543225416),
('/auth-permission/index', 4, 'auth permission index', NULL, NULL, 1543225066, 1543225066),
('/auth-permission/update', 4, 'auth permission update', NULL, NULL, 1543310118, 1543310118),
('/auth-role/create', 4, 'auth role create', NULL, NULL, 1543387986, 1543387986),
('/auth-role/index', 4, 'auth role index', NULL, NULL, 1543225064, 1543225064),
('/auth-role/permission', 4, 'auth role permission', NULL, NULL, 1543570277, 1543570277),
('/auth-role/update', 4, 'auth role update', NULL, NULL, 1543288315, 1543288315),
('/auth-rule/create', 4, 'auth rule create', NULL, NULL, 1543225072, 1543225072),
('/auth-rule/index', 4, 'auth rule index', NULL, NULL, 1543225069, 1543225069),
('/auth-rule/update', 4, 'auth rule update', NULL, NULL, 1543309941, 1543309941),
('/auth-rule/view', 4, 'auth rule view', NULL, NULL, 1543309946, 1543309946),
('/backlog/acceptance/create', 4, 'backlog acceptance create', NULL, NULL, 1543457417, 1543457417),
('/backlog/acceptance/index', 4, 'backlog acceptance index', NULL, NULL, 1543457223, 1543457223),
('/backlog/default/create', 4, 'backlog default create', NULL, NULL, 1543397576, 1543397576),
('/backlog/default/index', 4, 'backlog default index', NULL, NULL, 1543397160, 1543397160),
('/backlog/default/trans', 4, 'backlog default trans', NULL, NULL, 1544435556, 1544435556),
('/backlog/default/update', 4, 'backlog default update', NULL, NULL, 1547446324, 1547446324),
('/backlog/default/view', 4, 'backlog default view', NULL, NULL, 1544435473, 1544435473),
('/change/default/create', 4, 'change default create', NULL, NULL, 1543389913, 1543389913),
('/change/default/index', 4, 'change default index', NULL, NULL, 1543388974, 1543388974),
('/event-handler/create', 4, 'event handler create', NULL, NULL, 1543392895, 1543392895),
('/event-handler/index', 4, 'event handler index', NULL, NULL, 1543392890, 1543392890),
('/event-handler/update', 4, 'event handler update', NULL, NULL, 1543549693, 1543549693),
('/event/create', 4, 'event create', NULL, NULL, 1543370011, 1543370011),
('/event/index', 4, 'event index', NULL, NULL, 1543370008, 1543370008),
('/event/update', 4, 'event update', NULL, NULL, 1543548211, 1543548211),
('/im-robot/create', 4, 'im robot create', NULL, NULL, 1543400043, 1543400043),
('/im-robot/index', 4, 'im robot index', NULL, NULL, 1543392062, 1543392062),
('/im-robot/update', 4, 'im robot update', NULL, NULL, 1543462272, 1543462272),
('/link/default/create', 4, 'link default create', NULL, NULL, 1546506744, 1546506744),
('/link/default/index', 4, 'link default index', NULL, NULL, 1546506685, 1546506685),
('/link/default/view', 4, 'link default view', NULL, NULL, 1546507350, 1546507350),
('/meet/default/create', 4, 'meet default create', NULL, NULL, 1543388471, 1543388471),
('/meet/default/delete', 4, 'meet default delete', NULL, NULL, 1543562135, 1543562135),
('/meet/default/index', 4, 'meet default index', NULL, NULL, 1543388350, 1543388350),
('/meet/default/update', 4, 'meet default update', NULL, NULL, 1543567793, 1543567793),
('/meet/default/view', 4, 'meet default view', NULL, NULL, 1543561947, 1543561947),
('/member/default/create', 4, 'member default create', NULL, NULL, 1543387712, 1543387712),
('/member/default/delete', 4, 'member default delete', NULL, NULL, 1543569831, 1543569831),
('/member/default/index', 4, 'member default index', NULL, NULL, 1543387160, 1543387160),
('/member/default/update', 4, 'member default update', NULL, NULL, 1543399855, 1543399855),
('/member/default/view', 4, 'member default view', NULL, NULL, 1543563100, 1543563100),
('/myproject/default/create', 4, 'myproject default create', NULL, NULL, 1543455548, 1543455548),
('/myproject/default/index', 4, 'myproject default index', NULL, NULL, 1543455189, 1543455189),
('/plan/default/index', 4, 'plan default index', NULL, NULL, 1543237893, 1543237893),
('/project/create', 4, 'project create', NULL, NULL, 1543239722, 1543239722),
('/project/index', 4, 'project index', NULL, NULL, 1543239549, 1543239549),
('/project/space', 4, 'project space', NULL, NULL, 1543371051, 1543371051),
('/project/update', 4, 'project update', NULL, NULL, 1543310102, 1543310102),
('/project/view', 4, 'project view', NULL, NULL, 1543310095, 1543310095),
('/robot-message/create', 4, 'robot message create', NULL, NULL, 1543975504, 1543975504),
('/robot-message/index', 4, 'robot message index', NULL, NULL, 1543392356, 1543392356),
('/robot-message/update', 4, 'robot message update', NULL, NULL, 1543976189, 1543976189),
('/robot-message/view', 4, 'robot message view', NULL, NULL, 1543976876, 1543976876),
('/robot/default/create', 4, 'robot default create', NULL, NULL, 1543391518, 1543391518),
('/robot/default/index', 4, 'robot default index', NULL, NULL, 1543391351, 1543391351),
('/robot/default/update', 4, 'robot default update', NULL, NULL, 1543462308, 1543462308),
('/role/create', 4, 'role create', NULL, NULL, 1543288176, 1543288176),
('/role/index', 4, 'role index', NULL, NULL, 1543288172, 1543288172),
('/role/permission', 4, 'role permission', NULL, NULL, 1543288992, 1543288992),
('/role/update', 4, 'role update', NULL, NULL, 1543288233, 1543288233),
('/setting/create', 4, 'setting create', NULL, NULL, 1547621358, 1547621358),
('/setting/index', 4, 'setting index', NULL, NULL, 1547621354, 1547621354),
('/setting/update', 4, 'setting update', NULL, NULL, 1547714528, 1547714528),
('/site/index', 4, 'site index', NULL, NULL, 1543207656, 1543207656),
('/space/default/create', 4, 'space default create', NULL, NULL, 1543377197, 1543377197),
('/space/default/index', 4, 'space default index', NULL, NULL, 1543375474, 1543375474),
('/space/default/update', 4, 'space default update', NULL, NULL, 1543477938, 1543477938),
('/sprint/default/create', 4, 'sprint default create', NULL, NULL, 1543242482, 1543242482),
('/sprint/default/delete', 4, 'sprint default delete', NULL, NULL, 1543459132, 1543459132),
('/sprint/default/index', 4, 'sprint default index', NULL, NULL, 1543242478, 1543242478),
('/sprint/default/update', 4, 'sprint default update', NULL, NULL, 1543415054, 1543415054),
('/sprint/default/view', 4, 'sprint default view', NULL, NULL, 1543458272, 1543458272),
('/sprint/story-active/create', 4, 'sprint story active create', NULL, NULL, 1543416108, 1543416108),
('/sprint/story/create', 4, 'sprint story create', NULL, NULL, 1543399496, 1543399496),
('/sprint/story/index', 4, 'sprint story index', NULL, NULL, 1543398611, 1543398611),
('/sprint/story/trans', 4, 'sprint story trans', NULL, NULL, 1543985858, 1543985858),
('/sprint/story/update', 4, 'sprint story update', NULL, NULL, 1543462511, 1543462511),
('/sprint/story/view', 4, 'sprint story view', NULL, NULL, 1543415664, 1543415664),
('/story-status/create', 4, 'story status create', NULL, NULL, 1543394955, 1543394955),
('/story-status/index', 4, 'story status index', NULL, NULL, 1543394875, 1543394875),
('/switch-project/index', 4, 'switch project index', NULL, NULL, 1543370113, 1543370113),
('/user/create', 4, 'user create', NULL, NULL, 1543208720, 1543208720),
('/user/index', 4, 'user index', NULL, NULL, 1543207762, 1543207762),
('/user/role', 4, 'user role', NULL, NULL, 1543207775, 1543207775),
('/user/update', 4, 'user update', NULL, NULL, 1543207796, 1543207796),
('/user/view', 4, 'user view', NULL, NULL, 1543209419, 1543209419),
('ac-route', 3, 'ac route', NULL, NULL, 1543224289, 1543224289),
('ac-route-create', 2, 'ac route create', NULL, NULL, 1543224292, 1543224292),
('ac-route-index', 2, 'ac route index', NULL, NULL, 1543224289, 1543224289),
('ac-route-update', 2, 'ac route update', NULL, NULL, 1544087957, 1544087957),
('ac-route-view', 2, 'ac route view', NULL, NULL, 1543224304, 1543224304),
('aliyun-log-default', 3, 'aliyun log default', NULL, NULL, 1543812156, 1543812156),
('aliyun-log-default-setting', 2, 'aliyun log default setting', NULL, NULL, 1543812158, 1543812158),
('aliyun-log-store', 3, 'aliyun log store', NULL, NULL, 1543813263, 1543813263),
('app-module', 3, 'app module', NULL, NULL, 1543222002, 1543222002),
('app-module-index', 2, 'app module index', NULL, NULL, 1543222003, 1543222003),
('app-module-update', 2, 'app module update', NULL, NULL, 1544087093, 1544087093),
('app-module-view', 2, 'app module view', NULL, NULL, 1544087941, 1544087941),
('auth-permission', 3, 'auth permission', NULL, NULL, 1543225066, 1543225066),
('auth-permission-create', 2, 'auth permission create', NULL, NULL, 1543225416, 1543225416),
('auth-permission-index', 2, 'auth permission index', NULL, NULL, 1543225066, 1543225066),
('auth-permission-update', 2, 'auth permission update', NULL, NULL, 1543310118, 1543310118),
('auth-role', 3, 'auth role', NULL, NULL, 1543225064, 1543225064),
('auth-role-create', 2, 'auth role create', NULL, NULL, 1543387986, 1543387986),
('auth-role-index', 2, 'auth role index', NULL, NULL, 1543225064, 1543225064),
('auth-role-permission', 2, 'auth role permission', NULL, NULL, 1543570277, 1543570277),
('auth-role-update', 2, 'auth role update', NULL, NULL, 1543288315, 1543288315),
('auth-rule', 3, 'auth rule', NULL, NULL, 1543225069, 1543225069),
('auth-rule-create', 2, 'auth rule create', NULL, NULL, 1543225072, 1543225072),
('auth-rule-index', 2, 'auth rule index', NULL, NULL, 1543225069, 1543225069),
('auth-rule-update', 2, 'auth rule update', NULL, NULL, 1543309942, 1543309942),
('auth-rule-view', 2, 'auth rule view', NULL, NULL, 1543309946, 1543309946),
('backlog-acceptance', 3, 'backlog acceptance', NULL, NULL, 1543457223, 1543457223),
('backlog-acceptance-create', 2, 'backlog acceptance create', NULL, NULL, 1543457417, 1543457417),
('backlog-acceptance-index', 2, 'backlog acceptance index', NULL, NULL, 1543457223, 1543457223),
('backlog-default', 3, 'backlog default', NULL, NULL, 1543397160, 1543397160),
('backlog-default-create', 2, 'backlog default create', NULL, NULL, 1543397576, 1543397576),
('backlog-default-index', 2, 'backlog default index', NULL, NULL, 1543397160, 1543397160),
('backlog-default-trans', 2, 'backlog default trans', NULL, NULL, 1544435556, 1544435556),
('backlog-default-update', 2, 'backlog default update', NULL, NULL, 1547446324, 1547446324),
('backlog-default-view', 2, 'backlog default view', NULL, NULL, 1544435473, 1544435473),
('change-default', 3, 'change default', NULL, NULL, 1543388974, 1543388974),
('change-default-create', 2, 'change default create', NULL, NULL, 1543389914, 1543389914),
('change-default-index', 2, 'change default index', NULL, NULL, 1543388974, 1543388974),
('event', 3, 'event', NULL, NULL, 1543370008, 1543370008),
('event-create', 2, 'event create', NULL, NULL, 1543370011, 1543370011),
('event-handler', 3, 'event handler', NULL, NULL, 1543392890, 1543392890),
('event-handler-create', 2, 'event handler create', NULL, NULL, 1543392895, 1543392895),
('event-handler-index', 2, 'event handler index', NULL, NULL, 1543392890, 1543392890),
('event-handler-update', 2, 'event handler update', NULL, NULL, 1543549693, 1543549693),
('event-index', 2, 'event index', NULL, NULL, 1543370008, 1543370008),
('event-update', 2, 'event update', NULL, NULL, 1543548211, 1543548211),
('im-robot', 3, 'im robot', NULL, NULL, 1543392062, 1543392062),
('im-robot-create', 2, 'im robot create', NULL, NULL, 1543400044, 1543400044),
('im-robot-index', 2, 'im robot index', NULL, NULL, 1543392062, 1543392062),
('im-robot-update', 2, 'im robot update', NULL, NULL, 1543462272, 1543462272),
('link-default', 3, 'link default', NULL, NULL, 1546506685, 1546506685),
('link-default-create', 2, 'link default create', NULL, NULL, 1546506744, 1546506744),
('link-default-index', 2, 'link default index', NULL, NULL, 1546506685, 1546506685),
('link-default-view', 2, 'link default view', NULL, NULL, 1546507350, 1546507350),
('meet-default', 3, 'meet default', NULL, NULL, 1543388350, 1543388350),
('meet-default-create', 2, 'meet default create', NULL, NULL, 1543388471, 1543388471),
('meet-default-delete', 2, 'meet default delete', NULL, NULL, 1543562135, 1543562135),
('meet-default-index', 2, 'meet default index', NULL, NULL, 1543388350, 1543388350),
('meet-default-update', 2, 'meet default update', NULL, NULL, 1543567793, 1543567793),
('meet-default-view', 2, 'meet default view', NULL, NULL, 1543561947, 1543561947),
('member-default', 3, 'member default', NULL, NULL, 1543387160, 1543387160),
('member-default-create', 2, 'member default create', NULL, NULL, 1543387712, 1543387712),
('member-default-delete', 2, 'member default delete', NULL, NULL, 1543569831, 1543569831),
('member-default-index', 2, 'member default index', NULL, NULL, 1543387160, 1543387160),
('member-default-update', 2, 'member default update', NULL, NULL, 1543399855, 1543399855),
('member-default-view', 2, 'member default view', NULL, NULL, 1543563100, 1543563100),
('myproject-default', 3, 'myproject default', NULL, NULL, 1543455189, 1543455189),
('myproject-default-create', 2, 'myproject default create', NULL, NULL, 1543455548, 1543455548),
('myproject-default-index', 2, 'myproject default index', NULL, NULL, 1543455189, 1543455189),
('plan-default', 3, 'plan default', NULL, NULL, 1543237893, 1543237893),
('plan-default-index', 2, 'plan default index', NULL, NULL, 1543237893, 1543237893),
('project', 3, 'project', NULL, NULL, 1543239549, 1543239549),
('project-create', 2, 'project create', NULL, NULL, 1543239722, 1543239722),
('project-index', 2, 'project index', NULL, NULL, 1543239549, 1543239549),
('project-space', 2, 'project space', NULL, NULL, 1543371051, 1543371051),
('project-update', 2, 'project update', NULL, NULL, 1543310102, 1543310102),
('project-view', 2, 'project view', NULL, NULL, 1543310095, 1543310095),
('robot-default', 3, 'robot default', NULL, NULL, 1543391351, 1543391351),
('robot-default-create', 2, 'robot default create', NULL, NULL, 1543391518, 1543391518),
('robot-default-index', 2, 'robot default index', NULL, NULL, 1543391351, 1543391351),
('robot-default-update', 2, 'robot default update', NULL, NULL, 1543462308, 1543462308),
('robot-message', 3, 'robot message', NULL, NULL, 1543392356, 1543392356),
('robot-message-create', 2, 'robot message create', NULL, NULL, 1543975504, 1543975504),
('robot-message-index', 2, 'robot message index', NULL, NULL, 1543392356, 1543392356),
('robot-message-update', 2, 'robot message update', NULL, NULL, 1543976189, 1543976189),
('robot-message-view', 2, 'robot message view', NULL, NULL, 1543976876, 1543976876),
('role', 3, 'role', NULL, NULL, 1543288172, 1543288172),
('role-create', 2, 'role create', NULL, NULL, 1543288176, 1543288176),
('role-index', 2, 'role index', NULL, NULL, 1543288172, 1543288172),
('role-permission', 2, 'role permission', NULL, NULL, 1543288992, 1543288992),
('role-update', 2, 'role update', NULL, NULL, 1543288233, 1543288233),
('setting', 3, 'setting', NULL, NULL, 1547621354, 1547621354),
('setting-create', 2, 'setting create', NULL, NULL, 1547621358, 1547621358),
('setting-index', 2, 'setting index', NULL, NULL, 1547621354, 1547621354),
('setting-update', 2, 'setting update', NULL, NULL, 1547714528, 1547714528),
('site', 3, 'site', NULL, NULL, 1543207654, 1543207654),
('site-index', 2, 'site index', NULL, NULL, 1543207656, 1543207656),
('space-default', 3, 'space default', NULL, NULL, 1543375474, 1543375474),
('space-default-create', 2, 'space default create', NULL, NULL, 1543377197, 1543377197),
('space-default-index', 2, 'space default index', NULL, NULL, 1543375474, 1543375474),
('space-default-update', 2, 'space default update', NULL, NULL, 1543477938, 1543477938),
('sprint-default', 3, 'sprint default', NULL, NULL, 1543242478, 1543242478),
('sprint-default-create', 2, 'sprint default create', NULL, NULL, 1543242482, 1543242482),
('sprint-default-delete', 2, 'sprint default delete', NULL, NULL, 1543459132, 1543459132),
('sprint-default-index', 2, 'sprint default index', NULL, NULL, 1543242478, 1543242478),
('sprint-default-update', 2, 'sprint default update', NULL, NULL, 1543415054, 1543415054),
('sprint-default-view', 2, 'sprint default view', NULL, NULL, 1543458272, 1543458272),
('sprint-story', 3, 'sprint story', NULL, NULL, 1543398611, 1543398611),
('sprint-story-active', 3, 'sprint story active', NULL, NULL, 1543416108, 1543416108),
('sprint-story-active-create', 2, 'sprint story active create', NULL, NULL, 1543416108, 1543416108),
('sprint-story-create', 2, 'sprint story create', NULL, NULL, 1543399496, 1543399496),
('sprint-story-index', 2, 'sprint story index', NULL, NULL, 1543398611, 1543398611),
('sprint-story-trans', 2, 'sprint story trans', NULL, NULL, 1543985858, 1543985858),
('sprint-story-update', 2, 'sprint story update', NULL, NULL, 1543462511, 1543462511),
('sprint-story-view', 2, 'sprint story view', NULL, NULL, 1543415664, 1543415664),
('story-status', 3, 'story status', NULL, NULL, 1543394875, 1543394875),
('story-status-create', 2, 'story status create', NULL, NULL, 1543394956, 1543394956),
('story-status-index', 2, 'story status index', NULL, NULL, 1543394875, 1543394875),
('switch-project', 3, 'switch project', NULL, NULL, 1543370113, 1543370113),
('switch-project-index', 2, 'switch project index', NULL, NULL, 1543370113, 1543370113),
('update-my-project', 2, '更新自己的项目', '\\app\\rules\\IsMyProject', NULL, 1543312748, 1543312748),
('user', 3, 'user', NULL, NULL, 1543207753, 1543207753),
('user-create', 2, 'user create', NULL, NULL, 1543208720, 1543208720),
('user-index', 2, 'user index', NULL, NULL, 1543207762, 1543207762),
('user-role', 2, 'user role', NULL, NULL, 1543207775, 1543207775),
('user-update', 2, 'user update', NULL, NULL, 1543207796, 1543207796),
('user-view', 2, 'user view', NULL, NULL, 1543209419, 1543209419),
('开发人员', 1, NULL, NULL, NULL, 1543562615, 1543562615),
('敏捷教练', 1, NULL, NULL, NULL, 1543562548, 1543562548),
('管理员1', 1, '', NULL, NULL, 1543288187, 1543288472),
('部门负责人', 1, 'deparment charge', NULL, NULL, 1543218870, 1543218975),
('项目负责人', 1, NULL, NULL, NULL, 1543388020, 1543388020);
/*!40000 ALTER TABLE `auth_item` ENABLE KEYS */;
-- 正在导出表 geetask.auth_item_child 的数据:~372 rows (大约)
/*!40000 ALTER TABLE `auth_item_child` DISABLE KEYS */;
INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
('ac-route', '/ac-route/create'),
('ac-route', '/ac-route/index'),
('ac-route', '/ac-route/update'),
('ac-route', '/ac-route/view'),
('ac-route', 'ac-route-create'),
('ac-route', 'ac-route-index'),
('ac-route', 'ac-route-update'),
('ac-route', 'ac-route-view'),
('ac-route-create', '/ac-route/create'),
('ac-route-index', '/ac-route/index'),
('ac-route-update', '/ac-route/update'),
('ac-route-view', '/ac-route/view'),
('aliyun-log-default', '/aliyun-log/default/setting'),
('aliyun-log-default', 'aliyun-log-default-setting'),
('aliyun-log-default-setting', '/aliyun-log/default/setting'),
('app-module', '/app-module/index'),
('app-module', '/app-module/update'),
('app-module', '/app-module/view'),
('app-module', 'app-module-index'),
('app-module', 'app-module-update'),
('app-module', 'app-module-view'),
('app-module-index', '/app-module/index'),
('app-module-update', '/app-module/update'),
('app-module-view', '/app-module/view'),
('auth-permission', '/auth-permission/create'),
('auth-permission', '/auth-permission/index'),
('auth-permission', '/auth-permission/update'),
('auth-permission', 'auth-permission-create'),
('auth-permission', 'auth-permission-index'),
('auth-permission', 'auth-permission-update'),
('auth-permission-create', '/auth-permission/create'),
('auth-permission-index', '/auth-permission/index'),
('auth-permission-update', '/auth-permission/update'),
('auth-role', '/auth-role/create'),
('auth-role', '/auth-role/index'),
('auth-role', '/auth-role/permission'),
('auth-role', '/auth-role/update'),
('auth-role', 'auth-role-create'),
('auth-role', 'auth-role-index'),
('auth-role', 'auth-role-permission'),
('auth-role', 'auth-role-update'),
('auth-role-create', '/auth-role/create'),
('auth-role-index', '/auth-role/index'),
('auth-role-permission', '/auth-role/permission'),
('auth-role-update', '/auth-role/update'),
('auth-rule', '/auth-rule/create'),
('auth-rule', '/auth-rule/index'),
('auth-rule', '/auth-rule/update'),
('auth-rule', '/auth-rule/view'),
('auth-rule', 'auth-rule-create'),
('auth-rule', 'auth-rule-index'),
('auth-rule', 'auth-rule-update'),
('auth-rule', 'auth-rule-view'),
('auth-rule-create', '/auth-rule/create'),
('auth-rule-index', '/auth-rule/index'),
('auth-rule-update', '/auth-rule/update'),
('auth-rule-view', '/auth-rule/view'),
('backlog-acceptance', '/backlog/acceptance/create'),
('backlog-acceptance', '/backlog/acceptance/index'),
('backlog-acceptance', 'backlog-acceptance-create'),
('backlog-acceptance', 'backlog-acceptance-index'),
('backlog-acceptance-create', '/backlog/acceptance/create'),
('backlog-acceptance-index', '/backlog/acceptance/index'),
('backlog-default', '/backlog/default/create'),
('backlog-default', '/backlog/default/index'),
('backlog-default', '/backlog/default/trans'),
('backlog-default', '/backlog/default/update'),
('backlog-default', '/backlog/default/view'),
('backlog-default', 'backlog-default-create'),
('backlog-default', 'backlog-default-index'),
('backlog-default', 'backlog-default-trans'),
('backlog-default', 'backlog-default-update'),
('backlog-default', 'backlog-default-view'),
('backlog-default-create', '/backlog/default/create'),
('backlog-default-index', '/backlog/default/index'),
('backlog-default-trans', '/backlog/default/trans'),
('backlog-default-update', '/backlog/default/update'),
('backlog-default-view', '/backlog/default/view'),
('change-default', '/change/default/create'),
('change-default', '/change/default/index'),
('change-default', 'change-default-create'),
('change-default', 'change-default-index'),
('change-default-create', '/change/default/create'),
('change-default-index', '/change/default/index'),
('event', '/event/create'),
('event', '/event/index'),
('event', '/event/update'),
('event', 'event-create'),
('event', 'event-index'),
('event', 'event-update'),
('event-create', '/event/create'),
('event-handler', '/event-handler/create'),
('event-handler', '/event-handler/index'),
('event-handler', '/event-handler/update'),
('event-handler', 'event-handler-create'),
('event-handler', 'event-handler-index'),
('event-handler', 'event-handler-update'),
('event-handler-create', '/event-handler/create'),
('event-handler-index', '/event-handler/index'),
('event-handler-update', '/event-handler/update'),
('event-index', '/event/index'),
('event-update', '/event/update'),
('im-robot', '/im-robot/create'),
('im-robot', '/im-robot/index'),
('im-robot', '/im-robot/update'),
('im-robot', 'im-robot-create'),
('im-robot', 'im-robot-index'),
('im-robot', 'im-robot-update'),
('im-robot-create', '/im-robot/create'),
('im-robot-index', '/im-robot/index'),
('im-robot-update', '/im-robot/update'),
('link-default', '/link/default/create'),
('link-default', '/link/default/index'),
('link-default', '/link/default/view'),
('link-default', 'link-default-create'),
('link-default', 'link-default-index'),
('link-default', 'link-default-view'),
('link-default-create', '/link/default/create'),
('link-default-index', '/link/default/index'),
('link-default-view', '/link/default/view'),
('meet-default', '/meet/default/create'),
('meet-default', '/meet/default/delete'),
('meet-default', '/meet/default/index'),
('meet-default', '/meet/default/update'),
('meet-default', '/meet/default/view'),
('meet-default', 'meet-default-create'),
('meet-default', 'meet-default-delete'),
('meet-default', 'meet-default-index'),
('meet-default', 'meet-default-update'),
('meet-default', 'meet-default-view'),
('meet-default-create', '/meet/default/create'),
('meet-default-delete', '/meet/default/delete'),
('meet-default-index', '/meet/default/index'),
('meet-default-update', '/meet/default/update'),
('meet-default-view', '/meet/default/view'),
('member-default', '/member/default/create'),
('member-default', '/member/default/delete'),
('member-default', '/member/default/index'),
('member-default', '/member/default/update'),
('member-default', '/member/default/view'),
('member-default', 'member-default-create'),
('member-default', 'member-default-delete'),
('member-default', 'member-default-index'),
('member-default', 'member-default-update'),
('member-default', 'member-default-view'),
('member-default-create', '/member/default/create'),
('member-default-delete', '/member/default/delete'),
('member-default-index', '/member/default/index'),
('member-default-update', '/member/default/update'),
('member-default-view', '/member/default/view'),
('myproject-default', '/myproject/default/create'),
('myproject-default', '/myproject/default/index'),
('myproject-default', 'myproject-default-create'),
('myproject-default', 'myproject-default-index'),
('myproject-default-create', '/myproject/default/create'),
('myproject-default-index', '/myproject/default/index'),
('plan-default', '/plan/default/index'),
('plan-default', 'plan-default-index'),
('plan-default-index', '/plan/default/index'),
('project', '/project/create'),
('project', '/project/index'),
('project', '/project/space'),
('project', '/project/update'),
('project', '/project/view'),
('project', 'project-create'),
('project', 'project-index'),
('project', 'project-space'),
('project', 'project-update'),
('project', 'project-view'),
('project-create', '/project/create'),
('project-index', '/project/index'),
('project-space', '/project/space'),
('project-update', '/project/update'),
('project-view', '/project/view'),
('robot-default', '/robot/default/create'),
('robot-default', '/robot/default/index'),
('robot-default', '/robot/default/update'),
('robot-default', 'robot-default-create'),
('robot-default', 'robot-default-index'),
('robot-default', 'robot-default-update'),
('robot-default-create', '/robot/default/create'),
('robot-default-index', '/robot/default/index'),
('robot-default-update', '/robot/default/update'),
('robot-message', '/robot-message/create'),
('robot-message', '/robot-message/index'),
('robot-message', '/robot-message/update'),
('robot-message', '/robot-message/view'),
('robot-message', 'robot-message-create'),
('robot-message', 'robot-message-index'),
('robot-message', 'robot-message-update'),
('robot-message', 'robot-message-view'),
('robot-message-create', '/robot-message/create'),
('robot-message-index', '/robot-message/index'),
('robot-message-update', '/robot-message/update'),
('robot-message-view', '/robot-message/view'),
('role', '/role/create'),
('role', '/role/index'),
('role', '/role/permission'),
('role', '/role/update'),
('role', 'role-create'),
('role', 'role-index'),
('role', 'role-permission'),
('role', 'role-update'),
('role-create', '/role/create'),
('role-index', '/role/index'),
('role-permission', '/role/permission'),
('role-update', '/role/update'),
('setting', '/setting/create'),
('setting', '/setting/index'),
('setting', '/setting/update'),
('setting', 'setting-create'),
('setting', 'setting-index'),
('setting', 'setting-update'),
('setting-create', '/setting/create'),
('setting-index', '/setting/index'),
('setting-update', '/setting/update'),
('site', '/site/index'),
('site', 'site-index'),
('site-index', '/site/index'),
('space-default', '/space/default/create'),
('space-default', '/space/default/index'),
('space-default', '/space/default/update'),
('space-default', 'space-default-create'),
('space-default', 'space-default-index'),
('space-default', 'space-default-update'),
('space-default-create', '/space/default/create'),
('space-default-index', '/space/default/index'),
('space-default-update', '/space/default/update'),
('sprint-default', '/sprint/default/create'),
('sprint-default', '/sprint/default/delete'),
('sprint-default', '/sprint/default/index'),
('sprint-default', '/sprint/default/update'),
('sprint-default', '/sprint/default/view'),
('sprint-default', 'sprint-default-create'),
('sprint-default', 'sprint-default-delete'),
('sprint-default', 'sprint-default-index'),
('sprint-default', 'sprint-default-update'),
('sprint-default', 'sprint-default-view'),
('sprint-default-create', '/sprint/default/create'),
('sprint-default-delete', '/sprint/default/delete'),
('sprint-default-index', '/sprint/default/index'),
('sprint-default-update', '/sprint/default/update'),
('sprint-default-view', '/sprint/default/view'),
('sprint-story', '/sprint/story/create'),
('sprint-story', '/sprint/story/index'),
('sprint-story', '/sprint/story/trans'),
('sprint-story', '/sprint/story/update'),
('sprint-story', '/sprint/story/view'),
('sprint-story', 'sprint-story-create'),
('sprint-story', 'sprint-story-index'),
('sprint-story', 'sprint-story-trans'),
('sprint-story', 'sprint-story-update'),
('sprint-story', 'sprint-story-view'),
('sprint-story-active', '/sprint/story-active/create'),
('sprint-story-active', 'sprint-story-active-create'),
('sprint-story-active-create', '/sprint/story-active/create'),
('sprint-story-create', '/sprint/story/create'),
('sprint-story-index', '/sprint/story/index'),
('sprint-story-trans', '/sprint/story/trans'),
('sprint-story-update', '/sprint/story/update'),
('sprint-story-view', '/sprint/story/view'),
('story-status', '/story-status/create'),
('story-status', '/story-status/index'),
('story-status', 'story-status-create'),
('story-status', 'story-status-index'),
('story-status-create', '/story-status/create'),
('story-status-index', '/story-status/index'),
('switch-project', '/switch-project/index'),
('switch-project', 'switch-project-index'),
('switch-project-index', '/switch-project/index'),
('update-my-project', 'project-update'),
('user', '/user/create'),
('user', '/user/index'),
('user', '/user/role'),
('user', '/user/update'),
('user', '/user/view'),
('user', 'user-create'),
('user', 'user-index'),
('user', 'user-role'),
('user', 'user-update'),
('user', 'user-view'),
('user-create', '/user/create'),
('user-index', '/user/index'),
('user-role', '/user/role'),
('user-update', '/user/update'),
('user-view', '/user/view'),
('开发人员', 'meet-default-create'),
('开发人员', 'meet-default-delete'),
('开发人员', 'meet-default-index'),
('开发人员', 'meet-default-update'),
('开发人员', 'meet-default-view'),
('开发人员', 'myproject-default-create'),
('开发人员', 'myproject-default-index'),
('开发人员', 'space-default-index'),
('开发人员', 'sprint-default-create'),
('开发人员', 'sprint-default-delete'),
('开发人员', 'sprint-default-index'),
('开发人员', 'sprint-default-update'),
('开发人员', 'sprint-default-view'),
('开发人员', 'sprint-story-active-create'),
('开发人员', 'sprint-story-create'),
('开发人员', 'sprint-story-index'),
('开发人员', 'sprint-story-update'),
('开发人员', 'sprint-story-view'),
('敏捷教练', 'backlog-acceptance-create'),
('敏捷教练', 'backlog-acceptance-index'),
('敏捷教练', 'backlog-default-create'),
('敏捷教练', 'backlog-default-index'),
('敏捷教练', 'change-default-create'),
('敏捷教练', 'change-default-index'),
('敏捷教练', 'meet-default-create'),
('敏捷教练', 'meet-default-delete'),
('敏捷教练', 'meet-default-index'),
('敏捷教练', 'meet-default-update'),
('敏捷教练', 'meet-default-view'),
('敏捷教练', 'member-default-create'),
('敏捷教练', 'member-default-delete'),
('敏捷教练', 'member-default-index'),
('敏捷教练', 'member-default-update'),
('敏捷教练', 'member-default-view'),
('敏捷教练', 'myproject-default-create'),
('敏捷教练', 'myproject-default-index'),
('敏捷教练', 'robot-default-create'),
('敏捷教练', 'robot-default-index'),
('敏捷教练', 'robot-default-update'),
('敏捷教练', 'space-default-create'),
('敏捷教练', 'space-default-index'),
('敏捷教练', 'space-default-update'),
('敏捷教练', 'sprint-default-create'),
('敏捷教练', 'sprint-default-delete'),
('敏捷教练', 'sprint-default-index'),
('敏捷教练', 'sprint-default-update'),
('敏捷教练', 'sprint-default-view'),
('敏捷教练', 'sprint-story-active-create'),
('敏捷教练', 'sprint-story-create'),
('敏捷教练', 'sprint-story-index'),
('敏捷教练', 'sprint-story-update'),
('敏捷教练', 'sprint-story-view'),
('项目负责人', 'backlog-acceptance-create'),
('项目负责人', 'backlog-acceptance-index'),
('项目负责人', 'backlog-default-create'),
('项目负责人', 'backlog-default-index'),
('项目负责人', 'change-default-create'),
('项目负责人', 'change-default-index'),
('项目负责人', 'meet-default-create'),
('项目负责人', 'meet-default-delete'),
('项目负责人', 'meet-default-index'),
('项目负责人', 'meet-default-update'),
('项目负责人', 'meet-default-view'),
('项目负责人', 'member-default-create'),
('项目负责人', 'member-default-delete'),
('项目负责人', 'member-default-index'),
('项目负责人', 'member-default-update'),
('项目负责人', 'member-default-view'),
('项目负责人', 'myproject-default-create'),
('项目负责人', 'myproject-default-index'),
('项目负责人', 'robot-default-create'),
('项目负责人', 'robot-default-index'),
('项目负责人', 'robot-default-update'),
('项目负责人', 'space-default-create'),
('项目负责人', 'space-default-index'),
('项目负责人', 'space-default-update'),
('项目负责人', 'sprint-default-create'),
('项目负责人', 'sprint-default-delete'),
('项目负责人', 'sprint-default-index'),
('项目负责人', 'sprint-default-update'),
('项目负责人', 'sprint-default-view'),
('项目负责人', 'sprint-story-active-create'),
('项目负责人', 'sprint-story-create'),
('项目负责人', 'sprint-story-index'),
('项目负责人', 'sprint-story-update'),
('项目负责人', 'sprint-story-view');
/*!40000 ALTER TABLE `auth_item_child` ENABLE KEYS */;
-- 正在导出表 geetask.auth_rule 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `auth_rule` DISABLE KEYS */;
INSERT INTO `auth_rule` (`name`, `data`, `created_at`, `updated_at`) VALUES
('\\app\\rules\\IsMyProject', _binary 0x4F3A32313A226170705C72756C65735C49734D7950726F6A656374223A333A7B733A343A226E616D65223B733A32323A225C6170705C72756C65735C49734D7950726F6A656374223B733A393A22637265617465644174223B693A313534333330393933353B733A393A22757064617465644174223B693A313534333330393933353B7D, 1543309935, 1543309935);
/*!40000 ALTER TABLE `auth_rule` ENABLE KEYS */;
-- 正在导出表 geetask.gt_change_category 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `gt_change_category` DISABLE KEYS */;
INSERT INTO `gt_change_category` (`id`, `name`) VALUES
(1, 'SQL');
/*!40000 ALTER TABLE `gt_change_category` ENABLE KEYS */;
-- 正在导出表 geetask.gt_event 的数据:~3 rows (大约)
/*!40000 ALTER TABLE `gt_event` DISABLE KEYS */;
INSERT INTO `gt_event` (`id`, `created_at`, `updated_at`, `name`, `code`, `intro`) VALUES
(1, 1543392882, 1543548341, '添加新的故事', 'sprint.story.create', '在迭代计划中添加新的故事'),
(2, 1543548739, 1543551967, '更新故事', 'sprint.story.change', '在迭代计划中通过修改状态或者指派新的处理'),
(3, 1547620062, 1547620062, '会议保存', 'meeting.save', '添加会议和保存会议的时候触发');
/*!40000 ALTER TABLE `gt_event` ENABLE KEYS */;
-- 正在导出表 geetask.gt_event_handler 的数据:~4 rows (大约)
/*!40000 ALTER TABLE `gt_event_handler` DISABLE KEYS */;
INSERT INTO `gt_event_handler` (`id`, `event_id`, `created_at`, `updated_at`, `name`, `handler`, `intro`) VALUES
(1, 1, 1543462486, 1543549720, '发送机器人消息', '\\modules\\sprint\\handlers\\OnCreateStorySendMessageHandler', '发送标题消息'),
(2, 2, 1543549761, 1543551513, '发送机器人消息', '\\modules\\sprint\\handlers\\OnChangeStorySendMessageHandler', '发送标题消息'),
(3, 3, 1547620166, 1547620166, '会话通知到钉钉', '\\modules\\meet\\handlers\\OnSaveMeetingSendMessageHandler', '会议通知到钉钉'),
(4, 3, 1547623198, 1547623198, '会议通过邮件通知', '\\modules\\meet\\handlers\\OnSaveMeetingSendEmailHandler', '邮件通知');
/*!40000 ALTER TABLE `gt_event_handler` ENABLE KEYS */;
-- 正在导出表 geetask.gt_link 的数据:~2 rows (大约)
/*!40000 ALTER TABLE `gt_link` DISABLE KEYS */;
INSERT INTO `gt_link` (`id`, `project_id`, `label`, `url`) VALUES
(1, 1, '阿里云', 'https://www.aliyun.com'),
(2, 1, '支付宝', 'https://www.alipay.com');
/*!40000 ALTER TABLE `gt_link` ENABLE KEYS */;
-- 正在导出表 geetask.gt_robot 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `gt_robot` DISABLE KEYS */;
INSERT INTO `gt_robot` (`id`, `created_at`, `updated_at`, `name`, `code_full_class`) VALUES
(1, 1543400079, 1543462291, '钉钉', '\\app\\robots\\DingTalkRobot');
/*!40000 ALTER TABLE `gt_robot` ENABLE KEYS */;
-- 正在导出表 geetask.gt_robot_message 的数据:~2 rows (大约)
/*!40000 ALTER TABLE `gt_robot_message` DISABLE KEYS */;
INSERT INTO `gt_robot_message` (`id`, `code`, `name`, `msg_subject`, `subject_vars`, `msg_body`, `body_vars`) VALUES
(1, 'OnChangeStoryInSprint', '修改迭代中的用户故事的时候', '{user.nick_name} -> 才更新了用户故事#{story.id}🎉🎉🎉', '{user.nick_name},{story.id},{story.name},{story.status},{story.user}', '> **处理人:** {story.user}\r\n> **状态:** {story.old_status} -> {story.status}\r\n> **内容:** {story.name}\r\n> **备注:** {story.remark}\r\n> ❤❤❤\r\n\r\n\r\n', '{story.id},{story.name},{story.status},{story.user},{story.remark}'),
(2, 'OnCreateStoryInSprint', '添加迭代中的用户故事的时候', '{user.nick_name} -> 才添加了用户故事#{story.id}🎉🎉🎉', '{user.nick_name},{story.id},{story.name},{story.status},{story.user}', '> **处理人:** {story.user}\r\n> **内容:** {story.name}\r\n> ❤❤❤', '{story.id},{story.name},{story.status},{story.user}');
/*!40000 ALTER TABLE `gt_robot_message` ENABLE KEYS */;
-- 正在导出表 geetask.gt_role 的数据:~4 rows (大约)
/*!40000 ALTER TABLE `gt_role` DISABLE KEYS */;
INSERT INTO `gt_role` (`id`, `name`, `scope`, `description`, `is_sys`) VALUES
(1, '管理员1', 'ADMIN', '', NULL),
(2, '项目负责人', 'POSITION', 'product owner', 1),
(3, '敏捷教练', 'POSITION', 'project master', 1),
(4, '开发人员', 'POSITION', 'developer', 1);
/*!40000 ALTER TABLE `gt_role` ENABLE KEYS */;
-- 正在导出表 geetask.gt_setting 的数据:~5 rows (大约)
/*!40000 ALTER TABLE `gt_setting` DISABLE KEYS */;
INSERT INTO `gt_setting` (`name`, `title`, `value`) VALUES
('email.host', '邮件主机', 'ssl://smtp.ndabooking.com'),
('email.password', '邮件密码', ''),
('email.port', '邮件端口', '465'),
('email.useralias', '邮件账号别名', 'GeeTask'),
('email.username', '邮件账号', '');
/*!40000 ALTER TABLE `gt_setting` ENABLE KEYS */;
-- 正在导出表 geetask.gt_story_status 的数据:~11 rows (大约)
/*!40000 ALTER TABLE `gt_story_status` DISABLE KEYS */;
INSERT INTO `gt_story_status` (`id`, `is_backlog`, `name`, `description`, `sort`) VALUES
(1, 1, '待评估', '产品负责人添加新的故事默认状态', 1000),
(2, 1, '已评估', '故事已经更开发人员沟通评估等待迭代', 900),
(3, 1, '作废', '评估失败', 0),
(4, 0, '启动', '任务已经分配待开发,待开发人员再跟产品经理确认需求', 800),
(5, 0, '确认', '开发者已跟产品经理确认需求一致,待开发', 700),
(6, 0, '开发中', '开发者进行编码或者设计', 650),
(7, 0, '开发完', '编码完成,跟产品经理再次确认完成的结果一致', 600),
(8, 0, '测试中', '测试人员进行测试,并确认需求一致', 550),
(9, 0, '测试完', '测试人员完成测试,待通知产品验收', 500),
(10, 0, '验收', '产品经理验收', 450),
(11, 0, '完成', '结束任务项待发布', 400);
/*!40000 ALTER TABLE `gt_story_status` ENABLE KEYS */;
-- 正在导出表 geetask.gt_user 的数据:~16 rows (大约)
/*!40000 ALTER TABLE `gt_user` DISABLE KEYS */;
INSERT INTO `gt_user` (`id`, `username`, `nick_name`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `mobile`, `status`, `is_admin`, `is_super`, `def_project`, `created_at`, `updated_at`, `role`, `is_del`) VALUES
(1, 'admin', '管理员', 'dFIfQutSickXRaQXsZSCPB1LAJZ6FnbA', '$2y$13$m5Z6Ruhoi3NIVaCCdnhuvO4tS9SEeMOFEIWy4UXAw39qqPJaRVzTu', NULL, 'dungang@126.com', '', 10, 1, 1, 1, 1543204772, 1544087066, '管理员1', 0);
/*!40000 ALTER TABLE `gt_user` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化