SQL Statement

# $Revision: 0
# $Data: 2011-11-13

CREATE TABLE account (
    username VARCHAR(64) NOT NULL,
    plainPassword VARCHAR(32),
    encryptedPassword VARCHAR(255),
    name VARCHAR(100),
    firstName VARCHAR(50),
    lastName VARCHAR(50),
    gender CHAR(1),
    birth CHAR(15),
    email VARCHAR(100),
    address VARCHAR(100),
    phoneNumber BIGINT(20) NOT NULL,
    creationDate CHAR(15) NOT NULL,
    modificationDate CHAR(15) NOT NULL,
    PRIMARY KEY (username)
);