Author: amarkhel Date: 2009-05-04 07:38:21 -0400 (Mon, 04 May 2009) New Revision: 14002 Modified: trunk/examples/photoalbum/source/ejb/sql/full/import.sql trunk/examples/photoalbum/source/ejb/sql/short/import.sql Log: Modified: trunk/examples/photoalbum/source/ejb/sql/full/import.sql =================================================================== --- trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-04 11:25:17 UTC (rev 14001) +++ trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-04 11:38:21 UTC (rev 14002) @@ -2,14 +2,14 @@ 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 images', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature images', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature images', 2, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature images', 3, '2009-12-18', true); --------------------------------------------------------------------- -- ALBUM - Animals" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals images', 1, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (0, 'Animals'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '1750979205_6e51b47ce9_o.jpg', '1750979205_6e51b47ce9_o.jpg', 'Animals - 1750979205_6e51b47ce9_o.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); @@ -73,7 +73,7 @@ --------------------------------------------------------------------- -- ALBUM - Cars" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars pictures', 3, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars images', 3, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (1, 'Cars'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '190193308_ce2a4de5fa_o.jpg', '190193308_ce2a4de5fa_o.jpg', 'Cars - 190193308_ce2a4de5fa_o.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); @@ -134,7 +134,7 @@ --------------------------------------------------------------------- -- ALBUM - Monuments and just buildings" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings pictures', 4, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings images', 4, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (2, 'Monuments and just buildings'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (30, '05[303x457].jpg', '05[303x457].jpg', 'Monuments and just buildings - 05[303x457].jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); @@ -229,7 +229,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 images', 2, '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); @@ -320,7 +320,7 @@ --------------------------------------------------------------------- -- ALBUM - Portrait" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait pictures', 3, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait images', 3, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (4, 'Portrait'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (73, '02[303x202].jpg', '02[303x202].jpg', 'Portrait - 02[303x202].jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); @@ -403,7 +403,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 images', 4, '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); @@ -467,7 +467,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 images', 1, '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-04 11:25:17 UTC (rev 14001) +++ trunk/examples/photoalbum/source/ejb/sql/short/import.sql 2009-05-04 11:38:21 UTC (rev 14002) @@ -2,14 +2,14 @@ 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 images', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature images', 1, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature images', 2, '2009-12-18', true); +INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature images', 3, '2009-12-18', true); --------------------------------------------------------------------- -- ALBUM - Animals" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals images', 1, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (0, 'Animals'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '1750979205_6e51b47ce9_o.jpg', '1750979205_6e51b47ce9_o.jpg', 'Animals - 1750979205_6e51b47ce9_o.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); @@ -34,7 +34,7 @@ --------------------------------------------------------------------- -- ALBUM - Cars" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars pictures', 3, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars images', 3, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (1, 'Cars'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '190193308_ce2a4de5fa_o.jpg', '190193308_ce2a4de5fa_o.jpg', 'Cars - 190193308_ce2a4de5fa_o.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); @@ -57,7 +57,7 @@ --------------------------------------------------------------------- -- ALBUM - Monuments and just buildings" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings pictures', 4, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings images', 4, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (2, 'Monuments and just buildings'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '05[303x457].jpg', '05[303x457].jpg', 'Monuments and just buildings - 05[303x457].jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); @@ -77,7 +77,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 images', 2, '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 (12, '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); @@ -100,7 +100,7 @@ --------------------------------------------------------------------- -- ALBUM - Portrait" --------------------------------------------------------------------- -INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait pictures', 3, '2009-12-18'); +INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait images', 3, '2009-12-18'); INSERT INTO MetaTag(id, tag) VALUES (4, 'Portrait'); INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '02[303x202].jpg', '02[303x202].jpg', 'Portrait - 02[303x202].jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); @@ -122,7 +122,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 images', 4, '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 (20, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); @@ -145,7 +145,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 images', 1, '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 (24, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);