From 5e472fb66090f87de04f1aa102996e5ed2f9f40a Mon Sep 17 00:00:00 2001 From: gongchunyi <deslre0381@gmail.com> Date: 星期五, 15 五月 2026 20:45:34 +0800 Subject: [PATCH] chore: 移除多余sql表 --- /dev/null | 5 ----- 1 files changed, 0 insertions(+), 5 deletions(-) diff --git a/doc/1767778273_add_product_order_id_to_product_work_order.sql b/doc/1767778273_add_product_order_id_to_product_work_order.sql deleted file mode 100644 index 8804120..0000000 --- a/doc/1767778273_add_product_order_id_to_product_work_order.sql +++ /dev/null @@ -1,2 +0,0 @@ -alter table product_work_order - add product_order_id bigint not null default 0 comment '鐢熶骇璁㈠崟id'; diff --git a/doc/20260113-product_model.sql b/doc/20260113-product_model.sql deleted file mode 100644 index dcbb610..0000000 --- a/doc/20260113-product_model.sql +++ /dev/null @@ -1,14 +0,0 @@ -alter table product_model - add product_code varchar(255) null comment '浜у搧缂栫爜'; - -alter table process_route - add process_route_code varchar(255) null comment '宸ヨ壓璺嚎缂栫爜'; - -alter table procurement_record_storage - add product_model_id bigint null comment '浜у搧瑙勬牸id'; -alter table procurement_record_out - add product_model_id bigint null comment '浜у搧瑙勬牸id'; - - -alter table quality_inspect - add product_model_id bigint null comment '浜у搧瑙勬牸id'; diff --git a/doc/20260114_add_dimission_reason_and_remark_to_staff_join_leave_record.sql b/doc/20260114_add_dimission_reason_and_remark_to_staff_join_leave_record.sql deleted file mode 100644 index 4c4acc2..0000000 --- a/doc/20260114_add_dimission_reason_and_remark_to_staff_join_leave_record.sql +++ /dev/null @@ -1,3 +0,0 @@ -alter table staff_join_leave_record - add dimission_reason varchar(255) null comment '绂昏亴鍘熷洜', - add dimission_remark text null comment '绂昏亴澶囨敞'; diff --git a/doc/20260115_add_sys_post_id_to_staff_join_leave_record.sql b/doc/20260115_add_sys_post_id_to_staff_join_leave_record.sql deleted file mode 100644 index 7fea0ad..0000000 --- a/doc/20260115_add_sys_post_id_to_staff_join_leave_record.sql +++ /dev/null @@ -1,6 +0,0 @@ -alter table staff_on_job - add sys_post_id bigint not null default 0 comment '宀椾綅id'; -alter table staff_on_job -drop column post_job; -alter table staff_on_job - add sys_dept_id bigint default 0 not null; \ No newline at end of file diff --git a/doc/20260116_create_table_staff_contract.sql b/doc/20260116_create_table_staff_contract.sql deleted file mode 100644 index f8fc20a..0000000 --- a/doc/20260116_create_table_staff_contract.sql +++ /dev/null @@ -1,13 +0,0 @@ -# 鍛樺伐鍚堝悓琛� -drop table if exists staff_contract; -create table staff_contract -( - id bigint auto_increment primary key, - staff_on_job_id bigint not null default 0 comment '鍛樺伐鍦ㄨ亴id', - contract_start_time datetime null comment '鍚堝悓寮�濮嬫椂闂�', - contract_end_time datetime null comment '鍚堝悓缁撴潫鏃堕棿', - contract_term int not null default 0 comment '鍚堝悓鏈熼檺', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); diff --git a/doc/20260116_create_table_staff_leave.sql b/doc/20260116_create_table_staff_leave.sql deleted file mode 100644 index 7e4b1cf..0000000 --- a/doc/20260116_create_table_staff_leave.sql +++ /dev/null @@ -1,13 +0,0 @@ -#鍛樺伐绂昏亴琛� -drop table if exists staff_join_leave_record; -drop table if exists staff_leave; -create table staff_leave -( - id bigint auto_increment primary key, - staff_on_job_id bigint not null default 0 comment '鍛樺伐鍦ㄨ亴id', - reason varchar(255) null comment '绂昏亴鍘熷洜', - remark text null comment '绂昏亴澶囨敞', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); diff --git a/doc/20260119-procurement_record_storage.sql b/doc/20260119-procurement_record_storage.sql deleted file mode 100644 index 923bbd3..0000000 --- a/doc/20260119-procurement_record_storage.sql +++ /dev/null @@ -1,2 +0,0 @@ -alter table procurement_record_storage - add quality_inspect_id bigint null comment '璐ㄦid'; \ No newline at end of file diff --git a/doc/20260128_add_unique_to_staff_on_job.sql b/doc/20260128_add_unique_to_staff_on_job.sql deleted file mode 100644 index 16b2221..0000000 --- a/doc/20260128_add_unique_to_staff_on_job.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE staff_on_job ADD unique (staff_no); \ No newline at end of file diff --git a/doc/20260209_create_personal_attendance_records.sql b/doc/20260209_create_personal_attendance_records.sql deleted file mode 100644 index 0a25e18..0000000 --- a/doc/20260209_create_personal_attendance_records.sql +++ /dev/null @@ -1,18 +0,0 @@ -#鍛樺伐鑰冨嫟琛� -drop table if exists personal_attendance_records; -create table personal_attendance_records -( - id bigint auto_increment primary key, - staff_on_job_id bigint not null default 0 comment '鍛樺伐鍦ㄨ亴id', - date date not null comment '鏃ユ湡', - work_start_at datetime null comment '宸ヤ綔寮�濮嬫椂闂�', - work_end_at datetime null comment '宸ヤ綔缁撴潫鏃堕棿', - work_hours decimal(5,2) null comment '宸ヤ綔鏃堕暱', - status tinyint not null default 0 comment '鐘舵�� 0姝ｅ父 1杩熷埌 2鏃╅��', - remark text null comment '澶囨敞', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿', - index idx_staff_on_job_id (staff_on_job_id), - unique idx_staff_on_job_id_date (staff_on_job_id, date) -); diff --git a/doc/20260306_create_purchase_return_orders.sql b/doc/20260306_create_purchase_return_orders.sql deleted file mode 100644 index 328cb00..0000000 --- a/doc/20260306_create_purchase_return_orders.sql +++ /dev/null @@ -1,38 +0,0 @@ -#浜у搧閫�璐у崟琛� -drop table if exists purchase_return_orders; -create table purchase_return_orders -( - id bigint auto_increment primary key, - no varchar(255) null comment '閫�璐у崟缂栧彿', - return_type tinyint not null default 0 comment '閫�璐ф柟寮� 0閫�璐ч��娆� 1鎷掓敹', - supplier_id bigint not null default 0 comment '渚涘簲鍟唅d', - project_id bigint not null default 0 comment '椤圭洰id', - project_phase tinyint not null default 0 comment '椤圭洰闃舵', - prepared_at datetime null comment '鍒跺崟鏃ユ湡', - prepared_user_id bigint not null default 0 comment '鍒跺崟浜篿d', - return_user_id bigint not null default 0 comment '閫�鏂欎汉id', - purchase_ledger_id bigint not null default 0 comment '閲囪喘璁㈠崟id', - total_discount_amount decimal(10, 2) null comment '鏁村崟鎶樻墸棰�', - total_discount_rate decimal(10, 2) null comment '鏁村崟鎶樻墸鐜�', - total_amount decimal(10,2) null comment '鎴愪氦閲戦', - remark text null comment '澶囨敞', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿', - index idx_supplier_id (supplier_id), - index idx_purchase_ledger_id (purchase_ledger_id), - index idx_project_id (project_id) -); - -#浜у搧閫�璐у崟涓庨噰璐骇鍝佸叧鑱旇〃 -drop table if exists purchase_return_order_products; -create table purchase_return_order_products -( - id bigint auto_increment primary key, - purchase_return_order_id bigint not null default 0 comment '閫�璐у崟id', - sales_ledger_product_id bigint not null default 0 comment '閲囪喘浜у搧id', - return_quantity decimal(16, 4) not null default 0 comment '閫�璐ф暟閲�', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿', - index idx_purchase_return_order_id (purchase_return_order_id), - index idx_sales_ledger_product_id (sales_ledger_product_id) -); \ No newline at end of file diff --git a/doc/alter_table_measuring_instrument_ledger.sql b/doc/alter_table_measuring_instrument_ledger.sql deleted file mode 100644 index 2c036fe..0000000 --- a/doc/alter_table_measuring_instrument_ledger.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE measuring_instrument_ledger - ADD COLUMN dept_id BIGINT COMMENT '閮ㄩ棬ID', - ADD COLUMN installation_location VARCHAR(255) COMMENT '瀹夎浣嶇疆', - ADD COLUMN unit VARCHAR(100) COMMENT '妫�瀹氬崟浣�', - ADD COLUMN cycle INT COMMENT '妫�瀹氬懆鏈燂紙澶╋級'; -- Gitblit v1.9.3