blob: b9a9b9f61e8c763e9acea398d84ddd3dbda112af (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE usrgrp_tmp (
usrgrpid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (usrgrpid)
) ENGINE=InnoDB;
CREATE INDEX usrgrp_1 on usrgrp_tmp (name);
insert into usrgrp_tmp select * from usrgrp;
drop table usrgrp;
alter table usrgrp_tmp rename usrgrp;
|