# lyoggl **Repository Path**: lichongbing/lyoggl ## Basic Information - **Project Name**: lyoggl - **Description**: 开发实现目标管理，任务管理，标签管理，周历日历数据统计，目标进度数据追踪统计透视，个人财务管理，内购订阅包月管理 - **Primary Language**: Java - **License**: Not specified - **Default Branch**: dev - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 1 - **Forks**: 1 - **Created**: 2022-08-18 - **Last Updated**: 2026-04-23 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # 技术架构 SpringBoot + Mybatis Plus + redis + Mysql8.0 + flyway # 工程结构 ``` ├── chrome-lyoggl-plugin # google 插件 ├── pom.xml ├── readme.md #说明 ├── src #后端工程 └── ui #Vue前端 ``` ``` mvn flyway:migrate ``` ``` Mon, 25 Apr 2022 09:02:51 +0800 ``` ```json "EEE, dd MMM yyyy HH:mm:ss Z" ``` ``` ``` ```sql create table clients ( id double null, wid double null, name varchar(100) null, at varchar(100) null ); create table color ( tid varchar(50) null, r varchar(10) null, g varchar(10) null, b varchar(10) null, name varchar(50) null ) comment '标签颜色表'; create table flags ( name varchar(100) null, id varchar(50) null, wid double null, pid double null, active varchar(5) default '1' null, estimated_seconds double null, uid varchar(60) null, title varchar(400) null ); create table flyway_schema_history ( installed_rank int not null primary key, version varchar(50) null, description varchar(200) not null, type varchar(20) not null, script varchar(1000) not null, checksum int null, installed_by varchar(100) not null, installed_on timestamp default CURRENT_TIMESTAMP not null, execution_time int not null, success tinyint(1) not null ); create index flyway_schema_history_s_idx on flyway_schema_history (success); create table lyoggl_activity ( user_id double null, project_id double null, duration double null, description varchar(100) null, stop varchar(100) null ); create table lyoggl_groups ( id double null, wid double null, name varchar(100) null, at varchar(100) null ); create table lyoggl_users ( id varchar(50) not null primary key, api_token varchar(100) null, default_wid double null, email varchar(100) null, fullname varchar(100) null, jquery_timeofday_format varchar(100) null, jquery_date_format varchar(100) null, timeofday_format varchar(100) null, date_format varchar(100) null, store_start_and_stop_time varchar(100) null, beginning_of_week double null, language varchar(100) null, image_url varchar(100) null, sidebar_piechart varchar(100) null, at varchar(100) null, retention double null, record_timeline varchar(100) null, render_timeline varchar(100) null, timeline_enabled varchar(100) null, timeline_experiment varchar(100) null, new_blog_post varchar(100) null, invitation varchar(100) null, password varchar(200) null, role varchar(20) null, constraint lyoggl_users_pk unique (id), constraint lyoggl_users_pk_2 unique (id) ); create table most_active_user ( user_id double null, duration double null ); create table project ( name varchar(100) null, wid double null, cid double null, active varchar(100) null, is_private varchar(100) null, template varchar(100) null, template_id double null, billable varchar(100) null, auto_estimates varchar(100) null, estimated_hours varchar(100) null, at varchar(100) null, color double null, rate varchar(100) null, created_at varchar(100) null, content varchar(5000) null, title varchar(30) null, id varchar(50) null, uid varchar(50) null ); create table project_users ( id double null, pid double null, uid double null, wid double null, manager varchar(100) null, rate double null, fullname varchar(100) null, at varchar(100) null ); create table tags ( id varchar(50) null, wid double null, name varchar(100) null, r varchar(10) null, g varchar(10) null, b varchar(10) null, color varchar(10) null, uid varchar(50) null ); create table time_entries ( id varchar(50) null, guid varchar(100) null, wid double null, pid varchar(50) null, billable varchar(100) null, start varchar(100) null, stop varchar(100) null, duration double null, description varchar(100) null, tags0 varchar(100) null, tags1 varchar(100) null, tags2 varchar(100) null, duronly varchar(100) null, at varchar(100) null, fid varchar(50) null, tid varchar(50) null, uid varchar(50) null, name varchar(100) null ); create table time_line ( id varchar(50) null, name varchar(100) null, start varchar(100) null, stop varchar(100) null, duration double null, descriptions varchar(900) null, tags varchar(100) null, state varchar(10) null ); create table workspace_users ( id double null, uid double null, wid double null, admin varchar(100) null, active varchar(100) null, email varchar(100) null, invite_url varchar(100) null ); create table workspaces ( id double null, name varchar(100) null, premium varchar(100) null, admin varchar(100) null, default_hourly_rate double null, default_currency varchar(100) null, only_admins_may_create_projects varchar(100) null, only_admins_see_billable_rates varchar(100) null, rounding double null, rounding_minutes double null, at varchar(100) null, logo_url varchar(100) null ); create definer = root@`%` view vflags as select distinct `t1`.`id` AS `id`, `t1`.`uid` AS `uid`, `t1`.`name` AS `name`, `t1`.`active` AS `active`, `t1`.`estimated_seconds` AS `estimated_seconds`, `t1`.`tid` AS `tid`, `t1`.`usetime` AS `usetime`, `t`.`color` AS `color`, `t`.`r` AS `r`, `t`.`g` AS `g`, `t`.`b` AS `b` from ((select `f`.`id` AS `id`, `f`.`uid` AS `uid`, `f`.`name` AS `name`, `f`.`active` AS `active`, `f`.`estimated_seconds` AS `estimated_seconds`, `t`.`tid` AS `tid`, (select sum(`lyoggl`.`time_entries`.`duration`) from `lyoggl`.`time_entries` where ((`lyoggl`.`time_entries`.`fid` = `f`.`id`) and (`lyoggl`.`time_entries`.`uid` = `f`.`uid`))) AS `usetime` from (`lyoggl`.`flags` `f` left join `lyoggl`.`time_entries` `t` on ((`t`.`fid` = `f`.`id`)))) `t1` left join `lyoggl`.`tags` `t` on ((`t`.`id` = `t1`.`tid`))); INSERT INTO lyoggl.lyoggl_users (id, api_token, default_wid, email, fullname, jquery_timeofday_format, jquery_date_format, timeofday_format, date_format, store_start_and_stop_time, beginning_of_week, language, image_url, sidebar_piechart, at, retention, record_timeline, render_timeline, timeline_enabled, timeline_experiment, new_blog_post, invitation, password, role) VALUES ('000551.066c957c49e14a1aac6af3ae62b3a779.0918', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('9cc145e03b3c4600908bb2de89fe06af', null, null, '6732a8aa00b544bf92b8ebfae3a92cgp', null, '2022-04-15 08:23:00', '2022-04-15 08:24:00', 60, '工作', null, null, null, null, null, '9d99d3df405740678e70c0c94f0ff88f', 'f5b902ecf8954ac2840522fb9287218d', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('c71ceb23b674483b95019139f490466e', null, null, '6732a8aa00b544bf92b8ebfae3a92c1p', null, '2022-04-15 08:24:00', '2022-04-16 15:52:00', 400, '上班', null, null, null, null, null, '9d99d3df405740678e70c0c94f0gg88f', '139e5bfd39d545be9a476a299f0e1fat', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('38887bd2192e4508b50eb3ddb89c8322', null, null, '6732a8aa00b544bf92b8ebfae3a92cgp', null, '2022-04-16 15:52:00', '2022-04-16 17:39:00', 6420, '工作', null, null, null, null, null, 'aa00a7062c7a450885d63bebee5518f8', 'f5b902ecf8954ac2840522fb9287218d', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('39574faa1383439a8047e4878a86fb2f', null, null, '6732a8aa00b544bf92b8ebfae3a92cgp', null, '2022-04-16 17:39:00', '2022-04-16 18:38:00', 400, '工作', null, null, null, null, null, 'bfd22628b5b844099e6e4f4435172f14', 'f5b902ecf8954ac2840522fb9287218d', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('811701322733497e89e6838bd765b826', null, null, 'cd8690a6406744dba031a1f08278b04p', null, '2022-04-16 18:38:00', '2022-04-17 15:17:00', 890, '学习', null, null, null, null, null, 'a9b40790dbd445759a6bc26605b86ef8', 'f5b902ecf8954ac2840522fb9287218d', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('2edf684f541446588bbb215fcda4f1ea', null, null, '754aecd329e54b77889f21a0f7f92258', null, '2022-04-17 15:17:00', '2022-04-17 18:55:00', 340, '上班', null, null, null, null, null, 'a892e78071c54264b73019dda72db948', '139e5bfd39d545be9a476a299f0e1fat', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('2e57c935e54c4124b9ec59ea8a3fa1cd', null, null, '8d4994a32f3c405cac4526fc91c0c5fa', null, '2022-04-17 18:55:00', '2022-04-17 23:08:00', 15180, '上班', null, null, null, null, null, '32223f0e55e3469eb04afd7e9b414a11', 'd0f8fe38dfdd492fbdc0c2b8e0666054', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('1c35fe78c39d4e38b3fe6105f69fbeb9', null, null, '59a1fdcc307648cf99adc6885ffa9144', null, '2022-04-17 23:08:00', '2022-04-18 07:31:00', 30180, '跑步', null, null, null, null, null, 'ce50657fa49141e0bc1209e22518cd7d', 'a5b96f2fb94e46eb873daf3137e3b999', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('1d8ed6eba9484906ba96328e79f6fb96', null, null, '0bb5b93f9e684a3c9ce48cea820a2b38', null, '2022-04-18 07:31:00', '2022-04-18 07:58:13', 1633, '洗澡', null, null, null, null, null, '44f60c3d2dde445b827d256351f3d5c6', 'ea6423332c5c4b7bbcd6a063a639497e', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.time_entries (id, guid, wid, pid, billable, start, stop, duration, description, tags0, tags1, tags2, duronly, at, fid, tid, uid, name) VALUES ('1be43a1e27144fd8b893daf5afa35ca4', null, null, 'e30a638eb8cc4d98b7573b137b03fb6p', null, '2022-04-18 07:58:13', '2022-04-18 08:02:30', 257, '起床', null, null, null, null, null, 'fe0f36416b3c4462a69f7f1a5923064d', '9f4214432b234268bfbca665d00f3e8f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', null); INSERT INTO lyoggl.project (name, wid, cid, active, is_private, template, template_id, billable, auto_estimates, estimated_hours, at, color, rate, created_at, content, title, id, uid) VALUES ('李崇兵', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '57fce4b9002d48b3b8f66328441f4f20', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO lyoggl.tags (id, wid, name, r, g, b, color, uid) VALUES ('b0622a2fccee49b39f517d0609683a20', null, '绿茶婊', null, null, null, null, '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO lyoggl.flags (name, id, wid, pid, active, estimated_seconds, uid, title) VALUES ('学习20220808', 'ed334e5ae24e40b4850047bf06bccc85', null, null, '1', 7200, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '学习'); ``` ```sql /* Navicat Premium Data Transfer Source Server : 106.53.153.92 Source Server Type : MySQL Source Server Version : 80027 Source Host : 106.53.153.92:3306 Source Schema : lyoggl Target Server Type : MySQL Target Server Version : 80027 File Encoding : 65001 Date: 12/08/2022 08:38:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for account -- ---------------------------- DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `bank` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `idcard` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `date1` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '还款日', `date0` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账单日', `money` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账单金额', `money1` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL, `money2` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '剩余额度', `money3` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '利息', `pay` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手续费', `pay1` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '刷卡费', `mouth` int DEFAULT NULL COMMENT '月份', `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '持卡人', `duted` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '总欠款', `year` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '年份', `bankid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='账单'; -- ---------------------------- -- Records of account -- ---------------------------- BEGIN; INSERT INTO `account` VALUES ('18edb6d12dc04e45add2ff791d6fa2ae', NULL, NULL, NULL, NULL, '10', '1', '1', '1', '1', '1', 8, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL, '2022', 'dc1b91841c4b472985ecbacff94f0e71'); COMMIT; -- ---------------------------- -- Table structure for bank -- ---------------------------- DROP TABLE IF EXISTS `bank`; CREATE TABLE `bank` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `card` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `date0` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `date1` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of bank -- ---------------------------- BEGIN; INSERT INTO `bank` VALUES ('dc1b91841c4b472985ecbacff94f0e71', '华夏', '6259691149743117', '15', '4', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `bank` VALUES ('2345b29aa1514e5da4471ca9012f49f0', '招商', '', '', '', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `bank` VALUES ('8fb0733017ad43c9b8917428298a4db8', '民生', '', '', '', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); COMMIT; -- ---------------------------- -- Table structure for clients -- ---------------------------- DROP TABLE IF EXISTS `clients`; CREATE TABLE `clients` ( `id` double DEFAULT NULL, `wid` double DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of clients -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for color -- ---------------------------- DROP TABLE IF EXISTS `color`; CREATE TABLE `color` ( `tid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `r` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `g` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `b` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='标签颜色表'; -- ---------------------------- -- Records of color -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for flags -- ---------------------------- DROP TABLE IF EXISTS `flags`; CREATE TABLE `flags` ( `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `wid` double DEFAULT NULL, `pid` double DEFAULT NULL, `active` varchar(5) COLLATE utf8mb4_bin DEFAULT '1', `estimated_seconds` double DEFAULT NULL, `uid` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL, `title` varchar(400) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of flags -- ---------------------------- BEGIN; INSERT INTO `flags` VALUES ('学习20220808', 'ed334e5ae24e40b4850047bf06bccc85', NULL, NULL, '-1', 7200, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '学习'); INSERT INTO `flags` VALUES ('学习20220808', '762ad7b8fab14f46ba6cdeac60f25442', NULL, NULL, '-1', 3600, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '学习'); INSERT INTO `flags` VALUES ('系统优化bug20220808', 'ee947f1645bd4082abab0da4960a2728', NULL, NULL, '1', 72000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '系统优化bug'); INSERT INTO `flags` VALUES ('走路20220808', 'dfaa999fee9c4b58a95a2615740bc7d0', NULL, NULL, '1', 14400, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '走路'); INSERT INTO `flags` VALUES ('吃饭20220808', '906decc2c7d1417ab9f5779cb66e5a87', NULL, NULL, '-1', 3600, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '吃饭'); INSERT INTO `flags` VALUES ('吃饭20220808', 'f1dfcd8a642e42cfa05b1e7c06d893da', NULL, NULL, '1', 18000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '吃饭'); INSERT INTO `flags` VALUES ('睡觉20220808', 'ac71ac9056ed4e55bde15b7959752473', NULL, NULL, '1', 180000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '睡觉'); INSERT INTO `flags` VALUES ('学习20220808', '85072e5c80194c32b9a634d50d3e0943', NULL, NULL, '1', 36000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '学习'); INSERT INTO `flags` VALUES ('娱乐20220808', '2eb80c5ea34948d08c55096b2e7fd2dc', NULL, NULL, '1', 25200, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '娱乐'); INSERT INTO `flags` VALUES ('洗漱20220809', '5d09345201c34184954a2aad496468ff', NULL, NULL, '1', 3600, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '洗漱'); INSERT INTO `flags` VALUES ('洗澡20220809', 'd702370575b5454aa7a54612e5a444a9', NULL, NULL, '1', 7200, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '洗澡'); INSERT INTO `flags` VALUES ('临时安排20220809', 'f40840b100fa49f9ac0ada22759e9abd', NULL, NULL, '-1', 248400, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '临时安排'); INSERT INTO `flags` VALUES ('休息20220809', 'dab52c3ab43348a4a7c6fdb0aa2d0987', NULL, NULL, '1', 36000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '休息'); INSERT INTO `flags` VALUES ('临时安排20220809', '1f2099820cd44d92b1326223d97fd402', NULL, NULL, '-1', 212400, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '临时安排'); INSERT INTO `flags` VALUES ('总结20220809', '13124c477fa142eaafd499068ad1501e', NULL, NULL, '1', 36000, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '总结'); INSERT INTO `flags` VALUES ('临时安排20220809', 'bebb271603804ce0a2a2ca4658a1a057', NULL, NULL, '1', 176400, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '临时安排'); COMMIT; -- ---------------------------- -- Table structure for flyway_schema_history -- ---------------------------- DROP TABLE IF EXISTS `flyway_schema_history`; CREATE TABLE `flyway_schema_history` ( `installed_rank` int NOT NULL, `version` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `description` varchar(200) COLLATE utf8mb4_bin NOT NULL, `type` varchar(20) COLLATE utf8mb4_bin NOT NULL, `script` varchar(1000) COLLATE utf8mb4_bin NOT NULL, `checksum` int DEFAULT NULL, `installed_by` varchar(100) COLLATE utf8mb4_bin NOT NULL, `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `execution_time` int NOT NULL, `success` tinyint(1) NOT NULL, PRIMARY KEY (`installed_rank`), KEY `flyway_schema_history_s_idx` (`success`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of flyway_schema_history -- ---------------------------- BEGIN; INSERT INTO `flyway_schema_history` VALUES (1, '20220808172222', 'init', 'SQL', 'V20220808172222__init.sql', -1372292157, 'root', '2022-08-08 17:29:06', 6343, 1); COMMIT; -- ---------------------------- -- Table structure for lyoggl_activity -- ---------------------------- DROP TABLE IF EXISTS `lyoggl_activity`; CREATE TABLE `lyoggl_activity` ( `user_id` double DEFAULT NULL, `project_id` double DEFAULT NULL, `duration` double DEFAULT NULL, `description` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `stop` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of lyoggl_activity -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for lyoggl_groups -- ---------------------------- DROP TABLE IF EXISTS `lyoggl_groups`; CREATE TABLE `lyoggl_groups` ( `id` double DEFAULT NULL, `wid` double DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of lyoggl_groups -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for lyoggl_users -- ---------------------------- DROP TABLE IF EXISTS `lyoggl_users`; CREATE TABLE `lyoggl_users` ( `id` varchar(50) COLLATE utf8mb4_bin NOT NULL, `api_token` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `default_wid` double DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `fullname` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `jquery_timeofday_format` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `jquery_date_format` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `timeofday_format` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `date_format` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `store_start_and_stop_time` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `beginning_of_week` double DEFAULT NULL, `language` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `image_url` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `sidebar_piechart` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `retention` double DEFAULT NULL, `record_timeline` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `render_timeline` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `timeline_enabled` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `timeline_experiment` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `new_blog_post` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `invitation` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `password` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL, `role` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lyoggl_users_pk` (`id`), UNIQUE KEY `lyoggl_users_pk_2` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of lyoggl_users -- ---------------------------- BEGIN; INSERT INTO `lyoggl_users` VALUES ('000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for money -- ---------------------------- DROP TABLE IF EXISTS `money`; CREATE TABLE `money` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `date_time` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `money` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL, `type` int DEFAULT NULL COMMENT '1 收入\n2 支出', `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `ways` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `mouth` varchar(5) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '月份', `year` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '年份' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='收支明细'; -- ---------------------------- -- Records of money -- ---------------------------- BEGIN; INSERT INTO `money` VALUES ('f484814e930c44e890cf70bf5938f9ec', '2022年08月11日23时13分', '6', 0, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '买水', '8', '2022'); INSERT INTO `money` VALUES ('3ce3cf7415284a829b1b1f66e8d55859', '2022年08月12日00时24分', '20', 0, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '吃鱼头', '8', '2022'); INSERT INTO `money` VALUES ('13f312dd9de8427a9c2f58a1fc769f7f', '2022年08月12日00时27分', '15', 0, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '吃午饭', '8', '2022'); INSERT INTO `money` VALUES ('5c57561624994804aa2b50a0888696e2', '2022年08月12日01时45分', '1', 1, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '测试', '8', '2022'); INSERT INTO `money` VALUES ('81a680386cdc40b09baf61252e3687fb', '2022年08月12日07时56分', '2.5', 0, '000551.066c957c49e14a1aac6af3ae62b3a779.0918', '包子1个', '8', '2022'); COMMIT; -- ---------------------------- -- Table structure for most_active_user -- ---------------------------- DROP TABLE IF EXISTS `most_active_user`; CREATE TABLE `most_active_user` ( `user_id` double DEFAULT NULL, `duration` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of most_active_user -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for project -- ---------------------------- DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `wid` double DEFAULT NULL, `cid` double DEFAULT NULL, `active` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `is_private` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `template` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `template_id` double DEFAULT NULL, `billable` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `auto_estimates` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `estimated_hours` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `color` double DEFAULT NULL, `rate` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `content` varchar(5000) COLLATE utf8mb4_bin DEFAULT NULL, `title` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL, `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of project -- ---------------------------- BEGIN; INSERT INTO `project` VALUES ('开发', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f071d233b4724feca6d210916e1090a4', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('上班走路', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('下班走路', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '159b3e393c714c0181b78ac97467d36a', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('吃饭', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('博客', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fc5dd96a26d94c9b988e56b50a17c389', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('睡觉', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('洗澡', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5123835b527648338df81f4cc399b198', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('洗漱', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '72b2c5fc3a324b4d92bfd9faee2c52c8', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('喝水', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('厕所', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6e1c42d035084d8d9a2cffb22005d604', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('学习', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `project` VALUES ('财务', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36256867e508407dbdffa17761454b45', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); COMMIT; -- ---------------------------- -- Table structure for project_users -- ---------------------------- DROP TABLE IF EXISTS `project_users`; CREATE TABLE `project_users` ( `id` double DEFAULT NULL, `pid` double DEFAULT NULL, `uid` double DEFAULT NULL, `wid` double DEFAULT NULL, `manager` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `rate` double DEFAULT NULL, `fullname` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of project_users -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for tags -- ---------------------------- DROP TABLE IF EXISTS `tags`; CREATE TABLE `tags` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `wid` double DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `r` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `g` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `b` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `color` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL, `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of tags -- ---------------------------- BEGIN; INSERT INTO `tags` VALUES ('07ed461d4d2b4be59c9b99941eaeb353', NULL, '学习', '1', '0', '0', '红色', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `tags` VALUES ('a6de0240373a475eaae51885d5871eac', NULL, '工作', '0.5', '0.5', '0.5', '绿色', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `tags` VALUES ('b697c8617a324bdbbe4cfc0e2b86e790', NULL, '休息', '0', '0', '1', '蓝色', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `tags` VALUES ('449e88c0e4d74b8d8fd4530bf10ac0b8', NULL, '总结', '0.3', '1', '0.5', '灰色', '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `tags` VALUES ('bb28ff6d6c814f1387deacd2d8b1277f', NULL, '用餐', '0.5', '0.2', '0.1', NULL, '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); INSERT INTO `tags` VALUES ('327aaafe71194526a2397560b46a2ac9', NULL, '睡觉', '0.1', '0.7', '0.8', NULL, '000551.066c957c49e14a1aac6af3ae62b3a779.0918'); COMMIT; -- ---------------------------- -- Table structure for time_entries -- ---------------------------- DROP TABLE IF EXISTS `time_entries`; CREATE TABLE `time_entries` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `guid` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `wid` double DEFAULT NULL, `pid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `billable` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `start` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `stop` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `duration` double DEFAULT NULL, `description` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `tags0` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `tags1` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `tags2` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `duronly` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `fid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `tid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `uid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of time_entries -- ---------------------------- BEGIN; INSERT INTO `time_entries` VALUES ('23bd9cea6b294690878969cd52bb8a87', NULL, NULL, '3a12c14c11604151b5d7893d94a4a74c', NULL, '2022-08-08 21:29:37', '2022-08-09 00:37:45', 11288, '午休', NULL, NULL, NULL, NULL, NULL, '1f240bccba524a0bab8afb781edf9272', '9f4214432b234268bfbca665d00f3e8f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('f3e2b50d11d845c08988fc2d21f737db', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 00:37:45', '2022-08-09 00:37:57', 12, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('0ee76c66604e4458978e875ea19221d8', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 00:37:57', '2022-08-09 00:38:02', 5, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('4f5a98e7277543d3864f4e7f18401781', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 00:38:02', '2022-08-09 00:38:16', 14, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('65468f78108d4160bbc4c104d603b435', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 00:38:16', '2022-08-09 06:57:42', 22766, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('3ee8b4a762744110a6d9847e474f7b79', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 06:57:42', '2022-08-09 06:57:44', 2, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('242677a018864378942279132c2172c5', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 06:57:44', '2022-08-09 06:57:46', 2, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('50f667ec95f0485388274687b2b46e66', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 06:57:46', '2022-08-09 06:59:21', 95, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('bedd7dfc974845199dea163577270f0a', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 06:59:21', '2022-08-09 07:05:11', 350, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('3f486c69dd104717979e8879464eef7b', NULL, NULL, '5123835b527648338df81f4cc399b198', NULL, '2022-08-09 07:05:11', '2022-08-09 07:47:56', 2565, '个人卫生', NULL, NULL, NULL, NULL, NULL, 'd702370575b5454aa7a54612e5a444a9', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('2d9f71867f4b46a09b961fce699a44e9', NULL, NULL, '5f1cb3789b044dc2b287067acd1c58d3', NULL, '2022-08-09 07:47:56', '2022-08-09 07:47:58', 2, '下班', NULL, NULL, NULL, NULL, NULL, '1dca6658e1664f16bede569e9a780019', '68beab4a06094fb398bfc415ecb464f9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('a25c7e330ae74aa3810156a8c25c03f0', NULL, NULL, '5f1cb3789b044dc2b287067acd1c58d3', NULL, '2022-08-09 07:47:58', '2022-08-09 07:48:17', 19, '下班', NULL, NULL, NULL, NULL, NULL, '1dca6658e1664f16bede569e9a780019', '68beab4a06094fb398bfc415ecb464f9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('78d43667b00644389a32c3a4e8be55a9', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-09 07:48:17', '2022-08-09 07:48:20', 3, '走路', NULL, NULL, NULL, NULL, NULL, '2aa30198857243f19ec2668c179c88ae', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('2de752d64ff04716ba36bcd8e88e2926', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-09 07:48:20', '2022-08-09 07:51:10', 170, '走路', NULL, NULL, NULL, NULL, NULL, '2aa30198857243f19ec2668c179c88ae', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('c9751ea0972945bdac6f5b727c3d610c', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-09 07:51:10', '2022-08-09 07:51:14', 4, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('bd6bd8d88bfb46268f083f05a939591b', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-09 07:51:14', '2022-08-09 08:07:58', 1004, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('a0513269bcbf4d2f8f0004370a59b6a8', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 08:07:58', '2022-08-09 08:08:20', 22, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('c1e87e0023e6413c939db776a6ea8599', NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', NULL, '2022-08-09 08:08:20', '2022-08-09 08:53:59', 2739, '晚饭', NULL, NULL, NULL, NULL, NULL, 'f1dfcd8a642e42cfa05b1e7c06d893da', 'bb28ff6d6c814f1387deacd2d8b1277f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('4127028b12094887b08d5ac790e24799', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 08:53:59', '2022-08-09 09:56:57', 6, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b6616678292b4c339124ea6f586364e3', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 09:56:57', '2022-08-09 10:07:17', 620, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('586811fc140e457a97ad88fd76d22c44', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 10:07:17', '2022-08-09 10:07:28', 11, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('ea26f8a1c4ab4731a00f2ff86f7f96c2', NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', NULL, '2022-08-09 10:07:17', '2022-08-09 10:07:28', 10, '学习', NULL, NULL, NULL, NULL, NULL, '85072e5c80194c32b9a634d50d3e0943', '07ed461d4d2b4be59c9b99941eaeb353', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('d725039aad8a4d8186eb12886d18d790', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 10:07:28', '2022-08-09 10:07:28', 0, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5fbc74ab2dd24224a53f0a71cb75a953', NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', NULL, '2022-08-09 10:07:28', '2022-08-09 10:50:58', 2610, '学习', NULL, NULL, NULL, NULL, NULL, '85072e5c80194c32b9a634d50d3e0943', '07ed461d4d2b4be59c9b99941eaeb353', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('6677361d02ec4ff992e3304f2ac04694', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 10:50:58', '2022-08-09 10:59:10', 492, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('664154115be74fca9fdfda453c6681f2', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 10:59:10', '2022-08-09 10:59:10', 0, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('8f125f8b1d034b2d926cb1db89bad89e', NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', NULL, '2022-08-09 10:59:10', '2022-08-09 11:24:21', 1511, '学习', NULL, NULL, NULL, NULL, NULL, '85072e5c80194c32b9a634d50d3e0943', '07ed461d4d2b4be59c9b99941eaeb353', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('477af27e6a364df9968cbc61b41ba3ad', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 11:24:21', '2022-08-09 11:30:44', 383, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('573e76f3135a461396fcd50255bc5803', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 11:30:44', '2022-08-09 11:30:44', 0, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('24b52c7e429948c7a38d24f30b9ebf9a', NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', NULL, '2022-08-09 11:30:44', '2022-08-09 11:32:27', 103, '学习', NULL, NULL, NULL, NULL, NULL, '85072e5c80194c32b9a634d50d3e0943', '07ed461d4d2b4be59c9b99941eaeb353', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('9a0953b3e49a421483f09aa2b69b6bd0', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 11:32:27', '2022-08-09 11:32:32', 5, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('ed489ec7af904be48432b67d1ffc24ad', NULL, NULL, '31191046ca49494c8f1e87fc1fffb5f3', NULL, '2022-08-09 11:32:32', '2022-08-09 11:32:36', 4, '学习', NULL, NULL, NULL, NULL, NULL, '85072e5c80194c32b9a634d50d3e0943', '07ed461d4d2b4be59c9b99941eaeb353', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('fef8ea86c9c74046b7905e67344cd43b', NULL, NULL, 'fc5dd96a26d94c9b988e56b50a17c389', NULL, '2022-08-09 11:32:36', '2022-08-09 11:32:43', 7, '总结', NULL, NULL, NULL, NULL, NULL, '13124c477fa142eaafd499068ad1501e', '449e88c0e4d74b8d8fd4530bf10ac0b8', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('93ff18e1b3b5495fb7cf66bb2f3cb7b0', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 11:32:43', '2022-08-09 11:35:18', 155, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5569fc83f3dc414aa120a3eee38a2f71', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 11:35:18', '2022-08-09 11:38:48', 210, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('10d42dc007de4b4da2fc0af28894c2d7', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 11:38:48', '2022-08-09 12:03:58', 1510, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('37d803e7f1da4df39875b37c52947053', NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', NULL, '2022-08-09 12:03:58', '2022-08-09 12:30:41', 1603, '晚饭', NULL, NULL, NULL, NULL, NULL, 'f1dfcd8a642e42cfa05b1e7c06d893da', 'bb28ff6d6c814f1387deacd2d8b1277f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('64f4cd0b50a0453394c8b6b798318205', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 12:30:41', '2022-08-09 12:30:51', 10, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('fa1a2bcf9fef4669891a75da18b8e2b5', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 12:30:51', '2022-08-09 14:11:09', 6018, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('8032d4c1374c45df87d102f2f1ab5f09', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 14:11:09', '2022-08-09 14:53:16', 2527, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('e332155fdec74f30b742aa23d01b052f', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 14:53:16', '2022-08-09 15:22:05', 1729, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5beeeb11e2834254808ab6edb2d6953a', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 15:22:05', '2022-08-09 16:05:33', 2608, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('97c7481a8a404634b89cf9b6e2cafd2c', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 16:05:33', '2022-08-09 18:20:09', 8076, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b1f3be556094411fab6e9e102de8389f', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-09 18:20:09', '2022-08-09 18:20:39', 30, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('e732e6b6f80041408dc3419fa35ecd68', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 18:20:39', '2022-08-09 18:21:04', 25, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('bb61f2fba85f450fb6853838ff133323', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:04', '2022-08-09 18:21:06', 2, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('08f84129f5404ddaa703c28e9c6aa6dc', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:06', '2022-08-09 18:21:07', 1, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('58300c3591fb462cbd5d7658ae20e165', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:07', '2022-08-09 18:21:10', 3, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('029049576ef74ad6833549b735243b53', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:10', '2022-08-09 18:21:10', 0, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('8946b59c309f438592063379288c73fd', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:10', '2022-08-09 18:21:11', 1, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('45acf8d75e15496f8a1c2c64d53b954c', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-09 18:21:11', '2022-08-09 18:21:12', 1, '午休', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('49cad8a46bc14111bebd1d7efc994cd9', NULL, NULL, '36256867e508407dbdffa17761454b45', NULL, '2022-08-09 18:21:12', '2022-08-09 18:21:13', 1, '还款', NULL, NULL, NULL, NULL, NULL, 'bebb271603804ce0a2a2ca4658a1a057', 'e0ba1cbd76da4162be64d509cb381209', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5efeb2aa302c4dafa0ece1384cd34d71', NULL, NULL, 'a1f2b8baa3d047c6a8bc2aeff7b0f0c1', NULL, '2022-08-09 18:21:13', '2022-08-09 19:06:10', 2697, '开会讨论', NULL, NULL, NULL, NULL, NULL, '33223571168c49699005d47e526596b4', '1f70b3b5c794466b8c45a441ed6ed9cc', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('7072917d510a4103a6577926d7a33faa', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 19:06:10', '2022-08-09 19:08:43', 153, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('ded726274138488da311f4605aa79111', NULL, NULL, '159b3e393c714c0181b78ac97467d36a', NULL, '2022-08-09 19:08:43', '2022-08-09 19:29:04', 1221, '下班', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('4a3c7d1cb3314c43a1b9d9c67d0fb93a', NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', NULL, '2022-08-09 19:29:04', '2022-08-09 19:48:33', 1169, '晚饭', NULL, NULL, NULL, NULL, NULL, 'f1dfcd8a642e42cfa05b1e7c06d893da', 'bb28ff6d6c814f1387deacd2d8b1277f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('6e8594b295674946b17333f53385716a', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-09 19:48:33', '2022-08-10 00:10:01', 15688, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('3d141ad6f9e44cd8bc98609a0a5aae3e', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-10 00:10:01', '2022-08-10 07:43:19', 27198, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b46adf63ff7f409da5dc299b8e05d8ae', NULL, NULL, '72b2c5fc3a324b4d92bfd9faee2c52c8', NULL, '2022-08-10 07:43:19', '2022-08-10 08:02:12', 1133, '洗漱', NULL, NULL, NULL, NULL, NULL, '5d09345201c34184954a2aad496468ff', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('8878599d4b9c4431b9cf5898a736c2bd', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-10 08:02:12', '2022-08-10 08:02:18', 6, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('2066d1bb254040efb0a0ee00591b3a56', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-10 08:02:18', '2022-08-10 08:24:37', 1339, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('4bf87ea5eaed41ed8737cb9e2f880182', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-10 08:24:37', '2022-08-10 09:21:49', 3432, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('43bbb51c156546dea274098001eb0800', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-10 09:21:49', '2022-08-10 12:01:43', 9594, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('2c856e45cf9a4b31abbe464a23a1fe2e', NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', NULL, '2022-08-10 12:01:43', '2022-08-10 12:55:45', 3242, '晚饭', NULL, NULL, NULL, NULL, NULL, 'f1dfcd8a642e42cfa05b1e7c06d893da', 'bb28ff6d6c814f1387deacd2d8b1277f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b4f8c2587b794cfab83cce1c8872e0c1', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-10 12:55:45', '2022-08-10 14:35:24', 6000, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('042dc229fed54c1797c04863d5122747', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-10 14:35:24', '2022-08-10 20:20:16', 21500, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('31f3bbea72814637828e6c09bd863fa9', NULL, NULL, '159b3e393c714c0181b78ac97467d36a', NULL, '2022-08-10 20:20:16', '2022-08-11 00:27:06', 14400, '下班', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('3fcfc3b0eb2242f3ab012ecbab86e233', NULL, NULL, '94b5c08f55d044d2a9d49a97e6245590', NULL, '2022-08-11 00:27:06', '2022-08-11 08:31:27', 29061, '睡觉', NULL, NULL, NULL, NULL, NULL, 'ac71ac9056ed4e55bde15b7959752473', '327aaafe71194526a2397560b46a2ac9', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('4c6a306a3b5544c98a2d8ac159b17a9d', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-11 08:31:27', '2022-08-11 12:09:12', 13065, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b2728ecf1e6245919a6de4ab8d68d5b6', NULL, NULL, '32e26b88134a4b49885f19f1a46adf24', NULL, '2022-08-11 12:09:12', '2022-08-11 12:36:08', 1616, '晚饭', NULL, NULL, NULL, NULL, NULL, 'f1dfcd8a642e42cfa05b1e7c06d893da', 'bb28ff6d6c814f1387deacd2d8b1277f', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('b4c6af3ecaa647f4ac0452775191e4c4', NULL, NULL, '461bef9da51a42f0be1e8eae4510b209', NULL, '2022-08-11 12:36:08', '2022-08-11 14:04:27', 5400, '喝水', NULL, NULL, NULL, NULL, NULL, 'dab52c3ab43348a4a7c6fdb0aa2d0987', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5f9a8dab89fd4b09a280599e4ddd37dc', NULL, NULL, 'f071d233b4724feca6d210916e1090a4', NULL, '2022-08-11 14:04:27', '2022-08-11 20:14:37', 21600, '开发', NULL, NULL, NULL, NULL, NULL, 'ee947f1645bd4082abab0da4960a2728', 'a6de0240373a475eaae51885d5871eac', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('7b5ce9c512dc4551b62beea8c20120cc', NULL, NULL, '159b3e393c714c0181b78ac97467d36a', NULL, '2022-08-11 20:14:37', '2022-08-11 20:14:37', 0, '下班', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('dcf7795cdcca457d8410fe5a723ef66d', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-12 07:35:57', '2022-08-12 08:21:20', 2723, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('c52a685430bc491991d24e60e4079d16', NULL, NULL, '159b3e393c714c0181b78ac97467d36a', NULL, '2022-08-12 08:21:20', '2022-08-12 08:21:27', 7, '下班', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('c4d63398c44f4e72a0f6e3cdfcbf50bd', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-12 08:21:27', '2022-08-12 08:21:45', 18, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); INSERT INTO `time_entries` VALUES ('5e7fcf57577f4b97bf856b97db94d074', NULL, NULL, '42b4cc9d8c9746e685e5af2430492990', NULL, '2022-08-12 08:21:45', NULL, NULL, '走路', NULL, NULL, NULL, NULL, NULL, 'dfaa999fee9c4b58a95a2615740bc7d0', 'b697c8617a324bdbbe4cfc0e2b86e790', '000551.066c957c49e14a1aac6af3ae62b3a779.0918', NULL); COMMIT; -- ---------------------------- -- Table structure for time_line -- ---------------------------- DROP TABLE IF EXISTS `time_line`; CREATE TABLE `time_line` ( `id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `start` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `stop` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `duration` double DEFAULT NULL, `descriptions` varchar(900) COLLATE utf8mb4_bin DEFAULT NULL, `tags` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `state` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of time_line -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for workspace_users -- ---------------------------- DROP TABLE IF EXISTS `workspace_users`; CREATE TABLE `workspace_users` ( `id` double DEFAULT NULL, `uid` double DEFAULT NULL, `wid` double DEFAULT NULL, `admin` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `active` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `invite_url` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of workspace_users -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for workspaces -- ---------------------------- DROP TABLE IF EXISTS `workspaces`; CREATE TABLE `workspaces` ( `id` double DEFAULT NULL, `name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `premium` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `admin` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `default_hourly_rate` double DEFAULT NULL, `default_currency` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `only_admins_may_create_projects` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `only_admins_see_billable_rates` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `rounding` double DEFAULT NULL, `rounding_minutes` double DEFAULT NULL, `at` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL, `logo_url` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; -- ---------------------------- -- Records of workspaces -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- View structure for vflags -- ---------------------------- DROP VIEW IF EXISTS `vflags`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vflags` AS select distinct `t1`.`id` AS `id`,`t1`.`uid` AS `uid`,`t1`.`name` AS `name`,`t1`.`active` AS `active`,`t1`.`estimated_seconds` AS `estimated_seconds`,`t1`.`tid` AS `tid`,`t1`.`usetime` AS `usetime`,`t`.`color` AS `color`,`t`.`r` AS `r`,`t`.`g` AS `g`,`t`.`b` AS `b` from ((select `f`.`id` AS `id`,`f`.`uid` AS `uid`,`f`.`name` AS `name`,`f`.`active` AS `active`,`f`.`estimated_seconds` AS `estimated_seconds`,`t`.`tid` AS `tid`,(select sum(`time_entries`.`duration`) from `time_entries` where ((`time_entries`.`fid` = `f`.`id`) and (`time_entries`.`uid` = `f`.`uid`))) AS `usetime` from (`flags` `f` left join `time_entries` `t` on((`t`.`fid` = `f`.`id`)))) `t1` left join `tags` `t` on((`t`.`id` = `t1`.`tid`))); SET FOREIGN_KEY_CHECKS = 1; ``` ```js import SwiftUI struct ContentView: View { var body: some View { NavigationView{ VStack { Text("这个是实现了文本链接效果 ") HStack(spacing: 0) { NavigationLink(destination: Text("新界面")) { Text("去新界面") } Text(" and ") NavigationLink(destination: Text("第二个新界面")) { Text("第二个新界面") } Text(".") } } } } } ``` qq873610008@ ss