Server to collect DHT views from yggdrasil nodes and store in a data base
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

45 lines
1.2 KiB

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
CREATE SCHEMA public;
ALTER SCHEMA public OWNER TO postgres;
COMMENT ON SCHEMA public IS 'standard public schema';
SET default_tablespace = '';
SET default_with_oids = false;
CREATE TABLE public.timeseries (
max integer,
unixtstamp integer
);
ALTER TABLE public.timeseries OWNER TO yggindex;
CREATE TABLE public.yggindex (
ipv6 character varying(46),
coords character varying,
unixtstamp character varying(30),
name character varying
);
ALTER TABLE public.yggindex OWNER TO yggindex;
CREATE TABLE public.yggnodeinfo (
ipv6 character varying(46),
nodeinfo character varying,
"timestamp" character varying(12)
);
ALTER TABLE public.yggnodeinfo OWNER TO yggindex;
ALTER TABLE ONLY public.yggindex
ADD CONSTRAINT yggindex_ipv6_key UNIQUE (ipv6);
ALTER TABLE ONLY public.yggnodeinfo
ADD CONSTRAINT yggnodeinfo_ipv6_key UNIQUE (ipv6);