Author: amarkhel Date: 2009-04-09 09:52:23 -0400 (Thu, 09 Apr 2009) New Revision: 13462 Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Album.java 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/Shelf.java trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/User.java trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/Constants.java trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/SearchAction.java trunk/test-applications/realworld2/ejb/src/main/resources/import.sql Log: Refactoring FileManager Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Album.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Album.java 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Album.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -20,6 +20,7 @@ */ package org.richfaces.realworld.domain; +import java.io.File; import java.io.Serializable; import java.util.ArrayList; import java.util.Date; @@ -342,6 +343,13 @@ image.setVisited(isSetVisited); } + public String getPath(){ + if(getShelf() != null && getOwner() != null && getShelf().getPath() != null){ + return getShelf().getPath() + this.getId().toString() + File.separator; + } + return null; + } + @Override public boolean equals(Object o) { if (this == o) return true; 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-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -25,6 +25,7 @@ */ package org.richfaces.realworld.domain; +import java.io.File; import java.io.Serializable; import java.util.ArrayList; import java.util.Date; @@ -555,6 +556,13 @@ return s.toString(); } + public String getFullPath(){ + if(getAlbum() != null && getAlbum().getOwner() != null && getAlbum().getPath() != null){ + return getAlbum().getPath() + this.path; + } + return null; + } + public boolean equals(Object o) { if (this == o) return true; if (o == null || getClass() != o.getClass()) return false; Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Shelf.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Shelf.java 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Shelf.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -1,5 +1,6 @@ package org.richfaces.realworld.domain; +import java.io.File; import java.io.Serializable; import java.util.ArrayList; import java.util.Date; @@ -298,6 +299,13 @@ } return null; } + + public String getPath(){ + if(getOwner() != null && getOwner().getPath() != null){ + return getOwner().getPath() + this.getId().toString() + File.separator; + } + return null; + } public boolean equals(Object o) { if (this == o) return true; Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/User.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/User.java 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/User.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -20,6 +20,7 @@ */ package org.richfaces.realworld.domain; +import java.io.File; import java.io.Serializable; import java.util.ArrayList; import java.util.Date; @@ -354,4 +355,11 @@ } return images; } + + public String getPath(){ + if(this.getId() != null){ + return File.separator + this.getLogin().toString() + File.separator; + } + return null; + } } \ No newline at end of file Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/Constants.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/Constants.java 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/Constants.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -52,9 +52,19 @@ public static final String USER_DELETED_EVENT = "userDeletedEvent"; //Errors(Internationalization pending) + public static final String UPDATE_USER_ERROR = "Error while saving preferences to database."; + public static final String SHELF_DELETING_ERROR = "Error while deleting shelf from database."; + public static final String SHELF_SAVING_ERROR = "Error while saving shelf to database."; + public static final String DELETE_COMMENT_ERROR = "Error while deleting comment from database."; + public static final String SAVE_COMMENT_ERROR = "Error while saving comment to database."; + public static final String IMAGE_SAVING_ERROR = "Error while saving image to database."; + public static final String IMAGE_DELETING_ERROR = "Error while deleting image from database."; + public static final String ERROR_IN_DB = "Error in DB."; + public static final String ALBUM_DELETING_ERROR = "Error while deleting album from database."; + public static final String ALBUM_SAVING_ERROR = "Error while saving album to database"; public static final String SHELF_MUST_BE_NOT_NULL_ERROR = "Shelf must be not-null"; public static final String NO_SHELF_ERROR = "You must create at least one shelf before creating album!"; - public static final String ALBUM_CREATE_ERROR = "You must create at least one shelf before creating album!"; + public static final String FILE_UPLOAD_SHOW_ERROR = "You must create at least one shelf before uploading images!"; public static final String DND_ALBUM_ERROR = "You can't add album to that shelf"; public static final String DND_PHOTO_ERROR = "You can't add photo's to that album"; public static final String NO_ALBUM_TO_DOWNLOAD_ERROR = "Please specify album to download"; @@ -91,21 +101,10 @@ public static final String ADMIN_ROLE = "admin"; public static final String GUEST_ROLE = "guest"; - //Size - public static final int MEDIUM_SIZE = 600; - public static final int SMALL_200_SIZE = 200; - public static final int SMALL_160_SIZE = 160; - public static final int SMALL_120_SIZE = 120; - public static final int SMALL_80_SIZE = 80; - public static final int AVATAR_SIZE = 80; - public static final String AVATAR_JPG = "/avatar.jpg"; - public static final String _SMALL160 = "_small160"; - public static final String _SMALL120 = "_small120"; - public static final String _SMALL80 = "_small80"; - public static final String _SMALL200 = "_small200"; - public static final String _MEDIUM = "_medium"; - //misc + public static final String AVATAR_JPG = "avatar.jpg"; + public static final int AVATAR_SIZE = 80; + public static final int DEFAULT_IMAGE_SIZEVALUE = 120; public static final String SLASH = "/"; public static final String DOT = "."; public static final String JPEG = "jpeg"; Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/SearchAction.java =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/SearchAction.java 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/SearchAction.java 2009-04-09 13:52:23 UTC (rev 13462) @@ -51,8 +51,7 @@ @In(value="entityManager") EntityManager em; - @In - private User user; + @In private User user; /** * Return List of albums, founded by query Modified: trunk/test-applications/realworld2/ejb/src/main/resources/import.sql =================================================================== --- trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-09 13:52:12 UTC (rev 13461) +++ trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-09 13:52:23 UTC (rev 13462) @@ -13,67 +13,67 @@ 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', 'amarkhel/0/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) 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_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', 'amarkhel/0/10005.jpg', 'Animals - 10005.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/400004.jpg', 'Animals - 400004.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/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) 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_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', 'amarkhel/0/400027.jpg', 'Animals - 400027.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/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 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 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', 'amarkhel/0/400034.jpg', 'Animals - 400034.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/400035.jpg', 'Animals - 400035.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/400063.jpg', 'Animals - 400063.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'amarkhel/0/400095.jpg', 'Animals - 400095.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/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) 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_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', 'amarkhel/0/dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, '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) VALUES (11, 'dog2.jpg', 'dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', 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', 'amarkhel/0/pinn40.jpg', 'Animals - pinn40.jpg image', '2009-12-18', 0, '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) 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 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', 'amarkhel/0/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) 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_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 images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (15, 'turtle.jpg', 'amarkhel/0/turtle.jpg', 'Animals - turtle.jpg image', '2009-12-18', 0, '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) 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); @@ -83,78 +83,78 @@ 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', 'Viking/1/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) 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_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', 'Viking/1/2.jpg', 'Building - 2.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/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 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 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', 'Viking/1/4.jpg', 'Building - 4.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/400018.jpg', 'Building - 400018.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/400036.jpg', 'Building - 400036.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'Viking/1/400069.jpg', 'Building - 400069.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/400076.jpg', 'Building - 400076.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/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) 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_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', 'Viking/1/5.jpg', 'Building - 5.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/6.jpg', 'Building - 6.jpg image', '2009-12-18', 1, '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) 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 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', 'Viking/1/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) 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_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', 'Viking/1/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) 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_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', 'Viking/1/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) 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_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', 'Viking/1/pinn82.jpg', 'Building - pinn82.jpg image', '2009-12-18', 1, '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) 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', 'Viking/1/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(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); @@ -166,66 +166,66 @@ 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', 'Noname/2/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) 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_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', 'Noname/2/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) 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_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', 'Noname/2/203036.jpg', 'Coasts - 203036.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'Noname/2/203043.jpg', 'Coasts - 203043.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203049.jpg', 'Coasts - 203049.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, '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) VALUES (37, '203052.jpg', '203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', 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', 'Noname/2/203053.jpg', 'Coasts - 203053.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203054.jpg', 'Coasts - 203054.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203058.jpg', 'Coasts - 203058.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203066.jpg', 'Coasts - 203066.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/203067.jpg', 'Coasts - 203067.jpg image', '2009-12-18', 2, '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) 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 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', 'Noname/2/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) 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_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', 'Noname/2/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) 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_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', 'Noname/2/203073.jpg', 'Coasts - 203073.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) 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', 'Noname/2/203076.jpg', 'Coasts - 203076.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) 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); @@ -235,60 +235,60 @@ 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', 'amarkhel/3/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) 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_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', 'amarkhel/3/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) 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_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', 'amarkhel/3/132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, '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) VALUES (50, '132051.jpg', '132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', 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', 'amarkhel/3/132059.jpg', 'Flora - 132059.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/132060.jpg', 'Flora - 132060.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/132071.jpg', 'Flora - 132071.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/132074.jpg', 'Flora - 132074.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/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) 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_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', 'amarkhel/3/142011.jpg', 'Flora - 142011.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/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 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 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', 'amarkhel/3/167049.jpg', 'Flora - 167049.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/167055.jpg', 'Flora - 167055.jpg image', '2009-12-18', 3, '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) 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 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', 'amarkhel/3/400010.jpg', 'Flora - 400010.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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', 'amarkhel/3/400073.jpg', 'Flora - 400073.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) 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', 'amarkhel/3/403011.jpg', 'Flora - 403011.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) 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); --------------------------------------------------------------------- @@ -297,92 +297,92 @@ 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', 'Viking/4/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) 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_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', 'Viking/4/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) 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_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', 'Viking/4/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) 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_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', 'Viking/4/184033.jpg', 'Ices - 184033.jpg image', '2009-12-18', 4, '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) 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 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', 'Viking/4/184034.jpg', 'Ices - 184034.jpg image', '2009-12-18', 4, '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) 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 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', 'Viking/4/184035.jpg', 'Ices - 184035.jpg image', '2009-12-18', 4, '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) 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 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', 'Viking/4/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 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 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', 'Viking/4/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) 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_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', 'Viking/4/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) 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_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', 'Viking/4/184046.jpg', 'Ices - 184046.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'Viking/4/184047.jpg', 'Ices - 184047.jpg image', '2009-12-18', 4, '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) 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 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', 'Viking/4/184053.jpg', 'Ices - 184053.jpg image', '2009-12-18', 4, '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) 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 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', 'Viking/4/184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, '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) VALUES (76, '184057.jpg', '184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', 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', 'Viking/4/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) 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_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', 'Viking/4/184069.jpg', 'Ices - 184069.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) 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 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', 'Viking/4/184072.jpg', 'Ices - 184072.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) 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 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', 'Viking/4/184077.jpg', 'Ices - 184077.jpg image', '2009-12-18', 4, '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) 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', 'Viking/4/184078.jpg', 'Ices - 184078.jpg image', '2009-12-18', 4, '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) 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', 'Viking/4/184079.jpg', 'Ices - 184079.jpg image', '2009-12-18', 4, '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) 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', 'Viking/4/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(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); @@ -393,69 +393,69 @@ 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', 'Noname/5/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) 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_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', 'Noname/5/400003.jpg', 'Sport - 400003.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'Noname/5/400033.jpg', 'Sport - 400033.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/400048.jpg', 'Sport - 400048.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/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) 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_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', 'Noname/5/479031.jpg', 'Sport - 479031.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/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) 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_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', 'Noname/5/hghjump.jpg', 'Sport - hghjump.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/pinn01.jpg', 'Sport - pinn01.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/pinn04.jpg', 'Sport - pinn04.jpg image', '2009-12-18', 5, '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) 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 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', 'Noname/5/pinn29.jpg', 'Sport - pinn29.jpg image', '2009-12-18', 5, '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) 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', 'Noname/5/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(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', 'Noname/5/pinn64.jpg', 'Sport - pinn64.jpg image', '2009-12-18', 5, '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) 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', 'Noname/5/sa28.jpg', 'Sport - sa28.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) 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', 'Noname/5/swimmer.jpg', 'Sport - swimmer.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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); --------------------------------------------------------------------- @@ -464,87 +464,87 @@ 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', 'amarkhel/6/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) 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_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', 'amarkhel/6/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) 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_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', 'amarkhel/6/45002.jpg', 'Underwater - 45002.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/45003.jpg', 'Underwater - 45003.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/45004.jpg', 'Underwater - 45004.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/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) 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_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', 'amarkhel/6/45006.jpg', 'Underwater - 45006.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/45009.jpg', 'Underwater - 45009.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/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 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 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', 'amarkhel/6/45012.jpg', 'Underwater - 45012.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/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) 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_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', 'amarkhel/6/45014.jpg', 'Underwater - 45014.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true); +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 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', 'amarkhel/6/45016.jpg', 'Underwater - 45016.jpg image', '2009-12-18', 6, '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) 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 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', 'amarkhel/6/45017.jpg', 'Underwater - 45017.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) 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 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', 'amarkhel/6/45018.jpg', 'Underwater - 45018.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) VALUES (115, '45018.jpg', '45018.jpg', 'Underwater - 45018.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', 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', 'amarkhel/6/45019.jpg', 'Underwater - 45019.jpg image', '2009-12-18', 6, '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) 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', 'amarkhel/6/45020.jpg', 'Underwater - 45020.jpg image', '2009-12-18', 6, '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) 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', 'amarkhel/6/45021.jpg', 'Underwater - 45021.jpg image', '2009-12-18', 6, '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) 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', 'amarkhel/6/45022.jpg', 'Underwater - 45022.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) 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', 'amarkhel/6/45023.jpg', 'Underwater - 45023.jpg image', '2009-12-18', 6, '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) 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', 'amarkhel/6/45024.jpg', 'Underwater - 45024.jpg image', '2009-12-18', 6, '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) 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);