MySQL

set SQL_SAFE_UPDATES=0;
use mars5_cloud_lulu;
update mars_bit_map set `category`=11;
set SQL_SAFE_UPDATES=1;

 

rename table apk_permission_info to mars_bit_map;
alter table mars_bit_map change `id` `bitMap` varbinary(255) NOT NULL;
alter table mars_bit_map change `permission` `value` varchar(128) COLLATE utf8_bin DEFAULT NULL;
alter table mars_bit_map change `summary` `description` varchar(512) COLLATE utf8_bin DEFAULT NULL;
alter table mars_bit_map add `comment` varchar(128) COLLATE utf8_bin DEFAULT NULL;
alter table mars_bit_map add `extern1` varchar(128) COLLATE utf8_bin DEFAULT NULL;
alter table mars_bit_map add `extern2` int(11) DEFAULT NULL;
alter table mars_bit_map add `category` int(11) NOT NULL;
alter table mars_bit_map drop primary key, add primary key (`category`,`bitMap`);
alter table mars_bit_map modify `category` int(11) NOT NULL first;

CREATE TABLE IF NOT EXISTS `mars_bit_map` (
`category` int(11) NOT NULL,
`bitMap` varbinary(255) NOT NULL,
`value` varchar(128) COLLATE utf8_bin DEFAULT NULL,
`description` varchar(512) COLLATE utf8_bin DEFAULT NULL,
`comment` varchar(128) COLLATE utf8_bin DEFAULT NULL,
`extern1` varchar(128) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (`category`,`bitMap`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

 

set SQL_SAFE_UPDATES=0;
use mars5_cloud_lulu;
drop table mars_bit_map;
set SQL_SAFE_UPDATES=1;