However, if I drop all of those tables, I receive this message when I try to reinstall:
Database error in vBulletin 3.0.6:
Invalid SQL: ALTER TABLE `user`
ADD `rpgclass` int(3) NOT NULL,
ADD `rpgrace` int(3) NOT NULL,
ADD `alignment` int(3) NOT NULL,
ADD `rpgtype` int(3) NOT NULL,
ADD `rpggender` int(3) NOT NULL,
ADD `hp` int(6) NOT NULL default '0',
ADD `maxhp` int(6) NOT NULL default '0',
ADD `ma` int(6) NOT NULL default '0',
ADD `maxma` int(6) NOT NULL default '0',
ADD `pp` int(6) NOT NULL default '0',
ADD `maxpp` int(6) NOT NULL default '0',
ADD `ap` int(6) NOT NULL default '0',
ADD `element` int(3) NOT NULL default '0',
ADD `inbattle` int(3) NOT NULL default '0',
ADD `xp` int(11) NOT NULL default '0',
ADD `clan` smallint(5) NOT NULL default '0',
ADD `rpgstats` char(1) NOT NULL default '1';
mysql error: Duplicate column name 'rpgclass'
mysql error number: 1060
Now I know that if I drop the "user" table, the forums will crash!
|