USE nzimmerman_melt CREATE TABLE melt_states ( melt_states_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, state VARCHAR(30) NOT NULL, abbr CHAR(2) NOT NULL, PRIMARY KEY (melt_states_id) ) ENGINE = InnoDB; INSERT INTO melt_states(state, abbr) VALUES ('Alabama', 'AL'), ('Alaska', 'AK'), ('Arizona', 'AZ'), ('Arkansas', 'AR'), ('California', 'CA'), ('Colorado', 'CO'), ('Connecticut', 'CT'), ('Delaware', 'DE'), ('District of Columbia', 'DC'), ('Florida', 'FL'), ('Georgia', 'GA'), ('Hawaii', 'HI'), ('Idaho', 'ID'), ('Illinois', 'IL'), ('Indiana', 'IN'), ('Iowa', 'IA'), ('Kansas', 'KS'), ('Kentucky', 'KY'), ('Louisiana', 'LA'), ('Maine', 'ME'), ('Maryland', 'MD'), ('Massachusetts', 'MA'), ('Michigan', 'MI'), ('Minnesota', 'MN'), ('Mississippi', 'MS'), ('Missouri', 'MO'), ('Montana', 'MT'), ('Nebraska', 'NE'), ('Nevada', 'NV'), ('New Hampshire', 'NH'), ('New Jersey', 'NJ'), ('New Mexico', 'NM'), ('New York', 'NY'), ('North Carolina', 'NC'), ('North Dakota', 'ND'), ('Ohio', 'OH'), ('Oklahoma', 'OK'), ('Oregon', 'OR'), ('Pennsylvania', 'PA'), ('Rhode Island', 'RI'), ('South Carolina', 'SC'), ('South Dakota', 'SD'), ('Tennessee', 'TN'), ('Texas', 'TX'), ('Utah', 'UT'), ('Vermont', 'VT'), ('Virginia', 'VA'), ('Washington', 'WA'), ('West Virginia', 'WV'), ('Wisconsin', 'WI'), ('Wyoming', 'WY'); CREATE TABLE melt_customers( melt_customers_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, first_name VARCHAR(30) NOT NULL, last_name VARCHAR(30) NOT NULL, email VARCHAR(40) NOT NULL, phone VARCHAR(20) NOT NULL, password CHAR(255) NOT NULL, address_1 VARCHAR(100) NOT NULL, address_2 VARCHAR(100), city VARCHAR(50) NOT NULL, melt_states_id TINYINT UNSIGNED NOT NULL, zip CHAR(5) NOT NULL, date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(melt_customers_id), INDEX ind_melt_states_id (melt_states_id), CONSTRAINT fk_melt_states_id FOREIGN KEY (melt_states_id) REFERENCES melt_states(melt_states_id) ON DELETE CASCADE ON UPDATE CASCADE )ENGINE = InnoDB; create table melt_transactions( melt_transactions_id INT UNSIGNED NOT NULL AUTO_INCREMENT, amount_charged DECIMAL(6, 3) NOT NULL, type VARCHAR(100) NOT NULL, response_code VARCHAR(200) NOT NULL, response_reason VARCHAR(200) NOT NULL, response_text VARCHAR(400) NOT NULL, date_created TIMESTAMP NOT NULL, PRIMARY KEY(melt_transactions_id) ) ENGINE = InnoDB; create table melt_shipping_addresses( melt_shipping_addresses_id INT UNSIGNED NOT NULL AUTO_INCREMENT, address_1 VARCHAR(100) NOT NULL, address_2 VARCHAR(100), city VARCHAR(50) NOT NULL, melt_states_id TINYINT UNSIGNED NOT NULL, zip CHAR(5) NOT NULL, date_created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(melt_shipping_addresses_id) ) ENGINE = InnoDB; create table melt_billing_addresses( melt_billing_addresses_id INT UNSIGNED NOT NULL AUTO_INCREMENT, address_1 VARCHAR(100) NOT NULL, address_2 VARCHAR(100), city VARCHAR(50) NOT NULL, melt_states_id TINYINT UNSIGNED NOT NULL, zip CHAR(5) NOT NULL, date_created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(melt_billing_addresses_id) ) ENGINE = InnoDB; create table melt_carriers_methods( melt_carriers_methods_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, carrier VARCHAR(50) NOT NULL, method VARCHAR(50) NOT NULL, fee DECIMAL(6, 3) NOT NULL, PRIMARY KEY(melt_carriers_methods_id) ) ENGINE = InnoDB; INSERT INTO melt_carriers_methods (carrier, method, fee) VALUES ('USPS', 'Standard', '9.00'); create table melt_orders( melt_orders_id INT UNSIGNED NOT NULL AUTO_INCREMENT, melt_customers_id MEDIUMINT UNSIGNED NOT NULL, melt_transactions_id INT UNSIGNED NOT NULL, melt_shipping_addresses_id INT UNSIGNED NOT NULL, melt_carriers_methods_id TINYINT UNSIGNED NOT NULL, melt_billing_addresses_id INT UNSIGNED NOT NULL, order_total DECIMAL(7, 3) NOT NULL, shipping_fee DECIMAL(6, 3) NOT NULL, order_date TIMESTAMP NOT NULL, shipping_date TIMESTAMP NOT NULL, PRIMARY KEY(melt_orders_id), INDEX ind_melt_customers_id (melt_customers_id), CONSTRAINT fk_melt_customers_id FOREIGN KEY (melt_customers_id) REFERENCES melt_customers(melt_customers_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melt_transactions_id (melt_transactions_id), CONSTRAINT fk_melt_transactions_id FOREIGN KEY (melt_transactions_id) REFERENCES melt_transactions(melt_transactions_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melt_shipping_addresses_id (melt_shipping_addresses_id), CONSTRAINT fk_melt_shipping_addresses_id FOREIGN KEY (melt_shipping_addresses_id) REFERENCES melt_shipping_addresses(melt_shipping_addresses_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melt_carriers_methods_id (melt_carriers_methods_id), CONSTRAINT fk_melt_carriers_methods_id FOREIGN KEY (melt_carriers_methods_id) REFERENCES melt_carriers_methods(melt_carriers_methods_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melt_billing_addresses_id (melt_billing_addresses_id), CONSTRAINT fk_melt_billing_addresses_id FOREIGN KEY (melt_billing_addresses_id) REFERENCES melt_billing_addresses(melt_billing_addresses_id) ON DELETE CASCADE on UPDATE CASCADE ) ENGINE = InnoDB; create table melt_categories( melt_categories_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, category VARCHAR(100) NOT NULL, PRIMARY KEY(melt_categories_id) ) ENGINE = InnoDB; INSERT INTO melt_categories (category) VALUES ('Aromatherapy'), ('Bakery'), ('Breakfast'), ('Chocolate'), ('Clean'), ('Christmas/ Winter'), ('Coffee'), ('Easter'), ('Pet'), ('Fall'), ('Halloween'), ('Masculine'), ('Pop/ Soda'), ('Thanksgiving'), ('Wine'); create table melt_scents( melt_scents_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, scents VARCHAR(1000) NOT NULL, description VARCHAR(1000), PRIMARY KEY(melt_scents_id) ) ENGINE = InnoDB; INSERT INTO melt_scents (scents, description) VALUES ('4-Leaf Clover', 'A wonderful floral ozony blend of clover, green grass, with hints of fresh cut wisteria'), ('7-UP Pound Cake', ' A perfect blend of warm cake, almond, lemon, lime, vanilla, and sugar'), ('A Thousand Dreams', 'A warm mix of fruity and floral notes over a combination of musk, sandalwood and amber'), ('Absinthe', 'An aromatic blend of just the right combination of star anise, fennel, spicy cinnamon cassia, nutmeg, melissa, fresh green herbal notes, with base notes of amber and woods'), ('Acai Berry', 'A unique tropical berry scent with a top note of acai berry as well as middle and bottom notes of cherry, plum, violet petals and woods'), ('Acorn Harvest', 'A warm earthy nutty aroma with rich buttery vanilla notes'), ('Agave Lime', 'A shimmering citrus blend with high concentrations of lime, lemon and orange. Tropical floral notes and exotic agave greens balance at the heart of the fragrance, while clear musk and rich sandalwood form a soft background for this highly textured scent.'), ('Alien Princess', 'Notes of bright melon and sparkling mandarin are mixed with orange blossom, star jasmine, and rose and a woody base is supplemented by vanilla and musk.'), ('Almond', 'A fresh, true almond aroma'), ('Almond Macaroon', 'Fresh orange sweetens the toasted almond character, as bakery tones of warm cookie and toasted nut add a yummy sensation to the vanilla base notes.'), ('Almond Marzipan', 'A truly luscious combination of almond, rose, benzoin, cassis, and black currant.'), ('Almond Rum Cake', 'A scrumptious bakery arrangement beginning with top notes of almond extract, chopped almonds, and dark rum; followed by middle notes of sugar cane, coconut milk, vanilla extract, and heavy cream; well-rounded with base notes of butter and cake batter'), ('Aloe Vera and Cucumber', 'The scent of crisp, cool cucumbers, refreshing green aloe and a touch of fresh citrus'), ('Aloha', 'A tropical delight that combines sweet coconut and juicy island fruits with exotic, and delightfully fragrant native flora of tiare and plumeria flowers'), ('Alpine Snowdrift', 'A perfect blend of wet snow, a frozen air accord, menthol, woodland moss, spearmint leaves, winter anise, an ozonic accord, frosted vanilla, and galbanum'), ('Alyssum', 'Wonderful aroma of freshly picked alyssum flowers'), ('Amaretto', 'The aroma of fresh, true almond with notes of ripe, juicy cherries'), ('Amazingly Grace', 'Italian bergamot and sparkling lemon are sweetened with freshly picked citron and neroli. A white floral jasmine, orange blossom and rose are blended with sheer musk and cedarwood.'), ('Amber Waters', 'A woodsy, sexy, masculine aroma with top notes of pink grapefruit, Italian bergamot, and red berries, followed by middle notes of white lilies, lavender, and a marine accord; sitting on base notes of golden amber, patchouli, and guaiac wood.'), ('Ambered Tobacco Leaf', 'A unisex fragrance with top notes of lemon sparkle, dried apricot, and mandarin leaf, followed by middle notes of warm cardamom, sugared orchid, and water locus; all sitting on base notes of Cuban tobacco, amber, and brushed sandalwood'), ('Amish Friendship Bread', 'The aroma of fresh baked bread with notes of raisin, nut, and strawberries'), ('Amish Quilt', 'The tender sun kissed florals of heliotrope and jasmine, softly blended with woody violet and herbaceous anise to create a cozy scent of pure comfort'), ('Angel Love', 'A feminine, gourmand aroma with luscious rich top notes of lemon, raspberry, honeydew melon, black currants; with middle notes of jasmine, gardenia, and nutmeg; bottom notes of white chocolate, musk, sandalwood, and patchouli'), ('Angel Wings', 'A wonderful aroma embracing the softness of a newborn baby and the creaminess of vanilla custard with top notes of jasmine, geranium and violet.'), ('Angelica', 'Begins with top notes of lemon, mandarin, jasmine, and rose; followed by middle notes of white lily, violet, and pepper; sitting on base notes of patchouli, sandalwood, and white musk'), ('Animalistic Instinct', 'An intoxicating scent that has clean citrus notes of orange and lemon with spicy notes of clove, anise, pepper, and rose. Notes of vanilla, leather, balsam, and warm musks lead to an unforgettable finish.'), ('Anjou Pear Blossoms', 'A sophisticated blend of bergamot, pear nectar and ripe, orchard apples; enhanced by heady garden florals of jasmine, lily, rose, pear blossoms, and gardenia, intertwined with precious woods and vanilla'), ('Antique Lace', 'The romantic blend of jasmine and fresh vanilla beans, with a base note of musk'), ('Aphrodisiac', 'Aphrodisiac begins with top notes of grapefruit, lemon, mandarin, and green tomato leaf; followed by middle notes of jasmine, lily, bamboo and dry base notes of eucalyptus and woods.'), ('Apple Butter Caramel', 'A wonderful blend of mcIntosh apple, steamed milk, pure sugar, caramel candy, toffee pudding, apple butter, fresh nutmeg, vanilla bean, and soft musk.'), ('Apple Butter Pie', 'The perfect arrangement of tart pie apples, apple butter, evaporated milk, cinnamon, and buttery, flakey pie crust'), ('Apple Cinnamon', 'The aroma of a red juicy McIntosh apple, sprinkled with fresh ground cinnamon sticks.'), ('Apple Cinnamon Streusel', 'The fragrance begins with top notes of apples, pears, and applesauce. Middle notes include banana leaves and freshly ground cinnamon bark. Base notes include dry notes of vanilla, hazelnut, and almond.'), ('Apple Crisp', 'The aroma of a red juicy apple combined with buttercream and cinnamon with a base note of a baked oatmeal cookie.'), ('Apple Dumpling', 'Begins with top notes of red candy apples, and pears. Middle notes include nutmeg, clove, cardamom and freshly ground cinnamon bark. Base notes include dry notes of vanilla, and hazelnut'), ('Apple Happy Camper Candy', 'The aroma of tangy yet sweet green apple goodness'), ('Apple Jack Peel', 'The wonderful aroma of fresh peeled apples with zesty top notes of lemon and grapefruit, middle notes of peach, orange, cinnamon and clove. Sitting on base notes of maple, vanilla, cream, and musk.'), ('Apple Orchard', 'The perfect combination of Cameo, McIntosh, Red Delicious, Fuji, and Granny Smith apples.'), ('Apple Pecan Sage', 'The aroma of sweet fresh picked apples with aromatic spices and a wonderful nutty flavor.'), ('Apple Pie', 'Top notes of tart green apple and middle notes of cinnamon and brown sugar. While finishing with a base note of vanilla and buttery pie crust'), ('Apples and Oak', 'A complex fragrance blend of McIntosh and Granny Smith apples, orange, peach, and pineapple with floral middle notes of lily of the valley, jasmine, and violet. Base notes of woodsy fresh oak leaves and oak moss.'), ('Applewood Fir Needle', 'This woodsy fragrance oil starts with top notes of fallen leaves and fresh winter air. This aroma is centered around middle notes of winter berries and fir needles. It is anchored by warm notes of applewood and cedar.'), ('Apricot', 'The aroma of ripened fresh apricots.'), ('Aromatherapy Energizing', 'An uplifting blend of fresh airy notes combined with lemon, garden peppermint, spearmint, and wintergreen; balanced with floral notes of gardenia, jasmine, and rose. '), ('Aromatherapy Mood Enhance', 'An uplifting, herbal floral aroma composed of fresh citrus top notes, floral middle notes of lavender and rose, with earthy base notes of patchouli and cedarwood.'), ('Aromatherapy Passion', 'A blend of floral notes such as lilac, gardenia, carnation, lavender, and hyacinth on a strong bouquet of roses'), ('Aromatherapy Relaxxation', 'A relaxing blend of freshly picked lavender flowers, with juicy citrus top notes; well balanced with woodsy base notes.'), ('Asian Pear and Lily', 'A complex accord containing top notes of Nashi Pear, Apple, and Leafy Greenery; followed by middle notes of Jasmine, Lily of the Valley, and Rose Petals; all sitting on base notes of Pear Nectar, Musk, and Peony Blossoms.'), ('Aspen Winter', 'The aroma of crisp citrus notes intertwined with an abundance of warm winter spices of clove and cinnamon, sitting on a dry down of sweet vanilla.'), ('Australian Bamboo Grass', 'Top notes of bamboo, fresh lime, lemon, mint, and ozone; balanced with middle notes of French lavender, and well-rounded with a nice base note of white musk'), ('Autumn Magic', 'Autumn magic starts with top notes of lemon and apple; followed by middle notes of anise, cinnamon, and ginger; sitting on well-rounded base notes of woods, musk, and vanilla.'), ('Autumn Woods', 'A walk in the woods with the smell of crisp leaves under foot and fresh pine with berries falling off the trees.'), ('Autumn Wreath', 'A cheerful, fall, and welcoming scent with the spicy warmth of autumn leaves, cinnamon apples, nutmeg and clove.'), ('Awapuhi Seaberry', 'Tropical flowers and ozonic marine notes collide in this fresh fragrance. Beginning with top notes of Italian bergamot extract, tart seaberries, and marine, ozonic notes; flowing nicely into middle notes of geranium, jasmine, and fresh rose petals; well-balanced with a base note of white musk. '), ('Green Apple Explosion', 'The spunkiest granny smith green apple fragrance'), ('Aloe and White Lilac', 'A complex fragrance beginning with top notes of petitgrain, Italian bergamot, and ozonic notes; middle notes of lilac, lily of the valley, and hints of tuberose; base notes of sweet vanilla, amber, precious musk, and oakmoss.'), ('Amber Romancing', 'A rich combination of amber, African vanilla, and musk with a faint undertone of black cherry.'), ('Angels Whispering', 'This fragrance begins with top notes of green leafy ferns and sweet florals; followed by jasmine and white floral lily; sitting on a floral musk base note.'), ('Apple Mango Tango', 'This fragrance begins with top notes of sweet, ripened, McIntosh apples, pears, and white roses; followed by middle notes of freshly sliced mango, fresh greenery, and tiger lily; all sitting on base notes of floral musks.'), ('April Clean', 'The aroma of fresh powder, light musk, and just a hint of fresh spring flowers of lavender, jasmine, and tulips.'), ('Aqua di Gio', 'A sexy, fresh, aquatic aroma with bergamot, neroli, and tangerine; flowing into mid notes of rosemary, jasmine, and persimmon; all sitting on a woodsy base note of essential oil of patchouli.'), ('Baby Clean', 'This wonderful scent has top notes of granny smith apple, lemon zest, and hints of mint, rounded out with blossoms of spring wildflowers, butterfly violets & honeysuckle.'), ('Baby Powder', 'This fragrance is reminiscent of Johnson's Baby powder scent.'), ('Bacon', 'The aroma of hot sizzling bacon.'), ('Balsam and Cedar', 'A camphoraceous woody blend of pine, eucalyptus, cedarwood; finished with sweet balsam. This fragrance is composed of top notes of orange, raspberry, and plum; middle notes of lily, carnation, and hyacinth; base notes of balsam, pine, eucalyptus, and cedarwood.'), ('Balsam', 'A wonderful fresh pine with a touch of earthiness makeup this timeless scent.'), ('Bamboo and White Grapefruit', 'This fragrance begins with top notes of White Grapefruit, Petitgrain, and Tangerine; leading to middle notes of Mandarin, Tangerine, and Mimosa Petals; and balanced with base notes of Rainforest Bamboo, Juniper Berries, and Musk.'), ('Bamboo Hemp', 'An incredibly well-balanced blend of bamboo stalks, vetiver, and patchouli, with undertones of hemp seed and oakmoss.'), ('Banana', 'This scent has the single note of fresh ripened bananas.'), ('Banana Cream Pie', 'This fragrance begins with top notes of ripe banana, quince, and apple; middle notes of juicy pearberry, Anjou pear, clove buds, and plantain leaves; base notes of vanilla extract, pie crust, and butter rum.'), ('Banana Foster Pie', 'This decadent dessert fragrance is a wonderful blend of sweet, ripened bananas, caramel sauce, butter, brown sugar, banana liquor, vanilla ice cream, and just a touch of dark rum and cinnamon.'), ('Banana Kiwi', 'The aroma of fresh banana and tart kiwi.'), ('Banana Nut Bread', 'The aroma of freshly baked banana nut bread.'), ('Basil Sage Mint', 'A garden fresh medley of basil leaves, clary sage and peppermint sprigs accented by hints of citrus zests, fresh spring flowers, and soft, soothing musk.'), ('Bay Rum', 'A spicy, cultural blend of crushed cloves, cinnamon sticks, patchouli, and crisp pine needles, with a sweet orange freshness.'), ('Bayberry', 'A nice blend of fir and balsam and delicate spicy undertones of nutmeg and ginger.'), ('Beach Bum', 'Combining juicy mandarin, sand jasmine, and refreshing oceanic mist.'), ('Beach Daisies', 'This scent begins with top notes of Asian lemongrass, dune grass, and daisy petals; followed by middle notes of gardenia bloom, ylang ylang, and clove leaf; sitting on base notes of blond woods, amber sands, and sheer musk.'), ('Beautiful Babe', 'Delicate white and red roses, heady jasmine and spicy carnations blend with juicy melon and ripe plums, culminating to a sensual finish of precious woods and warming amber.'), ('Bedtime Baby', 'This soothing bedtime blend combines notes of mandarin, lavender and chamomile, neroli and lily of the valley with bottom notes of hay and musk.'), ('Beer', 'This fragrance has notes of malt liquor and hops with fruity notes of strawberry, pineapple, apple, and raspberry.'), ('Bergamot & Tarragon', 'This is a fragrance with notes of tarragon leaves, grapefruit, and lime; complimented by notes of bergamot and jasmine; well rounded with base notes of oakmoss and bamboo.'), ('Bergamot', 'Crisp, clean and juicy with a subtle floralcy.'), ('Bermuda Triangle', 'An excellent blend of cantaloupe, honeydew, and watermelon; with citrus top notes of mandarin, tangerine, grapefruit and lime; with just a hint of juicy McIntosh apples.'), ('Berry Bewitching Brew', 'Berry Bewitching Brew begins with top notes of peach, apricot, and blackberries; middle notes of mandarin, cinnamon, and rose; and nicely balanced with just a hint of woodsy musk.'), ('Best Friends', 'This is an aromatic blend of boysenberries, elderberries, strawberries, guava and pomegranate with a down of soft vanilla.'), ('Bet Your Butterscotch', 'A fragrance that captures the goodness of sweet, creamy, delicious butterscotch candy wrapped in bright golden foil.'), ('Better Than Sex Cake', 'This fragrance smells like German chocolate cake that is blended with semi-sweet chocolate chips and laced with crunchy toffee bits to create this decadent treat. Vanilla creme and butterscotch syrup create a luscious undertone, while hints of almond and coconut complete the yummy blend.'), ('Beverly Hills Glam', 'Bursting with beautiful notes of ylang ylang, rose, and carnation with green moss, sweet amber and warm sandalwood complete the scent as a background.'), ('Birds of Paradise', 'This fragrance begins with top notes of lemon, orange, and tuberose, followed by middle notes of birds of paradise, gardenia, rose, and honeysuckle; all sitting on base notes of magnolia leaves and jasmine.'), ('Bitches Brew', 'The smoky, woody sweetness of balsamic resins and patchouli enveloping herbaceous florals for a bewitching scent.'), ('Bite Me', 'Fresh citrus notes of lime and orange sparkle with effervescent highlights as they lead to a luscious blend of berry and cherry in this playful scent. Leafy green accents add intensity as a base of vanilla creates sweet tones for the fragrance.'), ('Black Cherry Bomb', 'A delightful black cherry aroma that is not too sickeningly sweet.'), ('Black Cherry', 'An extremely strong aroma of ripened sweet black cherries.'), ('Black Currant', 'A rich, fruity blend of juicy wild berries and ripe currant highlighted by sparkling citrus and wrapped in a blend of floral infused vanilla.'), ('Black Licorice', 'This scent is a strong and true black licorice smell.'), ('Black Linen & Amber', 'This fragrance begins with top notes of fresh cotton and crisp ozonic notes; followed by middle notes of white blossoms; well rounded with base notes of cashmere, amber, musk, and patchouli.'), ('Black Magic', 'A magical blend of earthy sandalwood & ylang ylang, with base notes of baby powder, patchouli, and vanilla.'), ('Black Ops', 'An oriental, alluring, masculine aroma that begins with citrus top notes of bergamot, and fresh lemon; leading to a middle note of olive flower; and sitting on base notes of Amber,Tonka bean and Guaiac woods.'), ('Black Raspberry Vanilla', 'An enticing blend of blackberries and raspberries, with middle notes of white floral greenery, and bottom notes of musk and vanilla.'), ('Black Tie', 'This fragrqnce begins with top notes of Kaffir lime, lemon, and ozonic notes; followed by middle notes of basil, black pepper, and cucumber; sitting on base notes of vetiver and spice.'), ('Black Tuxedo', 'A modern, classy, sexy, complex blend of the following fragrance notes: bergamot, lemon, silver fir, and geranium; all sitting on intoxicating notes of woods, leather, and musk.'), ('Blackberry Bling Bling', 'The scent of juicy blackberries and bright citrus perfectly blended with fresh herbs.'), ('Blackberry Fizz', 'This fragrance begins with aldehydic fruity notes of blackberry, strawberry, and pomegranate, citrus middle notes of mandarin, grapefruit, and lime, with a base note of bamboo.'), ('Blackberry Jam', 'A well-rounded blend of ripe and tart blackberries with base notes of vanilla and fresh greenery.'), ('Blackberry Sage', 'This fragrance has strong top notes of tart blackberries, mulberries, and orange zests; middle notes of nutmeg, rose petals; bottom notes of fresh green sage leaves, red clover, and a dry down of vanilla.'), ('Blackened Amethyst', 'This fragrance combines aquatic top notes with Italian bergamot, rare camellias, and lime; followed by middle notes of lily, jasmine, and rose; finished with notes of exotic sandalwood and vetiver.'), ('BLood Orange', 'This fragrance is a tangy, juicy orange scent with just a touch of floral thyme.'), ('Blood Orange Margarita', 'Blood Orange Margarita is a refreshing girly cocktail with juicy blood orange, navel orange, and lime for its top notes, an upscale Cointreau wine and tequila accord for a well rounded middle, with orange peel and sage sprigs as the bottom.'), ('Blue Agave', 'This fragrance begins with top notes of Kaffir lime, lemon zests, apple, and black currant; followed by middle notes of lily of the valley and rose petals; sitting on base notes of oakmoss and white woods.'), ('Blue Cotton Candy', 'This is an airy sweet cotton candy fragrance with fruity notes of strawberry and raspberry, laced with caramel swirls and hints of nutty almond sweetened with vanilla.'), ('Blue Hawaiian', 'Blue Hawaiian begins with mouth-watering top notes of juicy orange, lemon, and maraschino cherries; followed by tangy pineapple, acai berry, and sea spray; well rounded with base notes of sweet coconut, vanilla rum, and fresh ozonic notes.'), ('Blue Raspberry Slushie', 'The aroma of ripened raspberries, sugary cotton candy, and the effervescence of crushed ice'), ('Blue Sugar', 'A romantic floral bouquet at the heart of the fragrance intertwines with fresh green tones and rich patchouli. The vanilla signature at the base of the scent is balanced with soft musk and warmed by exotic woody tones for lingering sensuality.'), ('Blueberry Cheesecake', 'This fragrance begins with Tahitian vanilla, rich creamy butter and ripe blueberries atop a crumbly graham cracker crust.'), ('Blueberry Cobbler', 'This fragrance has top notes of butter and juicy blueberries with a background of freshly ground cinnamon bark and warm vanilla.'), ('Blueberry Flapjack', 'The aroma of blueberry buttermilk pancakes drenched with savory maple syrup; topped with pecans'), ('Blueberry', 'This fragrance has a single note of fresh blueberries.'), ('Blueberry Muffin', 'This fragrance has top notes of juicy tart blueberries with orange zests, middle notes of butter cake, and base notes of vanilla and almond.'), ('Bogeyman', 'Bogeyman fragrance begins with notes of geranium, bergamot, and rich Indian spices; well rounded with notes of amber, woods, and musk.'), ('Born to Win', 'The essence of a champ, this medley of masculine appeal begins with a base note of Oakmoss, Amber, Timber and Cashmere Woods. As well as middle and top notes of French Lavender, Honeysuckle, Italian Bergamot, Pineapple and Orange.'), ('Boston Tea Party', 'This fragrance is the aroma of freshly brewed iced tea with juicy lemon.'), ('Brazilian Jackfruit', 'This fragrance begins with notes of tropical jackfruit, pineapple and delicious apple combined with an alluring heart of jasmine, rose, and white florals; complimented by the soft warmth of sandalwood and musk.'), ('Breezes & Sunshine', 'Breezes and sunshine fragrance begins with top notes of blood orange blossoms and sea waves; followed by rose, and sitting on base notes of sea lily flowers and woody notes.'), ('Brown Sugar & Fig', 'This fragrance is composed of top notes of fresh figs, peaches, and passion fruit; followed by middle notes of coconut milk, vanilla orchid, jasmine, muguet, and freesia; well-balanced with base notes of vanilla beans, caramel, maple sugar, fig leaves, and musk.'), ('Bubble Luscious', 'This fragrance begins with top notes of strawberry, aldehydic effervescent notes, and citrus; followed by middle notes of coconut and clove; sitting on a base note of crisp vanilla.'), ('Bubblegum', 'This is the aroma of sweet, juicy childhood bubblegum.'), ('Bumbleberry', 'This fragrance begins with top notes of blackberry, apricot, and strawberry; followed by middle notes of sweet pear, lavender, and jasmine; sitting on base notes of earthy woods.'), ('Burberry British', 'This fragrance is a fresh, modern blend of classic cologne citruses highlight warm, inviting ouds, amber, sandalwood and white musks.'), ('Burgundy Rose', 'Sensual burgundy rose with fresh white floral nuances, blend with exquisite burgundy wine, and warmed by precious musk and apple wood. Finally, a rose fragrance that withstands the saponification process without losing its authenticity.'), ('Butt Naked', 'This fragrance is the medley of granny smith apples and honeydew melon, strawberries and pears, with hints of spice.'), ('Butter Brickle', 'This fragrance starts with strong base notes of vanilla, with hints of almond.'), ('Buttercream Cupcake', 'This wonderful fragrance begins with top notes of churned whipped butter, blonde sugar cane; followed by middle notes of Madagascar vanilla and maple; well-rounded with a dry base note of vanilla extract.'), ('Buttercream', 'The aroma of buttery, buttercream frosting with hints of vanilla.'), ('Buttered Maple Oats Honey', 'This fragrance includes mouth-watering notes of oatmeal and sweet cream butter, cinnamon, raisins, and honey, with notes of vanilla, brown sugar, and maple.'), ('Buttered Popcorn', 'This fragrance is the delicious aroma of freshly popped popcorn with rich creamy butter.'), ('Butterfly Flower', 'A blend of lily and sage is twisted with shimmering greens as tangy tones of cassis create a bright accent for the floralcy. Sweet amber and crisp orange flower are blended with musk at the base of the scent.'), ('Butterfly Hugs', 'This fragrance is a creative fresh blend of apple blossom, lily of the valley and rose petals'), ('Butterfly Meadow', 'This fragrance begins with top notes of summer dandelion, refreshing verbena, and soft heliotrope; followed by middle notes of spring meadows, lily of the valley, and weeping willow; all sitting on base notes of sweet pea blossoms and Kentucky bluegrass.'), ('Buttermilk Pancakes', 'A well-rounded fragrance composed of notes of rich buttermilk, freshly baked cake, sweet cream butter, and maple syrup; nice lingering vanilla base note.'), ('Fresh Bamboo', 'This fragrance is a well-balanced, green fragrance encompassing a fusion of the following unique fragrance notes: golden bamboo, sparkling bergamot, red grapefruit, night-blooming jasmine, cyclamen, muguet lily, and wild grasses.'), ('Fresh Basil', 'This fragrance is the refreshing aroma of fresh cut leaves of basil. '), ('Baby Bee Buttermilk', 'A fragrance cocktail of luscious fruits such as peaches, mandarin oranges, coconut pulp, bergamot, grapefruit, tropical guava, and tangy lemons.'), ('Baby Graceful', 'This fragrance is a fresh accord combining feminine notes of mimosa flowers, poppy, pepper, white woods, fresh greenery, and musk.'), ('Baby Powder Fabuloso', 'Blooming lilac, sweet jasmine, wild rose, and fresh lily balance with hints of spice for the fragrance signature. Fresh green accents boost the floralcy while a background of soft sandalwood adds a luxurious touch. Powdery sweet base notes carry the bouquet to a soft finish.'), ('Blue Hydrangea', 'This fragrance will remind you of a combination of sun-kissed hydrangeas and fresh breezes.'), ('Burst of Energy', 'This fabulous fragrance begins with top notes of forest fresh green leaves and lemon zests, and well rounded with fruity notes of peaches, apples, and pineapples.'), ('Riesling Berry Slush', 'This fragrance is a berry wine slushy scent that begins with top notes of juicy strawberry, ripe peach, and Sicilian bergamot, followed by middle notes of black currant, orange zests, and a semi-sweet riesling accord; finishes with base notes of rose buds, apple peel, and transparent musk.'), ('Cabernet', 'This fragrance is the sweet aroma of wild grapes enhanced with hints of strawberries and sweet sugary notes with a light alcoholic background.'), ('Cafe Caramel', 'This fragrance is the aroma of fresh-brewed cappuccino, filled with heavy cream, and sweetened with sugary caramel.'), ('Cafe Mocha', 'This fragrance has notes of fresh brewed coffee, chocolate syrup, creamy vanilla, and marshmallows.'), ('Cake Bake', 'This fragrance is the aroma of almond cake with a base note of melted butter.'), ('Camu Camu', 'This scent is an abundance of tart red berries, juicy orange and peach nectar blended with a twist of lime.'), ('Candied Apple', 'This fragrance is an irresistible blend of juicy apples, rounded out with notes of sweet plums and ripened strawberries; enhanced with a splash of lime, orange zests, with sharp green notes'), ('Candy Cane', 'This fragrance is a wonderful combination of fresh peppermint leaves and sweet ripened strawberries, on a dry down of vanilla.'), ('Candy Corn', 'This fragrance is a warm vanilla candy with top notes of butter with a slight down of almond'), ('Cane Sugar Cookies', 'This fragrance is the aromatic combination of just the right top notes of cane sugar, butter, and rum; followed by middle notes of caramel and vanilla extract; sitting on a dry base note of vanilla sugar.'), ('Cannabis Flower', 'A warm blend of cashmere wood surrounds the floralcy, while sensual undertones of musk and golden amber soften the scent from within.'), ('Cannabis Rose', 'This fragrance is a blend of Bulgarian rose, pomegranate flower, bergamot, cannabis accord, sheer jasmine, dark chocolate, white musk, patchouli, and oolong tea.'), ('Cantaloupe', 'This fragrance is the refreshing aroma of fresh ripened cantaloupe slices, with base notes of fresh greenery.'), ('Cappuccino', 'This fragrance is a rich strong fresh brewed coffee with heavy cream and sugar.'), ('Capri Olivo', 'Capri Olivo is a culturally complex aroma of tart Japanese grapefruit, Fresh Osmanthus (Sweet Olive), and dew-covered watercress; followed by middle notes of rose, jasmine, and cassis'), ('Caribbean', 'This fragrance is a tropical paradise blend of coconut, fresh sliced pineapple, with a scoop of vanilla ice cream.'), ('Carnation', 'This fragrance is a crisp, clean aroma of freshly picked carnation flowers with bottom notes of fresh greenery.'), ('Carrot Cake', 'This fragrance is a buttery spice blend with hints of peach, coconut, carrots, cinnamon and warm vanilla.'), ('Carrot Cupcake', 'This fragrance has notes citrus spiced with clove, carrot, nutmeg, cinnamon and bay leaf and comforting vanilla extract.'), ('Cashmere', 'This fragrance has notes of saffron, pimento berries, white pepper, and a lovely blend of floral, patchouli, and vanilla.'), ('Cedar Wood', 'This fragrance is a warm earthy scent of cedar, with base notes of vanilla and musk.'), ('Celestial', 'This fragrance is the infusion of warm sandalwood, vetiver, cedar and musk, with enlightening spicy notes of sage and thyme to combine with bright citrus notes that inspire both mind and soul.'), ('Chai Tea', 'The chai tea fragrance is a fabulous aroma of just the right amount of gourmet tea leaves, rich spices, and vanilla soy milk.'), ('Chamomile', 'This fragrance is the wonderful aroma of freshly picked chamomile flowers with hints of fresh green herbs.'), ('Champagne Pear', 'Orchard pear and fresh apple balance at the heart of this fragrance, while a hint of apple blossom creates texture for the fruity accord. Luxurious musk undertones soften the blend.'), ('Champagne Pomegranate', 'This fragrance is a sparkling bouquet of grapefruit, lemon & orange blended with fresh tones of red fruit and a twist of crushed pomegranate seeds in this lively scent. Hints of green foliage are freshened with a blend of crisp aldehydes to reinforce the sparkling top note.'), ('Champaka', 'Champaka flowers have a unique aroma that combines the floral notes of jasmine, lavender, lilac, and fresh greenery with the earthy notes of patchouli and sandalwood.'), ('Chance of a Lifetime', 'This fragrance is a blend of citron, water hyacinth, jasmine, iris, teakwood, vetiver, patchouli, amber, and white musk.'), ('Che Bella Donna', 'This fragrance has notes of sparkling citrus mingling with romantic floral notes of heady tuberose, lily and sassy carnation.'), ('Cherry Almond', 'This fragrance is a nutty cherry aroma with top notes of juicy cherry, wild raspberries, and sweet almonds, followed by mid notes of mimosa flower, rose petals, and cinnamon; sitting on well grounded base notes of vanilla and Tonka beans.'), ('Cherry Crumb Pie', 'This fragrance is a combination of sweet black cherries and sour cherries with a base note of a freshly baked southern flake crust.'), ('Cherry', 'This is the aroma of fresh tart red cherries. Very strong!'), ('Chestnut Brown Sugar', 'This fragrance is a succulent aroma that is reminiscent of fall time with top notes of caramel, brown sugar, nutty characters, maple, and butter; followed by powdery middle notes; sitting on a fresh, full-bodied base note of chestnut.'), ('Childrens Room', 'This fragrance is a very soft violet powder accord with very light floral bottom notes of peony and alyssum flowers.'), ('China Rain', 'This fragrance is a refreshing, clean aroma with top notes of fresh rose petals, middle notes of wisteria and cyclamen, bottom notes of sandalwood and vanilla.'), ('Chocolate and Amber', 'This fragrance begins with a warm heart of sandalwood and patchouli that blends with jasmine blossoms. Rich undertones of musk are sweetened with precious amber and hints of vanilla. A lingering accent of cocoa bean creates a heady twist for the scent.'), ('Chocolate Chip Cookies', 'This fragrance is the wonderful aroma of freshly baked cookies with base notes of semi-sweet chocolate and vanilla.'), ('Chocolate Con Churros', 'This fragrance is a wonderful blend of fresh pastry churros with warm notes of creamy dark chocolate and vanilla.'), ('Chocolate Covered Cherries', 'This fragrance is the aroma of sweet maraschino cherries smothered in milk chocolate, with a dry down of French vanilla.'), ('Chocolate Covered Strawberries', 'This fragrance has hints of orange liquor that accent the fresh fruity tones of this luscious confection. Ripe red strawberry is surrounded by creamy milk chocolate notes to create a decadent treat. Sweet vanilla creme and rich maple combine at the base of the scent.'), ('Chocolate Cream Cheese Cupcake', 'This fragrance begins with a creamy top note of coconut; followed by a warm middle note of buttercream; and well rounded with a base note of dark cocoa.'), ('Chocolate Fudge', 'Rich, dark chocolate swirled with ribbons of buttery caramel and vanilla creme, sprinkled with toasted almond slivers and creamy hazelnut.'), ('Chocolate Lovers', 'This fragrance is a fusion of lemon, orange, bergamot and mandarin, lily of the valley and coriander emerged with unmistakable notes of sweet chocolate, along with warm vanilla and musk.'), ('Chocolate Orchid', 'This fragrance is reminiscent of true chocolate orchids, which smell like a fresh floral with undertones of real chocolate.'), ('Chocolate Raspberry Drizzle', 'A rich dark chocolate accord surrounds luscious ripe raspberry tones for the fragrance signature. Green stem notes create natural appeal for the fruit character, while a generous base of velvet musk and sweet vanilla completes this fragrance.'), ('Christmas Cabernet', 'This fragrance has top notes of red grape, strawberry and ginger that are paired with middle notes of cherry, plum and rose hips. All pulled together with base notes of cabernet wine, oak and vanilla.'), ('Christmas Cabin', 'This fragrance is a wonderful blend of bayberries and cranberries with a top note of freshly crushed cinnamon bark with hints of orange zests.'), ('Christmas Cookies', 'This fragrance smells just like a freshly-baked, buttery Christmas Cookie with frosting.'), ('Christmas Cravings', 'This wonderful fragrance begins with top notes of orange, grapefruit, lemon, and apple; followed by middle notes of cinnamon, ginger, carrot, and nutmeg; sitting on base notes of buttercream and vanilla.'), ('Christmas Memories', 'This fragrance begins with top notes of orange peel and cranberry sauce; flowing nicely into middle notes of cinnamon sticks and freshly ground cloves; with base notes of evergreen and pine cones.'), ('Christmas Splendor', 'This fragrance is the wonderful Christmas combination of apples, oak, balsam, fir, and pine, with a background of cinnamon and clove.'), ('Christmas Thyme', 'This fragrance is the aroma of bayberries and apples with a base note of fresh pine needles and thyme, with a top note of freshly ground cinnamon bark.'), ('Christmas Tree', 'This fragrance begins with top notes of pine and fresh lime; with middle notes of cardamom and pepper; with a base note of Scotch pine.'), ('Christmas Wassail', 'This fragrance is the wonderful aroma of mulled apple cider, fresh pineapple, and orange zests surrounded with spicy cinnamon and cloves.'), ('Chrsitmas Wreath', 'This fragrance is the aroma of fresh cut boughs of pine, balsam, hollyberry and earthy pinecones.'), ('Chubba Dubba Weight Loss', 'This fragrance is the fresh aroma blend of Sicilian orange, lemongrass, lemon slices, jasmine, green tea, and Tahitian vanilla. '), ('Cinnabun', 'This fragrance is the aroma of freshly baked cinnabun rolls with flowing streams of cream cheese frosting.'), ('Cinnamon Buns', 'This fragrance is a spicy cinnamon accord with warm nutty undertones along with the aroma of fresh baked bread.'), ('Cinnamon Doughnuts', 'The aroma of fresh crushed cinnamon bark with base notes of baked yellow cake with creamy buttery vanilla undertones.'), ('Cinnamon Sticks', 'This fragrance is the aroma of freshly ground cinnamon bark.'), ('Cinnamon Yum Yums', 'This fragrance begins with top notes of cinnamon and clove; followed by middle notes of fresh danish, lily of the valley, and jasmine; with base notes of vanilla, nuts, and yeast.'), ('Cinnanut Columbian Cafe', 'This fragrance is the rich tones of fresh roasted Colombian coffee perfectly balanced with warm cinnamon to create this blend. Buttery roasted Brazil nuts and rich maple add texture to the gourmand delight.'), ('Citronella Berry', 'This fragrance is citronella combined with fruity notes of strawberry, mandarin, and raspberry.'), ('Citronella', 'This fragrance is reminiscent of a wild Indonesian Herb used to keep bugs away.'), ('Citrus Strawberry', 'This fragrance is an amazing, creative strawberry citrus fragrance combination including top notes of mandarin, strawberry, and lime; followed by middle notes of raspberry, sweet sugar caramel, and lily of the valley; and well-rounded with a nice woodsy, musk muguet.'), ('Class and Sass', 'A gorgeous array of fresh floral ylang ylang, rose petals, and French jasmine. Lovely notes of vetiver and sandalwood, provides a woodsy bottom. '), ('Clean Crisp Air', 'This complex fragrance begins with top notes of fresh clover and ivy. Middle notes of baby's breath, periwinkle, and lily of the valley. Base notes of ozony fresh notes.'), ('Clean Fresh Cotton', 'This fragrance begins with top notes of Kaffir lime and lemon zests; followed by middle notes of baby powder, African violet, and jasmine; sitting on base notes of woods and white musk.'), ('Clean', 'This fragrance combines the fragrance notes of litsea cubeba, orange, sweet lime, pink grapefruit, passion lily, rose geranium, and white musk. A clean, sweet layer combines the fragrance notes of sweet orange, grapefruit, lime, neroli, and rose to add a sweet feminine layer to the scent while maintaining the soapy, clean essence.'), ('Clementine', 'This fragrance is a wonderful citrus arrangement including top notes of clementine, tangerine, orange, grapefruit, and lime; with middle notes of ginger, and lime blossoms, and a fresh base note of vanilla bean.'), ('Clove', 'This fragrance is a strong natural clove with hints of other spices like cinnamon and ginger.'), ('Cocktails by the Pool', 'This fragrance begins with top notes of Sparkling Lemon, Honeydew and Pear, with middle notes of Vibrant Orange, Pineapple and Nectarine combined with wonderful base notes of Lily of the Valley, Jasmine, Sandalwood and Vanilla.'), ('Coco Mango', 'This complex fragrance begins with fruity notes of mango, fresh strawberries, elderberries, and ripe papaya. This scent is completed with rich vanilla and toasted coconut with just a hint of soft musk.'), ('Coconut Cabana', 'This fragrance is a combination of just the right notes of cocoa butter and tropical fruits.'), ('Coconut Coast', 'This fragrance is the summertime sensation of creamy coconut enhanced by fresh fruits and island air.'), ('Coconut Craziness', 'This fragrance begins with top notes of lemon, orange, pineapple, and lime; rounded-out with middle notes of caramel and coconut, with base notes of buttercream, coconut milk, vanilla bean, and musk.'), ('Coconut Cream Pie', 'This fragrance is a rich, creamy vanilla base with notes of coconut, butter, with a hint of fresh baked.'), ('Coconut', 'This fragrance is a delightful fresh and true coconut aroma.'), ('Coconut Lime Verbana', 'This fragrance is a citrus bouquet of lime, kumquat, grapefruit, lemon, with a soft floral undertone of jasmine, on a background of musk and sandalwood.'), ('Coconut Shea', 'This fragrance begins with top notes of fresh coconut shavings, juicy lemon, and orange zests, leading to notes of creamy shea butter, hints of rose petals, with a marine accord; all sitting on a warm base of driftwood, tonka bean, and exotic musk. '), ('Cognac and Cubans', 'This fragrance is an aromatic blend of bergamot with fresh lemon zest spritzing a heart of velvety cognac essences and rich, spiced tobacco leaves.'), ('Cola', 'This fragrance is the aroma of carbonated coca cola!'), ('Cool Cilantro', 'This fragrance is a single note of freshly picked cilantro herb.'), ('Cool Clear Water', 'This fragrance is a blend of lavender, jasmine, oakmoss, musk and sandalwood.'), ('Cool Spring', 'This fragrance contains notes of bergamot, geranium, lavender, cedarwood and oak.'), ('Cotton Candy', 'This fragrance is a blend of fresh strawberry and French vanilla.'), ('Cotton Headed Ninny Muggin', 'This fragrance inspired by the movie “Elf” begins with notes of sweet, buttery, creamy coconut and vanilla frosting; leading to middle notes of powdery heliotrope and spicy hints; and sits on a powerful vanilla base.'), ('Country Apple', 'This fragrance begins with top notes of pineapple, jasmine, and tiger lily; strong middle notes of juicy McIntosh apples and tart granny smith apples; with a dry down of vanilla beans.'), ('Country Bumpkin', 'This fragrance is the blend of apples, candied yams, marshmallows, sweet cream butter, brown sugar, nutmeg, crushed cinnamon bark and fresh cloves.'), ('Country Christmas', 'This fragrance is a blend of bayberries, cranberries, and apples, with spicy nuances of nutmeg and cloves with a top note of orange zests.'), ('Country Clothesline', 'This fragrance is the aroma of fresh powder, light musk, and just a hint of fresh spring flowers of daffodils and tulips.'), ('Country Garden', 'This fragrance begins with top notes of fresh green clover, and ivy with middle notes of romantic snapdragon, rose petals, and carnations; ending with base notes of white musk and fig leaves.'), ('Country Home', 'This fragrance begins with top notes of orange blended with middle notes of clove and cinnamon. All pulled together with base notes of Musk and woods.'), ('Couture Hotness', 'This fragrance combines top notes of raspberry and bergamot, middle notes of magnolia and jasmine, and base notes of white musk and vetiver.'), ('Cracklin Birch', 'This fragrance begins with top notes of bergamot, orange, and lemon; with middle notes of geranium, lily, and rose; and base notes of patchouli, vetiver, and tonka beans.'), ('Crackling Firewood', 'This fragrance begins with top notes of herbaceous pine, balsam, and citrus bergamot; leading to middle notes of white flowers and earthy sandalwood; sitting on base notes of woodsy patchouli and violet.'), ('Cranberry Balsam', 'This fragrance has strong notes of fresh balsam fir needles, and hints of citrus; rose, nutmeg and jasmine; with bold notes of tart cranberries, and fresh greenery.'), ('Cranberry Cobbler', 'This fragrance is a combination of cranberry relish, with hints of fresh ground cinnamon sticks, orange zests, with a faint hint of vanilla and butter.'), ('Cranberry Orange', 'This fragrance is a blend of citrus notes of orange, satsuma, yuzu, and tangerine; followed by notes of cranberry, peach, and hints of spice.'), ('Cranberry Relish', 'This fragrance is a wonderful fresh, tart cranberry.'), ('Cranberry Rhubarb', 'This fragrance begins with top notes of anjou pear, Georgia peach, and juicy cranberry, followed by middle notes of black currant preserves, grapefruit zest, strawberry vine, and rhubarb; all sitting on base notes of vanilla sugar, tonka bean, and white musk.'), ('Cream Soda', 'This fragrance is an old fashioned soda shop classic having all the bubbly notes frothing over the glass with the truly characteristic, caramelized sugar and vanilla cream aroma.'), ('Creamy Chocolate Cupcake', 'This fragrance begins with creamy top notes of bittersweet chocolate and buttercream; followed by warm middle notes of corn syrup and amaretto; and well rounded with base notes of vanilla sugar, malt, dark cocoa, and espresso powder.'), ('Creamy Coconut', 'This fragrance is the aroma of creamy coconut milk.'), ('Creme Brulee', 'This fragrance is the aroma of creamy vanilla custard pudding drenched with creamy buttery caramel sauce!'), ('Crisp and Candied', 'This fragrance begins with top notes of orange peels, apples, and lemons; followed by middle notes of clove, cinnamon, and nutmeg; and well-rounded with base notes of cinnamon bark and woods.'), ('Crystal Blue Waters', 'This is the fragrance of hyacinth, hydrangea flowers, and lily of the valley; rounded out with ozony notes of fresh green ferns, vetiver, and cyclamen.'), ('Cucumber Melon', 'This fragrance is an aroma of sweet and sour cucumber and a deep green oily note with hints of violet, with a background of sweet, freshly sliced honeydew melon.'), ('Cucumber Basil Mint Martini', 'This fragrance is the blend of refreshing top notes of orange, bergamot, and lemon peel, with a heart of fresh cucumber water, fresh basil and garden mint; sitting on a gorgeous base of dry vermouth, geranium, and musk.'), ('Cucumber Cantaloupe', 'This fragrance is the aromatic blend of ripe cantaloupe, with base notes of juicy cucumber and fresh green notes.'), ('Cucumber', 'This fragrance is the aroma of sweet and sour cucumber and a deep green oily note with hints of violet.'), ('Cucumber Mint', 'This fragrance begins with top notes of garden-fresh cucumber, ripe banana, and juicy clementine; followed by middle notes of cyclamen blossoms, African violets, and Madonna lily; sitting on base notes of palm fronds, spearmint leaves, and cool peppermint.'), ('Cucumber Splash', 'This fragrance begins with top notes of cucumber, bergamot, aloe, and grapefruit; followed by middle notes of freesia, melons, paperwhites, and jasmine; well-rounded with base notes of teakwood, sandalwood, fern and oakmoss.'), ('Cucumber Wasabi', 'This fragrance begins with top notes of aldehydic fruit notes of grapefruit and lime, with middle notes of fresh cucumber, guava, and passionfruit, and base notes of wasabi, cilantro, and fern.'), ('Curved and Chiseled', 'This fragrance is a blend of fresh greens, warm wind, pepper, and finishing with mahogany and water.'), ('Happy Birthday Vanilla Cupcake', 'This fragrance begins with top notes of creme fraiche, lemon and butter; followed by middle notes of honey and buttercream; and well rounded with base notes of vanilla bean and powdered sugar.'), ('Homemade Cheesecake', 'This fragrance has base notes of graham crackers and sweet cream butter, middle notes of vanilla, sweetened condensed milk and cream cheese; with a hint of almond as a top note.'), ('Mountain Hazelnut Cafe', 'This fragrance is rich roasted hazelnut with buttery accents to compliment this roasted coffee blend. Sweet undertones of brown sugar create a caramelized effect for the beverage sensation.'), ('CanCan', 'This fragrance begins with fresh mandarin that balances with hints of apple peel to open this feminine fragrance. Jasmine, violet and lily form a floral accord that balances with woodland fern and hints of berry at the heart of this scent. A sensual blend of cashmere musk, golden amber and vanilla bean creates a romantic sweetness that surrounds the floralcy.'), ('Cashmere and Silk', 'This fragrance is a soft and sensual bouquet of creamy French vanilla with sandalwood, patchouli, and musk accented by rose, violet, apricot, and creamy coconut milk.'), ('Clean Breeze Type', 'This fragrance is a fruity floral blend of peach, watermelon, neroli and jasmine on a dry down of aquatic notes and musk.'), ('Coconut Vanilla', 'This fragrance begins with top notes of coconut, cream and sugar; followed by middle notes of rose and lily of the valley; with base notes of cedarwood and vanilla.'), ('Cool Citrus and Basil', 'This fragrance begins with top notes of Tunisian basil, California orange, Italian bergamot, and Sicilian lemon oil; followed by middle notes of damascena rose, clove bud, and ylang ylang; with base notes of precious woods and musk.'), ('Copper Hue Suntan Lotion', 'This fragrance is a wonderful arrangement of green herbs, jasmine, rose, lavender, and lilac.'), ('Cottage and Breezes', 'An incredibly fresh aroma that will remind you of the alluring scent of salt water mist, and the feeling of the warm sands beneath your feet. This aroma is a complex blend of ozonic salt water notes, floral melon notes, green amber, powdery woods, and musk. '), ('Cotton and Blossoms', 'This fragrance is a sweet and subtle blend of jasmine, violet and gardenia, with a sparkle of lemon zests on a dry down of vanilla.'), ('Daisy', 'This fragrance begins with top notes of tangy lemon and jasmine; followed by middle notes of muguet lily, rose petals, African violet, and daylily; sitting on base notes of cedarwood, patchouli, and musk to complete a wonderful daisy scent.'), ('Dance of the Sugar Plum Fairy', 'This delightful fragrance has plums, dark cherries and sweet oranges enhanced with peppery woody undertones.'), ('Dandelion Pear', 'This aroma begins with the slightly bitter aroma of dandelion, and wildflowers; perfectly mellowed out with tart fresh pear, green tea leaves, and cool aloe vera. Refreshing and clean!'), ('Dare to be Sexy', 'This fragrance is a naughty blend of sweet sensuality and sinful fruits starring in this Oh So Sexy fragrance. Luscious peach nectar, red delicious apple and ripe blood orange lead you to the sensual floral heart. Delicate muguet and pretty pink peonies are teased by a tempting black plum, and tickled with notes of musky vanilla.'), ('Dark Musk', 'Sultry amber notes embrace silky sandalwood, velvety florals and tender musks to create this smoldering oriental blend.'), ('Deadly Weapon', 'A rugged and masculine scent with the perfect balance of intense spices including black pepper, cardamom and clove with a touch of sweet mandarin set the scene for the introduction of rich leather, smooth frankincense and edgy woods.'), ('Deb's Flower Shoppe', 'This fragrance is just like walking into a flower shoppe. You can smell the aroma of all of the flowers, green stems, and water droplets on the flower petals filling the air.'), ('Democrat Fragrance', 'This unique fragrance has a very fresh greenery base of clover, ivy and aloe, combined with exciting notes of grapefruit, orange, tangerine, and persimmon.'), ('Denim', 'This fragrance is a complex blend of fresh breeze, lemon, lime, cyclamen, and water lily; sitting on base notes of soft woods, sweet amber, and sheer musk.'), ('Desire', 'Top notes of fresh citrus and vetiver and rose geranium, middle notes of jasmine, lily of the valley; and bottom notes of amber guise, vanilla, and musk.'), ('Dill Pickle', 'A true dill pickle scent with base notes of dill pickle, mid notes of parsley and cucumber and top notes of lemon.'), ('Doodle Bug', 'An aroma that will allow you to visualize yourself being a young child with a cream soda dum dum sucker stuck in your hair, sitting at the picnic table eating a piece of watermelon. Doodle Bug is a blend of cream soda, fresh watermelon slices, hubba bubba bubblegum, with a hint of new born baby.'), ('Down Home Country', 'This fragrance is a woodsy blend of fresh cedar, true patchouli, natural lavender, effervescent clove, and aromatic eucalyptus.'), ('Dr. Feel Good', 'Fresh florals of water lily, tea rose, and jasmine come together with woods and musk notes to make this scent a truly sensual blend'), ('Dragons Blood', 'This fragrance smells just like the essential oil.'), ('Dreama', 'This fragrance has top notes of oakmoss and lilies; middle notes of ylang ylang and jasmine; bottom notes of amber, musk, and sandalwood.'), ('Dreamsicle', 'This fragrance is a refreshing iced orange popsicle with a creamy vanilla filling.'), ('Dude Fragrance', 'Crisp ozone and fresh citrus create shimmering accents for this woody blend. Soft floral tones balance with a heart of cedar and sandalwood, as earthy accents of patchouli and warm spicy tones add drama. Leather and balsam combine at the base of the scent, with hints of powdery vanilla and sweet amber to complete the sensual sensation.'), ('Delicious', 'This fragrance begins with top notes of apple, cucumber, and yuzu; followed by middle notes of magnolia, tuberose, lily of the valley, and fresh cut roses; with base notes of sandalwood and white amber.'), ('Drifiting Away', 'This aroma is a refreshing blend of ozonic sea salt notes, white lilac, white lily, fresh greenery, and woodsy floral notes.'), ('Earl Grey Tea', 'This fragrance is traditional Earl Grey Tea leaves which are blended with bergamot zest and sweet herbal notes to create a refined scent that is both fresh and clean.'), ('Easter Bunny Burps', 'This vibrant blend of shimmering garden greens is highlighted with a hint of mint for a fresh sensation. A blend of spring flowers is tucked away among the green tones for added texture, while sandalwood creates glowing warmth for the blend. Hints of musk finish the fragrance.'), ('Eggnog', 'This creamy eggnog has strong notes of buttercream vanilla, with hints of cinnamon, nutmeg, and clove. Many of our customers use this scent year round by renaming it Creamy Spice.'), ('Egyptian Dragon', 'is a blend of essences of tears of myrrh, dragons blood, patchouli; with floral notes of rose and jasmine, and base notes of woodsy musk.'), ('Elderflower and Apple Blossoms', 'This feminine aroma begins with top notes of dewdrops and lemon leaves that open to elderflowers and white lilies at the heart of the scent. Orange blossoms and night-blooming jasmine linger to finish this delicate floral aroma.'), ('Elegant Diva', 'This fragrance is a beautiful powdery floral rose with soft petals of peony and warm undertones of sandalwood.'), ('Elf Sweat', 'This fragrance is a bubbly, magical blend of candy, candy canes, candy corn, and syrup, with effervescent spicy soda pop bubbles to provide a unique, magical top note.'), ('Endlessly in Love', 'This fragrance is a green fruity floral bouquet with apple, rose and jasmine top notes with a sweet woodsy musky background.'), ('English Ivy', 'A botanical accord of forest fern, green leaves and cut stems is blended with a soft floral bouquet at the heart of the scent. Earthy base notes of musk add softness to the fragrance.'), ('Eucalyptus and Spearmint', 'This fragrance is the invigorating herbal blend of eucalyptus and spearmint with fresh citrus lemon, lavender flowers, and a hint of sage.'), ('Eucalyptus', 'This fragrance is fresh picked eucalyptus leaves with hints of lime.'), ('Euphoric Majesty', 'This fragrance speaks to women who embrace sensuality and fantasy. A provocative blend of pomegranate, persimmon, green notes, black orchid, lotus blossom, liquid amber, mahogany woods, black violet, and a cream accord.'), ('Extreme Fragrance', 'This fragrance is an upscale, masculine aroma with top notes of blood orange, Sicilian bergamot, and juniper berries, followed with middle notes of petitgrain, dark amber, and patchouli; flexing its muscles with base notes of ebony woods, tonka bean, and exotic musk.'), ('Extremely Sexy for Men', 'This scent contains top notes of pink lime, bergamot leaves, and tangerine. Middle notes of cinnamon bark, limewood, and sage. Vetiver and orange flower comprise the dry down.'), ('Extremely Sexy for Women', 'This fragrance has notes of cactus flower and clementine, blackberry, and vanilla orchid. Base notes of white amber and pimento.'), ('Early Sunrise', 'This fragrance is a complex blend of just the right amount of lemon, grapefruit, clementine, green herbal floral notes, and amber woods.'), ('Exotic Coconut', 'This fragrance begins with top notes of guava, pineapple and currants, followed by middle notes of toasted coconut and vanilla, and rounded-out with base notes of Tonka beans, sandalwood, and white musk.'); create table melts( melts_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, melt_categories_id SMALLINT UNSIGNED NOT NULL, melt_scents_id SMALLINT UNSIGNED NOT NULL, price DECIMAL(6,3) NOT NULL, photo VARCHAR(100), stock_quantity MEDIUMINT UNSIGNED NOT NULL, date_added TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(melts_id), INDEX ind_melt_categories_id (melt_categories_id), CONSTRAINT fk_melt_categories_id FOREIGN KEY (melt_categories_id) REFERENCES melt_categories(melt_categories_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX fk_melt_scents_id (melt_scents_id), CONSTRAINT fk_melt_scents_id FOREIGN KEY (melt_scents_id) REFERENCES melt_scents(melt_scents_id) ON DELETE CASCADE on UPDATE CASCADE ) ENGINE = InnoDB; INSERT INTO melts (melts_id, melt_categories_id, melt_scents_id, price, photo, stock__quantity, date_added) VALUES (1, 1, 1, '3.25', './images/scents.jpg', 10, current_timestamp()), (2, 2, 2, '3.25', './images/scents.jpg', 10, current_timestamp()), (3, 1, 3, '3.25', './images/AThousandDreams.jpg', 10, current_timestamp()), (4, 10, 4, '3.25', './images/scents.jpg', 10, current_timestamp()), (5, 1, 5, '3.25', './images/AcaiBerry.jpg', 10, current_timestamp()), (6, 10, 6, '3.25', './images/scents.jpg', 10, current_timestamp()), (7, 1, 7, '3.25', './images/scents.jpg', 10, current_timestamp()), (8, 11, 8, '3.25', './images/scents.jpg', 10, current_timestamp()), (9, 2, 9, '3.25', './images/scents.jpg', 10, current_timestamp()), (10, 2, 10, '3.25', './images/AlmondMacaroon.jpg', 10, current_timestamp()), (11, 2, 11, '3.25', './images/AlmondMarzipan.jpg', 10, current_timestamp()), (12, 2, 12, '3.25', './images/AlmondRumCake.jpg', 10, current_timestamp()), (13, 1, 13, '3.25', './images/AloeVeraAndCucumber.jpg', 10, current_timestamp()), (14, 1, 14, '3.25', './images/scents.jpg', 10, current_timestamp()), (15, 6, 15, '3.25', './images/AlpineSnowDrift.jpg', 10, current_timestamp()), (16, 1, 16, '3.25', './images/scents.jpg', 10, current_timestamp()), (17, 14, 17, '3.25', './images/scents.jpg', 10, current_timestamp()), (18, 8, 18, '3.25', './images/AmazinglyGrace.jpg', 10, current_timestamp()), (19, 12, 19, '3.25', './images/AmberWaters.jpg', 10, current_timestamp()), (20, 12, 20, '3.25', './images/scents.jpg', 10, current_timestamp()), (21, 10, 21, '3.25', './images/scents.jpg', 10, current_timestamp()), (22, 1, 22, '3.25', './images/scents.jpg', 10, current_timestamp()), (23, 8, 23, '3.25', './images/scents.jpg', 10, current_timestamp()), (24, 8, 24, '3.25', './images/AngelWings.jpg', 10, current_timestamp()), (25, 8, 25, '3.25', './images/Angelica.jpg', 10, current_timestamp()); (26, 2, 26, '5.00', './images/scents.jpg', 10, current_timestamp()), (27, 2, 27, '5.00', './images/scents.jpg', 10, current_timestamp()), (28, 2, 28, '5.00', './images/scents.jpg', 10, current_timestamp()), (29, 2, 29, '5.00', './images/scents.jpg', 10, current_timestamp()), (30, 2, 30, '5.00', './images/scents.jpg', 10, current_timestamp()), (31, 2, 31, '5.00', './images/scents.jpg', 10, current_timestamp()), (32, 2, 32, '5.00', './images/scents.jpg', 10, current_timestamp()), (33, 2, 33, '5.00', './images/scents.jpg', 10, current_timestamp()), (34, 2, 34, '5.00', './images/scents.jpg', 10, current_timestamp()), (35, 2, 35, '5.00', './images/scents.jpg', 10, current_timestamp()); (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 2, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), (1, 1, 1, '5.00', '', 10, current_timestamp()), create table melt_orders_melts( melt_orders_melts_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, melt_orders_id INT UNSIGNED NOT NULL, melts_id MEDIUMINT UNSIGNED NOT NULL, quantity TINYINT UNSIGNED NOT NULL, price DECIMAL(7,3) NOT NULL, PRIMARY KEY(melt_orders_melts_id), INDEX ind_melt_orders_id (melt_orders_id), CONSTRAINT fk_melt_orders_id FOREIGN KEY (melt_orders_id) REFERENCES melt_orders(melt_orders_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melts_id (melts_id), CONSTRAINT fk_melts_id FOREIGN KEY (melts_id) REFERENCES melts(melts_id) ON DELETE CASCADE on UPDATE CASCADE ) ENGINE = InnoDB; create table melt_carts( melt_carts_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, melt_customers_id MEDIUMINT UNSIGNED NOT NULL, melts_id MEDIUMINT UNSIGNED NOT NULL, quantity TINYINT UNSIGNED NOT NULL, date_added TIMESTAMP NOT NULL, date_modified TIMESTAMP NOT NULL, PRIMARY KEY(melt_carts_id), INDEX ind_melt_customers_id (melt_customers_id), CONSTRAINT fk_carts_melt_customers_id FOREIGN KEY (melt_customers_id) REFERENCES melt_customers(melt_customers_id) ON DELETE CASCADE on UPDATE CASCADE, INDEX ind_melts_id (melts_id), CONSTRAINT fk_carts_melts_id FOREIGN KEY (melts_id) REFERENCES melts(melts_id) ON DELETE CASCADE on UPDATE CASCADE ) ENGINE = InnoDB; STRIPE - application (payment form) Due Thursday 1:30pm: Some form of a payment, style differently,