#\r
# It's strongly recommended to check this file into your version control system.\r
\r
-ActiveRecord::Schema.define(:version => 20120102071851) do\r
-\r
+ActiveRecord::Schema.define(:version => 20120617061753) do\r
create_table "admins", :force => true do |t|\r
t.string "email", :default => "", :null => false\r
t.string "encrypted_password", :limit => 128, :default => "", :null => false\r
t.datetime "last_sign_in_at"\r
t.string "current_sign_in_ip"\r
t.string "last_sign_in_ip"\r
- t.integer "activate", :default => 0, :null => false\r
+ t.string "confirmation_token"\r
+ t.datetime "confirmed_at"\r
+ t.datetime "confirmation_sent_at"\r
+ t.string "authentication_token"\r
+ t.integer "approve", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
+ add_index "admins", ["authentication_token"], :name => "index_admins_on_authentication_token", :unique => true\r
+ add_index "admins", ["confirmation_token"], :name => "index_admins_on_confirmation_token", :unique => true\r
add_index "admins", ["email"], :name => "index_admins_on_email", :unique => true\r
add_index "admins", ["reset_password_token"], :name => "index_admins_on_reset_password_token", :unique => true\r
\r
t.string "name"\r
t.string "homepage_url"\r
t.string "api_url"\r
- t.integer "default_lisence_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.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
-\r
- create_table "balloon_templates", :force => true do |t|\r
- t.integer "speach_balloon_id", :null => false\r
- t.integer "system_picture_id", :null => false\r
- t.integer "tail", :default => 1, :null => false\r
- t.integer "border", :default => 1, :null => false\r
- t.integer "min_width", :default => 0, :null => false\r
- t.integer "max_width", :default => 0, :null => false\r
- t.integer "min_height", :default => 0, :null => false\r
- t.integer "max_height", :default => 0, :null => false\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 "balloon_templates", ["speach_balloon_id", "tail", "border"], :name => "sb_tb", :unique => true\r
- add_index "balloon_templates", ["speach_balloon_id"], :name => "index_balloon_templates_on_speach_balloon_id"\r
+ add_index "authors", ["user_id"], :name => "index_authors_on_user_id", :unique => true\r
\r
create_table "balloons", :force => true do |t|\r
- t.integer "panel_id", :null => false\r
- t.integer "balloon_template_id", :null => false\r
- t.integer "system_picture_id", :null => false\r
- t.integer "tail", :default => 1, :null => false\r
- t.integer "border", :default => 1, :null => false\r
- t.integer "zindex", :null => false\r
- t.integer "top_offset", :null => false\r
- t.integer "left_offset", :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\r
+ t.integer "speech_balloon_id", :null => false\r
+ t.integer "system_picture_id", :null => false\r
+ t.integer "x", :null => false\r
+ t.integer "y", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.string "caption"\r
+ t.string "settings"\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "balloons", ["panel_id", "zindex"], :name => "index_balloons_on_panel_id_and_zindex"\r
- add_index "balloons", ["panel_id"], :name => "index_balloons_on_panel_id"\r
+ add_index "balloons", ["speech_balloon_id"], :name => "index_balloons_on_speech_balloon_id"\r
\r
create_table "comics", :force => true do |t|\r
- t.string "title"\r
- t.integer "default_width", :default => 200, :null => false\r
- t.integer "default_height", :default => 80, :null => false\r
- t.integer "author_id"\r
+ t.string "title", :limit => 100, :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.integer "visible", :default => 0, :null => false\r
+ t.integer "editable", :default => 0, :null => false\r
+ t.integer "author_id", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
add_index "comics", ["author_id"], :name => "index_comics_on_author_id"\r
\r
- create_table "common_lisences", :force => true do |t|\r
- t.integer "lisence_id", :null => false\r
+ create_table "common_licenses", :force => true do |t|\r
+ t.integer "license_id", :null => false\r
t.string "name", :null => false\r
t.string "url", :null => false\r
t.integer "cc_by", :default => 0, :null => false\r
t.integer "cc_nc", :default => 0, :null => false\r
t.integer "no_resize", :default => 0, :null => false\r
t.integer "no_flip", :default => 0, :null => false\r
+ t.integer "no_convert", :default => 0, :null => false\r
t.integer "keep_aspect_ratio", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- create_table "lisences", :force => true do |t|\r
- t.string "name", :null => false\r
- t.string "url", :null => false\r
- t.integer "cc_by", :default => 0, :null => false\r
- t.integer "cc_sa", :default => 0, :null => false\r
- t.integer "cc_nd", :default => 0, :null => false\r
- t.integer "cc_nc", :default => 0, :null => false\r
- t.integer "no_resize", :default => 0, :null => false\r
- t.integer "no_flip", :default => 0, :null => false\r
- t.integer "keep_aspect_ratio", :default => 0, :null => false\r
+ create_table "license_groups", :force => true do |t|\r
+ t.string "name", :limit => 50, :null => false\r
+ t.string "classname", :limit => 50, :null => false\r
+ t.string "caption", :limit => 30, :null => false\r
+ t.string "url", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "lisences", ["url"], :name => "index_lisences_on_url", :unique => true\r
+ create_table "imports", :force => true do |t|\r
+ t.integer "a"\r
+ t.string "b", :null => false\r
+ t.datetime "created_at"\r
+ t.datetime "updated_at"\r
+ end\r
\r
- create_table "original_lisences", :force => true do |t|\r
- t.integer "artist_id", :null => false\r
- t.integer "lisence_id", :null => false\r
+ create_table "licenses", :force => true do |t|\r
+ t.integer "license_group_id", :default => 0, :null => false\r
+ t.string "name", :limit => 50, :default => "Default", :null => false\r
+ t.string "classname", :limit => 50, :default => "Default", :null => false\r
+ t.string "caption", :limit => 30, :default => "no name", :null => false\r
+ t.string "url", :null => false\r
+ t.datetime "created_at"\r
+ t.datetime "updated_at"\r
+ end\r
+\r
+ add_index "licenses", ["name"], :name => "index_licenses_on_name", :unique => true\r
+\r
+ create_table "original_licenses", :force => true do |t|\r
+ t.integer "license_id", :null => false\r
t.string "name", :null => false\r
t.string "url", :null => false\r
t.integer "cc_by", :default => 0, :null => false\r
t.integer "cc_nc", :default => 0, :null => false\r
t.integer "no_resize", :default => 0, :null => false\r
t.integer "no_flip", :default => 0, :null => false\r
+ t.integer "no_convert", :default => 0, :null => false\r
t.integer "keep_aspect_ratio", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\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 "lisence_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
create_table "panel_pictures", :force => true do |t|\r
t.integer "panel_id", :null => false\r
t.integer "resource_picture_id", :null => false\r
+ t.string "link", :limit => 200\r
+ t.integer "x", :null => false\r
+ t.integer "y", :null => false\r
+ t.integer "z", :null => false\r
+ t.integer "t", :null => false\r
t.integer "width", :null => false\r
t.integer "height", :null => false\r
- t.integer "top_offset", :null => false\r
- t.integer "left_offset", :null => false\r
- t.integer "zindex", :null => false\r
- t.integer "v", :default => 0, :null => false\r
- t.integer "h", :default => 0, :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "panel_pictures", ["panel_id", "zindex"], :name => "index_panel_pictures_on_panel_id_and_zindex"\r
+ add_index "panel_pictures", ["panel_id", "t"], :name => "panel_pictures_idt", :unique => true\r
\r
create_table "panels", :force => true do |t|\r
- t.integer "comic_id", :null => false\r
- t.integer "resource_picture_id"\r
- t.integer "width", :default => 200, :null => false\r
- t.integer "height", :default => 80, :null => false\r
- t.integer "border", :default => 1, :null => false\r
- t.integer "seqno", :null => false\r
- t.integer "author_id"\r
+ t.integer "comic_id"\r
+ t.integer "width", :default => 200, :null => false\r
+ t.integer "height", :default => 80, :null => false\r
+ t.integer "border", :default => 1, :null => false\r
+ t.integer "x"\r
+ t.integer "y"\r
+ t.integer "z"\r
+ t.integer "t", :null => false\r
+ t.integer "author_id", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
add_index "panels", ["author_id"], :name => "index_panels_on_author_id"\r
- add_index "panels", ["comic_id", "seqno"], :name => "index_panels_on_comic_id_and_seqno"\r
+\r
+ create_table "resource_picture_licenses", :force => true do |t|\r
+ t.integer "resource_picture_id", :null => false\r
+ t.integer "license_id", :null => false\r
+ t.string "artist_name", :null => false\r
+ t.string "credit"\r
+ t.string "settings"\r
+ t.datetime "created_at"\r
+ t.datetime "updated_at"\r
+ end\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 "lisence_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
\r
- create_table "speach_balloons", :force => true do |t|\r
- t.string "name", :null => false\r
- t.integer "tail_limit", :default => 1, :null => false\r
- t.integer "border_limit", :default => 1, :null => false\r
+ create_table "speech_balloon_templates", :force => true do |t|\r
+ t.string "name", :limit => 50, :null => false\r
+ t.string "classname", :limit => 50, :null => false\r
+ t.string "caption", :limit => 30, :null => false\r
+ t.integer "t", :default => 0, :null => false\r
+ t.string "settings", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- create_table "speach_templates", :force => true do |t|\r
- t.integer "balloon_template_id", :null => false\r
- t.integer "top_offset", :null => false\r
- t.integer "left_offset", :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\r
+ add_index "speech_balloon_templates", ["name"], :name => "speech_balloon_templates_name", :unique => true\r
+ add_index "speech_balloon_templates", ["t"], :name => "speech_balloon_templates_t", :unique => true\r
+\r
+ create_table "speech_balloons", :force => true do |t|\r
+ t.integer "panel_id", :null => false\r
+ t.integer "speech_balloon_template_id", :null => false\r
+ t.string "classname", :limit => 50, :null => false\r
+ t.integer "z", :null => false\r
+ t.integer "t", :null => false\r
+ t.string "settings"\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "speach_templates", ["balloon_template_id"], :name => "index_speach_templates_on_balloon_template_id"\r
+ add_index "speech_balloons", ["panel_id"], :name => "index_speech_balloons_on_panel_id"\r
\r
- create_table "speaches", :force => true do |t|\r
- t.integer "balloon_id", :null => false\r
+ create_table "speeches", :force => true do |t|\r
+ t.integer "speech_balloon_id", :null => false\r
t.string "content"\r
- t.integer "top_offset", :null => false\r
- t.integer "left_offset", :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\r
+ t.integer "x", :null => false\r
+ t.integer "y", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.string "settings"\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\r
\r
- add_index "speaches", ["balloon_id"], :name => "index_speaches_on_balloon_id"\r
+ add_index "speeches", ["speech_balloon_id"], :name => "index_speeches_on_speech_balloon_id"\r
\r
create_table "system_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.string "ext", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
+ t.integer "filesize", :null => false\r
+ t.string "md5", :limit => 32, :null => false\r
t.datetime "created_at"\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