major re-organisation of the different SQL files; cleanup and fixing of the postgres...

[infobot.git] / setup / mysql / seen.sql

diff --git a/setup/mysql/seen.sql b/setup/mysql/seen.sql
new file mode 100644 (file)
index 0000000..d920f79
--- /dev/null
+++ b/setup/mysql/seen.sql
@@ -0,0 +1,8 @@
+CREATE TABLE seen (
+ nick VARCHAR(20) NOT NULL,
+ time INT NOT NULL,
+ channel VARCHAR(20) NOT NULL,
+ host VARCHAR(80) NOT NULL,
+ message TINYTEXT NOT NULL,
+ PRIMARY KEY (nick,channel)
+);