From 232de8462461f027d3c33df63adbb5d3c48b3efa Mon Sep 17 00:00:00 2001 From: dms Date: Sun, 24 Nov 2002 16:32:32 +0000 Subject: [PATCH] - update table to have default values for numeric columns hrm... should any columns be NULL at all? git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@705 c11ca15a-4712-0410-83d8-924469b57eb5 --- blootbot/setup/factoids.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/blootbot/setup/factoids.sql b/blootbot/setup/factoids.sql index a7ecfd0..e594b61 100644 --- a/blootbot/setup/factoids.sql +++ b/blootbot/setup/factoids.sql @@ -1,17 +1,17 @@ CREATE TABLE factoids ( factoid_key VARCHAR(64) NOT NULL, - requested_by VARCHAR(64), - requested_time INT, - requested_count SMALLINT UNSIGNED, + requested_by VARCHAR(64) NOT NULL, + requested_time INT NOT NULL DEFAULT '0', + requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0', created_by VARCHAR(64), - created_time INT, + created_time INT NOT NULL DEFAULT '0', modified_by VARCHAR(192), - modified_time INT, + modified_time INT NOT NULL DEFAULT '0', locked_by VARCHAR(64), - locked_time INT, + locked_time INT NOT NULL DEFAULT '0', factoid_value TEXT NOT NULL, -- 2.39.5