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 fsgroup
 149 (
 150         group_id        = i4,
 151         filsys_id       = i4,
 152         key             = c8
 153 )
 154 create nfsphys
 155 (
 156         nfsphys_id      = i4,
 157         mach_id         = i4,
 158         device          = c16,
 159         dir             = c16,
 160         status          = i2,
 161         allocated       = i4,
 162         size            = i4,
 163         modtime         = date,
 164         modby           = i4,
 165         modwith         = c8
 166 )
 167 create nfsquota
 168 (
 169         users_id        = i4,
 170         filsys_id       = i4,
 171         phys_id         = i4,
 172         quota           = i4,
 173         modtime         = date,
 174         modby           = i4,
 175         modwith         = c8
 176 )
 177 create zephyr
 178 (
 179         class           = c16,
 180         xmt_type        = c8,
 181         xmt_id          = i4,
 182         sub_type        = c8,
 183         sub_id          = i4,
 184         iws_type        = c8,
 185         iws_id          = i4,
 186         iui_type        = c8,
 187         iui_id          = i4,
 188         modtime         = date,
 189         modby           = i4,
 190         modwith         = c8
 191 )
 192 create hostaccess
 193 (
 194         mach_id         = i4,
 195         acl_type        = c8,
 196         acl_id          = i4,
 197         modtime         = date,
 198         modby           = i4,
 199         modwith         = c8
 200 )
 201 create strings
 202 (
 203         string_id       = i4,
 204         string          = c128
 205 )
 206 create services
 207 (
 208         name            = c16,
 209         protocol        = c8,
 210         port            = i2,
 211         desc            = c64,
 212         modtime         = date,
 213         modby           = i4,
 214         modwith         = c8
 215 )
 216 create printcap
 217 (
 218         name            = c16,
 219         mach_id         = i4,
 220         dir             = c32,
 221         rp              = c16,
 222         comments        = c64,
 223         modtime         = date,
 224         modby           = i4,
 225         modwith         = c8
 226 )
 227 create capacls
 228 (
 229         capability      = c32,
 230         tag             = c4,
 231         list_id         = i4
 232 )
 233 create alias
 234 (
 235         name            = c32,
 236         type            = c16,
 237         trans           = c128
 238 )
 239 create values
 240 (
 241         name            = c32,
 242         value           = i4
 243 )
 244 create tblstats
 245 (
 246         table           = c12,
 247         modtime         = date,
 248         retrieves       = i4,
 249         appends         = i4,
 250         updates         = i4,
 251         deletes         = i4
 252 )