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         service         = c16,
  93         update_int      = i4,
  94         target_file     = c64,
  95         script          = c128,
  96         dfgen           = date,
  97         type            = c8,
  98         enable          = i1,
  99         inprogress      = i1,
 100         harderror       = i1,
 101         errmsg          = c80,
 102         acl_type        = c8,
 103         acl_id          = i4,
 104         modtime         = date,
 105         modby           = i4,
 106         modwith         = c8
 107 )
 108 create serverhosts
 109 (
 110         service         = c16,
 111         mach_id         = i4,
 112         success         = i1,
 113         enable          = i1,
 114         override        = i1,
 115         inprogress      = i1,
 116         hosterror       = i1,
 117         hosterrmsg      = c80,
 118         ltt             = date,
 119         lts             = date,
 120         value1          = i4,
 121         value2          = i4,
 122         value3          = c32,
 123         modtime         = date,
 124         modby           = i4,
 125         modwith         = c8
 126 )
 127 create filesys
 128 (
 129         filsys_id       = i4,
 130         label           = c16,
 131         order           = i2,
 132         type            = c8,
 133         mach_id         = i4,
 134         name            = c32,
 135         mount           = c32,
 136         access          = c1,
 137         comments        = c64,
 138         owner           = i4,
 139         owners          = i4,
 140         createflg       = i1,
 141         lockertype      = c8,
 142         modtime         = date,
 143         modby           = i4,
 144         modwith         = c8
 145 )
 146 create nfsphys
 147 (
 148         nfspys_id       = i4,
 149         mach_id         = i4,
 150         device          = c16,
 151         dir             = c16,
 152         status          = i2,
 153         allocated       = i4,
 154         size            = i4,
 155         modtime         = date,
 156         modby           = i4,
 157         modwith         = c8
 158 )
 159 create nfsquota
 160 (
 161         users_id        = i4,
 162         mach_id         = i4,
 163         device          = c16,
 164         quota           = i4,
 165         modtime         = date,
 166         modby           = i4,
 167         modwith         = c8
 168 )
 169 create zephyr
 170 (
 171         class           = c16,
 172         xmt_type        = c8,
 173         xmt_id          = i4,
 174         sub_type        = c8,
 175         sub_id          = i4,
 176         iws_type        = c8,
 177         iws_id          = i4,
 178         iui_type        = c8,
 179         iui_id          = i4,
 180         modtime         = date,
 181         modby           = i4,
 182         modwith         = c8
 183 )
 184 create hostaccess
 185 (
 186         mach_id         = i4,
 187         acl_type        = c8,
 188         acl_id          = i4,
 189         modtime         = date,
 190         modby           = i4,
 191         modwith         = c8
 192 )
 193 create strings
 194 (
 195         string_id       = i4,
 196         string          = c128
 197 )
 198 create services
 199 (
 200         name            = c16,
 201         protocol        = c8,
 202         port            = i2,
 203         desc            = c64,
 204         modtime         = date,
 205         modby           = i4,
 206         modwith         = c8
 207 )
 208 create printcap
 209 (
 210         name            = c16,
 211         pcap            = text(512)
 212 )
 213 create capacls
 214 (
 215         capability      = c32,
 216         tag             = c4,
 217         list_id         = i4
 218 )
 219 create alias
 220 (
 221         name            = c32,
 222         type            = c16,
 223         trans           = c128
 224 )
 225 create values
 226 (
 227         name            = c32,
 228         value           = i4
 229 )
 230 create tblstats
 231 (
 232         table           = c12,
 233         modtime         = date,
 234         retrieves       = i4,
 235         appends         = i4,
 236         updates         = i4,
 237         deletes         = i4
 238 )