keep track of who/when modified onjoin

[infobot.git] / setup / onjoin.sql

diff --git a/setup/onjoin.sql b/setup/onjoin.sql
index 001924e4df886d5f223a98e4fd3935b4c294507c..994cc5480c97af655d005beef7b3e26faa6b1d47 100644 (file)
--- a/setup/onjoin.sql
+++ b/setup/onjoin.sql
@@ -1,5 +1,14 @@
 CREATE TABLE onjoin (
        nick VARCHAR(20) NOT NULL,
        channel VARCHAR(16) NOT NULL,
-       message VARCHAR(255) NOT NULL
+       message VARCHAR(255) NOT NULL,
+       modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody',
+       modified_time INT NOT NULL DEFAULT '0',
+       PRIMARY KEY (nick, channel)
 );
+
+-- v.2 -> v.3
+-- ALTER TABLE onjoin ADD COLUMN modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody';
+-- ALTER TABLE onjoin ADD COLUMN modified_time INT NOT NULL DEFAULT '0';
+-- ** the following doesn't work for sqlite **
+-- ALTER TABLE onjoin ADD PRIMARY KEY (nick, channel);