spec/dummy/db/schema.rb in my_forum-0.0.1.beta32 vs spec/dummy/db/schema.rb in my_forum-0.0.1.beta33
- old
+ new
@@ -9,33 +9,41 @@
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20151012095554) do
+ActiveRecord::Schema.define(version: 20151221205045) do
create_table "my_forum_categories", force: :cascade do |t|
t.string "name"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_category_permissions", force: :cascade do |t|
t.integer "user_group_id"
t.integer "category_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
end
+ create_table "my_forum_emoticons", force: :cascade do |t|
+ t.string "file_name"
+ t.string "code"
+ t.boolean "is_active", default: true
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "my_forum_forums", force: :cascade do |t|
t.integer "category_id"
t.string "name"
t.string "description"
t.integer "topics_count"
t.integer "posts_count"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_images", force: :cascade do |t|
t.integer "user_id"
t.integer "post_id"
@@ -48,26 +56,29 @@
create_table "my_forum_log_read_marks", force: :cascade do |t|
t.integer "user_id"
t.integer "topic_id"
t.integer "post_id"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_posts", force: :cascade do |t|
t.integer "user_id"
t.integer "topic_id"
t.integer "forum_id"
- t.text "text"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.text "text", limit: 4294967295
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.boolean "is_deleted", default: false
end
create_table "my_forum_private_messages", force: :cascade do |t|
t.integer "sender_id"
+ t.string "sender_login"
t.integer "recipient_id"
+ t.string "recipient_login"
t.boolean "sender_deleted", default: false
t.boolean "recipient_deleted", default: false
t.boolean "unread", default: true
t.string "subject"
t.text "body"
@@ -77,12 +88,12 @@
create_table "my_forum_roles", force: :cascade do |t|
t.string "name"
t.string "color"
t.text "rights"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_topics", force: :cascade do |t|
t.integer "forum_id"
t.integer "user_id"
@@ -92,47 +103,57 @@
t.integer "views"
t.integer "posts_count", default: 0
t.boolean "pinned", default: false
t.boolean "closed", default: false
t.boolean "deleted", default: false
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.boolean "is_deleted", default: false
end
create_table "my_forum_user_group_links", force: :cascade do |t|
t.integer "user_id"
t.integer "user_group_id"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_user_groups", force: :cascade do |t|
t.string "name"
t.string "html_color"
t.boolean "default", default: false
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_user_roles", force: :cascade do |t|
t.integer "user_id"
t.integer "role_id"
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
end
create_table "my_forum_users", force: :cascade do |t|
t.string "login"
t.string "password"
t.string "salt"
+ t.string "real_name"
+ t.integer "gender"
+ t.date "birthdate"
+ t.text "signature"
+ t.text "avatar_url"
+ t.string "location"
+ t.string "user_ip"
+ t.text "additional_info"
t.string "email"
t.integer "posts_count"
+ t.boolean "activated", default: false
t.boolean "is_admin", default: false
t.boolean "is_moderator", default: false
t.boolean "is_deleted", default: false
t.boolean "permanently_banned", default: false
- t.datetime "created_at"
- t.datetime "updated_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
t.datetime "last_logged_in"
end
end