richfaces-svn-commits
April 2009
richfaces-svn-commits@lists.jboss.org
- 1 participants
- 645 discussions
JBoss Rich Faces SVN: r13526 - Reports/3.3.1 and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: tkuprevich
Date: 2009-04-13 08:24:22 -0400 (Mon, 13 Apr 2009)
New Revision: 13526
Modified:
trunk/test-applications/qa/Test Reports/3.3.1/RFTestReport3.3.1.BETA3.xls
Log:
Modified: trunk/test-applications/qa/Test Reports/3.3.1/RFTestReport3.3.1.BETA3.xls
===================================================================
(Binary files differ)
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13525 - in trunk/samples/richfaces-demo/src/main: webapp/richfaces/columns/examples and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-04-13 08:21:55 -0400 (Mon, 13 Apr 2009)
New Revision: 13525
Modified:
trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/DataTableScrollerBean.java
trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/Facet.java
trunk/samples/richfaces-demo/src/main/webapp/richfaces/columns/examples/example.xhtml
Log:
https://jira.jboss.org/jira/browse/RF-6680
Modified: trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/DataTableScrollerBean.java
===================================================================
--- trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/DataTableScrollerBean.java 2009-04-13 12:16:48 UTC (rev 13524)
+++ trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/DataTableScrollerBean.java 2009-04-13 12:21:55 UTC (rev 13525)
@@ -12,8 +12,6 @@
import java.util.Random;
import java.util.Set;
-import javax.faces.context.FacesContext;
-
import org.richfaces.component.UIScrollableDataTable;
import org.richfaces.demo.datafilterslider.DemoInventoryItem;
import org.richfaces.model.SortField;
Modified: trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/Facet.java
===================================================================
--- trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/Facet.java 2009-04-13 12:16:48 UTC (rev 13524)
+++ trunk/samples/richfaces-demo/src/main/java/org/richfaces/datatablescroller/Facet.java 2009-04-13 12:21:55 UTC (rev 13525)
@@ -6,6 +6,9 @@
package org.richfaces.datatablescroller;
+import org.richfaces.model.Ordering;
+
+
/**
* TODO Class description goes here.
* @author "Andrey Markavtsov"
@@ -49,5 +52,14 @@
public void setFooter(String footer) {
this.footer = footer;
}
+
+ private Ordering sortOrder;
+ public Ordering getSortOrder() {
+ return sortOrder;
+ }
+
+ public void setSortOrder(Ordering sortOrder) {
+ this.sortOrder = sortOrder;
+ }
}
Modified: trunk/samples/richfaces-demo/src/main/webapp/richfaces/columns/examples/example.xhtml
===================================================================
--- trunk/samples/richfaces-demo/src/main/webapp/richfaces/columns/examples/example.xhtml 2009-04-13 12:16:48 UTC (rev 13524)
+++ trunk/samples/richfaces-demo/src/main/webapp/richfaces/columns/examples/example.xhtml 2009-04-13 12:21:55 UTC (rev 13525)
@@ -12,7 +12,7 @@
</f:facet>
<rich:columns value="#{dataTableScrollerBean.columns}" var="columns"
- index="ind" sortBy="#{model[ind].price}">
+ index="ind" id="column#{ind}" sortBy="#{model[ind].price}" sortOrder="#{columns.sortOrder}">
<f:facet name="header">
<h:outputText value="#{columns.header}" />
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13524 - in trunk/ui/scrollableDataTable/src/main: javascript/ClientUI/controls/grid and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: konstantin.mishin
Date: 2009-04-13 08:16:48 -0400 (Mon, 13 Apr 2009)
New Revision: 13524
Modified:
trunk/ui/scrollableDataTable/src/main/java/org/richfaces/renderkit/html/ScrollableDataTableBaseRenderer.java
trunk/ui/scrollableDataTable/src/main/javascript/ClientUI/controls/grid/GridBody.js
Log:
RF-5054
Modified: trunk/ui/scrollableDataTable/src/main/java/org/richfaces/renderkit/html/ScrollableDataTableBaseRenderer.java
===================================================================
--- trunk/ui/scrollableDataTable/src/main/java/org/richfaces/renderkit/html/ScrollableDataTableBaseRenderer.java 2009-04-13 11:54:15 UTC (rev 13523)
+++ trunk/ui/scrollableDataTable/src/main/java/org/richfaces/renderkit/html/ScrollableDataTableBaseRenderer.java 2009-04-13 12:16:48 UTC (rev 13524)
@@ -659,18 +659,28 @@
String s_id = clientId + ":si";
grid.resetReqRowsCount();
+ String firstString = null;
if(parameters.containsKey(s_id)){
String options = (String)parameters.get(s_id);
grid.setScrollPos(options);
if(options.length() > 0){
String[] si = options.split(",");
- grid.setFirst(Integer.parseInt(si[1]));
+ firstString = si[1];
+ if (si.length >= 5) {
+ grid.setFirst(Integer.parseInt(si[4]));
+ } else {
+ grid.setFirst(Integer.parseInt(firstString));
+ }
component.getAttributes().put(ScrollableDataTableUtils.CLIENT_ROW_KEY, Integer.parseInt(si[3]));
}
}
composite.decode(context, component);
+ if (firstString != null) {
+ grid.setFirst(Integer.parseInt(firstString));
+ }
+
if(parameters.containsKey(clientId + ":sortColumn") &&
parameters.containsKey(clientId + ":sortStartRow") &&
parameters.containsKey(clientId + ":sortIndex")){
Modified: trunk/ui/scrollableDataTable/src/main/javascript/ClientUI/controls/grid/GridBody.js
===================================================================
--- trunk/ui/scrollableDataTable/src/main/javascript/ClientUI/controls/grid/GridBody.js 2009-04-13 11:54:15 UTC (rev 13523)
+++ trunk/ui/scrollableDataTable/src/main/javascript/ClientUI/controls/grid/GridBody.js 2009-04-13 12:16:48 UTC (rev 13524)
@@ -376,6 +376,9 @@
if(countToLoad > 0 && process) {
this.updateStarted = true;
ClientUILib.log(ClientUILogger.WARNING, "Start loading: index: " + startIndex + ", and startRow: " + startRowIndx + ", and count: " + countToLoad);
+
+ this.scrollInput.value = task.pos + "," + range.start + "," + range.end + "," + firstIndex + "," + this.currRange.start;
+
this.currRange = range;
this.currentPos = task.pos;
@@ -633,7 +636,7 @@
this.currentPos = values[0];
this.currRange.start = values[1];
this.currRange.end = values[2];
- this.scrollBox.getElement().scrollTop = this.sizeBox.getHeight(); // values[0];
+ this.scrollBox.getElement().scrollTop = values[0];
var visibleRowPos = this.currRange.start * this.defaultRowHeight;
this._showContainer();
this.templFrozen.moveToY(visibleRowPos);
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13523 - trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/manager.
by richfaces-svn-commits＠lists.jboss.org
Author: amarkhel
Date: 2009-04-13 07:54:15 -0400 (Mon, 13 Apr 2009)
New Revision: 13523
Modified:
trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/manager/Authenticator.java
Log:
Modified: trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/manager/Authenticator.java
===================================================================
--- trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/manager/Authenticator.java 2009-04-13 11:54:10 UTC (rev 13522)
+++ trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/manager/Authenticator.java 2009-04-13 11:54:15 UTC (rev 13523)
@@ -113,7 +113,12 @@
return null;
}
user.setPasswordHash(hash(user.getPassword()));
- userAction.register(user);
+ try{
+ userAction.register(user);
+ }
+ catch(Exception e){
+ return null;
+ }
return Constants.INDEX_OUTCOME;
}
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13522 - in trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld: service and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: amarkhel
Date: 2009-04-13 07:54:10 -0400 (Mon, 13 Apr 2009)
New Revision: 13522
Modified:
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/AlbumAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IImageAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IUserAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ImageAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/RealworldException.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ShelfAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/UserAction.java
Log:
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-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -81,9 +81,7 @@
@NamedQuery(
name = "tag-suggest",
query = "select m from MetaTag m where lower(m.tag) like :tag"
- )
- }
-)
+ )})
/**
* Class for representing Image Entity
* EJB3 Entity Bean
@@ -94,7 +92,7 @@
@Entity
@Name("image")
@Table(name = "Images", uniqueConstraints = {
- @UniqueConstraint(columnNames = "path"),
+ @UniqueConstraint(columnNames = "path")
})
@Scope(ScopeType.CONVERSATION)
@AutoCreate
@@ -185,22 +183,47 @@
this.showMetaInfo = showMetaInfo;
}
- public Long getId() {
+ /**
+ * Getter for property id
+ *
+ * @return id of image
+ */
+ public Long getId() {
return id;
}
+ /**
+ * Getter for property name
+ *
+ * @return name of image
+ */
public String getName() {
return name;
}
+ /**
+ * Setter for property name
+ *
+ * @param name - name of image
+ */
public void setName(String name) {
this.name = name;
}
+ /**
+ * Getter for property description
+ *
+ * @return description of image
+ */
public String getDescription() {
return description;
}
+ /**
+ * Setter for property description
+ *
+ * @param description - description of image
+ */
public void setDescription(String description) {
this.description = description;
}
@@ -217,18 +240,38 @@
return path;
}
+ /**
+ * Setter for property path
+ *
+ * @param path - relative path to image
+ */
public void setPath(String path) {
this.path = path;
}
+ /**
+ * Getter for property created
+ *
+ * @return date of creation of this image
+ */
public Date getCreated() {
return created;
}
+ /**
+ * Setter for property created
+ *
+ * @param created - date of creation
+ */
public void setCreated(Date created) {
this.created = created;
}
+ /**
+ * Getter for property album
+ *
+ * @return containing album
+ */
public Album getAlbum() {
return album;
}
@@ -261,6 +304,8 @@
}
/**
+ * Setter for property meta
+ *
* @param meta - string representation of metatags, associated to image. Used at jsf page.
*/
public void setMeta(String meta) {
@@ -268,7 +313,8 @@
}
/**
- *
+ * Getter for property meta
+ *
* @return string representation of metatags, associated to image. Used at jsf page.
*/
public String getMetaString(){
@@ -276,6 +322,7 @@
}
/**
+ * Getter for property cameraModel
*
* @return model of camera
*/
@@ -284,6 +331,7 @@
}
/**
+ * setter for property cameraModel
*
* @param cameraModel- model of camera
*/
@@ -292,6 +340,7 @@
}
/**
+ * Getter for property height
*
* @return height of image
*/
@@ -300,6 +349,7 @@
}
/**
+ * setter for property height
*
* @param height - height of image
*/
@@ -308,6 +358,7 @@
}
/**
+ * Getter for property size
*
* @return size of image in KB
*/
@@ -316,6 +367,7 @@
}
/**
+ * setter for property size
*
* @param size - size of image in KB
*/
@@ -324,6 +376,7 @@
}
/**
+ * Getter for property width
*
* @return width of image
*/
@@ -332,6 +385,7 @@
}
/**
+ * setter for property width
*
* @param width - width of image
*/
@@ -340,6 +394,7 @@
}
/**
+ * Getter for property uploaded
*
* @return date of upload to site of this image
*/
@@ -348,6 +403,7 @@
}
/**
+ * setter for property uploaded
*
* @param uploaded - date of upload
*/
@@ -388,6 +444,7 @@
}
/**
+ * Getter for property visited
*
* @return boolean value, that indicated is user visit this image already
*/
@@ -396,6 +453,7 @@
}
/**
+ * Setter for property visited
*
* @param visited - boolean value, that indicated is user visit this image already
*/
@@ -404,6 +462,7 @@
}
/**
+ * Determine if this image should be marked as new(on jsf page, for example in tree)
*
* @return boolean value, that indicated is this image should be marked as new
*/
@@ -416,6 +475,11 @@
//---------------------------Business methods
+ /**
+ * Add comment to this image.
+ *
+ * @param comment - comment to add
+ */
public void addComment(Comment comment) {
if (comment == null) {
throw new IllegalArgumentException("Null comment!");
@@ -424,6 +488,11 @@
comments.add(comment);
}
+ /**
+ * Remove comment from list of comments, belongs to that image.
+ *
+ * @param comment - comment to delete
+ */
public void removeComment(Comment comment) {
if (comment == null) {
throw new IllegalArgumentException("Null comment");
@@ -436,6 +505,11 @@
}
}
+ /**
+ * Add metatag to this image.
+ *
+ * @param metatag - metatag to add
+ */
public void addMetaTag(MetaTag metatag) {
if (metatag == null) {
throw new IllegalArgumentException("Null metatag!");
@@ -446,6 +520,11 @@
}
}
+ /**
+ * Remove metatag from list of metatag, associated to that image.
+ *
+ * @param metatag - metatag to delete
+ */
public void removeMetaTag(MetaTag metatag) {
if (metatag == null) {
throw new IllegalArgumentException("Null metatag!");
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/AlbumAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/AlbumAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/AlbumAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -48,8 +48,9 @@
/**
* Persist album entity to database
* @param album - album to add
+ * @throws RealworldException
*/
- public void addAlbum(Album album) {
+ public void addAlbum(Album album) throws RealworldException {
try{
em.persist(album);
//Add to shelf
@@ -64,8 +65,9 @@
/**
* Remove album entity from database
* @param album - album to delete
+ * @throws RealworldException
*/
- public void deleteAlbum(Album album){
+ public void deleteAlbum(Album album) throws RealworldException{
try{
if(album.getShelf() == null){
return;
@@ -83,8 +85,9 @@
/**
* Synchronize state of album entity with database
* @param album - album to Synchronize
+ * @throws RealworldException
*/
- public void editAlbum(Album album){
+ public void editAlbum(Album album) throws RealworldException{
try{
em.flush();
}
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -36,10 +36,10 @@
@Local
public interface IAlbumAction {
- void addAlbum(Album album);
+ void addAlbum(Album album) throws RealworldException;
- void deleteAlbum(Album album);
+ void deleteAlbum(Album album) throws RealworldException;
- void editAlbum(Album album);
+ void editAlbum(Album album) throws RealworldException;
}
\ No newline at end of file
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IImageAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IImageAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IImageAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -37,15 +37,15 @@
@Local
public interface IImageAction {
- public void deleteImage(Image image);
+ public void deleteImage(Image image) throws RealworldException;
- public void editImage(Image image, boolean metatagsChanged);
+ public void editImage(Image image, boolean metatagsChanged) throws RealworldException;
- public void addImage(Image image);
+ public void addImage(Image image) throws RealworldException;
- public void deleteComment(Comment comment);
+ public void deleteComment(Comment comment) throws RealworldException;
- public void addComment(Comment comment);
+ public void addComment(Comment comment) throws RealworldException;
public MetaTag getTagByName(String tag);
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -37,11 +37,11 @@
@Local
public interface IShelfAction {
- void addShelf(Shelf shelf);
-
- void deleteShelf(Shelf shelf);
-
- void editShelf(Shelf shelf);
-
+ void addShelf(Shelf shelf) throws RealworldException;
+
+ void deleteShelf(Shelf shelf) throws RealworldException;
+
+ void editShelf(Shelf shelf) throws RealworldException;
+
List<Shelf> getShelfs(User user);
}
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IUserAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IUserAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IUserAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -33,7 +33,7 @@
@Local
public interface IUserAction {
public User login(String username, String password);
- public void register(User user);
- public boolean isUserExist(String login);
- public User updateUser();
+ public void register(User user) throws RealworldException;
+ public boolean isUserExist(String login) ;
+ public User updateUser() throws RealworldException;
}
\ No newline at end of file
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ImageAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ImageAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ImageAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -52,8 +52,9 @@
/**
* Remove image entity from database
* @param image - image to delete
+ * @throws RealworldException
*/
- public void deleteImage(Image image) {
+ public void deleteImage(Image image) throws RealworldException {
try{
if(image.getAlbum().getCoveringImage().equals(image)){
image.getAlbum().setCoveringImage(null);
@@ -71,8 +72,9 @@
* Synchronize state of image entity with database
* @param image - image to Synchronize
* @param metatagsChanged - boolean value, that indicates is metatags of this image were changed(add new or delete older)
+ * @throws RealworldException
*/
- public void editImage(Image image, boolean metatagsChanged) {
+ public void editImage(Image image, boolean metatagsChanged) throws RealworldException {
try{
if(metatagsChanged){
//Create cash of metatags early associated with image
@@ -131,8 +133,9 @@
/**
* Persist image entity to database
* @param image - image to add
+ * @throws RealworldException
*/
- public void addImage(Image image) {
+ public void addImage(Image image) throws RealworldException {
try{
em.persist(image);
image.getAlbum().addImage(image);
@@ -146,8 +149,9 @@
/**
* Remove comment from image
* @param comment - comment to remove
+ * @throws RealworldException
*/
- public void deleteComment(Comment comment) {
+ public void deleteComment(Comment comment) throws RealworldException {
try{
comment.getImage().removeComment(comment);
em.flush();
@@ -160,8 +164,9 @@
/**
* Add comment from image
* @param comment - comment to add
+ * @throws RealworldException
*/
- public void addComment(Comment comment) {
+ public void addComment(Comment comment) throws RealworldException {
try{
comment.getImage().addComment(comment);
em.flush();
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/RealworldException.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/RealworldException.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/RealworldException.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -1,9 +1,10 @@
package org.richfaces.realworld.service;
-import org.jboss.seam.annotations.ApplicationException;
+import javax.ejb.ApplicationException;
+
@ApplicationException(rollback=false)
-public class RealworldException extends RuntimeException {
+public class RealworldException extends Exception {
public RealworldException()
{
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ShelfAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ShelfAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/ShelfAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -54,8 +54,9 @@
/**
* Persist shelf entity to database
* @param shelf - shelf to add
+ * @throws RealworldException
*/
- public void addShelf(Shelf shelf) {
+ public void addShelf(Shelf shelf) throws RealworldException {
try{
em.persist(shelf);
//Add reference to user
@@ -70,8 +71,9 @@
/**
* Remove shelf entity from database
* @param shelf - shelf to delete
+ * @throws RealworldException
*/
- public void deleteShelf(Shelf shelf) {
+ public void deleteShelf(Shelf shelf) throws RealworldException {
//Remove reference from user
try{
user.removeShelf(shelf);
@@ -86,8 +88,9 @@
/**
* Synchronize state of shelf entity with database
* @param shelf - shelf to Synchronize
+ * @throws RealworldException
*/
- public void editShelf(Shelf shelf) {
+ public void editShelf(Shelf shelf) throws RealworldException {
try{
em.flush();
}
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/UserAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/UserAction.java 2009-04-13 11:29:41 UTC (rev 13521)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/UserAction.java 2009-04-13 11:54:10 UTC (rev 13522)
@@ -61,8 +61,9 @@
/**
* Persist user entity to database
* @param user - user to register
+ * @throws RealworldException
*/
- public void register(User user) {
+ public void register(User user) throws RealworldException {
try{
em.persist(user);
em.flush();
@@ -75,8 +76,9 @@
/**
* Synchronize state of user entity with database
* @return user if success
+ * @throws RealworldException
*/
- public User updateUser() {
+ public User updateUser() throws RealworldException {
try{
em.flush();
}
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13521 - trunk/samples/richfaces-demo/src/main/webapp/richfaces/tree/examples.
by richfaces-svn-commits＠lists.jboss.org
Author: ilya_shaikovsky
Date: 2009-04-13 07:29:41 -0400 (Mon, 13 Apr 2009)
New Revision: 13521
Modified:
trunk/samples/richfaces-demo/src/main/webapp/richfaces/tree/examples/simple-tree-data-dnd.properties
Log:
problematic space removed.(TO DO using trim in the bean)
Modified: trunk/samples/richfaces-demo/src/main/webapp/richfaces/tree/examples/simple-tree-data-dnd.properties
===================================================================
--- trunk/samples/richfaces-demo/src/main/webapp/richfaces/tree/examples/simple-tree-data-dnd.properties 2009-04-13 11:28:09 UTC (rev 13520)
+++ trunk/samples/richfaces-demo/src/main/webapp/richfaces/tree/examples/simple-tree-data-dnd.properties 2009-04-13 11:29:41 UTC (rev 13521)
@@ -1,5 +1,5 @@
#path=name - type - icon
-1=Unsorted - node - image.gif
+1=Unsorted - node - image.gif
1.1=pic1.jpg - leaf
1.2=pic2.jpg - leaf
1.3=pic3.jpg - leaf
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13520 - trunk/test-applications/realworld2/ejb/src/main/resources.
by richfaces-svn-commits＠lists.jboss.org
Author: Alex.Kolonitsky
Date: 2009-04-13 07:28:09 -0400 (Mon, 13 Apr 2009)
New Revision: 13520
Modified:
trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
Log:
remove preDefined from import.sql
Modified: trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-13 10:26:15 UTC (rev 13519)
+++ trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-13 11:28:09 UTC (rev 13520)
@@ -2,10 +2,10 @@
INSERT INTO Users(user_id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar) VALUES (2, 'Nick', 'Curtis', 'nkurtis(a)iba.com', 'Viking', '8cb2237d0679ca88db6464eac60da96345513964', '1978-01-08', 1, 0);
INSERT INTO Users(user_id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar) VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname', '8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08', 1, 0);
-INSERT INTO shelves(shelf_id, name, description, user_id, created, shared, preDefined) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true, true);
-INSERT INTO shelves(shelf_id, name, description, user_id, created, shared, preDefined) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true, true);
-INSERT INTO shelves(shelf_id, name, description, user_id, created, shared, preDefined) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true, true);
-INSERT INTO shelves(shelf_id, name, description, user_id, created, shared, preDefined) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true, true);
+INSERT INTO shelves(shelf_id, name, description, user_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO shelves(shelf_id, name, description, user_id, created, shared) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO shelves(shelf_id, name, description, user_id, created, shared) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true);
+INSERT INTO shelves(shelf_id, name, description, user_id, created, shared) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true);
---------------------------------------------------------------------
-- ALBUM - Animals
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13519 - in trunk/test-applications/realworld2: ejb/src/main/java/org/richfaces/realworld/service and 3 other directories.
by richfaces-svn-commits＠lists.jboss.org
Author: Alex.Kolonitsky
Date: 2009-04-13 06:26:15 -0400 (Mon, 13 Apr 2009)
New Revision: 13519
Modified:
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java
trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java
trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java
trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageEditInfo.xhtml
trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageInfo.xhtml
Log:
add show meta info field t image
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-12 19:12:48 UTC (rev 13518)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/domain/Image.java 2009-04-13 10:26:15 UTC (rev 13519)
@@ -52,6 +52,9 @@
import org.hibernate.validator.Length;
import org.hibernate.validator.NotEmpty;
import org.hibernate.validator.NotNull;
+import org.hibernate.annotations.LazyCollection;
+import org.hibernate.annotations.LazyCollectionOption;
+import org.hibernate.annotations.OrderBy;
import org.jboss.seam.ScopeType;
import org.jboss.seam.annotations.AutoCreate;
import org.jboss.seam.annotations.Name;
@@ -159,8 +162,8 @@
private Date created;
@OneToMany(mappedBy = "image", cascade = {CascadeType.ALL}, fetch = FetchType.LAZY)
- @org.hibernate.annotations.LazyCollection(org.hibernate.annotations.LazyCollectionOption.EXTRA)
- @org.hibernate.annotations.OrderBy(clause = "date asc")
+ @LazyCollection(LazyCollectionOption.EXTRA)
+ @OrderBy(clause = "date asc")
private List<Comment> comments = new ArrayList<Comment>();
@ManyToOne(fetch = FetchType.LAZY)
@@ -170,49 +173,34 @@
@NotNull
private boolean allowComments;
- // ********************** Accessor Methods ********************** //
+ private Boolean showMetaInfo = true;
- /**
- * Getter for property id
- *
- * @return id of image
- */
- public Long getId() {
+ // ********************** Accessor Methods ********************** //
+
+ public Boolean getShowMetaInfo() {
+ return showMetaInfo;
+ }
+
+ public void setShowMetaInfo(final Boolean showMetaInfo) {
+ this.showMetaInfo = showMetaInfo;
+ }
+
+ public Long getId() {
return id;
}
- /**
- * Getter for property name
- *
- * @return name of image
- */
public String getName() {
return name;
}
- /**
- * Setter for property name
- *
- * @param name - name of image
- */
public void setName(String name) {
this.name = name;
}
- /**
- * Getter for property description
- *
- * @return description of image
- */
public String getDescription() {
return description;
}
- /**
- * Setter for property description
- *
- * @param description - description of image
- */
public void setDescription(String description) {
this.description = description;
}
@@ -229,38 +217,18 @@
return path;
}
- /**
- * Setter for property path
- *
- * @param path - relative path to image
- */
public void setPath(String path) {
this.path = path;
}
- /**
- * Getter for property created
- *
- * @return date of creation of this image
- */
public Date getCreated() {
return created;
}
- /**
- * Setter for property created
- *
- * @param created - date of creation
- */
public void setCreated(Date created) {
this.created = created;
}
- /**
- * Getter for property album
- *
- * @return containing album
- */
public Album getAlbum() {
return album;
}
@@ -293,8 +261,6 @@
}
/**
- * Setter for property meta
- *
* @param meta - string representation of metatags, associated to image. Used at jsf page.
*/
public void setMeta(String meta) {
@@ -302,8 +268,7 @@
}
/**
- * Getter for property meta
- *
+ *
* @return string representation of metatags, associated to image. Used at jsf page.
*/
public String getMetaString(){
@@ -311,7 +276,6 @@
}
/**
- * Getter for property cameraModel
*
* @return model of camera
*/
@@ -320,7 +284,6 @@
}
/**
- * setter for property cameraModel
*
* @param cameraModel- model of camera
*/
@@ -329,7 +292,6 @@
}
/**
- * Getter for property height
*
* @return height of image
*/
@@ -338,7 +300,6 @@
}
/**
- * setter for property height
*
* @param height - height of image
*/
@@ -347,7 +308,6 @@
}
/**
- * Getter for property size
*
* @return size of image in KB
*/
@@ -356,7 +316,6 @@
}
/**
- * setter for property size
*
* @param size - size of image in KB
*/
@@ -365,7 +324,6 @@
}
/**
- * Getter for property width
*
* @return width of image
*/
@@ -374,7 +332,6 @@
}
/**
- * setter for property width
*
* @param width - width of image
*/
@@ -383,7 +340,6 @@
}
/**
- * Getter for property uploaded
*
* @return date of upload to site of this image
*/
@@ -392,7 +348,6 @@
}
/**
- * setter for property uploaded
*
* @param uploaded - date of upload
*/
@@ -433,7 +388,6 @@
}
/**
- * Getter for property visited
*
* @return boolean value, that indicated is user visit this image already
*/
@@ -442,7 +396,6 @@
}
/**
- * Setter for property visited
*
* @param visited - boolean value, that indicated is user visit this image already
*/
@@ -451,7 +404,6 @@
}
/**
- * Determine if this image should be marked as new(on jsf page, for example in tree)
*
* @return boolean value, that indicated is this image should be marked as new
*/
@@ -464,11 +416,6 @@
//---------------------------Business methods
- /**
- * Add comment to this image.
- *
- * @param comment - comment to add
- */
public void addComment(Comment comment) {
if (comment == null) {
throw new IllegalArgumentException("Null comment!");
@@ -477,11 +424,6 @@
comments.add(comment);
}
- /**
- * Remove comment from list of comments, belongs to that image.
- *
- * @param comment - comment to delete
- */
public void removeComment(Comment comment) {
if (comment == null) {
throw new IllegalArgumentException("Null comment");
@@ -494,11 +436,6 @@
}
}
- /**
- * Add metatag to this image.
- *
- * @param metatag - metatag to add
- */
public void addMetaTag(MetaTag metatag) {
if (metatag == null) {
throw new IllegalArgumentException("Null metatag!");
@@ -509,11 +446,6 @@
}
}
- /**
- * Remove metatag from list of metatag, associated to that image.
- *
- * @param metatag - metatag to delete
- */
public void removeMetaTag(MetaTag metatag) {
if (metatag == null) {
throw new IllegalArgumentException("Null metatag!");
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-12 19:12:48 UTC (rev 13518)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IAlbumAction.java 2009-04-13 10:26:15 UTC (rev 13519)
@@ -36,10 +36,10 @@
@Local
public interface IAlbumAction {
- public abstract void addAlbum(Album album);
+ void addAlbum(Album album);
- public void deleteAlbum(Album album);
+ void deleteAlbum(Album album);
- public void editAlbum(Album album);
+ void editAlbum(Album album);
}
\ No newline at end of file
Modified: trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-12 19:12:48 UTC (rev 13518)
+++ trunk/test-applications/realworld2/ejb/src/main/java/org/richfaces/realworld/service/IShelfAction.java 2009-04-13 10:26:15 UTC (rev 13519)
@@ -37,11 +37,11 @@
@Local
public interface IShelfAction {
- public abstract void addShelf(Shelf shelf);
-
- public void deleteShelf(Shelf shelf);
-
- public void editShelf(Shelf shelf);
-
- public List<Shelf> getShelfs(User user);
+ void addShelf(Shelf shelf);
+
+ void deleteShelf(Shelf shelf);
+
+ void editShelf(Shelf shelf);
+
+ List<Shelf> getShelfs(User user);
}
Modified: trunk/test-applications/realworld2/ejb/src/main/resources/import.sql
===================================================================
--- trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-12 19:12:48 UTC (rev 13518)
+++ trunk/test-applications/realworld2/ejb/src/main/resources/import.sql 2009-04-13 10:26:15 UTC (rev 13519)
@@ -13,152 +13,137 @@
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (0, 'Animals');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (0, '067.jpg', '067.jpg', 'Animals - 067.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '067.jpg', '067.jpg', 'Animals - 067.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 0);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (1, '10005.jpg', '10005.jpg', 'Animals - 10005.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (0, '1985-01-08', 'Amazing shot..',0, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (1, '10005.jpg', '10005.jpg', 'Animals - 10005.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (0, '1985-01-08', 'I Think this is Art!',1, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (1, '1985-01-08', 'nice shot =) ',1, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (2, '1985-01-08', 'nice shot =) ',1, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (2, '400004.jpg', '400004.jpg', 'Animals - 400004.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (1, '1985-01-08', 'Beautiful colours. Nice close up. ',1, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (2, '1985-01-08', 'I Think this is Art!',1, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (2, '400004.jpg', '400004.jpg', 'Animals - 400004.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (3, '400008.jpg', '400008.jpg', 'Animals - 400008.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (3, '400008.jpg', '400008.jpg', 'Animals - 400008.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (3, '1985-01-08', 'love every thing about this picture, really beautiful... :))',3, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (4, '1985-01-08', 'Amazing shot..',3, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (5, '1985-01-08', 'love every thing about this picture, really beautiful... :))',3, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (4, '400027.jpg', '400027.jpg', 'Animals - 400027.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (3, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',3, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (4, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',3, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (5, '1985-01-08', 'Gorgeous! Lovely color!',3, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (6, '1985-01-08', 'I Think this is Art!',3, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '400027.jpg', '400027.jpg', 'Animals - 400027.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 4);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (6, '1985-01-08', 'Such a lovely colour azaga!',4, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (7, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',4, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (8, '1985-01-08', 'Bellissima macro!',4, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (9, '1985-01-08', 'this is extremely Good:) Congratulations!',4, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (5, '400028.jpg', '400028.jpg', 'Animals - 400028.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (7, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',4, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (8, '1985-01-08', 'Wonderful.',4, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (9, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',4, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (5, '400028.jpg', '400028.jpg', 'Animals - 400028.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 5);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (10, '1985-01-08', 'Stunning capture! :-)',5, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (11, '1985-01-08', '++Beautiful',5, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (6, '400034.jpg', '400034.jpg', 'Animals - 400034.jpg image', '2009-12-18', 0, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (10, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',5, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (11, '1985-01-08', 'Wonderful.',5, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (12, '1985-01-08', 'Bellísima.!!! saludos.',5, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (6, '400034.jpg', '400034.jpg', 'Animals - 400034.jpg image', '2009-12-18', 0, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 6);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (12, '1985-01-08', 'Very *lovely*',6, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (7, '400035.jpg', '400035.jpg', 'Animals - 400035.jpg image', '2009-12-18', 0, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (13, '1985-01-08', 'fantastic shot !!!!!!',6, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (14, '1985-01-08', 'Perfecft!',6, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (15, '1985-01-08', 'Perfecft!',6, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (16, '1985-01-08', 'Gorgeous! Lovely color!',6, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (7, '400035.jpg', '400035.jpg', 'Animals - 400035.jpg image', '2009-12-18', 0, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 7);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (13, '1985-01-08', 'whoah ! wonderful',7, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (14, '1985-01-08', 'I Think this is Art!',7, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (15, '1985-01-08', 'I Think this is Art!',7, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (16, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',7, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (8, '400063.jpg', '400063.jpg', 'Animals - 400063.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (17, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',7, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '400063.jpg', '400063.jpg', 'Animals - 400063.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 8);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (17, '1985-01-08', 'whoah ! wonderful',8, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (18, '1985-01-08', 'love every thing about this picture, really beautiful... :))',8, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (9, '400095.jpg', '400095.jpg', 'Animals - 400095.jpg image', '2009-12-18', 0, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (18, '1985-01-08', 'Stunning capture! :-)',8, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (19, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',8, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (9, '400095.jpg', '400095.jpg', 'Animals - 400095.jpg image', '2009-12-18', 0, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 9);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (19, '1985-01-08', 'Gorgeous! Lovely color!',9, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (20, '1985-01-08', 'whoah ! wonderful',9, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (21, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',9, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (22, '1985-01-08', 'Stunning capture! :-)',9, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (10, 'deer.jpg', 'deer.jpg', 'Animals - deer.jpg image', '2009-12-18', 0, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (10, 'deer.jpg', 'deer.jpg', 'Animals - deer.jpg image', '2009-12-18', 0, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 10);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (23, '1985-01-08', 'Bellísima.!!! saludos.',10, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (24, '1985-01-08', '++Beautiful',10, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (11, 'dog2.jpg', 'dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (20, '1985-01-08', 'Bellissima macro!',10, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (11, 'dog2.jpg', 'dog2.jpg', 'Animals - dog2.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 11);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (25, '1985-01-08', '++Beautiful',11, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (26, '1985-01-08', 'love every thing about this picture, really beautiful... :))',11, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (12, 'pinn40.jpg', 'pinn40.jpg', 'Animals - pinn40.jpg image', '2009-12-18', 0, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (21, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',11, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (22, '1985-01-08', 'Beautiful colours. Nice close up. ',11, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (12, 'pinn40.jpg', 'pinn40.jpg', 'Animals - pinn40.jpg image', '2009-12-18', 0, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 12);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (13, 'pinn51.jpg', 'pinn51.jpg', 'Animals - pinn51.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (13, 'pinn51.jpg', 'pinn51.jpg', 'Animals - pinn51.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 13);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (27, '1985-01-08', 'nice shot =) ',13, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (28, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',13, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (29, '1985-01-08', 'whoah ! wonderful',13, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (30, '1985-01-08', 'fantastic shot !!!!!!',13, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (23, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',13, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (24, '1985-01-08', 'Wonderful.',13, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (25, '1985-01-08', 'Wonderful.',13, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (26, '1985-01-08', 'Very *lovely*',13, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (14, 'turtle.jpg', 'turtle.jpg', 'Animals - turtle.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 14);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (27, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',14, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (28, '1985-01-08', 'Very *lovely*',14, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (29, '1985-01-08', 'Wonderful.',14, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (30, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',14, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (15, 'turtle.jpg', 'turtle.jpg', 'Animals - turtle.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(0, 15);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (33, '1985-01-08', 'I Think this is Art!',15, 1);
-
---------------------------------------------------------------------
-- ALBUM - Building
---------------------------------------------------------------------
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (1, 'Building', 'Building pictures', 3, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (1, 'Building');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (16, '1.jpg', '1.jpg', 'Building - 1.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '1.jpg', '1.jpg', 'Building - 1.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 15);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (31, '1985-01-08', 'Beautiful colours. Nice close up. ',15, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (32, '1985-01-08', 'Very *lovely*',15, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (33, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',15, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '2.jpg', '2.jpg', 'Building - 2.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 16);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (34, '1985-01-08', 'whoah ! wonderful',16, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (35, '1985-01-08', 'Bellísima.!!! saludos.',16, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (36, '1985-01-08', 'Amazing shot..',16, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (37, '1985-01-08', 'Bellísima.!!! saludos.',16, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (17, '2.jpg', '2.jpg', 'Building - 2.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (34, '1985-01-08', 'that is a beautiful flower with great colours ',16, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (35, '1985-01-08', 'Gorgeous! Lovely color!',16, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (17, '3.jpg', '3.jpg', 'Building - 3.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 17);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (38, '1985-01-08', 'Bellísima.!!! saludos.',17, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (39, '1985-01-08', 'that is a beautiful flower with great colours ',17, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (40, '1985-01-08', 'Very *lovely*',17, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (41, '1985-01-08', 'Stunning capture! :-)',17, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (18, '3.jpg', '3.jpg', 'Building - 3.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (36, '1985-01-08', 'I Think this is Art!',17, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (37, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',17, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (38, '1985-01-08', 'whoah ! wonderful',17, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (18, '4.jpg', '4.jpg', 'Building - 4.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 18);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (42, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (43, '1985-01-08', 'whoah ! wonderful',18, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (19, '4.jpg', '4.jpg', 'Building - 4.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (39, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (40, '1985-01-08', 'Amazing shot..',18, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (41, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (42, '1985-01-08', 'this is extremely Good:) Congratulations!',18, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (19, '400018.jpg', '400018.jpg', 'Building - 400018.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 19);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (44, '1985-01-08', 'Amazing shot..',19, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (45, '1985-01-08', 'that is a beautiful flower with great colours ',19, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (20, '400018.jpg', '400018.jpg', 'Building - 400018.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (43, '1985-01-08', 'Gorgeous! Lovely color!',19, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (44, '1985-01-08', 'Bellísima.!!! saludos.',19, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (45, '1985-01-08', 'Beautiful colours. Nice close up. ',19, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (46, '1985-01-08', 'nice shot =) ',19, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (20, '400036.jpg', '400036.jpg', 'Building - 400036.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 20);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (46, '1985-01-08', 'Very *lovely*',20, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (47, '1985-01-08', 'Very *lovely*',20, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (48, '1985-01-08', 'nice shot =) ',20, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (49, '1985-01-08', 'Stunning capture! :-)',20, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (21, '400036.jpg', '400036.jpg', 'Building - 400036.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (47, '1985-01-08', 'Gorgeous! Lovely color!',20, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (48, '1985-01-08', 'Amazing shot..',20, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (49, '1985-01-08', 'Beautiful colours. Nice close up. ',20, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (50, '1985-01-08', 'this is extremely Good:) Congratulations!',20, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (21, '400069.jpg', '400069.jpg', 'Building - 400069.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 21);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (50, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',21, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (51, '1985-01-08', 'Stunning capture! :-)',21, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (22, '400069.jpg', '400069.jpg', 'Building - 400069.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (51, '1985-01-08', 'Gorgeous! Lovely color!',21, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (52, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',21, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (53, '1985-01-08', 'that is a beautiful flower with great colours ',21, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (22, '400076.jpg', '400076.jpg', 'Building - 400076.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 22);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (52, '1985-01-08', 'Bellissima macro!',22, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (53, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',22, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (54, '1985-01-08', 'this is extremely Good:) Congratulations!',22, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (55, '1985-01-08', 'I Think this is Art!',22, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (23, '400076.jpg', '400076.jpg', 'Building - 400076.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (54, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',22, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (55, '1985-01-08', 'Very *lovely*',22, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (56, '1985-01-08', '++Beautiful',22, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (57, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',22, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (23, '400083.jpg', '400083.jpg', 'Building - 400083.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 23);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (56, '1985-01-08', 'Stunning capture! :-)',23, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (57, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',23, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (58, '1985-01-08', 'this is extremely Good:) Congratulations!',23, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (59, '1985-01-08', 'Wonderful.',23, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (24, '400083.jpg', '400083.jpg', 'Building - 400083.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '5.jpg', '5.jpg', 'Building - 5.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 24);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (60, '1985-01-08', 'fantastic shot !!!!!!',24, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (61, '1985-01-08', 'Wonderful.',24, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (25, '5.jpg', '5.jpg', 'Building - 5.jpg image', '2009-12-18', 1, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (58, '1985-01-08', 'Bellísima.!!! saludos.',24, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (25, '6.jpg', '6.jpg', 'Building - 6.jpg image', '2009-12-18', 1, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 25);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (62, '1985-01-08', 'Amazing shot..',25, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (63, '1985-01-08', '++Beautiful',25, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (64, '1985-01-08', 'fantastic shot !!!!!!',25, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (26, '6.jpg', '6.jpg', 'Building - 6.jpg image', '2009-12-18', 1, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (59, '1985-01-08', 'Perfecft!',25, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (60, '1985-01-08', 'Wonderful.',25, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (61, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',25, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (26, '7.jpg', '7.jpg', 'Building - 7.jpg image', '2009-12-18', 1, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 26);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (65, '1985-01-08', 'this is extremely Good:) Congratulations!',26, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (27, '7.jpg', '7.jpg', 'Building - 7.jpg image', '2009-12-18', 1, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, 'church.jpg', 'church.jpg', 'Building - church.jpg image', '2009-12-18', 1, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 27);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (66, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',27, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (67, '1985-01-08', 'Bellísima.!!! saludos.',27, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (68, '1985-01-08', 'love every thing about this picture, really beautiful... :))',27, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (69, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',27, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (28, 'church.jpg', 'church.jpg', 'Building - church.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (28, 'pinn71.jpg', 'pinn71.jpg', 'Building - pinn71.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 28);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (70, '1985-01-08', 'Beautiful colours. Nice close up. ',28, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (71, '1985-01-08', 'Bellissima macro!',28, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (72, '1985-01-08', 'Bellísima.!!! saludos.',28, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (29, 'pinn71.jpg', 'pinn71.jpg', 'Building - pinn71.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (29, 'pinn82.jpg', 'pinn82.jpg', 'Building - pinn82.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 29);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (30, 'pinn82.jpg', 'pinn82.jpg', 'Building - pinn82.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 30);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (73, '1985-01-08', '++Beautiful',30, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (74, '1985-01-08', 'Bellissima macro!',30, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (31, 'thumbs.db', 'thumbs.db', 'Building - thumbs.db image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(1, 31);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (75, '1985-01-08', 'Stunning capture! :-)',31, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (76, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',31, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (77, '1985-01-08', 'I Think this is Art!',31, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (62, '1985-01-08', 'whoah ! wonderful',29, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (63, '1985-01-08', 'Wonderful.',29, 2);
---------------------------------------------------------------------
-- ALBUM - Coasts
@@ -166,68 +151,65 @@
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (2, 'Coasts', 'Coasts pictures', 4, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (2, 'Coasts');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (32, '203015.jpg', '203015.jpg', 'Coasts - 203015.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (30, '203015.jpg', '203015.jpg', 'Coasts - 203015.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 30);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (64, '1985-01-08', 'Such a lovely colour azaga!',30, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (65, '1985-01-08', 'Bellissima macro!',30, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (66, '1985-01-08', 'love every thing about this picture, really beautiful... :))',30, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (67, '1985-01-08', 'love every thing about this picture, really beautiful... :))',30, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (31, '203034.jpg', '203034.jpg', 'Coasts - 203034.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 31);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (68, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',31, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (32, '203036.jpg', '203036.jpg', 'Coasts - 203036.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 32);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (78, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',32, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (79, '1985-01-08', 'Bellísima.!!! saludos.',32, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (80, '1985-01-08', 'nice shot =) ',32, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (33, '203034.jpg', '203034.jpg', 'Coasts - 203034.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (33, '203043.jpg', '203043.jpg', 'Coasts - 203043.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 33);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (81, '1985-01-08', 'nice shot =) ',33, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (82, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',33, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (34, '203036.jpg', '203036.jpg', 'Coasts - 203036.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (69, '1985-01-08', 'fantastic shot !!!!!!',33, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (70, '1985-01-08', 'I Think this is Art!',33, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (34, '203049.jpg', '203049.jpg', 'Coasts - 203049.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 34);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (83, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',34, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (84, '1985-01-08', 'nice shot =) ',34, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (85, '1985-01-08', 'Perfecft!',34, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (35, '203043.jpg', '203043.jpg', 'Coasts - 203043.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (71, '1985-01-08', 'Stunning capture! :-)',34, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (35, '203052.jpg', '203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 35);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (86, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',35, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (87, '1985-01-08', 'Stunning capture! :-)',35, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (88, '1985-01-08', 'Bellissima macro!',35, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (89, '1985-01-08', 'I Think this is Art!',35, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (36, '203049.jpg', '203049.jpg', 'Coasts - 203049.jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (72, '1985-01-08', 'Wonderful.',35, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (73, '1985-01-08', 'Stunning capture! :-)',35, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (36, '203053.jpg', '203053.jpg', 'Coasts - 203053.jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 36);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (90, '1985-01-08', 'Bellissima macro!',36, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (91, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',36, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (92, '1985-01-08', 'Beautiful colours. Nice close up. ',36, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (93, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',36, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (37, '203052.jpg', '203052.jpg', 'Coasts - 203052.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (74, '1985-01-08', 'Such a lovely colour azaga!',36, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (75, '1985-01-08', 'that is a beautiful flower with great colours ',36, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (76, '1985-01-08', 'Stunning capture! :-)',36, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (77, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',36, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (37, '203054.jpg', '203054.jpg', 'Coasts - 203054.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 37);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (94, '1985-01-08', 'Gorgeous! Lovely color!',37, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (38, '203053.jpg', '203053.jpg', 'Coasts - 203053.jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (78, '1985-01-08', 'Bellísima.!!! saludos.',37, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (79, '1985-01-08', 'Bellísima.!!! saludos.',37, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (80, '1985-01-08', 'Bellissima macro!',37, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (81, '1985-01-08', 'Gorgeous! Lovely color!',37, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (38, '203058.jpg', '203058.jpg', 'Coasts - 203058.jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 38);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (95, '1985-01-08', 'Bellissima macro!',38, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (96, '1985-01-08', 'whoah ! wonderful',38, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (97, '1985-01-08', 'this is extremely Good:) Congratulations!',38, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (39, '203054.jpg', '203054.jpg', 'Coasts - 203054.jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (82, '1985-01-08', 'that is a beautiful flower with great colours ',38, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (83, '1985-01-08', 'Amazing shot..',38, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (84, '1985-01-08', 'Wonderful.',38, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (39, '203066.jpg', '203066.jpg', 'Coasts - 203066.jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 39);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (98, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',39, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (99, '1985-01-08', 'fantastic shot !!!!!!',39, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (40, '203058.jpg', '203058.jpg', 'Coasts - 203058.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (85, '1985-01-08', 'nice shot =) ',39, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (86, '1985-01-08', 'this is extremely Good:) Congratulations!',39, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (40, '203067.jpg', '203067.jpg', 'Coasts - 203067.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 40);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (100, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',40, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (41, '203066.jpg', '203066.jpg', 'Coasts - 203066.jpg image', '2009-12-18', 2, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (87, '1985-01-08', 'Wonderful.',40, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (88, '1985-01-08', 'Very *lovely*',40, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (89, '1985-01-08', 'Bellissima macro!',40, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (90, '1985-01-08', 'Gorgeous! Lovely color!',40, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (41, '203071.jpg', '203071.jpg', 'Coasts - 203071.jpg image', '2009-12-18', 2, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 41);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (42, '203067.jpg', '203067.jpg', 'Coasts - 203067.jpg image', '2009-12-18', 2, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (91, '1985-01-08', 'Amazing shot..',41, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (92, '1985-01-08', 'Bellísima.!!! saludos.',41, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (42, '203072.jpg', '203072.jpg', 'Coasts - 203072.jpg image', '2009-12-18', 2, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 42);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (101, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',42, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (43, '203071.jpg', '203071.jpg', 'Coasts - 203071.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (43, '203073.jpg', '203073.jpg', 'Coasts - 203073.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 43);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (102, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',43, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (44, '203072.jpg', '203072.jpg', 'Coasts - 203072.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (44, '203076.jpg', '203076.jpg', 'Coasts - 203076.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 44);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (103, '1985-01-08', 'Bellissima macro!',44, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (104, '1985-01-08', 'I Think this is Art!',44, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (105, '1985-01-08', 'Such a lovely colour azaga!',44, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (45, '203073.jpg', '203073.jpg', 'Coasts - 203073.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 45);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (106, '1985-01-08', 'this is extremely Good:) Congratulations!',45, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (107, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',45, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (108, '1985-01-08', 'Bellísima.!!! saludos.',45, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (46, '203076.jpg', '203076.jpg', 'Coasts - 203076.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(2, 46);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (109, '1985-01-08', 'that is a beautiful flower with great colours ',46, 3);
---------------------------------------------------------------------
-- ALBUM - Flora
@@ -235,61 +217,62 @@
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (3, 'Flora', 'Flora pictures', 2, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (3, 'Flora');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (48, '132000.jpg', '132000.jpg', 'Flora - 132000.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (45, '132000.jpg', '132000.jpg', 'Flora - 132000.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 45);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (93, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',45, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (94, '1985-01-08', 'love every thing about this picture, really beautiful... :))',45, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (46, '132022.jpg', '132022.jpg', 'Flora - 132022.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 46);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (95, '1985-01-08', 'Bellísima.!!! saludos.',46, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (96, '1985-01-08', 'fantastic shot !!!!!!',46, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (97, '1985-01-08', 'Wonderful.',46, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (47, '132051.jpg', '132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 47);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (98, '1985-01-08', 'whoah ! wonderful',47, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (48, '132059.jpg', '132059.jpg', 'Flora - 132059.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 48);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (112, '1985-01-08', 'this is extremely Good:) Congratulations!',48, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (49, '132022.jpg', '132022.jpg', 'Flora - 132022.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (49, '132060.jpg', '132060.jpg', 'Flora - 132060.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 49);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (113, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',49, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (114, '1985-01-08', 'Wonderful.',49, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (115, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',49, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (50, '132051.jpg', '132051.jpg', 'Flora - 132051.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (99, '1985-01-08', 'Amazing shot..',49, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (100, '1985-01-08', 'love every thing about this picture, really beautiful... :))',49, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (101, '1985-01-08', '++Beautiful',49, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (50, '132071.jpg', '132071.jpg', 'Flora - 132071.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 50);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (116, '1985-01-08', 'Wonderful.',50, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (117, '1985-01-08', 'Very *lovely*',50, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (118, '1985-01-08', 'fantastic shot !!!!!!',50, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (119, '1985-01-08', 'Such a lovely colour azaga!',50, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (51, '132059.jpg', '132059.jpg', 'Flora - 132059.jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (102, '1985-01-08', 'Stunning capture! :-)',50, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (103, '1985-01-08', '++Beautiful',50, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (104, '1985-01-08', 'Wonderful.',50, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (105, '1985-01-08', 'I Think this is Art!',50, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (51, '132074.jpg', '132074.jpg', 'Flora - 132074.jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 51);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (120, '1985-01-08', 'Amazing shot..',51, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (121, '1985-01-08', 'Beautiful colours. Nice close up. ',51, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (52, '132060.jpg', '132060.jpg', 'Flora - 132060.jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (106, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',51, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (52, '132078.jpg', '132078.jpg', 'Flora - 132078.jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 52);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (122, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',52, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (53, '132071.jpg', '132071.jpg', 'Flora - 132071.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (107, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',52, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (108, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',52, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (109, '1985-01-08', 'this is extremely Good:) Congratulations!',52, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (53, '142011.jpg', '142011.jpg', 'Flora - 142011.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 53);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (123, '1985-01-08', 'love every thing about this picture, really beautiful... :))',53, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (124, '1985-01-08', 'that is a beautiful flower with great colours ',53, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (125, '1985-01-08', 'that is a beautiful flower with great colours ',53, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (54, '132074.jpg', '132074.jpg', 'Flora - 132074.jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (110, '1985-01-08', 'Bellísima.!!! saludos.',53, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (54, '142039.jpg', '142039.jpg', 'Flora - 142039.jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 54);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (126, '1985-01-08', 'that is a beautiful flower with great colours ',54, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (55, '132078.jpg', '132078.jpg', 'Flora - 132078.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (55, '167049.jpg', '167049.jpg', 'Flora - 167049.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 55);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (56, '142011.jpg', '142011.jpg', 'Flora - 142011.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (111, '1985-01-08', 'Beautiful colours. Nice close up. ',55, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (112, '1985-01-08', 'I Think this is Art!',55, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (56, '167055.jpg', '167055.jpg', 'Flora - 167055.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 56);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (57, '142039.jpg', '142039.jpg', 'Flora - 142039.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (113, '1985-01-08', 'Bellissima macro!',56, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (114, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',56, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (115, '1985-01-08', 'Bellísima.!!! saludos.',56, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (57, '400010.jpg', '400010.jpg', 'Flora - 400010.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 57);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (127, '1985-01-08', 'Stunning capture! :-)',57, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (128, '1985-01-08', 'this is extremely Good:) Congratulations!',57, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (129, '1985-01-08', 'Very *lovely*',57, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (130, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',57, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (58, '167049.jpg', '167049.jpg', 'Flora - 167049.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (116, '1985-01-08', 'Very *lovely*',57, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (58, '400073.jpg', '400073.jpg', 'Flora - 400073.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 58);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (59, '167055.jpg', '167055.jpg', 'Flora - 167055.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (117, '1985-01-08', 'whoah ! wonderful',58, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (59, '403011.jpg', '403011.jpg', 'Flora - 403011.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 59);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (131, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',59, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (60, '400010.jpg', '400010.jpg', 'Flora - 400010.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 60);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (132, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',60, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (133, '1985-01-08', 'Perfecft!',60, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (61, '400073.jpg', '400073.jpg', 'Flora - 400073.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 61);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (134, '1985-01-08', 'Amazing shot..',61, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (135, '1985-01-08', 'Gorgeous! Lovely color!',61, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (136, '1985-01-08', '++Beautiful',61, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (62, '403011.jpg', '403011.jpg', 'Flora - 403011.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(3, 62);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (118, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',59, 3);
---------------------------------------------------------------------
-- ALBUM - Ices
@@ -297,166 +280,148 @@
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (4, 'Ices', 'Ices pictures', 3, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (4, 'Ices');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (64, '184023.jpg', '184023.jpg', 'Ices - 184023.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (60, '184023.jpg', '184023.jpg', 'Ices - 184023.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 60);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (119, '1985-01-08', 'Amazing shot..',60, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (120, '1985-01-08', 'nice shot =) ',60, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (121, '1985-01-08', 'Beautiful colours. Nice close up. ',60, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (122, '1985-01-08', 'that is a beautiful flower with great colours ',60, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (61, '184030.jpg', '184030.jpg', 'Ices - 184030.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 61);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (123, '1985-01-08', 'whoah ! wonderful',61, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (124, '1985-01-08', 'nice shot =) ',61, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (125, '1985-01-08', 'Perfecft!',61, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (126, '1985-01-08', 'I Think this is Art!',61, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (62, '184031.jpg', '184031.jpg', 'Ices - 184031.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 62);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (127, '1985-01-08', 'Stunning capture! :-)',62, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (128, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',62, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (129, '1985-01-08', 'Bellissima macro!',62, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (63, '184033.jpg', '184033.jpg', 'Ices - 184033.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 63);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (130, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',63, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (131, '1985-01-08', 'Such a lovely colour azaga!',63, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (64, '184034.jpg', '184034.jpg', 'Ices - 184034.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 64);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (140, '1985-01-08', 'fantastic shot !!!!!!',64, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (141, '1985-01-08', 'Stunning capture! :-)',64, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (65, '184030.jpg', '184030.jpg', 'Ices - 184030.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (65, '184035.jpg', '184035.jpg', 'Ices - 184035.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 65);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (142, '1985-01-08', 'I Think this is Art!',65, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (143, '1985-01-08', 'whoah ! wonderful',65, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (144, '1985-01-08', 'nice shot =) ',65, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (66, '184031.jpg', '184031.jpg', 'Ices - 184031.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (66, '184038.jpg', '184038.jpg', 'Ices - 184038.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 66);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (145, '1985-01-08', 'nice shot =) ',66, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (146, '1985-01-08', 'Gorgeous! Lovely color!',66, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (147, '1985-01-08', 'I Think this is Art!',66, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (67, '184033.jpg', '184033.jpg', 'Ices - 184033.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (132, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',66, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (67, '184040.jpg', '184040.jpg', 'Ices - 184040.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 67);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (148, '1985-01-08', 'Very *lovely*',67, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (149, '1985-01-08', 'Bellísima.!!! saludos.',67, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (150, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',67, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (151, '1985-01-08', 'nice shot =) ',67, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (68, '184034.jpg', '184034.jpg', 'Ices - 184034.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (133, '1985-01-08', 'Such a lovely colour azaga!',67, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (134, '1985-01-08', 'fantastic shot !!!!!!',67, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (135, '1985-01-08', 'I Think this is Art!',67, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (136, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',67, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (68, '184044.jpg', '184044.jpg', 'Ices - 184044.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 68);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (69, '184035.jpg', '184035.jpg', 'Ices - 184035.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (137, '1985-01-08', 'Bellísima.!!! saludos.',68, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (138, '1985-01-08', 'Bellísima.!!! saludos.',68, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (69, '184046.jpg', '184046.jpg', 'Ices - 184046.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 69);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (152, '1985-01-08', 'that is a beautiful flower with great colours ',69, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (153, '1985-01-08', 'Perfecft!',69, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (154, '1985-01-08', 'Bellissima macro!',69, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (155, '1985-01-08', 'Amazing shot..',69, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (70, '184038.jpg', '184038.jpg', 'Ices - 184038.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (139, '1985-01-08', 'Very *lovely*',69, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (140, '1985-01-08', 'whoah ! wonderful',69, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (141, '1985-01-08', 'this is extremely Good:) Congratulations!',69, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (70, '184047.jpg', '184047.jpg', 'Ices - 184047.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 70);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (156, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',70, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (157, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',70, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (158, '1985-01-08', 'Gorgeous! Lovely color!',70, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (159, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',70, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (71, '184040.jpg', '184040.jpg', 'Ices - 184040.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (71, '184053.jpg', '184053.jpg', 'Ices - 184053.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 71);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (160, '1985-01-08', 'Wonderful.',71, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (161, '1985-01-08', 'Very *lovely*',71, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (162, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',71, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (72, '184044.jpg', '184044.jpg', 'Ices - 184044.jpg image', '2009-12-18', 4, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (72, '184057.jpg', '184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 72);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (73, '184046.jpg', '184046.jpg', 'Ices - 184046.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (142, '1985-01-08', '++Beautiful',72, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (143, '1985-01-08', 'Wonderful.',72, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (73, '184063.jpg', '184063.jpg', 'Ices - 184063.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 73);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (163, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',73, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (164, '1985-01-08', 'Perfecft!',73, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (74, '184047.jpg', '184047.jpg', 'Ices - 184047.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (144, '1985-01-08', 'Such a lovely colour azaga!',73, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (145, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',73, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (146, '1985-01-08', 'Beautiful colours. Nice close up. ',73, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (74, '184069.jpg', '184069.jpg', 'Ices - 184069.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 74);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (165, '1985-01-08', 'Very *lovely*',74, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (75, '184053.jpg', '184053.jpg', 'Ices - 184053.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (147, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',74, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (148, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',74, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (149, '1985-01-08', 'I Think this is Art!',74, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (75, '184072.jpg', '184072.jpg', 'Ices - 184072.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 75);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (166, '1985-01-08', 'Perfecft!',75, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (167, '1985-01-08', 'love every thing about this picture, really beautiful... :))',75, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (168, '1985-01-08', '++Beautiful',75, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (169, '1985-01-08', 'fantastic shot !!!!!!',75, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (76, '184057.jpg', '184057.jpg', 'Ices - 184057.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (150, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',75, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (151, '1985-01-08', 'Wonderful.',75, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (76, '184077.jpg', '184077.jpg', 'Ices - 184077.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 76);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (170, '1985-01-08', 'this is extremely Good:) Congratulations!',76, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (77, '184063.jpg', '184063.jpg', 'Ices - 184063.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (77, '184078.jpg', '184078.jpg', 'Ices - 184078.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 77);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (171, '1985-01-08', 'nice shot =) ',77, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (172, '1985-01-08', 'Stunning capture! :-)',77, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (173, '1985-01-08', 'whoah ! wonderful',77, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (78, '184069.jpg', '184069.jpg', 'Ices - 184069.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (152, '1985-01-08', 'nice shot =) ',77, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (153, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',77, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (154, '1985-01-08', 'love every thing about this picture, really beautiful... :))',77, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (155, '1985-01-08', '++Beautiful',77, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (78, '184079.jpg', '184079.jpg', 'Ices - 184079.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 78);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (174, '1985-01-08', 'Such a lovely colour azaga!',78, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (175, '1985-01-08', 'love every thing about this picture, really beautiful... :))',78, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (176, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',78, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (79, '184072.jpg', '184072.jpg', 'Ices - 184072.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (156, '1985-01-08', 'Gorgeous! Lovely color!',78, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (157, '1985-01-08', 'Bellísima.!!! saludos.',78, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (158, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',78, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (159, '1985-01-08', 'I Think this is Art!',78, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (79, '400000.jpg', '400000.jpg', 'Ices - 400000.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 79);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (177, '1985-01-08', 'Beautiful colours. Nice close up. ',79, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (178, '1985-01-08', 'love every thing about this picture, really beautiful... :))',79, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (179, '1985-01-08', '++Beautiful',79, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (180, '1985-01-08', 'Bellísima.!!! saludos.',79, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (80, '184077.jpg', '184077.jpg', 'Ices - 184077.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 80);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (181, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',80, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (182, '1985-01-08', 'Stunning capture! :-)',80, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (81, '184078.jpg', '184078.jpg', 'Ices - 184078.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 81);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (183, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',81, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (184, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',81, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (82, '184079.jpg', '184079.jpg', 'Ices - 184079.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 82);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (185, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',82, 2);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (186, '1985-01-08', 'Gorgeous! Lovely color!',82, 2);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (83, '400000.jpg', '400000.jpg', 'Ices - 400000.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(4, 83);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (187, '1985-01-08', 'nice shot =) ',83, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (160, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',79, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (161, '1985-01-08', '++Beautiful',79, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (162, '1985-01-08', 'Bellísima.!!! saludos.',79, 1);
-
---------------------------------------------------------------------
-- ALBUM - Sport
---------------------------------------------------------------------
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (5, 'Sport');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (85, '23048.jpg', '23048.jpg', 'Sport - 23048.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (80, '23048.jpg', '23048.jpg', 'Sport - 23048.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 80);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (163, '1985-01-08', 'love every thing about this picture, really beautiful... :))',80, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (164, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',80, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (165, '1985-01-08', 'Perfecft!',80, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (81, '400003.jpg', '400003.jpg', 'Sport - 400003.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 81);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (166, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',81, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (167, '1985-01-08', 'whoah ! wonderful',81, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (82, '400033.jpg', '400033.jpg', 'Sport - 400033.jpg image', '2009-12-18', 5, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 82);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (168, '1985-01-08', 'Perfecft!',82, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (83, '400048.jpg', '400048.jpg', 'Sport - 400048.jpg image', '2009-12-18', 5, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 83);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (84, '400081.jpg', '400081.jpg', 'Sport - 400081.jpg image', '2009-12-18', 5, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 84);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (85, '479031.jpg', '479031.jpg', 'Sport - 479031.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 85);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (191, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',85, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (86, '400003.jpg', '400003.jpg', 'Sport - 400003.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (169, '1985-01-08', 'Bellísima.!!! saludos.',85, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (170, '1985-01-08', 'Such a lovely colour azaga!',85, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (171, '1985-01-08', 'that is a beautiful flower with great colours ',85, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (86, 'balloon.jpg', 'balloon.jpg', 'Sport - balloon.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 86);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (192, '1985-01-08', 'Amazing shot..',86, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (87, '400033.jpg', '400033.jpg', 'Sport - 400033.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (172, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',86, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (87, 'hghjump.jpg', 'hghjump.jpg', 'Sport - hghjump.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 87);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (88, '400048.jpg', '400048.jpg', 'Sport - 400048.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (173, '1985-01-08', 'love every thing about this picture, really beautiful... :))',87, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (88, 'pinn01.jpg', 'pinn01.jpg', 'Sport - pinn01.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 88);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (193, '1985-01-08', 'Wonderful.',88, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (89, '400081.jpg', '400081.jpg', 'Sport - 400081.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (89, 'pinn04.jpg', 'pinn04.jpg', 'Sport - pinn04.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 89);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (194, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',89, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (195, '1985-01-08', 'Beautiful colours. Nice close up. ',89, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (196, '1985-01-08', 'this is extremely Good:) Congratulations!',89, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (197, '1985-01-08', 'Amazing shot..',89, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (90, '479031.jpg', '479031.jpg', 'Sport - 479031.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (174, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',89, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (175, '1985-01-08', 'Beautiful colours. Nice close up. ',89, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (176, '1985-01-08', 'nice shot =) ',89, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (90, 'pinn29.jpg', 'pinn29.jpg', 'Sport - pinn29.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 90);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (198, '1985-01-08', 'Stunning capture! :-)',90, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (199, '1985-01-08', 'nice shot =) ',90, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (200, '1985-01-08', 'nice shot =) ',90, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (91, 'balloon.jpg', 'balloon.jpg', 'Sport - balloon.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (91, 'pinn39.jpg', 'pinn39.jpg', 'Sport - pinn39.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 91);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (201, '1985-01-08', 'this is extremely Good:) Congratulations!',91, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (202, '1985-01-08', 'that is a beautiful flower with great colours ',91, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (203, '1985-01-08', 'Wonderful.',91, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (204, '1985-01-08', 'nice shot =) ',91, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (92, 'hghjump.jpg', 'hghjump.jpg', 'Sport - hghjump.jpg image', '2009-12-18', 5, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (177, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',91, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (178, '1985-01-08', 'this is extremely Good:) Congratulations!',91, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (179, '1985-01-08', 'Bellísima.!!! saludos.',91, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (180, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',91, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (92, 'pinn64.jpg', 'pinn64.jpg', 'Sport - pinn64.jpg image', '2009-12-18', 5, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 92);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (205, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',92, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (206, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',92, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (207, '1985-01-08', 'I Think this is Art!',92, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (93, 'pinn01.jpg', 'pinn01.jpg', 'Sport - pinn01.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (181, '1985-01-08', 'Beautiful colours. Nice close up. ',92, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (93, 'sa28.jpg', 'sa28.jpg', 'Sport - sa28.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 93);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (208, '1985-01-08', 'Bellissima macro!',93, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (94, 'pinn04.jpg', 'pinn04.jpg', 'Sport - pinn04.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (182, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',93, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (183, '1985-01-08', 'Very *lovely*',93, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (94, 'swimmer.jpg', 'swimmer.jpg', 'Sport - swimmer.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 94);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (209, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',94, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (210, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',94, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (211, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',94, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (95, 'pinn29.jpg', 'pinn29.jpg', 'Sport - pinn29.jpg image', '2009-12-18', 5, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 95);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (212, '1985-01-08', 'Beautiful colours. Nice close up. ',95, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (213, '1985-01-08', 'this is extremely Good:) Congratulations!',95, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (214, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',95, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (96, 'pinn39.jpg', 'pinn39.jpg', 'Sport - pinn39.jpg image', '2009-12-18', 5, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 96);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (215, '1985-01-08', 'love every thing about this picture, really beautiful... :))',96, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (216, '1985-01-08', 'love every thing about this picture, really beautiful... :))',96, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (217, '1985-01-08', 'Wonderful.',96, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (97, 'pinn64.jpg', 'pinn64.jpg', 'Sport - pinn64.jpg image', '2009-12-18', 5, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 97);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (218, '1985-01-08', 'love every thing about this picture, really beautiful... :))',97, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (219, '1985-01-08', 'Bellísima.!!! saludos.',97, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (220, '1985-01-08', 'fantastic shot !!!!!!',97, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (98, 'sa28.jpg', 'sa28.jpg', 'Sport - sa28.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 98);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (221, '1985-01-08', 'that is a beautiful flower with great colours ',98, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (222, '1985-01-08', 'fantastic shot !!!!!!',98, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (223, '1985-01-08', 'Stunning capture! :-)',98, 3);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (224, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',98, 3);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (99, 'swimmer.jpg', 'swimmer.jpg', 'Sport - swimmer.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(5, 99);
---------------------------------------------------------------------
-- ALBUM - Underwater
@@ -464,91 +429,86 @@
INSERT INTO albums(album_id, name, description, shelf_id, created) VALUES (6, 'Underwater', 'Underwater pictures', 1, '2009-12-18');
INSERT INTO metatags(metatag_id, tag) VALUES (6, 'Underwater');
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (101, '45000.jpg', '45000.jpg', 'Underwater - 45000.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (95, '45000.jpg', '45000.jpg', 'Underwater - 45000.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 95);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (184, '1985-01-08', 'Gorgeous! Lovely color!',95, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (185, '1985-01-08', 'Perfecft!',95, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (96, '45001.jpg', '45001.jpg', 'Underwater - 45001.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 96);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (186, '1985-01-08', 'Such a lovely colour azaga!',96, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (187, '1985-01-08', 'that is a beautiful flower with great colours ',96, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (97, '45002.jpg', '45002.jpg', 'Underwater - 45002.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 97);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (188, '1985-01-08', 'Such a lovely colour azaga!',97, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (98, '45003.jpg', '45003.jpg', 'Underwater - 45003.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 98);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (189, '1985-01-08', 'that is a beautiful flower with great colours ',98, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (190, '1985-01-08', 'Amazing shot..',98, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (99, '45004.jpg', '45004.jpg', 'Underwater - 45004.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 99);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (191, '1985-01-08', 'Bellissima macro!',99, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (100, '45005.jpg', '45005.jpg', 'Underwater - 45005.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 100);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (101, '45006.jpg', '45006.jpg', 'Underwater - 45006.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 101);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (225, '1985-01-08', 'nice shot =) ',101, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (226, '1985-01-08', 'Beautiful colours. Nice close up. ',101, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (102, '45001.jpg', '45001.jpg', 'Underwater - 45001.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (102, '45009.jpg', '45009.jpg', 'Underwater - 45009.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 102);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (227, '1985-01-08', 'this is extremely Good:) Congratulations!',102, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (228, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',102, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (229, '1985-01-08', 'nice shot =) ',102, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (103, '45002.jpg', '45002.jpg', 'Underwater - 45002.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (192, '1985-01-08', 'Gorgeous! Lovely color!',102, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (193, '1985-01-08', 'this is extremely Good:) Congratulations!',102, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (194, '1985-01-08', 'Amazing shot..',102, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (103, '45010.jpg', '45010.jpg', 'Underwater - 45010.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 103);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (104, '45003.jpg', '45003.jpg', 'Underwater - 45003.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (195, '1985-01-08', '++Beautiful',103, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (104, '45012.jpg', '45012.jpg', 'Underwater - 45012.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 104);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (230, '1985-01-08', 'Very *lovely*',104, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (231, '1985-01-08', 'Stunning capture! :-)',104, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (232, '1985-01-08', '++Beautiful',104, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (233, '1985-01-08', 'Such a lovely colour azaga!',104, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (105, '45004.jpg', '45004.jpg', 'Underwater - 45004.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (196, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',104, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (197, '1985-01-08', 'I Think this is Art!',104, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (198, '1985-01-08', 'Bellissima macro!',104, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (199, '1985-01-08', 'that is a beautiful flower with great colours ',104, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (105, '45013.jpg', '45013.jpg', 'Underwater - 45013.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 105);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (106, '45005.jpg', '45005.jpg', 'Underwater - 45005.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (106, '45014.jpg', '45014.jpg', 'Underwater - 45014.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 106);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (234, '1985-01-08', 'Such a lovely colour azaga!',106, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (235, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',106, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (236, '1985-01-08', 'Wonderful.',106, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (107, '45006.jpg', '45006.jpg', 'Underwater - 45006.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (200, '1985-01-08', 'that is a beautiful flower with great colours ',106, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (107, '45016.jpg', '45016.jpg', 'Underwater - 45016.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 107);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (237, '1985-01-08', 'Wonderful.',107, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (238, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',107, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (239, '1985-01-08', 'fantastic shot !!!!!!',107, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (108, '45009.jpg', '45009.jpg', 'Underwater - 45009.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (201, '1985-01-08', '++Beautiful',107, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (202, '1985-01-08', 'Bellísima.!!! saludos.',107, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (108, '45017.jpg', '45017.jpg', 'Underwater - 45017.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 108);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (240, '1985-01-08', 'nice shot =) ',108, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (241, '1985-01-08', 'love every thing about this picture, really beautiful... :))',108, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (109, '45010.jpg', '45010.jpg', 'Underwater - 45010.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (203, '1985-01-08', 'Such a lovely colour azaga!',108, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (204, '1985-01-08', 'I Think this is Art!',108, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (205, '1985-01-08', 'nice shot =) ',108, 1);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (109, '45018.jpg', '45018.jpg', 'Underwater - 45018.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 109);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (242, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',109, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (243, '1985-01-08', 'love every thing about this picture, really beautiful... :))',109, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (244, '1985-01-08', 'nice shot =) ',109, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (245, '1985-01-08', 'Beautiful colours. Nice close up. ',109, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (110, '45012.jpg', '45012.jpg', 'Underwater - 45012.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (206, '1985-01-08', 'Stunning capture! :-)',109, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (110, '45019.jpg', '45019.jpg', 'Underwater - 45019.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 110);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (111, '45013.jpg', '45013.jpg', 'Underwater - 45013.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (111, '45020.jpg', '45020.jpg', 'Underwater - 45020.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 111);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (112, '45014.jpg', '45014.jpg', 'Underwater - 45014.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (207, '1985-01-08', 'fantastic shot !!!!!!',111, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (208, '1985-01-08', '++Beautiful',111, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (209, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',111, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (112, '45021.jpg', '45021.jpg', 'Underwater - 45021.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 112);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (113, '45016.jpg', '45016.jpg', 'Underwater - 45016.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (210, '1985-01-08', 'Very *lovely*',112, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (211, '1985-01-08', 'this is extremely Good:) Congratulations!',112, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (212, '1985-01-08', 'Such a lovely colour azaga!',112, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (213, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',112, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (113, '45022.jpg', '45022.jpg', 'Underwater - 45022.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 113);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (246, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',113, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (114, '45017.jpg', '45017.jpg', 'Underwater - 45017.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (214, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',113, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (215, '1985-01-08', 'whoah ! wonderful',113, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (216, '1985-01-08', 'this is extremely Good:) Congratulations!',113, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (217, '1985-01-08', 'Amazing shot..',113, 2);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (114, '45023.jpg', '45023.jpg', 'Underwater - 45023.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 114);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (115, '45018.jpg', '45018.jpg', 'Underwater - 45018.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (218, '1985-01-08', 'that is a beautiful flower with great colours ',114, 3);
+INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (115, '45024.jpg', '45024.jpg', 'Underwater - 45024.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 115);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (247, '1985-01-08', 'fantastic shot !!!!!!',115, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (248, '1985-01-08', 'Such a lovely colour azaga!',115, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (249, '1985-01-08', '++Beautiful',115, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (250, '1985-01-08', 'Stunning capture! :-)',115, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (116, '45019.jpg', '45019.jpg', 'Underwater - 45019.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 116);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (251, '1985-01-08', 'Perfecft!',116, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (252, '1985-01-08', 'Stunning capture! :-)',116, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (117, '45020.jpg', '45020.jpg', 'Underwater - 45020.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 117);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (253, '1985-01-08', 'fantastic shot !!!!!!',117, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (254, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',117, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (255, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',117, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (118, '45021.jpg', '45021.jpg', 'Underwater - 45021.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 118);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (256, '1985-01-08', 'Gorgeous! Lovely color!',118, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (257, '1985-01-08', 'Amazing shot..',118, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (119, '45022.jpg', '45022.jpg', 'Underwater - 45022.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 119);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (258, '1985-01-08', 'Bellísima.!!! saludos.',119, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (259, '1985-01-08', 'Wonderful.',119, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (260, '1985-01-08', '++Beautiful',119, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (261, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',119, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (120, '45023.jpg', '45023.jpg', 'Underwater - 45023.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 120);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (262, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',120, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (263, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',120, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (264, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',120, 1);
-INSERT INTO images(image_id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments) VALUES (121, '45024.jpg', '45024.jpg', 'Underwater - 45024.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true);
-INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) VALUES(6, 121);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (265, '1985-01-08', 'that is a beautiful flower with great colours ',121, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (266, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',121, 1);
-INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (267, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',121, 1);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (219, '1985-01-08', '++Beautiful',115, 3);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (220, '1985-01-08', 'Gorgeous! Lovely color!',115, 2);
+INSERT INTO comments(comment_id, date, message, image_id, user_id) VALUES (221, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',115, 2);
INSERT INTO metatags(metatag_id, tag) VALUES (7, 'butterfly');
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 7, image_id from Images where name like '067%');
@@ -634,4 +594,3 @@
INSERT INTO metatags(metatag_id, tag) VALUES (29, 'starfish');
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 29, image_id from Images where name like '45021%');
INSERT INTO IMAGES_METATAGS(CI_METATAG_ID, CI_IMAGE_ID) ( select 29, image_id from Images where name like '45023%');
-
Modified: trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java
===================================================================
--- trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java 2009-04-12 19:12:48 UTC (rev 13518)
+++ trunk/test-applications/realworld2/web/src/main/java/org/richfaces/realworld/ui/ImageLoader.java 2009-04-13 10:26:15 UTC (rev 13519)
@@ -75,9 +75,9 @@
in.close();
}
- }else{
- String prefix = excludeFilePrefix(imageResource.getPath());
- paintImage(out, fileManager.transformPath(Constants.DEFAULT_ORIGINAL_PICTURE, prefix));
+ } else {
+ String suffix = excludeFilePrefix(imageResource.getPath());
+ paintImage(out, fileManager.transformPath(Constants.DEFAULT_ORIGINAL_PICTURE, suffix));
return;
}
}
Modified: trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageEditInfo.xhtml
===================================================================
(Binary files differ)
Modified: trunk/test-applications/realworld2/web/src/main/webapp/includes/image/imageInfo.xhtml
===================================================================
(Binary files differ)
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13518 - trunk/test-applications/seleniumTest/richfaces/src/test/java/org/richfaces/testng.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-04-12 15:12:48 -0400 (Sun, 12 Apr 2009)
New Revision: 13518
Modified:
trunk/test-applications/seleniumTest/richfaces/src/test/java/org/richfaces/testng/AjaxLogTest.java
Log:
AjaxLogTest updated
Modified: trunk/test-applications/seleniumTest/richfaces/src/test/java/org/richfaces/testng/AjaxLogTest.java
===================================================================
--- trunk/test-applications/seleniumTest/richfaces/src/test/java/org/richfaces/testng/AjaxLogTest.java 2009-04-12 16:34:18 UTC (rev 13517)
+++ trunk/test-applications/seleniumTest/richfaces/src/test/java/org/richfaces/testng/AjaxLogTest.java 2009-04-12 19:12:48 UTC (rev 13518)
@@ -50,7 +50,9 @@
selenium.windowFocus();
//writeStatus("Type smth. All typing is being logged");
- type(inputElemId, "typing");
+
+ //http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Selenium%20FAQ#section-Selenium+FAQ-WhyDoYouUseTheTypeKeysCommandAndThenFollowThatCommandUpWithTypeWithTheExactSameTextInAdditionINoticedSomeTyposWhenYouWroteTheValuesForTheTypeKeysCommands
+ selenium.typeKeys(inputElemId, "taping");
try {
selenium.selectWindow("logWindow");
@@ -84,7 +86,8 @@
writeStatus("Type smth. All typing is being logged");
- type(inputElemId, "typing");
+ http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Selenium%20FA...
+ selenium.typeKeys(inputElemId, "taping");
waitForAjaxCompletion();
writeStatus("test that log element is present");
@@ -108,7 +111,8 @@
writeStatus("Type smth. All typing is being logged");
- type(inputElemId, "typing");
+ http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Selenium%20FA...
+ selenium.typeKeys(inputElemId, "taping");
waitForAjaxCompletion();
writeStatus("test that log element is present");
15 years, 2 months
- 1
- 0
JBoss Rich Faces SVN: r13517 - trunk/ui/colorPicker/src/main/templates/org/richfaces.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-04-12 12:34:18 -0400 (Sun, 12 Apr 2009)
New Revision: 13517
Modified:
trunk/ui/colorPicker/src/main/templates/org/richfaces/htmlColorPicker.jspx
Log:
https://jira.jboss.org/jira/browse/RF-6616
Modified: trunk/ui/colorPicker/src/main/templates/org/richfaces/htmlColorPicker.jspx
===================================================================
--- trunk/ui/colorPicker/src/main/templates/org/richfaces/htmlColorPicker.jspx 2009-04-12 15:36:48 UTC (rev 13516)
+++ trunk/ui/colorPicker/src/main/templates/org/richfaces/htmlColorPicker.jspx 2009-04-12 16:34:18 UTC (rev 13517)
@@ -19,12 +19,12 @@
<c:object var="showEvent" type="java.lang.String" />
<c:object var="clientIdJquery" type="java.lang.String" />
<c:object var="colorMode" type="java.lang.String" />
- <c:object var="value" type="java.lang.String" />
+ <c:object var="value" type="java.lang.String" value="#{this:getInputValue(context, component)}" />
<f:call name="addPopupToAjaxRendered" />
<span id="#{clientId}" class="rich-colorPicker-span" x:passThruWithExclusions="value,name,type,id,styleClass,class,style">
- <input readonly="readonly" type="text" name="#{clientId}" value="#{this:getInputValue(context, component)}"/>
+ <input readonly="readonly" type="text" name="#{clientId}" value="#{value}"/>
<jsp:scriptlet><![CDATA[
if(component.getFacet("icon")!=null && component.getFacet("icon").isRendered()) {
]]></jsp:scriptlet>
@@ -106,7 +106,6 @@
Boolean flat = (Boolean) component.getAttributes().get("flat");
colorMode = (String) component.getAttributes().get("colorMode");
showEvent = (String) component.getAttributes().get("showEvent");
- value = (String) component.getAttributes().get("value");
if (value == null || value.length() == 0){
value = "#ffffff";
15 years, 2 months
- 1
- 0