X-Git-Url: https://jfr.im/git/irc/evilnet/x3.git/blobdiff_plain/d76ed9a966ee3d955c8ef00ecc02e643c2005e2e..HEAD:/patches/log-pgsql.txt

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 '