BEGIN TRANSACTION;

CREATE TABLE "bans" (
	`Name`	TEXT,
	`BannedBy`	TEXT,
	`Reason`	TEXT,
	`IP`	TEXT,
	`Date`	TEXT
);

CREATE TABLE "achievements" (
	`ID`	INTEGER,
	`Completed0`	INTEGER DEFAULT 0,
	`Completed1`	INTEGER DEFAULT 0,
	`Completed2`	INTEGER DEFAULT 0,
	`Completed3`	INTEGER DEFAULT 0,
	`Completed4`	INTEGER DEFAULT 0,
	`Completed5`	INTEGER DEFAULT 0,
	`Completed6`	INTEGER DEFAULT 0,
	`Completed7`	INTEGER DEFAULT 0,
	`Completed8`	INTEGER DEFAULT 0,
	`Completed9`	INTEGER DEFAULT 0,
	PRIMARY KEY(`ID`)
);

CREATE TABLE "accounts" (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT,
	`Name`	TEXT,
	`Password`	TEXT,
	`Salt`	TEXT,
	`Email`	TEXT,
	`IP`	TEXT,
	`RegisterDate`	TEXT,
	`Admin`	INTEGER DEFAULT 0,
	`Donator`	INTEGER DEFAULT 0,
	`DonatorExpire`	INTEGER DEFAULT 0,
	`Muted`	INTEGER DEFAULT 0,
	`MuteTime`	INTEGER DEFAULT 0,
	`Score`	TEXT DEFAULT 0,
	`Minutes`	INTEGER DEFAULT 0,
	`Audio`	INTEGER DEFAULT 1,
	`HitSound`	INTEGER DEFAULT 0,
	`HitMark`	INTEGER DEFAULT 0,
	`Tips`	INTEGER DEFAULT 1,
	`ShowFPS`	INTEGER DEFAULT 1,
	`Kills`	INTEGER DEFAULT 0,
	`Deaths`	INTEGER DEFAULT 0,
	`BombsPlanted`	INTEGER DEFAULT 0,
	`BombsDefused`	INTEGER DEFAULT 0,
	`Experience`	INTEGER DEFAULT 0,
	`Rank`	INTEGER DEFAULT 0,
	`Hidden`	INTEGER DEFAULT 0
);

CREATE TABLE "accessories" (
	`ID`	INTEGER DEFAULT -1,
	`Model`	INTEGER DEFAULT 0,
	`Offset0`	REAL DEFAULT 0.0,
	`Offset1`	REAL DEFAULT 0.0,
	`Offset2`	REAL DEFAULT 0.0,
	`Offset3`	REAL DEFAULT 0.0,
	`Offset4`	REAL DEFAULT 0.0,
	`Offset5`	REAL DEFAULT 0.0,
	`Offset6`	REAL DEFAULT 0.0,
	`Offset7`	REAL DEFAULT 0.0,
	`Offset8`	REAL DEFAULT 0.0
);

COMMIT;