fish = Category.create!(
  :string_id => 'FISH',
  :name => 'Fish',
  :description => '<image src="../images/fish_icon.gif"><font size="5" color="blue"> Fish</font>',
  :banner => '<image src="../images/banner_fish.gif">'
)
dogs = Category.create!(
  :string_id => 'DOGS',
  :name => 'Dogs',
  :description => '<image src="../images/dogs_icon.gif"><font size="5" color="blue"> Dogs</font>',
  :banner => '<image src="../images/banner_dogs.gif">'
)
reptiles = Category.create!(
  :string_id => 'REPTILES',
  :name => 'Reptiles',
  :description => '<image src="../images/reptiles_icon.gif"><font size="5" color="blue"> Reptiles</font>',
  :banner => '<image src="../images/banner_reptiles.gif">'
)
cats = Category.create!(
  :string_id => 'CATS',
  :name => 'Cats',
  :description => '<image src="../images/cats_icon.gif"><font size="5" color="blue"> Cats</font>',
  :banner => '<image src="../images/banner_cats.gif">'
)
birds = Category.create!(
  :string_id => 'BIRDS',
  :name => 'Birds',
  :description => '<image src="../images/birds_icon.gif"><font size="5" color="blue"> Birds</font>',
  :banner => '<image src="../images/banner_birds.gif">'
)
Account.create!(
  :username            => 'j2ee',
  :password            => 'j2ee',
  :password_confirmation => 'j2ee',
  :email               => 'yourname@yourdomain.com',
  :first_name          => 'ABC',
  :last_name           => 'XYX',
  :status              => 'OK',
  :address_line_1      => '901 San Antonio Road',
  :address_line_2      => 'MS UCUP02-206',
  :city                => 'Palo Alto',
  :state               => 'CA',
  :zip                 => '94303',
  :country             => 'USA',
  :phone               => '555-555-5555',
  :language_preference => "english",
  :favorite_category   => dogs,
  :my_list_option      => true,
  :banner_option       => true
)
Account.create!(
  :username            => 'ACID',
  :password            => 'ACID',
  :password_confirmation => 'ACID',
  :email               => 'acid@yourdomain.com',
  :first_name          => 'ABC',
  :last_name           => 'XYX',
  :status              => 'OK',
  :address_line_1      => '901 San Antonio Road',
  :address_line_2      => 'MS UCUP02-206',
  :city                => 'Palo Alto',
  :state               => 'CA',
  :zip                 => '94303',
  :country             => 'USA',
  :phone               => '555-555-5555',
  :language_preference => "english",
  :favorite_category   => cats,
  :my_list_option      => true,
  :banner_option       => true
)
Product.create!(
  :string_id => 'FI-SW-01',
  :category => fish,
  :name => 'Angelfish',
  :description => '<image src="../images/fish1.jpg">Salt Water fish from Australia')
Product.create!(
  :string_id => 'FI-SW-02',
  :category => fish,
  :name => 'Tiger Shark',
  :description => '<image src="../images/fish4.gif">Salt Water fish from Australia')
Product.create!(
  :string_id => 'FI-FW-01',
  :category => fish,
  :name =>  'Koi',
  :description => '<image src="../images/fish3.gif">Fresh Water fish from Japan')
Product.create!(
  :string_id => 'FI-FW-02',
  :category => fish,
  :name =>  'Goldfish',
  :description => '<image src="../images/fish2.gif">Fresh Water fish from China')
Product.create!(
  :string_id => 'K9-BD-01',
  :category => dogs,
  :name => 'Bulldog',
  :description => '<image src="../images/dog2.gif">Friendly dog from England')
Product.create!(
  :string_id => 'K9-PO-02',
  :category => dogs,
  :name => 'Poodle',
  :description => '<image src="../images/dog6.gif">Cute dog from France')
Product.create!(
  :string_id => 'K9-DL-01',
  :category => dogs,
  :name =>  'Dalmation',
  :description => '<image src="../images/dog5.gif">Great dog for a Fire Station')
Product.create!(
  :string_id => 'K9-RT-01',
  :category => dogs,
  :name =>  'Golden Retriever',
  :description => '<image src="../images/dog1.gif">Great family dog')
Product.create!(
  :string_id => 'K9-RT-02',
  :category => dogs,
  :name =>  'Labrador Retriever',
  :description => '<image src="../images/dog5.gif">Great hunting dog')
Product.create!(
  :string_id => 'K9-CW-01',
  :category => dogs,
  :name =>  'Chihuahua',
  :description => '<image src="../images/dog4.gif">Great companion dog')
Product.create!(
  :string_id => 'RP-SN-01',
  :category => reptiles,
  :name => 'Rattlesnake',
  :description => '<image src="../images/lizard3.gif">Doubles as a watch dog')
Product.create!(
  :string_id => 'RP-LI-02',
  :category => reptiles,
  :name => 'Iguana',
  :description => '<image src="../images/lizard2.gif">Friendly green friend')
Product.create!(
  :string_id => 'FL-DSH-01',
  :category => cats,
  :name => 'Manx',
  :description => '<image src="../images/cat3.gif">Great for reducing mouse populations')
Product.create!(
  :string_id => 'FL-DLH-02',
  :category => cats,
  :name => 'Persian',
  :description => '<image src="../images/cat1.gif">Friendly house cat, doubles as a princess')
Product.create!(
  :string_id => 'AV-CB-01',
  :category => birds,
  :name => 'Amazon Parrot',
  :description => '<image src="../images/bird4.gif">Great companion for up to 75 years')
