relation/sql/relationdb_n_migrate_201210_01.sql
aozhiwei 67a13aefe4 1
2020-12-10 17:30:30 +08:00

13 lines
364 B
SQL

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;