Calculation/sql/update.sql

ALTER TABLE `zh_pos_0`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_1`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_2`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_3`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_4`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_5`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_6`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_7`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_8`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_9`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_10`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_11`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_12`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_13`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_14`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_15`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_16`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_17`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_18`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_pos_19`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

Update zh_pos_0 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_1 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_2 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_3 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_4 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_5 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_6 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_7 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_8 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_9 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_10 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_11 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_12 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_13 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_14 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_15 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_16 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_17 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_18 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_pos_19 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;

ALTER TABLE `zh_revise_pos0`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos1`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos2`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos3`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos4`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos5`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos6`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos7`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos8`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos9`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos10`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos11`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos12`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos13`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos14`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos15`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos16`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos17`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos18`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

ALTER TABLE `zh_revise_pos19`
MODIFY COLUMN `add_stage`  int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
ADD COLUMN `add_stage_order`  tinyint(4) NOT NULL COMMENT '新增期序号' AFTER `add_stage`;

Update zh_revise_pos0 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos1 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos2 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos3 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos4 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos5 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos6 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos7 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos8 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos9 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos10 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos11 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos12 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos13 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos14 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos15 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos16 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos17 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos18 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;
Update zh_revise_pos19 p Left Join zh_stage s ON sj.add_stage = s.id Set sj.add_stage_order = s.order;