-- CREATE SCHEMA sparql;
-- version 0.4

COMMENT ON SCHEMA sparql IS 'SPARQL utilities';

SET search_path = sparql, pg_catalog;

--
-- Name: iri; Type: DOMAIN; Schema: sparql; Owner: sparql
--

CREATE DOMAIN iri AS text;

--
-- Name: config; Type: TABLE; Schema: sparql; Owner: sparql; Tablespace: 
--

CREATE TABLE IF NOT EXISTS config (
    name text NOT NULL,
    value text,
    regtype regtype DEFAULT 'text'::regtype NOT NULL,
    comment text
);

--
-- Name: TABLE config; Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON TABLE config IS 'Various configuration options';

--
-- Name: endpoint; Type: TABLE; Schema: sparql; Owner: sparql; Tablespace: 
--

CREATE TABLE IF NOT EXISTS endpoint (
    name name NOT NULL,
    url text NOT NULL
);

--
-- Name: TABLE endpoint; Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON TABLE endpoint IS 'SPARQL endpoint definitions';


--
-- Name: namespace; Type: TABLE; Schema: sparql; Owner: sparql; Tablespace: 
--

CREATE TABLE IF NOT EXISTS namespace (
    name text NOT NULL,
    uri iri NOT NULL
);

--
-- Name: TABLE namespace; Type: COMMENT; Schema: sparql; Owner: sparql
--

ALTER TABLE ONLY namespace ADD PRIMARY KEY (name);
ALTER TABLE ONLY namespace ADD UNIQUE (uri);
COMMENT ON TABLE namespace IS 'Table of common RDF namespaces';



--
-- Name: compile_query(name, text, text, name[]); Type: FUNCTION; Schema: sparql; Owner: ziga
--

CREATE OR REPLACE FUNCTION compile_query(endpoint_name name, identifier text, query text, group_by name[] DEFAULT NULL::name[]) RETURNS text
    LANGUAGE plperlu
    AS $_X$
my ($name,$func,$query,$group_by)=@_;
use LWP::Simple;
use URI::Escape;
use JSON;

my $p=spi_prepare('select sparql.endpoint_url($1),now()','name');
my $baseUrl = spi_exec_prepared($p,$name)->{rows}->[0];
unless($baseUrl) {
  elog(ERROR,'No endpoint definition in sparql.endpoint for name "'.$name.'"');
}
my $now = $baseUrl->{now};
$baseUrl = $baseUrl->{endpoint_url};
my $extras ="?debug=on&timeout=&save=display&fname=".
	    "&format=".uri_escape("application/sparql-results+json").
	    "&query=";

my $url = $baseUrl.$extras;
my $json = get($url.uri_escape($query));
my $data;
eval { $data = decode_json($json); } 
  or do { elog(ERROR,'SPARQL error'.$json); };
my $vars = $data->{head}{vars};
if(!ref($vars)) { elog(ERROR,'bad result'); }
my $outputs = join(', ', map { qq{out "$_" text} } @{$vars});
my $bindings = $data->{results}{bindings};
$query=~s/^\s*//; $query=~s/\s*$//;

my $ddl1 = "create or replace function $func(endpoint_name name default '$name',$outputs) \nreturns setof record \nas ".'$sparql$'.'
use LWP::Simple;
use URI::Escape;
use Try::Tiny;
use JSON;

