Changeset View
Changeset View
Standalone View
Standalone View
keyserver/src/database/setup-db.js
| Show First 20 Lines • Show All 148 Lines • ▼ Show 20 Lines | SQL` | ||||
| containing_thread_id bigint(20) DEFAULT NULL, | containing_thread_id bigint(20) DEFAULT NULL, | ||||
| community bigint(20) DEFAULT NULL, | community bigint(20) DEFAULT NULL, | ||||
| depth int UNSIGNED NOT NULL DEFAULT 0, | depth int UNSIGNED NOT NULL DEFAULT 0, | ||||
| default_role bigint(20) NOT NULL, | default_role bigint(20) NOT NULL, | ||||
| creator bigint(20) NOT NULL, | creator bigint(20) NOT NULL, | ||||
| creation_time bigint(20) NOT NULL, | creation_time bigint(20) NOT NULL, | ||||
| color char(6) COLLATE utf8mb4_bin NOT NULL, | color char(6) COLLATE utf8mb4_bin NOT NULL, | ||||
| source_message bigint(20) DEFAULT NULL UNIQUE, | source_message bigint(20) DEFAULT NULL UNIQUE, | ||||
| replies_count int UNSIGNED NOT NULL DEFAULT 0 | replies_count int UNSIGNED NOT NULL DEFAULT 0, | ||||
| avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL | |||||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | ||||
| CREATE TABLE updates ( | CREATE TABLE updates ( | ||||
| id bigint(20) NOT NULL, | id bigint(20) NOT NULL, | ||||
| user bigint(20) NOT NULL, | user bigint(20) NOT NULL, | ||||
| type tinyint(3) UNSIGNED NOT NULL, | type tinyint(3) UNSIGNED NOT NULL, | ||||
| \`key\` bigint(20) DEFAULT NULL, | \`key\` bigint(20) DEFAULT NULL, | ||||
| updater bigint(20) DEFAULT NULL, | updater bigint(20) DEFAULT NULL, | ||||
| ▲ Show 20 Lines • Show All 265 Lines • Show Last 20 Lines | |||||