Make all phone fields 24 characters long.

diff --git a/db/schema.sql b/db/schema.sql
index 1b21ade712434e0e8810feeb83b00977ea5fb3ab..e6ae9697ee97aeac1467f8f46b762a281e7f704e 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -18,9 +18,9 @@ create table users
        fullname        VARCHAR(92)     DEFAULT CHR(0)  NOT NULL,
        nickname        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        home_addr       VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
        fullname        VARCHAR(92)     DEFAULT CHR(0)  NOT NULL,
        nickname        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        home_addr       VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,

-       home_phone      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       home_phone      VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,

        office_addr     VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        office_addr     VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,

-       office_phone    VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
+       office_phone    VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,

        department      VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        affiliation     VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        fmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        department      VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        affiliation     VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        fmodtime        DATE            DEFAULT SYSDATE NOT NULL,


@@ -37,8 +37,8 @@ create table users
        xdept           VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xtitle          VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xaddress        VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
        xdept           VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xtitle          VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xaddress        VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,

-       xphone1         VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
-       xphone2         VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
+       xphone1         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       xphone2         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,

        xmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        sigdate         INTEGER         DEFAULT 0       NOT NULL,
        sigwho          INTEGER         DEFAULT 0       NOT NULL,
        xmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        sigdate         INTEGER         DEFAULT 0       NOT NULL,
        sigwho          INTEGER         DEFAULT 0       NOT NULL,