-- Full SQL of v0.5.1, please not modify this file(It must be same as the file in the release package) CREATE DATABASE IF NOT EXISTS dbgpt; use dbgpt; -- For alembic migration tool CREATE TABLE IF NOT EXISTS `alembic_version` ( version_num VARCHAR(32) NOT NULL, CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num) ) DEFAULT CHARSET=utf8mb4 ; CREATE TABLE IF NOT EXISTS `knowledge_space` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'auto increment id', `name` varchar(100) NOT NULL COMMENT 'knowledge space name', `vector_type` varchar(50) NOT NULL COMMENT 'vector type', `desc` varchar(500) NOT NULL COMMENT 'description', `owner` varchar(100) DEFAULT NULL COMMENT 'owner', `context` TEXT DEFAULT NULL COMMENT 'context argument', `gmt_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', PRIMARY KEY (`id`), KEY `idx_name` (`name`) COMMENT 'index:idx_name' ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='knowledge space table'; CREATE TABLE IF NOT EXISTS `knowledge_document` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'auto increment id', `doc_name` varchar(100) NOT NULL COMMENT 'document path name', `doc_type` varchar(50) NOT NULL COMMENT 'doc type', `space` varchar(50) NOT NULL COMMENT 'knowledge space', `chunk_size` int NOT NULL COMMENT 'chunk size', `last_sync` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'last sync time', `status` varchar(50) NOT NULL COMMENT 'status TODO,RUNNING,FAILED,FINISHED', `content` LONGTEXT NOT NULL COMMENT 'knowledge embedding sync result', `result` TEXT NULL COMMENT 'knowledge content', `vector_ids` LONGTEXT NULL COMMENT 'vector_ids', `summary` LONGTEXT NULL COMMENT 'knowledge summary', `gmt_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', PRIMARY KEY (`id`), KEY `idx_doc_name` (`doc_name`) COMMENT 'index:idx_doc_name' ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='knowledge document table'; CREATE TABLE IF NOT EXISTS `document_chunk` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'auto increment id', `doc_name` varchar(100) NOT NULL COMMENT 'document path name', `doc_type` varchar(50) NOT NULL COMMENT 'doc type', `document_id` int NOT NULL COMMENT 'document parent id', `content` longtext NOT NULL COMMENT 'chunk content', `meta_info` varchar(200) NOT NULL COMMENT 'metadata info', `gmt_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', PRIMARY KEY (`id`), KEY `idx_document_id` (`document_id`) COMMENT 'index:document_id' ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='knowledge document chunk detail'; CREATE TABLE IF NOT EXISTS `connect_config` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `db_type` varchar(255) NOT NULL COMMENT 'db type', `db_name` varchar(255) NOT NULL COMMENT 'db name', `db_path` varchar(255) DEFAULT NULL COMMENT 'file db path', `db_host` varchar(255) DEFAULT NULL COMMENT 'db connect host(not file db)', `db_port` varchar(255) DEFAULT NULL COMMENT 'db cnnect port(not file db)', `db_user` varchar(255) DEFAULT NULL COMMENT 'db user', `db_pwd` varchar(255) DEFAULT NULL COMMENT 'db password', `comment` text COMMENT 'db comment', `sys_code` varchar(128) DEFAULT NULL COMMENT 'System code', PRIMARY KEY (`id`), UNIQUE KEY `uk_db` (`db_name`), KEY `idx_q_db_type` (`db_type`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT 'Connection confi'; CREATE TABLE IF NOT EXISTS `chat_history` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `conv_uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Conversation record unique id', `chat_mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Conversation scene mode', `summary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Conversation record summary', `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'interlocutor', `messages` text COLLATE utf8mb4_unicode_ci COMMENT 'Conversation details', `message_ids` text COLLATE utf8mb4_unicode_ci COMMENT 'Message id list, split by comma', `sys_code` varchar(128) DEFAULT NULL COMMENT 'System code', `gmt_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', UNIQUE KEY `conv_uid` (`conv_uid`), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'Chat history'; CREATE TABLE IF NOT EXISTS `chat_history_message` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `conv_uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Conversation record unique id', `index` int NOT NULL COMMENT 'Message index', `round_index` int NOT NULL COMMENT 'Round of conversation', `message_detail` text COLLATE utf8mb4_unicode_ci COMMENT 'Message details, json format', `gmt_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', UNIQUE KEY `message_uid_index` (`conv_uid`, `index`), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'Chat history message'; CREATE TABLE IF NOT EXISTS `chat_feed_back` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `conv_uid` varchar(128) DEFAULT NULL COMMENT 'Conversation ID', `conv_index` int(4) DEFAULT NULL COMMENT 'Round of conversation', `score` int(1) DEFAULT NULL COMMENT 'Score of user', `ques_type` varchar(32) DEFAULT NULL COMMENT 'User question category', `question` longtext DEFAULT NULL COMMENT 'User question', `knowledge_space` varchar(128) DEFAULT NULL COMMENT 'Knowledge space name', `messages` longtext DEFAULT NULL COMMENT 'The details of user feedback', `user_name` varchar(128) DEFAULT NULL COMMENT 'User name', `gmt_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', PRIMARY KEY (`id`), UNIQUE KEY `uk_conv` (`conv_uid`,`conv_index`), KEY `idx_conv` (`conv_uid`,`conv_index`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='User feedback table'; CREATE TABLE IF NOT EXISTS `my_plugin` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `tenant` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'user tenant', `user_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'user code', `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'user name', `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'plugin name', `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'plugin package file name', `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin type', `version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin version', `use_count` int DEFAULT NULL COMMENT 'plugin total use count', `succ_count` int DEFAULT NULL COMMENT 'plugin total success count', `sys_code` varchar(128) DEFAULT NULL COMMENT 'System code', `gmt_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'plugin install time', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='User plugin table'; CREATE TABLE IF NOT EXISTS `plugin_hub` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'plugin name', `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'plugin description', `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin author', `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin author email', `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin type', `version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin version', `storage_channel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin storage channel', `storage_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin download url', `download_param` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'plugin download param', `gmt_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'plugin upload time', `installed` int DEFAULT NULL COMMENT 'plugin already installed count', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Plugin Hub table'; CREATE TABLE IF NOT EXISTS `prompt_manage` ( `id` int(11) NOT NULL AUTO_INCREMENT, `chat_scene` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Chat scene', `sub_chat_scene` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Sub chat scene', `prompt_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Prompt type: common or private', `prompt_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'prompt name', `content` longtext COLLATE utf8mb4_unicode_ci COMMENT 'Prompt content', `input_variables` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Prompt input variables(split by comma))', `model` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Prompt model name(we can use different models for different prompt)', `prompt_language` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Prompt language(eg:en, zh-cn)', `prompt_format` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'f-string' COMMENT 'Prompt format(eg: f-string, jinja2)', `prompt_desc` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Prompt description', `user_name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'User name', `sys_code` varchar(128) DEFAULT NULL COMMENT 'System code', `gmt_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time', `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time', PRIMARY KEY (`id`), UNIQUE KEY `prompt_name_uiq` (`prompt_name`, `sys_code`, `prompt_language`, `model`), KEY `gmt_created_idx` (`gmt_created`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Prompt management table'; CREATE TABLE IF NOT EXISTS `gpts_conversations` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `conv_id` varchar(255) NOT NULL COMMENT 'The unique id of the conversation record', `user_goal` text NOT NULL COMMENT 'User''s goals content', `gpts_name` varchar(255) NOT NULL COMMENT 'The gpts name', `state` varchar(255) DEFAULT NULL COMMENT 'The gpts state', `max_auto_reply_round` int(11) NOT NULL COMMENT 'max auto reply round', `auto_reply_count` int(11) NOT NULL COMMENT 'auto reply count', `user_code` varchar(255) DEFAULT NULL COMMENT 'user code', `sys_code` varchar(255) DEFAULT NULL COMMENT 'system app ', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', `team_mode` varchar(255) NULL COMMENT 'agent team work mode', PRIMARY KEY (`id`), UNIQUE KEY `uk_gpts_conversations` (`conv_id`), KEY `idx_gpts_name` (`gpts_name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT="gpt conversations"; CREATE TABLE IF NOT EXISTS `gpts_instance` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `gpts_name` varchar(255) NOT NULL COMMENT 'Current AI assistant name', `gpts_describe` varchar(2255) NOT NULL COMMENT 'Current AI assistant describe', `resource_db` text COMMENT 'List of structured database names contained in the current gpts', `resource_internet` text COMMENT 'Is it possible to retrieve information from the internet', `resource_knowledge` text COMMENT 'List of unstructured database names contained in the current gpts', `gpts_agents` varchar(1000) DEFAULT NULL COMMENT 'List of agents names contained in the current gpts', `gpts_models` varchar(1000) DEFAULT NULL COMMENT 'List of llm model names contained in the current gpts', `language` varchar(100) DEFAULT NULL COMMENT 'gpts language', `user_code` varchar(255) NOT NULL COMMENT 'user code', `sys_code` varchar(255) DEFAULT NULL COMMENT 'system app code', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', `team_mode` varchar(255) NOT NULL COMMENT 'Team work mode', `is_sustainable` tinyint(1) NOT NULL COMMENT 'Applications for sustainable dialogue', PRIMARY KEY (`id`), UNIQUE KEY `uk_gpts` (`gpts_name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT="gpts instance"; CREATE TABLE `gpts_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `conv_id` varchar(255) NOT NULL COMMENT 'The unique id of the conversation record', `sender` varchar(255) NOT NULL COMMENT 'Who speaking in the current conversation turn', `receiver` varchar(255) NOT NULL COMMENT 'Who receive message in the current conversation turn', `model_name` varchar(255) DEFAULT NULL COMMENT 'message generate model', `rounds` int(11) NOT NULL COMMENT 'dialogue turns', `content` text COMMENT 'Content of the speech', `current_goal` text COMMENT 'The target corresponding to the current message', `context` text COMMENT 'Current conversation context', `review_info` text COMMENT 'Current conversation review info', `action_report` text COMMENT 'Current conversation action report', `role` varchar(255) DEFAULT NULL COMMENT 'The role of the current message content', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', PRIMARY KEY (`id`), KEY `idx_q_messages` (`conv_id`,`rounds`,`sender`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT="gpts message"; CREATE TABLE `gpts_plans` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `conv_id` varchar(255) NOT NULL COMMENT 'The unique id of the conversation record', `sub_task_num` int(11) NOT NULL COMMENT 'Subtask number', `sub_task_title` varchar(255) NOT NULL COMMENT 'subtask title', `sub_task_content` text NOT NULL COMMENT 'subtask content', `sub_task_agent` varchar(255) DEFAULT NULL COMMENT 'Available agents corresponding to subtasks', `resource_name` varchar(255) DEFAULT NULL COMMENT 'resource name', `rely` varchar(255) DEFAULT NULL COMMENT 'Subtask dependencies，like: 1,2,3', `agent_model` varchar(255) DEFAULT NULL COMMENT 'LLM model used by subtask processing agents', `retry_times` int(11) DEFAULT NULL COMMENT 'number of retries', `max_retry_times` int(11) DEFAULT NULL COMMENT 'Maximum number of retries', `state` varchar(255) DEFAULT NULL COMMENT 'subtask status', `result` longtext COMMENT 'subtask result', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', PRIMARY KEY (`id`), UNIQUE KEY `uk_sub_task` (`conv_id`,`sub_task_num`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT="gpt plan"; -- dbgpt.dbgpt_serve_flow definition CREATE TABLE `dbgpt_serve_flow` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'Auto increment id', `uid` varchar(128) NOT NULL COMMENT 'Unique id', `dag_id` varchar(128) DEFAULT NULL COMMENT 'DAG id', `name` varchar(128) DEFAULT NULL COMMENT 'Flow name', `flow_data` text COMMENT 'Flow data, JSON format', `user_name` varchar(128) DEFAULT NULL COMMENT 'User name', `sys_code` varchar(128) DEFAULT NULL COMMENT 'System code', `gmt_created` datetime DEFAULT NULL COMMENT 'Record creation time', `gmt_modified` datetime DEFAULT NULL COMMENT 'Record update time', `flow_category` varchar(64) DEFAULT NULL COMMENT 'Flow category', `description` varchar(512) DEFAULT NULL COMMENT 'Flow description', `state` varchar(32) DEFAULT NULL COMMENT 'Flow state', `error_message` varchar(512) NULL comment 'Error message', `source` varchar(64) DEFAULT NULL COMMENT 'Flow source', `source_url` varchar(512) DEFAULT NULL COMMENT 'Flow source url', `version` varchar(32) DEFAULT NULL COMMENT 'Flow version', `label` varchar(128) DEFAULT NULL COMMENT 'Flow label', `editable` int DEFAULT NULL COMMENT 'Editable, 0: editable, 1: not editable', PRIMARY KEY (`id`), UNIQUE KEY `uk_uid` (`uid`), KEY `ix_dbgpt_serve_flow_sys_code` (`sys_code`), KEY `ix_dbgpt_serve_flow_uid` (`uid`), KEY `ix_dbgpt_serve_flow_dag_id` (`dag_id`), KEY `ix_dbgpt_serve_flow_user_name` (`user_name`), KEY `ix_dbgpt_serve_flow_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- dbgpt.gpts_app definition CREATE TABLE `gpts_app` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `app_code` varchar(255) NOT NULL COMMENT 'Current AI assistant code', `app_name` varchar(255) NOT NULL COMMENT 'Current AI assistant name', `app_describe` varchar(2255) NOT NULL COMMENT 'Current AI assistant describe', `language` varchar(100) NOT NULL COMMENT 'gpts language', `team_mode` varchar(255) NOT NULL COMMENT 'Team work mode', `team_context` text COMMENT 'The execution logic and team member content that teams with different working modes rely on', `user_code` varchar(255) DEFAULT NULL COMMENT 'user code', `sys_code` varchar(255) DEFAULT NULL COMMENT 'system app code', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', `icon` varchar(1024) DEFAULT NULL COMMENT 'app icon, url', PRIMARY KEY (`id`), UNIQUE KEY `uk_gpts_app` (`app_name`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE `gpts_app_collection` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `app_code` varchar(255) NOT NULL COMMENT 'Current AI assistant code', `user_code` int(11) NOT NULL COMMENT 'user code', `sys_code` varchar(255) NOT NULL COMMENT 'system app code', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', PRIMARY KEY (`id`), KEY `idx_app_code` (`app_code`), KEY `idx_user_code` (`user_code`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT="gpt collections"; -- dbgpt.gpts_app_detail definition CREATE TABLE `gpts_app_detail` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'autoincrement id', `app_code` varchar(255) NOT NULL COMMENT 'Current AI assistant code', `app_name` varchar(255) NOT NULL COMMENT 'Current AI assistant name', `agent_name` varchar(255) NOT NULL COMMENT ' Agent name', `node_id` varchar(255) NOT NULL COMMENT 'Current AI assistant Agent Node id', `resources` text COMMENT 'Agent bind resource', `prompt_template` text COMMENT 'Agent bind template', `llm_strategy` varchar(25) DEFAULT NULL COMMENT 'Agent use llm strategy', `llm_strategy_value` text COMMENT 'Agent use llm strategy value', `created_at` datetime DEFAULT NULL COMMENT 'create time', `updated_at` datetime DEFAULT NULL COMMENT 'last update time', PRIMARY KEY (`id`), UNIQUE KEY `uk_gpts_app_agent_node` (`app_name`,`agent_name`,`node_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE DATABASE IF NOT EXISTS EXAMPLE_1; use EXAMPLE_1; CREATE TABLE IF NOT EXISTS `users` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL COMMENT '用户名', `password` varchar(50) NOT NULL COMMENT '密码', `email` varchar(50) NOT NULL COMMENT '邮箱', `phone` varchar(20) DEFAULT NULL COMMENT '电话', PRIMARY KEY (`id`), KEY `idx_username` (`username`) COMMENT '索引：按用户名查询' ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='聊天用户表'; INSERT INTO users (username, password, email, phone) VALUES ('user_1', 'password_1', 'user_1@example.com', '12345678901'); INSERT INTO users (username, password, email, phone) VALUES ('user_2', 'password_2', 'user_2@example.com', '12345678902'); INSERT INTO users (username, password, email, phone) VALUES ('user_3', 'password_3', 'user_3@example.com', '12345678903'); INSERT INTO users (username, password, email, phone) VALUES ('user_4', 'password_4', 'user_4@example.com', '12345678904'); INSERT INTO users (username, password, email, phone) VALUES ('user_5', 'password_5', 'user_5@example.com', '12345678905'); INSERT INTO users (username, password, email, phone) VALUES ('user_6', 'password_6', 'user_6@example.com', '12345678906'); INSERT INTO users (username, password, email, phone) VALUES ('user_7', 'password_7', 'user_7@example.com', '12345678907'); INSERT INTO users (username, password, email, phone) VALUES ('user_8', 'password_8', 'user_8@example.com', '12345678908'); INSERT INTO users (username, password, email, phone) VALUES ('user_9', 'password_9', 'user_9@example.com', '12345678909'); INSERT INTO users (username, password, email, phone) VALUES ('user_10', 'password_10', 'user_10@example.com', '12345678900'); INSERT INTO users (username, password, email, phone) VALUES ('user_11', 'password_11', 'user_11@example.com', '12345678901'); INSERT INTO users (username, password, email, phone) VALUES ('user_12', 'password_12', 'user_12@example.com', '12345678902'); INSERT INTO users (username, password, email, phone) VALUES ('user_13', 'password_13', 'user_13@example.com', '12345678903'); INSERT INTO users (username, password, email, phone) VALUES ('user_14', 'password_14', 'user_14@example.com', '12345678904'); INSERT INTO users (username, password, email, phone) VALUES ('user_15', 'password_15', 'user_15@example.com', '12345678905'); INSERT INTO users (username, password, email, phone) VALUES ('user_16', 'password_16', 'user_16@example.com', '12345678906'); INSERT INTO users (username, password, email, phone) VALUES ('user_17', 'password_17', 'user_17@example.com', '12345678907'); INSERT INTO users (username, password, email, phone) VALUES ('user_18', 'password_18', 'user_18@example.com', '12345678908'); INSERT INTO users (username, password, email, phone) VALUES ('user_19', 'password_19', 'user_19@example.com', '12345678909'); INSERT INTO users (username, password, email, phone) VALUES ('user_20', 'password_20', 'user_20@example.com', '12345678900');