* Revert factoid_key back to 64 to prevent excessive lengths

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

diff --git a/setup/mysql/factoids.sql b/setup/mysql/factoids.sql
index 80c3a2ff3f6dfa1ac0bc8760b58b759ebc47718c..50523952cffac31c284b53bb85b3afa3264f40a3 100644 (file)
--- a/setup/mysql/factoids.sql
+++ b/setup/mysql/factoids.sql
@@ -3,7 +3,7 @@
 --
 
 CREATE TABLE `factoids` (
-  `factoid_key` varchar(100) NOT NULL,
+  `factoid_key` varchar(64) NOT NULL,
   `requested_by` varchar(100) default NULL,
   `requested_time` int(11) default NULL,
   `requested_count` smallint(5) unsigned NOT NULL default '0',

diff --git a/setup/pgsql/factoids.sql b/setup/pgsql/factoids.sql
index b64924f2fec4fa02cef6fc02a0516e2f0af81d8e..59b5d67e329820010b403f55e631dcf3fd10203b 100644 (file)
--- a/setup/pgsql/factoids.sql
+++ b/setup/pgsql/factoids.sql
@@ -1,5 +1,5 @@
 CREATE TABLE factoids (
-    factoid_key VARCHAR(100) NOT NULL,
+    factoid_key VARCHAR(64) NOT NULL,
     requested_by VARCHAR(100) DEFAULT NULL,
     requested_time numeric(11) DEFAULT NULL,
     requested_count numeric(5) DEFAULT 0 NOT NULL,

diff --git a/setup/sqlite/factoids.sql b/setup/sqlite/factoids.sql
index 8eb38b61df4c02cde734c4f9a6b44f37eb6349b7..dc3f595e3136e0b4c06c494e5612bbb65f80ee1e 100644 (file)
--- a/setup/sqlite/factoids.sql
+++ b/setup/sqlite/factoids.sql
@@ -1,5 +1,5 @@
 CREATE TABLE factoids (
- factoid_key VARCHAR(100) NOT NULL,
+ factoid_key VARCHAR(64) NOT NULL,
  requested_by VARCHAR(100) DEFAULT NULL,
  requested_time INT DEFAULT NULL,
  requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',

diff --git a/setup/sqlite2/factoids.sql b/setup/sqlite2/factoids.sql
index 8eb38b61df4c02cde734c4f9a6b44f37eb6349b7..dc3f595e3136e0b4c06c494e5612bbb65f80ee1e 100644 (file)
--- a/setup/sqlite2/factoids.sql
+++ b/setup/sqlite2/factoids.sql
@@ -1,5 +1,5 @@
 CREATE TABLE factoids (
- factoid_key VARCHAR(100) NOT NULL,
+ factoid_key VARCHAR(64) NOT NULL,
  requested_by VARCHAR(100) DEFAULT NULL,
  requested_time INT DEFAULT NULL,
  requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',