FeelTheGhost

[SQL Table] Ghost's PvP System v1.0

Jan 31st, 2012
5,947
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //SQL Table for Ghost's PvP System
  2. CREATE TABLE IF NOT EXISTS `pvp_rank` (
  3.  `char_id` int(11) NOT NULL,
  4.  `account_id` int(11) NOT NULL,
  5.  `char` varchar(30) NOT NULL,
  6.  `kill` int(11) NOT NULL,
  7.  `death` int(11) NOT NULL,
  8.  `kdr` varchar(30) NOT NULL,
  9.  `killingstreak` int(11) NOT NULL,
  10.  `multikill` int(11) NOT NULL,
  11.  `killingspree` int(11) NOT NULL,
  12.  `dominating` int(11) NOT NULL,
  13.  `megakill` int(11) NOT NULL,
  14.  `unstoppable` int(11) NOT NULL,
  15.  `wickedsick` int(11) NOT NULL,
  16.  `monsterkill` int(11) NOT NULL,
  17.  `godlike` int(11) NOT NULL,
  18.  `beyondgodlike` int(11) NOT NULL,
  19.  `doublekill` int(11) NOT NULL,
  20.  `triplekill` int(11) NOT NULL,
  21.  `ultrakill` int(11) NOT NULL,
  22.  `rampage` int(11) NOT NULL,
  23.  `ownage` int(11) NOT NULL,
  24.  `nemesiskill` int(11) NOT NULL,
  25.  `feedcount` int(11) NOT NULL,
  26.  PRIMARY KEY (`char_id`)
  27. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
RAW Paste Data