relation/sql/relationdb_n_migrate_201118_02.sql
aozhiwei a7bcfab146 1
2020-11-18 10:54:28 +08:00

12 lines
353 B
SQL

start transaction;
alter table `user` add column `gameid` int(11) NOT NULL DEFAULT '0' COMMENT 'gameid';
alter table `user` add column `channel` int(11) NOT NULL DEFAULT '0' COMMENT 'channel';
alter table `user` add KEY `gameid` (`gameid`);
alter table `user` add KEY `channel` (`channel`);
insert into version (version) values(2020111802);
commit;