--
--

\restrict 9HcYvNEaOUmz2eDUIACBYZGasPiwJSUfsJyAMJhnwrKD5e5Gh7hQlRpWnXgQpTz


SELECT pg_catalog.set_config('search_path', '', false);

ALTER TABLE ONLY public.server_user DROP CONSTRAINT server_user_user_id_fkey;
ALTER TABLE ONLY public.server_user DROP CONSTRAINT server_user_server_id_fkey;
ALTER TABLE ONLY public.port_user DROP CONSTRAINT port_user_user_id_fkey;
ALTER TABLE ONLY public.port_user DROP CONSTRAINT port_user_port_id_fkey;
ALTER TABLE ONLY public.port_usage DROP CONSTRAINT port_usage_port_id_fkey;
ALTER TABLE ONLY public.port DROP CONSTRAINT port_server_id_fkey;
ALTER TABLE ONLY public.port_forward_rule DROP CONSTRAINT port_forward_rule_port_id_fkey;
DROP INDEX public.ix_user_id;
DROP INDEX public.ix_user_email;
DROP INDEX public.ix_server_user_id;
DROP INDEX public.ix_server_name;
DROP INDEX public.ix_server_id;
DROP INDEX public.ix_port_user_id;
DROP INDEX public.ix_port_usage_id;
DROP INDEX public.ix_port_id;
DROP INDEX public.ix_port_forward_rule_id;
ALTER TABLE ONLY public."user" DROP CONSTRAINT user_pkey;
ALTER TABLE ONLY public.server_user DROP CONSTRAINT server_user_pkey;
ALTER TABLE ONLY public.server DROP CONSTRAINT server_pkey;
ALTER TABLE ONLY public.port_user DROP CONSTRAINT port_user_pkey;
ALTER TABLE ONLY public.port_usage DROP CONSTRAINT port_usage_pkey;
ALTER TABLE ONLY public.port DROP CONSTRAINT port_pkey;
ALTER TABLE ONLY public.port_forward_rule DROP CONSTRAINT port_forward_rule_pkey;
ALTER TABLE ONLY public.alembic_version DROP CONSTRAINT alembic_version_pkc;
ALTER TABLE ONLY public.server_user DROP CONSTRAINT _server_user_server_id_user_id_uc;
ALTER TABLE ONLY public.server DROP CONSTRAINT _server_ansible_name_uc;
ALTER TABLE ONLY public.server DROP CONSTRAINT _server_ansible_host_ansible_port_uc;
ALTER TABLE ONLY public.port_user DROP CONSTRAINT _port_user_server_id_user_id_uc;
ALTER TABLE ONLY public.port_usage DROP CONSTRAINT _port_usage_port_id_uc;
ALTER TABLE ONLY public.port DROP CONSTRAINT _port_num_server_uc;
ALTER TABLE ONLY public.port DROP CONSTRAINT _port_external_num_server_uc;
ALTER TABLE public."user" ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.server_user ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.server ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.port_user ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.port_usage ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.port_forward_rule ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.port ALTER COLUMN id DROP DEFAULT;
DROP SEQUENCE public.user_id_seq;
DROP TABLE public."user";
DROP SEQUENCE public.server_user_id_seq;
DROP TABLE public.server_user;
DROP SEQUENCE public.server_id_seq;
DROP TABLE public.server;
DROP SEQUENCE public.port_user_id_seq;
DROP TABLE public.port_user;
DROP SEQUENCE public.port_usage_id_seq;
DROP TABLE public.port_usage;
DROP SEQUENCE public.port_id_seq;
DROP SEQUENCE public.port_forward_rule_id_seq;
DROP TABLE public.port_forward_rule;
DROP TABLE public.port;
DROP TABLE public.alembic_version;
DROP TYPE public.methodenum;
--
-- Name: methodenum; Type: TYPE; Schema: public; Owner: aurora
--

