Terugdraaien sql query

[lot]

Ik had de autolock mod geinstalleerd maar die blijkt niet te werken op grotere forums, ik heb 'm er weer af gehaald maar weet iemand hoe ik onderstaande SQL Query ongedaan kan maken?

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');

Alvast bedankt!

Lotte

[lot]

Heb 'm !!

Voor diegene met hetzelfde probleem:

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';

Lotte