blob: d009ecf2de5aa93bdde83fecd7f0bdfe34b2177f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE rights_tmp (
rightid bigint unsigned DEFAULT '0' NOT NULL,
groupid bigint unsigned DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
permission integer DEFAULT '0' NOT NULL,
id bigint unsigned ,
PRIMARY KEY (rightid)
) ENGINE=InnoDB;
CREATE INDEX rights_1 on rights_tmp (groupid);
insert into rights_tmp select * from rights;
drop table rights;
alter table rights_tmp rename rights;
|