23 lines
1.4 KiB
SQL
23 lines
1.4 KiB
SQL
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.SchemaVersions') AND OBJECTPROPERTY(id, N'IsTable') = 1)
|
|
BEGIN
|
|
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.__EFMigrationsHistory') AND OBJECTPROPERTY(id, N'IsTable') = 1)
|
|
BEGIN
|
|
CREATE TABLE __EFMigrationsHistory
|
|
(
|
|
MigrationId nvarchar(150) NOT NULL CONSTRAINT PK___EFMigrationsHistory PRIMARY KEY,
|
|
ProductVersion nvarchar(32) NOT NULL,
|
|
AppliedDate datetime2(7) NOT NULL,
|
|
AppliedVersion nvarchar(10) NULL
|
|
)
|
|
END
|
|
INSERT INTO __EFMigrationsHistory(MigrationId, ProductVersion, AppliedDate, AppliedVersion)
|
|
VALUES ('Tenant.01.00.00.00', '5.0.4', SYSDATETIME(), '{{Version}}')
|
|
INSERT INTO __EFMigrationsHistory(MigrationId, ProductVersion, AppliedDate, AppliedVersion)
|
|
SELECT REPLACE(REPLACE(ScriptName, 'Oqtane.Scripts.', ''), '.sql', '') As MigrationId,
|
|
ProductVersion = '5.0.4',
|
|
AppliedDate = CONVERT(datetime2(7), Applied),
|
|
AppliedVersion = '{{Version}}'
|
|
FROM SchemaVersions
|
|
WHERE ScriptName LIKE 'Oqtane.Scripts.Tenant.01%'
|
|
OR ScriptName LIKE 'Oqtane.Scripts.Tenant.02%'
|
|
END |