From 15ccfb296b65663ea4e14fd74978abae9516efec Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Sun, 31 Aug 2003 00:40:42 +0000
Subject: [PATCH] Ouch!!  Missing PostgreSQL files for chat module

---
 mod/chat/db/postgres7.php | 14 ++++++++++
 mod/chat/db/postgres7.sql | 55 +++++++++++++++++++++++++++++++++++++++
 2 files changed, 69 insertions(+)
 create mode 100644 mod/chat/db/postgres7.php
 create mode 100644 mod/chat/db/postgres7.sql

diff --git a/mod/chat/db/postgres7.php b/mod/chat/db/postgres7.php
new file mode 100644
index 0000000000..371bd92162
--- /dev/null
+++ b/mod/chat/db/postgres7.php
@@ -0,0 +1,14 @@
+<?PHP // $Id$
+
+function chat_upgrade($oldversion) {
+// This function does anything necessary to upgrade
+// older versions to match current functionality
+
+    global $CFG;
+
+    return true;
+}
+
+
+?>
+
diff --git a/mod/chat/db/postgres7.sql b/mod/chat/db/postgres7.sql
new file mode 100644
index 0000000000..ff2143775a
--- /dev/null
+++ b/mod/chat/db/postgres7.sql
@@ -0,0 +1,55 @@
+#
+# Table structure for table `chat`
+#
+
+CREATE TABLE prefix_chat (
+  id SERIAL,
+  course INTEGER NOT NULL default '0',
+  name varchar(255) NOT NULL default '',
+  intro text NOT NULL,
+  keepdays INTEGER NOT NULL default '0',
+  studentlogs INTEGER NOT NULL default '0',
+  chattime INTEGER NOT NULL default '0',
+  schedule INTEGER NOT NULL default '0',
+  timemodified INTEGER NOT NULL default '0',
+  PRIMARY KEY  (id)
+);
+# --------------------------------------------------------
+
+#
+# Table structure for table `chat_messages`
+#
+
+CREATE TABLE prefix_chat_messages (
+  id SERIAL,
+  chatid integer NOT NULL default '0',
+  userid integer NOT NULL default '0',
+  system integer NOT NULL default '0',
+  message text NOT NULL,
+  timestamp integer NOT NULL default '0',
+  PRIMARY KEY  (id)
+);
+# --------------------------------------------------------
+
+#
+# Table structure for table `chat_users`
+#
+
+CREATE TABLE prefix_chat_users (
+  id SERIAL,
+  chatid integer NOT NULL default '0',
+  userid integer NOT NULL default '0',
+  version varchar(16) NOT NULL default '',
+  ip varchar(15) NOT NULL default '',
+  firstping integer NOT NULL default '0',
+  lastping integer NOT NULL default '0',
+  lastmessageping integer NOT NULL default '0',
+  sid varchar(32) NOT NULL default '',
+  PRIMARY KEY  (id)
+);
+
+
+INSERT INTO prefix_log_display VALUES ('chat', 'view', 'chat', 'name');
+INSERT INTO prefix_log_display VALUES ('chat', 'add', 'chat', 'name');
+INSERT INTO prefix_log_display VALUES ('chat', 'update', 'chat', 'name');
+INSERT INTO prefix_log_display VALUES ('chat', 'report', 'chat', 'name');
-- 
2.39.5