Increase size of list name column.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 13262f06bc541904835852007e62d623e57951b1..5760d4ae6441454cb4f52aac55beb87ab8faf9c5 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -144,7 +144,7 @@ create table svc
 
 create table list
 (
-       name            VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       name            VARCHAR(56)     DEFAULT CHR(0)  NOT NULL,
        list_id         INTEGER         DEFAULT 0       NOT NULL,
        active          INTEGER         DEFAULT 0       NOT NULL,
        publicflg       INTEGER         DEFAULT 0       NOT NULL,
@@ -329,7 +329,7 @@ create table printers
 (
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
-       hwtype          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       hwtype          VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        duplexname      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        mach_id         INTEGER         DEFAULT 0       NOT NULL,
        loghost         INTEGER         DEFAULT 0       NOT NULL,