17 lines
888 B
SQL
17 lines
888 B
SQL
start transaction;
|
|
|
|
alter table `guild` add column `owner_vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'owner vip等级';
|
|
alter table `guild` add column `owner_head` int(11) NOT NULL DEFAULT '0' COMMENT 'owner 头像框';
|
|
alter table `guild` add column `creator_vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'creator vip等级';
|
|
alter table `guild` add column `creator_head` int(11) NOT NULL DEFAULT '0' COMMENT 'creator 头像框';
|
|
|
|
alter table `guild_apply` add column `sender_vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'vip_lv';
|
|
alter table `guild_apply` add column `sender_head` int(11) NOT NULL DEFAULT '0' COMMENT 'head';
|
|
|
|
alter table `friend_apply` add column `sender_vip_lv` int(11) NOT NULL DEFAULT '0' COMMENT 'vip_lv';
|
|
alter table `friend_apply` add column `sender_head` int(11) NOT NULL DEFAULT '0' COMMENT 'head';
|
|
|
|
insert into version (version) values(2020112301);
|
|
|
|
commit;
|