Add billing_contact column to machine table.

diff --git a/db/schema.sql b/db/schema.sql
index 7073f68faafbc0ba603c6564eea9c3c8ae78b59a..b756465c72b72596f07367e1367ae3bef0afb6ee 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -63,6 +63,7 @@ create table machine
        os              VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(32)     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,

        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
        statuschange    DATE            DEFAULT SYSDATE NOT NULL,
        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
        statuschange    DATE            DEFAULT SYSDATE NOT NULL,