From d5632b6b011c33af5ae91cd4ebb05fcfd1a6eb75 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 20 Jul 2026 09:20:04 +0000 Subject: [PATCH] database: Make domains(id) BIGINT Signed-off-by: Michael Tremer --- src/database.sql | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) diff --git a/src/database.sql b/src/database.sql index bd747eb..4d7c1dc 100644 --- a/src/database.sql +++ b/src/database.sql @@ -2,10 +2,10 @@ -- PostgreSQL database dump -- -\restrict djz8ldYp4Ibt0nuMIDjTvZxpbMpzfk5h4nJXJqevhuhHUcLnPp7CWYU7CqIZtDF +\restrict 8jQK8ebx90d1fZCvw8DAeyt0JFQLnIJsrsklcrmqPX4coQGYZBoGhMC64DaKUIc --- Dumped from database version 17.7 (Debian 17.7-0+deb13u1) --- Dumped by pg_dump version 17.7 (Debian 17.7-0+deb13u1) +-- Dumped from database version 17.10 (Debian 17.10-0+deb13u1) +-- Dumped by pg_dump version 17.10 (Debian 17.10-0+deb13u1) SET statement_timeout = 0; SET lock_timeout = 0; @@ -67,7 +67,7 @@ ALTER SEQUENCE public.api_keys_id_seq OWNED BY public.api_keys.id; -- CREATE TABLE public.domains ( - id integer NOT NULL, + id bigint NOT NULL, list_id integer NOT NULL, name text NOT NULL, source_id integer, @@ -151,7 +151,6 @@ CREATE VIEW public.domain_events AS -- CREATE SEQUENCE public.domains_id_seq - AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -705,5 +704,5 @@ ALTER TABLE ONLY public.sources -- PostgreSQL database dump complete -- -\unrestrict djz8ldYp4Ibt0nuMIDjTvZxpbMpzfk5h4nJXJqevhuhHUcLnPp7CWYU7CqIZtDF +\unrestrict 8jQK8ebx90d1fZCvw8DAeyt0JFQLnIJsrsklcrmqPX4coQGYZBoGhMC64DaKUIc -- 2.47.3