100 lines
6.3 KiB
Transact-SQL
100 lines
6.3 KiB
Transact-SQL
-- T1-R3
|
|
DECLARE @LayerId UNIQUEIDENTIFIER;
|
|
SET @LayerId = NEWID();
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Layers]
|
|
([Id], [Number], [Name], [CreatedAt], [ModifiedAt], [IsDeleted],
|
|
[CreatedById], [ModifiedById], [Type])
|
|
VALUES ((SELECT @LayerId), 4174, 'L4174-A-PW_R2-2025-202412311544',
|
|
GETDATE(), GETDATE(), 0, '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 2);
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'FK2',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'K5',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'FK',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'PU',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'AA',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Source', 'AK',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'IsEnabled', 'True',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Year', '2025',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Type', 'ProcessWorker',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'ProcessType', 'T4-R2',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'LayerName', 'P-2025-R2-T4',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'GoogleSheetName-Invoices', 'Raport_R2_Faktury_2024',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'GoogleSheetName', 'Raport_R2_Sprzedaz_2024',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Codes-PU', '6000;6001;6002;6003',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Codes-AK', '7000;7001;7002;7003',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Codes-K5', '5000;5001;5002;5003',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Codes-FK', '8000;8005',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|
|
|
|
INSERT INTO [diunabi-morska].[dbo].[Records]
|
|
([Id], [Code], [Desc1], [CreatedAt], [ModifiedAt], [CreatedById], [ModifiedById], [IsDeleted], [LayerId])
|
|
VALUES ((SELECT NEWID()), 'Codes-AA', '1001',
|
|
GETDATE(), GETDATE(), '117be4f0-b5d1-41a1-a962-39dc30cce368', '117be4f0-b5d1-41a1-a962-39dc30cce368', 0, (SELECT @LayerId));
|