bookmark-add-one-2-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="url_add">      
      <querytext>

	select url__new (
           		:url_id,
           		:url_title,
	   		:host_url,
	   		:complete_url,
           		:meta_keywords,
           		:meta_description,
           		:viewed_user_id,
           		:creation_ip,
			null
			);

      </querytext>
</fullquery>

 
<fullquery name="bookmark_add">      
      <querytext>


	select bookmark__new (
		    :bookmark_id,
		    :viewed_user_id,
		    :url_id,
		    :local_title,
		    FALSE,
		    :parent_id,
		    null,
		    :user_id,
		    :creation_ip,
		    null);

      </querytext>
</fullquery>

 
</queryset>