Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS [Account] (
- [Username] VARCHAR(32) UNIQUE NOT NULL,
- [Password] VARCHAR(32) NOT NULL,
- [Email] VARCHAR(64) NOT NULL,
- [Nickname] VARCHAR(128) NOT NULL,
- [Faction] NUMERIC DEFAULT ''0'' NULL,
- [Wealth] NUMERIC DEFAULT ''0'' NULL,
- [Points] NUMERIC DEFAULT ''0'' NULL,
- [Karma] FLOAT DEFAULT ''0.0'' NULL,
- [Level] NUMERIC DEFAULT ''0'' NULL
- )
- CREATE TABLE IF NOT EXISTS [Bans] (
- [USER] NUMERIC DEFAULT ''0'' NOT NULL,
- [TIMESTAMP] TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
- [Duration] TIMESTAMP NOT NULL,
- [Reason] VARCHAR(64) NULL,
- [Admin] NUMERIC DEFAULT ''0'' NOT NULL,
- [Expired] BOOLEAN DEFAULT ''FALSE'' NOT NULL
- )
- CREATE TABLE IF NOT EXISTS [Profile] (
- [Firstname] VARCHAR(64) NULL,
- [Lastname] VARCHAR(64) NULL,
- [City] VARCHAR(64) NULL,
- [State] VARCHAR(64) NULL,
- [Country] VARCHAR(64) NULL,
- [CanKick] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanBan] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanJoin] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanSpeak] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanDrive] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanGetOnBoard] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanTakeDamage] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanChangeName] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanSpawn] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanSpectate] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanReceivePM] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanSendPM] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [CanTeamKill] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
- [Visited] TIMESTAMP DEFAULT ''0'' NULL,
- [LastIP] VARCHAR(16) NULL,
- [Activity] NUMERIC DEFAULT ''0'' NULL,
- [LastSpree] NUMERIC DEFAULT ''0'' NULL,
- [BestSpree] NUMERIC DEFAULT ''0'' NULL,
- [Spawns] NUMERIC DEFAULT ''0'' NULL,
- [Joins] NUMERIC DEFAULT ''0'' NULL,
- [Wrecks] NUMERIC DEFAULT ''0'' NULL,
- [Chats] NUMERIC DEFAULT ''0'' NULL,
- [Actions] NUMERIC DEFAULT ''0'' NULL,
- [TeamKills] NUMERIC DEFAULT ''0'' NULL
- )
- CREATE TABLE IF NOT EXISTS [Body] (
- [KBODY] NUMERIC DEFAULT ''0'' NOT NULL, [KTORSO] NUMERIC DEFAULT ''0'' NOT NULL, [KLEFTARM] NUMERIC DEFAULT ''0'' NOT NULL,
- [KRIGHTARM] NUMERIC DEFAULT ''0'' NOT NULL, [KLEFTLEG] NUMERIC DEFAULT ''0'' NOT NULL, [KRIGHTLEG] NUMERIC DEFAULT ''0'' NOT NULL,
- [KHEAD] NUMERIC DEFAULT ''0'' NOT NULL,
- [DBODY] NUMERIC DEFAULT ''0'' NOT NULL, [DTORSO] NUMERIC DEFAULT ''0'' NOT NULL, [DLEFTARM] NUMERIC DEFAULT ''0'' NOT NULL,
- [DRIGHTARM] NUMERIC DEFAULT ''0'' NOT NULL, [DLEFTLEG] NUMERIC DEFAULT ''0'' NOT NULL, [DRIGHTLEG] NUMERIC DEFAULT ''0'' NOT NULL,
- [DHEAD] NUMERIC DEFAULT ''0'' NOT NULL
- )
- CREATE TABLE IF NOT EXISTS [Deaths] (
- [FIST] NUMERIC DEFAULT ''0'' NOT NULL, [BRASSKNUCKLES] NUMERIC DEFAULT ''0'' NOT NULL, [SCREWDRIVER] NUMERIC DEFAULT ''0'' NOT NULL,
- [GOLFCLUB] NUMERIC DEFAULT ''0'' NOT NULL, [NIGHTSTICK] NUMERIC DEFAULT ''0'' NOT NULL, [KNIFE] NUMERIC DEFAULT ''0'' NOT NULL,
- [BASEBALLBAT] NUMERIC DEFAULT ''0'' NOT NULL, [HAMMER] NUMERIC DEFAULT ''0'' NOT NULL, [MEATCLEAVER] NUMERIC DEFAULT ''0'' NOT NULL,
- [MACHETE] NUMERIC DEFAULT ''0'' NOT NULL, [KATANA] NUMERIC DEFAULT ''0'' NOT NULL, [CHAINSAW] NUMERIC DEFAULT ''0'' NOT NULL,
- [GRENADE] NUMERIC DEFAULT ''0'' NOT NULL, [REMOTE] NUMERIC DEFAULT ''0'' NOT NULL, [TEARGAS] NUMERIC DEFAULT ''0'' NOT NULL,
- [MOLOTOV] NUMERIC DEFAULT ''0'' NOT NULL, [ROCKET] NUMERIC DEFAULT ''0'' NOT NULL, [COLT45] NUMERIC DEFAULT ''0'' NOT NULL,
- [PYTHON] NUMERIC DEFAULT ''0'' NOT NULL, [SHOTGUN] NUMERIC DEFAULT ''0'' NOT NULL, [SPAS12] NUMERIC DEFAULT ''0'' NOT NULL,
- [STUBBY] NUMERIC DEFAULT ''0'' NOT NULL, [TEC9] NUMERIC DEFAULT ''0'' NOT NULL, [UZI] NUMERIC DEFAULT ''0'' NOT NULL,
- [INGRAM] NUMERIC DEFAULT ''0'' NOT NULL, [MP5] NUMERIC DEFAULT ''0'' NOT NULL, [M4] NUMERIC DEFAULT ''0'' NOT NULL,
- [RUGER] NUMERIC DEFAULT ''0'' NOT NULL, [SNIPER] NUMERIC DEFAULT ''0'' NOT NULL, [LASERSCOPE] NUMERIC DEFAULT ''0'' NOT NULL,
- [ROCKETLAUNCHER] NUMERIC DEFAULT ''0'' NOT NULL, [FLAMETHROWER] NUMERIC DEFAULT ''0'' NOT NULL, [M60] NUMERIC DEFAULT ''0'' NOT NULL,
- [MINIGUN] NUMERIC DEFAULT ''0'' NOT NULL, [BOMB] NUMERIC DEFAULT ''0'' NOT NULL, [HELICANNON] NUMERIC DEFAULT ''0'' NOT NULL,
- [CAMERA] NUMERIC DEFAULT ''0'' NOT NULL, [VEHICLE] NUMERIC DEFAULT ''0'' NOT NULL, [DRIVEBY] NUMERIC DEFAULT ''0'' NOT NULL,
- [DROWNED] NUMERIC DEFAULT ''0'' NOT NULL, [FALL] NUMERIC DEFAULT ''0'' NOT NULL, [EXPLOSION] NUMERIC DEFAULT ''0'' NOT NULL,
- [SUICIDE] NUMERIC DEFAULT ''0'' NOT NULL
- )
- CREATE TABLE IF NOT EXISTS [Kills] (
- [FIST] NUMERIC DEFAULT ''0'' NOT NULL, [BRASSKNUCKLES] NUMERIC DEFAULT ''0'' NOT NULL, [SCREWDRIVER] NUMERIC DEFAULT ''0'' NOT NULL,
- [GOLFCLUB] NUMERIC DEFAULT ''0'' NOT NULL, [NIGHTSTICK] NUMERIC DEFAULT ''0'' NOT NULL, [KNIFE] NUMERIC DEFAULT ''0'' NOT NULL,
- [BASEBALLBAT] NUMERIC DEFAULT ''0'' NOT NULL, [HAMMER] NUMERIC DEFAULT ''0'' NOT NULL, [MEATCLEAVER] NUMERIC DEFAULT ''0'' NOT NULL,
- [MACHETE] NUMERIC DEFAULT ''0'' NOT NULL, [KATANA] NUMERIC DEFAULT ''0'' NOT NULL, [CHAINSAW] NUMERIC DEFAULT ''0'' NOT NULL,
- [GRENADE] NUMERIC DEFAULT ''0'' NOT NULL, [REMOTE] NUMERIC DEFAULT ''0'' NOT NULL, [TEARGAS] NUMERIC DEFAULT ''0'' NOT NULL,
- [MOLOTOV] NUMERIC DEFAULT ''0'' NOT NULL, [ROCKET] NUMERIC DEFAULT ''0'' NOT NULL, [COLT45] NUMERIC DEFAULT ''0'' NOT NULL,
- [PYTHON] NUMERIC DEFAULT ''0'' NOT NULL, [SHOTGUN] NUMERIC DEFAULT ''0'' NOT NULL, [SPAS12] NUMERIC DEFAULT ''0'' NOT NULL,
- [STUBBY] NUMERIC DEFAULT ''0'' NOT NULL, [TEC9] NUMERIC DEFAULT ''0'' NOT NULL, [UZI] NUMERIC DEFAULT ''0'' NOT NULL,
- [INGRAM] NUMERIC DEFAULT ''0'' NOT NULL, [MP5] NUMERIC DEFAULT ''0'' NOT NULL, [M4] NUMERIC DEFAULT ''0'' NOT NULL,
- [RUGER] NUMERIC DEFAULT ''0'' NOT NULL, [SNIPER] NUMERIC DEFAULT ''0'' NOT NULL, [LASERSCOPE] NUMERIC DEFAULT ''0'' NOT NULL,
- [ROCKETLAUNCHER] NUMERIC DEFAULT ''0'' NOT NULL, [FLAMETHROWER] NUMERIC DEFAULT ''0'' NOT NULL, [M60] NUMERIC DEFAULT ''0'' NOT NULL,
- [MINIGUN] NUMERIC DEFAULT ''0'' NOT NULL, [BOMB] NUMERIC DEFAULT ''0'' NOT NULL, [HELICANNON] NUMERIC DEFAULT ''0'' NOT NULL,
- [CAMERA] NUMERIC DEFAULT ''0'' NOT NULL, [VEHICLE] NUMERIC DEFAULT ''0'' NOT NULL, [DRIVEBY] NUMERIC DEFAULT ''0'' NOT NULL,
- [DROWNED] NUMERIC DEFAULT ''0'' NOT NULL, [FALL] NUMERIC DEFAULT ''0'' NOT NULL, [EXPLOSION] NUMERIC DEFAULT ''0'' NOT NULL,
- [SUICIDE] NUMERIC DEFAULT ''0'' NOT NULL
- )
- CREATE TABLE IF NOT EXISTS [Faction] (
- [Name] VARCHAR(32) NOT NULL,
- [Tag] VARCHAR(8) NOT NULL,
- [Wealth] NUMERIC DEFAULT ''0'' NOT NULL,
- [Points] NUMERIC DEFAULT ''0'' NOT NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement