diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2008-12-16 08:27:06 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2008-12-16 08:27:06 +0000 |
| commit | e2544da5b0f1a1a8a2706c9487374b9fac58c597 (patch) | |
| tree | 9263a56ee37f852c190aba6c0609d566ed6185ae | |
| parent | 3e219aab6ba88738832627ac39a3b3249f0ce2c3 (diff) | |
Alphabetize field names to make it easier to find 'em.
| -rw-r--r-- | core/helpers/core_installer.php | 26 |
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`)) |