当前仓库属于关闭状态,部分功能使用受限,详情请查阅 仓库状态说明
521 Star 1K Fork 700

龙影 / ECP
关闭

 / 详情

龙影你好

已完成
创建于  
2015-01-08 21:22

我在恢复数据库文件的时候,恢复总是有4处错误,请问您使用的postgresql是多少版本的,能否将您机子上的数据文件备份一份给我呢,万分感谢!

总是提示如下错误:

警告: 恢复中忽略错误: 4

进程退出并返回 1。

评论 (6)

使用的是postgresql 9.2的版本。目前为止还未有其他的朋友不能导入的。你看看是否你的数据库安装不正确或是其他的问题。

请看下wiki中的简要说明

我卸载了9.4的安装9.2的了,但还是报同样的错误,我把异常信息粘贴在下面,请帮忙看下,谢谢!
[Err] 错误: 角色 "ecp" 不存在

[Err] --
-- Name: COLUMN sso_person.mobile; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.mobile IS '手机';

--
-- Name: COLUMN sso_person.telephone; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.telephone IS '电话';

--
-- Name: COLUMN sso_person.address; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.address IS '地址';

--
-- Name: COLUMN sso_person.weixinid; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.weixinid IS '微信号';

--
-- Name: COLUMN sso_person.head_pic; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.head_pic IS '头像';

--
-- Name: COLUMN sso_person.department; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.department IS '部门';

--
-- Name: COLUMN sso_person.post; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.post IS '岗位';

--
-- Name: COLUMN sso_person.saltname; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.saltname IS '称呼';

--
-- Name: COLUMN sso_person.qq; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.qq IS 'qq';

--
-- Name: COLUMN sso_person.xinzuo; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.xinzuo IS '星座';

--
-- Name: COLUMN sso_person.blood_type; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.blood_type IS '血型';

--
-- Name: COLUMN sso_person."character"; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person."character" IS '性格';

--
-- Name: COLUMN sso_person.company_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person.company_id IS '企业id';

--
-- Name: sso_person_data; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABLE sso_person_data (
id character varying(10) NOT NULL,
data text NOT NULL
);

ALTER TABLE public.sso_person_data OWNER TO postgres;

--
-- Name: TABLE sso_person_data; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON TABLE sso_person_data IS '人员属性数据';

--
-- Name: COLUMN sso_person_data.id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person_data.id IS 'id';

--
-- Name: COLUMN sso_person_data.data; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_person_data.data IS 'd自定义数据';

--
-- Name: sso_position; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABLE sso_position (
id character varying(10) NOT NULL,
company_id character varying(10) NOT NULL,
parent_id character varying(10),
parentids character varying(50),
department_id character varying(10),
departids character varying(100),
name character varying(20) NOT NULL,
description character varying(200),
permission text,
quota smallint DEFAULT 1,
type integer,
sort_num integer DEFAULT 1,
is_head integer,
m integer
);

ALTER TABLE public.sso_position OWNER TO postgres;

--
-- Name: TABLE sso_position; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON TABLE sso_position IS '岗位';

--
-- Name: COLUMN sso_position.id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_position.id IS 'id';

--
-- Name: COLUMN sso_position.company_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_position.company_id IS '企业id';

--
-- Name: COLUMN sso_position.parent_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_position.parent_id IS '父级id';

--
-- Name: COLUMN sso_position.parentids; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_position.parentids IS 'p父级id集合';

--
-- Name: COLUMN sso_position.department_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_position.department_id IS '部门id';

--
-- Name: COLUMN sso_position.departids; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN sso_positio
[Err] 错误: 语法错误 在 "1" 或附近的
LINE 527: 1 \N 北京 4 1
^

[Err] --
-- Name: COLUMN wf_hist_task.expire_time; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task.expire_time IS '任务期望完成时间';

--
-- Name: COLUMN wf_hist_task.action_url; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task.action_url IS '任务处理url';

--
-- Name: COLUMN wf_hist_task.parent_task_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task.parent_task_id IS '父任务ID';

--
-- Name: COLUMN wf_hist_task.variable; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task.variable IS '附属变量json存储';

