blob: 3f62ae80a7c45a95556a6442214fbf9b708593fb (
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;
|
