Expanded name and description fields for the subnet table

[moira.git] / db / schema

diff --git a/db/schema b/db/schema
index d9328c22258768f8b1664ed1ea85fd04545a261a..cb276f5ccf4d8e94a86ac333313c8c925f0c9dc3 100644 (file)
--- a/db/schema
+++ b/db/schema
@@ -51,13 +51,50 @@ create table krbmap
 );
 create table machine
 (
-       name            VARCHAR(32)     NOT NULL WITH DEFAULT,
+       name            VARCHAR(40)     NOT NULL WITH DEFAULT,
        mach_id         INTEGER         NOT NULL WITH DEFAULT,
-       type            CHAR(8)         NOT NULL WITH DEFAULT,
+       vendor          CHAR(16)        NOT NULL WITH DEFAULT,
+       model           CHAR(24)        NOT NULL WITH DEFAULT,
+       os              CHAR(16)        NOT NULL WITH DEFAULT,
+       location        CHAR(16)        NOT NULL WITH DEFAULT,
+       contact         CHAR(32)        NOT NULL WITH DEFAULT,
+       use             INTEGER         NOT NULL WITH DEFAULT,
+       status          INTEGER1        NOT NULL WITH DEFAULT,
+       statuschange    DATE            NOT NULL WITH DEFAULT,
+       snet_id         INTEGER         NOT NULL WITH DEFAULT,
+       address         CHAR(16)        NOT NULL WITH DEFAULT,
+       owner_type      CHAR(8)         NOT NULL WITH DEFAULT,
+       owner_id        INTEGER         NOT NULL WITH DEFAULT,
+       acomment        INTEGER         NOT NULL WITH DEFAULT,
+       ocomment        INTEGER         NOT NULL WITH DEFAULT,
+       created         DATE            NOT NULL WITH DEFAULT,
+       creator         INTEGER         NOT NULL WITH DEFAULT,
+       inuse           DATE            NOT NULL WITH DEFAULT,
        modtime         DATE            NOT NULL WITH DEFAULT,
        modby           INTEGER         NOT NULL WITH DEFAULT,
        modwith         CHAR(8)         NOT NULL WITH DEFAULT
 );
+create table hostalias
+(
+       name            VARCHAR(40)     NOT NULL WITH DEFAULT,
+       mach_id         INTEGER         NOT NULL WITH DEFAULT
+);
+create table subnet
+(
+       name            CHAR(16)        NOT NULL WITH DEFAULT,
+       snet_id         INTEGER         NOT NULL WITH DEFAULT,
+       description     VARCHAR(48)     NOT NULL WITH DEFAULT,
+       saddr           INTEGER         NOT NULL WITH DEFAULT,
+       mask            INTEGER         NOT NULL WITH DEFAULT,
+       low             INTEGER         NOT NULL WITH DEFAULT,
+       high            INTEGER         NOT NULL WITH DEFAULT,
+       prefix          CHAR(8)         NOT NULL WITH DEFAULT,
+       owner_type      CHAR(8)         NOT NULL WITH DEFAULT,
+       owner_id        INTEGER         NOT NULL WITH DEFAULT,
+       modtime         DATE            NOT NULL WITH DEFAULT,
+       modby           INTEGER         NOT NULL WITH DEFAULT,
+       modwith         CHAR(8)         NOT NULL WITH DEFAULT
+);
 create table cluster
 (
        name            VARCHAR(32)     NOT NULL WITH DEFAULT,