CREATE TYPE public.methodenum AS ENUM (
    'IPTABLES',
    'GOST',
    'EHCO',
    'V2RAY',
    'SOCAT',
    'BROOK',
    'WSTUNNEL',
    'NODE_EXPORTER',
    'TINY_PORT_MAPPER',
    'SHADOWSOCKS',
    'CADDY',
    'IPERF',
    'REALM',
    'HAPROXY'
);


ALTER TYPE public.methodenum OWNER TO aurora;



--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE public.alembic_version OWNER TO aurora;

--
-- Name: port; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.port (
    id integer NOT NULL,
    external_num integer,
    num integer NOT NULL,
    server_id integer,
    config json NOT NULL,
    is_active boolean,
    notes text
);


ALTER TABLE public.port OWNER TO aurora;

--
-- Name: port_forward_rule; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.port_forward_rule (
    id integer NOT NULL,
    port_id integer NOT NULL,
    config json NOT NULL,
    method public.methodenum NOT NULL,
    status character varying,
    is_active boolean
);


ALTER TABLE public.port_forward_rule OWNER TO aurora;

--
-- Name: port_forward_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.port_forward_rule_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.port_forward_rule_id_seq OWNER TO aurora;

--
-- Name: port_forward_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.port_forward_rule_id_seq OWNED BY public.port_forward_rule.id;


--
-- Name: port_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.port_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.port_id_seq OWNER TO aurora;

--
-- Name: port_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.port_id_seq OWNED BY public.port.id;


--
-- Name: port_usage; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.port_usage (
    id integer NOT NULL,
    port_id integer NOT NULL,
    download bigint NOT NULL,
    upload bigint NOT NULL,
    download_accumulate bigint NOT NULL,
    upload_accumulate bigint NOT NULL,
    download_checkpoint bigint NOT NULL,
    upload_checkpoint bigint NOT NULL
);


ALTER TABLE public.port_usage OWNER TO aurora;

--
-- Name: port_usage_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.port_usage_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.port_usage_id_seq OWNER TO aurora;

--
-- Name: port_usage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.port_usage_id_seq OWNED BY public.port_usage.id;


--
-- Name: port_user; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.port_user (
    id integer NOT NULL,
    port_id integer NOT NULL,
    user_id integer NOT NULL,
    config json NOT NULL
);


ALTER TABLE public.port_user OWNER TO aurora;

--
-- Name: port_user_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.port_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.port_user_id_seq OWNER TO aurora;

--
-- Name: port_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.port_user_id_seq OWNED BY public.port_user.id;


--
-- Name: server; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.server (
    id integer NOT NULL,
    name character varying NOT NULL,
    address character varying NOT NULL,
    ansible_name character varying NOT NULL,
    ansible_host character varying,
    ansible_port integer,
    ansible_user character varying,
    config json NOT NULL,
    ssh_password character varying,
    sudo_password character varying,
    is_active boolean
);


ALTER TABLE public.server OWNER TO aurora;

--
-- Name: server_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.server_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.server_id_seq OWNER TO aurora;

--
-- Name: server_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.server_id_seq OWNED BY public.server.id;


--
-- Name: server_user; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public.server_user (
    id integer NOT NULL,
    server_id integer NOT NULL,
    user_id integer NOT NULL,
    config json NOT NULL,
    download bigint NOT NULL,
    upload bigint NOT NULL,
    notes text
);


ALTER TABLE public.server_user OWNER TO aurora;

--
-- Name: server_user_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.server_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.server_user_id_seq OWNER TO aurora;

--
-- Name: server_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.server_user_id_seq OWNED BY public.server_user.id;


--
-- Name: user; Type: TABLE; Schema: public; Owner: aurora
--

CREATE TABLE public."user" (
    id integer NOT NULL,
    email character varying NOT NULL,
    first_name character varying,
    last_name character varying,
    hashed_password character varying NOT NULL,
    is_active boolean,
    is_ops boolean,
    is_superuser boolean,
    notes text
);


