1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/20180713092803_create_user_statuses.rb b/db/migrate/20180713092803_create_user_statuses.rb
new file mode 100644
index 00000000000..cbe21b89ad9
--- /dev/null
+++ b/db/migrate/20180713092803_create_user_statuses.rb
@@ -0,0 +1,20 @@
+# frozen_string_literal: true
+
+class CreateUserStatuses < ActiveRecord::Migration
+  include Gitlab::Database::MigrationHelpers
+
+  DOWNTIME = false
+
+  def change
+    create_table :user_statuses, id: false, primary_key: :user_id do |t|
+      t.references :user,
+                   foreign_key: { on_delete: :cascade },
+                   null: false,
+                   primary_key: true
+      t.integer :cached_markdown_version, limit: 4
+      t.string :emoji, null: false, default: 'speech_balloon'
+      t.string :message, limit: 100
+      t.string :message_html
+    end
+  end
+end