CREATE TABLE [dbo].[crepository]
(
[regno] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mackey] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[signingkey] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[serno] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[commonname] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[profilename] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[profileversion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[privatekey] [varbinary] (2000) NULL,
[tbscert_lo] [varbinary] (2000) NULL,
[tbscert_hi] [varbinary] (1000) NULL,
[processing] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[casigned] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[retrieved] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[emailaddress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timeofcreation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timeofsigning] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[typeofservice] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[craclient] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$crepo_u00003d7b00000000] ON [dbo].[crepository] ([mackey]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_crepository] ON [dbo].[crepository] ([regno]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [crepository_idx_01] ON [dbo].[crepository] ([serno]) ON [PRIMARY]
GO