ALTER TABLE public."user" OWNER TO aurora;

--
-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: aurora
--

CREATE SEQUENCE public.user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_id_seq OWNER TO aurora;

--
-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aurora
--

ALTER SEQUENCE public.user_id_seq OWNED BY public."user".id;


--
-- Name: port id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port ALTER COLUMN id SET DEFAULT nextval('public.port_id_seq'::regclass);


--
-- Name: port_forward_rule id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_forward_rule ALTER COLUMN id SET DEFAULT nextval('public.port_forward_rule_id_seq'::regclass);


--
-- Name: port_usage id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_usage ALTER COLUMN id SET DEFAULT nextval('public.port_usage_id_seq'::regclass);


--
-- Name: port_user id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_user ALTER COLUMN id SET DEFAULT nextval('public.port_user_id_seq'::regclass);


--
-- Name: server id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server ALTER COLUMN id SET DEFAULT nextval('public.server_id_seq'::regclass);


--
-- Name: server_user id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server_user ALTER COLUMN id SET DEFAULT nextval('public.server_user_id_seq'::regclass);


--
-- Name: user id; Type: DEFAULT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public."user" ALTER COLUMN id SET DEFAULT nextval('public.user_id_seq'::regclass);


--
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.alembic_version (version_num) FROM stdin;
ea4a5dba09c3
\.


--
-- Data for Name: port; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.port (id, external_num, num, server_id, config, is_active, notes) FROM stdin;
1	\N	60000	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
2	\N	60007	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
3	\N	60001	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
4	\N	60002	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
5	\N	60004	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
6	\N	60003	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
7	\N	60005	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
8	\N	60006	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
9	\N	60014	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
10	\N	60022	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
11	\N	60023	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
12	\N	60024	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
13	\N	60025	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
14	\N	60026	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
15	\N	60027	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
16	\N	60028	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
17	\N	60029	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
18	\N	60020	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
19	\N	60035	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
20	\N	60019	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
21	\N	60031	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
22	\N	60018	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
23	\N	60017	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
24	\N	60032	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
25	\N	60016	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
26	\N	60015	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
27	\N	60033	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
28	\N	60021	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
29	\N	60034	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
30	\N	60013	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
31	\N	60012	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
32	\N	60011	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
33	\N	60010	1	{"egress_limit": null, "ingress_limit": null, "valid_until": null, "due_action": 0, "quota": null, "quota_action": 0}	t	\N
\.


--
-- Data for Name: port_forward_rule; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.port_forward_rule (id, port_id, config, method, status, is_active) FROM stdin;
\.


--
-- Data for Name: port_usage; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.port_usage (id, port_id, download, upload, download_accumulate, upload_accumulate, download_checkpoint, upload_checkpoint) FROM stdin;
\.


--
-- Data for Name: port_user; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.port_user (id, port_id, user_id, config) FROM stdin;
\.


