create table Languages(LID int NOT NULL, Name char(64), PRIMARY KEY(LID), UNIQUE(Name));
create table VerifiedUsers(UID int NOT NULL, username char(16), pwsalt int, pwhash char(40), realname char(128), email char(64), enabled char(1), failedlogins int, lastip char(16), PRIMARY KEY(UID), UNIQUE(username));
create table PendingUsers(username char(16) NOT NULL, pwsalt int, pwhash char(40), realname char(128), email char(64), vcode int, timestamp timestamp, PRIMARY KEY(username));
mySQl> create table ACLs(UID int NOT NULL, LID int NOT NULL, access int, PRIMARY KEY(UID,LID));
Query OK, 0 rows affected (0.03 sec)

mysql> create table AdminUser(login char(16) NOT NULL, pwsalt int, pwhash char(40), PRIMARY KEY(login));
Query OK, 0 rows affected (0.09 sec)

mysql> create table PendingQueue(PID int NOT NULL, UID int, LID int, timestamp timestamp, ipaddress char(20), path char(255), type int, data mediumblob, PRIMARY KEY(PID));
Query OK, 0 rows affected (0.02 sec)

mysql> create table History(HID int NOT NULL, path varchar(255), timestamp timestamp, createdbyUID int, LID int, data mediumblob, type int, approvedbyUID int, PRIMARY KEY(HID));