Skip to content

Commit c3322df

Browse files
sashazykovsashazykov
committed
updated schema
1 parent 176706f commit c3322df

File tree

1 file changed

+109
-116
lines changed

1 file changed

+109
-116
lines changed

‎db/schema.rb‎

Lines changed: 109 additions & 116 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,3 @@
1-
# encoding: UTF-8
2-
# frozen_string_literal: true
3-
41
# This file is auto-generated from the current state of the database. Instead
52
# of editing this file, please use the migrations feature of Active Record to
63
# incrementally modify your database, and then regenerate this schema definition.
@@ -13,132 +10,128 @@
1310
#
1411
# It's strongly recommended that you check this file into your version control system.
1512

16-
ActiveRecord::Schema.define(version: 20170308163825) do
17-
create_table 'collaborators', force: :cascade do |t|
18-
t.integer 'project_id', limit: 4
19-
t.string 'login', limit: 255
20-
t.datetime 'created_at'
21-
t.datetime 'updated_at'
22-
end
23-
24-
add_index 'collaborators', ['project_id'], name: 'index_collaborators_on_project_id', using: :btree
13+
ActiveRecord::Schema.define(version: 2017_03_08_163825) do
2514

26-
create_table 'deposits', force: :cascade do |t|
27-
t.integer 'project_id', limit: 4
28-
t.string 'txid', limit: 255
29-
t.integer 'confirmations', limit: 4
30-
t.datetime 'created_at'
31-
t.datetime 'updated_at'
32-
t.integer 'amount', limit: 8
33-
t.float 'fee_size', limit: 24
15+
create_table "collaborators", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
16+
t.integer "project_id"
17+
t.string "login"
18+
t.datetime "created_at"
19+
t.datetime "updated_at"
20+
t.index ["project_id"], name: "index_collaborators_on_project_id"
3421
end
3522

36-
add_index 'deposits', ['project_id'], name: 'index_deposits_on_project_id', using: :btree
37-
38-
create_table 'projects', force: :cascade do |t|
39-
t.string 'url', limit: 255
40-
t.string 'bitcoin_address', limit: 255
41-
t.datetime 'created_at'
42-
t.datetime 'updated_at'
43-
t.string 'name', limit: 255
44-
t.string 'full_name', limit: 255
45-
t.string 'source_full_name', limit: 255
46-
t.text 'description', limit: 65535
47-
t.integer 'watchers_count', limit: 4
48-
t.string 'language', limit: 255
49-
t.string 'last_commit', limit: 255
50-
t.integer 'available_amount_cache', limit: 4
51-
t.string 'github_id', limit: 255
52-
t.string 'host', limit: 255, default: 'github'
53-
t.boolean 'hold_tips', default: false
54-
t.datetime 'info_updated_at'
55-
t.string 'branch', limit: 255
56-
t.boolean 'disable_notifications'
57-
t.string 'avatar_url', limit: 255
58-
t.datetime 'deleted_at'
59-
t.string 'bitcoin_address2', limit: 255
60-
t.integer 'wallet_id', limit: 4
61-
t.string 'legacy_address', limit: 255
23+
create_table "deposits", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
24+
t.integer "project_id"
25+
t.string "txid"
26+
t.integer "confirmations"
27+
t.datetime "created_at"
28+
t.datetime "updated_at"
29+
t.bigint "amount"
30+
t.float "fee_size"
31+
t.index ["project_id"], name: "index_deposits_on_project_id"
6232
end
6333

64-
add_index 'projects', ['full_name'], name: 'index_projects_on_full_name', unique: true, using: :btree
65-
add_index 'projects', ['github_id'], name: 'index_projects_on_github_id', unique: true, using: :btree
66-
67-
create_table 'sendmanies', force: :cascade do |t|
68-
t.string 'txid', limit: 255
69-
t.text 'data', limit: 65535
70-
t.string 'result', limit: 255
71-
t.boolean 'is_error'
72-
t.datetime 'created_at'
73-
t.datetime 'updated_at'
34+
create_table "projects", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
35+
t.string "url"
36+
t.string "bitcoin_address"
37+
t.datetime "created_at"
38+
t.datetime "updated_at"
39+
t.string "name"
40+
t.string "full_name"
41+
t.string "source_full_name"
42+
t.text "description"
43+
t.integer "watchers_count"
44+
t.string "language"
45+
t.string "last_commit"
46+
t.integer "available_amount_cache"
47+
t.string "github_id"
48+
t.string "host", default: "github"
49+
t.boolean "hold_tips", default: false
50+
t.datetime "info_updated_at"
51+
t.string "branch"
52+
t.boolean "disable_notifications"
53+
t.string "avatar_url"
54+
t.datetime "deleted_at"
55+
t.string "bitcoin_address2"
56+
t.integer "wallet_id"
57+
t.string "legacy_address"
58+
t.index ["full_name"], name: "index_projects_on_full_name", unique: true
59+
t.index ["github_id"], name: "index_projects_on_github_id", unique: true
7460
end
7561

76-
create_table 'tipping_policies_texts', force: :cascade do |t|
77-
t.integer 'project_id', limit: 4
78-
t.integer 'user_id', limit: 4
79-
t.text 'text', limit: 65535
80-
t.datetime 'created_at'
81-
t.datetime 'updated_at'
62+
create_table "sendmanies", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
63+
t.string "txid"
64+
t.text "data"
65+
t.string "result"
66+
t.boolean "is_error"
67+
t.datetime "created_at"
68+
t.datetime "updated_at"
8269
end
8370

