|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SET statement_timeout = 0; |
|
SET lock_timeout = 0; |
|
SET idle_in_transaction_session_timeout = 0; |
|
SET client_encoding = 'EUC_CN'; |
|
SET standard_conforming_strings = on; |
|
SELECT pg_catalog.set_config('search_path', '', false); |
|
SET check_function_bodies = false; |
|
SET client_min_messages = warning; |
|
SET row_security = off; |
|
|
|
SET default_tablespace = ''; |
|
|
|
SET default_with_oids = false; |
|
|
|
|
|
|
|
|
|
|
|
CREATE SEQUENCE public.goadmin_site_myid_seq |
|
START WITH 1 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
MAXVALUE 99999999 |
|
CACHE 1; |
|
|
|
ALTER TABLE public.goadmin_site_myid_seq OWNER TO postgres; |
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE public.goadmin_site ( |
|
id integer DEFAULT nextval('public.goadmin_site_myid_seq'::regclass) NOT NULL, |
|
key character varying(100) NOT NULL, |
|
value text NOT NULL, |
|
type integer DEFAULT 0, |
|
description character varying(3000), |
|
state integer DEFAULT 0, |
|
created_at timestamp without time zone DEFAULT now(), |
|
updated_at timestamp without time zone DEFAULT now() |
|
); |
|
|
|
|
|
ALTER TABLE public.goadmin_site OWNER TO postgres; |
|
|
|
|
|
|
|
|
|
|
|
COPY public.goadmin_site (id, key, value, type, description, state, created_at, updated_at) FROM stdin; |
|
\. |
|
|
|
|
|
|
|
|
|
|
|
|
|
ALTER TABLE ONLY public.goadmin_site |
|
ADD CONSTRAINT goadmin_site_pkey PRIMARY KEY (id); |
|
|
|
|
|
|
|
|
|
|
|
|
|
|