db/schema

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