From d96f50552e993f996a9ea70d8d1a8cce6645b9e1 Mon Sep 17 00:00:00 2001 From: timriker Date: Sat, 15 Mar 2008 22:40:29 +0000 Subject: [PATCH 1/1] sqlite2 changes git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@1639 c11ca15a-4712-0410-83d8-924469b57eb5 --- setup/sqlite2/factoids.sql | 2 +- setup/sqlite2/seen.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/sqlite2/factoids.sql b/setup/sqlite2/factoids.sql index d5189d0..05862b8 100644 --- a/setup/sqlite2/factoids.sql +++ b/setup/sqlite2/factoids.sql @@ -1,6 +1,6 @@ CREATE TABLE factoids ( factoid_key VARCHAR(64) NOT NULL, - requested_by VARCHAR(64) NOT NULL DEFAULT 'nobody', + requested_by VARCHAR(64), requested_time INT NOT NULL DEFAULT '0', requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0', created_by VARCHAR(64), diff --git a/setup/sqlite2/seen.sql b/setup/sqlite2/seen.sql index 3398038..75c7639 100644 --- a/setup/sqlite2/seen.sql +++ b/setup/sqlite2/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