Guest User

hnoke

a guest
Oct 5th, 2010
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SET FOREIGN_KEY_CHECKS=0;
  2.  
  3. DROP TABLE IF EXISTS `pvp_rewards`;
  4. CREATE TABLE `pvp_rewards` (
  5.   `id` DECIMAL(11,0) NOT NULL DEFAULT '0',
  6.   `chance` INT(15) NOT NULL DEFAULT '100000',
  7.   `min` tinyint(5) NOT NULL DEFAULT '0',
  8.   `max` tinyint(5) NOT NULL DEFAULT '1',
  9.   `rewardAfter` tinyint(5) NOT NULL DEFAULT '0',
  10.   `levelRequired` tinyint(3) NOT NULL DEFAULT '75',
  11.   `pvpsRequired` SMALLINT(5) NOT NULL DEFAULT '0',
  12.   PRIMARY KEY (`id`,`chance`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment