Gitlink
/
forgeplus
33
1
Fork 58
Code Issues 1 Pull Requests 1 Packages Releases 15 Wiki Activity
forgeplus/db/init.sql

6884 lines
3.2 MiB
MySQL
Raw Permalink Normal View History

整理初始菜单sql
2023-05-29 18:18:00 +08:00
-- MySQL dump 10.13 Distrib 8.0.25, for macos11.3 (x86_64)
--
-- Host: localhost Database: forge_structure
-- ------------------------------------------------------
-- Server version 8.0.25
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `api_keys`
--
CREATE DATABASE IF NOT EXISTS forgeplus default charset utf8 COLLATE utf8_general_ci;
USE forgeplus;
DROP TABLE IF EXISTS `api_keys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_keys` (
`id` int NOT NULL AUTO_INCREMENT,
`access_token` varchar(255) DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
`user_id` int DEFAULT NULL,
`active` tinyint(1) DEFAULT '1',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_api_keys_on_user_id` (`user_id`),
KEY `index_api_keys_on_access_token` (`access_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api_keys`
--
LOCK TABLES `api_keys` WRITE;
/*!40000 ALTER TABLE `api_keys` DISABLE KEYS */;
/*!40000 ALTER TABLE `api_keys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applied_contests`
--
DROP TABLE IF EXISTS `applied_contests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applied_contests` (
`id` int NOT NULL AUTO_INCREMENT,
`contest_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`role` varchar(255) DEFAULT NULL,
`status` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_applied_contests_on_contest_id` (`contest_id`),
KEY `index_applied_contests_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applied_contests`
--
LOCK TABLES `applied_contests` WRITE;
/*!40000 ALTER TABLE `applied_contests` DISABLE KEYS */;
/*!40000 ALTER TABLE `applied_contests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applied_messages`
--
DROP TABLE IF EXISTS `applied_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applied_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`applied_id` int DEFAULT NULL,
`applied_type` varchar(255) DEFAULT NULL,
`viewed` int DEFAULT '0',
`status` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`name` varchar(255) DEFAULT NULL,
`applied_user_id` int DEFAULT NULL,
`role` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applied_messages`
--
LOCK TABLES `applied_messages` WRITE;
/*!40000 ALTER TABLE `applied_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `applied_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applied_projects`
--
DROP TABLE IF EXISTS `applied_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applied_projects` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL,
`user_id` int NOT NULL,
`role` int DEFAULT '0',
`status` int DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applied_projects`
--
LOCK TABLES `applied_projects` WRITE;
/*!40000 ALTER TABLE `applied_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `applied_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applied_transfer_projects`
--
DROP TABLE IF EXISTS `applied_transfer_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applied_transfer_projects` (
`id` bigint NOT NULL AUTO_INCREMENT,
`project_id` bigint DEFAULT NULL,
`owner_id` bigint DEFAULT NULL,
`user_id` bigint DEFAULT NULL,
`status` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_applied_transfer_projects_on_project_id` (`project_id`),
KEY `index_applied_transfer_projects_on_owner_id` (`owner_id`),
KEY `index_applied_transfer_projects_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applied_transfer_projects`
--
LOCK TABLES `applied_transfer_projects` WRITE;
/*!40000 ALTER TABLE `applied_transfer_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `applied_transfer_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apply_actions`
--
DROP TABLE IF EXISTS `apply_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `apply_actions` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`reason` varchar(255) DEFAULT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`dealer_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`status` tinyint DEFAULT '0',
`apply_reason` text,
`noticed` tinyint(1) DEFAULT '0',
`ip_addr` varchar(255) DEFAULT NULL,
`reject_description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_apply_actions_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apply_actions`
--
LOCK TABLES `apply_actions` WRITE;
/*!40000 ALTER TABLE `apply_actions` DISABLE KEYS */;
/*!40000 ALTER TABLE `apply_actions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apply_add_departments`
--
DROP TABLE IF EXISTS `apply_add_departments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `apply_add_departments` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`department_id` int DEFAULT NULL,
`school_id` int DEFAULT NULL,
`remarks` text,
`user_id` int DEFAULT NULL,
`status` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_apply_add_departments_on_department_id` (`department_id`),
KEY `index_apply_add_departments_on_school_id` (`school_id`),
KEY `index_apply_add_departments_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apply_add_departments`
--
LOCK TABLES `apply_add_departments` WRITE;
/*!40000 ALTER TABLE `apply_add_departments` DISABLE KEYS */;
/*!40000 ALTER TABLE `apply_add_departments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apply_project_masters`
--
DROP TABLE IF EXISTS `apply_project_masters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `apply_project_masters` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`apply_type` varchar(255) DEFAULT NULL,
`apply_id` int DEFAULT NULL,
`status` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apply_project_masters`
--
LOCK TABLES `apply_project_masters` WRITE;
/*!40000 ALTER TABLE `apply_project_masters` DISABLE KEYS */;
/*!40000 ALTER TABLE `apply_project_masters` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apply_resources`
--
DROP TABLE IF EXISTS `apply_resources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `apply_resources` (
`id` int NOT NULL AUTO_INCREMENT,
`status` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`attachment_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`content` text,
`apply_user_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apply_resources`
--
LOCK TABLES `apply_resources` WRITE;
/*!40000 ALTER TABLE `apply_resources` DISABLE KEYS */;
/*!40000 ALTER TABLE `apply_resources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `apply_user_authentications`
--
DROP TABLE IF EXISTS `apply_user_authentications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `apply_user_authentications` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`status` int DEFAULT NULL,
`auth_type` int DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL,
`dealer` int DEFAULT NULL,
`deal_time` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`is_delete` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_apply_user_authentications_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `apply_user_authentications`
--
LOCK TABLES `apply_user_authentications` WRITE;
/*!40000 ALTER TABLE `apply_user_authentications` DISABLE KEYS */;
/*!40000 ALTER TABLE `apply_user_authentications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ar_internal_metadata`
--
DROP TABLE IF EXISTS `ar_internal_metadata`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ar_internal_metadata` (
`key` varchar(255) NOT NULL,
`value` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ar_internal_metadata`
--
LOCK TABLES `ar_internal_metadata` WRITE;
/*!40000 ALTER TABLE `ar_internal_metadata` DISABLE KEYS */;
INSERT INTO `ar_internal_metadata` VALUES ('environment','development','2021-08-27 08:51:46','2021-08-27 08:51:46');
/*!40000 ALTER TABLE `ar_internal_metadata` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachment_group_settings`
--
DROP TABLE IF EXISTS `attachment_group_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attachment_group_settings` (
`id` int NOT NULL AUTO_INCREMENT,
`attachment_id` int DEFAULT NULL,
`course_group_id` int DEFAULT NULL,
`course_id` int DEFAULT NULL,
`publish_time` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_attachment_group_settings_on_attachment_id` (`attachment_id`),
KEY `index_attachment_group_settings_on_course_group_id` (`course_group_id`),
KEY `index_attachment_group_settings_on_course_id` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachment_group_settings`
--
LOCK TABLES `attachment_group_settings` WRITE;
/*!40000 ALTER TABLE `attachment_group_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachment_group_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachment_histories`
--
DROP TABLE IF EXISTS `attachment_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attachment_histories` (
`id` int NOT NULL AUTO_INCREMENT,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`filename` varchar(255) DEFAULT '',
`disk_filename` varchar(255) DEFAULT '',
`filesize` int DEFAULT '0',
`content_type` varchar(255) DEFAULT '',
`digest` varchar(60) DEFAULT '',
`downloads` int DEFAULT '0',
`author_id` int DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`description` text,
`disk_directory` varchar(255) DEFAULT NULL,
`attachtype` int DEFAULT NULL,
`is_public` int DEFAULT NULL,
`copy_from` int DEFAULT NULL,
`quotes` int DEFAULT NULL,
`version` int DEFAULT NULL,
`attachment_id` int DEFAULT NULL,
`is_publish` int DEFAULT '1',
`publish_time` date DEFAULT NULL,
`cloud_url` varchar(255) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachment_histories`
--
LOCK TABLES `attachment_histories` WRITE;
/*!40000 ALTER TABLE `attachment_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachment_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachments`
--
DROP TABLE IF EXISTS `attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attachments` (
`id` int NOT NULL AUTO_INCREMENT,
`container_id` int DEFAULT NULL,
`container_type` varchar(30) DEFAULT NULL,
`filename` varchar(255) NOT NULL DEFAULT '',
`disk_filename` varchar(255) NOT NULL DEFAULT '',
`filesize` int NOT NULL DEFAULT '0',
`content_type` varchar(255) DEFAULT '',
`digest` varchar(60) NOT NULL DEFAULT '',
`downloads` int NOT NULL DEFAULT '0',
`author_id` int NOT NULL DEFAULT '0',
`created_on` datetime DEFAULT NULL,
`description` text,
`disk_directory` varchar(255) DEFAULT NULL,
`attachtype` int DEFAULT '1',
`is_public` int DEFAULT '1',
`copy_from` int DEFAULT NULL,
`quotes` int DEFAULT '0',
`is_publish` int DEFAULT '1',
`publish_time` datetime DEFAULT NULL,
`resource_bank_id` int DEFAULT NULL,
`unified_setting` tinyint(1) DEFAULT '1',
`cloud_url` varchar(255) DEFAULT '',
`course_second_category_id` int DEFAULT '0',
`delay_publish` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_attachments_on_author_id` (`author_id`),
KEY `index_attachments_on_created_on` (`created_on`),
KEY `index_attachments_on_container_id_and_container_type` (`container_id`,`container_type`),
KEY `index_attachments_on_course_second_category_id` (`course_second_category_id`),
KEY `index_attachments_on_quotes` (`quotes`),
KEY `index_attachments_on_is_public` (`is_public`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachments`
--
LOCK TABLES `attachments` WRITE;
/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachmentstypes`
--
DROP TABLE IF EXISTS `attachmentstypes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attachmentstypes` (
`id` int NOT NULL AUTO_INCREMENT,
`typeId` int NOT NULL,
`typeName` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachmentstypes`
--
LOCK TABLES `attachmentstypes` WRITE;
/*!40000 ALTER TABLE `attachmentstypes` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachmentstypes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_sources`
--
DROP TABLE IF EXISTS `auth_sources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_sources` (
`id` int NOT NULL AUTO_INCREMENT,
`type` varchar(30) NOT NULL DEFAULT '',
`name` varchar(60) NOT NULL DEFAULT '',
`host` varchar(60) DEFAULT NULL,
`port` int DEFAULT NULL,
`account` varchar(255) DEFAULT NULL,
`account_password` varchar(255) DEFAULT '',
`base_dn` varchar(255) DEFAULT NULL,
`attr_login` varchar(30) DEFAULT NULL,
`attr_firstname` varchar(30) DEFAULT NULL,
`attr_lastname` varchar(30) DEFAULT NULL,
`attr_mail` varchar(30) DEFAULT NULL,
`onthefly_register` tinyint(1) NOT NULL DEFAULT '0',
`tls` tinyint(1) NOT NULL DEFAULT '0',
`filter` varchar(255) DEFAULT NULL,
`timeout` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_auth_sources_on_id_and_type` (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_sources`
--
LOCK TABLES `auth_sources` WRITE;
/*!40000 ALTER TABLE `auth_sources` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_sources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `authentications`
--
DROP TABLE IF EXISTS `authentications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `authentications` (
`id` int NOT NULL AUTO_INCREMENT,
`level` tinyint DEFAULT NULL,
`permissions` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `authentications`
--
LOCK TABLES `authentications` WRITE;
/*!40000 ALTER TABLE `authentications` DISABLE KEYS */;
/*!40000 ALTER TABLE `authentications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `authentications_users`
--
DROP TABLE IF EXISTS `authentications_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `authentications_users` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`authentication_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `authentications_users`
--
LOCK TABLES `authentications_users` WRITE;
/*!40000 ALTER TABLE `authentications_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `authentications_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bidding_users`
--
DROP TABLE IF EXISTS `bidding_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bidding_users` (
`id` int NOT NULL AUTO_INCREMENT,
`project_package_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_bidding_users_on_project_package_id` (`project_package_id`),
KEY `index_bidding_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bidding_users`
--
LOCK TABLES `bidding_users` WRITE;
/*!40000 ALTER TABLE `bidding_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `bidding_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `biding_projects`
--
DROP TABLE IF EXISTS `biding_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biding_projects` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`bid_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`reward` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biding_projects`
--
LOCK TABLES `biding_projects` WRITE;
/*!40000 ALTER TABLE `biding_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `biding_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bids`
--
DROP TABLE IF EXISTS `bids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bids` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`budget` varchar(255) NOT NULL,
`author_id` int DEFAULT NULL,
`deadline` date DEFAULT NULL,
`description` text,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`commit` int DEFAULT NULL,
`reward_type` int DEFAULT NULL,
`homework_type` int DEFAULT NULL,
`parent_id` int DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`is_evaluation` int DEFAULT NULL,
`proportion` int DEFAULT '60',
`comment_status` int DEFAULT '0',
`evaluation_num` int DEFAULT '3',
`open_anonymous_evaluation` int DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bids`
--
LOCK TABLES `bids` WRITE;
/*!40000 ALTER TABLE `bids` DISABLE KEYS */;
/*!40000 ALTER TABLE `bids` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_cloud_accounts`
--
DROP TABLE IF EXISTS `ci_cloud_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_cloud_accounts` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`ip_num` int DEFAULT NULL,
`account` varchar(255) DEFAULT NULL,
`secret` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`ci_user_id` int DEFAULT NULL,
`server_type` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `dev_ops_cloud_accounts_p_u_ip` (`user_id`,`ip_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_cloud_accounts`
--
LOCK TABLES `ci_cloud_accounts` WRITE;
/*!40000 ALTER TABLE `ci_cloud_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `ci_cloud_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_languages`
--
DROP TABLE IF EXISTS `ci_languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_languages` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'The name of project language.',
`content` text NOT NULL COMMENT 'The content of project language.',
`usage_amount` int DEFAULT '0' COMMENT 'number of people Using the language',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`cover_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_languages`
--
LOCK TABLES `ci_languages` WRITE;
/*!40000 ALTER TABLE `ci_languages` DISABLE KEYS */;
INSERT INTO `ci_languages` VALUES (1,'C','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IGdjYwogIGNvbW1hbmRzOgogIC0gLi9jb25maWd1cmUKICAtIG1h\na2UKICAtIG1ha2UgdGVzdA==\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(2,'C++','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IGdjYwogIGNvbW1hbmRzOgogIC0gLi9jb25maWd1cmUKICAtIG1h\na2UKICAtIG1ha2UgdGVzdA==\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(3,'Docker','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IGRvY2tlcjpkaW5kCiAgdm9sdW1lczoKICAtIG5hbWU6IGRvY2tl\ncnNvY2sKICAgIHBhdGg6IC92YXIvcnVuL2RvY2tlci5zb2NrCiAgICBjb21t\nYW5kczoKICAgIC0gZG9ja2VyIHBzIC1hCgp2b2x1bWVzOgotIG5hbWU6IGRv\nY2tlcnNvY2sKICBob3N0OgogICAgcGF0aDogL3Zhci9ydW4vZG9ja2VyLnNv\nY2s=\n',0,'2020-10-21 10:14:22','2020-11-26 01:35:20',351688),(4,'Java','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IG1hdmVuOjMtamRrLTEwCiAgY29tbWFuZHM6CiAgLSBtdm4gaW5z\ndGFsbCAtRHNraXBUZXN0cz10cnVlIC1EbWF2ZW4uamF2YWRvYy5za2lwPXRy\ndWUgLUIgLVYKICAtIG12biB0ZXN0IC1C\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(5,'R','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IHItYmFzZQogIGNvbW1hbmRzOgogIC0gUiAtZSAnaW5zdGFsbC5w\nYWNrYWdlcyhjKCdwYWNrYWdlMScsJ3BhY2thZ2UyJykpJwogIC0gUiBDTUQg\nYnVpbGQgLg==\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(6,'Ruby','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IHJ1YnkKICBjb21tYW5kczoKICAtIGJ1bmRsZSBpbnN0YWxsIC0t\nam9icz0zIC0tcmV0cnk9MwogIC0gcmFrZQ==\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(7,'PHP','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiBpbnN0YWxs\nCiAgaW1hZ2U6IGNvbXBvc2VyCiAgY29tbWFuZHM6CiAgLSBjb21wb3NlciBp\nbnN0YWxsCgotIG5hbWU6IHRlc3QKICBpbWFnZTogcGhwOjcKICBjb21tYW5k\nczoKICAtIHZlbmRvci9iaW4vcGhwdW5pdCAtLWNvbmZpZ3VyYXRpb24gY29u\nZmlnLnhtbA==\n',0,'2020-10-21 10:14:22','2020-11-26 01:37:04',351690),(8,'Python','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IHB5dGhvbgogIGNvbW1hbmRzOgogIC0gcGlwIGluc3RhbGwgLXIg\ncmVxdWlyZW1lbnRzLnR4dAogIC0gcHl0ZXN0\n',0,'2020-10-21 10:14:22','2020-11-26 01:40:00',351693),(9,'MySQL','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IG15c3FsCiAgY29tbWFuZHM6CiAgLSBzbGVlcCAxNQogIC0gbXlz\ncWwgLXUgcm9vdCAtaCBkYXRhYmFzZSAtLWV4ZWN1dGU9J1NFTEVDVCBWRVJT\nSU9OKCk7JwoKc2VydmljZXM6Ci0gbmFtZTogZGF0YWJhc2UKICBpbWFnZTog\nbXlzcWwKICBlbnZpcm9ubWVudDoKICAgIE1ZU1FMX0FMTE9XX0VNUFRZX1BB\nU1NXT1JEOiAneWVzJwogICAgTVlTUUxfREFUQUJBU0U6IHRlc3Q=\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(10,'MongoDB','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiBwaW5nCiAg\naW1hZ2U6IG1vbmdvOjQKICBjb21tYW5kczoKICAtIHNsZWVwIDUKICAtIG1v\nbmdvIC0taG9zdCBtb25nbyAtLWV2YWwgJ2RiLnZlcnNpb24oKScKCnNlcnZp\nY2VzOgotIG5hbWU6IG1vbmdvCiAgaW1hZ2U6IG1vbmdvOjQKICBjb21tYW5k\nOiBbIC0tc21hbGxmaWxlcyBd\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(11,'Clojure','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IGNsb2p1cmUKICBjb21tYW5kczoKICAtIGxlaW4gdGVzdA==\n',0,'2020-10-21 10:14:22','2020-10-21 10:14:22',NULL),(12,'CouchDB','CmtpbmQ6IHBpcGVsaW5lCm5hbWU6IGRlZmF1bHQKCnBsYXRmb3JtOgogIG9z\nOiBsaW51eAogIGFyY2g6IGFybTY0CgpzdGVwczoKLSBuYW1lOiB0ZXN0CiAg\naW1hZ2U6IGNvdWNoZGI6Mi4yCiAgY29tbWFuZHM6CiAgLSBzbGVlcCAxNQog\nIC0gY3VybCBodHRwOi8vZGF0YWJhc2U6NTk4NAoKc2VydmljZXM6Ci0gbmFt\nZTogZGF0YW
/*!40000 ALTER TABLE `ci_languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_pipeline_stage_steps`
--
DROP TABLE IF EXISTS `ci_pipeline_stage_steps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_pipeline_stage_steps` (
`id` bigint NOT NULL AUTO_INCREMENT,
`step_name` varchar(255) NOT NULL COMMENT '步骤名称',
`stage_id` int NOT NULL COMMENT '阶段id',
`template_id` int DEFAULT NULL COMMENT '模板id',
`content` text,
`show_index` int NOT NULL DEFAULT '0' COMMENT '阶段排序',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_pipeline_stage_steps`
--
LOCK TABLES `ci_pipeline_stage_steps` WRITE;
/*!40000 ALTER TABLE `ci_pipeline_stage_steps` DISABLE KEYS */;
/*!40000 ALTER TABLE `ci_pipeline_stage_steps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_pipeline_stages`
--
DROP TABLE IF EXISTS `ci_pipeline_stages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_pipeline_stages` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stage_name` varchar(255) NOT NULL COMMENT '阶段名称',
`stage_type` varchar(255) NOT NULL COMMENT '阶段类型：init/build/deploy/customize/confirm',
`pipeline_id` int NOT NULL COMMENT '阶段所属流水线id',
`show_index` int NOT NULL DEFAULT '0' COMMENT '阶段排序',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_pipeline_stages`
--
LOCK TABLES `ci_pipeline_stages` WRITE;
/*!40000 ALTER TABLE `ci_pipeline_stages` DISABLE KEYS */;
/*!40000 ALTER TABLE `ci_pipeline_stages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_pipelines`
--
DROP TABLE IF EXISTS `ci_pipelines`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_pipelines` (
`id` bigint NOT NULL AUTO_INCREMENT,
`pipeline_name` varchar(255) NOT NULL COMMENT '流水线名称',
`pipeline_status` varchar(255) NOT NULL DEFAULT 'unknown' COMMENT 'successed/failed/running/errored/pending/killed/unknown',
`file_name` varchar(255) NOT NULL COMMENT '文件名称',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`login` varchar(255) DEFAULT NULL,
`sync` int NOT NULL DEFAULT '0' COMMENT '0 未同步到gitea，1 已同步',
`identifier` varchar(255) DEFAULT NULL,
`branch` varchar(255) DEFAULT NULL,
`event` varchar(255) DEFAULT NULL,
`sha` varchar(255) DEFAULT NULL,
`owner` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_pipelines`
--
LOCK TABLES `ci_pipelines` WRITE;
/*!40000 ALTER TABLE `ci_pipelines` DISABLE KEYS */;
/*!40000 ALTER TABLE `ci_pipelines` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_templates`
--
DROP TABLE IF EXISTS `ci_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ci_templates` (
`id` bigint NOT NULL AUTO_INCREMENT,
`template_name` varchar(255) NOT NULL COMMENT '模板名称',
`stage_type` varchar(255) NOT NULL COMMENT '模板所属阶段类型：init/build/deploy/customize/confirm',
`category` varchar(255) NOT NULL COMMENT '模板分类',
`content` text NOT NULL COMMENT '模板yml内容',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`parent_category` varchar(255) DEFAULT NULL,
`login` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_ci_templates_on_stage_type` (`stage_type`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_templates`
--
LOCK TABLES `ci_templates` WRITE;
/*!40000 ALTER TABLE `ci_templates` DISABLE KEYS */;
INSERT INTO `ci_templates` VALUES (2,'linux/amd64','init','初始化','kind: pipeline\r\ntype: docker\r\nname: {name}\r\nplatform:\r\n os: linux\r\n arch: amd64','2021-01-12 02:44:23','2021-02-02 10:51:36','初始化','admin'),(3,'linux/arm64','init','初始化','kind: pipeline\r\ntype: docker\r\nname: {name}\r\nplatform:\r\n os: linux\r\n arch: arm64','2021-01-12 02:45:17','2021-02-02 10:51:47','初始化','admin'),(4,'maven','build','Java','- name: maven\r\n image: maven:3-jdk-10\r\n commands:\r\n - mvn install -DskipTests=true','2021-01-12 02:53:29','2021-01-12 02:53:29','编译构建','admin'),(5,'maven单元测试','customize','Java','- name: maven\r\n image: maven:3-jdk-10\r\n commands:\r\n - mvn test','2021-01-12 02:53:29','2021-01-12 02:53:29','单元测试','admin'),(6,'golang单元测试','customize','Golang','- name: golang单元测试\r\n image: golang\r\n commands:\r\n - go test','2021-01-12 03:03:35','2021-01-12 03:03:35','单元测试','admin'),(8,'gradle','build','Java','- name: gradle\r\n image: gradle:jdk10\r\n commands:\r\n - gradle build -x test','2021-01-12 03:05:33','2021-01-12 03:05:33','编译构建','admin'),(9,'gradle单元测试','customize','Java','- name: gradle\r\n image: gradle:jdk10\r\n commands:\r\n - gradle test','2021-01-12 03:05:33','2021-01-12 03:05:33','单元测试','admin'),(10,'远程主机部署','deploy','部署','# 需要将软件包与部署脚本提前上传到远程主机(见文件上传模板)\r\n# host、username、password可在参数管理中配置\r\n- name: 远程主机部署\r\n image: appleboy/drone-ssh\r\n settings:\r\n host: \r\n from_secret: ip\r\n username: \r\n from_secret: name\r\n password: \r\n from_secret: pwd\r\n port: 22\r\n script:\r\n - chmod +x /home/deploy.sh\r\n - ./home/deploy.sh','2021-01-12 03:32:46','2021-03-05 06:22:02','部署','admin'),(11,'远程命令','customize','其他','# host、username、password可在参数管理中配置\r\n- name: 远程命令\r\n image: appleboy/drone-ssh\r\n settings:\r\n host: \r\n from_secret: ip\r\n username: \r\n from_secret: name\r\n password: \r\n from_secret: pwd\r\n port: 22\r\n script:\r\n - echo \'hello world!\'','2021-01-12 03:40:38','2021-03-05 06:19:44','其他','admin'),(12,'上传文件','customize','其他','# 本模板示例为上传软件包和部署脚本到home目录\r\n# host、username、password可在参数管理中配置\r\n- name: 上传文件\r\n image: appleboy/drone-scp\r\n settings:\r\n host: \r\n from_secret: ip\r\n username: \r\n from_secret: name\r\n password: \r\n from_secret: pwd\r\n port: 22\r\n target: /home\r\n source: \r\n - target/*.jar\r\n - deploy.sh','2021-01-12 03:40:55','2021-03-05 06:22:22','其他','admin'),(17,'make-c','build','C','- name: 编译\r\n image: gcc\r\n commands:\r\n - ./configure\r\n - make','2021-01-15 01:19:38','2021-02-02 10:52:15','编译构建','admin'),(19,'make-c++','build','C++','- name: 编译构建\r\n image: gcc\r\n commands:\r\n - ./configure\r\n - make','2021-01-15 01:21:05','2021-01-15 01:21:05','编译构建','admin'),(20,'python','build','Python','- name: 编译构建\r\n image: python\r\n commands:\r\n - pip install -r requirements.txt','2021-01-15 01:22:36','2021-01-15 01:22:36','编译构建','admin'),(21,'Docker','build','Docker','# 构建Docker镜像并推送到仓库\r\n# 定义镜像Hub路径以及账号密码\r\n- name: Docker镜像构建\r\n image: plugins/docker\r\n settings:\r\n username: username\r\n password: pwd\r\n repo: repoUrl\r\n tags: latest','2021-01-15 01:23:16','2021-02-03 03:40:49','编译构建','admin'),(22,'空白模板','customize','customize','','2021-01-15 02:53:02','2021-01-15 02:53:02','其他','admin'),(25,'Go (with Gopath)','build','Go','- name: golang\r\n image: golang\r\n commands:\r\n - go get\r\n - go test','2021-02-03 00:57:32','2021-02-03 03:36:15','编译构建','admin'),(26,'PHP','build','PHP','- name: install\r\n image: composer
/*!40000 ALTER TABLE `ci_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `code_review_assignments`
--
DROP TABLE IF EXISTS `code_review_assignments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `code_review_assignments` (
`id` int NOT NULL AUTO_INCREMENT,
`issue_id` int DEFAULT NULL,
`change_id` int DEFAULT NULL,
`attachment_id` int DEFAULT NULL,
`file_path` varchar(255) DEFAULT NULL,
`rev` varchar(255) DEFAULT NULL,
`rev_to` varchar(255) DEFAULT NULL,
`action_type` varchar(255) DEFAULT NULL,
`changeset_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `code_review_assignments`
--
LOCK TABLES `code_review_assignments` WRITE;
/*!40000 ALTER TABLE `code_review_assignments` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_review_assignments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `code_review_project_settings`
--
DROP TABLE IF EXISTS `code_review_project_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `code_review_project_settings` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`tracker_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`hide_code_review_tab` tinyint(1) DEFAULT '0',
`auto_relation` int DEFAULT '1',
`assignment_tracker_id` int DEFAULT NULL,
`auto_assign` text,
`lock_version` int NOT NULL DEFAULT '0',
`tracker_in_review_dialog` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `code_review_project_settings`
--
LOCK TABLES `code_review_project_settings` WRITE;
/*!40000 ALTER TABLE `code_review_project_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_review_project_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `code_review_user_settings`
--
DROP TABLE IF EXISTS `code_review_user_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `code_review_user_settings` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL DEFAULT '0',
`mail_notification` int NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `code_review_user_settings`
--
LOCK TABLES `code_review_user_settings` WRITE;
/*!40000 ALTER TABLE `code_review_user_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_review_user_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `code_reviews`
--
DROP TABLE IF EXISTS `code_reviews`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `code_reviews` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`change_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`line` int DEFAULT NULL,
`updated_by_id` int DEFAULT NULL,
`lock_version` int NOT NULL DEFAULT '0',
`status_changed_from` int DEFAULT NULL,
`status_changed_to` int DEFAULT NULL,
`issue_id` int DEFAULT NULL,
`action_type` varchar(255) DEFAULT NULL,
`file_path` varchar(255) DEFAULT NULL,
`rev` varchar(255) DEFAULT NULL,
`rev_to` varchar(255) DEFAULT NULL,
`attachment_id` int DEFAULT NULL,
`file_count` int NOT NULL DEFAULT '0',
`diff_all` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `code_reviews`
--
LOCK TABLES `code_reviews` WRITE;
/*!40000 ALTER TABLE `code_reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_reviews` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `code_tests`
--
DROP TABLE IF EXISTS `code_tests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `code_tests` (
`id` int NOT NULL AUTO_INCREMENT,
`homework_id` int DEFAULT NULL,
`wait_time` int DEFAULT '0',
`language` int DEFAULT NULL,
`status` int DEFAULT NULL,
`time_used` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`student_work_id` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `code_tests`
--
LOCK TABLES `code_tests` WRITE;
/*!40000 ALTER TABLE `code_tests` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_tests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `comments`
--
DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `comments` (
`id` int NOT NULL AUTO_INCREMENT,
`commented_type` varchar(30) NOT NULL DEFAULT '',
`commented_id` int NOT NULL DEFAULT '0',
`author_id` int NOT NULL DEFAULT '0',
`comments` text,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`parent_id` int DEFAULT NULL,
`comments_count` int DEFAULT '0',
`reply_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_comments_on_commented_id_and_commented_type` (`commented_id`,`commented_type`),
KEY `index_comments_on_author_id` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `comments`
--
LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commit_issues`
--
DROP TABLE IF EXISTS `commit_issues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `commit_issues` (
`id` int NOT NULL AUTO_INCREMENT,
`commit_id` varchar(255) DEFAULT NULL,
`issue_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commit_issues`
--
LOCK TABLES `commit_issues` WRITE;
/*!40000 ALTER TABLE `commit_issues` DISABLE KEYS */;
/*!40000 ALTER TABLE `commit_issues` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commits`
--
DROP TABLE IF EXISTS `commits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `commits` (
`id` int NOT NULL AUTO_INCREMENT,
`repository_id` int DEFAULT NULL,
`version` varchar(255) DEFAULT NULL,
`committer` varchar(255) DEFAULT NULL,
`comments` text,
`committed_on` datetime DEFAULT NULL,
`project_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commits`
--
LOCK TABLES `commits` WRITE;
/*!40000 ALTER TABLE `commits` DISABLE KEYS */;
/*!40000 ALTER TABLE `commits` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `compose_projects`
--
DROP TABLE IF EXISTS `compose_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `compose_projects` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`compose_id` int DEFAULT NULL,
`position` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_compose_projects_on_user_id_and_project_id_and_compose_id` (`user_id`,`project_id`,`compose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `compose_projects`
--
LOCK TABLES `compose_projects` WRITE;
/*!40000 ALTER TABLE `compose_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `compose_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `compose_users`
--
DROP TABLE IF EXISTS `compose_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `compose_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`compose_id` int DEFAULT NULL,
`is_manager` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_compose_users_on_user_id_and_compose_id` (`user_id`,`compose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `compose_users`
--
LOCK TABLES `compose_users` WRITE;
/*!40000 ALTER TABLE `compose_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `compose_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `composes`
--
DROP TABLE IF EXISTS `composes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `composes` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` text,
`show_mode` int DEFAULT '0',
`compose_mode` tinyint(1) DEFAULT '0',
`compose_users_count` int DEFAULT '0',
`compose_projects_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_composes_on_user_id_and_show_mode_and_compose_mode` (`user_id`,`show_mode`,`compose_mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `composes`
--
LOCK TABLES `composes` WRITE;
/*!40000 ALTER TABLE `composes` DISABLE KEYS */;
/*!40000 ALTER TABLE `composes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `coo_imgs`
--
DROP TABLE IF EXISTS `coo_imgs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `coo_imgs` (
`id` int NOT NULL AUTO_INCREMENT,
`src_states` varchar(255) DEFAULT NULL,
`url_states` varchar(255) DEFAULT NULL,
`img_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`position` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `coo_imgs`
--
LOCK TABLES `coo_imgs` WRITE;
/*!40000 ALTER TABLE `coo_imgs` DISABLE KEYS */;
/*!40000 ALTER TABLE `coo_imgs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `coop_imgs`
--
DROP TABLE IF EXISTS `coop_imgs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `coop_imgs` (
`id` int NOT NULL AUTO_INCREMENT,
`src_states` varchar(255) DEFAULT NULL,
`url_states` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`img_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `coop_imgs`
--
LOCK TABLES `coop_imgs` WRITE;
/*!40000 ALTER TABLE `coop_imgs` DISABLE KEYS */;
/*!40000 ALTER TABLE `coop_imgs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cooperations`
--
DROP TABLE IF EXISTS `cooperations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cooperations` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`mail` varchar(255) DEFAULT NULL,
`qq` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cooperations`
--
LOCK TABLES `cooperations` WRITE;
/*!40000 ALTER TABLE `cooperations` DISABLE KEYS */;
/*!40000 ALTER TABLE `cooperations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `data_exceptions`
--
DROP TABLE IF EXISTS `data_exceptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `data_exceptions` (
`id` int NOT NULL AUTO_INCREMENT,
`message` varchar(255) DEFAULT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `data_exceptions`
--
LOCK TABLES `data_exceptions` WRITE;
/*!40000 ALTER TABLE `data_exceptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `data_exceptions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `department_members`
--
DROP TABLE IF EXISTS `department_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `department_members` (
`id` int NOT NULL AUTO_INCREMENT,
`department_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_department_members_on_department_id` (`department_id`),
KEY `index_department_members_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department_members`
--
LOCK TABLES `department_members` WRITE;
/*!40000 ALTER TABLE `department_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `department_members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `departments`
--
DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`school_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`is_auth` tinyint(1) DEFAULT '0',
`identifier` varchar(255) DEFAULT NULL,
`host_count` int DEFAULT '5',
`is_delete` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_departments_on_school_id` (`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `departments`
--
LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `diff_record_contents`
--
DROP TABLE IF EXISTS `diff_record_contents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `diff_record_contents` (
`id` bigint NOT NULL AUTO_INCREMENT,
`diff_record_id` bigint DEFAULT NULL,
`content` text,
PRIMARY KEY (`id`),
KEY `index_diff_record_contents_on_diff_record_id` (`diff_record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `diff_record_contents`
--
LOCK TABLES `diff_record_contents` WRITE;
/*!40000 ALTER TABLE `diff_record_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `diff_record_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `diff_records`
--
DROP TABLE IF EXISTS `diff_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `diff_records` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`container_id` bigint DEFAULT NULL,
`column_name` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_diff_records_on_user_id` (`user_id`),
KEY `index_diff_records_on_container_type_and_container_id` (`container_type`,`container_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `diff_records`
--
LOCK TABLES `diff_records` WRITE;
/*!40000 ALTER TABLE `diff_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `diff_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `documents`
--
DROP TABLE IF EXISTS `documents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `documents` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL DEFAULT '0',
`category_id` int NOT NULL DEFAULT '0',
`title` varchar(60) NOT NULL DEFAULT '',
`description` text,
`created_on` datetime DEFAULT NULL,
`user_id` int DEFAULT '0',
`is_public` int DEFAULT '1',
PRIMARY KEY (`id`),
KEY `documents_project_id` (`project_id`),
KEY `index_documents_on_category_id` (`category_id`),
KEY `index_documents_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `documents`
--
LOCK TABLES `documents` WRITE;
/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dts`
--
DROP TABLE IF EXISTS `dts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dts` (
`Num` int NOT NULL DEFAULT '0',
`Defect` varchar(50) DEFAULT NULL,
`Category` varchar(50) DEFAULT NULL,
`File` varchar(255) DEFAULT NULL,
`Method` varchar(255) DEFAULT NULL,
`Module` varchar(20) DEFAULT NULL,
`Variable` varchar(50) DEFAULT NULL,
`StartLine` int DEFAULT NULL,
`IPLine` int DEFAULT NULL,
`IPLineCode` varchar(200) DEFAULT NULL,
`Judge` varchar(15) DEFAULT NULL,
`Review` tinyint DEFAULT NULL,
`Description` varchar(255) DEFAULT NULL,
`PreConditions` longtext,
`TraceInfo` longtext,
`Code` longtext,
`project_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`id` int NOT NULL,
PRIMARY KEY (`Num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dts`
--
LOCK TABLES `dts` WRITE;
/*!40000 ALTER TABLE `dts` DISABLE KEYS */;
/*!40000 ALTER TABLE `dts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `editor_of_documents`
--
DROP TABLE IF EXISTS `editor_of_documents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `editor_of_documents` (
`id` int NOT NULL AUTO_INCREMENT,
`editor_id` int DEFAULT NULL,
`org_document_comment_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `editor_of_documents`
--
LOCK TABLES `editor_of_documents` WRITE;
/*!40000 ALTER TABLE `editor_of_documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `editor_of_documents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `edu_settings`
--
DROP TABLE IF EXISTS `edu_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `edu_settings` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_edu_settings_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `edu_settings`
--
LOCK TABLES `edu_settings` WRITE;
/*!40000 ALTER TABLE `edu_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `edu_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `enabled_modules`
--
DROP TABLE IF EXISTS `enabled_modules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enabled_modules` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`name` varchar(255) NOT NULL,
`course_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `enabled_modules_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `enabled_modules`
--
LOCK TABLES `enabled_modules` WRITE;
/*!40000 ALTER TABLE `enabled_modules` DISABLE KEYS */;
/*!40000 ALTER TABLE `enabled_modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `enumerations`
--
DROP TABLE IF EXISTS `enumerations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enumerations` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`position` int DEFAULT '1',
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(255) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`project_id` int DEFAULT NULL,
`parent_id` int DEFAULT NULL,
`position_name` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_enumerations_on_project_id` (`project_id`),
KEY `index_enumerations_on_id_and_type` (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `enumerations`
--
LOCK TABLES `enumerations` WRITE;
/*!40000 ALTER TABLE `enumerations` DISABLE KEYS */;
/*!40000 ALTER TABLE `enumerations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `error_checks`
--
DROP TABLE IF EXISTS `error_checks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `error_checks` (
`id` int NOT NULL AUTO_INCREMENT,
`game_indentifier` varchar(255) DEFAULT NULL,
`login` varchar(255) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `error_checks`
--
LOCK TABLES `error_checks` WRITE;
/*!40000 ALTER TABLE `error_checks` DISABLE KEYS */;
/*!40000 ALTER TABLE `error_checks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `evaluate_records`
--
DROP TABLE IF EXISTS `evaluate_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `evaluate_records` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`shixun_id` int DEFAULT NULL,
`game_id` int DEFAULT NULL,
`consume_time` float DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`file_update` float DEFAULT NULL,
`git_pull` float DEFAULT NULL,
`create_pod` float DEFAULT NULL,
`pod_execute` float DEFAULT NULL,
`student_work` float DEFAULT NULL,
`test_cases` float DEFAULT NULL,
`retry` float DEFAULT NULL,
`game_build` float DEFAULT NULL,
`return_back` float DEFAULT NULL,
`brige` float DEFAULT NULL,
`create_status` datetime DEFAULT NULL,
`front_js` float DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_evaluate_records_on_identifier` (`identifier`),
KEY `index_evaluate_records_on_game_id` (`game_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `evaluate_records`
--
LOCK TABLES `evaluate_records` WRITE;
/*!40000 ALTER TABLE `evaluate_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `evaluate_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faqs`
--
DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `faqs` (
`id` bigint NOT NULL AUTO_INCREMENT,
`question` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faqs`
--
LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `first_pages`
--
DROP TABLE IF EXISTS `first_pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `first_pages` (
`id` int NOT NULL AUTO_INCREMENT,
`web_title` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` text,
`page_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sort_type` int DEFAULT NULL,
`image_width` int DEFAULT '107',
`image_height` int DEFAULT '63',
`show_course` int DEFAULT '1',
`show_contest` int DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `first_pages`
--
LOCK TABLES `first_pages` WRITE;
/*!40000 ALTER TABLE `first_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `first_pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forge_applied_messages`
--
DROP TABLE IF EXISTS `forge_applied_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `forge_applied_messages` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`applied_type` varchar(255) DEFAULT NULL,
`applied_id` bigint DEFAULT NULL,
`viewed` int DEFAULT '0',
`status` int DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`applied_user_id` bigint DEFAULT NULL,
`role` int DEFAULT NULL,
`project_id` bigint DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_forge_applied_messages_on_user_id` (`user_id`),
KEY `index_forge_applied_messages_on_applied_type_and_applied_id` (`applied_type`,`applied_id`),
KEY `index_forge_applied_messages_on_applied_user_id` (`applied_user_id`),
KEY `index_forge_applied_messages_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forge_applied_messages`
--
LOCK TABLES `forge_applied_messages` WRITE;
/*!40000 ALTER TABLE `forge_applied_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `forge_applied_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forge_applied_projects`
--
DROP TABLE IF EXISTS `forge_applied_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `forge_applied_projects` (
`id` bigint NOT NULL AUTO_INCREMENT,
`project_id` bigint DEFAULT NULL,
`user_id` bigint DEFAULT NULL,
`role` int DEFAULT '0',
`status` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_forge_applied_projects_on_project_id` (`project_id`),
KEY `index_forge_applied_projects_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forge_applied_projects`
--
LOCK TABLES `forge_applied_projects` WRITE;
/*!40000 ALTER TABLE `forge_applied_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `forge_applied_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fork_users`
--
DROP TABLE IF EXISTS `fork_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fork_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`fork_project_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_fork_users_on_project_id` (`project_id`),
KEY `index_fork_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fork_users`
--
LOCK TABLES `fork_users` WRITE;
/*!40000 ALTER TABLE `fork_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `fork_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gitlab_urls`
--
DROP TABLE IF EXISTS `gitlab_urls`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gitlab_urls` (
`id` int NOT NULL AUTO_INCREMENT,
`myshixun_id` int DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`myshixun_identifier` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gitlab_urls`
--
LOCK TABLES `gitlab_urls` WRITE;
/*!40000 ALTER TABLE `gitlab_urls` DISABLE KEYS */;
/*!40000 ALTER TABLE `gitlab_urls` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups_users`
--
DROP TABLE IF EXISTS `groups_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `groups_users` (
`group_id` int NOT NULL,
`user_id` int NOT NULL,
UNIQUE KEY `groups_users_ids` (`group_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups_users`
--
LOCK TABLES `groups_users` WRITE;
/*!40000 ALTER TABLE `groups_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `groups_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `homepages`
--
DROP TABLE IF EXISTS `homepages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `homepages` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`article_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_homepages_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `homepages`
--
LOCK TABLES `homepages` WRITE;
/*!40000 ALTER TABLE `homepages` DISABLE KEYS */;
/*!40000 ALTER TABLE `homepages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ignores`
--
DROP TABLE IF EXISTS `ignores`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ignores` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`content` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ignores`
--
LOCK TABLES `ignores` WRITE;
/*!40000 ALTER TABLE `ignores` DISABLE KEYS */;
INSERT INTO `ignores` VALUES (1,'OCaml','*.annot\n*.cmo\n*.cma\n*.cmi\n*.a\n*.o\n*.cmx\n*.cmxs\n*.cmxa\n\n# ocamlbuild working directory\n_build/\n\n# ocamlbuild targets\n*.byte\n*.native\n\n# oasis generated files\nsetup.data\nsetup.log\n\n# Merlin configuring file for Vim and Emacs\n.merlin\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(2,'Redcar','.redcar\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(3,'Scheme','*.ss~\n*.ss#*\n.#*.ss\n\n*.scm~\n*.scm#*\n.#*.scm\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(4,'XilinxISE','# intermediate build files\n*.bgn\n*.bit\n*.bld\n*.cmd_log\n*.drc\n*.ll\n*.lso\n*.msd\n*.msk\n*.ncd\n*.ngc\n*.ngd\n*.ngr\n*.pad\n*.par\n*.pcf\n*.prj\n*.ptwx\n*.rbb\n*.rbd\n*.stx\n*.syr\n*.twr\n*.twx\n*.unroutes\n*.ut\n*.xpi\n*.xst\n*_bitgen.xwbt\n*_envsettings.html\n*_map.map\n*_map.mrp\n*_map.ngm\n*_map.xrpt\n*_ngdbuild.xrpt\n*_pad.csv\n*_pad.txt\n*_par.xrpt\n*_summary.html\n*_summary.xml\n*_usage.xml\n*_xst.xrpt\n\n# iMPACT generated files\n_impactbatch.log\nimpact.xsl\nimpact_impact.xwbt\nise_impact.cmd\nwebtalk_impact.xml\n\n# Core Generator generated files\nxaw2verilog.log\n\n# project-wide generated files\n*.gise\npar_usage_statistics.html\nusage_statistics_webtalk.html\nwebtalk.log\nwebtalk_pn.xml\n\n# generated folders\niseconfig/\nxlnx_auto_0_xdb/\nxst/\n_ngo/\n_xmsgs/\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(5,'Xcode','# Xcode\n#\n# gitignore contributors: remember to update Global/Xcode.gitignore, Objective-C.gitignore & Swift.gitignore\n\n## Build generated\nbuild/\nDerivedData/\n\n## Various settings\n*.pbxuser\n!default.pbxuser\n*.mode1v3\n!default.mode1v3\n*.mode2v3\n!default.mode2v3\n*.perspectivev3\n!default.perspectivev3\nxcuserdata/\n\n## Other\n*.moved-aside\n*.xccheckout\n*.xcscmblueprint\n\n## Obj-C/Swift specific\n*.hmap\n*.ipa\n*.dSYM.zip\n*.dSYM\n\n## Playgrounds\ntimeline.xctimeline\nplayground.xcworkspace\n\n# Swift Package Manager\n#\n# Add this line if you want to avoid checking in source code from Swift Package Manager dependencies.\n# Packages/\n# Package.pins\n# Package.resolved\n.build/\n\n# CocoaPods\n#\n# We recommend against adding the Pods directory to your .gitignore. However\n# you should judge for yourself, the pros and cons are mentioned at:\n# https://guides.cocoapods.org/using/using-cocoapods.html#should-i-check-the-pods-directory-into-source-control\n#\n# Pods/\n#\n# Add this line if you want to avoid checking in source code from the Xcode workspace\n# *.xcworkspace\n\n# Carthage\n#\n# Add this line if you want to avoid checking in source code from Carthage dependencies.\n# Carthage/Checkouts\n\nCarthage/Build\n\n# fastlane\n#\n# It is recommended to not store the screenshots in the git repo. Instead, use fastlane to re-generate the\n# screenshots whenever they are needed.\n# For more information about the recommended setup visit:\n# https://docs.fastlane.tools/best-practices/source-control/#source-control\n\nfastlane/report.xml\nfastlane/Preview.html\nfastlane/screenshots/**/*.png\nfastlane/test_output\n\n# Code Injection\n#\n# After new code Injection tools there\'s a generated folder /iOSInjectionProject\n# https://github.com/johnno1962/injectionforxcode\n\niOSInjectionProject/\n\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(6,'Ada','# Object file\n*.o\n\n# Ada Library Information\n*.ali\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(7,'Gcov','# gcc coverage testing tool files\n\n*.gcno\n*.gcda\n*.gcov\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(8,'SVN','.svn/\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(9,'Scrivener','/Files/binder.autosave\n/Files/binder.backup\n/Files/search.indexes\n/Files/user.lock\n/Files/Docs/docs.checksum\n/QuickLook/\n/Settings/ui.plist\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(10,'Vim','# Swap\n[._]*.s[a-v][a-z]\n[._]*.sw[a-p]\n[._]s[a-rt-v][a-z]\n[._]ss[a-gi-z]\n[._]sw[a-p]\n\n# Session\nSession.vim\n\n# Temporary\n.netrwhist\n*~\n# Auto-generated tag files\ntags\n# Persistent undo\n[._]*.un~\n','2021-08-27 08:51:43','2021-08-27 08:51:43'),(11,'RhodesRhomobile','rholog-*\nsim-*\nbin/libs\nb
/*!40000 ALTER TABLE `ignores` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invite_lists`
--
DROP TABLE IF EXISTS `invite_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invite_lists` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`mail` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invite_lists`
--
LOCK TABLES `invite_lists` WRITE;
/*!40000 ALTER TABLE `invite_lists` DISABLE KEYS */;
/*!40000 ALTER TABLE `invite_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_depends`
--
DROP TABLE IF EXISTS `issue_depends`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_depends` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`issue_id` int DEFAULT NULL,
`depend_issue_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_depends_on_user_id_and_issue_id_and_depend_issue_id` (`user_id`,`issue_id`,`depend_issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_depends`
--
LOCK TABLES `issue_depends` WRITE;
/*!40000 ALTER TABLE `issue_depends` DISABLE KEYS */;
/*!40000 ALTER TABLE `issue_depends` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_priorities`
--
DROP TABLE IF EXISTS `issue_priorities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_priorities` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`position` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_priorities_on_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_priorities`
--
LOCK TABLES `issue_priorities` WRITE;
/*!40000 ALTER TABLE `issue_priorities` DISABLE KEYS */;
INSERT INTO `issue_priorities` VALUES (1,'低',1,'2021-08-27 08:51:44','2021-08-27 08:51:44'),(2,'正常',2,'2021-08-27 08:51:44','2021-08-27 08:51:44'),(3,'高',3,'2021-08-27 08:51:44','2021-08-27 08:51:44'),(4,'紧急',4,'2021-08-27 08:51:44','2021-08-27 08:51:44'),(5,'立刻',5,'2021-08-27 08:51:44','2021-08-27 08:51:44');
/*!40000 ALTER TABLE `issue_priorities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_relations`
--
DROP TABLE IF EXISTS `issue_relations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_relations` (
`id` int NOT NULL AUTO_INCREMENT,
`issue_from_id` int NOT NULL,
`issue_to_id` int NOT NULL,
`relation_type` varchar(255) NOT NULL DEFAULT '',
`delay` int DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_issue_relations_on_issue_from_id_and_issue_to_id` (`issue_from_id`,`issue_to_id`),
KEY `index_issue_relations_on_issue_from_id` (`issue_from_id`),
KEY `index_issue_relations_on_issue_to_id` (`issue_to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_relations`
--
LOCK TABLES `issue_relations` WRITE;
/*!40000 ALTER TABLE `issue_relations` DISABLE KEYS */;
/*!40000 ALTER TABLE `issue_relations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_statuses`
--
DROP TABLE IF EXISTS `issue_statuses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_statuses` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`is_closed` tinyint(1) NOT NULL DEFAULT '0',
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`position` int DEFAULT '1',
`default_done_ratio` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_statuses_on_position` (`position`),
KEY `index_issue_statuses_on_is_closed` (`is_closed`),
KEY `index_issue_statuses_on_is_default` (`is_default`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_statuses`
--
LOCK TABLES `issue_statuses` WRITE;
/*!40000 ALTER TABLE `issue_statuses` DISABLE KEYS */;
INSERT INTO `issue_statuses` VALUES (1,'新增',0,1,1,NULL),(2,'正在解决',0,0,2,NULL),(3,'已解决',0,0,3,NULL),(4,'反馈',0,0,4,NULL),(5,'关闭',1,0,5,NULL),(6,'拒绝',0,0,6,NULL);
/*!40000 ALTER TABLE `issue_statuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_tags`
--
DROP TABLE IF EXISTS `issue_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_tags` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`color` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`issues_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`gid` int DEFAULT NULL,
`gitea_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_tags_on_user_id_and_name_and_project_id` (`user_id`,`name`,`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_tags`
--
LOCK TABLES `issue_tags` WRITE;
/*!40000 ALTER TABLE `issue_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `issue_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_tags_relates`
--
DROP TABLE IF EXISTS `issue_tags_relates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_tags_relates` (
`id` bigint NOT NULL AUTO_INCREMENT,
`issue_id` int DEFAULT NULL,
`issue_tag_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_tags_relates_on_issue_id_and_issue_tag_id` (`issue_id`,`issue_tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_tags_relates`
--
LOCK TABLES `issue_tags_relates` WRITE;
/*!40000 ALTER TABLE `issue_tags_relates` DISABLE KEYS */;
/*!40000 ALTER TABLE `issue_tags_relates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issue_times`
--
DROP TABLE IF EXISTS `issue_times`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issue_times` (
`id` bigint NOT NULL AUTO_INCREMENT,
`issue_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`start_time` datetime DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`cost_time` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_issue_times_on_issue_id_and_user_id` (`issue_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issue_times`
--
LOCK TABLES `issue_times` WRITE;
/*!40000 ALTER TABLE `issue_times` DISABLE KEYS */;
/*!40000 ALTER TABLE `issue_times` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issues`
--
DROP TABLE IF EXISTS `issues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `issues` (
`id` int NOT NULL AUTO_INCREMENT,
`tracker_id` int NOT NULL,
`project_id` int NOT NULL,
`subject` varchar(255) NOT NULL DEFAULT '',
`description` longtext,
`due_date` date DEFAULT NULL,
`category_id` int DEFAULT NULL,
`status_id` int NOT NULL,
`assigned_to_id` int DEFAULT NULL,
`priority_id` int NOT NULL,
`fixed_version_id` int DEFAULT NULL,
`author_id` int NOT NULL,
`created_on` datetime DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`start_date` date DEFAULT NULL,
`done_ratio` int NOT NULL DEFAULT '0',
`estimated_hours` float DEFAULT NULL,
`parent_id` int DEFAULT NULL,
`root_id` int DEFAULT NULL,
`lft` int DEFAULT NULL,
`rgt` int DEFAULT NULL,
`is_private` tinyint(1) NOT NULL DEFAULT '0',
`closed_on` datetime DEFAULT NULL,
`project_issues_index` int DEFAULT NULL,
`issue_type` varchar(255) DEFAULT NULL,
`token` int DEFAULT '0',
`issue_tags_value` varchar(255) DEFAULT NULL,
`is_lock` tinyint(1) DEFAULT '0',
`issue_classify` varchar(255) DEFAULT NULL,
`ref_name` varchar(255) DEFAULT NULL,
`branch_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `issues_project_id` (`project_id`),
KEY `index_issues_on_status_id` (`status_id`),
KEY `index_issues_on_category_id` (`category_id`),
KEY `index_issues_on_assigned_to_id` (`assigned_to_id`),
KEY `index_issues_on_fixed_version_id` (`fixed_version_id`),
KEY `index_issues_on_tracker_id` (`tracker_id`),
KEY `index_issues_on_priority_id` (`priority_id`),
KEY `index_issues_on_author_id` (`author_id`),
KEY `index_issues_on_created_on` (`created_on`),
KEY `index_issues_on_root_id_and_lft_and_rgt` (`root_id`,`lft`,`rgt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issues`
--
LOCK TABLES `issues` WRITE;
/*!40000 ALTER TABLE `issues` DISABLE KEYS */;
/*!40000 ALTER TABLE `issues` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `journal_details`
--
DROP TABLE IF EXISTS `journal_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `journal_details` (
`id` int NOT NULL AUTO_INCREMENT,
`journal_id` int NOT NULL DEFAULT '0',
`property` varchar(30) NOT NULL DEFAULT '',
`prop_key` varchar(30) NOT NULL DEFAULT '',
`old_value` text,
`value` text,
PRIMARY KEY (`id`),
KEY `journal_details_journal_id` (`journal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `journal_details`
--
LOCK TABLES `journal_details` WRITE;
/*!40000 ALTER TABLE `journal_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `journal_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `journal_replies`
--
DROP TABLE IF EXISTS `journal_replies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `journal_replies` (
`journal_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`reply_id` int DEFAULT NULL,
KEY `index_journal_replies_on_user_id` (`user_id`),
KEY `index_journal_replies_on_journal_id` (`journal_id`),
KEY `index_journal_replies_on_reply_id` (`reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `journal_replies`
--
LOCK TABLES `journal_replies` WRITE;
/*!40000 ALTER TABLE `journal_replies` DISABLE KEYS */;
/*!40000 ALTER TABLE `journal_replies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `journals`
--
DROP TABLE IF EXISTS `journals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `journals` (
`id` int NOT NULL AUTO_INCREMENT,
`journalized_id` int NOT NULL DEFAULT '0',
`journalized_type` varchar(30) NOT NULL DEFAULT '',
`user_id` int NOT NULL DEFAULT '0',
`notes` text,
`created_on` datetime NOT NULL,
`private_notes` tinyint(1) NOT NULL DEFAULT '0',
`parent_id` int DEFAULT NULL,
`comments_count` int DEFAULT '0',
`reply_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `journals_journalized_id` (`journalized_id`,`journalized_type`),
KEY `index_journals_on_user_id` (`user_id`),
KEY `index_journals_on_journalized_id` (`journalized_id`),
KEY `index_journals_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `journals`
--
LOCK TABLES `journals` WRITE;
/*!40000 ALTER TABLE `journals` DISABLE KEYS */;
/*!40000 ALTER TABLE `journals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `journals_for_messages`
--
DROP TABLE IF EXISTS `journals_for_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `journals_for_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`jour_id` int DEFAULT NULL,
`jour_type` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`notes` text,
`status` int DEFAULT NULL,
`reply_id` int DEFAULT NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`m_parent_id` varchar(255) DEFAULT NULL,
`is_readed` tinyint(1) DEFAULT NULL,
`m_reply_count` int DEFAULT NULL,
`m_reply_id` int DEFAULT NULL,
`is_comprehensive_evaluation` int DEFAULT NULL,
`private` int DEFAULT '0',
`root_id` int DEFAULT NULL,
`hidden` tinyint(1) DEFAULT '0',
`praises_count` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_journals_for_messages_on_root_id` (`root_id`),
KEY `index_journals_for_messages_on_jour_id` (`jour_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `journals_for_messages`
--
LOCK TABLES `journals_for_messages` WRITE;
/*!40000 ALTER TABLE `journals_for_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `journals_for_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kindeditor_assets`
--
DROP TABLE IF EXISTS `kindeditor_assets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kindeditor_assets` (
`id` int NOT NULL AUTO_INCREMENT,
`asset` varchar(255) DEFAULT NULL,
`file_size` int DEFAULT NULL,
`file_type` varchar(255) DEFAULT NULL,
`owner_id` int DEFAULT NULL,
`asset_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`owner_type` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kindeditor_assets`
--
LOCK TABLES `kindeditor_assets` WRITE;
/*!40000 ALTER TABLE `kindeditor_assets` DISABLE KEYS */;
/*!40000 ALTER TABLE `kindeditor_assets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `laboratories`
--
DROP TABLE IF EXISTS `laboratories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `laboratories` (
`id` bigint NOT NULL AUTO_INCREMENT,
`school_id` bigint DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sync_course` tinyint(1) DEFAULT '0',
`sync_subject` tinyint(1) DEFAULT '0',
`sync_shixun` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_laboratories_on_identifier` (`identifier`),
KEY `index_laboratories_on_school_id` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `laboratories`
--
LOCK TABLES `laboratories` WRITE;
/*!40000 ALTER TABLE `laboratories` DISABLE KEYS */;
INSERT INTO `laboratories` VALUES (1,NULL,'www','2019-10-16 15:16:11','2019-10-16 15:16:11',0,0,0);
/*!40000 ALTER TABLE `laboratories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `laboratory_settings`
--
DROP TABLE IF EXISTS `laboratory_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `laboratory_settings` (
`id` bigint NOT NULL AUTO_INCREMENT,
`laboratory_id` bigint DEFAULT NULL,
`config` text,
PRIMARY KEY (`id`),
KEY `index_laboratory_settings_on_laboratory_id` (`laboratory_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `laboratory_settings`
--
LOCK TABLES `laboratory_settings` WRITE;
/*!40000 ALTER TABLE `laboratory_settings` DISABLE KEYS */;
整理sql
2023-09-06 16:05:12 +08:00
INSERT INTO `laboratory_settings` VALUES (1,1,'{\"name\":\"EduCoder\",\"navbar\":[{\"name\":\"实践课程\",\"link\":\"/paths\",\"hidden\":false},{\"name\":\"翻转课堂\",\"link\":\"/courses\",\"hidden\":false},{\"name\":\"实现项目\",\"link\":\"/shixuns\",\"hidden\":false},{\"name\":\"在线竞赛\",\"link\":\"/competitions\",\"hidden\":false},{\"name\":\"教学案例\",\"link\":\"/moop_cases\",\"hidden\":false},{\"name\":\"交流问答\",\"link\":\"/forums\",\"hidden\":false}],\"footer\":\"\\n\\u003cp class=\\\"footer_con-p inline lineh-30 font-14\\\"\\u003e\\n \\u003cspan class=\\\"font-18 fl\\\"\\u003e©\\u003c/span\\u003e\\u0026nbsp;2019\\u0026nbsp;EduCoder\\n \\u003ca target=\\\"_blank\\\" href=\\\"http://beian.miit.gov.cn/\\\" class=\\\"ml15 mr15\\\" style=\\\"color: rgb(136, 136, 136);\\\"\\u003e湘ICP备17009477号\\u003c/a\\u003e\\n \\u003ca target=\\\"_blank\\\" href=\\\"http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=43019002000962\\\" class=\\\"mr15\\\" style=\\\"color: rgb(136, 136, 136);\\\"\\u003e\\n \\u003cimg class=\\\"vertical4\\\" src=\\\"https://ali-cdn.educoder.net/react/build/static/media/beian.d0289dc0.png\\\"\\u003e湘公网安备43019002000962号\\n \\u003c/a\\u003e\\n \\u003ca href=\\\"https://team.trustie.net\\\" target=\\\"_blank\\\" style=\\\"color: rgb(136, 136, 136);\\\"\\u003eTrustie\\u003c/a\\u003e\\n \\u0026nbsp;\\u0026nbsp;\\u0026nbsp;\\u0026amp;\\u0026nbsp;\\u0026nbsp;\\u0026nbsp;IntelliDE inside.\\n \\u003cspan class=\\\"mr15\\\"\\u003e版权所有 XXXX有限公司\\u003c/span\\u003e\\u003c/p\\u003e\\n \"}');
整理初始菜单sql
2023-05-29 18:18:00 +08:00
/*!40000 ALTER TABLE `laboratory_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `laboratory_users`
--
DROP TABLE IF EXISTS `laboratory_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `laboratory_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`laboratory_id` bigint DEFAULT NULL,
`user_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_laboratory_users_on_laboratory_id` (`laboratory_id`),
KEY `index_laboratory_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `laboratory_users`
--
LOCK TABLES `laboratory_users` WRITE;
/*!40000 ALTER TABLE `laboratory_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `laboratory_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `licenses`
--
DROP TABLE IF EXISTS `licenses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `licenses` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`content` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=361 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `licenses`
--
LOCK TABLES `licenses` WRITE;
/*!40000 ALTER TABLE `licenses` DISABLE KEYS */;
INSERT INTO `licenses` VALUES (1,'OSL-2.1','The Open Software Licensev. 2.1\n\nThis Open Software License (the \"License\") applies to any original work of\nauthorship (the \"Original Work\") whose owner (the \"Licensor\") has placed the\nfollowing notice immediately following the copyright notice for the Original\nWork:\n\nLicensed under the Open Software License version 2.1\n\n1) Grant of Copyright License. Licensor hereby grants You a world-wide, royalty-free,\nnon-exclusive, perpetual, sublicenseable license to do the following:\n\n a) to reproduce the Original Work in copies;\n\nb) to prepare derivative works (\"Derivative Works\") based upon the Original\nWork;\n\nc) to distribute copies of the Original Work and Derivative Works to the public,\nwith the proviso that copies of Original Work or Derivative Works that You\ndistribute shall be licensed under the Open Software License;\n\n d) to perform the Original Work publicly; and\n\n e) to display the Original Work publicly.\n\n2) Grant of Patent License. Licensor hereby grants You a world-wide, royalty-free,\nnon-exclusive, perpetual, sublicenseable license, under patent claims owned\nor controlled by the Licensor that are embodied in the Original Work as furnished\nby the Licensor, to make, use, sell and offer for sale the Original Work and\nDerivative Works.\n\n3) Grant of Source Code License. The term \"Source Code\" means the preferred\nform of the Original Work for making modifications to it and all available\ndocumentation describing how to modify the Original Work. Licensor hereby\nagrees to provide a machine-readable copy of the Source Code of the Original\nWork along with each copy of the Original Work that Licensor distributes.\nLicensor reserves the right to satisfy this obligation by placing a machine-readable\ncopy of the Source Code in an information repository reasonably calculated\nto permit inexpensive and convenient access by You for as long as Licensor\ncontinues to distribute the Original Work, and by publishing the address of\nthat information repository in a notice immediately following the copyright\nnotice that applies to the Original Work.\n\n4) Exclusions From License Grant. Neither the names of Licensor, nor the names\nof any contributors to the Original Work, nor any of their trademarks or service\nmarks, may be used to endorse or promote products derived from this Original\nWork without express prior written permission of the Licensor. Nothing in\nthis License shall be deemed to grant any rights to trademarks, copyrights,\npatents, trade secrets or any other intellectual property of Licensor except\nas expressly stated herein. No patent license is granted to make, use, sell\nor offer to sell embodiments of any patent claims other than the licensed\nclaims defined in Section 2. No right is granted to the trademarks of Licensor\neven if such marks are included in the Original Work. Nothing in this License\nshall be interpreted to prohibit Licensor from licensing under different terms\nfrom this License any Original Work that Licensor otherwise would have a right\nto license.\n\n5) External Deployment. The term \"External Deployment\" means the use or distribution\nof the Original Work or Derivative Works in any way such that the Original\nWork or Derivative Works may be used by anyone other than You, whether the\nOriginal Work or Derivative Works are distributed to those persons or made\navailable as an application intended for use over a computer network. As an\nexpress condition for the grants of license hereunder, You agree that any\nExternal Deployment by You of a Derivative Work shall be deemed a distribution\nand shall be licensed to all under the terms of this License, as prescribed\nin section 1(c) herein.\n\n6) Attribution Rights. You must retain, in the Source Code of any Derivative\nWorks that You create, all copyright, patent or trademark notices from the\nSource Code of the Original Work, as well as any notices of licensing and\nany descriptive text identified therein as an \"Attribution Notice.\" You must\nca
INSERT INTO `licenses` VALUES (125,'CECILL-B','CeCILL-B FREE SOFTWARE LICENSE AGREEMENT Notice\n\nThis Agreement is a Free Software license agreement that is the result of\ndiscussions between its authors in order to ensure compliance with the two\nmain principles guiding its drafting:\n\n* firstly, compliance with the principles governing the distribution of Free\nSoftware: access to source code, broad rights granted to users,\n\n* secondly, the election of a governing law, French law, with which it is\nconformant, both as regards the law of torts and intellectual property law,\nand the protection that it offers to both authors and holders of the economic\nrights over software.\n\nThe authors of the CeCILL¹ license are:\n\n \n\nCommissariat à l\'Energie Atomique - CEA, a public scientific, technical and\nindustrial research establishment, having its principal place of business\nat 25 rue Leblanc, immeuble Le Ponant D, 75015 Paris, France.\n\n \n\nCentre National de la Recherche Scientifique - CNRS, a public scientific and\ntechnological establishment, having its principal place of business at 3 rue\nMichel-Ange, 75794 Paris cedex 16, France.\n\n \n\nInstitut National de Recherche en Informatique et en Automatique - INRIA,\na public scientific and technological establishment, having its principal\nplace of business at Domaine de Voluceau, Rocquencourt, BP 105, 78153 Le Chesnay\ncedex, France.\n\nPreamble This Agreement is an open source software license intended to give\nusers significant freedom to modify and redistribute the software licensed\nhereunder.\n\nThe exercising of this freedom is conditional upon a strong obligation of\ngiving credits for everybody that distributes a software incorporating a software\nruled by the current license so as all contributions to be properly identified\nand acknowledged.\n\nIn consideration of access to the source code and the rights to copy, modify\nand redistribute granted by the license, users are provided only with a limited\nwarranty and the software\'s author, the holder of the economic rights, and\nthe successive licensors only have limited liability.\n\nIn this respect, the risks associated with loading, using, modifying and/or\ndeveloping or reproducing the software by the user are brought to the user\'s\nattention, given its Free Software status, which may make it complicated to\nuse, with the result that its use is reserved for developers and experienced\nprofessionals having in-depth computer knowledge. Users are therefore encouraged\nto load and test the suitability of the software as regards their requirements\nin conditions enabling the security of their systems and/or data to be ensured\nand, more generally, to use and operate it in the same conditions of security.\nThis Agreement may be freely reproduced and published, provided it is not\naltered, and that no provisions are either added or removed herefrom.\n\nThis Agreement may apply to any or all software for which the holder of the\neconomic rights decides to submit the use thereof to its provisions.\n\n Article 1 - DEFINITIONS\n\nFor the purpose of this Agreement, when the following expressions commence\nwith a capital letter, they shall have the following meaning:\n\n \n\nAgreement: means this license agreement, and its possible subsequent versions\nand annexes.\n\n \n\nSoftware: means the software in its Object Code and/or Source Code form and,\nwhere applicable, its documentation, \"as is\" when the Licensee accepts the\nAgreement.\n\n \n\nInitial Software: means the Software in its Source Code and possibly its Object\nCode form and, where applicable, its documentation, \"as is\" when it is first\ndistributed under the terms and conditions of the Agreement.\n\n \n\nModified Software: means the Software modified by at least one Contribution.\n\n \n\nSource Code: means all the Software\'s instructions and program lines to which\naccess is required so as to modify the Software.\n\n \n\nObject Code: means the binary files originating from the compilation of the\nSource Co
INSERT INTO `licenses` VALUES (261,'ODbL-1.0','ODC Open Database License (ODbL) Preamble\n\nThe Open Database License (ODbL) is a license agreement intended to allow\nusers to freely share, modify, and use this Database while maintaining this\nsame freedom for others. Many databases are covered by copyright, and therefore\nthis document licenses these rights. Some jurisdictions, mainly in the European\nUnion, have specific rights that cover databases, and so the ODbL addresses\nthese rights, too. Finally, the ODbL is also an agreement in contract for\nusers of this Database to act in certain ways in return for accessing this\nDatabase.\n\nDatabases can contain a wide variety of types of content (images, audiovisual\nmaterial, and sounds all in the same database, for example), and so the ODbL\nonly governs the rights over the Database, and not the contents of the Database\nindividually. Licensors should use the ODbL together with another license\nfor the contents, if the contents have a single set of rights that uniformly\ncovers all of the contents. If the contents have multiple sets of different\nrights, Licensors should describe what rights govern what contents together\nin the individual record or in some other way that clarifies what rights apply.\n\nSometimes the contents of a database, or the database itself, can be covered\nby other rights not addressed here (such as private contracts, trade mark\nover the name, or privacy rights / data protection rights over information\nin the contents), and so you are advised that you may have to consult other\ndocuments or clear other rights before doing activities not covered by this\nLicense.\n\n------\n\nThe Licensor (as defined below)\n\nand\n\nYou (as defined below)\n\nagree as follows:\n\n 1.0 Definitions of Capitalised Words\n\n\"Collective Database\" - Means this Database in unmodified form as part of\na collection of independent databases in themselves that together are assembled\ninto a collective whole. A work that constitutes a Collective Database will\nnot be considered a Derivative Database.\n\n\"Convey\" - As a verb, means Using the Database, a Derivative Database, or\nthe Database as part of a Collective Database in any way that enables a Person\nto make or receive copies of the Database or a Derivative Database. Conveying\ndoes not include interaction with a user through a computer network, or creating\nand Using a Produced Work, where no transfer of a copy of the Database or\na Derivative Database occurs.\n\n\"Contents\" - The contents of this Database, which includes the information,\nindependent works, or other material collected into the Database. For example,\nthe contents of the Database could be factual data or works such as images,\naudiovisual material, text, or sounds.\n\n\"Database\" - A collection of material (the Contents) arranged in a systematic\nor methodical way and individually accessible by electronic or other means\noffered under the terms of this License.\n\n\"Database Directive\" - Means Directive 96/9/EC of the European Parliament\nand of the Council of 11 March 1996 on the legal protection of databases,\nas amended or succeeded.\n\n\"Database Right\" - Means rights resulting from the Chapter III (\"sui generis\")\nrights in the Database Directive (as amended and as transposed by member states),\nwhich includes the Extraction and Re-utilisation of the whole or a Substantial\npart of the Contents, as well as any similar rights available in the relevant\njurisdiction under Section 10.4.\n\n\"Derivative Database\" - Means a database based upon the Database, and includes\nany translation, adaptation, arrangement, modification, or any other alteration\nof the Database or of a Substantial part of the Contents. This includes, but\nis not limited to, Extracting or Re-utilising the whole or a Substantial part\nof the Contents in a new Database.\n\n\"Extraction\" - Means the permanent or temporary transfer of all or a Substantial\npart of the Contents to another medium by any means or in any form.\n\n\"License\" - Means this license agreement a
/*!40000 ALTER TABLE `licenses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mark_downs`
--
DROP TABLE IF EXISTS `mark_downs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mark_downs` (
`id` int NOT NULL AUTO_INCREMENT,
`description` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mark_downs`
--
LOCK TABLES `mark_downs` WRITE;
/*!40000 ALTER TABLE `mark_downs` DISABLE KEYS */;
/*!40000 ALTER TABLE `mark_downs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `member_roles`
--
DROP TABLE IF EXISTS `member_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `member_roles` (
`id` int NOT NULL AUTO_INCREMENT,
`member_id` int NOT NULL,
`role_id` int NOT NULL,
`inherited_from` int DEFAULT NULL,
`is_current` int DEFAULT '1',
PRIMARY KEY (`id`),
KEY `index_member_roles_on_member_id` (`member_id`),
KEY `index_member_roles_on_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `member_roles`
--
LOCK TABLES `member_roles` WRITE;
/*!40000 ALTER TABLE `member_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `member_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `members`
--
DROP TABLE IF EXISTS `members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `members` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL DEFAULT '0',
`project_id` int DEFAULT '0',
`created_on` datetime DEFAULT NULL,
`mail_notification` tinyint(1) NOT NULL DEFAULT '0',
`course_id` int DEFAULT '-1',
`course_group_id` int DEFAULT '0',
`is_collect` int DEFAULT '1',
`graduation_group_id` int DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_members_on_user_id_and_project_id` (`user_id`,`project_id`,`course_id`),
KEY `index_members_on_user_id` (`user_id`),
KEY `index_members_on_project_id` (`project_id`),
KEY `index_members_on_course_id` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `members`
--
LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;
/*!40000 ALTER TABLE `members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_migrate_errors`
--
DROP TABLE IF EXISTS `mirror_migrate_errors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_migrate_errors` (
`id` int NOT NULL AUTO_INCREMENT,
`shixun_id` int DEFAULT NULL,
`game_info` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_migrate_errors`
--
LOCK TABLES `mirror_migrate_errors` WRITE;
/*!40000 ALTER TABLE `mirror_migrate_errors` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_migrate_errors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_operation_records`
--
DROP TABLE IF EXISTS `mirror_operation_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_operation_records` (
`id` int NOT NULL AUTO_INCREMENT,
`mirror_repository_id` int DEFAULT NULL,
`mirror_id` text,
`mirror_name` text,
`status` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_id` int DEFAULT NULL,
`old_tag` varchar(255) DEFAULT NULL,
`new_tag` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_operation_records`
--
LOCK TABLES `mirror_operation_records` WRITE;
/*!40000 ALTER TABLE `mirror_operation_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_operation_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_repositories`
--
DROP TABLE IF EXISTS `mirror_repositories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_repositories` (
`id` int NOT NULL AUTO_INCREMENT,
`mirrorID` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`main_type` varchar(255) DEFAULT NULL,
`description` text,
`status` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type_name` text,
`script_template` longtext,
`resource_limit` int DEFAULT '10000',
`memory_limit` int DEFAULT '1024',
`cpu_limit` tinyint DEFAULT '1',
`time_limit` int DEFAULT '120',
`should_compile` tinyint(1) DEFAULT NULL,
`repertoire_id` int DEFAULT NULL,
`sub_repertoire_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_repositories`
--
LOCK TABLES `mirror_repositories` WRITE;
/*!40000 ALTER TABLE `mirror_repositories` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_repositories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_repository_types`
--
DROP TABLE IF EXISTS `mirror_repository_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_repository_types` (
`id` int NOT NULL AUTO_INCREMENT,
`mirror_type_id` int DEFAULT NULL,
`mirror_repository_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_mirror_repository_types_on_mirror_type_id` (`mirror_type_id`),
KEY `index_mirror_repository_types_on_mirror_repository_id` (`mirror_repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_repository_types`
--
LOCK TABLES `mirror_repository_types` WRITE;
/*!40000 ALTER TABLE `mirror_repository_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_repository_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_scripts`
--
DROP TABLE IF EXISTS `mirror_scripts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_scripts` (
`id` int NOT NULL AUTO_INCREMENT,
`mirror_repository_id` int DEFAULT NULL,
`script` longtext,
`script_type` varchar(255) DEFAULT NULL,
`description` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_scripts`
--
LOCK TABLES `mirror_scripts` WRITE;
/*!40000 ALTER TABLE `mirror_scripts` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_scripts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_types`
--
DROP TABLE IF EXISTS `mirror_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_types` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_types`
--
LOCK TABLES `mirror_types` WRITE;
/*!40000 ALTER TABLE `mirror_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirror_update_records`
--
DROP TABLE IF EXISTS `mirror_update_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirror_update_records` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`mirror_repository_id` int DEFAULT NULL,
`oldName` varchar(255) DEFAULT NULL,
`newName` varchar(255) DEFAULT NULL,
`oldType` varchar(255) DEFAULT NULL,
`newType` varchar(255) DEFAULT NULL,
`oldTag` text,
`newTag` text,
`oldDescription` text,
`newDescription` text,
`oldStatus` int DEFAULT NULL,
`newStatus` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_mirror_update_records_on_user_id` (`user_id`),
KEY `index_mirror_update_records_on_mirror_repository_id` (`mirror_repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirror_update_records`
--
LOCK TABLES `mirror_update_records` WRITE;
/*!40000 ALTER TABLE `mirror_update_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirror_update_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mirrors`
--
DROP TABLE IF EXISTS `mirrors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mirrors` (
`id` bigint NOT NULL AUTO_INCREMENT,
`repo_id` int DEFAULT NULL,
`status` int NOT NULL DEFAULT '0' COMMENT '0 - succeeded, 1 - waiting, 2 - failed',
`interval` int DEFAULT NULL COMMENT 'mirror interval with unix time',
`next_update_time` datetime DEFAULT NULL COMMENT 'next update mirror time, for datetime',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sync_num` int DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mirrors`
--
LOCK TABLES `mirrors` WRITE;
/*!40000 ALTER TABLE `mirrors` DISABLE KEYS */;
/*!40000 ALTER TABLE `mirrors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `module_settings`
--
DROP TABLE IF EXISTS `module_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `module_settings` (
`id` bigint NOT NULL AUTO_INCREMENT,
`module_type` varchar(255) DEFAULT NULL,
`property` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_module_settings_on_module_type` (`module_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `module_settings`
--
LOCK TABLES `module_settings` WRITE;
/*!40000 ALTER TABLE `module_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `module_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `no_uses`
--
DROP TABLE IF EXISTS `no_uses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `no_uses` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`no_use_type` varchar(255) DEFAULT NULL,
`no_use_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `no_uses`
--
LOCK TABLES `no_uses` WRITE;
/*!40000 ALTER TABLE `no_uses` DISABLE KEYS */;
/*!40000 ALTER TABLE `no_uses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notificationcomments`
--
DROP TABLE IF EXISTS `notificationcomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notificationcomments` (
`id` int NOT NULL AUTO_INCREMENT,
`notificationcommented_type` varchar(255) DEFAULT NULL,
`notificationcommented_id` int DEFAULT NULL,
`author_id` int DEFAULT NULL,
`notificationcomments` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notificationcomments`
--
LOCK TABLES `notificationcomments` WRITE;
/*!40000 ALTER TABLE `notificationcomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `notificationcomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oauth_configs`
--
DROP TABLE IF EXISTS `oauth_configs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_configs` (
`id` int NOT NULL AUTO_INCREMENT,
`client_id` varchar(255) DEFAULT NULL,
`client_secret` varchar(255) DEFAULT NULL,
`redirect_uri` varchar(255) DEFAULT NULL,
`scope` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oauth_configs`
--
LOCK TABLES `oauth_configs` WRITE;
/*!40000 ALTER TABLE `oauth_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_configs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oauths`
--
DROP TABLE IF EXISTS `oauths`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauths` (
`id` int NOT NULL AUTO_INCREMENT,
`client_id` varchar(255) DEFAULT NULL,
`client_secret` varchar(255) DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`redirect_uri` varchar(255) DEFAULT NULL,
`scope` varchar(255) DEFAULT NULL,
`access_token` varchar(255) DEFAULT NULL,
`refresh_token` varchar(255) DEFAULT NULL,
`token_created_at` int DEFAULT NULL,
`token_expires_in` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_id` int DEFAULT '0',
`gitea_oauth_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_oauths_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oauths`
--
LOCK TABLES `oauths` WRITE;
/*!40000 ALTER TABLE `oauths` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauths` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `onclick_times`
--
DROP TABLE IF EXISTS `onclick_times`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `onclick_times` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`onclick_time` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_onclick_times_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `onclick_times`
--
LOCK TABLES `onclick_times` WRITE;
/*!40000 ALTER TABLE `onclick_times` DISABLE KEYS */;
/*!40000 ALTER TABLE `onclick_times` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_id_authentication_associations`
--
DROP TABLE IF EXISTS `open_id_authentication_associations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `open_id_authentication_associations` (
`id` int NOT NULL AUTO_INCREMENT,
`issued` int DEFAULT NULL,
`lifetime` int DEFAULT NULL,
`handle` varchar(255) DEFAULT NULL,
`assoc_type` varchar(255) DEFAULT NULL,
`server_url` blob,
`secret` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_id_authentication_associations`
--
LOCK TABLES `open_id_authentication_associations` WRITE;
/*!40000 ALTER TABLE `open_id_authentication_associations` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_id_authentication_associations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_id_authentication_nonces`
--
DROP TABLE IF EXISTS `open_id_authentication_nonces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `open_id_authentication_nonces` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` int NOT NULL,
`server_url` varchar(255) DEFAULT NULL,
`salt` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_id_authentication_nonces`
--
LOCK TABLES `open_id_authentication_nonces` WRITE;
/*!40000 ALTER TABLE `open_id_authentication_nonces` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_id_authentication_nonces` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_source_projects`
--
DROP TABLE IF EXISTS `open_source_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `open_source_projects` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`commit_count` int DEFAULT '0',
`code_line` int DEFAULT '0',
`users_count` int DEFAULT '0',
`last_commit_time` date DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`date_collected` date DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_source_projects`
--
LOCK TABLES `open_source_projects` WRITE;
/*!40000 ALTER TABLE `open_source_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_source_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_users`
--
DROP TABLE IF EXISTS `open_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `open_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`uid` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`extra` text,
PRIMARY KEY (`id`),
UNIQUE KEY `index_open_users_on_type_and_uid` (`type`,`uid`),
KEY `index_open_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_users`
--
LOCK TABLES `open_users` WRITE;
/*!40000 ALTER TABLE `open_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `openis`
--
DROP TABLE IF EXISTS `openis`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `openis` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`openi_user_id` int DEFAULT NULL,
`login` varchar(255) DEFAULT NULL,
`avatar_url` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`allow` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `openis`
--
LOCK TABLES `openis` WRITE;
/*!40000 ALTER TABLE `openis` DISABLE KEYS */;
/*!40000 ALTER TABLE `openis` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `option_numbers`
--
DROP TABLE IF EXISTS `option_numbers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `option_numbers` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`memo` int DEFAULT NULL,
`messages_for_issues` int DEFAULT NULL,
`issues_status` int DEFAULT NULL,
`replay_for_message` int DEFAULT NULL,
`replay_for_memo` int DEFAULT NULL,
`follow` int DEFAULT NULL,
`tread` int DEFAULT NULL,
`praise_by_one` int DEFAULT NULL,
`praise_by_two` int DEFAULT NULL,
`praise_by_three` int DEFAULT NULL,
`tread_by_one` int DEFAULT NULL,
`tread_by_two` int DEFAULT NULL,
`tread_by_three` int DEFAULT NULL,
`changeset` int DEFAULT NULL,
`document` int DEFAULT NULL,
`attachment` int DEFAULT NULL,
`issue_done_ratio` int DEFAULT NULL,
`post_issue` int DEFAULT NULL,
`score_type` int DEFAULT NULL,
`total_score` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`project_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `option_numbers`
--
LOCK TABLES `option_numbers` WRITE;
/*!40000 ALTER TABLE `option_numbers` DISABLE KEYS */;
/*!40000 ALTER TABLE `option_numbers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_activities`
--
DROP TABLE IF EXISTS `org_activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_activities` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`org_act_id` int DEFAULT NULL,
`org_act_type` varchar(255) DEFAULT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_activities`
--
LOCK TABLES `org_activities` WRITE;
/*!40000 ALTER TABLE `org_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_courses`
--
DROP TABLE IF EXISTS `org_courses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_courses` (
`id` int NOT NULL AUTO_INCREMENT,
`organization_id` int DEFAULT NULL,
`course_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_courses`
--
LOCK TABLES `org_courses` WRITE;
/*!40000 ALTER TABLE `org_courses` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_courses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_document_comments`
--
DROP TABLE IF EXISTS `org_document_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_document_comments` (
`id` int NOT NULL AUTO_INCREMENT,
`title` text,
`content` text,
`organization_id` int DEFAULT NULL,
`creator_id` int DEFAULT NULL,
`parent_id` int DEFAULT NULL,
`reply_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`locked` tinyint(1) DEFAULT '0',
`sticky` int DEFAULT '0',
`org_subfield_id` int DEFAULT NULL,
`status` int DEFAULT '0',
`root_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_org_document_comments_on_root_id` (`root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_document_comments`
--
LOCK TABLES `org_document_comments` WRITE;
/*!40000 ALTER TABLE `org_document_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_document_comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_member_roles`
--
DROP TABLE IF EXISTS `org_member_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_member_roles` (
`id` int NOT NULL AUTO_INCREMENT,
`org_member_id` int DEFAULT NULL,
`role_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_member_roles`
--
LOCK TABLES `org_member_roles` WRITE;
/*!40000 ALTER TABLE `org_member_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_member_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_members`
--
DROP TABLE IF EXISTS `org_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_members` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`organization_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_members`
--
LOCK TABLES `org_members` WRITE;
/*!40000 ALTER TABLE `org_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_messages`
--
DROP TABLE IF EXISTS `org_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`sender_id` int DEFAULT NULL,
`organization_id` int DEFAULT NULL,
`message_type` varchar(255) DEFAULT NULL,
`message_id` int DEFAULT NULL,
`viewed` int DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`status` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_messages`
--
LOCK TABLES `org_messages` WRITE;
/*!40000 ALTER TABLE `org_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_projects`
--
DROP TABLE IF EXISTS `org_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_projects` (
`id` int NOT NULL AUTO_INCREMENT,
`organization_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_projects`
--
LOCK TABLES `org_projects` WRITE;
/*!40000 ALTER TABLE `org_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_subfield_messages`
--
DROP TABLE IF EXISTS `org_subfield_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_subfield_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`org_subfield_id` int DEFAULT NULL,
`message_id` int DEFAULT NULL,
`message_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_subfield_messages`
--
LOCK TABLES `org_subfield_messages` WRITE;
/*!40000 ALTER TABLE `org_subfield_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_subfield_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `org_subfields`
--
DROP TABLE IF EXISTS `org_subfields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `org_subfields` (
`id` int NOT NULL AUTO_INCREMENT,
`organization_id` int DEFAULT NULL,
`priority` int DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`field_type` varchar(255) DEFAULT NULL,
`hide` int DEFAULT '0',
`status` int DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `org_subfields`
--
LOCK TABLES `org_subfields` WRITE;
/*!40000 ALTER TABLE `org_subfields` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_subfields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `organization_extensions`
--
DROP TABLE IF EXISTS `organization_extensions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `organization_extensions` (
`id` bigint NOT NULL AUTO_INCREMENT,
`organization_id` bigint DEFAULT NULL,
`description` varchar(255) DEFAULT NULL COMMENT '组织描述',
`website` varchar(255) DEFAULT NULL COMMENT '组织官方网站',
`location` varchar(255) DEFAULT NULL COMMENT '组织地区',
`repo_admin_change_team_access` tinyint(1) DEFAULT '0' COMMENT '项目管理员是否可以添加或移除团队的访问权限',
`visibility` int DEFAULT '0' COMMENT '组织可见性',
`max_repo_creation` int DEFAULT '-1' COMMENT '组织最大仓库数',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`num_projects` int DEFAULT '0',
`num_users` int DEFAULT '0',
`num_teams` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_organization_extensions_on_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `organization_extensions`
--
LOCK TABLES `organization_extensions` WRITE;
/*!40000 ALTER TABLE `organization_extensions` DISABLE KEYS */;
/*!40000 ALTER TABLE `organization_extensions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `organization_users`
--
DROP TABLE IF EXISTS `organization_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `organization_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`organization_id` bigint DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_organization_users_on_user_id` (`user_id`),
KEY `index_organization_users_on_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `organization_users`
--
LOCK TABLES `organization_users` WRITE;
/*!40000 ALTER TABLE `organization_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `organization_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `organizations`
--
DROP TABLE IF EXISTS `organizations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `organizations` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`creator_id` int DEFAULT NULL,
`home_id` int DEFAULT NULL,
`is_public` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`allow_guest_download` tinyint(1) DEFAULT '1',
`visits` int DEFAULT '0',
`show_mode` int DEFAULT '0',
`allow_teacher` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `organizations`
--
LOCK TABLES `organizations` WRITE;
/*!40000 ALTER TABLE `organizations` DISABLE KEYS */;
/*!40000 ALTER TABLE `organizations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `outputs`
--
DROP TABLE IF EXISTS `outputs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outputs` (
`id` int NOT NULL AUTO_INCREMENT,
`code` int DEFAULT NULL,
`game_id` int DEFAULT NULL,
`msg` text,
`out_put` longtext,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`test_set_position` int DEFAULT NULL,
`actual_output` longtext,
`result` tinyint(1) DEFAULT NULL,
`is_public` tinyint(1) DEFAULT NULL,
`query_index` int DEFAULT '1',
`compile_success` int DEFAULT '1',
`text_scor` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `game` (`game_id`,`query_index`),
KEY `index_outputs_on_test_set_position` (`test_set_position`),
KEY `index_outputs_on_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `outputs`
--
LOCK TABLES `outputs` WRITE;
/*!40000 ALTER TABLE `outputs` DISABLE KEYS */;
/*!40000 ALTER TABLE `outputs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phone_app_versions`
--
DROP TABLE IF EXISTS `phone_app_versions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `phone_app_versions` (
`id` int NOT NULL AUTO_INCREMENT,
`version` varchar(255) DEFAULT NULL,
`description` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phone_app_versions`
--
LOCK TABLES `phone_app_versions` WRITE;
/*!40000 ALTER TABLE `phone_app_versions` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_app_versions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pinned_projects`
--
DROP TABLE IF EXISTS `pinned_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pinned_projects` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`project_id` bigint DEFAULT NULL,
`position` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_pinned_projects_on_user_id` (`user_id`),
KEY `index_pinned_projects_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pinned_projects`
--
LOCK TABLES `pinned_projects` WRITE;
/*!40000 ALTER TABLE `pinned_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `pinned_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `platform_samples`
--
DROP TABLE IF EXISTS `platform_samples`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `platform_samples` (
`id` int NOT NULL AUTO_INCREMENT,
`samples_type` varchar(255) DEFAULT NULL,
`contents` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `platform_samples`
--
LOCK TABLES `platform_samples` WRITE;
/*!40000 ALTER TABLE `platform_samples` DISABLE KEYS */;
/*!40000 ALTER TABLE `platform_samples` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `praise_tread_caches`
--
DROP TABLE IF EXISTS `praise_tread_caches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `praise_tread_caches` (
`id` int NOT NULL AUTO_INCREMENT,
`object_id` int NOT NULL,
`object_type` varchar(255) DEFAULT NULL,
`praise_num` int DEFAULT NULL,
`tread_num` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `praise_tread_caches`
--
LOCK TABLES `praise_tread_caches` WRITE;
/*!40000 ALTER TABLE `praise_tread_caches` DISABLE KEYS */;
/*!40000 ALTER TABLE `praise_tread_caches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `praise_treads`
--
DROP TABLE IF EXISTS `praise_treads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `praise_treads` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`praise_tread_object_id` int DEFAULT NULL,
`praise_tread_object_type` varchar(255) DEFAULT NULL,
`praise_or_tread` int DEFAULT '1',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `praise_tread` (`praise_tread_object_id`,`praise_tread_object_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `praise_treads`
--
LOCK TABLES `praise_treads` WRITE;
/*!40000 ALTER TABLE `praise_treads` DISABLE KEYS */;
/*!40000 ALTER TABLE `praise_treads` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `principal_activities`
--
DROP TABLE IF EXISTS `principal_activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `principal_activities` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`principal_id` int DEFAULT NULL,
`principal_act_id` int DEFAULT NULL,
`principal_act_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `principal_activities`
--
LOCK TABLES `principal_activities` WRITE;
/*!40000 ALTER TABLE `principal_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `principal_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `private_messages`
--
DROP TABLE IF EXISTS `private_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `private_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`target_id` int DEFAULT NULL,
`sender_id` int DEFAULT NULL,
`receiver_id` int DEFAULT NULL,
`content` text,
`send_time` datetime DEFAULT NULL,
`status` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_private_messages_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `private_messages`
--
LOCK TABLES `private_messages` WRITE;
/*!40000 ALTER TABLE `private_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `private_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `professional_levels`
--
DROP TABLE IF EXISTS `professional_levels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `professional_levels` (
`id` int NOT NULL AUTO_INCREMENT,
`level` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `professional_levels`
--
LOCK TABLES `professional_levels` WRITE;
/*!40000 ALTER TABLE `professional_levels` DISABLE KEYS */;
/*!40000 ALTER TABLE `professional_levels` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_categories`
--
DROP TABLE IF EXISTS `project_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_categories` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`position` int DEFAULT NULL,
`projects_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`ancestry` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_project_categories_on_ancestry` (`ancestry`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_categories`
--
LOCK TABLES `project_categories` WRITE;
/*!40000 ALTER TABLE `project_categories` DISABLE KEYS */;
INSERT INTO `project_categories` VALUES (1,'大数据',1,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(2,'机器学习',2,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(3,'深度学习',3,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(4,'人工智能',4,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(5,'量子计算',5,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(6,'智慧医疗',6,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(7,'自动驾驶',7,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL),(8,'其他',8,0,'2021-08-27 08:51:40','2021-08-27 08:51:40',NULL);
/*!40000 ALTER TABLE `project_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_details`
--
DROP TABLE IF EXISTS `project_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_details` (
`id` bigint NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`content` longtext,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_project_details_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_details`
--
LOCK TABLES `project_details` WRITE;
/*!40000 ALTER TABLE `project_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_educoders`
--
DROP TABLE IF EXISTS `project_educoders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_educoders` (
`id` bigint NOT NULL AUTO_INCREMENT,
`owner` varchar(255) DEFAULT NULL,
`repo_name` varchar(255) DEFAULT NULL,
`image_url` varchar(255) DEFAULT NULL,
`project_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`commit_count` int DEFAULT '0',
`forked_count` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_project_educoders_on_repo_name` (`repo_name`),
KEY `index_project_educoders_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_educoders`
--
LOCK TABLES `project_educoders` WRITE;
/*!40000 ALTER TABLE `project_educoders` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_educoders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_infos`
--
DROP TABLE IF EXISTS `project_infos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_infos` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_infos`
--
LOCK TABLES `project_infos` WRITE;
/*!40000 ALTER TABLE `project_infos` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_infos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_languages`
--
DROP TABLE IF EXISTS `project_languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_languages` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`position` int DEFAULT NULL,
`projects_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_languages`
--
LOCK TABLES `project_languages` WRITE;
/*!40000 ALTER TABLE `project_languages` DISABLE KEYS */;
INSERT INTO `project_languages` VALUES (1,'Ruby',NULL,0,'2021-08-27 08:51:40','2021-08-27 08:51:40'),(2,'C',NULL,0,'2021-08-27 08:51:40','2021-08-27 08:51:40'),(3,'C#',NULL,0,'2021-08-27 08:51:40','2021-08-27 08:51:40'),(4,'C++',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(5,'HTML',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(6,'Haml',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(7,'CSS',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(8,'JavaScript',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(9,'Python',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(10,'PHP',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(11,'Java',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(12,'JSON',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(13,'JSX',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(14,'Lex',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(15,'Shell',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(16,'Objective-C',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(17,'Cycript',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(18,'Clojure',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(19,'Go',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(20,'Grace',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(21,'Gradle',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(22,'GraphQL',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(23,'Dart',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(24,'Elixir',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(25,'Erlang',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(26,'Perl',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(27,'R',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(28,'Reason',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(29,'Sass',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(30,'Slice',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41'),(31,'SVG',NULL,0,'2021-08-27 08:51:41','2021-08-27 08:51:41');
/*!40000 ALTER TABLE `project_languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_package_applies`
--
DROP TABLE IF EXISTS `project_package_applies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_package_applies` (
`id` int NOT NULL AUTO_INCREMENT,
`project_package_id` int DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`reason` varchar(255) DEFAULT NULL,
`refused_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_project_package_applies_on_project_package_id` (`project_package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_package_applies`
--
LOCK TABLES `project_package_applies` WRITE;
/*!40000 ALTER TABLE `project_package_applies` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_package_applies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_package_categories`
--
DROP TABLE IF EXISTS `project_package_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_package_categories` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`position` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_package_categories`
--
LOCK TABLES `project_package_categories` WRITE;
/*!40000 ALTER TABLE `project_package_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_package_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_packages`
--
DROP TABLE IF EXISTS `project_packages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_packages` (
`id` int NOT NULL AUTO_INCREMENT,
`creator_id` int DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`content` text,
`contact_name` varchar(255) DEFAULT NULL,
`contact_phone` varchar(255) DEFAULT NULL,
`min_price` decimal(10,0) DEFAULT NULL,
`max_price` decimal(10,0) DEFAULT NULL,
`visit_count` int DEFAULT '0',
`bidding_users_count` int DEFAULT '0',
`deadline_at` datetime DEFAULT NULL,
`published_at` datetime DEFAULT NULL,
`bidding_finished_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`project_package_category_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_project_packages_on_published_at` (`published_at`),
KEY `index_project_packages_on_creator_id` (`creator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_packages`
--
LOCK TABLES `project_packages` WRITE;
/*!40000 ALTER TABLE `project_packages` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_packages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_scores`
--
DROP TABLE IF EXISTS `project_scores`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_scores` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` varchar(255) DEFAULT NULL,
`score` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`issue_num` int DEFAULT '0',
`issue_journal_num` int DEFAULT '0',
`news_num` int DEFAULT '0',
`documents_num` int DEFAULT '0',
`changeset_num` int DEFAULT '0',
`board_message_num` int DEFAULT '0',
`board_num` int DEFAULT '0',
`attach_num` int DEFAULT '0',
`commit_time` datetime DEFAULT NULL,
`pull_request_num` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_scores`
--
LOCK TABLES `project_scores` WRITE;
/*!40000 ALTER TABLE `project_scores` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_scores` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_statistics`
--
DROP TABLE IF EXISTS `project_statistics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_statistics` (
`id` bigint NOT NULL AUTO_INCREMENT,
`common_projects_count` int DEFAULT '0',
`mirror_projects_count` int DEFAULT '0',
`sync_mirror_projects_count` int DEFAULT '0',
`commits_total_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_statistics`
--
LOCK TABLES `project_statistics` WRITE;
/*!40000 ALTER TABLE `project_statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_statistics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_statuses`
--
DROP TABLE IF EXISTS `project_statuses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_statuses` (
`id` int NOT NULL AUTO_INCREMENT,
`changesets_count` int DEFAULT NULL,
`watchers_count` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`project_type` int DEFAULT NULL,
`grade` float DEFAULT '0',
`course_ac_para` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_project_statuses_on_grade` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_statuses`
--
LOCK TABLES `project_statuses` WRITE;
/*!40000 ALTER TABLE `project_statuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_statuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_trends`
--
DROP TABLE IF EXISTS `project_trends`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_trends` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`trend_type` varchar(255) DEFAULT NULL,
`trend_id` bigint DEFAULT NULL,
`action_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_project_trends_on_trend_type_and_trend_id` (`trend_type`,`trend_id`),
KEY `index_project_trends_on_user_id_and_project_id` (`user_id`,`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_trends`
--
LOCK TABLES `project_trends` WRITE;
/*!40000 ALTER TABLE `project_trends` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_trends` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_units`
--
DROP TABLE IF EXISTS `project_units`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_units` (
`id` bigint NOT NULL AUTO_INCREMENT,
`project_id` bigint DEFAULT NULL,
`unit_type` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_project_units_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_units`
--
LOCK TABLES `project_units` WRITE;
/*!40000 ALTER TABLE `project_units` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_units` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projecting_softapplictions`
--
DROP TABLE IF EXISTS `projecting_softapplictions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projecting_softapplictions` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`softapplication_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projecting_softapplictions`
--
LOCK TABLES `projecting_softapplictions` WRITE;
/*!40000 ALTER TABLE `projecting_softapplictions` DISABLE KEYS */;
/*!40000 ALTER TABLE `projecting_softapplictions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects`
--
DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projects` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`description` longtext,
`homepage` varchar(255) DEFAULT '',
`is_public` tinyint(1) NOT NULL DEFAULT '1',
`parent_id` int DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`identifier` varchar(255) DEFAULT NULL,
`status` int NOT NULL DEFAULT '1',
`lft` int DEFAULT NULL,
`rgt` int DEFAULT NULL,
`inherit_members` tinyint(1) NOT NULL DEFAULT '0',
`project_type` int DEFAULT '0',
`hidden_repo` tinyint(1) NOT NULL DEFAULT '0',
`attachmenttype` int DEFAULT '1',
`user_id` int DEFAULT NULL,
`dts_test` int DEFAULT '0',
`enterprise_name` varchar(255) DEFAULT NULL,
`organization_id` int DEFAULT NULL,
`project_new_type` int DEFAULT NULL,
`gpid` int DEFAULT NULL,
`forked_from_project_id` int DEFAULT NULL,
`forked_count` int DEFAULT '0',
`publish_resource` int DEFAULT '0',
`visits` int DEFAULT '0',
`hot` int DEFAULT '0',
`invite_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`qrcode` varchar(255) DEFAULT NULL,
`qrcode_expiretime` int DEFAULT '0',
`script` text,
`training_status` tinyint DEFAULT '0',
`rep_identifier` varchar(255) DEFAULT NULL,
`project_category_id` int DEFAULT NULL,
`project_language_id` int DEFAULT NULL,
`license_id` int DEFAULT NULL,
`ignore_id` int DEFAULT NULL,
`praises_count` int DEFAULT '0',
`watchers_count` int DEFAULT '0',
`issues_count` int DEFAULT '0',
`pull_requests_count` int DEFAULT '0',
`language` varchar(255) DEFAULT NULL,
`versions_count` int DEFAULT '0',
`issue_tags_count` int DEFAULT '0',
`closed_issues_count` int DEFAULT '0',
`open_devops` tinyint(1) DEFAULT '0',
`gitea_webhook_id` int DEFAULT NULL,
`open_devops_count` int DEFAULT '0' COMMENT '针对同一台ci服务器激活devops流程的次数',
`recommend` tinyint(1) DEFAULT '0',
`platform` int DEFAULT '0',
`default_branch` varchar(255) DEFAULT 'master',
`website` varchar(255) DEFAULT NULL,
`lesson_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_projects_on_lft` (`lft`),
KEY `index_projects_on_rgt` (`rgt`),
KEY `index_projects_on_identifier` (`identifier`),
KEY `index_projects_on_project_type` (`project_type`),
KEY `index_projects_on_updated_on` (`updated_on`),
KEY `index_projects_on_is_public` (`is_public`),
KEY `index_projects_on_status` (`status`),
KEY `index_projects_on_forked_from_project_id` (`forked_from_project_id`),
KEY `index_projects_on_recommend` (`recommend`),
KEY `index_projects_on_platform` (`platform`),
KEY `index_projects_on_name` (`name`),
KEY `index_projects_on_invite_code` (`invite_code`),
KEY `index_projects_on_project_category_id` (`project_category_id`),
KEY `index_projects_on_project_language_id` (`project_language_id`),
KEY `index_projects_on_license_id` (`license_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects`
--
LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_trackers`
--
DROP TABLE IF EXISTS `projects_trackers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projects_trackers` (
`project_id` int NOT NULL DEFAULT '0',
`tracker_id` int NOT NULL DEFAULT '0',
UNIQUE KEY `projects_trackers_unique` (`project_id`,`tracker_id`),
KEY `projects_trackers_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_trackers`
--
LOCK TABLES `projects_trackers` WRITE;
/*!40000 ALTER TABLE `projects_trackers` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_trackers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `protected_branches`
--
DROP TABLE IF EXISTS `protected_branches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `protected_branches` (
`id` bigint NOT NULL AUTO_INCREMENT,
`repo_id` int DEFAULT NULL,
`branch_name` varchar(255) DEFAULT '',
`can_push` tinyint(1) NOT NULL DEFAULT '0',
`enable_whitelist` tinyint(1) DEFAULT '0',
`whitelist_user_i_ds` text,
`whitelist_team_i_ds` text,
`enable_merge_whitelist` tinyint(1) NOT NULL DEFAULT '0',
`whitelist_deploy_keys` tinyint(1) NOT NULL DEFAULT '0',
`merge_whitelist_user_i_ds` text,
`merge_whitelist_team_i_ds` text,
`enable_status_check` tinyint(1) NOT NULL DEFAULT '0',
`status_check_contexts` text,
`approvals_whitelist_user_i_ds` text,
`approvals_whitelist_team_i_ds` text,
`required_approvals` int DEFAULT '0',
`enable_approvals_whitelist` tinyint(1) NOT NULL DEFAULT '0',
`block_on_rejected_reviews` tinyint(1) NOT NULL DEFAULT '0',
`dismiss_stale_approvals` tinyint(1) NOT NULL DEFAULT '0',
`require_signed_commits` tinyint(1) NOT NULL DEFAULT '0',
`protected_file_patterns` text,
`block_on_outdated_branch` tinyint(1) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_protected_branches_on_repo_id` (`repo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `protected_branches`
--
LOCK TABLES `protected_branches` WRITE;
/*!40000 ALTER TABLE `protected_branches` DISABLE KEYS */;
/*!40000 ALTER TABLE `protected_branches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pull_request_assigns`
--
DROP TABLE IF EXISTS `pull_request_assigns`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pull_request_assigns` (
`id` bigint NOT NULL AUTO_INCREMENT,
`pull_request_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_login` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_pull_request_assigns_on_user_id_and_pull_request_id` (`pull_request_id`),
KEY `index_pull_request_assigns_on_user_login` (`user_login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pull_request_assigns`
--
LOCK TABLES `pull_request_assigns` WRITE;
/*!40000 ALTER TABLE `pull_request_assigns` DISABLE KEYS */;
/*!40000 ALTER TABLE `pull_request_assigns` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pull_request_tags`
--
DROP TABLE IF EXISTS `pull_request_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pull_request_tags` (
`id` bigint NOT NULL AUTO_INCREMENT,
`issue_tag_id` int DEFAULT NULL,
`pull_request_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_pull_request_tags_on_issue_tag_id_and_pull_request_id` (`issue_tag_id`,`pull_request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pull_request_tags`
--
LOCK TABLES `pull_request_tags` WRITE;
/*!40000 ALTER TABLE `pull_request_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `pull_request_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pull_requests`
--
DROP TABLE IF EXISTS `pull_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pull_requests` (
`id` int NOT NULL AUTO_INCREMENT,
`gitea_id` int DEFAULT NULL,
`gitea_number` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`status` int DEFAULT '0',
`project_id` int DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`milestone` int DEFAULT NULL,
`body` text,
`head` varchar(255) DEFAULT NULL,
`base` varchar(255) DEFAULT NULL,
`issue_id` int DEFAULT NULL,
`fork_project_id` int DEFAULT NULL,
`is_original` tinyint(1) DEFAULT '0',
`comments_count` int DEFAULT '0' COMMENT 'number of comments for pull request',
`commits_count` int DEFAULT '0' COMMENT 'number of git commits for pull request',
`files_count` int DEFAULT '0' COMMENT 'number of git change files for pull request',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pull_requests`
--
LOCK TABLES `pull_requests` WRITE;
/*!40000 ALTER TABLE `pull_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `pull_requests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quality_analyses`
--
DROP TABLE IF EXISTS `quality_analyses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quality_analyses` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`author_login` varchar(255) DEFAULT NULL,
`rep_identifier` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sonar_version` int DEFAULT '0',
`path` varchar(255) DEFAULT NULL,
`branch` varchar(255) DEFAULT NULL,
`language` varchar(255) DEFAULT NULL,
`sonar_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quality_analyses`
--
LOCK TABLES `quality_analyses` WRITE;
/*!40000 ALTER TABLE `quality_analyses` DISABLE KEYS */;
/*!40000 ALTER TABLE `quality_analyses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `queries`
--
DROP TABLE IF EXISTS `queries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `queries` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`filters` text,
`user_id` int NOT NULL DEFAULT '0',
`is_public` tinyint(1) NOT NULL DEFAULT '0',
`column_names` text,
`sort_criteria` text,
`group_by` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_queries_on_project_id` (`project_id`),
KEY `index_queries_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `queries`
--
LOCK TABLES `queries` WRITE;
/*!40000 ALTER TABLE `queries` DISABLE KEYS */;
/*!40000 ALTER TABLE `queries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `relationships`
--
DROP TABLE IF EXISTS `relationships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `relationships` (
`id` bigint NOT NULL AUTO_INCREMENT,
`follower_id` int DEFAULT NULL,
`followed_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_relationships_on_follower_id_and_followed_id` (`follower_id`,`followed_id`),
KEY `index_relationships_on_followed_id` (`followed_id`),
KEY `index_relationships_on_follower_id` (`follower_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `relationships`
--
LOCK TABLES `relationships` WRITE;
/*!40000 ALTER TABLE `relationships` DISABLE KEYS */;
/*!40000 ALTER TABLE `relationships` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rep_statics`
--
DROP TABLE IF EXISTS `rep_statics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rep_statics` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`commits_num` int DEFAULT NULL,
`uname` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`add` int DEFAULT NULL,
`del` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`changeset` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rep_statics`
--
LOCK TABLES `rep_statics` WRITE;
/*!40000 ALTER TABLE `rep_statics` DISABLE KEYS */;
/*!40000 ALTER TABLE `rep_statics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `repertoires`
--
DROP TABLE IF EXISTS `repertoires`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `repertoires` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `repertoires`
--
LOCK TABLES `repertoires` WRITE;
/*!40000 ALTER TABLE `repertoires` DISABLE KEYS */;
/*!40000 ALTER TABLE `repertoires` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `repositories`
--
DROP TABLE IF EXISTS `repositories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `repositories` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL DEFAULT '0',
`url` varchar(255) NOT NULL DEFAULT '',
`login` varchar(60) DEFAULT '',
`password` varchar(255) DEFAULT '',
`root_url` varchar(255) DEFAULT '',
`type` varchar(255) DEFAULT NULL,
`path_encoding` varchar(64) DEFAULT NULL,
`log_encoding` varchar(64) DEFAULT NULL,
`extra_info` text,
`identifier` varchar(255) DEFAULT NULL,
`is_default` tinyint(1) DEFAULT '0',
`hidden` tinyint(1) DEFAULT '0',
`shixun_id` int DEFAULT NULL,
`myshixun_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`mirror_url` varchar(255) DEFAULT NULL,
`version_releases_count` int DEFAULT '0',
`fork_url` varchar(255) DEFAULT NULL,
`is_mirror` tinyint(1) DEFAULT '0',
`accelerator_url` varchar(255) DEFAULT '',
`source_clone_url` varchar(255) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index_repositories_on_project_id` (`project_id`),
KEY `index_repositories_on_identifier` (`identifier`),
KEY `index_repositories_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `repositories`
--
LOCK TABLES `repositories` WRITE;
/*!40000 ALTER TABLE `repositories` DISABLE KEYS */;
/*!40000 ALTER TABLE `repositories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `resource_banks`
--
DROP TABLE IF EXISTS `resource_banks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `resource_banks` (
`id` int NOT NULL AUTO_INCREMENT,
`course_id` int DEFAULT NULL,
`attachment_id` int DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`disk_filename` varchar(255) DEFAULT NULL,
`filesize` int DEFAULT NULL,
`digest` varchar(255) DEFAULT NULL,
`downloads` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`description` text,
`disk_directory` varchar(255) DEFAULT NULL,
`is_public` tinyint(1) DEFAULT NULL,
`copy_from` int DEFAULT NULL,
`quotes` int DEFAULT NULL,
`applicable_syllabus` varchar(255) DEFAULT NULL,
`major_level` int DEFAULT NULL,
`discipline_category_id` int DEFAULT NULL,
`first_level_discipline_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`content_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_resource_banks_on_course_id` (`course_id`),
KEY `index_resource_banks_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `resource_banks`
--
LOCK TABLES `resource_banks` WRITE;
/*!40000 ALTER TABLE `resource_banks` DISABLE KEYS */;
/*!40000 ALTER TABLE `resource_banks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`position` int DEFAULT '1',
`assignable` tinyint(1) DEFAULT '1',
`builtin` int NOT NULL DEFAULT '0',
`permissions` text,
`issues_visibility` varchar(30) NOT NULL DEFAULT 'default',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'Non member',1,1,1,'---\n- :upload_attachments\n- :memos_attachments_download\n- :add_project\n- :projects_attachments_download\n- :add_course\n- :course_attachments_download\n- :view_course_files\n- :add_messages\n- :delete_own_messages\n- :view_calendar\n- :view_documents\n- :view_files\n- :view_gantt\n- :view_issues\n- :save_queries\n- :comment_news\n- :browse_repository\n- :view_changesets\n- :view_time_entries\n- :view_wiki_pages\n- :view_wiki_edits\n','default'),(2,'Anonymous',2,1,2,'---\n- :memos_attachments_download\n- :view_course_files\n- :view_calendar\n- :view_documents\n- :view_files\n- :view_gantt\n- :view_issues\n- :browse_repository\n- :view_changesets\n- :view_time_entries\n- :view_wiki_pages\n- :view_wiki_edits\n','default'),(3,'Manager',3,1,0,'---\n- :add_project\n- :edit_project\n- :close_project\n- :select_project_modules\n- :manage_members\n- :manage_versions\n- :add_subprojects\n- :is_manager\n- :projects_attachments_download\n- :as_teacher\n- :add_course\n- :edit_course\n- :close_course\n- :select_course_modules\n- :view_course_journals_for_messages\n- :course_attachments_download\n- :view_course_files\n- :view_homework_attaches\n- :quote_project\n- :manage_boards\n- :add_messages\n- :edit_messages\n- :edit_own_messages\n- :delete_messages\n- :delete_own_messages\n- :view_calendar\n- :view_code_review\n- :add_code_review\n- :edit_code_review\n- :delete_code_review\n- :assign_code_review\n- :code_review_setting\n- :add_documents\n- :edit_documents\n- :delete_documents\n- :view_documents\n- :manage_files\n- :view_files\n- :view_gantt\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :manage_subtasks\n- :set_issues_private\n- :set_own_issues_private\n- :add_issue_notes\n- :edit_issue_notes\n- :edit_own_issue_notes\n- :view_private_notes\n- :set_notes_private\n- :move_issues\n- :delete_issues\n- :manage_public_queries\n- :save_queries\n- :view_issue_watchers\n- :add_issue_watchers\n- :delete_issue_watchers\n- :manage_news\n- :comment_news\n- :manage_repository\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n- :log_time\n- :view_time_entries\n- :edit_time_entries\n- :edit_own_time_entries\n- :manage_project_activities\n- :manage_wiki\n- :rename_wiki_pages\n- :delete_wiki_pages\n- :view_wiki_pages\n- :export_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :delete_wiki_pages_attachments\n- :protect_wiki_pages\n','all'),(4,'Developer',5,1,0,'---\n- :add_project\n- :manage_versions\n- :projects_attachments_download\n- :add_course\n- :edit_course\n- :close_course\n- :select_course_modules\n- :view_course_journals_for_messages\n- :course_attachments_download\n- :view_course_files\n- :view_homework_attaches\n- :paret_in_homework\n- :select_contest_modules\n- :quote_project\n- :contest_attachments_download\n- :manage_contestnotifications\n- :notificationcomment_contestnotifications\n- :manage_boards\n- :add_messages\n- :edit_own_messages\n- :delete_own_messages\n- :view_calendar\n- :manage_files\n- :view_files\n- :view_gantt\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :manage_subtasks\n- :set_issues_private\n- :set_own_issues_private\n- :add_issue_notes\n- :edit_issue_notes\n- :edit_own_issue_notes\n- :view_private_notes\n- :set_notes_private\n- :move_issues\n- :delete_issues\n- :manage_public_queries\n- :save_queries\n- :view_issue_watchers\n- :add_issue_watchers\n- :delete_issue_watchers\n- :manage_repository\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n','all'),(5,'Reporter',4,1,0,'---\n- :add_project\n- :projects_attachments_download\n- :add_course\n- :edit_course\n- :close_course\n- :select_course_modules\n- :view_course_journals_for_messages\n- :course_attachments_download\n- :view_course_files\n- :view_homework_attaches\n- :manage_boards\n- :add_messages\n- :edit_own_messages\n- :delete_own_messages\n- :view_calendar\n- :view_code_review\n- :manage_files\n- :view_files\n- :view_gantt\n
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `run_code_messages`
--
DROP TABLE IF EXISTS `run_code_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `run_code_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`status` int DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`game_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_run_code_messages_on_game_id` (`game_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `run_code_messages`
--
LOCK TABLES `run_code_messages` WRITE;
/*!40000 ALTER TABLE `run_code_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `run_code_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `schema_migrations`
--
DROP TABLE IF EXISTS `schema_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schema_migrations` (
`version` varchar(255) NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `schema_migrations`
--
LOCK TABLES `schema_migrations` WRITE;
/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
INSERT INTO `schema_migrations` VALUES ('20191212110933'),('20191213091840'),('20191218015959'),('20191218022602'),('20191218023731'),('20191218024615'),('20191218092812'),('20191218105120'),('20191220085002'),('20191220085133'),('20191220085352'),('20191220092618'),('20191223031855'),('20191223063139'),('20191224064403'),('20191225073843'),('20191225125634'),('20191227013202'),('20191227084951'),('20191227090611'),('20191227105755'),('20191227140150'),('20191227162744'),('20200103062707'),('20200103062807'),('20200103113839'),('20200106022157'),('20200106022235'),('20200106082806'),('20200106093141'),('20200108015358'),('20200108025756'),('20200108031646'),('20200108071622'),('20200108082955'),('20200117032213'),('20200210071320'),('20200210074241'),('20200210111249'),('20200210111308'),('20200212055807'),('20200213090203'),('20200213094050'),('20200220063545'),('20200220075242'),('20200317160914'),('20200416154625'),('20200417094626'),('20200421092002'),('20200429085544'),('20200513080857'),('20200515024117'),('20200515080705'),('20200515082628'),('20200518065521'),('20200518081445'),('20200518090640'),('20200518092612'),('20200521090205'),('20200521093338'),('20200525021613'),('20200525054200'),('20200609100407'),('20200610071625'),('20200629020618'),('20200629081111'),('20200708114354'),('20200709061656'),('20200710124116'),('20200713150706'),('20200714014513'),('20200714032759'),('20200714072948'),('20200714112206'),('20200715075831'),('20200715152711'),('20200716060536'),('20200717015216'),('20200731073851'),('20200813144941'),('20200813150315'),('20200828021007'),('20200828022021'),('20200904074907'),('20200925090122'),('20200927023922'),('20200929062837'),('20201004034434'),('20201004070431'),('20201019082617'),('20201019104433'),('20201020071758'),('20201020083709'),('20201020093834'),('20201021031915'),('20201021033117'),('20201021041202'),('20201021070524'),('20201021080638'),('20201022164823'),('20201023025821'),('20201104034658'),('20201130081039'),('20201230054355'),('20210108015318'),('20210108055023'),('20210108062016'),('20210111013512'),('20210111065934'),('20210111065954'),('20210111093008'),('20210111093016'),('20210111093024'),('20210111093200'),('20210112053516'),('20210118011710'),('20210119025745'),('20210120081821'),('20210122052755'),('20210126071814'),('20210202034128'),('20210202100517'),('20210315093350'),('20210317012035'),('20210322084619'),('20210408070123'),('20210419023310'),('20210425032825'),('20210429095016'),('20210429100619'),('20210514024444'),('20210527024043'),('20210531100250'),('20210603020327'),('20210609072904'),('20210615063727'),('20210617081433'),('20210621090005'),('20210624101058');
/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`value` text,
`updated_on` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_settings_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shares`
--
DROP TABLE IF EXISTS `shares`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shares` (
`id` int NOT NULL AUTO_INCREMENT,
`created_on` date DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`share_type` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`project_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shares`
--
LOCK TABLES `shares` WRITE;
/*!40000 ALTER TABLE `shares` DISABLE KEYS */;
/*!40000 ALTER TABLE `shares` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shield_activities`
--
DROP TABLE IF EXISTS `shield_activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shield_activities` (
`id` int NOT NULL AUTO_INCREMENT,
`container_type` varchar(255) DEFAULT NULL,
`container_id` int DEFAULT NULL,
`shield_type` varchar(255) DEFAULT NULL,
`shield_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shield_activities`
--
LOCK TABLES `shield_activities` WRITE;
/*!40000 ALTER TABLE `shield_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `shield_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shield_wechat_messages`
--
DROP TABLE IF EXISTS `shield_wechat_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shield_wechat_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`shield_id` int DEFAULT NULL,
`shield_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shield_wechat_messages`
--
LOCK TABLES `shield_wechat_messages` WRITE;
/*!40000 ALTER TABLE `shield_wechat_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `shield_wechat_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sites`
--
DROP TABLE IF EXISTS `sites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sites` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '中文名称',
`url` varchar(255) DEFAULT NULL COMMENT '具体链接',
`key` varchar(255) DEFAULT NULL COMMENT '标识',
`site_type` int DEFAULT NULL COMMENT '分类，按照分类编排链接',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sites`
--
LOCK TABLES `sites` WRITE;
/*!40000 ALTER TABLE `sites` DISABLE KEYS */;
INSERT INTO `sites` VALUES (1,'新建项目','/projects/deposit/new','add_mirror_project',0,'2021-08-27 08:51:45','2021-08-27 08:51:45'),(2,'导入项目','/projects/mirror/new','add_common',0,'2021-08-27 08:51:45','2021-08-27 08:51:45'),(3,'新建组织','/organize/new','add_org',0,'2021-08-27 08:51:45','2021-08-27 08:51:45'),(4,'个人主页','/current_user','my_page',1,'2021-08-27 08:51:45','2021-08-27 08:51:45'),(6,'设置','/settings/profile','profile',1,'2021-08-27 08:51:45','2021-08-27 08:51:45'),(8,'注册','/register','register',2,'2021-08-27 08:51:45','2021-08-27 08:51:45');
/*!40000 ALTER TABLE `sites` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `softapplications`
--
DROP TABLE IF EXISTS `softapplications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `softapplications` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`app_type_id` int DEFAULT NULL,
`app_type_name` varchar(255) DEFAULT NULL,
`android_min_version_available` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`contest_id` int DEFAULT NULL,
`softapplication_id` int DEFAULT NULL,
`is_public` int DEFAULT NULL,
`application_developers` varchar(255) DEFAULT NULL,
`deposit_project_url` varchar(255) DEFAULT NULL,
`deposit_project` varchar(255) DEFAULT NULL,
`project_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `softapplications`
--
LOCK TABLES `softapplications` WRITE;
/*!40000 ALTER TABLE `softapplications` DISABLE KEYS */;
/*!40000 ALTER TABLE `softapplications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sonar_errors`
--
DROP TABLE IF EXISTS `sonar_errors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sonar_errors` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int DEFAULT NULL,
`jenkins_job_name` varchar(255) DEFAULT NULL,
`output` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sonar_errors`
--
LOCK TABLES `sonar_errors` WRITE;
/*!40000 ALTER TABLE `sonar_errors` DISABLE KEYS */;
/*!40000 ALTER TABLE `sonar_errors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ssos`
--
DROP TABLE IF EXISTS `ssos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ssos` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`openid` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`sex` int DEFAULT NULL,
`school` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_ssos_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ssos`
--
LOCK TABLES `ssos` WRITE;
/*!40000 ALTER TABLE `ssos` DISABLE KEYS */;
/*!40000 ALTER TABLE `ssos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subject_members`
--
DROP TABLE IF EXISTS `subject_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_members` (
`id` int NOT NULL AUTO_INCREMENT,
`subject_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`role` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`position` int DEFAULT '1',
PRIMARY KEY (`id`),
KEY `index_subject_members_on_subject_id` (`subject_id`),
KEY `index_subject_members_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subject_members`
--
LOCK TABLES `subject_members` WRITE;
/*!40000 ALTER TABLE `subject_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `subject_members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subject_records`
--
DROP TABLE IF EXISTS `subject_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_records` (
`id` bigint NOT NULL AUTO_INCREMENT,
`subject_id` bigint DEFAULT NULL,
`study_count` int DEFAULT '0',
`course_study_count` int DEFAULT '0',
`initiative_study` int DEFAULT '0',
`passed_count` int DEFAULT '0',
`course_used_count` int DEFAULT '0',
`school_used_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_subject_records_on_subject_id` (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subject_records`
--
LOCK TABLES `subject_records` WRITE;
/*!40000 ALTER TABLE `subject_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `subject_records` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subjects`
--
DROP TABLE IF EXISTS `subjects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subjects` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`user_id` int DEFAULT NULL,
`visits` int DEFAULT '1',
`status` int DEFAULT '0',
`course_list_id` int DEFAULT NULL,
`major_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`hidden` tinyint(1) DEFAULT '0',
`learning_notes` text,
`introduction` varchar(255) DEFAULT NULL,
`stages_count` int DEFAULT '0',
`stage_shixuns_count` int DEFAULT '0',
`homepage_show` tinyint(1) DEFAULT '0',
`repertoire_id` int DEFAULT NULL,
`score_count` int DEFAULT NULL,
`shixuns_count` int DEFAULT '0',
`publish_time` datetime DEFAULT NULL,
`subject_level_system_id` int DEFAULT NULL,
`student_count` int DEFAULT '0',
`participant_count` int DEFAULT '0',
`team_title` varchar(255) DEFAULT '教学团队',
`copy_subject_id` int DEFAULT NULL,
`public` int DEFAULT '0',
`show_mobile` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_subjects_on_user_id` (`user_id`),
KEY `index_subjects_on_course_list_id` (`course_list_id`),
KEY `index_subjects_on_major_id` (`major_id`),
KEY `index_subjects_on_subject_level_system_id` (`subject_level_system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subjects`
--
LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_messages`
--
DROP TABLE IF EXISTS `system_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`description` text,
`subject` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_messages`
--
LOCK TABLES `system_messages` WRITE;
/*!40000 ALTER TABLE `system_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `system_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_update_notices`
--
DROP TABLE IF EXISTS `system_update_notices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_update_notices` (
`id` int NOT NULL AUTO_INCREMENT,
`subject` varchar(255) DEFAULT NULL,
`notes` text,
`start_time` datetime DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`notice_type` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_update_notices`
--
LOCK TABLES `system_update_notices` WRITE;
/*!40000 ALTER TABLE `system_update_notices` DISABLE KEYS */;
/*!40000 ALTER TABLE `system_update_notices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tag_discipline_containers`
--
DROP TABLE IF EXISTS `tag_discipline_containers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tag_discipline_containers` (
`id` bigint NOT NULL AUTO_INCREMENT,
`tag_discipline_id` bigint DEFAULT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_tag_discipline_containers_on_tag_discipline_id` (`tag_discipline_id`),
KEY `index_on_container` (`container_type`,`container_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tag_discipline_containers`
--
LOCK TABLES `tag_discipline_containers` WRITE;
/*!40000 ALTER TABLE `tag_discipline_containers` DISABLE KEYS */;
/*!40000 ALTER TABLE `tag_discipline_containers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tag_disciplines`
--
DROP TABLE IF EXISTS `tag_disciplines`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tag_disciplines` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sub_discipline_id` bigint DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`subject` tinyint(1) DEFAULT '1',
`shixun` tinyint(1) DEFAULT '1',
`question` tinyint(1) DEFAULT '1',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_id` int DEFAULT NULL,
`position` int DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_tag_disciplines_on_sub_discipline_id` (`sub_discipline_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tag_disciplines`
--
LOCK TABLES `tag_disciplines` WRITE;
/*!40000 ALTER TABLE `tag_disciplines` DISABLE KEYS */;
/*!40000 ALTER TABLE `tag_disciplines` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tag_repertoires`
--
DROP TABLE IF EXISTS `tag_repertoires`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tag_repertoires` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`sub_repertoire_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tag_repertoires`
--
LOCK TABLES `tag_repertoires` WRITE;
/*!40000 ALTER TABLE `tag_repertoires` DISABLE KEYS */;
/*!40000 ALTER TABLE `tag_repertoires` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `taggings`
--
DROP TABLE IF EXISTS `taggings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `taggings` (
`id` int NOT NULL AUTO_INCREMENT,
`tag_id` int DEFAULT NULL,
`taggable_id` int DEFAULT NULL,
`taggable_type` varchar(255) DEFAULT NULL,
`tagger_id` int DEFAULT NULL,
`tagger_type` varchar(255) DEFAULT NULL,
`context` varchar(128) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `taggings_idx` (`tag_id`,`taggable_id`,`taggable_type`,`context`,`tagger_id`,`tagger_type`),
KEY `index_taggings_on_taggable_type` (`taggable_type`),
KEY `index_taggings_on_taggable_id_and_taggable_type_and_context` (`taggable_id`,`taggable_type`,`context`),
KEY `index_taggings_on_tag_id` (`tag_id`),
KEY `index_taggings_on_taggable_id` (`taggable_id`),
KEY `index_taggings_on_tagger_id` (`tagger_id`),
KEY `index_taggings_on_context` (`context`),
KEY `index_taggings_on_tagger_id_and_tagger_type` (`tagger_id`,`tagger_type`),
KEY `taggings_idy` (`taggable_id`,`taggable_type`,`tagger_id`,`context`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taggings`
--
LOCK TABLES `taggings` WRITE;
/*!40000 ALTER TABLE `taggings` DISABLE KEYS */;
/*!40000 ALTER TABLE `taggings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tags`
--
DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tags` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`taggings_count` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tags`
--
LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teacher_course_groups`
--
DROP TABLE IF EXISTS `teacher_course_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teacher_course_groups` (
`id` int NOT NULL AUTO_INCREMENT,
`member_id` int DEFAULT NULL,
`course_group_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`course_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`course_member_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_teacher_course_groups_on_course_group_id` (`course_group_id`),
KEY `index_teacher_course_groups_on_user_id` (`user_id`),
KEY `index_teacher_course_groups_on_course_id` (`course_id`),
KEY `index_teacher_course_groups_on_course_member_id` (`course_member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teacher_course_groups`
--
LOCK TABLES `teacher_course_groups` WRITE;
/*!40000 ALTER TABLE `teacher_course_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `teacher_course_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_members`
--
DROP TABLE IF EXISTS `team_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_members` (
`id` int NOT NULL AUTO_INCREMENT,
`competition_team_id` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`role` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`competition_id` int DEFAULT NULL,
`is_teacher` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_team_members_on_competition_team_id` (`competition_team_id`),
KEY `index_team_members_on_user_id` (`user_id`),
KEY `index_team_members_on_competition_id` (`competition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team_members`
--
LOCK TABLES `team_members` WRITE;
/*!40000 ALTER TABLE `team_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_members` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_projects`
--
DROP TABLE IF EXISTS `team_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_projects` (
`id` bigint NOT NULL AUTO_INCREMENT,
`organization_id` bigint DEFAULT NULL,
`project_id` bigint DEFAULT NULL,
`team_id` bigint DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_team_projects_on_organization_id` (`organization_id`),
KEY `index_team_projects_on_project_id` (`project_id`),
KEY `index_team_projects_on_team_id` (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team_projects`
--
LOCK TABLES `team_projects` WRITE;
/*!40000 ALTER TABLE `team_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_units`
--
DROP TABLE IF EXISTS `team_units`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_units` (
`id` bigint NOT NULL AUTO_INCREMENT,
`organization_id` bigint DEFAULT NULL,
`team_id` bigint DEFAULT NULL,
`unit_type` int DEFAULT NULL COMMENT '访问单元类型',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_team_units_on_organization_id` (`organization_id`),
KEY `index_team_units_on_team_id` (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team_units`
--
LOCK TABLES `team_units` WRITE;
/*!40000 ALTER TABLE `team_units` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_units` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_users`
--
DROP TABLE IF EXISTS `team_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`organization_id` bigint DEFAULT NULL,
`team_id` bigint DEFAULT NULL,
`user_id` bigint DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_team_users_on_organization_id` (`organization_id`),
KEY `index_team_users_on_team_id` (`team_id`),
KEY `index_team_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team_users`
--
LOCK TABLES `team_users` WRITE;
/*!40000 ALTER TABLE `team_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teams`
--
DROP TABLE IF EXISTS `teams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teams` (
`id` bigint NOT NULL AUTO_INCREMENT,
`organization_id` bigint DEFAULT NULL,
`name` varchar(255) DEFAULT NULL COMMENT '团队名称',
`description` varchar(255) DEFAULT NULL COMMENT '团队描述',
`authorize` int DEFAULT '0' COMMENT '团队权限',
`num_projects` int DEFAULT '0' COMMENT '团队项目数量',
`num_users` int DEFAULT '0' COMMENT '团队成员数量',
`includes_all_project` tinyint(1) DEFAULT '0' COMMENT '团队是否拥有所有项目',
`can_create_org_project` tinyint(1) DEFAULT '0' COMMENT '团队是否能创建项目',
`gtid` int DEFAULT NULL COMMENT '团队在gitea里的id',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nickname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_teams_on_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teams`
--
LOCK TABLES `teams` WRITE;
/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tidings`
--
DROP TABLE IF EXISTS `tidings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tidings` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`trigger_user_id` int DEFAULT NULL,
`container_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`parent_container_id` int DEFAULT NULL,
`parent_container_type` varchar(255) DEFAULT NULL,
`belong_container_id` int DEFAULT NULL,
`belong_container_type` varchar(255) DEFAULT NULL,
`status` int DEFAULT '0',
`viewed` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`tiding_type` varchar(255) DEFAULT NULL,
`extra` varchar(255) DEFAULT NULL,
`is_delete` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_tidings_on_user_id` (`user_id`),
KEY `index_tidings_on_container_id` (`container_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tidings`
--
LOCK TABLES `tidings` WRITE;
/*!40000 ALTER TABLE `tidings` DISABLE KEYS */;
/*!40000 ALTER TABLE `tidings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `time_entries`
--
DROP TABLE IF EXISTS `time_entries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `time_entries` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL,
`user_id` int NOT NULL,
`issue_id` int DEFAULT NULL,
`hours` float NOT NULL,
`comments` varchar(255) DEFAULT NULL,
`activity_id` int NOT NULL,
`spent_on` date NOT NULL,
`tyear` int NOT NULL,
`tmonth` int NOT NULL,
`tweek` int NOT NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `time_entries_project_id` (`project_id`),
KEY `time_entries_issue_id` (`issue_id`),
KEY `index_time_entries_on_activity_id` (`activity_id`),
KEY `index_time_entries_on_user_id` (`user_id`),
KEY `index_time_entries_on_created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `time_entries`
--
LOCK TABLES `time_entries` WRITE;
/*!40000 ALTER TABLE `time_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_entries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tokens`
--
DROP TABLE IF EXISTS `tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tokens` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL DEFAULT '0',
`action` varchar(30) NOT NULL DEFAULT '',
`value` varchar(40) NOT NULL DEFAULT '',
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `tokens_value` (`value`),
KEY `index_tokens_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tokens`
--
LOCK TABLES `tokens` WRITE;
/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `trackers`
--
DROP TABLE IF EXISTS `trackers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trackers` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`is_in_chlog` tinyint(1) NOT NULL DEFAULT '0',
`position` int DEFAULT '1',
`is_in_roadmap` tinyint(1) NOT NULL DEFAULT '1',
`fields_bits` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `trackers`
--
LOCK TABLES `trackers` WRITE;
/*!40000 ALTER TABLE `trackers` DISABLE KEYS */;
INSERT INTO `trackers` VALUES (1,'缺陷',1,1,1,0),(2,'功能',1,2,1,0),(3,'支持',0,3,1,0),(4,'任务',0,4,1,0),(5,'周报',0,5,1,0);
/*!40000 ALTER TABLE `trackers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `trustie_hackathons`
--
DROP TABLE IF EXISTS `trustie_hackathons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trustie_hackathons` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`trustie_hacks_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `trustie_hackathons`
--
LOCK TABLES `trustie_hackathons` WRITE;
/*!40000 ALTER TABLE `trustie_hackathons` DISABLE KEYS */;
/*!40000 ALTER TABLE `trustie_hackathons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `trustie_hacks`
--
DROP TABLE IF EXISTS `trustie_hacks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trustie_hacks` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`user_id` bigint DEFAULT NULL,
`hack_users_count` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`trustie_hackathon_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_trustie_hacks_on_user_id` (`user_id`),
KEY `index_trustie_hacks_on_trustie_hackathon_id` (`trustie_hackathon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `trustie_hacks`
--
LOCK TABLES `trustie_hacks` WRITE;
/*!40000 ALTER TABLE `trustie_hacks` DISABLE KEYS */;
/*!40000 ALTER TABLE `trustie_hacks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_actions`
--
DROP TABLE IF EXISTS `user_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_actions` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`action_type` varchar(255) DEFAULT NULL,
`action_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`ip` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_user_actions_on_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_actions`
--
LOCK TABLES `user_actions` WRITE;
/*!40000 ALTER TABLE `user_actions` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_actions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_activities`
--
DROP TABLE IF EXISTS `user_activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_activities` (
`id` int NOT NULL AUTO_INCREMENT,
`act_type` varchar(255) DEFAULT NULL,
`act_id` int DEFAULT NULL,
`container_type` varchar(255) DEFAULT NULL,
`container_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_act_index` (`act_id`,`act_type`,`container_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_activities`
--
LOCK TABLES `user_activities` WRITE;
/*!40000 ALTER TABLE `user_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_agents`
--
DROP TABLE IF EXISTS `user_agents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_agents` (
`id` int NOT NULL AUTO_INCREMENT,
`agent_type` varchar(255) DEFAULT NULL,
`key` varchar(255) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`register_status` int DEFAULT '0',
`action_status` int DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_user_agents_on_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_agents`
--
LOCK TABLES `user_agents` WRITE;
/*!40000 ALTER TABLE `user_agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_agents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_day_certifications`
--
DROP TABLE IF EXISTS `user_day_certifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_day_certifications` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`status` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_day_certifications_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_day_certifications`
--
LOCK TABLES `user_day_certifications` WRITE;
/*!40000 ALTER TABLE `user_day_certifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_day_certifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_extensions`
--
DROP TABLE IF EXISTS `user_extensions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_extensions` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`birthday` date DEFAULT NULL,
`brief_introduction` varchar(255) DEFAULT NULL,
`gender` int DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`occupation` varchar(255) DEFAULT NULL,
`work_experience` int DEFAULT NULL,
`zip_code` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`technical_title` varchar(255) DEFAULT NULL,
`identity` int DEFAULT NULL,
`student_id` varchar(255) DEFAULT NULL,
`teacher_realname` varchar(255) DEFAULT NULL,
`student_realname` varchar(255) DEFAULT NULL,
`location_city` varchar(255) DEFAULT NULL,
`school_id` int DEFAULT NULL,
`description` varchar(255) DEFAULT '',
`department_id` int DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`custom_department` varchar(255) DEFAULT NULL,
`show_email` tinyint(1) DEFAULT '0',
`show_location` tinyint(1) DEFAULT '0',
`show_department` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_user_extensions_on_user_id` (`user_id`),
KEY `index_user_extensions_on_department_id` (`department_id`),
KEY `index_user_extensions_on_school_id_and_user_id` (`school_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_extensions`
--
LOCK TABLES `user_extensions` WRITE;
/*!40000 ALTER TABLE `user_extensions` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_extensions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_feedback_messages`
--
DROP TABLE IF EXISTS `user_feedback_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_feedback_messages` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`journals_for_message_id` int DEFAULT NULL,
`journals_for_message_type` varchar(255) DEFAULT NULL,
`viewed` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_feedback_messages_on_user_id_and_created_at` (`user_id`,`created_at`),
KEY `index_user_feedback_messages_on_journals_for_message_id` (`journals_for_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_feedback_messages`
--
LOCK TABLES `user_feedback_messages` WRITE;
/*!40000 ALTER TABLE `user_feedback_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_feedback_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_grades`
--
DROP TABLE IF EXISTS `user_grades`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_grades` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`project_id` int NOT NULL,
`grade` float DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_grades_on_grade` (`grade`),
KEY `index_user_grades_on_project_id` (`project_id`),
KEY `index_user_grades_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_grades`
--
LOCK TABLES `user_grades` WRITE;
/*!40000 ALTER TABLE `user_grades` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_grades` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_hidden_modules`
--
DROP TABLE IF EXISTS `user_hidden_modules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_hidden_modules` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`module_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_hidden_modules_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_hidden_modules`
--
LOCK TABLES `user_hidden_modules` WRITE;
/*!40000 ALTER TABLE `user_hidden_modules` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_hidden_modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_interests`
--
DROP TABLE IF EXISTS `user_interests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_interests` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`repertoire_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_user_interests_on_user_id` (`user_id`),
KEY `index_user_interests_on_repertoire_id` (`repertoire_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_interests`
--
LOCK TABLES `user_interests` WRITE;
/*!40000 ALTER TABLE `user_interests` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_interests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_levels`
--
DROP TABLE IF EXISTS `user_levels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_levels` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`level` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_levels`
--
LOCK TABLES `user_levels` WRITE;
/*!40000 ALTER TABLE `user_levels` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_levels` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_preferences`
--
DROP TABLE IF EXISTS `user_preferences`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_preferences` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL DEFAULT '0',
`others` text,
`hide_mail` tinyint(1) DEFAULT '0',
`time_zone` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_user_preferences_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_preferences`
--
LOCK TABLES `user_preferences` WRITE;
/*!40000 ALTER TABLE `user_preferences` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_preferences` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_score_details`
--
DROP TABLE IF EXISTS `user_score_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_score_details` (
`id` int NOT NULL AUTO_INCREMENT,
`current_user_id` int DEFAULT NULL,
`target_user_id` int DEFAULT NULL,
`score_type` varchar(255) DEFAULT NULL,
`score_action` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`old_score` int DEFAULT NULL,
`new_score` int DEFAULT NULL,
`current_user_level` int DEFAULT NULL,
`target_user_level` int DEFAULT NULL,
`score_changeable_obj_id` int DEFAULT NULL,
`score_changeable_obj_type` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_score_details`
--
LOCK TABLES `user_score_details` WRITE;
/*!40000 ALTER TABLE `user_score_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_score_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_scores`
--
DROP TABLE IF EXISTS `user_scores`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_scores` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`collaboration` int DEFAULT NULL,
`influence` int DEFAULT NULL,
`skill` int DEFAULT NULL,
`active` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_scores`
--
LOCK TABLES `user_scores` WRITE;
/*!40000 ALTER TABLE `user_scores` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_scores` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_searches`
--
DROP TABLE IF EXISTS `user_searches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_searches` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`search_type` int DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_searches_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_searches`
--
LOCK TABLES `user_searches` WRITE;
/*!40000 ALTER TABLE `user_searches` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_searches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_sources`
--
DROP TABLE IF EXISTS `user_sources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_sources` (
`id` int NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
`user_id` int DEFAULT NULL,
`uuid` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_user_sources_on_type_and_uuid` (`type`,`uuid`),
KEY `index_user_sources_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_sources`
--
LOCK TABLES `user_sources` WRITE;
/*!40000 ALTER TABLE `user_sources` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_sources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_statuses`
--
DROP TABLE IF EXISTS `user_statuses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_statuses` (
`id` int NOT NULL AUTO_INCREMENT,
`changesets_count` int DEFAULT NULL,
`watchers_count` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`grade` float DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_user_statuses_on_changesets_count` (`changesets_count`),
KEY `index_user_statuses_on_watchers_count` (`watchers_count`),
KEY `index_user_statuses_on_grade` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_statuses`
--
LOCK TABLES `user_statuses` WRITE;
/*!40000 ALTER TABLE `user_statuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_statuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_system_notices`
--
DROP TABLE IF EXISTS `user_system_notices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_system_notices` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`notice_type` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_user_system_notices_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_system_notices`
--
LOCK TABLES `user_system_notices` WRITE;
/*!40000 ALTER TABLE `user_system_notices` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_system_notices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_wechats`
--
DROP TABLE IF EXISTS `user_wechats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_wechats` (
`id` int NOT NULL AUTO_INCREMENT,
`subscribe` int DEFAULT NULL,
`openid` varchar(255) DEFAULT NULL,
`nickname` varchar(255) DEFAULT NULL,
`sex` int DEFAULT NULL,
`language` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`headimgurl` varchar(255) DEFAULT NULL,
`subscribe_time` varchar(255) DEFAULT NULL,
`unionid` varchar(255) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`groupid` int DEFAULT NULL,
`user_id` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`bindtype` int DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_wechats`
--
LOCK TABLES `user_wechats` WRITE;
/*!40000 ALTER TABLE `user_wechats` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_wechats` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT,
`login` varchar(255) NOT NULL DEFAULT '',
`hashed_password` varchar(40) NOT NULL DEFAULT '',
`firstname` varchar(30) NOT NULL DEFAULT '',
`lastname` varchar(255) NOT NULL DEFAULT '',
`mail` varchar(60) DEFAULT NULL,
`admin` tinyint(1) NOT NULL DEFAULT '0',
`status` int NOT NULL DEFAULT '1',
`last_login_on` datetime DEFAULT NULL,
`language` varchar(5) DEFAULT '',
`auth_source_id` int DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`identity_url` varchar(255) DEFAULT NULL,
`mail_notification` varchar(255) NOT NULL DEFAULT '',
`salt` varchar(64) DEFAULT NULL,
`gid` int DEFAULT NULL,
`visits` int DEFAULT '0',
`excellent_teacher` int DEFAULT '0',
`excellent_student` int DEFAULT '0',
`phone` varchar(255) DEFAULT NULL,
`authentication` tinyint(1) DEFAULT '0',
`grade` int DEFAULT '0',
`experience` int DEFAULT '0',
`nickname` varchar(255) DEFAULT NULL,
`show_realname` tinyint(1) DEFAULT '1',
`professional_certification` tinyint(1) DEFAULT '0',
`ID_number` varchar(255) DEFAULT NULL,
`certification` int DEFAULT '0',
`homepage_teacher` tinyint(1) DEFAULT '0',
`homepage_engineer` tinyint(1) DEFAULT '0',
`is_test` tinyint DEFAULT '0',
`ecoder_user_id` int DEFAULT '0',
`business` tinyint(1) DEFAULT '0',
`profile_completed` tinyint(1) DEFAULT '0',
`laboratory_id` bigint DEFAULT NULL,
`platform` varchar(255) DEFAULT '0',
`gitea_token` varchar(255) DEFAULT NULL,
`gitea_uid` int DEFAULT NULL,
`is_shixun_marker` tinyint(1) DEFAULT '0',
`is_sync_pwd` tinyint(1) DEFAULT '1',
`watchers_count` int DEFAULT '0',
`devops_step` int DEFAULT '0' COMMENT '0: uninit devops; 1: unverified; 2: verified',
PRIMARY KEY (`id`),
KEY `index_users_on_homepage_engineer` (`homepage_engineer`),
KEY `index_users_on_homepage_teacher` (`homepage_teacher`),
KEY `index_users_on_ecoder_user_id` (`ecoder_user_id`),
KEY `index_users_on_laboratory_id` (`laboratory_id`),
KEY `index_users_on_login` (`login`),
KEY `index_users_on_mail` (`mail`),
KEY `index_users_on_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'','','','Anonymous','358551897@qq.com',0,0,NULL,'',NULL,'2021-08-27 08:57:14','2021-08-27 08:57:14','AnonymousUser',NULL,'',NULL,NULL,0,0,0,'13333333333',0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge',NULL,NULL,0,1,0,0),(2,'ZnyasTFN','1d3dd001b5f65bee7817c118024721c2e6cdd879','','','ZnyasTFN@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','6aa50de7150db13ba4d8e6ad49e40439',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','d0918589184a0f53f273819d91d7aeb7f8d07b1f',41579,0,1,0,0),(3,'DxvLwRYF','c15e7e755319d866c5456a405c4df02790a847c3','','','DxvLwRYF@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','d4bcb8c3560cb56bb6d19d3138afa19e',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','39ceff555d804275ae8b8204f9bf5b8f2cebdf3b',41580,0,1,0,0),(4,'Zpxuokf9','83dda2f13b6a335afe6ed6d2f163419f91b256d0','','','Zpxuokf9@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','a02723dc3d4d2570d41235f5e04c66c2',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','4b7fd4d1f7b01797172173a9c804aa6ee96b98b7',41581,0,1,0,0),(5,'OxvEgfSs','4217333234131bf6571dc779aa24feefc7315833','','','OxvEgfSs@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','dcb809642d279c3cc00816f6cc9c28c3',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','c0b698259781c44cfd19922809570192c671169a',41582,0,1,0,0),(6,'T6yhtVbf','cd6a5a8d6d4158c4daf8b9f796214472452a675a','','','T6yhtVbf@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','a95862fe0d7328ca8ab46e4f1857ccdb',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','720fec8be622e482bcb1494600caf263c2d1799f',41583,0,1,0,0),(7,'v7VlJ1zM','05dc92145075df62d02c3ee56c6df571d51a3316','','','v7VlJ1zM@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','9c1a0860465ab617d1ea098bff58251e',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','d374325f963a8d0f0e4261c40a894f88df22d215',41584,0,1,0,0),(8,'jKeAkiRy','24ffb105d9be14a0bccd34ebc309b69ab5d6ca37','','','jKeAkiRy@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','0e7bcb8a4758aec20ec5ceb8cfec2e21',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','792fa69238235d32fa4c211b49a88b102d6c37f3',41585,0,1,0,0),(9,'mGKx2CQU','bf4ae2350ef6f887fb7fb8f8b72bd64377708c49','','','mGKx2CQU@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','fa09c02ffefde54c47d5ceb41685ff7e',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','3c78a3f3fa4a1177a977d2caafb91964e169151b',41586,0,1,0,0),(10,'JIH8mVUt','e1fb2c24883c9d6033ab3bb358559257f96345cd','','','JIH8mVUt@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','154b8377b50e5e290a150bef742569f5',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','79a8b6269cafeac79ed1878af0f6d04cedbcafa3',41587,0,1,0,0),(11,'furi2MpX','07cf01fab33f9757a7a8f59f9b1d6ad15a5a7e38','','','furi2MpX@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','b575f20f11deaf08d5a10e61a5f9bdd7',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','f300b911a8a5d8a5e2f6acc276443ad736967881',41588,0,1,0,0),(12,'BbcuFM2E','5f3c6c26ead480ef62d1880172980839a730f7cc','','','BbcuFM2E@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','7d4d36a626d734ca1b5d7fb6f86e0498',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','dc59343c3efd0288d348ba14cb39f926c7bdba9c',41589,0,1,0,0),(13,'kRjH5T94','07d8b5c6659dc9e4621b8145f75bbc6426588a8a','','','kRjH5T94@forge.com',0,1,NULL,'',NULL,'2021-08-27 10:05:25','2021-08-27 10:05:25','User',NULL,'','cdf06126f6777176cb370726b51e2fe3',NULL,0,0,0,NULL,0,0,0,NULL,1,0,NULL,0,0,0,0,0,0,0,NULL,'forge','60469a6a347807aa89c046e1a776b4bebecd3d1d',41590,0,1,0,0),(14,'qcmVUkXv','e102c2849d682e23e4c46fba31407012
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_authentications`
--
DROP TABLE IF EXISTS `users_authentications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_authentications` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`authentication_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_authentications`
--
LOCK TABLES `users_authentications` WRITE;
/*!40000 ALTER TABLE `users_authentications` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_authentications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `verification_codes`
--
DROP TABLE IF EXISTS `verification_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `verification_codes` (
`id` int NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL,
`code_type` int DEFAULT NULL,
`status` int DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `by_phone` (`phone`),
KEY `by_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `verification_codes`
--
LOCK TABLES `verification_codes` WRITE;
/*!40000 ALTER TABLE `verification_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `verification_codes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `version_releases`
--
DROP TABLE IF EXISTS `version_releases`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `version_releases` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`body` text,
`tag_name` varchar(255) DEFAULT NULL,
`target_commitish` varchar(255) DEFAULT NULL,
`draft` tinyint(1) DEFAULT '0',
`prerelease` tinyint(1) DEFAULT '0',
`tarball_url` varchar(255) DEFAULT NULL,
`zipball_url` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`version_gid` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`repository_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_version_releases_on_repository_id` (`repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `version_releases`
--
LOCK TABLES `version_releases` WRITE;
/*!40000 ALTER TABLE `version_releases` DISABLE KEYS */;
/*!40000 ALTER TABLE `version_releases` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `versions`
--
DROP TABLE IF EXISTS `versions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `versions` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`description` text,
`effective_date` date DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`wiki_page_title` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT 'open',
`sharing` varchar(255) NOT NULL DEFAULT 'none',
`user_id` int DEFAULT NULL,
`issues_count` int DEFAULT '0',
`closed_issues_count` int DEFAULT '0',
`percent` float DEFAULT '0',
PRIMARY KEY (`id`),
KEY `versions_project_id` (`project_id`),
KEY `index_versions_on_sharing` (`sharing`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `versions`
--
LOCK TABLES `versions` WRITE;
/*!40000 ALTER TABLE `versions` DISABLE KEYS */;
/*!40000 ALTER TABLE `versions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `visitors`
--
DROP TABLE IF EXISTS `visitors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `visitors` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`master_id` int DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_visitors_user_id` (`user_id`),
KEY `index_visitors_master_id` (`master_id`),
KEY `index_visitors_updated_on` (`updated_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `visitors`
--
LOCK TABLES `visitors` WRITE;
/*!40000 ALTER TABLE `visitors` DISABLE KEYS */;
/*!40000 ALTER TABLE `visitors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `watchers`
--
DROP TABLE IF EXISTS `watchers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `watchers` (
`id` int NOT NULL AUTO_INCREMENT,
`watchable_type` varchar(255) NOT NULL DEFAULT '',
`watchable_id` int NOT NULL DEFAULT '0',
`user_id` int DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `watchers_user_id_type` (`user_id`,`watchable_type`),
KEY `index_watchers_on_user_id` (`user_id`),
KEY `index_watchers_on_watchable_id_and_watchable_type` (`watchable_id`,`watchable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `watchers`
--
LOCK TABLES `watchers` WRITE;
/*!40000 ALTER TABLE `watchers` DISABLE KEYS */;
/*!40000 ALTER TABLE `watchers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `weapp_settings`
--
DROP TABLE IF EXISTS `weapp_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `weapp_settings` (
`id` bigint NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`online` tinyint(1) DEFAULT '0',
`position` int DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `weapp_settings`
--
LOCK TABLES `weapp_settings` WRITE;
/*!40000 ALTER TABLE `weapp_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `weapp_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `web_footer_companies`
--
DROP TABLE IF EXISTS `web_footer_companies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_footer_companies` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`logo_size` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `web_footer_companies`
--
LOCK TABLES `web_footer_companies` WRITE;
/*!40000 ALTER TABLE `web_footer_companies` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_footer_companies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `web_footer_oranizers`
--
DROP TABLE IF EXISTS `web_footer_oranizers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_footer_oranizers` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `web_footer_oranizers`
--
LOCK TABLES `web_footer_oranizers` WRITE;
/*!40000 ALTER TABLE `web_footer_oranizers` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_footer_oranizers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `websshes`
--
DROP TABLE IF EXISTS `websshes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `websshes` (
`id` int NOT NULL AUTO_INCREMENT,
`myshixun_id` int DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
`port` int DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `websshes`
--
LOCK TABLES `websshes` WRITE;
/*!40000 ALTER TABLE `websshes` DISABLE KEYS */;
/*!40000 ALTER TABLE `websshes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wechat_logs`
--
DROP TABLE IF EXISTS `wechat_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wechat_logs` (
`id` int NOT NULL AUTO_INCREMENT,
`openid` varchar(255) NOT NULL,
`request_raw` text,
`response_raw` text,
`session_raw` text,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_wechat_logs_on_openid` (`openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wechat_logs`
--
LOCK TABLES `wechat_logs` WRITE;
/*!40000 ALTER TABLE `wechat_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `wechat_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiki_content_versions`
--
DROP TABLE IF EXISTS `wiki_content_versions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wiki_content_versions` (
`id` int NOT NULL AUTO_INCREMENT,
`wiki_content_id` int NOT NULL,
`page_id` int NOT NULL,
`author_id` int DEFAULT NULL,
`data` longblob,
`compression` varchar(6) DEFAULT '',
`comments` varchar(255) DEFAULT '',
`updated_on` datetime NOT NULL,
`version` int NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_content_versions_wcid` (`wiki_content_id`),
KEY `index_wiki_content_versions_on_updated_on` (`updated_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiki_content_versions`
--
LOCK TABLES `wiki_content_versions` WRITE;
/*!40000 ALTER TABLE `wiki_content_versions` DISABLE KEYS */;
/*!40000 ALTER TABLE `wiki_content_versions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiki_contents`
--
DROP TABLE IF EXISTS `wiki_contents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wiki_contents` (
`id` int NOT NULL AUTO_INCREMENT,
`page_id` int NOT NULL,
`author_id` int DEFAULT NULL,
`text` longtext,
`comments` varchar(255) DEFAULT '',
`updated_on` datetime NOT NULL,
`version` int NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_contents_page_id` (`page_id`),
KEY `index_wiki_contents_on_author_id` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiki_contents`
--
LOCK TABLES `wiki_contents` WRITE;
/*!40000 ALTER TABLE `wiki_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `wiki_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiki_pages`
--
DROP TABLE IF EXISTS `wiki_pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wiki_pages` (
`id` int NOT NULL AUTO_INCREMENT,
`wiki_id` int NOT NULL,
`title` varchar(255) NOT NULL,
`created_on` datetime NOT NULL,
`protected` tinyint(1) NOT NULL DEFAULT '0',
`parent_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `wiki_pages_wiki_id_title` (`wiki_id`,`title`),
KEY `index_wiki_pages_on_wiki_id` (`wiki_id`),
KEY `index_wiki_pages_on_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiki_pages`
--
LOCK TABLES `wiki_pages` WRITE;
/*!40000 ALTER TABLE `wiki_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `wiki_pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiki_redirects`
--
DROP TABLE IF EXISTS `wiki_redirects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wiki_redirects` (
`id` int NOT NULL AUTO_INCREMENT,
`wiki_id` int NOT NULL,
`title` varchar(255) DEFAULT NULL,
`redirects_to` varchar(255) DEFAULT NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`),
KEY `index_wiki_redirects_on_wiki_id` (`wiki_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiki_redirects`
--
LOCK TABLES `wiki_redirects` WRITE;
/*!40000 ALTER TABLE `wiki_redirects` DISABLE KEYS */;
/*!40000 ALTER TABLE `wiki_redirects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wikis`
--
DROP TABLE IF EXISTS `wikis`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wikis` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL,
`start_page` varchar(255) NOT NULL,
`status` int NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `wikis_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wikis`
--
LOCK TABLES `wikis` WRITE;
/*!40000 ALTER TABLE `wikis` DISABLE KEYS */;
/*!40000 ALTER TABLE `wikis` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zip_packs`
--
DROP TABLE IF EXISTS `zip_packs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `zip_packs` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`homework_id` int DEFAULT NULL,
`file_digest` varchar(255) DEFAULT NULL,
`file_path` varchar(255) DEFAULT NULL,
`pack_times` int DEFAULT '1',
`pack_size` float DEFAULT '0',
`file_digests` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`container_id` int DEFAULT '0',
`container_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_zip_packs_on_container_id_and_container_type` (`container_id`,`container_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zip_packs`
--
LOCK TABLES `zip_packs` WRITE;
/*!40000 ALTER TABLE `zip_packs` DISABLE KEYS */;
/*!40000 ALTER TABLE `zip_packs` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-08-27 18:07:21