CREATE TABLE [dbo].[SysuserProfilePic]
(
[SysuserProfilePicID] [int] NOT NULL IDENTITY(1, 1),
[SysuserFID] [int] NOT NULL,
[Picture] [varbinary] (max) NOT NULL,
[MoversConnectMobileUserPicFID] [int] NULL,
[MoversSuiteSyncDate] [datetime] NULL,
[DateModified] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[SysuserProfilePic] ADD CONSTRAINT [PK_SysuserProfilePic] PRIMARY KEY NONCLUSTERED  ([SysuserProfilePicID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SysuserProfilePic] ADD CONSTRAINT [IX_SysuserProfilePic_Sysuser] UNIQUE NONCLUSTERED  ([SysuserFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SysuserProfilePic] ADD CONSTRAINT [FK_SysuserProfilePic_Sysuser] FOREIGN KEY ([SysuserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[SysuserProfilePic] TO [MssExec]
GRANT INSERT ON  [dbo].[SysuserProfilePic] TO [MssExec]
GRANT DELETE ON  [dbo].[SysuserProfilePic] TO [MssExec]
GRANT UPDATE ON  [dbo].[SysuserProfilePic] TO [MssExec]
GO