Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 477
- Log:
Overlooked schema update
- Author:
- rool
- Date:
- Wed Jun 19 05:53:42 +0100 2019
- Size:
- 3924 Bytes
1 | # This file is autogenerated. Instead of editing this file, please use the |
2 | # migrations feature of ActiveRecord to incrementally modify your database, and |
3 | # then regenerate this schema definition. |
4 | |
5 | ActiveRecord::Schema.define(:version => 49) do |
6 | |
7 | create_table "blacklists", :force => true do |t| |
8 | t.column "list", :text, :default => "" |
9 | t.column "title_list", :text, :default => "" |
10 | end |
11 | |
12 | create_table "forums", :force => true do |t| |
13 | t.column "name", :string |
14 | t.column "description", :string |
15 | t.column "topics_count", :integer, :default => 0 |
16 | t.column "posts_count", :integer, :default => 0 |
17 | t.column "position", :integer |
18 | t.column "description_html", :text |
19 | end |
20 | |
21 | create_table "logged_exceptions", :force => true do |t| |
22 | t.column "exception_class", :string |
23 | t.column "controller_name", :string |
24 | t.column "action_name", :string |
25 | t.column "message", :string |
26 | t.column "backtrace", :text |
27 | t.column "environment", :text |
28 | t.column "request", :text |
29 | t.column "created_at", :datetime |
30 | end |
31 | |
32 | create_table "moderatorships", :force => true do |t| |
33 | t.column "forum_id", :integer |
34 | t.column "user_id", :integer |
35 | end |
36 | |
37 | add_index "moderatorships", ["forum_id"], :name => "index_moderatorships_on_forum_id" |
38 | |
39 | create_table "monitorships", :force => true do |t| |
40 | t.column "topic_id", :integer |
41 | t.column "user_id", :integer |
42 | t.column "active", :boolean, :default => true |
43 | end |
44 | |
45 | create_table "posts", :force => true do |t| |
46 | t.column "user_id", :integer |
47 | t.column "topic_id", :integer |
48 | t.column "body", :text |
49 | t.column "created_at", :datetime |
50 | t.column "updated_at", :datetime |
51 | t.column "forum_id", :integer |
52 | t.column "body_html", :text |
53 | end |
54 | |
55 | add_index "posts", ["created_at", "forum_id"], :name => "index_posts_on_forum_id" |
56 | add_index "posts", ["user_id", "created_at"], :name => "index_posts_on_user_id" |
57 | |
58 | create_table "sessions", :force => true do |t| |
59 | t.column "session_id", :string |
60 | t.column "data", :text |
61 | t.column "updated_at", :datetime |
62 | t.column "user_id", :integer |
63 | end |
64 | |
65 | add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" |
66 | |
67 | create_table "topics", :force => true do |t| |
68 | t.column "forum_id", :integer |
69 | t.column "user_id", :integer |
70 | t.column "title", :string |
71 | t.column "created_at", :datetime |
72 | t.column "updated_at", :datetime |
73 | t.column "hits", :integer, :default => 0 |
74 | t.column "posts_count", :integer, :default => 0 |
75 | t.column "replied_at", :datetime |
76 | t.column "sticky", :integer, :default => 0 |
77 | t.column "locked", :boolean, :default => false |
78 | t.column "replied_by", :integer |
79 | t.column "last_post_id", :integer |
80 | end |
81 | |
82 | add_index "topics", ["forum_id"], :name => "index_topics_on_forum_id" |
83 | add_index "topics", ["forum_id", "replied_at", "sticky"], :name => "index_topics_on_sticky_and_replied_at" |
84 | |
85 | create_table "users", :force => true do |t| |
86 | t.column "login", :string |
87 | t.column "email", :string |
88 | t.column "password_hash", :string |
89 | t.column "created_at", :datetime |
90 | t.column "last_login_at", :datetime |
91 | t.column "admin", :boolean |
92 | t.column "posts_count", :integer, :default => 0 |
93 | t.column "last_seen_at", :datetime |
94 | t.column "display_name", :string |
95 | t.column "updated_at", :datetime |
96 | t.column "website", :string |
97 | t.column "login_key", :string |
98 | t.column "login_key_expires_at", :datetime |
99 | t.column "activated", :boolean, :default => false |
100 | t.column "bio", :string |
101 | t.column "bio_html", :text |
102 | end |
103 | |
104 | add_index "users", ["last_seen_at"], :name => "index_users_on_last_seen_at" |
105 | |
106 | end |