bookmarks-import-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="folder_insert">      
      <querytext>

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

      </querytext>
</fullquery>

 
<fullquery name="new_url">      
      <querytext>

	select url__new (
           		:url_id,
           		:local_title,
	   		:host_url,
	   		:complete_url,
			null,
			null,
           		:viewed_user_id,
           		:creation_ip,
			null
			);

      </querytext>
</fullquery>

 
<fullquery name="bookmark_insert">      
      <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>