X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=db%2Fschema.rb;h=2c94bfb28e5a080023a56ac836b84e6fc62525aa;hb=2983ab721a7fbeb9568a1b291ce30afc93a10f03;hp=2d863a7588d5d4ec49eddb958ab9cb05f98138f4;hpb=aec34f8b39f39ec0794d39c878659487909f0136;p=pettanr%2Fpettanr.git

diff --git a/db/schema.rb b/db/schema.rb
index 2d863a75..2c94bfb2 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -59,40 +59,20 @@ ActiveRecord::Schema.define(:version => 20120424100555) do
 
   add_index "authors", ["user_id"], :name => "index_authors_on_user_id", :unique => true
 
-  create_table "balloon_templates", :force => true do |t|
-    t.integer  "speech_balloon_id",                :null => false
-    t.integer  "system_picture_id",                :null => false
-    t.integer  "tail",              :default => 1, :null => false
-    t.integer  "size",              :default => 1, :null => false
-    t.integer  "min_width",         :default => 0, :null => false
-    t.integer  "max_width",         :default => 0, :null => false
-    t.integer  "min_height",        :default => 0, :null => false
-    t.integer  "max_height",        :default => 0, :null => false
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "balloon_templates", ["speech_balloon_id", "tail", "size"], :name => "balloon_templates_idts", :unique => true
-  add_index "balloon_templates", ["speech_balloon_id"], :name => "index_balloon_templates_on_speech_balloon_id"
-
   create_table "balloons", :force => true do |t|
-    t.integer  "panel_id",                           :null => false
-    t.integer  "balloon_template_id",                :null => false
-    t.integer  "system_picture_id",                  :null => false
-    t.integer  "tail",                :default => 1, :null => false
-    t.integer  "size",                :default => 1, :null => false
-    t.integer  "x",                                  :null => false
-    t.integer  "y",                                  :null => false
-    t.integer  "z",                                  :null => false
-    t.integer  "t",                   :default => 1, :null => false
-    t.integer  "width",                              :null => false
-    t.integer  "height",                             :null => false
+    t.integer  "speech_balloon_id", :null => false
+    t.integer  "system_picture_id", :null => false
+    t.integer  "x",                 :null => false
+    t.integer  "y",                 :null => false
+    t.integer  "width",             :null => false
+    t.integer  "height",            :null => false
+    t.string   "caption"
+    t.string   "settings"
     t.datetime "created_at"
     t.datetime "updated_at"
   end
 
-  add_index "balloons", ["panel_id", "t"], :name => "balloon_idt", :unique => true
-  add_index "balloons", ["panel_id"], :name => "index_balloons_on_panel_id"
+  add_index "balloons", ["speech_balloon_id"], :name => "index_balloons_on_speech_balloon_id"
 
   create_table "comics", :force => true do |t|
     t.string   "title",      :limit => 100,                :null => false
@@ -186,7 +166,7 @@ ActiveRecord::Schema.define(:version => 20120424100555) do
   add_index "panel_pictures", ["panel_id", "t"], :name => "panel_pictures_idt", :unique => true
 
   create_table "panels", :force => true do |t|
-    t.integer  "comic_id",                             :null => false
+    t.integer  "comic_id"
     t.integer  "resource_picture_id"
     t.integer  "width",               :default => 200, :null => false
     t.integer  "height",              :default => 80,  :null => false
@@ -201,7 +181,6 @@ ActiveRecord::Schema.define(:version => 20120424100555) do
   end
 
   add_index "panels", ["author_id"], :name => "index_panels_on_author_id"
-  add_index "panels", ["comic_id", "t"], :name => "panels_idt", :unique => true
 
   create_table "resource_pictures", :force => true do |t|
     t.string   "ext",                                :null => false
@@ -229,44 +208,31 @@ ActiveRecord::Schema.define(:version => 20120424100555) do
   add_index "speech_balloon_templates", ["t"], :name => "speech_balloon_templates_t", :unique => true
 
   create_table "speech_balloons", :force => true do |t|
-    t.string   "name",                      :null => false
-    t.integer  "tail_count", :default => 1, :null => false
-    t.integer  "size_count", :default => 1, :null => false
-    t.integer  "t",          :default => 1, :null => false
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "speech_balloons", ["t"], :name => "speech_balloons_t", :unique => true
-
-  create_table "speech_templates", :force => true do |t|
-    t.integer  "balloon_template_id",                :null => false
-    t.integer  "x",                                  :null => false
-    t.integer  "y",                                  :null => false
-    t.integer  "t",                   :default => 1, :null => false
-    t.integer  "width",                              :null => false
-    t.integer  "height",                             :null => false
+    t.integer  "panel_id",                                 :null => false
+    t.integer  "speech_balloon_template_id",               :null => false
+    t.string   "classname",                  :limit => 50, :null => false
+    t.integer  "z",                                        :null => false
+    t.integer  "t",                                        :null => false
+    t.string   "settings"
     t.datetime "created_at"
     t.datetime "updated_at"
   end
 
-  add_index "speech_templates", ["balloon_template_id", "t"], :name => "speech_templates_idt", :unique => true
+  add_index "speech_balloons", ["panel_id"], :name => "index_speech_balloons_on_panel_id"
 
   create_table "speeches", :force => true do |t|
-    t.integer  "balloon_id",                        :null => false
-    t.integer  "speech_template_id",                :null => false
+    t.integer  "speech_balloon_id", :null => false
     t.string   "content"
-    t.integer  "x",                                 :null => false
-    t.integer  "y",                                 :null => false
-    t.integer  "t",                  :default => 1, :null => false
-    t.integer  "width",                             :null => false
-    t.integer  "height",                            :null => false
+    t.integer  "x",                 :null => false
+    t.integer  "y",                 :null => false
+    t.integer  "width",             :null => false
+    t.integer  "height",            :null => false
+    t.string   "settings"
     t.datetime "created_at"
     t.datetime "updated_at"
   end
 
-  add_index "speeches", ["balloon_id", "t"], :name => "speeches_bt", :unique => true
-  add_index "speeches", ["balloon_id"], :name => "index_speeches_on_balloon_id"
+  add_index "speeches", ["speech_balloon_id"], :name => "index_speeches_on_speech_balloon_id"
 
   create_table "system_pictures", :force => true do |t|
     t.string   "ext",                      :null => false