Home

Fix for Achievements schema

February 2, 2010 - 7:56pm — mikey_p
  1. mysql> describe achievement_storage;
  2. +----------------+--------------+------+-----+---------+-------+
  3. | Field          | Type         | Null | Key | Default | Extra |
  4. +----------------+--------------+------+-----+---------+-------+
  5. | achievement_id | varchar(255) | NO   | MUL |         |       |
  6. | uid            | int(11)      | NO   | MUL | 0       |       |
  7. | data           | longblob     | NO   |     | NULL    |       |
  8. +----------------+--------------+------+-----+---------+-------+
  9. 3 rows in set (0.00 sec)
  10.  
  11. mysql> describe achievement_totals;
  12. +-----------+---------+------+-----+---------+-------+
  13. | Field     | Type    | Null | Key | Default | Extra |
  14. +-----------+---------+------+-----+---------+-------+
  15. | uid       | int(11) | NO   | MUL | 0       |       |
  16. | points    | int(11) | NO   | MUL | 0       |       |
  17. | timestamp | int(11) | NO   | MUL | 0       |       |
  18. +-----------+---------+------+-----+---------+-------+
  19. 3 rows in set (0.01 sec)
  20.  
  21. mysql> describe achievement_unlocks;
  22. +----------------+--------------+------+-----+---------+-------+
  23. | Field          | Type         | Null | Key | Default | Extra |
  24. +----------------+--------------+------+-----+---------+-------+
  25. | achievement_id | varchar(255) | NO   | MUL |         |       |
  26. | rank           | int(11)      | NO   | MUL | 0       |       |
  27. | uid            | int(11)      | NO   | MUL | 0       |       |
  28. | timestamp      | int(11)      | NO   | MUL | 0       |       |
  29. +----------------+--------------+------+-----+---------+-------+
  30. 4 rows in set (0.01 sec)

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.