phpBB.de

Code: Alles auswählen

CREATE TABLE phpbb_forums_watch ( 
    forum_id smallint(5) unsigned NOT NULL default '0', 
    user_id mediumint(8) NOT NULL default '0', 
    notify_status tinyint(1) NOT NULL default '0', 
    KEY forum_id (forum_id), 
    KEY user_id (user_id), 
    KEY notify_status (notify_status) 
)

Code: Alles auswählen

ALTER TABLE phpbb_forums ADD forum_notify TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL AFTER forum_last_post_id