diff options
| author | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-09 13:30:22 +0000 |
|---|---|---|
| committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-09 13:30:22 +0000 |
| commit | c0375db79f47b4e4e0b1c261929389c6d3995edc (patch) | |
| tree | 7c8c5fd3b02cb12fb12361d738f591faea08adac /installer/install.sql | |
| parent | caa0a6d47fb5ed3faa0c321c10c86c5b6f3d7db8 (diff) | |
Restructure the sort order to maintain the sort column and sort order
as two separate columns in the item table.
Diffstat (limited to 'installer/install.sql')
| -rw-r--r-- | installer/install.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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; |