my ($name) = @_;
my $p = spi_prepare(\'select sparql.endpoint_url($1)\',\'name\');
my $endpoint_url = spi_exec_prepared($p,$name)->{rows}->[0]->{endpoint_url};
unless($endpoint_url) {
  elog(ERROR,\'No endpoint definition in sparql.endpoint for name "\'.$name.\'"\');
}
my $extras="?debug=on&timeout=&save=display&fname=".
	   "&format=".uri_escape("application/sparql-results+json").
	   "&query=";
	   
my $query = <<"SPARQL";
'.$query.'
SPARQL

my $url  = $endpoint_url.$extras.uri_escape_utf8($query);
my $json = get($url); 
# $json=~s!\\U([0-9A-F]+)!chr(hex($1))!ge;
try { my $data = decode_json($json);
  my $vars = $data->{head}{vars};
  my $bindings = $data->{results}{bindings};
  for my $row (@{$bindings}) {
	my $r = {};
	for my $var (@{$vars}) { $r->{$var}=$row->{$var}{value}; }
	return_next $r;
  }
  return undef;
} catch {
  elog(ERROR,"SPARQL ENDPOINT FAILURE\n$_");
}
'.'$sparql$'." language plperlu cost 5000;
comment on function $func(name) is 'Compiled with sparql.compile_query() on $now';
";

my @a = (); my @g = (); my $gb = "";
if($group_by) {
	for my $w1 (@$vars) {
	  if( grep {$w1 eq $_} @$group_by ) { push @a,qq{"$w1"}; push @g,$w1; } 
	  else { push @a,qq{array_agg(distinct "$w1") filter (where "$w1" is not null) as "$w1"}; }
    }
    if(@g) { $gb = " group by ".join(', ', map {qq{"$_"}} @g); }
} else { @a = ('*'); }

my $ddl2 = "
create or replace view ${func} as select ".join(', ',@a)." from $func()$gb;
comment on view ${func} is 'Compiled with sparql.compile_query() on $now';
";

my $ddl = $ddl1.$ddl2;
spi_exec_query($ddl,1);
return  $ddl;

$_X$;

COMMENT ON FUNCTION compile_query(name,text,text,name[])
IS 'Compile SPARQL query into a SQL function+view';

--
-- Name: config(text); Type: FUNCTION; Schema: sparql; Owner: sparql
--

CREATE OR REPLACE FUNCTION config(var text) RETURNS text
    LANGUAGE sql
    AS $_$
select "value" from sparql.config where "name"=$1;
$_$;

--
-- Name: FUNCTION config(var text); Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON FUNCTION config(var text) IS 'Return configuration setting';

--
-- Name: endpoint_url(name); Type: FUNCTION; Schema: sparql; Owner: sparql
--

CREATE OR REPLACE FUNCTION endpoint_url(endpoint_name name) RETURNS text
    LANGUAGE sql
    AS $_$
select url from sparql.endpoint where name = $1
$_$;

--
-- Name: FUNCTION endpoint_url(endpoint_name name); Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON FUNCTION endpoint_url(endpoint_name name) IS 'Return SPARQL endpoint url for named endpoint';


--
-- Name: get_properties(name, text); Type: FUNCTION; Schema: sparql; Owner: sparql
--

CREATE OR REPLACE FUNCTION get_properties(endpoint_name name, iri text, 
OUT predicate text, OUT object text, OUT value text, OUT lang text, OUT datatype text) RETURNS SETOF record
    LANGUAGE plperlu STABLE STRICT ROWS 5000
    AS $_$
use LWP::Simple;
use URI::Escape;
use JSON;

my ($name,$iri)=@_;
unless($iri) { return; }
my $p=spi_prepare('select sparql.endpoint_url($1)','name');
my $baseUrl = spi_exec_prepared($p,$name)->{rows}->[0]->{endpoint_url};
unless($baseUrl) {
  elog(ERROR,'No endpoint definition in sparql.endpoint for name "'.$name.'"');
}

$iri=~s!(\\|>|\n|\r|\t)!{"\t"=>'\t',"\n"=>'\n',"\r"=>'\r','>'=>'\>','\\'=>'\\\\' }->{$1}!ges; 
$iri=qq{<$iri>};
my $query = <<"SPARQL";
prefix rdfs:  <http://www.w3.org/2000/01/rdf-schema#>

select distinct 
 (?p as ?predicate) 
 (?o as ?object)
 (coalesce(?lo, ?o) as ?value)
 (lang(?lo) as ?lang)
 (coalesce(datatype(?lo),datatype(?o)) as ?datatype) 
where {
  $iri ?p ?o.
  OPTIONAL {?o rdfs:label ?lo}.
}
order by ?p
SPARQL

my $url  = $baseUrl."?debug=on&timeout=&save=display&fname=&format=application%2Fsparql-results%2Bjson&query=".uri_escape_utf8($query);
my $json = get($url);
my $data = decode_json($json);
my $vars = $data->{head}{vars};
my $bindings = $data->{results}{bindings};
for my $row (@{$bindings}) {
	my $r = {};
	for my $var (@{$vars}) { $r->{$var}=$row->{$var}{value}; }
	return_next $r;
}
return undef;
$_$;

--
-- Name: FUNCTION get_properties(endpoint_name name, iri text, OUT predicate text, OUT object text, OUT value text, OUT lang text); Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON FUNCTION get_properties(endpoint_name name, iri text)
 IS 'Get properties for RDF resource from SPARQL endpoint';


CREATE OR REPLACE FUNCTION sparql.get_references(endpoint_name name, iri text, out subject text, OUT predicate text, out label text,out lang text)
 RETURNS SETOF record
  LANGUAGE plperlu
   STABLE STRICT ROWS 5000
   AS $function$
use LWP::Simple;
use URI::Escape;
use JSON;

my ($name,$iri)=@_;
unless($iri) { return; }
my $p=spi_prepare('select sparql.endpoint_url($1)','name');
my $baseUrl = spi_exec_prepared($p,$name)->{rows}->[0]->{endpoint_url};
unless($baseUrl) {
  elog(ERROR,'No endpoint definition in sparql.endpoint for name "'.$name.'"');
}

$iri=~s!(\\|>|\n|\r|\t)!{"\t"=>'\t',"\n"=>'\n',"\r"=>'\r','>'=>'\>','\\'=>'\\\\' }->{$1}!ges;
$iri=qq{<$iri>};
my $query = <<"SPARQL";
prefix rdfs:  <http://www.w3.org/2000/01/rdf-schema#>
prefix rdf:   <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix vc:    <http://www.w3.org/2006/vcard/ns#>
prefix swivt: <http://semantic-mediawiki.org/swivt/1.0#>
prefix dc:    <http://purl.org/dc/elements/1.1/>
prefix foaf:  <http://xmlns.com/foaf/0.1/>

select distinct
 (coalesce(?ls, ?s) as ?subject),
 (?p as ?predicate),
 (?l as ?label),
 (lang(?ls) as ?lang)
 where {
  ?s ?p $iri.
  OPTIONAL {?p rdfs:label ?l}.
  OPTIONAL {?s rdfs:label ?ls}.
 }
 order by ?p
SPARQL

my $url  = $baseUrl."?debug=on&timeout=&save=display&fname=&format=application%2Fsparql-results%2Bjson&query=".uri_escape_utf8($query);
my $json = get($url);
my $data = decode_json($json);
my $vars = $data->{head}{vars};
my $bindings = $data->{results}{bindings};
for my $row (@{$bindings}) {
    my $r = {};
    for my $var (@{$vars}) { $r->{$var}=$row->{$var}{value}; }
    return_next $r;
}
return undef;
$function$
;

COMMENT ON FUNCTION get_references(endpoint_name name, iri text)
 IS 'Get properties for RDF resource from SPARQL endpoint';

-- IRI functions

CREATE OR REPLACE FUNCTION iri_ident(text) RETURNS text
    LANGUAGE plperl IMMUTABLE strict
    AS $_$
  my ($url)=@_;
  if($url=~s!([/#])([_\-a-zA-Z0-9]+)$!$1!) { return $2; }
  return undef;
$_$;
COMMENT ON FUNCTION iri_ident(text) IS 'Get identifier part of IRI';

CREATE OR REPLACE FUNCTION iri_prefix(text) RETURNS text
    LANGUAGE plperl IMMUTABLE strict
    AS $_$
  my ($url)=@_;
  if($url=~s!([/#])([_\-a-zA-Z0-9]+)$!$1!) { return $url; }
  return undef;
$_$;
COMMENT ON FUNCTION iri_prefix(text) IS 'Get namespace prefix part of IRI';

CREATE OR REPLACE FUNCTION iri_ns(text) RETURNS text
    LANGUAGE sql IMMUTABLE strict
    AS $_$
 select name from sparql.namespace where uri = sparql.iri_prefix($1)
$_$;
COMMENT ON FUNCTION iri_ns(text) IS 'Get abbreviated namespace for IRI';

CREATE OR REPLACE FUNCTION iri_crunch(text) RETURNS text
    LANGUAGE sql IMMUTABLE strict
    AS $_$
 select coalesce(iri_ns||':'||iri_ident, $1)
 from ( select sparql.iri_ns($1),sparql.iri_ident($1) ) as iri
$_$;
COMMENT ON FUNCTION iri_crunch(text) IS 'Get abbreviated IRI (with namespace)';

--
-- Name: properties(name); Type: FUNCTION; Schema: sparql; Owner: sparql
--

CREATE OR REPLACE FUNCTION list_properties(endpoint_name name, OUT pred text, OUT label text, OUT comment text, OUT cardinality text, OUT range text, OUT "isDefinedBy" text) RETURNS SETOF record
    LANGUAGE plperlu COST 10000
    AS $_X$
use LWP::Simple;
use URI::Escape;
use Try::Tiny;
use JSON;

my ($name) = @_;
my $p = spi_prepare('select sparql.endpoint_url($1)','name');
my $endpoint_url = spi_exec_prepared($p,$name)->{rows}->[0]->{endpoint_url};
unless($endpoint_url) {
  elog(ERROR,'No endpoint definition in sparql.endpoint for name "'.$name.'"');
}
my $extras="?debug=on&timeout=&save=display&fname=".
	   "&format=".uri_escape("application/sparql-results+json").
	   "&query=";
	   
my $query = <<"SPARQL";
select distinct ?pred ?label ?comment ?cardinality ?range ?isDefinedBy
WHERE {
  ?pred a rdf:Property.
  ?pred rdfs:label ?label.
  optional {?pred rdfs:comment ?comment}.
  optional {?pred rdfs:range ?range}.
  optional {?pred rdfs:cardinality ?cardinality}.
  optional {?pred rdfs:isDefinedBy ?isDefinedBy}.
}
SPARQL

my $url  = $endpoint_url.$extras.uri_escape_utf8($query);
my $json = get($url); 
# $json=~s!\U([0-9A-F]+)!chr(hex($1))!ge;
try { my $data = decode_json($json);
  my $vars = $data->{head}{vars};
  my $bindings = $data->{results}{bindings};
  for my $row (@{$bindings}) {
	my $r = {};
	for my $var (@{$vars}) { $r->{$var}=$row->{$var}{value}; }
	return_next $r;
  }
  return undef;
} catch {
  elog(ERROR,"SPARQL ENDPOINT FAILURE\n$_");
}
$_X$;

--
-- Name: FUNCTION properties(endpoint_name name, OUT pred text, OUT label text, OUT comment text, OUT cardinality text, OUT range text, OUT "isDefinedBy" text); Type: COMMENT; Schema: sparql; Owner: sparql
--

COMMENT ON FUNCTION list_properties(endpoint_name name)
IS 'Get a list of all properties from a SPARQL endpoint';

SET default_with_oids = false;

--
-- Data for Name: endpoint; Type: TABLE DATA; Schema: sparql; Owner: sparql
--

INSERT INTO endpoint VALUES ('localhost', 'http://localhost:8890/sparql/');
INSERT INTO endpoint VALUES ('virtuoso',  'http://localhost:8890/sparql/');
INSERT INTO endpoint VALUES ('dbpedia',   'http://dbpedia.org/sparql/');
INSERT INTO endpoint VALUES ('geonames',  'http://www.lotico.com:3030/lotico/sparql');
INSERT INTO endpoint VALUES ('wikidata',  'https://query.wikidata.org/sparql');
INSERT INTO endpoint VALUES ('europeana', 'https://data.europa.eu/sparql');

--
-- Data for Name: namespace; Type: TABLE DATA; Schema: sparql; Owner: sparql
--

INSERT INTO namespace VALUES ('xml',      'http://www.w3.org/XML/1998/namespace');
INSERT INTO namespace VALUES ('xhtml',    'http://www.w3.org/1999/xhtml');
INSERT INTO namespace VALUES ('xlink',    'http://www.w3.org/1999/xlink/');
INSERT INTO namespace VALUES ('rdf',      'http://www.w3.org/1999/02/22-rdf-syntax-ns#');
INSERT INTO namespace VALUES ('rdfs',     'http://www.w3.org/2000/01/rdf-schema#');
INSERT INTO namespace VALUES ('xsd',      'http://www.w3.org/2001/XMLSchema#');
INSERT INTO namespace VALUES ('xsi',      'http://www.w3.org/2001/XMLSchema-instance');
INSERT INTO namespace VALUES ('owl',      'http://www.w3.org/2002/07/owl#');
INSERT INTO namespace VALUES ('ical',     'http://www.w3.org/2002/12/cal/icaltzd#');
INSERT INTO namespace VALUES ('skos',     'http://www.w3.org/2004/02/skos/core#');
INSERT INTO namespace VALUES ('results',  'http://www.w3.org/2005/sparql-results#');
INSERT INTO namespace VALUES ('vcard',    'http://www.w3.org/2006/vcard/ns#');
INSERT INTO namespace VALUES ('dcat',     'http://www.w3.org/tr/vocab-dcat/');
INSERT INTO namespace VALUES ('schema',   'http://schema.org/');
INSERT INTO namespace VALUES ('foaf',     'http://xmlns.com/foaf/0.1/');
INSERT INTO namespace VALUES ('dc',       'http://purl.org/dc/elements/1.1/');
INSERT INTO namespace VALUES ('dcterms',  'http://purl.org/dc/terms/');
INSERT INTO namespace VALUES ('dbp',      'http://dbpedia.org/property/');
INSERT INTO namespace VALUES ('dbo',      'http://dbpedia.org/ontology/');
INSERT INTO namespace VALUES ('dbr',      'http://dbpedia.org/resource/');
INSERT INTO namespace VALUES ('ese',      'http://www.europeana.eu/schemas/ese/');
INSERT INTO namespace VALUES ('edm',      'http://www.europeana.eu/schemas/edm/');
INSERT INTO namespace VALUES ('oai',      'http://www.openarchives.org/OAI/2.0/');
INSERT INTO namespace VALUES ('oai_dc',   'http://www.openarchives.org/OAI/2.0/oai_dc/');
INSERT INTO namespace VALUES ('ore',      'http://www.openarchives.org/ore/terms/');


-- more obscure items

INSERT INTO namespace VALUES ('NC', 'http://home.netscape.com/NC-rdf#');
INSERT INTO namespace VALUES ('NS0', 'http://www.daml.org/2002/02/telephone/1/areacodes-ont#');
INSERT INTO namespace VALUES ('a1', 'http://protege.stanford.edu/system#');
INSERT INTO namespace VALUES ('a2', 'http://www.cogsci.princeton.edu/~wn/concept#');
INSERT INTO namespace VALUES ('admin', 'http://webns.net/mvcb/');
INSERT INTO namespace VALUES ('ag', 'http://purl.org/rss/1.0/modules/aggregation/');
INSERT INTO namespace VALUES ('air', 'http://www.megginson.com/exp/ns/airports#');
INSERT INTO namespace VALUES ('ajft', 'http://ajft.org/foaf.rdf#');
INSERT INTO namespace VALUES ('an2', 'http://rdf.desire.org/vocab/recommend.rdf#');
INSERT INTO namespace VALUES ('annotate', 'http://purl.org/rss/1.0/modules/annotate/');
INSERT INTO namespace VALUES ('app', 'http://example.com/app#');
INSERT INTO namespace VALUES ('assert', 'http://ebiquity.umbc.edu/ontology/assertion.owl#');
INSERT INTO namespace VALUES ('assoc', 'http://ebiquity.umbc.edu/ontology/association.owl#');
INSERT INTO namespace VALUES ('at', 'http://www.sixapart.com/ns/at');
INSERT INTO namespace VALUES ('attribute', 'http://wiki.ontoworld.org/index.php/_Attribute-3A');
INSERT INTO namespace VALUES ('b', 'http://www.cogsci.princeton.edu/~wn/schema/');
INSERT INTO namespace VALUES ('base', 'http://www.aktors.org/ontology/base#');
INSERT INTO namespace VALUES ('bbc', 'http://bbc.co.uk/ns#');
INSERT INTO namespace VALUES ('bio', 'http://purl.org/vocab/bio/0.1/');
INSERT INTO namespace VALUES ('bk', 'http://www.hackcraft.net/bookrdf/vocab/0_1/');
INSERT INTO namespace VALUES ('blogChannel', 'http://backend.userland.com/blogChannelModule');
INSERT INTO namespace VALUES ('bulkfeeds', 'http://bulkfeeds.net/xmlns#');
INSERT INTO namespace VALUES ('bz', 'http://bitzi.com/xmlns/2002/01/bz-core#');
INSERT INTO namespace VALUES ('canon', 'http://nwalsh.com/rdf/exif-canon#');
INSERT INTO namespace VALUES ('cap', 'http://impressive.net/people/gerald/2001/captivate-ns#');
INSERT INTO namespace VALUES ('card', 'http://person.org/BusinessCard/');
INSERT INTO namespace VALUES ('cc', 'http://web.resource.org/cc/');
INSERT INTO namespace VALUES ('ccpp', 'http://www.w3.org/2000/07/04-ccpp#');
INSERT INTO namespace VALUES ('ccpp2', 'http://www.w3.org/2002/11/08-ccpp-schema#');
INSERT INTO namespace VALUES ('chefmoz', 'http://chefmoz.org/rdf/elements/1.0/');
INSERT INTO namespace VALUES ('chrome', 'http://www.mozilla.org/rdf/chrome#');
INSERT INTO namespace VALUES ('cld', 'http://www.ukoln.ac.uk/metadata/rslp/1.0/');
INSERT INTO namespace VALUES ('clique', 'http://russell.rucus.net/2004/clique/#');
INSERT INTO namespace VALUES ('cmet', 'http://veggente.berlios.de/ns/RIM_CMET#');
INSERT INTO namespace VALUES ('co', 'http://purl.org/rss/1.0/modules/company/');
INSERT INTO namespace VALUES ('conf', 'http://www.mindswap.org/2004/www04photo.owl#');
INSERT INTO namespace VALUES ('confoto', 'http://www.confoto.org/ns/confoto#');
INSERT INTO namespace VALUES ('contact2', 'http://ebiquity.umbc.edu/ontology/contact.owl#');
INSERT INTO namespace VALUES ('content', 'http://purl.org/rss/1.0/modules/content/');
INSERT INTO namespace VALUES ('cvs', 'http://nwalsh.com/rdf/cvs#');
INSERT INTO namespace VALUES ('cyc', 'http://opencyc.sourceforge.net/daml/cyc.daml#');
INSERT INTO namespace VALUES ('daml2', 'http://www.daml.org/2000/10/daml-ont#');
INSERT INTO namespace VALUES ('date', 'java:java.util.Date');
INSERT INTO namespace VALUES ('dc10', 'http://purl.org/dc/elements/1.0/');
INSERT INTO namespace VALUES ('dcq1', 'http://dublincore.org/2000/03/13/dcq#');
INSERT INTO namespace VALUES ('dcq', 'http://purl.org/dc/qualifiers/1.0/');
INSERT INTO namespace VALUES ('dct', 'http://dublincore.org/2000/03/13-dctype');
INSERT INTO namespace VALUES ('dctype1', 'http://dublincore.org/2003/12/08/dctype#');
INSERT INTO namespace VALUES ('dctype', 'http://purl.org/dc/dcmitype/');
INSERT INTO namespace VALUES ('doap2', 'http://usefulinc.com/ns/doap/#');
INSERT INTO namespace VALUES ('doc', 'http://www.w3.org/2000/10/swap/pim/doc#');
INSERT INTO namespace VALUES ('e', 'http://eulersharp.sourceforge.net/2003/03swap/log-rules#');
INSERT INTO namespace VALUES ('ecademy', 'http://www.ecademy.com/namespace/');
INSERT INTO namespace VALUES ('eg',  'http://example.org/');
INSERT INTO namespace VALUES ('enc', 'http://purl.oclc.org/net/rss_2.0/enc#');
INSERT INTO namespace VALUES ('ent', 'http://jena.hpl.hp.com/ENT/1.0/#');
INSERT INTO namespace VALUES ('eor', 'http://dublincore.org/2000/03/13/eor#');
INSERT INTO namespace VALUES ('ethan', 'http://spire.umbc.edu/ontologies/ethan.owl#');
INSERT INTO namespace VALUES ('ev', 'http://purl.org/rss/1.0/modules/event/');
INSERT INTO namespace VALUES ('event', 'http://ebiquity.umbc.edu/ontology/event.owl#');
INSERT INTO namespace VALUES ('ex1', 'http://example.org/stuff/1.0/');
INSERT INTO namespace VALUES ('ex', 'http://www.example.com/schema#');
INSERT INTO namespace VALUES ('exif4', 'http://impressive.net/people/gerald/2001/exif#');
INSERT INTO namespace VALUES ('exif3', 'http://nwalsh.com/rdf/exif#');
INSERT INTO namespace VALUES ('exif2', 'http://www.kanzaki.com/ns/exif#');
INSERT INTO namespace VALUES ('exifgps', 'http://nwalsh.com/rdf/exif-gps#');
INSERT INTO namespace VALUES ('exifi', 'http://nwalsh.com/rdf/exif-intrinsic#');
INSERT INTO namespace VALUES ('feedburner', 'http://rssnamespace.org/feedburner/ext/1.0');
INSERT INTO namespace VALUES ('file', 'http://www.w3.org/2000/10/swap/pim/file#');
INSERT INTO namespace VALUES ('flair', 'http://simile.mit.edu/2005/04/flair#');
INSERT INTO namespace VALUES ('fotonotes', 'http://fotonotes.net/rdf/fotonotes-schema#');
INSERT INTO namespace VALUES ('g', 'http://www.w3.org/2001/02pd/gv#');
INSERT INTO namespace VALUES ('gal', 'http://norman.walsh.name/rdf/gallery#');
INSERT INTO namespace VALUES ('geoinsee', 'http://rdf.insee.fr/geo/');
INSERT INTO namespace VALUES ('geo', 'http://www.w3.org/2003/01/geo/wgs84_pos#');
INSERT INTO namespace VALUES ('gps', 'http://hackdiary.com/ns/gps#');
INSERT INTO namespace VALUES ('gump', 'http://gump.apache.org/schemas/main/1.0/');
INSERT INTO namespace VALUES ('hl7', 'urn:hl7-org:v3/mif');
INSERT INTO namespace VALUES ('http', 'http://www.w3.org/1999/xx/http#');
INSERT INTO namespace VALUES ('iX', 'http://ns.adobe.com/iX/1.0/');
INSERT INTO namespace VALUES ('ical1', 'http://www.w3.org/2002/12/cal/#');
INSERT INTO namespace VALUES ('image', 'http://jibbering.com/vocabs/image/#');
INSERT INTO namespace VALUES ('img1', 'http://igargoyle.com/rss/1.0/modules/img/');
INSERT INTO namespace VALUES ('img2', 'http://jibbering.com/2002/3/svg/#');
INSERT INTO namespace VALUES ('imreg', 'http://www.w3.org/2004/02/image-regions#');
INSERT INTO namespace VALUES ('iw', 'http://inferenceweb.stanford.edu/2004/07/iw.owl#');
INSERT INTO namespace VALUES ('iwip', 'http://www.iwi-iuk.org/material/RDF/Schema/Property/iwip#');
INSERT INTO namespace VALUES ('jms', 'http://jena.hpl.hp.com/2003/08/jms#');
INSERT INTO namespace VALUES ('jpegrdf', 'http://nwalsh.com/rdf/jpegrdf#');
INSERT INTO namespace VALUES ('keyword', 'http://animaldiversity.ummz.umich.edu/local/keywords/keywords.owl#');
INSERT INTO namespace VALUES ('ethan_kw', 'http://spire.umbc.edu/ontologies/ethan_keywords.owl#');
INSERT INTO namespace VALUES ('l', 'http://purl.org/rss/1.0/modules/link/');
INSERT INTO namespace VALUES ('lang', 'http://purl.org/net/inkel/rdf/schemas/lang/1.1#');
INSERT INTO namespace VALUES ('marc', 'http://www.loc.gov/marc/relators/');
INSERT INTO namespace VALUES ('mat', 'http://www.w3.org/2002/05/matrix/vocab#');
INSERT INTO namespace VALUES ('math', 'http://www.w3.org/2000/10/swap/math#');
INSERT INTO namespace VALUES ('mathind', 'http://www.math.org/#');
INSERT INTO namespace VALUES ('mcc', 'http://mutemap.openmute.org/2003/mcc#');
INSERT INTO namespace VALUES ('mesh', 'http://www.nlm.nih.gov/mesh/2004#');
INSERT INTO namespace VALUES ('mindswap', 'http://www.mindswap.org/2003/owl/mindswap#');
INSERT INTO namespace VALUES ('mindswap-projects', 'http://www.mindswap.org/2004/owl/mindswap-projects#');
INSERT INTO namespace VALUES ('mindswappers', 'http://www.mindswap.org/2004/owl/mindswappers#');
INSERT INTO namespace VALUES ('mm20', 'http://musicbrainz.org/mm/mm-2.0#');
INSERT INTO namespace VALUES ('mm21', 'http://musicbrainz.org/mm/mm-2.1#');
INSERT INTO namespace VALUES ('mms', 'http://www.openmobilealliance.org/tech/profiles/MMS/ccppschema-20050301-MMS1.2#');
INSERT INTO namespace VALUES ('mmswap', 'http://www.wapforum.org/profiles/MMS/ccppschema-20010111#');
INSERT INTO namespace VALUES ('mnp', 'http://www.iwi-iuk.org/material/RDF/1.1/Schema/Property/mnp#');
INSERT INTO namespace VALUES ('mnst', 'http://www.iwi-iuk.org/material/RDF/1.1/descriptor/#');
INSERT INTO namespace VALUES ('moblog', 'http://kaywa.com/rss/modules/moblog/');
INSERT INTO namespace VALUES ('modwiki', 'http://www.usemod.com/cgi-bin/mb.pl?ModWiki');
INSERT INTO namespace VALUES ('mp', 'http://www.mutopiaproject.org/piece-data/0.1/');
INSERT INTO namespace VALUES ('mu', 'http://storymill.com/mu/2005/03/');
INSERT INTO namespace VALUES ('neg', 'http://www.inrialpes.fr/opera/people/Tayeb.Lemlouma/NegotiationSchema/ClientProfileSchema-03012002#');
INSERT INTO namespace VALUES ('news', 'http://www.nature.com/schema/2004/05/news#');
INSERT INTO namespace VALUES ('nhet', 'http://spire.umbc.edu/ontologies/nhet.owl#');
INSERT INTO namespace VALUES ('nikon', 'http://nwalsh.com/rdf/exif-nikon5700#');
INSERT INTO namespace VALUES ('nikon950', 'http://nwalsh.com/rdf/exif-nikon950#');
INSERT INTO namespace VALUES ('nines', 'http://www.nines.org/schema#');
INSERT INTO namespace VALUES ('nlo', 'http://nulllogicone.net/schema.rdfs#');
INSERT INTO namespace VALUES ('nwn-what', 'http://norman.walsh.name/knows/what#');
INSERT INTO namespace VALUES ('nwn-where', 'http://norman.walsh.name/knows/where#');
INSERT INTO namespace VALUES ('nwn-who', 'http://norman.walsh.name/knows/who#');
INSERT INTO namespace VALUES ('oiled', 'http://img.cs.man.ac.uk/oil/oiled#');
INSERT INTO namespace VALUES ('ontosem', 'http://morpheus.cs.umbc.edu/aks1/ontosem.owl#');
INSERT INTO namespace VALUES ('ontoware', 'http://swrc.ontoware.org/ontology/ontoware#');
INSERT INTO namespace VALUES ('org', 'http://www.w3.org/2001/04/roadmap/org#');
INSERT INTO namespace VALUES ('os', 'http://downlode.org/rdf/os/0.1/');
INSERT INTO namespace VALUES ('p', 'http://www.usefulinc.com/picdiary/');
INSERT INTO namespace VALUES ('p0', 'http://eulersharp.sourceforge.net/2003/03swap/xsd-rules#');
INSERT INTO namespace VALUES ('p1', 'http://eulersharp.sourceforge.net/2003/03swap/rdfs-rules#');
INSERT INTO namespace VALUES ('person', 'http://ebiquity.umbc.edu/ontology/person.owl#');
INSERT INTO namespace VALUES ('pm', 'http://mindswap.org/2005/owl/photomesa#');
INSERT INTO namespace VALUES ('prf', 'http://www.openmobilealliance.org/tech/profiles/UAPROF/ccppschema-20021212#');
INSERT INTO namespace VALUES ('prfwap', 'http://www.wapforum.org/profiles/UAPROF/ccppschema-20010430#');
INSERT INTO namespace VALUES ('prism', 'http://prismstandard.org/namespaces/1.2/basic/');
INSERT INTO namespace VALUES ('process10', 'http://www.daml.org/services/owl-s/1.0/Process.owl#');
INSERT INTO namespace VALUES ('process11', 'http://www.daml.org/services/owl-s/1.1/Process.owl#');
INSERT INTO namespace VALUES ('profile', 'http://www.daml.org/services/owl-s/1.0/Profile.owl#');
INSERT INTO namespace VALUES ('project', 'http://ebiquity.umbc.edu/ontology/project.owl#');
INSERT INTO namespace VALUES ('project2', 'http://www.mindswap.org/2003/owl/project#');
INSERT INTO namespace VALUES ('protege', 'http://protege.stanford.edu/plugins/owl/protege#');
INSERT INTO namespace VALUES ('pub', 'http://ebiquity.umbc.edu/ontology/publication.owl#');
INSERT INTO namespace VALUES ('q', 'http://www.w3.org/2004/ql#');
INSERT INTO namespace VALUES ('ra', 'http://www.rossettiarchive.org/schema#');
INSERT INTO namespace VALUES ('random', 'http://random.ioctl.org/#');
INSERT INTO namespace VALUES ('rcs', 'http://www.w3.org/2001/03swell/rcs#');
INSERT INTO namespace VALUES ('rec', 'http://www.w3.org/2001/02pd/rec54#');
INSERT INTO namespace VALUES ('ref', 'http://purl.org/rss/1.0/modules/reference/');
INSERT INTO namespace VALUES ('rel', 'http://purl.org/vocab/relationship/');
INSERT INTO namespace VALUES ('relation', 'http://wiki.ontoworld.org/index.php/_Relation-3A');
INSERT INTO namespace VALUES ('research', 'http://ebiquity.umbc.edu/ontology/research.owl#');
INSERT INTO namespace VALUES ('rim_dt', 'http://veggente.berlios.de/ns/RIMDatatype#');
INSERT INTO namespace VALUES ('role', 'http://www.loc.gov/loc.terms/relators/');
INSERT INTO namespace VALUES ('rs', 'http://www.w3.org/2001/sw/DataAccess/tests/result-set#');
INSERT INTO namespace VALUES ('rss2', 'http://backend.userland.com/RSS2#');
INSERT INTO namespace VALUES ('rss1', 'http://purl.org/rss/1.0/');
INSERT INTO namespace VALUES ('s', 'http://snipsnap.org/rdf/snip-schema#');
INSERT INTO namespace VALUES ('schemaweb', 'http://www.schemaweb.info/schemas/meta/rdf/');
INSERT INTO namespace VALUES ('s0', 'http://www.w3.org/2000/PhotoRDF/dc-1-0#');
INSERT INTO namespace VALUES ('s1', 'http://sophia.inria.fr/~enerbonn/rdfpiclang#');
INSERT INTO namespace VALUES ('se', 'http://www.w3.org/2004/02/skos/extensions#');
INSERT INTO namespace VALUES ('semblog', 'http://www.semblog.org/ns/semblog/0.1/');
INSERT INTO namespace VALUES ('service', 'http://www.daml.org/services/owl-s/1.0/Service.owl#');
INSERT INTO namespace VALUES ('signage', 'http://www.aktors.org/ontology/signage#');
INSERT INTO namespace VALUES ('slash', 'http://purl.org/rss/1.0/modules/slash/');
INSERT INTO namespace VALUES ('smw', 'http://smw.ontoware.org/2005/smw#');
INSERT INTO namespace VALUES ('space', 'http://frot.org/space/0.1/');
INSERT INTO namespace VALUES ('spi', 'http://www.trustix.net/schema/rdf/spi-0.0.1#');
INSERT INTO namespace VALUES ('str', 'http://www.w3.org/2000/10/swap/string#');
INSERT INTO namespace VALUES ('support', 'http://www.aktors.org/ontology/support#');
INSERT INTO namespace VALUES ('svgr', 'http://www.w3.org/2001/svgRdf/axsvg-schema.rdf#');
INSERT INTO namespace VALUES ('swrl', 'http://www.w3.org/2003/11/swrl#');
INSERT INTO namespace VALUES ('sy', 'http://purl.org/rss/1.0/modules/syndication/');
INSERT INTO namespace VALUES ('sy0', 'http://purl.org/rss/modules/syndication/');
INSERT INTO namespace VALUES ('tax', 'http://semweb.mcdonaldbradley.com/OWL/TaxonomyMapping/Definitions/TaxonomySupport.owl#');
INSERT INTO namespace VALUES ('taxo', 'http://purl.org/rss/1.0/modules/taxonomy/');
INSERT INTO namespace VALUES ('template', 'http://redfoot.net/2005/template#');
INSERT INTO namespace VALUES ('terms', 'http://jibbering.com/2002/6/terms#');
INSERT INTO namespace VALUES ('thes', 'http://reports.eea.eu.int/EEAIndexTerms/ThesaurusSchema.rdf#');
INSERT INTO namespace VALUES ('thing', 'http://wiki.ontoworld.org/index.php/_');
INSERT INTO namespace VALUES ('ti', 'http://purl.org/rss/1.0/modules/textinput/');
INSERT INTO namespace VALUES ('tif', 'http://www.limber.rl.ac.uk/External/thesaurus-iso.rdf#');
INSERT INTO namespace VALUES ('trackback', 'http://madskills.com/public/xml/rss/module/trackback/');
INSERT INTO namespace VALUES ('trust', 'http://trust.mindswap.org/ont/trust.owl#');
INSERT INTO namespace VALUES ('units', 'http://visus.mit.edu/fontomri/0.01/units.owl#');
INSERT INTO namespace VALUES ('ure', 'http://medea.mpiwg-berlin.mpg.de/ure/vocab#');
INSERT INTO namespace VALUES ('urfm', 'http://purl.org/urfm/');
INSERT INTO namespace VALUES ('uri', 'http://www.w3.org/2000/07/uri43/uri.xsl?template=');
INSERT INTO namespace VALUES ('vCard', 'http://www.w3.org/2001/vcard-rdf/3.0#');
INSERT INTO namespace VALUES ('vann', 'http://purl.org/vocab/vann/');
INSERT INTO namespace VALUES ('vlma', 'http://medea.mpiwg-berlin.mpg.de/vlma/vocab#');
INSERT INTO namespace VALUES ('vra', 'http://www.swi.psy.uva.nl/mia/vra#');
INSERT INTO namespace VALUES ('vs', 'http://www.w3.org/2003/06/sw-vocab-status/ns#');
INSERT INTO namespace VALUES ('wfw', 'http://wellformedweb.org/CommentAPI/');
INSERT INTO namespace VALUES ('wiki', 'http://purl.org/rss/1.0/modules/wiki/');
INSERT INTO namespace VALUES ('wikiped', 'http://en.wikipedia.org/wiki/');
INSERT INTO namespace VALUES ('wn', 'http://xmlns.com/wordnet/1.6/');
INSERT INTO namespace VALUES ('wot', 'http://xmlns.com/wot/0.1/');
INSERT INTO namespace VALUES ('x', 'http://www.softwarestudio.org/libical/UsingLibical/node49.html#');
INSERT INTO namespace VALUES ('xfn', 'http://gmpg.org/xfn/1#');
INSERT INTO namespace VALUES ('prov', 'http://www.w3.org/ns/prov#');
INSERT INTO namespace VALUES ('m3c', 'http://www.m3c.si/xmlns/m3c/2006-06#');
INSERT INTO namespace VALUES ('akt', 'http://www.aktors.org/ontology/portal#');
INSERT INTO namespace VALUES ('an', 'http://www.w3.org/2000/10/annotation-ns#');
INSERT INTO namespace VALUES ('bib', 'http://www.isi.edu/webscripter/bibtex.o.daml#');
INSERT INTO namespace VALUES ('conf2', 'http://www.mindswap.org/~golbeck/web/www04photo.owl#');
INSERT INTO namespace VALUES ('contact', 'http://www.w3.org/2000/10/swap/pim/contact#');
INSERT INTO namespace VALUES ('daml', 'http://www.daml.org/2001/03/daml+oil#');
INSERT INTO namespace VALUES ('doa', 'http://www.daml.org/2001/10/html/airport-ont#');
INSERT INTO namespace VALUES ('doap', 'http://usefulinc.com/ns/doap#');
INSERT INTO namespace VALUES ('exif', 'http://www.w3.org/2000/10/swap/pim/exif#');
INSERT INTO namespace VALUES ('georss', 'http://www.georss.org/georss/');
INSERT INTO namespace VALUES ('ical2', 'http://www.w3.org/2002/12/cal/ical#');
INSERT INTO namespace VALUES ('iwi', 'http://www.iwi-iuk.org/material/RDF/Schema/Class/iwi#');
INSERT INTO namespace VALUES ('log', 'http://www.w3.org/2000/10/swap/log#');
INSERT INTO namespace VALUES ('midesc', 'http://www.iwi-iuk.org/material/RDF/Schema/Descriptor/midesc#');
INSERT INTO namespace VALUES ('rssmn', 'http://usefulinc.com/rss/manifest/');
INSERT INTO namespace VALUES ('mn', 'http://www.iwi-iuk.org/material/RDF/1.1/Schema/Class/mn#');
INSERT INTO namespace VALUES ('otest', 'http://www.w3.org/2002/03owlt/testOntology#');
INSERT INTO namespace VALUES ('rev', 'http://www.purl.org/stuff/rev#');
INSERT INTO namespace VALUES ('rtest', 'http://www.w3.org/2000/10/rdf-tests/rdfcore/testSchema#');
INSERT INTO namespace VALUES ('sioc', 'http://rdfs.org/sioc/ns#');
INSERT INTO namespace VALUES ('swrc', 'http://swrc.ontoware.org/ontology#');
INSERT INTO namespace VALUES ('swivt', 'http://semantic-mediawiki.org/swivt/1.0#');
INSERT INTO namespace VALUES ('csi', 'http://culture.si/en/Special:URIResolver/');

--
-- Name: config_pkey; Type: CONSTRAINT; Schema: sparql; Owner: sparql; Tablespace: 
--

ALTER TABLE ONLY config
    ADD CONSTRAINT config_pkey PRIMARY KEY (name);


--
-- Name: endpoint_pkey; Type: CONSTRAINT; Schema: sparql; Owner: sparql; Tablespace: 
--

ALTER TABLE ONLY endpoint
    ADD CONSTRAINT endpoint_pkey PRIMARY KEY (name);