From: Alan Knowles <alan@akbkhome.com>
Date: Fri, 8 Apr 2011 09:59:11 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=75db56ff2bc414c3082d19e1531b9f7d319427e0

DataObjects/core.sql
---

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;