modify license columns

diff --git a/db/migrate/20120617061753_change_license.rb b/db/migrate/20120617061753_change_license.rb
new file mode 100644 (file)
index 0000000..47d2af7
--- /dev/null
+++ b/db/migrate/20120617061753_change_license.rb
@@ -0,0 +1,35 @@
+class ChangeLicense < ActiveRecord::Migration
+  def up
+    remove_index :licenses, :column => [:url]
+    drop_table :licenses
+    create_table :licenses do |t|
+      t.integer :license_group_id, :null => false, :default => 0
+      t.string :name, :null => false, :limit => 50, :default => 'Default'
+      t.string :classname, :null => false, :limit => 50, :default => 'Default'
+      t.string :caption, :null => false, :limit => 30, :default => 'no name'
+      t.string :url, :null => false\r
+      t.timestamps
+    end
+    add_index :licenses, [:name], :unique => true
+  end
+
+  def down
+    remove_index :licenses, :column => [:name]
+    drop_table :licenses
+    create_table :licenses do |t|
+      t.string :name, :null => false\r
+      t.string :url, :null => false\r
+      t.integer :cc_by, :null => false, :default => 0\r
+      t.integer :cc_sa, :null => false, :default => 0\r
+      t.integer :cc_nd, :null => false, :default => 0\r
+      t.integer :cc_nc, :null => false, :default => 0\r
+      t.integer :no_resize, :null => false, :default => 0\r
+      t.integer :no_flip, :null => false, :default => 0\r
+      t.integer :no_convert, :null => false, :default => 0\r
+      t.integer :keep_aspect_ratio, :null => false, :default => 0\r
+
+      t.timestamps
+    end
+    add_index :licenses, [:url], :unique => true
+  end
+end

diff --git a/db/schema.rb b/db/schema.rb
index d488500..a9668bc 100644 (file)
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #\r
 # It's strongly recommended to check this file into your version control system.\r
 \r
-ActiveRecord::Schema.define(:version => 20120617055928) do\r
+ActiveRecord::Schema.define(:version => 20120617061753) do\r
 \r
   create_table "admins", :force => true do |t|\r
     t.string   "email",                                 :default => "", :null => false\r
@@ -113,21 +113,16 @@ ActiveRecord::Schema.define(:version => 20120617055928) do
   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  "license_id",                       :null => false\r