From b80bd744ad873f6fc43018bc4bfb90677de167bd Mon Sep 17 00:00:00 2001
From: Stefan Wintermeyer <stefan.wintermeyer@amooma.de>
Date: Mon, 17 Dec 2012 12:01:45 +0100
Subject: Start of GS5.

---
 db/migrate/20111104141002_create_tasks.rb | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 db/migrate/20111104141002_create_tasks.rb

(limited to 'db/migrate/20111104141002_create_tasks.rb')

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
-- 
cgit v1.2.3