JBoss Rich Faces SVN: r14044 - in trunk/ui/layout/src/main: templates/org/richfaces and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: alexsmirnov
Date: 2009-05-06 17:48:34 -0400 (Wed, 06 May 2009)
New Revision: 14044
Added:
trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/fonts.xcss
trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/page.xcss
Modified:
trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/simple.xcss
trunk/ui/layout/src/main/templates/org/richfaces/htmlPage.jspx
Log:
https://jira.jboss.org/jira/browse/RF-7042
Added: trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/fonts.xcss
===================================================================
--- trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/fonts.xcss (rev 0)
+++ trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/fonts.xcss 2009-05-06 21:48:34 UTC (rev 14044)
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<f:template xmlns:f='http:/jsf.exadel.com/template'
+ xmlns:u='http:/jsf.exadel.com/template/util'
+ xmlns="http://www.w3.org/1999/xhtml">
+
+<u:selector name="body" >
+ <u:style name="font" value="13px/1.231 arial,helvetica,clean,sans-serif" />
+ <u:style name="*font-size" value="small" /> /* for IE */
+ <u:style name="*font" value="x-small" /> /* for IE in quirks mode */
+</u:selector>
+
+/**
+ * Nudge down to get to 13px equivalent for these form elements
+ */
+<u:selector name="select,input,button,textarea" >
+ <u:style name="font" value="99% arial,helvetica,clean,sans-serif" />
+</u:selector>
+
+/**
+ * To help tables remember to inherit
+ */
+<u:selector name="table" >
+ <u:style name="font-size" value="inherit" />
+ <u:style name="font" value="100%" />
+</u:selector>
+
+/**
+ * Bump up IE to get to 13px equivalent for these fixed-width elements
+ */
+<u:selector name="pre,code,kbd,samp,tt">
+ <u:style name="font-family" value="monospace" />
+ <u:style name="*font-size" value="108%" />
+ <u:style name="line-height" value="100%" />
+</u:selector>
+</f:template>
\ No newline at end of file
Added: trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/page.xcss
===================================================================
--- trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/page.xcss (rev 0)
+++ trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/page.xcss 2009-05-06 21:48:34 UTC (rev 14044)
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<f:template xmlns:f='http:/jsf.exadel.com/template'
+ xmlns:u='http:/jsf.exadel.com/template/util'
+ xmlns="http://www.w3.org/1999/xhtml">
+<u:selector name=".rich-page-footer">
+ <u:style name="clear" value="both" />
+</u:selector>
+<u:selector name=".rich-page">
+ <u:style name="margin" value="auto" />
+ <u:style name="text-align" value="left" />
+ <u:style name="min-width" value="750px" />
+</u:selector>
+<u:selector name=".rich-page-sidebar">
+ <u:style name="position" value="relative" />
+</u:selector>
+<u:selector name=".rich-page-sidebar,.rich-page-body">
+ <u:style name="_position" value="static" />
+</u:selector>
+<u:selector name=".rich-page-body">
+ <u:style name="position" value="static" />
+</u:selector>
+<u:selector name=".rich-page-main ">
+ <u:style name="width" value="100%" />
+</u:selector>
+<u:selector name=".rich-page-content:after">
+ <u:style name="content" value="'.'" />
+ <u:style name="display" value="block" />
+ <u:style name="height" value="0" />
+ <u:style name="clear" value="both" />
+ <u:style name="visibility" value="hidden" />
+</u:selector>
+<u:selector name=".rich-page-content">
+ <u:style name="zoom" value="1" />
+</u:selector>
+</f:template>
\ No newline at end of file
Modified: trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/simple.xcss
===================================================================
--- trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/simple.xcss 2009-05-06 21:47:59 UTC (rev 14043)
+++ trunk/ui/layout/src/main/resources/org/richfaces/renderkit/html/css/simple.xcss 2009-05-06 21:48:34 UTC (rev 14044)
@@ -43,13 +43,15 @@
</u:selector>
<u:selector name=".rich-page-content">
- <!-- u:style name="background-image">
+ <!--
+ <u:style name="background-image">
<f:resource f:key="org.richfaces.renderkit.html.images.PageContentGradient"/>
- </u:style-->
- <u:style name="min-height" value="200px" />
- <u:style name="background-color" skin="generalBackgroundColor"/>
+ <u:style name="min-height" value="200px" />
+ </u:style>
<u:style name="background-repeat" value="repeat-x"/>
<u:style name="background-position" value="top left"/>
+ -->
+ <u:style name="background-color" skin="generalBackgroundColor"/>
<u:style name="border" value="2px solid" />
<u:style name="border-color" skin="panelBorderColor" />
</u:selector>
Modified: trunk/ui/layout/src/main/templates/org/richfaces/htmlPage.jspx
===================================================================
--- trunk/ui/layout/src/main/templates/org/richfaces/htmlPage.jspx 2009-05-06 21:47:59 UTC (rev 14043)
+++ trunk/ui/layout/src/main/templates/org/richfaces/htmlPage.jspx 2009-05-06 21:48:34 UTC (rev 14044)
@@ -11,7 +11,7 @@
baseclass="org.richfaces.renderkit.AbstractPageRenderer"
component="org.richfaces.component.UIPage"
>
- <h:styles>css/fonts.css,css/page.css</h:styles>
+ <h:styles>css/page.xcss</h:styles>
<f:clientid var="clientId"/>
<c:set var="namespace" value="#{this:prolog(context,component)}"/>
<html x:xmlns="#{namespace}" x:lang="#{context.viewRoot.locale}"
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14043 - trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-05-06 17:47:59 -0400 (Wed, 06 May 2009)
New Revision: 14043
Modified:
trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js
Log:
https://jira.jboss.org/jira/browse/RF-7040
Modified: trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js
===================================================================
--- trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js 2009-05-06 21:45:16 UTC (rev 14042)
+++ trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js 2009-05-06 21:47:59 UTC (rev 14043)
@@ -7060,7 +7060,7 @@
n.src = tinymce.baseURL + '/plugins/safari/blank.htm';
} else {
if (!isIE || !tinymce.relaxedDomain) {
- if (!isWebKit || n.tagName != 'iframe' /* not XHTML mode */) {
+ if (!isWebKit || !n || n.tagName != 'iframe' /* not XHTML mode */) {
t.setupIframe();
} else {
var _t = t;
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14042 - trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-05-06 17:45:16 -0400 (Wed, 06 May 2009)
New Revision: 14042
Modified:
trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js
Log:
https://jira.jboss.org/jira/browse/RF-7040
Modified: trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js
===================================================================
--- trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js 2009-05-06 19:47:11 UTC (rev 14041)
+++ trunk/ui/editor/src/main/resources/org/richfaces/renderkit/html/scripts/tiny_mce/tiny_mce_src.js 2009-05-06 21:45:16 UTC (rev 14042)
@@ -7059,9 +7059,15 @@
Event.add(n, 'load', t.setupIframe, t);
n.src = tinymce.baseURL + '/plugins/safari/blank.htm';
} else {
- if (!isIE || !tinymce.relaxedDomain)
- t.setupIframe();
-
+ if (!isIE || !tinymce.relaxedDomain) {
+ if (!isWebKit || n.tagName != 'iframe' /* not XHTML mode */) {
+ t.setupIframe();
+ } else {
+ var _t = t;
+ setTimeout(function() { _t.setupIframe(); _t = undefined; }, 0);
+ }
+ }
+
e = n = o = null; // Cleanup
}
},
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14041 - trunk/ui/paint2D/src/main/config/component.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-05-06 15:47:11 -0400 (Wed, 06 May 2009)
New Revision: 14041
Modified:
trunk/ui/paint2D/src/main/config/component/paint2D.xml
Log:
https://jira.jboss.org/jira/browse/RF-7044
Modified: trunk/ui/paint2D/src/main/config/component/paint2D.xml
===================================================================
--- trunk/ui/paint2D/src/main/config/component/paint2D.xml 2009-05-06 19:46:48 UTC (rev 14040)
+++ trunk/ui/paint2D/src/main/config/component/paint2D.xml 2009-05-06 19:47:11 UTC (rev 14041)
@@ -109,7 +109,7 @@
<classname>java.lang.String</classname>
<description><![CDATA[
For compability with XHTML 1.1 standart]]></description>
- <defaultvalue>" "</defaultvalue>
+ <defaultvalue>""</defaultvalue>
</property>
<property hidden="true">
<name>dir</name>
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14040 - trunk/ui/dataTable/src/main/java/org/richfaces/renderkit.
by richfaces-svn-commits＠lists.jboss.org
Author: nbelaevski
Date: 2009-05-06 15:46:48 -0400 (Wed, 06 May 2009)
New Revision: 14040
Modified:
trunk/ui/dataTable/src/main/java/org/richfaces/renderkit/AbstractTableRenderer.java
Log:
https://jira.jboss.org/jira/browse/RF-5104
Modified: trunk/ui/dataTable/src/main/java/org/richfaces/renderkit/AbstractTableRenderer.java
===================================================================
--- trunk/ui/dataTable/src/main/java/org/richfaces/renderkit/AbstractTableRenderer.java 2009-05-06 17:34:23 UTC (rev 14039)
+++ trunk/ui/dataTable/src/main/java/org/richfaces/renderkit/AbstractTableRenderer.java 2009-05-06 19:46:48 UTC (rev 14040)
@@ -779,7 +779,7 @@
if (imageUrl != null) {
writer.startElement(HTML.IMG_ELEMENT, column);
writer.writeAttribute(HTML.src_ATTRIBUTE, imageUrl, null);
- writer.writeAttribute(HTML.alt_ATTRIBUTE, " ", null);
+ writer.writeAttribute(HTML.alt_ATTRIBUTE, "", null);
writer.writeAttribute(HTML.width_ATTRIBUTE, "15", null);
writer.writeAttribute(HTML.height_ATTRIBUTE, "15", null);
writer.writeAttribute(HTML.class_ATTRIBUTE, "dr-table-header-sort-img rich-sort-icon", null);
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14039 - in trunk/examples/photoalbum/source: ejb/sql/short and 7 other directories.
by richfaces-svn-commits＠lists.jboss.org
Author: Alex.Kolonitsky
Date: 2009-05-06 13:34:23 -0400 (Wed, 06 May 2009)
New Revision: 14039
Removed:
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457].jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/1/
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small80.jpg
Modified:
trunk/examples/photoalbum/source/ejb/sql/full/import.sql
trunk/examples/photoalbum/source/ejb/sql/short/import.sql
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small80.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_medium.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small120.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small160.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small200.jpg
trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small80.jpg
Log:
Change images
Modified: trunk/examples/photoalbum/source/ejb/sql/full/import.sql
===================================================================
--- trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-06 15:48:08 UTC (rev 14038)
+++ trunk/examples/photoalbum/source/ejb/sql/full/import.sql 2009-05-06 17:34:23 UTC (rev 14039)
@@ -2,534 +2,562 @@
INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (2, 'Nick', 'Curtis', 'nkurtis(a)iba.com', 'Viking', '8cb2237d0679ca88db6464eac60da96345513964', '1978-01-08', 1, 0, true);
INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname', '8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08', 1, 0, true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature images', 1, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature images', 1, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature images', 2, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature images', 3, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true);
---------------------------------------------------------------------
-- ALBUM - Animals"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals images', 1, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (0, 'Animals');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '1750979205_6e51b47ce9_o.jpg', '1750979205_6e51b47ce9_o.jpg', 'Animals - 1750979205_6e51b47ce9_o.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 0);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (0, '1985-01-08', '++Beautiful',0, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (1, '1985-01-08', 'this is extremely Good:) Congratulations!',0, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (2, '1985-01-08', 'Very *lovely*',0, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (0, '1985-01-08', 'this is extremely Good:) Congratulations!',0, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (1, '1906662004_655d0f6ccf_o.jpg', '1906662004_655d0f6ccf_o.jpg', 'Animals - 1906662004_655d0f6ccf_o.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (3, '1985-01-08', 'fantastic shot !!!!!!',1, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (1, '1985-01-08', 'nice shot =) ',1, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (2, '1985-01-08', 'nice shot =) ',1, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (2, '2090459727_f2888e5cbe_o.jpg', '2090459727_f2888e5cbe_o.jpg', 'Animals - 2090459727_f2888e5cbe_o.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (4, '1985-01-08', 'fantastic shot !!!!!!',2, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (5, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',2, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (3, '2297752925_de29b5fb10_o.jpg', '2297752925_de29b5fb10_o.jpg', 'Animals - 2297752925_de29b5fb10_o.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (3, '1985-01-08', 'that is a beautiful flower with great colours ',3, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (4, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',3, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (5, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',3, 3);
INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (6, '1985-01-08', 'Gorgeous! Lovely color!',3, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (7, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',3, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (8, '1985-01-08', 'Amazing shot..',3, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (9, '1985-01-08', '++Beautiful',3, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '2298556444_2151b7a6c4_o.jpg', '2298556444_2151b7a6c4_o.jpg', 'Animals - 2298556444_2151b7a6c4_o.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 4);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (10, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',4, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (11, '1985-01-08', 'Beautiful colours. Nice close up. ',4, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (7, '1985-01-08', 'Stunning capture! :-)',4, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (8, '1985-01-08', 'Wonderful.',4, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (5, '2508246015_313952406c_o.jpg', '2508246015_313952406c_o.jpg', 'Animals - 2508246015_313952406c_o.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 5);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (9, '1985-01-08', 'Gorgeous! Lovely color!',5, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (6, '2521898117_f2ebf233c9_o.jpg', '2521898117_f2ebf233c9_o.jpg', 'Animals - 2521898117_f2ebf233c9_o.jpg image', '2009-12-18', 0, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 6);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (10, '1985-01-08', 'this is extremely Good:) Congratulations!',6, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (11, '1985-01-08', 'fantastic shot !!!!!!',6, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (7, '308709862_f8f7fbcec4_b.jpg', '308709862_f8f7fbcec4_b.jpg', 'Animals - 308709862_f8f7fbcec4_b.jpg image', '2009-12-18', 0, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 7);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (12, '1985-01-08', 'Amazing shot..',7, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (12, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',7, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (13, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',7, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '3390059723_4b2883ee59_o.jpg', '3390059723_4b2883ee59_o.jpg', 'Animals - 3390059723_4b2883ee59_o.jpg image', '2009-12-18', 0, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 8);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (14, '1985-01-08', 'Wonderful.',8, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (15, '1985-01-08', 'Amazing shot..',8, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (16, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',8, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (17, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',8, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (9, '3390865548_e394404198_o.jpg', '3390865548_e394404198_o.jpg', 'Animals - 3390865548_e394404198_o.jpg image', '2009-12-18', 0, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 9);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (18, '1985-01-08', 'that is a beautiful flower with great colours ',9, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (10, '3390879696_059660d45c_o.jpg', '3390879696_059660d45c_o.jpg', 'Animals - 3390879696_059660d45c_o.jpg image', '2009-12-18', 0, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 10);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (13, '1985-01-08', 'Stunning capture! :-)',10, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (14, '1985-01-08', 'nice shot =) ',10, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (19, '1985-01-08', 'Perfecft!',10, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (20, '1985-01-08', 'whoah ! wonderful',10, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (21, '1985-01-08', 'Wonderful.',10, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (22, '1985-01-08', 'Amazing shot..',10, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (11, '3390886140_b05ae25b14_o.jpg', '3390886140_b05ae25b14_o.jpg', 'Animals - 3390886140_b05ae25b14_o.jpg image', '2009-12-18', 0, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 11);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (15, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',11, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (16, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',11, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (17, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',11, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (18, '1985-01-08', 'Amazing shot..',11, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (23, '1985-01-08', 'this is extremely Good:) Congratulations!',11, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (24, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',11, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (25, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',11, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (26, '1985-01-08', 'Bellissima macro!',11, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (12, '3413588364_dd0d602b9b_o.jpg', '3413588364_dd0d602b9b_o.jpg', 'Animals - 3413588364_dd0d602b9b_o.jpg image', '2009-12-18', 0, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 12);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (19, '1985-01-08', 'Stunning capture! :-)',12, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (20, '1985-01-08', 'that is a beautiful flower with great colours ',12, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (21, '1985-01-08', 'I Think this is Art!',12, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (27, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',12, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (28, '1985-01-08', '++Beautiful',12, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (29, '1985-01-08', 'Beautiful colours. Nice close up. ',12, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (30, '1985-01-08', 'Beautiful colours. Nice close up. ',12, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (13, '3415160108_c22eb69f37_o.jpg', '3415160108_c22eb69f37_o.jpg', 'Animals - 3415160108_c22eb69f37_o.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 13);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (31, '1985-01-08', 'Wonderful.',13, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (14, '3415165572_f6d48c2a21_o.jpg', '3415165572_f6d48c2a21_o.jpg', 'Animals - 3415165572_f6d48c2a21_o.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 14);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (22, '1985-01-08', 'Perfecft!',14, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (23, '1985-01-08', 'Perfecft!',14, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (32, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',14, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (33, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',14, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '839245545_5db77619d5_o.jpg', '839245545_5db77619d5_o.jpg', 'Animals - 839245545_5db77619d5_o.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 15);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (34, '1985-01-08', 'Beautiful colours. Nice close up. ',15, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (35, '1985-01-08', 'Gorgeous! Lovely color!',15, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (36, '1985-01-08', 'love every thing about this picture, really beautiful... :))',15, 2);
UPDATE Album set coveringImage_id=15 where id = 0;
---------------------------------------------------------------------
-- ALBUM - Cars"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars images', 3, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars pictures', 2, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (1, 'Cars');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '190193308_ce2a4de5fa_o.jpg', '190193308_ce2a4de5fa_o.jpg', 'Cars - 190193308_ce2a4de5fa_o.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 16);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (24, '1985-01-08', 'Bellísima.!!! saludos.',16, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (25, '1985-01-08', 'Gorgeous! Lovely color!',16, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (37, '1985-01-08', 'Amazing shot..',16, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (38, '1985-01-08', 'Wonderful.',16, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (17, '1941230817_bcce17b8ef_o.jpg', '1941230817_bcce17b8ef_o.jpg', 'Cars - 1941230817_bcce17b8ef_o.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 17);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (39, '1985-01-08', 'whoah ! wonderful',17, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (18, '2151423750_129317a034_o.jpg', '2151423750_129317a034_o.jpg', 'Cars - 2151423750_129317a034_o.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 18);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (26, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',18, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (27, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',18, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (19, '2233985073_9a3fd7d3ac_b.jpg', '2233985073_9a3fd7d3ac_b.jpg', 'Cars - 2233985073_9a3fd7d3ac_b.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 19);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (40, '1985-01-08', 'Amazing shot..',19, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (41, '1985-01-08', 'Perfecft!',19, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (42, '1985-01-08', 'I Think this is Art!',19, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (20, '2386071696_2b4e84eddb_o.jpg', '2386071696_2b4e84eddb_o.jpg', 'Cars - 2386071696_2b4e84eddb_o.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 20);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (28, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',20, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (29, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',20, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (30, '1985-01-08', 'whoah ! wonderful',20, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (43, '1985-01-08', 'Stunning capture! :-)',20, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (44, '1985-01-08', 'Bellísima.!!! saludos.',20, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (45, '1985-01-08', 'Gorgeous! Lovely color!',20, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (46, '1985-01-08', 'Wonderful.',20, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (21, '3089719367_a03a2b55a4_b.jpg', '3089719367_a03a2b55a4_b.jpg', 'Cars - 3089719367_a03a2b55a4_b.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 21);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (31, '1985-01-08', 'Gorgeous! Lovely color!',21, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (47, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',21, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (48, '1985-01-08', 'Stunning capture! :-)',21, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (49, '1985-01-08', '++Beautiful',21, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (22, '3200944376_2867888262_b.jpg', '3200944376_2867888262_b.jpg', 'Cars - 3200944376_2867888262_b.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 22);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (32, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',22, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (33, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',22, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (50, '1985-01-08', 'this is extremely Good:) Congratulations!',22, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (51, '1985-01-08', 'Gorgeous! Lovely color!',22, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (52, '1985-01-08', 'fantastic shot !!!!!!',22, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (53, '1985-01-08', 'Bellissima macro!',22, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (23, '3286825259_2a927e8ec1_o.jpg', '3286825259_2a927e8ec1_o.jpg', 'Cars - 3286825259_2a927e8ec1_o.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 23);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (34, '1985-01-08', 'fantastic shot !!!!!!',23, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (35, '1985-01-08', 'Beautiful colours. Nice close up. ',23, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (54, '1985-01-08', 'love every thing about this picture, really beautiful... :))',23, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (55, '1985-01-08', 'Wonderful.',23, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '3287637120_c1b3495371_o.jpg', '3287637120_c1b3495371_o.jpg', 'Cars - 3287637120_c1b3495371_o.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 24);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (36, '1985-01-08', 'Bellissima macro!',24, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (37, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',24, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (56, '1985-01-08', 'Wonderful.',24, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (25, '3327664478_7f77093f52_o.jpg', '3327664478_7f77093f52_o.jpg', 'Cars - 3327664478_7f77093f52_o.jpg image', '2009-12-18', 1, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 25);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (38, '1985-01-08', 'Wonderful.',25, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (57, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',25, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (58, '1985-01-08', 'nice shot =) ',25, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (59, '1985-01-08', 'Bellissima macro!',25, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (26, '361088850_73d4bef19a_o.jpg', '361088850_73d4bef19a_o.jpg', 'Cars - 361088850_73d4bef19a_o.jpg image', '2009-12-18', 1, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 26);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (39, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',26, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (40, '1985-01-08', 'fantastic shot !!!!!!',26, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (41, '1985-01-08', 'love every thing about this picture, really beautiful... :))',26, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (60, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',26, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (61, '1985-01-08', 'Gorgeous! Lovely color!',26, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (62, '1985-01-08', 'Very *lovely*',26, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (63, '1985-01-08', 'Gorgeous! Lovely color!',26, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, '361091514_20cd7e7eea_o.jpg', '361091514_20cd7e7eea_o.jpg', 'Cars - 361091514_20cd7e7eea_o.jpg image', '2009-12-18', 1, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 27);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (64, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',27, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (65, '1985-01-08', 'Wonderful.',27, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (66, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',27, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (67, '1985-01-08', 'whoah ! wonderful',27, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (28, '361092609_25d6d4bd90_o.jpg', '361092609_25d6d4bd90_o.jpg', 'Cars - 361092609_25d6d4bd90_o.jpg image', '2009-12-18', 1, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 28);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (42, '1985-01-08', 'Bellissima macro!',28, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (43, '1985-01-08', 'nice shot =) ',28, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (44, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',28, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (68, '1985-01-08', 'Beautiful colours. Nice close up. ',28, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (69, '1985-01-08', 'Very *lovely*',28, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (70, '1985-01-08', 'I Think this is Art!',28, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (29, '400440032_a63fe65cab_o.jpg', '400440032_a63fe65cab_o.jpg', 'Cars - 400440032_a63fe65cab_o.jpg image', '2009-12-18', 1, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 29);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (45, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',29, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (46, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',29, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (47, '1985-01-08', 'this is extremely Good:) Congratulations!',29, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (48, '1985-01-08', 'I Think this is Art!',29, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (71, '1985-01-08', 'Gorgeous! Lovely color!',29, 2);
UPDATE Album set coveringImage_id=29 where id = 1;
---------------------------------------------------------------------
-- ALBUM - Monuments and just buildings"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings images', 4, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings pictures', 4, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (2, 'Monuments and just buildings');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (30, '05[303x457].jpg', '05[303x457].jpg', 'Monuments and just buildings - 05[303x457].jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 30);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (49, '1985-01-08', 'I Think this is Art!',30, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (72, '1985-01-08', 'Gorgeous! Lovely color!',30, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (73, '1985-01-08', 'this is extremely Good:) Congratulations!',30, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (74, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',30, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (31, '07[303x457].jpg', '07[303x457].jpg', 'Monuments and just buildings - 07[303x457].jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 31);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (50, '1985-01-08', 'I Think this is Art!',31, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (51, '1985-01-08', 'nice shot =) ',31, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (52, '1985-01-08', 'whoah ! wonderful',31, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (32, '1805365000_ca64d20b10_o.jpg', '1805365000_ca64d20b10_o.jpg', 'Monuments and just buildings - 1805365000_ca64d20b10_o.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 32);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (33, '1[303x457].jpg', '1[303x457].jpg', 'Monuments and just buildings - 1[303x457].jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 33);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (75, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',33, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (76, '1985-01-08', 'Bellissima macro!',33, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (34, '2099090261_1efb89ae95_o.jpg', '2099090261_1efb89ae95_o.jpg', 'Monuments and just buildings - 2099090261_1efb89ae95_o.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 34);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (53, '1985-01-08', 'that is a beautiful flower with great colours ',34, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (54, '1985-01-08', 'Such a lovely colour azaga!',34, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (55, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',34, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (77, '1985-01-08', 'whoah ! wonderful',34, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (78, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',34, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (35, '2976358258_5c08813ddf_o.jpg', '2976358258_5c08813ddf_o.jpg', 'Monuments and just buildings - 2976358258_5c08813ddf_o.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 35);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (56, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',35, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (57, '1985-01-08', 'Wonderful.',35, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (58, '1985-01-08', 'Bellissima macro!',35, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (79, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',35, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (36, '2[457x303].jpg', '2[457x303].jpg', 'Monuments and just buildings - 2[457x303].jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 36);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (59, '1985-01-08', 'Perfecft!',36, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (60, '1985-01-08', 'love every thing about this picture, really beautiful... :))',36, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (61, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',36, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (80, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',36, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (81, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',36, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (82, '1985-01-08', 'Such a lovely colour azaga!',36, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (83, '1985-01-08', 'Such a lovely colour azaga!',36, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (37, '32971256_8bd6bf165d_o.jpg', '32971256_8bd6bf165d_o.jpg', 'Monuments and just buildings - 32971256_8bd6bf165d_o.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 37);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (62, '1985-01-08', 'Bellísima.!!! saludos.',37, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (63, '1985-01-08', 'Very *lovely*',37, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (64, '1985-01-08', 'Such a lovely colour azaga!',37, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (84, '1985-01-08', 'Wonderful.',37, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (85, '1985-01-08', 'Amazing shot..',37, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (86, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',37, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (87, '1985-01-08', 'that is a beautiful flower with great colours ',37, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (38, '3392872753_e47f1c7078_o.jpg', '3392872753_e47f1c7078_o.jpg', 'Monuments and just buildings - 3392872753_e47f1c7078_o.jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 38);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (88, '1985-01-08', 'nice shot =) ',38, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (89, '1985-01-08', 'Stunning capture! :-)',38, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (39, '3397511520_9839039136_o.jpg', '3397511520_9839039136_o.jpg', 'Monuments and just buildings - 3397511520_9839039136_o.jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 39);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (90, '1985-01-08', 'Gorgeous! Lovely color!',39, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (40, '3399540332_576df61129_o.jpg', '3399540332_576df61129_o.jpg', 'Monuments and just buildings - 3399540332_576df61129_o.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 40);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (65, '1985-01-08', 'Gorgeous! Lovely color!',40, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (66, '1985-01-08', 'this is extremely Good:) Congratulations!',40, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (67, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',40, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (91, '1985-01-08', 'Wonderful.',40, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (92, '1985-01-08', 'Very *lovely*',40, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (41, '3403152285_3e72d1264a_o.jpg', '3403152285_3e72d1264a_o.jpg', 'Monuments and just buildings - 3403152285_3e72d1264a_o.jpg image', '2009-12-18', 2, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 41);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (68, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',41, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (69, '1985-01-08', 'I Think this is Art!',41, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (70, '1985-01-08', 'love every thing about this picture, really beautiful... :))',41, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (71, '1985-01-08', 'Gorgeous! Lovely color!',41, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (93, '1985-01-08', '++Beautiful',41, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (42, '3413630679_d77f525413_o.jpg', '3413630679_d77f525413_o.jpg', 'Monuments and just buildings - 3413630679_d77f525413_o.jpg image', '2009-12-18', 2, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 42);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (72, '1985-01-08', 'Bellísima.!!! saludos.',42, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (73, '1985-01-08', 'whoah ! wonderful',42, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (74, '1985-01-08', 'Stunning capture! :-)',42, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (75, '1985-01-08', 'Wonderful.',42, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (94, '1985-01-08', 'Amazing shot..',42, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (43, '3414974777_a4f44f69c7_o.jpg', '3414974777_a4f44f69c7_o.jpg', 'Monuments and just buildings - 3414974777_a4f44f69c7_o.jpg image', '2009-12-18', 2, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 43);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (76, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',43, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (77, '1985-01-08', 'Perfecft!',43, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (78, '1985-01-08', 'Wonderful.',43, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (79, '1985-01-08', 'Such a lovely colour azaga!',43, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (95, '1985-01-08', 'love every thing about this picture, really beautiful... :))',43, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (44, '3415278215_968db2dbbf_o.jpg', '3415278215_968db2dbbf_o.jpg', 'Monuments and just buildings - 3415278215_968db2dbbf_o.jpg image', '2009-12-18', 2, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 44);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (80, '1985-01-08', 'Stunning capture! :-)',44, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (81, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',44, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (96, '1985-01-08', 'this is extremely Good:) Congratulations!',44, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (97, '1985-01-08', 'that is a beautiful flower with great colours ',44, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (98, '1985-01-08', 'fantastic shot !!!!!!',44, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (45, '3415840434_949aeabf08_o.jpg', '3415840434_949aeabf08_o.jpg', 'Monuments and just buildings - 3415840434_949aeabf08_o.jpg image', '2009-12-18', 2, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 45);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (82, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',45, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (83, '1985-01-08', 'this is extremely Good:) Congratulations!',45, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (84, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',45, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (85, '1985-01-08', 'Amazing shot..',45, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (99, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',45, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (46, '370031898_84e952e0b0_o.jpg', '370031898_84e952e0b0_o.jpg', 'Monuments and just buildings - 370031898_84e952e0b0_o.jpg image', '2009-12-18', 2, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 46);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (86, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',46, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (87, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',46, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (88, '1985-01-08', 'fantastic shot !!!!!!',46, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (89, '1985-01-08', 'Bellissima macro!',46, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (100, '1985-01-08', 'fantastic shot !!!!!!',46, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (101, '1985-01-08', 'this is extremely Good:) Congratulations!',46, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (47, '381889523_f276d45e9d_o.jpg', '381889523_f276d45e9d_o.jpg', 'Monuments and just buildings - 381889523_f276d45e9d_o.jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 47);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (90, '1985-01-08', 'fantastic shot !!!!!!',47, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (102, '1985-01-08', 'I Think this is Art!',47, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (48, '441026665_07699ebddd_o.jpg', '441026665_07699ebddd_o.jpg', 'Monuments and just buildings - 441026665_07699ebddd_o.jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 48);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (91, '1985-01-08', 'that is a beautiful flower with great colours ',48, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (92, '1985-01-08', 'Bellissima macro!',48, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (93, '1985-01-08', 'I Think this is Art!',48, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (103, '1985-01-08', 'Gorgeous! Lovely color!',48, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (49, '4[457x303].jpg', '4[457x303].jpg', 'Monuments and just buildings - 4[457x303].jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 49);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (104, '1985-01-08', 'Gorgeous! Lovely color!',49, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (50, '960942349_dcc90c0a61_o.jpg', '960942349_dcc90c0a61_o.jpg', 'Monuments and just buildings - 960942349_dcc90c0a61_o.jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 50);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (105, '1985-01-08', 'Beautiful colours. Nice close up. ',50, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (106, '1985-01-08', 'love every thing about this picture, really beautiful... :))',50, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (107, '1985-01-08', 'Very *lovely*',50, 3);
UPDATE Album set coveringImage_id=50 where id = 2;
---------------------------------------------------------------------
-- ALBUM - Nature"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature images', 2, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 2, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (3, 'Nature');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (51, '01[303x202].jpg', '01[303x202].jpg', 'Nature - 01[303x202].jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 51);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (94, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',51, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (108, '1985-01-08', 'Perfecft!',51, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (109, '1985-01-08', 'I Think this is Art!',51, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (110, '1985-01-08', 'that is a beautiful flower with great colours ',51, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (52, '1[305x457].jpg', '1[305x457].jpg', 'Nature - 1[305x457].jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 52);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (111, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',52, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (53, '273927725_c9f5ef5952_o.jpg', '273927725_c9f5ef5952_o.jpg', 'Nature - 273927725_c9f5ef5952_o.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 53);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (95, '1985-01-08', 'love every thing about this picture, really beautiful... :))',53, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (96, '1985-01-08', 'that is a beautiful flower with great colours ',53, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (97, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',53, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (112, '1985-01-08', 'Very *lovely*',53, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (113, '1985-01-08', 'Very *lovely*',53, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (114, '1985-01-08', 'whoah ! wonderful',53, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (115, '1985-01-08', 'Bellissima macro!',53, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (54, '2[303x457].jpg', '2[303x457].jpg', 'Nature - 2[303x457].jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 54);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (98, '1985-01-08', 'Bellísima.!!! saludos.',54, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (99, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',54, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (100, '1985-01-08', 'Gorgeous! Lovely color!',54, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (116, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',54, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (117, '1985-01-08', 'I Think this is Art!',54, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (55, '3392730627_1cdb18cba6_o.jpg', '3392730627_1cdb18cba6_o.jpg', 'Nature - 3392730627_1cdb18cba6_o.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 55);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (56, '3392993334_36d7f097df_o.jpg', '3392993334_36d7f097df_o.jpg', 'Nature - 3392993334_36d7f097df_o.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 56);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (101, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',56, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (102, '1985-01-08', '++Beautiful',56, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (103, '1985-01-08', 'I Think this is Art!',56, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (118, '1985-01-08', 'Stunning capture! :-)',56, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (119, '1985-01-08', 'Wonderful.',56, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (120, '1985-01-08', 'love every thing about this picture, really beautiful... :))',56, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (57, '3393235094_7cc613d363_o.jpg', '3393235094_7cc613d363_o.jpg', 'Nature - 3393235094_7cc613d363_o.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 57);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (121, '1985-01-08', 'Amazing shot..',57, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (122, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',57, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (58, '3412793157_683290a536_o.jpg', '3412793157_683290a536_o.jpg', 'Nature - 3412793157_683290a536_o.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 58);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (59, '3414996504_b42abb3be6_o.jpg', '3414996504_b42abb3be6_o.jpg', 'Nature - 3414996504_b42abb3be6_o.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 59);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (104, '1985-01-08', 'Beautiful colours. Nice close up. ',59, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (105, '1985-01-08', 'Wonderful.',59, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (60, '3415639261_20d2d3b52c_o.jpg', '3415639261_20d2d3b52c_o.jpg', 'Nature - 3415639261_20d2d3b52c_o.jpg image', '2009-12-18', 3, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 60);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (106, '1985-01-08', 'Such a lovely colour azaga!',60, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (107, '1985-01-08', 'fantastic shot !!!!!!',60, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (108, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',60, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (61, '3416307534_40f6616283_o.jpg', '3416307534_40f6616283_o.jpg', 'Nature - 3416307534_40f6616283_o.jpg image', '2009-12-18', 3, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 61);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (109, '1985-01-08', 'Beautiful colours. Nice close up. ',61, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (110, '1985-01-08', 'Beautiful colours. Nice close up. ',61, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (111, '1985-01-08', 'Amazing shot..',61, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (112, '1985-01-08', 'Beautiful colours. Nice close up. ',61, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (123, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',61, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (124, '1985-01-08', 'Wonderful.',61, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (62, '3416321407_068332d9f2_o.jpg', '3416321407_068332d9f2_o.jpg', 'Nature - 3416321407_068332d9f2_o.jpg image', '2009-12-18', 3, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 62);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (113, '1985-01-08', 'fantastic shot !!!!!!',62, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (114, '1985-01-08', 'I Think this is Art!',62, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (125, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',62, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (126, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',62, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (63, '3416371116_f793561d19_o.jpg', '3416371116_f793561d19_o.jpg', 'Nature - 3416371116_f793561d19_o.jpg image', '2009-12-18', 3, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 63);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (115, '1985-01-08', 'fantastic shot !!!!!!',63, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (127, '1985-01-08', 'Stunning capture! :-)',63, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (128, '1985-01-08', 'this is extremely Good:) Congratulations!',63, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (64, '3417131300_2aac5ec32c_o.jpg', '3417131300_2aac5ec32c_o.jpg', 'Nature - 3417131300_2aac5ec32c_o.jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 64);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (116, '1985-01-08', 'love every thing about this picture, really beautiful... :))',64, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (117, '1985-01-08', 'Beautiful colours. Nice close up. ',64, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (129, '1985-01-08', 'Beautiful colours. Nice close up. ',64, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (130, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',64, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (131, '1985-01-08', 'I Think this is Art!',64, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (132, '1985-01-08', 'I Think this is Art!',64, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (65, '3417132360_56d0b48a9d_o.jpg', '3417132360_56d0b48a9d_o.jpg', 'Nature - 3417132360_56d0b48a9d_o.jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 65);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (118, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',65, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (119, '1985-01-08', 'Such a lovely colour azaga!',65, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (133, '1985-01-08', 'love every thing about this picture, really beautiful... :))',65, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (134, '1985-01-08', 'Very *lovely*',65, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (135, '1985-01-08', 'Beautiful colours. Nice close up. ',65, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (136, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',65, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (66, '3417319507_8d1f2d5c77_o.jpg', '3417319507_8d1f2d5c77_o.jpg', 'Nature - 3417319507_8d1f2d5c77_o.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 66);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (120, '1985-01-08', 'that is a beautiful flower with great colours ',66, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (121, '1985-01-08', 'Amazing shot..',66, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (137, '1985-01-08', 'I Think this is Art!',66, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (138, '1985-01-08', 'Bellissima macro!',66, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (139, '1985-01-08', '++Beautiful',66, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (67, '3417494725_e21724aba9_o.jpg', '3417494725_e21724aba9_o.jpg', 'Nature - 3417494725_e21724aba9_o.jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 67);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (122, '1985-01-08', 'that is a beautiful flower with great colours ',67, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (68, '3418371942_a61ae58de4_o.jpg', '3418371942_a61ae58de4_o.jpg', 'Nature - 3418371942_a61ae58de4_o.jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 68);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (123, '1985-01-08', 'Amazing shot..',68, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (124, '1985-01-08', 'fantastic shot !!!!!!',68, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (125, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',68, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (126, '1985-01-08', 'Wonderful.',68, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (140, '1985-01-08', 'Perfecft!',68, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (69, '345009210_1f826cd5a1_o.jpg', '345009210_1f826cd5a1_o.jpg', 'Nature - 345009210_1f826cd5a1_o.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 69);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (70, '55109059_55408b3d5f_o.jpg', '55109059_55408b3d5f_o.jpg', 'Nature - 55109059_55408b3d5f_o.jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 70);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (127, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',70, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (128, '1985-01-08', 'Bellísima.!!! saludos.',70, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (129, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',70, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (130, '1985-01-08', 'Stunning capture! :-)',70, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (141, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',70, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (142, '1985-01-08', 'Stunning capture! :-)',70, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (71, '570841724_b11c8b0df2_o.jpg', '570841724_b11c8b0df2_o.jpg', 'Nature - 570841724_b11c8b0df2_o.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 71);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (131, '1985-01-08', 'Bellísima.!!! saludos.',71, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (143, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',71, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (72, '672840660_4a91f39f02_o.jpg', '672840660_4a91f39f02_o.jpg', 'Nature - 672840660_4a91f39f02_o.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 72);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (132, '1985-01-08', 'that is a beautiful flower with great colours ',72, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (144, '1985-01-08', 'this is extremely Good:) Congratulations!',72, 3);
UPDATE Album set coveringImage_id=72 where id = 3;
---------------------------------------------------------------------
-- ALBUM - Portrait"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait images', 3, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait pictures', 3, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (4, 'Portrait');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (73, '02[303x202].jpg', '02[303x202].jpg', 'Portrait - 02[303x202].jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 73);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (133, '1985-01-08', 'Beautiful colours. Nice close up. ',73, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (134, '1985-01-08', 'Such a lovely colour azaga!',73, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (145, '1985-01-08', 'Amazing shot..',73, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (146, '1985-01-08', 'whoah ! wonderful',73, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (147, '1985-01-08', 'fantastic shot !!!!!!',73, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (148, '1985-01-08', 'Bellissima macro!',73, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (74, '1033975999_7e058fcf1c_o.jpg', '1033975999_7e058fcf1c_o.jpg', 'Portrait - 1033975999_7e058fcf1c_o.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 74);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (135, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',74, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (149, '1985-01-08', 'that is a beautiful flower with great colours ',74, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (150, '1985-01-08', 'love every thing about this picture, really beautiful... :))',74, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (151, '1985-01-08', 'love every thing about this picture, really beautiful... :))',74, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (75, '1516027705_ddff0a70dd_o.jpg', '1516027705_ddff0a70dd_o.jpg', 'Portrait - 1516027705_ddff0a70dd_o.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 75);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (136, '1985-01-08', 'nice shot =) ',75, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (137, '1985-01-08', 'Beautiful colours. Nice close up. ',75, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (138, '1985-01-08', 'Bellissima macro!',75, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (139, '1985-01-08', 'Beautiful colours. Nice close up. ',75, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (152, '1985-01-08', 'Beautiful colours. Nice close up. ',75, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (153, '1985-01-08', 'that is a beautiful flower with great colours ',75, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (76, '1799039821_b6ee53167c_o.jpg', '1799039821_b6ee53167c_o.jpg', 'Portrait - 1799039821_b6ee53167c_o.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 76);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (140, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',76, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (141, '1985-01-08', 'Bellissima macro!',76, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (142, '1985-01-08', 'I Think this is Art!',76, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (154, '1985-01-08', 'this is extremely Good:) Congratulations!',76, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (155, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',76, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (77, '19654343_f445e1efa2_o.jpg', '19654343_f445e1efa2_o.jpg', 'Portrait - 19654343_f445e1efa2_o.jpg image', '2009-12-18', 4, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 77);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (143, '1985-01-08', 'Such a lovely colour azaga!',77, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (144, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',77, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (145, '1985-01-08', 'Beautiful colours. Nice close up. ',77, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (156, '1985-01-08', 'Wonderful.',77, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (157, '1985-01-08', 'Very *lovely*',77, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (78, '2187016030_e81b911b3e_o.jpg', '2187016030_e81b911b3e_o.jpg', 'Portrait - 2187016030_e81b911b3e_o.jpg image', '2009-12-18', 4, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 78);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (158, '1985-01-08', 'Perfecft!',78, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (159, '1985-01-08', 'I Think this is Art!',78, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (79, '2307649188_a6206c17a4_o.jpg', '2307649188_a6206c17a4_o.jpg', 'Portrait - 2307649188_a6206c17a4_o.jpg image', '2009-12-18', 4, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 79);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (146, '1985-01-08', 'whoah ! wonderful',79, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (147, '1985-01-08', 'nice shot =) ',79, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (148, '1985-01-08', 'this is extremely Good:) Congratulations!',79, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (149, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',79, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (80, '2879155528_1ebbaaf951_o.jpg', '2879155528_1ebbaaf951_o.jpg', 'Portrait - 2879155528_1ebbaaf951_o.jpg image', '2009-12-18', 4, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 80);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (150, '1985-01-08', 'Such a lovely colour azaga!',80, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (151, '1985-01-08', 'Such a lovely colour azaga!',80, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (152, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',80, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (153, '1985-01-08', 'that is a beautiful flower with great colours ',80, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (81, '2933904745_b323535d4a_o.jpg', '2933904745_b323535d4a_o.jpg', 'Portrait - 2933904745_b323535d4a_o.jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 81);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (154, '1985-01-08', 'this is extremely Good:) Congratulations!',81, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (155, '1985-01-08', 'nice shot =) ',81, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (156, '1985-01-08', 'Beautiful colours. Nice close up. ',81, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (157, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',81, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (160, '1985-01-08', 'Such a lovely colour azaga!',81, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (161, '1985-01-08', 'whoah ! wonderful',81, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (162, '1985-01-08', 'Perfecft!',81, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (163, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',81, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (82, '3-3.jpg', '3-3.jpg', 'Portrait - 3-3.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 82);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (158, '1985-01-08', 'that is a beautiful flower with great colours ',82, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (159, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',82, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (160, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',82, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (164, '1985-01-08', 'Bellísima.!!! saludos.',82, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (165, '1985-01-08', 'Stunning capture! :-)',82, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (166, '1985-01-08', 'whoah ! wonderful',82, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (83, '3176975826_ef29a459fa_o.jpg', '3176975826_ef29a459fa_o.jpg', 'Portrait - 3176975826_ef29a459fa_o.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 83);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (161, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',83, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (162, '1985-01-08', 'fantastic shot !!!!!!',83, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (163, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',83, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (164, '1985-01-08', 'fantastic shot !!!!!!',83, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (167, '1985-01-08', 'Amazing shot..',83, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (84, '323301225_3aef765e5a_o.jpg', '323301225_3aef765e5a_o.jpg', 'Portrait - 323301225_3aef765e5a_o.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 84);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (165, '1985-01-08', 'Wonderful.',84, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (166, '1985-01-08', 'love every thing about this picture, really beautiful... :))',84, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (167, '1985-01-08', 'fantastic shot !!!!!!',84, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (168, '1985-01-08', 'Gorgeous! Lovely color!',84, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (169, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',84, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (170, '1985-01-08', 'Such a lovely colour azaga!',84, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (85, 'img_0103.jpg', 'img_0103.jpg', 'Portrait - img_0103.jpg image', '2009-12-18', 4, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 85);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (86, '_mg_0161.jpg', '_mg_0161.jpg', 'Portrait - _mg_0161.jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 86);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (168, '1985-01-08', 'I Think this is Art!',86, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (171, '1985-01-08', 'Very *lovely*',86, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (172, '1985-01-08', 'Very *lovely*',86, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (173, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',86, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (174, '1985-01-08', 'Perfecft!',86, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (87, '_mg_0264.jpg', '_mg_0264.jpg', 'Portrait - _mg_0264.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 87);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (169, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',87, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (170, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',87, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (88, '_mg_0510.jpg', '_mg_0510.jpg', 'Portrait - _mg_0510.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 88);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (171, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',88, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (172, '1985-01-08', 'nice shot =) ',88, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (175, '1985-01-08', 'this is extremely Good:) Congratulations!',88, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (176, '1985-01-08', 'Bellissima macro!',88, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (177, '1985-01-08', 'that is a beautiful flower with great colours ',88, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (178, '1985-01-08', 'Stunning capture! :-)',88, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (89, '_mg_1788.jpg', '_mg_1788.jpg', 'Portrait - _mg_1788.jpg image', '2009-12-18', 4, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 89);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (173, '1985-01-08', 'Stunning capture! :-)',89, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (179, '1985-01-08', 'that is a beautiful flower with great colours ',89, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (180, '1985-01-08', 'that is a beautiful flower with great colours ',89, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (181, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',89, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (182, '1985-01-08', 'Wonderful.',89, 1);
UPDATE Album set coveringImage_id=89 where id = 4;
---------------------------------------------------------------------
-- ALBUM - Sport"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport images', 4, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (5, 'Sport');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (90, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 90);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (174, '1985-01-08', 'Beautiful colours. Nice close up. ',90, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (175, '1985-01-08', 'Wonderful.',90, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (176, '1985-01-08', 'fantastic shot !!!!!!',90, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (177, '1985-01-08', 'fantastic shot !!!!!!',90, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (183, '1985-01-08', 'love every thing about this picture, really beautiful... :))',90, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (184, '1985-01-08', 'fantastic shot !!!!!!',90, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (185, '1985-01-08', 'that is a beautiful flower with great colours ',90, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (186, '1985-01-08', 'Beautiful colours. Nice close up. ',90, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (91, '1350250361_2d963dd4e7_o.jpg', '1350250361_2d963dd4e7_o.jpg', 'Sport - 1350250361_2d963dd4e7_o.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 91);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (178, '1985-01-08', 'Such a lovely colour azaga!',91, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (92, '2042654579_d25c0db64f_o.jpg', '2042654579_d25c0db64f_o.jpg', 'Sport - 2042654579_d25c0db64f_o.jpg image', '2009-12-18', 5, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 92);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (179, '1985-01-08', 'Gorgeous! Lovely color!',92, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (187, '1985-01-08', 'Bellísima.!!! saludos.',92, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (188, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',92, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (189, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',92, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (190, '1985-01-08', 'whoah ! wonderful',92, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (93, '2158910844_e5a6deeeab_o.jpg', '2158910844_e5a6deeeab_o.jpg', 'Sport - 2158910844_e5a6deeeab_o.jpg image', '2009-12-18', 5, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 93);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (180, '1985-01-08', 'Wonderful.',93, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (181, '1985-01-08', 'Wonderful.',93, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (182, '1985-01-08', 'I Think this is Art!',93, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (191, '1985-01-08', 'that is a beautiful flower with great colours ',93, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (192, '1985-01-08', 'I Think this is Art!',93, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (193, '1985-01-08', 'nice shot =) ',93, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (194, '1985-01-08', 'love every thing about this picture, really beautiful... :))',93, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (94, '2228156682_74520fa2e5_o.jpg', '2228156682_74520fa2e5_o.jpg', 'Sport - 2228156682_74520fa2e5_o.jpg image', '2009-12-18', 5, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 94);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (183, '1985-01-08', 'whoah ! wonderful',94, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (184, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',94, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (185, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',94, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (195, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',94, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (196, '1985-01-08', 'Wonderful.',94, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (197, '1985-01-08', 'Bellissima macro!',94, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (198, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',94, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (95, '2264670815_82c5619ec6_o.jpg', '2264670815_82c5619ec6_o.jpg', 'Sport - 2264670815_82c5619ec6_o.jpg image', '2009-12-18', 5, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 95);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (186, '1985-01-08', 'fantastic shot !!!!!!',95, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (187, '1985-01-08', 'I Think this is Art!',95, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (199, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',95, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (200, '1985-01-08', 'I Think this is Art!',95, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (201, '1985-01-08', 'nice shot =) ',95, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (96, '2266019996_6b7fcb9d41_o.jpg', '2266019996_6b7fcb9d41_o.jpg', 'Sport - 2266019996_6b7fcb9d41_o.jpg image', '2009-12-18', 5, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 96);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (188, '1985-01-08', 'Beautiful colours. Nice close up. ',96, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (189, '1985-01-08', 'Bellísima.!!! saludos.',96, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (190, '1985-01-08', '++Beautiful',96, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (191, '1985-01-08', 'Wonderful.',96, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (202, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',96, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (203, '1985-01-08', 'Gorgeous! Lovely color!',96, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (204, '1985-01-08', '++Beautiful',96, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (205, '1985-01-08', 'Stunning capture! :-)',96, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (97, '2338319633_4feac41833_o.jpg', '2338319633_4feac41833_o.jpg', 'Sport - 2338319633_4feac41833_o.jpg image', '2009-12-18', 5, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 97);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (192, '1985-01-08', 'Amazing shot..',97, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (206, '1985-01-08', 'Wonderful.',97, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (207, '1985-01-08', 'Wonderful.',97, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (208, '1985-01-08', 'Stunning capture! :-)',97, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (98, '2541626690_d6c35f7122_o.jpg', '2541626690_d6c35f7122_o.jpg', 'Sport - 2541626690_d6c35f7122_o.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 98);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (209, '1985-01-08', 'that is a beautiful flower with great colours ',98, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (210, '1985-01-08', 'Wonderful.',98, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (211, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',98, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (212, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',98, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (99, '2760610141_8a56e469d0_o.jpg', '2760610141_8a56e469d0_o.jpg', 'Sport - 2760610141_8a56e469d0_o.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 99);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (213, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',99, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (214, '1985-01-08', 'this is extremely Good:) Congratulations!',99, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (100, '2767537621_e378165405_o.jpg', '2767537621_e378165405_o.jpg', 'Sport - 2767537621_e378165405_o.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 100);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (101, '2813129574_018acd119d_o.jpg', '2813129574_018acd119d_o.jpg', 'Sport - 2813129574_018acd119d_o.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 101);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (215, '1985-01-08', '++Beautiful',101, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (216, '1985-01-08', 'Perfecft!',101, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (102, '2832747707_fb68c8147f_o.jpg', '2832747707_fb68c8147f_o.jpg', 'Sport - 2832747707_fb68c8147f_o.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 102);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (193, '1985-01-08', 'I Think this is Art!',102, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (194, '1985-01-08', 'nice shot =) ',102, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (195, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',102, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (217, '1985-01-08', 'love every thing about this picture, really beautiful... :))',102, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (103, '3037432738_e4b2388861_o.jpg', '3037432738_e4b2388861_o.jpg', 'Sport - 3037432738_e4b2388861_o.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 103);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (196, '1985-01-08', 'Perfecft!',103, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (218, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',103, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (219, '1985-01-08', 'whoah ! wonderful',103, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (220, '1985-01-08', 'whoah ! wonderful',103, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (221, '1985-01-08', 'Such a lovely colour azaga!',103, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (104, '413103429_50ff9d8ae3_o.jpg', '413103429_50ff9d8ae3_o.jpg', 'Sport - 413103429_50ff9d8ae3_o.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 104);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (197, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',104, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (198, '1985-01-08', 'Amazing shot..',104, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (199, '1985-01-08', 'Bellísima.!!! saludos.',104, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (222, '1985-01-08', 'Gorgeous! Lovely color!',104, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (223, '1985-01-08', 'love every thing about this picture, really beautiful... :))',104, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (224, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',104, 1);
UPDATE Album set coveringImage_id=104 where id = 5;
---------------------------------------------------------------------
-- ALBUM - Water"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water images', 1, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 1, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (6, 'Water');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (105, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 105);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (200, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',105, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (106, '1323769314_fe850cd954_o.jpg', '1323769314_fe850cd954_o.jpg', 'Water - 1323769314_fe850cd954_o.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 106);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (201, '1985-01-08', 'this is extremely Good:) Congratulations!',106, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (202, '1985-01-08', 'nice shot =) ',106, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (203, '1985-01-08', 'Very *lovely*',106, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (225, '1985-01-08', 'Such a lovely colour azaga!',106, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (226, '1985-01-08', 'Wonderful.',106, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (107, '205579493_baf0f850d1_o.jpg', '205579493_baf0f850d1_o.jpg', 'Water - 205579493_baf0f850d1_o.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 107);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (204, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',107, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (227, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',107, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (228, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',107, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (229, '1985-01-08', 'whoah ! wonderful',107, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (108, '2198502835_1644c8fde2_o.jpg', '2198502835_1644c8fde2_o.jpg', 'Water - 2198502835_1644c8fde2_o.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 108);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (205, '1985-01-08', 'Wonderful.',108, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (230, '1985-01-08', 'Bellísima.!!! saludos.',108, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (231, '1985-01-08', 'this is extremely Good:) Congratulations!',108, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (232, '1985-01-08', 'Stunning capture! :-)',108, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (233, '1985-01-08', 'Bellissima macro!',108, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (109, '2242254221_f2af58e243_o.jpg', '2242254221_f2af58e243_o.jpg', 'Water - 2242254221_f2af58e243_o.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 109);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (206, '1985-01-08', 'Bellissima macro!',109, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (207, '1985-01-08', 'Very *lovely*',109, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (208, '1985-01-08', 'Bellísima.!!! saludos.',109, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (234, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',109, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (235, '1985-01-08', 'Perfecft!',109, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (236, '1985-01-08', 'Beautiful colours. Nice close up. ',109, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (110, '3170219697_4d259ff802_o.jpg', '3170219697_4d259ff802_o.jpg', 'Water - 3170219697_4d259ff802_o.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 110);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (209, '1985-01-08', 'Stunning capture! :-)',110, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (237, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',110, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (238, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',110, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (111, '3200123361_cfd16bb12a_o.jpg', '3200123361_cfd16bb12a_o.jpg', 'Water - 3200123361_cfd16bb12a_o.jpg image', '2009-12-18', 6, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 111);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (210, '1985-01-08', 'that is a beautiful flower with great colours ',111, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (211, '1985-01-08', 'Gorgeous! Lovely color!',111, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (239, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',111, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (240, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',111, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (112, '3253676430_b14ae3f5c9_o.jpg', '3253676430_b14ae3f5c9_o.jpg', 'Water - 3253676430_b14ae3f5c9_o.jpg image', '2009-12-18', 6, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 112);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (212, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',112, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (213, '1985-01-08', 'Beautiful colours. Nice close up. ',112, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (214, '1985-01-08', 'Perfecft!',112, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (215, '1985-01-08', 'Amazing shot..',112, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (113, '336589255_6a8ba0ebb6_o.jpg', '336589255_6a8ba0ebb6_o.jpg', 'Water - 336589255_6a8ba0ebb6_o.jpg image', '2009-12-18', 6, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 113);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (216, '1985-01-08', 'nice shot =) ',113, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (217, '1985-01-08', 'that is a beautiful flower with great colours ',113, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (218, '1985-01-08', 'Amazing shot..',113, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (241, '1985-01-08', 'Amazing shot..',113, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (242, '1985-01-08', 'Gorgeous! Lovely color!',113, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (243, '1985-01-08', 'Wonderful.',113, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (244, '1985-01-08', 'Stunning capture! :-)',113, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (114, '3411135019_0cc403fcb8_o.jpg', '3411135019_0cc403fcb8_o.jpg', 'Water - 3411135019_0cc403fcb8_o.jpg image', '2009-12-18', 6, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 114);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (219, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',114, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (115, '3416553183_2564d26ef1_b.jpg', '3416553183_2564d26ef1_b.jpg', 'Water - 3416553183_2564d26ef1_b.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 115);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (245, '1985-01-08', 'Bellissima macro!',115, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (246, '1985-01-08', 'Perfecft!',115, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (247, '1985-01-08', 'Bellissima macro!',115, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (116, '381634787_f52e84a5af_o.jpg', '381634787_f52e84a5af_o.jpg', 'Water - 381634787_f52e84a5af_o.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 116);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (220, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',116, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (221, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',116, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (222, '1985-01-08', 'Very *lovely*',116, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (248, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',116, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (249, '1985-01-08', 'Amazing shot..',116, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (250, '1985-01-08', 'Amazing shot..',116, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (117, '396318116_a47c4a8392_o.jpg', '396318116_a47c4a8392_o.jpg', 'Water - 396318116_a47c4a8392_o.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 117);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (251, '1985-01-08', 'Bellísima.!!! saludos.',117, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (252, '1985-01-08', 'Perfecft!',117, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (118, '412426470_47be44c1f1_o.jpg', '412426470_47be44c1f1_o.jpg', 'Water - 412426470_47be44c1f1_o.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 118);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (223, '1985-01-08', 'Such a lovely colour azaga!',118, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (224, '1985-01-08', 'Such a lovely colour azaga!',118, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (225, '1985-01-08', 'whoah ! wonderful',118, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (253, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',118, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (254, '1985-01-08', 'Very *lovely*',118, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (119, '7530427_08dcad5953_o.jpg', '7530427_08dcad5953_o.jpg', 'Water - 7530427_08dcad5953_o.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 119);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (226, '1985-01-08', 'nice shot =) ',119, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (227, '1985-01-08', 'I Think this is Art!',119, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (228, '1985-01-08', 'Such a lovely colour azaga!',119, 2);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (120, '767963055_bd02f406d6_o.jpg', '767963055_bd02f406d6_o.jpg', 'Water - 767963055_bd02f406d6_o.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 120);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (255, '1985-01-08', 'Perfecft!',120, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (256, '1985-01-08', 'Gorgeous! Lovely color!',120, 1);
UPDATE Album set coveringImage_id=120 where id = 6;
Modified: trunk/examples/photoalbum/source/ejb/sql/short/import.sql
===================================================================
--- trunk/examples/photoalbum/source/ejb/sql/short/import.sql 2009-05-06 15:48:08 UTC (rev 14038)
+++ trunk/examples/photoalbum/source/ejb/sql/short/import.sql 2009-05-06 17:34:23 UTC (rev 14039)
@@ -2,169 +2,191 @@
INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (2, 'Nick', 'Curtis', 'nkurtis(a)iba.com', 'Viking', '8cb2237d0679ca88db6464eac60da96345513964', '1978-01-08', 1, 0, true);
INSERT INTO User(id, firstname, secondname, email, login, passwordHash, birthdate, sex, hasAvatar, preDefined) VALUES (3, 'John', 'Smith', 'jsmith(a)jboss.com', 'Noname', '8cb2237d0679ca88db6464eac60da96345513964', '1970-01-08', 1, 0, true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature images', 1, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature images', 1, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature images', 2, '2009-12-18', true);
-INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature images', 3, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (1, 'Nature', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (2, 'Sport', 'Nature pictures', 1, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (3, 'Water', 'Nature pictures', 2, '2009-12-18', true);
+INSERT INTO Shelf(id, name, description, owner_id, created, shared) VALUES (4, 'Flowers', 'Nature pictures', 3, '2009-12-18', true);
---------------------------------------------------------------------
-- ALBUM - Animals"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals images', 1, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (0, 'Animals', 'Animals pictures', 1, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (0, 'Animals');
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (0, '1750979205_6e51b47ce9_o.jpg', '1750979205_6e51b47ce9_o.jpg', 'Animals - 1750979205_6e51b47ce9_o.jpg image', '2009-12-18', 0, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 0);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (1, '1906662004_655d0f6ccf_o.jpg', '1906662004_655d0f6ccf_o.jpg', 'Animals - 1906662004_655d0f6ccf_o.jpg image', '2009-12-18', 0, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (0, '1985-01-08', 'Gorgeous! Lovely color!',1, 3);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (2, '2090459727_f2888e5cbe_o.jpg', '2090459727_f2888e5cbe_o.jpg', 'Animals - 2090459727_f2888e5cbe_o.jpg image', '2009-12-18', 0, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (1, '1985-01-08', 'Amazing shot..',2, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (2, '1985-01-08', 'Wonderful.',2, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (3, '1985-01-08', 'that is a beautiful flower with great colours ',2, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (4, '1985-01-08', 'Beautiful colours. Nice close up. ',2, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (0, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',2, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (1, '1985-01-08', 'Gorgeous! Lovely color!',2, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (2, '1985-01-08', 'Gorgeous! Lovely color!',2, 1);
INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (3, '2297752925_de29b5fb10_o.jpg', '2297752925_de29b5fb10_o.jpg', 'Animals - 2297752925_de29b5fb10_o.jpg image', '2009-12-18', 0, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (5, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',3, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (6, '1985-01-08', '++Beautiful',3, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (7, '1985-01-08', 'Gorgeous! Lovely color!',3, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (8, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',3, 1);
-UPDATE Album set coveringImage_id=3 where id = 0;
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (3, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',3, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (4, '1985-01-08', 'whoah ! wonderful',3, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (5, '1985-01-08', 'Such a lovely colour azaga!',3, 3);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '2298556444_2151b7a6c4_o.jpg', '2298556444_2151b7a6c4_o.jpg', 'Animals - 2298556444_2151b7a6c4_o.jpg image', '2009-12-18', 0, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 4);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (6, '1985-01-08', 'Beautiful colours. Nice close up. ',4, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (7, '1985-01-08', 'Amazing shot..',4, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (8, '1985-01-08', '++Beautiful',4, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (9, '1985-01-08', 'Beautiful colours. Nice close up. ',4, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (5, '2508246015_313952406c_o.jpg', '2508246015_313952406c_o.jpg', 'Animals - 2508246015_313952406c_o.jpg image', '2009-12-18', 0, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(0, 5);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (10, '1985-01-08', 'Perfecft!',5, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (11, '1985-01-08', 'whoah ! wonderful',5, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (12, '1985-01-08', 'Gorgeous! Lovely color!',5, 3);
+UPDATE Album set coveringImage_id=5 where id = 0;
---------------------------------------------------------------------
-- ALBUM - Cars"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars images', 3, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (1, 'Cars', 'Cars pictures', 2, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (1, 'Cars');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (4, '190193308_ce2a4de5fa_o.jpg', '190193308_ce2a4de5fa_o.jpg', 'Cars - 190193308_ce2a4de5fa_o.jpg image', '2009-12-18', 1, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 4);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (5, '1941230817_bcce17b8ef_o.jpg', '1941230817_bcce17b8ef_o.jpg', 'Cars - 1941230817_bcce17b8ef_o.jpg image', '2009-12-18', 1, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 5);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (9, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',5, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (10, '1985-01-08', 'nice shot =) ',5, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (11, '1985-01-08', 'nice shot =) ',5, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (12, '1985-01-08', 'Such a lovely colour azaga!',5, 3);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (6, '2151423750_129317a034_o.jpg', '2151423750_129317a034_o.jpg', 'Cars - 2151423750_129317a034_o.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (6, '190193308_ce2a4de5fa_o.jpg', '190193308_ce2a4de5fa_o.jpg', 'Cars - 190193308_ce2a4de5fa_o.jpg image', '2009-12-18', 1, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 6);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (13, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',6, 1);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (7, '2233985073_9a3fd7d3ac_b.jpg', '2233985073_9a3fd7d3ac_b.jpg', 'Cars - 2233985073_9a3fd7d3ac_b.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (7, '1941230817_bcce17b8ef_o.jpg', '1941230817_bcce17b8ef_o.jpg', 'Cars - 1941230817_bcce17b8ef_o.jpg image', '2009-12-18', 1, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 7);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (14, '1985-01-08', 'Gorgeous! Lovely color!',7, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (15, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',7, 2);
-UPDATE Album set coveringImage_id=7 where id = 1;
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (13, '1985-01-08', 'love every thing about this picture, really beautiful... :))',7, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (14, '1985-01-08', 'Very *lovely*',7, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (15, '1985-01-08', 'Very *lovely*',7, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (16, '1985-01-08', 'Gorgeous! Lovely color!',7, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '2151423750_129317a034_o.jpg', '2151423750_129317a034_o.jpg', 'Cars - 2151423750_129317a034_o.jpg image', '2009-12-18', 1, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 8);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (17, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',8, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (9, '2233985073_9a3fd7d3ac_b.jpg', '2233985073_9a3fd7d3ac_b.jpg', 'Cars - 2233985073_9a3fd7d3ac_b.jpg image', '2009-12-18', 1, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 9);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (18, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',9, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (19, '1985-01-08', 'Bellissima macro!',9, 1);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (10, '2386071696_2b4e84eddb_o.jpg', '2386071696_2b4e84eddb_o.jpg', 'Cars - 2386071696_2b4e84eddb_o.jpg image', '2009-12-18', 1, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 10);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (20, '1985-01-08', 'Such a lovely colour azaga!',10, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (11, '3089719367_a03a2b55a4_b.jpg', '3089719367_a03a2b55a4_b.jpg', 'Cars - 3089719367_a03a2b55a4_b.jpg image', '2009-12-18', 1, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(1, 11);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (21, '1985-01-08', 'Very *lovely*',11, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (22, '1985-01-08', 'whoah ! wonderful',11, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (23, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',11, 2);
+UPDATE Album set coveringImage_id=11 where id = 1;
---------------------------------------------------------------------
-- ALBUM - Monuments and just buildings"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings images', 4, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (2, 'Monuments and just buildings', 'Monuments and just buildings pictures', 4, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (2, 'Monuments and just buildings');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (8, '05[303x457].jpg', '05[303x457].jpg', 'Monuments and just buildings - 05[303x457].jpg image', '2009-12-18', 2, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 8);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (9, '07[303x457].jpg', '07[303x457].jpg', 'Monuments and just buildings - 07[303x457].jpg image', '2009-12-18', 2, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 9);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (10, '1805365000_ca64d20b10_o.jpg', '1805365000_ca64d20b10_o.jpg', 'Monuments and just buildings - 1805365000_ca64d20b10_o.jpg image', '2009-12-18', 2, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 10);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (16, '1985-01-08', 'Bellísima.!!! saludos.',10, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (17, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',10, 1);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (11, '1[303x457].jpg', '1[303x457].jpg', 'Monuments and just buildings - 1[303x457].jpg image', '2009-12-18', 2, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 11);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (18, '1985-01-08', '++Beautiful',11, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (19, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',11, 2);
-UPDATE Album set coveringImage_id=11 where id = 2;
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (12, '05[303x457].jpg', '05[303x457].jpg', 'Monuments and just buildings - 05[303x457].jpg image', '2009-12-18', 2, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 12);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (24, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',12, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (25, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',12, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (26, '1985-01-08', 'that is a beautiful flower with great colours ',12, 1);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (13, '07[303x457].jpg', '07[303x457].jpg', 'Monuments and just buildings - 07[303x457].jpg image', '2009-12-18', 2, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 13);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (27, '1985-01-08', 'Wonderful.',13, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (28, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',13, 3);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (14, '1805365000_ca64d20b10_o.jpg', '1805365000_ca64d20b10_o.jpg', 'Monuments and just buildings - 1805365000_ca64d20b10_o.jpg image', '2009-12-18', 2, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(2, 14);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (29, '1985-01-08', 'Stunning capture! :-)',14, 1);
+UPDATE Album set coveringImage_id=14 where id = 2;
---------------------------------------------------------------------
-- ALBUM - Nature"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature images', 2, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (3, 'Nature', 'Nature pictures', 2, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (3, 'Nature');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (12, '01[303x202].jpg', '01[303x202].jpg', 'Nature - 01[303x202].jpg image', '2009-12-18', 3, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 12);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (13, '1[305x457].jpg', '1[305x457].jpg', 'Nature - 1[305x457].jpg image', '2009-12-18', 3, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 13);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (20, '1985-01-08', 'Amazing shot..',13, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (21, '1985-01-08', 'Very *lovely*',13, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (22, '1985-01-08', 'Amazing shot..',13, 2);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (14, '273927725_c9f5ef5952_o.jpg', '273927725_c9f5ef5952_o.jpg', 'Nature - 273927725_c9f5ef5952_o.jpg image', '2009-12-18', 3, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 14);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (23, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',14, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (24, '1985-01-08', 'Beautiful colours. Nice close up. ',14, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (25, '1985-01-08', 'Bellissima macro!',14, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (26, '1985-01-08', 'Perfecft!',14, 1);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '2[303x457].jpg', '2[303x457].jpg', 'Nature - 2[303x457].jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (15, '01[303x202].jpg', '01[303x202].jpg', 'Nature - 01[303x202].jpg image', '2009-12-18', 3, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 15);
-UPDATE Album set coveringImage_id=15 where id = 3;
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '1[305x457].jpg', '1[305x457].jpg', 'Nature - 1[305x457].jpg image', '2009-12-18', 3, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 16);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (30, '1985-01-08', 'Bellísima.!!! saludos.',16, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (31, '1985-01-08', 'Amazing shot..',16, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (32, '1985-01-08', 'Gorgeous! Lovely color!',16, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (33, '1985-01-08', 'Very *lovely*',16, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (17, '273927725_c9f5ef5952_o.jpg', '273927725_c9f5ef5952_o.jpg', 'Nature - 273927725_c9f5ef5952_o.jpg image', '2009-12-18', 3, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 17);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (34, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',17, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (35, '1985-01-08', 'Bellísima.!!! saludos.',17, 3);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (18, '2[303x457].jpg', '2[303x457].jpg', 'Nature - 2[303x457].jpg image', '2009-12-18', 3, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 18);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (36, '1985-01-08', 'this is extremely Good:) Congratulations!',18, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (37, '1985-01-08', 'whoah ! wonderful',18, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (19, '3392730627_1cdb18cba6_o.jpg', '3392730627_1cdb18cba6_o.jpg', 'Nature - 3392730627_1cdb18cba6_o.jpg image', '2009-12-18', 3, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 19);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (20, '3392993334_36d7f097df_o.jpg', '3392993334_36d7f097df_o.jpg', 'Nature - 3392993334_36d7f097df_o.jpg image', '2009-12-18', 3, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(3, 20);
+UPDATE Album set coveringImage_id=20 where id = 3;
---------------------------------------------------------------------
-- ALBUM - Portrait"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait images', 3, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (4, 'Portrait', 'Portrait pictures', 3, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (4, 'Portrait');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (16, '02[303x202].jpg', '02[303x202].jpg', 'Portrait - 02[303x202].jpg image', '2009-12-18', 4, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 16);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (17, '1033975999_7e058fcf1c_o.jpg', '1033975999_7e058fcf1c_o.jpg', 'Portrait - 1033975999_7e058fcf1c_o.jpg image', '2009-12-18', 4, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 17);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (27, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',17, 1);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (18, '1516027705_ddff0a70dd_o.jpg', '1516027705_ddff0a70dd_o.jpg', 'Portrait - 1516027705_ddff0a70dd_o.jpg image', '2009-12-18', 4, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 18);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (28, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',18, 3);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (19, '1799039821_b6ee53167c_o.jpg', '1799039821_b6ee53167c_o.jpg', 'Portrait - 1799039821_b6ee53167c_o.jpg image', '2009-12-18', 4, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 19);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (29, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',19, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (30, '1985-01-08', 'this is extremely Good:) Congratulations!',19, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (31, '1985-01-08', 'Amazing shot..',19, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (32, '1985-01-08', 'this is extremely Good:) Congratulations!',19, 1);
-UPDATE Album set coveringImage_id=19 where id = 4;
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (21, '02[303x202].jpg', '02[303x202].jpg', 'Portrait - 02[303x202].jpg image', '2009-12-18', 4, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 21);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (38, '1985-01-08', 'Bellissima macro!',21, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (39, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',21, 1);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (40, '1985-01-08', 'I Think this is Art!',21, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (41, '1985-01-08', 'this is extremely Good:) Congratulations!',21, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (22, '1033975999_7e058fcf1c_o.jpg', '1033975999_7e058fcf1c_o.jpg', 'Portrait - 1033975999_7e058fcf1c_o.jpg image', '2009-12-18', 4, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 22);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (23, '1516027705_ddff0a70dd_o.jpg', '1516027705_ddff0a70dd_o.jpg', 'Portrait - 1516027705_ddff0a70dd_o.jpg image', '2009-12-18', 4, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(4, 23);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (42, '1985-01-08', 'Superb Shot and so beautiful Colors !!! ',23, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (43, '1985-01-08', 'Wow!! Macro stupenda!!! Complimenti! ',23, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (44, '1985-01-08', 'Beautiful ^Flower^...great Macro....Excellent !!!',23, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (45, '1985-01-08', 'Amazing shot..',23, 1);
+UPDATE Album set coveringImage_id=23 where id = 4;
---------------------------------------------------------------------
-- ALBUM - Sport"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport images', 4, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (5, 'Sport', 'Sport pictures', 4, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (5, 'Sport');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (20, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'Olympus Stylus mju 1040', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 20);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (33, '1985-01-08', 'Such a lovely colour azaga!',20, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (34, '1985-01-08', 'Beautiful colours. Nice close up. ',20, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (35, '1985-01-08', 'Beautiful colours. Nice close up. ',20, 1);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (21, '1350250361_2d963dd4e7_o.jpg', '1350250361_2d963dd4e7_o.jpg', 'Sport - 1350250361_2d963dd4e7_o.jpg image', '2009-12-18', 5, 'BBK DP810', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 21);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (22, '2042654579_d25c0db64f_o.jpg', '2042654579_d25c0db64f_o.jpg', 'Sport - 2042654579_d25c0db64f_o.jpg image', '2009-12-18', 5, 'BenQ DC E800', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 22);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (23, '2158910844_e5a6deeeab_o.jpg', '2158910844_e5a6deeeab_o.jpg', 'Sport - 2158910844_e5a6deeeab_o.jpg image', '2009-12-18', 5, 'Konica Minolta', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 23);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (36, '1985-01-08', 'Perfecft!',23, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (37, '1985-01-08', 'fantastic shot !!!!!!',23, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (38, '1985-01-08', 'fantastic shot !!!!!!',23, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (39, '1985-01-08', '++Beautiful',23, 2);
-UPDATE Album set coveringImage_id=23 where id = 5;
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '103193233_860c47c909_o.jpg', '103193233_860c47c909_o.jpg', 'Sport - 103193233_860c47c909_o.jpg image', '2009-12-18', 5, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 24);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (46, '1985-01-08', 'Bellissima macro!',24, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (25, '1350250361_2d963dd4e7_o.jpg', '1350250361_2d963dd4e7_o.jpg', 'Sport - 1350250361_2d963dd4e7_o.jpg image', '2009-12-18', 5, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 25);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (47, '1985-01-08', 'Perfecft!',25, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (48, '1985-01-08', 'Stunning capture! :-)',25, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (49, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',25, 2);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (26, '2042654579_d25c0db64f_o.jpg', '2042654579_d25c0db64f_o.jpg', 'Sport - 2042654579_d25c0db64f_o.jpg image', '2009-12-18', 5, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(5, 26);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (50, '1985-01-08', 'Beautiful colours. Nice close up. ',26, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (51, '1985-01-08', 'Perfecft!',26, 2);
+UPDATE Album set coveringImage_id=26 where id = 5;
---------------------------------------------------------------------
-- ALBUM - Water"
---------------------------------------------------------------------
-INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water images', 1, '2009-12-18');
+INSERT INTO Album(id, name, description, shelf_id, created) VALUES (6, 'Water', 'Water pictures', 1, '2009-12-18');
INSERT INTO MetaTag(id, tag) VALUES (6, 'Water');
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (24, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Panasonic', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 24);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (40, '1985-01-08', 'this is extremely Good:) Congratulations!',24, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (41, '1985-01-08', 'really pretty. it looks like there is a lady in the _center_, blowing kisses!!',24, 3);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (25, '1323769314_fe850cd954_o.jpg', '1323769314_fe850cd954_o.jpg', 'Water - 1323769314_fe850cd954_o.jpg image', '2009-12-18', 6, 'LG LDC-A310', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 25);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (42, '1985-01-08', 'Such a lovely colour azaga!',25, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (43, '1985-01-08', 'that is a beautiful flower with great colours ',25, 3);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (44, '1985-01-08', '++Beautiful',25, 2);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (26, '205579493_baf0f850d1_o.jpg', '205579493_baf0f850d1_o.jpg', 'Water - 205579493_baf0f850d1_o.jpg image', '2009-12-18', 6, 'Canon EOS 450D', 1024, 1917, 768, '2009-12-01', true, true);
- INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 26);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (45, '1985-01-08', 'fantastic shot !!!!!!',26, 2);
-INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, '2198502835_1644c8fde2_o.jpg', '2198502835_1644c8fde2_o.jpg', 'Water - 2198502835_1644c8fde2_o.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (27, '117215467_5cccef9aaa_b.jpg', '117215467_5cccef9aaa_b.jpg', 'Water - 117215467_5cccef9aaa_b.jpg image', '2009-12-18', 6, 'Sony CyberShot DSC-T77', 1024, 1917, 768, '2009-12-01', true, true);
INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 27);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (46, '1985-01-08', 'Amazing shot..',27, 2);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (47, '1985-01-08', 'fantastic shot !!!!!!',27, 1);
- INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (48, '1985-01-08', '++Beautiful',27, 2);
-UPDATE Album set coveringImage_id=27 where id = 6;
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (52, '1985-01-08', '|Wonderful| coloured flower .... *excellent* macro .... -nice- details!!!',27, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (53, '1985-01-08', 'love every thing about this picture, really beautiful... :))',27, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (54, '1985-01-08', 'Perfecft!',27, 3);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (55, '1985-01-08', 'Beautiful colours. Nice close up. ',27, 1);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (28, '1323769314_fe850cd954_o.jpg', '1323769314_fe850cd954_o.jpg', 'Water - 1323769314_fe850cd954_o.jpg image', '2009-12-18', 6, 'Canon PowerShot SX110 IS', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 28);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (56, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',28, 1);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (29, '205579493_baf0f850d1_o.jpg', '205579493_baf0f850d1_o.jpg', 'Water - 205579493_baf0f850d1_o.jpg image', '2009-12-18', 6, 'Nikon D60', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 29);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (30, '2198502835_1644c8fde2_o.jpg', '2198502835_1644c8fde2_o.jpg', 'Water - 2198502835_1644c8fde2_o.jpg image', '2009-12-18', 6, 'Sony Alpha DSLR-A350', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 30);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (57, '1985-01-08', 'Perfecft!',30, 1);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (31, '2242254221_f2af58e243_o.jpg', '2242254221_f2af58e243_o.jpg', 'Water - 2242254221_f2af58e243_o.jpg image', '2009-12-18', 6, 'Canon Digital IXUS 80 IS (PowerShot SD1100 IS)', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 31);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (58, '1985-01-08', 'fantastic shot !!!!!!',31, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (59, '1985-01-08', 'Bellissima macro!',31, 3);
+INSERT INTO Image(id, name, path, description, created, album_id, cameraModel, width, size, height, uploaded, allowComments, showMetaInfo) VALUES (32, '3170219697_4d259ff802_o.jpg', '3170219697_4d259ff802_o.jpg', 'Water - 3170219697_4d259ff802_o.jpg image', '2009-12-18', 6, 'Pentax Optio E40', 1024, 1917, 768, '2009-12-01', true, true);
+ INSERT INTO Image_MetaTag(IMAGETAGS_ID, IMAGES_ID) VALUES(6, 32);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (60, '1985-01-08', 'I Think this is Art!',32, 2);
+ INSERT INTO Comment(id, date, message, image_id, author_id) VALUES (61, '1985-01-08', 'Fantastic job. Great light and color! Great shot!',32, 2);
+UPDATE Album set coveringImage_id=32 where id = 6;
-
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/05[303x457]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/07[303x457]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1805365000_ca64d20b10_o_small80.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457].jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_medium.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small120.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small160.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small200.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/2/1[303x457]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/103193233_860c47c909_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/1350250361_2d963dd4e7_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2042654579_d25c0db64f_o_small80.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_medium.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small120.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small160.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small200.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Noname/4/5/2158910844_e5a6deeeab_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/02[303x202]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1033975999_7e058fcf1c_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1516027705_ddff0a70dd_o_small80.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_medium.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small120.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small160.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small200.jpg
===================================================================
(Binary files differ)
Deleted: trunk/examples/photoalbum/source/web/Upload/short/Viking/3/4/1799039821_b6ee53167c_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1750979205_6e51b47ce9_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/1906662004_655d0f6ccf_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2090459727_f2888e5cbe_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/0/2297752925_de29b5fb10_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/117215467_5cccef9aaa_b_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/1323769314_fe850cd954_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/205579493_baf0f850d1_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/1/6/2198502835_1644c8fde2_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/01[303x202]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/1[305x457]_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/273927725_c9f5ef5952_o_small80.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_medium.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small120.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small160.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small200.jpg
===================================================================
(Binary files differ)
Modified: trunk/examples/photoalbum/source/web/Upload/short/amarkhel/2/3/2[303x457]_small80.jpg
===================================================================
(Binary files differ)
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14038 - in branches/examples-data/photoapp/images: amarkhel/2 and 1 other directory.
by richfaces-svn-commits＠lists.jboss.org
Author: Alex.Kolonitsky
Date: 2009-05-06 11:48:08 -0400 (Wed, 06 May 2009)
New Revision: 14038
Added:
branches/examples-data/photoapp/images/amarkhel/2/1/
Removed:
branches/examples-data/photoapp/images/Viking/3/1/
Log:
move album to amarkhel
Copied: branches/examples-data/photoapp/images/amarkhel/2/1 (from rev 14037, branches/examples-data/photoapp/images/Viking/3/1)
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14037 - trunk/docs/realworld_app_guide/en/src/main/docbook/includes.
by richfaces-svn-commits＠lists.jboss.org
Author: msorokin
Date: 2009-05-06 10:46:51 -0400 (Wed, 06 May 2009)
New Revision: 14037
Added:
trunk/docs/realworld_app_guide/en/src/main/docbook/includes/validators.xml
Log:
added VUser Input Data Validation chapter
https://jira.jboss.org/jira/browse/RF-5768
Added: trunk/docs/realworld_app_guide/en/src/main/docbook/includes/validators.xml
===================================================================
--- trunk/docs/realworld_app_guide/en/src/main/docbook/includes/validators.xml (rev 0)
+++ trunk/docs/realworld_app_guide/en/src/main/docbook/includes/validators.xml 2009-05-06 14:46:51 UTC (rev 14037)
@@ -0,0 +1,69 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<section id="Validators">
+ <title>User Input Data Validation</title>
+ <para>
+ Validation of user input is a very frequent situation for a developer. RichFaces library offers 3 component to get this job done:
+ <emphasis role="bold"><property><rich:beanValidator/></property></emphasis>, <emphasis role="bold"><property><rich:graphValidator/></property></emphasis>,
+
+ and <emphasis role="bold"><property><rich:ajaxValidator/></property></emphasis>. The latter two components are used in the Photo Album application. <emphasis role="bold"><property><rich:graphValidator/></property></emphasis> is intended to validate the whole object or the graph of interrelated objects and the validation occurs when the whole form is submitted. While <emphasis role="bold"><property><rich:ajaxValidator/></property></emphasis> validates only one input field or a value at a time, validation is activated upon some event and adds interactivity to the application.
+ Both components use Hibernate validators which helps to locate validation logic in one place, such approach is really helpful given that usually data validation logic is stored in multiple places including UI pages and in Java code that interacts with a database.
+ </para>
+ <para>
+
+ Let's have a look at the components usage on the registration page. This is how the page looks like (some irrelevant details were removed from the example):
+
+ </para>
+ <programlisting role="XML"><![CDATA[...
+<ui:composition xmlns="http://www.w3.org/1999/xhtml" ...
+
+ <rich:graphValidator>
+ ...
+ <h:inputText id="loginName" value="#{user.login}" />
+ <rich:messages for="loginName" />
+ <h:inputSecret required="true" id="password" value="#{user.password}" />
+ <rich:messages for="password" />
+ <h:inputSecret required="true" id="confirmPassword"
+ value="#{user.confirmPassword}" />
+ <rich:messages for="confirmPassword" />
+ <h:inputText id="firstname" value="#{user.firstName}" />
+ <rich:messages for="firstname" style="color:red;" />
+ <h:inputText id="secondname" value="#{user.secondName}" />
+ <rich:messages for="secondname" />
+ <h:selectOneRadio required="true" id="sex" value="#{user.sex}">
+ <f:selectItems value="#{userPrefsBean.sexs}" />
+ <s:convertEnum />
+ </h:selectOneRadio>
+ <rich:messages for="sex" />
+ <a4j:outputPanel id="calendar" layout="block">
+ <rich:calendar id="birthDate" value="#{user.birthDate}"
+
+ <rich:ajaxValidator event="oninputblur" />
+ </rich:calendar>
+ </a4j:outputPanel>
+ <rich:messages for="birthDate" />
+ <h:inputText id="email" value="#{user.email}" />
+ <rich:messages for="email" />
+ </rich:graphValidator>
+ <richx:commandButton actionListener="#{authenticator.register(user)}"
+ value="Register" />
+ <richx:commandButton actionListener="#{controller.cancelRegistration()}"
+ immediate="true" value="Cancel" />
+</ui:composition>
+
+...]]></programlisting>
+
+ <para>
+
+ <emphasis role="bold"><property><rich:graphValidator/></property></emphasis> validates the entity User object, in which restrictions are set with the help of Hibernate annotations.
+ When the <emphasis role="bold" >Register</emphasis> button is clicked on the <property>name, password, sex</property> etc. fields are validated sequentially. In case of an error (for example, if a <property>loginName</property> contains only on character and the annotation restricts it to at least 3 characters to be typed in) a error message in red color is displayed next to the input field and the request is aborted. If all values are valid the <code>authenticator.register(user)</code> method will be invoked and the user will be saved to the database.
+
+ </para>
+ <para>
+ <emphasis role="bold"><property><rich:ajaxValidator/></property></emphasis> acts in a slightly different way, in our case it is attached to the <code>user.birthDate</code> field. When the value of the field is changed and the field loses focus it is immediately validated. If the input data is incorrect and error message will displayed, which is a quick way to respond to user input errors and avoid sending incorrect data to the server.
+
+ </para>
+ <para>
+ If you would like to get more details about the validators that RichFaces library provides please visit <link url="http://livedemo.exadel.com/richfaces-demo/richfaces/ajaxValidator.jsf">Live Demo</link> web page and <link url="http://www.jboss.org/file-access/default/members/jbossrichfaces/freezone/..." >RichFaces Developer Guide</link>.
+
+ </para>
+</section>
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14036 - trunk/docs/realworld_app_guide/en/src/main/docbook.
by richfaces-svn-commits＠lists.jboss.org
Author: msorokin
Date: 2009-05-06 10:45:48 -0400 (Wed, 06 May 2009)
New Revision: 14036
Modified:
trunk/docs/realworld_app_guide/en/src/main/docbook/master.xml
Log:
added VUser Input Data Validation chapter
Modified: trunk/docs/realworld_app_guide/en/src/main/docbook/master.xml
===================================================================
--- trunk/docs/realworld_app_guide/en/src/main/docbook/master.xml 2009-05-06 14:31:47 UTC (rev 14035)
+++ trunk/docs/realworld_app_guide/en/src/main/docbook/master.xml 2009-05-06 14:45:48 UTC (rev 14036)
@@ -18,6 +18,7 @@
<!ENTITY contextMenu SYSTEM "includes/contextMenu.xml">
<!ENTITY tooltips SYSTEM "includes/tooltips.xml">
<!ENTITY hiw SYSTEM "includes/hiw.xml">
+ <!ENTITY validators SYSTEM "includes/validators.xml">
]>
<book>
@@ -77,6 +78,7 @@
&uploadImages;
&contextMenu;
&tooltips;
+ &validators;
<!-- &hiw; -->
&userPreferencesView;
&errorsReports;
15 years, 8 months
- 1
- 0
JBoss Rich Faces SVN: r14035 - trunk/docs/realworld_app_guide/en/src/main/docbook/includes.
by richfaces-svn-commits＠lists.jboss.org
Author: atsebro
Date: 2009-05-06 10:31:47 -0400 (Wed, 06 May 2009)
New Revision: 14035
Modified:
trunk/docs/realworld_app_guide/en/src/main/docbook/includes/albumView.xml
trunk/docs/realworld_app_guide/en/src/main/docbook/includes/navigationPanel.xml
trunk/docs/realworld_app_guide/en/src/main/docbook/includes/uploadImages.xml
Log:
RF-5768: Real World Demo Application Tutorial Update for 3.3.1 release: updating guide
Modified: trunk/docs/realworld_app_guide/en/src/main/docbook/includes/albumView.xml
===================================================================
--- trunk/docs/realworld_app_guide/en/src/main/docbook/includes/albumView.xml 2009-05-06 13:59:46 UTC (rev 14034)
+++ trunk/docs/realworld_app_guide/en/src/main/docbook/includes/albumView.xml 2009-05-06 14:31:47 UTC (rev 14035)
@@ -14,11 +14,11 @@
The component is included into the page with the help of <emphasis role="bold"><property>ui:include</property></emphasis>:
</para>
<programlisting role="XML"><![CDATA[...
-<ui:include src="/includes/misc/inputNumberSlider.xhtml"/>
+<ui:include src="src/main/webapp/includes/image/inputNumberSlider.xhtml"/>
...]]></programlisting>
<para>
- Now let's have a look at <code>src/main/webapp/includes/misc/inputNumberSlider.xhtml</code> file:
+ Now let's have a look at <code>src/main/webapp/includes/image/inputNumberSlider.xhtml</code> file:
</para>
<programlisting role="XML"><![CDATA[...
<ui:composition ...>
@@ -37,73 +37,92 @@
</ui:composition>
...]]></programlisting>
<para>
- On each slider position change the <emphasis role="bold"><property>a4j:support</property></emphasis> component invokes an Ajax request that passes a new set value into the <code>ImageSizeHelper.java</code> class.
- This class saves new photo dimensions, processes and assigns new values to photo related attributes (a CSS class for new photo size, postfix for a new file name, image background):
+ There is special Enumeration type that contains four predefined values for image size. Each type has a set of image related attributes such as CSS class for new photo size, postfix for a new file name, image background.
+ The <code>setValue</code> method of the <code>ImageSizeHelper.java</code> class is triggered on each slider's position change. This method sets one of four predefined values for image size and due to slider's position.
</para>
+ <programlisting role="JAVA"><![CDATA[public void setValue(int value) {
+ currentDimension = ImageDimension.getInstance(value);
+ this.value = currentDimension.getX();
+}]]></programlisting>
+
+ <para>
+ And here is the <code>ImageDimension.java</code> class:
+ </para>
+
<programlisting role="JAVA"><![CDATA[...
- public static enum ImageDimension {
-
- SIZE_80(80), SIZE_120(120), SIZE_160(160), SIZE_200(200);
-
- final static String CSS_CLASS = "preview_box_photo_";
- final static String FILE_POSTFIX = "_small";
- final static String IMAGE_BG = "/img/shell/frame_photo_%1$d.png";
- final static String IMAGE_BG_STYLE = "width: %1$dpx; height: %1$dpx";
+ public enum ImageDimension {
- int x;
- String bgStyle;
- String cssClass;
- String imageBgSrc;
- String filePostfix;
+ SIZE_80(80), SIZE_120(120), SIZE_160(160), SIZE_200(200), SIZE_MEDIUM(600), ORIGINAL(0);
- private ImageDimension(int x) {
- this.x = x;
- this.bgStyle = String.format(IMAGE_BG_STYLE, x + 20);
- cssClass = CSS_CLASS + x;
- imageBgSrc = String.format(IMAGE_BG, (x == 160) ? 200 : x);
- filePostfix = FILE_POSTFIX + x;
- }
+ final static String CSS_CLASS = "preview_box_photo_";
+ final static String FILE_POSTFIX = "_small";
+ final static String IMAGE_BG = "/img/shell/frame_photo_%1$d.png";
+ final static String IMAGE_BG_STYLE = "width: %1$dpx; height: %1$dpx";
+
+ int x;
+ String bgStyle;
+ String cssClass;
+ String imageBgSrc;
+ String filePostfix;
+
+ private ImageDimension(int x) {
+ this.x = x;
+ this.bgStyle = String.format(IMAGE_BG_STYLE, x + 20);
+ cssClass = CSS_CLASS + x;
+ imageBgSrc = String.format(IMAGE_BG, (x == 160) ? 200 : x);
+ if(x == 600){
+ filePostfix = "_medium";
+ }else if(x == 0){
+ filePostfix = "";
+ }else{
+ filePostfix = FILE_POSTFIX + x;
+ }
+ }
...]]></programlisting>
-
- <para>
- After the <code>ImageSizeHelper.java</code> is worked out the <emphasis role="bold"><property>a4j:support</property></emphasis> component renders user photos
+
+ <para>
+ After the <emphasis role="bold"><property><a4j:support></property></emphasis> is worked out user photos
(more exactly, the <emphasis role="bold"><property>h:panelGroup</property></emphasis> with <code>userAlbumImages</code> id that contains user photos)
- correspondingly to a new set value. Here is <code>web/src/main/webapp/includes/image/imageList.xhtml</code>:
+ are rendered correspondingly to a new set value. Here is <code>web/src/main/webapp/includes/image/imageList.xhtml</code>:
</para>
<programlisting role="XML"><![CDATA[...
<h:panelGroup id="userAlbumImages">
- <a4j:repeat id="imageList" value="#{model.images}" var="image" rows="20">
- <h:panelGroup layout="block" styleClass="#{imageSizeHelper.currentDimension.cssClass}">
- <h:graphicImage styleClass="pr_photo_bg" style="#{imageSizeHelper.currentDimension.imageBgStyle}" value="#{imageSizeHelper.currentDimension.imageBg}" />
- <h:panelGrid cellpadding="0">
- <h:panelGroup>
- <a4j:commandLink actionListener="#{controller.showImage(image)}" reRender="mainArea, tree">
- <a4j:mediaOutput id="img" element="img"
- createContent="#{imageLoader.paintImage}"
- style="border : 1px solid #FFFFFF;"
- value="#{fileManager.transformPath(image.fullPath, imageSizeHelper.currentDimension.filePostfix)}">
- <f:param value="#{imageSizeHelper.currentDimension.x}" name="x" />
- <rich:dragSupport rendered="#{controller.isUserImage(image)}" reRender="mainArea, tree" id="dragSource" dragIndicator="dragIndicator"
- dragType="image" dragValue="#{image}">
- <rich:dndParam id="dragParam" name="label" value="#{image.name}" />
- </rich:dragSupport>
- <ui:include src="/includes/contextMenu/CMForImage.xhtml" >
- <ui:param name="image" value="#{image}" />
- </ui:include>
- </a4j:mediaOutput>
- </a4j:commandLink>
- <br/>
- </h:panelGroup>
- </h:panelGrid>
- <h:panelGroup layout="block" styleClass="photo_name">#{image.name} </h:panelGroup>
- <h:panelGroup layout="block" styleClass="photo_data">
- <h:outputText value="#{image.created}">
- <f:convertDateTime />
- </h:outputText>
- </h:panelGroup>
- </h:panelGroup>
- </a4j:repeat>
-</h:panelGroup>
+ <a4j:repeat id="imageList" value="#{model.images}" var="image" rows="20">
+ <h:panelGroup layout="block" styleClass="#{imageSizeHelper.currentDimension.cssClass}">
+ <h:graphicImage styleClass="pr_photo_bg" style="#{imageSizeHelper.currentDimension.imageBgStyle}" value="#{imageSizeHelper.currentDimension.imageBg}" />
+ <h:panelGrid cellpadding="0">
+ <h:panelGroup>
+ <a4j:commandLink
+ actionListener="#{controller.showImage(image)}"
+ reRender="mainArea, treePanel">
+ <a4j:mediaOutput id="img" element="img"
+ createContent="#{imageLoader.paintImage}"
+ style="border : 1px solid #FFFFFF;"
+ value="#{fileManager.transformPath(image.fullPath, imageSizeHelper.currentDimension.filePostfix)}">
+ <f:param value="#{imageSizeHelper.currentDimension.x}" name="x" />
+ <rich:dragSupport rendered="#{controller.isUserImage(image)}" reRender="mainArea, treePanel" id="dragSource" dragIndicator="dragIndicator"
+ dragType="image" dragValue="#{image}">
+ <rich:dndParam id="dragParam" name="label" value="#{image.name}" />
+ </rich:dragSupport>
+ </a4j:mediaOutput>
+ </a4j:commandLink>
+ <br/>
+ </h:panelGroup>
+ <ui:include src="/includes/contextMenu/CMForImage.xhtml" >
+ <ui:param name="image" value="#{image}" />
+ <ui:param name="mediaOutput" value="#{rich:clientId('img')}"/>
+ </ui:include>
+
+ </h:panelGrid>
+ <h:panelGroup layout="block" styleClass="photo_name">#{image.name}</h:panelGroup>
+ <h:panelGroup layout="block" styleClass="photo_data">
+ <h:outputText value="#{image.created}">
+ <f:convertDateTime />
+ </h:outputText>
+ </h:panelGroup>
+ </h:panelGroup>
+ </a4j:repeat>
+ </h:panelGroup>
...]]></programlisting>
<para>
@@ -118,6 +137,25 @@
</imageobject>
</mediaobject>
</figure>
+ <para>
+ Vizit following pages at RichFaces Live Demo for more information, examples and sources on the components used in the application and described in this chapter:
+ </para>
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/inputNumberSlider.jsf...">InputNumberSlider</ulink> page for the <emphasis role="bold"><property><rich:inputNumberSlider></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/support.jsf?c=support">AjaxSupport</ulink> for the <emphasis role="bold"><property><a4j:suport></property></emphasis> component.
+ </para>
+ </listitem>
+
+
+ </itemizedlist>
</section>
@@ -305,5 +343,53 @@
}
...]]></programlisting>
+ <para>
+ Vizit following pages at RichFaces Live Demo for more information, examples and sources on the components used in the application and described in this chapter:
+ </para>
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/modalPanel.jsf?c=moda...">ModalPanel</ulink> page for the <emphasis role="bold"><property><rich:modalPanel></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/effect.jsf?c=effect">Effect</ulink> for the <emphasis role="bold"><property><rich:effect></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/mediaOutput.jsf?c=med...">MediaOutput</ulink> for the <emphasis role="bold"><property><a4j:mediaOutput></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/support.jsf?c=support">AjaxSupport</ulink> for the <emphasis role="bold"><property><a4j:suport></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/commandLink.jsf?c=com...">CommandLink</ulink> for the <emphasis role="bold"><property><a4j:commandLink></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/form.jsf?c=form">AjaxForm</ulink> for the <emphasis role="bold"><property><a4j:form></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/poll.jsf?c=poll">Poll</ulink> for the <emphasis role="bold"><property><a4j:poll></property></emphasis> component.
+ </para>
+ </listitem>
+ </itemizedlist>
+
</section>
</section>
Modified: trunk/docs/realworld_app_guide/en/src/main/docbook/includes/navigationPanel.xml
===================================================================
--- trunk/docs/realworld_app_guide/en/src/main/docbook/includes/navigationPanel.xml 2009-05-06 13:59:46 UTC (rev 14034)
+++ trunk/docs/realworld_app_guide/en/src/main/docbook/includes/navigationPanel.xml 2009-05-06 14:31:47 UTC (rev 14035)
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8"?>
-<section id="navigationPanel" xreflabel="navigationPanel">
+<section id="navigationTree" xreflabel="navigationTree">
<?dbhtml filename="navigationPanel.html"?>
- <title>Navigation panel</title>
+ <title>Navigation tree</title>
<para>
The <emphasis role="bold"><property><rich:tree></property></emphasis> component takes one of the main places
in the <property>Photo Album</property> and is tightly bounded with the application logic.
@@ -11,11 +11,11 @@
is used to group thematic albums and may contain as many albums as needed.
</para>
<para>
- There are two types of navigation panel in the application: for a registered user and for a guest.
+ There are two types of navigation tree in the application: for a registered user and for a guest.
The difference between them is that the first one has a context menu and drag-and-drop possibility.
</para>
<section>
- <title>Navigation panel for a guest</title>
+ <title>Navigation tree for a guest</title>
<!--para>
The <emphasis role="bold"><property><rich:tree></property></emphasis> component is designed for
@@ -23,7 +23,7 @@
The component also supports built-in drag-and-drop functionality.
</para-->
<para>
- Navigation panel for a guest is represented as a simple
+ Navigation tree for a guest is represented as a simple
<emphasis role="bold"><property><rich:tree></property></emphasis> component.
</para>
<para>
@@ -41,7 +41,7 @@
According to the "Shelves - Albums" hierarchy we need two nested
<emphasis role="bold"><property><rich:treeNodesAdaptor></property></emphasis> components.
The first one iterates over the Shelves collection
- that is returned from the <code>getPredefinedShelves()</code> method:
+ that is returned from the <code>getPredefinedShelves()</code> method of <code>ShelfManager.java</code> class:
</para>
<programlisting role="JAVA"><![CDATA[...
public List<Shelf> getPredefinedShelves() {
@@ -58,7 +58,7 @@
<emphasis><property>"var"</property></emphasis> attribute.
The <emphasis><property>"var"</property></emphasis> attribute
is used to get access to the data object of the current collection element Shelf,
- so it is possible to output any necessary data:
+ so it is possible to output any necessary data. Let's see the <code>src/main/webapp/includes/index/tree.xhtml</code> file:
</para>
<!--
The <emphasis role="bold"><property><rich:treeNodesAdaptor></property></emphasis> component accepts
@@ -116,53 +116,49 @@
</para-->
<programlisting role="XML"><![CDATA[...
-<rich:tree
- adviseNodeOpened="#{treeManager.adviseNodeSelected}"
- adviseNodeSelected="#{treeManager.adviseNodeSelected}"
- ajaxSubmitSelection="false" id="PreDefinedTree"
- treeNodeVar="treeNode" switchType="client"
- iconCollapsed="/img/shell/tree_icon_plus.png"
- iconExpanded="/img/shell/tree_icon_minus.png"
- showConnectingLines="false">
- <rich:treeNodesAdaptor nodes="#{shelfManager.getPredefinedShelves()}" var="shelf">
- <rich:treeNode style="cursor:pointer" reRender="treeform,mainArea"
- selectedClass="tree-selected-node">
- <f:facet name="icon">
- <h:graphicImage style="border: none" value="/img/shell/tree_icon_shelf.png">
- <a4j:support reRender="treeform,mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
- </h:graphicImage>
- </f:facet>
- <a4j:outputPanel >
- <h:outputText style="cursor:pointer" value="#{shelf.name}" />
- <h:outputText value=" :: " />
- <strong>#{shelf.unvisitedImages.size()}</strong> new
- <a4j:support reRender="treeform,mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
- </a4j:outputPanel>
- </rich:treeNode>
- <rich:treeNodesAdaptor var="album"
- nodes="#{shelf.albums}">
- <rich:treeNode style="cursor:pointer" reRender="treeform,mainArea"
- selectedClass="tree-selected-node"
- icon="img/shell/tree_icon_album.png">
- <f:facet name="iconLeaf">
- <h:graphicImage style="border: none" value="img/shell/tree_icon_album.png">
- <a4j:support reRender="treeform,mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
- </h:graphicImage>
- </f:facet>
- <a4j:outputPanel>
- <h:outputText style="cursor:pointer" value="#{album.name}" />
- <h:outputText value=" :: " />
- <strong>#{album.unvisitedImages.size()}</strong> new
- <a4j:support reRender="treeform,mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
- </a4j:outputPanel>
- </rich:treeNode>
- </rich:treeNodesAdaptor>
- </rich:treeNodesAdaptor>
- </rich:tree>
+<rich:tree adviseNodeOpened="#{treeManager.adviseNodeSelected}"
+ adviseNodeSelected="#{treeManager.adviseNodeSelected}"
+ ajaxSubmitSelection="false" id="PreDefinedTree"
+ treeNodeVar="treeNode" switchType="client"
+ iconCollapsed="/img/shell/tree_icon_plus.png"
+ iconExpanded="/img/shell/tree_icon_minus.png"
+ showConnectingLines="false">
+ <rich:treeNodesAdaptor nodes="#{shelfManager.getPredefinedShelves()}" var="shelf">
+ <rich:treeNode style="cursor:pointer" reRender="treePanel,mainArea" selectedClass="tree-selected-node">
+ <f:facet name="icon">
+ <h:graphicImage style="border: none" value="/img/shell/tree_icon_shelf.png">
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
+ </h:graphicImage>
+ </f:facet>
+ <a4j:outputPanel >
+ <h:outputText style="cursor:pointer" value="#{shelf.name}" />
+ <h:outputText value=" :: " />
+ <strong>#{shelf.unvisitedImages.size()}</strong> new
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
+ </a4j:outputPanel>
+ </rich:treeNode>
+
+ <rich:treeNodesAdaptor var="album" nodes="#{shelf.albums}">
+ <rich:treeNode style="cursor:pointer" reRender="treePanel,mainArea" selectedClass="tree-selected-node" icon="img/shell/tree_icon_album.png">
+ <f:facet name="iconLeaf">
+ <h:graphicImage style="border: none" value="img/shell/tree_icon_album.png">
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
+ </h:graphicImage>
+ </f:facet>
+ <a4j:outputPanel>
+ <h:outputText style="cursor:pointer" value="#{album.name}" />
+ <h:outputText value=" :: " />
+ <strong>#{album.unvisitedImages.size()}</strong> new
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
+ </a4j:outputPanel>
+ </rich:treeNode>
+ </rich:treeNodesAdaptor>
+ </rich:treeNodesAdaptor>
+</rich:tree>
...]]></programlisting>
<para>
- The image below shows how the navigation panel for a guest is rendered on the page.
+ The image below shows how the navigation tree for a guest is rendered on the page.
</para>
<figure>
@@ -177,9 +173,9 @@
</section>
<section>
- <title>Navigation panel for a registered user</title>
+ <title>Navigation tree for a registered user</title>
<para>
- As it was mentioned before a navigation panel for a registered user has
+ As it was mentioned before a navigation tree for a registered user has
two main features: drag-and-drop and context menu. Context menu is described
in the <link linkend="contextMenu">"Context menu"</link> chapter.
</para>
@@ -220,23 +216,32 @@
For this purpose we use previously mentioned
<emphasis><property>"dragValue"</property></emphasis>,
<emphasis><property>"dragType"</property></emphasis>
- attributes:
+ attributes. Let's have a look at the <code>src/main/webapp/includes/index/tree.xhtml</code> file:
</para>
<programlisting role="XML"><![CDATA[<rich:treeNodesAdaptor var="album" nodes="#{shelf.albums}">
- <rich:treeNode dragType="album" dragValue="#{album}" reRender="mainArea, treeform">
- ...
- </rich:treeNode>
+ <rich:treeNode style="cursor:pointer"
+ reRender="mainArea, treePanel"
+ dragType="album"
+ dragValue="#{album}"
+ dropValue="#{album}"
+ acceptedTypes="image"
+ selectedClass="tree-selected-node"
+ icon="img/shell/tree_icon_album.png">
+ ...
+ <rich:dndParam name="label" type="drag" value="#{album.name}" />
+ ...
+ </rich:treeNode>
</rich:treeNodesAdaptor>
]]></programlisting>
<para>
To provide drop functionality for the marked albums, we should mark Shelves as drop zones in the application code too.
For this purpose we add the <emphasis><property>"dropValue"</property></emphasis> and
- <emphasis><property>"acceptedTypes"</property></emphasis> attributes to the "Shelf" node:
+ <emphasis><property>"acceptedTypes"</property></emphasis> attributes to the "Shelf" node in the same <code>src/main/webapp/includes/index/tree.xhtml</code> file:
</para>
<programlisting role="XML"><![CDATA[<rich:treeNodesAdaptor nodes="#{shelfManager.getUserShelves()}" var="shelf">
- <rich:treeNode acceptedTypes="album" dropValue="#{shelf}" reRender="mainArea, treeform">
- ...
- </rich:treeNode>
+ <rich:treeNode style="cursor:pointer" acceptedTypes="album" dropValue="#{shelf}" reRender="mainArea, treePanel" selectedClass="tree-selected-node">
+ ...
+ </rich:treeNode>
</rich:treeNodeAdaptor>]]></programlisting>
<para>
The <emphasis><property>"acceptedTypes"</property></emphasis> attribute tells the "Shelf" node
@@ -246,14 +251,27 @@
so the "Shelf" node can accept it.
</para>
<para>
- Finally we need to specify a listener in the <emphasis><property>"dropListener"</property></emphasis>
- attribute in order to process drop on the server side:
+ Finally in order to process drop on the server side we need to specify a listener for the <emphasis role="bold"><property><rich:tree></property></emphasis> in the <emphasis><property>"dropListener"</property></emphasis>
+ attribute (<code>src/main/webapp/includes/index/tree.xhtml</code> file):
</para>
- <programlisting role="XML"><![CDATA[<rich:tree dragIndicator="dragIndicator" dropListener="#{dndManager.processDrop}">
- ...
-</rich:tree>]]></programlisting>
+ <programlisting role="XML"><![CDATA[<rich:tree adviseNodeOpened="#{treeManager.adviseNodeSelected}"
+ adviseNodeSelected="#{treeManager.adviseNodeSelected}"
+ ajaxSubmitSelection="false" dragIndicator="dragIndicator"
+ treeNodeVar="treeNode" switchType="client"
+ iconCollapsed="/img/shell/tree_icon_plus.png"
+ iconExpanded="/img/shell/tree_icon_minus.png"
+ dropListener="#{dndManager.processDrop}"
+ showConnectingLines="false">
+ ...
+</tree>]]></programlisting>
<para>
- The <code>processDrop()</code> method is shown in the listing below:
+ The code for the <emphasis role="bold"><property><rich:dragIndicator></property></emphasis> looks like the following:
+ </para>
+ <programlisting role="XML"><![CDATA[<rich:dragIndicator id="dragIndicator" />]]></programlisting>
+
+
+ <para>
+ The <code>processDrop()</code> method of <code>DnDManager.java</code> class is shown in the listing below:
</para>
<programlisting role="JAVA"><![CDATA[...
public void processDrop(DropEvent dropEvent) {
@@ -276,23 +294,25 @@
}
...]]></programlisting>
<para>
- Here is the whole example of the "Navigation panel for a registered user":
+ Here is the whole example of the "Navigation tree for a registered user":
</para>
-<programlisting role="XML"><![CDATA[<rich:tree
+ <programlisting role="XML"><![CDATA[<h:panelGroup id="tree" rendered="#{identity.hasRole('admin')}" layout="block">
+ <a4j:commandLink actionListener="#{controller.selectShelves()}" reRender="mainArea, treePanel"><h2><h:outputText value="My shelves:"/></h2></a4j:commandLink><br/>
+ <rich:dragIndicator
+ id="dragIndicator" />
+ <rich:tree
+ adviseNodeOpened="#{treeManager.adviseNodeSelected}"
+ adviseNodeSelected="#{treeManager.adviseNodeSelected}"
ajaxSubmitSelection="false" dragIndicator="dragIndicator"
treeNodeVar="treeNode" switchType="client"
iconCollapsed="/img/shell/tree_icon_plus.png"
iconExpanded="/img/shell/tree_icon_minus.png"
dropListener="#{dndManager.processDrop}"
showConnectingLines="false">
- <rich:treeNodesAdaptor nodes="#{shelfManager.getUserShelves()}"
- var="shelf">
- <rich:treeNode style="cursor:pointer" acceptedTypes="album" dropValue="#{shelf}"
- reRender="mainArea, treeform"
- selectedClass="tree-selected-node">
+
<f:facet name="icon">
<h:graphicImage style="border: none" value="/img/shell/tree_icon_shelf.png">
- <a4j:support reRender="treeform, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
</h:graphicImage>
</f:facet>
<ui:include src="/includes/contextMenu/CMForShelf.xhtml" >
@@ -302,20 +322,20 @@
<h:outputText style="cursor:pointer" value="#{shelf.name}" />
<h:outputText value=" :: " />
<strong>#{shelf.unvisitedImages.size()}</strong> new
- <a4j:support reRender="treeform, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showShelf(shelf)}" similarityGroupingId="sel" />
</a4j:outputPanel>
</rich:treeNode>
<rich:treeNodesAdaptor var="album"
nodes="#{shelf.albums}">
- <rich:treeNode style="cursor:pointer" reRender="mainArea, treeform" dragType="album"
+ <rich:treeNode style="cursor:pointer" reRender="mainArea, treePanel" dragType="album"
dragValue="#{album}" dropValue="#{album}"
acceptedTypes="image"
selectedClass="tree-selected-node"
icon="img/shell/tree_icon_album.png">
<f:facet name="iconLeaf">
<h:graphicImage style="border: none" value="img/shell/tree_icon_album.png">
- <a4j:support reRender="treeform, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
</h:graphicImage>
</f:facet>
<ui:include src="/includes/contextMenu/CMForAlbum.xhtml" >
@@ -326,14 +346,15 @@
<h:outputText style="cursor:pointer" value="#{album.name}" />
<h:outputText value=" :: " />
<strong>#{album.unvisitedImages.size()}</strong> new
- <a4j:support reRender="treeform, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
+ <a4j:support reRender="treePanel, mainArea" event="onclick" actionListener="#{controller.showAlbum(album)}" similarityGroupingId="sel" />
</a4j:outputPanel>
</rich:treeNode>
</rich:treeNodesAdaptor>
</rich:treeNodesAdaptor>
-</rich:tree>]]></programlisting>
+ </rich:tree>
+ </h:panelGroup>]]></programlisting>
<para>
The image below shows how the described above drag-and-drop features are rendered in the Photo Album.
</para>
@@ -345,6 +366,38 @@
</imageobject>
</mediaobject>
</figure>
+ <para>
+ Vizit following pages at RichFaces Live Demo for more information, examples and sources on the components used in the application and described in this chapter:
+ </para>
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/tree.jsf?c=tree">Tree</ulink> for the <emphasis role="bold"><property><rich:tree></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/treeNodesAdaptor.jsf?...">TreeNodesAdaptor</ulink> for the <emphasis role="bold"><property><rich:treeNodesAdaptor></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/dragSupport.jsf?c=dra...">DragIndicator</ulink> for the <emphasis role="bold"><property><rich:dragIndicator></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/dragSupport.jsf?c=dnd...">DragDropParameter</ulink> for the <emphasis role="bold"><property><rich:dndParam></property></emphasis> component.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+
</section>
</section>
Modified: trunk/docs/realworld_app_guide/en/src/main/docbook/includes/uploadImages.xml
===================================================================
--- trunk/docs/realworld_app_guide/en/src/main/docbook/includes/uploadImages.xml 2009-05-06 13:59:46 UTC (rev 14034)
+++ trunk/docs/realworld_app_guide/en/src/main/docbook/includes/uploadImages.xml 2009-05-06 14:31:47 UTC (rev 14035)
@@ -2,12 +2,12 @@
<section>
<title>Upload Images</title>
<para>
- In the previous chapter we have discussed how to create Navigation Panels
+ In the previous chapter we have discussed how to create Navigation Trees
that represent "Shelves - Albums" hierarchy.
Now it is time to upload images.
</para>
<para>
- The implementation of <emphasis role="bold"><property><rich:fileUpload></property></emphasis>
+ The <emphasis role="bold"><property><rich:fileUpload></property></emphasis> component
in the Photo Album application uses the embedded Flash module
that adds extra functionality to the component:
</para>
@@ -23,8 +23,7 @@
</listitem>
</itemizedlist>
<para>
- The "/includes/fileUpload/fileUploader.xhtml" page
- is responsible for the photos uploading functionality:
+ The code for the <emphasis role="bold"><property><rich:fileUpload></property></emphasis> is contained in the "/includes/fileUpload/fileUploader.xhtml" page:
</para>
<programlisting role="XML"><![CDATA[...
<rich:fileUpload
@@ -46,7 +45,7 @@
</para>
<para>
The <emphasis><property>"fileUploadListener"</property></emphasis> attribute
- represents the action listener method <code>listener()</code> of the <code>fileUploadManager</code>
+ represents the action listener method <code>listener()</code> of the <code>FileUploadManager</code>
class that is notified after file is uploaded.
This method makes the main job on the upload:
</para>
@@ -85,7 +84,7 @@
...]]></programlisting>
<para>
The <code>listener()</code> method is called at server side after every file uploaded
- and saves files in a temporary folder or in RAM.
+ and server saves these files in a temporary folder or in RAM depending on configuration.
In the Photo Album application the uploaded files are stored in the temporary folder
because the value of the <code>createTempFile</code> parameter is set to <code>true</code>.
See the code from the <code>web.xml</code> descriptor:
@@ -93,22 +92,45 @@
<programlisting role="XML"><![CDATA[...
<filter>
- <filter-name>Seam Filter</filter-name>
- <filter-class>org.jboss.seam.servlet.SeamFilter</filter-class>
- <init-param>
- <param-name>createTempFiles</param-name>
- <param-value>true</param-value>
- </init-param>
- ...
+ <filter-name>Seam Filter</filter-name>
+ <filter-class>org.jboss.seam.servlet.SeamFilter</filter-class>
+ <init-param>
+ <param-name>createTempFiles</param-name>
+ <param-value>true</param-value>
+ </init-param>
+ <init-param>
+ <param-name>maxRequestSize</param-name>
+ <param-value>20000000</param-value>
+ </init-param>
</filter>
...]]></programlisting>
<para>
- After the image is stored in the temporary folder
- the <code>listener()</code> method creates an <code>Image</code> object
+ The <code>listener()</code> method creates an <code>Image</code> object
and extracts all image metadata such as Camera name, Image size, etc.
- It saves six different sizes of the photo in order to create thumbnails
- and perform images scaling.
+ It performs scaling of an image and saves six different image's dimentions in order to create thumbnails.
After that the photo is added into the database
the temporary file is removed.
</para>
+
+ <para>
+ Vizit following pages at RichFaces Live Demo for more information, examples and sources on the components used in the application and described in this chapter:
+ </para>
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/fileUpload.jsf?c=file...">FileUpload</ulink> page for the <emphasis role="bold"><property><rich:fileUpload></property></emphasis> component;
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <ulink url="http://livedemo.exadel.com/richfaces-demo/richfaces/support.jsf?c=support">AjaxSupport</ulink> for the <emphasis role="bold"><property><a4j:suport></property></emphasis> component.
+ </para>
+ </listitem>
+
+
+ </itemizedlist>
+
+
</section>
15 years, 8 months
- 1
- 0