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 c6f86cd3b0abdaa14818b176f1f992a184bf5fb1..7cdd45ace13fa9b878aa7cf71c7029778a748b2e 100644 (file)
--- 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 2d2336191ac1fa62cdd20e87c23098a0ca2f094d..5b49fa0cc25283f61ad7148b1812d0067e76b9c9 100644 (file)
--- 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 '