X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=patches%2Flog-pgsql.txt;h=5b49fa0cc25283f61ad7148b1812d0067e76b9c9;hb=80d9ed728be4b02ac483f3339cbb184f6602d15b;hp=2d2336191ac1fa62cdd20e87c23098a0ca2f094d;hpb=222e1b0003536cf7b47858961d4b56d45c6d6606;p=srvx.git

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 '