CREATE TABLE Users
(
Id INT UNIQUE IDENTITY(1,1),
Username NVARCHAR(30) NOT NULL,
Password NVARCHAR(26) NOT NULL,
Picture VARBINARY(MAX),
LastLogintime DATE,
isDeleted BIT
)
ALTER TABLE Users ADD PRIMARY KEY(Id)
ALTER TABLE Users
ADD CONSTRAINT CH_Picture CHECK(DATALENGTH(Picture) < 900 * 1024)

INSERT INTO Users (Username, Password) VALUES ('Minka', 'asdf' )
INSERT INTO Users (Username, Password) VALUES ('Ginka', 'dsa' )
INSERT INTO Users (Username, Password) VALUES ('Pesho', 'asdf')
INSERT INTO Users (Username, Password) VALUES ('Gosho', 'a11234')
INSERT INTO Users (Username, Password) VALUES ('Misho', 'fasfsa')