數據庫SQL文件 · ThinkPHP5高階實戰教程 --詮釋為API開發而生

~~~ -- ---------------------------- -- Table structure for my_admin_department -- ---------------------------- DROP TABLE IF EXISTS `my_admin_department`; CREATE TABLE `my_admin_department` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desc` varchar(200) NOT NULL, `status` int(11) NOT NULL DEFAULT '1', `create_time` int(11) DEFAULT NULL, `update_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_department -- ---------------------------- INSERT INTO `my_admin_department` VALUES ('1', '行政部', '行政部', '1', '1478228668', '1478228668'); INSERT INTO `my_admin_department` VALUES ('2', '技術部', '技術部', '1', '1478228705', '1478228705'); -- ---------------------------- -- Table structure for my_admin_integral -- ---------------------------- DROP TABLE IF EXISTS `my_admin_integral`; CREATE TABLE `my_admin_integral` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `department_id` int(11) NOT NULL DEFAULT '1' COMMENT '部門id', `jobs_id` int(11) DEFAULT '1' COMMENT '職位ID', `integral_value` int(11) NOT NULL COMMENT 'Integral value', `validation` int(11) NOT NULL DEFAULT '0' COMMENT '驗證方法', `desc` varchar(100) DEFAULT NULL COMMENT '備注', `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態', `create_time` int(11) DEFAULT NULL, `update_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_integral -- ---------------------------- -- ---------------------------- -- Table structure for my_admin_jobs -- ---------------------------- DROP TABLE IF EXISTS `my_admin_jobs`; CREATE TABLE `my_admin_jobs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desc` varchar(100) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', `create_time` int(11) DEFAULT NULL, `update_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_jobs -- ---------------------------- INSERT INTO `my_admin_jobs` VALUES ('1', '班長', '', '1', '1478245107', '1478245107'); INSERT INTO `my_admin_jobs` VALUES ('2', '組長', '', '1', '1478245170', '1478245170'); -- ---------------------------- -- Table structure for my_admin_node -- ---------------------------- DROP TABLE IF EXISTS `my_admin_node`; CREATE TABLE `my_admin_node` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aid` int(11) DEFAULT NULL, `node_name` varchar(155) DEFAULT '' COMMENT '節點名稱', `module_name` varchar(155) DEFAULT '' COMMENT '模塊名', `control_name` varchar(155) DEFAULT '' COMMENT '控制器名', `action_name` varchar(155) DEFAULT NULL COMMENT '方法名', `is_menu` tinyint(1) DEFAULT '0' COMMENT '是否是菜單項 0不是 1是', `pid` int(11) DEFAULT NULL COMMENT '父級節點id', `icon` varchar(155) DEFAULT '' COMMENT '菜單樣式', `sort` tinyint(3) unsigned DEFAULT '255', `status` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL, `update_time` int(11) DEFAULT NULL, `group` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_node -- ---------------------------- INSERT INTO `my_admin_node` VALUES ('1', '1', '我的組織', '#', '#', '#', '1', '0', 'fa fa-globe', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('2', '1', '員工管理', 'admin', 'User', 'user', '1', '1', '', '3', '1', null, '1478489017', ''); INSERT INTO `my_admin_node` VALUES ('3', '1', '用戶修改', 'admin', 'User', 'useredit', '0', '2', '', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('4', '1', '還原密碼', 'admin', 'User', 'password', '0', '2', '', '2', '1', '1479705083', '1479707835', ''); INSERT INTO `my_admin_node` VALUES ('5', '1', '修改狀態', 'admin', 'User', 'setStatus', '0', '2', '', '3', '1', '1479707901', '1479707901', ''); INSERT INTO `my_admin_node` VALUES ('6', '1', '部門管理', 'admin', 'System', 'departmentlist', '1', '1', '', '255', '1', null, '1478489154', ''); INSERT INTO `my_admin_node` VALUES ('7', '1', '部門修改', 'admin', 'System', 'DepartmentEdit', '0', '6', '', '2', '1', '1479708131', '1479708131', ''); INSERT INTO `my_admin_node` VALUES ('8', '1', '狀態設置', 'admin', 'System', 'setStatus', '0', '6', '', '3', '1', '1479708149', '1479708149', ''); INSERT INTO `my_admin_node` VALUES ('9', '1', '工作職位', 'admin', 'System', 'jobslist', '1', '1', '', '255', '1', null, '1478489697', ''); INSERT INTO `my_admin_node` VALUES ('10', '1', '職位修改', 'admin', 'System', 'JobsEdit', '0', '9', '', '1', '1', '1479708339', '1479708339', ''); INSERT INTO `my_admin_node` VALUES ('11', '1', '狀態設置', 'admin', 'System', 'setStatus', '0', '9', '', '3', '1', '1479708373', '1479708373', ''); INSERT INTO `my_admin_node` VALUES ('12', '1', '系統管理', '#', '#', '#', '1', '0', 'fa fa-desktop', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('13', '1', '后臺角色', 'admin', 'Role', 'role', '1', '12', '', '255', '1', null, '1478489392', ''); INSERT INTO `my_admin_node` VALUES ('14', '1', '添加角色', 'admin', 'Role', 'roleadd', '0', '13', '', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('15', '1', '編輯角色', 'admin', 'Role', 'roleedit', '0', '13', '', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('16', '1', '刪除角色', 'admin', 'Role', 'roledel', '0', '13', '', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('17', '1', '分配權限', 'admin', 'Role', 'giveaccess', '0', '13', '', '255', '1', null, null, null); INSERT INTO `my_admin_node` VALUES ('18', '1', '數據備份', 'admin', 'Data', 'index', '1', '12', '', '255', '1', null, '1478486078', null); INSERT INTO `my_admin_node` VALUES ('19', '1', '備份數據', 'admin', 'Data', 'importdata', '1', '18', '', '255', '1', null, '1480673310', ''); INSERT INTO `my_admin_node` VALUES ('20', '1', '還原數據', 'admin', 'Data', 'backdata', '0', '18', '', '255', '1', null, '1478491159', ''); INSERT INTO `my_admin_node` VALUES ('21', '1', '后臺權限', 'admin', 'Node', 'node', '1', '12', '', '255', '1', null, '1478489411', ''); INSERT INTO `my_admin_node` VALUES ('22', '1', '后臺日志', 'admin', 'action', 'actionlog', '1', '12', '', '255', '1', '1475411492', '1478489442', ''); INSERT INTO `my_admin_node` VALUES ('23', '1', '微信管理', '#', '#', '#', '1', '0', 'fa fa-wechat', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('24', '1', '我的微信', 'admin', 'We', 'we', '1', '23', '', '255', '1', null, '1481959705', ''); INSERT INTO `my_admin_node` VALUES ('25', '1', '我的粉絲', 'admin', 'We', 'fans', '1', '23', '', '255', '1', null, '1481959716', ''); INSERT INTO `my_admin_node` VALUES ('26', '1', '微信菜單', 'admin', 'We', 'menu', '1', '23', '', '255', '1', null, '1481959724', ''); INSERT INTO `my_admin_node` VALUES ('27', '1', '微信菜單按鈕', 'admin', 'We', 'menuButton', '0', '26', '', '1', '1', '1482284604', '1482715400', ''); INSERT INTO `my_admin_node` VALUES ('28', '1', '微信菜單編輯', 'admin', 'We', 'menuEdit', '0', '26', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('29', '1', '微信菜單同步推送', 'admin', 'We', 'sendMenu', '0', '26', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('30', '1', '微信菜單按鈕編輯', 'admin', 'We', 'menuButtonEdit', '0', '26', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('31', '1', '會員管理', '#', '#', '#', '1', '0', 'fa fa-user', '1', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('32', null, '會員管理列表', 'admin', 'User', 'member', '1', '31', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('33', null, '會員修改', 'admin', 'User', 'memberEdit', '0', '32', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('34', null, '會員等級', 'admin', 'User', 'memberGrade', '1', '31', '', '255', '1', null, '1482715400', null); INSERT INTO `my_admin_node` VALUES ('35', null, '會員等級編輯', 'admin', 'User', 'memberGradeEdit', '0', '34', '', '255', '1', null, '1482715400', null); -- ---------------------------- -- Table structure for my_admin_role -- ---------------------------- DROP TABLE IF EXISTS `my_admin_role`; CREATE TABLE `my_admin_role` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `rolename` varchar(155) NOT NULL COMMENT '角色名稱', `rule` varchar(255) DEFAULT '' COMMENT '權限節點數據', `status` tinyint(4) DEFAULT '4', `create_time` int(11) DEFAULT NULL, `update_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_role -- ---------------------------- INSERT INTO `my_admin_role` VALUES ('1', '超級管理員', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,23,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40', '1', null, null); INSERT INTO `my_admin_role` VALUES ('2', '系統維護員', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,23,25', '1', null, null); INSERT INTO `my_admin_role` VALUES ('3', '運營人員', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,22,23,25', '1', null, null); -- ---------------------------- -- Table structure for my_admin_user -- ---------------------------- DROP TABLE IF EXISTS `my_admin_user`; CREATE TABLE `my_admin_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `department_id` int(11) DEFAULT NULL COMMENT '部門', `jobs_id` int(10) DEFAULT NULL COMMENT '職位', `weixin_openid` char(64) DEFAULT NULL, `banding_code` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '微信綁定碼', `role_id` int(11) NOT NULL, `aid_title` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '用戶名', `simple_name` varchar(30) DEFAULT NULL COMMENT '用戶簡稱', `nickname` varchar(30) NOT NULL COMMENT '用戶名', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '密碼', `birthday` varchar(10) DEFAULT NULL, `calendar` tinyint(4) DEFAULT '0' COMMENT '0陽歷，1農歷', `loginnum` int(11) DEFAULT '0' COMMENT '登陸次數', `last_login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '最后登錄IP', `last_login_time` int(11) DEFAULT '0' COMMENT '最后登錄時間', `status` int(1) DEFAULT '0' COMMENT '狀態', `typeid` int(11) DEFAULT '1' COMMENT '用戶角色id', `position` varchar(32) DEFAULT NULL, `mobile` char(15) NOT NULL COMMENT '用戶手機', `gender` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性別', `qq` char(32) NOT NULL, `email` char(32) NOT NULL COMMENT '用戶郵箱', `weixinid` char(32) NOT NULL, `avatar` varchar(255) DEFAULT NULL, `extattr` text, `marriage` tinyint(4) DEFAULT NULL, `idcard` varchar(18) DEFAULT NULL, `bankcard` varchar(25) DEFAULT NULL, `joinday` int(10) DEFAULT NULL, `join_from` tinyint(4) DEFAULT NULL, `leaveday` int(10) DEFAULT NULL, `leave_type` tinyint(4) DEFAULT NULL, `leave_why` varchar(100) DEFAULT NULL, `description` text, `address` varchar(20) DEFAULT NULL, `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余額', `update_time` int(11) NOT NULL, `create_time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of my_admin_user -- ---------------------------- INSERT INTO `my_admin_user` VALUES ('1', '1', '0', 'oO059v39zsst76IkuiYV3yMvc4Sw', '55229586246', '0', '', 'mikkle', '', '何大鵬', 'b74ba7b7e2d0f1e7b9c834f52d84f04a', '', '0', '173', '14.153.203.45', '1485914301', '1', '1', '', '17092610050', '0', '', '', '', null, '', '0', '', '', '0', '0', '0', '0', '', null, '', '0.00', '1480426399', '0'); INSERT INTO `my_admin_user` VALUES ('2', '2', '1', '', '', '1', null, 'admin', null, '超級管理員', 'f4a11cdf4ea5c8173800767de05f622c', '', '0', '22', '219.134.109.157', '1486449550', '1', '1', '', '', '1', '', '', '', null, null, '0', '', '', '0', '0', '0', '0', '', null, '', '0.00', '1480673171', '1480673171'); ~~~