From 4ab6702d5ac0ec4541e8a724ab5e4409630b5546 Mon Sep 17 00:00:00 2001 From: "Ira W. Snyder" Date: Wed, 21 Nov 2007 23:46:49 -0800 Subject: [PATCH] Change video's director column to a string It was an int, which was stupid of me Signed-off-by: Ira W. Snyder --- db/development.sqlite3 | Bin 9216 -> 9216 bytes .../012_rentables_director_int_to_str.rb | 9 +++++++++ db/schema.rb | 4 ++-- 3 files changed, 11 insertions(+), 2 deletions(-) create mode 100644 db/migrate/012_rentables_director_int_to_str.rb diff --git a/db/development.sqlite3 b/db/development.sqlite3 index f020ede71df316999a64794be0ea1621a822dde0..50680b2ab8df79b3503de38839d1ab7deddfe304 100644 GIT binary patch delta 363 zcmZqhXz-XIEx4Zn0@#5RBM|Fv)Va*e$hwK;KQklGCJsgpQD!~{cBXv{%ukt~GB0E9 zV%o>-z%0G7aRpPoDk~R*xFSEJJWyj;W=d*)P-=>TOHpEaeqI_=XkK<+etDjP5raAt zP?;t_qcluem_k~9kwRE%UP@|7Nn#o!R4D`VAqHNMdHf)S%Ipxs;kq1iGE?&u{4(=W z(^$Ydc*^q_JlKG$;`tfXCz}Zy^9H1rq!uZ7B_?MV=jToC6t+|X`bZgMH`qv!6VdH9 znEXUoiQ^~(<54DIrhgk7w=-^z6}4pCT(88$C;t;cg7tEVv b*jU)=8JOys8#gu6;TNU0tGR-iW` diff --git a/db/migrate/012_rentables_director_int_to_str.rb b/db/migrate/012_rentables_director_int_to_str.rb new file mode 100644 index 0000000..9498c14 --- /dev/null +++ b/db/migrate/012_rentables_director_int_to_str.rb @@ -0,0 +1,9 @@ +class RentablesDirectorIntToStr < ActiveRecord::Migration + def self.up + change_column :rentables, :director, :string + end + + def self.down + change_column :rentables, :director, :integer + end +end diff --git a/db/schema.rb b/db/schema.rb index f099861..f0435a6 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -2,7 +2,7 @@ # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. -ActiveRecord::Schema.define(:version => 11) do +ActiveRecord::Schema.define(:version => 12) do create_table "coitems", :force => true do |t| t.column "customer_id", :integer @@ -24,7 +24,7 @@ ActiveRecord::Schema.define(:version => 11) do t.column "title", :string t.column "newrelease", :boolean, :default => false t.column "video_genre", :integer - t.column "director", :integer + t.column "director", :string t.column "media", :integer t.column "game_genre", :integer t.column "platform", :integer -- 2.34.1