| 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 |
| 29f84283 |
19 | create index i_mac_addr on machine (address);\g |
| 20 | modify i_mac_addr to btree;\g |
| 21 | create index i_mac_loc on machine (location);\g |
| 22 | modify i_mac_loc to btree;\g |
| 644e96a1 |
23 | ;\g |
| 230c2fd2 |
24 | modify hostalias to cbtree unique on name;\g |
| 25 | create index i_hal_id on hostalias (mach_id);\g |
| 1ea5a498 |
26 | modify i_hal_id to btree;\g |
| 230c2fd2 |
27 | ;\g |
| 28 | modify subnet to btree unique on snet_id;\g |
| 29 | create index i_snt_name on subnet (name);\g |
| 92f92c3a |
30 | create index i_snt_saddr on subnet(saddr);\g |
| 230c2fd2 |
31 | ;\g |
| 644e96a1 |
32 | modify cluster to cbtree unique on clu_id;\g |
| 33 | create index i_clu_name on cluster (name);\g |
| 34 | modify i_clu_name to btree;\g |
| 35 | ;\g |
| 36 | modify mcmap to cbtree on clu_id;\g |
| 37 | create index i_mcm_mach on mcmap (mach_id);\g |
| 38 | modify i_mcm_mach to cbtree;\g |
| 39 | ;\g |
| 40 | modify svc to cbtree on clu_id;\g |
| 41 | ;\g |
| 42 | modify servers to btree on name;\g |
| 43 | ;\g |
| 44 | modify serverhosts to btree on service;\g |
| 45 | create index i_sho_mach on serverhosts (mach_id);\g |
| 46 | modify i_sho_mach to cbtree;\g |
| 47 | ;\g |
| 48 | modify list to cbtree unique on list_id;\g |
| 49 | create index i_lis_name on list (name);\g |
| 50 | modify i_lis_name to cbtree;\g |
| 51 | create index i_lis_mail on list (maillist);\g |
| 52 | create index i_lis_group on list (grouplist);\g |
| 53 | create index i_lis_gid on list (gid);\g |
| 54 | modify i_lis_gid to btree;\g |
| 55 | ;\g |
| 56 | modify imembers to cbtree on member_id, member_type;\g |
| 57 | create index i_imem_list on imembers (list_id);\g |
| 58 | modify i_imem_list to hash;\g |
| 59 | ;\g |
| 60 | modify strings to cbtree unique on string_id;\g |
| 61 | create index i_str_name on strings (string);\g |
| 62 | modify i_str_name to hash;\g |
| 63 | ;\g |
| 64 | modify nfsphys to cbtree unique on nfsphys_id;\g |
| 65 | create index i_nfs_mach on nfsphys (mach_id);\g |
| 66 | modify i_nfs_mach to btree;\g |
| 67 | ;\g |
| 68 | modify filesys to cbtree unique on filsys_id;\g |
| 69 | create index i_fil_name on filesys (label);\g |
| 70 | modify i_fil_name to cbtree;\g |
| 71 | create index i_fil_mach on filesys (mach_id);\g |
| 72 | modify i_fil_mach to btree;\g |
| 73 | create index i_fil_phys on filesys (phys_id);\g |
| 74 | modify i_fil_phys to cbtree;\g |
| 75 | create index i_fil_grp on filesys (owners);\g |
| 76 | modify i_fil_grp to btree;\g |
| 77 | create index i_fil_user on filesys (owner);\g |
| 78 | modify i_fil_user to btree;\g |
| 79 | ;\g |
| 80 | modify fsgroup to cbtree on group_id;\g |
| 81 | create index i_fsg_filsys on fsgroup (filsys_id);\g |
| 82 | modify i_fsg_filsys to btree;\g |
| 83 | ;\g |
| 84 | modify quota to cbtree on entity_id;\g |
| 85 | create index i_qot_fil on quota (filsys_id);\g |
| 86 | modify i_qot_fil to cbtree;\g |
| 87 | create index i_qot_phys on quota (phys_id);\g |
| 88 | modify i_qot_phys to cbtree;\g |
| 89 | ;\g |
| 90 | modify zephyr to cbtree unique on class;\g |
| 91 | ;\g |
| 92 | modify hostaccess to cbtree unique on mach_id;\g |
| 93 | ;\g |
| 94 | modify printcap to cbtree on name;\g |
| 95 | create index i_pcp_mach on printcap (mach_id);\g |
| 96 | modify i_pcp_mach to btree;\g |
| 97 | ;\g |
| 98 | modify palladium to cbtree on name;\g |
| 99 | ;\g |
| 100 | modify capacls to cbtree on tag;\g |
andersk / moira.git / blame