From c0375db79f47b4e4e0b1c261929389c6d3995edc Mon Sep 17 00:00:00 2001
From: Tim Almdal <tnalmdal@shaw.ca>
Date: Mon, 9 Mar 2009 13:30:22 +0000
Subject: Restructure the sort order to maintain the sort column and sort order
 as two separate columns in the item table.

---
 installer/install.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'installer/install.sql')

diff --git a/installer/install.sql b/installer/install.sql
index 501f8f1d..48434b08 100644
--- a/installer/install.sql
+++ b/installer/install.sql
@@ -138,6 +138,7 @@ CREATE TABLE {items} (
   `width` int(9) default NULL,
   `rand_key` float default NULL,
   `sort_column` varchar(64) default NULL,
+  `sort_order` char(4) default 'ASC',
   `view_1` tinyint(2) NOT NULL default '0',
   `view_2` tinyint(2) NOT NULL default '0',
   PRIMARY KEY  (`id`),
@@ -146,7 +147,7 @@ CREATE TABLE {items} (
   KEY `random` (`rand_key`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
-INSERT INTO {items} VALUES (NULL,1236569573,'',NULL,1,1,1,NULL,NULL,NULL,0,NULL,NULL,1,2,NULL,NULL,1,'Gallery','album',1236569573,0,NULL,NULL,NULL,1,1);
+INSERT INTO {items} VALUES (NULL,1236569573,'',NULL,1,1,1,NULL,NULL,NULL,0,NULL,NULL,1,2,NULL,NULL,1,'Gallery','album',1236569573,0,NULL,NULL,'id','ASC',1,1);
 DROP TABLE IF EXISTS {items_tags};
 SET @saved_cs_client     = @@character_set_client;
 SET character_set_client = utf8;
-- 
cgit v1.2.3

