Add the nosmoke command

[NDIRC.git] / database / nosmoke.sql

diff --git a/database/nosmoke.sql b/database/nosmoke.sql
new file mode 100644 (file)
index 0000000..42c3cc0
--- /dev/null
+++ b/database/nosmoke.sql
@@ -0,0 +1,6 @@
+CREATE TABLE last_smokes (
+       nick CITEXT PRIMARY KEY,
+       time TIMESTAMPTZ NOT NULL
+);
+
+INSERT INTO last_smokes (nick,time) (SELECT SUBSTR(id,6),value::timestamptz from misc WHERE id like 'SMOKE%');