1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/20111104141101_create_registrations.rb b/db/migrate/20111104141101_create_registrations.rb
new file mode 100644
index 0000000..e2683d7
--- /dev/null
+++ b/db/migrate/20111104141101_create_registrations.rb
@@ -0,0 +1,20 @@
+class CreateRegistrations < ActiveRecord::Migration
+  def self.up
+    create_table :registrations, :id => false do |t|
+      t.string  :reg_user
+      t.string  :realm,         :limit => '256'
+      t.string  :token,         :limit => '256'
+      t.text    :url
+      t.integer :expires
+      t.string  :network_ip,    :limit => '256'
+      t.string  :network_port,  :limit => '256'
+      t.string  :network_proto, :limit => '256'
+      t.string  :hostname,      :limit => '256'
+    end
+    add_index :registrations, [ :reg_user, :realm, :hostname ], :unique => false, :name => 'regindex1'
+  end
+
+  def self.down
+    drop_table :registrations
+  end
+end