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 krbmap
  38 (
  39         users_id        = i4,
  40         string_id       = i4
  41 )
  42 create machine
  43 (
  44         name            = c32,
  45         mach_id         = i4,
  46         type            = c8,
  47         modtime         = date,
  48         modby           = i4,
  49         modwith         = c8
  50 )
  51 create cluster
  52 (
  53         name            = c32,
  54         clu_id          = i4,
  55         desc            = c32,
  56         location        = c64,
  57         modtime         = date,
  58         modby           = i4,
  59         modwith         = c8
  60 )
  61 create mcmap
  62 (
  63         mach_id         = i4,
  64         clu_id          = i4
  65 )
  66 create svc
  67 (
  68         clu_id          = i4,
  69         serv_label      = c16,
  70         serv_cluster    = c32
  71 )
  72 create list
  73 (
  74         name            = c32,
  75         list_id         = i4,
  76         active          = i1,
  77         public          = i1,
  78         hidden          = i1,
  79         maillist        = i1,
  80         group           = i1,
  81         gid             = i2,
  82         desc            = c255,
  83         acl_type        = c8,
  84         acl_id          = i4,
  85         modtime         = date,
  86         modby           = i4,
  87         modwith         = c8
  88 )
  89 create imembers
  90 (
  91         list_id         = i4,
  92         member_type     = c8,
  93         member_id       = i4,
  94         ref_count       = i2,
  95         direct          = i2
  96 )
  97 create servers
  98 (
  99         name            = c16,
 100         update_int      = i4,
 101         target_file     = c64,
 102         script          = c128,
 103         dfgen           = i4,
 104         dfcheck         = i4,
 105         type            = c8,
 106         enable          = i1,
 107         inprogress      = i1,
 108         harderror       = i4,
 109         errmsg          = c80,
 110         acl_type        = c8,
 111         acl_id          = i4,
 112         modtime         = date,
 113         modby           = i4,
 114         modwith         = c8
 115 )
 116 create serverhosts
 117 (
 118         service         = c16,
 119         mach_id         = i4,
 120         success         = i1,
 121         enable          = i1,
 122         override        = i1,
 123         inprogress      = i1,
 124         hosterror       = i4,
 125         hosterrmsg      = c80,
 126         ltt             = i4,
 127         lts             = i4,
 128         value1          = i4,
 129         value2          = i4,
 130         value3          = c32,
 131         modtime         = date,
 132         modby           = i4,
 133         modwith         = c8
 134 )
 135 create filesys
 136 (
 137         filsys_id       = i4,
 138         phys_id         = i4,
 139         label           = c32,
 140         order           = i2,
 141         type            = c8,
 142         mach_id         = i4,
 143         name            = c80,
 144         mount           = c32,
 145         access          = c1,
 146         comments        = c64,
 147         owner           = i4,
 148         owners          = i4,
 149         createflg       = i1,
 150         lockertype      = c8,
 151         modtime         = date,
 152         modby           = i4,
 153         modwith         = c8
 154 )
 155 create fsgroup
 156 (
 157         group_id        = i4,
 158         filsys_id       = i4,
 159         key             = c8
 160 )
 161 create nfsphys
 162 (
 163         nfsphys_id      = i4,
 164         mach_id         = i4,
 165         device          = c16,
 166         dir             = c16,
 167         status          = i2,
 168         allocated       = i4,
 169         size            = i4,
 170         modtime         = date,
 171         modby           = i4,
 172         modwith         = c8
 173 )
 174 create nfsquota
 175 (
 176         users_id        = i4,
 177         filsys_id       = i4,
 178         phys_id         = i4,
 179         quota           = i4,
 180         modtime         = date,
 181         modby           = i4,
 182         modwith         = c8
 183 )
 184 create zephyr
 185 (
 186         class           = c16,
 187         xmt_type        = c8,
 188         xmt_id          = i4,
 189         sub_type        = c8,
 190         sub_id          = i4,
 191         iws_type        = c8,
 192         iws_id          = i4,
 193         iui_type        = c8,
 194         iui_id          = i4,
 195         modtime         = date,
 196         modby           = i4,
 197         modwith         = c8
 198 )
 199 create hostaccess
 200 (
 201         mach_id         = i4,
 202         acl_type        = c8,
 203         acl_id          = i4,
 204         modtime         = date,
 205         modby           = i4,
 206         modwith         = c8
 207 )
 208 create strings
 209 (
 210         string_id       = i4,
 211         string          = c128
 212 )
 213 create services
 214 (
 215         name            = c16,
 216         protocol        = c8,
 217         port            = i2,
 218         desc            = c64,
 219         modtime         = date,
 220         modby           = i4,
 221         modwith         = c8
 222 )
 223 create printcap
 224 (
 225         name            = c16,
 226         mach_id         = i4,
 227         dir             = c32,
 228         rp              = c16,
 229         comments        = c64,
 230         modtime         = date,
 231         modby           = i4,
 232         modwith         = c8
 233 )
 234 create palladium
 235 (
 236         name            = c32,
 237         ident           = i4,
 238         mach_id         = i4,
 239         modtime         = date,
 240         modby           = i4,
 241         modwith         = c8
 242 )
 243 create capacls
 244 (
 245         capability      = c32,
 246         tag             = c4,
 247         list_id         = i4
 248 )
 249 create alias
 250 (
 251         name            = c32,
 252         type            = c16,
 253         trans           = c128
 254 )
 255 create values
 256 (
 257         name            = c32,
 258         value           = i4
 259 )
 260 create tblstats
 261 (
 262         table           = c12,
 263         modtime         = date,
 264         retrieves       = i4,
 265         appends         = i4,
 266         updates         = i4,
 267         deletes         = i4
 268 )
 269 create incremental
 270 (
 271         table           = c16,
 272         service         = c16
 273 )