phpBB.de

Code: Alles auswählen

*** I have considered the table prefix as "phpbb_". If your table prefix is different the replace accordingly.
		
ALTER TABLE phpbb_users ADD user_online_time INT( 11 ) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE phpbb_users ADD user_online_timeformat TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0;

Code: Alles auswählen

SQL-Befehl:

* * * I have considered the TABLE prefix AS "phpbb_".If your TABLE prefix IS different the REPLACE accordingly.
ALTER TABLE phpbb_users ADD user_online_time INT( 11 ) UNSIGNED NOT NULL DEFAULT 0

MySQL meldet: Dokumentation
#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 '*** I have considered the table prefix as "phpbb_". If your table prefix is diff' at line 1 

Code: Alles auswählen

ALTER TABLE phpbb_users ADD user_online_time INT( 11 ) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD user_online_timeformat TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0;