1
ALTER TABLE `sessions` DROP INDEX `id_ses`;
2
ALTER TABLE `sessions` ADD INDEX ( `phpid_ses` );
3
ALTER TABLE `sessions` ADD INDEX ( `user_ses` );
4
ALTER TABLE `sessions` ADD INDEX ( `cookie_expire_ses` );
5
ALTER TABLE `locks` DROP INDEX `id_lok`;
6
ALTER TABLE `locks` ADD INDEX ( `resource_lok` );
7
ALTER TABLE `pageTemplates` DROP INDEX `id_pt`;
8
ALTER TABLE `regenerator` DROP INDEX `page_reg`;
9
ALTER TABLE `contactDatas` DROP INDEX `id_cd`;
10
ALTER TABLE `I18NM_messages` ADD INDEX ( `module` );
11
ALTER TABLE `languages` DROP INDEX `code_lng`;
12
ALTER TABLE `linx_tree_public` DROP INDEX `id_ltr`;
13
ALTER TABLE `log` DROP INDEX `id_ulo`;
14
ALTER TABLE `modules` DROP INDEX `id_mod`;
15
ALTER TABLE `mod_standard_rows` DROP INDEX `id_row`;
16
ALTER TABLE `pages` DROP INDEX `id_pag`;
17
ALTER TABLE `pagesBaseData_archived` DROP INDEX `id_pbd`;
18
ALTER TABLE `pagesBaseData_deleted` DROP INDEX `id_pbd`;
19
ALTER TABLE `pagesBaseData_edited` DROP INDEX `id_pbd`;
20
ALTER TABLE `pagesBaseData_public` DROP INDEX `id_pbd`;
21
ALTER TABLE `profiles` DROP INDEX `id_pr`;
22
ALTER TABLE `profilesUsers` DROP INDEX `id_pru`;
23
ALTER TABLE `profilesUsersGroups` DROP INDEX `id_prg`;
24
ALTER TABLE `profilesUsers_validators` DROP INDEX `id_puv`;
25
ALTER TABLE `resources` DROP INDEX `id_res`;
26
ALTER TABLE `resourceStatuses` DROP INDEX `id_rs`;
27
ALTER TABLE `resourceValidations` DROP INDEX `id_rv`;
28
ALTER TABLE `websites` DROP INDEX `id_web`;
29
delete FROM `profileUsersByGroup` WHERE `userId_gu`='1';
b'\\ No newline at end of file'