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