github.com/kotovmak/go-admin@v1.1.1/data/migrations/admin_2020_04_14_100427_postgres.sql (about)

     1  --
     2  -- PostgreSQL database dump
     3  --
     4  
     5  -- Dumped from database version 9.5.14
     6  -- Dumped by pg_dump version 10.5
     7  
     8  SET statement_timeout = 0;
     9  SET lock_timeout = 0;
    10  SET idle_in_transaction_session_timeout = 0;
    11  SET client_encoding = 'EUC_CN';
    12  SET standard_conforming_strings = on;
    13  SELECT pg_catalog.set_config('search_path', '', false);
    14  SET check_function_bodies = false;
    15  SET client_min_messages = warning;
    16  SET row_security = off;
    17  
    18  SET default_tablespace = '';
    19  
    20  SET default_with_oids = false;
    21  
    22  --
    23  -- Name: goadmin_site_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
    24  --
    25  
    26  CREATE SEQUENCE public.goadmin_site_myid_seq
    27      START WITH 1
    28      INCREMENT BY 1
    29      NO MINVALUE
    30      MAXVALUE 99999999
    31      CACHE 1;
    32  
    33  ALTER TABLE public.goadmin_site_myid_seq OWNER TO postgres;
    34  
    35  --
    36  -- Name: goadmin_site; Type: TABLE; Schema: public; Owner: postgres
    37  --
    38  
    39  CREATE TABLE public.goadmin_site (
    40      id integer DEFAULT nextval('public.goadmin_site_myid_seq'::regclass) NOT NULL,
    41      key character varying(100) NOT NULL,
    42      value text NOT NULL,
    43      type integer DEFAULT 0,
    44      description character varying(3000),
    45      state integer DEFAULT 0,
    46      created_at timestamp without time zone DEFAULT now(),
    47      updated_at timestamp without time zone DEFAULT now()
    48  );
    49  
    50  
    51  ALTER TABLE public.goadmin_site OWNER TO postgres;
    52  
    53  --
    54  -- Data for Name: goadmin_site; Type: TABLE DATA; Schema: public; Owner: postgres
    55  --
    56  
    57  COPY public.goadmin_site (id, key, value, type, description, state, created_at, updated_at) FROM stdin;
    58  \.
    59  
    60  
    61  --
    62  -- Name: goadmin_site goadmin_site_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
    63  --
    64  
    65  ALTER TABLE ONLY public.goadmin_site
    66      ADD CONSTRAINT goadmin_site_pkey PRIMARY KEY (id);
    67  
    68  
    69  --
    70  -- PostgreSQL database dump complete
    71  --
    72