Code Select
function CreateTables()
{
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARACHAR(225), LastIPUsed VARACHAR(20), Level NUMERIC, Password VARACHR(255), Kills NUMERIC, Deaths NUMERIC, Cash NUMERIC, Bank NUMERIC, Joins NUMERIC, Datereg TEXT, Randspawn TEXT, Nogoto TEXT, VIPLevel NUMERIC)" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Bans ( Name VARCHAR(32), IP VARCHAR(25), Admin TEXT, Reason TEXT )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Tempban( ban_nick TEXT, ban_ip TEXT, ban_time TEXT, ban_expire TEXT, ban_expireratio TEXT, ban_admin TEXT, ban_reason TEXT )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS lastjoin ( Name TEXT, Time NUMERIC )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Spawnwep ( Name TEXT, Wep NUMERIC, Wep2 NUMERIC, Wep3 NUMERIC, Wep4 NUMERIC )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Spawnloc ( Name VARACHAR(255), Position FLOAT )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Locations( Name VARACHAR(255), Loc TEXT, Position FLOAT)" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Alias ( Name TEXT, IP VARCHAR(20), UID TEXT )" );
QuerySQL(vdb, "CREATE TABLE IF NOT EXISTS Vehicles ( Model INT, World INT, Posangle FLOAT, color INT)" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS ClanMembers ( Clan TEXT, Owner TEXT, Leader1 TEXT, Leader2 TEXT, Leader3 TEXT, Users TEXT )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS ClanStats ( Tag TEXT, Clan TEXT, Kills NUMERIC DEFAULT 0, Deaths NUMERIC DEFAULT 0, Deads NUMERIC DEFAULT 0 )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS ClanMembersRequest ( Player TEXT, Tag TEXT, Clan TEXT, State TEXT )" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS ClanReports ( Clan TEXT, Member TEXT, Reporter TEXT, Reason TEXT, Date_Of_Report TEXT )" );
//Reports Table
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Reports ( Reporter VARACHAR(255), Player VARACHAR(255), Reason TEXT, Date TEXT )" );
// Badges Table
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Badges( Name VARACHAR(255), Badge TEXT )" );
//Alters the Accounts table.
QuerySQL(db, "ALTER TABLE Accounts ADD UID VARACHAR(255)" ); //13
QuerySQL(db, "ALTER TABLE Accounts ADD Gems VARACHAR(255)" ); //14
QuerySQL(db, "ALTER TABLE Accounts ADD GemsRange VARACHAR(255)" ); //15
QuerySQL(db, "ALTER TABLE Accounts ADD VehiclesOwned NUMERIC " ); //16
QuerySQL(db, "ALTER TABLE Accounts ADD Clan TEXT " ); //17
QuerySQL(db, "ALTER TABLE Accounts ADD Headshots NUMERIC DEFAULT 0" ); //18
QuerySQL(db, "ALTER TABLE Accounts ADD Timeplayed NUMERIC DEFAULT 0" ); //19
QuerySQL(db, "ALTER TABLE Accounts ADD Cskinowner TEXT DEFAULT false" ); //20
// Alters Vehicles Table
QuerySQL(vdb, "ALTER TABLE Vehicles ADD VehOwner TEXT " );
QuerySQL(vdb, "ALTER TABLE Vehicles ADD VehCost NUMERIC " );
QuerySQL(vdb, "ALTER TABLE Vehicles ADD SharedWith VARACHAR(255) " );
QuerySQL(vdb, "ALTER TABLE Vehicles ADD VehID NUMERIRC" );
}
