Author: Alex.Kolonitsky Date: 2009-05-12 12:44:06 -0400 (Tue, 12 May 2009) New Revision: 14134 Modified: trunk/examples/photoalbum/source/ejb/sql/full/import.sql trunk/examples/photoalbum/source/ejb/sql/short/import.sql Log: change images Modified: trunk/examples/photoalbum/source/ejb/sql/full/import.sql =================================================================== --- trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-12 16:35:49 UTC (rev 14133) +++ trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-12 16:44:06 UTC (rev 14134) @@ -2,10 +2,12 @@ INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (2, 'Nick', 'Curtis', 'nkurtis(a)iba.com', 'Viking', '8cb2237d0679ca88db6464eac60da96345513964', '1978-01-08', 1, 0, true); INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname', '8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08', 1, 0, true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport & Cars', 'Sport & Cars pictures', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Prtrait', 'Nature pictures', 2, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Monuments', 'Monuments pictures', 3, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (5, 'Water', 'Water pictures', 3, '2009-12-18', true); + --------------------------------------------------------------------- -- ALBUM - Animals" --------------------------------------------------------------------- @@ -243,7 +245,7 @@ --------------------------------------------------------------------- -- ALBUM - Nature" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 2, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 1, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (3, 'Nature'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (51, '01[303x202].jpg', '01[303x202].jpg', 'Nature - 01[303x202].jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); @@ -412,7 +414,7 @@ --------------------------------------------------------------------- -- ALBUM - Sport" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 2, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (5, 'Sport'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (90, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); @@ -492,7 +494,7 @@ --------------------------------------------------------------------- -- ALBUM - Water" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 1, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 5, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (6, 'Water'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (105, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); Modified: trunk/examples/photoalbum/source/ejb/sql/short/import.sql =================================================================== --- trunk/examples/photoalbum/source/ejb/sql/short/import.sql 2009-05-12 16:35:49 UTC (rev 14133) +++ trunk/examples/photoalbum/source/ejb/sql/short/import.sql 2009-05-12 16:44:06 UTC (rev 14134) @@ -2,10 +2,12 @@ INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (2, 'Nick', 'Curtis', 'nkurtis(a)iba.com', 'Viking', '8cb2237d0679ca88db6464eac60da96345513964', '1978-01-08', 1, 0, true); INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname', '8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08', 1, 0, true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true); -INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport & Cars', 'Sport & Cars pictures', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Prtrait', 'Nature pictures', 2, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Monuments', 'Monuments pictures', 3, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (5, 'Water', 'Water pictures', 3, '2009-12-18', true); + --------------------------------------------------------------------- -- ALBUM - Animals" --------------------------------------------------------------------- @@ -93,7 +95,7 @@ --------------------------------------------------------------------- -- ALBUM - Nature" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 2, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 1, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (3, 'Nature'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '01[303x202].jpg', '01[303x202].jpg', 'Nature - 01[303x202].jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); @@ -143,7 +145,7 @@ --------------------------------------------------------------------- -- ALBUM - Sport" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 2, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (5, 'Sport'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); @@ -163,7 +165,7 @@ --------------------------------------------------------------------- -- ALBUM - Water" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 1, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 5, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (6, 'Water'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);