From 600a8ae0735a911b2d9feb75cceb2dc21f1e2dbf Mon Sep 17 00:00:00 2001 From: yuan <123@> Date: 星期三, 24 六月 2026 19:29:46 +0800 Subject: [PATCH] docs: 删除doc目录下已废弃的SQL文件 --- /dev/null | 15 --------------- 1 files changed, 0 insertions(+), 15 deletions(-) diff --git a/doc/20260428_create_table_ai_chat_session.sql b/doc/20260428_create_table_ai_chat_session.sql deleted file mode 100644 index f490376..0000000 --- a/doc/20260428_create_table_ai_chat_session.sql +++ /dev/null @@ -1,16 +0,0 @@ -CREATE TABLE IF NOT EXISTS `ai_chat_session` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', - `memory_id` varchar(64) NOT NULL COMMENT '浼氳瘽ID', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID', - `tenant_id` bigint DEFAULT NULL COMMENT '绉熸埛ID', - `title` varchar(128) DEFAULT NULL COMMENT '浼氳瘽鏍囬', - `last_message` varchar(512) DEFAULT NULL COMMENT '鏈�鍚庝竴鏉℃秷鎭�', - `message_count` int NOT NULL DEFAULT 0 COMMENT '娑堟伅鏁伴噺', - `last_chat_time` datetime DEFAULT NULL COMMENT '鏈�鍚庤亰澶╂椂闂�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - PRIMARY KEY (`id`), - UNIQUE KEY `uk_ai_chat_session_memory_id` (`memory_id`), - KEY `idx_ai_chat_session_user_tenant` (`user_id`, `tenant_id`), - KEY `idx_ai_chat_session_last_chat_time` (`last_chat_time`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='AI鍘嗗彶浼氳瘽鍏冩暟鎹〃'; diff --git a/doc/20260506_add_ai_enabled_to_sys_user.sql b/doc/20260506_add_ai_enabled_to_sys_user.sql deleted file mode 100644 index 7e7ee9d..0000000 --- a/doc/20260506_add_ai_enabled_to_sys_user.sql +++ /dev/null @@ -1,2 +0,0 @@ -alter table sys_user - add ai_enabled tinyint(1) not null default 0 comment '鏄惁寮�閫欰I鍔熻兘锛�0鍚� 1鏄級'; diff --git a/doc/20260512_add_parent_id_to_account_subject.sql b/doc/20260512_add_parent_id_to_account_subject.sql deleted file mode 100644 index cf33a33..0000000 --- a/doc/20260512_add_parent_id_to_account_subject.sql +++ /dev/null @@ -1,5 +0,0 @@ --- account_subject 澧炲姞鐖剁骇绉戠洰瀛楁锛堟爲褰㈢粨鏋勶級 -ALTER TABLE `account_subject` -ADD COLUMN `parent_id` bigint NULL COMMENT '鐖剁鐩甀D锛堜负绌鸿〃绀烘牴鑺傜偣锛�' AFTER `id`; - -CREATE INDEX `idx_account_subject_parent_id` ON `account_subject` (`parent_id`); diff --git a/doc/20260512_create_financial_management_tables.sql b/doc/20260512_create_financial_management_tables.sql deleted file mode 100644 index db3caad..0000000 --- a/doc/20260512_create_financial_management_tables.sql +++ /dev/null @@ -1,104 +0,0 @@ --- 璐㈠姟绠＄悊妯″潡寤鸿〃鑴氭湰锛堝浐瀹氳祫浜�/鏃犲舰璧勪骇/鍑瘉/绉戠洰璐︼級 --- 璇存槑锛� --- 1) 鎬昏处绉戠洰缁х画澶嶇敤宸叉湁琛� account_subject锛屼笉閲嶅鍒涘缓 fin_account_subject銆� --- 2) 閲戦瀛楁缁熶竴 decimal(18,2)銆� - -CREATE TABLE IF NOT EXISTS `fin_fixed_asset` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', - `asset_code` varchar(64) NOT NULL COMMENT '璧勪骇缂栧彿', - `asset_name` varchar(128) NOT NULL COMMENT '璧勪骇鍚嶇О', - `category` varchar(64) NOT NULL COMMENT '璧勪骇绫诲埆', - `specification` varchar(255) DEFAULT NULL COMMENT '瑙勬牸鍨嬪彿', - `purchase_date` date NOT NULL COMMENT '璐疆鏃ユ湡', - `original_value` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '璧勪骇鍘熷��', - `useful_life` int NOT NULL DEFAULT '1' COMMENT '浣跨敤骞撮檺(骞�)', - `residual_rate` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '娈嬪�肩巼(%)', - `accumulated_depreciation` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '绱鎶樻棫', - `net_value` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '鍑�鍊�', - `location` varchar(255) DEFAULT NULL COMMENT '瀛樻斁鍦扮偣', - `department` varchar(128) DEFAULT NULL COMMENT '浣跨敤閮ㄩ棬', - `keeper` varchar(64) DEFAULT NULL COMMENT '淇濈浜�', - `status` varchar(32) NOT NULL DEFAULT 'in_use' COMMENT '鐘舵��: in_use/idle/repair/scrapped', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_user` varchar(64) DEFAULT NULL COMMENT '鍒涘缓浜�', - `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_user` varchar(64) DEFAULT NULL COMMENT '淇敼浜�', - `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿', - `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', - PRIMARY KEY (`id`), - UNIQUE KEY `uk_fin_fixed_asset_code` (`asset_code`), - KEY `idx_fin_fixed_asset_status` (`status`), - KEY `idx_fin_fixed_asset_category` (`category`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鍥哄畾璧勪骇'; - -CREATE TABLE IF NOT EXISTS `fin_intangible_asset` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', - `asset_code` varchar(64) NOT NULL COMMENT '璧勪骇缂栧彿', - `asset_name` varchar(128) NOT NULL COMMENT '璧勪骇鍚嶇О', - `category` varchar(64) NOT NULL COMMENT '璧勪骇绫诲埆', - `certificate_no` varchar(128) DEFAULT NULL COMMENT '璇佷功缂栧彿', - `acquisition_date` date NOT NULL COMMENT '鍙栧緱鏃ユ湡', - `original_value` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '璧勪骇鍘熷��', - `amortization_period` int NOT NULL DEFAULT '1' COMMENT '鎽婇攢骞撮檺(骞�)', - `residual_rate` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '娈嬪�肩巼(%)', - `accumulated_amortization` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '绱鎽婇攢', - `net_value` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '鍑�鍊�', - `validity_date` date DEFAULT NULL COMMENT '鏈夋晥鏈熻嚦', - `status` varchar(32) NOT NULL DEFAULT 'in_use' COMMENT '鐘舵��: in_use/expired/amortized', - `description` varchar(1000) DEFAULT NULL COMMENT '璧勪骇鎻忚堪', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_user` varchar(64) DEFAULT NULL COMMENT '鍒涘缓浜�', - `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_user` varchar(64) DEFAULT NULL COMMENT '淇敼浜�', - `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿', - `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', - PRIMARY KEY (`id`), - UNIQUE KEY `uk_fin_intangible_asset_code` (`asset_code`), - KEY `idx_fin_intangible_asset_status` (`status`), - KEY `idx_fin_intangible_asset_category` (`category`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鏃犲舰璧勪骇'; - -CREATE TABLE IF NOT EXISTS `fin_voucher` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', - `voucher_no` varchar(64) NOT NULL COMMENT '鍑瘉瀛楀彿', - `voucher_date` date NOT NULL COMMENT '鍑瘉鏃ユ湡', - `summary` varchar(500) DEFAULT NULL COMMENT '鎽樿', - `debit` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '鍊熸柟鍚堣', - `credit` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '璐锋柟鍚堣', - `creator` varchar(64) DEFAULT NULL COMMENT '鍒跺崟浜�', - `status` varchar(32) NOT NULL DEFAULT 'unposted' COMMENT '鐘舵��: unposted/posted/cancelled', - `attachment_count` int NOT NULL DEFAULT '0' COMMENT '闄勪欢寮犳暟', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_user` varchar(64) DEFAULT NULL COMMENT '鍒涘缓浜�', - `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_user` varchar(64) DEFAULT NULL COMMENT '淇敼浜�', - `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿', - `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', - PRIMARY KEY (`id`), - UNIQUE KEY `uk_fin_voucher_no` (`voucher_no`), - KEY `idx_fin_voucher_date` (`voucher_date`), - KEY `idx_fin_voucher_status` (`status`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鍑瘉涓昏〃'; - -CREATE TABLE IF NOT EXISTS `fin_voucher_entry` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', - `voucher_id` bigint NOT NULL COMMENT '鍑瘉ID', - `row_no` int NOT NULL DEFAULT '1' COMMENT '琛屽彿', - `subject_code` varchar(64) NOT NULL COMMENT '绉戠洰缂栫爜', - `subject_name` varchar(128) DEFAULT NULL COMMENT '绉戠洰鍚嶇О', - `summary` varchar(500) DEFAULT NULL COMMENT '鎽樿', - `debit` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '鍊熸柟閲戦', - `credit` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '璐锋柟閲戦', - `auxiliary_type` varchar(32) DEFAULT NULL COMMENT '杈呭姪鏍哥畻绫诲瀷', - `auxiliary_id` varchar(64) DEFAULT NULL COMMENT '杈呭姪鏍哥畻瀵硅薄ID', - `auxiliary_name` varchar(128) DEFAULT NULL COMMENT '杈呭姪鏍哥畻瀵硅薄鍚嶇О', - `create_user` varchar(64) DEFAULT NULL COMMENT '鍒涘缓浜�', - `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_user` varchar(64) DEFAULT NULL COMMENT '淇敼浜�', - `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿', - `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', - PRIMARY KEY (`id`), - KEY `idx_fin_voucher_entry_voucher` (`voucher_id`), - KEY `idx_fin_voucher_entry_subject` (`subject_code`), - KEY `idx_fin_voucher_entry_aux` (`auxiliary_type`, `auxiliary_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鍑瘉鍒嗗綍'; diff --git a/doc/20260515_device_maintenance_inspection_abnormal_acceptance.sql b/doc/20260515_device_maintenance_inspection_abnormal_acceptance.sql deleted file mode 100644 index 7f34fe0..0000000 --- a/doc/20260515_device_maintenance_inspection_abnormal_acceptance.sql +++ /dev/null @@ -1,22 +0,0 @@ -ALTER TABLE `inspection_task` - ADD COLUMN `inspection_project` VARCHAR(100) NULL COMMENT '宸℃椤圭洰' AFTER `task_name`; - -ALTER TABLE `inspection_task` - ADD COLUMN `inspection_result` VARCHAR(1) NULL COMMENT '宸℃缁撴灉 0寮傚父 1姝ｅ父' AFTER `remarks`, - ADD COLUMN `abnormal_description` VARCHAR(500) NULL COMMENT '寮傚父鎻忚堪' AFTER `inspection_result`, - ADD COLUMN `device_repair_id` BIGINT NULL COMMENT '鍏宠仈缁翠慨鍗旾D' AFTER `abnormal_description`, - ADD COLUMN `acceptance_user_id` BIGINT NULL COMMENT '楠屾敹浜篒D' AFTER `device_repair_id`, - ADD COLUMN `acceptance_name` VARCHAR(100) NULL COMMENT '楠屾敹浜�' AFTER `acceptance_user_id`; - -ALTER TABLE `timing_task` - ADD COLUMN `inspection_project` VARCHAR(100) NULL COMMENT '宸℃椤圭洰' AFTER `task_name`, - ADD COLUMN `is_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '鏄惁鍚敤 0鍚� 1鏄�' AFTER `is_active`; - -CREATE INDEX `idx_inspection_task_device_repair_id` - ON `inspection_task` (`device_repair_id`); - -CREATE INDEX `idx_inspection_task_inspection_result` - ON `inspection_task` (`inspection_result`); - -CREATE INDEX `idx_timing_task_is_enabled` - ON `timing_task` (`is_enabled`); diff --git "a/doc/20260523_ \345\215\217\345\220\214\345\256\241\346\211\271\346\226\260\345\242\236\345\207\272\345\267\256\346\227\266\351\227\264\345\222\214\347\273\223\346\235\237\346\227\266\351\227\264.sql" "b/doc/20260523_ \345\215\217\345\220\214\345\256\241\346\211\271\346\226\260\345\242\236\345\207\272\345\267\256\346\227\266\351\227\264\345\222\214\347\273\223\346\235\237\346\227\266\351\227\264.sql" deleted file mode 100644 index 0e0c5ce..0000000 --- "a/doc/20260523_ \345\215\217\345\220\214\345\256\241\346\211\271\346\226\260\345\242\236\345\207\272\345\267\256\346\227\266\351\227\264\345\222\214\347\273\223\346\235\237\346\227\266\351\227\264.sql" +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE approve_process - ADD COLUMN start_date_time datetime DEFAULT NULL COMMENT '鍑哄樊寮�濮嬫椂闂�', - ADD COLUMN end_date_time datetime DEFAULT NULL COMMENT '鍑哄樊缁撴潫鏃堕棿'; diff --git "a/doc/20260523_\346\226\260\345\242\236\345\205\245\345\272\223\350\256\260\345\275\225\350\241\250\347\232\204\351\242\204\350\255\246\346\225\260\351\207\217.sql" "b/doc/20260523_\346\226\260\345\242\236\345\205\245\345\272\223\350\256\260\345\275\225\350\241\250\347\232\204\351\242\204\350\255\246\346\225\260\351\207\217.sql" deleted file mode 100644 index 90392d2..0000000 --- "a/doc/20260523_\346\226\260\345\242\236\345\205\245\345\272\223\350\256\260\345\275\225\350\241\250\347\232\204\351\242\204\350\255\246\346\225\260\351\207\217.sql" +++ /dev/null @@ -1,2 +0,0 @@ -alter table stock_in_record - add warn_num decimal(16, 4) null comment '棰勮鏁伴噺'; diff --git a/doc/add_rating_evaluation_fields.sql b/doc/add_rating_evaluation_fields.sql deleted file mode 100644 index 5cb24ec..0000000 --- a/doc/add_rating_evaluation_fields.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE after_sales_service - ADD COLUMN rating DECIMAL(2, 1) COMMENT '璇勫垎(1-5鍒嗭紝鍙繚鐣�1浣嶅皬鏁�)' AFTER dis_date, -ADD COLUMN evaluation VARCHAR(1000) COMMENT '璇勪环鍐呭鎻忚堪' AFTER rating; diff --git a/doc/create_table_customer_user.sql b/doc/create_table_customer_user.sql deleted file mode 100644 index dacbfb4..0000000 --- a/doc/create_table_customer_user.sql +++ /dev/null @@ -1,10 +0,0 @@ -drop table if exists customer_user; -create table customer_user -( - id bigint auto_increment - primary key, - customer_id bigint not null default 0 comment '瀹㈡埛id', - user_id bigint not null default 0 comment '鐢ㄦ埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - tenant_id bigint not null default 0 comment '绉熸埛id' -); diff --git a/doc/create_table_process_route.sql b/doc/create_table_process_route.sql deleted file mode 100644 index 4a453f8..0000000 --- a/doc/create_table_process_route.sql +++ /dev/null @@ -1,11 +0,0 @@ -# 宸ヨ壓璺嚎 -drop table if exists process_route; -create table process_route -( - id bigint auto_increment primary key, - product_model_id bigint not null default 0 comment '浜у搧id', - description varchar(255) not null default '' comment '鎻忚堪', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); diff --git a/doc/create_table_process_route_item.sql b/doc/create_table_process_route_item.sql deleted file mode 100644 index a1efff9..0000000 --- a/doc/create_table_process_route_item.sql +++ /dev/null @@ -1,62 +0,0 @@ -# 宸ヨ壓璺嚎椤圭洰 -drop table if exists process_route_item; -create table process_route_item -( - id bigint auto_increment primary key, - route_id bigint not null default 0 comment '宸ヨ壓璺嚎id', - product_model_id bigint not null default 0 comment '浜у搧id', - process_id bigint not null default 0 comment '宸ュ簭id', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); - -# 鐢熶骇宸ヨ壓璺嚎椤圭洰 -drop table if exists product_process_route_item; -create table product_process_route_item -( - id bigint auto_increment primary key, - route_id bigint not null default 0 comment '宸ヨ壓璺嚎id', - product_model_id bigint not null default 0 comment '閿�鍞彴璐︿骇鍝乮d', - process_id bigint not null default 0 comment '宸ュ簭id', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); - -# 鐢熶骇璁㈠崟 -drop table if exists product_order; -create table product_order -( - id bigint auto_increment primary key, - sales_ledger_id bigint not null default 0 comment '閿�鍞彴璐d', - product_model_id bigint not null default 0 comment '閿�鍞彴璐︿骇鍝乮d', - route_id bigint not null default 0 comment '宸ヨ壓璺嚎id', - nps_no varchar(255) not null default '' comment '鐢熶骇璁㈠崟鍙�', - status int not null default 0 comment '鐘舵�� 0 寰呯‘璁� 1 宸茬‘璁�', - tenant_id bigint not null comment '绉熸埛id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿' -); -alter table quality_inspect - add purchase_ledger_id int null comment '閲囪喘璁㈠崟id'; - -# 鐢熶骇宸ュ崟 -drop table if exists product_work_order; -create table product_work_order -( - id bigint auto_increment primary key, - product_process_route_item_id bigint not null default 0 comment '宸ヨ壓璺嚎椤圭洰id', - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿', - work_order_no varchar(255) not null default '' comment '宸ュ崟缂栧彿', - plan_start_time datetime null comment '璁″垝寮�濮嬫椂闂�', - plan_end_time datetime null comment '璁″垝缁撴潫鏃堕棿', - actual_start_time datetime null comment '瀹為檯寮�濮嬫椂闂�', - actual_end_time datetime null comment '瀹為檯缁撴潫鏃堕棿', - status int not null default 0 comment '鐘舵�� 1 寰呯‘璁� 2 寰呯敓浜� 3鐢熶骇涓� 4宸茬敓浜� ', - tenant_id bigint not null comment '绉熸埛id' -); - -alter table product_process - add salary_quota numeric(16,3) null comment '宸ヨ祫瀹氶'; \ No newline at end of file diff --git a/doc/create_table_product_process.sql b/doc/create_table_product_process.sql deleted file mode 100644 index 6242614..0000000 --- a/doc/create_table_product_process.sql +++ /dev/null @@ -1,13 +0,0 @@ -# 宸ュ簭 -drop table if exists product_process; -create table product_process -( - id bigint auto_increment - primary key, - create_time datetime null comment '褰曞叆鏃堕棿', - update_time datetime null comment '鏇存柊鏃堕棿', - name varchar(255) not null default '' comment '宸ヨ壓鍚嶇О', - no varchar(255) not null default '' comment '宸ヨ壓缂栧彿', - remark varchar(255) not null default '' comment '澶囨敞', - tenant_id bigint not null default 0 comment '绉熸埛id' -); \ No newline at end of file diff --git a/doc/create_table_product_structure.sql b/doc/create_table_product_structure.sql deleted file mode 100644 index 83af495..0000000 --- a/doc/create_table_product_structure.sql +++ /dev/null @@ -1,16 +0,0 @@ -# 浜у搧缁撴瀯 -drop table if exists product_structure; -create table product_structure -( - id bigint auto_increment - primary key, - product_model_id bigint not null comment '浜у搧id', - process_id bigint not null comment '宸ュ簭id', - unit_quantity numeric(16, 4) not null comment '鍗曚綅浜у嚭闇�瑕佹暟閲�', - demanded_quantity numeric(16, 4) not null comment '闇�姹傛暟閲�', - unit varchar(255) not null comment '鍗曚綅', - disk_quantity numeric(16, 4) not null comment '鐩樻暟閲�', - tenant_id bigint not null comment '绉熸埛id' -); -alter table product_structure - add parent_id bigint null comment '鐖秈d'; diff --git a/doc/create_table_production_product_main.sql b/doc/create_table_production_product_main.sql deleted file mode 100644 index 18fb92d..0000000 --- a/doc/create_table_production_product_main.sql +++ /dev/null @@ -1,36 +0,0 @@ -drop table if exists production_product_main; -create table production_product_main -( - id bigint auto_increment - primary key, - product_no varchar(255) not null comment '鎶ュ伐鍗曞彿', - user_id bigint not null comment '鎶ュ伐鐢ㄦ埛id', - work_order_id bigint not null comment '宸ュ崟id', - status int not null comment '鐘舵�� 0 寰呮姤宸� 1 寰呯‘璁�', - create_time datetime null comment '褰曞叆鏃堕棿', - tenant_id bigint not null comment '绉熸埛id' -); - -drop table if exists production_product_output; -create table production_product_output -( - id bigint auto_increment - primary key, - product_main_id bigint not null comment '鎶ュ伐鍗昳d', - product_model_id bigint not null comment '浜у搧id', - quantity numeric(16, 4) not null comment '鏁伴噺', - create_time datetime null comment '褰曞叆鏃堕棿', - tenant_id bigint not null comment '绉熸埛id' -); - -drop table if exists production_product_input; -create table production_product_input -( - id bigint auto_increment - primary key, - product_main_id bigint not null comment '鎶ュ伐鍗昳d', - product_model_id bigint not null comment '浜у搧id', - quantity numeric(16, 4) not null comment '鏁伴噺', - create_time datetime null comment '褰曞叆鏃堕棿', - tenant_id bigint not null comment '绉熸埛id' -) diff --git a/doc/update_after_sales_service.sql b/doc/update_after_sales_service.sql deleted file mode 100644 index 14cc8ec..0000000 --- a/doc/update_after_sales_service.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `after_sales_service` - ADD COLUMN `product_model_quantities` varchar(255) DEFAULT NULL COMMENT '浜у搧鍨嬪彿瀵瑰簲鍞悗鏁伴噺'; diff --git "a/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" "b/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" deleted file mode 100644 index d3f9ccf..0000000 --- "a/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" +++ /dev/null @@ -1,15 +0,0 @@ --- 鏇存敼 production_order_pick - -ALTER TABLE `production_order_pick` - MODIFY COLUMN `quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '鏁伴噺' AFTER `product_model_id`, - MODIFY COLUMN `demanded_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '闇�姹傛暟閲�' AFTER `technology_operation_id`, - MODIFY COLUMN `feeding_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '琛ユ枡鎬婚噺' AFTER `is_returned`, - MODIFY COLUMN `return_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '閫�鏂欐暟閲�' AFTER `feeding_qty`, - MODIFY COLUMN `actual_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '瀹為檯鏁伴噺' AFTER `return_qty`; - --- 鏇存敼 production_order_pick_record - -ALTER TABLE `production_order_pick_record` - MODIFY COLUMN `pick_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鏁伴噺' AFTER `batch_no`, - MODIFY COLUMN `before_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鍓嶆暟閲�' AFTER `pick_quantity`, - MODIFY COLUMN `after_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鍚庡墿浣欐暟閲�' AFTER `before_quantity`; -- Gitblit v1.9.3