SET IDENTITY_INSERT [dbo].[Accounts] ON 
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress]) VALUES (1, 1, N'KNOKS', CAST(1000.00000000 AS Decimal(22, 8)), CAST(1000.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-08T22:06:30.090' AS DateTime), NULL, NULL, NULL, '0x12890d2cce102216644c59dae5baed380d84830c')
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress]) VALUES (2, 2, N'KNOKS', CAST(1000.00000000 AS Decimal(22, 8)), CAST(1000.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-08T22:06:30.090' AS DateTime), NULL, NULL, NULL, '0x00bd138abd70e2f00903268f3db08f2d25677c9e')
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress]) VALUES (3, 3, N'KNOKS', CAST(0.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-08T22:06:30.090' AS DateTime), NULL, NULL, NULL, '0x00bd138abd70e2f00903268f3db08f2d25677c9c')
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress]) VALUES (4, 4, N'KNOKS', CAST(0.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-08T22:06:30.090' AS DateTime), NULL, NULL, NULL, '0x00bd138abd70e2f00903268f3db08f2d25677c9a')
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress]) VALUES (5, 5, N'KNOKS', CAST(5200.00000000 AS Decimal(22, 8)), CAST(5200.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-11T22:34:23.943' AS DateTime), CAST(N'2018-02-12T14:05:22.340' AS DateTime), N'DESKTOP-MQBDV8K\YoavP', NULL, '0x12890d2cce102216644c59dae5baed380d84830c')
GO
INSERT [dbo].[Accounts] ([AccountId], [UserId], [Symbol], [CurrentBalance], [CurrentBonusBalance], [TotalPending], [CreateDate], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [WalletAddress])
VALUES (6, 6, N'KNOKS', CAST(5200.00000000 AS Decimal(22, 8)), CAST(5200.00000000 AS Decimal(22, 8)), CAST(0.00000000 AS Decimal(22, 8)), CAST(N'2018-02-11T22:34:23.943' AS DateTime), CAST(N'2018-02-12T14:05:22.340' AS DateTime), N'DESKTOP-MQBDV8K\YoavP', NULL, '0x004ec07d2329997267ec62b4166639513386f32e')
GO
SET IDENTITY_INSERT [dbo].[Accounts] OFF
GO


SET IDENTITY_INSERT [dbo].[AccountTransactions] ON 
GO
INSERT [dbo].[AccountTransactions] ([AccountTransactionId], [AccountId], [UserId], [AccountTransactionDate], [AccountTransactionTypeId], [Symbol], [Amount], [AmountUSD], [ExternalReferenceId], [Comment], [Origin], [CurrentBalance], [CurrentBonusBalance], [OperatorId], [WalletAddress], [PendingId]) VALUES (1, 6, 5, CAST(N'2018-02-12T14:05:22.3400000' AS DateTime2), 1, N'KNOKS', CAST(5200.00000000 AS Decimal(22, 8)), CAST(150.00000000 AS Decimal(22, 8)), N'BONUS_6', N'Free Tokens Bonus - 1st time after registration', N'DESKTOP-MQBDV8K\YoavP', CAST(5200.00000000 AS Decimal(22, 8)), CAST(5200.00000000 AS Decimal(22, 8)), NULL, NULL, NULL)
GO
SET IDENTITY_INSERT [dbo].[AccountTransactions] OFF
GO
SET IDENTITY_INSERT [dbo].[Error_Log] ON 
GO
INSERT [dbo].[Error_Log] ([id], [date], [ErrorNumber], [ErrorSeverity], [ErrorState], [ErrorProcedure], [ErrorLine], [ErrorMessage]) VALUES (1, CAST(N'2018-02-12T14:03:02.967' AS DateTime), 50000, 16, 1, N'TRN_FreeTokensCredit', 77, N'External Reference cannot be null')
GO
INSERT [dbo].[Error_Log] ([id], [date], [ErrorNumber], [ErrorSeverity], [ErrorState], [ErrorProcedure], [ErrorLine], [ErrorMessage]) VALUES (2, CAST(N'2018-02-12T14:07:01.767' AS DateTime), 50000, 16, 1, N'TRN_FreeTokensCredit', 115, N'External Reference already registered')
GO
SET IDENTITY_INSERT [dbo].[Error_Log] OFF
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (1, N'BitFinex', NULL, 1)
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (2, N'Bittrex', NULL, 1)
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (3, N'Binance', NULL, 1)
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (4, N'CEX', NULL, 1)
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (5, N'HUOBI', NULL, 1)
GO
INSERT [dbo].[Exchanges] ([ExchangeId], [ExchangeName], [UserId], [IsActive]) VALUES (6, N'OKEx', NULL, 1)
GO

INSERT [dbo].[KnokTypes] ([KnokTypeId], [KnokTypeSymbol], [KnokTypeDescription]) VALUES (1, N'F', N'Fundamental')
GO
INSERT [dbo].[KnokTypes] ([KnokTypeId], [KnokTypeSymbol], [KnokTypeDescription]) VALUES (2, N'TA', N'Technical Analysis')
GO
INSERT [dbo].[SignalTypes] ([SignalTypeId], [SignalTypeDescription]) VALUES (N'F', N'Fundamental')
GO
INSERT [dbo].[SignalTypes] ([SignalTypeId], [SignalTypeDescription]) VALUES (N'T', N'Technical Analysis')
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'BCH', N'Bitcoin Cash', 1, 8)
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'BTC', N'Bitcoin', 1, 8)
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'ETH', N'Ethereum', 1, 8)
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'LTC', N'Litecoin', 1, 8)
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'USD', N'US Dollar', 2, 2)
GO
INSERT [dbo].[Symbols] ([Symbol], [SymbolDescription], [SymbolTypeId], [Decimals]) VALUES (N'USDT', N'USD Tether', 1, 2)
GO
SET IDENTITY_INSERT [dbo].[Tickers] ON 
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (1, 1, N'ETHBTC', N'Ethereum', N'ETH', N'BTC', N'ETH', N'ETH/BTC')
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (2, 2, N'BTCETH', N'Bitcoin', N'BTC', N'ETH', N'BTC', N'BTC/ETH')
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (3, 3, N'BTCETH', N'Bitcoin', N'BTC', N'ETH', N'BTC', N'BTC/ETH')
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (4, 4, N'BTCUSD', N'Bitcoin', N'BTC', N'USD', N'BTC', N'BTC/USD')
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (5, 5, N'BTCETH', N'Bitcoin', N'BTC', N'ETH', N'BTC', N'BTC/ETH')
GO
INSERT [dbo].[Tickers] ([TickerId], [ExchangeId], [TickerSymbol], [TickerDescription], [Base], [NonBase], [Currency], [TickerDisplayName]) VALUES (6, 6, N'BTCETH', N'Bitcoin', N'BTC', N'ETH', N'BTC', N'BTC/ETH')
SET IDENTITY_INSERT [dbo].[Tickers] OFF
GO
SET IDENTITY_INSERT [dbo].[ApiConsumers] ON
INSERT INTO [dbo].[ApiConsumers] ([Id], [ApiIdentifier], [ApiTypeId], [IsEnabled]) VALUES (1, N'138659eb-ebbf-408a-a128-2d46ebdfbdc7', 1, 1)
SET IDENTITY_INSERT [dbo].[ApiConsumers] OFF
GO
SET IDENTITY_INSERT [BO_Operators] ON
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (0, 1, N'System', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Sys', N'tem', NULL, NULL, NULL, 1, 0, 0, 0, 1, 0)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (1, 1, N'Admin', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'General', N'Administrator', NULL, NULL, NULL, 1, 0, 0, 1, 1, 1)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (2, 1, N'AccountManager', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Account', N'Manager', NULL, NULL, NULL, 1, 0, 0, 2, 1, 2)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (3, 1, N'LoanProcessing', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Loan Processing', N'Manager', NULL, NULL, NULL, 1, 0, 0, 3, 1, 3)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (4, 1, N'Appraisal&Compliance', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Appraisal & Compliance', N'Manager', NULL, NULL, NULL, 1, 0, 0, 4, 1, 4)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (5, 1, N'Underwriting', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Underwriting', N'Manager', NULL, NULL, NULL, 1, 0, 0, 5, 1, 5)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (6, 1, N'Funds', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Funds', N'Manager', NULL, NULL, NULL, 1, 0, 0, 6, 1, 6)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (11, 1, N'John', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'John', N'Luis', NULL, NULL, NULL, 1, 0, 0, 4, 0, 4)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (12, 1, N'Will', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Will', N'Smith', NULL, NULL, NULL, 1, 0, 0, 5, 0, 5)
INSERT [dbo].[BO_Operators] ([OperatorId], [ApiConsumerId], [OperatorName], [OperatorPassword], [OperatorCreationDate], [FirstName], [LastName], [Phone], [Email], [CountryId], [IsActive], [IsReadOnly], [IsTest], [OperatorTeamId], [IsTeamManager], [PermissionRoleId]) VALUES (13, 1, N'Vlad', N'V1|lDibyHN2SHJBzoFYyWRr1d5fzvnA0MCWnYoVakxWQQI=|ispgQFkjdyD//lgKGE1Gew==', CAST(N'2017-02-02 00:00:00.0000000' AS DateTime2), N'Vlad', N'Amirov', NULL, NULL, NULL, 1, 0, 0, 2, 0, 2)
SET IDENTITY_INSERT [BO_Operators] OFF
GO
SET IDENTITY_INSERT [dbo].[Users] ON 
GO
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email], [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName]) VALUES (1, 1, 1, N'CompanyWallet@knoks.com', 1, N'V1|sKnkhqMK83XphTJsUKXGpNLG8KiWMezFuSN/I0mR3OM=|sJZU/pMPycLxQVPL6RxCAA==', N'Company', N'Wallet', 0, NULL, N'000000', NULL, NULL, NULL, NULL, NULL, 0, 0, CAST(N'2018-01-01T00:00:00.0000000' AS DateTime2), 0, CAST(N'2018-01-01T00:00:00.000' AS DateTime), N'DB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test User')
GO
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email], [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName]) VALUES (2, 2, 1, N'BonusWallet@knoks.com', 1, N'XXXXXX', N'Bonus', N'Wallet', 0, NULL, N'000000', NULL, NULL, NULL, NULL, NULL, 0, 0, CAST(N'2018-01-01T00:00:00.0000000' AS DateTime2), 0, CAST(N'2018-01-01T00:00:00.000' AS DateTime), N'DB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test User')
GO
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email], [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName]) VALUES (3, 3, 1, N'AffiliatesWallet@knoks.com', 1, N'XXXXXX', N'Affiliates', N'Wallet', 0, NULL, N'000000', NULL, NULL, NULL, NULL, NULL, 0, 0, CAST(N'2018-01-01T00:00:00.0000000' AS DateTime2), 0, CAST(N'2018-01-01T00:00:00.000' AS DateTime), N'DB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test User')
GO
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email], [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName]) VALUES (4, 4, 1, N'SideBet@knoks.com', 1, N'XXXXXX', N'SideBet', N'Wallet', 0, NULL, N'000000', NULL, NULL, NULL, NULL, NULL, 0, 0, CAST(N'2018-01-01T00:00:00.0000000' AS DateTime2), 0, CAST(N'2018-01-01T00:00:00.000' AS DateTime), N'DB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test User')
GO
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email], [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName]) VALUES (5, 0, 1, N'yoav.pinkas@gmail.com', 0, N'ÁAABBBCCC', N'Yoav', N'Pinkas', 104, N'+972', N'541223344', N'Hanavi Yerucham 28', N'Bney-Brak', N'55900', CAST(N'1966-12-01' AS Date), N'1', 27, 0, CAST(N'2018-02-11T22:34:23.9400000' AS DateTime2), 0, CAST(N'2018-02-11T22:34:23.940' AS DateTime), N'0', N'127.0.0.1', N'web', NULL, NULL, NULL, 1, 0, 0,  'Test User')
GO
--platform user
INSERT [dbo].[Users] ([UserId], [UserRoleId], [ApiConsumerId], [Email],					 [UserTypeId], [Password], [FirstName], [LastName], [CountryId], [PhonePrefix], [Phone], [Address], [City], [ZipCode], [BirthDate], [Gender], [LanguageId], [IsUSTaxEntity], [RegistrationDate], [KYC_Approved], [CreateDate], [CreateOrigin], [CreateIPAddress], [Source], [LastModifyDate], [LastModifyOrigin], [LastModifyOperatorId], [TermsOfServiceChecked], [MailVerfied], [PhoneVerified], [UserName] )
				VALUES (6,		 0,			 1,					N'admin@knoks.com',		2,				N'ÁAABBBCCC', N'Yoav',	N'Pinkas',	104,		N'+972', N'541223344',	 N'Hanavi Yerucham 28', N'Bney-Brak', N'55900', CAST(N'1966-12-01' AS Date), N'1', 27, 0, CAST(N'2018-02-11T22:34:23.9400000' AS DateTime2), 0, CAST(N'2018-02-11T22:34:23.940' AS DateTime), N'0', N'127.0.0.1', N'web', NULL, NULL, NULL, 1, 0, 0,'TestUser')
GO
SET IDENTITY_INSERT [dbo].[Users] OFF
GO