#\r
# It's strongly recommended to check this file into your version control system.\r
\r
-ActiveRecord::Schema.define(:version => 20120102071851) do\r
+ActiveRecord::Schema.define(:version => 20120306231650) do\r
\r
create_table "admins", :force => true do |t|\r
t.string "email", :default => "", :null => false\r
t.string "name"\r
t.string "homepage_url"\r
t.string "api_url"\r
- t.integer "default_license_id"\r
+ t.integer "default_license_id", :default => 0, :null => false\r
t.datetime "crowled_at"\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
\r
create_table "authors", :force => true do |t|\r
t.string "name"\r
- t.string "email", :default => "", :null => false\r
- t.string "encrypted_password", :limit => 128, :default => "", :null => false\r
- t.string "reset_password_token"\r
- t.datetime "reset_password_sent_at"\r
- t.datetime "remember_created_at"\r
- t.integer "sign_in_count", :default => 0\r
- t.datetime "current_sign_in_at"\r
- t.datetime "last_sign_in_at"\r
- t.string "current_sign_in_ip"\r
- t.string "last_sign_in_ip"\r
- t.string "authentication_token"\r
- t.string "confirmation_token"\r
- t.datetime "confirmed_at"\r
- t.datetime "confirmation_sent_at"\r
+ t.integer "user_id", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "authors", ["authentication_token"], :name => "index_authors_on_authentication_token", :unique => true\r
- add_index "authors", ["confirmation_token"], :name => "index_authors_on_confirmation_token", :unique => true\r
- add_index "authors", ["email"], :name => "index_authors_on_email", :unique => true\r
- add_index "authors", ["reset_password_token"], :name => "index_authors_on_reset_password_token", :unique => true\r
+ add_index "authors", ["user_id"], :name => "index_authors_on_user_id", :unique => true\r
\r
create_table "balloon_templates", :force => true do |t|\r
t.integer "speach_balloon_id", :null => false\r
end\r
\r
create_table "original_pictures", :force => true do |t|\r
- t.string "ext", :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\r
- t.integer "filesize", :null => false\r
- t.integer "artist_id"\r
- t.integer "license_id"\r
+ t.string "ext", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.integer "filesize", :null => false\r
+ t.integer "artist_id", :default => 0, :null => false\r
+ t.integer "license_id", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
t.integer "t", :default => 1, :null => false\r
t.integer "width", :null => false\r
t.integer "height", :null => false\r
- t.integer "flipv", :default => 0, :null => false\r
- t.integer "fliph", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
add_index "panels", ["comic_id", "t"], :name => "panels_idt", :unique => true\r
\r
create_table "resource_pictures", :force => true do |t|\r
- t.string "ext", :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\r
- t.integer "filesize", :null => false\r
- t.integer "artist_id"\r
- t.integer "license_id"\r
- t.integer "original_picture_id", :null => false\r
+ t.string "ext", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.integer "filesize", :null => false\r
+ t.integer "artist_id", :default => 0, :null => false\r
+ t.integer "license_id", :default => 0, :null => false\r
+ t.integer "original_picture_id", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
t.datetime "updated_at"\r
end\r
\r
+ create_table "users", :force => true do |t|\r
+ t.string "email", :default => "", :null => false\r
+ t.string "encrypted_password", :limit => 128, :default => "", :null => false\r
+ t.string "reset_password_token"\r
+ t.datetime "reset_password_sent_at"\r
+ t.datetime "remember_created_at"\r
+ t.integer "sign_in_count", :default => 0\r
+ t.datetime "current_sign_in_at"\r
+ t.datetime "last_sign_in_at"\r
+ t.string "current_sign_in_ip"\r
+ t.string "last_sign_in_ip"\r
+ t.string "authentication_token"\r
+ t.string "confirmation_token"\r
+ t.datetime "confirmed_at"\r
+ t.datetime "confirmation_sent_at"\r
+ t.datetime "created_at"\r
+ t.datetime "updated_at"\r
+ end\r
+\r
+ add_index "users", ["authentication_token"], :name => "index_users_on_authentication_token", :unique => true\r
+ add_index "users", ["confirmation_token"], :name => "index_users_on_confirmation_token", :unique => true\r
+ add_index "users", ["email"], :name => "index_users_on_email", :unique => true\r
+ add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true\r
+\r
end\r