2 # This file is auto-generated from the current state of the database. Instead
\r
3 # of editing this file, please use the migrations feature of Active Record to
\r
4 # incrementally modify your database, and then regenerate this schema definition.
\r
6 # Note that this schema.rb definition is the authoritative source for your
\r
7 # database schema. If you need to create the application database on another
\r
8 # system, you should be using db:schema:load, not running all the migrations
\r
9 # from scratch. The latter is a flawed and unsustainable approach (the more migrations
\r
10 # you'll amass, the slower it'll run and the greater likelihood for issues).
\r
12 # It's strongly recommended to check this file into your version control system.
\r
14 ActiveRecord::Schema.define(:version => 20120306231650) do
\r
16 create_table "admins", :force => true do |t|
\r
17 t.string "email", :default => "", :null => false
\r
18 t.string "encrypted_password", :limit => 128, :default => "", :null => false
\r
19 t.string "reset_password_token"
\r
20 t.datetime "reset_password_sent_at"
\r
21 t.datetime "remember_created_at"
\r
22 t.integer "sign_in_count", :default => 0
\r
23 t.datetime "current_sign_in_at"
\r
24 t.datetime "last_sign_in_at"
\r
25 t.string "current_sign_in_ip"
\r
26 t.string "last_sign_in_ip"
\r
27 t.string "confirmation_token"
\r
28 t.datetime "confirmed_at"
\r
29 t.datetime "confirmation_sent_at"
\r
30 t.string "authentication_token"
\r
31 t.integer "approve", :default => 0, :null => false
\r
32 t.datetime "created_at"
\r
33 t.datetime "updated_at"
\r
36 add_index "admins", ["authentication_token"], :name => "index_admins_on_authentication_token", :unique => true
\r
37 add_index "admins", ["confirmation_token"], :name => "index_admins_on_confirmation_token", :unique => true
\r
38 add_index "admins", ["email"], :name => "index_admins_on_email", :unique => true
\r
39 add_index "admins", ["reset_password_token"], :name => "index_admins_on_reset_password_token", :unique => true
\r
41 create_table "artists", :force => true do |t|
\r
44 t.string "homepage_url"
\r
46 t.integer "default_license_id", :default => 0, :null => false
\r
47 t.datetime "crowled_at"
\r
48 t.datetime "created_at"
\r
49 t.datetime "updated_at"
\r
50 t.integer "author_id"
\r
53 create_table "authors", :force => true do |t|
\r
55 t.integer "user_id", :default => 0, :null => false
\r
56 t.datetime "created_at"
\r
57 t.datetime "updated_at"
\r
60 add_index "authors", ["user_id"], :name => "index_authors_on_user_id", :unique => true
\r
62 create_table "balloon_templates", :force => true do |t|
\r
63 t.integer "speach_balloon_id", :null => false
\r
64 t.integer "system_picture_id", :null => false
\r
65 t.integer "tail", :default => 1, :null => false
\r
66 t.integer "size", :default => 1, :null => false
\r
67 t.integer "min_width", :default => 0, :null => false
\r
68 t.integer "max_width", :default => 0, :null => false
\r
69 t.integer "min_height", :default => 0, :null => false
\r
70 t.integer "max_height", :default => 0, :null => false
\r
71 t.datetime "created_at"
\r
72 t.datetime "updated_at"
\r
75 add_index "balloon_templates", ["speach_balloon_id", "tail", "size"], :name => "balloon_templates_idts", :unique => true
\r
76 add_index "balloon_templates", ["speach_balloon_id"], :name => "index_balloon_templates_on_speach_balloon_id"
\r
78 create_table "balloons", :force => true do |t|
\r
79 t.integer "panel_id", :null => false
\r
80 t.integer "balloon_template_id", :null => false
\r
81 t.integer "system_picture_id", :null => false
\r
82 t.integer "tail", :default => 1, :null => false
\r
83 t.integer "size", :default => 1, :null => false
\r
84 t.integer "x", :null => false
\r
85 t.integer "y", :null => false
\r
86 t.integer "z", :null => false
\r
87 t.integer "t", :default => 1, :null => false
\r
88 t.integer "width", :null => false
\r
89 t.integer "height", :null => false
\r
90 t.datetime "created_at"
\r
91 t.datetime "updated_at"
\r
94 add_index "balloons", ["panel_id", "t"], :name => "balloon_idt", :unique => true
\r
95 add_index "balloons", ["panel_id"], :name => "index_balloons_on_panel_id"
\r
97 create_table "comics", :force => true do |t|
\r
99 t.integer "width", :default => 200, :null => false
\r
100 t.integer "height", :default => 80, :null => false
\r
101 t.integer "visible", :default => 0, :null => false
\r
102 t.integer "editable", :default => 0, :null => false
\r
103 t.integer "author_id"
\r
104 t.datetime "created_at"
\r
105 t.datetime "updated_at"
\r
108 add_index "comics", ["author_id"], :name => "index_comics_on_author_id"
\r
110 create_table "common_licenses", :force => true do |t|
\r
111 t.integer "license_id", :null => false
\r
112 t.string "name", :null => false
\r
113 t.string "url", :null => false
\r
114 t.integer "cc_by", :default => 0, :null => false
\r
115 t.integer "cc_sa", :default => 0, :null => false
\r
116 t.integer "cc_nd", :default => 0, :null => false
\r
117 t.integer "cc_nc", :default => 0, :null => false
\r
118 t.integer "no_resize", :default => 0, :null => false
\r
119 t.integer "no_flip", :default => 0, :null => false
\r
120 t.integer "no_convert", :default => 0, :null => false
\r
121 t.integer "keep_aspect_ratio", :default => 0, :null => false
\r
122 t.datetime "created_at"
\r
123 t.datetime "updated_at"
\r
126 create_table "licenses", :force => true do |t|
\r
127 t.string "name", :null => false
\r
128 t.string "url", :null => false
\r
129 t.integer "cc_by", :default => 0, :null => false
\r
130 t.integer "cc_sa", :default => 0, :null => false
\r
131 t.integer "cc_nd", :default => 0, :null => false
\r
132 t.integer "cc_nc", :default => 0, :null => false
\r
133 t.integer "no_resize", :default => 0, :null => false
\r
134 t.integer "no_flip", :default => 0, :null => false
\r
135 t.integer "no_convert", :default => 0, :null => false
\r
136 t.integer "keep_aspect_ratio", :default => 0, :null => false
\r
137 t.datetime "created_at"
\r
138 t.datetime "updated_at"
\r
141 add_index "licenses", ["url"], :name => "index_licenses_on_url", :unique => true
\r
143 create_table "original_licenses", :force => true do |t|
\r
144 t.integer "artist_id", :null => false
\r
145 t.integer "license_id", :null => false
\r
146 t.string "name", :null => false
\r
147 t.string "url", :null => false
\r
148 t.integer "cc_by", :default => 0, :null => false
\r
149 t.integer "cc_sa", :default => 0, :null => false
\r
150 t.integer "cc_nd", :default => 0, :null => false
\r
151 t.integer "cc_nc", :default => 0, :null => false
\r
152 t.integer "no_resize", :default => 0, :null => false
\r
153 t.integer "no_flip", :default => 0, :null => false
\r
154 t.integer "no_convert", :default => 0, :null => false
\r
155 t.integer "keep_aspect_ratio", :default => 0, :null => false
\r
156 t.datetime "created_at"
\r
157 t.datetime "updated_at"
\r
160 create_table "original_pictures", :force => true do |t|
\r
161 t.string "ext", :null => false
\r
162 t.integer "width", :null => false
\r
163 t.integer "height", :null => false
\r
164 t.integer "filesize", :null => false
\r
165 t.integer "artist_id", :default => 0, :null => false
\r
166 t.integer "license_id", :default => 0, :null => false
\r
167 t.datetime "created_at"
\r
168 t.datetime "updated_at"
\r
171 add_index "original_pictures", ["artist_id"], :name => "index_original_pictures_on_artist_id"
\r
173 create_table "panel_pictures", :force => true do |t|
\r
174 t.integer "panel_id", :null => false
\r
175 t.integer "resource_picture_id", :null => false
\r
176 t.string "link", :limit => 200
\r
177 t.integer "x", :null => false
\r
178 t.integer "y", :null => false
\r
179 t.integer "z", :null => false
\r
180 t.integer "t", :default => 1, :null => false
\r
181 t.integer "width", :null => false
\r
182 t.integer "height", :null => false
\r
183 t.datetime "created_at"
\r
184 t.datetime "updated_at"
\r
187 add_index "panel_pictures", ["panel_id", "t"], :name => "panel_pictures_idt", :unique => true
\r
189 create_table "panels", :force => true do |t|
\r
190 t.integer "comic_id", :null => false
\r
191 t.integer "resource_picture_id"
\r
192 t.integer "width", :default => 200, :null => false
\r
193 t.integer "height", :default => 80, :null => false
\r
194 t.integer "border", :default => 1, :null => false
\r
195 t.integer "x", :null => false
\r
196 t.integer "y", :null => false
\r
197 t.integer "z", :null => false
\r
198 t.integer "t", :default => 1, :null => false
\r
199 t.integer "author_id"
\r
200 t.datetime "created_at"
\r
201 t.datetime "updated_at"
\r
204 add_index "panels", ["author_id"], :name => "index_panels_on_author_id"
\r
205 add_index "panels", ["comic_id", "t"], :name => "panels_idt", :unique => true
\r
207 create_table "resource_pictures", :force => true do |t|
\r
208 t.string "ext", :null => false
\r
209 t.integer "width", :null => false
\r
210 t.integer "height", :null => false
\r
211 t.integer "filesize", :null => false
\r
212 t.integer "artist_id", :default => 0, :null => false
\r
213 t.integer "license_id", :default => 0, :null => false
\r
214 t.integer "original_picture_id", :null => false
\r
215 t.datetime "created_at"
\r
216 t.datetime "updated_at"
\r
219 create_table "speach_balloons", :force => true do |t|
\r
220 t.string "name", :null => false
\r
221 t.integer "tail_count", :default => 1, :null => false
\r
222 t.integer "size_count", :default => 1, :null => false
\r
223 t.integer "t", :default => 1, :null => false
\r
224 t.datetime "created_at"
\r
225 t.datetime "updated_at"
\r
228 add_index "speach_balloons", ["t"], :name => "speach_balloons_t", :unique => true
\r
230 create_table "speach_templates", :force => true do |t|
\r
231 t.integer "balloon_template_id", :null => false
\r
232 t.integer "x", :null => false
\r
233 t.integer "y", :null => false
\r
234 t.integer "t", :default => 1, :null => false
\r
235 t.integer "width", :null => false
\r
236 t.integer "height", :null => false
\r
237 t.datetime "created_at"
\r
238 t.datetime "updated_at"
\r
241 add_index "speach_templates", ["balloon_template_id", "t"], :name => "speach_templates_idt", :unique => true
\r
243 create_table "speaches", :force => true do |t|
\r
244 t.integer "balloon_id", :null => false
\r
246 t.integer "x", :null => false
\r
247 t.integer "y", :null => false
\r
248 t.integer "t", :default => 1, :null => false
\r
249 t.integer "width", :null => false
\r
250 t.integer "height", :null => false
\r
251 t.datetime "created_at"
\r
252 t.datetime "updated_at"
\r
255 add_index "speaches", ["balloon_id", "t"], :name => "speaches_bt", :unique => true
\r
256 add_index "speaches", ["balloon_id"], :name => "index_speaches_on_balloon_id"
\r
258 create_table "system_pictures", :force => true do |t|
\r
259 t.string "ext", :null => false
\r
260 t.integer "width", :null => false
\r
261 t.integer "height", :null => false
\r
262 t.integer "filesize", :null => false
\r
263 t.datetime "created_at"
\r
264 t.datetime "updated_at"
\r
267 create_table "users", :force => true do |t|
\r
268 t.string "email", :default => "", :null => false
\r
269 t.string "encrypted_password", :limit => 128, :default => "", :null => false
\r
270 t.string "reset_password_token"
\r
271 t.datetime "reset_password_sent_at"
\r
272 t.datetime "remember_created_at"
\r
273 t.integer "sign_in_count", :default => 0
\r
274 t.datetime "current_sign_in_at"
\r
275 t.datetime "last_sign_in_at"
\r
276 t.string "current_sign_in_ip"
\r
277 t.string "last_sign_in_ip"
\r
278 t.string "authentication_token"
\r
279 t.string "confirmation_token"
\r
280 t.datetime "confirmed_at"
\r
281 t.datetime "confirmation_sent_at"
\r
282 t.datetime "created_at"
\r
283 t.datetime "updated_at"
\r
286 add_index "users", ["authentication_token"], :name => "index_users_on_authentication_token", :unique => true
\r
287 add_index "users", ["confirmation_token"], :name => "index_users_on_confirmation_token", :unique => true
\r
288 add_index "users", ["email"], :name => "index_users_on_email", :unique => true
\r
289 add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true
\r