X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fnosmoke.sql;fp=database%2Fnosmoke.sql;h=42c3cc0167cc9b26984e0f86bd80b041d34cb665;hb=284c203203bc036d9f4b70115d2bcf33ed1c8fad;hp=0000000000000000000000000000000000000000;hpb=10707d9620d6beadaaa0faf0fe3c2ad28013175d;p=NDIRC.git

diff --git a/database/nosmoke.sql b/database/nosmoke.sql
new file mode 100644
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%');