diff options
Diffstat (limited to 'database')
-rw-r--r-- | database/database.mysql | 4 | ||||
-rw-r--r-- | database/database.pgsql | 5 | ||||
-rw-r--r-- | database/updates.inc | 26 |
3 files changed, 32 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 9f2ef285f..0be5db11f 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -20,13 +20,15 @@ CREATE TABLE access ( -- CREATE TABLE accesslog ( + aid tinyint(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) + KEY accesslog_timestamp (timestamp), + PRIMARY KEY (aid) ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index 92ba88c67..df50d5d84 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -18,12 +18,15 @@ CREATE TABLE access ( -- CREATE TABLE accesslog ( + aid SERIAL, + mask varchar(255) NOT NULL default '', title varchar(255) default NULL, path varchar(255) default NULL, url varchar(255) default NULL, hostname varchar(128) default NULL, uid integer default '0', - timestamp integer NOT NULL default '0' + timestamp integer NOT NULL default '0', + PRIMARY KEY (aid) ); CREATE INDEX accesslog_timestamp_idx ON accesslog (timestamp); diff --git a/database/updates.inc b/database/updates.inc index c5881f8d3..a0b1097e9 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -88,7 +88,8 @@ $sql_updates = array( "2004-10-18" => "update_109", "2004-10-31: first update since Drupal 4.5.0 release" => "update_110", "2004-11-07" => "update_111", - "2004-11-15" => "update_112" + "2004-11-15" => "update_112", + "2004-11-28" => "update_113" ); function update_32() { @@ -1991,6 +1992,29 @@ function update_112() { return $ret; } +function update_113() { + $ret = array(); + + if ($GLOBALS['db_type'] == 'mysql') { + $ret[] = update_sql('DROP TABLE {accesslog}'); + $ret[] = update_sql("CREATE TABLE {accesslog} ( + aid tinyint(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))"); + } + + // Flush the menu cache: + cache_clear_all('menu:', TRUE); + + return $ret; +} + function update_sql($sql) { $edit = $_POST["edit"]; $result = db_query($sql); |