صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
Silent
/
RailwayTwo
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
شاخه: master
شاخه‌ها تگ‌ها
RailwayTwo
/
database
/
seeds
/
railway_two.sql

railway_two.sql 12 KB
لینک دائمی تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 
  1. -- phpMyAdmin SQL Dump
    2. 

  2. -- version 4.7.4
    3. 

  3. -- https://www.phpmyadmin.net/
    4. 

  4. --
    5. 

  5. -- Host: 127.0.0.1:3306
    6. 

  6. -- Generation Time: 2021-01-10 21:08:55
    7. 

  7. -- 服务器版本： 5.7.19
    8. 

  8. -- PHP Version: 7.3.10
    9. 

  9. 

  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    11. 

  11. SET AUTOCOMMIT = 0;
    12. 

  12. START TRANSACTION;
    13. 

  13. SET time_zone = "+00:00";
    14. 

  14. 

  15. 

  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    17. 

  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    18. 

  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    19. 

  19. /*!40101 SET NAMES utf8mb4 */;
    20. 

  20. 

  21. --
    22. 

  22. -- Database: `railway_two`
    23. 

  23. --
    24. 

  24. 

  25. -- --------------------------------------------------------
    26. 

  26. 

  27. --
    28. 

  28. -- 表的结构 `admin_menus`
    29. 

  29. --
    30. 

  30. 

  31. DROP TABLE IF EXISTS `admin_menus`;
    32. 

  32. CREATE TABLE IF NOT EXISTS `admin_menus` (
    33. 

  33.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    34. 

  34.   `pid` int(11) NOT NULL,
    35. 

  35.   `path` char(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URL',
    36. 

  36.   `name` char(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '节点的名字',
    37. 

  37.   `display` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1为显示为菜单，0则不显示',
    38. 

  38.   `sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
    39. 

  39.   `level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '第几级菜单',
    40. 

  40.   `ico` char(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单图标',
    41. 

  41.   `mark` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    42. 

  42.   `created_at` timestamp NULL DEFAULT NULL,
    43. 

  43.   `updated_at` timestamp NULL DEFAULT NULL,
    44. 

  44.   `deleted_at` timestamp NULL DEFAULT NULL,
    45. 

  45.   PRIMARY KEY (`id`),
    46. 

  46.   KEY `idx_deleted_at` (`deleted_at`)
    47. 

  47. ) ENGINE=MyISAM AUTO_INCREMENT=634 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    48. 

  48. 

  49. --
    50. 

  50. -- 转存表中的数据 `admin_menus`
    51. 

  51. --
    52. 

  52. 

  53. INSERT INTO `admin_menus` (`id`, `pid`, `path`, `name`, `display`, `sort`, `level`, `ico`, `mark`, `created_at`, `updated_at`, `deleted_at`) VALUES
    54. 

  54. (1, 0, '#', '系统管理', 0, 2, 1, 'fa-globe', '', '2016-12-31 16:00:00', '2020-11-28 04:07:16', NULL),
    55. 

  55. (2, 0, '#', '账号管理', 1, 100, 1, 'fa-users', '', '2016-12-31 16:00:00', '2020-12-03 05:24:31', NULL),
    56. 

  56. (3, 0, '#', '商品管理', 0, 98, 1, 'fa-calendar', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    57. 

  57. (5, 0, '#', '公共权限', 0, 0, 1, 'fa-cart-plus', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    58. 

  58. (6, 0, '#', '缓存管理', 0, 94, 1, 'fa-magic', '', '2016-12-31 16:00:00', '2020-11-28 04:06:58', NULL),
    59. 

  59. (7, 0, '#', '数据报表', 0, 96, 1, 'fa-globe', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    60. 

  60. (9, 0, '#', '参数设置', 0, 95, 1, 'fa-bar-chart-o', '', '2017-01-04 10:32:17', '2020-11-28 04:06:49', NULL),
    61. 

  61. (103, 1, 'Base/Menus/index', '菜单管理', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    62. 

  62. (104, 1, 'Base/Role/index', '角色管理', 1, 0, 2, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    63. 

  63. (105, 1, 'Base/User/index', '账号管理', 1, 0, 2, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    64. 

  64. (501, 5, 'Base/Index/index', '首页（必选）', 0, 0, 2, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    65. 

  65. (502, 5, 'Base/Index/welcome', '欢迎页', 0, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    66. 

  66. (503, 5, 'Base/Login/logout', '退出页', 0, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    67. 

  67. (519, 103, 'Base/Menus/create', '添加菜单', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    68. 

  68. (520, 103, 'Base/Menus/update', '修改菜单', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    69. 

  69. (521, 103, 'Base/Menus/destroy', '删除菜单', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    70. 

  70. (522, 104, 'Base/Role/create', '添加角色', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    71. 

  71. (523, 104, 'Base/Role/update', '修改角色', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    72. 

  72. (524, 104, 'Base/Role/auth', '角色授权', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    73. 

  73. (525, 104, 'Base/Role/destroy', '删除角色', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    74. 

  74. (526, 105, 'Base/User/update', '编辑用户', 0, 0, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    75. 

  75. (543, 5, 'Base/Attachment/upload', '编辑器上传', 0, 0, 2, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    76. 

  76. (544, 105, 'Base/User/auth', '为用户授权', 0, 1, 3, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    77. 

  77. (578, 1, 'Base/Crud/create', 'Crud', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    78. 

  78. (579, 6, 'Cache/File/clearcache', '清空缓存', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    79. 

  79. (580, 6, 'Cache/File/clearview', '清空模板缓存', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    80. 

  80. (581, 6, 'Cache/File/clearsessions', '强制在线用户下线', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    81. 

  81. (582, 6, 'Cache/File/index', '文件管理', 1, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    82. 

  82. (583, 6, 'Cache/File/view', '文件查看', 0, 0, 1, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    83. 

  83. (596, 1, 'Base/Settings/index', '系统配置', 1, 0, 2, '', '', '2016-03-29 11:42:29', '2016-03-29 11:42:29', NULL),
    84. 

  84. (597, 2, 'AdminUser/index', '账号列表', 1, 100, 2, '', '账号列表', '2017-04-04 22:39:13', '2020-12-03 05:24:42', NULL),
    85. 

  85. (613, 0, '#', '项目管理', 1, 120, 1, 'iconfont icon-xiangmu', '项目管理', '2020-12-03 05:33:10', '2020-12-03 05:39:54', NULL),
    86. 

  86. (542, 5, 'Foundation/Attachment/webupload', '文件上传', 0, 0, 2, '', '', '2016-12-31 16:00:00', '2016-12-31 16:00:00', NULL),
    87. 

  87. (604, 596, 'Base/Settings/create', '添加', 0, 1, 1, '', ' ', '2017-05-30 20:56:09', '2017-05-30 20:56:09', NULL),
    88. 

  88. (605, 596, 'Base/Settings/update', '修改', 0, 1, 1, '', ' ', '2017-05-30 20:56:09', '2017-05-30 20:56:09', NULL),
    89. 

  89. (606, 596, 'Base/Settings/destroy', '删除', 0, 1, 1, '', ' ', '2017-05-30 20:56:09', '2017-05-30 20:56:09', NULL),
    90. 

  90. (607, 596, 'Base/Settings/view', '查看', 0, 1, 1, '', ' ', '2017-05-30 20:56:09', '2017-05-30 20:56:09', NULL),
    91. 

  91. (608, 596, 'Base/Settings/check', '选择数据', 0, 1, 1, '', ' ', '2017-05-30 20:56:09', '2017-05-30 20:56:09', NULL),
    92. 

  92. (609, 1, 'Base/Photos/index', '图片管理', 1, 1, 2, '', '图片管理', '2017-08-01 22:43:20', '2017-08-01 22:43:21', NULL),
    93. 

  93. (612, 0, '#', '订单管理', 1, 110, 1, 'iconfont icon-icon', '订单管理', '2020-12-03 05:27:41', '2020-12-03 05:40:07', NULL),
    94. 

  94. (614, 0, '#', '角色管理', 1, 130, 1, 'iconfont icon-role', '角色管理', '2020-12-03 05:39:38', '2020-12-03 05:42:28', NULL),
    95. 

  95. (615, 612, 'Order/index', '订单列表', 1, 100, 2, 'fa-bar-chart-o', '订单列表', '2020-12-03 05:40:32', '2020-12-03 05:40:55', NULL),
    96. 

  96. (616, 613, 'Project/index', '项目列表', 1, 100, 2, 'fa-bar-chart-o', '项目列表', '2020-12-03 05:41:31', '2020-12-03 05:41:31', NULL),
    97. 

  97. (617, 614, 'ProjectRole/index', '角色列表', 1, 100, 2, 'fa-bar-chart-o', '角色列表', '2020-12-03 05:42:03', '2020-12-24 05:51:42', NULL),
    98. 

  98. (618, 0, '#', '设备管理', 1, 150, 1, 'iconfont icon-shebei', '设备管理', '2020-12-03 05:43:56', '2020-12-03 05:49:41', NULL),
    99. 

  99. (619, 618, 'InnerDevice/index', '内部设备列表', 1, 100, 2, 'fa-bar-chart-o', '内部设备列表', '2020-12-03 05:44:24', '2021-01-09 14:42:34', NULL),
    100. 

  100. (620, 0, '/', '首页', 1, 160, 1, 'iconfont icon-shouye', '首页', '2020-12-03 05:46:20', '2020-12-03 05:49:33', NULL),
    101. 

  101. (621, 0, '#', '用户管理', 1, 140, 1, 'iconfont icon-yonghu', '用户管理', '2020-12-03 05:48:56', '2020-12-03 05:48:56', NULL),
    102. 

  102. (622, 621, '/User/index', '用户列表', 1, 100, 2, 'fa-bar-chart-o', '用户列表', '2020-12-03 05:50:13', '2020-12-03 05:50:13', NULL),
    103. 

  103. (623, 621, 'UserReset/index', '密码重置', 1, 90, 2, 'fa-bar-chart-o', '密码重置', '2020-12-03 17:16:37', '2020-12-03 17:16:37', NULL),
    104. 

  104. (624, 618, 'Device/index', '设备类型', 1, 90, 2, 'fa-bar-chart-o', '设备类型', '2020-12-23 17:10:37', '2020-12-23 17:10:37', NULL),
    105. 

  105. (625, 618, 'DeviceName/index', '设备名称', 1, 80, 2, 'fa-bar-chart-o', '设备名称', '2020-12-23 17:11:18', '2020-12-23 17:11:18', NULL),
    106. 

  106. (626, 618, 'Spec/index', '规格型号', 1, 70, 2, 'fa-bar-chart-o', '规格型号', '2020-12-23 17:11:36', '2020-12-23 17:11:36', NULL),
    107. 

  107. (628, 614, 'ProjectRoleRight/index', '权限管理', 1, 80, 2, 'fa-bar-chart-o', '权限管理', '2020-12-30 09:38:06', '2020-12-30 09:44:38', NULL),
    108. 

  108. (629, 621, 'UserAuth/index', '用户授权', 1, 80, 2, 'fa-bar-chart-o', '用户授权', '2021-01-09 14:20:16', '2021-01-09 14:21:50', NULL),
    109. 

  109. (630, 613, 'Project/applyIndex', '申请列表', 1, 90, 2, 'fa-bar-chart-o', '申请列表', '2021-01-10 11:33:39', '2021-01-10 11:33:39', NULL),
    110. 

  110. (631, 613, 'WorkPoint/index', '工点管理', 1, 80, 2, 'fa-bar-chart-o', '工点管理', '2021-01-10 11:57:07', '2021-01-10 11:57:07', NULL),
    111. 

  111. (632, 612, 'OrderDevice/rentList', '租赁订单设备列表', 1, 90, 2, 'fa-bar-chart-o', '租赁订单设备列表', '2021-01-10 12:41:39', '2021-01-10 12:41:39', NULL),
    112. 

  112. (633, 612, 'OrderDevice/applyList', '调用设备明细列表', 1, 80, 1, 'fa-bar-chart-o', '调用设备明细列表', '2021-01-10 12:42:06', '2021-01-10 12:42:50', NULL);
    113. 

  113. 

  114. -- --------------------------------------------------------
    115. 

  115. 

  116. --
    117. 

  117. -- 表的结构 `options`
    118. 

  118. --
    119. 

  119. 

  120. DROP TABLE IF EXISTS `options`;
    121. 

  121. CREATE TABLE IF NOT EXISTS `options` (
    122. 

  122.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    123. 

  123.   `table` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    124. 

  124.   `column` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    125. 

  125.   `key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    126. 

  126.   `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    127. 

  127.   `sort` int(10) UNSIGNED DEFAULT NULL,
    128. 

  128.   `color` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    129. 

  129.   `label_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'red|orange|green|cyan|blue|black|gray',
    130. 

  130.   `created_at` timestamp NULL DEFAULT NULL,
    131. 

  131.   `updated_at` timestamp NULL DEFAULT NULL,
    132. 

  132.   PRIMARY KEY (`id`)
    133. 

  133. ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    134. 

  134. 

  135. --
    136. 

  136. -- 转存表中的数据 `options`
    137. 

  137. --
    138. 

  138. 

  139. INSERT INTO `options` (`id`, `table`, `column`, `key`, `name`, `sort`, `color`, `label_type`, `created_at`, `updated_at`) VALUES
    140. 

  140. (1, 'orders', 'status', 'checking', '待审核', 1, 'rgba(234, 151, 14, 1)', NULL, '2020-12-21 05:19:11', '2020-12-21 05:19:11'),
    141. 

  141. (2, 'orders', 'status', 'checked', '已审核', 2, 'rgba(76, 173, 132, 1)', NULL, '2020-12-21 05:19:11', '2020-12-21 05:19:11'),
    142. 

  142. (3, 'orders', 'status', 'pass', '已完成', 3, 'rgba(25, 133, 251, 1)', NULL, '2020-12-21 05:19:11', '2020-12-21 05:19:11'),
    143. 

  143. (4, 'orders', 'status', 'reject', '已驳回', 4, 'rgba(225, 132, 132, 1)', NULL, '2020-12-21 05:19:11', '2020-12-21 05:19:11'),
    144. 

  144. (5, 'orders', 'status', 'back', '已归还', 5, 'rgb(114, 50, 221)', NULL, '2020-12-21 05:19:11', '2020-12-21 05:19:11'),
    145. 

  145. (6, 'inner_devices', 'status', 'free', '闲置中', 1, '#07c160', NULL, '2020-12-21 05:19:15', '2020-12-21 05:19:15'),
    146. 

  146. (7, 'inner_devices', 'status', 'using', '使用中', 2, '#ee0a24', NULL, '2020-12-21 05:19:15', '2020-12-21 05:19:15'),
    147. 

  147. (8, 'inner_devices', 'status', 'repair', '维修', 3, '#ff976a', NULL, '2020-12-21 05:19:15', '2020-12-21 05:19:15'),
    148. 

  148. (9, 'inner_devices', 'status', 'scrap', '报废', 4, 'black', NULL, '2020-12-21 05:19:15', '2020-12-21 05:19:15'),
    149. 

  149. (10, 'projects', 'active', '1', '通过', 1, NULL, 'green', '2020-12-26 16:00:00', '2020-12-26 16:00:00'),
    150. 

  150. (11, 'projects', 'active', '2', '拒绝', NULL, NULL, '', NULL, NULL),
    151. 

  151. (12, 'projects', 'active', '3', '待审核', NULL, '', 'orange', NULL, NULL),
    152. 

  152. (13, 'work_points', 'status', '1', '激活', 1, NULL, 'blue', NULL, NULL),
    153. 

  153. (14, 'work_points', 'status', '2', '禁用', NULL, NULL, 'orange', NULL, NULL);
    154. 

  154. COMMIT;
    155. 

  155. 

  156. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    157. 

  157. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    158. 

  158. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    159.