Warning, file /webapps/ocs-webserver/sql_code/20190930_alter_table_section_support.sql was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
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 ;