r23281 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r23280‎ | r23281 | r23282 >
Date:04:43, 23 June 2007
Author:robchurch
Status:old
Tags:
Comment:
Introduce `reportcache_info` table and updater
Modified paths:
  • /branches/robchurch/reports/maintenance/archives/patch-reportcache_info.sql (added) (history)
  • /branches/robchurch/reports/maintenance/tables.sql (modified) (history)
  • /branches/robchurch/reports/maintenance/updaters.inc (modified) (history)

Diff [purge]

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
114 + native
Index: branches/robchurch/reports/maintenance/updaters.inc
@@ -36,6 +36,7 @@
3737 array( 'filearchive', 'patch-filearchive.sql' ),
3838 array( 'querycachetwo', 'patch-querycachetwo.sql' ),
3939 array( 'reportcache', 'patch-reportcache.sql' ),
 40+ array( 'reportcache_info', 'patch-reportcache_info.sql' ),
4041 );
4142
4243 $wgNewFields = array(
Index: branches/robchurch/reports/maintenance/tables.sql
@@ -1175,4 +1175,17 @@
11761176
11771177 ) /*$wgDBTableOptions*/;
11781178
 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+
11791192 -- vim: sw=2 sts=2 et

Status & tagging log