summaryrefslogtreecommitdiff
path: root/db/migrate/20130210075617_create_intruders.rb
diff options
context:
space:
mode:
authorStefan Wintermeyer <stefan.wintermeyer@amooma.de>2013-02-12 13:53:28 +0100
committerStefan Wintermeyer <stefan.wintermeyer@amooma.de>2013-02-12 13:53:28 +0100
commitc9066760fd1f5f2f892ce2be5cf2a83bb5210246 (patch)
tree82ecdd528e803ccd1b469dc13482e06cf8ea0b8e /db/migrate/20130210075617_create_intruders.rb
parent0b97717b2171820dea41de8df705f8f0e4b71464 (diff)
parentfb66a5e5a4c5d5f9eac4a5e8de6a286482cb55d5 (diff)
Release a new beta.5.1-beta4
Diffstat (limited to 'db/migrate/20130210075617_create_intruders.rb')
-rw-r--r--db/migrate/20130210075617_create_intruders.rb28
1 files changed, 28 insertions, 0 deletions
diff --git a/db/migrate/20130210075617_create_intruders.rb b/db/migrate/20130210075617_create_intruders.rb
new file mode 100644
index 0000000..fc944cc
--- /dev/null
+++ b/db/migrate/20130210075617_create_intruders.rb
@@ -0,0 +1,28 @@
+class CreateIntruders < ActiveRecord::Migration
+ def self.up
+ create_table :intruders do |t|
+ t.string :list_type
+ t.string :key
+ t.integer :points
+ t.integer :bans
+ t.datetime :ban_last
+ t.datetime :ban_end
+ t.string :contact_ip
+ t.integer :contact_port
+ t.integer :contact_count
+ t.datetime :contact_last
+ t.float :contacts_per_second
+ t.float :contacts_per_second_max
+ t.string :user_agent
+ t.string :to_user
+ t.string :comment
+ t.timestamps
+ end
+
+ add_index :intruders, :key, :unique => true
+ end
+
+ def self.down
+ drop_table :intruders
+ end
+end