[richfaces-svn-commits] JBoss Rich Faces SVN: r12523 - in trunk/test-applications/realworld: web/src/main/webapp/WEB-INF/Upload and 3 other directories.

Author: alevkovsky Date: 2009-02-02 11:26:54 -0500 (Mon, 02 Feb 2009) New Revision: 12523 Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/ trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/ trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/ trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_mini.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_medium.jpg trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_mini.jpg Modified: trunk/test-applications/realworld/ejb/src/main/resources/import.sql Log: Add user with photos Modified: trunk/test-applications/realworld/ejb/src/main/resources/import.sql =================================================================== --- trunk/test-applications/realworld/ejb/src/main/resources/import.sql 2009-02-02 16:08:33 UTC (rev 12522) +++ trunk/test-applications/realworld/ejb/src/main/resources/import.sql 2009-02-02 16:26:54 UTC (rev 12523) @@ -2,6 +2,7 @@ INSERT INTO Users(user_id, firstname, secondname, email, login, password, birthdate) VALUES (2, 'Andrey', 'Markhel', 'amarkhel(a)exadel.com', 'root', '12345', '1985-01-08'); INSERT INTO Users(user_id, firstname, secondname, email, login, password, birthdate) VALUES (3, 'Andrey', 'Markhel', 'amarkhel(a)exadel.com', 'qqqq', '12345', '1985-01-08'); INSERT INTO Users(user_id, firstname, secondname, email, login, password, birthdate) VALUES (4, 'Andrey', 'Markhel', 'amarkhel(a)exadel.com', 'sss', '12345', '1985-01-08'); +INSERT INTO Users(user_id, firstname, secondname, email, login, password, birthdate) VALUES (6, 'User', 'User', 'alevkovsky(a)exadel.com', 'user', '12345', '1985-01-01'); INSERT INTO Users(user_id, firstname, secondname, email, login, password, birthdate) VALUES (5, 'Barak', 'Abama', 'amarkavtsov(a)exadel.com', 'admin', '12345', '1985-01-08'); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (1, 'Cars', 'Photo of my dog', true, 1, null); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (2, 'Tetki', 'Simple Album 2', true, 1, null); @@ -10,6 +11,8 @@ INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (5, 'Music', 'Simple Album 2', false, 3, null); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (6, 'Child1', 'Simple Album 2', true, 1, 1); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (7, 'Child2', 'Simple Album 2', true, 1, 1); +INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (11, 'Water', 'Water Fotos', true, 6, null); +INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (12, 'Bmw', 'BMW Cars Fotos', true, 6, null); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (8, 'Album1', 'Favotite', true, 5, null); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (9, 'Planes', 'Planes', true, 5, null); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (10, 'Moon', 'Moon', true, 5, 8); @@ -61,6 +64,27 @@ INSERT INTO Ranks(rank_id, total, hits) VALUES (46, 98, 19); INSERT INTO Ranks(rank_id, total, hits) VALUES (47, 2, 40); INSERT INTO Ranks(rank_id, total, hits) VALUES (48, 200, 36); +INSERT INTO Ranks(rank_id, total, hits) VALUES (49, 180, 31); +INSERT INTO Ranks(rank_id, total, hits) VALUES (50, 95, 11); +INSERT INTO Ranks(rank_id, total, hits) VALUES (51, 80, 10); +INSERT INTO Ranks(rank_id, total, hits) VALUES (52, 98, 13); +INSERT INTO Ranks(rank_id, total, hits) VALUES (53, 110, 21); +INSERT INTO Ranks(rank_id, total, hits) VALUES (54, 100, 12); +INSERT INTO Ranks(rank_id, total, hits) VALUES (55, 102, 18); +INSERT INTO Ranks(rank_id, total, hits) VALUES (56, 98, 19); +INSERT INTO Ranks(rank_id, total, hits) VALUES (57, 2, 40); +INSERT INTO Ranks(rank_id, total, hits) VALUES (58, 200, 36); +INSERT INTO Ranks(rank_id, total, hits) VALUES (59, 180, 31); +INSERT INTO Ranks(rank_id, total, hits) VALUES (60, 95, 11); +INSERT INTO Ranks(rank_id, total, hits) VALUES (61, 80, 10); +INSERT INTO Ranks(rank_id, total, hits) VALUES (62, 98, 13); +INSERT INTO Ranks(rank_id, total, hits) VALUES (63, 110, 21); +INSERT INTO Ranks(rank_id, total, hits) VALUES (64, 100, 12); +INSERT INTO Ranks(rank_id, total, hits) VALUES (65, 102, 18); +INSERT INTO Ranks(rank_id, total, hits) VALUES (66, 98, 19); +INSERT INTO Ranks(rank_id, total, hits) VALUES (67, 2, 40); +INSERT INTO Ranks(rank_id, total, hits) VALUES (68, 200, 36); + INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (1, 'Aston Martin', 'amarkhel/Cars/aston_martin.jpg', 'Where is the Batman?', '2008-12-18', 1, 1,'Canon S3', 500, 20, 375, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (2, 'Ferrari', 'amarkhel/Cars/ferrari_profile.jpg', 'Beauty!', '2008-12-18', 1, 2,'Canon S3', 500, 37.5, 314, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (3, 'Australian supercar', 'amarkhel/Cars/holden-efijy-1809.jpg', 'This one glitters in my garage ;)', '2008-12-18', 1, 3,'Canon S3', 450, 28.1, 221, '2008-12-01'); @@ -109,6 +133,29 @@ INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (46, 'Plane3', 'admin/Planes/images3.jpg', 'Planes pictures', '2008-12-18', 9, 46,'Canon S3', 1024, 45.0, 768, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (47, 'Plane4', 'admin/Planes/images4.jpg', 'Planes pictures', '2008-12-18', 9, 47,'Canon S3', 1024, 78.7, 768, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (48, 'Plane4', 'admin/Planes/images5.jpg', 'Planes pictures', '2008-12-18', 9, 48,'Canon S3', 1024, 50.8, 768, '2008-12-01'); + + +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (49, 'Water1', 'user/Water/P4020733.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 49,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (50, 'Water2', 'user/Water/P4300975.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 50,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (51, 'Water3', 'user/Water/P5081081.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 51,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (52, 'Water4', 'user/Water/P6191535.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 52,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (53, 'Water5', 'user/Water/P6191547.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 53,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (54, 'Water6', 'user/Water/P7121703.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 54,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (55, 'Water7', 'user/Water/P7231757.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 55,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (56, 'Water8', 'user/Water/Spa53749.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 56,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (57, 'Water9', 'user/Water/SPA537441.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 57,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (58, 'Water10', 'user/Water/Spa53740.jpg', 'Belorussian lakes and rivers', '2008-12-18', 11, 58,'Canon S3', 768, 100.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (59, 'Bmw1', 'user/Bmw/bmw-5-e39-535i-1.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 59,'Canon S3', 600, 89.0, 800, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (60, 'Bmw2', 'user/Bmw/bmw-5-e39-535i-2.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 60,'Canon S3', 600, 137.0, 800, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (61, 'Bmw3', 'user/Bmw/bmw-5-e39-535i-3.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 61,'Canon S3', 600, 116.0, 800, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (62, 'Bmw4', 'user/Bmw/bmw-5-e39-535i-4.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 62,'Canon S3', 624, 133.0, 832, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (63, 'Bmw5', 'user/Bmw/bmw-5-e39-535i-6.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 63,'Canon S3', 624, 97.0, 832, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (64, 'Bmw6', 'user/Bmw/bmw-5-e39-535i-7.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 64,'Canon S3', 624, 100.0, 832, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (65, 'Bmw7', 'user/Bmw/bmw-5-e39-535i-8.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 65,'Canon S3', 546, 96.0, 728, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (66, 'Bmw8', 'user/Bmw/bmw_525i_sedan_1.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 66,'Canon S3', 768, 284.0, 1024, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (67, 'Bmw9', 'user/Bmw/bmw_530i_3.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 67,'Canon S3', 1200, 157.0, 1600, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (68, 'Bmw10', 'user/Bmw/bmw_m5_sedan_2.jpg', 'BMW 5-series sedan', '2008-12-18', 12, 68,'Canon S3', 768, 152.0, 1024, '2008-12-01'); + INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (1, 'Beach', 1); INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (22, 'Sun', 1); INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (23, 'Summer', 1); @@ -135,6 +182,28 @@ INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (19, 'friend', 18); INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (20, 'Cool', 19); INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (21, 'Cool2', 20); + +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (22, 'Cool', 49); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (23, 'Cool', 50); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (24, 'Cool', 51); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (25, 'Cool', 52); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (26, 'Cool', 53); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (27, 'Cool', 54); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (28, 'Cool', 55); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (29, 'Cool', 56); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (30, 'Cool', 57); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (31, 'Cool', 58); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (32, 'Car', 59); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (33, 'Car', 60); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (34, 'Car', 61); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (35, 'Car', 62); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (36, 'Car', 63); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (37, 'Car', 64); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (38, 'Car', 65); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (39, 'Car', 66); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (40, 'Car', 67); +INSERT INTO metatags(metatag_id, tag, image_metatag_id) VALUES (41, 'Car', 68); + INSERT INTO comments(comment_id, date, message, image_comment_id, from_user_id) VALUES (1, '1985-01-08', 'Hello I am user', 1, 2); INSERT INTO comments(comment_id, date, message, image_comment_id, from_user_id) VALUES (2, '1985-01-08', 'Hello I am user2', 1, 3); INSERT INTO messages(message_id, date, message, author_id, owner_id, readed, theme, friendshipRequest) VALUES (1, '1985-01-08', 'Hello I am user', 2, 1, false, 'Hello, amarkhel', false); Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-1_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-2_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-3_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-4_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-6_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-7_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw-5-e39-535i-8_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_525i_sedan_1_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_530i_3_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/BMW/bmw_m5_sedan_2_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4020733_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P4300975_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P5081081_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191535_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P6191547_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7121703_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/P7231757_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53740_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA537441_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_medium.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_medium.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg Added: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_mini.jpg =================================================================== (Binary files differ) Property changes on: trunk/test-applications/realworld/web/src/main/webapp/WEB-INF/Upload/user/Water/SPA53749_mini.jpg ___________________________________________________________________ Name: svn:mime-type + image/jpeg