-- -- Kingbase database dump -- -- Dumped from database version 12.1 -- Dumped by sys_dump version 12.1 -- Started on 2024-10-23 14:27:20 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'GBK'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', 'public', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_with_oids = off; SET default_with_rowid = off; -- -- TOC entry 45 (class 2615 OID 21511) -- Name: z_report; Type: SCHEMA; Schema: -; Owner: system -- CREATE SCHEMA z_report; ALTER SCHEMA z_report OWNER TO system; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- TOC entry 1083 (class 1259 OID 21512) -- Name: report; Type: TABLE; Schema: z_report; Owner: sysdba -- SET escape = off; CREATE TABLE z_report.report ( id varcharbyte NOT NULL, index_code numeric, create_worker varcharbyte, create_time timestamp(6) without time zone, latest_modify_worker varcharbyte, latest_modify_time timestamp(6) without time zone, isvalid numeric, bz1 varcharbyte, bz2 varcharbyte, bz3 varcharbyte, bz4 varcharbyte, name varcharbyte, bz varcharbyte, report_catalog_id varcharbyte, datasource_url varcharbyte, report_mark varcharbyte, i_enable_save_word_btn integer, i_enable_save_excel_btn integer ); ALTER TABLE z_report.report OWNER TO sysdba; -- -- TOC entry 6728 (class 0 OID 0) -- Dependencies: 1083 -- Name: COLUMN report.i_enable_save_word_btn; Type: COMMENT; Schema: z_report; Owner: sysdba -- COMMENT ON COLUMN z_report.report.i_enable_save_word_btn IS '是否启用保存报表为Word按钮'; -- -- TOC entry 6729 (class 0 OID 0) -- Dependencies: 1083 -- Name: COLUMN report.i_enable_save_excel_btn; Type: COMMENT; Schema: z_report; Owner: sysdba -- COMMENT ON COLUMN z_report.report.i_enable_save_excel_btn IS '是否启用保存报表为Excel按钮'; -- -- TOC entry 1084 (class 1259 OID 21520) -- Name: report_catalog; Type: TABLE; Schema: z_report; Owner: sysdba -- SET escape = off; CREATE TABLE z_report.report_catalog ( id varcharbyte NOT NULL, index_code numeric, create_worker varcharbyte, create_time timestamp(6) without time zone, latest_modify_worker varcharbyte, latest_modify_time timestamp(6) without time zone, isvalid numeric, bz1 varcharbyte, bz2 varcharbyte, bz3 varcharbyte, bz4 varcharbyte, parent_id varcharbyte, name varcharbyte ); ALTER TABLE z_report.report_catalog OWNER TO sysdba; -- -- TOC entry 1085 (class 1259 OID 21528) -- Name: report_content; Type: TABLE; Schema: z_report; Owner: sysdba -- SET escape = off; CREATE TABLE z_report.report_content ( id varcharbyte NOT NULL, index_code numeric, create_worker varcharbyte, create_time timestamp(6) without time zone, latest_modify_worker varcharbyte, latest_modify_time timestamp(6) without time zone, isvalid numeric, bz1 varcharbyte, bz2 varcharbyte, bz3 varcharbyte, bz4 varcharbyte, content blob, report_id varcharbyte ); ALTER TABLE z_report.report_content OWNER TO sysdba; -- -- TOC entry 1086 (class 1259 OID 21887) -- Name: report_data_connection; Type: TABLE; Schema: z_report; Owner: sysdba -- SET escape = off; CREATE TABLE z_report.report_data_connection ( id varcharbyte NOT NULL, index_code numeric, create_worker varcharbyte, create_time timestamp(6) without time zone, latest_modify_worker varcharbyte, latest_modify_time timestamp(6) without time zone, isvalid numeric, bz1 varcharbyte, bz2 varcharbyte, bz3 varcharbyte, bz4 varcharbyte, name varcharbyte, connection_driver varcharbyte, connection_url varcharbyte, connection_username varcharbyte, connection_password varcharbyte, connection_identity varcharbyte ); ALTER TABLE z_report.report_data_connection OWNER TO sysdba; -- -- TOC entry 1087 (class 1259 OID 21895) -- Name: report_datasource; Type: TABLE; Schema: z_report; Owner: sysdba -- SET escape = off; CREATE TABLE z_report.report_datasource ( id varcharbyte NOT NULL, index_code numeric, create_worker varcharbyte, create_time timestamp(6) without time zone, latest_modify_worker varcharbyte, latest_modify_time timestamp(6) without time zone, isvalid numeric, bz1 varcharbyte, bz2 varcharbyte, bz3 varcharbyte, bz4 varcharbyte, sql blob, report_id varcharbyte, name varcharbyte, report_data_connection_id varcharbyte ); ALTER TABLE z_report.report_datasource OWNER TO sysdba; -- -- TOC entry 6717 (class 0 OID 21512) -- Dependencies: 1083 -- Data for Name: report; Type: TABLE DATA; Schema: z_report; Owner: sysdba -- -- -- TOC entry 6718 (class 0 OID 21520) -- Dependencies: 1084 -- Data for Name: report_catalog; Type: TABLE DATA; Schema: z_report; Owner: sysdba -- -- -- TOC entry 6719 (class 0 OID 21528) -- Dependencies: 1085 -- Data for Name: report_content; Type: TABLE DATA; Schema: z_report; Owner: sysdba -- -- -- TOC entry 6720 (class 0 OID 21887) -- Dependencies: 1086 -- Data for Name: report_data_connection; Type: TABLE DATA; Schema: z_report; Owner: sysdba -- -- -- TOC entry 6721 (class 0 OID 21895) -- Dependencies: 1087 -- Data for Name: report_datasource; Type: TABLE DATA; Schema: z_report; Owner: sysdba -- -- -- TOC entry 6176 (class 2606 OID 21527) -- Name: report_catalog report_catalog_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba -- ALTER TABLE ONLY z_report.report_catalog ADD CONSTRAINT report_catalog_pkey PRIMARY KEY (id); -- -- TOC entry 6178 (class 2606 OID 21535) -- Name: report_content report_content_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba -- ALTER TABLE ONLY z_report.report_content ADD CONSTRAINT report_content_pkey PRIMARY KEY (id); -- -- TOC entry 6180 (class 2606 OID 21894) -- Name: report_data_connection report_data_connection_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba -- ALTER TABLE ONLY z_report.report_data_connection ADD CONSTRAINT report_data_connection_pkey PRIMARY KEY (id); -- -- TOC entry 6182 (class 2606 OID 21902) -- Name: report_datasource report_datasource_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba -- ALTER TABLE ONLY z_report.report_datasource ADD CONSTRAINT report_datasource_pkey PRIMARY KEY (id); -- -- TOC entry 6174 (class 2606 OID 21519) -- Name: report report_pkey; Type: CONSTRAINT; Schema: z_report; Owner: sysdba -- ALTER TABLE ONLY z_report.report ADD CONSTRAINT report_pkey PRIMARY KEY (id); -- -- TOC entry 6727 (class 0 OID 0) -- Dependencies: 45 -- Name: SCHEMA z_report; Type: ACL; Schema: -; Owner: system -- GRANT ALL ON SCHEMA z_report TO z_report; -- Completed on 2024-10-23 14:27:21 -- -- Kingbase database dump complete --