Fossil SCM
In /admin_log, add rowid DESC to the ORDER BY so that entries with the same timestamp predictably sort newest-first.
Commit
914c6b5a0e585e3c711d7c02507c68b7502dd881a91094d3ef55a1415aef2260
Parent
3078ff46eebfde9…
1 file changed
+1
-1
+1
-1
| --- src/setup.c | ||
| +++ src/setup.c | ||
| @@ -1972,11 +1972,11 @@ | ||
| 1972 | 1972 | @ <p><a href="admin_log?n=%d(limit)&x=%d(prevx)">[Newer]</a></p> |
| 1973 | 1973 | } |
| 1974 | 1974 | db_prepare(&stLog, |
| 1975 | 1975 | "SELECT datetime(time,'unixepoch'), who, page, what " |
| 1976 | 1976 | "FROM admin_log " |
| 1977 | - "ORDER BY time DESC"); | |
| 1977 | + "ORDER BY time DESC, rowid DESC"); | |
| 1978 | 1978 | style_table_sorter(); |
| 1979 | 1979 | @ <table class="sortable adminLogTable" width="100%%" \ |
| 1980 | 1980 | @ data-column-types='Tttx' data-init-sort='1'> |
| 1981 | 1981 | @ <thead> |
| 1982 | 1982 | @ <th>Time</th> |
| 1983 | 1983 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -1972,11 +1972,11 @@ | |
| 1972 | @ <p><a href="admin_log?n=%d(limit)&x=%d(prevx)">[Newer]</a></p> |
| 1973 | } |
| 1974 | db_prepare(&stLog, |
| 1975 | "SELECT datetime(time,'unixepoch'), who, page, what " |
| 1976 | "FROM admin_log " |
| 1977 | "ORDER BY time DESC"); |
| 1978 | style_table_sorter(); |
| 1979 | @ <table class="sortable adminLogTable" width="100%%" \ |
| 1980 | @ data-column-types='Tttx' data-init-sort='1'> |
| 1981 | @ <thead> |
| 1982 | @ <th>Time</th> |
| 1983 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -1972,11 +1972,11 @@ | |
| 1972 | @ <p><a href="admin_log?n=%d(limit)&x=%d(prevx)">[Newer]</a></p> |
| 1973 | } |
| 1974 | db_prepare(&stLog, |
| 1975 | "SELECT datetime(time,'unixepoch'), who, page, what " |
| 1976 | "FROM admin_log " |
| 1977 | "ORDER BY time DESC, rowid DESC"); |
| 1978 | style_table_sorter(); |
| 1979 | @ <table class="sortable adminLogTable" width="100%%" \ |
| 1980 | @ data-column-types='Tttx' data-init-sort='1'> |
| 1981 | @ <thead> |
| 1982 | @ <th>Time</th> |
| 1983 |