stuff for hosttable in moira

diff --git a/db/schema b/db/schema
index d9328c22258768f8b1664ed1ea85fd04545a261a..ceec9517f8c60a2953da14ac918f0c69cbdbf07e 100644 (file)
--- a/db/schema
+++ b/db/schema
@@ -53,11 +53,47 @@ create table machine
 (
        name            VARCHAR(32)     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(32)     NOT NULL WITH DEFAULT,
+       mach_id         INTEGER         NOT NULL WITH DEFAULT
+);
+create table subnet
+(
+       name            CHAR(8)         NOT NULL WITH DEFAULT,
+       snet_id         INTEGER         NOT NULL WITH DEFAULT,
+       description     VARCHAR(32)     NOT NULL WITH DEFAULT,
+       address         INTEGER         NOT NULL WITH DEFAULT,
+       mask            INTEGER         NOT NULL WITH DEFAULT,
+       low             INTEGER         NOT NULL WITH DEFAULT,
+       high            INTEGER         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,