CREATE TABLE [RemoteControl_PremiumDevice]
(
    [DeviceGuid]         uniqueidentifier    NOT NULL,
    [OMRowVersion]       rowversion          NOT NULL,
    [DateCreated]        datetime            NOT NULL,
    [DateModified]       datetime            NOT NULL,
    [SyncGuid]           uniqueidentifier    NOT NULL,
    [PremiumComputerID]  nvarchar(256)           NULL,
    [PasswordSet]		 nvarchar(256)           NULL,
    [PasswordRetrieved]  nvarchar(256)           NULL
    ,InstallStatus        int                not NULL 
	 constraint RemoteControl_PremiumDevice_InstallStatus_DF default (0)   /*0 is Unknown */
    ,CONSTRAINT [RemoteControl_PremiumDevice_SyncGuid_UC]  UNIQUE ([SyncGuid])
    ,CONSTRAINT [RemoteControl_PremiumDevice_DeviceGuid_PK]  PRIMARY KEY 
	                                                                      clustered 
	                                                        ([DeviceGuid])
)
go
