 			SELECT id
 			FROM supply.ego_dp_res_powerplant
 			WHERE scenario in ('NEP 2035')
-			AND version = 'v0.4.0'
+			AND version = 'v0.4.1'
 			AND generation_type not in ('biomass','gas','reservoir','run_of_river')
 			AND flag in ('commissioning', 'repowering')
 			AND generation_subtype not in ('wind_offshore')

			Order by id)
		 AND scenario in ('NEP 2035')
		 And preversion = 'v0.3.0'
		 AND version = 'v0.4.0'
		 AND electrical_capacity > 0
		 ORDER BY id	
	) sub3

	AND capacity > 0
	AND (shutdown IS NULL or shutdown >= 2049)
	AND preversion = 'v0.3.0'
	AND version = 'v0.4.1';

ALTER MATERIALIZED VIEW supply.ego_dp_conv_powerplant_ego100_mview
    OWNER TO oeuser;

-- scenario log (project,version,io,schema_name,table_name,script_name,comment)
SELECT scenario_log('eGo_DP','v0.4.1','result','supply','ego_dp_conv_powerplant_sq_mview','ego_dp_versioning_mviews.sql','versioning');
SELECT scenario_log('eGo_DP','v0.4.1','result','supply','ego_dp_conv_powerplant_nep2035_mview','ego_dp_versioning_mviews.sql','versioning');
SELECT scenario_log('eGo_DP','v0.4.1','result','supply','ego_dp_conv_powerplant_ego100_mview','ego_dp_versioning_mviews.sql','versioning');

-- Create View with full dataset per scenario and renewables power plants

