From 4e437f8818c169273bf7eae436adec45c3dbbdb7 Mon Sep 17 00:00:00 2001 From: djmcgrath Date: Tue, 18 Mar 2008 20:30:34 +0000 Subject: [PATCH] * Synced schema for seen table in other engines to match sqlite2 schema (PKEY only nick now) * 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 --- setup/mysql/seen.sql | 2 +- setup/pgsql/seen.sql | 4 +--- setup/sqlite/seen.sql | 2 +- 3 files changed, 3 insertions(+), 5 deletions(-) diff --git a/setup/mysql/seen.sql b/setup/mysql/seen.sql index 831e64d..9a2b691 100644 --- 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 8cf6cd1..d90a6f6 100644 --- 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 3398038..7892d76 100644 --- 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) ); -- 2.39.2