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
|
# File 'lib/generators/air18n/migration/templates/active_record/migration.rb', line 2
def self.up
create_table "phrase_revisions", :force => true do |t|
t.string "key"
t.text "value"
t.string "value_hash"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "phrase_revisions", ["key", "value_hash"], :name => "index_phrase_revisions_on_key_and_value_hash"
create_table "phrase_screenshots", :force => true do |t|
t.string "screenshot_url"
t.datetime "created_at"
t.datetime "updated_at"
t.string "controller"
t.string "action"
t.string "phrase_key"
t.integer "width"
t.integer "height"
t.integer "x"
t.integer "y"
end
add_index "phrase_screenshots", ["controller", "action", "phrase_key"], :name => "index_phrase_screenshots_on_controller_and_action_and_phrase_key", :unique => true
add_index "phrase_screenshots", ["phrase_key"], :name => "index_phrase_screenshots_on_phrase_key"
create_table "phrase_translations", :force => true do |t|
t.integer "user_id"
t.integer "phrase_id"
t.string "key"
t.text "value"
t.string "locale"
t.datetime "created_at"
t.datetime "updated_at"
t.text "value_old", :limit => 16777215
t.boolean "is_verification", :default => false
t.boolean "is_stale", :default => false
t.boolean "is_latest", :default => false
t.integer "source_word_count", :default => 0
t.string "source_hash"
t.text "payment_details"
end
add_index "phrase_translations", ["locale", "is_latest", "is_stale", "is_verification"], :name => "index_phrase_translations_on_locale_and_flags"
add_index "phrase_translations", ["phrase_id"], :name => "index_phrase_translations_on_phrase_id"
create_table "phrases", :force => true do |t|
t.string "key"
t.string "description"
t.text "value", :limit => 16777215
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "phrases", ["key"], :name => "index_phrases_on_key", :unique => true
create_table "screenshots", :force => true do |t|
t.string "screenshot_url", :null => false
t.integer "status", :default => 0, :null => false
t.integer "reviewed_by"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "screenshots", ["screenshot_url", "status"], :name => "index_screenshots_on_screenshot_url_and_status"
create_table "translator_infos", :force => true do |t|
t.integer "user_id"
t.string "currency"
t.float "translate_rate"
t.float "verify_rate"
t.integer "roles"
t.string "project"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "translator_infos", ["user_id"], :name => "index_translator_infos_on_user_id", :unique => true
end
|