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