Enforce table locking hierarchy

[moira.git] / db / schema

diff --git a/db/schema b/db/schema
index e35096e8274b62f19937f1a8ff5c11b3a8b7e9b9..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,14 +76,14 @@ 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,
+       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,