-- $Id: users.sql,v 1.4 2007/01/25 03:18:52 jeneric Exp $

DROP TABLE users;

CREATE TABLE users (
    username        varchar(50) PRIMARY KEY,
    password        text,   -- md5 
    creation        TIMESTAMP DEFAULT now(),
    last_on         TIMESTAMP,
    port_control    boolean DEFAULT false,
    ldap            boolean DEFAULT false,
    admin           boolean DEFAULT false,
    fullname        text,
    note            text
                    );
