summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--core/helpers/core_installer.php26
1 files changed, 13 insertions, 13 deletions
diff --git a/core/helpers/core_installer.php b/core/helpers/core_installer.php
index b4f994f9..1c5f92ea 100644
--- a/core/helpers/core_installer.php
+++ b/core/helpers/core_installer.php
@@ -44,23 +44,23 @@ class core_installer {
ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db->query("CREATE TABLE `items` (
- `id` int(9) NOT NULL auto_increment,
- `type` char(32) NOT NULL,
- `title` char(255) default NULL,
`description` char(255) default NULL,
- `name` char(255) default NULL,
- `mime_type` char(64) default NULL,
+ `height` int(9) default NULL,
+ `id` int(9) NOT NULL auto_increment,
`left` int(9) NOT NULL,
- `right` int(9) NOT NULL,
- `parent_id` int(9) NOT NULL,
`level` int(9) NOT NULL,
- `width` int(9) default NULL,
- `height` int(9) default NULL,
- `thumbnail_width` int(9) default NULL,
- `thumbnail_height` int(9) default NULL,
- `resize_width` int(9) default NULL,
- `resize_height` int(9) default NULL,
+ `mime_type` char(64) default NULL,
+ `name` char(255) default NULL,
`owner_id` int(9) default NULL,
+ `parent_id` int(9) NOT NULL,
+ `resize_height` int(9) default NULL,
+ `resize_width` int(9) default NULL,
+ `right` int(9) NOT NULL,
+ `thumbnail_height` int(9) default NULL,
+ `thumbnail_width` int(9) default NULL,
+ `title` char(255) default NULL,
+ `type` char(32) NOT NULL,
+ `width` int(9) default NULL,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `type` (`type`))