Thread: DB write errors
View Single Post
  #7  
Old 11-05-2015, 04:02 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,165
Default

I guess this didn't happen?

Code:
RENAME TABLE `character_alternate_abilities` TO `character_alternate_abilities_old`;                                                                                                                                                     
DROP TABLE IF EXISTS `character_alternate_abilities`;                                                                                                                                                                                    
CREATE TABLE IF NOT EXISTS `character_alternate_abilities` (                                                                                                                                                                             
   `id` int(11) unsigned NOT NULL DEFAULT '0',                                                                                                                                                                                            
   `aa_id` smallint(11) unsigned NOT NULL DEFAULT '0',                                                                                                                                                                                    
   `aa_value` smallint(11) unsigned NOT NULL DEFAULT '0',                                                                                                                                                                                 
   `charges` smallint(11) unsigned NOT NULL DEFAULT '0',                                                                                                                                                                                  
    PRIMARY KEY (`id`,`aa_id`)                                                                                                                                                                                                             
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Reply With Quote