wakapi/testing/data.sql at master · muety/wakapi · GitHub

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
BEGIN
TRANSACTION;
INSERT INTO "key_string_values" ("key", "value") VALUES ('20210213-add_has_data_field', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20210221-add_created_date_column', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('imprint', 'no content here');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20210411-add_imprint_content', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20210806-remove_persisted_project_labels', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20211215-migrate_id_to_bigint-add_has_data_field', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20212212-total_summary_heartbeats', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20220317-align_num_heartbeats', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20220318-mysql_timestamp_precision', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('202203191-drop_diagnostics_user', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20221016-drop_rank_column', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20230219-add_astro_language', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20230219-add_subscription_renewal', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20231023-fill_last_branch', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20241220-share_activity_chart_flag', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20250219-update_heartbeats_timeout', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20250802_fix_default_coding_category', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20250802-fix_wsl_os', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20250313-fix_browsing_category', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20251005-drop_duplicate_emails', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20260103-add_webauthn_fields', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20260722-sqlite_recreate_view_post', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('20260722-sqlite_convert_time_to_integer', 'done');
INSERT INTO "key_string_values" ("key", "value") VALUES ('latest_total_time', '0s');
INSERT INTO "key_string_values" ("key", "value") VALUES ('latest_total_users', '0');
COMMIT;

BEGIN TRANSACTION;
INSERT INTO "users" ("id", "api_key", "email", "location", "password", "created_at", "last_logged_in_at",
                     "share_data_max_days", "share_editors", "share_languages", "share_projects", "share_oss",
                     "share_machines", "is_admin", "has_data", "wakatime_api_key", "reset_token", "reports_weekly")
VALUES ('readuser', '33e7f538-0dce-4eba-8ffe-53db6814ed42', 'johndoe@example.org', 'Europe/Berlin',
        '$2a$10$93CAptdjLGRtc1D3xrZJcu8B/YBAPSjCZOHZRId.xpyrsLAeHOoA.', 1622205265000,
        1622205274178, 0, 0, 0, 0, 0, 0, 1, 0, '', '', 0);
INSERT INTO "users" ("id", "api_key", "email", "location", "password", "created_at", "last_logged_in_at",
                     "share_data_max_days", "share_editors", "share_languages", "share_projects", "share_oss",
                     "share_machines", "is_admin", "has_data", "wakatime_api_key", "reset_token", "reports_weekly")
VALUES ('writeuser', 'f7aa255c-8647-4d0b-b90f-621c58fd580f', NULL, 'Europe/Berlin',
        '$2a$10$93CAptdjLGRtc1D3xrZJcu8B/YBAPSjCZOHZRId.xpyrsLAeHOoA.', 1622205296000,
        1622205305118, 7, 0, 0, 1, 0, 0, 0, 1, '', '', 0);

INSERT INTO "api_keys" ("api_key", "user_id", "label", "read_only")
VALUES ('1c91f670-2309-45fb-9d7e-738c766e85a6', 'writeuser', 'Full Access Key', false),
       ('774f7e16-b9a3-433e-ac68-7e28a82a50ca', 'writeuser', 'Read Only Key', true);
COMMIT;