diff options
author | jomo <github@jomo.tv> | 2014-04-20 03:07:39 +0200 |
---|---|---|
committer | jomo <github@jomo.tv> | 2014-04-20 03:07:39 +0200 |
commit | cbafa3c46a4406f6d6bf13e2871c16ae4c264d75 (patch) | |
tree | 3f5d51b805ad8f60faa21a09572b7b11c7342850 /db | |
parent | 097f9b1ba47ab3d844ddc12c740fd3b47070a221 (diff) |
cleaned up, added threadreplies, added info
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/11_create_info.rb | 8 | ||||
-rw-r--r-- | db/schema.rb | 85 |
2 files changed, 53 insertions, 40 deletions
diff --git a/db/migrate/11_create_info.rb b/db/migrate/11_create_info.rb new file mode 100644 index 0000000..c7dc516 --- /dev/null +++ b/db/migrate/11_create_info.rb @@ -0,0 +1,8 @@ +class CreateInfo < ActiveRecord::Migration + def change + create_table :info do |t| + t.string :title + t.text :content + end + end +end diff --git a/db/schema.rb b/db/schema.rb index b877bbc..f666e1a 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -9,36 +9,36 @@ # 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 to check this file into your version control system. +# It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(:version => 10) do +ActiveRecord::Schema.define(version: 11) do - create_table "blogposts", :force => true do |t| + 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", null: false + t.datetime "updated_at", null: false end - create_table "comments", :force => true do |t| + create_table "comments", force: true do |t| t.text "content" 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", null: false + t.datetime "updated_at", null: false end - create_table "forumgroups", :force => true do |t| + create_table "forumgroups", force: true do |t| t.string "name" t.integer "position" t.integer "role_read_id" t.integer "role_write_id" end - create_table "forums", :force => true do |t| + create_table "forums", force: true do |t| t.string "name" t.integer "position" t.integer "role_read_id" @@ -46,67 +46,72 @@ ActiveRecord::Schema.define(:version => 10) do t.integer "forumgroup_id" end - create_table "forumthreads", :force => true do |t| + create_table "forumthreads", force: true do |t| t.string "title" t.text "content" - t.boolean "sticky", :default => false - t.boolean "locked", :default => false + t.boolean "sticky", default: false + t.boolean "locked", default: false 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", null: false + t.datetime "updated_at", null: false 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 "info", force: true do |t| + t.string "title" + t.text "content" end - create_table "roles", :force => true do |t| + create_table "register_tokens", primary_key: "uuid", force: true do |t| + t.string "token", limit: 6, null: false + t.string "email", null: false + end + + create_table "roles", force: true do |t| t.string "name" t.integer "value" end - create_table "sessions", :force => true do |t| - t.string "session_id", :null => false + 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", null: false + t.datetime "updated_at", null: false end - add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" - add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" + add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree + add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree - create_table "threadreplies", :force => true do |t| + create_table "threadreplies", force: true do |t| t.text "content" 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", null: false + t.datetime "updated_at", null: false end - create_table "users", :force => true do |t| - t.string "uuid", :null => false - t.string "name", :null => false - t.string "password_digest", :null => false - t.string "ign", :null => false - t.string "email", :null => false + create_table "users", force: true do |t| + t.string "uuid", null: false + t.string "name", null: false + t.string "password_digest", null: false + t.string "ign", null: false + t.string "email", null: false t.text "about" t.string "last_ip" t.string "skype" - t.boolean "skype_public", :default => false + t.boolean "skype_public", default: false t.string "youtube" t.string "youtube_channelname" t.string "twitter" - t.boolean "donor", :default => false + t.boolean "donor", default: false t.string "email_token" - t.boolean "confirmed", :default => false + t.boolean "confirmed", default: false t.datetime "last_seen" - t.integer "role_id", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false + t.integer "role_id", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end end |