Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code

Unified Diff: sitescripts/filterhits/schema.sql

Issue 4615801646612480: Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Simplified geometrical_mean code and reduced filter inserts. Created March 16, 2015, 4:24 p.m.
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: sitescripts/filterhits/schema.sql
diff --git a/sitescripts/filterhits/schema.sql b/sitescripts/filterhits/schema.sql
new file mode 100644
index 0000000000000000000000000000000000000000..48967ef8290372fcb9d8714b3860aa7f1e61f4fb
--- /dev/null
+++ b/sitescripts/filterhits/schema.sql
@@ -0,0 +1,16 @@
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `filters` (
+ `sha1` BINARY(20) NOT NULL,
+ `filter` TEXT CHARACTER SET utf8 NOT NULL,
+ PRIMARY KEY(sha1)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+CREATE TABLE `geometrical_mean` (
+ `filter_sha1` BINARY(20) NOT NULL,
+ `domain` varchar(255) CHARACTER SET utf8 NOT NULL,
+ `hits` int(10) unsigned DEFAULT 0 NOT NULL,
+ `timestamp` timestamp NOT NULL,
+ PRIMARY KEY(domain, filter_sha1)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+/*!40101 SET character_set_client = @saved_cs_client */;

Powered by Google App Engine
This is Rietveld