From ee65e19aeb14d9bad2a74156ca0c24f389687073 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 22 Jan 2005 09:43:52 +0000 Subject: - Patch #15962 by Goba: no need to drop the accesslog table to add a new primary key. --- database/updates.inc | 12 +----------- 1 file changed, 1 insertion(+), 11 deletions(-) diff --git a/database/updates.inc b/database/updates.inc index c1d5b566f..ae2932d94 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -2001,17 +2001,7 @@ function update_113() { $ret = array(); if ($GLOBALS['db_type'] == 'mysql') { - $ret[] = update_sql('DROP TABLE {accesslog}'); - $ret[] = update_sql("CREATE TABLE {accesslog} ( - aid int(10) NOT NULL auto_increment, - title varchar(255) default NULL, - path varchar(255) default NULL, - url varchar(255) default NULL, - hostname varchar(128) default NULL, - uid int(10) unsigned default '0', - timestamp int(11) unsigned NOT NULL default '0', - KEY accesslog_timestamp (timestamp), - PRIMARY KEY (aid))"); + $ret[] = update_sql('ALTER TABLE {accesslog} ADD aid int(10) NOT NULL auto_increment, ADD PRIMARY KEY (aid)'); } // Flush the menu cache: -- cgit v1.2.3