[richfaces-svn-commits] JBoss Rich Faces SVN: r13519 - in trunk/test-applications/realworld2: ejb/src/main/java/org/richfaces/realworld/service and 3 other directories.

Author: Alex.Kolonitsky Date: 2009-04-13 06:26:15 -0400 (Mon, 13 Apr 2009) New Revision: 13519 Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java trunk/test-applications/realworld2/ejb/src/main/resources/import.sql trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageEditInfo.xhtml trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageInfo.xhtml Log: add show meta info field t image Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-12 19:12:48 UTC (rev 13518) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-13 10:26:15 UTC (rev 13519) @@ -52,6 +52,9 @@ import org.hibernate.validator.Length; import org.hibernate.validator.NotEmpty; import org.hibernate.validator.NotNull; +import org.hibernate.annotations.LazyCollection; +import org.hibernate.annotations.LazyCollectionOption; +import org.hibernate.annotations.OrderBy; import org.jboss.seam.ScopeType; import org.jboss.seam.annotations.AutoCreate; import org.jboss.seam.annotations.Name; @@ -159,8 +162,8 @@ private Date created; @OneToMany(mappedBy = "image", cascade = {CascadeType.ALL}, fetch = FetchType.LAZY) - @org.hibernate.annotations.LazyCollection(org.hibernate.annotations.LazyCollectionOption.EXTRA) - @org.hibernate.annotations.OrderBy(clause = "date asc") + @LazyCollection(LazyCollectionOption.EXTRA) + @OrderBy(clause = "date asc") private List<Comment> comments = new ArrayList<Comment>(); @ManyToOne(fetch = FetchType.LAZY) @@ -170,49 +173,34 @@ @NotNull private boolean allowComments; - // ********************** Accessor Methods ********************** // + private Boolean showMetaInfo = true; - /** - * Getter for property id - * - * @return id of image - */ - public Long getId() { + // ********************** Accessor Methods ********************** // + + public Boolean getShowMetaInfo() { + return showMetaInfo; + } + + public void setShowMetaInfo(final Boolean showMetaInfo) { + this.showMetaInfo = showMetaInfo; + } + + public Long getId() { return id; } - /** - * Getter for property name - * - * @return name of image - */ public String getName() { return name; } - /** - * Setter for property name - * - * @param name - name of image - */ public void setName(String name) { this.name = name; } - /** - * Getter for property description - * - * @return description of image - */ public String getDescription() { return description; } - /** - * Setter for property description - * - * @param description - description of image - */ public void setDescription(String description) { this.description = description; } @@ -229,38 +217,18 @@ return path; } - /** - * Setter for property path - * - * @param path - relative path to image - */ public void setPath(String path) { this.path = path; } - /** - * Getter for property created - * - * @return date of creation of this image - */ public Date getCreated() { return created; } - /** - * Setter for property created - * - * @param created - date of creation - */ public void setCreated(Date created) { this.created = created; } - /** - * Getter for property album - * - * @return containing album - */ public Album getAlbum() { return album; } @@ -293,8 +261,6 @@ } /** - * Setter for property meta - * * @param meta - string representation of metatags, associated to image. Used at jsf page. */ public void setMeta(String meta) { @@ -302,8 +268,7 @@ } /** - * Getter for property meta - * + * * @return string representation of metatags, associated to image. Used at jsf page. */ public String getMetaString(){ @@ -311,7 +276,6 @@ } /** - * Getter for property cameraModel * * @return model of camera */ @@ -320,7 +284,6 @@ } /** - * setter for property cameraModel * * @param cameraModel- model of camera */ @@ -329,7 +292,6 @@ } /** - * Getter for property height * * @return height of image */ @@ -338,7 +300,6 @@ } /** - * setter for property height * * @param height - height of image */ @@ -347,7 +308,6 @@ } /** - * Getter for property size * * @return size of image in KB */ @@ -356,7 +316,6 @@ } /** - * setter for property size * * @param size - size of image in KB */ @@ -365,7 +324,6 @@ } /** - * Getter for property width * * @return width of image */ @@ -374,7 +332,6 @@ } /** - * setter for property width * * @param width - width of image */ @@ -383,7 +340,6 @@ } /** - * Getter for property uploaded * * @return date of upload to site of this image */ @@ -392,7 +348,6 @@ } /** - * setter for property uploaded * * @param uploaded - date of upload */ @@ -433,7 +388,6 @@ } /** - * Getter for property visited * * @return boolean value, that indicated is user visit this image already */ @@ -442,7 +396,6 @@ } /** - * Setter for property visited * * @param visited - boolean value, that indicated is user visit this image already */ @@ -451,7 +404,6 @@ } /** - * Determine if this image should be marked as new(on jsf page, for example in tree) * * @return boolean value, that indicated is this image should be marked as new */ @@ -464,11 +416,6 @@ //---------------------------Business methods - /** - * Add comment to this image. - * - * @param comment - comment to add - */ public void addComment(Comment comment) { if (comment == null) { throw new IllegalArgumentException("Null comment!"); @@ -477,11 +424,6 @@ comments.add(comment); } - /** - * Remove comment from list of comments, belongs to that image. - * - * @param comment - comment to delete - */ public void removeComment(Comment comment) { if (comment == null) { throw new IllegalArgumentException("Null comment"); @@ -494,11 +436,6 @@ } } - /** - * Add metatag to this image. - * - * @param metatag - metatag to add - */ public void addMetaTag(MetaTag metatag) { if (metatag == null) { throw new IllegalArgumentException("Null metatag!"); @@ -509,11 +446,6 @@ } } - /** - * Remove metatag from list of metatag, associated to that image. - * - * @param metatag - metatag to delete - */ public void removeMetaTag(MetaTag metatag) { if (metatag == null) { throw new IllegalArgumentException("Null metatag!"); Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-12 19:12:48 UTC (rev 13518) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-13 10:26:15 UTC (rev 13519) @@ -36,10 +36,10 @@ @Local public interface IAlbumAction { - public abstract void addAlbum(Album album); + void addAlbum(Album album); - public void deleteAlbum(Album album); + void deleteAlbum(Album album); - public void editAlbum(Album album); + void editAlbum(Album album); } \ No newline at end of file Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-12 19:12:48 UTC (rev 13518) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-13 10:26:15 UTC (rev 13519) @@ -37,11 +37,11 @@ @Local public interface IShelfAction { - public abstract void addShelf(Shelf shelf); - - public void deleteShelf(Shelf shelf); - - public void editShelf(Shelf shelf); - - public List<Shelf> getShelfs(User user); + void addShelf(Shelf shelf); + + void deleteShelf(Shelf shelf); + + void editShelf(Shelf shelf); + + List<Shelf> getShelfs(User user); } Modified: trunk/test-applications/realworld2/ejb/src/main/resources/import.sql =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-12 19:12:48 UTC (rev 13518) +++ trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-13 10:26:15 UTC (rev 13519) @@ -13,152 +13,137 @@ INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (0, 'Animals'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (0, '067.jpg', '067.jpg', 'Animals - 067.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '067.jpg', '067.jpg', 'Animals - 067.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 0); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (1, '10005.jpg', '10005.jpg', 'Animals - 10005.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (0, '1985-01-08', 'Amazing shot..',0, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (1, '10005.jpg', '10005.jpg', 'Animals - 10005.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (0, '1985-01-08', 'I Think this is Art!',1, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (1, '1985-01-08', 'nice shot =) ',1, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (2, '1985-01-08', 'nice shot =) ',1, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (2, '400004.jpg', '400004.jpg', 'Animals - 400004.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (1, '1985-01-08', 'Beautiful colours. Nice close up. ',1, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (2, '1985-01-08', 'I Think this is Art!',1, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (2, '400004.jpg', '400004.jpg', 'Animals - 400004.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (3, '400008.jpg', '400008.jpg', 'Animals - 400008.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (3, '400008.jpg', '400008.jpg', 'Animals - 400008.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (3, '1985-01-08', 'love every thing about this picture, really beautiful... :))',3, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (4, '1985-01-08', 'Amazing shot..',3, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (5, '1985-01-08', 'love every thing about this picture, really beautiful... :))',3, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (4, '400027.jpg', '400027.jpg', 'Animals - 400027.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (3, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',3, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (4, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',3, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (5, '1985-01-08', 'Gorgeous! Lovely color!',3, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (6, '1985-01-08', 'I Think this is Art!',3, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '400027.jpg', '400027.jpg', 'Animals - 400027.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 4); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (6, '1985-01-08', 'Such a lovely colour azaga!',4, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (7, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',4, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (8, '1985-01-08', 'Bellissima macro!',4, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (9, '1985-01-08', 'this is extremely Good:) Congratulations!',4, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (5, '400028.jpg', '400028.jpg', 'Animals - 400028.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (7, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',4, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (8, '1985-01-08', 'Wonderful.',4, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (9, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',4, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (5, '400028.jpg', '400028.jpg', 'Animals - 400028.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 5); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (10, '1985-01-08', 'Stunning capture! :-)',5, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (11, '1985-01-08', '++Beautiful',5, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (6, '400034.jpg', '400034.jpg', 'Animals - 400034.jpg image', '2009-12-18', 0, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (10, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',5, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (11, '1985-01-08', 'Wonderful.',5, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (12, '1985-01-08', 'Bellísima.!!! saludos.',5, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (6, '400034.jpg', '400034.jpg', 'Animals - 400034.jpg image', '2009-12-18', 0, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 6); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (12, '1985-01-08', 'Very *lovely*',6, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (7, '400035.jpg', '400035.jpg', 'Animals - 400035.jpg image', '2009-12-18', 0, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (13, '1985-01-08', 'fantastic shot !!!!!!',6, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (14, '1985-01-08', 'Perfecft!',6, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (15, '1985-01-08', 'Perfecft!',6, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (16, '1985-01-08', 'Gorgeous! Lovely color!',6, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (7, '400035.jpg', '400035.jpg', 'Animals - 400035.jpg image', '2009-12-18', 0, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 7); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (13, '1985-01-08', 'whoah ! wonderful',7, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (14, '1985-01-08', 'I Think this is Art!',7, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (15, '1985-01-08', 'I Think this is Art!',7, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (16, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',7, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (8, '400063.jpg', '400063.jpg', 'Animals - 400063.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (17, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',7, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '400063.jpg', '400063.jpg', 'Animals - 400063.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 8); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (17, '1985-01-08', 'whoah ! wonderful',8, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (18, '1985-01-08', 'love every thing about this picture, really beautiful... :))',8, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (9, '400095.jpg', '400095.jpg', 'Animals - 400095.jpg image', '2009-12-18', 0, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (18, '1985-01-08', 'Stunning capture! :-)',8, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (19, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',8, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (9, '400095.jpg', '400095.jpg', 'Animals - 400095.jpg image', '2009-12-18', 0, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 9); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (19, '1985-01-08', 'Gorgeous! Lovely color!',9, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (20, '1985-01-08', 'whoah ! wonderful',9, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (21, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',9, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (22, '1985-01-08', 'Stunning capture! :-)',9, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (10, 'deer.jpg', 'deer.jpg', 'Animals - deer.jpg image', '2009-12-18', 0, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (10, 'deer.jpg', 'deer.jpg', 'Animals - deer.jpg image', '2009-12-18', 0, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 10); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (23, '1985-01-08', 'Bellísima.!!! saludos.',10, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (24, '1985-01-08', '++Beautiful',10, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (11, 'dog2.jpg', 'dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (20, '1985-01-08', 'Bellissima macro!',10, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (11, 'dog2.jpg', 'dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 11); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (25, '1985-01-08', '++Beautiful',11, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (26, '1985-01-08', 'love every thing about this picture, really beautiful... :))',11, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (12, 'pinn40.jpg', 'pinn40.jpg', 'Animals - pinn40.jpg image', '2009-12-18', 0, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (21, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',11, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (22, '1985-01-08', 'Beautiful colours. Nice close up. ',11, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (12, 'pinn40.jpg', 'pinn40.jpg', 'Animals - pinn40.jpg image', '2009-12-18', 0, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 12); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (13, 'pinn51.jpg', 'pinn51.jpg', 'Animals - pinn51.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (13, 'pinn51.jpg', 'pinn51.jpg', 'Animals - pinn51.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 13); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (27, '1985-01-08', 'nice shot =) ',13, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (28, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',13, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (29, '1985-01-08', 'whoah ! wonderful',13, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (30, '1985-01-08', 'fantastic shot !!!!!!',13, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (23, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',13, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (24, '1985-01-08', 'Wonderful.',13, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (25, '1985-01-08', 'Wonderful.',13, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (26, '1985-01-08', 'Very *lovely*',13, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (14, 'turtle.jpg', 'turtle.jpg', 'Animals - turtle.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 14); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (27, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',14, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (28, '1985-01-08', 'Very *lovely*',14, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (29, '1985-01-08', 'Wonderful.',14, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (30, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',14, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (15, 'turtle.jpg', 'turtle.jpg', 'Animals - turtle.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 15); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (33, '1985-01-08', 'I Think this is Art!',15, 1); - --------------------------------------------------------------------- -- ALBUM - Building --------------------------------------------------------------------- INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (1, 'Building', 'Building pictures', 3, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (1, 'Building'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (16, '1.jpg', '1.jpg', 'Building - 1.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '1.jpg', '1.jpg', 'Building - 1.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 15); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (31, '1985-01-08', 'Beautiful colours. Nice close up. ',15, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (32, '1985-01-08', 'Very *lovely*',15, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (33, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',15, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '2.jpg', '2.jpg', 'Building - 2.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 16); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (34, '1985-01-08', 'whoah ! wonderful',16, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (35, '1985-01-08', 'Bellísima.!!! saludos.',16, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (36, '1985-01-08', 'Amazing shot..',16, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (37, '1985-01-08', 'Bellísima.!!! saludos.',16, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (17, '2.jpg', '2.jpg', 'Building - 2.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (34, '1985-01-08', 'that is a beautiful flower with great colours ',16, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (35, '1985-01-08', 'Gorgeous! Lovely color!',16, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (17, '3.jpg', '3.jpg', 'Building - 3.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 17); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (38, '1985-01-08', 'Bellísima.!!! saludos.',17, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (39, '1985-01-08', 'that is a beautiful flower with great colours ',17, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (40, '1985-01-08', 'Very *lovely*',17, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (41, '1985-01-08', 'Stunning capture! :-)',17, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (18, '3.jpg', '3.jpg', 'Building - 3.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (36, '1985-01-08', 'I Think this is Art!',17, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (37, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',17, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (38, '1985-01-08', 'whoah ! wonderful',17, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (18, '4.jpg', '4.jpg', 'Building - 4.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 18); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (42, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (43, '1985-01-08', 'whoah ! wonderful',18, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (19, '4.jpg', '4.jpg', 'Building - 4.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (39, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (40, '1985-01-08', 'Amazing shot..',18, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (41, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (42, '1985-01-08', 'this is extremely Good:) Congratulations!',18, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (19, '400018.jpg', '400018.jpg', 'Building - 400018.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 19); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (44, '1985-01-08', 'Amazing shot..',19, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (45, '1985-01-08', 'that is a beautiful flower with great colours ',19, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (20, '400018.jpg', '400018.jpg', 'Building - 400018.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (43, '1985-01-08', 'Gorgeous! Lovely color!',19, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (44, '1985-01-08', 'Bellísima.!!! saludos.',19, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (45, '1985-01-08', 'Beautiful colours. Nice close up. ',19, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (46, '1985-01-08', 'nice shot =) ',19, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (20, '400036.jpg', '400036.jpg', 'Building - 400036.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 20); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (46, '1985-01-08', 'Very *lovely*',20, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (47, '1985-01-08', 'Very *lovely*',20, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (48, '1985-01-08', 'nice shot =) ',20, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (49, '1985-01-08', 'Stunning capture! :-)',20, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (21, '400036.jpg', '400036.jpg', 'Building - 400036.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (47, '1985-01-08', 'Gorgeous! Lovely color!',20, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (48, '1985-01-08', 'Amazing shot..',20, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (49, '1985-01-08', 'Beautiful colours. Nice close up. ',20, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (50, '1985-01-08', 'this is extremely Good:) Congratulations!',20, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (21, '400069.jpg', '400069.jpg', 'Building - 400069.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 21); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (50, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',21, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (51, '1985-01-08', 'Stunning capture! :-)',21, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (22, '400069.jpg', '400069.jpg', 'Building - 400069.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (51, '1985-01-08', 'Gorgeous! Lovely color!',21, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (52, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',21, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (53, '1985-01-08', 'that is a beautiful flower with great colours ',21, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (22, '400076.jpg', '400076.jpg', 'Building - 400076.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 22); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (52, '1985-01-08', 'Bellissima macro!',22, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (53, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',22, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (54, '1985-01-08', 'this is extremely Good:) Congratulations!',22, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (55, '1985-01-08', 'I Think this is Art!',22, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (23, '400076.jpg', '400076.jpg', 'Building - 400076.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (54, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',22, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (55, '1985-01-08', 'Very *lovely*',22, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (56, '1985-01-08', '++Beautiful',22, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (57, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',22, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (23, '400083.jpg', '400083.jpg', 'Building - 400083.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 23); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (56, '1985-01-08', 'Stunning capture! :-)',23, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (57, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',23, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (58, '1985-01-08', 'this is extremely Good:) Congratulations!',23, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (59, '1985-01-08', 'Wonderful.',23, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (24, '400083.jpg', '400083.jpg', 'Building - 400083.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '5.jpg', '5.jpg', 'Building - 5.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 24); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (60, '1985-01-08', 'fantastic shot !!!!!!',24, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (61, '1985-01-08', 'Wonderful.',24, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (25, '5.jpg', '5.jpg', 'Building - 5.jpg image', '2009-12-18', 1, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (58, '1985-01-08', 'Bellísima.!!! saludos.',24, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (25, '6.jpg', '6.jpg', 'Building - 6.jpg image', '2009-12-18', 1, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 25); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (62, '1985-01-08', 'Amazing shot..',25, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (63, '1985-01-08', '++Beautiful',25, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (64, '1985-01-08', 'fantastic shot !!!!!!',25, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (26, '6.jpg', '6.jpg', 'Building - 6.jpg image', '2009-12-18', 1, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (59, '1985-01-08', 'Perfecft!',25, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (60, '1985-01-08', 'Wonderful.',25, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (61, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',25, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (26, '7.jpg', '7.jpg', 'Building - 7.jpg image', '2009-12-18', 1, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 26); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (65, '1985-01-08', 'this is extremely Good:) Congratulations!',26, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (27, '7.jpg', '7.jpg', 'Building - 7.jpg image', '2009-12-18', 1, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, 'church.jpg', 'church.jpg', 'Building - church.jpg image', '2009-12-18', 1, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 27); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (66, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',27, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (67, '1985-01-08', 'Bellísima.!!! saludos.',27, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (68, '1985-01-08', 'love every thing about this picture, really beautiful... :))',27, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (69, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',27, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (28, 'church.jpg', 'church.jpg', 'Building - church.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (28, 'pinn71.jpg', 'pinn71.jpg', 'Building - pinn71.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 28); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (70, '1985-01-08', 'Beautiful colours. Nice close up. ',28, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (71, '1985-01-08', 'Bellissima macro!',28, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (72, '1985-01-08', 'Bellísima.!!! saludos.',28, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (29, 'pinn71.jpg', 'pinn71.jpg', 'Building - pinn71.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (29, 'pinn82.jpg', 'pinn82.jpg', 'Building - pinn82.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 29); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (30, 'pinn82.jpg', 'pinn82.jpg', 'Building - pinn82.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 30); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (73, '1985-01-08', '++Beautiful',30, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (74, '1985-01-08', 'Bellissima macro!',30, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (31, 'thumbs.db', 'thumbs.db', 'Building - thumbs.db image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 31); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (75, '1985-01-08', 'Stunning capture! :-)',31, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (76, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',31, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (77, '1985-01-08', 'I Think this is Art!',31, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (62, '1985-01-08', 'whoah ! wonderful',29, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (63, '1985-01-08', 'Wonderful.',29, 2); --------------------------------------------------------------------- -- ALBUM - Coasts @@ -166,68 +151,65 @@ INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (2, 'Coasts', 'Coasts pictures', 4, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (2, 'Coasts'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (32, '203015.jpg', '203015.jpg', 'Coasts - 203015.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (30, '203015.jpg', '203015.jpg', 'Coasts - 203015.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 30); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (64, '1985-01-08', 'Such a lovely colour azaga!',30, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (65, '1985-01-08', 'Bellissima macro!',30, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (66, '1985-01-08', 'love every thing about this picture, really beautiful... :))',30, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (67, '1985-01-08', 'love every thing about this picture, really beautiful... :))',30, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (31, '203034.jpg', '203034.jpg', 'Coasts - 203034.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 31); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (68, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',31, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (32, '203036.jpg', '203036.jpg', 'Coasts - 203036.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 32); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (78, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',32, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (79, '1985-01-08', 'Bellísima.!!! saludos.',32, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (80, '1985-01-08', 'nice shot =) ',32, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (33, '203034.jpg', '203034.jpg', 'Coasts - 203034.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (33, '203043.jpg', '203043.jpg', 'Coasts - 203043.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 33); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (81, '1985-01-08', 'nice shot =) ',33, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (82, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',33, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (34, '203036.jpg', '203036.jpg', 'Coasts - 203036.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (69, '1985-01-08', 'fantastic shot !!!!!!',33, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (70, '1985-01-08', 'I Think this is Art!',33, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (34, '203049.jpg', '203049.jpg', 'Coasts - 203049.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 34); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (83, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',34, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (84, '1985-01-08', 'nice shot =) ',34, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (85, '1985-01-08', 'Perfecft!',34, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (35, '203043.jpg', '203043.jpg', 'Coasts - 203043.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (71, '1985-01-08', 'Stunning capture! :-)',34, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (35, '203052.jpg', '203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 35); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (86, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',35, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (87, '1985-01-08', 'Stunning capture! :-)',35, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (88, '1985-01-08', 'Bellissima macro!',35, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (89, '1985-01-08', 'I Think this is Art!',35, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (36, '203049.jpg', '203049.jpg', 'Coasts - 203049.jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (72, '1985-01-08', 'Wonderful.',35, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (73, '1985-01-08', 'Stunning capture! :-)',35, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (36, '203053.jpg', '203053.jpg', 'Coasts - 203053.jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 36); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (90, '1985-01-08', 'Bellissima macro!',36, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (91, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',36, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (92, '1985-01-08', 'Beautiful colours. Nice close up. ',36, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (93, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',36, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (37, '203052.jpg', '203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (74, '1985-01-08', 'Such a lovely colour azaga!',36, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (75, '1985-01-08', 'that is a beautiful flower with great colours ',36, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (76, '1985-01-08', 'Stunning capture! :-)',36, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (77, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',36, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (37, '203054.jpg', '203054.jpg', 'Coasts - 203054.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 37); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (94, '1985-01-08', 'Gorgeous! Lovely color!',37, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (38, '203053.jpg', '203053.jpg', 'Coasts - 203053.jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (78, '1985-01-08', 'Bellísima.!!! saludos.',37, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (79, '1985-01-08', 'Bellísima.!!! saludos.',37, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (80, '1985-01-08', 'Bellissima macro!',37, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (81, '1985-01-08', 'Gorgeous! Lovely color!',37, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (38, '203058.jpg', '203058.jpg', 'Coasts - 203058.jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 38); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (95, '1985-01-08', 'Bellissima macro!',38, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (96, '1985-01-08', 'whoah ! wonderful',38, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (97, '1985-01-08', 'this is extremely Good:) Congratulations!',38, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (39, '203054.jpg', '203054.jpg', 'Coasts - 203054.jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (82, '1985-01-08', 'that is a beautiful flower with great colours ',38, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (83, '1985-01-08', 'Amazing shot..',38, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (84, '1985-01-08', 'Wonderful.',38, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (39, '203066.jpg', '203066.jpg', 'Coasts - 203066.jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 39); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (98, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',39, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (99, '1985-01-08', 'fantastic shot !!!!!!',39, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (40, '203058.jpg', '203058.jpg', 'Coasts - 203058.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (85, '1985-01-08', 'nice shot =) ',39, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (86, '1985-01-08', 'this is extremely Good:) Congratulations!',39, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (40, '203067.jpg', '203067.jpg', 'Coasts - 203067.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 40); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (100, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',40, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (41, '203066.jpg', '203066.jpg', 'Coasts - 203066.jpg image', '2009-12-18', 2, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (87, '1985-01-08', 'Wonderful.',40, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (88, '1985-01-08', 'Very *lovely*',40, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (89, '1985-01-08', 'Bellissima macro!',40, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (90, '1985-01-08', 'Gorgeous! Lovely color!',40, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (41, '203071.jpg', '203071.jpg', 'Coasts - 203071.jpg image', '2009-12-18', 2, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 41); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (42, '203067.jpg', '203067.jpg', 'Coasts - 203067.jpg image', '2009-12-18', 2, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (91, '1985-01-08', 'Amazing shot..',41, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (92, '1985-01-08', 'Bellísima.!!! saludos.',41, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (42, '203072.jpg', '203072.jpg', 'Coasts - 203072.jpg image', '2009-12-18', 2, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 42); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (101, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',42, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (43, '203071.jpg', '203071.jpg', 'Coasts - 203071.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (43, '203073.jpg', '203073.jpg', 'Coasts - 203073.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 43); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (102, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',43, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (44, '203072.jpg', '203072.jpg', 'Coasts - 203072.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (44, '203076.jpg', '203076.jpg', 'Coasts - 203076.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 44); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (103, '1985-01-08', 'Bellissima macro!',44, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (104, '1985-01-08', 'I Think this is Art!',44, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (105, '1985-01-08', 'Such a lovely colour azaga!',44, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (45, '203073.jpg', '203073.jpg', 'Coasts - 203073.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 45); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (106, '1985-01-08', 'this is extremely Good:) Congratulations!',45, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (107, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',45, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (108, '1985-01-08', 'Bellísima.!!! saludos.',45, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (46, '203076.jpg', '203076.jpg', 'Coasts - 203076.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 46); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (109, '1985-01-08', 'that is a beautiful flower with great colours ',46, 3); --------------------------------------------------------------------- -- ALBUM - Flora @@ -235,61 +217,62 @@ INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (3, 'Flora', 'Flora pictures', 2, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (3, 'Flora'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (48, '132000.jpg', '132000.jpg', 'Flora - 132000.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (45, '132000.jpg', '132000.jpg', 'Flora - 132000.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 45); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (93, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',45, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (94, '1985-01-08', 'love every thing about this picture, really beautiful... :))',45, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (46, '132022.jpg', '132022.jpg', 'Flora - 132022.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 46); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (95, '1985-01-08', 'Bellísima.!!! saludos.',46, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (96, '1985-01-08', 'fantastic shot !!!!!!',46, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (97, '1985-01-08', 'Wonderful.',46, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (47, '132051.jpg', '132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 47); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (98, '1985-01-08', 'whoah ! wonderful',47, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (48, '132059.jpg', '132059.jpg', 'Flora - 132059.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 48); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (112, '1985-01-08', 'this is extremely Good:) Congratulations!',48, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (49, '132022.jpg', '132022.jpg', 'Flora - 132022.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (49, '132060.jpg', '132060.jpg', 'Flora - 132060.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 49); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (113, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',49, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (114, '1985-01-08', 'Wonderful.',49, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (115, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',49, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (50, '132051.jpg', '132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (99, '1985-01-08', 'Amazing shot..',49, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (100, '1985-01-08', 'love every thing about this picture, really beautiful... :))',49, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (101, '1985-01-08', '++Beautiful',49, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (50, '132071.jpg', '132071.jpg', 'Flora - 132071.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 50); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (116, '1985-01-08', 'Wonderful.',50, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (117, '1985-01-08', 'Very *lovely*',50, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (118, '1985-01-08', 'fantastic shot !!!!!!',50, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (119, '1985-01-08', 'Such a lovely colour azaga!',50, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (51, '132059.jpg', '132059.jpg', 'Flora - 132059.jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (102, '1985-01-08', 'Stunning capture! :-)',50, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (103, '1985-01-08', '++Beautiful',50, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (104, '1985-01-08', 'Wonderful.',50, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (105, '1985-01-08', 'I Think this is Art!',50, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (51, '132074.jpg', '132074.jpg', 'Flora - 132074.jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 51); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (120, '1985-01-08', 'Amazing shot..',51, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (121, '1985-01-08', 'Beautiful colours. Nice close up. ',51, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (52, '132060.jpg', '132060.jpg', 'Flora - 132060.jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (106, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',51, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (52, '132078.jpg', '132078.jpg', 'Flora - 132078.jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 52); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (122, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',52, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (53, '132071.jpg', '132071.jpg', 'Flora - 132071.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (107, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',52, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (108, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',52, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (109, '1985-01-08', 'this is extremely Good:) Congratulations!',52, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (53, '142011.jpg', '142011.jpg', 'Flora - 142011.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 53); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (123, '1985-01-08', 'love every thing about this picture, really beautiful... :))',53, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (124, '1985-01-08', 'that is a beautiful flower with great colours ',53, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (125, '1985-01-08', 'that is a beautiful flower with great colours ',53, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (54, '132074.jpg', '132074.jpg', 'Flora - 132074.jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (110, '1985-01-08', 'Bellísima.!!! saludos.',53, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (54, '142039.jpg', '142039.jpg', 'Flora - 142039.jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 54); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (126, '1985-01-08', 'that is a beautiful flower with great colours ',54, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (55, '132078.jpg', '132078.jpg', 'Flora - 132078.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (55, '167049.jpg', '167049.jpg', 'Flora - 167049.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 55); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (56, '142011.jpg', '142011.jpg', 'Flora - 142011.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (111, '1985-01-08', 'Beautiful colours. Nice close up. ',55, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (112, '1985-01-08', 'I Think this is Art!',55, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (56, '167055.jpg', '167055.jpg', 'Flora - 167055.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 56); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (57, '142039.jpg', '142039.jpg', 'Flora - 142039.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (113, '1985-01-08', 'Bellissima macro!',56, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (114, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',56, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (115, '1985-01-08', 'Bellísima.!!! saludos.',56, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (57, '400010.jpg', '400010.jpg', 'Flora - 400010.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 57); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (127, '1985-01-08', 'Stunning capture! :-)',57, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (128, '1985-01-08', 'this is extremely Good:) Congratulations!',57, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (129, '1985-01-08', 'Very *lovely*',57, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (130, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',57, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (58, '167049.jpg', '167049.jpg', 'Flora - 167049.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (116, '1985-01-08', 'Very *lovely*',57, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (58, '400073.jpg', '400073.jpg', 'Flora - 400073.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 58); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (59, '167055.jpg', '167055.jpg', 'Flora - 167055.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (117, '1985-01-08', 'whoah ! wonderful',58, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (59, '403011.jpg', '403011.jpg', 'Flora - 403011.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 59); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (131, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',59, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (60, '400010.jpg', '400010.jpg', 'Flora - 400010.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 60); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (132, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',60, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (133, '1985-01-08', 'Perfecft!',60, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (61, '400073.jpg', '400073.jpg', 'Flora - 400073.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 61); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (134, '1985-01-08', 'Amazing shot..',61, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (135, '1985-01-08', 'Gorgeous! Lovely color!',61, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (136, '1985-01-08', '++Beautiful',61, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (62, '403011.jpg', '403011.jpg', 'Flora - 403011.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 62); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (118, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',59, 3); --------------------------------------------------------------------- -- ALBUM - Ices @@ -297,166 +280,148 @@ INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (4, 'Ices', 'Ices pictures', 3, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (4, 'Ices'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (64, '184023.jpg', '184023.jpg', 'Ices - 184023.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (60, '184023.jpg', '184023.jpg', 'Ices - 184023.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 60); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (119, '1985-01-08', 'Amazing shot..',60, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (120, '1985-01-08', 'nice shot =) ',60, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (121, '1985-01-08', 'Beautiful colours. Nice close up. ',60, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (122, '1985-01-08', 'that is a beautiful flower with great colours ',60, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (61, '184030.jpg', '184030.jpg', 'Ices - 184030.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 61); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (123, '1985-01-08', 'whoah ! wonderful',61, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (124, '1985-01-08', 'nice shot =) ',61, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (125, '1985-01-08', 'Perfecft!',61, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (126, '1985-01-08', 'I Think this is Art!',61, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (62, '184031.jpg', '184031.jpg', 'Ices - 184031.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 62); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (127, '1985-01-08', 'Stunning capture! :-)',62, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (128, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',62, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (129, '1985-01-08', 'Bellissima macro!',62, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (63, '184033.jpg', '184033.jpg', 'Ices - 184033.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 63); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (130, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',63, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (131, '1985-01-08', 'Such a lovely colour azaga!',63, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (64, '184034.jpg', '184034.jpg', 'Ices - 184034.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 64); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (140, '1985-01-08', 'fantastic shot !!!!!!',64, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (141, '1985-01-08', 'Stunning capture! :-)',64, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (65, '184030.jpg', '184030.jpg', 'Ices - 184030.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (65, '184035.jpg', '184035.jpg', 'Ices - 184035.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 65); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (142, '1985-01-08', 'I Think this is Art!',65, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (143, '1985-01-08', 'whoah ! wonderful',65, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (144, '1985-01-08', 'nice shot =) ',65, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (66, '184031.jpg', '184031.jpg', 'Ices - 184031.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (66, '184038.jpg', '184038.jpg', 'Ices - 184038.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 66); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (145, '1985-01-08', 'nice shot =) ',66, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (146, '1985-01-08', 'Gorgeous! Lovely color!',66, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (147, '1985-01-08', 'I Think this is Art!',66, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (67, '184033.jpg', '184033.jpg', 'Ices - 184033.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (132, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',66, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (67, '184040.jpg', '184040.jpg', 'Ices - 184040.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 67); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (148, '1985-01-08', 'Very *lovely*',67, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (149, '1985-01-08', 'Bellísima.!!! saludos.',67, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (150, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',67, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (151, '1985-01-08', 'nice shot =) ',67, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (68, '184034.jpg', '184034.jpg', 'Ices - 184034.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (133, '1985-01-08', 'Such a lovely colour azaga!',67, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (134, '1985-01-08', 'fantastic shot !!!!!!',67, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (135, '1985-01-08', 'I Think this is Art!',67, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (136, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',67, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (68, '184044.jpg', '184044.jpg', 'Ices - 184044.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 68); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (69, '184035.jpg', '184035.jpg', 'Ices - 184035.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (137, '1985-01-08', 'Bellísima.!!! saludos.',68, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (138, '1985-01-08', 'Bellísima.!!! saludos.',68, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (69, '184046.jpg', '184046.jpg', 'Ices - 184046.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 69); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (152, '1985-01-08', 'that is a beautiful flower with great colours ',69, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (153, '1985-01-08', 'Perfecft!',69, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (154, '1985-01-08', 'Bellissima macro!',69, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (155, '1985-01-08', 'Amazing shot..',69, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (70, '184038.jpg', '184038.jpg', 'Ices - 184038.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (139, '1985-01-08', 'Very *lovely*',69, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (140, '1985-01-08', 'whoah ! wonderful',69, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (141, '1985-01-08', 'this is extremely Good:) Congratulations!',69, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (70, '184047.jpg', '184047.jpg', 'Ices - 184047.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 70); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (156, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',70, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (157, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',70, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (158, '1985-01-08', 'Gorgeous! Lovely color!',70, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (159, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',70, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (71, '184040.jpg', '184040.jpg', 'Ices - 184040.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (71, '184053.jpg', '184053.jpg', 'Ices - 184053.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 71); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (160, '1985-01-08', 'Wonderful.',71, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (161, '1985-01-08', 'Very *lovely*',71, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (162, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',71, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (72, '184044.jpg', '184044.jpg', 'Ices - 184044.jpg image', '2009-12-18', 4, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (72, '184057.jpg', '184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 72); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (73, '184046.jpg', '184046.jpg', 'Ices - 184046.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (142, '1985-01-08', '++Beautiful',72, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (143, '1985-01-08', 'Wonderful.',72, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (73, '184063.jpg', '184063.jpg', 'Ices - 184063.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 73); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (163, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',73, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (164, '1985-01-08', 'Perfecft!',73, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (74, '184047.jpg', '184047.jpg', 'Ices - 184047.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (144, '1985-01-08', 'Such a lovely colour azaga!',73, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (145, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',73, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (146, '1985-01-08', 'Beautiful colours. Nice close up. ',73, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (74, '184069.jpg', '184069.jpg', 'Ices - 184069.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 74); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (165, '1985-01-08', 'Very *lovely*',74, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (75, '184053.jpg', '184053.jpg', 'Ices - 184053.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (147, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',74, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (148, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',74, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (149, '1985-01-08', 'I Think this is Art!',74, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (75, '184072.jpg', '184072.jpg', 'Ices - 184072.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 75); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (166, '1985-01-08', 'Perfecft!',75, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (167, '1985-01-08', 'love every thing about this picture, really beautiful... :))',75, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (168, '1985-01-08', '++Beautiful',75, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (169, '1985-01-08', 'fantastic shot !!!!!!',75, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (76, '184057.jpg', '184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (150, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',75, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (151, '1985-01-08', 'Wonderful.',75, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (76, '184077.jpg', '184077.jpg', 'Ices - 184077.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 76); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (170, '1985-01-08', 'this is extremely Good:) Congratulations!',76, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (77, '184063.jpg', '184063.jpg', 'Ices - 184063.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (77, '184078.jpg', '184078.jpg', 'Ices - 184078.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 77); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (171, '1985-01-08', 'nice shot =) ',77, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (172, '1985-01-08', 'Stunning capture! :-)',77, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (173, '1985-01-08', 'whoah ! wonderful',77, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (78, '184069.jpg', '184069.jpg', 'Ices - 184069.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (152, '1985-01-08', 'nice shot =) ',77, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (153, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',77, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (154, '1985-01-08', 'love every thing about this picture, really beautiful... :))',77, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (155, '1985-01-08', '++Beautiful',77, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (78, '184079.jpg', '184079.jpg', 'Ices - 184079.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 78); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (174, '1985-01-08', 'Such a lovely colour azaga!',78, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (175, '1985-01-08', 'love every thing about this picture, really beautiful... :))',78, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (176, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',78, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (79, '184072.jpg', '184072.jpg', 'Ices - 184072.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (156, '1985-01-08', 'Gorgeous! Lovely color!',78, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (157, '1985-01-08', 'Bellísima.!!! saludos.',78, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (158, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',78, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (159, '1985-01-08', 'I Think this is Art!',78, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (79, '400000.jpg', '400000.jpg', 'Ices - 400000.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 79); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (177, '1985-01-08', 'Beautiful colours. Nice close up. ',79, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (178, '1985-01-08', 'love every thing about this picture, really beautiful... :))',79, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (179, '1985-01-08', '++Beautiful',79, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (180, '1985-01-08', 'Bellísima.!!! saludos.',79, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (80, '184077.jpg', '184077.jpg', 'Ices - 184077.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 80); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (181, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',80, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (182, '1985-01-08', 'Stunning capture! :-)',80, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (81, '184078.jpg', '184078.jpg', 'Ices - 184078.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 81); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (183, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',81, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (184, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',81, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (82, '184079.jpg', '184079.jpg', 'Ices - 184079.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 82); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (185, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',82, 2); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (186, '1985-01-08', 'Gorgeous! Lovely color!',82, 2); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (83, '400000.jpg', '400000.jpg', 'Ices - 400000.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 83); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (187, '1985-01-08', 'nice shot =) ',83, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (160, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',79, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (161, '1985-01-08', '++Beautiful',79, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (162, '1985-01-08', 'Bellísima.!!! saludos.',79, 1); - --------------------------------------------------------------------- -- ALBUM - Sport --------------------------------------------------------------------- INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (5, 'Sport'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (85, '23048.jpg', '23048.jpg', 'Sport - 23048.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (80, '23048.jpg', '23048.jpg', 'Sport - 23048.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 80); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (163, '1985-01-08', 'love every thing about this picture, really beautiful... :))',80, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (164, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',80, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (165, '1985-01-08', 'Perfecft!',80, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (81, '400003.jpg', '400003.jpg', 'Sport - 400003.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 81); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (166, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',81, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (167, '1985-01-08', 'whoah ! wonderful',81, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (82, '400033.jpg', '400033.jpg', 'Sport - 400033.jpg image', '2009-12-18', 5, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 82); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (168, '1985-01-08', 'Perfecft!',82, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (83, '400048.jpg', '400048.jpg', 'Sport - 400048.jpg image', '2009-12-18', 5, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 83); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (84, '400081.jpg', '400081.jpg', 'Sport - 400081.jpg image', '2009-12-18', 5, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 84); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (85, '479031.jpg', '479031.jpg', 'Sport - 479031.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 85); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (191, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',85, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (86, '400003.jpg', '400003.jpg', 'Sport - 400003.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (169, '1985-01-08', 'Bellísima.!!! saludos.',85, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (170, '1985-01-08', 'Such a lovely colour azaga!',85, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (171, '1985-01-08', 'that is a beautiful flower with great colours ',85, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (86, 'balloon.jpg', 'balloon.jpg', 'Sport - balloon.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 86); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (192, '1985-01-08', 'Amazing shot..',86, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (87, '400033.jpg', '400033.jpg', 'Sport - 400033.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (172, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',86, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (87, 'hghjump.jpg', 'hghjump.jpg', 'Sport - hghjump.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 87); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (88, '400048.jpg', '400048.jpg', 'Sport - 400048.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (173, '1985-01-08', 'love every thing about this picture, really beautiful... :))',87, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (88, 'pinn01.jpg', 'pinn01.jpg', 'Sport - pinn01.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 88); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (193, '1985-01-08', 'Wonderful.',88, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (89, '400081.jpg', '400081.jpg', 'Sport - 400081.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (89, 'pinn04.jpg', 'pinn04.jpg', 'Sport - pinn04.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 89); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (194, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',89, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (195, '1985-01-08', 'Beautiful colours. Nice close up. ',89, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (196, '1985-01-08', 'this is extremely Good:) Congratulations!',89, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (197, '1985-01-08', 'Amazing shot..',89, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (90, '479031.jpg', '479031.jpg', 'Sport - 479031.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (174, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',89, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (175, '1985-01-08', 'Beautiful colours. Nice close up. ',89, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (176, '1985-01-08', 'nice shot =) ',89, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (90, 'pinn29.jpg', 'pinn29.jpg', 'Sport - pinn29.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 90); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (198, '1985-01-08', 'Stunning capture! :-)',90, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (199, '1985-01-08', 'nice shot =) ',90, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (200, '1985-01-08', 'nice shot =) ',90, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (91, 'balloon.jpg', 'balloon.jpg', 'Sport - balloon.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (91, 'pinn39.jpg', 'pinn39.jpg', 'Sport - pinn39.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 91); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (201, '1985-01-08', 'this is extremely Good:) Congratulations!',91, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (202, '1985-01-08', 'that is a beautiful flower with great colours ',91, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (203, '1985-01-08', 'Wonderful.',91, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (204, '1985-01-08', 'nice shot =) ',91, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (92, 'hghjump.jpg', 'hghjump.jpg', 'Sport - hghjump.jpg image', '2009-12-18', 5, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (177, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',91, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (178, '1985-01-08', 'this is extremely Good:) Congratulations!',91, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (179, '1985-01-08', 'Bellísima.!!! saludos.',91, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (180, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',91, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (92, 'pinn64.jpg', 'pinn64.jpg', 'Sport - pinn64.jpg image', '2009-12-18', 5, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 92); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (205, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',92, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (206, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',92, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (207, '1985-01-08', 'I Think this is Art!',92, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (93, 'pinn01.jpg', 'pinn01.jpg', 'Sport - pinn01.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (181, '1985-01-08', 'Beautiful colours. Nice close up. ',92, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (93, 'sa28.jpg', 'sa28.jpg', 'Sport - sa28.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 93); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (208, '1985-01-08', 'Bellissima macro!',93, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (94, 'pinn04.jpg', 'pinn04.jpg', 'Sport - pinn04.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (182, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',93, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (183, '1985-01-08', 'Very *lovely*',93, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (94, 'swimmer.jpg', 'swimmer.jpg', 'Sport - swimmer.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 94); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (209, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',94, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (210, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',94, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (211, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',94, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (95, 'pinn29.jpg', 'pinn29.jpg', 'Sport - pinn29.jpg image', '2009-12-18', 5, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 95); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (212, '1985-01-08', 'Beautiful colours. Nice close up. ',95, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (213, '1985-01-08', 'this is extremely Good:) Congratulations!',95, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (214, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',95, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (96, 'pinn39.jpg', 'pinn39.jpg', 'Sport - pinn39.jpg image', '2009-12-18', 5, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 96); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (215, '1985-01-08', 'love every thing about this picture, really beautiful... :))',96, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (216, '1985-01-08', 'love every thing about this picture, really beautiful... :))',96, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (217, '1985-01-08', 'Wonderful.',96, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (97, 'pinn64.jpg', 'pinn64.jpg', 'Sport - pinn64.jpg image', '2009-12-18', 5, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 97); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (218, '1985-01-08', 'love every thing about this picture, really beautiful... :))',97, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (219, '1985-01-08', 'Bellísima.!!! saludos.',97, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (220, '1985-01-08', 'fantastic shot !!!!!!',97, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (98, 'sa28.jpg', 'sa28.jpg', 'Sport - sa28.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 98); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (221, '1985-01-08', 'that is a beautiful flower with great colours ',98, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (222, '1985-01-08', 'fantastic shot !!!!!!',98, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (223, '1985-01-08', 'Stunning capture! :-)',98, 3); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (224, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',98, 3); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (99, 'swimmer.jpg', 'swimmer.jpg', 'Sport - swimmer.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 99); --------------------------------------------------------------------- -- ALBUM - Underwater @@ -464,91 +429,86 @@ INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (6, 'Underwater', 'Underwater pictures', 1, '2009-12-18'); INSERT INTO metatags(metatag_id, tag) VALUES (6, 'Underwater'); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (101, '45000.jpg', '45000.jpg', 'Underwater - 45000.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (95, '45000.jpg', '45000.jpg', 'Underwater - 45000.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 95); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (184, '1985-01-08', 'Gorgeous! Lovely color!',95, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (185, '1985-01-08', 'Perfecft!',95, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (96, '45001.jpg', '45001.jpg', 'Underwater - 45001.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 96); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (186, '1985-01-08', 'Such a lovely colour azaga!',96, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (187, '1985-01-08', 'that is a beautiful flower with great colours ',96, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (97, '45002.jpg', '45002.jpg', 'Underwater - 45002.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 97); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (188, '1985-01-08', 'Such a lovely colour azaga!',97, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (98, '45003.jpg', '45003.jpg', 'Underwater - 45003.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 98); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (189, '1985-01-08', 'that is a beautiful flower with great colours ',98, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (190, '1985-01-08', 'Amazing shot..',98, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (99, '45004.jpg', '45004.jpg', 'Underwater - 45004.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 99); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (191, '1985-01-08', 'Bellissima macro!',99, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (100, '45005.jpg', '45005.jpg', 'Underwater - 45005.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); +INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 100); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (101, '45006.jpg', '45006.jpg', 'Underwater - 45006.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 101); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (225, '1985-01-08', 'nice shot =) ',101, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (226, '1985-01-08', 'Beautiful colours. Nice close up. ',101, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (102, '45001.jpg', '45001.jpg', 'Underwater - 45001.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (102, '45009.jpg', '45009.jpg', 'Underwater - 45009.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 102); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (227, '1985-01-08', 'this is extremely Good:) Congratulations!',102, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (228, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',102, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (229, '1985-01-08', 'nice shot =) ',102, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (103, '45002.jpg', '45002.jpg', 'Underwater - 45002.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (192, '1985-01-08', 'Gorgeous! Lovely color!',102, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (193, '1985-01-08', 'this is extremely Good:) Congratulations!',102, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (194, '1985-01-08', 'Amazing shot..',102, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (103, '45010.jpg', '45010.jpg', 'Underwater - 45010.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 103); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (104, '45003.jpg', '45003.jpg', 'Underwater - 45003.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (195, '1985-01-08', '++Beautiful',103, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (104, '45012.jpg', '45012.jpg', 'Underwater - 45012.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 104); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (230, '1985-01-08', 'Very *lovely*',104, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (231, '1985-01-08', 'Stunning capture! :-)',104, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (232, '1985-01-08', '++Beautiful',104, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (233, '1985-01-08', 'Such a lovely colour azaga!',104, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (105, '45004.jpg', '45004.jpg', 'Underwater - 45004.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (196, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',104, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (197, '1985-01-08', 'I Think this is Art!',104, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (198, '1985-01-08', 'Bellissima macro!',104, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (199, '1985-01-08', 'that is a beautiful flower with great colours ',104, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (105, '45013.jpg', '45013.jpg', 'Underwater - 45013.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 105); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (106, '45005.jpg', '45005.jpg', 'Underwater - 45005.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (106, '45014.jpg', '45014.jpg', 'Underwater - 45014.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 106); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (234, '1985-01-08', 'Such a lovely colour azaga!',106, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (235, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',106, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (236, '1985-01-08', 'Wonderful.',106, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (107, '45006.jpg', '45006.jpg', 'Underwater - 45006.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (200, '1985-01-08', 'that is a beautiful flower with great colours ',106, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (107, '45016.jpg', '45016.jpg', 'Underwater - 45016.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 107); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (237, '1985-01-08', 'Wonderful.',107, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (238, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',107, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (239, '1985-01-08', 'fantastic shot !!!!!!',107, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (108, '45009.jpg', '45009.jpg', 'Underwater - 45009.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (201, '1985-01-08', '++Beautiful',107, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (202, '1985-01-08', 'Bellísima.!!! saludos.',107, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (108, '45017.jpg', '45017.jpg', 'Underwater - 45017.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 108); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (240, '1985-01-08', 'nice shot =) ',108, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (241, '1985-01-08', 'love every thing about this picture, really beautiful... :))',108, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (109, '45010.jpg', '45010.jpg', 'Underwater - 45010.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (203, '1985-01-08', 'Such a lovely colour azaga!',108, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (204, '1985-01-08', 'I Think this is Art!',108, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (205, '1985-01-08', 'nice shot =) ',108, 1); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (109, '45018.jpg', '45018.jpg', 'Underwater - 45018.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 109); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (242, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',109, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (243, '1985-01-08', 'love every thing about this picture, really beautiful... :))',109, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (244, '1985-01-08', 'nice shot =) ',109, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (245, '1985-01-08', 'Beautiful colours. Nice close up. ',109, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (110, '45012.jpg', '45012.jpg', 'Underwater - 45012.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (206, '1985-01-08', 'Stunning capture! :-)',109, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (110, '45019.jpg', '45019.jpg', 'Underwater - 45019.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 110); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (111, '45013.jpg', '45013.jpg', 'Underwater - 45013.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (111, '45020.jpg', '45020.jpg', 'Underwater - 45020.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 111); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (112, '45014.jpg', '45014.jpg', 'Underwater - 45014.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (207, '1985-01-08', 'fantastic shot !!!!!!',111, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (208, '1985-01-08', '++Beautiful',111, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (209, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',111, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (112, '45021.jpg', '45021.jpg', 'Underwater - 45021.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 112); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (113, '45016.jpg', '45016.jpg', 'Underwater - 45016.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (210, '1985-01-08', 'Very *lovely*',112, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (211, '1985-01-08', 'this is extremely Good:) Congratulations!',112, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (212, '1985-01-08', 'Such a lovely colour azaga!',112, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (213, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',112, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (113, '45022.jpg', '45022.jpg', 'Underwater - 45022.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 113); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (246, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',113, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (114, '45017.jpg', '45017.jpg', 'Underwater - 45017.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (214, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',113, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (215, '1985-01-08', 'whoah ! wonderful',113, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (216, '1985-01-08', 'this is extremely Good:) Congratulations!',113, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (217, '1985-01-08', 'Amazing shot..',113, 2); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (114, '45023.jpg', '45023.jpg', 'Underwater - 45023.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 114); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (115, '45018.jpg', '45018.jpg', 'Underwater - 45018.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (218, '1985-01-08', 'that is a beautiful flower with great colours ',114, 3); +INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (115, '45024.jpg', '45024.jpg', 'Underwater - 45024.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 115); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (247, '1985-01-08', 'fantastic shot !!!!!!',115, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (248, '1985-01-08', 'Such a lovely colour azaga!',115, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (249, '1985-01-08', '++Beautiful',115, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (250, '1985-01-08', 'Stunning capture! :-)',115, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (116, '45019.jpg', '45019.jpg', 'Underwater - 45019.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 116); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (251, '1985-01-08', 'Perfecft!',116, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (252, '1985-01-08', 'Stunning capture! :-)',116, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (117, '45020.jpg', '45020.jpg', 'Underwater - 45020.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 117); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (253, '1985-01-08', 'fantastic shot !!!!!!',117, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (254, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',117, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (255, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',117, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (118, '45021.jpg', '45021.jpg', 'Underwater - 45021.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 118); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (256, '1985-01-08', 'Gorgeous! Lovely color!',118, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (257, '1985-01-08', 'Amazing shot..',118, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (119, '45022.jpg', '45022.jpg', 'Underwater - 45022.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 119); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (258, '1985-01-08', 'Bellísima.!!! saludos.',119, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (259, '1985-01-08', 'Wonderful.',119, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (260, '1985-01-08', '++Beautiful',119, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (261, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',119, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (120, '45023.jpg', '45023.jpg', 'Underwater - 45023.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 120); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (262, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',120, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (263, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',120, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (264, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',120, 1); -INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (121, '45024.jpg', '45024.jpg', 'Underwater - 45024.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true); -INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 121); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (265, '1985-01-08', 'that is a beautiful flower with great colours ',121, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (266, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',121, 1); -INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (267, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',121, 1); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (219, '1985-01-08', '++Beautiful',115, 3); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (220, '1985-01-08', 'Gorgeous! Lovely color!',115, 2); +INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (221, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',115, 2); INSERT INTO metatags(metatag_id, tag) VALUES (7, 'butterfly'); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 7, image_id from Images where name like '067%'); @@ -634,4 +594,3 @@ INSERT INTO metatags(metatag_id, tag) VALUES (29, 'starfish'); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 29, image_id from Images where name like '45021%'); INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 29, image_id from Images where name like '45023%'); - Modified: trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java =================================================================== --- trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java 2009-04-12 19:12:48 UTC (rev 13518) +++ trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java 2009-04-13 10:26:15 UTC (rev 13519) @@ -75,9 +75,9 @@ in.close(); } - }else{ - String prefix = excludeFilePrefix(imageResource.getPath()); - paintImage(out, fileManager.transformPath(Constants.DEFAULT_ORIGINAL_PICTURE, prefix)); + } else { + String suffix = excludeFilePrefix(imageResource.getPath()); + paintImage(out, fileManager.transformPath(Constants.DEFAULT_ORIGINAL_PICTURE, suffix)); return; } } Modified: trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageEditInfo.xhtml =================================================================== (Binary files differ) Modified: trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageInfo.xhtml =================================================================== (Binary files differ)