SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for oa_admin -- ---------------------------- DROP TABLE IF EXISTS `oa_admin`; CREATE TABLE `oa_admin` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` varchar(100) NOT NULL DEFAULT '' COMMENT 'WeCom userid', `username` varchar(100) NOT NULL DEFAULT '' COMMENT 'Login username', `pwd` varchar(100) NOT NULL DEFAULT '' COMMENT 'Login password', `salt` varchar(100) NOT NULL DEFAULT '' COMMENT 'Password salt', `reg_pwd` varchar(100) NOT NULL DEFAULT '' COMMENT 'Initial password', `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Employee name', `email` varchar(100) NOT NULL DEFAULT '' COMMENT 'Email', `mobile` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Mobile number', `sex` int(1) NOT NULL DEFAULT 0 COMMENT 'Gender: 1 male, 2 female', `nickname` varchar(100) NOT NULL DEFAULT '' COMMENT 'Nickname', `thumb` varchar(255) NOT NULL COMMENT 'Avatar', `theme` varchar(50) NOT NULL DEFAULT 'white' COMMENT 'System theme', `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Primary department id', `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'Manager id', `position_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Position id', `position_name` int(11) NOT NULL DEFAULT 0 COMMENT 'Job title', `position_rank` int(11) NOT NULL DEFAULT 0 COMMENT 'Job rank', `type` int(1) NOT NULL DEFAULT 0 COMMENT 'Employee type: 0 unset, 1 full-time, 2 probation, 3 intern', `is_staff` int(1) NOT NULL DEFAULT 1 COMMENT 'Identity type: 1 employee, 2 contractor, 3 part-time', `job_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Employee number', `birthday` varchar(255) NOT NULL DEFAULT '' COMMENT 'Birthday', `age` int(11) NOT NULL DEFAULT 0 COMMENT 'Age', `work_date` varchar(255) NOT NULL DEFAULT '' COMMENT 'Work start date', `work_location` int(11) NOT NULL DEFAULT 0 COMMENT 'Work location', `native_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Native place', `nation` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ethnicity', `home_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Home address', `current_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Current address', `contact` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact', `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact phone', `resident_type` int(1) NOT NULL DEFAULT 0 COMMENT 'Household type: 1 rural, 2 urban', `resident_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Household location', `graduate_school` varchar(255) NOT NULL DEFAULT '' COMMENT 'School', `graduate_day` int(11) NOT NULL DEFAULT 0 COMMENT 'Graduation date', `political` int(1) NOT NULL DEFAULT 1 COMMENT 'Political status: 1 party member, 2 league member', `marital_status` int(1) NOT NULL DEFAULT 1 COMMENT 'Marital status: 1 single, 2 married, 3 divorced', `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID card', `education` varchar(255) NOT NULL DEFAULT '' COMMENT 'Degree', `speciality` varchar(255) NOT NULL DEFAULT '' COMMENT 'Major', `social_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Social security account', `medical_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Medical insurance account', `provident_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Housing fund account', `bank_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank card number', `bank_info` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments', `desc` mediumtext NULL COMMENT 'Employee profile', `is_hide` int(1) NOT NULL DEFAULT 0 COMMENT 'Hide contact info: 0 no, 1 yes', `entry_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Entry date', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Registered at', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Updated at', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `last_login_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Last login time', `login_num` int(11) NOT NULL DEFAULT 0 COMMENT 'Login count', `last_login_ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'Last login IP', `is_lock` int(1) NOT NULL DEFAULT 0 COMMENT 'Lock screen: 1 yes, 0 no', `auth_did` int(2) NOT NULL DEFAULT 0 COMMENT 'Data permission type:0,1,2,3,4,5,6,7,8,9,10', `auth_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Visible departments', `son_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Visible sub-departments', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1,0,1,2', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Employee table'; -- ---------------------------- -- Table structure for oa_admin_profiles -- ---------------------------- DROP TABLE IF EXISTS `oa_admin_profiles`; CREATE TABLE `oa_admin_profiles` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID', `types` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:1/2/3/4/5', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '//Name/Name/Name/Name/', `start_time` varchar(255) NOT NULL DEFAULT '' COMMENT 'Start time', `end_time` varchar(255) NOT NULL DEFAULT '' COMMENT 'End time', `speciality` varchar(50) NOT NULL DEFAULT '' COMMENT 'Major', `education` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `authority` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `know` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `sort` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_labor_contract -- ---------------------------- DROP TABLE IF EXISTS `oa_labor_contract`; CREATE TABLE `oa_labor_contract` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `renewal_pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `change_pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID', `cate` int(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3', `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2,2', `enterprise_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `properties` int(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `secure_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `trial_months` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment', `trial_end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `trial_salary` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `worker_salary` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_admin_log -- ---------------------------- DROP TABLE IF EXISTS `oa_admin_log`; CREATE TABLE `oa_admin_log` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `type` varchar(80) NOT NULL DEFAULT '' COMMENT 'Type', `action` varchar(80) NOT NULL DEFAULT '' COMMENT 'Comment', `subject` varchar(80) NOT NULL DEFAULT '' COMMENT 'Comment', `module` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment', `controller` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment', `function` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'ip', `param_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `param` mediumtext NULL COMMENT 'json', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_admin_module -- ---------------------------- DROP TABLE IF EXISTS `oa_admin_module`; CREATE TABLE `oa_admin_module` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',,', `desc` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `type` int(2) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3', `sourse` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_admin_module -- ---------------------------- INSERT INTO `oa_admin_module` VALUES (1, 'System Module', 'home','', 1, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (2, 'HR Module', 'user','', 1, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (3, 'Administration Module', 'adm','', 1, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (4, 'Office Module', 'office','', 1, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (5, 'Finance Module', 'finance','', 1, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (6, 'Customer Module', 'customer','', 2, 1,1, 1639562910, 0); INSERT INTO `oa_admin_module` VALUES (7, 'Contract Module', 'contract','', 2, 1,1, 1656142368, 0); INSERT INTO `oa_admin_module` VALUES (8, 'Project Module', 'project','', 2, 1,1, 1656142368, 0); INSERT INTO `oa_admin_module` VALUES (9, 'Disk Module', 'disk','', 2, 1,1, 1656143065, 0); -- ---------------------------- -- Table structure for oa_admin_rule -- ---------------------------- DROP TABLE IF EXISTS `oa_admin_rule`; CREATE TABLE `oa_admin_rule` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `src` varchar(255) NOT NULL DEFAULT '' COMMENT 'url', `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `module` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `menu` int(1) NOT NULL DEFAULT 0 COMMENT ',1,2', `sort` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status,0,1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_admin_rule -- ---------------------------- INSERT INTO `oa_admin_rule` VALUES (1, 0, '', 'System Management', 'System Management', 'home', 'icon-jichupeizhi', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (2, 0, '', 'Master Data', 'Master Data', 'base', 'icon-hetongshezhi', 1, 2, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (3, 0, '', 'HR Management', 'HR Management', 'user', 'icon-renshishezhi', 1, 3, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (4, 0, '', 'Administration', 'Administration', 'adm', 'icon-banjiguanli', 1, 4, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (5, 0, '', 'Personal Office', 'Personal Office', 'office', 'icon-kaoshijihua', 1, 5, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (6, 0, '', 'Finance', 'Finance', 'finance', 'icon-yuangongtidian', 1, 6, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (7, 0, '', 'Customers', 'Customers', 'customer', 'icon-kehuguanli', 1, 7, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (8, 0, '', 'Contracts', 'Contracts', 'contract', 'icon-hetongyidong', 1, 8, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (9, 0, '', 'Projects', 'Projects', 'project', 'icon-xiangmuguanli', 1, 9, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (10, 0, '', 'Knowledge Drive', 'Knowledge Drive', 'disk', 'icon-tikuguanli', 1, 10, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (11, 1, 'home/conf/index', 'System Settings', 'System Settings', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (12, 11, 'home/conf/add', 'Create/Edit', 'Config Item', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (13, 11, 'home/conf/delete', 'Delete', 'Config Item', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (14, 11, 'home/conf/edit', 'Edit', 'Config Details', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (15, 1, 'home/module/index', 'Modules', 'Modules', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (16, 15, 'home/module/add', 'Create/Edit', 'Modules', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (17, 15, 'home/module/del', 'Delete', 'Modules', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (18, 15, 'home/module/recovery', 'Restore', 'Modules', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (19, 15, 'home/module/install', 'Install', 'Modules', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (20, 1, 'home/dataauth/index', 'Module Settings', 'Module Settings', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (21, 20, 'home/dataauth/edit', 'Edit', 'Module Settings', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (22, 1, 'home/rule/index', 'Feature Nodes', 'Feature Nodes', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (23, 22, 'home/rule/add', 'Create/Edit', 'Feature Nodes', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (24, 22, 'home/rule/delete', 'Delete', 'Feature Nodes', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (25, 1, 'mobile/bar/datalist', 'Mobile Configuration', 'Mobile Configuration', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (26, 25, 'mobile/bar/datalist', 'BAR Menu', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (27, 26, 'mobile/bar/add', 'Create/Edit', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (28, 26, 'mobile/bar/set', 'Settings', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (29, 25, 'mobile/types/datalist', 'Workspace Menu Types', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (30, 29, 'mobile/types/add', 'Create/Edit', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (31, 29, 'mobile/types/del', 'Delete', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (32, 29, 'mobile/types/set', 'Settings', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (33, 25, 'mobile/menu/datalist', 'Workspace Menu', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (34, 33, 'mobile/menu/add', 'Create/Edit', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (35, 33, 'mobile/menu/del', 'Delete', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (36, 33, 'mobile/menu/set', 'Settings', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (37, 1, 'home/role/index', 'Roles & Permissions', 'Roles & Permissions', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (38, 37, 'home/role/add', 'Create/Edit', 'Roles & Permissions', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (39, 37, 'home/role/delete', 'Delete', 'Roles & Permissions', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (40, 1, 'home/log/index', 'Operation Log', 'Operation Log', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (41, 1, 'home/files/index', 'Attachment Management','Attachment Management', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (42, 41, 'home/files/edit', 'EditAttachment','Attachment', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (43, 41, 'home/files/move', 'Move Attachment','Attachment', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (44, 41, 'home/files/delete', 'DeleteAttachment','Attachment', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (45, 41, 'home/files/get_group', 'Attachment Groups','Attachment Groups', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (46, 41, 'home/files/add_group', 'Create/Edit','Attachment Groups', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (47, 41, 'home/files/del_group', 'DeleteAttachment Groups','Attachment Groups', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (48, 1, 'home/database/database', 'Backup Data', 'Data Backup', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (49, 48, 'home/database/backup', 'Backup Tables', 'Data', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (50, 48, 'home/database/optimize', 'Optimize Tables', 'Tables', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (51, 48, 'home/database/repair', 'Repair Tables', 'Tables', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (52, 1, 'home/database/backuplist', 'Restore Data', 'Data Restore', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (53, 52, 'home/database/import', 'Restore Tables', 'Data', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (54, 52, 'home/database/downfile', 'Backup Data', 'Backup Data', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (55, 52, 'home/database/del', 'DeleteBackup Data', 'Backup Data', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (56, 1, 'home/task/index', 'Scheduled Tasks', 'Scheduled Tasks', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (57, 56, 'home/task/add', 'Create/Edit', 'Scheduled Tasks', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (58, 56, 'home/task/delete', 'Delete', 'Scheduled Tasks', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (59, 2, '', 'Common Module', 'Common Module', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (60, 59, 'home/template/datalist', 'Message Templates', 'Message Templates', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (61, 60, 'home/template/add', 'Create/Edit', 'Message Templates', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (62, 60, 'home/template/set', 'Settings', 'Message Templates', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (63, 60, 'home/template/view', 'View', 'Message Templates', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (64, 59, 'adm/flow/modulelist', 'Approval Modules', 'Approval Modules', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (65, 64, 'adm/flow/module_add', 'Create/Edit', 'Approval Modules', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (66, 64, 'adm/flow/module_check', 'Settings', 'Approval Modules', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (67, 59, 'adm/flow/catelist', 'Approval Categories', 'Approval Categories', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (68, 67, 'adm/flow/cate_add', 'Create/Edit', 'Approval Categories', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (69, 67, 'adm/flow/cate_check', 'Settings', 'Approval Categories', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (70, 59, 'adm/flow/datalist', 'Approval Workflows', 'Approval Workflows', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (71, 70, 'adm/flow/add', 'Create/Edit', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (72, 70, 'adm/flow/del', 'Delete', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (73, 70, 'adm/flow/check', 'Settings', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (74, 59, 'home/cate/enterprise', 'Company Entity', 'Company Entity', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (75, 74, 'home/cate/enterprise_add', 'Create/Edit', 'Company Entity', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (76, 74, 'home/cate/enterprise_check', 'Settings', 'Company Entity', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (77, 59, 'home/area/datalist', 'Provinces & Cities', 'Provinces & Cities', 'home', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (78, 77, 'home/area/add', 'Create/Edit', 'Provinces & Cities', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (79, 77, 'home/area/set', 'Settings', 'Provinces & Cities', 'home', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (80, 2, '', 'HR Module', 'HR Module', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (81, 80, 'user/rewardscate/datalist', 'Reward/Penalty Items', 'Reward/Penalty Items', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (82, 81, 'user/rewardscate/add', 'Create/Edit', 'Reward/Penalty Items', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (83, 81, 'user/rewardscate/set', 'Settings', 'Reward/Penalty Items', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (84, 80, 'user/carecate/datalist', 'Care Items', 'Care Items', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (85, 84, 'user/carecate/add', 'Create/Edit', 'Care Items', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (86, 84, 'user/carecate/set', 'Settings', 'Care Items', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (87, 80, 'user/basic/datalist', 'Data', 'Data', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (88, 87, 'user/basic/add', 'Create/Edit', 'Data', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (89, 87, 'user/basic/set', 'Settings', 'Data', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (90, 3, 'user/department/index', 'Department Structure', 'Department', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (91, 90, 'user/department/add', 'Create/Edit', 'Department', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (92, 90, 'user/department/delete', 'Delete', 'Department', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (93, 3, 'user/position/index', 'Positions & Titles', 'Positions & Titles', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (94, 93, 'user/position/add', 'Create/Edit', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (95, 93, 'user/position/delete', 'Delete', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (96, 93, 'user/position/view', 'View', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (97, 3, 'user/user/index', 'Employees', 'Item', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (98, 97, 'user/user/add', 'Create/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (99, 97, 'user/user/view', 'View', 'Employee Info', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (100, 97, 'user/user/set', 'Settings', 'Employee Status', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (101, 97, 'user/user/reset_psw', 'Reset Password', 'Employee Password', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (102, 97, 'user/user/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (103, 3, 'user/files/datalist', 'Employee Files', 'Employee Files', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (104, 103, 'user/files/add', 'Edit', 'Employee Files', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (105, 103, 'user/files/view', 'View', 'Employee Files', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (106, 3, 'user/personal/change', 'Personnel Transfer', 'Personnel Transfer', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (107, 106, 'user/personal/change_add', 'Create/Edit', 'Personnel Transfer', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (108, 3, 'user/personal/leave', 'Resignation Request', 'Resignation Request', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (109, 108, 'user/personal/leave_add', 'Create/Edit', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (110, 108, 'user/personal/leave_delete', 'Delete', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (111, 108, 'user/personal/leave_view', 'View', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (112, 3, 'user/rewards/datalist', 'Rewards & Penalties', 'Rewards & Penalties', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (113, 112, 'user/rewards/add', 'Create/Edit', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (114, 112, 'user/rewards/view', 'View', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (115, 112, 'user/rewards/del', 'Delete', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (116, 3, 'user/care/datalist', 'Employee Care', 'Employee Care', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (117, 116, 'user/care/add', 'Create/Edit', 'Employee Care', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (118, 116, 'user/care/view', 'View', 'Employee Care', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (119, 116, 'user/care/del', 'Delete', 'Employee Care', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (120, 3, 'user/laborcontract/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (121, 120, 'user/laborcontract/add', 'Create/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (122, 120, 'user/laborcontract/add_renewal', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (123, 120, 'user/laborcontract/add_change', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (124, 120, 'user/laborcontract/view', 'View', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (125, 120, 'user/laborcontract/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (126, 120, 'user/laborcontract/set', 'Settings', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (127, 2, '', 'Administration Module', 'Administration Module', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (128, 127, 'adm/propertycate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (129, 128, 'adm/propertycate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (130, 128, 'adm/propertycate/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (131, 127, 'adm/propertybrand/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (132, 131, 'adm/propertybrand/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (133, 131, 'adm/propertybrand/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (134, 127, 'adm/propertyunit/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (135, 134, 'adm/propertyunit/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (136, 134, 'adm/propertyunit/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (137, 127, 'adm/sealcate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (138, 137, 'adm/sealcate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (139, 137, 'adm/sealcate/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (140, 127, 'adm/basic/datalist', 'Data', 'Data', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (141, 140, 'adm/basic/add', 'Create/Edit', 'Data', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (142, 140, 'adm/basic/set', 'Settings', 'Data', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (143, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (144, 143, 'adm/property/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (145, 144, 'adm/property/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (146, 144, 'adm/property/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (147, 144, 'adm/property/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (148, 143, 'adm/property/repair_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (149, 148, 'adm/property/repair_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (150, 148, 'adm/property/repair_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (151, 148, 'adm/property/repair_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (152, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (153, 152, 'adm/car/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (154, 153, 'adm/car/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (155, 153, 'adm/car/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (156, 153, 'adm/car/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (157, 152, 'adm/car/repair_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (158, 157, 'adm/car/repair_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (159, 157, 'adm/car/repair_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (160, 157, 'adm/car/repair_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (161, 152, 'adm/car/protect_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (162, 161, 'adm/car/protect_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (163, 161, 'adm/car/protect_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (164, 161, 'adm/car/protect_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (165, 152, 'adm/car/mileage_list', 'Item', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (166, 165, 'adm/car/mileage_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (167, 165, 'adm/car/mileage_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (168, 152, 'adm/car/fee_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (169, 168, 'adm/car/fee_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (170, 168, 'adm/car/fee_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (171, 168, 'adm/car/fee_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (172, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (173, 172, 'adm/meeting/room', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (174, 173, 'adm/meeting/room_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (175, 173, 'adm/meeting/room_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (176, 173, 'adm/meeting/room_check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (177, 172, 'adm/meeting/records', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (178, 177, 'adm/meeting/records_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (179, 177, 'adm/meeting/records_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (180, 177, 'adm/meeting/records_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (181, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (182, 181, 'adm/official/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (183, 182, 'adm/official/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (184, 182, 'adm/official/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (185, 182, 'adm/official/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (186, 181, 'adm/official/pending', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (187, 181, 'adm/official/reviewed', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (188, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (189, 188, 'adm/seal/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (190, 189, 'adm/seal/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (191, 189, 'adm/seal/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (192, 189, 'adm/seal/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (193, 188, 'adm/seal/record', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (194, 127, 'adm/notecate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (195, 194, 'adm/notecate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (196, 194, 'adm/notecate/set', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (197, 4, 'adm/note/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (198, 197, 'adm/note/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (199, 197, 'adm/note/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (200, 197, 'adm/note/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (201, 4, 'adm/news/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (202, 201, 'adm/news/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (203, 201, 'adm/news/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (204, 201, 'adm/news/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (205, 5, 'oa/plan/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (206, 205, 'oa/plan/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (207, 205, 'oa/plan/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (208, 205, 'oa/plan/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (209, 5, 'oa/plan/calendar', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (210, 5, 'oa/schedule/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (211, 210, 'oa/schedule/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (212, 210, 'oa/schedule/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (213, 210, 'oa/schedule/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (214, 5, 'oa/schedule/calendar', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (215, 5, 'oa/work/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (216, 215, 'oa/work/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (217, 215, 'oa/work/send', 'Item', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (218, 215, 'oa/work/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (219, 215, 'oa/work/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (220, 5, 'oa/note/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (221, 220, 'oa/note/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (222, 5, 'oa/news/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (223, 222, 'oa/news/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (224, 5, 'oa/meeting/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (225, 224, 'oa/meeting/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (226, 2, '', 'Finance Module', 'Finance Module', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (227, 226, 'finance/expensecate/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (228, 227, 'finance/expensecate/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (229, 227, 'finance/expensecate/set', 'Settings', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (230, 226, 'finance/costcate/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (231, 230, 'finance/costcate/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (233, 230, 'finance/costcate/set', 'Settings', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (234, 6, 'finance/expense/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (235, 234, 'finance/expense/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (236, 234, 'finance/expense/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (237, 234, 'finance/expense/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (238, 6, 'finance/invoice/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (239, 238, 'finance/invoice/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (240, 238, 'finance/invoice/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (241, 238, 'finance/invoice/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (242, 6, 'finance/ticket/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (243, 242, 'finance/ticket/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (244, 242, 'finance/ticket/delete', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (245, 242, 'finance/ticket/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (246, 6, 'finance/income/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (247, 246, 'finance/income/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (248, 246, 'finance/income/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (249, 246, 'finance/income/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (250, 6, 'finance/invoice/datalist_a', 'Item', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (251, 250, 'finance/invoice/add_a', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (252, 250, 'finance/invoice/del_a', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (253, 250, 'finance/invoice/view_a', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (254, 6, 'finance/payment/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (255, 254, 'finance/payment/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (256, 254, 'finance/payment/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (257, 254, 'finance/payment/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (258, 6, 'finance/ticket/datalist_a', 'Item', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (259, 258, 'finance/ticket/add_a', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (260, 258, 'finance/ticket/del_a', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (261, 258, 'finance/ticket/view_a', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (262, 6, '', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (263, 262, 'finance/expense/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (264, 262, 'finance/invoice/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (265, 262, 'finance/ticket/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (266, 262, 'finance/income/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (267, 262, 'finance/payment/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (268, 2, '', 'Customer Module', 'Customer Module', 'customer', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (269, 268, 'customer/industry/datalist', 'Item', 'Item', 'home', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (270, 269, 'customer/industry/add', 'Create/Edit', 'Item', 'home', '', 2, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (271, 269, 'customer/industry/set', 'Settings', 'Item', 'home', '', 2, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (272, 268, 'customer/grade/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (273, 272, 'customer/grade/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (274, 272, 'customer/grade/set', 'Settings', 'Item', 'customer', '', 2,0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (275, 268, 'customer/source/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (276, 275, 'customer/source/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (277, 275, 'customer/source/set', 'Settings', 'Item', 'customer', '', 2,0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (278, 268, 'customer/basic/datalist', 'Data', 'Data', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (279, 278, 'customer/basic/add', 'Create/Edit', 'Data', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (280, 278, 'customer/basic/set', 'Settings', 'Data', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (281, 7, 'customer/customer/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (282, 281, 'customer/customer/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (283, 281, 'customer/customer/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (284, 281, 'customer/customer/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (285, 7, 'customer/index/rush', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (286, 7, 'customer/index/sea', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (287, 286, 'customer/index/to_get', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (288, 286, 'customer/index/to_divide', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (289, 286, 'customer/index/to_sea', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (290, 286, 'customer/index/to_trash', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (291, 286, 'customer/index/to_revert', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (292, 7, 'customer/index/trash', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0); INSERT INTO `oa_admin_rule` VALUES (293, 7, 'customer/contact/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (294, 286, 'customer/contact/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (295, 286, 'customer/contact/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (296, 286, 'customer/contact/view', 'View', 'Item', 'customer', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (297, 7, 'customer/chance/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (298, 297, 'customer/chance/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (299, 297, 'customer/chance/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (300, 297, 'customer/chance/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (301, 7, 'customer/trace/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (302, 301, 'customer/trace/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (303, 301, 'customer/trace/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (304, 301, 'customer/trace/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (305, 2, '', 'Contract Module', 'Contract Module', 'contract', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (306, 305, 'contract/cate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (307, 306, 'contract/cate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 0, 1656143065); INSERT INTO `oa_admin_rule` VALUES (308, 306, 'contract/cate/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (309, 305, 'contract/productcate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (310, 309, 'contract/productcate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (311, 309, 'contract/productcate/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (312, 305, 'contract/product/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (313, 312, 'contract/product/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (314, 312, 'contract/product/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (315, 312, 'contract/product/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (316, 312, 'contract/product/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (317, 305, 'contract/services/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (318, 317, 'contract/services/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (319, 317, 'contract/services/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (320, 305, 'contract/supplier/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (321, 320, 'contract/supplier/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (322, 320, 'contract/supplier/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (323, 320, 'contract/supplier/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (324, 320, 'contract/supplier/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (325, 320, 'contract/supplier/contact_add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (326, 320, 'contract/supplier/contact_del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (327, 305, 'contract/purchasedcate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (328, 327, 'contract/purchasedcate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (329, 327, 'contract/purchasedcate/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (330, 305, 'contract/purchased/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (331, 330, 'contract/purchased/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (332, 330, 'contract/purchased/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (333, 330, 'contract/purchased/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (334, 330, 'contract/purchased/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (335, 8, 'contract/contract/datalist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (336, 335, 'contract/contract/add', 'Create/Edit', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (337, 335, 'contract/contract/view', 'View', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (338, 335, 'contract/contract/del', 'Delete', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (339, 8, 'contract/purchase/datalist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (340, 339, 'contract/purchase/add', 'Create/Edit', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (341, 339, 'contract/purchase/view', 'View', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (342, 339, 'contract/purchase/del', 'Delete', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (343, 8, 'contract/contract/archivelist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (344, 343, 'contract/purchase/archivelist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (345, 8, 'contract/contract/stoplist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (346, 345, 'contract/purchase/stoplist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (347, 8, 'contract/contract/voidlist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (348, 347, 'contract/purchase/voidlist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (349, 2, '', 'Project Module', 'Project Module', 'project', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (350, 349, 'project/step/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (351, 350, 'project/step/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (352, 350, 'project/step/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (353, 349, 'project/cate/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (354, 353, 'project/cate/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 0, 1656143065); INSERT INTO `oa_admin_rule` VALUES (355, 353, 'project/cate/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (356, 349, 'project/work/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (357, 356, 'project/work/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (358, 356, 'project/work/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (359, 9, 'project/index/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (360, 359, 'project/index/add', 'Create', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (361, 359, 'project/index/edit', 'Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (362, 359, 'project/index/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (363, 359, 'project/index/del', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (364, 9, 'project/task/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (365, 364, 'project/task/add', 'Create', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (366, 364, 'project/task/edit', 'Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (367, 364, 'project/task/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (368, 364, 'project/task/del', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (369, 9, 'project/task/hour', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (370, 9, 'project/document/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (371, 370, 'project/document/add', 'Create/Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (372, 370, 'project/document/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (373, 370, 'project/document/delete', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0); INSERT INTO `oa_admin_rule` VALUES (374, 10, 'disk/index/datalist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (375, 374, 'disk/index/add_upload', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (376, 374, 'disk/index/add_folder', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (377, 374, 'disk/index/add_article', '/Edit', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (378, 374, 'disk/index/view_article', 'View', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (379, 374, 'disk/index/del', 'Delete', '//', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (380, 374, 'disk/index/rename', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (381, 374, 'disk/index/move', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (382, 374, 'disk/index/star', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (383, 374, 'disk/index/unstar', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (384, 374, 'disk/index/back', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (385, 374, 'disk/index/clear', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (386, 10, 'disk/index/sharelist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (387, 386, 'disk/index/add_group', 'Create/Edit','Item', 'disk', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (388, 386, 'disk/index/del_group', 'Delete','Item', 'disk', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (389, 10, 'disk/index/clearlist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0); INSERT INTO `oa_admin_rule` VALUES (390, 6, 'finance/loan/datalist', 'Item', 'Item', 'finance', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (391, 390, 'finance/loan/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (392, 390, 'finance/loan/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (393, 390, 'finance/loan/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (394, 262, 'finance/loan/record', 'Item', 'Item', 'finance', '', 1, 0, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (395, 3, 'user/talent/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (396, 395, 'user/talent/add', '/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (397, 395, 'user/talent/view', 'View', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (398, 395, 'user/talent/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (399, 395, 'user/talent/set', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (400, 3, 'user/blacklist/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (401, 400, 'user/blacklist/add', 'Edit', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (402, 400, 'user/blacklist/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0); INSERT INTO `oa_admin_rule` VALUES (403, 106, 'user/personal/change_view', 'View', 'Personnel Transfer', 'user', '', 2, 1, 1, 0, 0); -- ---------------------------- -- Table structure for oa_admin_group -- ---------------------------- DROP TABLE IF EXISTS `oa_admin_group`; CREATE TABLE `oa_admin_group` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '', `status` int(1) NOT NULL DEFAULT 1, `rules` mediumtext NULL COMMENT 'id', `layouts` mediumtext NULL COMMENT 'Comment', `mobile_bar` mediumtext NULL COMMENT 'Bar', `mobile_menu` mediumtext NULL COMMENT 'Comment', `desc` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0, `update_time` bigint(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_admin_group -- ---------------------------- INSERT INTO `oa_admin_group` VALUES (1, 'Item', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403', '1,2,3,4,5,6,7,8,9,10,11,12','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16',',,Data,,Delete.', 0, 0); INSERT INTO `oa_admin_group` VALUES (2, 'Item', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403','1,2,3,4,5,6,7,8,9,10,11,12','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 'Roles & Permissions,.', 0, 0); INSERT INTO `oa_admin_group` VALUES (3, 'Item', 1, '4,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,197,198,199,200,201,202,203,204,5,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,6,390,391,392,393,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,394,263,264,265,266,267,7,281,282,283,284,285,286,287,288,289,290,291,294,295,296,292,293,297,298,299,300,301,302,303,304,8,335,336,337,338,339,340,341,342,343,344,345,346,347,348,9,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,10,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 'Roles & Permissions,.', 0, 0); -- ---------------------------- -- Table structure for oa_data_auth -- ---------------------------- DROP TABLE IF EXISTS `oa_data_auth`; CREATE TABLE `oa_data_auth` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',', `desc` mediumtext NULL COMMENT 'Comment', `module` varchar(255) NOT NULL DEFAULT '' COMMENT ',,', `uids` mediumtext NULL COMMENT ',1,2,3', `conf_1` mediumtext NULL COMMENT '1,', `conf_2` mediumtext NULL COMMENT '2,', `conf_3` mediumtext NULL COMMENT '3,', `conf_4` mediumtext NULL COMMENT '4,', `conf_5` mediumtext NULL COMMENT '5,', `conf_6` mediumtext NULL COMMENT '6,', `conf_7` mediumtext NULL COMMENT '7,', `conf_8` mediumtext NULL COMMENT '8,', `conf_9` mediumtext NULL COMMENT '9,', `conf_10` mediumtext NULL COMMENT '9,', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_data_auth -- ---------------------------- INSERT INTO `oa_data_auth` VALUES (1, 'Item', 'office_admin', 'Data.', 'office', '', '', '3', '', '', '', '', '', '', '', '', 1656143065, 1724830718); INSERT INTO `oa_data_auth` VALUES (2, 'Finance Module', 'finance_admin', 'Data.', 'finance', '', '', '', '', '', '', '', '', '', '', '', 1656143065, 0); INSERT INTO `oa_data_auth` VALUES (3, 'Customer Module', 'customer_admin', 'Customer ModuleData.', 'customer', '', '', '10', '100', '', '', '', '', '', '', '', 1656143065, 1724830738); INSERT INTO `oa_data_auth` VALUES (4, 'Contract Module', 'contract_admin', 'Contract ModuleData.', 'contract', '', '', '1', '1', '1', '1', '1', '1', '', '', '30', 1656143065, 1724830772); INSERT INTO `oa_data_auth` VALUES (5, 'Project Module', 'project_admin', 'Project ModuleData.', 'project', '', '', '', '', '', '', '', '', '', '', '3', 1656143065, 0); INSERT INTO `oa_data_auth` VALUES (6, 'Disk Module', 'disk_admin', 'Disk ModuleData.', 'disk', '', '', '', '', '', '', '', '', '', '', '', 1656143065, 0); -- ---------------------------- -- Table structure for oa_config -- ---------------------------- DROP TABLE IF EXISTS `oa_config`; CREATE TABLE `oa_config` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_config -- ---------------------------- INSERT INTO `oa_config`VALUES (1, 'Item', 'web', 'a:10:{s:2:\"id\";s:1:\"1\";s:11:\"admin_title\";s:2:\"OA\";s:6:\"domain\";s:24:\"https://www.gougucms.com\";s:3:\"icp\";s:12:\"ICPxxxxxxx-1\";s:4:\"logo\";s:31:\"/static/home/images/syslogo.png\";s:4:\"file\";s:0:\"\";s:10:\"small_logo\";s:37:\"/static/home/images/syslogo_small.png\";s:5:\"beian\";s:9:\"xxxxxxx-1\";s:8:\"keywords\";s:2:\"OA\";s:4:\"desc\";s:76:\"ThinkPHP8 + Layui + MySql,.Settings. Data. . . . . . . . . . .,,,,,CRM,ERP,.\";}', 1, 1612514630, 1724823769); INSERT INTO `oa_config`VALUES (2, 'Item', 'system', 'a:8:{s:9:\"menu_mode\";s:9:\"classical\";s:19:\"upload_max_filesize\";s:2:\"50\";s:9:\"msg_sound\";s:1:\"1\";s:9:\"watermark\";s:1:\"1\";s:6:\"qrcode\";s:1:\"2\";s:7:\"version\";s:5:\"5.0.2\";s:9:\"copyright\";s:24:\"© 2021-2025 gouguoa.com\";s:2:\"id\";s:1:\"2\";}', 1, 1612514630, 1724824879); INSERT INTO `oa_config`VALUES (3, 'Item', 'email', 'a:8:{s:2:\"id\";s:1:\"2\";s:4:\"smtp\";s:11:\"smtp.qq.com\";s:9:\"smtp_port\";s:3:\"465\";s:9:\"smtp_user\";s:15:\"gougucms@qq.com\";s:8:\"smtp_pwd\";s:6:\"123456\";s:4:\"from\";s:3:\"CMS\";s:5:\"email\";s:18:\"admin@gougucms.com\";s:8:\"template\";s:65:\"

ThinkPHP8 + Layui + MySql,.Settings. . . . .,,,,,CRM,ERP,.

\";}', 1, 1612521657, 1637075205); INSERT INTO `oa_config`VALUES (4, 'Api Token', 'token', 'a:5:{s:2:\"id\";s:1:\"3\";s:3:\"iss\";s:15:\"oa.gougucms.com\";s:3:\"aud\";s:7:\"gouguoa\";s:7:\"secrect\";s:7:\"GOUGUOA\";s:7:\"exptime\";s:4:\"3600\";}', 1, 1627313142, 1638010233); INSERT INTO `oa_config`VALUES (5, 'Item', 'other', 'a:3:{s:2:\"id\";s:1:\"5\";s:6:\"author\";s:0:\"\";s:7:\"version\";s:13:\"v1.2025.06.06\";}', 1, 1613725791, 1724824410); -- ---------------------------- -- Table structure for oa_timing_task -- ---------------------------- DROP TABLE IF EXISTS `oa_timing_task`; CREATE TABLE `oa_timing_task` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',', `link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `types` int(2) NOT NULL DEFAULT 3 COMMENT 'Status:1,2,3', `desc` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_department -- ---------------------------- DROP TABLE IF EXISTS `oa_department`; CREATE TABLE `oa_department` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `leader_ids` varchar(500) NULL DEFAULT '' COMMENT 'ids', `phone` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_department -- ---------------------------- INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (1, 'Item', 0); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (2, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (3, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (4, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (5, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (6, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (7, 'Item', 1); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (8, 'Item', 5); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (9, 'Item', 5); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (10, 'Item', 5); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (11, 'Item', 6); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (12, 'Item', 6); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (13, 'Item', 6); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (14, 'Item', 7); INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (15, 'Item', 7); -- ---------------------------- -- Table structure for oa_department_admin -- ---------------------------- DROP TABLE IF EXISTS `oa_department_admin`; CREATE TABLE `oa_department_admin` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID', `department_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_talent -- ---------------------------- DROP TABLE IF EXISTS `oa_talent`; CREATE TABLE `oa_talent` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email', `mobile` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Mobile number', `sex` int(255) NOT NULL DEFAULT 0 COMMENT 'Gender: 1 male, 2 female', `to_did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `to_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `thumb` varchar(255) NOT NULL COMMENT 'Avatar', `position_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Position id', `type` int(1) NOT NULL DEFAULT 0 COMMENT 'Employee type: 0 unset, 1 full-time, 2 probation, 3 intern', `position_name` int(11) NOT NULL DEFAULT 0 COMMENT 'Job title', `position_rank` int(11) NOT NULL DEFAULT 0 COMMENT 'Job rank', `job_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Employee number', `birthday` varchar(255) NOT NULL DEFAULT '' COMMENT 'Birthday', `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `work_date` varchar(255) NOT NULL DEFAULT '' COMMENT 'Work start date', `work_location` int(11) NOT NULL DEFAULT 0 COMMENT 'Work location', `native_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Native place', `nation` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ethnicity', `home_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Home address', `current_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Current address', `contact` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact', `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact phone', `resident_type` int(1) NOT NULL DEFAULT 0 COMMENT 'Household type: 1 rural, 2 urban', `resident_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Household location', `graduate_school` varchar(255) NOT NULL DEFAULT '' COMMENT 'School', `graduate_day` varchar(255) NOT NULL DEFAULT 'Item', `political` int(1) NOT NULL DEFAULT 1 COMMENT 'Political status: 1 party member, 2 league member', `marital_status` int(1) NOT NULL DEFAULT 1 COMMENT 'Marital status: 1 single, 2 married, 3 divorced', `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID card', `education` varchar(255) NOT NULL DEFAULT '' COMMENT 'Degree', `speciality` varchar(255) NOT NULL DEFAULT '' COMMENT 'Major', `bank_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank card number', `social_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Social security account', `salary` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `salary_remark` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `reference_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `reference_rel` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `reference_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments', `desc` mediumtext NULL COMMENT 'Comment', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `entry_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_staff` int(1) NOT NULL DEFAULT 1 COMMENT 'Identity type:1,2', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Updated at', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `talent_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_personal_quit -- ---------------------------- DROP TABLE IF EXISTS `oa_personal_quit`; CREATE TABLE `oa_personal_quit` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `lead_admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `connect_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `connect_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `connect_uids` varchar(100) NOT NULL DEFAULT '' COMMENT ',', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments', `quit_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_department_change -- ---------------------------- DROP TABLE IF EXISTS `oa_department_change`; CREATE TABLE `oa_department_change` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID', `from_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `to_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `connect_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `connect_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `connect_uids` varchar(100) NOT NULL DEFAULT '' COMMENT ',', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments', `move_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_blacklist -- ---------------------------- DROP TABLE IF EXISTS `oa_blacklist`; CREATE TABLE `oa_blacklist` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Mobile number', `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID card', `remark` text NULL COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Updated at', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_file_group -- ---------------------------- DROP TABLE IF EXISTS `oa_file_group`; CREATE TABLE `oa_file_group` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_file -- ---------------------------- DROP TABLE IF EXISTS `oa_file`; CREATE TABLE `oa_file` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `module` varchar(15) NOT NULL DEFAULT '' COMMENT 'Comment', `sha1` varchar(60) NOT NULL COMMENT 'sha1', `md5` varchar(60) NOT NULL COMMENT 'md5', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `filepath` varchar(255) NOT NULL DEFAULT '' COMMENT '+', `filesize` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `fileext` varchar(10) NOT NULL DEFAULT '' COMMENT 'Comment', `mimetype` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type', `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `uploadip` varchar(15) NOT NULL DEFAULT '' COMMENT 'IP', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '01-1', `create_time` bigint(11) NOT NULL DEFAULT 0, `admin_id` int(11) NOT NULL COMMENT 'id', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `audit_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `action` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `use` varchar(255) NULL DEFAULT NULL COMMENT 'Comment', `download` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_file -- ---------------------------- INSERT INTO `oa_file` VALUES (1, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', 'f95982689eb222b84e999122a50b3780.jpg.jpg', 'f95982689eb222b84e999122a50b3780.jpg', 'https://blog.gougucms.com/storage/202202/f95982689eb222b84e999122a50b3780.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0); INSERT INTO `oa_file` VALUES (2, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', 'e729477de18e3be7e7eb4ec7fe2f821e.jpg', 'e729477de18e3be7e7eb4ec7fe2f821e.jpg', 'https://blog.gougucms.com/storage/202202/e729477de18e3be7e7eb4ec7fe2f821e.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0); INSERT INTO `oa_file` VALUES (3, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', '1193f7a1585b9f6e8a97ae17718018b3.jpg', 'images/1193f7a1585b9f6e8a97ae17718018b3.jpg', 'https://blog.gougucms.com/storage/202204/1193f7a1585b9f6e8a97ae17718018b3.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0); INSERT INTO `oa_file` VALUES (4, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', '0f22a5ba4797b2fa22049ea73e6f779c.jpg', 'images/0f22a5ba4797b2fa22049ea73e6f779c.jpg', 'https://blog.gougucms.com/storage/202202/0f22a5ba4797b2fa22049ea73e6f779c.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0); -- ---------------------------- -- Table structure for oa_enterprise -- ---------------------------- DROP TABLE IF EXISTS `oa_enterprise`; CREATE TABLE `oa_enterprise` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `city` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `bank` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `bank_sn` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `phone` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment', `address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_enterprise -- ---------------------------- INSERT INTO `oa_enterprise` VALUES (1, 'Item','Item','','','','','','', 1, 1638006751, 0); -- ---------------------------- -- Table structure for oa_template -- ---------------------------- DROP TABLE IF EXISTS `oa_template`; CREATE TABLE `oa_template` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',', `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2', `check_types` int(11) NOT NULL DEFAULT 0 COMMENT 'Type:0', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT ',', `msg_link` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `msg_title_0` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `msg_content_0` varchar(500) NOT NULL DEFAULT '' COMMENT '()', `msg_title_1` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `msg_content_1` varchar(500) NOT NULL DEFAULT '' COMMENT '()', `msg_title_2` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `msg_content_2` varchar(500) NOT NULL DEFAULT '' COMMENT '()', `msg_title_3` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `msg_content_3` varchar(500) NOT NULL DEFAULT '' COMMENT '()', `email_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_template -- ---------------------------- INSERT INTO `oa_template` VALUES (1, 'Item', 'note', 1, 0, '', '/adm/note/view/id/{action_id}', '{from_user}"",View', ':{title}.', '', '', '', '', '', '', '', 1, 1, 1733312491, 1733314809, 0); INSERT INTO `oa_template` VALUES (2, 'Item', 'leaves', 2, 0, '', '/home/leaves/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312616, 1733314814, 0); INSERT INTO `oa_template` VALUES (3, 'Item', 'trips', 2, 0, '', '/home/trips/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312725, 1733314819, 0); INSERT INTO `oa_template` VALUES (4, 'Item', 'outs', 2, 0, '', '/home/outs/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312801, 1733314824, 0); INSERT INTO `oa_template` VALUES (5, 'Item', 'overtimes', 2, 0, '', '/home/overtimes/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312801, 1733314828, 0); INSERT INTO `oa_template` VALUES (6, 'Item', 'seal', 2, 0, '', '/adm/seal/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313018, 1733314834, 0); INSERT INTO `oa_template` VALUES (7, 'Item', 'official', 2, 0, '', '/adm/official/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313078, 1733313262, 0); INSERT INTO `oa_template` VALUES (8, 'Item', 'expense', 2, 0, '', '/finance/expense/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313169, 1733313253, 0); INSERT INTO `oa_template` VALUES (9, 'Item', 'invoice', 2, 0, '', '/finance/invoice/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313245, 0, 0); INSERT INTO `oa_template` VALUES (10, 'Item', 'ticket', 2, 0, '', '/finance/ticket/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313341, 0, 0); INSERT INTO `oa_template` VALUES (11, 'Item', 'invoicea', 2, 0, '', '/finance/invoice/view_a/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314549, 0, 0); INSERT INTO `oa_template` VALUES (12, 'Item', 'ticketa', 2, 0, '', '/finance/ticket/view_a/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314607, 0, 0); INSERT INTO `oa_template` VALUES (13, 'Item', 'contract', 2, 0, '', '/contract/contract/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314701, 0, 0); INSERT INTO `oa_template` VALUES (14, 'Item', 'purchase', 2, 0, '', '/contract/purchase/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0); INSERT INTO `oa_template` VALUES (15, 'Item', 'loan', 2, 0, '', '/finance/loan/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0); INSERT INTO `oa_template` VALUES (16, 'Item', 'talent', 2, 0, '', '/user/talent/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0); INSERT INTO `oa_template` VALUES (17, 'Item', 'personal_quit', 2, 0, '', '/user/personal/leave_view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0); INSERT INTO `oa_template` VALUES (18, 'Personnel Transfer', 'personal_change', 2, 0, '', '/user/personal/change_view/id/{action_id}', '{from_user}"Personnel Transfer",', '"Personnel Transfer".', '"Personnel Transfer"', '{create_time}"Personnel Transfer"{date}.', '"Personnel Transfer"', '{create_time}"Personnel Transfer"{date}.', '{from_user}"Personnel Transfer"', '{from_user}{create_time}"Personnel Transfer",View.', '', 1, 1, 1733314789, 1753284351, 0); -- ---------------------------- -- Table structure for oa_industry -- ---------------------------- DROP TABLE IF EXISTS `oa_industry`; CREATE TABLE `oa_industry` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_industry -- ---------------------------- INSERT INTO `oa_industry` VALUES (1, 'Item', 1, 1637987189, 0); INSERT INTO `oa_industry` VALUES (2, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (3, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (4, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (5, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (6, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (7, 'Item', 1, 1637987199, 0); INSERT INTO `oa_industry` VALUES (8, 'Item', 1, 1637987199, 0); -- ---------------------------- -- Table structure for oa_rewards_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_rewards_cate`; CREATE TABLE `oa_rewards_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_rewards_cate -- ---------------------------- INSERT INTO `oa_rewards_cate` VALUES (1, 'Item', 1, 1637987189, 0); INSERT INTO `oa_rewards_cate` VALUES (2, 'Item', 1, 1637987199, 0); INSERT INTO `oa_rewards_cate` VALUES (3, 'Item', 1, 1638088518, 0); INSERT INTO `oa_rewards_cate` VALUES (4, 'Item', 1, 1637987199, 0); INSERT INTO `oa_rewards_cate` VALUES (5, 'Item', 1, 1637987199, 0); INSERT INTO `oa_rewards_cate` VALUES (6, 'Item', 1, 1637987199, 0); -- ---------------------------- -- Table structure for oa_rewards -- ---------------------------- DROP TABLE IF EXISTS `oa_rewards`; CREATE TABLE `oa_rewards` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID', `types` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:12', `rewards_cate` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `rewards_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `thing` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:12', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_basic_user -- ---------------------------- DROP TABLE IF EXISTS `oa_basic_user`; CREATE TABLE `oa_basic_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Job title,2Job rank,3', `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_basic_user -- ---------------------------- INSERT INTO `oa_basic_user` VALUES (1, '2', 'Item', 1, 1733384661, 0); INSERT INTO `oa_basic_user` VALUES (2, '2', 'Item', 1, 1733384671, 0); INSERT INTO `oa_basic_user` VALUES (3, '2', 'Item', 1, 1733384675, 0); INSERT INTO `oa_basic_user` VALUES (4, '1', 'Item', 1, 1733384651, 0); INSERT INTO `oa_basic_user` VALUES (5, '1', 'Item', 1, 1733384651, 0); -- ---------------------------- -- Table structure for oa_care_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_care_cate`; CREATE TABLE `oa_care_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_care_cate -- ---------------------------- INSERT INTO `oa_care_cate` VALUES (1, 'Item', 1, 1637987189, 0); INSERT INTO `oa_care_cate` VALUES (2, 'Item', 1, 1637987199, 0); INSERT INTO `oa_care_cate` VALUES (3, 'Item', 1, 1638088518, 0); INSERT INTO `oa_care_cate` VALUES (4, 'Item', 1, 1637987199, 0); -- ---------------------------- -- Table structure for oa_care -- ---------------------------- DROP TABLE IF EXISTS `oa_care`; CREATE TABLE `oa_care` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID', `care_cate` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `care_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `vacation` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `thing` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:12', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_flow_module -- ---------------------------- DROP TABLE IF EXISTS `oa_flow_module`; CREATE TABLE `oa_flow_module` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT ',', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `department_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID()1,2,3', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_flow_module -- ---------------------------- INSERT INTO `oa_flow_module` VALUES (1, 'Attendance', '', 0, '', 1, 1723277295, 0); INSERT INTO `oa_flow_module` VALUES (2, 'Administration', '', 0, '', 1, 1723277311, 0); INSERT INTO `oa_flow_module` VALUES (3, 'Business', '', 0, '', 1, 1723277351, 0); INSERT INTO `oa_flow_module` VALUES (4, 'Finance', '', 0, '', 1, 1723277356, 0); INSERT INTO `oa_flow_module` VALUES (5, 'HR', '', 0, '', 1, 1723277368, 0); INSERT INTO `oa_flow_module` VALUES (6, 'Other', '', 0, '', 1, 1723277374, 0); -- ---------------------------- -- Table structure for oa_flow_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_flow_cate`; CREATE TABLE `oa_flow_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName', `name` varchar(100) NOT NULL COMMENT 'Type,', `module_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_table` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `department_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID()1,2,3', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `is_copy` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment', `is_file` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_export` int(11) NOT NULL DEFAULT 0 COMMENT 'PDF', `is_back` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment', `is_reversed` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `form` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',:1,2', `add_url` varchar(255) NOT NULL DEFAULT '' COMMENT ':', `view_url` varchar(255) NOT NULL DEFAULT '' COMMENT ':', `form_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id:', `is_list` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':0 1', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `template_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; -- ---------------------------- -- Records of oa_flow_cate -- ---------------------------- INSERT INTO `oa_flow_cate` VALUES (1, 'Leave', 'leaves', 1, 'leaves', 'icon-kechengziyuanguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/leaves/add', '/home/leaves/view', 0, 1, 1, 2, 1723604674, 0); INSERT INTO `oa_flow_cate` VALUES (2, 'Business Trip', 'trips', 1, 'trips', 'icon-jiaoshiguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/trips/add', '/home/trips/view', 0, 1, 1, 3, 1723799422, 0); INSERT INTO `oa_flow_cate` VALUES (3, 'Field Work', 'outs', 1, 'outs', 'icon-tuiguangguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/outs/add', '/home/outs/view', 0, 1, 1, 4, 1723800336, 0); INSERT INTO `oa_flow_cate` VALUES (4, 'Overtime', 'overtimes', 1, 'overtimes', 'icon-xueshengchengji', '', 0, 1, 0, 0, 1, 0, 1, '/home/overtimes/add', '/home/overtimes/view', 0, 1, 1, 5, 1723800393, 0); INSERT INTO `oa_flow_cate` VALUES (5, 'Seal Usage', 'seal', 2, 'seal', 'icon-shenpishezhi', '', 0, 1, 0, 0, 1, 0, 1, '/adm/seal/add', '/adm/seal/view', 0, 1, 1, 6, 1723469451, 0); INSERT INTO `oa_flow_cate` VALUES (6, 'Official Documents', 'official_docs', 2, 'official_docs', 'icon-lunwenguanli', '', 0, 1, 0, 0, 1, 0, 1, '/adm/official/add', '/adm/official/view', 0, 0, 1, 7, 1723469614, 0); INSERT INTO `oa_flow_cate` VALUES (7, 'Expense', 'expense', 4, 'expense', 'icon-jizhang', '', 0, 1, 0, 0, 1, 0, 1, '/finance/expense/add', '/finance/expense/view', 0, 1, 1, 8, 1723469732, 0); INSERT INTO `oa_flow_cate` VALUES (8, 'Invoice', 'invoice', 4, 'invoice', 'icon-duizhangdan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/invoice/add', '/finance/invoice/view', 0, 1, 1, 9, 1723469814, 0); INSERT INTO `oa_flow_cate` VALUES (9, 'Invoice Receipt', 'ticket', 4, 'ticket', 'icon-yingjiaoqingdan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/ticket/add', '/finance/ticket/view', 0, 1, 1, 10, 1724749856, 0); INSERT INTO `oa_flow_cate` VALUES (10, 'Invoice (Type A)', 'invoicea', 4, 'invoice', 'icon-shoufeipeizhi', '', 0, 1, 0, 0, 1, 0, 1, '/finance/invoice/add_a', '/finance/invoice/view_a', 0, 1, 1, 11, 1725856435, 0); INSERT INTO `oa_flow_cate` VALUES (11, 'Invoice Receipt (Type A)', 'ticketa', 4, 'ticket', 'icon-bulujiesuan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/ticket/add_a', '/finance/ticket/view_a', 0, 1, 1, 12, 1725856613, 0); INSERT INTO `oa_flow_cate` VALUES (12, 'Sales Contract', 'contract', 3, 'contract', 'icon-hetongguanli', '', 0, 0, 0, 0, 1, 0, 1, '/contract/contract/add', '/contract/contract/view', 0, 1, 1, 13, 1723469917, 0); INSERT INTO `oa_flow_cate` VALUES (13, 'Purchase Contract', 'purchase', 3, 'purchase', 'icon-dianshang', '', 0, 0, 0, 0, 1, 0, 1, '/contract/purchase/add', '/contract/purchase/view', 0, 1, 1, 14, 1723470017, 0); INSERT INTO `oa_flow_cate` VALUES (14, 'Loan', 'loan', 4, 'loan', 'icon-zhangbuguanli', '', 0, 1, 0, 1, 1, 0, 1, '/finance/loan/add', '/finance/loan/view', 0, 1, 1, 15, 1723470017, 0); INSERT INTO `oa_flow_cate` VALUES (15, 'Recruitment', 'talent', 5, 'talent', 'icon-yuangongdaoru', '', 0, 1, 0, 1, 1, 0, 1, '/user/talent/add', '/user/talent/view', 0, 1, 1, 16, 1729490152, 0); INSERT INTO `oa_flow_cate` VALUES (16, 'Resignation', 'personal_quit', 5, 'personal_quit', 'icon-yuangongtongji2', '', 0, 1, 0, 1, 1, 0, 1, '/user/personal/leave_add', '/user/personal/leave_view', 0, 1, 1, 17, 1729490152, 0); INSERT INTO `oa_flow_cate`VALUES (17, 'Personnel Transfer', 'personal_change', 5, 'personal_change', 'icon-yuangongbiandong', '', 0, 1, 0, 1, 1, 0, 1, '/user/personal/change_add', '/user/personal/change_view', 0, 1, 1, 18, 1729490152, 0); -- ---------------------------- -- Table structure for oa_flow -- ---------------------------- DROP TABLE IF EXISTS `oa_flow`; CREATE TABLE `oa_flow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` tinyint(11) NOT NULL DEFAULT 0 COMMENT 'Typeid', `check_type` tinyint(4) NOT NULL COMMENT '1,2,3,4', `department_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID(0)1,2,3', `copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID', `flow_list` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Status 1,0', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) NOT NULL COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_flow_cate -- ---------------------------- INSERT INTO `oa_flow` VALUES (1, 'Item', 1, 1, '', '', '', 1, '', 1, 1723791655, 0, 0); INSERT INTO `oa_flow` VALUES (2, 'Item', 2, 1, '', '', '', 1, '', 1, 1723799665, 0, 0); INSERT INTO `oa_flow` VALUES (3, 'Item', 3, 1, '', '', '', 1, '', 1, 1723800434, 0, 0); INSERT INTO `oa_flow` VALUES (4, 'Item', 4, 1, '', '', '', 1, '', 1, 1723800446, 0, 0); INSERT INTO `oa_flow` VALUES (5, 'Item', 5, 1, '', '', '', 1, '', 1, 1723470400, 0, 0); INSERT INTO `oa_flow` VALUES (6, 'Item', 6, 1, '', '', '', 1, '', 1, 1723470419, 0, 0); INSERT INTO `oa_flow` VALUES (7, 'Item', 7, 1, '', '', '', 1, '', 1, 1723470468, 0, 0); INSERT INTO `oa_flow` VALUES (8, 'Item', 8, 1, '', '', '', 1, '', 1, 1723470482, 0, 0); INSERT INTO `oa_flow` VALUES (9, 'Item', 9, 1, '', '', '', 1, '', 1, 1723470482, 0, 0); INSERT INTO `oa_flow` VALUES (10, 'Item', 10, 1, '', '', '', 1, '', 1, 1725935073, 0, 0); INSERT INTO `oa_flow` VALUES (11, 'Item', 11, 1, '', '', '', 1, '', 1, 1725935159, 0, 0); INSERT INTO `oa_flow` VALUES (12, 'Item', 12, 1, '', '', '', 1, '', 1, 1723470490, 0, 0); INSERT INTO `oa_flow` VALUES (13, 'Item', 13, 1, '', '', '', 1, '', 1, 1723470501, 0, 0); INSERT INTO `oa_flow` VALUES (14, 'Item', 14, 1, '', '', '', 1, '', 1, 1723470501, 0, 0); INSERT INTO `oa_flow` VALUES (15, 'Item', 15, 1, '', '', '', 1, '', 1, 1723470501, 0, 0); INSERT INTO `oa_flow` VALUES (16, 'Item', 16, 1, '', '', '', 1, '', 1, 1723470501, 0, 0); INSERT INTO `oa_flow` VALUES (17, 'Item', 17, 1, '', '', '', 1, '', 1, 1723470501, 0, 0); -- ---------------------------- -- Table structure for oa_flow_step -- ---------------------------- DROP TABLE IF EXISTS `oa_flow_step`; CREATE TABLE `oa_flow_step` ( `id` int(11) NOT NULL AUTO_INCREMENT, `flow_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `action_id` int(11) NOT NULL COMMENT 'ID', `flow_id` int(11) NOT NULL COMMENT 'id', `check_role` tinyint(4) NOT NULL DEFAULT 0 COMMENT ':0,1,2,3,4,5', `check_position_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids(1,2,3)', `check_types` tinyint(4) NOT NULL DEFAULT 1 COMMENT ':12', `sort` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_flow_record -- ---------------------------- DROP TABLE IF EXISTS `oa_flow_record`; CREATE TABLE `oa_flow_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `check_table` varchar(255) NOT NULL DEFAULT 'Tables', `flow_id` int(11) NOT NULL COMMENT 'id', `step_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `check_files` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `check_time` bigint(11) NOT NULL COMMENT 'Comment', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3', `content` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_cost_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_cost_cate`; CREATE TABLE `oa_cost_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; -- ---------------------------- -- Records of oa_cost_cate -- ---------------------------- INSERT INTO `oa_cost_cate` VALUES (1, 'Item', 1, 1639898199, 0,0); INSERT INTO `oa_cost_cate` VALUES (2, 'Item', 1, 1639898434, 0,0); INSERT INTO `oa_cost_cate` VALUES (3, 'Item', 1, 1639898564, 0,0); INSERT INTO `oa_cost_cate` VALUES (4, 'Item', 1, 1639898564, 0,0); INSERT INTO `oa_cost_cate` VALUES (5, 'Item', 1, 1639898564, 0,0); INSERT INTO `oa_cost_cate` VALUES (6, 'Item', 1, 1639898564, 0,0); -- ---------------------------- -- Table structure for oa_seal_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_seal_cate`; CREATE TABLE `oa_seal_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `keep_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; INSERT INTO `oa_seal_cate` VALUES (1, 'Item', 2, 1, '', 1733385406, 0); -- ---------------------------- -- Table structure for oa_meeting_room -- ---------------------------- DROP TABLE IF EXISTS `oa_meeting_room`; CREATE TABLE `oa_meeting_room` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `keep_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `device` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `num` int(10) NOT NULL DEFAULT 10 COMMENT 'Comment', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_meeting_records -- ---------------------------- DROP TABLE IF EXISTS `oa_meeting_records`; CREATE TABLE `oa_meeting_records` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment', `meeting_date` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `room_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `content` text NOT NULL COMMENT 'Comment', `plans` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `join_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `sign_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `share_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `anchor_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `recorder_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `remarks` text NOT NULL COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0, `update_time` bigint(11) NOT NULL DEFAULT 0, `delete_time` bigint(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_car -- ---------------------------- DROP TABLE IF EXISTS `oa_car`; CREATE TABLE `oa_car` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `oil` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `mileage` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `seats` int(11) NOT NULL DEFAULT 5 COMMENT 'Comment', `color` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `vin` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `engine` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `buy_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `thumb` int(11) NOT NULL DEFAULT 5 COMMENT 'Comment', `types` int(11) NOT NULL DEFAULT 5 COMMENT 'Type:1,2,3,4,5,6,7,8', `driver` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `insure_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `review_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` int(11) NOT NULL DEFAULT 1 COMMENT 'Status:1,,,', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_car_repair -- ---------------------------- DROP TABLE IF EXISTS `oa_car_repair`; CREATE TABLE `oa_car_repair` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2', `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `address` varchar(255) NOT NULL DEFAULT '' COMMENT '()', `content` varchar(1000) NULL DEFAULT '' COMMENT '()&', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '()', `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `repair_time` bigint(11) NOT NULL DEFAULT 0 COMMENT '()', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = '()'; -- ---------------------------- -- Table structure for oa_car_mileage -- ---------------------------- DROP TABLE IF EXISTS `oa_car_mileage`; CREATE TABLE `oa_car_mileage` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `mileage` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `mileage_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_car_fee -- ---------------------------- DROP TABLE IF EXISTS `oa_car_fee`; CREATE TABLE `oa_car_fee` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Typeid', `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `fee_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `content` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_expense_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_expense_cate`; CREATE TABLE `oa_expense_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; -- ---------------------------- -- Records of oa_expense_cate -- ---------------------------- INSERT INTO `oa_expense_cate` VALUES (1, 'Item', 1, 1637987189, 0,0); INSERT INTO `oa_expense_cate` VALUES (2, 'Item', 1, 1637987199, 0,0); INSERT INTO `oa_expense_cate` VALUES (3, 'Item', 1, 1638088518, 0,0); INSERT INTO `oa_expense_cate` VALUES (4, 'Item', 1, 1637987199, 0,0); INSERT INTO `oa_expense_cate` VALUES (5, 'Item', 1, 1637987199, 0,0); INSERT INTO `oa_expense_cate` VALUES (6, 'Item', 1, 1637987199, 0,0); -- ---------------------------- -- Table structure for oa_loan -- ---------------------------- DROP TABLE IF EXISTS `oa_loan`; CREATE TABLE `oa_loan` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `subject_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `title` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `types` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Type:1,2', `loan_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `plan_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `content` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `balance_cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `balance_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1,2', `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1', `pay_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `pay_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `back_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1', `back_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `back_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_expense -- ---------------------------- DROP TABLE IF EXISTS `oa_expense`; CREATE TABLE `oa_expense` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `subject_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `income_month` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `expense_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `loan_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `balance_cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `pay_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1', `pay_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `pay_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_expense_interfix -- ---------------------------- DROP TABLE IF EXISTS `oa_expense_interfix`; CREATE TABLE `oa_expense_interfix` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `exid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `cate_id` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT 'TypeID', `remarks` mediumtext NULL COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_invoice -- ---------------------------- DROP TABLE IF EXISTS `oa_invoice`; CREATE TABLE `oa_invoice` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `contract_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `open_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2', `open_admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `open_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delivery` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:12', `invoice_type` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3', `invoice_subject` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `invoice_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_tax` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_phone` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_account` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_banking` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `other_file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `remark` mediumtext NULL COMMENT 'Comment', `enter_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `enter_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2', `enter_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_invoice_income -- ---------------------------- DROP TABLE IF EXISTS `oa_invoice_income`; CREATE TABLE `oa_invoice_income` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `invoice_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `enter_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `remarks` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1 6', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_ticket -- ---------------------------- DROP TABLE IF EXISTS `oa_ticket`; CREATE TABLE `oa_ticket` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `supplier_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `purchase_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `open_status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT 'Status:1 2', `open_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `invoice_type` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3', `invoice_subject` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `invoice_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_tax` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_phone` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_account` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `invoice_banking` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `other_file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `remark` mediumtext NULL COMMENT 'Comment', `pay_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `cash_type` int(11) UNSIGNED NULL DEFAULT 1 COMMENT 'Type:1,2,3,4,5,6,7,8', `pay_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2', `pay_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_ticket_payment -- ---------------------------- DROP TABLE IF EXISTS `oa_ticket_payment`; CREATE TABLE `oa_ticket_payment` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ticket_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `pay_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `remarks` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1 6', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_third_message -- ---------------------------- DROP TABLE IF EXISTS `oa_third_message`; CREATE TABLE `oa_third_message` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `msgtype` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type,email,weixin,mobile', `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3,4', `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `pids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `content` mediumtext NULL COMMENT 'Comment', `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_message -- ---------------------------- DROP TABLE IF EXISTS `oa_message`; CREATE TABLE `oa_message` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `template` varchar(100) NOT NULL DEFAULT '' COMMENT ',,', `content` mediumtext NULL COMMENT 'Comment', `file_ids` mediumtext NULL COMMENT 'Comment', `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0', `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3,4', `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `pids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `msg_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '. id', `is_draft` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1 2', `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `action_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id()', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_msg -- ---------------------------- DROP TABLE IF EXISTS `oa_msg`; CREATE TABLE `oa_msg` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `template` varchar(100) NOT NULL DEFAULT '' COMMENT ',,', `content` mediumtext NULL COMMENT 'Comment', `file_ids` mediumtext NULL COMMENT 'Comment', `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0', `to_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `message_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0', `msg_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '. id', `is_star` tinyint(1) NOT NULL DEFAULT 0 COMMENT ':1 0', `read_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `action_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id()', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_note_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_note_cate`; CREATE TABLE `oa_note_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `sort` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment', `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT '1-1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_note_cate -- ---------------------------- INSERT INTO `oa_note_cate` VALUES (1, 0, 1, 'Item',1, 1637984265, 1637984299,0); INSERT INTO `oa_note_cate` VALUES (2, 0, 2, 'Item',1, 1637984283, 1637984310,0); -- ---------------------------- -- Table structure for oa_note -- ---------------------------- DROP TABLE IF EXISTS `oa_note`; CREATE TABLE `oa_note` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment', `content` text NOT NULL COMMENT 'Comment', `src` varchar(100) NULL DEFAULT NULL COMMENT 'Comment', `status` int(1) NOT NULL DEFAULT 1 COMMENT '1-1', `sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `role_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT ',0,1,2', `role_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `role_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0, `update_time` bigint(11) NOT NULL DEFAULT 0, `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_note -- ---------------------------- INSERT INTO `oa_note` VALUES (1, 1, 'OA', '

OA,.Settings. . . . . . . . . .,,,,,CRM,ERP,.

', 'https://oa.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0); INSERT INTO `oa_note` VALUES (2, 1, 'OA', '

OA,.Settings. . . . . . . . . .

OA,,,,.

“hdm588”,. .

', 'https://oa.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0); INSERT INTO `oa_note` VALUES (3, 1, 'DEV', '

DEVIT,. ,.

:https://www.gougucms.com/home/pages/detail/s/gougudev.html

:https://gitee.com/gouguopen/dev

DEV,,,,.

“hdm588”,. .

', 'https://dev.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0); -- ---------------------------- -- Table structure for oa_position -- ---------------------------- DROP TABLE IF EXISTS `oa_position`; CREATE TABLE `oa_position` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `work_price` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_position -- ---------------------------- INSERT INTO `oa_position` VALUES (1, 'Item', 1000, ',', 1, 0, 0); INSERT INTO `oa_position` VALUES (2, 'Item', 1000, 'Item', 1, 0, 0); INSERT INTO `oa_position` VALUES (3, 'Item', 500, 'Item', 1, 0, 0); -- ---------------------------- -- Table structure for oa_position_group -- ---------------------------- DROP TABLE IF EXISTS `oa_position_group`; CREATE TABLE `oa_position_group` ( `pid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT 'id', `group_id` int(11) NULL DEFAULT NULL COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', UNIQUE INDEX `pid_group_id`(`pid`, `group_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_position_group -- ---------------------------- INSERT INTO `oa_position_group` VALUES (1, 1, 1635755739, 0); INSERT INTO `oa_position_group` VALUES (2, 2, 1638007427, 0); INSERT INTO `oa_position_group` VALUES (3, 3, 1638007427, 0); -- ---------------------------- -- Table structure for oa_plan -- ---------------------------- DROP TABLE IF EXISTS `oa_plan`; CREATE TABLE `oa_plan` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `type` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':TypeID', `cmid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID', `ptid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time', `remind_type` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Type', `remind_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_schedule -- ---------------------------- DROP TABLE IF EXISTS `oa_schedule`; CREATE TABLE `oa_schedule` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `cid` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ':TypeID', `cmid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID', `ptid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID', `tid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time', `labor_time` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `labor_type` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:12', `remark` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_approve -- ---------------------------- DROP TABLE IF EXISTS `oa_approve`; CREATE TABLE `oa_approve` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `content` text NOT NULL COMMENT '//', `types` varchar(255) NOT NULL DEFAULT '' COMMENT 'Type', `str_1` varchar(255) NOT NULL DEFAULT '' COMMENT '1', `str_2` varchar(255) NOT NULL DEFAULT '' COMMENT '2', `str_3` varchar(255) NOT NULL DEFAULT '' COMMENT '3', `str_4` varchar(255) NOT NULL DEFAULT '' COMMENT '4', `str_5` varchar(255) NOT NULL DEFAULT '' COMMENT '5', `str_6` varchar(255) NOT NULL DEFAULT '' COMMENT '6', `str_7` varchar(255) NOT NULL DEFAULT '' COMMENT '7', `str_8` varchar(255) NOT NULL DEFAULT '' COMMENT '8', `str_9` varchar(255) NOT NULL DEFAULT '' COMMENT '9', `str_10` varchar(255) NOT NULL DEFAULT '' COMMENT '10', `str_11` varchar(255) NOT NULL DEFAULT '' COMMENT '11', `str_12` varchar(255) NOT NULL DEFAULT '' COMMENT '12', `str_13` varchar(255) NOT NULL DEFAULT '' COMMENT '13', `str_14` varchar(255) NOT NULL DEFAULT '' COMMENT '14', `str_15` varchar(255) NOT NULL DEFAULT '' COMMENT '15', `str_16` varchar(255) NOT NULL DEFAULT '' COMMENT '16', `int_1` int(11) NOT NULL DEFAULT 0 COMMENT '1', `int_2` int(11) NOT NULL DEFAULT 0 COMMENT '2', `int_3` int(11) NOT NULL DEFAULT 0 COMMENT '3', `int_4` int(11) NOT NULL DEFAULT 0 COMMENT '4', `int_5` int(11) NOT NULL DEFAULT 0 COMMENT '5', `int_6` int(11) NOT NULL DEFAULT 0 COMMENT '6', `int_7` int(11) NOT NULL DEFAULT 0 COMMENT '7', `int_8` int(11) NOT NULL DEFAULT 0 COMMENT '8', `int_9` int(11) NOT NULL DEFAULT 0 COMMENT '9', `int_10` int(11) NOT NULL DEFAULT 0 COMMENT '10', `float_1` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '1(2)', `float_2` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '2(2)', `float_3` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '3(2)', `float_4` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '4(2)', `float_5` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '5(2)', `float_6` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '6(2)', `float_7` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '7(2)', `float_8` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '8(2)', `float_9` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '9(2)', `float_10` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '10(2)', `time_1` bigint(11) NOT NULL DEFAULT 0 COMMENT '1', `time_2` bigint(11) NOT NULL DEFAULT 0 COMMENT '2', `time_3` bigint(11) NOT NULL DEFAULT 0 COMMENT '3', `time_4` bigint(11) NOT NULL DEFAULT 0 COMMENT '4', `time_5` bigint(11) NOT NULL DEFAULT 0 COMMENT '5', `time_6` bigint(11) NOT NULL DEFAULT 0 COMMENT '6', `time_7` bigint(11) NOT NULL DEFAULT 0 COMMENT '7', `time_8` bigint(11) NOT NULL DEFAULT 0 COMMENT '8', `time_9` bigint(11) NOT NULL DEFAULT 0 COMMENT '9', `time_10` bigint(11) NOT NULL DEFAULT 0 COMMENT '10', `file_1` varchar(500) NOT NULL DEFAULT '' COMMENT '1,:1,2,3', `file_2` varchar(500) NOT NULL DEFAULT '' COMMENT '2,:1,2,3', `file_3` varchar(500) NOT NULL DEFAULT '' COMMENT '3,:1,2,3', `file_4` varchar(500) NOT NULL DEFAULT '' COMMENT '4,:1,2,3', `file_5` varchar(500) NOT NULL DEFAULT '' COMMENT '5,:1,2,3', `file_6` varchar(500) NOT NULL DEFAULT '' COMMENT '6,:1,2,3', `text_1` text NOT NULL COMMENT '1', `text_2` text NOT NULL COMMENT '2', `text_3` text NOT NULL COMMENT '3', `text_4` text NOT NULL COMMENT '4', `text_5` text NOT NULL COMMENT '5', `text_6` text NOT NULL COMMENT '6', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID', `did` int(11) NOT NULL DEFAULT '0' COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_attendance -- ---------------------------- DROP TABLE IF EXISTS `oa_attendance`; CREATE TABLE `oa_attendance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL COMMENT 'Employee ID', `did` int(11) NOT NULL COMMENT 'ID', `day_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `time_in_1` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `time_in_2` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `time_out_1` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `time_out_2` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `late_min` int(10) NOT NULL DEFAULT '0' COMMENT 'Comment', `leave_min` int(10) NOT NULL DEFAULT '0' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_leaves -- ---------------------------- DROP TABLE IF EXISTS `oa_leaves`; CREATE TABLE `oa_leaves` ( `id` int(11) NOT NULL AUTO_INCREMENT, `types` int(2) NOT NULL DEFAULT '0' COMMENT 'Type:1,2,3,4,5,6,7,8,9', `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()', `reason` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL COMMENT 'ID', `did` int(11) NOT NULL COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_trips -- ---------------------------- DROP TABLE IF EXISTS `oa_trips`; CREATE TABLE `oa_trips` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()', `reason` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL COMMENT 'ID', `did` int(11) NOT NULL COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_outs -- ---------------------------- DROP TABLE IF EXISTS `oa_outs`; CREATE TABLE `oa_outs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()', `reason` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL COMMENT 'ID', `did` int(11) NOT NULL COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_overtimes -- ---------------------------- DROP TABLE IF EXISTS `oa_overtimes`; CREATE TABLE `oa_overtimes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2', `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()', `reason` text NOT NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL COMMENT 'ID', `did` int(11) NOT NULL COMMENT 'ID', `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_work -- ---------------------------- DROP TABLE IF EXISTS `oa_work`; CREATE TABLE `oa_work` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1 2 3', `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment', `to_uids` mediumtext NULL COMMENT 'ID', `works` mediumtext NULL COMMENT 'Comment', `plans` mediumtext NULL COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_work_record -- ---------------------------- DROP TABLE IF EXISTS `oa_work_record`; CREATE TABLE `oa_work_record` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `work_id` int(11) UNSIGNED NOT NULL COMMENT 'id', `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `to_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `read_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_customer_grade -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_grade`; CREATE TABLE `oa_customer_grade` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `sort` int(01) NOT NULL DEFAULT 0 COMMENT ',', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status: 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_customer_grade -- ---------------------------- INSERT INTO `oa_customer_grade` VALUES (1, 'Item',0, 1, 1637987189, 0, 0); INSERT INTO `oa_customer_grade` VALUES (2, 'VIP',0, 1, 1637987199, 0, 0); -- ---------------------------- -- Table structure for oa_customer_source -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_source`; CREATE TABLE `oa_customer_source` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `sort` int(01) NOT NULL DEFAULT 0 COMMENT ',', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_customer_source -- ---------------------------- INSERT INTO `oa_customer_source` VALUES (1, 'Item',0, 1, 1637987189, 0, 0); INSERT INTO `oa_customer_source` VALUES (2, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (3, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (4, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (5, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (6, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (7, 'Item',0, 1, 1637987199, 0, 0); INSERT INTO `oa_customer_source` VALUES (8, 'Item',0, 1, 1637987199, 0, 0); -- ---------------------------- -- Table structure for oa_basic_customer -- ---------------------------- DROP TABLE IF EXISTS `oa_basic_customer`; CREATE TABLE `oa_basic_customer` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Status,2,3,4,5', `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_basic_customer -- ---------------------------- INSERT INTO `oa_basic_customer` VALUES (1, '1', 'Item', 1, 1732606239, 0); INSERT INTO `oa_basic_customer` VALUES (2, '1', 'Item', 1, 1732606269, 0); INSERT INTO `oa_basic_customer` VALUES (3, '1', 'Item', 1, 1732606279, 0); INSERT INTO `oa_basic_customer` VALUES (4, '1', 'Item', 1, 1732606303, 0); INSERT INTO `oa_basic_customer` VALUES (5, '1', 'Item', 1, 1732606311, 0); INSERT INTO `oa_basic_customer` VALUES (6, '2', 'Item', 1, 1732606331, 0); INSERT INTO `oa_basic_customer` VALUES (7, '2', 'Item', 1, 1732606346, 0); INSERT INTO `oa_basic_customer` VALUES (8, '2', 'Item', 1, 1732606354, 0); INSERT INTO `oa_basic_customer` VALUES (9, '3', 'Item', 1, 1732606405, 0); INSERT INTO `oa_basic_customer` VALUES (10, '3', 'Item', 1, 1732606409, 0); INSERT INTO `oa_basic_customer` VALUES (11, '3', 'Item', 1, 1732606413, 0); INSERT INTO `oa_basic_customer` VALUES (12, '3', 'Item', 1, 1732606418, 0); INSERT INTO `oa_basic_customer` VALUES (13, '4', 'Item', 1, 1732606467, 0); INSERT INTO `oa_basic_customer` VALUES (14, '4', 'Item', 1, 1732606475, 0); INSERT INTO `oa_basic_customer` VALUES (15, '4', 'Item', 1, 1732606483, 0); INSERT INTO `oa_basic_customer` VALUES (16, '4', 'Item', 1, 1732606490, 0); INSERT INTO `oa_basic_customer` VALUES (17, '4', 'Item', 1, 1732606499, 0); INSERT INTO `oa_basic_customer` VALUES (18, '4', 'Item', 1, 1732606506, 0); INSERT INTO `oa_basic_customer` VALUES (19, '4', 'Item', 1, 1732607018, 0); -- ---------------------------- -- Table structure for oa_customer -- ---------------------------- DROP TABLE IF EXISTS `oa_customer`; CREATE TABLE `oa_customer` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `source_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `grade_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `industry_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `services_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `provinceid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `cityid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `distid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `townid` bigint(20) NOT NULL DEFAULT 0 COMMENT 'id', `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `customer_status` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Status:0', `intent_status` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Status:0', `contact_first` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `belong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `belong_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `belong_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `distribute_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `follow_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `next_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `discard_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `content` mediumtext NULL COMMENT 'Comment', `market` mediumtext NULL COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `tax_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_banksn` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment', `is_lock` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Status:0,1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_customer_trace -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_trace`; CREATE TABLE `oa_customer_trace` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `contact_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `chance_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `types` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `stage` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `follow_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `next_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_customer_contact -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_contact`; CREATE TABLE `oa_customer_contact` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `is_default` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Gender:0,1,2', `mobile` char(20) NOT NULL DEFAULT '' COMMENT 'Mobile number', `qq` char(20) NOT NULL DEFAULT '' COMMENT 'QQ', `wechat` char(20) NOT NULL DEFAULT '' COMMENT 'Comment', `email` char(100) NOT NULL DEFAULT '' COMMENT 'Comment', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `department` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `birthday` varchar(50) NOT NULL DEFAULT '' COMMENT 'Birthday', `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `family` mediumtext NULL COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_customer_chance -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_chance`; CREATE TABLE `oa_customer_chance` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `contact_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `services_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `stage` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `discovery_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `expected_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `expected_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `belong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `assist_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_customer_file -- ---------------------------- DROP TABLE IF EXISTS `oa_customer_file`; CREATE TABLE `oa_customer_file` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `customer_id` int(11) UNSIGNED NOT NULL COMMENT 'id', `file_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_property_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_property_cate`; CREATE TABLE `oa_property_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_property_cate -- ---------------------------- INSERT INTO `oa_property_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733384708, 1733385234); INSERT INTO `oa_property_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385274, 0); -- ---------------------------- -- Table structure for oa_property_unit -- ---------------------------- DROP TABLE IF EXISTS `oa_property_unit`; CREATE TABLE `oa_property_unit` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_property_unit -- ---------------------------- INSERT INTO `oa_property_unit` VALUES (1, 'Item', 0, '', 1, 1733385300, 0); INSERT INTO `oa_property_unit` VALUES (2, 'Item', 0, '', 1, 1733385307, 0); INSERT INTO `oa_property_unit` VALUES (3, 'Item', 0, '', 1, 1733385313, 0); INSERT INTO `oa_property_unit` VALUES (4, 'Item', 0, '', 1, 1733385321, 0); INSERT INTO `oa_property_unit` VALUES (5, 'Item', 0, '', 1, 1733385328, 0); INSERT INTO `oa_property_unit` VALUES (6, 'Item', 0, '', 1, 1733385333, 0); -- ---------------------------- -- Table structure for oa_property_brand -- ---------------------------- DROP TABLE IF EXISTS `oa_property_brand`; CREATE TABLE `oa_property_brand` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_property_brand -- ---------------------------- INSERT INTO `oa_property_brand` VALUES (1, 'Item', 0, '', 1, 1733385289, 0); INSERT INTO `oa_property_brand` VALUES (2, 'Item', 0, '', 1, 1733385289, 0); -- ---------------------------- -- Table structure for oa_property -- ---------------------------- DROP TABLE IF EXISTS `oa_property`; CREATE TABLE `oa_property` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `brand_id`int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Name', `unit_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `quality_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `buy_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `rate` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `model` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `user_dids` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `user_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `source` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3,4', `purchase_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0,1,2,3,4', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_property_repair -- ---------------------------- DROP TABLE IF EXISTS `oa_property_repair`; CREATE TABLE `oa_property_repair` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `property_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `repair_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `director_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_basic_adm -- ---------------------------- DROP TABLE IF EXISTS `oa_basic_adm`; CREATE TABLE `oa_basic_adm` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Type,2', `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_cost_cate -- ---------------------------- INSERT INTO `oa_basic_adm` VALUES (1, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (2, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (3, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (4, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (5, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (6, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (7, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (8, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (9, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (10, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (11, '1', 'Item', 1, 1706840194, 0); INSERT INTO `oa_basic_adm` VALUES (12, '1', 'Item', 1, 1706840194, 0); -- ---------------------------- -- Table structure for oa_official_docs -- ---------------------------- DROP TABLE IF EXISTS `oa_official_docs`; CREATE TABLE `oa_official_docs` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `secrets` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2,3', `urgency` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2,3', `send_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid', `copy_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid', `share_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid', `content` mediumtext NULL COMMENT 'Comment', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `draft_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `draft_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_seal -- ---------------------------- DROP TABLE IF EXISTS `oa_seal`; CREATE TABLE `oa_seal` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `seal_cate_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Type', `content` mediumtext NULL COMMENT 'Comment', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `num` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `use_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_borrow` int(1) NOT NULL DEFAULT 0 COMMENT ':0,1', `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1(),2', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_news -- ---------------------------- DROP TABLE IF EXISTS `oa_news`; CREATE TABLE `oa_news` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment', `content` text NOT NULL COMMENT 'Comment', `src` varchar(100) NULL DEFAULT NULL COMMENT 'Comment', `sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `create_time` bigint(11) NOT NULL DEFAULT 0, `update_time` bigint(11) NOT NULL DEFAULT 0, `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_product_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_product_cate`; CREATE TABLE `oa_product_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_product_cate -- ---------------------------- INSERT INTO `oa_product_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733385454, 0); INSERT INTO `oa_product_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385467, 0); -- ---------------------------- -- Table structure for oa_product -- ---------------------------- DROP TABLE IF EXISTS `oa_product`; CREATE TABLE `oa_product` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `barcode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `unit` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `specs` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `brand` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `producer` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `base_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `purchase_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `sale_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` text NULL COMMENT 'Comment', `album_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `stock` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_object` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',12', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_services -- ---------------------------- DROP TABLE IF EXISTS `oa_services`; CREATE TABLE `oa_services` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` text NULL COMMENT 'Comment', `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_services -- ---------------------------- INSERT INTO `oa_services` VALUES (1, 'Item', 0, 999.00, NULL, 0, 1, 1733385487, 1733385493, 0); INSERT INTO `oa_services` VALUES (2, 'Item', 0, 99.00, NULL, 0, 1, 1733385500, 0, 0); -- ---------------------------- -- Table structure for oa_supplier -- ---------------------------- DROP TABLE IF EXISTS `oa_supplier`; CREATE TABLE `oa_supplier` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `phone` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `products` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `content` text NULL COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1', `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_bank` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `tax_banksn` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment', `file_license_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `file_idcard_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID card,:1,2,3', `file_bankcard_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `file_openbank_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Bank,:1,2,3', `tax_rate` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `sort` int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_supplier_contact -- ---------------------------- DROP TABLE IF EXISTS `oa_supplier_contact`; CREATE TABLE `oa_supplier_contact` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `sid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `is_default` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Gender:0,1,2', `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Mobile number', `qq` varchar(20) NOT NULL DEFAULT '' COMMENT 'QQ', `wechat` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `email` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `department` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment', `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Job title', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_purchased_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_purchased_cate`; CREATE TABLE `oa_purchased_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_purchased_cate -- ---------------------------- INSERT INTO `oa_purchased_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733385535, 0); INSERT INTO `oa_purchased_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385542, 0); -- ---------------------------- -- Table structure for oa_purchased -- ---------------------------- DROP TABLE IF EXISTS `oa_purchased`; CREATE TABLE `oa_purchased` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `barcode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `unit` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `specs` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `brand` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `producer` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `purchase_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `sale_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` text NULL COMMENT 'Comment', `album_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3', `stock` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_object` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',12', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_contract_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_contract_cate`; CREATE TABLE `oa_contract_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Nickname', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_contract_cate -- ---------------------------- INSERT INTO `oa_contract_cate` VALUES (1, 'Item', 1, 1637987189, 0,0); INSERT INTO `oa_contract_cate` VALUES (2, 'Item', 1, 1637987199, 0,0); -- ---------------------------- -- Table structure for oa_contract -- ---------------------------- DROP TABLE IF EXISTS `oa_contract`; CREATE TABLE `oa_contract` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':123', `subject_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID,', `customer` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `contact_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `prepared_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `sign_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `keeper_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `is_tax` tinyint(1) NOT NULL DEFAULT 0 COMMENT ':0,1', `tax` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `stop_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `stop_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `stop_remark` mediumtext NULL COMMENT 'Comment', `void_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `void_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `void_remark` mediumtext NULL COMMENT 'Comment', `archive_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `archive_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_purchase -- ---------------------------- DROP TABLE IF EXISTS `oa_purchase`; CREATE TABLE `oa_purchase` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':123', `subject_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `supplier_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `supplier` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `contact_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `prepared_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `sign_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `keeper_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `content` mediumtext NULL COMMENT 'Comment', `stop_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `stop_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `stop_remark` mediumtext NULL COMMENT 'Comment', `void_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `void_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `void_remark` mediumtext NULL COMMENT 'Comment', `archive_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `archive_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `remark` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4', `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id', `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3', `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_step -- ---------------------------- DROP TABLE IF EXISTS `oa_step`; CREATE TABLE `oa_step` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_step -- ---------------------------- INSERT INTO `oa_step` VALUES (1, 'Item', 0,1, 1637987189, 0,0); INSERT INTO `oa_step` VALUES (2, 'Item', 0,1, 1637987189, 0,0); INSERT INTO `oa_step` VALUES (3, 'Item', 0,1, 1637987189, 0,0); INSERT INTO `oa_step` VALUES (4, 'Item', 0,1, 1637987189, 0,0); INSERT INTO `oa_step` VALUES (5, 'Item', 0,1, 1637987189, 0,0); -- ---------------------------- -- Table structure for oa_work_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_work_cate`; CREATE TABLE `oa_work_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName', `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; -- ---------------------------- -- Records of oa_work_cate -- ---------------------------- INSERT INTO `oa_work_cate` VALUES (1, 'Item', 0,1, 1637987189, 0); INSERT INTO `oa_work_cate` VALUES (2, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (3, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (4, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (5, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (6, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (7, 'Item',0, 1, 1637987199, 0); INSERT INTO `oa_work_cate` VALUES (8, 'Item',0, 1, 1637987199, 0); -- ---------------------------- -- Table structure for oa_project_cate -- ---------------------------- DROP TABLE IF EXISTS `oa_project_cate`; CREATE TABLE `oa_project_cate` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Nickname', `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_work_cate -- ---------------------------- INSERT INTO `oa_project_cate` VALUES (1, 'Item', 0, 1, 1733385561, 0, 0); INSERT INTO `oa_project_cate` VALUES (2, 'Item', 0, 1, 1733385567, 0, 0); -- ---------------------------- -- Table structure for oa_project -- ---------------------------- DROP TABLE IF EXISTS `oa_project`; CREATE TABLE `oa_project` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `contract_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `director_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1,2,3,4', `content` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_step -- ---------------------------- DROP TABLE IF EXISTS `oa_project_step`; CREATE TABLE `oa_project_step` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL COMMENT 'ID', `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `director_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID () 1,2,3', `sort` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'ID', `is_current` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Comment', `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time', `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_step_record -- ---------------------------- DROP TABLE IF EXISTS `oa_project_step_record`; CREATE TABLE `oa_project_step_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `step_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `check_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID', `check_time` bigint(11) NOT NULL COMMENT 'Comment', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '123', `content` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_user -- ---------------------------- DROP TABLE IF EXISTS `oa_project_user`; CREATE TABLE `oa_project_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `project_id` int(11) UNSIGNED NOT NULL COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_task -- ---------------------------- DROP TABLE IF EXISTS `oa_project_task`; CREATE TABLE `oa_project_task` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `before_task` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `project_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `work_id` int(1) NOT NULL DEFAULT 0 COMMENT 'Type', `step_id` int(1) NOT NULL DEFAULT 0 COMMENT 'Comment', `plan_hours` decimal(10, 1) NOT NULL DEFAULT 0.00 COMMENT 'Comment', `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `over_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `director_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '()', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `assist_admin_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3', `priority` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3,4', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3,4,5', `done_ratio` int(2) NOT NULL DEFAULT 0 COMMENT ':0,20,40,50,60,80', `content` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_document -- ---------------------------- DROP TABLE IF EXISTS `oa_project_document`; CREATE TABLE `oa_project_document` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `project_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids', `content` mediumtext NULL COMMENT 'Comment', `md_content` mediumtext NULL COMMENT 'markdown', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_project_file -- ---------------------------- DROP TABLE IF EXISTS `oa_project_file`; CREATE TABLE `oa_project_file` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `module` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `topic_id` int(11) UNSIGNED NOT NULL COMMENT 'id', `file_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_disk -- ---------------------------- DROP TABLE IF EXISTS `oa_disk`; CREATE TABLE `oa_disk` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID', `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `types` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Type:0,1,2', `action_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `name` varchar(200) NOT NULL DEFAULT '' COMMENT 'Name', `file_ext` varchar(200) NOT NULL DEFAULT '' COMMENT 'Name', `file_size` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `is_star` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_disk_group -- ---------------------------- DROP TABLE IF EXISTS `oa_disk_group`; CREATE TABLE `oa_disk_group` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name', `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `director_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `group_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_disk_group -- ---------------------------- INSERT INTO `oa_disk_group` VALUES (1000, 'Item', 1, '', '', 1749030795, 1749031338, 0); INSERT INTO `oa_disk_group` VALUES (1001, 'Item', 1, '', '', 1749030795, 1749031338, 0); INSERT INTO `oa_disk_group` VALUES (1002, 'Item', 1, '', '', 1749030795, 1749031338, 0); INSERT INTO `oa_disk_group` VALUES (1003, 'Item', 1, '', '', 1749030795, 1749031338, 0); -- ---------------------------- -- Table structure for oa_article -- ---------------------------- DROP TABLE IF EXISTS `oa_article`; CREATE TABLE `oa_article` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `origin_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment', `content` text NOT NULL COMMENT 'Comment', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0, `update_time` bigint(11) NOT NULL DEFAULT 0, `delete_time` bigint(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_edit_log -- ---------------------------- DROP TABLE IF EXISTS `oa_edit_log`; CREATE TABLE `oa_edit_log` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `field` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `action_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `second_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `old_content` mediumtext NULL COMMENT 'Comment', `new_content` mediumtext NULL COMMENT 'Comment', `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_comment -- ---------------------------- DROP TABLE IF EXISTS `oa_comment`; CREATE TABLE `oa_comment` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `module` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment', `topic_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `to_uids` varchar(100) NOT NULL DEFAULT '' COMMENT '@id', `content` mediumtext NULL COMMENT 'Comment', `md_content` mediumtext NULL COMMENT 'markdown', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_comment_read -- ---------------------------- DROP TABLE IF EXISTS `oa_comment_read`; CREATE TABLE `oa_comment_read` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `comment_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Table structure for oa_mobile_bar -- ---------------------------- DROP TABLE IF EXISTS `oa_mobile_bar`; CREATE TABLE `oa_mobile_bar` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Bar'; -- ---------------------------- -- Records of oa_mobile_bar -- ---------------------------- INSERT INTO `oa_mobile_bar` VALUES (1, 'Item', 'icon-gongzuotai1', '/qiye/index/index', 0, 1, 1723277311, 1733147213); INSERT INTO `oa_mobile_bar` VALUES (2, 'Item', 'icon-kehu', '/qiye/customer/index', 0, 1, 1723277311, 1733147238); INSERT INTO `oa_mobile_bar` VALUES (3, 'Item', 'icon-hetong2', '/qiye/contract/index', 0, 1, 1723277351, 1733147266); INSERT INTO `oa_mobile_bar` VALUES (4, 'Item', 'icon-xiangmu1', '/qiye/project/index', 0, 1, 1723277356, 1733147298); INSERT INTO `oa_mobile_bar` VALUES (5, 'Item', 'icon-xiaoxi1', '/qiye/msg/index', 0, 1, 1723277368, 1733147331); -- ---------------------------- -- Table structure for oa_mobile_types -- ---------------------------- DROP TABLE IF EXISTS `oa_mobile_types`; CREATE TABLE `oa_mobile_types` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `bgcolor` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type'; -- ---------------------------- -- Records of oa_mobile_types -- ---------------------------- INSERT INTO `oa_mobile_types` VALUES (1, 'Item', '', 'blue', 0, 1, 1723277311, 0); INSERT INTO `oa_mobile_types` VALUES (2, 'Item', '', 'green', 0, 1, 1723277311, 0); INSERT INTO `oa_mobile_types` VALUES (3, 'Item', '', 'yellow', 0, 1, 1723277351, 0); INSERT INTO `oa_mobile_types` VALUES (4, 'Item', '', 'purple', 0, 1, 1723277356, 0); -- ---------------------------- -- Table structure for oa_mobile_menu -- ---------------------------- DROP TABLE IF EXISTS `oa_mobile_menu`; CREATE TABLE `oa_mobile_menu` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `bgcolor` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment', `types` int(11) NOT NULL DEFAULT 0 COMMENT 'Type', `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1', `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment'; -- ---------------------------- -- Records of oa_mobile_menu -- ---------------------------- INSERT INTO `oa_mobile_menu` VALUES (1, 'Item', 'icon-shenpi','blue', '/qiye/approve/apply', 1, 0, 1, 1733146294, 1733152760, 0); INSERT INTO `oa_mobile_menu` VALUES (2, 'Item', 'icon-wodeshenpi1','blue', '/qiye/approve/mylist', 1, 0, 1, 1733152749, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (3, 'Item', 'icon-chulishenpi','blue', '/qiye/approve/checklist', 1, 0, 1, 1733152798, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (4, 'Item', 'icon-chaosong','blue', '/qiye/approve/copylist', 1, 0, 1, 1733152823, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (5, 'Item', 'icon-richeng','green', '/qiye/index/calendar', 2, 0, 1, 1733152855, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (6, 'Item', 'icon-jilu','green', '/qiye/index/schedule', 2, 0, 1, 1733152878, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (7, 'Item', 'icon-huibao','green', '/qiye/index/work', 2, 0, 1, 1733152906, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (8, 'Item', 'icon-gonggaotongzhi','yellow', '/qiye/index/note', 3, 0, 1, 1733152965, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (9, 'Item', 'icon-gongsixinwen','yellow', '/qiye/index/news', 3, 0, 1, 1733152993, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (10, 'Item', 'icon-huiyijiyao','yellow', '/qiye/index/meeting', 3, 0, 1, 1733152993, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (11, 'Item', 'icon-a-baoxiao3','purple', '/qiye/finance/expense', 4, 0, 1, 1733153019, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (12, 'Item', 'icon-kaipiao','purple', '/qiye/finance/invoice', 4, 0, 1, 1733153047, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (13, 'Item', 'icon-shoupiao','purple', '/qiye/finance/ticket', 4, 0, 1, 1733153077, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (14, 'Item', 'icon-huikuan','purple', '/qiye/finance/income', 4, 0, 1, 1733153106, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (15, 'Item', 'icon-fukuan','purple', '/qiye/finance/payment', 4, 0, 1, 1733153131, 0, 0); INSERT INTO `oa_mobile_menu` VALUES (16, 'Item', 'icon-a-baoxiao2','purple', '/qiye/finance/loan', 4, 0, 1, 1733153131, 0, 0);