| Index: trunk/phase3/includes/specials/SpecialUnusedimages.php |
| — | — | @@ -32,6 +32,9 @@ |
| 33 | 33 | case 'oracle': |
| 34 | 34 | $epoch = '((trunc(img_timestamp) - to_date(\'19700101\',\'YYYYMMDD\')) * 86400)'; |
| 35 | 35 | break; |
| | 36 | + case 'sqlite': |
| | 37 | + $epoch = 'img_timestamp'; |
| | 38 | + break; |
| 36 | 39 | default: |
| 37 | 40 | $epoch = 'EXTRACT(epoch FROM img_timestamp)'; |
| 38 | 41 | } |
| Index: trunk/phase3/includes/specials/SpecialAncientpages.php |
| — | — | @@ -37,6 +37,9 @@ |
| 38 | 38 | case 'oracle': |
| 39 | 39 | $epoch = '((trunc(rev_timestamp) - to_date(\'19700101\',\'YYYYMMDD\')) * 86400)'; |
| 40 | 40 | break; |
| | 41 | + case 'sqlite': |
| | 42 | + $epoch = 'rev_timestamp'; |
| | 43 | + break; |
| 41 | 44 | default: |
| 42 | 45 | $epoch = 'EXTRACT(epoch FROM rev_timestamp)'; |
| 43 | 46 | } |
| Index: trunk/phase3/RELEASE-NOTES |
| — | — | @@ -405,6 +405,7 @@ |
| 406 | 406 | * (bug 20203) "Powered by Mediawiki" now has height/width on image tag |
| 407 | 407 | * (bug 20273) Fix broken output when no pages are found in the content |
| 408 | 408 | namespaces |
| | 409 | +* (bug 20265) Make AncientPages and UnusedFiles work on SQLite |
| 409 | 410 | |
| 410 | 411 | == API changes in 1.16 == |
| 411 | 412 | |