qt
/
weaver-hrm-salary
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
weaver-hrm-salary/resource/sqlupgrade/Mysql/sql202206071403.sql

141 lines
7.2 KiB
MySQL
Raw Permalink Normal View History

上线脚本
2023-06-26 15:48:25 +08:00
CREATE TABLE hrsa_tax_agent_emp
(
id bigint(20) NOT NULL COMMENT 'ID',
create_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD>޸<EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
delete_type int(11) NULL DEFAULT 0,
tenant_key varchar(10) NULL DEFAULT NULL COMMENT '<EFBFBD>⻧KEY',
tax_agent_id bigint(20) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_id bigint(20) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_name varchar(255) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE,
INDEX idx_tax_agent(tax_agent_id) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_emp_change
(
id bigint(20) NOT NULL COMMENT 'ID',
create_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD>޸<EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
delete_type int(11) NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NULL DEFAULT NULL COMMENT '<EFBFBD>⻧KEY',
tax_agent_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
change_type int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͡<EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>2<EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD>',
employee_name varchar(255) NULL DEFAULT NULL,
module_type int(4) NOT NULL DEFAULT 0,
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE,
INDEX idx_tax_agent(tax_agent_id) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_admin
(
id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
tax_agent_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
create_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
delete_type int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>0<EFBFBD><EFBFBD>δɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NOT NULL DEFAULT '' COMMENT '<EFBFBD>⻧ID',
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE,
INDEX idx_employee_id(employee_id) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_manage_range
(
id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
tax_agent_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD>id',
employee_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
tax_agent_sub_admin_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵ķֹ<EFBFBD><EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>id',
target_type tinyint(4) NOT NULL DEFAULT 1 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͡<EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>2<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>š<EFBFBD>3<EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ',
target_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_status varchar(100) NOT NULL,
include_type int(4) NOT NULL DEFAULT 1,
creator bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
create_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
delete_type int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>0<EFBFBD><EFBFBD>δɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NOT NULL DEFAULT '' COMMENT '<EFBFBD>⻧ID',
range_type int(4) NOT NULL DEFAULT 0,
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant(tenant_key) USING BTREE,
INDEX idx_tax_agent_sub_admin_id(tax_agent_sub_admin_id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_base
(
id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
devolution_status int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>Ȩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬<EFBFBD><EFBFBD>0<EFBFBD><EFBFBD><EFBFBD>ء<EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
create_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0) ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
delete_type int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>0<EFBFBD><EFBFBD>δɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NOT NULL DEFAULT '' COMMENT '<EFBFBD>⻧ID',
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_sub_admin
(
id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
tax_agent_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_id bigint(20) NOT NULL COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
description varchar(100) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
create_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
delete_type int(11) NOT NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>0<EFBFBD><EFBFBD>δɾ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NOT NULL DEFAULT '' COMMENT '<EFBFBD>⻧ID',
remark text NULL,
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE,
INDEX idx_tax_agent_id(tax_agent_id) USING BTREE,
INDEX idx_employee_id(employee_id) USING BTREE
) ;
CREATE TABLE hrsa_tax_agent_sub_admin_emp
(
id bigint(20) NOT NULL COMMENT 'ID',
create_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>',
update_time datetime(0) NULL DEFAULT NULL COMMENT '<EFBFBD>޸<EFBFBD>ʱ<EFBFBD><EFBFBD>',
creator bigint(20) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
delete_type int(11) NULL DEFAULT 0 COMMENT '<EFBFBD>Ƿ<EFBFBD>ɾ<EFBFBD><EFBFBD>',
tenant_key varchar(10) NULL DEFAULT NULL COMMENT '<EFBFBD>⻧KEY',
tax_agent_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
tax_agent_sub_admin_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵ķֹ<EFBFBD><EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>id',
employee_id bigint(20) NOT NULL DEFAULT 0 COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
employee_name varchar(255) NULL DEFAULT NULL COMMENT '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',
PRIMARY KEY (id) USING BTREE,
INDEX idx_tenant_key(tenant_key) USING BTREE,
INDEX idx_tax_agent(tax_agent_id) USING BTREE
) ;
ALTER TABLE hrsa_tax_agent ADD COLUMN payment_agency varchar(255) NULL COMMENT '<EFBFBD><EFBFBD><EFBFBD>ɻ<EFBFBD><EFBFBD><EFBFBD>' ;
ALTER TABLE hrsa_salary_sob ADD COLUMN tax_agent_id bigint(0) NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ;
INSERT INTO hrsa_tax_agent_base(id, devolution_status, create_time, update_time, creator, delete_type, tenant_key) VALUES (1653303537239, 1, '2022-05-23 18:58:53', '2022-05-23 19:12:12', 1, 0, 'all_teams');
ALTER TABLE hrsa_bill_detail_temp ADD COLUMN payment_organization bigint(0) NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ;
ALTER TABLE hrsa_bill_detail ADD COLUMN payment_organization bigint(0) NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ;
ALTER TABLE hrsa_bill_batch ADD COLUMN payment_organization bigint(0) NULL COMMENT '<EFBFBD><EFBFBD>˰<EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ;