AQY3RKKu

1CREATE TABLE IF NOT EXISTS Users(
2    ID INT() NOT NULL AUTO_INCREMENT,
3    FirstGivenName VARCHAR() NOT NULL,
4    Name VARCHAR() NOT NULL,
5    Email VARCHAR() NOT NULL,
6    Loginname VARCHAR() NOT NULL,
7    Password VARCHAR(),
8    Salt1 VARCHAR(),
9    Salt2 VARCHAR(),
10    RecoveryString VARCHAR() NOT NULL UNIQUE,
11    OldPasswords VARCHAR(),
12    Groups VARCHAR(),
13    Rights VARCHAR(),
14    Sessions VARCHAR(),
15    CreationDate DATETIME() NOT NULL DEFAULT CURRENT_TIMESTAMP,
16    Timestamp DATETIME() on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
17    PRIMARY KEY (ID),
18    UNIQUE (Email),
19    UNIQUE (Loginname),
20    UNIQUE (RecoveryString)
21)