Kod: Tümünü seç
ALTER TABLE phpbb_users ADD user_birthday int(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD KEY(user_birthday);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_show',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_require',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_year',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_lock',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_lookahead',7);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_max',100);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bday_min',5);
BU KODU PHPMYADMİNDEN YAZIYORUM MYSQL YEMİYOR...
Error
SQL query:
ALTER TABLE phpbb_users ADD user_birthday int( 8 ) DEFAULT '0' NOT NULL ;
MySQL said:
#1060 - Duplicate column name 'user_birthday'