diff options
| author | Joe7 <jozsef.rnagy@site.hu> | 2011-01-15 21:49:22 +0100 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2011-01-16 16:58:58 -0800 |
| commit | 0020f87d6a23ce00200074b678a9293d055e27a3 (patch) | |
| tree | 1201da32b39f91a47f6798e04a897396636b86fd /installer/install.sql | |
| parent | 44da46abd4aa2e210300d1d54c1d6896988fd71b (diff) | |
Fixed paging for albums ordered by random.
MySql has problems when comparing float values against -seemingly same- float input, see http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html for details.
Fixes #1610
Diffstat (limited to 'installer/install.sql')
| -rw-r--r-- | installer/install.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/installer/install.sql b/installer/install.sql index 0ed7f2f3..07aae36d 100644 --- a/installer/install.sql +++ b/installer/install.sql @@ -160,7 +160,7 @@ CREATE TABLE {items} ( `name` varchar(255) DEFAULT NULL, `owner_id` int(9) DEFAULT NULL, `parent_id` int(9) NOT NULL, - `rand_key` float DEFAULT NULL, + `rand_key` decimal(11,10) DEFAULT NULL, `relative_path_cache` varchar(255) DEFAULT NULL, `relative_url_cache` varchar(255) DEFAULT NULL, `resize_dirty` tinyint(1) DEFAULT '1', @@ -244,7 +244,7 @@ CREATE TABLE {modules} ( KEY `weight` (`weight`) ) AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -INSERT INTO {modules} VALUES (1,1,'gallery',43,1); +INSERT INTO {modules} VALUES (1,1,'gallery',44,1); INSERT INTO {modules} VALUES (2,1,'user',3,2); INSERT INTO {modules} VALUES (3,1,'comment',3,3); INSERT INTO {modules} VALUES (4,1,'organize',3,4); |