diff options
| author | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-08 16:29:01 +0000 |
|---|---|---|
| committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-08 16:29:01 +0000 |
| commit | 39954ad0b77800b3d4935430794adf18c2625148 (patch) | |
| tree | a9016b38fa2b1ed0e9a20276457f2011a4a70f27 /installer/install.sql | |
| parent | bf6c814e81a00d6aec3cacdecd3b93b90cf73a3e (diff) | |
Implement Sortable albums. Current sort fields include (Creation
Date, Update Date, Random Key, Title, Mime Type, Item Type & Number of views)
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 c280a99b..a3ae66ef 100644 --- a/installer/install.sql +++ b/installer/install.sql @@ -139,13 +139,14 @@ CREATE TABLE {items} ( `view_1` tinyint(2) NOT NULL default '0', `view_2` tinyint(2) NOT NULL default '0', `rand_key` float default NULL, + `sort_column` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `type` (`type`), KEY `random` (`rand_key` DESC) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -INSERT INTO {items} VALUES (NULL,1234232381,'Welcome to your Gallery3',NULL,1,1,1,NULL,NULL,2,0,NULL,NULL,1,2,NULL,NULL,1,'Gallery','album',1234232381,0,NULL,1,1,NULL); +INSERT INTO {items} VALUES (NULL,1234232381,'Welcome to your Gallery3',NULL,1,1,1,NULL,NULL,2,0,NULL,NULL,1,2,NULL,NULL,1,'Gallery','album',1234232381,0,NULL,1,1,NULL,NULL); DROP TABLE IF EXISTS `items_tags`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; |