Add the `UserStatus` model

This model will hold the status of a user, including these fields:

- emoji: always present, with a default value
- user: always present, foreign key to user
- message: optional, maximum length of 100

The table also stores

- cached_markdown_version
- message_html

For rendering markdown in the `message` field.

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