photoprism/internal/entity/migrate/testdata/migrate_postgres_newdb.sql
2025-05-17 14:31:13 +10:00

31 lines
850 B
SQL

--
-- PostgreSQL database dump
--
-- Dumped from database version 17.4
-- Dumped by pg_dump version 17.4 (Debian 17.4-1.pgdg120+2)
-- Started on 2025-03-07 05:55:18 UTC
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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;
DROP DATABASE IF EXISTS migrate WITH (FORCE);
--
-- TOC entry 3924 (class 1262 OID 25875)
-- Name: migrate; Type: DATABASE; Schema: -; Owner: migrate
--
CREATE DATABASE migrate WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.utf8';
ALTER DATABASE migrate OWNER TO migrate;