Advertisement
Guest User

Escaped SQLite query

a guest
Sep 20th, 2014
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.58 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS [Account] (
  2.             [Username] VARCHAR(32)  UNIQUE NOT NULL,
  3.             [Password] VARCHAR(32)  NOT NULL,
  4.             [Email] VARCHAR(64)  NOT NULL,
  5.             [Nickname] VARCHAR(128)  NOT NULL,
  6.             [Faction] NUMERIC DEFAULT ''0'' NULL,
  7.             [Wealth] NUMERIC DEFAULT ''0'' NULL,
  8.             [Points] NUMERIC DEFAULT ''0'' NULL,
  9.             [Karma] FLOAT DEFAULT ''0.0'' NULL,
  10.             [Level] NUMERIC DEFAULT ''0'' NULL
  11.  
  12.         )
  13. CREATE TABLE IF NOT EXISTS [Bans] (
  14.             [USER] NUMERIC DEFAULT ''0'' NOT NULL,
  15.             [TIMESTAMP] TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
  16.             [Duration] TIMESTAMP  NOT NULL,
  17.             [Reason] VARCHAR(64)  NULL,
  18.             [Admin] NUMERIC DEFAULT ''0'' NOT NULL,
  19.             [Expired] BOOLEAN DEFAULT ''FALSE'' NOT NULL
  20.  
  21.         )
  22. CREATE TABLE IF NOT EXISTS [Profile] (
  23.             [Firstname] VARCHAR(64)  NULL,
  24.             [Lastname] VARCHAR(64)  NULL,
  25.             [City] VARCHAR(64)  NULL,
  26.             [State] VARCHAR(64)  NULL,
  27.             [Country] VARCHAR(64)  NULL,
  28.             [CanKick] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  29.             [CanBan] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  30.             [CanJoin] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  31.             [CanSpeak] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  32.             [CanDrive] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  33.             [CanGetOnBoard] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  34.             [CanTakeDamage] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  35.             [CanChangeName] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  36.             [CanSpawn] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  37.             [CanSpectate] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  38.             [CanReceivePM] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  39.             [CanSendPM] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  40.             [CanTeamKill] BOOLEAN DEFAULT ''TRUE'' NOT NULL,
  41.             [Visited] TIMESTAMP DEFAULT ''0'' NULL,
  42.             [LastIP] VARCHAR(16)  NULL,
  43.             [Activity] NUMERIC DEFAULT ''0'' NULL,
  44.             [LastSpree] NUMERIC DEFAULT ''0'' NULL,
  45.             [BestSpree] NUMERIC DEFAULT ''0'' NULL,
  46.             [Spawns] NUMERIC DEFAULT ''0'' NULL,
  47.             [Joins] NUMERIC DEFAULT ''0'' NULL,
  48.             [Wrecks] NUMERIC DEFAULT ''0'' NULL,
  49.             [Chats] NUMERIC DEFAULT ''0'' NULL,
  50.             [Actions] NUMERIC DEFAULT ''0'' NULL,
  51.             [TeamKills] NUMERIC DEFAULT ''0'' NULL
  52.         )
  53. CREATE TABLE IF NOT EXISTS [Body] (
  54.                 [KBODY] NUMERIC DEFAULT ''0'' NOT NULL, [KTORSO] NUMERIC DEFAULT ''0'' NOT NULL, [KLEFTARM] NUMERIC DEFAULT ''0'' NOT NULL,
  55.                 [KRIGHTARM] NUMERIC DEFAULT ''0'' NOT NULL, [KLEFTLEG] NUMERIC DEFAULT ''0'' NOT NULL, [KRIGHTLEG] NUMERIC DEFAULT ''0'' NOT NULL,
  56.                 [KHEAD] NUMERIC DEFAULT ''0'' NOT NULL,
  57.                 [DBODY] NUMERIC DEFAULT ''0'' NOT NULL, [DTORSO] NUMERIC DEFAULT ''0'' NOT NULL, [DLEFTARM] NUMERIC DEFAULT ''0'' NOT NULL,
  58.                 [DRIGHTARM] NUMERIC DEFAULT ''0'' NOT NULL, [DLEFTLEG] NUMERIC DEFAULT ''0'' NOT NULL, [DRIGHTLEG] NUMERIC DEFAULT ''0'' NOT NULL,
  59.                 [DHEAD] NUMERIC DEFAULT ''0'' NOT NULL
  60.  
  61.             )
  62. CREATE TABLE IF NOT EXISTS [Deaths] (
  63.             [FIST] NUMERIC DEFAULT ''0'' NOT NULL, [BRASSKNUCKLES] NUMERIC DEFAULT ''0'' NOT NULL, [SCREWDRIVER] NUMERIC DEFAULT ''0'' NOT NULL,
  64.             [GOLFCLUB] NUMERIC DEFAULT ''0'' NOT NULL, [NIGHTSTICK] NUMERIC DEFAULT ''0'' NOT NULL, [KNIFE] NUMERIC DEFAULT ''0'' NOT NULL,
  65.             [BASEBALLBAT] NUMERIC DEFAULT ''0'' NOT NULL, [HAMMER] NUMERIC DEFAULT ''0'' NOT NULL, [MEATCLEAVER] NUMERIC DEFAULT ''0'' NOT NULL,
  66.             [MACHETE] NUMERIC DEFAULT ''0'' NOT NULL, [KATANA] NUMERIC DEFAULT ''0'' NOT NULL, [CHAINSAW] NUMERIC DEFAULT ''0'' NOT NULL,
  67.             [GRENADE] NUMERIC DEFAULT ''0'' NOT NULL, [REMOTE] NUMERIC DEFAULT ''0'' NOT NULL, [TEARGAS] NUMERIC DEFAULT ''0'' NOT NULL,
  68.             [MOLOTOV] NUMERIC DEFAULT ''0'' NOT NULL, [ROCKET] NUMERIC DEFAULT ''0'' NOT NULL, [COLT45] NUMERIC DEFAULT ''0'' NOT NULL,
  69.             [PYTHON] NUMERIC DEFAULT ''0'' NOT NULL, [SHOTGUN] NUMERIC DEFAULT ''0'' NOT NULL, [SPAS12] NUMERIC DEFAULT ''0'' NOT NULL,
  70.             [STUBBY] NUMERIC DEFAULT ''0'' NOT NULL, [TEC9] NUMERIC DEFAULT ''0'' NOT NULL, [UZI] NUMERIC DEFAULT ''0'' NOT NULL,
  71.             [INGRAM] NUMERIC DEFAULT ''0'' NOT NULL, [MP5] NUMERIC DEFAULT ''0'' NOT NULL, [M4] NUMERIC DEFAULT ''0'' NOT NULL,
  72.             [RUGER] NUMERIC DEFAULT ''0'' NOT NULL, [SNIPER] NUMERIC DEFAULT ''0'' NOT NULL, [LASERSCOPE] NUMERIC DEFAULT ''0'' NOT NULL,
  73.             [ROCKETLAUNCHER] NUMERIC DEFAULT ''0'' NOT NULL, [FLAMETHROWER] NUMERIC DEFAULT ''0'' NOT NULL, [M60] NUMERIC DEFAULT ''0'' NOT NULL,
  74.             [MINIGUN] NUMERIC DEFAULT ''0'' NOT NULL, [BOMB] NUMERIC DEFAULT ''0'' NOT NULL, [HELICANNON] NUMERIC DEFAULT ''0'' NOT NULL,
  75.             [CAMERA] NUMERIC DEFAULT ''0'' NOT NULL, [VEHICLE] NUMERIC DEFAULT ''0'' NOT NULL, [DRIVEBY] NUMERIC DEFAULT ''0'' NOT NULL,
  76.             [DROWNED] NUMERIC DEFAULT ''0'' NOT NULL, [FALL] NUMERIC DEFAULT ''0'' NOT NULL, [EXPLOSION] NUMERIC DEFAULT ''0'' NOT NULL,
  77.             [SUICIDE] NUMERIC DEFAULT ''0'' NOT NULL
  78.  
  79.             )
  80. CREATE TABLE IF NOT EXISTS [Kills] (
  81.             [FIST] NUMERIC DEFAULT ''0'' NOT NULL, [BRASSKNUCKLES] NUMERIC DEFAULT ''0'' NOT NULL, [SCREWDRIVER] NUMERIC DEFAULT ''0'' NOT NULL,
  82.             [GOLFCLUB] NUMERIC DEFAULT ''0'' NOT NULL, [NIGHTSTICK] NUMERIC DEFAULT ''0'' NOT NULL, [KNIFE] NUMERIC DEFAULT ''0'' NOT NULL,
  83.             [BASEBALLBAT] NUMERIC DEFAULT ''0'' NOT NULL, [HAMMER] NUMERIC DEFAULT ''0'' NOT NULL, [MEATCLEAVER] NUMERIC DEFAULT ''0'' NOT NULL,
  84.             [MACHETE] NUMERIC DEFAULT ''0'' NOT NULL, [KATANA] NUMERIC DEFAULT ''0'' NOT NULL, [CHAINSAW] NUMERIC DEFAULT ''0'' NOT NULL,
  85.             [GRENADE] NUMERIC DEFAULT ''0'' NOT NULL, [REMOTE] NUMERIC DEFAULT ''0'' NOT NULL, [TEARGAS] NUMERIC DEFAULT ''0'' NOT NULL,
  86.             [MOLOTOV] NUMERIC DEFAULT ''0'' NOT NULL, [ROCKET] NUMERIC DEFAULT ''0'' NOT NULL, [COLT45] NUMERIC DEFAULT ''0'' NOT NULL,
  87.             [PYTHON] NUMERIC DEFAULT ''0'' NOT NULL, [SHOTGUN] NUMERIC DEFAULT ''0'' NOT NULL, [SPAS12] NUMERIC DEFAULT ''0'' NOT NULL,
  88.             [STUBBY] NUMERIC DEFAULT ''0'' NOT NULL, [TEC9] NUMERIC DEFAULT ''0'' NOT NULL, [UZI] NUMERIC DEFAULT ''0'' NOT NULL,
  89.             [INGRAM] NUMERIC DEFAULT ''0'' NOT NULL, [MP5] NUMERIC DEFAULT ''0'' NOT NULL, [M4] NUMERIC DEFAULT ''0'' NOT NULL,
  90.             [RUGER] NUMERIC DEFAULT ''0'' NOT NULL, [SNIPER] NUMERIC DEFAULT ''0'' NOT NULL, [LASERSCOPE] NUMERIC DEFAULT ''0'' NOT NULL,
  91.             [ROCKETLAUNCHER] NUMERIC DEFAULT ''0'' NOT NULL, [FLAMETHROWER] NUMERIC DEFAULT ''0'' NOT NULL, [M60] NUMERIC DEFAULT ''0'' NOT NULL,
  92.             [MINIGUN] NUMERIC DEFAULT ''0'' NOT NULL, [BOMB] NUMERIC DEFAULT ''0'' NOT NULL, [HELICANNON] NUMERIC DEFAULT ''0'' NOT NULL,
  93.             [CAMERA] NUMERIC DEFAULT ''0'' NOT NULL, [VEHICLE] NUMERIC DEFAULT ''0'' NOT NULL, [DRIVEBY] NUMERIC DEFAULT ''0'' NOT NULL,
  94.             [DROWNED] NUMERIC DEFAULT ''0'' NOT NULL, [FALL] NUMERIC DEFAULT ''0'' NOT NULL, [EXPLOSION] NUMERIC DEFAULT ''0'' NOT NULL,
  95.             [SUICIDE] NUMERIC DEFAULT ''0'' NOT NULL
  96.             )
  97. CREATE TABLE IF NOT EXISTS [Faction] (
  98.             [Name] VARCHAR(32)  NOT NULL,
  99.             [Tag] VARCHAR(8)  NOT NULL,
  100.             [Wealth] NUMERIC DEFAULT ''0'' NOT NULL,
  101.             [Points] NUMERIC DEFAULT ''0'' NOT NULL
  102.  
  103.         )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement