From 75db56ff2bc414c3082d19e1531b9f7d319427e0 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 8 Apr 2011 17:59:11 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index fc5b15a4..2fe5f372 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -233,7 +233,7 @@ ALTER TABLE images ADD COLUMN `parent_image_id` int(11) NOT NULL default '0' ALTER TABLE `Images` ADD INDEX `lookup`(`ontable`, `onid`); ALTER TABLE `Images` ADD COLUMN `created` datetime NOT NULL; -ALTER TABLE `Images` ADD COLUMN `created_by` datetime NOT NULL; +ALTER TABLE `Images` ADD COLUMN `created_by` INT(11) NOT NULL DEFAULT 0; ALTER TABLE `Images` ADD COLUMN `imgtype` VARCHAR(32) DEFAULT '' NOT NULL; ALTER TABLE `Images` ADD COLUMN `linkurl` VARCHAR(254) DEFAULT '' NOT NULL; -- 2.39.2