Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 7
- Log:
Initial import of RForum 0.2 sources from a downloaded Tarball.
RForum is a Ruby On Rails based forum and mail gateway service.
- Author:
- adh
- Date:
- Sat Jul 22 18:43:13 +0100 2006
- Size:
- 6700 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 => 4) do |
6 | |
7 | create_table "attachments", :force => true do |t| |
8 | t.column "created_at", :datetime, :null => false |
9 | t.column "updated_at", :datetime, :null => false |
10 | t.column "filename", :string, :limit => 60, :null => false |
11 | t.column "post_id", :integer |
12 | t.column "position", :integer |
13 | end |
14 | |
15 | create_table "blocked_ips", :force => true do |t| |
16 | t.column "created_at", :datetime, :null => false |
17 | t.column "updated_at", :datetime, :null => false |
18 | t.column "ip", :string, :limit => 20, :null => false |
19 | end |
20 | |
21 | add_index "blocked_ips", ["ip"], :name => "blocked_ips_1uq", :unique => true |
22 | |
23 | create_table "forums", :force => true do |t| |
24 | t.column "created_at", :datetime, :null => false |
25 | t.column "updated_at", :datetime, :null => false |
26 | t.column "name", :string, :limit => 60, :null => false |
27 | t.column "description", :string, :null => false |
28 | t.column "groupname", :string, :limit => 50 |
29 | t.column "list_address", :string, :limit => 50 |
30 | t.column "position", :integer |
31 | t.column "add_mail_headers", :string |
32 | end |
33 | |
34 | add_index "forums", ["groupname"], :name => "forums_1uq", :unique => true |
35 | |
36 | create_table "post_votes", :force => true do |t| |
37 | t.column "created_at", :datetime, :null => false |
38 | t.column "updated_at", :datetime, :null => false |
39 | t.column "post_id", :integer, :null => false |
40 | t.column "voter_id", :integer, :null => false |
41 | t.column "value", :integer, :null => false |
42 | end |
43 | |
44 | add_index "post_votes", ["voter_id", "post_id"], :name => "post_votes_uq1" |
45 | add_index "post_votes", ["post_id"], :name => "post_votes_1ix" |
46 | add_index "post_votes", ["voter_id"], :name => "post_votes_2ix" |
47 | |
48 | create_table "posts", :force => true do |t| |
49 | t.column "created_at", :datetime, :null => false |
50 | t.column "updated_at", :datetime, :null => false |
51 | t.column "topic_id", :integer, :null => false |
52 | t.column "l", :integer, :null => false |
53 | t.column "r", :integer, :null => false |
54 | t.column "parent_id", :integer |
55 | t.column "user_id", :integer |
56 | t.column "deleted", :integer, :default => 0, :null => false |
57 | t.column "guest_name", :string, :limit => 50 |
58 | t.column "guest_email", :string, :limit => 50 |
59 | t.column "author_host", :string, :limit => 50 |
60 | t.column "subject", :string, :limit => 100, :null => false |
61 | t.column "nntpid", :integer, :null => false |
62 | t.column "messageid", :string, :limit => 100, :null => false |
63 | t.column "text", :text, :null => false |
64 | t.column "post_method", :string, :limit => 10, :default => "web", :null => false |
65 | end |
66 | |
67 | add_index "posts", ["messageid"], :name => "posts_1uq", :unique => true |
68 | add_index "posts", ["l", "r", "parent_id"], :name => "posts_1ix" |
69 | add_index "posts", ["messageid"], :name => "posts_2ix" |
70 | add_index "posts", ["topic_id", "deleted", "created_at", "id"], :name => "posts_3ix" |
71 | add_index "posts", ["created_at"], :name => "posts_4ix" |
72 | add_index "posts", ["l"], :name => "posts_5ix" |
73 | add_index "posts", ["r"], :name => "posts_6ix" |
74 | add_index "posts", ["parent_id"], :name => "posts_7ix" |
75 | add_index "posts", ["user_id"], :name => "posts_8ix" |
76 | add_index "posts", ["nntpid"], :name => "posts_9ix" |
77 | |
78 | create_table "search_index_items", :force => true do |t| |
79 | t.column "post_id", :integer, :null => false |
80 | t.column "subject", :string, :limit => 60, :null => false |
81 | t.column "text", :text, :null => false |
82 | end |
83 | |
84 | create_table "sessions", :force => true do |t| |
85 | t.column "sessid", :string, :limit => 60, :null => false |
86 | t.column "data", :text |
87 | t.column "updated_at", :datetime |
88 | end |
89 | |
90 | add_index "sessions", ["sessid"], :name => "sessions_1uq", :unique => true |
91 | |
92 | create_table "tags", :force => true do |t| |
93 | t.column "name", :string, :limit => 60, :null => false |
94 | end |
95 | |
96 | create_table "topic_reads", :force => true do |t| |
97 | t.column "created_at", :datetime, :null => false |
98 | t.column "updated_at", :datetime, :null => false |
99 | t.column "user_id", :integer, :null => false |
100 | t.column "topic_id", :integer, :null => false |
101 | end |
102 | |
103 | add_index "topic_reads", ["topic_id", "user_id"], :name => "topic_reads_1uq", :unique => true |
104 | |
105 | create_table "topic_subscriptions", :force => true do |t| |
106 | t.column "created_at", :datetime, :null => false |
107 | t.column "updated_at", :datetime, :null => false |
108 | t.column "topic_id", :integer, :null => false |
109 | t.column "user_id", :integer |
110 | t.column "guest_email", :string, :limit => 50 |
111 | end |
112 | |
113 | add_index "topic_subscriptions", ["topic_id", "user_id"], :name => "topic_subscribers_1uq", :unique => true |
114 | add_index "topic_subscriptions", ["topic_id", "guest_email"], :name => "topic_subscribers_2uq", :unique => true |
115 | |
116 | create_table "topics", :force => true do |t| |
117 | t.column "created_at", :datetime, :null => false |
118 | t.column "updated_at", :datetime, :null => false |
119 | t.column "forum_id", :integer, :null => false |
120 | t.column "subject", :string, :limit => 60, :null => false |
121 | t.column "last_post_created_at", :datetime |
122 | t.column "last_post_user_id", :integer |
123 | t.column "last_post_author", :string, :limit => 60 |
124 | t.column "last_post_subject", :string, :limit => 60 |
125 | t.column "deleted", :integer, :default => 0, :null => false |
126 | t.column "post_counter", :integer, :default => 1 |
127 | end |
128 | |
129 | add_index "topics", ["forum_id", "deleted", "last_post_created_at"], :name => "topics_1ix" |
130 | |
131 | create_table "topics_tags", :id => false, :force => true do |t| |
132 | t.column "topic_id", :integer, :null => false |
133 | t.column "tag_id", :integer, :null => false |
134 | end |
135 | |
136 | add_index "topics_tags", ["topic_id", "tag_id"], :name => "topics_tags_1uq", :unique => true |
137 | |
138 | create_table "users", :force => true do |t| |
139 | t.column "created_at", :datetime, :null => false |
140 | t.column "updated_at", :datetime, :null => false |
141 | t.column "role", :string, :limit => 50, :null => false |
142 | t.column "name", :string, :limit => 20, :null => false |
143 | t.column "email", :string, :limit => 60, :null => false |
144 | t.column "firstname", :string, :limit => 30 |
145 | t.column "surname", :string, :limit => 30 |
146 | t.column "password", :string, :limit => 60, :null => false |
147 | t.column "security_token", :string, :limit => 32 |
148 | t.column "additional_information", :text |
149 | t.column "token_expiry", :datetime |
150 | t.column "receives_email", :integer, :default => 0, :null => false |
151 | t.column "sends_email", :integer, :default => 0, :null => false |
152 | end |
153 | |
154 | add_index "users", ["name"], :name => "users_1uq", :unique => true |
155 | add_index "users", ["role"], :name => "users_1ix" |
156 | |
157 | end |