1 files changed, 53 insertions, 0 deletions
diff --git a/modules/dblog/dblog.install b/modules/dblog/dblog.install
new file mode 100644
index 000000000..f94bab651
--- /dev/null
+++ b/modules/dblog/dblog.install
@@ -0,0 +1,53 @@
+<?php
+// $Id$
+
+/**
+ * Implementation of hook_install().
+ */
+function dblog_install() {
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      db_query("CREATE TABLE {watchdog} (
+        wid int NOT NULL auto_increment,
+        uid int NOT NULL default '0',
+        type varchar(16) NOT NULL default '',
+        message longtext NOT NULL,
+        severity tinyint unsigned NOT NULL default '0',
+        link varchar(255) NOT NULL default '',
+        location text NOT NULL,
+        referer varchar(128) NOT NULL default '',
+        hostname varchar(128) NOT NULL default '',
+        timestamp int NOT NULL default '0',
+        PRIMARY KEY (wid),
+        KEY (type)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+      break;
+
+    case 'pgsql':
+      db_query("CREATE TABLE {watchdog} (
+        wid serial,
+        uid int NOT NULL default '0',
+        type varchar(16) NOT NULL default '',
+        message text NOT NULL,
+        severity smallint_unsigned NOT NULL default '0',
+        link varchar(255) NOT NULL default '',
+        location text NOT NULL default '',
+        referer varchar(128) NOT NULL default '',
+        hostname varchar(128) NOT NULL default '',
+        timestamp int NOT NULL default '0',
+        PRIMARY KEY (wid)
+      )");
+      db_query("CREATE INDEX {watchdog}_type_idx ON {watchdog} (type)");
+
+
+      break;
+  }
+}
+
+/**
+ * Implementation of hook_uninstall().
+ */
+function dblog_uninstall() {
+  db_query('DROP TABLE {watchdog}');
+}