tables.sql

#Statistics for IdPs
CREATE TABLE identityProviders (
	year INT NOT NULL,
	month INT NOT NULL,
	day INT NOT NULL,
	sourceIdp VARCHAR(255) NOT NULL,
	count INT,
	INDEX (sourceIdp),
	INDEX (year),
	INDEX (year,month),
	INDEX (year,month,day),
	PRIMARY KEY (year, month, day, sourceIdp)
);

#Statistics for services
CREATE TABLE serviceProviders(
	year INT NOT NULL,
	month INT NOT NULL,
	day INT NOT NULL,
	service VARCHAR(255) NOT NULL,
	count INT,
	INDEX (service),
	INDEX (year),
	INDEX (year,month),
	INDEX (year,month,day),
	PRIMARY KEY (year, month, day, service)
);