Index: openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql	10 Jun 2003 10:06:42 -0000	1.1
+++ openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql	12 Jun 2003 06:55:45 -0000	1.2
@@ -145,4 +145,36 @@
       </querytext>
 </fullquery>
 
+<fullquery name="pa_load_images.update_photo_data">      
+    <querytext>
+
+        UPDATE pa_photos 
+        SET camera_model = :tmp_exif_Cameramodel,
+            user_filename = :upload_name,
+            date_taken = datetime(:tmp_exif_DateTime),
+            flash = :tmp_exif_Flashused,
+            aperture = :tmp_exif_Aperture,
+            metering = :tmp_exif_MeteringMode,
+            focal_length = :tmp_exif_Focallength,
+            exposure_time = :tmp_exif_Exposuretime,
+            focus_distance = :tmp_exif_FocusDist,
+            sha256 = :base_sha256
+        WHERE pa_photo_id = :photo_rev_id
+
+    </querytext>
+</fullquery>
+
+<fullquery name="pa_rotate.get_image_files">      
+      <querytext>
+      
+            select i.image_id, crr.content as filename, i.width, i.height
+            from cr_items cri, cr_revisions crr, images i
+            where cri.parent_id = :id
+              and crr.revision_id = cri.latest_revision
+              and i.image_id = cri.latest_revision
+            order by crr.content_length desc
+	
+      </querytext>
+</fullquery>
+
 </queryset>