From 99c481897b8d1574bf984a1d5ea732fe63482fe0 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Sat, 20 Dec 2008 22:49:32 +0000 Subject: Add "created" and "updated" timestamps to the items table. --- core/helpers/core_installer.php | 2 ++ 1 file changed, 2 insertions(+) (limited to 'core/helpers') diff --git a/core/helpers/core_installer.php b/core/helpers/core_installer.php index 4ab54da9..399b6bf5 100644 --- a/core/helpers/core_installer.php +++ b/core/helpers/core_installer.php @@ -44,6 +44,7 @@ class core_installer { ENGINE=InnoDB DEFAULT CHARSET=utf8;"); $db->query("CREATE TABLE `items` ( + `created` int(9) default NULL, `description` char(255) default NULL, `height` int(9) default NULL, `id` int(9) NOT NULL auto_increment, @@ -60,6 +61,7 @@ class core_installer { `thumb_width` int(9) default NULL, `title` char(255) default NULL, `type` char(32) NOT NULL, + `updated` int(9) default NULL, `view_count` int(9) default 0, `width` int(9) default NULL, PRIMARY KEY (`id`), -- cgit v1.2.3