<?xml version="1.0"?>
<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="add_mp3">      
      <querytext>

      select mp3__new(
	:mp3_id,
	:client_filename,
	:mp3_title

      );

      </querytext>
</fullquery>

<fullquery name="update_mp3_info">      
      <querytext>

update mp3_mp3s
set 	artist = :artist,
	bitrate = :bitrate,
	album = :album,
	tracknum = :tracknum,
	genre = :genre,
	year = :year,
	layer = :layer,
	copyright_p = :copyright_p,
	version = :version,
	mode_num = :mode_num,
	stereo_p = :stereo_p,
	frequency = :frequency,
	minutes = :minutes
where 	mp3_id = :mp3_id

      </querytext>
</fullquery>


</queryset>