if requested_by is NOT NULL, then we better fill it in on creation

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

diff --git a/setup/factoids.sql b/setup/factoids.sql
index e594b61c53cb01f61b48d4a373f4e0767f129d84..9711a945e19754c3632a40c603f738d5a158f149 100644 (file)
--- a/setup/factoids.sql
+++ b/setup/factoids.sql
@@ -1,7 +1,7 @@
 CREATE TABLE factoids (
        factoid_key VARCHAR(64) NOT NULL,
 
-       requested_by VARCHAR(64) NOT NULL,
+       requested_by VARCHAR(64) NOT NULL DEFAULT 'nobody',
        requested_time INT NOT NULL DEFAULT '0',
        requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
        created_by VARCHAR(64),