Author: amarkhel
Date: 2009-02-25 06:06:27 -0500 (Wed, 25 Feb 2009)
New Revision: 12736
Modified:
trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
Log:
Modified: trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-02-25
08:35:13 UTC (rev 12735)
+++ trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-02-25
11:06:27 UTC (rev 12736)
@@ -3,15 +3,18 @@
INSERT INTO Users(user_id, firstname, secondname, email, login, passwordHash, birthdate)
VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname',
'8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08');
INSERT INTO shelfs(shelf_id, name, description, shelf_user_id) VALUES (1,
'Nature', 'Nature pictures', 1);
-INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (15, 'Water', 'Rivers pictures', true, 2, null);
+INSERT INTO shelfs(shelf_id, name, description, shelf_user_id) VALUES (2,
'Sport', 'Nature pictures', 1);
+INSERT INTO shelfs(shelf_id, name, description, shelf_user_id) VALUES (3,
'Water', 'Nature pictures', 2);
+INSERT INTO shelfs(shelf_id, name, description, shelf_user_id) VALUES (4,
'Flowers', 'Nature pictures', 3);
+INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (15, 'Water', 'Rivers pictures', true, 2, 3);
INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (20, 'Sport', 'Nature pictures', true, 1, 1);
-INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (26, 'Travel', 'Fun pictures', true, 1, null);
+INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (26, 'Travel', 'Fun pictures', true, 1, 2);
INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (25, 'Beach', 'Fun pictures', true, 1, 1);
-INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (23, 'Flowers', 'Fun pictures', true, 3, null);
+INSERT INTO albums(album_id, name, description, shared, album_user_id, parent_shelf_id)
VALUES (23, 'Flowers', 'Fun pictures', true, 3, 4);
INSERT INTO images(image_id, name, path, description, created, img_album_id,
cameraModel, height, size, width, uploaded) VALUES (98, 'korana',
'Viking/15/korana.jpg', 'korana', '2008-12-18', 15, 'Canon
S3', 1024, 1917.000000, 768, '2008-12-01');