-- Create summary tables for fundraising statistics

CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/public_reporting_days (
	`prd_date` date NOT NULL,
	`prd_total` decimal(14,4) unsigned NOT NULL DEFAULT '0.0000',
	`prd_number` int(11) NOT NULL DEFAULT '0',
	`prd_average` decimal(8,4) unsigned NOT NULL DEFAULT '0.0000',
	`prd_maximum` decimal(11,4) unsigned NOT NULL DEFAULT '0.0000',
	`prd_insert_timestamp` int(10) NOT NULL,
	PRIMARY KEY (prd_date)
) /*$wgDBTableOptions*/;
