X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/a12d4f62752f546f57421244e370e79965706ffb..f7aee769411a893c1059c529a220c0d25c72974f:/vendor/plugins/login_engine/db/migrate/001_initial_schema.rb

diff --git a/vendor/plugins/login_engine/db/migrate/001_initial_schema.rb b/vendor/plugins/login_engine/db/migrate/001_initial_schema.rb
new file mode 100644
index 0000000..6af212c
--- /dev/null
+++ b/vendor/plugins/login_engine/db/migrate/001_initial_schema.rb
@@ -0,0 +1,25 @@
+class InitialSchema < ActiveRecord::Migration
+  def self.up
+    create_table LoginEngine.config(:user_table), :force => true do |t|
+      t.column "login", :string, :limit => 80, :default => "", :null => false
+      t.column "salted_password", :string, :limit => 40, :default => "", :null => false
+      t.column "email", :string, :limit => 60, :default => "", :null => false
+      t.column "firstname", :string, :limit => 40
+      t.column "lastname", :string, :limit => 40
+      t.column "salt", :string, :limit => 40, :default => "", :null => false
+      t.column "verified", :integer, :default => 0
+      t.column "role", :string, :limit => 40
+      t.column "security_token", :string, :limit => 40
+      t.column "token_expiry", :datetime
+      t.column "created_at", :datetime
+      t.column "updated_at", :datetime
+      t.column "logged_in_at", :datetime
+      t.column "deleted", :integer, :default => 0
+      t.column "delete_after", :datetime
+    end
+  end
+
+  def self.down
+    drop_table LoginEngine.config(:user_table)
+  end
+end