--
-- Name: wf_hist_task_actor; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABLE wf_hist_task_actor (
task_id character varying(100) NOT NULL,
actor_id character varying(100) NOT NULL
);

ALTER TABLE public.wf_hist_task_actor OWNER TO postgres;

--
-- Name: TABLE wf_hist_task_actor; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON TABLE wf_hist_task_actor IS '历史任务参与者表';

--
-- Name: COLUMN wf_hist_task_actor.task_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task_actor.task_id IS '任务ID';

--
-- Name: COLUMN wf_hist_task_actor.actor_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_hist_task_actor.actor_id IS '参与者ID';

--
-- Name: wf_order; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABLE wf_order (
id character varying(100) NOT NULL,
parent_id character varying(100),
process_id character varying(100) NOT NULL,
creator character varying(100),
create_time character varying(50) NOT NULL,
expire_time character varying(50),
last_update_time character varying(50),
last_updator character varying(100),
priority smallint,
parent_node_name character varying(100),
order_no character varying(100),
variable character varying(2000),
version smallint
);

ALTER TABLE public.wf_order OWNER TO postgres;

--
-- Name: TABLE wf_order; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON TABLE wf_order IS '流程实例表';

--
-- Name: COLUMN wf_order.id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.id IS '主键ID';

--
-- Name: COLUMN wf_order.parent_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.parent_id IS '父流程ID';

--
-- Name: COLUMN wf_order.process_id; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.process_id IS '流程定义ID';

--
-- Name: COLUMN wf_order.creator; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.creator IS '发起人';

--
-- Name: COLUMN wf_order.create_time; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.create_time IS '发起时间';

--
-- Name: COLUMN wf_order.expire_time; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.expire_time IS '期望完成时间';

--
-- Name: COLUMN wf_order.last_update_time; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.last_update_time IS '上次更新时间';

--
-- Name: COLUMN wf_order.last_updator; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.last_updator IS '上次更新人';

--
-- Name: COLUMN wf_order.priority; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.priority IS '优先级';

--
-- Name: COLUMN wf_order.parent_node_name; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.parent_node_name IS '父流程依赖的节点名称';

--
-- Name: COLUMN wf_order.order_no; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.order_no IS '流程实例编号';

--
-- Name: COLUMN wf_order.variable; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.variable IS '附属变量json存储';

--
-- Name: COLUMN wf_order.version; Type: COMMENT; Schema: public; Owner: postgres

COMMENT ON COLUMN wf_order.version IS '版本';

--
-- Name: wf_process; Type: TABLE; Schema: public; Owner: postgres; Tablespace:

CREATE TABL
[Err] 错误: 语法错误 在 "1001" 或附近的
LINE 2: 1001 0001 1001 库存现金 0 0 1 0
^

