Iss #116 - Add revalidation support

Adds new table for storing data for revalidation, and adds mechanisms in status UI for revalidation.

Resolves #116 (closed)

config/mariadb/initdb.d/init.sql

@@ -38,3 +38,15 @@ CREATE TABLE IF NOT EXISTS `PrivateProjectEvent` (
 );
 
 ALTER TABLE CommitValidationMessage ADD COLUMN IF NOT EXISTS `committerEmail` varchar(255) DEFAULT NULL;
+
+CREATE TABLE GithubWebhookTracking (
+  id SERIAL NOT NULL,
+  fingerprint varchar(127) NOT NULL,
+  installationId varchar(63) NOT NULL,
+  deliveryId varchar(63) NOT NULL,
+  headSha varchar(63) NOT NULL,
+  repositoryFullName varchar(127) NOT NULL,
+  pullRequestNumber int NOT NULL,
+  lastUpdated datetime DEFAULT NULL,
+  PRIMARY KEY (id)
+);
\ No newline at end of file