summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorjomo <github@jomo.tv>2014-04-20 03:07:39 +0200
committerjomo <github@jomo.tv>2014-04-20 03:07:39 +0200
commitcbafa3c46a4406f6d6bf13e2871c16ae4c264d75 (patch)
tree3f5d51b805ad8f60faa21a09572b7b11c7342850 /db
parent097f9b1ba47ab3d844ddc12c740fd3b47070a221 (diff)
cleaned up, added threadreplies, added info
Diffstat (limited to 'db')
-rw-r--r--db/migrate/11_create_info.rb8
-rw-r--r--db/schema.rb85
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