[richfaces-svn-commits] JBoss Rich Faces SVN: r12518 - trunk/test-applications/realworld/ejb/src/main/resources.

Author: andrei_exadel Date: 2009-02-02 09:30:36 -0500 (Mon, 02 Feb 2009) New Revision: 12518 Modified: trunk/test-applications/realworld/ejb/src/main/resources/import.sql Log: New user added Modified: trunk/test-applications/realworld/ejb/src/main/resources/import.sql =================================================================== --- trunk/test-applications/realworld/ejb/src/main/resources/import.sql 2009-02-02 14:30:12 UTC (rev 12517) +++ trunk/test-applications/realworld/ejb/src/main/resources/import.sql 2009-02-02 14:30:36 UTC (rev 12518) @@ -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 (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); INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_album_id) VALUES (3, 'Football', 'Simple Album 3', true, 2, null); @@ -9,6 +10,9 @@ 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 (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); INSERT INTO Ranks(rank_id, total, hits) VALUES (1, 100, 21); INSERT INTO Ranks(rank_id, total, hits) VALUES (2, 200, 21); INSERT INTO Ranks(rank_id, total, hits) VALUES (3, 100, 31); @@ -40,7 +44,23 @@ INSERT INTO Ranks(rank_id, total, hits) VALUES (29, 104, 29); INSERT INTO Ranks(rank_id, total, hits) VALUES (30, 100, 30); INSERT INTO Ranks(rank_id, total, hits) VALUES (31, 110, 31); - +INSERT INTO Ranks(rank_id, total, hits) VALUES (32, 110, 10); +INSERT INTO Ranks(rank_id, total, hits) VALUES (33, 100, 15); +INSERT INTO Ranks(rank_id, total, hits) VALUES (34, 200, 48); +INSERT INTO Ranks(rank_id, total, hits) VALUES (35, 350, 20); +INSERT INTO Ranks(rank_id, total, hits) VALUES (36, 450, 46); +INSERT INTO Ranks(rank_id, total, hits) VALUES (37, 120, 33); +INSERT INTO Ranks(rank_id, total, hits) VALUES (38, 130, 37); +INSERT INTO Ranks(rank_id, total, hits) VALUES (39, 180, 31); +INSERT INTO Ranks(rank_id, total, hits) VALUES (40, 95, 11); +INSERT INTO Ranks(rank_id, total, hits) VALUES (41, 80, 10); +INSERT INTO Ranks(rank_id, total, hits) VALUES (42, 98, 13); +INSERT INTO Ranks(rank_id, total, hits) VALUES (43, 110, 21); +INSERT INTO Ranks(rank_id, total, hits) VALUES (44, 100, 12); +INSERT INTO Ranks(rank_id, total, hits) VALUES (45, 102, 18); +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 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'); @@ -72,6 +92,23 @@ INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (29, 'Street musician', 'qqqq/Music/StreetMusician.jpg', 'unknown musician', '2008-12-18', 5, 29,'Canon S3', 336, 60.5, 500, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (30, 'SOAD', 'qqqq/Music/system-of-a-down.jpg', 'Try not to loose your innervision!', '2008-12-18', 5, 30,'Canon S3', 500, 39.5, 323, '2008-12-01'); INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (31, 'Amon Tobin', 'qqqq/Music/tobin.jpg', 'Brasilian, works in London. Try his "Supermodified2000" album', '2008-12-18', 5, 31,'Canon S3', 450, 37, 302, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (32, 'Cat', 'admin/Album1/images.jpg', 'Crazy Cats', '2008-12-18', 8, 32,'Canon S3', 452, 20.2, 393, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (33, 'Cat1', 'admin/Album1/images2.jpg', 'Crazy Cats', '2008-12-18', 8, 33,'Canon S3', 800, 92.2, 600, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (34, 'Cat2', 'admin/Album1/images3.jpg', 'Crazy Cats', '2008-12-18', 8, 34,'Canon S3', 622, 37.5, 466, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (35, 'Cat3', 'admin/Album1/images4.jpg', 'Crazy Cats', '2008-12-18', 8, 35,'Canon S3', 758, 35.8, 550, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (36, 'Cat4', 'admin/Album1/images5.jpg', 'Crazy Cats', '2008-12-18', 8, 36,'Canon S3', 555, 51.7, 596, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (37, 'Moon1', 'admin/Album1/Moon/images.jpg', 'Moon pictures', '2008-12-18', 10, 37,'Canon S3', 602, 44.0, 480, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (38, 'Moon2', 'admin/Album1/Moon/images1.jpg', 'Moon pictures', '2008-12-18', 10, 38,'Canon S3', 598, 23.0, 480, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (39, 'Moon3', 'admin/Album1/Moon/images2.jpg', 'Moon pictures', '2008-12-18', 10, 39,'Canon S3', 430, 49.0, 400, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (40, 'Moon4', 'admin/Album1/Moon/images3.jpg', 'Moon pictures', '2008-12-18', 10, 40,'Canon S3', 800, 36.0, 600, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (41, 'Moon5', 'admin/Album1/Moon/images4.jpg', 'Moon pictures', '2008-12-18', 10, 41,'Canon S3', 1309, 99.4, 1284, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (42, 'Moon6', 'admin/Album1/Moon/images5.jpg', 'Moon pictures', '2008-12-18', 10, 42,'Canon S3', 800, 93.5, 540, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (43, 'Plane', 'admin/Planes/images.jpg', 'Planes pictures', '2008-12-18', 9, 43,'Canon S3', 800, 28.6, 534, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (44, 'Plane1', 'admin/Planes/images1.jpg', 'Planes pictures', '2008-12-18', 9, 44,'Canon S3', 540, 31.9, 390, '2008-12-01'); +INSERT INTO images(image_id, name, path, description, created, img_album_id, rank_id, cameraModel, height, size, width, uploaded) VALUES (45, 'Plane2', 'admin/Planes/images2.jpg', 'Planes pictures', '2008-12-18', 9, 45,'Canon S3', 770, 66.0, 486, '2008-12-01'); +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 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); @@ -105,7 +142,10 @@ INSERT INTO messages(message_id, date, message, author_id, owner_id, readed, theme, friendshipRequest) VALUES (3, '1985-01-09', 'Hello ', 1, 2, false, 'Hello, amarkhel', false); INSERT INTO shared_albums(album_id, user_id) VALUES(4, 1); INSERT INTO shared_albums(album_id, user_id) VALUES(5, 1); +INSERT INTO shared_albums(album_id, user_id) VALUES(8, 5); +INSERT INTO shared_albums(album_id, user_id) VALUES(9, 5); INSERT INTO shared_images(image_id, user_id) VALUES(30, 1); INSERT INTO shared_images(image_id, user_id) VALUES(31, 1); INSERT INTO user_friends(user1_id, user2_id) VALUES(1, 2); +INSERT INTO user_friends(user1_id, user2_id) VALUES(1, 5); INSERT INTO friendship_requests(REQUEST_ID, USER_ID, FRIEND_ID) VALUES(1, 3, 1); \ No newline at end of file