Expanded name and description fields for the subnet table

[moira.git] / db / schema

diff --git a/db/schema b/db/schema
index ceec9517f8c60a2953da14ac918f0c69cbdbf07e..cb276f5ccf4d8e94a86ac333313c8c925f0c9dc3 100644 (file)
--- a/db/schema
+++ b/db/schema
@@ -51,7 +51,7 @@ 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,
        vendor          CHAR(16)        NOT NULL WITH DEFAULT,
        model           CHAR(24)        NOT NULL WITH DEFAULT,
@@ -76,18 +76,19 @@ create table machine
 );
 create table hostalias
 (
-       name            VARCHAR(32)     NOT NULL WITH DEFAULT,
+       name            VARCHAR(40)     NOT NULL WITH DEFAULT,
        mach_id         INTEGER         NOT NULL WITH DEFAULT
 );
 create table subnet
 (
-       name            CHAR(8)         NOT NULL WITH DEFAULT,
+       name            CHAR(16)        NOT NULL WITH DEFAULT,
        snet_id         INTEGER         NOT NULL WITH DEFAULT,
-       description     VARCHAR(32)     NOT NULL WITH DEFAULT,
-       address         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,