[Err] 1001 0001 1001 库存现金 0 0 1 0
1002 0001 1002 银行存款 0 0 1 0
100201 1002 0001 100201 招行科技园支行 0 0 1 0
100202 1002 0001 100202 工行高新支行 0 0 1 0
100203 1002 0001 100203 农行港币户 0 0 1 0
1012 0001 1012 其他货币资金 0 0 1 0
1101 0001 1101 短期投资 0 0 1 0
110101 1101 0001 110101 股票 0 0 1 0
110102 1101 0001 110102 债券 0 0 1 0
110103 1101 0001 110103 基金 0 0 1 0
110110 1101 0001 110110 其他 0 0 1 0
1121 0001 1121 应收票据 0 0 1 0
1122 0001 1122 应收账款 0 0 1 0
1123 0001 1123 预付账款 0 0 1 0
1131 0001 1131 应收股利 0 0 1 0
1132 0001 1132 应收利息 0 0 1 0
1221 0001 1221 其他应收款 0 0 1 0
1401 0001 1401 材料采购 0 0 1 0
1402 0001 1402 在途物资 0 0 1 0
1403 0001 1403 原材料 0 0 1 0
1404 0001 1404 材料成本差异 0 0 1 0
1405 0001 1405 库存商品 0 0 1 0
1407 0001 1407 商品进销差价 0 0 1 0
1408 0001 1408 委托加工物资 0 0 1 0
1411 0001 1411 周转材料 0 0 1 0
1421 0001 1421 消耗性生物资产 0 0 1 0
1501 0001 1501 长期债券投资 0 1 1 0
150101 1501 0001 150101 债券投资 0 1 1 0
150102 1501 0001 150102 其他债权投资 0 1 1 0
1511 0001 1511 长期股权投资 0 1 1 0
151101 1511 0001 151101 股票投资 0 1 1 0
151102 1511 0001 151102 其他股权投资 0 1 1 0
1601 0001 1601 固定资产 0 1 1 0
1602 0001 1602 累计折旧 0 1 1 1
1604 0001 1604 在建工程 0 1 1 0
160401 1604 0001 160401 建筑工程 0 1 1 0
160402 1604 0001 160402 安装工程 0 1 1 0
160403 1604 0001 160403 技术改造工程 0 1 1 0
160404 1604 0001 160404 其他支出 0 1 1 0
1605 0001 1605 工程物资 0 1 1 0
1606 0001 1606 固定资产清理 0 1 1 0
1621 0001 1621 生产性生物资产 0 1 1 0
1622 0001 1622 生产性生物资产累计折旧 0 1 1 1
1701 0001 1701 无形资产 0 1 1 0
1702 0001 1702 累计摊销 0 1 1 1
1801 0001 1801 长期待摊费用 0 1 1 0
1901 0001 1901 待处理财产损溢 0 1 1 0
2001 0001 2001 短期0款 1 2 1 1
2201 0001 2201 应付票据 1 2 1 1
2202 0001 2202 应付账款 1 2 1 1
2203 0001 2203 预收账款 1 2 1 1
2211 0001 2211 应付职工薪酬 1 2 1 1
2221 0001 2221 应交税费 1 2 1 1
222101 2221 0001 222101 应交增值税 1 2 1 1
22210101 222101 0001 22210101 进项税额 1 2 1 0
22210102 222101 0001 22210102 已交税金 1 2 1 0
22210103 222101 0001 22210103 减免税款 1 2 1 0
22210104 222101 0001 22210104 出口抵减内销产品应纳税额 1 2 1 0
22210105 222101 0001 22210105 转出未交增值税 1 2 1 0
22210106 222101 0001 22210106 销项税额 1 2 1 1
22210107 222101 0001 22210107 出口退税 1 2 1 1
22210108 222101 0001 22210108 进项税额转出 1 2 1 1
22210109 222101 0001 22210109 转出多交增值税 1 2 1 1
222102 2221 0001 222102 未交增值税 1 2 1 1
222103 2221 0001 222103 应交营业税 1 2 1 1
222104 2221 0001 222104 应交消费税 1 2 1 1
222105 2221 0001 222105 应交资源税 1 2 1 1
222106 2221 0001 222106 应交所得税 1 2 1 1
222107 2221 0001 222107 应交土地增值税 1 2 1 1
222108 2221 0001 222108 应交城市维护建设税 1 2 1 1
222109 2221 0001 222109 应交房产税 1 2 1 1
222110 2221 0001 222110 应交土地使用税 1 2 1 1
222111 2221 0001 222111 应交车船使用税 1 2 1 1
222112 2221 0001 222112 应交个人所得税 1 2 1 1
222113 2221 0001 222113 教育费附加 1 2 1 1
2231 0001 2231 应付利息 1 2 1 1
2232 0001 2232 应付利润 1 2 1 1
2241 0001 2241 其他应付款 1 2 1 1
2401 0001 2401 递延收益 1 2 1 1
2501 0001 2501 长期0款 1 2 1 1
2701 0001 2701 长期应付款 1 2 1 1
3001 0001 3001 实收资本 2 4 1 1
3002 0001 3002 资本公积 2 4 1 1
300201 3002 0001 300201 资本溢价 2 4 1 1
300202 3002 0001 300202 接受捐赠非现金资产准备 2 4 1 1
300206 3002 0001 300206 外币资本折算差额 2 4 1 1
300207 3002 0001 300207 其他资本公积 2 4 1 1
3101 0001 3101 盈余公积 2 4 1 1
310101 3101 0001 310101 法定盈余公积 2 4 1 1
310102 3101 0001 310102 任意盈余公积 2 4 1 1
310103 3101 0001 310103 法定公益金 2 4 1 1
3103 0001 3103 本年利润 2 4 1 1
3104 0001 3104 利润分配 2 4 1 1
310401 3104 0001 310401 其他转入 2 4 1 0
310402 3104 0001 310402 提取法定盈余公积 2 4 1 0
310403 3104 0001 310403 提取法定公益金 2 4 1 0
310409 3104 0001 310409 提取任意盈余公积 2 4 1 0
310410 3104 0001 310410 应付利润 2 4 1 0
310411 3104 0001 310411 转作资本的利润 2 4 1 0
310415 3104 0001 310415 未分配利润 2 4 1 1
4001 0001 4001 生产成本 3 5 1 0
400101 4001 0001 400101 基本生产成本 3 5 1 0
400102 4001 0001 400102 辅助生产成本 3 5 1 0
4101 0001 4101 制造费用 3 5 1 0
4301 0001 4301 研发支出 3 5 1 0
4401 0001 4401 工程施工 3 5 1 0
4403 0001 4403 机械作业 3 5 1 0
5001 0001 5001 主营业务收入 4 6 1 1
5051 0001 5051 其他业务收入 4 7 1 1
5111 0001 5111 投资收益 4 7 1 1
5301 0001 5301 营业外收入 4 7 1 1
530101 5301 0001 530101 非流动资产处置净收益 4 7 1 1
530102 5301 0001 530102 政府补助 4 7 1 1
530103 5301 0001 530103 捐赠收益 4 7 1 1
530104 5301 0001 530104 盘盈收益 4 7 1 1
530105 5301 0001 530105 其他 4 7 1 1
5401 0001 5401 主营业务成本 4 11 1 0
5402 0001 5402 其他业务成本 4 10 1 0
5403 0001 5403 营
[Err] 错误: 关系 "sso_person_data" 不存在

