Select Git revision
dask-testing.ipynb
1_setup-schema.sql 22.08 KiB
BEGIN;
CREATE TABLE IF NOT EXISTS `mdb_users`
(
id character varying(36) NOT NULL,
username character varying(255) NOT NULL,
firstname character varying(255),
lastname character varying(255),
email character varying(255) NOT NULL,
orcid character varying(255),
affiliation character varying(255),
mariadb_password character varying(255) NOT NULL,
theme character varying(255) NOT NULL default ('light'),
language character varying(3) NOT NULL default ('en'),
PRIMARY KEY (id),
UNIQUE (username),
UNIQUE (email)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_images`
(
id bigint NOT NULL AUTO_INCREMENT,
registry character varying(255) NOT NULL DEFAULT 'docker.io',
name character varying(255) NOT NULL,
version character varying(255) NOT NULL,
default_port integer NOT NULL,
dialect character varying(255) NOT NULL,
driver_class character varying(255) NOT NULL,
jdbc_method character varying(255) NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
last_modified timestamp,
PRIMARY KEY (id),
UNIQUE (name, version)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_images_date`
(
id bigint NOT NULL AUTO_INCREMENT,
iid bigint NOT NULL,
database_format character varying(255) NOT NULL,
unix_format character varying(255) NOT NULL,
example character varying(255) NOT NULL,
has_time boolean NOT NULL,
created_at timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (id),
FOREIGN KEY (iid) REFERENCES mdb_images (id),
UNIQUE (database_format, unix_format, example)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_containers`
(
id bigint NOT NULL AUTO_INCREMENT,
internal_name character varying(255) NOT NULL,
name character varying(255) NOT NULL,
host character varying(255) NOT NULL,
port integer NOT NULL default 3306,
ui_host character varying(255) NOT NULL default host,
ui_port integer NOT NULL default port,
ui_additional_flags text,
sidecar_host character varying(255),
sidecar_port integer,
image_id bigint NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
last_modified timestamp,
privileged_username character varying(255) NOT NULL,
privileged_password character varying(255) NOT NULL,
quota integer NOT NULL DEFAULT 50,
PRIMARY KEY (id),
FOREIGN KEY (image_id) REFERENCES mdb_images (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_data`
(
ID bigint NOT NULL AUTO_INCREMENT,
PROVENANCE text,
FileEncoding text,
FileType character varying(100),
Version text,
Seperator text,
PRIMARY KEY (ID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_licenses`
(
identifier character varying(255) NOT NULL,
uri text NOT NULL,
description text NOT NULL,
PRIMARY KEY (identifier),
UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_databases`
(
id bigint NOT NULL AUTO_INCREMENT,
cid bigint NOT NULL,
name character varying(255) NOT NULL,
internal_name character varying(255) NOT NULL,
exchange_name character varying(255) NOT NULL,
description text,
engine character varying(20),
is_public boolean NOT NULL DEFAULT TRUE,
image longblob,
created_by character varying(36),
owned_by character varying(36),
contact_person character varying(36),
created timestamp NOT NULL DEFAULT NOW(),
last_modified timestamp,
PRIMARY KEY (id),
FOREIGN KEY (cid) REFERENCES mdb_containers (id) /* currently we only support one-to-one */,
FOREIGN KEY (created_by) REFERENCES mdb_users (id),
FOREIGN KEY (owned_by) REFERENCES mdb_users (id),
FOREIGN KEY (contact_person) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_databases_subjects`
(
dbid BIGINT NOT NULL,
subjects character varying(255) NOT NULL,
PRIMARY KEY (dbid, subjects)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_tables`
(
ID bigint NOT NULL AUTO_INCREMENT,
tDBID bigint NOT NULL,
tName VARCHAR(64) NOT NULL,
internal_name VARCHAR(64) NOT NULL,
queue_name VARCHAR(255) NOT NULL,
routing_key VARCHAR(255),
tDescription VARCHAR(2048),
num_rows BIGINT,
data_length BIGINT,
max_data_length BIGINT,
avg_row_length BIGINT,
`separator` CHAR(1),
quote CHAR(1),
element_null VARCHAR(50),
skip_lines BIGINT,
element_true VARCHAR(50),
element_false VARCHAR(50),
Version TEXT,
created timestamp NOT NULL DEFAULT NOW(),
versioned boolean not null default true,
created_by character varying(36) NOT NULL,
owned_by character varying(36) NOT NULL,
last_modified timestamp,
PRIMARY KEY (ID),
UNIQUE (tDBID, internal_name),
FOREIGN KEY (tDBID) REFERENCES mdb_databases (id),
FOREIGN KEY (created_by) REFERENCES mdb_users (id),
FOREIGN KEY (owned_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns`
(
ID BIGINT NOT NULL AUTO_INCREMENT,
tID BIGINT NOT NULL,
dfID BIGINT,
cName VARCHAR(64),
internal_name VARCHAR(64) NOT NULL,
Datatype ENUM ('CHAR','VARCHAR','BINARY','VARBINARY','TINYBLOB','TINYTEXT','TEXT','BLOB','MEDIUMTEXT','MEDIUMBLOB','LONGTEXT','LONGBLOB','ENUM','SET','BIT','TINYINT','BOOL','SMALLINT','MEDIUMINT','INT','BIGINT','FLOAT','DOUBLE','DECIMAL','DATE','DATETIME','TIMESTAMP','TIME','YEAR'),
length BIGINT NULL,
ordinal_position INTEGER NOT NULL,
index_length BIGINT NULL,
description VARCHAR(2048),
size BIGINT,
d BIGINT,
auto_generated BOOLEAN DEFAULT false,
is_null_allowed BOOLEAN NOT NULL DEFAULT true,
val_min NUMERIC NULL,
val_max NUMERIC NULL,
mean NUMERIC NULL,
median NUMERIC NULL,
std_dev Numeric NULL,
created timestamp NOT NULL DEFAULT NOW(),
last_modified timestamp,
FOREIGN KEY (tID) REFERENCES mdb_tables (ID) ON DELETE CASCADE,
PRIMARY KEY (ID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_enums`
(
id bigint NOT NULL AUTO_INCREMENT,
column_id bigint NOT NULL,
value CHARACTER VARYING(255) NOT NULL,
FOREIGN KEY (column_id) REFERENCES mdb_columns (ID) ON DELETE CASCADE,
PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_sets`
(
id bigint NOT NULL AUTO_INCREMENT,
column_id bigint NOT NULL,
value CHARACTER VARYING(255) NOT NULL,
FOREIGN KEY (column_id) REFERENCES mdb_columns (ID) ON DELETE CASCADE,
PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_nom`
(
tID bigint,
cID bigint,
maxlength INTEGER,
last_modified timestamp,
created timestamp NOT NULL DEFAULT NOW(),
FOREIGN KEY (tID, cID) REFERENCES mdb_columns (tID, ID),
PRIMARY KEY (tID, cID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_cat`
(
tID bigint,
cID bigint,
num_cat INTEGER,
-- cat_array TEXT[],
last_modified timestamp,
created timestamp NOT NULL DEFAULT NOW(),
FOREIGN KEY (tID, cID) REFERENCES mdb_columns (tID, ID),
PRIMARY KEY (tID, cID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_constraints_foreign_key`
(
fkid BIGINT NOT NULL AUTO_INCREMENT,
tid BIGINT NOT NULL,
rtid BIGINT NOT NULL,
name VARCHAR(255) NOT NULL,
on_update VARCHAR(50) NULL,
on_delete VARCHAR(50) NULL,
position INT NULL,
PRIMARY KEY (fkid),
FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE,
FOREIGN KEY (rtid) REFERENCES mdb_tables (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_constraints_primary_key`
(
pkid BIGINT NOT NULL AUTO_INCREMENT,
tID BIGINT NOT NULL,
cid BIGINT NOT NULL,
PRIMARY KEY (pkid),
FOREIGN KEY (tID) REFERENCES mdb_tables (id) ON DELETE CASCADE,
FOREIGN KEY (cid) REFERENCES mdb_columns (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_constraints_foreign_key_reference`
(
id BIGINT NOT NULL AUTO_INCREMENT,
fkid BIGINT NOT NULL,
cid BIGINT NOT NULL,
rcid BIGINT NOT NULL,
PRIMARY KEY (id),
UNIQUE (fkid, cid, rcid),
FOREIGN KEY (fkid) REFERENCES mdb_constraints_foreign_key (fkid) ON UPDATE CASCADE,
FOREIGN KEY (cid) REFERENCES mdb_columns (id),
FOREIGN KEY (rcid) REFERENCES mdb_columns (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_constraints_unique`
(
uid BIGINT NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
tid BIGINT NOT NULL,
position INT NULL,
PRIMARY KEY (uid),
FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS `mdb_constraints_unique_columns`
(
id BIGINT NOT NULL AUTO_INCREMENT,
uid BIGINT NOT NULL,
cid BIGINT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (uid) REFERENCES mdb_constraints_unique (uid),
FOREIGN KEY (cid) REFERENCES mdb_columns (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_constraints_checks`
(
id BIGINT NOT NULL AUTO_INCREMENT,
tid BIGINT NOT NULL,
checks VARCHAR(255) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_concepts`
(
id bigint NOT NULL AUTO_INCREMENT,
uri text not null,
name VARCHAR(255) null,
description TEXT null,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (id),
UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_units`
(
id bigint NOT NULL AUTO_INCREMENT,
uri text not null,
name VARCHAR(255) null,
description TEXT null,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (id),
UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_concepts`
(
id bigint NOT NULL,
cID bigint NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (id, cid),
FOREIGN KEY (cID) REFERENCES mdb_columns (ID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_columns_units`
(
id bigint NOT NULL,
cID bigint NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (id, cID),
FOREIGN KEY (cID) REFERENCES mdb_columns (ID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_view`
(
id bigint NOT NULL AUTO_INCREMENT,
vdbid bigint NOT NULL,
vName VARCHAR(64) NOT NULL,
internal_name VARCHAR(64) NOT NULL,
Query TEXT NOT NULL,
query_hash VARCHAR(255) NOT NULL,
Public BOOLEAN NOT NULL,
InitialView BOOLEAN NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
last_modified timestamp,
created_by character varying(36) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (vdbid) REFERENCES mdb_databases (id),
FOREIGN KEY (created_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_banner_messages`
(
id bigint NOT NULL AUTO_INCREMENT,
type ENUM ('ERROR', 'WARNING', 'INFO') NOT NULL default 'INFO',
message TEXT NOT NULL,
link TEXT NULL,
link_text VARCHAR(255) NULL,
display_start timestamp NULL,
display_end timestamp NULL,
PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_ontologies`
(
id bigint NOT NULL AUTO_INCREMENT,
prefix VARCHAR(8) NOT NULL,
uri TEXT NOT NULL,
uri_pattern TEXT,
sparql_endpoint TEXT NULL,
rdf_path TEXT NULL,
last_modified timestamp,
created timestamp NOT NULL DEFAULT NOW(),
UNIQUE (prefix),
UNIQUE (uri(200)),
PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_view_columns`
(
id BIGINT NOT NULL AUTO_INCREMENT,
view_id BIGINT NOT NULL,
dfID BIGINT,
name VARCHAR(64),
internal_name VARCHAR(64) NOT NULL,
column_type ENUM ('CHAR','VARCHAR','BINARY','VARBINARY','TINYBLOB','TINYTEXT','TEXT','BLOB','MEDIUMTEXT','MEDIUMBLOB','LONGTEXT','LONGBLOB','ENUM','SET','BIT','TINYINT','BOOL','SMALLINT','MEDIUMINT','INT','BIGINT','FLOAT','DOUBLE','DECIMAL','DATE','DATETIME','TIMESTAMP','TIME','YEAR'),
ordinal_position INTEGER NOT NULL,
size BIGINT,
d BIGINT,
auto_generated BOOLEAN DEFAULT false,
is_null_allowed BOOLEAN NOT NULL DEFAULT true,
PRIMARY KEY (id),
FOREIGN KEY (view_id) REFERENCES mdb_view (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifiers`
(
id BIGINT NOT NULL AUTO_INCREMENT,
dbid BIGINT NOT NULL,
qid BIGINT,
vid BIGINT,
tid BIGINT,
publisher VARCHAR(255) NOT NULL,
language VARCHAR(2),
publication_year INTEGER NOT NULL,
publication_month INTEGER,
publication_day INTEGER,
identifier_type ENUM ('DATABASE', 'SUBSET', 'VIEW', 'TABLE') NOT NULL,
status ENUM ('DRAFT', 'PUBLISHED') NOT NULL DEFAULT ('PUBLISHED'),
query TEXT,
query_normalized TEXT,
query_hash VARCHAR(255),
execution TIMESTAMP,
result_hash VARCHAR(255),
result_number BIGINT,
doi VARCHAR(255),
created TIMESTAMP NOT NULL DEFAULT NOW(),
created_by VARCHAR(36) NOT NULL,
last_modified TIMESTAMP,
PRIMARY KEY (id), /* must be a single id from persistent identifier concept */
FOREIGN KEY (dbid) REFERENCES mdb_databases (id),
FOREIGN KEY (created_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifier_licenses`
(
pid bigint NOT NULL,
license_id VARCHAR(255) NOT NULL,
PRIMARY KEY (pid, license_id),
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id),
FOREIGN KEY (license_id) REFERENCES mdb_licenses (identifier)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifier_titles`
(
id bigint NOT NULL AUTO_INCREMENT,
pid bigint NOT NULL,
title text NOT NULL,
title_type ENUM ('ALTERNATIVE_TITLE', 'SUBTITLE', 'TRANSLATED_TITLE', 'OTHER'),
language VARCHAR(2),
PRIMARY KEY (id),
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifier_funders`
(
id bigint NOT NULL AUTO_INCREMENT,
pid bigint NOT NULL,
funder_name VARCHAR(255) NOT NULL,
funder_identifier TEXT,
funder_identifier_type ENUM ('CROSSREF_FUNDER_ID', 'GRID', 'ISNI', 'ROR', 'OTHER'),
scheme_uri text,
award_number VARCHAR(255),
award_title text,
language VARCHAR(255),
PRIMARY KEY (id),
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifier_descriptions`
(
id bigint NOT NULL AUTO_INCREMENT,
pid bigint NOT NULL,
description text NOT NULL,
description_type ENUM ('ABSTRACT', 'METHODS', 'SERIES_INFORMATION', 'TABLE_OF_CONTENTS', 'TECHNICAL_INFO', 'OTHER'),
language VARCHAR(2),
PRIMARY KEY (id),
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_related_identifiers`
(
id bigint NOT NULL AUTO_INCREMENT,
pid bigint NOT NULL,
value varchar(255) NOT NULL,
type varchar(255) NOT NULL,
relation varchar(255) NOT NULL,
PRIMARY KEY (id), /* must be a single id from persistent identifier concept */
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id),
UNIQUE (pid, value)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_identifier_creators`
(
id bigint NOT NULL AUTO_INCREMENT,
pid bigint NOT NULL,
given_names text,
family_name text,
creator_name VARCHAR(255) NOT NULL,
name_type ENUM ('PERSONAL', 'ORGANIZATIONAL') default 'PERSONAL',
name_identifier text,
name_identifier_scheme ENUM ('ROR', 'GRID', 'ISNI', 'ORCID'),
name_identifier_scheme_uri text,
affiliation VARCHAR(255),
affiliation_identifier text,
affiliation_identifier_scheme ENUM ('ROR', 'GRID', 'ISNI'),
affiliation_identifier_scheme_uri text,
PRIMARY KEY (id),
FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_update`
(
uUserID character varying(255) NOT NULL,
uDBID bigint NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (uUserID, uDBID),
FOREIGN KEY (uDBID) REFERENCES mdb_databases (id)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_access`
(
aUserID character varying(255) NOT NULL,
aDBID bigint REFERENCES mdb_databases (id),
attime TIMESTAMP,
download BOOLEAN,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (aUserID, aDBID)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_have_access`
(
user_id character varying(36) NOT NULL,
database_id bigint REFERENCES mdb_databases (id),
access_type ENUM ('READ', 'WRITE_OWN', 'WRITE_ALL') NOT NULL,
created timestamp NOT NULL DEFAULT NOW(),
PRIMARY KEY (user_id, database_id),
FOREIGN KEY (user_id) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;
COMMIT;
BEGIN;
INSERT INTO `mdb_licenses` (identifier, uri, description)
VALUES ('CC0-1.0', 'https://creativecommons.org/publicdomain/zero/1.0/legalcode',
'CC0 waives copyright interest in a work you''ve created and dedicates it to the world-wide public domain. Use CC0 to opt out of copyright entirely and ensure your work has the widest reach.'),
('CC-BY-4.0', 'https://creativecommons.org/licenses/by/4.0/legalcode',
'The Creative Commons Attribution license allows re-distribution and re-use of a licensed work on the condition that the creator is appropriately credited.');
INSERT INTO `mdb_images` (name, registry, version, default_port, dialect, driver_class, jdbc_method)
VALUES ('mariadb', 'docker.io', '11.1.3', 3306, 'org.hibernate.dialect.MariaDBDialect', 'org.mariadb.jdbc.Driver',
'mariadb');
INSERT INTO `mdb_images_date` (iid, database_format, unix_format, example, has_time)
VALUES (1, '%Y-%c-%d %H:%i:%S.%f', 'yyyy-MM-dd HH:mm:ss.SSSSSS', '2022-01-30 13:44:25.499', true),
(1, '%Y-%c-%d %H:%i:%S', 'yyyy-MM-dd HH:mm:ss', '2022-01-30 13:44:25', true),
(1, '%Y-%c-%d', 'yyyy-MM-dd', '2022-01-30', false),
(1, '%H:%i:%S', 'HH:mm:ss', '13:44:25', true),
(1, '%d.%c.%Y', 'dd.MM.yyyy', '30.01.2022', false);
INSERT INTO `mdb_ontologies` (prefix, uri, uri_pattern, sparql_endpoint, rdf_path)
VALUES ('om', 'http://www.ontology-of-units-of-measure.org/resource/om-2/',
'http://www.ontology-of-units-of-measure.org/resource/om-2/.*', null, 'rdf/om-2.0.rdf'),
('wd', 'http://www.wikidata.org/', 'http://www.wikidata.org/entity/.*', 'https://query.wikidata.org/sparql',
null),
('mo', 'http://purl.org/ontology/mo/', 'http://purl.org/ontology/mo/.*', null, null),
('dc', 'http://purl.org/dc/elements/1.1/', null, null, null),
('xsd', 'http://www.w3.org/2001/XMLSchema#', null, null, null),
('tl', 'http://purl.org/NET/c4dm/timeline.owl#', null, null, null),
('foaf', 'http://xmlns.com/foaf/0.1/', null, null, null),
('schema', 'http://schema.org/', null, null, null),
('rdf', 'http://www.w3.org/1999/02/22-rdf-syntax-ns#', null, null, null),
('rdfs', 'http://www.w3.org/2000/01/rdf-schema#', null, null, null),
('owl', 'http://www.w3.org/2002/07/owl#', null, null, null),
('prov', 'http://www.w3.org/ns/prov#', null, null, null),
('db', 'http://dbpedia.org', 'http://dbpedia.org/ontology/.*', 'http://dbpedia.org/sparql', null);
COMMIT;