diff options
Diffstat (limited to 'modules/statistics/statistics.install')
-rw-r--r-- | modules/statistics/statistics.install | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/modules/statistics/statistics.install b/modules/statistics/statistics.install index 2d4899300..2517d8819 100644 --- a/modules/statistics/statistics.install +++ b/modules/statistics/statistics.install @@ -18,5 +18,21 @@ function statistics_install() { KEY accesslog_timestamp (timestamp), PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + break; + case 'pgsql': + db_query("CREATE TABLE {accesslog} ( + aid serial, + sid varchar(32) NOT NULL default '', + title varchar(255) default NULL, + path varchar(255) default NULL, + url varchar(255) default NULL, + hostname varchar(128) default NULL, + uid uint default '0', + timer uint NOT NULL default '0', + timestamp uint NOT NULL default '0', + PRIMARY KEY (aid) + )"); + db_query("CREATE INDEX {accesslog}_accesslog_timestamp_idx ON {accesslog} (timestamp)"); + break; } -}
\ No newline at end of file +} |