From 19f437fe353459c7687cb7f0ea23776bda7a66f7 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/blootbot@705 c11ca15a-4712-0410-83d8-924469b57eb5 --- setup/factoids.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/setup/factoids.sql b/setup/factoids.sql index a7ecfd0..e594b61 100644 --- a/setup/factoids.sql +++ b/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