File indexing completed on 2024-04-21 06:00:37 

0001 ALTER TABLE `section_support`
0002         ADD COLUMN `creator_id` INT(11) NULL DEFAULT NULL AFTER `project_id`,
0003         ADD COLUMN `project_category_id` INT(11) NULL DEFAULT NULL AFTER `creator_id`;
0004 
0005 
0006 UPDATE section_support p
0007 JOIN project pp ON pp.project_id = p.project_id
0008 SET p.creator_id = pp.member_id, p.project_category_id = pp.project_category_id
0009 ;