INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("1", "Blues To My Shoes", "16", "14", "False", "CD", "Blues", "Urban Label", "Mirky Waters");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("2", "Too Blue To Be True", "15", "12", "True", "CD", "Blues", "Deep South Label", "Dee Prest");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("3", "Cheatin' On Me", "12", "10", "False", "CD", "Country", "Dustbowl Music", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("4", "My Dog Left And So Did You", "18", "17", "True", "CD", "Country", "Great Plains Records", "Backroad Boys");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("5", "Stop Your Cheatin'", "14", "12", "False", "CD", "Country", "Rural Label", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("6", "Cheatin' Again", "21", "13", "False", "CD", "Country", "Rural Label", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("7", "Tumbleweeds and Tears", "14", "11", "False", "CD", "Country", "Rural Label", "Loretta Lonesome");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("8", "When Will The Cheatin' End?", "17", "15", "False", "CD", "Country", "Rural Label", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("9", "Really Gettin' Tired of The Cheatin'", "22", "16", "False", "CD", "Country", "Rural Label", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("10", "Cryin' In My Beer", "20", "14", "False", "CD", "Country", "Great Plains Records", "Ada Nutherwun");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("11", "Cheatin' Ain't So Bad", "22", "11", "False", "CD", "Country", "Rural Label", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("12", "Honky Tonk Harry", "15", "12", "False", "CD", "Country", "Great Plains Records", "Hot Hands Harry");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("13", "Too Cool For This Cat", "9", "8", "False", "CD", "Jazz", "Groove Records", "Zip Zappo");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("14", "Dig Those Crazy Sounds", "13", "11", "True", "CD", "Jazz", "Far Out Music", "The Cool Cats");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("15", "Gather 'Round the Accordian", "11", "9", "False", "CD", "Polka", "Anything Goes Records", "Robin and the Merry Men");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("16", "Who's Listening To The Music?", "12", "10", "False", "CD", "Pop", "Titilation Records", "The Sugar Girls");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("17", "It's Not About Talent", "19", "14", "True", "CD", "Pop", "Corporate Music", "The Remakes");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("18", "All Sounds The Same", "20", "16", "False", "CD", "Pop", "Marketing Music Inc.", "The Midrif Dancers");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("19", "Soul Searchin'", "14", "13", "False", "CD", "R&B", "Hometown Records", "Soul Sisters");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("20", "To Be A Rock and Not To Roll", "12", "9", "False", "CD", "Rock", "Amp Tower Records", "Zed Lepplin");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("21", "Still Livin' in the Seventies", "17", "11", "True", "CD", "Rock", "Retire Now Music", "The Strolling Bones");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("22", "Riffs 'n' Powerchords", "16", "12", "False", "CD", "Rock", "Loud 'n' Fast Label", "Screaming Guitars");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("23", "Still Cheatin'", "11", "9", "False", "CD", "Country", "Dustbowl Music", "Slim Chance");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("24", "Symphony in B# Major", "17", "15", "False", "CD", "Classical", "SmartArts Label", "The Symphony Orchestra");
GO
INSERT INTO products(product_key, title, price, sale_price, onsale, type, category, supplier, artist) VALUES("25", "The Epic Love Tragedy", "13", "10", "False", "CD", "Classical", "SmartArts Label", "Diva Opera Company");
GO



INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("1", "abcd01", "public", "1", "Neil", "Downe", "Shoe Shop", "Collins Street", "Melbourne", "VIC", "Australia", "3000", "neild@gshoes.com.au", "Retail");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("2", "abcd02", "public", "3", "Lance", "Boyle", "Medical Centre", "Queen Street", "Brisbane", "QLD", "Australia", "4000", "drlance@md.com.au", "Medical");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("3", "abcd03", "public", "3", "Carrie", "Oakie", "School of Voice Training", "Crown Street", "Wollongong", "NSW", "Australia", "2000", "carrie.oakie@sing.net", "Education");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("4", "abcd12", "public", "2", "Robin", "Darich", "Rob's Antiques", "Queen Street", "Brisbane", "QLD", "Australia", "4000", "rd@antiques.com.au", "Retail");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("5", "abcd04", "member", "8", "Amanda", "Love", "Mandy's Dating Service", "Rundle Street", "Adelaide", "SA", "Australia", "5000", "mandy@callmenow.com.au", "Service");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("6", "abcd05", "member", "5", "Ben", "Dover", "City Aerobics Centre", "Hay Street", "Perth", "WA", "Australia", "6000", "bend@aerobics.com.au", "Service");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("7", "abcd06", "member", "9", "Drew", "Steele", "Drew's Knife Shop", "Smith Street", "Darwin", "NT", "Australia", "0800", "ds@sharpknives.com.au", "Retail");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("8", "abcd07", "member", "7", "Seymour", "Butz", "Proctology Institute", "Northbourne Avenue", "Canberra", "ACT", "Australia", "2600", "sbutz@pi.org.au", "Medical");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("9", "abcd08", "member", "6", "Isabelle", "Ringing", "Belle Alarm Company", "Elizabeth Street", "Hobart", "TAS", "Australia", "7000", "belle@alarms.com", "Wholesale");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("10", "abcd09", "member", "9", "Hugh", "Jasse", "State Library", "George Street", "Sydney", "NSW", "Australia", "2000", "hughj@library.gov.au", "Government");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("11", "abcd10", "public", "4", "Marshall", "Day", "Armed Forces", "Hunter Street", "Newcastle", "NSW", "Australia", "2000", "sd@aaf.gov.au", "Military");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("12", "abcd11", "member", "5", "Erin", "Drunner", "Super Quick Courier", "Bourke Street", "Melbourne", "VIC", "Australia", "3000", "edrunner@sqc.com", "Service");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("13", "abcd13", "administrator", "10", "Tess", "Deuzer", "AB's CDs", "Pitt Street", "Sydney", "NSW", "Australia", "2000", "tessd@abcd.com", "Retail");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("14", "abcd14", "member", "6", "Dinah", "Tallot", "Eat Out Magazine", "Lygon Street", "Melbourne", "VIC", "Australia", "3000", "dinah@restaurant.com.au", "Journalism");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("15", "abcd15", "public", "4", "Jacqueline", "Hyde", "J&H Psychiatry", "Elizabeth Street", "Sydney", "NSW", "Australia", "2000", "jhyde@shrink.com", "Psychiatry");
GO
INSERT INTO siteusers( siteusers_key,passwd , ulevel, login_id, firstname, lastname, company, address, city, state_prov, country, zip_post_code, email, groupname) VALUES("16", "abcd16", "public", "1", "Miles", "Long", "ML Fencing", "Elizabeth Street", "Brisbane", "QLD", "Australia", "4000", "ml@longfences.com", "Retail");
GO
