| |
| |
| |
|
|
| |
| |
|
|
| 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); |
|
|
|
|
| |
| |
| |
|
|
|
|