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 quota
 175 (
 176         filsys_id       = i4,
 177         type            = c8,
 178         entity_id       = i4,
 179         phys_id         = i4,
 180         quota           = i4,
 181         modtime         = date,
 182         modby           = i4,
 183         modwith         = c8
 184 )
 185 create zephyr
 186 (
 187         class           = c16,
 188         xmt_type        = c8,
 189         xmt_id          = i4,
 190         sub_type        = c8,
 191         sub_id          = i4,
 192         iws_type        = c8,
 193         iws_id          = i4,
 194         iui_type        = c8,
 195         iui_id          = i4,
 196         modtime         = date,
 197         modby           = i4,
 198         modwith         = c8
 199 )
 200 create hostaccess
 201 (
 202         mach_id         = i4,
 203         acl_type        = c8,
 204         acl_id          = i4,
 205         modtime         = date,
 206         modby           = i4,
 207         modwith         = c8
 208 )
 209 create strings
 210 (
 211         string_id       = i4,
 212         string          = c128
 213 )
 214 create services
 215 (
 216         name            = c16,
 217         protocol        = c8,
 218         port            = i2,
 219         desc            = c64,
 220         modtime         = date,
 221         modby           = i4,
 222         modwith         = c8
 223 )
 224 create printcap
 225 (
 226         name            = c16,
 227         mach_id         = i4,
 228         dir             = c32,
 229         rp              = c16,
 230         quotaserver     = i4,
 231         auth            = i1,
 232         price           = i2,
 233         comments        = c64,
 234         modtime         = date,
 235         modby           = i4,
 236         modwith         = c8
 237 )
 238 create palladium
 239 (
 240         name            = c32,
 241         ident           = i4,
 242         mach_id         = i4,
 243         modtime         = date,
 244         modby           = i4,
 245         modwith         = c8
 246 )
 247 create capacls
 248 (
 249         capability      = c32,
 250         tag             = c4,
 251         list_id         = i4
 252 )
 253 create alias
 254 (
 255         name            = c32,
 256         type            = c16,
 257         trans           = c128
 258 )
 259 create values
 260 (
 261         name            = c32,
 262         value           = i4
 263 )
 264 create tblstats
 265 (
 266         table           = c12,
 267         modtime         = date,
 268         retrieves       = i4,
 269         appends         = i4,
 270         updates         = i4,
 271         deletes         = i4
 272 )
 273 create incremental
 274 (
 275         table           = c16,
 276         service         = c16
 277 )