Product.create!(
  :string_id => 'AV-SB-02',
  :category => birds,
  :name => 'Finch',
  :description => '<image src="../images/bird1.gif">Great stress reliever')
Supplier.create!(
  :name => 'XYZ Pets',
  :status => 'AC',
  :address_line_1 => '600 Avon Way',
  :address_line_2 => '',
  :city => 'Los Angeles',
  :state => 'CA',
  :zip => '94024',
  :phone => '212-947-0797')
Supplier.create!(
  :name => 'ABC Pets',
  :status => 'AC',
  :address_line_1 => '700 Abalone Way',
  :address_line_2 => '',
  :city => 'San Francisco',
  :state => 'CA',
  :zip => '94024',
  :phone => '415-947-0797')

Item.create!(
  :string_id => 'EST-1',
  :product => Product.find_by_string_id('FI-SW-01'),
  :list_price => 16.50,
  :unit_cost => 10.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Large')
Item.create!(
  :string_id => 'EST-2',
  :product => Product.find_by_string_id('FI-SW-01'),
  :list_price => 16.50,
  :unit_cost => 10.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Small')
Item.create!(
  :string_id => 'EST-3',
  :product => Product.find_by_string_id('FI-SW-02'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Toothless')
Item.create!(
  :string_id => 'EST-4',
  :product => Product.find_by_string_id('FI-FW-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Spotted')
Item.create!(
  :string_id => 'EST-5',
  :product => Product.find_by_string_id('FI-FW-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Spotless')
Item.create!(
  :string_id => 'EST-6',
  :product => Product.find_by_string_id('K9-BD-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Male Adult')
Item.create!(
  :string_id => 'EST-7',
  :product => Product.find_by_string_id('K9-BD-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Female Puppy')
Item.create!(
  :string_id => 'EST-8',
  :product => Product.find_by_string_id('K9-PO-02'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Male Puppy')
Item.create!(
  :string_id => 'EST-9',
  :product => Product.find_by_string_id('K9-DL-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Spotless Male Puppy')
Item.create!(
  :string_id => 'EST-10',
  :product => Product.find_by_string_id('K9-DL-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Spotted Adult Female')
Item.create!(
  :string_id => 'EST-11',
  :product => Product.find_by_string_id('RP-SN-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Venomless')
Item.create!(
  :string_id => 'EST-12',
  :product => Product.find_by_string_id('RP-SN-01'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Rattleless')
Item.create!(
  :string_id => 'EST-13',
  :product => Product.find_by_string_id('RP-LI-02'),
  :list_price => 18.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Green Adult')
Item.create!(
  :string_id => 'EST-14',
  :product => Product.find_by_string_id('FL-DSH-01'),
  :list_price => 58.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Tailless')
Item.create!(
  :string_id => 'EST-15',
  :product => Product.find_by_string_id('FL-DSH-01'),
  :list_price => 23.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'With tail')
Item.create!(
  :string_id => 'EST-16',
  :product => Product.find_by_string_id('FL-DLH-02'),
  :list_price => 93.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')
Item.create!(
  :string_id => 'EST-17',
  :product => Product.find_by_string_id('FL-DLH-02'),
  :list_price => 93.50,
  :unit_cost => 12.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-18',
  :product => Product.find_by_string_id('AV-CB-01'),
  :list_price => 193.50,
  :unit_cost => 92.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-19',
  :product => Product.find_by_string_id('AV-SB-02'),
  :list_price => 15.50,
  :unit_cost =>  2.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-20',
  :product => Product.find_by_string_id('FI-FW-02'),
  :list_price => 5.50,
  :unit_cost =>  2.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-21',
  :product => Product.find_by_string_id('FI-FW-02'),
  :list_price => 5.29,
  :unit_cost =>  1.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')
Item.create!(
  :string_id => 'EST-22',
  :product => Product.find_by_string_id('K9-RT-02'),
  :list_price => 135.50,
  :unit_cost =>  100.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-23',
  :product => Product.find_by_string_id('K9-RT-02'),
  :list_price => 145.49,
  :unit_cost =>  100.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')
Item.create!(
  :string_id => 'EST-24',
  :product => Product.find_by_string_id('K9-RT-02'),
  :list_price => 255.50,
  :unit_cost =>  92.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-25',
  :product => Product.find_by_string_id('K9-RT-02'),
  :list_price => 325.29,
  :unit_cost =>  90.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')
Item.create!(
  :string_id => 'EST-26',
  :product => Product.find_by_string_id('K9-CW-01'),
  :list_price => 125.50,
  :unit_cost =>  92.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Male')
Item.create!(
  :string_id => 'EST-27',
  :product => Product.find_by_string_id('K9-CW-01'),
  :list_price => 155.29,
  :unit_cost =>  90.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')
Item.create!(
  :string_id => 'EST-28',
  :product => Product.find_by_string_id('K9-RT-01'),
  :list_price => 155.29,
  :unit_cost =>  90.00,
  :supplier => 1,
  :status => 'P',
  :attribute1 => 'Adult Female')

Item.find_by_string_id('EST-1').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-2').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-3').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-4').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-5').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-6').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-7').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-8').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-9').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-10').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-11').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-12').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-13').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-14').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-15').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-16').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-17').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-18').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-19').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-20').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-21').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-22').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-23').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-24').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-25').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-26').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-27').update_attributes!(:quantity => 10000)
Item.find_by_string_id('EST-28').update_attributes!(:quantity => 10000)