phpBB.nl

Code: Selecteer alles

CREATE TABLE phpbb_forum_auto_lock (
  auto_lock_id mediumint(8) unsigned NOT NULL auto_increment,
  forum_id smallint(5) unsigned NOT NULL default '0',
  auto_lock_days smallint(5) unsigned NOT NULL default '0',
  auto_lock_freq smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (auto_lock_id),
  KEY forum_id (forum_id)
) TYPE=MyISAM;

ALTER TABLE phpbb_forums 
ADD auto_lock_enable TINYINT( 1 ) NOT NULL DEFAULT '0',
ADD auto_lock_next INT( 11 );

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('auto_lock_enable', '0');

Code: Selecteer alles

DROP TABLE phpbb_forum_auto_lock;
ALTER TABLE phpbb_forums DROP auto_lock_enable, DROP auto_lock_next;
DELETE FROM phpbb_config WHERE config_name = 'auto_lock_enable';