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

);

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

INSERT INTO groups VALUES (
	1,
	'all',
	1,
	1

	groups bigint[] NOT NULL
);

INSERT INTO users (username, admin, salt, hash, registered, groups) VALUES (
	'system',
	true,
	'',
