Add PIN column to the users table.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 5ff0509c2dff2eb135b68fe77e08e5c9c8374b66..1e926c70e514b7fe10ffa83ced98b0ad56948d74 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -44,6 +44,7 @@ create table users
        sigwho          INTEGER         DEFAULT 0       NOT NULL,
        signature       VARCHAR(68)     DEFAULT CHR(0)  NOT NULL,
        secure          INTEGER         DEFAULT 0       NOT NULL,       
+       pin             VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        reservations    VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        flag            INTEGER         DEFAULT 0       NOT NULL,
        created         DATE            DEFAULT SYSDATE NOT NULL,