diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2008-12-20 22:49:32 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2008-12-20 22:49:32 +0000 |
| commit | 99c481897b8d1574bf984a1d5ea732fe63482fe0 (patch) | |
| tree | 00bfc1fd883d234292292ff6cc788e5c9564fed9 /core/helpers/core_installer.php | |
| parent | 05f26fa2d4d45d99082c81f03fa71922770d18dc (diff) | |
Add "created" and "updated" timestamps to the items table.
Diffstat (limited to 'core/helpers/core_installer.php')
| -rw-r--r-- | core/helpers/core_installer.php | 2 |
1 files changed, 2 insertions, 0 deletions
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`), |