Gitlink
/
forgeplus-deploy
0
0
Fork 1
Code Issues Pull Requests Packages Projects Releases Wiki Activity
forgeplus-deploy/00-db/mysql-init/03-init-gitea-user.sql

165 lines
11 KiB
SQL
Raw Permalink Blame History

/*
Navicat Premium Data Transfer
Source Server : 172.20.32.202-内
Source Server Type : MySQL
Source Server Version : 50742 (5.7.42)
Source Host : 172.20.32.202:3306
Source Schema : gitea_hat
Target Server Type : MySQL
Target Server Version : 50742 (5.7.42)
File Encoding : 65001
Date: 18/07/2024 15:56:13
*/
use gitea_hat;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`lower_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`keep_email_private` tinyint(1) NULL DEFAULT NULL,
`email_notifications_preference` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'enabled',
`passwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`passwd_hash_algo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'argon2',
`must_change_password` tinyint(1) NOT NULL DEFAULT 0,
`login_type` int(11) NULL DEFAULT NULL,
`login_source` bigint(20) NOT NULL DEFAULT 0,
`login_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`type` int(11) NULL DEFAULT NULL,
`location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`rands` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`language` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`created_unix` bigint(20) NULL DEFAULT NULL,
`updated_unix` bigint(20) NULL DEFAULT NULL,
`last_login_unix` bigint(20) NULL DEFAULT NULL,
`last_repo_visibility` tinyint(1) NULL DEFAULT NULL,
`max_repo_creation` int(11) NOT NULL DEFAULT -1,
`is_active` tinyint(1) NULL DEFAULT NULL,
`is_admin` tinyint(1) NULL DEFAULT NULL,
`is_restricted` tinyint(1) NOT NULL DEFAULT 0,
`allow_git_hook` tinyint(1) NULL DEFAULT NULL,
`allow_import_local` tinyint(1) NULL DEFAULT NULL,
`allow_create_organization` tinyint(1) NULL DEFAULT 1,
`prohibit_login` tinyint(1) NOT NULL DEFAULT 0,
`avatar` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`avatar_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`use_custom_avatar` tinyint(1) NULL DEFAULT NULL,
`num_followers` int(11) NULL DEFAULT NULL,
`num_following` int(11) NOT NULL DEFAULT 0,
`num_stars` int(11) NULL DEFAULT NULL,
`num_repos` int(11) NULL DEFAULT NULL,
`num_teams` int(11) NULL DEFAULT NULL,
`num_members` int(11) NULL DEFAULT NULL,
`visibility` int(11) NOT NULL DEFAULT 0,
`repo_admin_change_team_access` tinyint(1) NOT NULL DEFAULT 0,
`diff_view_style` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`theme` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`keep_activity_private` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `UQE_user_name`(`name`) USING BTREE,
UNIQUE INDEX `UQE_user_lower_name`(`lower_name`) USING BTREE,
INDEX `IDX_user_last_login_unix`(`last_login_unix`) USING BTREE,
INDEX `IDX_user_is_active`(`is_active`) USING BTREE,
INDEX `IDX_user_created_unix`(`created_unix`) USING BTREE,
INDEX `IDX_user_updated_unix`(`updated_unix`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 261 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'root', 'root', '', 'admin@gitlink.org.cn', 0, 'enabled', 'b5819220e8b325c2a46875e758089f86657951f4cab18344a92a6f599439ef2ec92073129d6103ef6aa367f9cdef14d85e47', 'pbkdf2$50000$50', 0, 0, 0, '', 0, '', '', 'aa8eef377aa9b89b1a29eb3db00d08e1', '3d66f890cd095b6a0759baa77001b6e9', 'zh-CN', '', 1701153981, 1718779641, 1718779641, 0, -1, 1, 1, 0, 0, 0, 1, 0, '', 'admin@gitlink.org.cn', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'auto', 0);
INSERT INTO `user` VALUES (100, 'innov', 'innov', '', 'innov@forge.com', 0, 'enabled', 'c8014c065c753440d26f9ab9659064ae03142a943ee23112e64108268dab4285f15b8de427e80b431a08392ef361a39d2204', 'pbkdf2$50000$50', 0, 1, 0, 'innov', 0, '', '', '48e904f80ace4f923aa1d865dc9f1bf8', '9b709e9915857b4d168faa5300e407e9', 'zh-CN', '', 1702868176, 1721121437, 1719281030, 0, -1, 1, 1, 0, 0, 0, 1, 0, '', 'innov@forge.com', 0, 0, 0, 0, 16, 0, 0, 0, 0, '', 'auto', 0);
-- ----------------------------
-- Table structure for access_token
-- ----------------------------
DROP TABLE IF EXISTS `access_token`;
CREATE TABLE `access_token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`uid` bigint(20) NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`token_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`token_salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`token_last_eight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`created_unix` bigint(20) NULL DEFAULT NULL,
`updated_unix` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `UQE_access_token_token_hash`(`token_hash`) USING BTREE,
INDEX `IDX_access_token_uid`(`uid`) USING BTREE,
INDEX `IDX_access_token_token_last_eight`(`token_last_eight`) USING BTREE,
INDEX `IDX_access_token_created_unix`(`created_unix`) USING BTREE,
INDEX `IDX_access_token_updated_unix`(`updated_unix`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
INSERT INTO `access_token` (`id`, `uid`, `name`, `token_hash`, `token_salt`, `token_last_eight`, `scope`, `created_unix`, `updated_unix`) VALUES (1, 100, 'innov-f6b7ed951354', '11e43d636d05b79eb73d6fdf824fc69c0c6a16079a4983b615c50ebf22065f4df7b67786619c0fe96faa5df29a576a707ae2', '180MlNOT3m', 'dcee33ba', 'all', 1721355049, 1721355101);
-- ----------------------------
-- Table structure for action_runner_token
-- ----------------------------
DROP TABLE IF EXISTS `action_runner_token`;
CREATE TABLE `action_runner_token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`owner_id` bigint(20) NULL DEFAULT NULL,
`repo_id` bigint(20) NULL DEFAULT NULL,
`is_active` tinyint(1) NULL DEFAULT NULL,
`created` bigint(20) NULL DEFAULT NULL,
`updated` bigint(20) NULL DEFAULT NULL,
`deleted` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `UQE_action_runner_token_token`(`token`) USING BTREE,
INDEX `IDX_action_runner_token_owner_id`(`owner_id`) USING BTREE,
INDEX `IDX_action_runner_token_repo_id`(`repo_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of action_runner_token
-- ----------------------------
INSERT INTO `action_runner_token` (`id`, `token`, `owner_id`, `repo_id`, `is_active`, `created`, `updated`, `deleted`) VALUES (1, 'XPnJXquS0rhGhK99t2HAfCQAcH200uZLmgWRFwag', 0, 0, 1, 1712643257, 1720771549, NULL);
DROP TABLE IF EXISTS `webhook`;
CREATE TABLE `webhook` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`repo_id` bigint(20) DEFAULT NULL,
`owner_id` bigint(20) DEFAULT NULL,
`is_system_webhook` tinyint(1) DEFAULT NULL,
`url` text,
`http_method` varchar(255) DEFAULT NULL,
`content_type` int(11) DEFAULT NULL,
`secret` text,
`events` text,
`is_active` tinyint(1) DEFAULT NULL,
`type` varchar(16) DEFAULT NULL,
`meta` text,
`last_status` int(11) DEFAULT NULL,
`header_authorization_encrypted` text,
`created_unix` bigint(20) DEFAULT NULL,
`updated_unix` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_webhook_owner_id` (`owner_id`),
KEY `IDX_webhook_is_active` (`is_active`),
KEY `IDX_webhook_created_unix` (`created_unix`),
KEY `IDX_webhook_updated_unix` (`updated_unix`),
KEY `IDX_webhook_repo_id` (`repo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
INSERT INTO `webhook` (`repo_id`, `owner_id`, `is_system_webhook`, `url`, `http_method`, `content_type`, `secret`, `events`, `is_active`, `type`, `meta`, `last_status`, `header_authorization_encrypted`, `created_unix`, `updated_unix`) VALUES ( 0, 0, 1, 'http://172.20.32.202:4000/commit_logs?token=7917908927b6f1b792f2027a08a8b24a2de42c1692c2fd45da0dee5cf90a5af5', 'POST', 1, '', '{\"push_only\":true,\"send_everything\":false,\"choose_events\":false,\"branch_filter\":\"*\",\"events\":{\"create\":false,\"delete\":false,\"fork\":false,\"issues\":false,\"issue_assign\":false,\"issue_label\":false,\"issue_milestone\":false,\"issue_comment\":false,\"push\":false,\"pull_request\":false,\"pull_request_assign\":false,\"pull_request_label\":false,\"pull_request_milestone\":false,\"pull_request_comment\":false,\"pull_request_review\":false,\"pull_request_sync\":false,\"pull_request_review_request\":false,\"wiki\":false,\"repository\":false,\"release\":false,\"package\":false}}', 1, 'gitea', '', 1, '', 1748567905, 1751337083);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink