 );
 
 CREATE TABLE groups (
-	groupid BIGSERIAL,
+	groupid BIGSERIAL UNIQUE,
 	groupname text UNIQUE NOT NULL,
 	creator bigint NOT NULL,
 	leader bigint NOT NULL
 );
 
-INSERT INTO groups VALUES (
-	1,
+INSERT INTO groups (groupname, creator, leader) VALUES (
 	'all',
 	1,
 	1

	groups bigint[] NOT NULL
);

INSERT INTO users VALUES (
	1,
	'system',
	true,
	'',

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