1 files changed, 16 insertions, 0 deletions
diff --git a/db/migrate/20111104141002_create_tasks.rb b/db/migrate/20111104141002_create_tasks.rb
new file mode 100644
index 0000000..d7539bc
--- /dev/null
+++ b/db/migrate/20111104141002_create_tasks.rb
@@ -0,0 +1,16 @@
+class CreateTasks < ActiveRecord::Migration
+  def self.up
+    create_table :tasks, :id => false do |t|
+      t.integer :task_id,                         :primary => true
+      t.string  :task_desc,       :limit=>'4096'
+      t.string  :task_group,      :limit=>'1024'
+      t.integer :task_sql_manager
+      t.string  :hostname,        :limit=>'256'
+    end
+    add_index :tasks, [ :hostname, :task_id ], :unique => true, :name => 'tasks1'
+  end
+
+  def self.down
+    drop_table :tasks
+  end
+end