#\r
# It's strongly recommended to check this file into your version control system.\r
\r
-ActiveRecord::Schema.define(:version => 20120424100555) 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
\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
- t.integer "system_picture_id", :null => false\r
- t.integer "tail", :default => 1, :null => false\r
- t.integer "size", :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.datetime "created_at"\r
- t.datetime "updated_at"\r
- end\r
-\r
- add_index "balloon_templates", ["speach_balloon_id", "tail", "size"], :name => "balloon_templates_idts", :unique => true\r
- add_index "balloon_templates", ["speach_balloon_id"], :name => "index_balloon_templates_on_speach_balloon_id"\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 "size", :default => 1, :null => false\r
- t.integer "x", :null => false\r
- t.integer "y", :null => false\r
- t.integer "z", :null => false\r
- t.integer "t", :default => 1, :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", "t"], :name => "balloon_idt", :unique => true\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", :limit => 100, :null => false\r
t.datetime "updated_at"\r
end\r
\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
+ 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 "licenses", :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 "no_convert", :default => 0, :null => false\r
- t.integer "keep_aspect_ratio", :default => 0, :null => false\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", ["url"], :name => "index_licenses_on_url", :unique => true\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 "artist_id", :null => false\r
t.integer "license_id", :null => false\r
t.string "name", :null => false\r
t.string "url", :null => false\r
add_index "original_pictures", ["artist_id"], :name => "index_original_pictures_on_artist_id"\r
\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.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", :default => 1, :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 "z", :null => false\r
+ t.integer "t", :null => false\r
+ t.integer "width", :null => false\r
+ t.integer "height", :null => false\r
t.datetime "created_at"\r
t.datetime "updated_at"\r
end\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 "x", :null => false\r
- t.integer "y", :null => false\r
- t.integer "z", :null => false\r
- t.integer "t", :default => 1, :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", "t"], :name => "panels_idt", :unique => true\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.datetime "updated_at"\r
end\r
\r
- create_table "speach_balloon_templates", :force => true do |t|\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_count", :default => 1, :null => false\r
- t.integer "size_count", :default => 1, :null => false\r
- t.integer "t", :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
- add_index "speach_balloons", ["t"], :name => "speach_balloons_t", :unique => true\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 "speach_templates", :force => true do |t|\r
- t.integer "balloon_template_id", :null => false\r
- t.integer "x", :null => false\r
- t.integer "y", :null => false\r
- t.integer "t", :default => 1, :null => false\r
- t.integer "width", :null => false\r
- t.integer "height", :null => false\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", "t"], :name => "speach_templates_idt", :unique => true\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
- t.integer "speach_template_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 "x", :null => false\r
- t.integer "y", :null => false\r
- t.integer "t", :default => 1, :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", "t"], :name => "speaches_bt", :unique => true\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
OSDN Git Service
