vinijmoura

CREATE TABLE [dbo].[TeamCardRuleSettings](
	[TeamProjectName] [varchar](100) NOT NULL,
	[TeamName] [varchar](100) NOT NULL,
	[TeamBackLogLevel] [varchar](40) NOT NULL,
	[TeamCardRuleSettingName] [varchar](40) NOT NULL,
	[TeamCardRuleSettingFilter] [nvarchar](MAX) NOT NULL,
	[TeamCardRuleSettingBackGroundColor] [varchar](20) NOT NULL
) ON [PRIMARY]
GO

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$ConnStr
)

$SQLQuery = "DELETE FROM TeamCardRuleSettings"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[TestPlansConfigurations](
	[TeamProjectName] [varchar](100) NOT NULL,
	[TeamPlanConfigurationId] [tinyint] NOT NULL,
	[TeamPlanConfigurationName] [varchar](100) NOT NULL,
	[TeamPlanConfigurationVariableName] [varchar](100) NOT NULL,
	[TeamPlanConfigurationVariableValue] [varchar](100) NOT NULL
) 
GO

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "TRUNCATE TABLE TestPlansConfigurations"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[InstalledExtensions](
	[ExtensionId] [varchar](100) NULL,
	[ExtensionName] [varchar](100) NULL,
	[ExtensionPublisherName] [varchar](100) NULL,
	[ExtensionVersion] [varchar](40) NULL,
	[ExtensionLastPublished] [datetime] NULL
)
GO

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "TRUNCATE TABLE InstalledExtensions"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[TeamSettingsIterationCapacities](
	[TeamProjectName] [varchar](100) NOT NULL,
	[TeamName] [varchar](100) NOT NULL,
	[IterationName] [varchar](100) NOT NULL,
	[IterationStartDate] [datetime] NOT NULL,
	[IterationFinishDate] [datetime] NOT NULL,
	[totalIterationCapacityPerDay] DECIMAL(10,2) NOT NULL,
	[totalIterationDaysOff] DECIMAL(10,2) NOT NULL
) 
GO

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "DELETE FROM TeamSettingsIterationCapacities"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[DeploymentGroupReleases](
	[TeamProjectName] [varchar](100) NULL,
	[ReleaseDefinitionName] [varchar](100) NULL,
	[EnvironmentName] [varchar](150) NULL,
	[DeploymentPhaseName] [varchar](150) NULL,
	[DeploymentGroupName] [varchar](150) NULL,
	[MachineName] [varchar](150) NULL
) ON [PRIMARY]
GO

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "DELETE FROM DeploymentGroupReleases"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr