Migration202109161043UdeResources_up.sql 594 Bytes
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
DECLARE @rdsS3udeId AS uniqueidentifier
SELECT @rdsS3udeId = [Id]
FROM [dbo].[ResourceTypes]
WHERE [DisplayName] = 'rdss3ude';

DECLARE @rdsudeId AS uniqueidentifier
SELECT @rdsudeId = [Id]
FROM [dbo].[ResourceTypes]
WHERE [DisplayName] = 'rdsude';

INSERT INTO [ProjectQuotas]
           ([ProjectId]
           ,[ResourceTypeId]
           ,[Quota]
           ,[MaxQuota])

SELECT [Id], @rdsS3udeId, 0, 0
FROM [Projects]

INSERT INTO [ProjectQuotas]
           ([ProjectId]
           ,[ResourceTypeId]
           ,[Quota]
           ,[MaxQuota])

SELECT [Id], @rdsudeId, 0, 0
FROM [Projects]