github.com/ddev/ddev@v1.23.2-0.20240519125000-d824ffe36ff3/pkg/ddevapp/testdata/TestDdevImportDB/postgres/users.mysql (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; Type: TABLE; Schema: public; Owner: db
    25  --
    26  
    27  CREATE TABLE public.users (
    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 OWNER TO db;
    36  
    37  --
    38  -- Name: TABLE users; Type: COMMENT; Schema: public; Owner: db
    39  --
    40  
    41  COMMENT ON TABLE public.users 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.uid;
    64  
    65  
    66  --
    67  -- Name: users uid; Type: DEFAULT; Schema: public; Owner: db
    68  --
    69  
    70  ALTER TABLE ONLY public.users ALTER COLUMN uid SET DEFAULT nextval('public.users_uid_seq'::regclass);
    71  
    72  
    73  --
    74  -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: db
    75  --
    76  
    77  COPY public.users (uid, uuid, langcode) FROM stdin;
    78  0	21ac33ef-45f8-44c2-b766-c4bb2f061a29	en
    79  1	e7ac962b-8c27-4907-87db-99d3b098cb24	en
    80  2	be7f5f12-edcc-4d9d-ab5f-47d59578a74a	en
    81  3	92fdab2e-a106-42a5-ac6a-770cb419b814	en
    82  4	f22db0d7-598e-4c24-a1b3-517f13a335a1	en
    83  5	e3d5e93f-eadc-4ad6-a5ef-986bfc3daf91	en
    84  6	2ec3643a-c569-4dc4-a581-e333dfc890e6	en
    85  7	e282ce38-1c2e-4928-8b49-662a44a6139e	en
    86  \.
    87  
    88  
    89  --
    90  -- Name: users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: db
    91  --
    92  
    93  SELECT pg_catalog.setval('public.users_uid_seq', 7, true);
    94  
    95  
    96  --
    97  -- Name: users users____pkey; Type: CONSTRAINT; Schema: public; Owner: db
    98  --
    99  
   100  ALTER TABLE ONLY public.users
   101      ADD CONSTRAINT users____pkey PRIMARY KEY (uid);
   102  
   103  
   104  --
   105  -- Name: users users__user_field__uuid__value__key; Type: CONSTRAINT; Schema: public; Owner: db
   106  --
   107  
   108  ALTER TABLE ONLY public.users
   109      ADD CONSTRAINT users__user_field__uuid__value__key UNIQUE (uuid);
   110  
   111  
   112  --
   113  -- PostgreSQL database dump complete
   114  --
   115