diff options
author | jomo <github@jomo.tv> | 2014-11-21 00:39:38 +0100 |
---|---|---|
committer | jomo <github@jomo.tv> | 2014-11-21 00:39:38 +0100 |
commit | 39fceedf56be0a7078c43ab726117cf043e8e0f3 (patch) | |
tree | 941e4232364bffc0bfcc785e2c621796370ff84e /db | |
parent | f6c4c787528cfb673340cb3669410f796a4dbbf0 (diff) |
add basic support for labels
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/20141120202853_add_labels.rb | 15 | ||||
-rw-r--r-- | db/schema.rb | 42 |
2 files changed, 42 insertions, 15 deletions
diff --git a/db/migrate/20141120202853_add_labels.rb b/db/migrate/20141120202853_add_labels.rb new file mode 100644 index 0000000..5ea97de --- /dev/null +++ b/db/migrate/20141120202853_add_labels.rb @@ -0,0 +1,15 @@ +class AddLabels < ActiveRecord::Migration + def change + create_table :labels do |t| + t.string :name + t.references :role + end + + add_column :forumthreads, :label_id, :integer + + create_table :forums_labels, id: false do |t| + t.references :forum + t.references :label + end + end +end
\ No newline at end of file diff --git a/db/schema.rb b/db/schema.rb index caaa7d9..e0ce7e0 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,15 +11,15 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20140617183755) do +ActiveRecord::Schema.define(version: 20141120202853) do create_table "blogposts", force: true do |t| t.string "title" t.text "content" t.integer "user_author_id" t.integer "user_editor_id" - t.datetime "created_at", null: false - t.datetime "updated_at", null: false + t.datetime "created_at" + t.datetime "updated_at" end create_table "comments", force: true do |t| @@ -27,8 +27,8 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.integer "user_author_id" t.integer "user_editor_id" t.integer "blogpost_id" - t.datetime "created_at", null: false - t.datetime "updated_at", null: false + t.datetime "created_at" + t.datetime "updated_at" end create_table "forumgroups", force: true do |t| @@ -46,6 +46,11 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.integer "forumgroup_id" end + create_table "forums_labels", id: false, force: true do |t| + t.integer "forum_id" + t.integer "label_id" + end + create_table "forumthreads", force: true do |t| t.string "title" t.text "content" @@ -54,8 +59,9 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.integer "user_author_id" t.integer "user_editor_id" t.integer "forum_id" - t.datetime "created_at", null: false - t.datetime "updated_at", null: false + t.datetime "created_at" + t.datetime "updated_at" + t.integer "label_id" end create_table "info", force: true do |t| @@ -63,9 +69,15 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.text "content" end - create_table "register_tokens", primary_key: "uuid", force: true do |t| - t.string "token", limit: 6, null: false - t.string "email", null: false + create_table "labels", force: true do |t| + t.string "name" + t.integer "role_id" + end + + create_table "register_tokens", force: true do |t| + t.string "uuid", limit: 32, null: false + t.string "token", limit: 6, null: false + t.string "email", null: false end create_table "roles", force: true do |t| @@ -76,8 +88,8 @@ ActiveRecord::Schema.define(version: 20140617183755) do create_table "sessions", force: true do |t| t.string "session_id", null: false t.text "data" - t.datetime "created_at", null: false - t.datetime "updated_at", null: false + t.datetime "created_at" + t.datetime "updated_at" end add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree @@ -88,8 +100,8 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.integer "user_author_id" t.integer "user_editor_id" t.integer "forumthread_id" - t.datetime "created_at", null: false - t.datetime "updated_at", null: false + t.datetime "created_at" + t.datetime "updated_at" end create_table "users", force: true do |t| @@ -109,7 +121,7 @@ ActiveRecord::Schema.define(version: 20140617183755) do t.string "email_token" t.boolean "confirmed", default: false t.datetime "last_seen" - t.integer "role_id", default: 3, null: false + t.integer "role_id", null: false t.datetime "created_at" t.datetime "updated_at" t.boolean "mail_own_thread_reply", default: true |