X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fonjoin.sql;h=994cc5480c97af655d005beef7b3e26faa6b1d47;hb=d57016860fded0e3b9c0f73325a434670da55bfd;hp=001924e4df886d5f223a98e4fd3935b4c294507c;hpb=7cda31c8b8a342cb3d98414a42ad31390e9bd1a5;p=infobot.git

diff --git a/setup/onjoin.sql b/setup/onjoin.sql
index 001924e..994cc54 100644
--- 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);