 	server_queue_size		INTEGER NOT NULL,
 	proxy_queue_size		INTEGER NOT NULL
 	);
--- TODO: add index by log_entry_id
--- TODO: add index by recorded_on_date
--- TODO: add index by frontend
--- TODO: add index by backend
+CREATE INDEX tcp_log_messages_log_entry_id_idx ON tcp_log_messages(log_entry_id);
+CREATE INDEX tcp_log_messages_recorded_on_date_idx ON tcp_log_messages(recorded_on_date);
+CREATE INDEX tcp_log_messages_frontend_idx ON tcp_log_messages(frontend);
+CREATE INDEX tcp_log_messages_backend_idx ON tcp_log_messages(backend);
 
 	
 -- The messages that are HTTP Logs	

		
		http_request			TEXT NOT NULL
		);
-- TODO: add index by log_entry_id
-- TODO: add index by recorded_on_date
-- TODO: add index by frontend
-- TODO: add index by backend
-- TODO: add index by server
-- TODO: add index by status
	start_offset			INTEGER, 	-- byte offset in the file of the starting point of the run
	end_offset				INTEGER, 	-- byte offset in the file of the ending pont of the run.
	);
CREATE INDEX imports_import_date_idx ON imports(import_date);

	
-- The basic information from every line of the log file
CREATE TABLE log_entries (
