-- -- PostgreSQL database dump -- -- Dumped from database version 9.5.14 -- Dumped by pg_dump version 10.5 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; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; -- -- Name: goadmin_menu_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_menu_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_menu_myid_seq OWNER TO postgres; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: goadmin_menu; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_menu ( id integer DEFAULT nextval('public.goadmin_menu_myid_seq'::regclass) NOT NULL, parent_id integer DEFAULT 0 NOT NULL, type integer DEFAULT 0, "order" integer DEFAULT 0 NOT NULL, title character varying(50) NOT NULL, header character varying(100), icon character varying(50) NOT NULL, uri character varying(50) NOT NULL, uuid character varying(100), plugin_name character varying(150) NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_menu OWNER TO postgres; -- -- Name: goadmin_operation_log_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_operation_log_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_operation_log_myid_seq OWNER TO postgres; -- -- Name: goadmin_operation_log; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_operation_log ( id integer DEFAULT nextval('public.goadmin_operation_log_myid_seq'::regclass) NOT NULL, user_id integer NOT NULL, path character varying(255) NOT NULL, method character varying(10) NOT NULL, ip character varying(15) NOT NULL, input text NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_operation_log OWNER TO postgres; -- -- Name: goadmin_permissions_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_permissions_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_permissions_myid_seq OWNER TO postgres; -- -- Name: goadmin_permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_permissions ( id integer DEFAULT nextval('public.goadmin_permissions_myid_seq'::regclass) NOT NULL, name character varying(50) NOT NULL, slug character varying(50) NOT NULL, http_method character varying(255), http_path text NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_permissions OWNER TO postgres; -- -- Name: goadmin_site_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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; -- -- Name: goadmin_site; Type: TABLE; Schema: public; Owner: 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; -- -- Name: goadmin_role_menu; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_role_menu ( role_id integer NOT NULL, menu_id integer NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_role_menu OWNER TO postgres; -- -- Name: goadmin_role_permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_role_permissions ( role_id integer NOT NULL, permission_id integer NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_role_permissions OWNER TO postgres; -- -- Name: goadmin_role_users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_role_users ( role_id integer NOT NULL, user_id integer NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_role_users OWNER TO postgres; -- -- Name: goadmin_roles_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_roles_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_roles_myid_seq OWNER TO postgres; -- -- Name: goadmin_roles; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_roles ( id integer DEFAULT nextval('public.goadmin_roles_myid_seq'::regclass) NOT NULL, name character varying NOT NULL, slug character varying NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_roles OWNER TO postgres; -- -- Name: goadmin_session_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_session_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_session_myid_seq OWNER TO postgres; -- -- Name: goadmin_session; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_session ( id integer DEFAULT nextval('public.goadmin_session_myid_seq'::regclass) NOT NULL, sid character varying(50) NOT NULL, "values" character varying(3000) NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_session OWNER TO postgres; -- -- Name: goadmin_user_permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_user_permissions ( user_id integer NOT NULL, permission_id integer NOT NULL, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_user_permissions OWNER TO postgres; -- -- Name: goadmin_users_myid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.goadmin_users_myid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 99999999 CACHE 1; ALTER TABLE public.goadmin_users_myid_seq OWNER TO postgres; -- -- Name: goadmin_users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.goadmin_users ( id integer DEFAULT nextval('public.goadmin_users_myid_seq'::regclass) NOT NULL, username character varying(190) NOT NULL, password character varying(80) NOT NULL, name character varying(255) NOT NULL, avatar character varying(255), remember_token character varying(100), created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.goadmin_users OWNER TO postgres; -- -- Name: user_like_books; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.user_like_books ( id integer, user_id integer, name character varying, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now() ); ALTER TABLE public.user_like_books OWNER TO postgres; -- -- Name: users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.users ( id integer NOT NULL, name character varying(100), homepage character varying(3000), email character varying(100), birthday timestamp with time zone, country character varying(50), city character varying(50), password character varying(100), ip character varying(20), certificate character varying(300), money integer, resume text, gender smallint, fruit character varying(200), drink character varying(200), experience smallint, created_at timestamp without time zone DEFAULT now(), updated_at timestamp without time zone DEFAULT now(), member_id integer DEFAULT 0 ); ALTER TABLE public.users OWNER TO postgres; -- -- Data for Name: goadmin_menu; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_menu (id, parent_id, type, "order", title, plugin_name, header, icon, uri, created_at, updated_at) FROM stdin; 1 0 1 2 Admin \N fa-tasks 2019-09-10 00:00:00 2019-09-10 00:00:00 2 1 1 2 Users \N fa-users /info/manager 2019-09-10 00:00:00 2019-09-10 00:00:00 3 1 1 3 Roles \N fa-user /info/roles 2019-09-10 00:00:00 2019-09-10 00:00:00 4 1 1 4 Permission \N fa-ban /info/permission 2019-09-10 00:00:00 2019-09-10 00:00:00 5 1 1 5 Menu \N fa-bars /menu 2019-09-10 00:00:00 2019-09-10 00:00:00 6 1 1 6 Operation log \N fa-history /info/op 2019-09-10 00:00:00 2019-09-10 00:00:00 7 0 1 1 Dashboard \N fa-bar-chart / 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: goadmin_operation_log; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_operation_log (id, user_id, path, method, ip, input, created_at, updated_at) FROM stdin; \. -- -- Data for Name: goadmin_site; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_site (id, key, value, description, state, created_at, updated_at) FROM stdin; \. -- -- Data for Name: goadmin_permissions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_permissions (id, name, slug, http_method, http_path, created_at, updated_at) FROM stdin; 1 All permission * * 2019-09-10 00:00:00 2019-09-10 00:00:00 2 Dashboard dashboard GET,PUT,POST,DELETE / 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: goadmin_role_menu; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_role_menu (role_id, menu_id, created_at, updated_at) FROM stdin; 1 1 2019-09-10 00:00:00 2019-09-10 00:00:00 1 7 2019-09-10 00:00:00 2019-09-10 00:00:00 2 7 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: goadmin_role_permissions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_role_permissions (role_id, permission_id, created_at, updated_at) FROM stdin; 1 1 2019-09-10 00:00:00 2019-09-10 00:00:00 1 2 2019-09-10 00:00:00 2019-09-10 00:00:00 2 2 2019-09-10 00:00:00 2019-09-10 00:00:00 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N 0 3 \N \N \. -- -- Data for Name: goadmin_role_users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_role_users (role_id, user_id, created_at, updated_at) FROM stdin; 1 1 2019-09-10 00:00:00 2019-09-10 00:00:00 2 2 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: goadmin_roles; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_roles (id, name, slug, created_at, updated_at) FROM stdin; 1 Administrator administrator 2019-09-10 00:00:00 2019-09-10 00:00:00 2 Operator operator 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: goadmin_session; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_session (id, sid, "values", created_at, updated_at) FROM stdin; 2 f5a99916-36c8-4fd6-8873-6f2be8845cd0 {"user_id":1} 2019-11-27 22:26:11.917665 2019-11-27 22:26:11.917665 3 03263ffc-0043-4b89-a02f-3aa616bbf857 {"user_id":3} 2019-11-27 22:26:12.819931 2019-11-27 22:26:12.819931 \. -- -- Data for Name: goadmin_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_user_permissions (user_id, permission_id, created_at, updated_at) FROM stdin; 2 2 2019-09-10 00:00:00 2019-09-10 00:00:00 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 0 1 \N \N 1 1 2019-11-27 22:26:12.425769 2019-11-27 22:26:12.425769 3 1 2019-11-27 22:26:12.572997 2019-11-27 22:26:12.572997 \. -- -- Data for Name: goadmin_users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.goadmin_users (id, username, password, name, avatar, remember_token, created_at, updated_at) FROM stdin; 1 admin $2a$10$OxWYJJGTP2gi00l2x06QuOWqw5VR47MQCJ0vNKnbMYfrutij10Hwe admin tlNcBVK9AvfYH7WEnwB1RKvocJu8FfRy4um3DJtwdHuJy0dwFsLOgAc0xUfh 2019-09-10 00:00:00 2019-09-10 00:00:00 2 operator $2a$10$rVqkOzHjN2MdlEprRflb1eGP0oZXuSrbJLOmJagFsCd81YZm0bsh. Operator \N 2019-09-10 00:00:00 2019-09-10 00:00:00 \. -- -- Data for Name: user_like_books; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_like_books (id, user_id, name, created_at, updated_at) FROM stdin; 1 1 Robinson Crusoe 2020-03-15 09:00:57.409596 2020-03-15 09:00:57.409596 \. -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.users (id, name, homepage, email, birthday, country, city, password, ip, certificate, money, resume, gender, fruit, drink, experience, created_at, updated_at, member_id) FROM stdin; 1 Jack http://jack.me jack@163.com 1993-10-21 00:00:00+08 china guangzhou 123456 127.0.0.1 \N 10

Jacks Resume

0 apple water 0 2020-03-09 15:24:00 2020-03-09 15:24:00 0 \. -- -- Name: goadmin_menu_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_menu_myid_seq', 7, true); -- -- Name: goadmin_operation_log_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_operation_log_myid_seq', 1, true); -- -- Name: goadmin_permissions_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_permissions_myid_seq', 2, true); -- -- Name: goadmin_roles_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_roles_myid_seq', 2, true); -- -- Name: goadmin_session_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_session_myid_seq', 1, true); -- -- Name: goadmin_site_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_site_myid_seq', 1, true); -- -- Name: goadmin_users_myid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.goadmin_users_myid_seq', 2, true); -- -- Name: goadmin_menu goadmin_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_menu ADD CONSTRAINT goadmin_menu_pkey PRIMARY KEY (id); -- -- Name: goadmin_operation_log goadmin_operation_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_operation_log ADD CONSTRAINT goadmin_operation_log_pkey PRIMARY KEY (id); -- -- Name: goadmin_permissions goadmin_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_permissions ADD CONSTRAINT goadmin_permissions_pkey PRIMARY KEY (id); -- -- Name: goadmin_roles goadmin_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_roles ADD CONSTRAINT goadmin_roles_pkey PRIMARY KEY (id); -- -- Name: goadmin_site goadmin_site_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_site ADD CONSTRAINT goadmin_site_pkey PRIMARY KEY (id); -- -- Name: goadmin_session goadmin_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_session ADD CONSTRAINT goadmin_session_pkey PRIMARY KEY (id); -- -- Name: goadmin_users goadmin_users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.goadmin_users ADD CONSTRAINT goadmin_users_pkey PRIMARY KEY (id); -- -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --