alter table im_group add column is_permit_out VARCHAR(1) DEFAULT 'Y' NOT NULL; COMMENT ON COLUMN im_group.is_permit_out IS 'Y-允许退群,N不允许退群'; alter table im_group_his add column is_permit_out VARCHAR(1) DEFAULT 'Y' NOT NULL; COMMENT ON COLUMN im_group_his.is_permit_out IS 'Y-允许退群,N不允许退群'; alter table pr_order_archives add column init_party_type varchar(3) default 'nil'::character varying; alter table pr_order_archives add column init_party_id numeric(9) default '-1'::integer; alter table pr_order_archives add column init_party_name varchar(256) default 'nil'::character varying; alter table pr_order_archives add column init_org_id numeric(9) default '-1'::integer; alter table pr_order_archives add column init_org_name varchar(256) default 'nil'::character varying; COMMENT ON COLUMN pr_order_archives.init_party_type IS '初始派发处理人类型'; COMMENT ON COLUMN pr_order_archives.init_party_id IS '初始派发处理人ID'; COMMENT ON COLUMN pr_order_archives.init_party_name IS '初始派发处理人名称'; COMMENT ON COLUMN pr_order_archives.init_org_id IS '初始派发处理人组织ID'; COMMENT ON COLUMN pr_order_archives.init_org_name IS '初始派发处理人组织名称';改成oracle的语法
时间: 2024-04-07 10:30:46 浏览: 14
ALTER TABLE im_group ADD is_permit_out VARCHAR2(1) DEFAULT 'Y' NOT NULL;
COMMENT ON COLUMN im_group.is_permit_out IS 'Y-允许退群,N不允许退群';
ALTER TABLE im_group_his ADD is_permit_out VARCHAR2(1) DEFAULT 'Y' NOT NULL;
COMMENT ON COLUMN im_group_his.is_permit_out IS 'Y-允许退群,N不允许退群';
ALTER TABLE pr_order_archives ADD init_party_type VARCHAR2(3) DEFAULT 'nil' NOT NULL;
ALTER TABLE pr_order_archives ADD init_party_id NUMBER(9) DEFAULT -1 NOT NULL;
ALTER TABLE pr_order_archives ADD init_party_name VARCHAR2(256) DEFAULT 'nil' NOT NULL;
ALTER TABLE pr_order_archives ADD init_org_id NUMBER(9) DEFAULT -1 NOT NULL;
ALTER TABLE pr_order_archives ADD init_org_name VARCHAR2(256) DEFAULT 'nil' NOT NULL;
COMMENT ON COLUMN pr_order_archives.init_party_type IS '初始派发处理人类型';
COMMENT ON COLUMN pr_order_archives.init_party_id IS '初始派发处理人ID';
COMMENT ON COLUMN pr_order_archives.init_party_name IS '初始派发处理人名称';
COMMENT ON COLUMN pr_order_archives.init_org_id IS '初始派发处理人组织ID';
COMMENT ON COLUMN pr_order_archives.init_org_name IS '初始派发处理人组织名称';