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