Index: branches/robchurch/reports/maintenance/archives/patch-reportcache_info.sql |
— | — | @@ -0,0 +1,12 @@ |
| 2 | +-- Stores information about the report cache state |
| 3 | +CREATE TABLE /*$wgDBprefix*/reportcache_info ( |
| 4 | + |
| 5 | + -- Report name |
| 6 | + `rci_report` VARCHAR(50) NOT NULL, |
| 7 | + |
| 8 | + -- Timestamp of last update |
| 9 | + `rci_updated` BINARY(14) NOT NULL, |
| 10 | + |
| 11 | + PRIMARY KEY( `rci_report` ) |
| 12 | + |
| 13 | +) /*$wgDBTableOptions*/; |
\ No newline at end of file |
Property changes on: branches/robchurch/reports/maintenance/archives/patch-reportcache_info.sql |
___________________________________________________________________ |
Added: svn:eol-style |
1 | 14 | + native |
Index: branches/robchurch/reports/maintenance/updaters.inc |
— | — | @@ -36,6 +36,7 @@ |
37 | 37 | array( 'filearchive', 'patch-filearchive.sql' ), |
38 | 38 | array( 'querycachetwo', 'patch-querycachetwo.sql' ), |
39 | 39 | array( 'reportcache', 'patch-reportcache.sql' ), |
| 40 | + array( 'reportcache_info', 'patch-reportcache_info.sql' ), |
40 | 41 | ); |
41 | 42 | |
42 | 43 | $wgNewFields = array( |
Index: branches/robchurch/reports/maintenance/tables.sql |
— | — | @@ -1175,4 +1175,17 @@ |
1176 | 1176 | |
1177 | 1177 | ) /*$wgDBTableOptions*/; |
1178 | 1178 | |
| 1179 | +-- Stores information about the report cache state |
| 1180 | +CREATE TABLE /*$wgDBprefix*/reportcache_info ( |
| 1181 | + |
| 1182 | + -- Report name |
| 1183 | + `rci_report` VARCHAR(50) NOT NULL, |
| 1184 | + |
| 1185 | + -- Timestamp of last update |
| 1186 | + `rci_updated` BINARY(14) NOT NULL, |
| 1187 | + |
| 1188 | + PRIMARY KEY( `rci_report` ) |
| 1189 | + |
| 1190 | +) /*$wgDBTableOptions*/; |
| 1191 | + |
1179 | 1192 | -- vim: sw=2 sts=2 et |