���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/doc/update_db/update_209.sql
���ѧ٧ѧ�
CREATE TABLE `lh_group_chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `status` int(11) NOT NULL, `time` int(11) NOT NULL, `user_id` int(11) NOT NULL, `last_msg_op_id` bigint(20) NOT NULL, `last_msg` varchar(200) NOT NULL, `last_user_msg_time` int(11) NOT NULL, `last_msg_id` bigint(20) NOT NULL, `type` tinyint(1) NOT NULL DEFAULT 0, `tm` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE `lh_group_msg` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `time` int(11) NOT NULL, `chat_id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `name_support` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `meta_msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `chat_id_id` (`chat_id`,`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE `lh_group_chat_member` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `group_id` bigint(20) NOT NULL, `last_activity` int(11) NOT NULL, `jtime` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `group_id` (`group_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