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