 	user text not null,
 	status text not null
 );
+CREATE INDEX statustrack_ticket_id on statustrack ( ticket_id );
 
 CREATE TABLE tags (
 	ticket_id integer not null references ticket ( id ),
 	tag text not null
 );
+CREATE INDEX tags_ticket_id on tags ( ticket_id );
 
 CREATE TABLE timetrack (
 	id integer primary key not null,

	dateclosed datetime,
	user text not null
);

CREATE TABLE comments ( 
	id integer primary key not null,

	user text not null,
	minutes integer not null
);
CREATE INDEX timetrack_ticket_id on timetrack ( ticket_id );

CREATE TABLE tagsdesc (
	tag text not null primary key,
