1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.
ActiveRecord::Schema.define(:version => 15) do
create_table "incoming_messages", :force => true do |t|
t.column "info_request_id", :integer
t.column "raw_data", :text
t.column "created_at", :datetime
t.column "updated_at", :datetime
end
create_table "info_requests", :force => true do |t|
t.column "title", :text
t.column "user_id", :integer
t.column "public_body_id", :integer
t.column "created_at", :datetime
t.column "updated_at", :datetime
end
create_table "outgoing_messages", :force => true do |t|
t.column "info_request_id", :integer
t.column "body", :text
t.column "status", :string
t.column "message_type", :string
t.column "created_at", :datetime
t.column "updated_at", :datetime
t.column "sent_at", :datetime
end
create_table "post_redirects", :force => true do |t|
t.column "token", :text
t.column "uri", :text
t.column "post_params_yaml", :text
t.column "created_at", :datetime
t.column "updated_at", :datetime
t.column "email_token", :text
end
create_table "public_bodies", :force => true do |t|
t.column "name", :text
t.column "short_name", :text
t.column "request_email", :text
t.column "complaint_email", :text
t.column "version", :integer
t.column "last_edit_editor", :string
t.column "last_edit_comment", :string
t.column "created_at", :datetime
t.column "updated_at", :datetime
end
create_table "public_body_versions", :force => true do |t|
t.column "public_body_id", :integer
t.column "version", :integer
t.column "name", :text
t.column "short_name", :text
t.column "request_email", :text
t.column "complaint_email", :text
t.column "updated_at", :datetime
t.column "last_edit_editor", :string
t.column "last_edit_comment", :string
end
create_table "sessions", :force => true do |t|
t.column "session_id", :string
t.column "data", :text
t.column "updated_at", :datetime
t.column "created_at", :datetime
end
add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
create_table "users", :force => true do |t|
t.column "email", :string
t.column "name", :string
t.column "hashed_password", :string
t.column "salt", :string
t.column "created_at", :datetime
t.column "updated_at", :datetime
end
end
|