--
-- Data for Name: server; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.server (id, name, address, ansible_name, ansible_host, ansible_port, ansible_user, config, ssh_password, sudo_password, is_active) FROM stdin;
1	Bandwagonhost	144.34.235.198	Megabox	144.34.235.198	6902	root	{"system": {"os_family": "Debian", "architecture": "x86_64", "distribution": "Debian", "distribution_version": "12.0", "distribution_release": "bookworm"}, "services": {"1panel.service": {"name": "1panel.service", "source": "systemd", "state": "running", "status": "enabled"}, "NetworkManager.service": {"name": "NetworkManager.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "acpid": {"name": "acpid", "source": "sysv", "state": "running"}, "acpid.service": {"name": "acpid.service", "source": "systemd", "state": "running", "status": "enabled"}, "apparmor": {"name": "apparmor", "source": "sysv", "state": "running"}, "apparmor.service": {"name": "apparmor.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "apt-daily-upgrade.service": {"name": "apt-daily-upgrade.service", "source": "systemd", "state": "stopped", "status": "static"}, "apt-daily.service": {"name": "apt-daily.service", "source": "systemd", "state": "stopped", "status": "static"}, "auditd.service": {"name": "auditd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "autovt@.service": {"name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias"}, "connman.service": {"name": "connman.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "console-getty.service": {"name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "console-screen.service": {"name": "console-screen.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "console-setup.service": {"name": "console-setup.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "console-setup.sh": {"name": "console-setup.sh", "source": "sysv", "state": "stopped"}, "container-getty@.service": {"name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static"}, "containerd.service": {"name": "containerd.service", "source": "systemd", "state": "running", "status": "enabled"}, "cron": {"name": "cron", "source": "sysv", "state": "running"}, "cron.service": {"name": "cron.service", "source": "systemd", "state": "running", "status": "enabled"}, "cryptdisks-early.service": {"name": "cryptdisks-early.service", "source": "systemd", "state": "inactive", "status": "masked"}, "cryptdisks.service": {"name": "cryptdisks.service", "source": "systemd", "state": "inactive", "status": "masked"}, "dbus": {"name": "dbus", "source": "sysv", "state": "running"}, "dbus-org.freedesktop.hostname1.service": {"name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias"}, "dbus-org.freedesktop.locale1.service": {"name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias"}, "dbus-org.freedesktop.login1.service": {"name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias"}, "dbus-org.freedesktop.timedate1.service": {"name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias"}, "dbus-org.freedesktop.timesync1.service": {"name": "dbus-org.freedesktop.timesync1.service", "source": "systemd", "state": "active", "status": "alias"}, "dbus.service": {"name": "dbus.service", "source": "systemd", "state": "running", "status": "static"}, "debug-shell.service": {"name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "display-manager.service": {"name": "display-manager.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "docker": {"name": "docker", "source": "sysv", "state": "running"}, "docker.service": {"name": "docker.service", "source": "systemd", "state": "running", "status": "enabled"}, "dpkg-db-backup.service": {"name": "dpkg-db-backup.service", "source": "systemd", "state": "stopped", "status": "static"}, "e2scrub@.service": {"name": "e2scrub@.service", "source": "systemd", "state": "unknown", "status": "static"}, "e2scrub_all.service": {"name": "e2scrub_all.service", "source": "systemd", "state": "stopped", "status": "static"}, "e2scrub_fail@.service": {"name": "e2scrub_fail@.service", "source": "systemd", "state": "unknown", "status": "static"}, "e2scrub_reap.service": {"name": "e2scrub_reap.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "emergency.service": {"name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static"}, "fail2ban": {"name": "fail2ban", "source": "sysv", "state": "stopped"}, "fail2ban.service": {"name": "fail2ban.service", "source": "systemd", "state": "stopped", "status": "failed"}, "firewalld.service": {"name": "firewalld.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "fstrim.service": {"name": "fstrim.service", "source": "systemd", "state": "stopped", "status": "static"}, "getty-static.service": {"name": "getty-static.service", "source": "systemd", "state": "stopped", "status": "static"}, "getty@.service": {"name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled"}, "getty@tty1.service": {"name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "active"}, "guestfs-firstboot": {"name": "guestfs-firstboot", "source": "sysv", "state": "running"}, "guestfs-firstboot.service": {"name": "guestfs-firstboot.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "gwarp": {"name": "gwarp", "source": "sysv", "state": "stopped"}, "gwarp.service": {"name": "gwarp.service", "source": "systemd", "state": "stopped", "status": "generated"}, "haveged": {"name": "haveged", "source": "sysv", "state": "running"}, "haveged.service": {"name": "haveged.service", "source": "systemd", "state": "running", "status": "enabled"}, "http-server.service": {"name": "http-server.service", "source": "systemd", "state": "running", "status": "enabled"}, "hwclock.service": {"name": "hwclock.service", "source": "systemd", "state": "inactive", "status": "masked"}, "hwclock.sh": {"name": "hwclock.sh", "source": "sysv", "state": "stopped"}, "ifup@.service": {"name": "ifup@.service", "source": "systemd", "state": "unknown", "status": "static"}, "ifupdown-pre.service": {"name": "ifupdown-pre.service", "source": "systemd", "state": "stopped", "status": "static"}, "ifupdown-wait-online.service": {"name": "ifupdown-wait-online.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "initrd-cleanup.service": {"name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static"}, "initrd-parse-etc.service": {"name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static"}, "initrd-switch-root.service": {"name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static"}, "initrd-udevadm-cleanup-db.service": {"name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static"}, "ip6tables.service": {"name": "ip6tables.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ipset.service": {"name": "ipset.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "iptables.service": {"name": "iptables.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ipv6net": {"name": "ipv6net", "source": "sysv", "state": "stopped"}, "ipv6net.service": {"name": "ipv6net.service", "source": "systemd", "state": "stopped", "status": "generated"}, "kbd.service": {"name": "kbd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "keyboard-setup.service": {"name": "keyboard-setup.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "keyboard-setup.sh": {"name": "keyboard-setup.sh", "source": "sysv", "state": "stopped"}, "kmod": {"name": "kmod", "source": "sysv", "state": "running"}, "kmod-static-nodes.service": {"name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static"}, "kmod.service": {"name": "kmod.service", "source": "systemd", "state": "active", "status": "alias"}, "komari-agent.service": {"name": "komari-agent.service", "source": "systemd", "state": "running", "status": "enabled"}, "komari.service": {"name": "komari.service", "source": "systemd", "state": "running", "status": "enabled"}, "logrotate.service": {"name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static"}, "man-db.service": {"name": "man-db.service", "source": "systemd", "state": "stopped", "status": "static"}, "modprobe@.service": {"name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static"}, "modprobe@configfs.service": {"name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@dm_mod.service": {"name": "modprobe@dm_mod.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@drm.service": {"name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@efi_pstore.service": {"name": "modprobe@efi_pstore.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@fuse.service": {"name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@loop.service": {"name": "modprobe@loop.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "networking": {"name": "networking", "source": "sysv", "state": "running"}, "networking.service": {"name": "networking.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "nftables.service": {"name": "nftables.service", "source": "systemd", "state": "stopped", "status": "disabled"}, "pam_namespace.service": {"name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static"}, "phpsessionclean.service": {"name": "phpsessionclean.service", "source": "systemd", "state": "stopped", "status": "static"}, "plymouth-quit-wait.service": {"name": "plymouth-quit-wait.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "plymouth-start.service": {"name": "plymouth-start.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "prefdm.service": {"name": "prefdm.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "procps": {"name": "procps", "source": "sysv", "state": "running"}, "procps.service": {"name": "procps.service", "source": "systemd", "state": "active", "status": "alias"}, "qemu-guest-agent": {"name": "qemu-guest-agent", "source": "sysv", "state": "running"}, "qemu-guest-agent.service": {"name": "qemu-guest-agent.service", "source": "systemd", "state": "running", "status": "static"}, "qemukvmga": {"name": "qemukvmga", "source": "sysv", "state": "stopped"}, "qemukvmga.service": {"name": "qemukvmga.service", "source": "systemd", "state": "running", "status": "generated"}, "quotaon.service": {"name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static"}, "rc-local.service": {"name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime"}, "rc.service": {"name": "rc.service", "source": "systemd", "state": "inactive", "status": "masked"}, "rcS.service": {"name": "rcS.service", "source": "systemd", "state": "inactive", "status": "masked"}, "rescue.service": {"name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static"}, "rsyslog.service": {"name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled"}, "s-ui.service": {"name": "s-ui.service", "source": "systemd", "state": "running", "status": "enabled"}, "serial-getty@.service": {"name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect"}, "serial-getty@ttyS0.service": {"name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "active"}, "sing-box.service": {"name": "sing-box.service", "source": "systemd", "state": "running", "status": "enabled"}, "sing-box@.service": {"name": "sing-box@.service", "source": "systemd", "state": "unknown", "status": "disabled"}, "ssh": {"name": "ssh", "source": "sysv", "state": "running"}, "ssh.service": {"name": "ssh.service", "source": "systemd", "state": "running", "status": "enabled"}, "sshd.service": {"name": "sshd.service", "source": "systemd", "state": "active", "status": "alias"}, "sub.service": {"name": "sub.service", "source": "systemd", "state": "running", "status": "enabled"}, "sudo": {"name": "sudo", "source": "sysv", "state": "stopped"}, "sudo.service": {"name": "sudo.service", "source": "systemd", "state": "inactive", "status": "masked"}, "syslog.service": {"name": "syslog.service", "source": "systemd", "state": "active", "status": "alias"}, "system-update-cleanup.service": {"name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-ask-password-console.service": {"name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-ask-password-wall.service": {"name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-backlight@.service": {"name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static"}, "systemd-binfmt.service": {"name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-boot-check-no-failures.service": {"name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "systemd-exit.service": {"name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-firstboot.service": {"name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-fsck-root.service": {"name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime"}, "systemd-fsck@.service": {"name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static"}, "systemd-fsck@dev-disk-by\\\\x2duuid-8defcd09\\\\x2d6511\\\\x2d4fc6\\\\x2dbad6\\\\x2da5a90521b7ad.service": {"name": "systemd-fsck@dev-disk-by\\\\x2duuid-8defcd09\\\\x2d6511\\\\x2d4fc6\\\\x2dbad6\\\\x2da5a90521b7ad.service", "source": "systemd", "state": "stopped", "status": "active"}, "systemd-fsckd.service": {"name": "systemd-fsckd.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-halt.service": {"name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-hibernate-resume@.service": {"name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static"}, "systemd-hibernate.service": {"name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-hostnamed.service": {"name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-hwdb-update.service": {"name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "systemd-hybrid-sleep.service": {"name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-initctl.service": {"name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-journal-flush.service": {"name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-journald.service": {"name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static"}, "systemd-journald@.service": {"name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static"}, "systemd-kexec.service": {"name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-localed.service": {"name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-logind.service": {"name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static"}, "systemd-machine-id-commit.service": {"name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-modules-load.service": {"name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-network-generator.service": {"name": "systemd-network-generator.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "systemd-networkd-wait-online.service": {"name": "systemd-networkd-wait-online.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "systemd-networkd-wait-online@.service": {"name": "systemd-networkd-wait-online@.service", "source": "systemd", "state": "unknown", "status": "disabled"}, "systemd-networkd.service": {"name": "systemd-networkd.service", "source": "systemd", "state": "stopped", "status": "disabled"}, "systemd-pcrphase-initrd.service": {"name": "systemd-pcrphase-initrd.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-pcrphase-sysinit.service": {"name": "systemd-pcrphase-sysinit.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-pcrphase.service": {"name": "systemd-pcrphase.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-poweroff.service": {"name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-pstore.service": {"name": "systemd-pstore.service", "source": "systemd", "state": "stopped", "status": "enabled"}, "systemd-quotacheck.service": {"name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-random-seed.service": {"name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-reboot.service": {"name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-remount-fs.service": {"name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime"}, "systemd-repart.service": {"name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-rfkill.service": {"name": "systemd-rfkill.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-suspend-then-hibernate.service": {"name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-suspend.service": {"name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-sysctl.service": {"name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-sysext.service": {"name": "systemd-sysext.service", "source": "systemd", "state": "stopped", "status": "disabled"}, "systemd-sysusers.service": {"name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-time-wait-sync.service": {"name": "systemd-time-wait-sync.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "systemd-timedated.service": {"name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static"}, "systemd-timesyncd.service": {"name": "systemd-timesyncd.service", "source": "systemd", "state": "running", "status": "enabled"}, "systemd-tmpfiles-clean.service": {"name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-tmpfiles-setup-dev.service": {"name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-tmpfiles-setup.service": {"name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-tmpfiles.service": {"name": "systemd-tmpfiles.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "systemd-udev-settle.service": {"name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-udev-trigger.service": {"name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-udevd.service": {"name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static"}, "systemd-update-done.service": {"name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "systemd-update-utmp-runlevel.service": {"name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-update-utmp.service": {"name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-user-sessions.service": {"name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static"}, "systemd-vconsole-setup.service": {"name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "systemd-volatile-root.service": {"name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static"}, "udev": {"name": "udev", "source": "sysv", "state": "running"}, "udev.service": {"name": "udev.service", "source": "systemd", "state": "active", "status": "alias"}, "ufw": {"name": "ufw", "source": "sysv", "state": "stopped"}, "ufw.service": {"name": "ufw.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "user-runtime-dir@.service": {"name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static"}, "user-runtime-dir@0.service": {"name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "active"}, "user@.service": {"name": "user@.service", "source": "systemd", "state": "unknown", "status": "static"}, "user@0.service": {"name": "user@0.service", "source": "systemd", "state": "running", "status": "active"}, "v2ray.service": {"name": "v2ray.service", "source": "systemd", "state": "running", "status": "enabled"}, "vnstat": {"name": "vnstat", "source": "sysv", "state": "running"}, "vnstat.service": {"name": "vnstat.service", "source": "systemd", "state": "running", "status": "enabled"}, "warp-svc.service": {"name": "warp-svc.service", "source": "systemd", "state": "running", "status": "enabled"}, "x11-common": {"name": "x11-common", "source": "sysv", "state": "stopped"}, "x11-common.service": {"name": "x11-common.service", "source": "systemd", "state": "inactive", "status": "masked"}}, "init": "2b40391be44a4566e97f2727a4252165"}	dn#5ey149#*SwxT!a^k*o^9U!113Z#	\N	t
\.


--
-- Data for Name: server_user; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public.server_user (id, server_id, user_id, config, download, upload, notes) FROM stdin;
\.


--
-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: aurora
--

COPY public."user" (id, email, first_name, last_name, hashed_password, is_active, is_ops, is_superuser, notes) FROM stdin;
1	enochkingsley83@gmail.com	\N	\N	$2b$12$dzwkJUIu1s1LEU3fiqnfEOblUTrHBM/sKhKkM4mHdXQF/QMdmynwK	t	f	t	\N
2	EnochKingsley83@gmail.com	\N	\N	$2b$12$ac/nxSR29VcYPzwXS17QV.bCG26NnCmJPDbqSYpd1o87IrPCGGqyO	t	f	t	\N
\.


--
-- Name: port_forward_rule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.port_forward_rule_id_seq', 1, false);


--
-- Name: port_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.port_id_seq', 33, true);


--
-- Name: port_usage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.port_usage_id_seq', 1, false);


--
-- Name: port_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.port_user_id_seq', 1, false);


--
-- Name: server_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.server_id_seq', 1, true);


--
-- Name: server_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.server_user_id_seq', 1, false);


--
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aurora
--

SELECT pg_catalog.setval('public.user_id_seq', 2, true);


--
-- Name: port _port_external_num_server_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port
    ADD CONSTRAINT _port_external_num_server_uc UNIQUE (external_num, server_id);


--
-- Name: port _port_num_server_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port
    ADD CONSTRAINT _port_num_server_uc UNIQUE (num, server_id);


--
-- Name: port_usage _port_usage_port_id_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_usage
    ADD CONSTRAINT _port_usage_port_id_uc UNIQUE (port_id);


--
-- Name: port_user _port_user_server_id_user_id_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_user
    ADD CONSTRAINT _port_user_server_id_user_id_uc UNIQUE (port_id, user_id);


--
-- Name: server _server_ansible_host_ansible_port_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server
    ADD CONSTRAINT _server_ansible_host_ansible_port_uc UNIQUE (ansible_host, ansible_port);


--
-- Name: server _server_ansible_name_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server
    ADD CONSTRAINT _server_ansible_name_uc UNIQUE (ansible_name);


--
-- Name: server_user _server_user_server_id_user_id_uc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server_user
    ADD CONSTRAINT _server_user_server_id_user_id_uc UNIQUE (server_id, user_id);


--
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.alembic_version
    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);


--
-- Name: port_forward_rule port_forward_rule_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_forward_rule
    ADD CONSTRAINT port_forward_rule_pkey PRIMARY KEY (id);


--
-- Name: port port_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port
    ADD CONSTRAINT port_pkey PRIMARY KEY (id);


--
-- Name: port_usage port_usage_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_usage
    ADD CONSTRAINT port_usage_pkey PRIMARY KEY (id);


--
-- Name: port_user port_user_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_user
    ADD CONSTRAINT port_user_pkey PRIMARY KEY (id);


--
-- Name: server server_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server
    ADD CONSTRAINT server_pkey PRIMARY KEY (id);


--
-- Name: server_user server_user_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server_user
    ADD CONSTRAINT server_user_pkey PRIMARY KEY (id);


--
-- Name: user user_pkey; Type: CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_pkey PRIMARY KEY (id);


--
-- Name: ix_port_forward_rule_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_port_forward_rule_id ON public.port_forward_rule USING btree (id);


--
-- Name: ix_port_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_port_id ON public.port USING btree (id);


--
-- Name: ix_port_usage_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_port_usage_id ON public.port_usage USING btree (id);


--
-- Name: ix_port_user_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_port_user_id ON public.port_user USING btree (id);


--
-- Name: ix_server_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_server_id ON public.server USING btree (id);


--
-- Name: ix_server_name; Type: INDEX; Schema: public; Owner: aurora
--

CREATE UNIQUE INDEX ix_server_name ON public.server USING btree (name);


--
-- Name: ix_server_user_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_server_user_id ON public.server_user USING btree (id);


--
-- Name: ix_user_email; Type: INDEX; Schema: public; Owner: aurora
--

CREATE UNIQUE INDEX ix_user_email ON public."user" USING btree (email);


--
-- Name: ix_user_id; Type: INDEX; Schema: public; Owner: aurora
--

CREATE INDEX ix_user_id ON public."user" USING btree (id);


--
-- Name: port_forward_rule port_forward_rule_port_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_forward_rule
    ADD CONSTRAINT port_forward_rule_port_id_fkey FOREIGN KEY (port_id) REFERENCES public.port(id);


--
-- Name: port port_server_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port
    ADD CONSTRAINT port_server_id_fkey FOREIGN KEY (server_id) REFERENCES public.server(id);


--
-- Name: port_usage port_usage_port_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_usage
    ADD CONSTRAINT port_usage_port_id_fkey FOREIGN KEY (port_id) REFERENCES public.port(id);


--
-- Name: port_user port_user_port_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_user
    ADD CONSTRAINT port_user_port_id_fkey FOREIGN KEY (port_id) REFERENCES public.port(id);


--
-- Name: port_user port_user_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.port_user
    ADD CONSTRAINT port_user_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id);


--
-- Name: server_user server_user_server_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server_user
    ADD CONSTRAINT server_user_server_id_fkey FOREIGN KEY (server_id) REFERENCES public.server(id);


--
-- Name: server_user server_user_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: aurora
--

ALTER TABLE ONLY public.server_user
    ADD CONSTRAINT server_user_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id);


--
--

\unrestrict 9HcYvNEaOUmz2eDUIACBYZGasPiwJSUfsJyAMJhnwrKD5e5Gh7hQlRpWnXgQpTz

