Increase size of contact and billing contact in machine and subnet tables.

diff --git a/db/schema.sql b/db/schema.sql
index 9793fa79607a818a3a25be5f6644e8e02ebfd6ed..02bfa0239120fb487ea3e34d537b82cf8bf8176d 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -65,8 +65,8 @@ create table machine
        model           VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
        os              VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
-       billing_contact VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       contact         VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
+       billing_contact VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,       
        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
@@ -98,7 +98,7 @@ create table subnet
        snet_id         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,
+       contact         VARCHAR(255)    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,