ALTER TABLE `hazmat_manage`.`hz_product_entry_record`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_warehouse_record`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_warehouse_record`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_hazmat_basic`
|
ADD COLUMN `peculiarity_type` varchar(255) NULL COMMENT '危化品特性种类' AFTER `del_flag`;
|
|
ALTER TABLE `hazmat_manage`.`hz_hazmat_basic`
|
ADD COLUMN `peculiarity_number` int NULL COMMENT '危化品特性编码' AFTER `peculiarity_type`;
|
|
ALTER TABLE `hazmat_manage`.`hz_hazmat_basic`
|
ADD COLUMN `secientific_id` int NULL COMMENT '分类信息id' AFTER `peculiarity_number`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_basic`
|
ADD COLUMN `peculiarity_type` varchar(255) NULL COMMENT '危化品特性种类' AFTER `del_flag`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_basic`
|
ADD COLUMN `peculiarity_number` int NULL COMMENT '危化品特性编码' AFTER `peculiarity_type`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_basic`
|
ADD COLUMN `secientific_id` int NULL COMMENT '分类信息id' AFTER `peculiarity_number`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_0`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_1`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_2`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_3`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_4`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_5`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_6`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_7`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_8`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_9`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_10`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_11`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_12`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_13`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_14`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_15`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_16`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_17`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_18`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|
|
ALTER TABLE `hazmat_manage`.`hz_product_19`
|
ADD COLUMN `cupboard_id` bigint NOT NULL COMMENT '存储柜id' AFTER `warehouse_id`;
|