text: ﻿USE [dbmlm]
  GO
  /****** Object:  Table [dbo].[Menu]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Menu](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[MenuText] [nvarchar](100) NOT NULL,
  	[MenuURL] [nvarchar](400) NOT NULL,
  	[ParentId] [int] NULL,
  	[SortOrder] [int] NULL,
   CONSTRAINT [PK_dbo.Menu] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Menu] ON
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (1, N'Role', N'Role', 97, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (4, N'User', N'User', 97, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (7, N'RoleUser', N'RoleUser', 97, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (10, N'Menu', N'Menu', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (13, N'Menu Permission', N'MenuPermission', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (16, N'User Personal Info', N'UserPersonalInfo', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (19, N'Gender', N'Gender', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (22, N'User Contact Info', N'UserContactInfo', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (25, N'Contact Type', N'ContactType', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (28, N'Country', N'Country', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (31, N'State', N'State', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (34, N'City', N'City', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (37, N'User Bank Info', N'UserBankInfo', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (40, N'Payment Mode Type', N'PaymentModeType', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (43, N'Product Category', N'ProductCategory', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (46, N'Product', N'Product', 101, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (49, N'Invoice', N'Invoice', 102, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (52, N'Payment Status', N'PaymentStatus', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (55, N'Invoice Item', N'InvoiceItem', 102, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (58, N'Invoice Transaction', N'InvoiceTransaction', 102, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (61, N'Reward Type', N'RewardType', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (64, N'Reward', N'Reward', 103, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (67, N'Reward User', N'RewardUser', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (70, N'Member Ship Level', N'MemberShipLevel', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (73, N'Leg', N'Leg', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (76, N'ePin Request', N'ePinRequest', 105, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (79, N'ePin Code', N'ePinCode', 105, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (82, N'Donation Request', N'DonationRequest', 107, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (85, N'Donation Transaction', N'DonationTransaction', 107, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (88, N'Ledger Account Type', N'LedgerAccountType', 98, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (91, N'Ledger Account', N'LedgerAccount', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (94, N'Transaction', N'Transaction', 108, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (97, N'Role User', N'ru', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (98, N'Master Utility', N'mu', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (100, N'Affiliate Management', N'am', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (101, N'Product Management', N'pm', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (102, N'Invoice Management', N'im', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (103, N'Reward Management', N'rw', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (105, N'Epin', N'ep', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (107, N'Donation Management', N'dm', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (108, N'Ledger Management', N'lm', NULL, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (109, N'Chile Tree', N'User/Tree', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (110, N'Legs Tree', N'User/TreeLegs', 100, NULL)
  INSERT [dbo].[Menu] ([Id], [MenuText], [MenuURL], [ParentId], [SortOrder]) VALUES (111, N'User Manage', N'User', 100, NULL)
  SET IDENTITY_INSERT [dbo].[Menu] OFF
  /****** Object:  Table [dbo].[MemberShipLevel]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[MemberShipLevel](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](100) NOT NULL,
   CONSTRAINT [PK_dbo.MemberShipLevel] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[MemberShipLevel] ON
  INSERT [dbo].[MemberShipLevel] ([Id], [Title]) VALUES (1, N'Defaut')
  INSERT [dbo].[MemberShipLevel] ([Id], [Title]) VALUES (2, N'Gold')
  INSERT [dbo].[MemberShipLevel] ([Id], [Title]) VALUES (3, N'Silver')
  INSERT [dbo].[MemberShipLevel] ([Id], [Title]) VALUES (4, N'Bronze')
  INSERT [dbo].[MemberShipLevel] ([Id], [Title]) VALUES (5, N'Diamond')
  SET IDENTITY_INSERT [dbo].[MemberShipLevel] OFF
  /****** Object:  Table [dbo].[Leg]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Leg](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](100) NOT NULL,
   CONSTRAINT [PK_dbo.Leg] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Leg] ON
  INSERT [dbo].[Leg] ([Id], [Name]) VALUES (1, N'Left')
  INSERT [dbo].[Leg] ([Id], [Name]) VALUES (2, N'Right')
  SET IDENTITY_INSERT [dbo].[Leg] OFF
  /****** Object:  Table [dbo].[LedgerAccountType]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[LedgerAccountType](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](50) NOT NULL,
  	[ParentId] [int] NULL,
   CONSTRAINT [PK_dbo.LedgerAccountType] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[LedgerAccountType] ON
  INSERT [dbo].[LedgerAccountType] ([Id], [Title], [ParentId]) VALUES (1, N'Wallet', NULL)
  SET IDENTITY_INSERT [dbo].[LedgerAccountType] OFF
  /****** Object:  Table [dbo].[Gender]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Gender](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](200) NOT NULL,
  	[IsActive] [bit] NULL,
   CONSTRAINT [PK_dbo.Gender] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Gender] ON
  INSERT [dbo].[Gender] ([Id], [Name], [IsActive]) VALUES (1, N'Male', 1)
  INSERT [dbo].[Gender] ([Id], [Name], [IsActive]) VALUES (2, N'Female', 1)
  INSERT [dbo].[Gender] ([Id], [Name], [IsActive]) VALUES (3, N'OTHER', 1)
  SET IDENTITY_INSERT [dbo].[Gender] OFF
  /****** Object:  Table [dbo].[Country]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Country](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](200) NOT NULL,
  	[Code] [nvarchar](3) NULL,
  	[IsActive] [bit] NULL,
   CONSTRAINT [PK_dbo.Country] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Country] ON
  INSERT [dbo].[Country] ([Id], [Name], [Code], [IsActive]) VALUES (4, N'India', N'in', 1)
  INSERT [dbo].[Country] ([Id], [Name], [Code], [IsActive]) VALUES (5, N'Canada', N'ca', 1)
  SET IDENTITY_INSERT [dbo].[Country] OFF
  /****** Object:  Table [dbo].[ContactType]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[ContactType](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[TypeName] [nvarchar](200) NOT NULL,
   CONSTRAINT [PK_dbo.ContactType] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[ContactType] ON
  INSERT [dbo].[ContactType] ([Id], [TypeName]) VALUES (1, N'Emails')
  INSERT [dbo].[ContactType] ([Id], [TypeName]) VALUES (2, N'Mobile')
  INSERT [dbo].[ContactType] ([Id], [TypeName]) VALUES (3, N'Address')
  SET IDENTITY_INSERT [dbo].[ContactType] OFF
  /****** Object:  Table [dbo].[PaymentStatus]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[PaymentStatus](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](50) NOT NULL,
   CONSTRAINT [PK_dbo.PaymentStatus] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[PaymentStatus] ON
  INSERT [dbo].[PaymentStatus] ([Id], [Title]) VALUES (1, N'Pending')
  INSERT [dbo].[PaymentStatus] ([Id], [Title]) VALUES (2, N'Paused')
  INSERT [dbo].[PaymentStatus] ([Id], [Title]) VALUES (3, N'Done')
  SET IDENTITY_INSERT [dbo].[PaymentStatus] OFF
  /****** Object:  Table [dbo].[PaymentModeType]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[PaymentModeType](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](100) NULL,
   CONSTRAINT [PK_dbo.PaymentModeType] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[PaymentModeType] ON
  INSERT [dbo].[PaymentModeType] ([Id], [Title]) VALUES (1, N'Paypal')
  SET IDENTITY_INSERT [dbo].[PaymentModeType] OFF
  /****** Object:  Table [dbo].[Role]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Role](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[RoleName] [nvarchar](50) NOT NULL,
  	[IsActive] [bit] NOT NULL,
   CONSTRAINT [PK_dbo.Role] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Role] ON
  INSERT [dbo].[Role] ([Id], [RoleName], [IsActive]) VALUES (1, N'Admin', 1)
  INSERT [dbo].[Role] ([Id], [RoleName], [IsActive]) VALUES (2, N'User', 1)
  SET IDENTITY_INSERT [dbo].[Role] OFF
  /****** Object:  Table [dbo].[RewardType]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[RewardType](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](100) NULL,
  	[IsActive] [bit] NULL,
   CONSTRAINT [PK_dbo.RewardType] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[RewardType] ON
  INSERT [dbo].[RewardType] ([Id], [Name], [IsActive]) VALUES (1, N'vehicle', 1)
  SET IDENTITY_INSERT [dbo].[RewardType] OFF
  /****** Object:  Table [dbo].[__MigrationHistory]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  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 CLUSTERED 
  (
  	[MigrationId] ASC,
  	[ContextKey] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET ANSI_PADDING OFF
  GO
  INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201703080846507_first', N'mlmStudio.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B8FDCBA917E5F60FFC3A09F760364DA7612E0E4609C603CB693496CCF1C8F4F80E4A521776BDA42D45247523B9EDFB60FFB93F62FACEEE2A58A2C5E2475F7F18B3D4D914556F163F1FEF1FFFEE77FAFFEF86D175F7C0DB33C4A93978BE797CF161761B24E3751B27DB938148FBFFE61F1C73FFCE77F5CBDD9ECBE5DFCAD8BF79B2A5E9932C95F2EBE14C5FEC7E5325F7F0977417EB98BD6599AA78FC5E53ADD2D834DBA7CF1ECD9EF97CF9F2FC352C4A294757171F5F19014D12EAC7F943F6FD2641DEE8B4310BF4F37619CB7E1E597875AEAC5876017E6FB601DBE5CECE2DD4371D844E965137771711D4741598E87307E5C5C04499216415196F2C79FF3F0A1C8D264FBB02F0382F8D3D33E2CE33D06711EB6A5FF71884E55E4D98B4A91E590D0CA108B5EC552C937A5318AA7AA78B5A22F1737E54F364619E7AFE113175006DD67E93ECC8AA78FE1639BEE76B3B858F2E99662C23E1993A6CABAFC2B297EF36271F1E110C7C1E738EC2DC598F4A148B3F04F61126641116EEE83A208B3A49211D62A48B90B7955FF76B9955553626C71F13EF8F62E4CB6C597978BD23E8B8BB7D1B770D385B425F839894A4896898AEC10EA32795716B504882AA3E7BFF3914F89AC4932BACDAFD745F4B5CFE7559AC66190E8923D947516EA6B5710F221F81A6DEBCA86C4AD7AA11FC3B88E957F89F64DDBBBAC50BB12A2BDCDD2DDC7346E31CD7F5D3DA4876C5DA995A2513E05D9362CE8A52CDB7C765F7AA93409E2DBE4315D55326F3739586030729B822DBA2A5E5FC24E0965E44E63569DABE5D0FE955EA1B6C977B780B6221DB4855C6F5265D39DB1E5DEA465F7983DF96BBB43C3C29A8271DB1561AF68DEE452366AAF18F581923679007187E22251247F83C5839C0EB995B662BEB7D389DAE96F266CA79ACEB14710DCC61C902BB6361DC2AD902BF65CE708E1B7519617F3E0F85DE02D677546A575366166DC7B0852AE3FA7874251D6F24F0F652D7F3E467178BB0BB6E31BE6750999BFA451D26554FDFE14EDCCABB26A29AEF67D1F6D3671380920DEEC822856B9501F3EF46D507C09B3EB64F3B04F0FB94EB1E77E2AF4EE955C971AB3A755312729DD87741725D318A29BB3B800F21FD15ED3D53EF751D4FB20F970D87D0E33D5D8DB0BEA378775DD67BC0E0B35FE7FE769DD212FDEECF671FA14866537B31BBDD2D90CFF1E062A837AA93936BFEBE4500D12D6E904E0761E9D71D3FAB1D601C4C90569D180AA41D3A5AF869E9DA2859448A1891057AF8D98C066A166D5F5A3146DB8040A4D98787A2DD8C84EB3BEC60EE738629E67B0ECDCE611C09297025D1A8F7649106B6DD6D3B673045EA557E267F06408BEFB20CFFF9D669B3972CE4AE34856D6F4CBE1D630C5FBB01A803D94F07F177E0D63D791E3C7701BE565E5DE0F532B689661B5A28A36F0D7656BAA823F86FF3A8479D17A71B875437181BE44114D6AD3AAB8A60B9F6169B84E4E551A952A6CDC3ACF2101AB8A229AA48A2AAEA92AB7C9D7345A87AB9B38AA810C2BD1C5AA73EBA2B2C50723480587639916F95DB8D99613D7F5BA5A4553C2488E0980088D24151F8F69AEC276D57A01A46F5B3151F89E6CF8020E9798CFA6433CC1CBAC00AF8395969054D0429B02D64E9FCC5CEBE45076F6BB28AF8E4A28F10444050085C79210A5886A0AA98FE1BF836CC348805510A201C58763484547A21917BB14A62F341B092A32F05D2E3014C9B4B875DAAED3C747A6B5F81712E6EB5070B4D97EB229CE0BBB5280AD8B2FA049295E05C93FFB199ACA345C44647E08C501CD0646B431E24D9A14C1BA206920C6459440A2817A60716D5491E6CBE42994CD8C5D3B75D2A9439E360903B8739D41396F03EDAAD149BFCA9E1ECAA4C642AAC5F9EBCD26ECCB425DADAF2A27CAC2CDA7288E4DD35A1EBE68F1F0212D34334FABA54DED74E653162479D976ABFE5B80A86E76A3482A8B82E63D4602D019919914AB1E53B16EE861AA2776659469A1930B622C768E6E08C09E8B4762ACE5EF8414A1BD1C4FCBC3006AD77EA92662A50B7540348D4282DA2468429229F0D44EADF7CC5BEDA7A88895E723475900558C144C072E9594574F6EBEE626DDED83E4E9EEF1315A9B9FA516750B3F4705B7E863B86C5B0B8007641A35CA21945BD68D049BBC996652D5A579BD1A0D99B8F64D1F2E8DE09928C323BD5FB35BC444EA1B30065B02928CC11C864925576D9ADEB4BFE265C28DCFC822B0088A41A09406F600933BF55D9CB0EFBD97B7239EAC59ABBC5DBB8C9B439685C9FA4939131D43935607DD1D091FC77BFAACE274F4234C56FBAB56CB2844B7A45EFBE5E372BF5EE07B4E7C3CCDB69310D9A9DF81978EBD28213A4B92C6564A54B5BC021BB2996EB81C92CA5872134BA0325CA67E60E70CC377C2C1850872DBC1898D45A0EED9D4209EC7167473288726BE16E51C37CED590F7B61C27B594EF03A369CF3511FB4CC0A319779F63796783CE56EBE1EDBB2F8351055C0ABC6346E2AB15C712396B4A1871F85250E9847456B1F247CCB9AC5FA2271AE964F14F85E39A207BE0CE6939D07653F436BFDEEFB3F4EB9092B8B5D9259356454D0E2A5653C215034DD54145312E9F4E3CAFA88E0D1E5BD424B11AC7B0F53BCE014CD195500E6B5A7B907A0A7F86EE4380924B4BBCD75D31F7C105416FEEA473C282FA53344008B6C4366B85DEF678EF3982F75514C776BB2122AA0E212C479DACE20F38E46EADA6B90E1844B1790F7657DDC16DAB778A25C6E188B9D3626C1656956DBCA7A83B2C7F5B84BB55F7B7FAC43C1B7548029C9C87236227E891D89687FFD9C5069A5A400AA576CAF89892EA44A6BADE074FBB12534D435A75ED4971D7014E205F7980E249AE5719D9EA2AE6D044FCDDD7C04A0DDFEA70E9232A009F633FC13402B79307F93A8BF6F55195B1C926E65960FAE910B4066D7BA2701DED827871719F957FB5E4963F2C2E1ED64125D3DC8465F18AFB2C5A87A3E6C05EB6B53C1D57222FF65746ED452F06A1E3755B8823D174722E0EE5DC0F77399CA1F4E4A2FC20CBEFC801C1196DB8610537AE033F4BA44DD31D68D1D45878C4211A763955399EB3DCA7DA9E2352D8BE6FC41BF7EA61707DD35571118F728D16BC9027DFB2B5AA7BE17EEA39E240E731A60182741158018A316E2B8320A25F72B604177B7DF81CB155696878FAAB32BFEB1809DC2ED2ACD0A55971976D069A3452AADBBC44F5AB810AACDF1832A6DF6916BBDCE57C0C03799BCA58CACFFB8D97D2BC0EE3D0428EF2B2FFAA0395FE863F171DBDE1CFC49246A48AA8A6CB3E95C055876E7DD9B9E868D99958BAB2B3517DB38739332B68CAEEEDCC5125F75C1DEDA7F09B8A4076240AA52AE79F3FBE5364FCDB23E26E22BA79B503521FF7E97DC40B11FB4D28C822D27E325D156FB3B12905D4E284029A94427092440A167307ADA160817CB995A3A8A49FA3A3A8F4D2CCFCC6593146E9019C060342FF46849D79DFAA811DD40D9B8C0BEAFE4DA5001709283AF41DA7D0D115D7A8955412CFB5A58C3211B106BC6E04690512B11F5022C9D778112273D23242A125F5363A1C48B1CE11D03E0E5136167295229F092537813AFFD5500C35479A141DE4491362C940C3A37A6F18B6FC6E8A327B6E1EE7D834663A1BAD65CAB7A53D025B4D77E3C269F7D195277A28CA8A2F15DA18566812B151603191C68146375ED911FD0381BDD1CE3329581C3127E6D0D2AB80736CED9E76BE2669291C3255A8F2D04C6074695B9515C258FAC773C4587B2DE9CF69BC99E8F91B1FC3BBAA4626296C6B1EEDCB347E727B9505C9FACBE847F16EDFDEDCAEB46FFA8CEA5CDC366115035327EE5788AC5649126BED521826D673F42AAD7A3E4672AD28ED1074A4A1AF0F6FE5BF1530F65D09B626B0092B52E3DCC26822B0D5D0528EF13890236DB24E196F5E80B1C4397A802A1F4D0FEDABC59219B739F0D188B73D37151D29B7BE91B99C267D5F1AF56CF1E6E974989D7DB3747358173765C9B7E92FF28DE7A3A40769AB6525540FD6F691E87272B6ED9313496D9F9ED2F80E9A2851790E4093FF0B405B342EA6249EC05137F850815795C41101D9062EAEE417E842C67A3AADACBD2F411EDEA4B9EB73050F411CF277BD484CB7D6C37F18FAD3BC89FDAAF419535CC1A65D41F4F3A8F8FB20393C9643AA43A65CCBF16340A0D7F0B3BB4EE89EA6EFDC102769D02D52BCE5759EA7EBA856AD6B92A56BAA86CA87A428A5B7FFDF8A7B7F6F92CD45532E24FE50FE061495C5EAA825300E7111EDE3685D96E7E5E257523DE965F77DE220BBFD284A7F2E492FBD7B5875DE511097F381BCC8822829E4AE204AD6D13E886905119213FB92AA56FA8CC42FAFC37DF5666952D0CC4C29C150974041FAFC84EE4E67AEAB25032135B2EA67991B3DEA7F15A092A34278BAA9BB483A9C00A9009240947AC2115E820920841B9592795765F360477A9D8A7D381CAB6F5522084F627C136C29F382FC15805D4F20A3146502B851AC4F725BEDEBF0C7813BF1B56A321ED077DF47C21FFA54F6905FFB94FA4428440A34071291BAA0146578A67C163CDABD838481C6F151A40149D0FB5A06E0757C164D2E4747E6390EB49D8A3B01DE9DAA95523EE0A5AD595A8392F01E031B8DFD7EC014FF828701AA696F0510337A7679E909BD94624D00524A35508A31AC68CF0FC17A9709604026210449AC8564BDFF640B4B2C531D3CA14C4782A8A688534355534DA706592259BB858FC3644DE563D1FC6DB03DBEEFD515775E97ACAB4C4AE9C047008EA005B0675A6838038FB7784733743046982DCA3015CD7997344C0C17D7F538B09C4E07F93AD8C8ABE3CBB218DE110EA830398E81CAA294A13BE4340B404DDFF3C10065FD72E00033CB299DF5B342938F872D4B3A018E2D6B8FB4A8063F0B75646007DF6A32479CFA51C811A1AE7E31EA8890AE2AE8AC4057551D69A5027CEDEB6896EEF0D7704D96CA088F768FBA5447789A97D4C8465C9ED31671A665396DD551CA2570CCCE8A6EEE7515CDA05A9146855C647197825A2827F2D0DA2B38152599108A0ACB1FFD1899F0EA0A06079327580654F46FFC1800CFE4B5253EA771B730E8E59A008DF4EAA01446787867366C624F57A9A0A27DC78A84111D20752F604DE309092599087B1AAB534AC13E4D360BE2D4FCFF181A888F010C78605F0131401DF1AD1C299F91A0472ACE04E023999F548E81887F4EF4A9DF08D08083F860808411CB898CD9034713239354AAE9004AAA9A13C229FCFE8006299AF7A2B408218051F3DEC19005FF98C5A8505496693A082AAD4F294667AB5971578F30FA67BD7468E0627B461A2F7BDA919FB20C13420AB42F69F5BC7F986DB643A9CCFB185855F3D1B003A7A6874CA1E737D895ECED78EBD770F6130006B62425E3F60593F960A27F314359D9F477305C6165F050C79093F848CB784799E9E59B0A8FE4AAA1140878486516CC32E4E5185A2026731611C9C1047B103BBB5A9A3F7F26E73D017664F351329DF9C89A823C5E55B170120C36436C530021F9CC02287559260298DAF03487D43C0D300BDC20266C1468506408625D3C137081B20158555F8EEF2C98AAF4130051553194ECDB7A9F1982948D5428B277089EE4714455E9A784E0296EB02A9ECE2076861A8FE8ADD33D49EFA8D761FACEFA143DA5E20532227C345ED31B4C2D3CE86863C379FCA1DEF047EF15359CDB68374AE4A967BC56F3E68249574D24F916F318F1C20BAD4853F4C424FB939C1D47B13E23069BB1ADF09A801A1B50121C7BC64345C2F3053A7C7BC59DAA2893614E65733ADE8E016BA4A988E6911A8F189BEF10A7BA10D322EB14FBD0BECCF82AEF10C5DB0E43236DF281979CF7543B049CF94E6095B72A2FF8D280AA5AD5CF0EF095DC3F3B62081DE58B05D3B81C5D3126C294CADA27E1766854E42A301852F8F3E8605FA93004A1211F3A4B8D38F0E28F074EA3E24D8456A3AAA2944920AC3F0A14531DA5F67D8651903AAFC7D4946406189EAADFE4F8D3A890C3128D4E7E77927B15142D2642ACAEE28E1EB27472660C53164CCDCCF9DC9673DE00C316CF1E48F9F5CF658CE3518D8B38015A8DAB89340F9229BCE74431FEEA82064C842718C818226097F08805393B7FF36F6AE1A603ABB65A8E6EAEFEA6268FAFC731511266DD91FADB2A24FC26BEADD1C47E080B86C1375F5CBCE919E8390E6409557CE29A771A4ADDF2746B92B7A4E760F61D65BC4684D82142B2E4D18B4668C3230B89EA587909A5C24AA24D2CDCFF86E448B7ED892299BB422AB1DCAD2D8D688D4813511C1508244CA06231115749D18A6C66E11AB1CCA554482077F59720AABA5B8DC9692EB46B84B417262019FD15149A88EAAAA3424C73AF94264A830AE876A0463077C50892295CBBD282630BC361AB4D2A1CC786C44847DFB522D9AD7758227FCE81201013A34D5CF58750E2E6A80E2131E6FE86236E3A21FD160A2886D99C2209C285100560DE83DDA2277409DD022DD6350C4BE00461CCC205268F5B26D2F6C5FDEA19DC1F33EB94B4A6DABDBFA868ACFD138D5A91FC600C14298E59692215A22411CC004C1803016FF25C30B1D95191EEF91E6EF0AE7BC0A7576A188B49234EBDB46E06C0481B8666E27A0A6F04828180A76500DBE81EA0E114513C41C3EAD00C6D1506513C3AA3B5AC8525A4D51BF6A114C026CAF8B856AA64909D8031B4C2664AE91092A05AF0613CF1B50F8A01952F84A8D5C4DE08F16748EC551026877E66E26C4EBBC72A001B7B78F582338BDBBB178CADE0498FA242DC5EBA00721EA609CED5A57C4D01A815FAEB0B9C0948EF2F309A8A53368575492F2E9045BB9A10E6CCD69B124B47D41B49AE356D3B8EA29A17CB466766301BBF68858B06BB1667327C2A003169E3411ECD719E2A62370DB51581EE302A948736187D1815DA4C147A641FD632E5FC066CE8441BCE59C096389CB10BB94FB4A50A1FD3911B72521BD5859ED59A681E25AFB5DF9A5032598F591166ACC9C4B1239176593B72D3132FFB1E2BEAA99689F5EE501510C5AFC2F05A466050691527B0C130982C7B44C74E20AA05CC674A6FCB696A4070CB28CCEC1528AC6840692BC8F638575111AC22C624F1B14A9AEA1859892A92E58E88433545286035034E514E3F1AAB28A321BF39A4B01C8D475496ECD17C6A8E4BDC8A06DC9890CA34764C5973726F63C48739AA85617646DCB20436474853359F234143BA50C06CE25EA337E3D50E6520A8C3ADC647D46BC6C577B6132F6D44AF57673490E5212BB8189D9EB49A0A10EAE90AAD92010EA1B7DEF4D6B3BF61F630E48D9375A433C799DB8FCE15C7C896F7D49D6DCCB0950176C4B8CC387D003633AECC09C859AAE42FD3A5B75414E1DF4214A7B075498A68F8BA04C5B8D30C1A136918BA463019C43E04190B8C872B0345870CC49C91509806940618A53DAEE1CF289AB923188FA08666B668689489E6870A9E1D7DE3A2A186C0CBE3A7714D842305E78BDE64344C113862FC986C229469784BA04668C074C237201AD7098B8BEE0C95AA59D2D84D24A9BE763314A41BA8F1C0D83A15A144B8D108FE4C4FCBA1AF0A3783E9DC3D8163025349E7F2CD8D345183ECB301078FCC57CD60B88EE430986ED28FAC2878AD1F515B4F012029A124011054624E486A4CA3BCF63F92A168F7D311CB595C6E979436BBDE2E58813F30AA31AFD98576EEE0207B8ED4BBD9091025DDBF562A4C00AAB53127842B7A2D9872528E6E39ED45627F27E426321EFD822A6049CBDBAD9CE2E6F75BD9D5CBFE60B3C2B4E6375AE51C98D3D8BE4C8EDFA6C42D4DBC8109A9AFBF8369A0B559067ECD5A5D73AFE4F4B700FB6F57CB87F5977017B40157CB32CA3ADC178720AE4EDFC779F7E17DB0DF47C9361F52B621170FFB605D1D96FEF5C3E2E2DB2E4EF2978B2F45B1FF71B9CC6BD1F9E52E5A67699E3E1697EB74B70C36E9F2C5B367BF5F3E7FBEDC3532966B6ED15FBCB3D8E754A459B00D85AF55A7B209DF46595EBC0E8AE07390971573B3D949D1B4771EBB7CD8AB8F721D76B701BAD8D5DF4D8A5DBC7B280E9B28BD6C6CD7DC9214240C967B5B2A536D24D47A85C29968395999F0611DC441D65D28652EB6DEA4F16197E0175DF1D4D5BF7CFA26842EE15D09B8526B41CA106A20294DB690A821982EEB36AFA81FBE0AA28650BAA4FE56022BA80F94E55C2D85FA1521B4943024B463119024B8B6D7109CF0DADCCB35072C92EE5811DB5C9C6425405729951A7843177323882F501F7C3408EB2FFDB8F9C4F6EAB6855BC4527EC7D9ECD89047EE4E2011C559A0452F621CD8D40311193B4CB049D70A891A42E992866B50ACA421942EE9FA737A2878316D105D46F9F3318AC3DB5D399AE345F15FE812CB915FF897344A786943285D52370966E574617429EFA3CD260EE5BA63C3E9D2DEEC8228E605B54106B80C8A2F61769D6C1EF6E921078A064630A881BB5782F1AB00038BA555F680C5987003E79DEECA413FE0C299700347DEDEC1E45C791B4697F28F682FF7087DA041EB09920F87EA4084D074866003649553CA7AC2F83A2C648C891FCD3CD79BDD3E4E9FC26A6AB6933D18FFD54EF2DFC320C325375FED245F2787AADB28E7AB80F305239D61A7DE5D2775EACA5B4E1CF30E1C4B78ACA3BD93A9D6661DD4797C6639269BAA42ABBC12A9528750137F9BE7FF4EB38DE86EBB5013491DF1172F09A303C325B5272239CF04BF578BCB004E14721DAFFE5D515CF6C7701BE5453902178764DC87A36912D25D14A7D621F26F993714AD84F1DA8CFBD8F77AD710707153841D44CAA592528DDDAF379B70230FE9DB601334FEEB1065E1E65314C7221CD92F732C00B555FC212D42B968FD87A36B29DCE5042FAD85A5FBB26F314A29E3B41A80078343ACFC992E5BB823C9CA153E1D0D42FC21C30D113320E15354C4422B6E83E6F17B7582574F822BEE024D163277FB2079BA7B7C6CAF4AF16B9AC247035DC10BD99CDA600CC31CA00E89FB606009F83E3F670F388A691E50A1F92F565EE47520F633D2C7A3F124C28D74275FC293839A7B134DFAE3F52720990A3F6F002218A0F59095D397B5E0648650036FD514415E23E33E58C88BD30C11587F9963FE6636D23E86F6D71CD9F3D7066B6247C77608CB38DEB6688E9F996A9EBB0FEF54E72CE1B1796D2B531F6F3DFF5408EEF027992D5D959E6544E0B66898F0794694E50C77BFCFD2AFA23036DCC043B769A4212A137E546DA2A1D8706E10754F66D71AE0A4E3340581E88415247C32708172F77E6FDAB1DB007A26D0F417EB9D30D331B59B43064D390E625E45712CCF308650833A3E84B2A03ED0ECF45E7529583CBC07DDCDC6A534BB7E41148B98E33ED0E5DD557BDA6DDDC80D42FE6A301CEFE923B8E1781F6A340D2D6D2DF96626F8D85A594342E3A3A5D58F1958B73638F5382D8EE1AFE1840CC1268B25F93A8BF6F58A99B058C27C98782875086AFB0AE3A93ED460CA9544C57D563F78C1CDBA86603359D55FB2A826D4C0466911087B126DD0B1B52E7FEBBAC0FB1ED66D6D8E555E8735799FCD78263808F4474E48E05F6531078126FDFC33C4D9566EB6CE6B355BABD51920D538B520BB5FCCF5CE5407126991537D886F0699D78D56C22FB6B5880C208E15C53DC564534F6A01E354534709C59F006AC20C0E33B4DC37DC3986366CEA63280F6956DC651BF1982C136CB2ECF521F8FA4A3C6C3A849A486A2650A2A42ED444D2C7309096E19A3013293FEF374079BA501349CD9BCBA2A42EF4A89ABB87466ED9B4A76CD09FAACBAE52936E42CD24FDFCF19D2CA80E9C63F7CCA669CF04B68636CB096CF5C37AE66083938D03B62A2F794036849EE129EA8190CEB9722D4F53E349C7ABE4A93BF7B92A97A19E72ABDEE1314A8B0A56241EA78AFD8CBC067235FE3C6B17EA7F23755698788188353C8E711E872F30CB97CCCCEF96F1E48732C4CCCF309D4EA7C3D0227A009DE5191C55E2B9177B4EBE8A799E3BA74A664559DED6C2938F53D1EDC1AE3FA7F106BA0C0C7C9EBA73AB2C22176C0835D615BACB2B7C32285D1624EB2F42D9DA3083C6F2F6E67625EF4B33C167DAF038DE3EE7B6C73EB06DD7FC9412C66981025B257FD29FFB642C13EAFE854F53B7E6934127479CE9844CF6AD7673542A538F34F26C7511069F7DE8D1D491F4B2BD533D09D2EC77477109F3CF14E6AA29914BD1ADA678693635A59370ACC3EA9339D17EDFD19EFAA869FB1A3EA19A3D64EB2F411EDEA4B9B087C07F3158B50FE2103880C504CF71FFBAAD18988B8AF9623243C880439D43E87C07F2DE07C9E1B1ECBD0F9938E1E0BF185B8FE53C064CC87E9ED82348D4B762943EF736A4FFDD53DFB6B4B31C1F6E6D8F8ADDB6B643DE52E08A3CB44D94C5456986AFD1A6E6A07DCA8B70775945B87CF857DC9CCB1D2294D5103D8679F129FD6798BC5CBC78F6EC87C5C5751C0579436A6CCEB01B6E76CB3CDF70C73D189FD78D2E239171F6EAAFE193580F5DDD7F0C1F2F30A774B514135E018EADCAFAE522AA54AF1DE59FC2B266AA63C5F74151845952C50ADB139E1F0E711C7CAE58931F833897DA8F28BEF1734D06C9D7A0725525A2DF07DFDE85C9B6F8521B95155A6407ADCC81CC5621F7F9EF8CC50EC4B65EE50E6EB011FB392A4C45F4FCB64C4D292B826DA44AA8015CB1BF18AC9184369D8442E81C7860F868BD2302E475FD8E09234CFC66744C90AB534DBC7AB2F5CA10B87AAEDC81CFD56FAF35B0BB529BAC2CA3A576E50BF65FBBE0DB7F9B96E69E6376F5ABE9C0F3DAC8AD8EAE155165514375BB05447B83B104AF7E956C195F554EC0D80B809CAFAAB18845DD5434B078B55044B014B07E0BC7D2C1FA95DCD1C3DA23A967865516CCB8190E2CB1AA2186393A45AE58A5748B11B8C818EBB7BA64DE58AF56475963FD6A315EA70E91B19E6C573E4A2F3EEE80EA4C2C3FD0AFD2814F123CB0B17A17DC2D65839E9CD4F81B6256EBF40011AB7DAFC2F1AFAAC6129A592619BD4A2AD39306B2E3C8BA65716B243CC669602E8361BC701B61F134A86EB23CAC3670D4A7EA06ADE9238D618ADE273E59A802FCA3F6A8152E387B5F0B3A3FF3B75BDFE4C1B6BF864F73431D1BA83D262402507B5130DDA775CFC9917C228E96349983293DADCBC5F3783A144CE2EE344203B9552AC82FBFB74B7EA80770693AB4AC9E45933C1BA5357A9650D3EB3200CFACE979E5C279246E3A6AB36B20F259ABEF8DC4A922C9D580D2459E7105D8AC55D4B7A8ECDD124B43E9D0D7FB9ABCB0DC93D6530E9672720C58CABC8D278B4981FBD11E01F7FA6D4DE3BD6E4B5491EB1224543CD9AA1C98191DA7113D33A35B53EE9819ED31C51132BA1546A661F43A541A38191D06880319A3F7310D4A6678B26867D8D45CA6A8CCD14BBF3BBCA38CB606AAC4B63584EB6857F10BDE67E55F15C5503918FFA134F63AA864BE305F0A1D081447CC81DDB3B15AB86A4815BD94D0B4099DE1A296DD32A0972649B6BE821CF0740DEFEE220C26B5DB33B19AE9010F17AB2969F64ED6827ADC793521CE8077B216ECC8F4AC17AF3AAA1D7B67AB9CB39386E703C196B58C81340F9CAB13CF5A7474792E321AAA3C17091D499E8B8C8E1E8F2AC3A8159D51DB6958EB3C9FEEE859EC14727F3BCFA911F3B6464686CC0C77B2C81828E6FCCE9A3487185CDA254CDB76D2353062B7E46469843FED646DEDBEE83E90B0D9CBC0770F5C7C12406676B2F534CEAE0DE164B5FE40140609F7CDEAF10EC0627C63278B0FD3F9E8FC17BA601EB093AD008047CC6F6DB87BEA8151CC6FC9046A31BFC23BAA31BFEBE20CEFD8A46DC665ECA164EF3AD976233080396C5CF1B45F9E7B4AF7D63722325006AD934545255AEBAAF4F568BAB00FF35A9DAE154D97581DBAF47B15DFD4C95A708C8580F10EABDD438C50E76B7BABCB571CD35423DCEEA60C433285881967BC00E8C4B14AF91D280D1C535E4FAA288E3C585101F064537E4D702F334EB9AE2B5DE779BA8EEA3B34CC31A570D5F296AC066E14BE646F92CD45B53A36309CB445A9989C2EFBB0F787B888F671B42EB32E9B89A4E020A6A1CE6185B421BC885F49224ACF11566E2C0AE272F491175910C92C5B65F348D6D13E8885420BF1880EA932672F51FCF23ADC57F7899382538C9211C34323E7D78B155CA34EFDAB2553C5EA9AAFAEF5AF9AEAEF28921C6B4B55E137CCB99D063475C028D54DAF03C7CA96B9C6907C7A0EAA596A5AA4B159D555DFD23A385598AAC625F21C5698FC719C864FAD204720A88982903C3B5E8DE3C044438BB0EA9976B06A6DE913D8CAEC824E0B1B100FC411A163A03C9A051FC025E29570FD56FCAD008D78739EAD6EE91B1D46D04D674834F77D143029A901C64195F69A37922D70897A16847117CD56DCAF172890F8EB9B6C5D0B5FF85A7E7679A9C21197B62127A54AF6841FC5B5D471D023AB4CC91467C39E1E32550DADA4102274EAC536B4929BAFF610AAD2AB6104E5300694E445C509E0D4AB7F6A9092E12487287A39478491E135AF779A0552A40CC12BEB4780AA6AFCB76A377254236269142C234454E62E690E5D5E5CD70380725211E4EB40A666AF168436C7092EE445C923C013F606CF24106207DE3C9C600A8F69474CD8887BFC91F6E42325D3F135C2B072642002E969BE63E848300493071DCD4200F2B7024116757D1A137FD39A9D69D22FDC729C1549DDF291C761911E29162B4F2736BEB159829A7584D37189AC18168E15CFC881D52ACB8EC3D628174E0749CF6A22CA6A024781054AF0330E3A60E216242F8116653674709E82A1EA19CD5B58E0EAC4BC8429EC5882A45970C07077ACDABF57C3557BAC223B6E1BB612FB303A1E58E2104054133E0A1E40729E712081B2A360D90D44077322821D84CE050C6CFC097D3E1398180F788F032D2B8E42630532690CD5CBF36DB0352B7C31460C05789EB0A1200D191521E41331950167C5443DAEE8C9AB461B554C5FF5538D264C6A7C20099BEDC0CBEA5DB85D356F18E04B5D5B61816B6BB8AC45828BB785ACED14D54C8653FB3EC47C152C50D688BF15152F92DDB035287D333BE934151A947C3D33230378F9631694543419ABEA1FFCA040CD36C2577F1560E404AA24D20900488EB7AA171952C6A9EF5E2F4A5E336FEDF3DC4BABBEE6954EC04FD50FD94AD2D84F270F857B84DA0AC9B1238E9A050E1D59C9AAFA63D5727D609558F3CAB055D7044CB21DDFB3AA88F98FD875C83C3AE38006668C41F2EAF858E685CBB19FDE98032E53CD2F8CE032EB32A5D0D91CBB8F99BB939ACADF587452B37A1D0146DE7CCF918F59A6F227167098D5AB347441AB813568C5511CA19E656019E2FC0B134C9FC1B67456B2A0B15C034291340E2220B22E24279E5D6A463C34A358161A5A2C10AA4F8F017994C1048F8885E970401F9AF6E47373E36092533473D5FF64E34CB3DA9FB54FE82B1C5FC1F23124A892482B586750D5BD5E27B082C5D2D54DD3D039823C51D0F0E1E41100930022F9CDDEDC19F6B515C3B9C5FEADA4EC1858BA78DA0E26DC0C222C1D9C8812EEDB48741E08EDD8787841F9EF902C0576B9A340CE640E645E744CE9464C6131BB27E1281F8E7D65F3185822A644933147C4AC706AE9A956024D95F85B812D91BA8F3B67257EA3BBA08E8D0E1037D6492B1507E138780129F790AC0022B139118321059FCF38004533CB11524B131E8DF493C70FA7F8D1CD88DED4247675271B2561D68FAD36E1DB28CB8BD741117C0E729135B549F510160CCFD2E2E24D4F88C7F1593DACBF84BBE0E562F3B9EA5E1A42BDE68B84195E6ACB8026896DC321B9ED278DE09E4D4F2E71F7052C74F751235EEE37A57CE4285086722C4DCE1D4D94945FF701CAA5FB46D00AD1042FBD56AA74414CCA408A01E525452266CB1D1F47B3E662A9B2E7226A8AA0CE5A9BA54956C215622933E13B949D10C524C366F6ABCEB489A3CDB889A6C99CBB492465CB7D8532E42210B26A2EB081F9349FB04C9AAF9A1CFA43CC5206FD17487EFF9126BEB9658365D17C5564D344A065A5863D144991B1492310AE1548590BDFA15C8528DA46B00561BFC580BED58A944EC94AE2A518505652246DB6FC0635902B1F01CE948F43C813C90997AF95DA9CFF90A436C190D4E60B412AD23D0E9F30E9A46E92DD0692F3603E82B930DF49F9A079A8E4136523BD01FB11CF83E4FFF9757470C0327CC6062E430C426EDC8A1B98211703CB938BA41DC2322BCBC03096F90A0F65990834C7D93FA080BACE2186C2790E9174D98AF342395B310698AD1889962D9E9D321B493C33ED1226360023F805139B9DEBE8C8C385BD086E7253E68ACE5CB874DC6CAB4E054FA696BC4A0475011A6C40531D59B64D6179C33093D4C62AD024D45C3D69D197E57E061455C6772CBE66719749AD9D5B7A308448784C3186922499538F9FECD64AC153D9598D62C7F20B58CA035D30670864E65DDB41339D06E500037B4E966AAC6E6E5625B52D603D3A152EA71C3873AED5524E887119CDF227558EAB61607E4DBD81B0744425D96182AC24D4FBAB65A98D068E26BC220A3607DC4C9DD94EA731EB7418E4F640B50643374C812D53C1711F89F2A6AC9280499C8829BDFB2FCCB1FB75E8863C8A4656D333319EA8D1CC980389830A22F5A0ABBA47308850D1E5298CA565D773F4550E23330B231038E2005B9832CB710A022BF4B5728AA577293DBBECDE270697D4ED4C8211A321B620F1A839E2C2C26C16CAABD9C000F50DE8C3387584AD8D5A1564DF024AC7EE59B069C1CD086B33A829B0706B185067F9340AE63F09FB25D62682799F70D31078A2F80324D0C64DAD95723FC6D6AC0E86A81BFF40C2835B808FE8D3478CAB685DEE81E10759CFC138808441D656185A49DB5FE6A6B05549CF6983A96AC886C3A984ECE6D5DA69B6E826310D43E402A88FD1BC082A0EBB78AD5EF22E9D94429AEF837B7B760A21742588821472130F0ACB9BAB7D5AC596A9B90140820E4075301EAE02BBAB5A171CDA35955248B04577431D14D50CE9F514148EFE786C4515A4087A488F55BB53425A719D5F6F80B16A7DD236ADBEC00E81DEE0CA3B8F046907BFC103BA370FA406527A3342E3B2845BDBA801C0D81E8A0FA4923D007E24C349799DBB235C6A7675781328DC971D1C98305F7D2A56459006261E15026FA122EAE96FAC7A50563C43D3A744CFC6D8294EBB7A8958C2E2DEA6705A423A47D39E98400FC84886028EFFF4B6529DE9713717012AA4EB891ED032AD11D04B76942306639A61CAA305F4EB6180552CEF96F12B33F011AD666D467DEE0A9203A5F76726FC4E146E1DE23DAA318DC2DF9BA2CB5218AABA115A89E96FFDF4DFAE96CDD9B636A0FC59A459B00DAB437B715E875E2D3F1ECAD4BBB0F9F53ACCA3ED20E2AA949984F502E320B48B53C1BEBBEE2494A88BD27DEE07F745B0098AE03A2BA2C7D283949FD76139704EB68B8BBF05F1A18CF266F739DCDC267787627F284A95C3DDE798334675694A95FFD5522AF3D5DDBEFA95FB50A12C6654AA10DE25AF0E51BCE9CBFD368873A16BC14454BB1A7F0ACBF0A62E8BACAAF2A75ED28734210A6ACDD75F22FB14EEF671292CBF4B1E82AF215E36BD0D798B5DBD8E826D16ECF256C690BEFC59C26FB3FBF687FF075B0879032B490200, N'6.0.0-20911')
  INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201703091141340_second', N'mlmStudio.Migrations.Configuration', 0x1F8B0800000000000400ED7D5B8FDC3A76EE7B80F31F0AFD7412ECB86DEF0C3031DA09ECB63DE9C4971EB77790E4A52157A9CBC2A8A41A49E5712338BFEC3CE427E52F44D4959745722D9292AA9CC206BCBB2872915CFCB8B878FBF8DFFFFFBFAEFEF1C72E5D7D8F8B32C9B39717CF9E3CBD58C5D93ADF24D9F6E5C5A17AF8DBDF5FFCE33FFC9FBFBA7ABBD9FD58FD6B1FEF5716AF4E99952F2FBE55D5FEC5E565B9FE16EFA2F2C92E591779993F544FD6F9EE32DAE497CF9F3EFDFBCB67CF2EE35AC4452D6BB5BAFA7CC8AA6417373FEA9FD779B68EF7D5214A3FE49B382DBBF0FACB5D2375F531DAC5E53E5AC72F2F76E9EEAE3A6C92FC491BF762F52A4DA2BA1C7771FA70B18AB22CAFA2AA2EE58BDFCAF8AE2AF26C7BB7AF03A2F4CBE33EAEE33D44691977A57F3146C756E4E9735691CB31612F6A7D28AB7C4714F8ECD74E3397727227FD5E0C9AAB75F7B6D671F5C86ADDE8EFE5C575FDF3622567F4E23A2D582455B54F58825F5643F02F03006A9CB0FF7E595D1FD2EA50C42FB3F8501551FACBEAF6F0354DD6FF123F7EC9FF14672FB3439AF285AA8B557F1302EAA0DB22DFC745F5F8397EE88A7AB3B9585D8AE92EE58443322E4D5B919BACFAF5F9C5EA639D79F4358D8736E72A7D57E545FC87388B8BA88A37B75155C545C664C48DD694DCA5BCD8BF7D6E35C8EADE72B1FA10FD781F67DBEADBCB8BBA492E56EF921FF1A60FE94AF05B96D49DAB4E541587D896C9FBBAA8B5E24D193DFB5D887CEA3E324B4637E5AB75957C1FF2799DE7691C65B66477759BC5F6D695847C8CBE27DBA6B12171F783D0CF71DAC42ABF25FBD68A34B8BF97A2BD2BF2DDE73CEDBA91F8F5FE2E3F146B56AD5C1BE54B546CE30A5FCADA7A15B77577CBB328BDC91EF27B26F36653820506237729F8A29BE20D25EC2B618CDCD798AFCED5E568728C86A8D109C9123529CEA668425364EB4E52AED7B9D15C2C682DAEF3DAB9281EC3D98BB133EBBA1FD95EC85DCD6052D0A56CAB7DCF551F28699B0710772CAE268A62E374F1204387B60C9D189A97D2A6395B8793B10EBFCE681D2C6EC0805BB8677BF417B98FDBFA95537F91C76852C791139F7B1094D7BBA428AB65BAD1FB2858CEE68C6AED6CE2823C644A525E7DCD0F95A1ACF59F01CA5AFF7C48D2F866176DA757CC9B1A32FF9C27599F11FBFD25D9D19B92F5355FFD7E48369B349E05106F7751929A2C780813FE2EAABEC5C5AB6C73B7CF0FA5AD62CFC234E8A7D76A5B5AD49EB362CE52BA8FF92EC9E651443F39F401E47F247BCB48FF2C44516FA3ECE361F7352E4C138E20A8DF1CD6CD98F126AECCF8FF5DA0059EB27ABBDBA7F9631CD7C3CC6EF246E733FCF73832293448CBF1F9BDCA0ECCCD58E73380DBDB3914D64FA65A70916754A8D5196C0DDA21FD7E1CD931B55012196A22C5B5D7464EE0B22276DF8FA398DA08090C35E1E2D96BC147F69AEAB67A2039EC6D92B39B0EE5B58C87EE6D6834BD04BDD0EBD363AD0BBEBA2EEE3C55254F4FCF5887F2629AC9C2388944BCDF4665F997BCD82C9173512B47D1B2C5FF88B7C4141F62E668DED53DEE7DFC3D4E7D3DE4CFF13629EBC6BD1DA790D06C2AC47279FDB3765FAD1AD25AA23775B767C19FE33F1FE2B2EAC638D80C41718191D6104D313EA6B8D4B5F0B856772F8795C654153E6E93E79880AF8A219A5215535C6A556EB2EF79B28EEFAFD3A4813F5C893E56935B1F952F3E184129381C8B5AE4F7F1665B4FEBD76BB6C46984911A1300913692527C7D4C7A15B6F79DEDD00CC2F75C1471C81DBF80CE24F799EA004BB6E91EB055BAD222924AB5B0A6806B674F46AF7576A8BD925D52B2C1DF8827202A00287D2C055186A854487D8EFF12151B4E025C05291A507C388652744D3472B16B61F642F391A02203DFD5024391A8C56DD2F6AE82DE856EC43F5730DF84826E71F7C9A538CFDD4A01F62EB1809452BC8EB23F0DF357936A84889AD9331407541B18D14589D7795645B57383A9811C5753094D34B01EBAB82E55515613D0733D97F50CEB1CCF561DF4FC4E72E048533D29ED79D607E5D5B7BCD716DD8EF946C30E485E6B8E3E15631B27AF369B78280B762785356F52C49B2F499A52D33A9E06EA10F531AF2CB365A76567EB64EA4B1165656D3998F72081DC36B73224554541B32E9200ED7C8C26C569BC36ACE9069868CA03296652EA6500398D3919412EFDD91082F64745BF8F4DE4F41DEED020A2C71E4FDFD77511370B8255112F5D6A03A46A0C12CC2AD12644A9429FDACB7EB8DA8DB3BDB075F0A44A8D87952759B036784954A78D4979FDE867E5AEF3DD3ECA1E3F3D3C246BFA650AB96EF1D7A41296DB88CBEC8D00D819B554A3761FFDB26E25B8E4CD75B437D1E84FE2DB95E42E0A9605EF2A4E601331AEA1DDA2BA2D1F6BDA1B50065F02948C511DC4A4CA20414D4F1D29459970E7236904168151089492A00F30B9D7A82908238D9B42CAF3C8095ABC45464EA16158DEBEC3D5F5A128E26CFD685C0198A2265D1D6C97A5421C791BB24AF3C98FF539EDC53B2D5F214DA279C55F8C2BFC7AAEDF6914E359361BA5C85E631EBC6110A412B2A146D5D8A912AC95EFC18E4CAB9B5E0EAACABAE4144D6865F84C7841C70086EF8C8E8D0C7257C7C84523906B40554860BF06AF0EA35B146A31D4F3B88419F2C19641959EE2EE94B13867C70CCA6B19C70C37EE23C76CC0A29287EFA94607C2606F1D61DC874F8257039742EF1868E29B2BAE4BE45D5384C713AA82462368D38A933DE44E03922C2197EE6C035D6CE04447FEFF5879AEC4F2074CBD16615DB7E16FCA57FB7D917F1F532237D3FB64CA5A34E5602E9B0CDF73E0361DCC95E38AE9E4F3B9E6D8E0315D4B12270F8E6FDF690E1CCB460C7338D9D976B58B1744C3C5129DAD16949784601F03706BA3D90871AD006F6550C7F1A5EACFD1EFA1DE8234154E9DA63B454FEA335D9A739781F27A9DA4A9DB869B8CE5430CCB312763CC2D87D2AFAFB637A1A324A50FD79F18FD400790395692C7FB235E6BEE45CC1A9BBC6D6DBB097353C5BBFBFE6FF375183EEA9804B8160347D45D8FD1C476BCD9C3AF29E1AA05A430D6CE185F574973226A5D6FA3C75D8DA9B623DDF7FDC97091094EA0DE6782E22906DF18D9E916FAD845C25DC6D2951ABEB2E533323100BB8C4E2CDD798402F31ABB9FDFB19A725D24FBF60498F7BCF6185710FF78883A85766360BC4E76517AB1BA2DEABF3A12EADF5FACEED611934957615DBCEAB668DCAF0973E0C9061C0F9DD6C84BC395D17A7F9443E87403A6C6845986571F53E67A66524D7E366C204C3DCE4607B29161A01DD669D2001DE76939E15DF05D485017529E510EA27C9EB1D08AE4B68D26F48C7517FE8D6EB4E32EF096B8EFBB3D6313CA8B773526645B31CF771ABE02C3756A0C190278AD5AE54A70429BC43240429E94F68C42170B390F0C1532090324A760BC00218C27CA7084364F414144369FF40C6C282FA623E24156D6F6BECE30B8FF6B5985CE8BEA53B119595051A96ECABA4BBD1E993E879D5E32D15DBBA0EB2FE7731CA9FBCE6429BFED37414AF3264E63073946B69AFB1E54768A1A21BA96A2868BA54C3D0C51A94B9B4CE07D8F6E7BD985E8DAB273B16C65E7A3862607F5A606B2943DD8F14926976CE5CFB61DCA8B69E64BFCC344493F115921CBF9B7CFEF0D19FFDD11B124224716B3CD331F561CCCD273B9BBB5A120F356F789BAD9D465E3520AA8934B05A49442B2CB48DA32FA9860A12D83860F27DBC4A4936C134B70B64D505E4C3396A9FD343B305A1E1D2F97471AC59148A77B1016A443CE06C5FB6946715305844840D1A1EF7AA63B5B71491D934924774E96E8DC41751D7492599E733FB3B9E74ED894473C23804339E3432614BE486D4983B9DE236526AD1F0DC9CE3D29582F90B1DFE8D8578A7A741FDDF79AFCEFC76298A95B95E8207DAB144B45B83E6AF01EE94A3B6B2873E07EE9D027CFFD11CA6BA17B33D637955C4918C1AEDADF03F43AB1E0FBB8C758947BB154DA1E78AF4D22F7445D4C4D8FD446272F12CA4609C164ED660E0D8CD63ACBE9615E58808389611FCF6606CA2BD0C6F52C5D54E812263807E89F30ACADDDD909DA3C0737F9ED9D3EE119DE505EDD05E17FCAD3CD4C8F4386F0A3599BCE52D84E3DD6771BC3E4F6BA88B2F5B7C9CF4CDFBCBBBEB9B7BE7839A95DF33B406198017871FF438F15181F0970B6661C133FD9A07169CF360DCAAB535008DFB9136575FA279A6C84B095E1FB20A7DF7B49D788B72C0CA9F52F5B6813817D1697728A873B3D1FEDB05526980DE23441B23F5CBAB3ED81F262F9583C9350B602FDD28C007BDC8333813BA9ED311A7BF7F6B96DC0B04B46BA94F68C7610ED81CED3BAB56EFB52E4755DF26D5E3CD25A574C7B6E5D28AF4536F63DC9D9BA86BD971A5867F734D1D5E4BCDD432752EC1E3E25F96ABA2CD1788EC992FF73A0B6DAB8BA4AEA1378D60D3E1415B44AB21F86D6818F2173316067C3E560B8A67ADAB9C6CCB7A88CAFF3D2F769B2BB288DC5EBDFA8971D9CA77A7087BBD945DB108EAC6D2DAF98850F06C74A50FF1920AF0F517678A89DD8BAF399560DC3281018ABC29CD4410C8AF30FA91AD34C188C3136FA5559E6EBA4A95ADF256BD3C4262787ACAAA577FFAF2B21EAF26DB659B5E5D2C41FCBDF828269AC895A03A3B6D6C9BEB6CF75795E5EFC8DD24E76D9C3483CCAEE3ECAD29F29D26BEB1E33972189D27A0656D6E3459255EA509064EB641FA5B88248C99163096B952123F9CB9B781F676C18C0A9195382B12D81820CF949C39D4D5D57971C84CCC8BAAE5BE4BEAD47F3AF01546A54084FD7CD108987132015401288D24038D297600608E9958AC9BC6FB265B0A3BC83DB5486FD63409129118427393E055BC6BC207B05603710C8304599016E18EDA3CC56DBC84782BB3FB01C8BEE7F14EC490927C79F9C1F80C1F6DB5C28D4146809246ADA025394A1E197C1A3DB8BA33AD0783E3F3A22097C4B170F5ECF2790D5720C04EE9340DBABB833E0DDAB5931E503DEB45DA437181F59D2810DF7E2D28829E9C53A3CAA71EF5321337AFAE44920F4628A35034831CD8029C6B88EBE3C049B7D3DE0D50B14423489AD906C77FC1C61A9CBD4064F28D389206A29E2DC50B534D3A94116F9408F838DD3C99ACBC66AF377C1F6F4B6D756DC654DB2AD3131A5031F7E3A821EC09F5FC2E10C3CCA141CCDD0212869B6A8C25456E7A7ACA5CC59BD6AFCC07A3A1D95EB68A3AE8E5FD6C5088E70A00AB3E318682C4C19FA036D8B0094FA86A40E50CE2F658F30739CD2393F6539BB3FEC58D21970ECD87AA84535F829D223033BF83E281D71E647D02784BAF995D22342BAA9A08B02DDD474A8950AF085D9A359BAD3FC4D5CB2D34A9969A94E9F3F807543BE132ECF598BB8D0B29CB5E930E59258DF1745B7F0AE9DC5A936A4312157B3B88B412D9413DAB50E0A4E43496684A241F347EF23231E9ED3C181F20ADD888AF175453CF028EF5C8A394DBB85812FD70C68C43707A630D2DB838B6153F768A8092AD617445118B101D2F6F6E83C9610519299B067D13AA614FCA3B08B20CEFC24900E0DC8F781463C084F92E151877CB84FC96722E8A18A3303F850EA4795637C1A6749F4995FEDB18003F9848F8211C7890CEDB5C59991892AD57C004535CD09E1147E95C78214CBE395568420C068790568CC427A5E6A4A281ACB341F048DDAC714A3D7D5A2B86B3C8CE18D511B1A84D8819126CA9ED7F3339661464881FA45AD9E0FAFC42E7628957BC349D7D46234DD8153EA2153E889287E257B3BDDFA359CFD0C80813589C9B87B656B3998D8DF55323636FEB5245F58119E731A73521E129BEC2833BE7C73E111DD34980201CF6D2D8259EEC9071D5AA0F71F7844B0F758F0D883DEB4304B0B67CFD4BC67C08EAA3E4CA60B1F59333CB9616A5838890E36B7DCB36D340069F2590450E6B2CC0430B3E27106A97D506511B841ACFA5AA041912188F5F128E0026503B0625F8EEF2C98A9F43300D1D43098ECBB765F1882988D54287270089EE4714453E9E784E0296EB01A5EFF410E86168B186CD03D49EB68AFC3FC83F5295A4AC3539148F858AC6630983A58D0C97CC365ECA15DF1476F152DC4F2DA6114F90A0467B5BA675408433592C95ECE63C20B2FB822CD3112A3F48F3276C23B020B62B0F56DA5B73ACCD88092E8B1477615118F83D8F01D1477A6A2CC863993CEF1783B06ACA1A6229677A702626CB9439CE642CC8BAC531C438732EB5779C728C176185A69B33B5E6ADE73ED1008EA3B81555E565EF04D0B53B39A1FB8101B797C5B87061DE3DB18F3981C5B3166C29449DB27617670E4EF2630109F6B10D121BC8742032191819EA746E4DE40980C9CA4E2CD8456525361CA243D11701428C61A4AEB5B1C932075598B6929C902303C55BB29F0A76121A74B3439F9DD49EE55606A3113626D0D77F490C59333EB30E5C0D4CC9DCFED99EEF11876786C41C96F7C2264128B4A2EE20C682537136A1EA452782F8962FD5B0F1630211E7E406308815DC4D319E8ECC2CDBFB1859B0FACD66639BAB9FADB863CBEF163922C2EFA23F5372C24FE01BDE8515BFFEE518FB263F797C1C324DEC515C7F25B5EACDE0E2CF5024FB2823C3171C34D0DA5EEB8BC2DC93B627430FB9E56DE22421E342159AA876311DA72CD42A27AE65E44A97425B12696EE884372941BF94891DC7D229358E1669745B4452445944017020993E85A28E29A0E6113D9CED42D62B98BAB9040E17A304214BB7FAD93D35E7AB708E92E554032866B2A3811EC3AA4414C7BF71427CA820AE806A145B0700D0992295DCDB282630BC3616B4D2A1DD986C428C7E3AD22F9ED7958A2781602215027C69A988D9950E2F6380F22B1CEFC8DC7E06C42866D16500CB7818512A4178214A0B31EFC363E6248E817717543C3B84C8E10C62D6EE8E4094B49D6B178586183C7636E2D13D755FB972D0D9D757C38D3265274D84091B25F8B136910A588E09C34C90702DEED5971B179AFC8F6C48FE0E0DB1EF9192A35FA628A576A97D6CF123869A36B26AFB9884A402808787E06D08DED911AA12286676AF83AB4AEAD4121868769AC9A75D084B2C2C33FA602E8C4185F5F2B5332484F800F6DD099513A8424A81542284F7E1104A340E32B22E66AEADE1109A748DDCB215C0EC3CCC45B9D6E0F5A003A0EF03286A016BFB731385DC1931E4383F8BD8601E43C4E13BC9BCBF8E202D02AF8171A0415A0DE68E06A2A4FD90CDA45BDCA8016EDAB429857DBAE4A5D3A64BD35C9ADAAEDFC28AC7A75D9D8D40C661316AD70D160D3E24D988F05A04EDA7490D7E6B84C13F11B8BD686D0EE421A2A0F6D4286502AB4E1288DC821B445E5050774E8452D2E68C0955C9CD30B7A4C74A5139FD2901379AB496D6167BE46AAC7C87D1DB6258C6CD75336048D5919E93B22A999AD9E9B9D9C39B4AF68A76346B6BB47534034C006C55B5983C14A9B7883096E305AF684861D41660BA88F4A812BD4944082CB5598DB2B306891407B2BC90E38573191B06A9489E26C556A6A636D4556112D77421C9A694401AD11784785FAE19847B91A8A9B4306CDE1B84655C901D567E6C1D46B91C09F095519C7A0A9D61C3DDA90383327D530CCE0A8D72C82F111AAA999F3115143BC50406DF25E6330E535066524B1D36B4D8C68AF9910DF5B4FA2B409AD5E93D148A8A759C1D551EE29ABA900E99EADD02619A00BBD0D566F3B439C4E1F446E39B58E787639BAFEF07C729C6C754FDD5BC71CA319A0471DDF99501F80F14C287306F29A1A39CE6CE91D2BAAE1E8D2541CC3E8A554C4C2E925554C38CD60519185C56B0295410C4590B2C078FACA40D121057167240CAA01A5014AE98E6B84538A65EE08C64354C3325B242A65A6F9A1818BC7DEB970A84170F784E95C33E1C8C00B6357190E53081E99302A9B0965166E13A81312D850C40E84E343E171D19FA132754B1C038A2235D46E86819843AB3C30B6AD8A5022BDD210F6CC4EDD616F0A3F85D9CC3D82874257259BC9A72B69A60E3964033A8FDC578B33DC44F270A6DBF4135714BCFAAFA9B69D2640A984912840AA127742D2A21A2335C0448AC2DD61D768CEE102BC5269DA1578490BE281518B7A6997DE858383FC39D2E06A4740147547DB586104509D9539235CB557873127E5F09AB35E360E77426E26E5E12FB1029A74BC012B549C7E07965FBD1C0E361B544BBFF5AAE6C09DC60EA572FD8D4BBDA691B734A1EADBEF69126A4DCB20AC5AD955782667B829387CBBBABC5B7F8B7751177075594759C7FBEA10A5ECF47D5AF61F3E44FB7D926DCB316517B2BADB476B7658FA6FEF2E563F766956BEBCF85655FB1797976523BA7CB24BD6455EE60FD59375BEBB8C36F9E5F3A74FFFFEF2D9B3CB5D2BE3722D2CFACBF71A879CAABC88B6B1F4950D2A9BF85D5294D59BA88ABE4665DD30D79B9D126DBC1729EA6DD0719F0F7FF5516DC3FE36401F9BFDDDA6D8A5BBBBEAB049F227ADEEDA5B9292845173EFEACAB08D84A65EB174265A4D5627BC5B476954F4974EB9CBAFD7797AD865FACBB0FAD4EC5F317D1B8297F0BE065C5D6B49CA184A9094675B48D4188C977553327A88EF92A831142F69B895C00B1A025539579752FBCA10BA543024F563199028B876D710BCF0DADECBA5035693EE5811DB5E9CE4254057298D3508862EEE469058A021F86810365CFAF1B389DDD56D07B3A84B79C6D9E2D8503D772F90C8E21CD06217310D6C1A4744C50E174C195A215163285ED2780D8A973486E225BDFA9A1F2A514C17849751FF7C48D2F866577B73A228F10B5E62EDF9C5FF9C2799286D0CC54BEA27C1BC9C3E0C2FE543B2D9A4B1DA767C385EDADB5D94A4A2A02E8880CBA8FA1617AFB2CDDD3E3F9440D1C0088416F8F45A523E0B20682C67D9031AE3C209C63BDFD54E3F60C2B9708221EFEE600AA6BC0BC34BF98F64AF8E084320A1F744D9C7033B1021759D319880AC7A4AD94C18DFC4958A31F923CD72BDDDEDD3FC316653B39D6AC1C4AF6E92FF3D8E0ABDE4F6AB9BE457D9810D1BF57C1530BE60A49F7050EFAF937A0DE51D270E7D00D7253C566FEF649AB55D07F5F6CF1C7DB2B91A94E595298D3A8652EC6D59FE252F36B2B9ED4329927A723051928E324C2FA93B11295826F84D5BBD0CE044A130F0DADF1ED5CBFE1C6F93B2AA3D70D925133E903C46B6F8A9A86E0C3E9AEEA5DC6BF1EA69329717BDD359254CD7FFFCFDE857BB96CC4B986EEC20822F9314360F78B5D9C41B757AD0055390FDE74352C49B2F499ACAD0E6BF2CB198D435F1C7BC8AD5A20D1F8EAEA708171D82F4169E3ACCBDC718A54CD36B004E0D01B1EA67BC6CE9BE252F57FA74340809870C3F442C80842F49954ABDB80B5AC6EE35095E3F4AA6B80FA42C8AEEF651F6F8E9E1A1BB7625AE8F4A1F0975052F770BD506631073800624E1034113303780A00F380A350FA8D0E217272BF22692C719E5E3D15812E976BB972D118946E9D6C492FE78ED0948CC22CE41800804B41E8A7A2AB4968CCC184AB0566D11D4F536E18383BC342F34029B2F4BCC05699EF631F4BFF6F85FB83ED890447AF64358C6F1F6453A7E166A79E16EBD579BF3E4C9F4D636A63EDE76FE632599C33FAACCEBA6F43CBB82B0DDC3852FE351D633DCFDBEC8BFCBC2F8708285EED2282E2A177E547DA2A5EBF0EE10CD48E6D61BE0A4D3740589348517247D2298407578BFA50EEC2E805E0834C3257D2FCCF4ACEF74C868534E8398D7499AAA338C3194D0C68758153404D24E02B20BC6F24140E89EB75E4ABB831825A98C39E1035EDE27B63FDEB58DDA21D4AF04777CA0A210DCF12194340DAD75ADD8662EF8D87A594B6813A2A7350F2338F73638F5343D8EE3C211848CC194C592725D24FB66C54C5A2CE13ECCEC4A1DA246BF923F358412A65C5952DD16CDE319C2AC6B0CA6C9627FA9A2DA50828EF22A92F624BAA063EB5DE1D67581B7429CFBDA12ABBC1E6BF221BBF1427090A894BC9020BEF042078125FDF233C4C5566EB6DE6B355BA7D51920D534ADA09A5F9DE95DA80D140224AFF690DF1FA2B78D55C2FFDADE22B389783694F0AC934B3B99054CD34C3DBD94789AA80D231C66E8787484730C5DD8DCC750EEF2A2FA546CE423B75C3065D9EB63F4FDB57C70750CA5486A2750B2A43E9422E9731C29CB706D1845CA6FFB0D509E3E9422A97DE35996D4871E55770FD0C91DBBF69C1DFA4BF3A0A8DCA5DB509AA4DF3EBF570535814BEC9EB974ED85C0D652707981AD79A48F0E3638D934606379A90ED918FA139EC81EC9EDBC1BD7F164B63EE9748D3CF7E0BE54E37234567ECD3B3E6CE9D0C086C4D3347118CF6B246A13CFB3F6A1E13752178549108838C3E318E771FA0566F5C21AFD9E9A48A4A8428C7E86E974061D8E623100E81CCFE098122FBDD873F24D2C72E67935322FCAF1E6973EF9340DDD1DECFAA73CDD40178B81CF730F6E4C236AC1C650725DA17BC1D22742E98A285B7F93CAD685113ACBBBEB9B7B755F9A0BFE493B9EC001E8DDF7F8C7BADDBA9F51C2343D5062BE144FFA0B9FC832A1E15FFA34776F3E19740A249C5EC8E4DF7DA7A3D2987A22CFB3AB8BE47C0EA147D346DD6E24D373807692A4B9EF8EEA252C3F5358AAA5645E46BF9612A5B9B4944DC2B1BAD52773A2FDB6A7500DD1D2EE2D7C422D7B28D6DFA232BECE4B690F41FC4258B58FD2183880C5052F71FFBA6B1898D78AFB42992114C0A1CE3174B903791FA2ECF0508FDE87429E70885FC8DAE3F9930115F29F67B6080A8DAE1C65C8BD0B197E0F34BA1D85ADC0ADDBE88331E5367A283B3A5D99D3B68D72B1AAD5F03DD9347CB68F6515EF9EB0084FEEFE9CB6E772C7087533240F71597DC9FF14672F2F9E3F7DFAFB8BD5AB3489CA9620B963EB7DB13E9455BE8BB22CAF3AFA64047DEFB35F197D6FBCD95DCAC9E924C04C4A596E8453249C29ED9DD64426C5BDFA97F8516EDE1E529FE38795CED65D5DCA09AF007BC9B27E7991308D36F6F70F71DDE0ECB4F26D54557191B158717770F4E3214DA3AF8CD8F9214A4BA55BCAE25BF3D966907D8F9805AC3BCA87E8C7FB38DB56DF9AB6E28556C5C12A73E4DB35C87DF63BB2D8917B37A8DCD1BAB662BF261555C440C1CBB5940CC61737D926FEF1F2E23F9B342F5637FF76DF25FB65D5ECEEBE583D5DFD3F4B03F236C308518006F77F0D465142DB31CB2074091C7154BB34240D09A7C01248767B4613094DBF4E8E2674739AD9684FB65D3956DBC08D3B92DC861D2747CA5B5A67EFD311FABA9A7947942BD6E8FFEEA21F7F4DADC6ADC0931B5645236B6E2B971DDEAB12D614C4EAF64BA8344DB7A9BCF4CCB3EC86D54D47BB6B323A64AB0312EF9ABC2D8726655CBCFAD6C488E07978C3168EE7E40D2BB9E7E8258EEB4D2A2F000EACBEC6FA903BFDC8F06BF2A1E8A096797E8DD21DA62632DB6FD85656397F836A5DCBF81BB616D3F91E1091EEC97A1C93381BD3FA7D3F89E647EA5C3CF051824726DDE082FBAD03DA00D0A7D30D0128ABD1B2F1D2326E12F9E40A70F6D24AA008F01A0605B25F93CF449EF7DF8EC4BF5C05837459235FEE49F7DE457CF19E61B0CDF821CDA38A2C836363F17362458A5E3F5901969E045A5EB3F1B3F81364746BEFBA9F2CC2016E5C1AD815015EB897AEEFD38A22249E6279F1E76BFEEE58087A6214CEF0E0CC60CF940B0E57C8F54E891CD75D144C854BEC2E800C1FDF4560D1D58C16A8493FCC994B5C038084F8D44EA4DBF5A89E42B14B0226DA4018386ACF264274F401CA5BAADBAF88F01A7A46C25CF44208CE86F1DCB94157A04412DDC08B66CB4D026772BADD3AB57A8CF3DCB197010EBAFDB414B63F71CBB9ACE735373BDDBD239E1A97D6F6634A2F031E6CBECB53E93ACF527906DDD08B2D300DEDC9C259A2B2A5814748EC859F5BFBD108F28A9B2326D14800D9654F1608234DADE7BC71A0A9F533043D4D2DFDACDCA1F482A2406AEB570795CA36A80F3AF2DA12A78A5D3A3F977D64C2C58E5BD49EA532C99E6CEFE2A82C696D3524F41B9EF913F361CF974CE2C98E0CB75D078CD7C98ED1C2DE16F55F6573E6FBD9EFEB665A474CE673FAE6C2C87B3B610EFCD6AF8B5BD771E1062921B5F3FD84EBADDAF5ED63EECCE87633B0C19E6E93F91B17C252C3F627D19AF5C489FD68025A6B465ED593D5A01D774155A8A73C3D590DF6ECA9D4C31C2C95CF02664FC946CBB74DE5E5624DB1728A9A278DB48FC8A50E68D1A5A77205975C9027D27A12571F192D81AB8F849EBAD547464FDA8A9541EAEA3F51076FB954039F811BB8550D72FFEEC4CED6D13B291A522AD1E9C9426A644C0D3B9BB49C7BF2E9D0300BE949B7C04F337A7AB5AB867CF4645B76B1D39423F12911545D3AAFCCF5DB6A3E1617601E3D595C4CB39D89B896633F21AAC392DB91153EAD17A6A6BB7AA163163D597051172296BFF10C337E9E6C03008CA1615B63B16165A41C0D5B21897B34ACF09E8B34EC0E0C474C3A6B57F3F1AF8CF49E27DBDD248A50E2AE2C9FD86F6B5664150D3CB62FD6E52784A396D7F364A1C8445BEDA3BDF9A9BB4F30DBE6E96A91BA0FE0E17EDC9A58304F568353ACE71CE139D75B88E0F2E76D34A7BBCD0271662BDCED7225C799A911338D7703D44920C90CEBD68D9499410F8D198E0239F1FA88DC99615570AB1268127BBC2C20C05AE1ABB2CCD74993638F47C6A2D793AB8D246B9231789B6D566CA574644AEB2AC3A82D9F0C611F0E6995ECD3645D675D77344545A39896BC8F17D2858822FE461151DB9E9859C2244A6BC7A7AC8A28516947EB0E96AD937D944A8596E2214D1A53E72051FEF226DE33C28FAC122A86C98863C253F31BC44AC6D556FDAB4BAE89CD2DCF88775A7EC69EA551DBE8C8D63235F8357722AE054D13304973E3DBC0B3B15596544D3E037BE6222D2DD3E1359C4B1DF192BEA3631ACCD4E20A091F2F4CFD384DC7C736902710CC84839A3C7BBEACE3C044CB5B3430EF6971D1F11BF18DD9079D163620A2A62342C7489DB8083E00E60A99B241A570D082466679E19B5BF986871144AF018916BE4F0226238DCD34A8B2728B68B205983B164198703D56BC95FD5C0B24F1A23CDFD6D217B1959F3E7962C29190B6656BC74A0E841F0301C034E851AB8CC954FF3CC8FC90612DA45EE64742A759E7D33672FBD51D422CBD1946500E5340495DCF9C014E43F54F0D522A9C20B688A9108686D7B2D6691148A13204C9418E0055CCFFEB3691B4D8698E6BC95EB08A10B9329FB2F6BCEFEAD5BA7D4DE43A2AD791FA560D5B10DA1C27B8344F6C1F019E748F12CE0221DEF116E104532ECDEB31E93CEEE93DEDD93D25AA7FAD61C43A3210819C64670C1D098660C6B8A35908D0FC6D4090435B9FC6C49FDAB20B4DFAA5FBC38B22A95F3E0AE816D991E2B0F27462FE8DCB12D4A21E4ECF46C453F188B43C5A58F0D45C7C8B0AE178900CBC48B2AC3670125868D9C5A641074CFDA4C94B22565A0C1D82A5E078C226B3160EB83A312B41851DCFCEB6080E383E9D9E8362E4A2D022A1E7B7E21B7108C3E38127F30144B5E193E00124E89A06125AC6225D762385C89288E09DD0A580A1F33FA1CF3F094CC80EEF71A0E55EA098B9079966C6E615F968F89695BE901183015E206C184875264508FA440C53E0A29868FC8A81896E32AF62FEA69FCB9BA0B4F8C8F8B7D88117F6E44FFBEC8F61A96B2B2D706D89CB5A28B8045BC8DACED1CC683875EF302DD7C012A593FAC292B6E1653228BE05956FB4934E73A1C1C867B5303280B7B2164109636869A89AF407051AA21BB1F95900C908B024CA0900484EB0A697C979A669EFA15E98BC16DEDA17B9C9EE8796371A81304D3F66AB48E33F9D3C146E35D46F9A1C7B62B545E0D0D3DD34942F1DEF8B16080D3311DF746DC02CDBF1032F8F9CFF844387CAC4340D6860CE214D5E3DA3CFB27039F6D31B4BC065AEF905092E8B2E534A83CDB1DB98A507A9B9EC8DC320B5A8D5916014CCF61CB9CF32973D7180C3A256A56555E2F89F042A28BD6519C99804FBC205E367B01D65982A682AD3A061929A061110219A262791C16B413CB45E2C0F0D2B1610CD67C780EA6570C11362613E1CE05DD3811970691CCC728A66A9F69FCDCFA4B5FEA263C2D0E0FA15AC102E014BA2AC60FD044D3DD4EB0456B07856BF793ABAC023280B1A3F9C3C0260AE444D7E8B77778E6D8EA75A1369D70C941D23419848DBC185D320C2D3DFC92811BE4D44E7A1613C9B0E2F5ABE3F4D96129BDE5120673603B22C3AE6342354582C6E4904CA87635FD93C06968839D144E68858144E1D3F95CC53A5F256E94F5949AC81C2392BF91BDE04F57C7680B8A94E5A99E80FA7C10B48DAA7C90AA0225B12313AA4E8E7331E40B1CC72A4D4CA84C722FDE4F12354FCE866446F1B12BB66904DB2B8187CAB4DFC2E29CAEA4D54455FA352266C6D53DDC515C7B374B17A3B10E2097C5677EB6FF12E7A79B1F9CA86979650AFFDA2604694DA31A02962BB70486EF7C9227860D3534BDC7F010BDD7FB48857C74D251F350A94A11ACB92734F13A5E4D77F8072E9BF216AA5A989BEF456A9CA0531250325069497120999AD707C5C9BB510CB94BD10D1520473D6D62C295949578895CCA4EF507652144A86EDECD79C691BC79A711BCD92B9709348C956F80A6528444064D55E6003F3693FE93269BF5A72180E312B190C5F20F9C3479CF8F6968D2E8BF6AB219B36022E2B33ECA148868C299D40BA56A0642D7D877295A2583BC11684FD5607F4AD55A4724A5611AFC480B2522259B31537A8815CC50870A6621C449E9A9CF4F2AD52DBF31F8AD4361892DA7E4148D50C8FE3279D74D430C96F03A979701FC15CB8EFA87CB47998E423656B4603FEA33E0F94FD17D7D1418765FCAC735CC61888DC841537304321862E4F2192D585E55696013796FB0ABBB25C049CE11CDE6ED09ACE3186C1788E916CD9CAF342355B390698AD1C0997AD3E3B63368A786EDA254D6C0046F015179B9FEBD8C8C3A5BD08617253E7AA9DB908E984D956930A9E4C5D8A55425417A0C1066A6A23CB7629ACA8186E92DA6A059A84D2ABA72CFAF2DCCF40458DF13D8B6F59DCE5525BE796011421131E639461244916AA274E769B4AC153D94595E2C6F20B682A005DB0A008CDCCBBD183653A0DCA011C7B4196C957A7ABD5486D0B680F4F852B540E9C3937D5324E88F532DAE54FAC1C5FC5C0FC9A7605E9D2212BC9BB096A25A1D1DF2CCBAC34D09B088A28581D7037F5663B9D47ADF36150D803B52A4CBB610A6C994A86FB482A4F65950454E2454C19DC7EE90C7B58834EE4512469CDCEC478A24AA33107229D0A24F5A06F758FC08930D1E519946565D7F3B4551E9E998312101C71802EA8CC7242058115FAA67286A577253DBFEC3E240697D4DD54A22346D3E802C5A3E6890B07B53954DECC0606549F401F265447DADA68AAA2D9B780D2F17B167C5A7033C2590D660A2CBD3608D4592195A2B39F88FD126715C1BC4F7AD52078A2C40324D0C64D532BE37E8CAB5A3D14D174FE918447AF013162481B316D459B728F0C3F9AF51C1D0790E4646D25D74AD9FEA2ABC2B54A764E1B5D55896C38429534BB794DED2C5B74B3A886237201AAAFA37991AA38EEE275F55277E99414CA7C1FDCDB73AB9086AE4453410CB949800AAB9BAB435AC396295D012041075075309EBE0AFCAE6A537068D75449A1C056BB1BEA51518B4B6FA7A0F0B4C75357D4408A6087F454AD3B27A40DD7F9ED0A98AAD567EDD3E60BEC10E80957DE4524283BF82D1EB47BF3406A20653025B4264BBAB5AD5500183B40F18154AA05D01FC9F0AABCCDDC212E35FB1ABC192A3C941D744CB8AF212BC622288E49C00A81B75035D5B3DF580D5059F90CCD90527B36C6ADE2B8AB971A4D38DCDB944E4B28E768BA1313DA03328AA280E33F83AE4C677AFCD585800AEA7A6200B4CCAB04ED253BCC118329D530E7D102FCF530402B8E77CBC49519F88856BB36633E7705C981D2875393FE4E945E3BC87B54532A45BC378597655014BB11CAC40CB77E866F5797EDD9B62EA0FE59E545B48DD9A1BDB46C42AF2E3F1FEAD4BBB8FDF5262E93ED28E2AA9699C5CD02E328B48FC360DF5F77924AD447E93F0FCE7D156DA22A7A5554C9436D41EACFEBB8769CB3EDC5EA5FA3F4504779BBFB1A6F6EB24F876A7FA8EA2AC7BBAFA9A00C7669CA94FFD5A552E6AB4F7BF6AB0C5185BA98495D85F853F6FA90A49BA1DCEFA2B49486169D08B6ABF187B80E6FDBB22A58933F0E923EE6195250A7BEE112D99778B74F6B61E5A7EC2EFA1EBB94AD366BEFE36DB47EACC3BF27CDE12B9D107B43886ABF7A9344DB22DA959D8C317DFDB3C6F066F7E31FFE07F860EB0FAC620200, N'6.1.3-40302')
  /****** Object:  Table [dbo].[ProductCategory]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[ProductCategory](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](50) NOT NULL,
  	[ParentId] [int] NULL,
   CONSTRAINT [PK_dbo.ProductCategory] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[ProductCategory] ON
  INSERT [dbo].[ProductCategory] ([Id], [Name], [ParentId]) VALUES (1, N'Home Care', NULL)
  INSERT [dbo].[ProductCategory] ([Id], [Name], [ParentId]) VALUES (2, N'Art', NULL)
  INSERT [dbo].[ProductCategory] ([Id], [Name], [ParentId]) VALUES (3, N'Clothing', NULL)
  INSERT [dbo].[ProductCategory] ([Id], [Name], [ParentId]) VALUES (4, N'Beauty', NULL)
  INSERT [dbo].[ProductCategory] ([Id], [Name], [ParentId]) VALUES (5, N'Nutritionals', NULL)
  SET IDENTITY_INSERT [dbo].[ProductCategory] OFF
  /****** Object:  Table [dbo].[User]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[User](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Username] [nvarchar](100) NOT NULL,
  	[Password] [nvarchar](100) NOT NULL,
  	[ParentId] [int] NULL,
  	[LegId] [int] NULL,
  	[MemberShipLevelId] [int] NOT NULL,
  	[RegisterPin] [nvarchar](35) NULL,
  	[ProductId] [int] NULL,
   CONSTRAINT [PK_dbo.User] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[User] ON
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (1, N'admin', N'admin', NULL, 1, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (2, N'User 2', N'user', 1, 1, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (3, N'User 3', N'user', 1, 2, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (4, N'User 4', N'user', 3, 1, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (5, N'User 5', N'user', 3, 2, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (6, N'New user', N'user', 5, 1, 2, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (7, N'testing user', N'user', 4, 1, 1, NULL, NULL)
  INSERT [dbo].[User] ([Id], [Username], [Password], [ParentId], [LegId], [MemberShipLevelId], [RegisterPin], [ProductId]) VALUES (8, N'testttt', N'test', 4, 1, 2, NULL, 2)
  SET IDENTITY_INSERT [dbo].[User] OFF
  /****** Object:  Table [dbo].[Product]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Product](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](100) NOT NULL,
  	[PurchaseCost] [float] NOT NULL,
  	[SalePrice] [float] NULL,
  	[IsActive] [bit] NOT NULL,
  	[ProductImage] [nvarchar](200) NULL,
  	[BareCode] [nvarchar](50) NULL,
  	[Description] [nvarchar](max) NULL,
  	[Manufacturer] [nvarchar](200) NULL,
  	[ProductCategoryId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.Product] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Product] ON
  INSERT [dbo].[Product] ([Id], [Name], [PurchaseCost], [SalePrice], [IsActive], [ProductImage], [BareCode], [Description], [Manufacturer], [ProductCategoryId]) VALUES (1, N'Juice Machine', 800, 900, 1, NULL, NULL, N'Juice Machine<br>', N'j', 1)
  SET IDENTITY_INSERT [dbo].[Product] OFF
  /****** Object:  Table [dbo].[State]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[State](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](200) NOT NULL,
  	[Code] [nvarchar](5) NULL,
  	[IsActive] [bit] NULL,
  	[CountryId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.State] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[State] ON
  INSERT [dbo].[State] ([Id], [Name], [Code], [IsActive], [CountryId]) VALUES (2, N'Punjab', N'pun', 1, 4)
  SET IDENTITY_INSERT [dbo].[State] OFF
  /****** Object:  Table [dbo].[Reward]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Reward](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](200) NOT NULL,
  	[Detail] [nvarchar](1000) NULL,
  	[RewardTypeId] [int] NOT NULL,
  	[IsActive] [bit] NULL,
   CONSTRAINT [PK_dbo.Reward] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Reward] ON
  INSERT [dbo].[Reward] ([Id], [Title], [Detail], [RewardTypeId], [IsActive]) VALUES (1, N'Car', N'Car', 1, 1)
  INSERT [dbo].[Reward] ([Id], [Title], [Detail], [RewardTypeId], [IsActive]) VALUES (2, N'Bike', N'Bike', 1, 1)
  SET IDENTITY_INSERT [dbo].[Reward] OFF
  /****** Object:  Table [dbo].[RewardUser]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[RewardUser](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[UserId] [int] NOT NULL,
  	[RewardId] [int] NOT NULL,
  	[Qty] [int] NULL,
   CONSTRAINT [PK_dbo.RewardUser] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[RewardUser] ON
  INSERT [dbo].[RewardUser] ([Id], [UserId], [RewardId], [Qty]) VALUES (1, 1, 1, 1)
  INSERT [dbo].[RewardUser] ([Id], [UserId], [RewardId], [Qty]) VALUES (2, 1, 2, 1)
  SET IDENTITY_INSERT [dbo].[RewardUser] OFF
  /****** Object:  Table [dbo].[MenuPermission]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[MenuPermission](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[MenuId] [int] NULL,
  	[RoleId] [int] NOT NULL,
  	[UserId] [int] NULL,
  	[SortOrder] [int] NULL,
  	[IsNavBar] [bit] NOT NULL,
  	[IsCreate] [bit] NOT NULL,
  	[IsRead] [bit] NOT NULL,
  	[IsUpdate] [bit] NOT NULL,
  	[IsDelete] [bit] NOT NULL,
   CONSTRAINT [PK_dbo.MenuPermission] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[MenuPermission] ON
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (34, 1, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (35, 4, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (36, 7, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (37, 10, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (38, 13, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (39, 16, 1, NULL, 1, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (40, 19, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (41, 22, 1, NULL, 2, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (42, 25, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (43, 28, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (44, 31, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (45, 34, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (46, 37, 1, NULL, 3, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (47, 40, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (48, 43, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (49, 46, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (50, 49, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (51, 52, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (52, 55, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (53, 58, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (54, 61, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (55, 64, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (56, 67, 1, NULL, 4, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (57, 70, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (58, 73, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (59, 76, 1, NULL, 5, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (60, 79, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (61, 82, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (62, 85, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (63, 88, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (64, 91, 1, NULL, 6, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (65, 94, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (66, 97, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (67, 98, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (68, 100, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (69, 101, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (70, 102, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (71, 103, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (72, 105, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (73, 107, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (74, 108, 1, NULL, NULL, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (75, 109, 1, NULL, 7, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (76, 110, 1, NULL, 8, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (77, 111, 1, NULL, 0, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (78, 100, 2, NULL, 1, 1, 1, 1, 1, 1)
  INSERT [dbo].[MenuPermission] ([Id], [MenuId], [RoleId], [UserId], [SortOrder], [IsNavBar], [IsCreate], [IsRead], [IsUpdate], [IsDelete]) VALUES (79, 109, 2, NULL, 1, 1, 1, 1, 1, 1)
  SET IDENTITY_INSERT [dbo].[MenuPermission] OFF
  /****** Object:  Table [dbo].[Invoice]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Invoice](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[BillDate] [datetime] NOT NULL,
  	[DueDate] [datetime] NULL,
  	[Status] [int] NOT NULL,
  	[LastEmailed] [datetime] NULL,
  	[OtherInvoiceCode] [nvarchar](50) NULL,
  	[ClientId] [int] NOT NULL,
  	[CreatedBy] [int] NOT NULL,
   CONSTRAINT [PK_dbo.Invoice] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[DonationRequest]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[DonationRequest](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[UserId] [int] NOT NULL,
  	[Amount] [float] NOT NULL,
  	[DateAdded] [datetime] NULL,
  	[RequiredTill] [datetime] NULL,
  	[IsActive] [bit] NULL,
  	[RequestNote] [nvarchar](1000) NULL,
   CONSTRAINT [PK_dbo.DonationRequest] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[City]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[City](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](200) NULL,
  	[Latitude] [nvarchar](15) NULL,
  	[Longitude] [nvarchar](15) NULL,
  	[IsActive] [bit] NULL,
  	[StateId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.City] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[City] ON
  INSERT [dbo].[City] ([Id], [Name], [Latitude], [Longitude], [IsActive], [StateId]) VALUES (2, N'Jalandhar', N'Jalandhar', N'Jalandhar', 1, 2)
  SET IDENTITY_INSERT [dbo].[City] OFF
  /****** Object:  Table [dbo].[ePinRequest]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[ePinRequest](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](200) NOT NULL,
  	[Qty] [int] NOT NULL,
  	[FromUserId] [int] NOT NULL,
  	[DateAdded] [datetime] NULL,
  	[IsApproved] [bit] NULL,
  	[ApprovedBy] [int] NULL,
   CONSTRAINT [PK_dbo.ePinRequest] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[ePinRequest] ON
  INSERT [dbo].[ePinRequest] ([Id], [Title], [Qty], [FromUserId], [DateAdded], [IsApproved], [ApprovedBy]) VALUES (1, N'need pins', 1, 1, CAST(0x0000A73500C30438 AS DateTime), 1, 1)
  INSERT [dbo].[ePinRequest] ([Id], [Title], [Qty], [FromUserId], [DateAdded], [IsApproved], [ApprovedBy]) VALUES (2, N'need pins', 3, 1, CAST(0x0000A73500C32C10 AS DateTime), 1, 1)
  INSERT [dbo].[ePinRequest] ([Id], [Title], [Qty], [FromUserId], [DateAdded], [IsApproved], [ApprovedBy]) VALUES (3, N'g', 2, 1, CAST(0x0000A735011E5E28 AS DateTime), 1, 1)
  INSERT [dbo].[ePinRequest] ([Id], [Title], [Qty], [FromUserId], [DateAdded], [IsApproved], [ApprovedBy]) VALUES (4, N'fff', 2, 1, CAST(0x0000A735011EF1D0 AS DateTime), 1, 1)
  INSERT [dbo].[ePinRequest] ([Id], [Title], [Qty], [FromUserId], [DateAdded], [IsApproved], [ApprovedBy]) VALUES (5, N'i need 2 pins', 2, 2, CAST(0x0000A735016AB908 AS DateTime), 1, 1)
  SET IDENTITY_INSERT [dbo].[ePinRequest] OFF
  /****** Object:  Table [dbo].[LedgerAccount]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[LedgerAccount](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](50) NOT NULL,
  	[LedgerAccountTypeId] [int] NOT NULL,
  	[Currency] [nvarchar](10) NOT NULL,
  	[AccountCode] [nvarchar](50) NULL,
  	[AccountColor] [nvarchar](10) NULL,
  	[ParentId] [int] NULL,
  	[UserId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.LedgerAccount] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[LedgerAccount] ON
  INSERT [dbo].[LedgerAccount] ([Id], [Title], [LedgerAccountTypeId], [Currency], [AccountCode], [AccountColor], [ParentId], [UserId]) VALUES (1, N'My Wallet', 1, N'$', NULL, NULL, NULL, 1)
  SET IDENTITY_INSERT [dbo].[LedgerAccount] OFF
  /****** Object:  Table [dbo].[RoleUser]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[RoleUser](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[RoleId] [int] NOT NULL,
  	[UserId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.RoleUser] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[RoleUser] ON
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (1, 1, 1)
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (2, 2, 2)
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (3, 2, 3)
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (4, 2, 4)
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (5, 2, 5)
  INSERT [dbo].[RoleUser] ([Id], [RoleId], [UserId]) VALUES (6, 2, 6)
  SET IDENTITY_INSERT [dbo].[RoleUser] OFF
  /****** Object:  Table [dbo].[UserContactInfo]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[UserContactInfo](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[ContactTypeId] [int] NOT NULL,
  	[ContactDetail] [nvarchar](200) NOT NULL,
  	[UserId] [int] NOT NULL,
  	[IsActive] [bit] NOT NULL,
   CONSTRAINT [PK_dbo.UserContactInfo] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[UserContactInfo] ON
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (1, 1, N'testing@gmail.com', 2, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (2, 2, N'333333333', 2, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (3, 3, N'Jalandhar', 2, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (4, 1, N'dummy@gmail.com', 1, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (5, 2, N'3333333', 1, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (6, 3, N'Jalandhar', 1, 1)
  INSERT [dbo].[UserContactInfo] ([Id], [ContactTypeId], [ContactDetail], [UserId], [IsActive]) VALUES (7, 2, N'3333333333', 1, 1)
  SET IDENTITY_INSERT [dbo].[UserContactInfo] OFF
  /****** Object:  Table [dbo].[UserBankInfo]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[UserBankInfo](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[AccountHolderName] [nvarchar](100) NULL,
  	[UserId] [int] NOT NULL,
  	[BankName] [nvarchar](100) NULL,
  	[AccountNumber] [nvarchar](100) NULL,
  	[Branch] [nvarchar](200) NULL,
  	[IFCI_Code] [nvarchar](100) NULL,
  	[IsActive] [bit] NOT NULL,
   CONSTRAINT [PK_dbo.UserBankInfo] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[UserBankInfo] ON
  INSERT [dbo].[UserBankInfo] ([Id], [AccountHolderName], [UserId], [BankName], [AccountNumber], [Branch], [IFCI_Code], [IsActive]) VALUES (1, N'SOHAIL', 1, N'OBC', N'234234134', N'JALANDHAR', N'51448', 1)
  INSERT [dbo].[UserBankInfo] ([Id], [AccountHolderName], [UserId], [BankName], [AccountNumber], [Branch], [IFCI_Code], [IsActive]) VALUES (2, N'sonu', 1, N'sonu', N'sonu', N'icici', N'sonu', 1)
  SET IDENTITY_INSERT [dbo].[UserBankInfo] OFF
  /****** Object:  Table [dbo].[UserPersonalInfo]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[UserPersonalInfo](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[FirstName] [nvarchar](200) NOT NULL,
  	[LastName] [nvarchar](200) NULL,
  	[GenderId] [int] NOT NULL,
  	[About] [nvarchar](max) NULL,
  	[ProfileImage] [nvarchar](200) NULL,
  	[DateJoin] [datetime] NOT NULL,
  	[UserId] [int] NOT NULL,
  	[MiddleName] [nvarchar](200) NULL,
  	[Email] [nvarchar](33) NULL,
  	[FatherAndSpouseName] [nvarchar](100) NULL,
  	[DOB] [datetime] NULL,
  	[MotherName] [nvarchar](100) NULL,
  	[NomineName] [nvarchar](100) NULL,
  	[CityId] [int] NOT NULL,
  	[ZipCode] [nvarchar](10) NULL,
  	[PanNumber] [nvarchar](50) NULL,
  	[EducationDetail] [nvarchar](500) NULL,
  	[LastEmployeeFirm] [nvarchar](100) NULL,
  	[LastEmployeeYear] [nvarchar](10) NULL,
  	[LastEmployeeAnualIncome] [nvarchar](100) NULL,
  	[IsActive] [bit] NULL,
   CONSTRAINT [PK_dbo.UserPersonalInfo] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[UserPersonalInfo] ON
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (2, N'Admin', N'SANDHU', 1, N'ABC', N'logo110032017012145.png', CAST(0x0000A73100DB9CB4 AS DateTime), 1, N'SINGH', N'kuldeepsandhu3500@gmail.com', N'SODHISIUNF', CAST(0x00008FA700000000 AS DateTime), N'IHJDH', N'JDHGOI', 2, N'894', N'789798', N'ODJFOI', N'KJNOK', N'DKMF', N'2689', 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (3, N'User 2', N'SANDHU', 1, N'ABC', N'logo110032017012224.png', CAST(0x0000A73200DB9CB4 AS DateTime), 2, N'SINGH', N'kuldeepsandhu3500@gmail.com', N'SODHISIUNF', CAST(0x00008F6400000000 AS DateTime), N'IHJDH', N'JDHGOI', 2, N'894', N'789798', N'ODJFOI', N'KJNOK', N'DKMF', N'2689', 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (4, N'User 3', N'SANDHU', 1, N'ABC', N'logo110032017012244.png', CAST(0x0000A73300DB9CB4 AS DateTime), 3, N'SINGH', N'kuldeepsandhu3500@gmail.com', N'SODHISIUNF', CAST(0x00008F4600000000 AS DateTime), N'IHJDH', N'JDHGOI', 2, N'894', N'789798', N'ODJFOI', N'KJNOK', N'DKMF', N'2689', 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (5, N'User 4', N'SANDHU', 1, N'ABC', N'logo110032017012303.png', CAST(0x0000A73300DB9CB4 AS DateTime), 4, N'SINGH', N'kuldeepsandhu3500@gmail.com', N'SODHISIUNF', CAST(0x00008F2700000000 AS DateTime), N'IHJDH', N'JDHGOI', 2, N'894', N'789798', N'ODJFOI', N'KJNOK', N'DKMF', N'2689', 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (6, N'User 5', N'SANDHU', 1, N'ABC', N'logo110032017012303.png', CAST(0x0000A73500DB9CB4 AS DateTime), 5, N'SINGH', N'kuldeepsandhu3500@gmail.com', N'SODHISIUNF', CAST(0x00008F2700000000 AS DateTime), N'IHJDH', N'JDHGOI', 2, N'894', N'789798', N'ODJFOI', N'KJNOK', N'DKMF', N'2689', 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (7, N'testing user', N'user', 1, N'ass', NULL, CAST(0x0000A735016C419C AS DateTime), 7, N's', N'singh.mvc@gmail.com', NULL, CAST(0x0000A73700000000 AS DateTime), N's', N's', 2, N'933929', NULL, N'f', NULL, N'f', NULL, 1)
  INSERT [dbo].[UserPersonalInfo] ([Id], [FirstName], [LastName], [GenderId], [About], [ProfileImage], [DateJoin], [UserId], [MiddleName], [Email], [FatherAndSpouseName], [DOB], [MotherName], [NomineName], [CityId], [ZipCode], [PanNumber], [EducationDetail], [LastEmployeeFirm], [LastEmployeeYear], [LastEmployeeAnualIncome], [IsActive]) VALUES (8, N'test', N'test', 1, N'test', NULL, CAST(0x0000A87F00AD6A24 AS DateTime), 8, N'ddfd', N'sonustar.in@gmail.com', N'ss', CAST(0x0000A88500000000 AS DateTime), N's', N's', 2, N'33333', N'3333', N'ss', N'sfds', N'sfds', N'sdfsf', 1)
  SET IDENTITY_INSERT [dbo].[UserPersonalInfo] OFF
  /****** Object:  Table [dbo].[Transaction]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Transaction](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](50) NOT NULL,
  	[DateAdded] [datetime] NOT NULL,
  	[AddedBy] [int] NOT NULL,
  	[CompanyOfficeId] [int] NOT NULL,
  	[DebitLedgerAccountId] [int] NULL,
  	[DebitAmount] [float] NULL,
  	[CreditLedgerAccountId] [int] NULL,
  	[CreditAmount] [float] NULL,
  	[TransactionDate] [datetime] NOT NULL,
   CONSTRAINT [PK_dbo.Transaction] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[Transaction] ON
  INSERT [dbo].[Transaction] ([Id], [Title], [DateAdded], [AddedBy], [CompanyOfficeId], [DebitLedgerAccountId], [DebitAmount], [CreditLedgerAccountId], [CreditAmount], [TransactionDate]) VALUES (1, N'Add money from paypal to my wallet', CAST(0x0000A7350108BD0C AS DateTime), 1, 1, NULL, NULL, 1, 1000, CAST(0x0000A73500000000 AS DateTime))
  INSERT [dbo].[Transaction] ([Id], [Title], [DateAdded], [AddedBy], [CompanyOfficeId], [DebitLedgerAccountId], [DebitAmount], [CreditLedgerAccountId], [CreditAmount], [TransactionDate]) VALUES (2, N'send 100 rs to User 2', CAST(0x0000A735016B69FC AS DateTime), 1, 1, 1, 100, NULL, NULL, CAST(0x0000A73500000000 AS DateTime))
  SET IDENTITY_INSERT [dbo].[Transaction] OFF
  /****** Object:  Table [dbo].[InvoiceTransaction]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[InvoiceTransaction](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[TransactionId] [int] NOT NULL,
  	[InvoiceId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.InvoiceTransaction] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[InvoiceItem]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[InvoiceItem](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[InvoiceId] [int] NOT NULL,
  	[Description] [nvarchar](200) NULL,
  	[Title] [nvarchar](50) NOT NULL,
  	[Quantity] [decimal](18, 2) NOT NULL,
  	[UnitPrice] [decimal](18, 2) NOT NULL,
  	[UnitName] [int] NOT NULL,
  	[Total] [decimal](18, 2) NOT NULL,
   CONSTRAINT [PK_dbo.InvoiceItem] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[ePinCode]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[ePinCode](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[ePinRequestId] [int] NOT NULL,
  	[PCode] [nvarchar](35) NULL,
  	[DateAdded] [datetime] NULL,
   CONSTRAINT [PK_dbo.ePinCode] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  SET IDENTITY_INSERT [dbo].[ePinCode] ON
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (1, 1, N'c85c2486-72cd-4dfa-b732-da8c2dda', CAST(0x0000A735011D4770 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (2, 2, N'26281021-7c3a-4f92-9a48-6e48880b', CAST(0x0000A735011D8213 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (3, 2, N'2cdc6621-09c9-4358-839d-eb5965d9', CAST(0x0000A735011D8771 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (4, 2, N'5b8d90a9-dc18-4eae-b82c-1e61c118', CAST(0x0000A735011D8C9A AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (5, 1, N'6ebaa658-c147-4b62-9681-a7822763', CAST(0x0000A735011E7E2F AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (6, 2, N'36b74c57-292b-4edd-af51-6ae80a6b', CAST(0x0000A735011E7E38 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (7, 2, N'37fb3b39-56fa-4bf1-a446-4f1f76b3', CAST(0x0000A735011E7E39 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (8, 2, N'0bb6fc9d-a9b3-46d6-91f2-e59b6ac6', CAST(0x0000A735011E7E39 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (9, 3, N'9d0ec028-5b2d-4f4b-8544-3ca39b3a', CAST(0x0000A735011E7E3A AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (10, 3, N'7fd0c68a-dcff-46ab-9f6f-043e1910', CAST(0x0000A735011E7E3B AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (11, 1, N'8c6a5bfb-5ab2-4cb1-bfc9-39678f00', CAST(0x0000A735016AFDA4 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (12, 2, N'8a8f7024-6595-4941-9622-85146e56', CAST(0x0000A735016AFDA7 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (13, 2, N'8849f945-3cff-4331-82c7-0841871f', CAST(0x0000A735016AFDA7 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (14, 2, N'b29887d8-a101-4d15-bc0f-11ef8db0', CAST(0x0000A735016AFDA7 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (15, 3, N'18864489-af34-4493-98da-49e1de98', CAST(0x0000A735016AFDA9 AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (16, 3, N'450c2869-a5d7-4559-9ef6-0b5c8f8b', CAST(0x0000A735016AFDAC AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (17, 4, N'4ea31304-76f5-4992-85ee-3b5140ad', CAST(0x0000A735016AFDAD AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (18, 4, N'7b8bc471-88f2-4288-a8c9-7a9c266e', CAST(0x0000A735016AFDAD AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (19, 5, N'9e3ac24e-e61d-40f6-af16-b179b4fa', CAST(0x0000A735016AFDAE AS DateTime))
  INSERT [dbo].[ePinCode] ([Id], [ePinRequestId], [PCode], [DateAdded]) VALUES (20, 5, N'e9aca35c-7b1c-4e5e-899b-65109fc5', CAST(0x0000A735016AFDAF AS DateTime))
  SET IDENTITY_INSERT [dbo].[ePinCode] OFF
  /****** Object:  Table [dbo].[DonationTransaction]    Script Date: 03/01/2019 18:31:38 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[DonationTransaction](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[DonationRequestId] [int] NOT NULL,
  	[TransactionId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.DonationTransaction] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  /****** Object:  ForeignKey [FK_dbo.City_dbo.State_StateId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[City]  WITH CHECK ADD  CONSTRAINT [FK_dbo.City_dbo.State_StateId] FOREIGN KEY([StateId])
  REFERENCES [dbo].[State] ([Id])
  GO
  ALTER TABLE [dbo].[City] CHECK CONSTRAINT [FK_dbo.City_dbo.State_StateId]
  GO
  /****** Object:  ForeignKey [FK_dbo.DonationRequest_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[DonationRequest]  WITH CHECK ADD  CONSTRAINT [FK_dbo.DonationRequest_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[DonationRequest] CHECK CONSTRAINT [FK_dbo.DonationRequest_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.DonationTransaction_dbo.DonationRequest_DonationRequestId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[DonationTransaction]  WITH CHECK ADD  CONSTRAINT [FK_dbo.DonationTransaction_dbo.DonationRequest_DonationRequestId] FOREIGN KEY([DonationRequestId])
  REFERENCES [dbo].[DonationRequest] ([Id])
  GO
  ALTER TABLE [dbo].[DonationTransaction] CHECK CONSTRAINT [FK_dbo.DonationTransaction_dbo.DonationRequest_DonationRequestId]
  GO
  /****** Object:  ForeignKey [FK_dbo.DonationTransaction_dbo.Transaction_TransactionId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[DonationTransaction]  WITH CHECK ADD  CONSTRAINT [FK_dbo.DonationTransaction_dbo.Transaction_TransactionId] FOREIGN KEY([TransactionId])
  REFERENCES [dbo].[Transaction] ([Id])
  GO
  ALTER TABLE [dbo].[DonationTransaction] CHECK CONSTRAINT [FK_dbo.DonationTransaction_dbo.Transaction_TransactionId]
  GO
  /****** Object:  ForeignKey [FK_dbo.ePinCode_dbo.ePinRequest_ePinRequestId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[ePinCode]  WITH CHECK ADD  CONSTRAINT [FK_dbo.ePinCode_dbo.ePinRequest_ePinRequestId] FOREIGN KEY([ePinRequestId])
  REFERENCES [dbo].[ePinRequest] ([Id])
  GO
  ALTER TABLE [dbo].[ePinCode] CHECK CONSTRAINT [FK_dbo.ePinCode_dbo.ePinRequest_ePinRequestId]
  GO
  /****** Object:  ForeignKey [FK_dbo.ePinRequest_dbo.User_FromUserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[ePinRequest]  WITH CHECK ADD  CONSTRAINT [FK_dbo.ePinRequest_dbo.User_FromUserId] FOREIGN KEY([FromUserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[ePinRequest] CHECK CONSTRAINT [FK_dbo.ePinRequest_dbo.User_FromUserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Invoice_dbo.PaymentStatus_Status]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Invoice]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Invoice_dbo.PaymentStatus_Status] FOREIGN KEY([Status])
  REFERENCES [dbo].[PaymentStatus] ([Id])
  GO
  ALTER TABLE [dbo].[Invoice] CHECK CONSTRAINT [FK_dbo.Invoice_dbo.PaymentStatus_Status]
  GO
  /****** Object:  ForeignKey [FK_dbo.Invoice_dbo.User_ClientId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Invoice]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Invoice_dbo.User_ClientId] FOREIGN KEY([ClientId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[Invoice] CHECK CONSTRAINT [FK_dbo.Invoice_dbo.User_ClientId]
  GO
  /****** Object:  ForeignKey [FK_dbo.InvoiceItem_dbo.Invoice_InvoiceId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[InvoiceItem]  WITH CHECK ADD  CONSTRAINT [FK_dbo.InvoiceItem_dbo.Invoice_InvoiceId] FOREIGN KEY([InvoiceId])
  REFERENCES [dbo].[Invoice] ([Id])
  GO
  ALTER TABLE [dbo].[InvoiceItem] CHECK CONSTRAINT [FK_dbo.InvoiceItem_dbo.Invoice_InvoiceId]
  GO
  /****** Object:  ForeignKey [FK_dbo.InvoiceTransaction_dbo.Invoice_InvoiceId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[InvoiceTransaction]  WITH CHECK ADD  CONSTRAINT [FK_dbo.InvoiceTransaction_dbo.Invoice_InvoiceId] FOREIGN KEY([InvoiceId])
  REFERENCES [dbo].[Invoice] ([Id])
  GO
  ALTER TABLE [dbo].[InvoiceTransaction] CHECK CONSTRAINT [FK_dbo.InvoiceTransaction_dbo.Invoice_InvoiceId]
  GO
  /****** Object:  ForeignKey [FK_dbo.LedgerAccount_dbo.LedgerAccount_ParentId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[LedgerAccount]  WITH CHECK ADD  CONSTRAINT [FK_dbo.LedgerAccount_dbo.LedgerAccount_ParentId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[LedgerAccount] ([Id])
  GO
  ALTER TABLE [dbo].[LedgerAccount] CHECK CONSTRAINT [FK_dbo.LedgerAccount_dbo.LedgerAccount_ParentId]
  GO
  /****** Object:  ForeignKey [FK_dbo.LedgerAccount_dbo.LedgerAccountType_LedgerAccountTypeId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[LedgerAccount]  WITH CHECK ADD  CONSTRAINT [FK_dbo.LedgerAccount_dbo.LedgerAccountType_LedgerAccountTypeId] FOREIGN KEY([LedgerAccountTypeId])
  REFERENCES [dbo].[LedgerAccountType] ([Id])
  GO
  ALTER TABLE [dbo].[LedgerAccount] CHECK CONSTRAINT [FK_dbo.LedgerAccount_dbo.LedgerAccountType_LedgerAccountTypeId]
  GO
  /****** Object:  ForeignKey [FK_dbo.LedgerAccount_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[LedgerAccount]  WITH CHECK ADD  CONSTRAINT [FK_dbo.LedgerAccount_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[LedgerAccount] CHECK CONSTRAINT [FK_dbo.LedgerAccount_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.LedgerAccountType_dbo.LedgerAccountType_ParentId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[LedgerAccountType]  WITH CHECK ADD  CONSTRAINT [FK_dbo.LedgerAccountType_dbo.LedgerAccountType_ParentId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[LedgerAccountType] ([Id])
  GO
  ALTER TABLE [dbo].[LedgerAccountType] CHECK CONSTRAINT [FK_dbo.LedgerAccountType_dbo.LedgerAccountType_ParentId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Menu_dbo.Menu_ParentId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Menu]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Menu_dbo.Menu_ParentId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[Menu] ([Id])
  GO
  ALTER TABLE [dbo].[Menu] CHECK CONSTRAINT [FK_dbo.Menu_dbo.Menu_ParentId]
  GO
  /****** Object:  ForeignKey [FK_dbo.MenuPermission_dbo.Menu_MenuId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[MenuPermission]  WITH CHECK ADD  CONSTRAINT [FK_dbo.MenuPermission_dbo.Menu_MenuId] FOREIGN KEY([MenuId])
  REFERENCES [dbo].[Menu] ([Id])
  GO
  ALTER TABLE [dbo].[MenuPermission] CHECK CONSTRAINT [FK_dbo.MenuPermission_dbo.Menu_MenuId]
  GO
  /****** Object:  ForeignKey [FK_dbo.MenuPermission_dbo.Role_RoleId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[MenuPermission]  WITH CHECK ADD  CONSTRAINT [FK_dbo.MenuPermission_dbo.Role_RoleId] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[Role] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[MenuPermission] CHECK CONSTRAINT [FK_dbo.MenuPermission_dbo.Role_RoleId]
  GO
  /****** Object:  ForeignKey [FK_dbo.MenuPermission_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[MenuPermission]  WITH CHECK ADD  CONSTRAINT [FK_dbo.MenuPermission_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[MenuPermission] CHECK CONSTRAINT [FK_dbo.MenuPermission_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Product_dbo.ProductCategory_ProductCategoryId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Product_dbo.ProductCategory_ProductCategoryId] FOREIGN KEY([ProductCategoryId])
  REFERENCES [dbo].[ProductCategory] ([Id])
  GO
  ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_dbo.Product_dbo.ProductCategory_ProductCategoryId]
  GO
  /****** Object:  ForeignKey [FK_dbo.ProductCategory_dbo.ProductCategory_ParentId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[ProductCategory]  WITH CHECK ADD  CONSTRAINT [FK_dbo.ProductCategory_dbo.ProductCategory_ParentId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[ProductCategory] ([Id])
  GO
  ALTER TABLE [dbo].[ProductCategory] CHECK CONSTRAINT [FK_dbo.ProductCategory_dbo.ProductCategory_ParentId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Reward_dbo.RewardType_RewardTypeId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Reward]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Reward_dbo.RewardType_RewardTypeId] FOREIGN KEY([RewardTypeId])
  REFERENCES [dbo].[RewardType] ([Id])
  GO
  ALTER TABLE [dbo].[Reward] CHECK CONSTRAINT [FK_dbo.Reward_dbo.RewardType_RewardTypeId]
  GO
  /****** Object:  ForeignKey [FK_dbo.RewardUser_dbo.Reward_RewardId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[RewardUser]  WITH CHECK ADD  CONSTRAINT [FK_dbo.RewardUser_dbo.Reward_RewardId] FOREIGN KEY([RewardId])
  REFERENCES [dbo].[Reward] ([Id])
  GO
  ALTER TABLE [dbo].[RewardUser] CHECK CONSTRAINT [FK_dbo.RewardUser_dbo.Reward_RewardId]
  GO
  /****** Object:  ForeignKey [FK_dbo.RewardUser_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[RewardUser]  WITH CHECK ADD  CONSTRAINT [FK_dbo.RewardUser_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[RewardUser] CHECK CONSTRAINT [FK_dbo.RewardUser_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.RoleUser_dbo.Role_RoleId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[RoleUser]  WITH CHECK ADD  CONSTRAINT [FK_dbo.RoleUser_dbo.Role_RoleId] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[Role] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[RoleUser] CHECK CONSTRAINT [FK_dbo.RoleUser_dbo.Role_RoleId]
  GO
  /****** Object:  ForeignKey [FK_dbo.RoleUser_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[RoleUser]  WITH CHECK ADD  CONSTRAINT [FK_dbo.RoleUser_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[RoleUser] CHECK CONSTRAINT [FK_dbo.RoleUser_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.State_dbo.Country_CountryId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[State]  WITH CHECK ADD  CONSTRAINT [FK_dbo.State_dbo.Country_CountryId] FOREIGN KEY([CountryId])
  REFERENCES [dbo].[Country] ([Id])
  GO
  ALTER TABLE [dbo].[State] CHECK CONSTRAINT [FK_dbo.State_dbo.Country_CountryId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Transaction_dbo.LedgerAccount_CreditLedgerAccountId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Transaction]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Transaction_dbo.LedgerAccount_CreditLedgerAccountId] FOREIGN KEY([CreditLedgerAccountId])
  REFERENCES [dbo].[LedgerAccount] ([Id])
  GO
  ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_dbo.Transaction_dbo.LedgerAccount_CreditLedgerAccountId]
  GO
  /****** Object:  ForeignKey [FK_dbo.Transaction_dbo.LedgerAccount_DebitLedgerAccountId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[Transaction]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Transaction_dbo.LedgerAccount_DebitLedgerAccountId] FOREIGN KEY([DebitLedgerAccountId])
  REFERENCES [dbo].[LedgerAccount] ([Id])
  GO
  ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_dbo.Transaction_dbo.LedgerAccount_DebitLedgerAccountId]
  GO
  /****** Object:  ForeignKey [FK_dbo.User_dbo.Leg_LegId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_dbo.User_dbo.Leg_LegId] FOREIGN KEY([LegId])
  REFERENCES [dbo].[Leg] ([Id])
  GO
  ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_dbo.User_dbo.Leg_LegId]
  GO
  /****** Object:  ForeignKey [FK_dbo.User_dbo.MemberShipLevel_MemberShipLevelId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_dbo.User_dbo.MemberShipLevel_MemberShipLevelId] FOREIGN KEY([MemberShipLevelId])
  REFERENCES [dbo].[MemberShipLevel] ([Id])
  GO
  ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_dbo.User_dbo.MemberShipLevel_MemberShipLevelId]
  GO
  /****** Object:  ForeignKey [FK_dbo.User_dbo.User_ParentId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_dbo.User_dbo.User_ParentId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_dbo.User_dbo.User_ParentId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserBankInfo_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserBankInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserBankInfo_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[UserBankInfo] CHECK CONSTRAINT [FK_dbo.UserBankInfo_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserContactInfo_dbo.ContactType_ContactTypeId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserContactInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserContactInfo_dbo.ContactType_ContactTypeId] FOREIGN KEY([ContactTypeId])
  REFERENCES [dbo].[ContactType] ([Id])
  GO
  ALTER TABLE [dbo].[UserContactInfo] CHECK CONSTRAINT [FK_dbo.UserContactInfo_dbo.ContactType_ContactTypeId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserContactInfo_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserContactInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserContactInfo_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  GO
  ALTER TABLE [dbo].[UserContactInfo] CHECK CONSTRAINT [FK_dbo.UserContactInfo_dbo.User_UserId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserPersonalInfo_dbo.City_CityId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserPersonalInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.City_CityId] FOREIGN KEY([CityId])
  REFERENCES [dbo].[City] ([Id])
  GO
  ALTER TABLE [dbo].[UserPersonalInfo] CHECK CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.City_CityId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserPersonalInfo_dbo.Gender_GenderId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserPersonalInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.Gender_GenderId] FOREIGN KEY([GenderId])
  REFERENCES [dbo].[Gender] ([Id])
  GO
  ALTER TABLE [dbo].[UserPersonalInfo] CHECK CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.Gender_GenderId]
  GO
  /****** Object:  ForeignKey [FK_dbo.UserPersonalInfo_dbo.User_UserId]    Script Date: 03/01/2019 18:31:38 ******/
  ALTER TABLE [dbo].[UserPersonalInfo]  WITH CHECK ADD  CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.User_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[User] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[UserPersonalInfo] CHECK CONSTRAINT [FK_dbo.UserPersonalInfo_dbo.User_UserId]
  GO
  