added ratelimit

diff --git a/src/static/dbSchemas/mysql_schema.sql b/src/static/dbSchemas/mysql_schema.sql
index f5ecb9b957c29e10a88be81bc13c6be5a20e69e6..5a7d81315c577175b5d0039af5c795c83834f891 100644 (file)
--- a/src/static/dbSchemas/mysql_schema.sql
+++ b/src/static/dbSchemas/mysql_schema.sql
@@ -24,3 +24,12 @@ CREATE TABLE `blacklist` (
   `time` int(15) DEFAULT NULL,
   PRIMARY KEY (`id`)
 );
+
+CREATE TABLE `ratelimit`
+(
+    `id`     int(20) unsigned NOT NULL auto_increment,
+    `iphash` char(40) DEFAULT NULL,
+    `files`  int(15)  default NULL,
+    `time`   int(15)  DEFAULT NULL,
+    PRIMARY KEY (`id`)
+);
\ No newline at end of file

diff --git a/src/static/dbSchemas/sqlite_schema.sql b/src/static/dbSchemas/sqlite_schema.sql
index 9354ab41a01a717c73d6ea4949cf5717d9806d37..f26b65b91a0454f5da87c82fd3b29a0887db27d6 100644 (file)
--- a/src/static/dbSchemas/sqlite_schema.sql
+++ b/src/static/dbSchemas/sqlite_schema.sql
@@ -28,4 +28,10 @@ CREATE TABLE `ratelimit` (
 ,  `time` integer default NULL
 ,  `files` integer default NULL
 );
+CREATE TABLE `ratelimit`(
+  `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT
+,  `iphash` char(40) default NULL
+,  `files` integer  default NULL
+,  `time` integer default NULL
+);
 END TRANSACTION;