From d1e9a8732e7cced1570d16b527ac92c9880715c8 Mon Sep 17 00:00:00 2001 From: djmcgrath Date: Wed, 19 Mar 2008 14:08:59 +0000 Subject: [PATCH] * 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 --- setup/mysql/factoids.sql | 2 +- setup/pgsql/factoids.sql | 2 +- setup/sqlite/factoids.sql | 2 +- setup/sqlite2/factoids.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) diff --git a/setup/mysql/factoids.sql b/setup/mysql/factoids.sql index 80c3a2f..5052395 100644 --- 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 b64924f..59b5d67 100644 --- 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 8eb38b6..dc3f595 100644 --- 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 8eb38b6..dc3f595 100644 --- 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', -- 2.39.5