sqlite2 changes

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

diff --git a/setup/sqlite2/factoids.sql b/setup/sqlite2/factoids.sql
index d5189d0d7a72c5e1342e94d8e1f311d0f1b27ce5..05862b8678fe651e10918de1c2813b961ccc8d1f 100644 (file)
--- 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 339803808448342c69dd965d025137f02add30b4..75c76392a2ee311c14b1e9f69c57a4114b923287 100644 (file)
--- 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)
 );