DROP TABLE item;

CREATE TABLE item (
 id INT NOT NULL,
 productid VARCHAR(10) ,
 name VARCHAR(30) ,
 description VARCHAR(500) ,
 imageurl VARCHAR(155),
 imagethumburl VARCHAR(155),
 price DECIMAL(14,2) ,
 primary key (id)
);

INSERT INTO item VALUES(1, 'feline01', 'Friendly Cat', 'This black and white colored cat is super friendly. Anyone passing by your front yard will find him puring at their feet and trying to make a new friend. His name is Anthony, but I call him Ant as a nickname since he loves to eat ants and other insects.', 'http://localhost:8080/catalog/images/anthony.jpg','http://localhost:8080/catalog/images/anthony-s.jpg', 307.10);
INSERT INTO item VALUES(2, 'feline01', 'Fluffy Cat', 'A great pet for a hair stylist! Have fun combing Bailey''s silver mane. Maybe trim his whiskers? He is very patient and loves to be pampered.', 'http://localhost:8080/catalog/images/bailey.jpg','http://localhost:8080/catalog/images/bailey-s.jpg', 307);
INSERT INTO item VALUES(3, 'feline02', 'Sneaky Cat', 'My cat is so sneaky. He is so curious that he just has to poke his nose into everything going on in the house. Everytime I turn around, BAM, he is in the room peaking at what I am doing. Nothing escapes his keen eye. He should be a spy in the CIA!', 'http://localhost:8080/catalog/images/bob.jpg','http://localhost:8080/catalog/images/bob-s.jpg', 307.20);
INSERT INTO item VALUES(4, 'feline02', 'Lazy Cat', 'A great pet to lounge on the sofa with. If you want a friend to watch TV with, this is the cat for you. Plus, she wont even ask for the remote! Really, could you ask for a better friend to lounge with?', 'http://localhost:8080/catalog/images/chantelle.jpg','http://localhost:8080/catalog/images/chantelle-s.jpg', 307.30);
INSERT INTO item VALUES(5, 'feline01', 'Old Cat', 'A great old pet retired from duty in the circus. This fully-trained tiger is looking for a place to retire. Loves to roam free and loves to eat other animals.', 'http://localhost:8080/catalog/images/charlie.jpg','http://localhost:8080/catalog/images/charlie-s.jpg', 307);
INSERT INTO item VALUES(6, 'feline02', 'Young Female cat', 'A great young pet to chase around. Loves to play with a ball of string. Bring some instant energy into your home.', 'http://localhost:8080/catalog/images/elkie.jpg','http://localhost:8080/catalog/images/elkie-s.jpg', 307.40);
INSERT INTO item VALUES(7, 'feline01', 'Playful Female Cat', 'A needy pet. This cat refuses to grow up. Do you like playful spirits? I need lots of attention. Please do not leave me alone, not even for a minute.', 'http://localhost:8080/catalog/images/faith.jpg','http://localhost:8080/catalog/images/faith-s.jpg', 307);
INSERT INTO item VALUES(8, 'feline01', 'White Fluffy Cat', 'This fluffy white cat looks like a snowball. Plus, she likes playing outside in the snow and it looks really cool to see this snowball cat run around on the ski slopes. I hope you have white carpet as this cat sheds lots of hair.', 'http://localhost:8080/catalog/images/gaetano.jpg','http://localhost:8080/catalog/images/gaetano-s.jpg', 307.50);
INSERT INTO item VALUES(9, 'feline02', 'Tiger Stripe Cat', 'This little tiger thinks it has big teeth. A great wild pet for an adventurous person. May eat your other pets so be careful- just kidding. This little tiger is affectionate.', 'http://localhost:8080/catalog/images/harmony.jpg','http://localhost:8080/catalog/images/harmony-s.jpg', 307);
INSERT INTO item VALUES(10, 'feline02', 'Alley Cat', 'Meow Meow in the back alley cat fights! This cat keeps the racoons away, but still has class.', 'http://localhost:8080/catalog/images/katzen.jpg','http://localhost:8080/catalog/images/katzen-s.jpg', 307.60);
INSERT INTO item VALUES(11, 'feline02', 'Speedy Cat', 'Fastest and coolest cat in town. If you always wanted to own a cheetah, this cat is even faster and better looking. No dog could ever catch this bolt of lightening.', 'http://localhost:8080/catalog/images/mario.jpg','http://localhost:8080/catalog/images/mario-s.jpg', 307);
INSERT INTO item VALUES(12, 'feline01', 'Stylish Cat', 'A high maintenance cat for an owner with time. This cat needs pampering: comb it hair, brush its teeth, wash its fur, paint its claws. For all you debutantes, let the world know you have arrived in style with this snooty cat in your purse!', 'http://localhost:8080/catalog/images/mimi.jpg','http://localhost:8080/catalog/images/mimi-s.jpg', 307.70);
INSERT INTO item VALUES(13, 'feline01', 'Smelly Cat', 'A great pet with its own song to sing with your fiends. "Smelly cat, Smelly cat ..." Need an excuse for that funky odor in your house? Smelly cat is the answer.', 'http://localhost:8080/catalog/images/monique.jpg','http://localhost:8080/catalog/images/monique-s.jpg', 307.80);
INSERT INTO item VALUES(14, 'feline01', 'Saber Cat', 'A great watch pet. Want to keep your roommates from stealing the beer from your refrigerator? This big-toothed crazy cat is better than a watchdog. Just place him on top of the refrigerator and watch him pounce when so-called friends try to sneak a beer. This cat is great fun at parties.', 'http://localhost:8080/catalog/images/olie.jpg','http://localhost:8080/catalog/images/olie-s.jpg', 307.90);
INSERT INTO item VALUES(15, 'feline01', 'Sophisticated Cat', 'This cat is from Paris. It has a very distinguished history and is looking for a castle to play in. This sophisticated cat has class and taste. No chasing on string, no catnip habits. Only the habits of royalty in this cats blood.', 'http://localhost:8080/catalog/images/paris.jpg','http://localhost:8080/catalog/images/paris-s.jpg', 307);
INSERT INTO item VALUES(16, 'feline01', 'Princess cat', 'Just beauty and elegance. She will charm you from the moment she enters the room.', 'http://localhost:8080/catalog/images/princess.jpg','http://localhost:8080/catalog/images/princess-s.jpg', 307);
INSERT INTO item VALUES(17, 'feline02', 'Lazy cat', 'Wow! This cat is cool. It has a beautiful tan coat. I wish I could get a sun tan of that color.', 'http://localhost:8080/catalog/images/simba.jpg','http://localhost:8080/catalog/images/simba-s.jpg', 307);
INSERT INTO item VALUES(18, 'feline02', 'Scapper male cat', 'A scappy cat that likes to cause trouble. If you are looking for a challenge to your cat training skills, this scapper is the test!', 'http://localhost:8080/catalog/images/thaicat.jpg','http://localhost:8080/catalog/images/thaicat-s.jpg', 307);
INSERT INTO item VALUES(19, 'feline01', 'Lazy cat', 'Buy me please. I love to sleep.', 'http://localhost:8080/catalog/images/cat1.gif','http://localhost:8080/catalog/images/cat1.gif', 307);
INSERT INTO item VALUES(20, 'feline01', 'Old Cat', 'A great old pet retired from duty in the circus. This fully-trained tiger is looking for a place to retire. Loves to roam free and loves to eat other animals.', 'http://localhost:8080/catalog/images/cat2.gif','http://localhost:8080/catalog/images/cat2.gif', 200);
INSERT INTO item VALUES(21, 'feline01', 'Young Cat', 'A great young pet to chase around. Loves to play with a ball of string.', 'http://localhost:8080/catalog/images/cat3.gif','http://localhost:8080/catalog/images/cat3.gif', 350);
INSERT INTO item VALUES(22, 'feline01', 'Scrappy Cat', 'A real trouble-maker in the neighborhood. Looking for some T.L.C', 'http://localhost:8080/catalog/images/cat4.gif','http://localhost:8080/catalog/images/cat4.gif', 417);
INSERT INTO item VALUES(23, 'feline01', 'Alley Cat', 'Loves to play in the alley outside my apartment, but looking for a warmer and safer place to spend its nights.', 'http://localhost:8080/catalog/images/cat5.gif','http://localhost:8080/catalog/images/cat5.gif', 307);
INSERT INTO item VALUES(24, 'feline02', 'Playful Cat', 'Come play with me. I am looking for fun.', 'http://localhost:8080/catalog/images/cat7.gif','http://localhost:8080/catalog/images/cat7.gif', 190);
INSERT INTO item VALUES(25, 'feline02', 'Long Haired Cat', 'Buy this fancy cat.', 'http://localhost:8080/catalog/images/cat8.gif', 'http://localhost:8080/catalog/images/cat8.gif', 199);
INSERT INTO item VALUES(26, 'feline02', 'Fresh Cat', 'Just need a nice bath and i will be fresh as a kitten.', 'http://localhost:8080/catalog/images/cat9.gif','http://localhost:8080/catalog/images/cat9.gif', 303);
INSERT INTO item VALUES(27, 'feline02', 'Wild Cat', 'This wild tiger loves to play.', 'http://localhost:8080/catalog/images/cat10.gif', 'http://localhost:8080/catalog/images/cat10.gif', 527);
INSERT INTO item VALUES(28, 'feline02', 'Saber Cat', 'Buy me', 'http://localhost:8080/catalog/images/cat11.gif', 'http://localhost:8080/catalog/images/cat11.gif', 237);
INSERT INTO item VALUES(29, 'feline02', 'Snappy Cat', 'Buy Me.', 'http://localhost:8080/catalog/images/cat12.gif', 'http://localhost:8080/catalog/images/cat12.gif', 337);