[Err] --
-- Name: oa_file_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_file
ADD CONSTRAINT oa_file_pkey PRIMARY KEY (id);

--
-- Name: oa_knowledge_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_pkey PRIMARY KEY (id);

--
-- Name: oa_message_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_message
ADD CONSTRAINT oa_message_pkey PRIMARY KEY (id);

--
-- Name: oa_notice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_notice
ADD CONSTRAINT oa_notice_pkey PRIMARY KEY (id);

--
-- Name: oa_task_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_task
ADD CONSTRAINT oa_task_pkey PRIMARY KEY (id);

--
-- Name: oa_topic_rep_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_topic_rep
ADD CONSTRAINT oa_topic_rep_pkey PRIMARY KEY (id);

--
-- Name: oa_workreport_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_workreport
ADD CONSTRAINT oa_workreport_pkey PRIMARY KEY (id);

--
-- Name: oa_workreporttemp_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_workreporttemp
ADD CONSTRAINT oa_workreporttemp_name_key UNIQUE (name);

--
-- Name: oa_workreporttemp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY oa_workreporttemp
ADD CONSTRAINT oa_workreporttemp_pkey PRIMARY KEY (id);

--
-- Name: os_topic_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY os_topic
ADD CONSTRAINT os_topic_pkey PRIMARY KEY (id);

--
-- Name: scm_competitor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_competitor
ADD CONSTRAINT scm_competitor_pkey PRIMARY KEY (id);

--
-- Name: scm_depot_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_depot
ADD CONSTRAINT scm_depot_pkey PRIMARY KEY (id);

--
-- Name: scm_order_data_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_order_data
ADD CONSTRAINT scm_order_data_id_key UNIQUE (id);

--
-- Name: scm_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_order
ADD CONSTRAINT scm_order_pkey PRIMARY KEY (id);

--
-- Name: scm_product_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_product
ADD CONSTRAINT scm_product_pkey PRIMARY KEY (id);

