summaryrefslogtreecommitdiff
path: root/db/ci/migrate/20141204133321_create_service.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/ci/migrate/20141204133321_create_service.rb')
-rw-r--r--db/ci/migrate/20141204133321_create_service.rb15
1 files changed, 15 insertions, 0 deletions
diff --git a/db/ci/migrate/20141204133321_create_service.rb b/db/ci/migrate/20141204133321_create_service.rb
new file mode 100644
index 00000000000..d87115c0577
--- /dev/null
+++ b/db/ci/migrate/20141204133321_create_service.rb
@@ -0,0 +1,15 @@
+class CreateService < ActiveRecord::Migration
+ def change
+ create_table :services, force: true do |t|
+ t.string :type
+ t.string :title
+ t.integer :project_id, null: false
+ t.datetime :created_at
+ t.datetime :updated_at
+ t.boolean :active, default: false, null: false
+ t.text :properties
+ end
+
+ add_index :services, [:project_id], name: :index_services_on_project_id, using: :btree
+ end
+end