-- Create summary tables for fundraising statistics
-- hard fail if exists

CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/public_reporting_hours (
	prh_datehour datetime NOT NULL,
	prh_total decimal(14,2) unsigned NOT NULL DEFAULT '0.00',
	prh_number int(11) NOT NULL DEFAULT '0',
	prh_average decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
	prh_maximum decimal(11,2) unsigned NOT NULL DEFAULT '0.00',
	-- note that other tables use non-native insert_timestamp
	prh_insert_timestamp datetime NOT NULL,
	PRIMARY KEY (prh_datehour)
) /*$wgDBTableOptions*/;
