egvQsFgt

12018/02/17 00:39:30 [I] PING DATABASE mysql
22018/02/17 00:39:30 [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? []interface {}{"gitea", "version"}
32018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `version` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `version` BIGINT(20) NULL) DEFAULT CHARSET utf8mb4
42018/02/17 00:39:30 [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [gitea version id]
52018/02/17 00:39:30 [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [gitea version version]
62018/02/17 00:39:30 [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 []interface {}{1}
72018/02/17 00:39:30 [I] [SQL] INSERT INTO `version` (`version`) VALUES (?) []interface {}{58}
82018/02/17 00:39:30 [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `TABLE_ROWS`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [gitea]
92018/02/17 00:39:30 [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [gitea version]
102018/02/17 00:39:30 [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [gitea version]
112018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `user` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `lower_name` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `full_name` VARCHAR(255) NULL, `email` VARCHAR(255) NOT NULL, `keep_email_private` TINYINT(1) NULL, `passwd` VARCHAR(255) NOT NULL, `login_type` INT NULL, `login_source` BIGINT(20) DEFAULT 0 NOT NULL, `login_name` VARCHAR(255) NULL, `type` INT NULL, `location` VARCHAR(255) NULL, `website` VARCHAR(255) NULL, `rands` VARCHAR(10) NULL, `salt` VARCHAR(10) NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL, `last_login_unix` BIGINT(20) NULL, `last_repo_visibility` TINYINT(1) NULL, `max_repo_creation` INT DEFAULT -1 NOT NULL, `is_active` TINYINT(1) NULL, `is_admin` TINYINT(1) NULL, `allow_git_hook` TINYINT(1) NULL, `allow_import_local` TINYINT(1) NULL, `allow_create_organization` TINYINT(1) DEFAULT true NULL, `prohibit_login` TINYINT(1) DEFAULT false NOT NULL, `avatar` VARCHAR(2048) NOT NULL, `avatar_email` VARCHAR(255) NOT NULL, `use_custom_avatar` TINYINT(1) NULL, `num_followers` INT NULL, `num_following` INT DEFAULT 0 NOT NULL, `num_stars` INT NULL, `num_repos` INT NULL, `description` VARCHAR(255) NULL, `num_teams` INT NULL, `num_members` INT NULL, `diff_view_style` VARCHAR(255) DEFAULT '' NOT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
122018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_user_lower_name` ON `user` (`lower_name`)
132018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_user_name` ON `user` (`name`)
142018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_user_created_unix` ON `user` (`created_unix`);
152018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_user_updated_unix` ON `user` (`updated_unix`);
162018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_user_last_login_unix` ON `user` (`last_login_unix`);
172018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_user_is_active` ON `user` (`is_active`);
182018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `public_key` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `owner_id` BIGINT(20) NOT NULL, `name` VARCHAR(255) NOT NULL, `fingerprint` VARCHAR(255) NOT NULL, `content` TEXT NOT NULL, `mode` INT DEFAULT 2 NOT NULL, `type` INT DEFAULT 1 NOT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
192018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_public_key_owner_id` ON `public_key` (`owner_id`);
202018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `access_token` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `sha1` VARCHAR(40) NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
212018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_access_token_sha1` ON `access_token` (`sha1`)
222018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_access_token_created_unix` ON `access_token` (`created_unix`);
232018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_access_token_updated_unix` ON `access_token` (`updated_unix`);
242018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_access_token_uid` ON `access_token` (`uid`);
252018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `repository` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `owner_id` BIGINT(20) NULL, `lower_name` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `description` VARCHAR(255) NULL, `website` VARCHAR(255) NULL, `default_branch` VARCHAR(255) NULL, `num_watches` INT NULL, `num_stars` INT NULL, `num_forks` INT NULL, `num_issues` INT NULL, `num_closed_issues` INT NULL, `num_pulls` INT NULL, `num_closed_pulls` INT NULL, `num_milestones` INT DEFAULT 0 NOT NULL, `num_closed_milestones` INT DEFAULT 0 NOT NULL, `is_private` TINYINT(1) NULL, `is_bare` TINYINT(1) NULL, `is_mirror` TINYINT(1) NULL, `is_fork` TINYINT(1) DEFAULT false NOT NULL, `fork_id` BIGINT(20) NULL, `size` BIGINT(20) DEFAULT 0 NOT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
262018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_repository_s` ON `repository` (`owner_id`,`lower_name`)
272018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_name` ON `repository` (`name`);
282018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_is_private` ON `repository` (`is_private`);
292018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_is_bare` ON `repository` (`is_bare`);
302018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_is_mirror` ON `repository` (`is_mirror`);
312018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_is_fork` ON `repository` (`is_fork`);
322018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_fork_id` ON `repository` (`fork_id`);
332018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_lower_name` ON `repository` (`lower_name`);
342018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_created_unix` ON `repository` (`created_unix`);
352018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_repository_updated_unix` ON `repository` (`updated_unix`);
362018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `deploy_key` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `key_id` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `fingerprint` VARCHAR(255) NULL, `mode` INT DEFAULT 1 NOT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
372018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_deploy_key_s` ON `deploy_key` (`key_id`,`repo_id`)
382018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_deploy_key_key_id` ON `deploy_key` (`key_id`);
392018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_deploy_key_repo_id` ON `deploy_key` (`repo_id`);
402018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `collaboration` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NOT NULL, `user_id` BIGINT(20) NOT NULL, `mode` INT DEFAULT 2 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
412018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_collaboration_s` ON `collaboration` (`repo_id`,`user_id`)
422018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_collaboration_repo_id` ON `collaboration` (`repo_id`);
432018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_collaboration_user_id` ON `collaboration` (`user_id`);
442018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `access` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL, `mode` INT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
452018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_access_s` ON `access` (`user_id`,`repo_id`)
462018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `upload` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uuid` VARCHAR(40) NULL, `name` VARCHAR(255) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
472018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_upload_uuid` ON `upload` (`uuid`)
482018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `watch` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
492018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_watch_watch` ON `watch` (`user_id`,`repo_id`)
502018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `star` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
512018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_star_s` ON `star` (`uid`,`repo_id`)
522018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `follow` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NULL, `follow_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
532018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_follow_follow` ON `follow` (`user_id`,`follow_id`)
542018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `action` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NULL, `op_type` INT NULL, `act_user_id` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL, `comment_id` BIGINT(20) NULL, `is_deleted` TINYINT(1) DEFAULT false NOT NULL, `ref_name` VARCHAR(255) NULL, `is_private` TINYINT(1) DEFAULT false NOT NULL, `content` TEXT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
552018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_user_id` ON `action` (`user_id`);
562018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_act_user_id` ON `action` (`act_user_id`);
572018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_repo_id` ON `action` (`repo_id`);
582018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_comment_id` ON `action` (`comment_id`);
592018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_is_deleted` ON `action` (`is_deleted`);
602018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_is_private` ON `action` (`is_private`);
612018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_action_created_unix` ON `action` (`created_unix`);
622018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `issue` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `index` BIGINT(20) NULL, `poster_id` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `content` TEXT NULL, `milestone_id` BIGINT(20) NULL, `priority` INT NULL, `assignee_id` BIGINT(20) NULL, `is_closed` TINYINT(1) NULL, `is_pull` TINYINT(1) NULL, `num_comments` INT NULL, `ref` VARCHAR(255) NULL, `deadline_unix` BIGINT(20) NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
632018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_issue_repo_index` ON `issue` (`repo_id`,`index`)
642018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_is_closed` ON `issue` (`is_closed`);
652018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_deadline_unix` ON `issue` (`deadline_unix`);
662018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_updated_unix` ON `issue` (`updated_unix`);
672018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_repo_id` ON `issue` (`repo_id`);
682018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_assignee_id` ON `issue` (`assignee_id`);
692018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_created_unix` ON `issue` (`created_unix`);
702018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_poster_id` ON `issue` (`poster_id`);
712018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_milestone_id` ON `issue` (`milestone_id`);
722018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_issue_is_pull` ON `issue` (`is_pull`);
732018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `pull_request` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `type` INT NULL, `status` INT NULL, `issue_id` BIGINT(20) NULL, `index` BIGINT(20) NULL, `head_repo_id` BIGINT(20) NULL, `base_repo_id` BIGINT(20) NULL, `head_user_name` VARCHAR(255) NULL, `head_branch` VARCHAR(255) NULL, `base_branch` VARCHAR(255) NULL, `merge_base` VARCHAR(40) NULL, `has_merged` TINYINT(1) NULL, `merged_commit_id` VARCHAR(40) NULL, `merger_id` BIGINT(20) NULL, `merged_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
742018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_base_repo_id` ON `pull_request` (`base_repo_id`);
752018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_has_merged` ON `pull_request` (`has_merged`);
762018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_merger_id` ON `pull_request` (`merger_id`);
772018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_merged_unix` ON `pull_request` (`merged_unix`);
782018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_issue_id` ON `pull_request` (`issue_id`);
792018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_pull_request_head_repo_id` ON `pull_request` (`head_repo_id`);
802018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `comment` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `type` INT NULL, `poster_id` BIGINT(20) NULL, `issue_id` BIGINT(20) NULL, `label_id` BIGINT(20) NULL, `old_milestone_id` BIGINT(20) NULL, `milestone_id` BIGINT(20) NULL, `old_assignee_id` BIGINT(20) NULL, `assignee_id` BIGINT(20) NULL, `old_title` VARCHAR(255) NULL, `new_title` VARCHAR(255) NULL, `commit_id` BIGINT(20) NULL, `line` BIGINT(20) NULL, `content` TEXT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL, `commit_sha` VARCHAR(40) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
812018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_comment_created_unix` ON `comment` (`created_unix`);
822018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_comment_updated_unix` ON `comment` (`updated_unix`);
832018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_comment_poster_id` ON `comment` (`poster_id`);
842018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_comment_issue_id` ON `comment` (`issue_id`);
852018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `attachment` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uuid` VARCHAR(40) NULL, `issue_id` BIGINT(20) NULL, `release_id` BIGINT(20) NULL, `comment_id` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `download_count` BIGINT(20) DEFAULT 0 NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
862018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_attachment_uuid` ON `attachment` (`uuid`)
872018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_attachment_issue_id` ON `attachment` (`issue_id`);
882018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_attachment_release_id` ON `attachment` (`release_id`);
892018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `label` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `color` VARCHAR(7) NULL, `num_issues` INT NULL, `num_closed_issues` INT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
902018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_label_repo_id` ON `label` (`repo_id`);
912018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `issue_label` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `issue_id` BIGINT(20) NULL, `label_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
922018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_issue_label_s` ON `issue_label` (`issue_id`,`label_id`)
932018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `milestone` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `name` VARCHAR(255) NULL, `content` TEXT NULL, `is_closed` TINYINT(1) NULL, `num_issues` INT NULL, `num_closed_issues` INT NULL, `completeness` INT NULL, `deadline_unix` BIGINT(20) NULL, `closed_date_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
942018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_milestone_repo_id` ON `milestone` (`repo_id`);
952018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `mirror` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `interval` BIGINT(20) NULL, `enable_prune` TINYINT(1) DEFAULT true NOT NULL, `updated_unix` BIGINT(20) NULL, `next_update_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
962018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_mirror_repo_id` ON `mirror` (`repo_id`);
972018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_mirror_updated_unix` ON `mirror` (`updated_unix`);
982018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_mirror_next_update_unix` ON `mirror` (`next_update_unix`);
992018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `release` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `publisher_id` BIGINT(20) NULL, `tag_name` VARCHAR(255) NULL, `lower_tag_name` VARCHAR(255) NULL, `target` VARCHAR(255) NULL, `title` VARCHAR(255) NULL, `sha1` VARCHAR(40) NULL, `num_commits` BIGINT(20) NULL, `note` TEXT NULL, `is_draft` TINYINT(1) DEFAULT false NOT NULL, `is_prerelease` TINYINT(1) DEFAULT false NOT NULL, `is_tag` TINYINT(1) DEFAULT false NOT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1002018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_release_n` ON `release` (`repo_id`,`tag_name`)
1012018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_release_created_unix` ON `release` (`created_unix`);
1022018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_release_repo_id` ON `release` (`repo_id`);
1032018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_release_publisher_id` ON `release` (`publisher_id`);
1042018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_release_tag_name` ON `release` (`tag_name`);
1052018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `login_source` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `type` INT NULL, `name` VARCHAR(255) NULL, `is_actived` TINYINT(1) DEFAULT false NOT NULL, `is_sync_enabled` TINYINT(1) DEFAULT false NOT NULL, `cfg` TEXT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1062018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_login_source_name` ON `login_source` (`name`)
1072018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_login_source_is_actived` ON `login_source` (`is_actived`);
1082018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_login_source_is_sync_enabled` ON `login_source` (`is_sync_enabled`);
1092018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_login_source_created_unix` ON `login_source` (`created_unix`);
1102018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_login_source_updated_unix` ON `login_source` (`updated_unix`);
1112018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `webhook` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `org_id` BIGINT(20) NULL, `url` TEXT NULL, `content_type` INT NULL, `secret` TEXT NULL, `events` TEXT NULL, `is_ssl` TINYINT(1) NULL, `is_active` TINYINT(1) NULL, `hook_task_type` INT NULL, `meta` TEXT NULL, `last_status` INT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1122018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_webhook_repo_id` ON `webhook` (`repo_id`);
1132018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_webhook_org_id` ON `webhook` (`org_id`);
1142018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_webhook_is_active` ON `webhook` (`is_active`);
1152018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_webhook_created_unix` ON `webhook` (`created_unix`);
1162018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_webhook_updated_unix` ON `webhook` (`updated_unix`);
1172018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `hook_task` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `hook_id` BIGINT(20) NULL, `uuid` VARCHAR(255) NULL, `type` INT NULL, `url` TEXT NULL, `payload_content` TEXT NULL, `content_type` INT NULL, `event_type` VARCHAR(255) NULL, `is_ssl` TINYINT(1) NULL, `is_delivered` TINYINT(1) NULL, `delivered` BIGINT(20) NULL, `is_succeed` TINYINT(1) NULL, `request_content` TEXT NULL, `response_content` TEXT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1182018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_hook_task_repo_id` ON `hook_task` (`repo_id`);
1192018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `team` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `org_id` BIGINT(20) NULL, `lower_name` VARCHAR(255) NULL, `name` VARCHAR(255) NULL, `description` VARCHAR(255) NULL, `authorize` INT NULL, `num_repos` INT NULL, `num_members` INT NULL, `unit_types` TEXT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1202018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_team_org_id` ON `team` (`org_id`);
1212018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `org_user` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NULL, `org_id` BIGINT(20) NULL, `is_public` TINYINT(1) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1222018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_org_user_s` ON `org_user` (`uid`,`org_id`)
1232018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_org_user_uid` ON `org_user` (`uid`);
1242018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_org_user_org_id` ON `org_user` (`org_id`);
1252018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_org_user_is_public` ON `org_user` (`is_public`);
1262018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `team_user` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `org_id` BIGINT(20) NULL, `team_id` BIGINT(20) NULL, `uid` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1272018/02/17 00:39:30 [I] [SQL] CREATE UNIQUE INDEX `UQE_team_user_s` ON `team_user` (`team_id`,`uid`)
1282018/02/17 00:39:30 [I] [SQL] CREATE INDEX `IDX_team_user_org_id` ON `team_user` (`org_id`);
1292018/02/17 00:39:30 [I] [SQL] CREATE TABLE IF NOT EXISTS `team_repo` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `org_id` BIGINT(20) NULL, `team_id` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1302018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_team_repo_s` ON `team_repo` (`team_id`,`repo_id`)
1312018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_team_repo_org_id` ON `team_repo` (`org_id`);
1322018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `notice` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `type` INT NULL, `description` TEXT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1332018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notice_created_unix` ON `notice` (`created_unix`);
1342018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `email_address` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NOT NULL, `email` VARCHAR(255) NOT NULL, `is_activated` TINYINT(1) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1352018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_email_address_email` ON `email_address` (`email`)
1362018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_email_address_uid` ON `email_address` (`uid`);
1372018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `notification` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NOT NULL, `repo_id` BIGINT(20) NOT NULL, `status` SMALLINT NOT NULL, `source` SMALLINT NOT NULL, `issue_id` BIGINT(20) NOT NULL, `commit_id` VARCHAR(255) NULL, `updated_by` BIGINT(20) NOT NULL, `created_unix` BIGINT(20) NOT NULL, `updated_unix` BIGINT(20) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1382018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_user_id` ON `notification` (`user_id`);
1392018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_repo_id` ON `notification` (`repo_id`);
1402018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_status` ON `notification` (`status`);
1412018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_source` ON `notification` (`source`);
1422018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_issue_id` ON `notification` (`issue_id`);
1432018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_commit_id` ON `notification` (`commit_id`);
1442018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_updated_by` ON `notification` (`updated_by`);
1452018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_created_unix` ON `notification` (`created_unix`);
1462018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_notification_updated_unix` ON `notification` (`updated_unix`);
1472018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `issue_user` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NULL, `issue_id` BIGINT(20) NULL, `is_read` TINYINT(1) NULL, `is_assigned` TINYINT(1) NULL, `is_mentioned` TINYINT(1) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1482018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_issue_user_uid` ON `issue_user` (`uid`);
1492018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `lfs_meta_object` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `oid` VARCHAR(255) NOT NULL, `size` BIGINT(20) NOT NULL, `repository_id` BIGINT(20) NOT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1502018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_lfs_meta_object_s` ON `lfs_meta_object` (`oid`,`repository_id`)
1512018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_lfs_meta_object_oid` ON `lfs_meta_object` (`oid`);
1522018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_lfs_meta_object_repository_id` ON `lfs_meta_object` (`repository_id`);
1532018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `two_factor` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NULL, `secret` VARCHAR(255) NULL, `scratch_token` VARCHAR(255) NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1542018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_two_factor_uid` ON `two_factor` (`uid`)
1552018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_two_factor_created_unix` ON `two_factor` (`created_unix`);
1562018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_two_factor_updated_unix` ON `two_factor` (`updated_unix`);
1572018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `gpg_key` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `owner_id` BIGINT(20) NOT NULL, `key_id` CHAR(16) NOT NULL, `primary_key_id` CHAR(16) NULL, `content` TEXT NOT NULL, `created_unix` BIGINT(20) NULL, `expired_unix` BIGINT(20) NULL, `added_unix` BIGINT(20) NULL, `emails` TEXT NULL, `can_sign` TINYINT(1) NULL, `can_encrypt_comms` TINYINT(1) NULL, `can_encrypt_storage` TINYINT(1) NULL, `can_certify` TINYINT(1) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1582018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_gpg_key_key_id` ON `gpg_key` (`key_id`);
1592018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_gpg_key_owner_id` ON `gpg_key` (`owner_id`);
1602018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `repo_unit` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `type` INT NULL, `config` TEXT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1612018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_repo_unit_s` ON `repo_unit` (`repo_id`,`type`);
1622018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_repo_unit_created_unix` ON `repo_unit` (`created_unix`);
1632018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `repo_redirect` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `owner_id` BIGINT(20) NULL, `lower_name` VARCHAR(255) NOT NULL, `redirect_repo_id` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1642018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_repo_redirect_s` ON `repo_redirect` (`owner_id`,`lower_name`)
1652018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_repo_redirect_lower_name` ON `repo_redirect` (`lower_name`);
1662018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `external_login_user` (`external_id` VARCHAR(255) NOT NULL, `user_id` BIGINT(20) NOT NULL, `login_source_id` BIGINT(20) NOT NULL, PRIMARY KEY ( `external_id`,`login_source_id` )) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1672018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_external_login_user_user_id` ON `external_login_user` (`user_id`);
1682018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `protected_branch` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `branch_name` VARCHAR(255) NULL, `can_push` TINYINT(1) DEFAULT false NOT NULL, `enable_whitelist` TINYINT(1) NULL, `whitelist_user_i_ds` TEXT NULL, `whitelist_team_i_ds` TEXT NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1692018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_protected_branch_s` ON `protected_branch` (`repo_id`,`branch_name`)
1702018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `user_open_id` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `uid` BIGINT(20) NOT NULL, `uri` VARCHAR(255) NOT NULL, `show` TINYINT(1) DEFAULT false NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1712018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_user_open_id_uri` ON `user_open_id` (`uri`)
1722018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_user_open_id_uid` ON `user_open_id` (`uid`);
1732018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `issue_watch` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `user_id` BIGINT(20) NOT NULL, `issue_id` BIGINT(20) NOT NULL, `is_watching` TINYINT(1) NOT NULL, `created_unix` BIGINT(20) NOT NULL, `updated_unix` BIGINT(20) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1742018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_issue_watch_watch` ON `issue_watch` (`user_id`,`issue_id`)
1752018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `commit_status` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `index` BIGINT(20) NULL, `repo_id` BIGINT(20) NULL, `state` VARCHAR(7) NOT NULL, `sha` VARCHAR(64) NOT NULL, `target_url` TEXT NULL, `description` TEXT NULL, `context` TEXT NULL, `creator_id` BIGINT(20) NULL, `created_unix` BIGINT(20) NULL, `updated_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1762018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_commit_status_repo_sha_index` ON `commit_status` (`index`,`repo_id`,`sha`)
1772018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_commit_status_index` ON `commit_status` (`index`);
1782018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_commit_status_repo_id` ON `commit_status` (`repo_id`);
1792018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_commit_status_sha` ON `commit_status` (`sha`);
1802018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_commit_status_created_unix` ON `commit_status` (`created_unix`);
1812018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_commit_status_updated_unix` ON `commit_status` (`updated_unix`);
1822018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `stopwatch` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `issue_id` BIGINT(20) NULL, `user_id` BIGINT(20) NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1832018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_stopwatch_issue_id` ON `stopwatch` (`issue_id`);
1842018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_stopwatch_user_id` ON `stopwatch` (`user_id`);
1852018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `tracked_time` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `issue_id` BIGINT(20) NULL, `user_id` BIGINT(20) NULL, `created_unix` BIGINT(20) NULL, `time` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1862018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_tracked_time_issue_id` ON `tracked_time` (`issue_id`);
1872018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_tracked_time_user_id` ON `tracked_time` (`user_id`);
1882018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `deleted_branch` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NOT NULL, `name` VARCHAR(255) NOT NULL, `commit` VARCHAR(255) NOT NULL, `deleted_by_id` BIGINT(20) NULL, `deleted_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1892018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_deleted_branch_s` ON `deleted_branch` (`repo_id`,`name`,`commit`)
1902018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_deleted_branch_repo_id` ON `deleted_branch` (`repo_id`);
1912018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_deleted_branch_deleted_by_id` ON `deleted_branch` (`deleted_by_id`);
1922018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_deleted_branch_deleted_unix` ON `deleted_branch` (`deleted_unix`);
1932018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `repo_indexer_status` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NULL, `commit_sha` VARCHAR(40) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1942018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_repo_indexer_status_repo_id` ON `repo_indexer_status` (`repo_id`);
1952018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `lfs_lock` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `repo_id` BIGINT(20) NOT NULL, `owner_id` BIGINT(20) NOT NULL, `path` TEXT NULL, `created` DATETIME NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1962018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_lfs_lock_owner_id` ON `lfs_lock` (`owner_id`);
1972018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_lfs_lock_repo_id` ON `lfs_lock` (`repo_id`);
1982018/02/17 00:39:31 [I] [SQL] CREATE TABLE IF NOT EXISTS `reaction` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `type` VARCHAR(255) NOT NULL, `issue_id` BIGINT(20) NOT NULL, `comment_id` BIGINT(20) NULL, `user_id` BIGINT(20) NOT NULL, `created_unix` BIGINT(20) NULL) ENGINE=InnoDB DEFAULT CHARSET utf8mb4
1992018/02/17 00:39:31 [I] [SQL] CREATE UNIQUE INDEX `UQE_reaction_s` ON `reaction` (`type`,`issue_id`,`comment_id`,`user_id`)
2002018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_reaction_created_unix` ON `reaction` (`created_unix`);
2012018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_reaction_type` ON `reaction` (`type`);
2022018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_reaction_issue_id` ON `reaction` (`issue_id`);
2032018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_reaction_comment_id` ON `reaction` (`comment_id`);
2042018/02/17 00:39:31 [I] [SQL] CREATE INDEX `IDX_reaction_user_id` ON `reaction` (`user_id`);
2052018/02/17 00:39:31 [I] [SQL] SELECT `id`, `type`, `name`, `is_actived`, `is_sync_enabled`, `cfg`, `created_unix`, `updated_unix` FROM `login_source` WHERE (is_actived = ? and type = ?) []interface {}{true, 6}
2062018/02/17 00:39:31 [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_watches!=(SELECT COUNT(*) FROM `watch` WHERE repo_id=repo.id)
2072018/02/17 00:39:31 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `size`, `created_unix`, `updated_unix` FROM `repository` WHERE (id > 0)
2082018/02/17 00:39:31 [I] [SQL] DELETE FROM `deleted_branch` WHERE (deleted_unix < ?) []interface {}{1518737971}
2092018/02/17 00:39:31 [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_stars!=(SELECT COUNT(*) FROM `star` WHERE repo_id=repo.id)
2102018/02/17 00:39:31 [I] [SQL] SELECT label.id FROM `label` WHERE label.num_issues!=(SELECT COUNT(*) FROM `issue_label` WHERE label_id=label.id)
2112018/02/17 00:39:31 [I] [SQL] SELECT `user`.id FROM `user` WHERE `user`.num_repos!=(SELECT COUNT(*) FROM `repository` WHERE owner_id=`user`.id)
2122018/02/17 00:39:31 [I] [SQL] SELECT `issue`.id FROM `issue` WHERE `issue`.num_comments!=(SELECT COUNT(*) FROM `comment` WHERE issue_id=`issue`.id AND type=0)
2132018/02/17 00:39:31 [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_closed_issues!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_closed=? AND is_pull=?) []interface {}{true, false}
2142018/02/17 00:39:31 [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_forks!=(SELECT COUNT(*) FROM `repository` WHERE fork_id=repo.id)
2152018/02/17 00:39:31 [I] [SQL] SELECT count(*) FROM `repository`
2162018/02/17 00:39:31 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `size`, `created_unix`, `updated_unix` FROM `repository` ORDER BY id ASC LIMIT 64
2172018/02/17 00:39:31 [I] [SQL] SELECT `id`, `type`, `status`, `issue_id`, `index`, `head_repo_id`, `base_repo_id`, `head_user_name`, `head_branch`, `base_branch`, `merge_base`, `has_merged`, `merged_commit_id`, `merger_id`, `merged_unix` FROM `pull_request` WHERE (status = ?) []interface {}{1}
2182018/02/17 00:39:31 [I] [SQL] SELECT `id`, `repo_id`, `hook_id`, `uuid`, `type`, `url`, `payload_content`, `content_type`, `event_type`, `is_ssl`, `is_delivered`, `delivered`, `is_succeed`, `request_content`, `response_content` FROM `hook_task` WHERE (is_delivered=?) []interface {}{false}