From: Michael Poole <mdpoole@troilus.org>
Date: Sat, 23 Dec 2006 05:27:23 +0000 (+0000)
Subject: Update PostgreSQL patch schema.
X-Git-Tag: v1.4.0-rc1~85
X-Git-Url: http://git.pk910.de/?p=srvx.git;a=commitdiff_plain;h=2851cb54bcad7f15f48825b9c244fc6db842a42f

Update PostgreSQL patch schema.

patches/log-pgsql.txt: Update to include HelpServ tables.
git-archimport-id: srvx@srvx.net--2006/srvx--devo--1.3--patch-71
---

diff --git a/ChangeLog b/ChangeLog
index c6f86cd..7cdd45a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -2,6 +2,19 @@
 # arch-tag: automatic-ChangeLog--srvx@srvx.net--2006/srvx--devo--1.3
 #
 
+2006-12-23 05:27:23 GMT	Michael Poole <mdpoole@troilus.org>	patch-71
+
+    Summary:
+      Update PostgreSQL patch schema.
+    Revision:
+      srvx--devo--1.3--patch-71
+
+    patches/log-pgsql.txt: Update to include HelpServ tables.
+
+    modified files:
+     ChangeLog patches/log-pgsql.txt
+
+
 2006-12-23 05:11:47 GMT	Michael Poole <mdpoole@troilus.org>	patch-70
 
     Summary:
diff --git a/patches/log-pgsql.txt b/patches/log-pgsql.txt
index 2d23361..5b49fa0 100644
--- a/patches/log-pgsql.txt
+++ b/patches/log-pgsql.txt
@@ -41,6 +41,29 @@ CREATE TABLE srvx_log (
   t_when TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
   c_message VARCHAR(1024) NOT NULL);
 
+CREATE TABLE srvx_helpserv_reqs (
+  c_bot VARCHAR(30) NOT NULL,
+  t_opened TIMESTAMP NOT NULL,
+  t_assigned TIMESTAMP NOT NULL,
+  t_closed TIMESTAMP NOT NULL,
+  i_id INTEGER NOT NULL PRIMARY KEY,
+  c_helper VARCHAR(30) NOT NULL,
+  c_user_account VARCHAR(30) NOT NULL,
+  c_user_nick VARCHAR(30) NOT NULL,
+  c_user_host VARCHAR(80) NOT NULL,
+  c_close_reason VARCHAR(512) NOT NULL,
+  c_text TEXT NOT NULL);
+
+CREATE TABLE srvx_helpserv_stats (
+  c_bot VARCHAR(30) NOT NULL,
+  t_weekstart TIMESTAMP NOT NULL,
+  c_helper VARCHAR(30) NOT NULL,
+  i_time INTEGER NOT NULL,
+  i_picked_up INTEGER NOT NULL,
+  i_closed INTEGER NOT NULL,
+  i_reassigned_from INTEGER NOT NULL,
+  i_reassigned_to INTEGER NOT NULL);
+
 CREATE SEQUENCE srvx_modules_id_seq MINVALUE 0 MAXVALUE 32767;
 CREATE FUNCTION srvx_module_id (VARCHAR(32)) RETURNS SMALLINT
   LANGUAGE 'plpgsql' STABLE STRICT AS '