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