Add contact and account_number fields to subnet table, to support

private subnets.

diff --git a/db/schema.sql b/db/schema.sql
index e6d31299293f1b69538bb3b9a00ccff3241f6c75..25b91ea39e95ed4dc7a54653292a2f8065e0088d 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -93,8 +93,10 @@ create table subnet
 (
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        snet_id         INTEGER         DEFAULT 0       NOT NULL,
-       status          INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(48)     DEFAULT CHR(0)  NOT NULL,
+       status          INTEGER         DEFAULT 0       NOT NULL,
+       contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        saddr           INTEGER         DEFAULT 0       NOT NULL,
        mask            INTEGER         DEFAULT 0       NOT NULL,
        low             INTEGER         DEFAULT 0       NOT NULL,