Created
April 6, 2019 14:51
-
-
Save YuzuRyo61/32f258427ce567197a0d419b6d55b8f5 to your computer and use it in GitHub Desktop.
Misskey PostgreSQL beta version report file (2019/04/06)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > [email protected] init /vagrant/misskey | |
| > node ./built/init.js | |
| Connecting database... | |
| INFO * [db sql] START TRANSACTION | |
| INFO * [db sql] SELECT * FROM current_schema() | |
| INFO * [db sql] SELECT * FROM "information_schema"."tables" WHERE ("table_schema" = 'public' AND "table_name" = 'log') OR ("table_schema" = 'public' AND "table_name" = 'drive_folder') OR ("table_schema" = 'public' AND "table_name" = 'drive_file') OR ("table_schema" = 'public' AND "table_name" = 'user') OR ("table_schema" = 'public' AND "table_name" = 'app') OR ("table_schema" = 'public' AND "table_name" = 'access_token') OR ("table_schema" = 'public' AND "table_name" = 'note') OR ("table_schema" = 'public' AND "table_name" = 'poll_vote') OR ("table_schema" = 'public' AND "table_name" = 'note_reaction') OR ("table_schema" = 'public' AND "table_name" = 'note_watching') OR ("table_schema" = 'public' AND "table_name" = 'note_unread') OR ("table_schema" = 'public' AND "table_name" = 'notification') OR ("table_schema" = 'public' AND "table_name" = 'meta') OR ("table_schema" = 'public' AND "table_name" = 'following') OR ("table_schema" = 'public' AND "table_name" = 'instance') OR ("table_schema" = 'public' AND "table_name" = 'muting') OR ("table_schema" = 'public' AND "table_name" = 'sw_subscription') OR ("table_schema" = 'public' AND "table_name" = 'blocking') OR ("table_schema" = 'public' AND "table_name" = 'user_list') OR ("table_schema" = 'public' AND "table_name" = 'user_list_joining') OR ("table_schema" = 'public' AND "table_name" = 'hashtag') OR ("table_schema" = 'public' AND "table_name" = 'note_favorite') OR ("table_schema" = 'public' AND "table_name" = 'abuse_user_report') OR ("table_schema" = 'public' AND "table_name" = 'registration_ticket') OR ("table_schema" = 'public' AND "table_name" = 'messaging_message') OR ("table_schema" = 'public' AND "table_name" = 'signin') OR ("table_schema" = 'public' AND "table_name" = 'auth_session') OR ("table_schema" = 'public' AND "table_name" = 'follow_request') OR ("table_schema" = 'public' AND "table_name" = 'emoji') OR ("table_schema" = 'public' AND "table_name" = 'reversi_game') OR ("table_schema" = 'public' AND "table_name" = 'reversi_matching') OR ("table_schema" = 'public' AND "table_name" = 'user_note_pining') OR ("table_schema" = 'public' AND "table_name" = 'user_service_linking') OR ("table_schema" = 'public' AND "table_name" = 'poll') OR ("table_schema" = 'public' AND "table_name" = 'user_keypair') OR ("table_schema" = 'public' AND "table_name" = 'user_publickey') OR ("table_schema" = 'public' AND "table_name" = '__chart__active_users') OR ("table_schema" = 'public' AND "table_name" = '__chart__drive') OR ("table_schema" = 'public' AND "table_name" = '__chart__federation') OR ("table_schema" = 'public' AND "table_name" = '__chart__hashtag') OR ("table_schema" = 'public' AND "table_name" = '__chart__instance') OR ("table_schema" = 'public' AND "table_name" = '__chart__network') OR ("table_schema" = 'public' AND "table_name" = '__chart__notes') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_drive') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_following') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_notes') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_reaction') OR ("table_schema" = 'public' AND "table_name" = '__chart__test_grouped') OR ("table_schema" = 'public' AND "table_name" = '__chart__test_unique') OR ("table_schema" = 'public' AND "table_name" = '__chart__test') OR ("table_schema" = 'public' AND "table_name" = '__chart__users') | |
| INFO * [db sql] SELECT *, ('"' || "udt_schema" || '"."' || "udt_name" || '"')::"regtype" AS "regtype" FROM "information_schema"."columns" WHERE ("table_schema" = 'public' AND "table_name" = 'log') OR ("table_schema" = 'public' AND "table_name" = 'drive_folder') OR ("table_schema" = 'public' AND "table_name" = 'drive_file') OR ("table_schema" = 'public' AND "table_name" = 'user') OR ("table_schema" = 'public' AND "table_name" = 'app') OR ("table_schema" = 'public' AND "table_name" = 'access_token') OR ("table_schema" = 'public' AND "table_name" = 'note') OR ("table_schema" = 'public' AND "table_name" = 'poll_vote') OR ("table_schema" = 'public' AND "table_name" = 'note_reaction') OR ("table_schema" = 'public' AND "table_name" = 'note_watching') OR ("table_schema" = 'public' AND "table_name" = 'note_unread') OR ("table_schema" = 'public' AND "table_name" = 'notification') OR ("table_schema" = 'public' AND "table_name" = 'meta') OR ("table_schema" = 'public' AND "table_name" = 'following') OR ("table_schema" = 'public' AND "table_name" = 'instance') OR ("table_schema" = 'public' AND "table_name" = 'muting') OR ("table_schema" = 'public' AND "table_name" = 'sw_subscription') OR ("table_schema" = 'public' AND "table_name" = 'blocking') OR ("table_schema" = 'public' AND "table_name" = 'user_list') OR ("table_schema" = 'public' AND "table_name" = 'user_list_joining') OR ("table_schema" = 'public' AND "table_name" = 'hashtag') OR ("table_schema" = 'public' AND "table_name" = 'note_favorite') OR ("table_schema" = 'public' AND "table_name" = 'abuse_user_report') OR ("table_schema" = 'public' AND "table_name" = 'registration_ticket') OR ("table_schema" = 'public' AND "table_name" = 'messaging_message') OR ("table_schema" = 'public' AND "table_name" = 'signin') OR ("table_schema" = 'public' AND "table_name" = 'auth_session') OR ("table_schema" = 'public' AND "table_name" = 'follow_request') OR ("table_schema" = 'public' AND "table_name" = 'emoji') OR ("table_schema" = 'public' AND "table_name" = 'reversi_game') OR ("table_schema" = 'public' AND "table_name" = 'reversi_matching') OR ("table_schema" = 'public' AND "table_name" = 'user_note_pining') OR ("table_schema" = 'public' AND "table_name" = 'user_service_linking') OR ("table_schema" = 'public' AND "table_name" = 'poll') OR ("table_schema" = 'public' AND "table_name" = 'user_keypair') OR ("table_schema" = 'public' AND "table_name" = 'user_publickey') OR ("table_schema" = 'public' AND "table_name" = '__chart__active_users') OR ("table_schema" = 'public' AND "table_name" = '__chart__drive') OR ("table_schema" = 'public' AND "table_name" = '__chart__federation') OR ("table_schema" = 'public' AND "table_name" = '__chart__hashtag') OR ("table_schema" = 'public' AND "table_name" = '__chart__instance') OR ("table_schema" = 'public' AND "table_name" = '__chart__network') OR ("table_schema" = 'public' AND "table_name" = '__chart__notes') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_drive') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_following') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_notes') OR ("table_schema" = 'public' AND "table_name" = '__chart__per_user_reaction') OR ("table_schema" = 'public' AND "table_name" = '__chart__test_grouped') OR ("table_schema" = 'public' AND "table_name" = '__chart__test_unique') OR ("table_schema" = 'public' AND "table_name" = '__chart__test') OR ("table_schema" = 'public' AND "table_name" = '__chart__users') | |
| INFO * [db sql] SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "cnst"."conname" AS "constraint_name", CASE "cnst"."contype" WHEN 'x' THEN pg_get_constraintdef("cnst"."oid", true) ELSE "cnst"."consrc" END AS "expression", CASE "cnst"."contype" WHEN 'p' THEN 'PRIMARY' WHEN 'u' THEN 'UNIQUE' WHEN 'c' THEN 'CHECK' WHEN 'x' THEN 'EXCLUDE' END AS "constraint_type", "a"."attname" AS "column_name" FROM "pg_constraint" "cnst" INNER JOIN "pg_class" "t" ON "t"."oid" = "cnst"."conrelid" INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "cnst"."connamespace" LEFT JOIN "pg_attribute" "a" ON "a"."attrelid" = "cnst"."conrelid" AND "a"."attnum" = ANY ("cnst"."conkey") WHERE "t"."relkind" = 'r' AND (("ns"."nspname" = 'public' AND "t"."relname" = 'log') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'drive_folder') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'drive_file') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'app') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'access_token') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'poll_vote') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_reaction') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_watching') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_unread') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'notification') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'meta') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'following') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'instance') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'muting') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'sw_subscription') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'blocking') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_list') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_list_joining') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'hashtag') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_favorite') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'abuse_user_report') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'registration_ticket') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'messaging_message') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'signin') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'auth_session') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'follow_request') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'emoji') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'reversi_game') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'reversi_matching') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_note_pining') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_service_linking') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'poll') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_keypair') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_publickey') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__active_users') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__drive') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__federation') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__hashtag') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__instance') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__network') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__notes') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_drive') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_following') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_notes') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_reaction') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test_grouped') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test_unique') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__users')) | |
| INFO * [db sql] SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "i"."relname" AS "constraint_name", "a"."attname" AS "column_name", CASE "ix"."indisunique" WHEN 't' THEN 'TRUE' ELSE'FALSE' END AS "is_unique", pg_get_expr("ix"."indpred", "ix"."indrelid") AS "condition", "types"."typname" AS "type_name" FROM "pg_class" "t" INNER JOIN "pg_index" "ix" ON "ix"."indrelid" = "t"."oid" INNER JOIN "pg_attribute" "a" ON "a"."attrelid" = "t"."oid" AND "a"."attnum" = ANY ("ix"."indkey") INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "t"."relnamespace" INNER JOIN "pg_class" "i" ON "i"."oid" = "ix"."indexrelid" INNER JOIN "pg_type" "types" ON "types"."oid" = "a"."atttypid" LEFT JOIN "pg_constraint" "cnst" ON "cnst"."conname" = "i"."relname" WHERE "t"."relkind" = 'r' AND "cnst"."contype" IS NULL AND (("ns"."nspname" = 'public' AND "t"."relname" = 'log') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'drive_folder') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'drive_file') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'app') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'access_token') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'poll_vote') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_reaction') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_watching') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_unread') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'notification') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'meta') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'following') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'instance') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'muting') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'sw_subscription') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'blocking') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_list') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_list_joining') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'hashtag') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'note_favorite') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'abuse_user_report') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'registration_ticket') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'messaging_message') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'signin') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'auth_session') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'follow_request') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'emoji') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'reversi_game') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'reversi_matching') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_note_pining') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_service_linking') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'poll') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_keypair') OR ("ns"."nspname" = 'public' AND "t"."relname" = 'user_publickey') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__active_users') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__drive') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__federation') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__hashtag') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__instance') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__network') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__notes') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_drive') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_following') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_notes') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__per_user_reaction') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test_grouped') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test_unique') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__test') OR ("ns"."nspname" = 'public' AND "t"."relname" = '__chart__users')) | |
| INFO * [db sql] SELECT "con"."conname" AS "constraint_name", "con"."nspname" AS "table_schema", "con"."relname" AS "table_name", "att2"."attname" AS "column_name", "ns"."nspname" AS "referenced_table_schema", "cl"."relname" AS "referenced_table_name", "att"."attname" AS "referenced_column_name", "con"."confdeltype" AS "on_delete", "con"."confupdtype" AS "on_update" FROM ( SELECT UNNEST ("con1"."conkey") AS "parent", UNNEST ("con1"."confkey") AS "child", "con1"."confrelid", "con1"."conrelid", "con1"."conname", "con1"."contype", "ns"."nspname", "cl"."relname", CASE "con1"."confdeltype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confdeltype", CASE "con1"."confupdtype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confupdtype" FROM "pg_class" "cl" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_constraint" "con1" ON "con1"."conrelid" = "cl"."oid" WHERE "con1"."contype" = 'f' AND (("ns"."nspname" = 'public' AND "cl"."relname" = 'log') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'drive_folder') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'drive_file') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'app') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'access_token') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'note') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'poll_vote') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'note_reaction') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'note_watching') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'note_unread') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'notification') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'meta') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'following') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'instance') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'muting') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'sw_subscription') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'blocking') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_list') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_list_joining') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'hashtag') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'note_favorite') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'abuse_user_report') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'registration_ticket') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'messaging_message') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'signin') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'auth_session') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'follow_request') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'emoji') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'reversi_game') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'reversi_matching') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_note_pining') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_service_linking') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'poll') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_keypair') OR ("ns"."nspname" = 'public' AND "cl"."relname" = 'user_publickey') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__active_users') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__drive') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__federation') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__hashtag') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__instance') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__network') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__notes') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__per_user_drive') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__per_user_following') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__per_user_notes') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__per_user_reaction') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__test_grouped') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__test_unique') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__test') OR ("ns"."nspname" = 'public' AND "cl"."relname" = '__chart__users')) ) "con" INNER JOIN "pg_attribute" "att" ON "att"."attrelid" = "con"."confrelid" AND "att"."attnum" = "con"."child" INNER JOIN "pg_class" "cl" ON "cl"."oid" = "con"."confrelid" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_attribute" "att2" ON "att2"."attrelid" = "con"."conrelid" AND "att2"."attnum" = "con"."parent" | |
| INFO * [db sql] creating a new table: log | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = 'log_level_enum' | |
| INFO * [db sql] CREATE TYPE "log_level_enum" AS ENUM('error', 'warning', 'info', 'success', 'debug') | |
| INFO * [db sql] CREATE TABLE "log" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "domain" character varying(64) array NOT NULL DEFAULT '{}'::varchar[], "level" "log_level_enum" NOT NULL, "worker" character varying(8) NOT NULL, "machine" character varying(128) NOT NULL, "message" character varying(1024) NOT NULL, "data" jsonb NOT NULL DEFAULT '{}', CONSTRAINT "PK_350604cbdf991d5930d9e618fbd" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_8e4eb51a35d81b64dda28eed0a" ON "log" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_8cb40cfc8f3c28261e6f887b03" ON "log" ("domain") | |
| INFO * [db sql] CREATE INDEX "IDX_584b536b49e53ac81beb39a177" ON "log" ("level") | |
| INFO * [db sql] creating a new table: drive_folder | |
| INFO * [db sql] CREATE TABLE "drive_folder" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "name" character varying(128) NOT NULL, "userId" character varying(32), "parentId" character varying(32), CONSTRAINT "PK_7a0c089191f5ebdc214e0af808a" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_02878d441ceae15ce060b73daf" ON "drive_folder" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_f4fc06e49c0171c85f1c48060d" ON "drive_folder" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_00ceffb0cdc238b3233294f08f" ON "drive_folder" ("parentId") | |
| INFO * [db sql] creating a new table: drive_file | |
| INFO * [db sql] CREATE TABLE "drive_file" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32), "userHost" character varying(128), "md5" character varying(32) NOT NULL, "name" character varying(256) NOT NULL, "type" character varying(128) NOT NULL, "size" integer NOT NULL, "comment" character varying(512), "properties" jsonb NOT NULL DEFAULT '{}', "storedInternal" boolean NOT NULL, "url" character varying(512) NOT NULL, "thumbnailUrl" character varying(512), "webpublicUrl" character varying(512), "accessKey" character varying(256) NOT NULL, "thumbnailAccessKey" character varying(256), "webpublicAccessKey" character varying(256), "uri" character varying(512), "src" character varying(512), "folderId" character varying(32), "isSensitive" boolean NOT NULL DEFAULT false, "isRemote" boolean NOT NULL DEFAULT false, CONSTRAINT "PK_43ddaaaf18c9e68029b7cbb032e" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_c8dfad3b72196dd1d6b5db168a" ON "drive_file" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_860fa6f6c7df5bb887249fba22" ON "drive_file" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_92779627994ac79277f070c91e" ON "drive_file" ("userHost") | |
| INFO * [db sql] CREATE INDEX "IDX_37bb9a1b4585f8a3beb24c62d6" ON "drive_file" ("md5") | |
| INFO * [db sql] CREATE INDEX "IDX_a40b8df8c989d7db937ea27cf6" ON "drive_file" ("type") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_d85a184c2540d2deba33daf642" ON "drive_file" ("accessKey") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_e74022ce9a074b3866f70e0d27" ON "drive_file" ("thumbnailAccessKey") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_c55b2b7c284d9fef98026fc88e" ON "drive_file" ("webpublicAccessKey") | |
| INFO * [db sql] CREATE INDEX "IDX_e5848eac4940934e23dbc17581" ON "drive_file" ("uri") | |
| INFO * [db sql] CREATE INDEX "IDX_bb90d1956dafc4068c28aa7560" ON "drive_file" ("folderId") | |
| INFO * [db sql] creating a new table: user | |
| INFO * [db sql] CREATE TABLE "user" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE, "lastFetchedAt" TIMESTAMP WITH TIME ZONE, "username" character varying(128) NOT NULL, "usernameLower" character varying(128) NOT NULL, "name" character varying(128), "location" character varying(128), "birthday" character(10), "followersCount" integer NOT NULL DEFAULT 0, "followingCount" integer NOT NULL DEFAULT 0, "notesCount" integer NOT NULL DEFAULT 0, "avatarId" character varying(32), "bannerId" character varying(32), "description" character varying(1024), "tags" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], "email" character varying(128), "emailVerifyCode" character varying(128), "emailVerified" boolean NOT NULL DEFAULT false, "twoFactorTempSecret" character varying(128), "twoFactorSecret" character varying(128), "avatarUrl" character varying(256), "bannerUrl" character varying(256), "avatarColor" character varying(32), "bannerColor" character varying(32), "isSuspended" boolean NOT NULL DEFAULT false, "isSilenced" boolean NOT NULL DEFAULT false, "isLocked" boolean NOT NULL DEFAULT false, "isBot" boolean NOT NULL DEFAULT false, "isCat" boolean NOT NULL DEFAULT false, "isAdmin" boolean NOT NULL DEFAULT false, "isModerator" boolean NOT NULL DEFAULT false, "isVerified" boolean NOT NULL DEFAULT false, "twoFactorEnabled" boolean NOT NULL DEFAULT false, "emojis" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], "host" character varying(128), "inbox" character varying(256), "sharedInbox" character varying(256), "featured" character varying(256), "uri" character varying(256), "password" character varying(128), "token" character varying(32), "clientData" jsonb NOT NULL DEFAULT '{}', "autoWatch" boolean NOT NULL DEFAULT false, "autoAcceptFollowed" boolean NOT NULL DEFAULT false, "alwaysMarkNsfw" boolean NOT NULL DEFAULT false, "carefulBot" boolean NOT NULL DEFAULT false, CONSTRAINT "UQ_a854e557b1b14814750c7c7b0c9" UNIQUE ("token"), CONSTRAINT "REL_58f5c71eaab331645112cf8cfa" UNIQUE ("avatarId"), CONSTRAINT "REL_afc64b53f8db3707ceb34eb28e" UNIQUE ("bannerId"), CONSTRAINT "PK_cace4a159ff9f2512dd42373760" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_e11e649824a45d8ed01d597fd9" ON "user" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_80ca6e6ef65fb9ef34ea8c90f4" ON "user" ("updatedAt") | |
| INFO * [db sql] CREATE INDEX "IDX_a27b942a0d6dcff90e3ee9b5e8" ON "user" ("usernameLower") | |
| INFO * [db sql] CREATE INDEX "IDX_fa99d777623947a5b05f394cae" ON "user" ("tags") | |
| INFO * [db sql] CREATE INDEX "IDX_3252a5df8d5bbd16b281f7799e" ON "user" ("host") | |
| INFO * [db sql] CREATE INDEX "IDX_be623adaa4c566baf5d29ce0c8" ON "user" ("uri") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_a854e557b1b14814750c7c7b0c" ON "user" ("token") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_5deb01ae162d1d70b80d064c27" ON "user" ("usernameLower", "host") | |
| INFO * [db sql] creating a new table: app | |
| INFO * [db sql] CREATE TABLE "app" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32), "secret" character varying(64) NOT NULL, "name" character varying(128) NOT NULL, "description" character varying(512) NOT NULL, "permission" character varying(64) array NOT NULL, "callbackUrl" character varying(256), CONSTRAINT "PK_9478629fc093d229df09e560aea" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_048a757923ed8b157e9895da53" ON "app" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_3f5b0899ef90527a3462d7c2cb" ON "app" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_f49922d511d666848f250663c4" ON "app" ("secret") | |
| INFO * [db sql] creating a new table: access_token | |
| INFO * [db sql] CREATE TABLE "access_token" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "token" character varying(128) NOT NULL, "hash" character varying(128) NOT NULL, "appId" character varying(32) NOT NULL, "userId" character varying(32), CONSTRAINT "PK_f20f028607b2603deabd8182d12" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_70ba8f6af34bc924fc9e12adb8" ON "access_token" ("token") | |
| INFO * [db sql] CREATE INDEX "IDX_64c327441248bae40f7d92f34f" ON "access_token" ("hash") | |
| INFO * [db sql] creating a new table: note | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = 'note_visibility_enum' | |
| INFO * [db sql] CREATE TYPE "note_visibility_enum" AS ENUM('public', 'home', 'followers', 'specified') | |
| INFO * [db sql] CREATE TABLE "note" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE, "replyId" character varying(32), "renoteId" character varying(32), "text" text, "name" character varying(256), "cw" character varying(512), "appId" character varying(32), "userId" character varying(32) NOT NULL, "viaMobile" boolean NOT NULL DEFAULT false, "localOnly" boolean NOT NULL DEFAULT false, "renoteCount" integer NOT NULL DEFAULT 0, "repliesCount" integer NOT NULL DEFAULT 0, "reactions" jsonb NOT NULL DEFAULT '{}', "visibility" "note_visibility_enum" NOT NULL, "uri" character varying(256), "score" integer NOT NULL DEFAULT 0, "fileIds" character varying(32) array NOT NULL DEFAULT '{}'::varchar[], "attachedFileTypes" character varying(256) array NOT NULL DEFAULT '{}'::varchar[], "visibleUserIds" character varying(32) array NOT NULL DEFAULT '{}'::varchar[], "mentions" character varying(32) array NOT NULL DEFAULT '{}'::varchar[], "mentionedRemoteUsers" text NOT NULL DEFAULT '[]', "emojis" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], "tags" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], "hasPoll" boolean NOT NULL DEFAULT false, "geo" jsonb DEFAULT '{}', "userHost" character varying(128), "userInbox" character varying(128), "replyUserId" character varying(32), "replyUserHost" character varying(128), "renoteUserId" character varying(32), "renoteUserHost" character varying(128), CONSTRAINT "PK_96d0c172a4fba276b1bbed43058" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_e7c0567f5261063592f022e9b5" ON "note" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_4d047e2d64406dcdacdd6c5c01" ON "note" ("updatedAt") | |
| INFO * [db sql] CREATE INDEX "IDX_17cb3553c700a4985dff5a30ff" ON "note" ("replyId") | |
| INFO * [db sql] CREATE INDEX "IDX_52ccc804d7c69037d558bac4c9" ON "note" ("renoteId") | |
| INFO * [db sql] CREATE INDEX "IDX_5b87d9d19127bd5d92026017a7" ON "note" ("userId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_153536c67d05e9adb24e99fc2b" ON "note" ("uri") | |
| INFO * [db sql] CREATE INDEX "IDX_796a8c03959361f97dc2be1d5c" ON "note" ("visibleUserIds") | |
| INFO * [db sql] CREATE INDEX "IDX_54ebcb6d27222913b908d56fd8" ON "note" ("mentions") | |
| INFO * [db sql] CREATE INDEX "IDX_88937d94d7443d9a99a76fa5c0" ON "note" ("tags") | |
| INFO * [db sql] CREATE INDEX "IDX_7125a826ab192eb27e11d358a5" ON "note" ("userHost") | |
| INFO * [db sql] creating a new table: poll_vote | |
| INFO * [db sql] CREATE TABLE "poll_vote" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "choice" integer NOT NULL, CONSTRAINT "PK_fd002d371201c472490ba89c6a0" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_0fb627e1c2f753262a74f0562d" ON "poll_vote" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_66d2bd2ee31d14bcc23069a89f" ON "poll_vote" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_aecfbd5ef60374918e63ee95fa" ON "poll_vote" ("noteId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_50bd7164c5b78f1f4a42c4d21f" ON "poll_vote" ("userId", "noteId", "choice") | |
| INFO * [db sql] creating a new table: note_reaction | |
| INFO * [db sql] CREATE TABLE "note_reaction" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "reaction" character varying(32) NOT NULL, CONSTRAINT "PK_767ec729b108799b587a3fcc9cf" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_01f4581f114e0ebd2bbb876f0b" ON "note_reaction" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_13761f64257f40c5636d0ff95e" ON "note_reaction" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_45145e4953780f3cd5656f0ea6" ON "note_reaction" ("noteId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_ad0c221b25672daf2df320a817" ON "note_reaction" ("userId", "noteId") | |
| INFO * [db sql] creating a new table: note_watching | |
| INFO * [db sql] CREATE TABLE "note_watching" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "noteUserId" character varying(32) NOT NULL, CONSTRAINT "PK_49286fdb23725945a74aa27d757" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_318cdf42a9cfc11f479bd802bb" ON "note_watching" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_b0134ec406e8d09a540f818288" ON "note_watching" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_03e7028ab8388a3f5e3ce2a861" ON "note_watching" ("noteId") | |
| INFO * [db sql] CREATE INDEX "IDX_44499765eec6b5489d72c4253b" ON "note_watching" ("noteUserId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_a42c93c69989ce1d09959df4cf" ON "note_watching" ("userId", "noteId") | |
| INFO * [db sql] creating a new table: note_unread | |
| INFO * [db sql] CREATE TABLE "note_unread" ("id" character varying(32) NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "noteUserId" character varying(32) NOT NULL, "isSpecified" boolean NOT NULL, CONSTRAINT "PK_1904eda61a784f57e6e51fa9c1f" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_56b0166d34ddae49d8ef7610bb" ON "note_unread" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_e637cba4dc4410218c4251260e" ON "note_unread" ("noteId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_d908433a4953cc13216cd9c274" ON "note_unread" ("userId", "noteId") | |
| INFO * [db sql] creating a new table: notification | |
| INFO * [db sql] CREATE TABLE "notification" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "notifieeId" character varying(32) NOT NULL, "notifierId" character varying(32) NOT NULL, "type" character varying(32) NOT NULL, "isRead" boolean NOT NULL DEFAULT false, "noteId" character varying(32), "reaction" character varying(128), "choice" integer, CONSTRAINT "PK_705b6c7cdf9b2c2ff7ac7872cb7" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b11a5e627c41d4dc3170f1d370" ON "notification" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_3c601b70a1066d2c8b517094cb" ON "notification" ("notifieeId") | |
| INFO * [db sql] creating a new table: meta | |
| INFO * [db sql] CREATE TABLE "meta" ("id" character varying(32) NOT NULL, "name" character varying(128), "description" character varying(1024), "maintainerName" character varying(128), "maintainerEmail" character varying(128), "announcements" jsonb NOT NULL DEFAULT '[]', "disableRegistration" boolean NOT NULL DEFAULT false, "disableLocalTimeline" boolean NOT NULL DEFAULT false, "disableGlobalTimeline" boolean NOT NULL DEFAULT false, "enableEmojiReaction" boolean NOT NULL DEFAULT true, "useStarForReactionFallback" boolean NOT NULL DEFAULT false, "langs" character varying(64) array NOT NULL DEFAULT '{}'::varchar[], "hiddenTags" character varying(256) array NOT NULL DEFAULT '{}'::varchar[], "blockedHosts" character varying(256) array NOT NULL DEFAULT '{}'::varchar[], "mascotImageUrl" character varying(256) DEFAULT '/assets/ai.png', "bannerUrl" character varying(256), "errorImageUrl" character varying(256) DEFAULT 'https://ai.misskey.xyz/aiart/yubitun.png', "iconUrl" character varying(256), "cacheRemoteFiles" boolean NOT NULL DEFAULT true, "proxyAccount" character varying(128), "enableRecaptcha" boolean NOT NULL DEFAULT false, "recaptchaSiteKey" character varying(64), "recaptchaSecretKey" character varying(64), "localDriveCapacityMb" integer NOT NULL DEFAULT 1024, "remoteDriveCapacityMb" integer NOT NULL DEFAULT 32, "maxNoteTextLength" integer NOT NULL DEFAULT 500, "summalyProxy" character varying(128), "enableEmail" boolean NOT NULL DEFAULT false, "email" character varying(128), "smtpSecure" boolean NOT NULL DEFAULT false, "smtpHost" character varying(128), "smtpPort" integer, "smtpUser" character varying(128), "smtpPass" character varying(128), "enableServiceWorker" boolean NOT NULL DEFAULT false, "swPublicKey" character varying(128), "swPrivateKey" character varying(128), "enableTwitterIntegration" boolean NOT NULL DEFAULT false, "twitterConsumerKey" character varying(128), "twitterConsumerSecret" character varying(128), "enableGithubIntegration" boolean NOT NULL DEFAULT false, "githubClientId" character varying(128), "githubClientSecret" character varying(128), "enableDiscordIntegration" boolean NOT NULL DEFAULT false, "discordClientId" character varying(128), "discordClientSecret" character varying(128), CONSTRAINT "PK_c4c17a6c2bd7651338b60fc590b" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: following | |
| INFO * [db sql] CREATE TABLE "following" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "followeeId" character varying(32) NOT NULL, "followerId" character varying(32) NOT NULL, "followerHost" character varying(128), "followerInbox" character varying(256), "followerSharedInbox" character varying(256), "followeeHost" character varying(128), "followeeInbox" character varying(256), "followeeSharedInbox" character varying(256), CONSTRAINT "PK_c76c6e044bdf76ecf8bfb82a645" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_582f8fab771a9040a12961f3e7" ON "following" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_24e0042143a18157b234df186c" ON "following" ("followeeId") | |
| INFO * [db sql] CREATE INDEX "IDX_6516c5a6f3c015b4eed39978be" ON "following" ("followerId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_307be5f1d1252e0388662acb96" ON "following" ("followerId", "followeeId") | |
| INFO * [db sql] creating a new table: instance | |
| INFO * [db sql] CREATE TABLE "instance" ("id" character varying(32) NOT NULL, "caughtAt" TIMESTAMP WITH TIME ZONE NOT NULL, "host" character varying(128) NOT NULL, "system" character varying(64), "usersCount" integer NOT NULL, "notesCount" integer NOT NULL, "followingCount" integer NOT NULL, "followersCount" integer NOT NULL, "driveUsage" integer NOT NULL, "driveFiles" integer NOT NULL, "latestRequestSentAt" TIMESTAMP WITH TIME ZONE, "latestStatus" integer, "latestRequestReceivedAt" TIMESTAMP WITH TIME ZONE, "lastCommunicatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, "isNotResponding" boolean NOT NULL DEFAULT false, "isMarkedAsClosed" boolean NOT NULL DEFAULT false, CONSTRAINT "PK_eaf60e4a0c399c9935413e06474" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_2cd3b2a6b4cf0b910b260afe08" ON "instance" ("caughtAt") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_8d5afc98982185799b160e10eb" ON "instance" ("host") | |
| INFO * [db sql] creating a new table: muting | |
| INFO * [db sql] CREATE TABLE "muting" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "muteeId" character varying(32) NOT NULL, "muterId" character varying(32) NOT NULL, CONSTRAINT "PK_2e92d06c8b5c602eeb27ca9ba48" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_f86d57fbca33c7a4e6897490cc" ON "muting" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_ec96b4fed9dae517e0dbbe0675" ON "muting" ("muteeId") | |
| INFO * [db sql] CREATE INDEX "IDX_93060675b4a79a577f31d260c6" ON "muting" ("muterId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_1eb9d9824a630321a29fd3b290" ON "muting" ("muterId", "muteeId") | |
| INFO * [db sql] creating a new table: sw_subscription | |
| INFO * [db sql] CREATE TABLE "sw_subscription" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "endpoint" character varying(256) NOT NULL, "auth" character varying(256) NOT NULL, "publickey" character varying(128) NOT NULL, CONSTRAINT "PK_e8f763631530051b95eb6279b91" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_97754ca6f2baff9b4abb7f853d" ON "sw_subscription" ("userId") | |
| INFO * [db sql] creating a new table: blocking | |
| INFO * [db sql] CREATE TABLE "blocking" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "blockeeId" character varying(32) NOT NULL, "blockerId" character varying(32) NOT NULL, CONSTRAINT "PK_e5d9a541cc1965ee7e048ea09dd" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b9a354f7941c1e779f3b33aea6" ON "blocking" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_2cd4a2743a99671308f5417759" ON "blocking" ("blockeeId") | |
| INFO * [db sql] CREATE INDEX "IDX_0627125f1a8a42c9a1929edb55" ON "blocking" ("blockerId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_98a1bc5cb30dfd159de056549f" ON "blocking" ("blockerId", "blockeeId") | |
| INFO * [db sql] creating a new table: user_list | |
| INFO * [db sql] CREATE TABLE "user_list" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "name" character varying(128) NOT NULL, CONSTRAINT "PK_87bab75775fd9b1ff822b656402" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b7fcefbdd1c18dce86687531f9" ON "user_list" ("userId") | |
| INFO * [db sql] creating a new table: user_list_joining | |
| INFO * [db sql] CREATE TABLE "user_list_joining" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "userListId" character varying(32) NOT NULL, CONSTRAINT "PK_11abb3768da1c5f8de101c9df45" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_d844bfc6f3f523a05189076efa" ON "user_list_joining" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_605472305f26818cc93d1baaa7" ON "user_list_joining" ("userListId") | |
| INFO * [db sql] creating a new table: hashtag | |
| INFO * [db sql] CREATE TABLE "hashtag" ("id" character varying(32) NOT NULL, "name" character varying(128) NOT NULL, "mentionedUserIds" character varying(32) array NOT NULL, "mentionedUsersCount" integer NOT NULL DEFAULT 0, "mentionedLocalUserIds" character varying(32) array NOT NULL, "mentionedLocalUsersCount" integer NOT NULL DEFAULT 0, "mentionedRemoteUserIds" character varying(32) array NOT NULL, "mentionedRemoteUsersCount" integer NOT NULL DEFAULT 0, "attachedUserIds" character varying(32) array NOT NULL, "attachedUsersCount" integer NOT NULL DEFAULT 0, "attachedLocalUserIds" character varying(32) array NOT NULL, "attachedLocalUsersCount" integer NOT NULL DEFAULT 0, "attachedRemoteUserIds" character varying(32) array NOT NULL, "attachedRemoteUsersCount" integer NOT NULL DEFAULT 0, CONSTRAINT "PK_cb36eb8af8412bfa978f1165d78" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_347fec870eafea7b26c8a73bac" ON "hashtag" ("name") | |
| INFO * [db sql] CREATE INDEX "IDX_2710a55f826ee236ea1a62698f" ON "hashtag" ("mentionedUsersCount") | |
| INFO * [db sql] CREATE INDEX "IDX_0e206cec573f1edff4a3062923" ON "hashtag" ("mentionedLocalUsersCount") | |
| INFO * [db sql] CREATE INDEX "IDX_4c02d38a976c3ae132228c6fce" ON "hashtag" ("mentionedRemoteUsersCount") | |
| INFO * [db sql] CREATE INDEX "IDX_d57f9030cd3af7f63ffb1c267c" ON "hashtag" ("attachedUsersCount") | |
| INFO * [db sql] CREATE INDEX "IDX_0c44bf4f680964145f2a68a341" ON "hashtag" ("attachedLocalUsersCount") | |
| INFO * [db sql] CREATE INDEX "IDX_0b03cbcd7e6a7ce068efa8ecc2" ON "hashtag" ("attachedRemoteUsersCount") | |
| INFO * [db sql] creating a new table: note_favorite | |
| INFO * [db sql] CREATE TABLE "note_favorite" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, CONSTRAINT "PK_af0da35a60b9fa4463a62082b36" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_47f4b1892f5d6ba8efb3057d81" ON "note_favorite" ("userId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_0f4fb9ad355f3effff221ef245" ON "note_favorite" ("userId", "noteId") | |
| INFO * [db sql] creating a new table: abuse_user_report | |
| INFO * [db sql] CREATE TABLE "abuse_user_report" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "reporterId" character varying(32) NOT NULL, "comment" character varying(512) NOT NULL, CONSTRAINT "PK_87873f5f5cc5c321a1306b2d18c" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_db2098070b2b5a523c58181f74" ON "abuse_user_report" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_d049123c413e68ca52abe73420" ON "abuse_user_report" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_04cc96756f89d0b7f9473e8cdf" ON "abuse_user_report" ("reporterId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_5cd442c3b2e74fdd99dae20243" ON "abuse_user_report" ("userId", "reporterId") | |
| INFO * [db sql] creating a new table: registration_ticket | |
| INFO * [db sql] CREATE TABLE "registration_ticket" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "code" character varying(64) NOT NULL, CONSTRAINT "PK_f11696b6fafcf3662d4292734f8" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_0ff69e8dfa9fe31bb4a4660f59" ON "registration_ticket" ("code") | |
| INFO * [db sql] creating a new table: messaging_message | |
| INFO * [db sql] CREATE TABLE "messaging_message" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "recipientId" character varying(32) NOT NULL, "text" character varying(4096), "isRead" boolean NOT NULL DEFAULT false, "fileId" character varying(32), CONSTRAINT "PK_db398fd79dc95d0eb8c30456eaa" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_e21cd3646e52ef9c94aaf17c2e" ON "messaging_message" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_5377c307783fce2b6d352e1203" ON "messaging_message" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_cac14a4e3944454a5ce7daa514" ON "messaging_message" ("recipientId") | |
| INFO * [db sql] creating a new table: signin | |
| INFO * [db sql] CREATE TABLE "signin" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "ip" character varying(128) NOT NULL, "headers" jsonb NOT NULL, "success" boolean NOT NULL, CONSTRAINT "PK_9e96ddc025712616fc492b3b588" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_2c308dbdc50d94dc625670055f" ON "signin" ("userId") | |
| INFO * [db sql] creating a new table: auth_session | |
| INFO * [db sql] CREATE TABLE "auth_session" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "token" character varying(128) NOT NULL, "userId" character varying(32) NOT NULL, "appId" character varying(32) NOT NULL, CONSTRAINT "PK_19354ed146424a728c1112a8cbf" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_62cb09e1129f6ec024ef66e183" ON "auth_session" ("token") | |
| INFO * [db sql] creating a new table: follow_request | |
| INFO * [db sql] CREATE TABLE "follow_request" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "followeeId" character varying(32) NOT NULL, "followerId" character varying(32) NOT NULL, "requestId" character varying(128), "followerHost" character varying(128), "followerInbox" character varying(256), "followerSharedInbox" character varying(256), "followeeHost" character varying(128), "followeeInbox" character varying(256), "followeeSharedInbox" character varying(256), CONSTRAINT "PK_53a9aa3725f7a3deb150b39dbfc" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_12c01c0d1a79f77d9f6c15fadd" ON "follow_request" ("followeeId") | |
| INFO * [db sql] CREATE INDEX "IDX_a7fd92dd6dc519e6fb435dd108" ON "follow_request" ("followerId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_d54a512b822fac7ed52800f6b4" ON "follow_request" ("followerId", "followeeId") | |
| INFO * [db sql] creating a new table: emoji | |
| INFO * [db sql] CREATE TABLE "emoji" ("id" character varying(32) NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE, "name" character varying(128) NOT NULL, "host" character varying(128), "url" character varying(256) NOT NULL, "uri" character varying(256), "type" character varying(64), "aliases" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], CONSTRAINT "PK_df74ce05e24999ee01ea0bc50a3" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b37dafc86e9af007e3295c2781" ON "emoji" ("name") | |
| INFO * [db sql] CREATE INDEX "IDX_5900e907bb46516ddf2871327c" ON "emoji" ("host") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_4f4d35e1256c84ae3d1f0eab10" ON "emoji" ("name", "host") | |
| INFO * [db sql] creating a new table: reversi_game | |
| INFO * [db sql] CREATE TABLE "reversi_game" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "startedAt" TIMESTAMP WITH TIME ZONE, "user1Id" character varying(32) NOT NULL, "user2Id" character varying(32) NOT NULL, "user1Accepted" boolean NOT NULL DEFAULT false, "user2Accepted" boolean NOT NULL DEFAULT false, "black" integer, "isStarted" boolean NOT NULL DEFAULT false, "isEnded" boolean NOT NULL DEFAULT false, "winnerId" character varying(32), "surrendered" character varying(32), "logs" jsonb NOT NULL DEFAULT '[]', "map" character varying(64) array NOT NULL, "bw" character varying(32) NOT NULL, "isLlotheo" boolean NOT NULL DEFAULT false, "canPutEverywhere" boolean NOT NULL DEFAULT false, "loopedBoard" boolean NOT NULL DEFAULT false, "form1" jsonb DEFAULT null, "form2" jsonb DEFAULT null, "crc32" character varying(32), CONSTRAINT "PK_76b30eeba71b1193ad7c5311c3f" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b46ec40746efceac604142be1c" ON "reversi_game" ("createdAt") | |
| INFO * [db sql] creating a new table: reversi_matching | |
| INFO * [db sql] CREATE TABLE "reversi_matching" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "parentId" character varying(32) NOT NULL, "childId" character varying(32) NOT NULL, CONSTRAINT "PK_880bd0afbab232f21c8b9d146cf" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_b604d92d6c7aec38627f6eaf16" ON "reversi_matching" ("createdAt") | |
| INFO * [db sql] CREATE INDEX "IDX_3b25402709dd9882048c2bbade" ON "reversi_matching" ("parentId") | |
| INFO * [db sql] CREATE INDEX "IDX_e247b23a3c9b45f89ec1299d06" ON "reversi_matching" ("childId") | |
| INFO * [db sql] creating a new table: user_note_pining | |
| INFO * [db sql] CREATE TABLE "user_note_pining" ("id" character varying(32) NOT NULL, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "userId" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, CONSTRAINT "PK_a6a2dad4ae000abce2ea9d9b103" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE INDEX "IDX_bfbc6f79ba4007b4ce5097f08d" ON "user_note_pining" ("userId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_410cd649884b501c02d6e72738" ON "user_note_pining" ("userId", "noteId") | |
| INFO * [db sql] creating a new table: user_service_linking | |
| INFO * [db sql] CREATE TABLE "user_service_linking" ("id" character varying(32) NOT NULL, "userId" character varying(32) NOT NULL, "twitter" boolean NOT NULL DEFAULT false, "twitterAccessToken" character varying(64) DEFAULT null, "twitterAccessTokenSecret" character varying(64) DEFAULT null, "twitterUserId" character varying(64) DEFAULT null, "twitterScreenName" character varying(64) DEFAULT null, "github" boolean NOT NULL DEFAULT false, "githubAccessToken" character varying(64) DEFAULT null, "githubId" integer DEFAULT null, "githubLogin" character varying(64) DEFAULT null, "discord" boolean NOT NULL DEFAULT false, "discordAccessToken" character varying(64) DEFAULT null, "discordRefreshToken" character varying(64) DEFAULT null, "discordExpiresDate" integer DEFAULT null, "discordId" character varying(64) DEFAULT null, "discordUsername" character varying(64) DEFAULT null, "discordDiscriminator" character varying(64) DEFAULT null, "userHost" character varying(128), CONSTRAINT "REL_c165fd56a9fa45ff9bdb8ef6fd" UNIQUE ("userId"), CONSTRAINT "PK_899751d519f2a9c1f900799ad92" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_c165fd56a9fa45ff9bdb8ef6fd" ON "user_service_linking" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_1f61ee10afd757b2eb99c573db" ON "user_service_linking" ("userHost") | |
| INFO * [db sql] creating a new table: poll | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = 'poll_notevisibility_enum' | |
| INFO * [db sql] CREATE TYPE "poll_notevisibility_enum" AS ENUM('public', 'home', 'followers', 'specified') | |
| INFO * [db sql] CREATE TABLE "poll" ("id" character varying(32) NOT NULL, "noteId" character varying(32) NOT NULL, "expiresAt" TIMESTAMP WITH TIME ZONE, "multiple" boolean NOT NULL, "choices" character varying(128) array NOT NULL DEFAULT '{}'::varchar[], "votes" integer array NOT NULL, "noteVisibility" "poll_notevisibility_enum" NOT NULL, "userId" character varying(32) NOT NULL, "userHost" character varying(128), CONSTRAINT "REL_da851e06d0dfe2ef397d8b1bf1" UNIQUE ("noteId"), CONSTRAINT "PK_03b5cf19a7f562b231c3458527e" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_da851e06d0dfe2ef397d8b1bf1" ON "poll" ("noteId") | |
| INFO * [db sql] CREATE INDEX "IDX_0610ebcfcfb4a18441a9bcdab2" ON "poll" ("userId") | |
| INFO * [db sql] CREATE INDEX "IDX_7fa20a12319c7f6dc3aed98c0a" ON "poll" ("userHost") | |
| INFO * [db sql] creating a new table: user_keypair | |
| INFO * [db sql] CREATE TABLE "user_keypair" ("id" character varying(32) NOT NULL, "userId" character varying(32) NOT NULL, "keyPem" character varying(2048) NOT NULL, CONSTRAINT "REL_f4853eb41ab722fe05f81cedeb" UNIQUE ("userId"), CONSTRAINT "PK_5a1142d3e11f23a37528d59d99d" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_f4853eb41ab722fe05f81cedeb" ON "user_keypair" ("userId") | |
| INFO * [db sql] creating a new table: user_publickey | |
| INFO * [db sql] CREATE TABLE "user_publickey" ("id" character varying(32) NOT NULL, "userId" character varying(32) NOT NULL, "keyId" character varying(256) NOT NULL, "keyPem" character varying(2048) NOT NULL, CONSTRAINT "REL_10c146e4b39b443ede016f6736" UNIQUE ("userId"), CONSTRAINT "PK_87ddc012774d4e4414c023419f0" PRIMARY KEY ("id")) | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_10c146e4b39b443ede016f6736" ON "user_publickey" ("userId") | |
| INFO * [db sql] CREATE UNIQUE INDEX "IDX_171e64971c780ebd23fae140bb" ON "user_publickey" ("keyId") | |
| INFO * [db sql] creating a new table: __chart__active_users | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__active_users_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__active_users_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__active_users" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__active_users_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_count" integer NOT NULL, "___remote_count" integer NOT NULL, CONSTRAINT "PK_317237a9f733b970604a11e314f" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__drive | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__drive_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__drive_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__drive" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__drive_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_totalCount" integer NOT NULL, "___local_totalSize" integer NOT NULL, "___local_incCount" integer NOT NULL, "___local_incSize" integer NOT NULL, "___local_decCount" integer NOT NULL, "___local_decSize" integer NOT NULL, "___remote_totalCount" integer NOT NULL, "___remote_totalSize" integer NOT NULL, "___remote_incCount" integer NOT NULL, "___remote_incSize" integer NOT NULL, "___remote_decCount" integer NOT NULL, "___remote_decSize" integer NOT NULL, CONSTRAINT "PK_f96bc548a765cd4b3b354221ce7" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__federation | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__federation_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__federation_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__federation" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__federation_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___instance_total" integer NOT NULL, "___instance_inc" integer NOT NULL, "___instance_dec" integer NOT NULL, CONSTRAINT "PK_b39dcd31a0fe1a7757e348e85fd" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__hashtag | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__hashtag_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__hashtag_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__hashtag" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__hashtag_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_count" integer NOT NULL, "___remote_count" integer NOT NULL, CONSTRAINT "PK_c32f1ea2b44a5d2f7881e37f8f9" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__instance | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__instance_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__instance_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__instance" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__instance_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___requests_failed" integer NOT NULL, "___requests_succeeded" integer NOT NULL, "___requests_received" integer NOT NULL, "___notes_total" integer NOT NULL, "___notes_inc" integer NOT NULL, "___notes_dec" integer NOT NULL, "___users_total" integer NOT NULL, "___users_inc" integer NOT NULL, "___users_dec" integer NOT NULL, "___following_total" integer NOT NULL, "___following_inc" integer NOT NULL, "___following_dec" integer NOT NULL, "___followers_total" integer NOT NULL, "___followers_inc" integer NOT NULL, "___followers_dec" integer NOT NULL, "___drive_totalFiles" integer NOT NULL, "___drive_totalUsage" integer NOT NULL, "___drive_incFiles" integer NOT NULL, "___drive_incUsage" integer NOT NULL, "___drive_decFiles" integer NOT NULL, "___drive_decUsage" integer NOT NULL, CONSTRAINT "PK_1267c67c7c2d47b4903975f2c00" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__network | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__network_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__network_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__network" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__network_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___incomingRequests" integer NOT NULL, "___outgoingRequests" integer NOT NULL, "___totalTime" integer NOT NULL, "___incomingBytes" integer NOT NULL, "___outgoingBytes" integer NOT NULL, CONSTRAINT "PK_bc4290c2e27fad14ef0c1ca93f3" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__notes | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__notes_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__notes_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__notes" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__notes_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_total" integer NOT NULL, "___local_inc" integer NOT NULL, "___local_dec" integer NOT NULL, "___local_diffs_normal" integer NOT NULL, "___local_diffs_reply" integer NOT NULL, "___local_diffs_renote" integer NOT NULL, "___remote_total" integer NOT NULL, "___remote_inc" integer NOT NULL, "___remote_dec" integer NOT NULL, "___remote_diffs_normal" integer NOT NULL, "___remote_diffs_reply" integer NOT NULL, "___remote_diffs_renote" integer NOT NULL, CONSTRAINT "PK_0aec823fa85c7f901bdb3863b14" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__per_user_drive | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__per_user_drive_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__per_user_drive_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__per_user_drive" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__per_user_drive_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___totalCount" integer NOT NULL, "___totalSize" integer NOT NULL, "___incCount" integer NOT NULL, "___incSize" integer NOT NULL, "___decCount" integer NOT NULL, "___decSize" integer NOT NULL, CONSTRAINT "PK_d0ef23d24d666e1a44a0cd3d208" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__per_user_following | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__per_user_following_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__per_user_following_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__per_user_following" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__per_user_following_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_followings_total" integer NOT NULL, "___local_followings_inc" integer NOT NULL, "___local_followings_dec" integer NOT NULL, "___local_followers_total" integer NOT NULL, "___local_followers_inc" integer NOT NULL, "___local_followers_dec" integer NOT NULL, "___remote_followings_total" integer NOT NULL, "___remote_followings_inc" integer NOT NULL, "___remote_followings_dec" integer NOT NULL, "___remote_followers_total" integer NOT NULL, "___remote_followers_inc" integer NOT NULL, "___remote_followers_dec" integer NOT NULL, CONSTRAINT "PK_85bb1b540363a29c2fec83bd907" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__per_user_notes | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__per_user_notes_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__per_user_notes_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__per_user_notes" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__per_user_notes_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___total" integer NOT NULL, "___inc" integer NOT NULL, "___dec" integer NOT NULL, "___diffs_normal" integer NOT NULL, "___diffs_reply" integer NOT NULL, "___diffs_renote" integer NOT NULL, CONSTRAINT "PK_334acf6e915af2f29edc11b8e50" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__per_user_reaction | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__per_user_reaction_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__per_user_reaction_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__per_user_reaction" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__per_user_reaction_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_count" integer NOT NULL, "___remote_count" integer NOT NULL, CONSTRAINT "PK_984f54dae441e65b633e8d27a7f" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__test_grouped | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__test_grouped_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__test_grouped_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__test_grouped" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__test_grouped_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___foo_total" integer NOT NULL, "___foo_inc" integer NOT NULL, "___foo_dec" integer NOT NULL, CONSTRAINT "PK_f4a2b175d308695af30d4293272" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__test_unique | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__test_unique_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__test_unique_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__test_unique" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__test_unique_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___foo" integer NOT NULL, CONSTRAINT "PK_409bac9c97cc612d8500012319d" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__test | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__test_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__test_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__test" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__test_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___foo_total" integer NOT NULL, "___foo_inc" integer NOT NULL, "___foo_dec" integer NOT NULL, CONSTRAINT "PK_b4bc31dffbd1b785276a3ecfc1e" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a new table: __chart__users | |
| INFO * [db sql] SELECT "n"."nspname", "t"."typname" FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = current_schema() AND "t"."typname" = '__chart__users_span_enum' | |
| INFO * [db sql] CREATE TYPE "__chart__users_span_enum" AS ENUM('hour', 'day') | |
| INFO * [db sql] CREATE TABLE "__chart__users" ("id" SERIAL NOT NULL, "date" integer NOT NULL, "group" character varying(128), "span" "__chart__users_span_enum" NOT NULL, "unique" jsonb NOT NULL DEFAULT '{}', "___local_total" integer NOT NULL, "___local_inc" integer NOT NULL, "___local_dec" integer NOT NULL, "___remote_total" integer NOT NULL, "___remote_inc" integer NOT NULL, "___remote_dec" integer NOT NULL, CONSTRAINT "PK_4dfcf2c78d03524b9eb2c99d328" PRIMARY KEY ("id")) | |
| INFO * [db sql] creating a foreign keys: FK_f4fc06e49c0171c85f1c48060d2, FK_00ceffb0cdc238b3233294f08f2 on table "drive_folder" | |
| INFO * [db sql] ALTER TABLE "drive_folder" ADD CONSTRAINT "FK_f4fc06e49c0171c85f1c48060d2" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "drive_folder" ADD CONSTRAINT "FK_00ceffb0cdc238b3233294f08f2" FOREIGN KEY ("parentId") REFERENCES "drive_folder"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_860fa6f6c7df5bb887249fba22e, FK_bb90d1956dafc4068c28aa7560a on table "drive_file" | |
| INFO * [db sql] ALTER TABLE "drive_file" ADD CONSTRAINT "FK_860fa6f6c7df5bb887249fba22e" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "drive_file" ADD CONSTRAINT "FK_bb90d1956dafc4068c28aa7560a" FOREIGN KEY ("folderId") REFERENCES "drive_folder"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_58f5c71eaab331645112cf8cfa5, FK_afc64b53f8db3707ceb34eb28e2 on table "user" | |
| INFO * [db sql] ALTER TABLE "user" ADD CONSTRAINT "FK_58f5c71eaab331645112cf8cfa5" FOREIGN KEY ("avatarId") REFERENCES "drive_file"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "user" ADD CONSTRAINT "FK_afc64b53f8db3707ceb34eb28e2" FOREIGN KEY ("bannerId") REFERENCES "drive_file"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_3f5b0899ef90527a3462d7c2cb3 on table "app" | |
| INFO * [db sql] ALTER TABLE "app" ADD CONSTRAINT "FK_3f5b0899ef90527a3462d7c2cb3" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_9949557d0e1b2c19e5344c171e9, FK_a3ff16c90cc87a82a0b5959e560 on table "access_token" | |
| INFO * [db sql] ALTER TABLE "access_token" ADD CONSTRAINT "FK_9949557d0e1b2c19e5344c171e9" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "access_token" ADD CONSTRAINT "FK_a3ff16c90cc87a82a0b5959e560" FOREIGN KEY ("appId") REFERENCES "app"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_17cb3553c700a4985dff5a30ff5, FK_52ccc804d7c69037d558bac4c96, FK_ec5c201576192ba8904c345c5cc, FK_5b87d9d19127bd5d92026017a7b on table "note" | |
| INFO * [db sql] ALTER TABLE "note" ADD CONSTRAINT "FK_17cb3553c700a4985dff5a30ff5" FOREIGN KEY ("replyId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note" ADD CONSTRAINT "FK_52ccc804d7c69037d558bac4c96" FOREIGN KEY ("renoteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note" ADD CONSTRAINT "FK_ec5c201576192ba8904c345c5cc" FOREIGN KEY ("appId") REFERENCES "app"("id") ON DELETE SET NULL ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note" ADD CONSTRAINT "FK_5b87d9d19127bd5d92026017a7b" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_66d2bd2ee31d14bcc23069a89f8, FK_aecfbd5ef60374918e63ee95fa7 on table "poll_vote" | |
| INFO * [db sql] ALTER TABLE "poll_vote" ADD CONSTRAINT "FK_66d2bd2ee31d14bcc23069a89f8" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "poll_vote" ADD CONSTRAINT "FK_aecfbd5ef60374918e63ee95fa7" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_13761f64257f40c5636d0ff95ee, FK_45145e4953780f3cd5656f0ea6a on table "note_reaction" | |
| INFO * [db sql] ALTER TABLE "note_reaction" ADD CONSTRAINT "FK_13761f64257f40c5636d0ff95ee" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note_reaction" ADD CONSTRAINT "FK_45145e4953780f3cd5656f0ea6a" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_b0134ec406e8d09a540f8182888, FK_03e7028ab8388a3f5e3ce2a8619 on table "note_watching" | |
| INFO * [db sql] ALTER TABLE "note_watching" ADD CONSTRAINT "FK_b0134ec406e8d09a540f8182888" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note_watching" ADD CONSTRAINT "FK_03e7028ab8388a3f5e3ce2a8619" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_56b0166d34ddae49d8ef7610bb9, FK_e637cba4dc4410218c4251260e4 on table "note_unread" | |
| INFO * [db sql] ALTER TABLE "note_unread" ADD CONSTRAINT "FK_56b0166d34ddae49d8ef7610bb9" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note_unread" ADD CONSTRAINT "FK_e637cba4dc4410218c4251260e4" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_3c601b70a1066d2c8b517094cb9, FK_3b4e96eec8d36a8bbb9d02aa710, FK_769cb6b73a1efe22ddf733ac453 on table "notification" | |
| INFO * [db sql] ALTER TABLE "notification" ADD CONSTRAINT "FK_3c601b70a1066d2c8b517094cb9" FOREIGN KEY ("notifieeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "notification" ADD CONSTRAINT "FK_3b4e96eec8d36a8bbb9d02aa710" FOREIGN KEY ("notifierId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "notification" ADD CONSTRAINT "FK_769cb6b73a1efe22ddf733ac453" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_24e0042143a18157b234df186c3, FK_6516c5a6f3c015b4eed39978be5 on table "following" | |
| INFO * [db sql] ALTER TABLE "following" ADD CONSTRAINT "FK_24e0042143a18157b234df186c3" FOREIGN KEY ("followeeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "following" ADD CONSTRAINT "FK_6516c5a6f3c015b4eed39978be5" FOREIGN KEY ("followerId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_ec96b4fed9dae517e0dbbe0675c, FK_93060675b4a79a577f31d260c67 on table "muting" | |
| INFO * [db sql] ALTER TABLE "muting" ADD CONSTRAINT "FK_ec96b4fed9dae517e0dbbe0675c" FOREIGN KEY ("muteeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "muting" ADD CONSTRAINT "FK_93060675b4a79a577f31d260c67" FOREIGN KEY ("muterId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_97754ca6f2baff9b4abb7f853dd on table "sw_subscription" | |
| INFO * [db sql] ALTER TABLE "sw_subscription" ADD CONSTRAINT "FK_97754ca6f2baff9b4abb7f853dd" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_2cd4a2743a99671308f5417759e, FK_0627125f1a8a42c9a1929edb552 on table "blocking" | |
| INFO * [db sql] ALTER TABLE "blocking" ADD CONSTRAINT "FK_2cd4a2743a99671308f5417759e" FOREIGN KEY ("blockeeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "blocking" ADD CONSTRAINT "FK_0627125f1a8a42c9a1929edb552" FOREIGN KEY ("blockerId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_b7fcefbdd1c18dce86687531f99 on table "user_list" | |
| INFO * [db sql] ALTER TABLE "user_list" ADD CONSTRAINT "FK_b7fcefbdd1c18dce86687531f99" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_d844bfc6f3f523a05189076efaa, FK_605472305f26818cc93d1baaa74 on table "user_list_joining" | |
| INFO * [db sql] ALTER TABLE "user_list_joining" ADD CONSTRAINT "FK_d844bfc6f3f523a05189076efaa" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "user_list_joining" ADD CONSTRAINT "FK_605472305f26818cc93d1baaa74" FOREIGN KEY ("userListId") REFERENCES "user_list"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_47f4b1892f5d6ba8efb3057d81a, FK_0e00498f180193423c992bc4370 on table "note_favorite" | |
| INFO * [db sql] ALTER TABLE "note_favorite" ADD CONSTRAINT "FK_47f4b1892f5d6ba8efb3057d81a" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "note_favorite" ADD CONSTRAINT "FK_0e00498f180193423c992bc4370" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_d049123c413e68ca52abe734203, FK_04cc96756f89d0b7f9473e8cdf3 on table "abuse_user_report" | |
| INFO * [db sql] ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_d049123c413e68ca52abe734203" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_04cc96756f89d0b7f9473e8cdf3" FOREIGN KEY ("reporterId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_5377c307783fce2b6d352e1203b, FK_cac14a4e3944454a5ce7daa5142, FK_535def119223ac05ad3fa9ef64b on table "messaging_message" | |
| INFO * [db sql] ALTER TABLE "messaging_message" ADD CONSTRAINT "FK_5377c307783fce2b6d352e1203b" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "messaging_message" ADD CONSTRAINT "FK_cac14a4e3944454a5ce7daa5142" FOREIGN KEY ("recipientId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "messaging_message" ADD CONSTRAINT "FK_535def119223ac05ad3fa9ef64b" FOREIGN KEY ("fileId") REFERENCES "drive_file"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_2c308dbdc50d94dc625670055f7 on table "signin" | |
| INFO * [db sql] ALTER TABLE "signin" ADD CONSTRAINT "FK_2c308dbdc50d94dc625670055f7" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_c072b729d71697f959bde66ade0, FK_dbe037d4bddd17b03a1dc778dee on table "auth_session" | |
| INFO * [db sql] ALTER TABLE "auth_session" ADD CONSTRAINT "FK_c072b729d71697f959bde66ade0" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "auth_session" ADD CONSTRAINT "FK_dbe037d4bddd17b03a1dc778dee" FOREIGN KEY ("appId") REFERENCES "app"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_12c01c0d1a79f77d9f6c15fadd2, FK_a7fd92dd6dc519e6fb435dd108f on table "follow_request" | |
| INFO * [db sql] ALTER TABLE "follow_request" ADD CONSTRAINT "FK_12c01c0d1a79f77d9f6c15fadd2" FOREIGN KEY ("followeeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "follow_request" ADD CONSTRAINT "FK_a7fd92dd6dc519e6fb435dd108f" FOREIGN KEY ("followerId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_f7467510c60a45ce5aca6292743, FK_6649a4e8c5d5cf32fb03b5da9f6 on table "reversi_game" | |
| INFO * [db sql] ALTER TABLE "reversi_game" ADD CONSTRAINT "FK_f7467510c60a45ce5aca6292743" FOREIGN KEY ("user1Id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "reversi_game" ADD CONSTRAINT "FK_6649a4e8c5d5cf32fb03b5da9f6" FOREIGN KEY ("user2Id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_3b25402709dd9882048c2bbade0, FK_e247b23a3c9b45f89ec1299d066 on table "reversi_matching" | |
| INFO * [db sql] ALTER TABLE "reversi_matching" ADD CONSTRAINT "FK_3b25402709dd9882048c2bbade0" FOREIGN KEY ("parentId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "reversi_matching" ADD CONSTRAINT "FK_e247b23a3c9b45f89ec1299d066" FOREIGN KEY ("childId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_bfbc6f79ba4007b4ce5097f08d6, FK_68881008f7c3588ad7ecae471cf on table "user_note_pining" | |
| INFO * [db sql] ALTER TABLE "user_note_pining" ADD CONSTRAINT "FK_bfbc6f79ba4007b4ce5097f08d6" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] ALTER TABLE "user_note_pining" ADD CONSTRAINT "FK_68881008f7c3588ad7ecae471cf" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_c165fd56a9fa45ff9bdb8ef6fd0 on table "user_service_linking" | |
| INFO * [db sql] ALTER TABLE "user_service_linking" ADD CONSTRAINT "FK_c165fd56a9fa45ff9bdb8ef6fd0" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_da851e06d0dfe2ef397d8b1bf1b on table "poll" | |
| INFO * [db sql] ALTER TABLE "poll" ADD CONSTRAINT "FK_da851e06d0dfe2ef397d8b1bf1b" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_f4853eb41ab722fe05f81cedeb6 on table "user_keypair" | |
| INFO * [db sql] ALTER TABLE "user_keypair" ADD CONSTRAINT "FK_f4853eb41ab722fe05f81cedeb6" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] creating a foreign keys: FK_10c146e4b39b443ede016f6736d on table "user_publickey" | |
| INFO * [db sql] ALTER TABLE "user_publickey" ADD CONSTRAINT "FK_10c146e4b39b443ede016f6736d" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION | |
| INFO * [db sql] COMMIT | |
| Done :) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =========== | |
| Environment Information | |
| =========== | |
| Base OS: Ubuntu 18.04 (Bionic Beaver) [Vagrant version] | |
| Vagrant Box Information: https://app.vagrantup.com/ubuntu/boxes/bionic64 | |
| Package version: | |
| nodejs: 11.13.0 | |
| npm: 6.7.0 | |
| yarn: 1.15.2 | |
| redis: 4.0.9 | |
| postgresql: 10.6 | |
| Misskey: | |
| branch: pg | |
| commit-hash: f4cffe045f9742a571fdeba1d7a178e093f32088 | |
| Hardware: | |
| CPU: Intel(R) Core(TM) i7-2670QM CPU @ 2.20GHz | |
| Core: 2 (Vagrant's quota only) | |
| Memory: 8192M (Vagrant's quota only) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # API Error: notes/local-timeline | |
| { | |
| "e": { | |
| "code": "42601", | |
| "file": "scan.l", | |
| "line": "1128", | |
| "name": "QueryFailedError", | |
| "query": "SELECT DISTINCT "distinctAlias"."note_id" as "ids_note_id", "distinctAlias"."note_id" FROM (SELECT "note"."id" AS "note_id", "note"."createdAt" AS "note_createdAt", "note"."updatedAt" AS "note_updatedAt", "note"."replyId" AS "note_replyId", "note"."renoteId" AS "note_renoteId", "note"."text" AS "note_text", "note"."name" AS "note_name", "note"."cw" AS "note_cw", "note"."appId" AS "note_appId", "note"."userId" AS "note_userId", "note"."viaMobile" AS "note_viaMobile", "note"."localOnly" AS "note_localOnly", "note"."renoteCount" AS "note_renoteCount", "note"."repliesCount" AS "note_repliesCount", "note"."reactions" AS "note_reactions", "note"."visibility" AS "note_visibility", "note"."uri" AS "note_uri", "note"."score" AS "note_score", "note"."fileIds" AS "note_fileIds", "note"."attachedFileTypes" AS "note_attachedFileTypes", "note"."visibleUserIds" AS "note_visibleUserIds", "note"."mentions" AS "note_mentions", "note"."mentionedRemoteUsers" AS "note_mentionedRemoteUsers", "note"."emojis" AS "note_emojis", "note"."tags" AS "note_tags", "note"."hasPoll" AS "note_hasPoll", "note"."geo" AS "note_geo", "note"."userHost" AS "note_userHost", "note"."userInbox" AS "note_userInbox", "note"."replyUserId" AS "note_replyUserId", "note"."replyUserHost" AS "note_replyUserHost", "note"."renoteUserId" AS "note_renoteUserId", "note"."renoteUserHost" AS "note_renoteUserHost", "user"."id" AS "user_id", "user"."createdAt" AS "user_createdAt", "user"."updatedAt" AS "user_updatedAt", "user"."lastFetchedAt" AS "user_lastFetchedAt", "user"."username" AS "user_username", "user"."name" AS "user_name", "user"."location" AS "user_location", "user"."birthday" AS "user_birthday", "user"."followersCount" AS "user_followersCount", "user"."followingCount" AS "user_followingCount", "user"."notesCount" AS "user_notesCount", "user"."avatarId" AS "user_avatarId", "user"."bannerId" AS "user_bannerId", "user"."description" AS "user_description", "user"."tags" AS "user_tags", "user"."email" AS "user_email", "user"."emailVerifyCode" AS "user_emailVerifyCode", "user"."emailVerified" AS "user_emailVerified", "user"."twoFactorTempSecret" AS "user_twoFactorTempSecret", "user"."twoFactorSecret" AS "user_twoFactorSecret", "user"."avatarUrl" AS "user_avatarUrl", "user"."bannerUrl" AS "user_bannerUrl", "user"."avatarColor" AS "user_avatarColor", "user"."bannerColor" AS "user_bannerColor", "user"."isSuspended" AS "user_isSuspended", "user"."isSilenced" AS "user_isSilenced", "user"."isLocked" AS "user_isLocked", "user"."isBot" AS "user_isBot", "user"."isCat" AS "user_isCat", "user"."isAdmin" AS "user_isAdmin", "user"."isModerator" AS "user_isModerator", "user"."isVerified" AS "user_isVerified", "user"."twoFactorEnabled" AS "user_twoFactorEnabled", "user"."emojis" AS "user_emojis", "user"."host" AS "user_host", "user"."inbox" AS "user_inbox", "user"."sharedInbox" AS "user_sharedInbox", "user"."featured" AS "user_featured", "user"."uri" AS "user_uri", "user"."password" AS "user_password", "user"."token" AS "user_token", "user"."clientData" AS "user_clientData", "user"."autoWatch" AS "user_autoWatch", "user"."autoAcceptFollowed" AS "user_autoAcceptFollowed", "user"."alwaysMarkNsfw" AS "user_alwaysMarkNsfw", "user"."carefulBot" AS "user_carefulBot" FROM "note" "note" LEFT JOIN "user" "user" ON "user"."id"="note"."userId" WHERE ("note"."visibility" = 'public') AND ("note"."userHost" IS NULL) AND "note"."fileIds" != '{}' AND "note"."attachedFileTypes" ANY($1)) "distinctAlias" ORDER BY "distinctAlias"."note_id" DESC, "note_id" ASC LIMIT 6", | |
| "length": 94, | |
| "message": "syntax error at or near "ANY"", | |
| "routine": "scanner_yyerror", | |
| "position": "3458", | |
| "severity": "ERROR", | |
| "parameters": [ | |
| [ | |
| "image/jpeg", | |
| "image/png", | |
| "image/gif" | |
| ] | |
| ] | |
| }, | |
| "ep": "notes/local-timeline", | |
| "ps": { | |
| "limit": 6, | |
| "fileType": [ | |
| "image/jpeg", | |
| "image/png", | |
| "image/gif" | |
| ], | |
| "excludeNsfw": true | |
| } | |
| } | |
| # API Error: hashtags/list | |
| { | |
| "e": { | |
| "code": "42P01", | |
| "file": "parse_relation.c", | |
| "line": "3239", | |
| "name": "QueryFailedError", | |
| "query": "SELECT tags.name, tags.mentionedUsersCount, tags.mentionedLocalUsersCount, tags.mentionedRemoteUsersCount, tags.attachedUsersCount, tags.attachedLocalUsersCount, tags.attachedRemoteUsersCount FROM "hashtag" "tag" WHERE tags.attachedLocalUsersCount != 0 ORDER BY tags.attachedLocalUsersCount DESC LIMIT 30", | |
| "length": 114, | |
| "message": "missing FROM-clause entry for table "tags"", | |
| "routine": "errorMissingRTE", | |
| "position": "8", | |
| "severity": "ERROR", | |
| "parameters": [ | |
| ] | |
| }, | |
| "ep": "hashtags/list", | |
| "ps": { | |
| "i": "!zheefI4P8xb6QGeq7957g1WArGZcksH", | |
| "sort": "+attachedLocalUsers", | |
| "limit": 30, | |
| "attachedToLocalUserOnly": true | |
| } | |
| } | |
| # API Error: hashtags/search | |
| { | |
| "e": { | |
| "code": "42803", | |
| "file": "parse_agg.c", | |
| "line": "1369", | |
| "name": "QueryFailedError", | |
| "query": "SELECT "tag"."id" AS "tag_id", "tag"."name" AS "tag_name", "tag"."mentionedUserIds" AS "tag_mentionedUserIds", "tag"."mentionedUsersCount" AS "tag_mentionedUsersCount", "tag"."mentionedLocalUserIds" AS "tag_mentionedLocalUserIds", "tag"."mentionedLocalUsersCount" AS "tag_mentionedLocalUsersCount", "tag"."mentionedRemoteUserIds" AS "tag_mentionedRemoteUserIds", "tag"."mentionedRemoteUsersCount" AS "tag_mentionedRemoteUsersCount", "tag"."attachedUserIds" AS "tag_attachedUserIds", "tag"."attachedUsersCount" AS "tag_attachedUsersCount", "tag"."attachedLocalUserIds" AS "tag_attachedLocalUserIds", "tag"."attachedLocalUsersCount" AS "tag_attachedLocalUsersCount", "tag"."attachedRemoteUserIds" AS "tag_attachedRemoteUserIds", "tag"."attachedRemoteUsersCount" AS "tag_attachedRemoteUsersCount" FROM "hashtag" "tag" WHERE "tag"."name" like $1 ORDER BY tag.count DESC LIMIT 30", | |
| "length": 168, | |
| "message": "column "tag.id" must appear in the GROUP BY clause or be used in an aggregate function", | |
| "routine": "check_ungrouped_columns_walker", | |
| "position": "8", | |
| "severity": "ERROR", | |
| "parameters": [ | |
| "わーーーーーーーーーーーーー%" | |
| ] | |
| }, | |
| "ep": "hashtags/search", | |
| "ps": { | |
| "i": "!thFC8RbzlgmtMnDHPZfIx6a1C2spB7F", | |
| "limit": 30, | |
| "query": "わーーーーーーーーーーーーー" | |
| } | |
| } | |
| # title | |
| null <= It appear when no setting instance name | |
| # Cannot shown when select instance | |
| 設定適用後、別の管理ページに行き、再びインスタンスに戻ると設定情報が読み込まれていない。 | |
| ページ再読込みをすると問題はない。 | |
| # It looks not surrender | |
| 投了ボタンを押したが、対戦ウィンドウが投了扱いにならない。戦績では投了扱いになる。 | |
| # Not appear broadcast | |
| お知らせが適用されない。エラーは特に発生していない。 | |
| 書いたお知らせも消えてしまう。 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > [email protected] build /vagrant/misskey | |
| > webpack && gulp build | |
| yes we can [====================] 100% (100/100) 230.6s | |
| Build completed in 230.617s | |
| Hash: d4940669e51b9235992b | |
| Version: webpack 4.28.4 | |
| Time: 230634ms | |
| Built at: 04/06/2019 2:11:37 PM | |
| Asset Size Chunks Chunk Names | |
| 0.11.0.0.js 414 KiB 0 [emitted] [big] | |
| 1.11.0.0.js 33.2 KiB 1 [emitted] | |
| 10.11.0.0.js 91.6 KiB 10 [emitted] | |
| 11.11.0.0.js 4.49 KiB 11 [emitted] | |
| 12.11.0.0.js 9.73 KiB 12 [emitted] | |
| 13.11.0.0.js 5.02 KiB 13, 18 [emitted] | |
| 14.11.0.0.js 42.9 KiB 14 [emitted] | |
| 15.11.0.0.js 1.86 KiB 15 [emitted] | |
| 16.11.0.0.js 1.69 KiB 16 [emitted] | |
| 17.11.0.0.js 4.19 KiB 17 [emitted] | |
| 18.11.0.0.js 4.46 KiB 18 [emitted] | |
| 19.11.0.0.js 3.51 KiB 19 [emitted] | |
| 2.11.0.0.js 28.3 KiB 2 [emitted] | |
| 20.11.0.0.js 194 KiB 20 [emitted] | |
| 21.11.0.0.js 1.1 KiB 21 [emitted] | |
| 22.11.0.0.js 878 bytes 22 [emitted] | |
| 23.11.0.0.js 873 bytes 23 [emitted] | |
| 24.11.0.0.js 866 bytes 24 [emitted] | |
| 3.11.0.0.js 4.99 KiB 3, 18 [emitted] | |
| 32.11.0.0.js 2.03 MiB 32 [emitted] [big] | |
| 33.11.0.0.js 21 KiB 33 [emitted] | |
| 34.11.0.0.js 15.6 KiB 34 [emitted] | |
| 35.11.0.0.js 7.98 KiB 35, 21 [emitted] | |
| 36.11.0.0.js 15.9 KiB 36 [emitted] | |
| 37.11.0.0.js 8.15 KiB 37 [emitted] | |
| 38.11.0.0.js 1.79 KiB 38, 41 [emitted] | |
| 39.11.0.0.js 3.93 KiB 39 [emitted] | |
| 4.11.0.0.js 687 bytes 4 [emitted] | |
| 40.11.0.0.js 3.08 KiB 40 [emitted] | |
| 41.11.0.0.js 1.67 KiB 41 [emitted] | |
| 42.11.0.0.js 1.62 KiB 42 [emitted] | |
| 43.11.0.0.js 1.21 KiB 43 [emitted] | |
| 44.11.0.0.js 1.37 KiB 44 [emitted] | |
| 45.11.0.0.js 1.78 KiB 45 [emitted] | |
| 46.11.0.0.js 1.77 KiB 46 [emitted] | |
| 47.11.0.0.js 1.37 KiB 47 [emitted] | |
| 48.11.0.0.js 2.27 KiB 48 [emitted] | |
| 49.11.0.0.js 854 bytes 49 [emitted] | |
| 5.11.0.0.js 687 bytes 5 [emitted] | |
| 6.11.0.0.js 68.2 KiB 6 [emitted] | |
| 7.11.0.0.js 48.4 KiB 7 [emitted] | |
| 8.11.0.0.js 24 KiB 8 [emitted] | |
| 9.11.0.0.js 9.85 KiB 9 [emitted] | |
| admin.11.0.0.js 1.58 MiB 25, 0 [emitted] [big] admin | |
| auth.11.0.0.js 1.03 MiB 26 [emitted] [big] auth | |
| desktop.11.0.0.js 1.33 MiB 27 [emitted] [big] desktop | |
| dev.11.0.0.js 1.44 MiB 28 [emitted] [big] dev | |
| mobile.11.0.0.js 1.24 MiB 29 [emitted] [big] mobile | |
| sw.11.0.0.js 4.25 KiB 30 [emitted] sw | |
| test.11.0.0.js 1.03 MiB 31 [emitted] [big] test | |
| Entrypoint desktop [big] = desktop.11.0.0.js | |
| Entrypoint mobile [big] = mobile.11.0.0.js | |
| Entrypoint dev [big] = dev.11.0.0.js | |
| Entrypoint auth [big] = auth.11.0.0.js | |
| Entrypoint admin [big] = admin.11.0.0.js | |
| Entrypoint test [big] = test.11.0.0.js | |
| Entrypoint sw = sw.11.0.0.js | |
| [8] ./src/client/app/config.ts 600 bytes {25} {26} {27} {28} {29} {31} [built] | |
| [12] ./src/prelude/array.ts 2.58 KiB {25} {26} {27} {28} {29} {30} {31} [built] | |
| [262] ./src/client/app/init.ts + 37 modules 612 KiB {25} {26} {27} {28} {29} {31} [built] | |
| | ./src/client/app/init.ts 10.6 KiB [built] | |
| | ./src/client/app/common/hotkey.ts 3.07 KiB [built] | |
| | ./src/client/app/common/size.ts 537 bytes [built] | |
| | ./src/client/app/app.vue 449 bytes [built] | |
| | ./src/client/app/mios.ts 14.9 KiB [built] | |
| | ./src/client/app/common/keycode.ts 756 bytes [built] | |
| | ./src/client/app/app.vue?vue&type=template&id=1e8ddc01& 269 bytes [built] | |
| | ./src/client/app/app.vue?vue&type=script&lang=ts& 486 bytes [built] | |
| | ./src/client/app/store.ts 12.2 KiB [built] | |
| | ./src/client/app/common/scripts/stream.ts 8.4 KiB [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/app.vue?vue&type=template&id=1e8ddc01& 316 bytes [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/app.vue?vue&type=script&lang=ts& 556 bytes [built] | |
| | + 26 hidden modules | |
| [263] ./src/client/app/common/views/pages/not-found.vue + 4 modules 2.25 KiB {25} {26} {27} {28} {29} {31} [built] | |
| | ./src/client/app/common/views/pages/not-found.vue 591 bytes [built] | |
| | ./src/client/app/common/views/pages/not-found.vue?vue&type=template&id=7a17a502&scoped=true& 314 bytes [built] | |
| | ./src/client/app/common/views/pages/not-found.vue?vue&type=script&lang=ts& 552 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/pages/not-found.vue?vue&type=template&id=7a17a502&scoped=true& 460 bytes [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/pages/not-found.vue?vue&type=script&lang=ts& 370 bytes [built] | |
| [451] ./src/client/app/desktop/views/components/ui-notification.vue + 4 modules 2.42 KiB {27} [built] | |
| | 5 modules | |
| [469] ./src/client/app/common/scripts/compose-notification.ts + 1 modules 2.57 KiB {27} {30} [built] | |
| | ./src/client/app/common/scripts/compose-notification.ts 2.08 KiB [built] | |
| | ./src/misc/get-reaction-emoji.ts 491 bytes [built] | |
| [482] ./src/client/app/common/views/deck/deck.vue + 64 modules 64.2 KiB {27} {29} [built] | |
| | ./src/client/app/common/views/deck/deck.vue 747 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.vue?vue&type=template&id=76e540a0&scoped=true& 309 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.vue?vue&type=script&lang=ts& 542 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/deck/deck.vue?vue&type=template&id=76e540a0&scoped=true& 1.18 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/deck/deck.vue?vue&type=script&lang=ts& 11 KiB [built] | |
| | ./src/client/app/common/views/deck/deck.column-core.vue 497 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.column-core.vue?vue&type=template&id=64d65e18& 309 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.column-core.vue?vue&type=script&lang=ts& 566 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/deck/deck.column-core.vue?vue&type=template&id=64d65e18& 1.44 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/deck/deck.column-core.vue?vue&type=script&lang=ts& 786 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.tl-column.vue 491 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.notifications-column.vue 524 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.widgets-column.vue 631 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.mentions-column.vue 509 bytes [built] | |
| | ./src/client/app/common/views/deck/deck.direct-column.vue 503 bytes [built] | |
| | + 50 hidden modules | |
| [483] ./src/client/app/common/views/pages/share.vue + 4 modules 3.15 KiB {27} {29} [built] | |
| | ./src/client/app/common/views/pages/share.vue 575 bytes [built] | |
| | ./src/client/app/common/views/pages/share.vue?vue&type=template&id=45f4f020&scoped=true& 310 bytes [built] | |
| | ./src/client/app/common/views/pages/share.vue?vue&type=script&lang=ts& 544 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/pages/share.vue?vue&type=template&id=45f4f020&scoped=true& 706 bytes [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/common/views/pages/share.vue?vue&type=script&lang=ts& 1.05 KiB [built] | |
| [1034] ./src/client/app/sw.js 1.38 KiB {30} [built] | |
| [1036] ./src/client/app/mobile/script.ts + 105 modules 90.5 KiB {29} [built] | |
| | ./src/client/app/mobile/script.ts 7.83 KiB [built] | |
| | ./src/client/app/mobile/views/pages/index.vue 464 bytes [built] | |
| | ./src/client/app/mobile/views/pages/signup.vue 579 bytes [built] | |
| | ./src/client/app/mobile/views/pages/selectdrive.vue 599 bytes [built] | |
| | ./src/client/app/mobile/views/pages/drive.vue 464 bytes [built] | |
| | ./src/client/app/mobile/views/pages/widgets.vue 583 bytes [built] | |
| | ./src/client/app/mobile/views/pages/messaging.vue 476 bytes [built] | |
| | ./src/client/app/mobile/views/pages/messaging-room.vue 491 bytes [built] | |
| | ./src/client/app/mobile/views/pages/received-follow-requests.vue 651 bytes [built] | |
| | ./src/client/app/mobile/views/pages/note.vue 571 bytes [built] | |
| | ./src/client/app/mobile/views/pages/search.vue 467 bytes [built] | |
| | ./src/client/app/mobile/views/pages/favorites.vue 591 bytes [built] | |
| | ./src/client/app/mobile/views/pages/user-lists.vue 479 bytes [built] | |
| | ./src/client/app/mobile/views/pages/user-list.vue 476 bytes [built] | |
| | ./src/client/app/mobile/views/pages/games/reversi.vue 473 bytes [built] | |
| | + 91 hidden modules | |
| [1038] ./src/client/app/admin/script.ts + 90 modules 161 KiB {25} [built] | |
| | ./src/client/app/admin/script.ts 537 bytes [built] | |
| | ./src/client/app/admin/views/index.vue 572 bytes [built] | |
| | ./src/client/app/admin/views/index.vue?vue&type=template&id=a62e74da&scoped=true& 301 bytes [built] | |
| | ./src/client/app/admin/views/index.vue?vue&type=script&lang=ts& 526 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/admin/views/index.vue?vue&type=template&id=a62e74da&scoped=true& 6.21 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/admin/views/index.vue?vue&type=script&lang=ts& 1.59 KiB [built] | |
| | ./src/client/app/admin/views/dashboard.vue 588 bytes [built] | |
| | ./src/client/app/admin/views/instance.vue 470 bytes [built] | |
| | ./src/client/app/admin/views/queue.vue 572 bytes [built] | |
| | ./src/client/app/admin/views/logs.vue 568 bytes [built] | |
| | ./src/client/app/admin/views/moderators.vue 476 bytes [built] | |
| | ./src/client/app/admin/views/emoji.vue 572 bytes [built] | |
| | ./src/client/app/admin/views/announcements.vue 485 bytes [built] | |
| | ./src/client/app/admin/views/hashtags.vue 470 bytes [built] | |
| | ./src/client/app/admin/views/users.vue 572 bytes [built] | |
| | + 76 hidden modules | |
| [1039] ./src/client/app/desktop/script.ts + 66 modules 75.2 KiB {27} [built] | |
| | ./src/client/app/desktop/script.ts 10.6 KiB [built] | |
| | ./src/client/app/common/scripts/fuck-ad-block.ts 368 bytes [built] | |
| | ./src/client/app/desktop/views/home/home.vue 571 bytes [built] | |
| | ./src/client/app/desktop/views/pages/selectdrive.vue 599 bytes [built] | |
| | ./src/client/app/desktop/views/pages/drive.vue 575 bytes [built] | |
| | ./src/client/app/desktop/views/pages/messaging-room.vue 611 bytes [built] | |
| | ./src/client/app/desktop/views/pages/games/reversi.vue 473 bytes [built] | |
| | ./src/client/app/desktop/views/pages/settings.vue 587 bytes [built] | |
| | ./src/client/app/desktop/views/home/timeline.vue 587 bytes [built] | |
| | ./src/client/app/desktop/views/home/home.vue?vue&type=template&id=5189f3c9&scoped=true& 309 bytes [built] | |
| | ./src/client/app/desktop/views/home/home.vue?vue&type=script&lang=ts& 542 bytes [built] | |
| | ./src/client/app/desktop/views/pages/selectdrive.vue?vue&type=template&id=a5a9083e&scoped=true& 316 bytes [built] | |
| | ./src/client/app/desktop/views/pages/selectdrive.vue?vue&type=script&lang=ts& 556 bytes [built] | |
| | ./src/client/app/desktop/views/pages/drive.vue?vue&type=template&id=38da1284&scoped=true& 310 bytes [built] | |
| | ./src/client/app/desktop/views/pages/drive.vue?vue&type=script&lang=ts& 544 bytes [built] | |
| | + 52 hidden modules | |
| [1041] ./src/client/app/dev/script.ts + 23 modules 13.6 KiB {28} [built] | |
| | ./src/client/app/dev/script.ts 1.01 KiB [built] | |
| | ./src/client/app/dev/views/index.vue 461 bytes [built] | |
| | ./src/client/app/dev/views/apps.vue 458 bytes [built] | |
| | ./src/client/app/dev/views/new-app.vue 467 bytes [built] | |
| | ./src/client/app/dev/views/app.vue 455 bytes [built] | |
| | ./src/client/app/dev/views/ui.vue 471 bytes [built] | |
| | ./src/client/app/dev/views/index.vue?vue&type=template&id=df4382ae& 289 bytes [built] | |
| | ./src/client/app/dev/views/index.vue?vue&type=script&lang=ts& 526 bytes [built] | |
| | ./src/client/app/dev/views/apps.vue?vue&type=template&id=4cd49b3d& 288 bytes [built] | |
| | ./src/client/app/dev/views/apps.vue?vue&type=script&lang=ts& 524 bytes [built] | |
| | ./src/client/app/dev/views/new-app.vue?vue&type=template&id=5a9875e8& 291 bytes [built] | |
| | ./src/client/app/dev/views/new-app.vue?vue&type=script&lang=ts& 530 bytes [built] | |
| | ./src/client/app/dev/views/app.vue?vue&type=template&id=7d9742f1& 287 bytes [built] | |
| | ./src/client/app/dev/views/app.vue?vue&type=script&lang=ts& 522 bytes [built] | |
| | ./src/client/app/dev/views/ui.vue?vue&type=template&id=f66716ca&scoped=true& 298 bytes [built] | |
| | + 9 hidden modules | |
| [1042] ./src/client/app/auth/script.ts + 10 modules 8.39 KiB {26} [built] | |
| | ./src/client/app/auth/script.ts 537 bytes [built] | |
| | ./src/client/app/auth/views/index.vue 572 bytes [built] | |
| | ./src/client/app/auth/views/index.vue?vue&type=template&id=27b49be2&scoped=true& 301 bytes [built] | |
| | ./src/client/app/auth/views/index.vue?vue&type=script&lang=ts& 526 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/auth/views/index.vue?vue&type=template&id=27b49be2&scoped=true& 1.49 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/auth/views/index.vue?vue&type=script&lang=ts& 1.39 KiB [built] | |
| | ./src/client/app/auth/views/form.vue 568 bytes [built] | |
| | ./src/client/app/auth/views/form.vue?vue&type=template&id=6241d27c&scoped=true& 300 bytes [built] | |
| | ./src/client/app/auth/views/form.vue?vue&type=script&lang=ts& 524 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/auth/views/form.vue?vue&type=template&id=6241d27c&scoped=true& 1.58 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/auth/views/form.vue?vue&type=script&lang=ts& 651 bytes [built] | |
| [1045] ./src/client/app/test/script.ts + 5 modules 4.51 KiB {31} [built] | |
| | ./src/client/app/test/script.ts 521 bytes [built] | |
| | ./src/client/app/test/views/index.vue 572 bytes [built] | |
| | ./src/client/app/test/views/index.vue?vue&type=template&id=9372f4bc&scoped=true& 301 bytes [built] | |
| | ./src/client/app/test/views/index.vue?vue&type=script&lang=ts& 526 bytes [built] | |
| | ./node_modules/vue-loader/lib/loaders/templateLoader.js??vue-loader-options!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/test/views/index.vue?vue&type=template&id=9372f4bc&scoped=true& 1.87 KiB [built] | |
| | ./node_modules/ts-loader??ref--5-0!./node_modules/vue-loader/lib??vue-loader-options!./node_modules/vue-svg-inline-loader/dist/index.min.js!./src/client/app/test/views/index.vue?vue&type=script&lang=ts& 746 bytes [built] | |
| + 1312 hidden modules | |
| WARNING in asset size limit: The following asset(s) exceed the recommended size limit (244 KiB). | |
| This can impact web performance. | |
| Assets: | |
| 0.11.0.0.js (414 KiB) | |
| admin.11.0.0.js (1.58 MiB) | |
| auth.11.0.0.js (1.03 MiB) | |
| desktop.11.0.0.js (1.33 MiB) | |
| dev.11.0.0.js (1.44 MiB) | |
| mobile.11.0.0.js (1.24 MiB) | |
| test.11.0.0.js (1.03 MiB) | |
| 32.11.0.0.js (2.03 MiB) | |
| WARNING in entrypoint size limit: The following entrypoint(s) combined asset size exceeds the recommended limit (244 KiB). This can impact web performance. | |
| Entrypoints: | |
| desktop (1.33 MiB) | |
| desktop.11.0.0.js | |
| mobile (1.24 MiB) | |
| mobile.11.0.0.js | |
| dev (1.44 MiB) | |
| dev.11.0.0.js | |
| auth (1.03 MiB) | |
| auth.11.0.0.js | |
| admin (1.58 MiB) | |
| admin.11.0.0.js | |
| test (1.03 MiB) | |
| test.11.0.0.js | |
| [14:11:43] Requiring external module ts-node/register | |
| [14:12:09] Using gulpfile /vagrant/misskey/gulpfile.ts | |
| [14:12:09] Starting 'build'... | |
| [14:12:09] Starting 'build:ts'... | |
| [14:12:09] Starting 'build:copy'... | |
| [14:12:09] Starting 'build:client'... | |
| [14:12:09] Starting 'doc'... | |
| [14:12:10] Starting 'build:copy:views'... | |
| [14:12:10] Starting '<anonymous>'... | |
| [14:12:10] Starting 'build:client:script'... | |
| [14:12:10] Starting 'build:client:styles'... | |
| [14:12:10] Starting 'copy:client'... | |
| [14:12:13] Finished 'build:client:styles' after 2.45 s | |
| [14:12:13] Finished 'doc' after 4.27 s | |
| [14:12:13] Finished 'build:client:script' after 2.52 s | |
| [14:12:13] Finished 'build:copy:views' after 2.54 s | |
| [14:12:17] Finished '<anonymous>' after 7.07 s | |
| [14:12:17] Finished 'build:copy' after 8.82 s | |
| src/server/api/endpoints/notes/local-timeline.ts(108,4): error TS7017: Element implicitly has an 'any' type because type 'SelectQueryBuilder<Note>' has no index signature. | |
| [14:12:56] gulp-imagemin: Minified 33 images (saved 85.7 kB - 4.2%) | |
| TypeScript: 1 semantic error | |
| TypeScript: emit succeeded (with errors) | |
| [14:12:57] Finished 'copy:client' after 46 s | |
| [14:12:57] Finished 'build:client' after 48 s | |
| [14:13:00] Finished 'build:ts' after 51 s | |
| [14:13:00] Finished 'build' after 51 s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment