 alter table ds_temp_tax_validator add wiki varchar2(255);
 alter table ds_temp_tax_validator add gni varchar2(255);
 alter table ds_temp_tax_validator add worms varchar2(255);
+alter table ds_temp_tax_validator add eol varchar2(255);
 
 create or replace public synonym ds_temp_tax_validator for ds_temp_tax_validator;
 grant all on ds_temp_tax_validator to manage_taxonomy;

			</cfif>



			<br>GNI:#g#
			<br>WikiData:#w#
			<br>WORMs:#wr#

			<cfquery name="u" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
				update ds_temp_tax_validator set wiki='#w#',gni='#g#',worms='#wr#' where taxon_name='#taxon_name#'
			</cfquery>

		</cfloop>

				<cfset g='found'>
			</cfif>

			<cfhttp url="http://www.marinespecies.org/rest/AphiaIDByName/#taxon_name#?marine_only=false" method="get">
				<cfhttpparam type="header" name="accept" value="application/json">
			</cfhttp>
