15 lines
452 B
MySQL
15 lines
452 B
MySQL
|
IF OBJECT_ID('dbo.SchemaVersion', 'U') IS NULL
|
|||
|
|
BEGIN
|
|||
|
|
CREATE TABLE dbo.SchemaVersion (
|
|||
|
|
VersionNumber VARCHAR(20) NOT NULL PRIMARY KEY,
|
|||
|
|
AppliedOn DATETIME2 NOT NULL DEFAULT GETDATE(),
|
|||
|
|
AppliedBy VARCHAR(100) NOT NULL DEFAULT SUSER_SNAME(),
|
|||
|
|
ScriptDescription VARCHAR(255) NULL
|
|||
|
|
);
|
|||
|
|
PRINT 'Table dbo.SchemaVersion created successfully.';
|
|||
|
|
END
|
|||
|
|
ELSE
|
|||
|
|
BEGIN
|
|||
|
|
PRINT 'Table dbo.SchemaVersion already exists.';
|
|||
|
|
END
|
|||
|
|
GO
|