* Synced schema for seen table in other engines to match sqlite2 schema (PKEY only...

* Removed extra pgsql fields in schema for stats

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@1643 c11ca15a-4712-0410-83d8-924469b57eb5

diff --git a/setup/mysql/seen.sql b/setup/mysql/seen.sql
index 831e64dd73605154e3f55f43bc4e4f7426c8d178..9a2b691531db5a57b8250e03decda1603dbf4178 100644 (file)
--- a/setup/mysql/seen.sql
+++ b/setup/mysql/seen.sql
@@ -8,5 +8,5 @@ CREATE TABLE `seen` (
   `channel` varchar(30) NOT NULL default '',
   `host` varchar(64) NOT NULL default '',
   `message` tinytext NOT NULL,
-  PRIMARY KEY  (`nick`,`channel`)
+  PRIMARY KEY  (`nick`)
 ) TYPE=MyISAM;

diff --git a/setup/pgsql/seen.sql b/setup/pgsql/seen.sql
index 8cf6cd15ba844901e8e0f962587b05e63a64f68d..d90a6f61bd3e012d0fb692d4835a5f2cae1fd6d5 100644 (file)
--- a/setup/pgsql/seen.sql
+++ b/setup/pgsql/seen.sql
@@ -4,11 +4,9 @@ CREATE TABLE seen (
     channel VARCHAR(30) NOT NULL,
     host VARCHAR(80) NOT NULL,
     message text NOT NULL,
-    hehcount numeric DEFAULT 0 NOT NULL,
-    messagecount numeric DEFAULT 0 NOT NULL
 ) WITHOUT OIDS;
 
 REVOKE ALL ON TABLE seen FROM PUBLIC;
 
 ALTER TABLE ONLY seen
-    ADD CONSTRAINT seen_pkey PRIMARY KEY (nick, channel);
+    ADD CONSTRAINT seen_pkey PRIMARY KEY (nick);

diff --git a/setup/sqlite/seen.sql b/setup/sqlite/seen.sql
index 339803808448342c69dd965d025137f02add30b4..7892d76c011a177d2c8b948bd6fc5e52846a4812 100644 (file)
--- a/setup/sqlite/seen.sql
+++ b/setup/sqlite/seen.sql
@@ -4,5 +4,5 @@ CREATE TABLE seen (
  channel VARCHAR(30) NOT NULL,
  host VARCHAR(80) NOT NULL,
  message TINYTEXT NOT NULL,
- PRIMARY KEY (nick,channel)
+ PRIMARY KEY (nick)
 );