* Moved all VARCHAR fields to 100 size for easier legacy db upgrades (should handle...

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

diff --git a/setup/sqlite2/factoids.sql b/setup/sqlite2/factoids.sql
index 05862b8678fe651e10918de1c2813b961ccc8d1f..8eb38b61df4c02cde734c4f9a6b44f37eb6349b7 100644 (file)
--- a/setup/sqlite2/factoids.sql
+++ b/setup/sqlite2/factoids.sql
@@ -1,14 +1,14 @@
 CREATE TABLE factoids (
- factoid_key VARCHAR(64) NOT NULL,
- requested_by VARCHAR(64),
- requested_time INT NOT NULL DEFAULT '0',
+ factoid_key VARCHAR(100) NOT NULL,
+ requested_by VARCHAR(100) DEFAULT NULL,
+ requested_time INT DEFAULT NULL,
  requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
- created_by VARCHAR(64),
- created_time INT NOT NULL DEFAULT '0',
- modified_by VARCHAR(192),
- modified_time INT NOT NULL DEFAULT '0',
- locked_by VARCHAR(64),
- locked_time INT NOT NULL DEFAULT '0',
+ created_by VARCHAR(100) DEFAULT NULL,
+ created_time INT DEFAULT NULL,
+ modified_by VARCHAR(100) DEFAULT NULL,
+ modified_time INT DEFAULT NULL,
+ locked_by VARCHAR(100) DEFAULT NULL,
+ locked_time INT DEFAULT NULL,
  factoid_value TEXT NOT NULL,
  PRIMARY KEY (factoid_key)
 );