JBoss Rich Faces SVN: r14002 - in trunk/examples/photoalbum/source/ejb/sql: short and 1 other directory.
6:38 a.m.
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);
5716
days inactive
5716
days old
richfaces-svn-commits@lists.jboss.org
0 comments
1 participants
participants (1)
-
richfaces-svn-commits＠lists.jboss.org