WeGPT

Flutter 版本的ChatGPT，支持iOS、Android、Windows、MACOS、Liniux和Web。后端使用Golang Fiber框架+GOGRPC开发。实现快速搭建ChatGPT聊天机器人。 app目录下是对应Flutter App端代码。 server目录下是服务端golang代码。

后端服务需要在MySQL中创建`gpt_app`数据库，然后使用sql 语句创建如下表：

免费用户可用免费消息数

CREATE TABLE `free_usages` (
  `user_id` int NOT NULL,
  `message_count` int DEFAULT '5',
  `created_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

用户邀请码

REATE TABLE `invite_codes` (
  `user_id` int NOT NULL,
  `code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

用户登录token

CREATE TABLE `tokens` (
  `user_id` int NOT NULL,
  `token` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

聊天消息tokens

CREATE TABLE `token_usages` (
  `user_id` int NOT NULL,
  `token_used` int NOT NULL,
  `reset_date` date NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

用户表

CREATE TABLE `users` (
  `id` int NOT NULL,
  `email` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inviter_id` int NOT NULL,
  `is_vip` int NOT NULL DEFAULT '0',
  `free_usage` int NOT NULL DEFAULT '10',
  `vip_started_at` timestamp NULL DEFAULT NULL,
  `vip_ended_at` timestamp NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

登录验证码

CREATE TABLE `verify_codes` (
  `code` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `used` int NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;