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

     1  --
     2  -- PostgreSQL database dump
     3  --
     4  
     5  -- Dumped from database version 10.19 (Debian 10.19-1.pgdg90+1)
     6  -- Dumped by pg_dump version 10.19 (Debian 10.19-1.pgdg90+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_with_oids = false;
    22  
    23  --
    24  -- Name: stdintable; Type: TABLE; Schema: public; Owner: db
    25  --
    26  
    27  CREATE TABLE public.stdintable (
    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.stdintable OWNER TO db;
    36  
    37  --
    38  -- Name: TABLE stdintable; Type: COMMENT; Schema: public; Owner: db
    39  --
    40  
    41  COMMENT ON TABLE public.stdintable 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.stdintable.uid;
    64  
    65  
    66  --
    67  -- Name: stdintable uid; Type: DEFAULT; Schema: public; Owner: db
    68  --
    69  
    70  ALTER TABLE ONLY public.stdintable ALTER COLUMN uid SET DEFAULT nextval('public.users_uid_seq'::regclass);
    71  
    72  
    73  --
    74  -- Data for Name: stdintable; Type: TABLE DATA; Schema: public; Owner: db
    75  --
    76  
    77  COPY public.stdintable (uid, uuid, langcode) FROM stdin;
    78  0	e6b6f38b-3133-474a-b1b0-35a6459ef010	en
    79  1	6c3ec872-f73e-4074-bfd3-029633935e26	en
    80  \.
    81  
    82  
    83  --
    84  -- Name: users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: db
    85  --
    86  
    87  SELECT pg_catalog.setval('public.users_uid_seq', 7, true);
    88  
    89  
    90  --
    91  -- Name: stdintable users____pkey; Type: CONSTRAINT; Schema: public; Owner: db
    92  --
    93  
    94  ALTER TABLE ONLY public.stdintable
    95      ADD CONSTRAINT users____pkey PRIMARY KEY (uid);
    96  
    97  
    98  --
    99  -- Name: stdintable users__user_field__uuid__value__key; Type: CONSTRAINT; Schema: public; Owner: db
   100  --
   101  
   102  ALTER TABLE ONLY public.stdintable
   103      ADD CONSTRAINT users__user_field__uuid__value__key UNIQUE (uuid);
   104  
   105  
   106  --
   107  -- PostgreSQL database dump complete
   108  --
   109