dunno

[infobot.git] / setup / pgsql / factoids.sql

diff --git a/setup/pgsql/factoids.sql b/setup/pgsql/factoids.sql
index 7fc8d79231b957409f5d555c8cd889fc371f5bb3..59b5d67e329820010b403f55e631dcf3fd10203b 100644 (file)
--- a/setup/pgsql/factoids.sql
+++ b/setup/pgsql/factoids.sql
@@ -1,19 +1,17 @@
 CREATE TABLE factoids (
     factoid_key VARCHAR(64) NOT NULL,
-    requested_by VARCHAR(80) DEFAULT 'nobody' NOT NULL,
-    requested_time numeric(11) DEFAULT 0 NOT NULL,
+    requested_by VARCHAR(100) DEFAULT NULL,
+    requested_time numeric(11) DEFAULT NULL,
     requested_count numeric(5) DEFAULT 0 NOT NULL,
-    created_by VARCHAR(80),
-    created_time numeric(11) DEFAULT 0 NOT NULL,
-    modified_by VARCHAR(80),
-    modified_time numeric(11) DEFAULT 0 NOT NULL,
-    locked_by VARCHAR(80),
-    locked_time numeric(11) DEFAULT 0 NOT NULL,
+    created_by VARCHAR(100) DEFAULT NULL,
+    created_time numeric(11) DEFAULT NULL,
+    modified_by VARCHAR(100) DEFAULT NULL,
+    modified_time numeric(11) DEFAULT NULL,
+    locked_by VARCHAR(100) DEFAULT NULL,
+    locked_time numeric(11) DEFAULT NULL,
     factoid_value text NOT NULL
 ) WITHOUT OIDS;
 
-REVOKE ALL ON TABLE factoids FROM PUBLIC;
-
 CREATE INDEX factoids_idx_fvalue ON factoids USING hash (factoid_value);
 
 ALTER TABLE ONLY factoids