sql/updates/2008_12_22_15_mangos_playercreateinfo_action.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_14_mangos_playercreateinfo required_2008_12_22_15_mangos_playercreateinfo_action bit;
   2
   3 DELETE FROM playercreateinfo_action WHERE class = 6;
   4 INSERT INTO playercreateinfo_action VALUES
   5 (1,6,0,6603,0,0),
   6 (1,6,1,49576,0,0),
   7 (1,6,2,45477,0,0),
   8 (1,6,3,45462,0,0),
   9 (1,6,4,45902,0,0),
  10 (1,6,5,47541,0,0),
  11 (1,6,11,59752,0,0),
  12 (2,6,0,6603,0,0),
  13 (2,6,1,49576,0,0),
  14 (2,6,2,45477,0,0),
  15 (2,6,3,45462,0,0),
  16 (2,6,4,45902,0,0),
  17 (2,6,5,47541,0,0),
  18 (2,6,10,20572,0,0),
  19 (3,6,0,6603,0,0),
  20 (3,6,1,49576,0,0),
  21 (3,6,2,45477,0,0),
  22 (3,6,3,45462,0,0),
  23 (3,6,4,45902,0,0),
  24 (3,6,5,47541,0,0),
  25 (3,6,10,2481,0,0),
  26 (4,6,0,6603,0,0),
  27 (4,6,1,49576,0,0),
  28 (4,6,2,45477,0,0),
  29 (4,6,3,45462,0,0),
  30 (4,6,4,45902,0,0),
  31 (4,6,5,47541,0,0),
  32 (4,6,10,58984,0,0),
  33 (4,6,83,58984,0,0),
  34 (5,6,0,6603,0,0),
  35 (5,6,1,49576,0,0),
  36 (5,6,2,45477,0,0),
  37 (5,6,3,45462,0,0),
  38 (5,6,4,45902,0,0),
  39 (5,6,5,47541,0,0),
  40 (5,6,10,20577,0,0),
  41 (6,6,0,6603,0,0),
  42 (6,6,1,49576,0,0),
  43 (6,6,2,45477,0,0),
  44 (6,6,3,45462,0,0),
  45 (6,6,4,45902,0,0),
  46 (6,6,5,47541,0,0),
  47 (6,6,10,20549,0,0),
  48 (6,6,75,20549,0,0),
  49 (7,6,0,6603,0,0),
  50 (7,6,1,49576,0,0),
  51 (7,6,2,45477,0,0),
  52 (7,6,3,45462,0,0),
  53 (7,6,4,45902,0,0),
  54 (7,6,5,47541,0,0),
  55 (7,6,10,20589,0,0),
  56 (7,6,72,6603,0,0),
  57 (7,6,83,117,128,0),
  58 (7,6,84,6603,0,0),
  59 (7,6,96,6603,0,0),
  60 (7,6,108,6603,0,0),
  61 (8,6,0,6603,0,0),
  62 (8,6,1,49576,0,0),
  63 (8,6,2,45477,0,0),
  64 (8,6,3,45462,0,0),
  65 (8,6,4,45902,0,0),
  66 (8,6,5,47541,0,0),
  67 (8,6,10,50621,0,0),
  68 (10,6,0,6603,0,0),
  69 (10,6,1,49576,0,0),
  70 (10,6,2,45477,0,0),
  71 (10,6,3,45462,0,0),
  72 (10,6,4,45902,0,0),
  73 (10,6,5,47541,0,0),
  74 (10,6,6,50613,0,0),
  75 (11,6,0,6603,0,0),
  76 (11,6,1,49576,0,0),
  77 (11,6,2,45477,0,0),
  78 (11,6,3,45462,0,0),
  79 (11,6,4,45902,0,0),
  80 (11,6,5,47541,0,0);