 );
 
 CREATE TABLE users (
-	userid BIGSERIAL,
+	userid BIGSERIAL UNIQUE,
 	username text UNIQUE NOT NULL,
 	admin boolean NOT NULL,
 	salt text NOT NULL,

CREATE TABLE files (
	fileid BIGSERIAL,
	filename text NOT NULL,
	mime text NOT NULL,
	extension text NOT NULL,

);

CREATE TABLE groups (
	groupid BIGSERIAL UNIQUE,
	groupname text UNIQUE NOT NULL,
	creator bigint NOT NULL,
	leader bigint NOT NULL
);

INSERT INTO groups (groupname, creator, leader) VALUES (
	'all',
	1,
	1
