upgrade_20170407.sql 954 B

12345678910111213141516171819202122232425
  1. ALTER TABLE `char`
  2. ADD COLUMN `title_id` int(11) unsigned NOT NULL default '0' AFTER `clan_id`;
  3. --
  4. -- Table structure for table `achievement`
  5. --
  6. CREATE TABLE IF NOT EXISTS `achievement` (
  7. `char_id` int(11) unsigned NOT NULL default '0',
  8. `id` bigint(11) unsigned NOT NULL,
  9. `count1` mediumint(8) unsigned NOT NULL default '0',
  10. `count2` mediumint(8) unsigned NOT NULL default '0',
  11. `count3` mediumint(8) unsigned NOT NULL default '0',
  12. `count4` mediumint(8) unsigned NOT NULL default '0',
  13. `count5` mediumint(8) unsigned NOT NULL default '0',
  14. `count6` mediumint(8) unsigned NOT NULL default '0',
  15. `count7` mediumint(8) unsigned NOT NULL default '0',
  16. `count8` mediumint(8) unsigned NOT NULL default '0',
  17. `count9` mediumint(8) unsigned NOT NULL default '0',
  18. `count10` mediumint(8) unsigned NOT NULL default '0',
  19. `completed` datetime,
  20. `rewarded` datetime,
  21. PRIMARY KEY (`char_id`,`id`),
  22. KEY `char_id` (`char_id`)
  23. ) ENGINE=MyISAM;