github.com/drud/ddev@v1.21.5-alpha1.0.20230226034409-94fcc4b94453/pkg/ddevapp/testdata/TestDdevImportDB/postgres/oneuser.sql (about)

     1  --
     2  -- PostgreSQL database dump
     3  --
     4  
     5  -- Dumped from database version 14.1 (Debian 14.1-1.pgdg110+1)
     6  -- Dumped by pg_dump version 14.1 (Debian 14.1-1.pgdg110+1)
     7  
     8  SET statement_timeout = 0;
     9  SET lock_timeout = 0;
    10  SET idle_in_transaction_session_timeout = 0;
    11  SET client_encoding = 'UTF8';
    12  SET standard_conforming_strings = on;
    13  SELECT pg_catalog.set_config('search_path', '', false);
    14  SET check_function_bodies = false;
    15  SET xmloption = content;
    16  SET client_min_messages = warning;
    17  SET row_security = off;
    18  
    19  SET default_tablespace = '';
    20  
    21  SET default_table_access_method = heap;
    22  
    23  --
    24  -- Name: users_just_one; Type: TABLE; Schema: public; Owner: db
    25  --
    26  
    27  CREATE TABLE public.users_just_one (
    28      uid integer NOT NULL,
    29      uuid character varying(128) NOT NULL,
    30      langcode character varying(12) NOT NULL,
    31      CONSTRAINT users_uid_check CHECK ((uid >= 0))
    32  );
    33  
    34  
    35  ALTER TABLE public.users_just_one OWNER TO db;
    36  
    37  --
    38  -- Name: TABLE users_just_one; Type: COMMENT; Schema: public; Owner: db
    39  --
    40  
    41  COMMENT ON TABLE public.users_just_one IS 'The base table for user entities.';
    42  
    43  
    44  --
    45  -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: db
    46  --
    47  
    48  CREATE SEQUENCE public.users_uid_seq
    49      AS integer
    50      START WITH 1
    51      INCREMENT BY 1
    52      NO MINVALUE
    53      NO MAXVALUE
    54      CACHE 1;
    55  
    56  
    57  ALTER TABLE public.users_uid_seq OWNER TO db;
    58  
    59  --
    60  -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: db
    61  --
    62  
    63  ALTER SEQUENCE public.users_uid_seq OWNED BY public.users_just_one.uid;
    64  
    65  
    66  --
    67  -- Name: users_just_one uid; Type: DEFAULT; Schema: public; Owner: db
    68  --
    69  
    70  ALTER TABLE ONLY public.users_just_one ALTER COLUMN uid SET DEFAULT nextval('public.users_uid_seq'::regclass);
    71  
    72  
    73  --
    74  -- Data for Name: users_just_one; Type: TABLE DATA; Schema: public; Owner: db
    75  --
    76  
    77  COPY public.users_just_one (uid, uuid, langcode) FROM stdin;
    78  0	21ac33ef-45f8-44c2-b766-c4bb2f061a29	en
    79  \.
    80  
    81  
    82  --
    83  -- Name: users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: db
    84  --
    85  
    86  SELECT pg_catalog.setval('public.users_uid_seq', 7, true);
    87  
    88  
    89  --
    90  -- Name: users_just_one users____pkey; Type: CONSTRAINT; Schema: public; Owner: db
    91  --
    92  
    93  ALTER TABLE ONLY public.users_just_one
    94      ADD CONSTRAINT users____pkey PRIMARY KEY (uid);
    95  
    96  
    97  --
    98  -- Name: users_just_one users__user_field__uuid__value__key; Type: CONSTRAINT; Schema: public; Owner: db
    99  --
   100  
   101  ALTER TABLE ONLY public.users_just_one
   102      ADD CONSTRAINT users__user_field__uuid__value__key UNIQUE (uuid);
   103  
   104  
   105  --
   106  -- PostgreSQL database dump complete
   107  --
   108