Index: sitescripts/filterhits/schema.sql |
=================================================================== |
deleted file mode 100644 |
--- a/sitescripts/filterhits/schema.sql |
+++ /dev/null |
@@ -1,16 +0,0 @@ |
-/*!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 `frequencies` ( |
- `filter_sha1` BINARY(20) NOT NULL, |
- `domain` varchar(255) CHARACTER SET utf8 NOT NULL, |
- `frequency` 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 */; |