Database setup

This is the code required to create the database table in MSSQL:

CREATE TABLE [UserID] (
[Field] [int] IDENTITY (1, 1) NOT NULL ,
[UI] [int] NULL DEFAULT (0),
[DealtWith] [bit] NOT NULL DEFAULT (0),
[Username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [aaaaaUserID_PK] PRIMARY KEY NONCLUSTERED
(
[Field]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT INTO [test_db].[dbo].[UserID]([UI], [DealtWith], [Username])
VALUES(12345678,1,'Alex')

INSERT INTO [test_db].[dbo].[UserID]([UI], [DealtWith], [Username])
VALUES(23456789,1,'Mark')

INSERT INTO [test_db].[dbo].[UserID]([UI], [DealtWith], [Username])
VALUES(34567890,0,'Jane')

INSERT INTO [test_db].[dbo].[UserID]([UI], [DealtWith], [Username])
VALUES(45678912,1,'Anne')