sql invoegen

[ptje]

ik heb dit in een mod staan:
ALTER TABLE phpbb_users ADD user_rank2 INT(11) AFTER user_rank DEFAULT '0';
ALTER TABLE phpbb_users ADD user_rank3 INT(11) AFTER user_rank2 DEFAULT '0';

Als ik dit invoeg dan krijg in onderstaande foutmelding


SQL-query:

ALTER TABLE phpbb_users ADD user_rank2 INT( 11 ) AFTER user_rank DEFAULT '0'
MySQL retourneerde:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT '0'' at line 1

Wat doe ik verkeerd?

[abcde]

Probeer dit:

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_rank2 INT(11) AFTER user_rank DEFAULT '0',
ALTER TABLE phpbb_users ADD user_rank3 INT(11) AFTER user_rank2 DEFAULT '0';