start transaction;

LOCK TABLES `guild` WRITE;
alter table `guild` add column `owner_sex` int(11) NOT NULL DEFAULT '0' COMMENT 'owner 性别';
alter table `guild` add column `creator_sex` int(11) NOT NULL DEFAULT '0' COMMENT 'creator 性别';
UNLOCK TABLES;

LOCK TABLES `version` WRITE;
insert into `version` (version) values(2020121001);
UNLOCK TABLES;

commit;