CREATE TABLE users 
(
ID int IDENTITY(1,1) PRIMARY KEY,
firstname varchar(255) NULL,
lastname varchar(255) NULL,
username varchar(255) NULL,
password varchar(255) NULL
);

CREATE TABLE files 
(
ID int IDENTITY(1,1) PRIMARY KEY,
name varchar(255) NULL,
path varchar(255) NULL,
archivedate datetime NULL,
filetype varchar(10) NULL
);

SELECT * FROM users

INSERT INTO users (firstname, lastname, username, password) VALUES ('Yannis','Biasutti','biasutti','123456');