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