INSERT INTO size (width,height) VALUES (30,41),(46,61),(61,81),(76,102),(91,122),(107,142); (41,30),(61,46),(81,61),(102,76),(122,91),(142,107),(30,41),(46,61),(61,81),(76,102),(91,122),(107,142); INSERT INTO category (category) VALUES ('fine art'),('decorative art'),('vintage art'),('photography'); INSERT INTO artist (last_name,first_name) VALUES ('Picaso','Pablo'), ('Van Gogh','Vincent'), ('Klimt','Gustav'), ('Lynch','Brent'), ('Klung','Mike'), ('Maitland','Laurie'), ('Schiele','Egon'), ('White','Rodney'), ('Barrett','Chad'), ('Cappiello','Leonetto'), ('Gehman','Raymond'), ('Silberman','Henri'), ('Guion','William'), ('Meyers','Steven'); INSERT INTO general_print (name,description,default_price,image_name,artistCreates,printInCategories) VALUES ('Mediterranean Landscape','Pablo Picasso (1881 – 1973) was an artistic virtuoso who co–founded Cubism, and produced an astounding 20,000 paintings, prints, drawings and sculptures during his brilliant 70–year career. Picasso‘s unparalleled body of work was so vast, and its phases so unique, that art historians have divided it into specific periods. A child prodigy, Picasso took advanced classes at the Royal Academy of Art in Barcelona when he was only 15. His revolutionary Cubist works, with their distorted shapes and fragmented forms, established art as a genre that does not need to literally represent reality. Zealously embracing every medium from primitive art to sketches to Surrealism, Picasso had an unrivaled influence upon 20th century art.',29.99,'mediterranean_landscape.jpg',1,1), ('Almond Branches in Bloom, San Remy, c.1890','Vincent Van Gogh‘s exquisite “Almond Blossom,” which he painted for his newborn nephew as a symbol of budding life, embraced one of his favorite subjects: flowering branches against a blue sky. Epitomizing the tormented artist, Van Gogh (1853 – 1890) was a post–Impressionist Master whose fragile psyche was uplifted by the healing effects of painting outdoors. Extraordinarily prolific, Van Gogh produced all of his works during a 10–year period–at one point, creating an astonishing 150 paintings and drawings within one year. Although Van Gogh only sold one painting within his lifetime, he profoundly influenced modern Expressionism, Fauvism and Early Abstraction.',19.99,'almond_branches.jpg',2,1), ('Irises, Saint-Remy, c.1889','Description: “Irises, Saint-Remy, 1889,” by post-Impressionist Grand Master Vincent Van Gogh (1853 – 1890), depicts the garden of the hospital where he was a recuperating, and was painted a few months before he died. Suffering from depression for most of his life, Van Gogh called this painting “the lightning conductor for my illness,” because he felt he could keep himself well by continuing to paint. The work was influenced by Japanese ukiyo-e woodblock prints, containing strong outlines, unusual angles, and non-literal coloring. Although Van Gogh only sold one painting in his lifetime, “Irises, Saint-Remy” was sold for $49 million in 1987, setting a world record.',14.99,'irises.jpg',2,1), ('The Tree of Life, Stoclet Frieze, c.1909','Symbolizing spiritual enlightenment and the union of heaven and earth, “Tree of Life” portrays a universal motif in a unique context of curlicues and gleaming gold leaf. Created by renowned Viennese Secession and Art Nouveau genius Gustav Klimt (1862-1918), the piece features the lavish ornamentation and gold embellishments prominent in his work. A forerunner of Modernism and the Art Deco movements, Klimt’s enormous creative influence still resonates in modern art, decorations and jewelry.',29.99,'tree_of_life.jpg',3,1), ('Evening Lounge','Description: Smoldering and sultry, a mysterious woman captures our attention in Brent Lynch‘s “Evening Lounge.” Lynch, a powerful figurative and landscape artist, is known for pushing the envelope with passionate imagery and daring innovation. Here, he uses intense reds, blacks and grays rendered in bold brushstrokes, and an interplay of shadow and light to create a narrative around his subject. “Evening Lounge” would be intriguingly offset by its “sister” painting, “Cigar Bar.”',27.99,'evening_lounge.jpg',4,2), ('Cigar Bar','A mysterious stranger captures our attention in Brent Lynch‘s “Cigar Bar.” Lynch, a powerful figurative and landscape artist, is known for pushing the envelope with passionate imagery and daring innovation. Here, he uses bold brushstrokes of intense reds, blacks and grays, while unsaturated yellow adds subtle warmth that draws the viewer into the story. “Cigar Bar” pairs beautifully with its sister painting, “Evening Lounge”.',27.99,'cigar_bar.jpg',4,2), ('Morning Luster 1','Mike Klung‘s multimedia compositions are in a class of their own. A self–taught artist from Baton Rouge, Louisiana, Klung spent 14 years as a framer and matte designer before he took up painting. Inspired by the sublime beauty of the native Louisiana woods, he lovingly depicts tree–filled landscapes. Klung‘s technique juxtaposes layers paint with untraditional materials such as leaves, wood and screens that together create a texturized, three–dimensional appearance.','29.99','morning_luster1.jpg',5,2), ('Symphony in Red and Khaki I','Abstract artist Laurie Maitland‘s stormy “Symphony in Red and Khaki I” is a visual drama. Its intensity is reflective of Maitland’s early theatrical influences. “Symphony in Red and Khaki I” is rich in bold colors lashed with filaments of white and black and pairs well with “Symphony in Red and Khaki II.” ',27.99,'symphony_in_red.jpg',6,2), ('Four Trees, 1917','The bodily distortions, explicit eroticism and anguish which made Egon Schiele‘s artworks unpopular during his lifetime are the same features which make them so mesmerizing today. Schiele (1890 – 1918) was an exceptionally prolific Austrian Expressionist who was a protégé of Gustav Klimt, and whose formidable talents were fully matured when he was a teenager. He created emotionally charged self–portraits and allegories, but was best–known for his nude or semi–nude drawings of women, portraying them in awkwardly contracted poses to convey distress. Arrested for immorality and seduction, he created numerous watercolors and drawings during his two–week imprisonment. Dying prematurely from the Spanish flu, Schiele left a legacy of almost 3,500 compelling artworks.',25.99,'four_trees.jpg',7,2), ('Life Needs More Green Lights','Description: Rodney White gives his painting “Life Needs More Green Lights,” the richly weathered look of an old advertisement with a wry slogan for the person who likes the open road. An Atlanta-based artist, White uses the influence and appearance of an advertisement to promote positive messages instead of products. Believing that the past contains valuable lessons, he replicates surfaces and objects that have an “aged, experienced look” which he gets from flea markets, antique shops, old buildings, packages and time-worn paper.',33.99,'life_needs_more.jpg',8,3), ('Nothing to Dream','Description: Atlanta-based contemporary artist Rodney White is known for his richly weathered, urban retooling of retro ads that are partially obscured, like ideas that are on the verge of being attained. White uses the influential appearance of an advertisement in his art to promote positive messages instead of products. Believing that the past contains valuable lessons, he replicates surfaces and objects that have an “aged, experienced look.” White’s uplifting imagery is inspired by flea markets, antique shops, old buildings, packages and time-worn paper.',29.99,'nothing_to_dream.jpg',8,3), ('Gilded Songbird III','Elegance and period style are the hallmarks of the artworks of Chad Barrett. With degrees in painting and art history from the Savannah College of Art and Design, Barrett embraces classical painting techniques offset by traditional Southern decorative motifs. Drawing inspiration from 19th century botanicals, Barrett also creates country landscapes brimming with shapes and movement, still-lifes and refined period-style portraits. Infusing his work with construction and deconstruction, Barrett’s universally appealing art blends both the original and the familiar.',7.99,'gilded_songbird.jpg',9,3), ('Asti Cinzano, c.1920','Description: The advertising poster “Asti Cinzano” by Leonetto Cappiello (1875 – 1942) is as bubbly as the product it is advertising, with its bold color, whirlwind movement, and unbridled revelry. Creating highly effective ads which are also visually stunning, the self-taught Cappiello revolutionized the art of poster design, creating nearly 1000 works in the process. A former caricaturist, Cappiello took 19th century images and, using a “less-is-more” philosophy that is still the used by modern lithographers, made them relevant to the faster-paced 20th century world.',24.99,'asti_cinzano.jpg',10,3), ('Bare Branches and Red Maple Leaves Growing Alongside the Highway','A photographer for “National Geographic,” Raymond Gehman has traveled the world capturing stunning images which exalt both the astounding and the ordinary in nature and humanity. Gehman, who is a “National Geographic” editor and has been shooting for them for 20 years, was 9 years old when one of the magazine’s photographers visited his school inspiring him to pursue photography. Gehman says photography is special because it expresses everyone’s unique view of the world, and he enjoys depicting “the little weird details.” Residing in Waynesboro, Pennsylvania, Gehman also lectures and judges photo contests.',30.99,'bare_branches.jpg',11,4), ('New York, New York, Brooklyn Bridge','New York’s Brooklyn Bridge—and Twin Towers—are immortalized in this photographic time capsule by Henri Silberman. Born in Paris and raised in Brooklyn, Silberman eloquently depicts the urban landscape. This print’s clean lines, striking clarity and magical nostalgia would add elegance to any room.',13.99,'new_york.jpg',12,4), ('Oak Alley, West Row','As the fog rolls in diffusing the light with enchanting allure, photographer Williams Guion sensitively captures the beauty and grace of mystical, majestic oaks, enhanced by the landscape’s quietude. Guion, a Louisiana native retains his childhood fascination with these elder trees of the American landscape that he shoots throughout the South and the West. A landscape photographer for 20 years, Guion is greatly influenced by the West Coast’s large format black and white of the late 80’s. A sampling of his work has been published in his first book, Heartwood, Meditations on Southern Oaks.',27.99,'oak_alley.jpg',13,4), ('Eucalyptus','The secret inner beauty that lives beneath a flower’s surface is etched like diaphanous butterfly wings in Steven Meyers’ “Eucalyptus.” A medical radiology technologist for 25 years, Meyers began experimenting with floral X-rays in 1975, now peruses the grocery store for new radiographic subjects. Diverging from the traditional landscapes that he originally photographed, Meyers entered the virtually unexplored world of X-ray photography, which reveals otherwise invisible textures, details and shadows through negatives, positives, and combinations of the two.',19.99,'eucalyptus.jpg',14,4); INSERT INTO specific_print (specific_price,general_printHasManyspecific_print,specificPrintHasSize) VALUES (29.99,1,1),(32.99,1,2),(40.49,1,3),(52.48,1,4),(59.98,1,5),(74.95,1,6), (19.99,2,1),(21.99,2,2),(26.98,2,3),(34.98,2,4),(39.98,2,5),(49.98,2,6), (14.99,3,7),(16.49,3,8),(20.24,3,9),(26.23,3,10),(29.98,3,11),(37.48,3,12), (29.99,4,1),(32.99,4,2),(40.49,4,3),(52.48,4,4),(59.98,4,5),(74.98,4,6), (27.99,5,7),(30.79,5,8),(37.79,5,9),(48.98,5,10),(55.98,5,11),(69.98,5,12), (27.99,6,7),(30.79,6,8),(37.79,6,9),(48.98,6,10),(55.98,6,11),(69.98,6,12), (29.99,7,1),(32.99,7,2),(40.49,7,3),(52.48,7,4),(59.98,7,5),(74.98,7,6), (27.99,8,1),(30.79,8,2),(37.79,8,3),(48.98,8,4),(55.98,8,5),(67.98,8,6), (25.99,9,1),(28.59,9,2),(35.09,9,3),(45.48,9,4),(51.98,9,5),(64.98,9,6), (33.99,10,1),(37.98,10,2),(45.89,10,3),(59.48,10,4),(67.98,10,5),(87.98,10,6), (29.99,11,7),(32.99,11,8),(40.49,11,9),(52.48,11,10),(59.98,11,11),(74.98,11,12), (7.99,12,7),(8.79,12,8),(10.79,12,9),(13.98,12,10),(15.98,12,11),(19.98,12,12), (24.99,13,7),(27.49,13,8),(33.79,13,9),(43.73,13,10),(49.98,13,11),(62.48,13,12), (30.99,14,1),(34.09,14,2),(41.84,14,3),(54.23,14,4),(61.98,14,5),(77.48,14,6), (13.99,15,1),(15.39,15,2),(18.89,15,3),(24.48,15,4),(27.98,15,5),(34.98,15,6), (27.99,16,7),(30.79,16,8),(37.79,16,9),(48.98,16,10),(55.98,16,11),(69.98,16,12), (19.99,17,7),(21.99,17,8),(26.99,17,9),(34.98,17,10),(39.98,17,11),(49.98,17,12);