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