| 2d32cef3 |
1 | modify users to cbtree unique on users_id |
| 2 | CREATE INDEX i_usr_login ON users (login) |
| 3 | modify i_usr_login to btree |
| 4 | |
| 5 | CREATE INDEX i_usr_name ON users (first, last) |
| 6 | modify i_usr_name to cbtree on first, last |
| 7 | |
| 8 | CREATE INDEX i_usr_last ON users (last, first) |
| 9 | modify i_usr_last to cbtree on last, first |
| 10 | |
| 11 | CREATE INDEX i_usr_uid ON users (uid) |
| 12 | modify i_usr_uid to btree |
| 13 | CREATE INDEX i_usr_pop ON users (pop_id) |
| 14 | modify i_usr_pop to btree |
| 15 | |
| 16 | modify krbmap to btree unique on users_id |
| 17 | CREATE INDEX i_krb_str ON krbmap (string_id) |
| 18 | modify i_krb_str to btree |
| 19 | |
| 20 | modify machine to cbtree unique on mach_id |
| 21 | CREATE INDEX i_mac_name ON machine (name) |
| 22 | modify i_mac_name to btree |
| 23 | |
| 24 | modify cluster to cbtree unique on clu_id |
| 25 | CREATE INDEX i_clu_name ON cluster (name) |
| 26 | modify i_clu_name to btree |
| 27 | |
| 28 | modify mcmap to cbtree on clu_id |
| 29 | CREATE INDEX i_mcm_mach ON mcmap (mach_id) |
| 30 | modify i_mcm_mach to cbtree |
| 31 | |
| 32 | modify svc to cbtree on clu_id |
| 33 | |
| 34 | modify servers to btree on name |
| 35 | |
| 36 | modify serverhosts to btree on service |
| 37 | CREATE INDEX i_sho_mach ON serverhosts (mach_id) |
| 38 | modify i_sho_mach to cbtree |
| 39 | |
| 40 | modify list to cbtree unique on list_id |
| 41 | CREATE INDEX i_lis_name ON list(name) |
| 42 | modify i_lis_name to btree |
| 43 | CREATE INDEX i_lis_mail ON list (maillist) |
| 44 | CREATE INDEX i_lis_group ON list (group) |
| 45 | CREATE INDEX i_lis_gid ON list (gid) |
| 46 | modify i_lis_gid to btree |
| 47 | |
| 48 | modify imembers to cbtree on member_id, member_type |
| 49 | CREATE INDEX i_imem_list ON imembers (list_id) |
| 50 | modify i_imem_list to hash |
| 51 | |
| 52 | modify strings to cbtree unique on string_id |
| 53 | CREATE INDEX i_str_name ON strings (string) |
| 54 | modify i_str_name to hash |
| 55 | |
| 56 | modify nfsphys to cbtree unique on nfsphys_id |
| 57 | CREATE INDEX i_nfs_mach ON nfsphys (mach_id) |
| 58 | modify i_nfs_mach to btree |
| 59 | |
| 60 | modify filesys to cbtree unique on filsys_id |
| 61 | CREATE INDEX i_fil_name ON filesys (label) |
| 62 | modify i_fil_name to cbtree |
| 63 | CREATE INDEX i_fil_mach ON filesys (mach_id) |
| 64 | modify i_fil_mach to btree |
| 65 | CREATE INDEX i_fil_phys ON filesys (phys_id) |
| 66 | modify i_fil_phys to cbtree |
| 67 | CREATE INDEX i_fil_grp ON filesys (owners) |
| 68 | modify i_fil_grp to btree |
| 69 | CREATE INDEX i_fil_user ON filesys (owner) |
| 70 | modify i_fil_user to btree |
| 71 | |
| 72 | modify fsgroup to cbtree on group_id |
| 73 | CREATE INDEX i_fsg_filsys ON fsgroup (filsys_id) |
| 74 | modify i_fsg_filsys to btree |
| 75 | |
| 76 | modify quota to cbtree on entity_id |
| 77 | CREATE INDEX i_qot_fil ON quota (filsys_id) |
| 78 | modify i_qot_fil to cbtree |
| 79 | CREATE INDEX i_qot_phys ON quota (phys_id) |
| 80 | modify i_qot_phys to cbtree |
| 81 | |
| 82 | modify zephyr to cbtree unique on class |
| 83 | |
| 84 | modify hostaccess to cbtree unique on mach_id |
| 85 | |
| 86 | modify printcap to cbtree on name |
| 87 | CREATE INDEX i_pcp_mach ON printcap (mach_id) |
| 88 | modify i_pcp_mach to btree |
| 89 | |
| 90 | modify palladium to cbtree on name |
| 91 | |
| 92 | modify capacls to cbtree on tag |
andersk / moira.git / blame