84-
add_index 'tipping_policies_texts', ['project_id'], name: 'index_tipping_policies_texts_on_project_id', using: :btree
85-
add_index 'tipping_policies_texts', ['user_id'], name: 'index_tipping_policies_texts_on_user_id', using: :btree
86-
87-
create_table 'tips', force: :cascade do |t|
88-
t.integer 'user_id', limit: 4
89-
t.integer 'amount', limit: 8
90-
t.integer 'sendmany_id', limit: 4
91-
t.datetime 'created_at'
92-
t.datetime 'updated_at'
93-
t.string 'commit', limit: 255
94-
t.integer 'project_id', limit: 4
95-
t.datetime 'refunded_at'
96-
t.text 'commit_message', limit: 65535
97-
t.datetime 'decided_at'
71+
create_table "tipping_policies_texts", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
72+
t.integer "project_id"
73+
t.integer "user_id"
74+
t.text "text"
75+
t.datetime "created_at"
76+
t.datetime "updated_at"
77+
t.index ["project_id"], name: "index_tipping_policies_texts_on_project_id"
78+
t.index ["user_id"], name: "index_tipping_policies_texts_on_user_id"
9879
end
9980

100-
add_index 'tips', ['project_id'], name: 'index_tips_on_project_id', using: :btree
101-
add_index 'tips', ['sendmany_id'], name: 'index_tips_on_sendmany_id', using: :btree
102-
add_index 'tips', ['user_id'], name: 'index_tips_on_user_id', using: :btree
103-
104-
create_table 'users', force: :cascade do |t|
105-
t.string 'email', limit: 255, default: '', null: false
106-
t.string 'encrypted_password', limit: 255, default: '', null: false
107-
t.string 'reset_password_token', limit: 255
108-
t.datetime 'reset_password_sent_at'
109-
t.datetime 'remember_created_at'
110-
t.integer 'sign_in_count', limit: 4, default: 0, null: false
111-
t.datetime 'current_sign_in_at'
112-
t.datetime 'last_sign_in_at'
113-
t.string 'current_sign_in_ip', limit: 255
114-
t.string 'last_sign_in_ip', limit: 255
115-
t.datetime 'created_at'
116-
t.datetime 'updated_at'
117-
t.string 'nickname', limit: 255
118-
t.string 'name', limit: 255
119-
t.string 'image', limit: 255
120-
t.string 'bitcoin_address', limit: 255
121-
t.string 'login_token', limit: 255
122-
t.boolean 'unsubscribed'
123-
t.datetime 'notified_at'
124-
t.integer 'commits_count', limit: 4, default: 0
125-
t.integer 'withdrawn_amount', limit: 8, default: 0
126-
t.datetime 'confirmed_at'
127-
t.datetime 'confirmation_sent_at'
128-
t.string 'confirmation_token', limit: 255
129-
t.string 'unconfirmed_email', limit: 255
130-
t.string 'display_name', limit: 255
131-
t.integer 'denom', limit: 4, default: 0
81+
create_table "tips", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
82+
t.integer "user_id"
83+
t.bigint "amount"
84+
t.integer "sendmany_id"
85+
t.datetime "created_at"
86+
t.datetime "updated_at"
87+
t.string "commit"
88+
t.integer "project_id"
89+
t.datetime "refunded_at"
90+
t.text "commit_message"
91+
t.datetime "decided_at"
92+
t.index ["project_id"], name: "index_tips_on_project_id"
93+
t.index ["sendmany_id"], name: "index_tips_on_sendmany_id"
94+
t.index ["user_id"], name: "index_tips_on_user_id"
13295
end
13396

134-
add_index 'users', ['email'], name: 'index_users_on_email', unique: true, using: :btree
135-
add_index 'users', ['reset_password_token'], name: 'index_users_on_reset_password_token', unique: true, using: :btree
97+
create_table "users", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
98+
t.string "email", default: "", null: false
99+
t.string "encrypted_password", default: "", null: false
100+
t.string "reset_password_token"
101+
t.datetime "reset_password_sent_at"
102+
t.datetime "remember_created_at"
103+
t.integer "sign_in_count", default: 0, null: false
104+
t.datetime "current_sign_in_at"
105+
t.datetime "last_sign_in_at"
106+
t.string "current_sign_in_ip"
107+
t.string "last_sign_in_ip"
108+
t.datetime "created_at"
109+
t.datetime "updated_at"
110+
t.string "nickname"
111+
t.string "name"
112+
t.string "image"
113+
t.string "bitcoin_address"
114+
t.string "login_token"
115+
t.boolean "unsubscribed"
116+
t.datetime "notified_at"
117+
t.integer "commits_count", default: 0
118+
t.bigint "withdrawn_amount", default: 0
119+
t.datetime "confirmed_at"
120+
t.datetime "confirmation_sent_at"
121+
t.string "confirmation_token"
122+
t.string "unconfirmed_email"
123+
t.string "display_name"
124+
t.integer "denom", default: 0
125+
t.index ["email"], name: "index_users_on_email", unique: true
126+
t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
127+
end
136128

137-
create_table 'wallets', force: :cascade do |t|
138-
t.string 'name', limit: 255
139-
t.string 'xpub', limit: 255
140-
t.integer 'last_address_index', limit: 4, default: 1
141-
t.datetime 'created_at', null: false
142-
t.datetime 'updated_at', null: false
129+
create_table "wallets", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
130+
t.string "name"
131+
t.string "xpub"
132+
t.integer "last_address_index", default: 1
133+
t.datetime "created_at", null: false
134+
t.datetime "updated_at", null: false
143135
end
136+
144137
end

0 commit comments

Comments
 (0)