phpBB.de

Code: Alles auswählen

# 
#-----[ SQL ]------------------------------------------ 
# Oder führe die enthaltene db_update.php aus!
CREATE TABLE phpbb_topic_moved (
  moved_id mediumint(8) unsigned NOT NULL auto_increment,
  moved_topic_id mediumint(8) unsigned NOT NULL default '0',
  moved_oldtopic_id mediumint(8) unsigned default '0',
  moved_type varchar(8) NOT NULL default '0',
  moved_parent mediumint(8) unsigned default '0',
  moved_target mediumint(8) unsigned default '0',
  moved_mod mediumint(8) NOT NULL default '0',
  moved_time int(11) NOT NULL default '0',
  last_post_id mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (moved_id)
) TYPE=MyISAM;
ALTER TABLE phpbb_posts ADD post_move TINYINT(1) DEFAULT 0 NOT NULL;