DeployDataBase.sql

CREATE TABLE [dbo].[Log] (
    [Id] [int] IDENTITY (1, 1) NOT NULL,
    [Date] [datetime] NOT NULL,
    [UserName] NVARCHAR(50) NOT NULL,
    [Level] [varchar] (50) NOT NULL,
    [Logger] [varchar] (255) NOT NULL,
    [Message] [varchar] (4000) NOT NULL,
    [Exception] [varchar] (2000) NULL,
	CONSTRAINT [PK_Log] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[Client] (
    [ID] [uniqueidentifier] NOT NULL,
    [Name] [nvarchar](max),
    [Email] [nvarchar](max),
    [Role] [nvarchar](max),
    CONSTRAINT [PK_dbo.Client] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[Policy] (
    [ID] [uniqueidentifier] NOT NULL,
    [AmountInsured] [decimal](18, 2) NOT NULL,
    [Email] [nvarchar](max),
    [InceptionDate] [datetime] NOT NULL,
    [InstallmentPayment] [bit] NOT NULL,
    [ClientId] [uniqueidentifier] NOT NULL,
    CONSTRAINT [PK_dbo.Policy] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[__MigrationHistory] (
    [MigrationId] [nvarchar](150) NOT NULL,
    [ContextKey] [nvarchar](300) NOT NULL,
    [Model] [varbinary](max) NOT NULL,
    [ProductVersion] [nvarchar](32) NOT NULL,
    CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY ([MigrationId], [ContextKey])
)
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'201805291827208_Initial', N'Gentil.DAL.Migrations.Configuration',  0x1F8B0800000000000400E558DB6EE336107D2FD07F10F4D4025931C9BE6C0379178E9D1446E3C488B2FB4E4B6387282F5A910AEC6FDB877E527FA143DD255F62C549D0A23060CB24E7702E87331CFDFDE32FFFCB4A70E70912CD941CB867DEA9EB800C55C4E472E0A666F1E193FBE5F3CF3FF957915839DFCA751FED3A94947AE03E1A135F10A2C34710547B828589D26A61BC5009422345CE4F4F7F2367670410C2452CC7F1EF53699880EC0FFE1D2919426C52CAA72A02AE8B719C093254E7960AD0310D61E0FE0E28CABDF1F0C64331032BA35D67C819455502E00BD7A1522A430D2A7AF1554360122597418C03943FAC63C0750BCA3514065CD4CB0FB5E5F4DCDA426AC1122A4CB551A227E0D9C7C239A42BFE2217BB95F3D07D57E82BB3B656672E1CB823CED07FAED3DDEA62C413BBACF2EF65AA9904ADBD3C225E2E78E274A64F2A4E2075ECE7C419A5DCA4090C24A426A1FCC499A573CEC23F60FDA0FE04399029E74D25514D9C6B0DE0D02C513124667D0F8B42F5C9D875485B8E74052BB1864C6156CA22D7B9C5BDE99C434501B257DC7E9700C8233C13AE33A5AB1B904BF33870F1D175AED90AA272A440FD2A191E21143249FAEC26578232FEE6BBDC2BFEDAA6F8A4A6D75ED2CD14C67FFD02D2E582FF33D20D85C2EC38911AED894AA431844C50A4C92CC1A722597F729D20A416F8BCF72EEFC3BA4996D751DB313515FDECF303B327ABA7CEE813433917C886195D8B2C91E590970AE94D656FC43CAB4DA21E01DBCF7A5B922892342936C8995B14AA2D27000B54710874E1D1B6BE396A00A6A53056BC5A89BCEC79656627FB01B223C5601B42794CB7595BD955976692D7E6B286931D45DC9FD2384676358A7A31E20479451F7D08FA573A916390506F297895B6D54E462574099D59DC1A35BD668936C8493AA736D6A3486C2C6B47718783CBBDDA81EAA698DAEBE57AFBDC244BEB6A5386B503533BF11AEDB2272133112A65AA4ABF21985DAA28A7C996AC35523C157257E6DB279D57CAA67C3E72384291909A10C5D0E11879916B42E4239B083EE9F8AF1B27B211A84E15E8C6FD205654A7EF585A1467B53F2D7609BE0D2D3AB5AC09D4997A5FA274EA52CBC0F6541FCCCDEAD406DE9C3F1CBDAE544DCC7AF49D29BE5117BA4BAADDABFAD0A9037E91939FEFF8369274BEC4DE85D4138B6C820ED6DA80F0EC022FF8CECB5A582E9852C916A04D7E1774B1E73AEFF48CFF9EFE8D681DF1839AB877BFCEA6927D4F011D8A0A2D182447F553F28926E1234D7E1174F56B13A977CF741452B32FEA01D4B7F7F9EFC56A6B1B12BD691B725420B7B61A113E9BD76D35E6CC1CDD66F40C4EBF9663F34E7B484BB1A7A3C8D32D3A73AED0805CCB3EDDC67A4FAFB10DFBC83E64B3AEF8A4F9BED11F8366CB1AC2BE7D94105AEAD4A0E59A895CA83298685653A3724927D653301469478709C6968606A743D03AEBAFBF519E66A49F43349177A9895333D41AC49CB7ECF5C9FEFDB366ABADB37F97915FBF8609A826B327E74E5EA68C4795DED75BA8B903C29210EFAD9064853030F80BCB758574ABE4814085FBC61083B4E7E50144CC114CDFC9803EC14B74C39EFB0696345C97D783DD20CF07A2ED767FCCE832A1421718B5BC7D874EEC4BF4CFFF007CB31B2D76170000 , N'6.2.0-61023')


INSERT INTO [dbo].[Client]([ID],[Name],[Email],[Role])VALUES('a0ece5db-cd14-4f21-812f-966633e7be86','Britney','britneyblankenship@quotezart.com','admin')
INSERT INTO [dbo].[Client]([ID],[Name],[Email],[Role])VALUES('e8fd159b-57c4-4d36-9bd7-a59ca13057bb','Manning','manningblankenship@quotezart.com','admin')
INSERT INTO [dbo].[Client]([ID],[Name],[Email],[Role])VALUES('a3b8d425-2b60-4ad7-becc-bedf2ef860bd','Barnett','barnettblankenship@quotezart.com','user')

INSERT INTO [dbo].[Policy]([ID],[AmountInsured],[Email],[InceptionDate],[InstallmentPayment],[ClientId])VALUES('64cceef9-3a01-49ae-a23b-3761b604800b',1825.89,'inesblankenship@quotezart.com','2016-06-01T03:33:32Z',1,'e8fd159b-57c4-4d36-9bd7-a59ca13057bb')
INSERT INTO [dbo].[Policy]([ID],[AmountInsured],[Email],[InceptionDate],[InstallmentPayment],[ClientId])VALUES('7b624ed3-00d5-4c1b-9ab8-c265067ef58b',399.89,'inesblankenship@quotezart.com','2015-07-06T06:55:49Z',1,'a0ece5db-cd14-4f21-812f-966633e7be86')
INSERT INTO [dbo].[Policy]([ID],[AmountInsured],[Email],[InceptionDate],[InstallmentPayment],[ClientId])VALUES('56b415d6-53ee-4481-994f-4bffa47b5239',2301.98,'inesblankenship@quotezart.com','2014-12-01T05:53:13Z',0,'e8fd159b-57c4-4d36-9bd7-a59ca13057bb')