3.5.0.sql 3.8 KB
Newer Older
chenweijian's avatar
chenweijian committed
1 2
ALTER TABLE hilo.group_power ADD nameplate varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' NOT NULL COMMENT '家族铭牌';
ALTER TABLE hilo.group_power ADD declaration varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' NOT NULL COMMENT '家族宣言';
chenweijian's avatar
chenweijian committed
3
ALTER TABLE hilo.group_power ADD icon varchar(200) DEFAULT '' NOT NULL COMMENT '家族头像';
chenweijian's avatar
chenweijian committed
4 5
update hilo.group_power set nameplate = id;
CREATE UNIQUE INDEX nameplate_IDX USING BTREE ON hilo.group_power (nameplate);
chenweijian's avatar
chenweijian committed
6 7 8 9 10 11 12 13 14 15 16 17 18

CREATE TABLE `group_power_invite_join` (
                                           `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                                           `user_id` bigint unsigned NOT NULL COMMENT '被邀请者id',
                                           `group_power_id` bigint unsigned NOT NULL,
                                           `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                           `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                           `invite_user_id` bigint unsigned NOT NULL COMMENT '邀请者id',
                                           `is_accept` tinyint NOT NULL DEFAULT '0' COMMENT '是否已经接受邀请',
                                           PRIMARY KEY (`id`),
                                           UNIQUE KEY `user_group` (`user_id`,`group_power_id`),
                                           KEY `group_power_id` (`group_power_id`),
                                           KEY `invite_user_id` (`invite_user_id`)
chenweijian's avatar
chenweijian committed
19 20 21 22 23 24 25 26 27
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邀请加入家族';

CREATE TABLE `group_power_apply_join` (
                                          `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                                          `user_id` bigint unsigned NOT NULL COMMENT '申请者id',
                                          `group_power_id` bigint unsigned NOT NULL,
                                          `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                          `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                          `is_accept` tinyint NOT NULL DEFAULT '0' COMMENT '是否已经接受',
chenweijian's avatar
chenweijian committed
28
                                          `mgr_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '审核的管理员id',
chenweijian's avatar
chenweijian committed
29
                                          PRIMARY KEY (`id`),
chenweijian's avatar
chenweijian committed
30 31
                                          KEY `group_power_id` (`group_power_id`),
                                          KEY `user_id` (`user_id`) USING BTREE
chenweijian's avatar
chenweijian committed
32 33 34
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='申请加入家族';

CREATE TABLE `group_power_quit_log` (
chenweijian's avatar
chenweijian committed
35 36 37
                                        `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                                        `user_id` bigint unsigned NOT NULL COMMENT '用户id',
                                        `mgr_id` bigint unsigned NOT NULL COMMENT '操作人id',
chenweijian's avatar
chenweijian committed
38 39
                                        `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                        `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
chenweijian's avatar
chenweijian committed
40
                                        `group_power_id` bigint unsigned NOT NULL,
chenweijian's avatar
chenweijian committed
41 42 43 44 45
                                        PRIMARY KEY (`id`),
                                        KEY `user_id` (`user_id`) USING BTREE,
                                        KEY `created_time` (`created_time`) USING BTREE,
                                        KEY `mgr_id` (`mgr_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;