收银系统更新

1. 更新 BMP 电子发票

相关信息

1、需要创建新 北洋数据结构
2、删除资源并重启服务

--备份
mkdir /u02/bak/20240605
cp -rf POSServer* /u02/bak/20240605
--更新数据结构
ALTER TABLE "T_ORDER"
ADD ("BMP_UPLOAD_STATUS" VARCHAR2(1));

COMMENT ON COLUMN "T_ORDER"."BMP_UPLOAD_STATUS" IS '订单上传到bmp：1 成功 0失败';

ALTER TABLE "H_T_ORDER"
ADD ("BMP_UPLOAD_STATUS" VARCHAR2(1));



alter TABLE POS_TERMINAL add (DEVICE_TYPE VARCHAR2(32));

alter table SOFT_INFO add (DEVICE_TYPE VARCHAR2(32));
COMMENT ON COLUMN "H_T_ORDER"."BMP_UPLOAD_STATUS" IS '订单上传到bmp：1 成功 0失败';
--更新同步标记
update t_order set BMP_UPLOAD_STATUS='1'
commit;
update h_t_order set BMP_UPLOAD_STATUS='1'
commit;

2. 更新新北洋

--更新新北洋
-- Create table
create table XBY_POS_INFO
(
  pos_no          NUMBER(10) not null,
  vem_id          VARCHAR2(50),
  sync_start_time DATE
)
tablespace BHG_SPACE;
-- Add comments to the columns
comment on column XBY_POS_INFO.pos_no
  is '款台号';
comment on column XBY_POS_INFO.vem_id
  is '售货机编码';
comment on column XBY_POS_INFO.sync_start_time
  is '开始同步数据时间';
-- Create/Recreate primary, unique and foreign key constraints
alter table XBY_POS_INFO
  add primary key (POS_NO);
  alter table h_t_order add (XBY_ORDER_ID varchar2(30));
alter table t_order add (XBY_ORDER_ID varchar2(30));