add new function 'ServiceCooperation' for elecoma

[elecoma/elecoma.git] / db / migrate / 20110511023916_create_service_cooperations.rb

diff --git a/db/migrate/20110511023916_create_service_cooperations.rb b/db/migrate/20110511023916_create_service_cooperations.rb
new file mode 100644 (file)
index 0000000..a649d94
--- /dev/null
+++ b/db/migrate/20110511023916_create_service_cooperations.rb
@@ -0,0 +1,19 @@
+class CreateServiceCooperations < ActiveRecord::Migration
+  def self.up
+    create_table :service_cooperations do |t|
+      t.string :name
+      t.boolean :enable
+      t.string :url_file_name
+      t.integer :file_type
+      t.integer :encode
+      t.integer :newline_character
+      t.text :sql
+      t.string :field_items
+      t.timestamps
+    end
+  end
+
+  def self.down
+    drop_table :service_cooperations
+  end
+end