Warning, file /webapps/ocs-webserver/sql_code/20190919_add_mediaview_factor_to_category.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 `project_category` 0002 CHANGE COLUMN `dl_pling_factor` `dl_pling_factor` DOUBLE UNSIGNED NULL DEFAULT '1' COMMENT 'Dowmload Factor' AFTER `orderPos`, 0003 ADD COLUMN `mv_pling_factor` DOUBLE UNSIGNED NULL DEFAULT '1' COMMENT 'Mediaview Factor' AFTER `dl_pling_factor`; 0004 0005 UPDATE project_category c 0006 SET c.mv_pling_factor = c.dl_pling_factor 0007 ; 0008