diff options
author | Dries Buytaert <dries@buytaert.net> | 2005-01-22 09:43:52 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2005-01-22 09:43:52 +0000 |
commit | ee65e19aeb14d9bad2a74156ca0c24f389687073 (patch) | |
tree | 568915c17ccf1e3bbba2dcc4a11ef2868f223eea | |
parent | c0814a2072ed9f12b40394da661c003758a75290 (diff) | |
download | brdo-ee65e19aeb14d9bad2a74156ca0c24f389687073.tar.gz brdo-ee65e19aeb14d9bad2a74156ca0c24f389687073.tar.bz2 |
- Patch #15962 by Goba: no need to drop the accesslog table to add a new primary key.
-rw-r--r-- | database/updates.inc | 12 |
1 files changed, 1 insertions, 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: |