From e2544da5b0f1a1a8a2706c9487374b9fac58c597 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Tue, 16 Dec 2008 08:27:06 +0000 Subject: Alphabetize field names to make it easier to find 'em. --- core/helpers/core_installer.php | 26 +++++++++++++------------- 1 file changed, 13 insertions(+), 13 deletions(-) (limited to 'core/helpers') 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`)) -- cgit v1.2.3