Stuff

INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Leonardo', 'Da Vinci', 'Renaissance', 'Italy', 'scientist, mathematician, engineer, inventor, anatomist, painter, sculptor, architect, botanist, musician and writer.', '1452-04-15', '1519-05-02');
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Michelangelo', 'Buonarotti', 'Renaissance', 'Italy', 'painter, sculptor, architect, poet and engineer', '1475-03-06', '1564-02-18'); 
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Dominikos', 'Theotokopoulos', 'Renaissance', 'Spain', 'painter, sculptor, and architect', '1541-1-1', '1614-04-07');
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Pablo', 'Picasso', '20th century', 'Italy', 'painter and sculptor, cubism', '1881-10-25', '1973-04-08');
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Salvador', 'Dali', '20th century', 'Spain', 'Spanish surrealist painter', '1904-05-11', '1989-01-23');
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Claud', 'Monet', '19th century', 'France', 'Impressionist painter', '1840-11-14', '1926-12-05'); 
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Auguste', 'Rodin', '19th century', 'France', 'Modern Sculptor', '1840-10-12', '1917-10-17'); 
INSERT INTO artist (art_onoma,art_eponymo,art_epoxi,art_xwra,art_perigrafi,art_im_genn,art_im_than) VALUES ('Vincent', 'Van Gogh', '19th century', 'Holland', 'Post-impresionist painter', '1853-03-30', '1890-07-29');
--SELECT * FROM artist;


INSERT INTO syllogh (syl_onoma,syl_perigrafh) VALUES ('Best artists of all times', 'This collection features works of renowed artists from all over the world.');


--da vinci
INSERT INTO antik (at_perigrafh, at_titlos, at_se_ekthesh, at_kwd_syl) VALUES ('Mona Lisa, or La Gioconda (La Joconde) is a 16th-century portrait painted in oil on a poplar panel by Leonardo Da Vinci during the Italian Renaissance. It is arguably the most famous painting in the world, and few other works of art have been subject to as much scrutiny, study, mythologizing and parody. It is owned by the French government and hangs in the Musée du Louvre in Paris, France with the title Portrait of Lisa Gherardini, wife of Francesco del Giocondo. The painting, a half-length portrait, depicts a woman whose gaze meets the viewer''s with an expression often described as enigmatic. The ambiguity of the sitter''s expression, the monumentality of the half-figure composition, and the subtle modeling of forms and atmospheric illusionism were novel qualities that have contributed to the painting''s continuing fascination.', 'Mona Lisa', 'TRUE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Mona Lisa'), 'sexy', 'sexy pinakas');
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Mona Lisa'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Da Vinci'), '1506'); 
--el greco
INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_se_ekthesh, at_kwd_syl) VALUES ('The Assumption of the Virgin (1577–1579, oil on canvas, 401 × 228 cm, Art Institute of Chicago) was one of the nine paintings El Greco completed for the church of Santo Domingo el Antiguo in Toledo, his first commission in Spain.', 'THe Assumption of the Virgin','Oil on canvas','Spain', 'Renaissance', '401', '228', 'FALSE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'THe Assumption of the Virgin'), 'relegious', 'renaissance');
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROm antik WHERE at_titlos = 'THe Assumption of the Virgin'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Theotokopoulos'), '1579' );

--van gogh
INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_se_ekthesh, at_kwd_syl) VALUES ('The portraits were painted in Auvers-sur-Oise close to Paris, and depict Doctor Paul Gachet with a foxglove plant. Gachet took care of van Gogh during the artist''s last months. Gachet was a hobby painter and became good friends with van Gogh.', 'Portrait of Dr. Gachet', 'Oil on canvas', 'Holland', 'Post-Renaissance', '67', '56', 'FALSE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Portrait of Dr. Gachet'), 'portrait', 'modern'); 
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Portrait of Dr. Gachet'), (SELECT art_kwdikos FROM artist WHERE art_eponymo = 'Van Gogh'), '1890');

--picasso
INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_se_ekthesh, at_kwd_syl) VALUES ('Guernica is a painting by Pablo Picasso, depicting the Nazi German bombing of Guernica, Spain, by twenty-eight bombers, on April 26, 1937 during the Spanish Civil War. The attack killed between 250 and 1,600 people, and many more were injured.', 'Guernica', 'Oil on canvas', 'Spain', 'Cubism', '349', '776', 'FALSE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'Guernica'), 'scenery', 'modern');
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Guernica'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Picasso'),'1937');

INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_se_ekthesh, at_kwd_syl) VALUES ('Les Demoiselles d Avignon (The Young Ladies of Avignon in English) is a celebrated painting by Pablo Picasso that depicts five prostitutes in a brothel, in Avignon Street in Barcelona, though, as usual with Picasso, the name was not given it until well after completion.', 'The Young Ladies of Avignon', 'Oil on canvas', 'Spain', 'Cubism', '243', '233', 'FALSE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'The Young Ladies of Avignon'), 'portrait', 'modern');
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Young Ladies of Avignon'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Picasso'),'1937');

--dali
INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_se_ekthesh, at_kwd_syl) VALUES ('La persistencia de la memoria (1931) or The Persistence of Memory is the most famous painting by artist Salvador Dalí. The painting has also been popularly known as Soft Watches, Droopy Watches, The Persistence of Time or Melting Clocks. It has been owned by the Museum of Modern Art (MoMA) in New York City since 1934. It is, however, currently on display at the Salvador Dalí Museum, in St. Petersburg, Florida, (February 1–June 1, 2008). The Persistence of Memory will return to Museum of Modern Art in June 2008 as part of the exhibition Dalí and Film, on view June 29–September 15, 2008.', 'The Persistence of Memory', 'Oil on canvas', 'Spain', 'Modern', '24', '33', 'FALSE', '1');
INSERT INTO pinakas (pin_at_kwdikos, pin_typos, pin_texnotr) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos = 'The Persistence of Memory'), 'abstract', 'surrealistic');
INSERT INTO filot_apo (fa_at_kwdikos, fa_art_kwdik, fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Persistence of Memory'),(SELECT art_kwdikos FROM artist WHERE art_eponymo='Dali'),'1931');

--rodin
INSERT INTO antik (at_perigrafh, at_titlos, at_yliko, at_katagwgh, at_epoxh, at_ypsos, at_platos, at_paxos, at_se_ekthesh, at_kwd_syl) VALUES ('The Thinker (French: Le Penseur) is a bronze and marble sculpture by Auguste Rodin, held in the Musée Rodin, in Paris. It depicts a man in sober meditation battling with a powerful internal struggle. It is often used to represent philosophy.', 'The Thinker', 'Bronze Statue', 'France', 'Modern', '1', '2', '3', 'FALSE', '1');
INSERT INTO filot_apo (fa_at_kwdikos,fa_art_kwdik,fa_date) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Thinker'), (SELECT art_kwdikos FROM artist WHERE art_eponymo='Rodin'),'1937');
INSERT INTO glypto (gl_at_kwdikos,gl_texnotr,gl_is_statue) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Thinker'), 'Modern', 'TRUE');


SELECT * FROM antik;
SELECT * FROM pinakas;
SELECT * FROM filot_apo;
SELECT * FROM glypto;

INSERT INTO ekthesi (ekth_onoma,ekth_thema,ekth_ticket,ekth_visitors,ekth_im_enarks,ekth_im_liks) VALUES ('A retrospective on Picasso', 'This is a retrospective display of Picasso', '5', '1400', '2006-12-2', '2007-3-26');

--SELECT * FROM ekthesi;


INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='Guernica'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='A retrospective on Picasso'));
INSERT INTO ektith (ekth_at_kwdikos,ekth_ekth_kwdikos) VALUES ((SELECT at_kwdikos FROM antik WHERE at_titlos='The Young Ladies of Avignon'), (SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='A retrospective on Picasso'));

--SELECT * FROM ektith;


INSERT INTO meso (mes_onoma,mes_typos) VALUES ('ET1', 'TV');


INSERT INTO diafimisi (diaf_ekth_kwdik,diaf_mes_kwdik,diaf_date,diaf_kostos) VALUES ((SELECT ekth_kwdikos FROM ekthesi WHERE ekth_onoma='A retrospective on Picasso'), (SELECT mes_kwdikos FROM meso WHERE mes_onoma='ET1'), '2007-01-15', '10000');