db/newdb

   1 create users
   2 (
   3         login           = c8,
   4         users_id        = i4,
   5         uid             = i2,
   6         shell           = c32,
   7         last            = c16,
   8         first           = c16,
   9         middle          = c16,
  10         status          = i2,
  11         mit_id          = c13,
  12         mit_year        = c8,
  13         modtime         = date,
  14         modby           = i4,
  15         modwith         = c8,
  16         fullname        = c32,
  17         nickname        = c16,
  18         home_addr       = c80,
  19         home_phone      = c16,
  20         office_addr     = c16,
  21         office_phone    = c12,
  22         mit_dept        = c12,
  23         mit_affil       = c4,
  24         fmodtime        = date,
  25         fmodby          = i4,
  26         fmodwith        = c8,
  27         potype          = c8,
  28         pop_id          = i4,
  29         box_id          = i4,
  30         pmodtime        = date,
  31         pmodby          = i4,
  32         pmodwith        = c8,
  33         gid             = i2,
  34         uglist_id       = i4,
  35         ugdefault       = i1
  36 )
  37 create machine
  38 (
  39         name            = c32,
  40         mach_id         = i4,
  41         type            = c8,
  42         modtime         = date,
  43         modby           = i4,
  44         modwith         = c8
  45 )
  46 create cluster
  47 (
  48         name            = c32,
  49         clu_id          = i4,
  50         desc            = c32,
  51         location        = c64,
  52         modtime         = date,
  53         modby           = i4,
  54         modwith         = c8
  55 )
  56 create mcmap
  57 (
  58         mach_id         = i4,
  59         clu_id          = i4
  60 )
  61 create svc
  62 (
  63         clu_id          = i4,
  64         serv_label      = c16,
  65         serv_cluster    = c32
  66 )
  67 create list
  68 (
  69         name            = c32,
  70         list_id         = i4,
  71         active          = i1,
  72         public          = i1,
  73         hidden          = i1,
  74         maillist        = i1,
  75         group           = i1,
  76         gid             = i2,
  77         desc            = c255,
  78         acl_type        = c8,
  79         acl_id          = i4,
  80         modtime         = date,
  81         modby           = i4,
  82         modwith         = c8
  83 )
  84 create members
  85 (
  86         list_id         = i4,
  87         member_type     = c8,
  88         member_id       = i4
  89 )
  90 create servers
  91 (
  92         name            = c16,
  93         update_int      = i4,
  94         target_file     = c64,
  95         script          = c128,
  96         dfgen           = i4,
  97         dfcheck         = i4,
  98         type            = c8,
  99         enable          = i1,
 100         inprogress      = i1,
 101         harderror       = i4,
 102         errmsg          = c80,
 103         acl_type        = c8,
 104         acl_id          = i4,
 105         modtime         = date,
 106         modby           = i4,
 107         modwith         = c8
 108 )
 109 create serverhosts
 110 (
 111         service         = c16,
 112         mach_id         = i4,
 113         success         = i1,
 114         enable          = i1,
 115         override        = i1,
 116         inprogress      = i1,
 117         hosterror       = i4,
 118         hosterrmsg      = c80,
 119         ltt             = i4,
 120         lts             = i4,
 121         value1          = i4,
 122         value2          = i4,
 123         value3          = c32,
 124         modtime         = date,
 125         modby           = i4,
 126         modwith         = c8
 127 )
 128 create filesys
 129 (
 130         filsys_id       = i4,
 131         phys_id         = i4,
 132         label           = c32,
 133         order           = i2,
 134         type            = c8,
 135         mach_id         = i4,
 136         name            = c32,
 137         mount           = c32,
 138         access          = c1,
 139         comments        = c64,
 140         owner           = i4,
 141         owners          = i4,
 142         createflg       = i1,
 143         lockertype      = c8,
 144         modtime         = date,
 145         modby           = i4,
 146         modwith         = c8
 147 )
 148 create nfsphys
 149 (
 150         nfsphys_id      = i4,
 151         mach_id         = i4,
 152         device          = c16,
 153         dir             = c16,
 154         status          = i2,
 155         allocated       = i4,
 156         size            = i4,
 157         modtime         = date,
 158         modby           = i4,
 159         modwith         = c8
 160 )
 161 create nfsquota
 162 (
 163         users_id        = i4,
 164         filsys_id       = i4,
 165         phys_id         = i4,
 166         quota           = i4,
 167         modtime         = date,
 168         modby           = i4,
 169         modwith         = c8
 170 )
 171 create zephyr
 172 (
 173         class           = c16,
 174         xmt_type        = c8,
 175         xmt_id          = i4,
 176         sub_type        = c8,
 177         sub_id          = i4,
 178         iws_type        = c8,
 179         iws_id          = i4,
 180         iui_type        = c8,
 181         iui_id          = i4,
 182         modtime         = date,
 183         modby           = i4,
 184         modwith         = c8
 185 )
 186 create hostaccess
 187 (
 188         mach_id         = i4,
 189         acl_type        = c8,
 190         acl_id          = i4,
 191         modtime         = date,
 192         modby           = i4,
 193         modwith         = c8
 194 )
 195 create strings
 196 (
 197         string_id       = i4,
 198         string          = c128
 199 )
 200 create services
 201 (
 202         name            = c16,
 203         protocol        = c8,
 204         port            = i2,
 205         desc            = c64,
 206         modtime         = date,
 207         modby           = i4,
 208         modwith         = c8
 209 )
 210 create printcap
 211 (
 212         name            = c16,
 213         mach_id         = i4,
 214         dir             = c32,
 215         rp              = c16,
 216         comments        = c64,
 217         modtime         = date,
 218         modby           = i4,
 219         modwith         = c8
 220 )
 221 create capacls
 222 (
 223         capability      = c32,
 224         tag             = c4,
 225         list_id         = i4
 226 )
 227 create alias
 228 (
 229         name            = c32,
 230         type            = c16,
 231         trans           = c128
 232 )
 233 create values
 234 (
 235         name            = c32,
 236         value           = i4
 237 )
 238 create tblstats
 239 (
 240         table           = c12,
 241         modtime         = date,
 242         retrieves       = i4,
 243         appends         = i4,
 244         updates         = i4,
 245         deletes         = i4
 246 )