IF NOT EXISTS (SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('teleport_wind_power') AND [name] = N'version' AND [minor_id] = 0)
EXEC sys.sp_addextendedproperty
@level1name=N'teleport_wind_power'
ELSE EXEC sys.sp_updateextendedproperty
@level1name=N'teleport_wind_power';
DECLARE @ConstraintName1 nvarchar(200)
SELECT @ConstraintName1 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'active_power'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName1 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName1);
DECLARE @ConstraintName2 nvarchar(200)
SELECT @ConstraintName2 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'available_active_power'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName2 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName2);
DECLARE @ConstraintName3 nvarchar(200)
SELECT @ConstraintName3 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'constrained_available_active_power_current_wind'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName3 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName3);
DECLARE @ConstraintName4 nvarchar(200)
SELECT @ConstraintName4 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'constrained_available_active_power_technical'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName4 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName4);
DECLARE @ConstraintName5 nvarchar(200)
SELECT @ConstraintName5 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'constrained_available_active_power_force_majeure'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName5 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName5);
DECLARE @ConstraintName6 nvarchar(200)
SELECT @ConstraintName6 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'constrained_available_active_power_external_setpoints'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @ConstraintName6 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @ConstraintName6);
DECLARE @ConstraintName7 nvarchar(200)
SELECT @ConstraintName7 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power_converters')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'active_power'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power_converters'))
IF @ConstraintName7 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power_converters DROP CONSTRAINT ' + @ConstraintName7);
DECLARE @Constraint8 nvarchar(200)
SELECT @Constraint8 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'wind_speed'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @Constraint8 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @Constraint8);
DECLARE @Constraint9 nvarchar(200)
SELECT @Constraint9 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'active_power_limit_percentage'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power'))
IF @Constraint9 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power DROP CONSTRAINT ' + @Constraint9);
DECLARE @Constraint10 nvarchar(200)
SELECT @Constraint10 = Name FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID('dbo.teleport_wind_power_converters')
AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns
WHERE NAME = N'wind_speed'
AND object_id = OBJECT_ID(N'dbo.teleport_wind_power_converters'))
IF @Constraint10 IS NOT NULL
EXEC('ALTER TABLE dbo.teleport_wind_power_converters DROP CONSTRAINT ' + @Constraint10);
ALTER TABLE teleport_wind_power
ADD generated_energy DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN active_power DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN available_active_power DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN constrained_available_active_power_current_wind DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN constrained_available_active_power_technical DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN constrained_available_active_power_force_majeure DECIMAL(23,3);
ALTER TABLE teleport_wind_power
ALTER COLUMN constrained_available_active_power_external_setpoints DECIMAL(23,3);
ALTER TABLE teleport_wind_power_converters
ADD generated_energy DECIMAL(23,3);
ALTER TABLE teleport_wind_power_converters
ALTER COLUMN active_power DECIMAL(23,3);
ALTER TABLE teleport_wind_power_converters