--
-- Name: scm_product_price_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_product_price_order
ADD CONSTRAINT scm_product_price_order_pkey PRIMARY KEY (id);

--
-- Name: scm_stock_allot_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_stock_allot
ADD CONSTRAINT scm_stock_allot_pkey PRIMARY KEY (id);

--
-- Name: scm_stock_check_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_stock_check
ADD CONSTRAINT scm_stock_check_pkey PRIMARY KEY (id);

--
-- Name: scm_storage_bill_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY scm_storage_bill
ADD CONSTRAINT scm_storage_bill_pkey PRIMARY KEY (id);

--
-- Name: sso_action_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY sso_action_log
ADD CONSTRAINT sso_action_log_pkey PRIMARY KEY (id);

--
-- Name: sso_company_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY sso_company
ADD CONSTRAINT sso_company_code_key UNIQUE (code);

--
-- Name: sso_company_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:

ALTER TABLE ONLY sso_company
ADD CON
[Err] 错误: 关系 "wf_hist_task_actor" 不存在

[Err] --
-- Name: fk_hist_taskactor; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY wf_hist_task_actor
ADD CONSTRAINT fk_hist_taskactor FOREIGN KEY (task_id) REFERENCES wf_hist_task(id);

--
-- Name: fk_order_parentid; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY wf_order
ADD CONSTRAINT fk_order_parentid FOREIGN KEY (parent_id) REFERENCES wf_order(id);

--
-- Name: fk_order_processid; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY wf_order
ADD CONSTRAINT fk_order_processid FOREIGN KEY (process_id) REFERENCES wf_process(id);

--
-- Name: fk_task_actor_taskid; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY wf_task_actor
ADD CONSTRAINT fk_task_actor_taskid FOREIGN KEY (task_id) REFERENCES wf_task(id);

--
-- Name: fk_task_orderid; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY wf_task
ADD CONSTRAINT fk_task_orderid FOREIGN KEY (order_id) REFERENCES wf_order(id);

--
-- Name: hr_assessment_kpi_model_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY hr_assessment_kpi
ADD CONSTRAINT hr_assessment_kpi_model_id_fkey FOREIGN KEY (model_id) REFERENCES hr_assessment_model(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: hr_assessment_model_postion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY hr_assessment_model
ADD CONSTRAINT hr_assessment_model_postion_id_fkey FOREIGN KEY (postion_id) REFERENCES sso_position(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: hr_pact_employee_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY hr_pact
ADD CONSTRAINT hr_pact_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES hr_employee(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: hr_salary_employee_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY hr_salary
ADD CONSTRAINT hr_salary_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES hr_employee(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_comment_creator_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_comment
ADD CONSTRAINT oa_comment_creator_role_id_fkey FOREIGN KEY (creator_role_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_dream_board_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_dream_board
ADD CONSTRAINT oa_dream_board_company_id_fkey FOREIGN KEY (company_id) REFERENCES sso_company(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_dream_board_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_dream_board
ADD CONSTRAINT oa_dream_board_user_id_fkey FOREIGN KEY (user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_file_creater_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_file
ADD CONSTRAINT oa_file_creater_id_fkey FOREIGN KEY (creater_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_knowledge_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_category_id_fkey FOREIGN KEY (category_id) REFERENCES sso_parame(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_knowledge_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_knowledge
ADD CONSTRAINT oa_knowledge_user_id_fkey FOREIGN KEY (user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_message_from_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

ALTER TABLE ONLY oa_message
ADD CONSTRAINT oa_message_from_user_id_fkey FOREIGN KEY (from_user_id) REFERENCES sso_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;

--
-- Name: oa_message_to_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres

[Msg] Finished - Unsuccessfully

搜索下 ecp, 然后 改成 你 数据库里 对应的 名称 就可以了

已经搞定了 谢谢

状态更改为 已关闭

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(3)
5147 loyin 1578914312
Java
1
https://gitee.com/loyin/ECP.git
git@gitee.com:loyin/ECP.git
loyin
ECP
ECP

搜索帮助