IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL

BEGIN

CREATE TABLE [__EFMigrationsHistory] (

[MigrationId] nvarchar(150) NOT NULL,

[ProductVersion] nvarchar(32) NOT NULL,

CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])

);

END;

GO

BEGIN TRANSACTION;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20220424132206_Initial')

BEGIN

CREATE TABLE [SysUser] (

[Id] uniqueidentifier NOT NULL,

[Name] nvarchar(128) NULL,

[Phone] nvarchar(11) NULL,

CONSTRAINT [PK_SysUser] PRIMARY KEY ([Id])

);

DECLARE @defaultSchema AS sysname;

SET @defaultSchema = SCHEMA_NAME();

DECLARE @description AS sql_variant;

SET @description = N'姓名';

EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'SysUser', 'COLUMN', N'Name';

SET @description = N'手机号码';

EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'SysUser', 'COLUMN', N'Phone';

END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20220424132206_Initial')

BEGIN

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])

VALUES (N'20220424132206_Initial', N'6.0.4');

END;

GO

COMMIT;

GO