 	pid						INTEGER,
 	message					TEXT NOT NULL
 	);
--- TODO: add index by import_id
--- TODO: add index by recorded_on_date
-
+CREATE INDEX log_entries_import_id_idx ON log_entries(import_id);
+CREATE INDEX log_entries_recorded_on_date_idx ON log_entries(recorded_on_date)
 	
 -- The messages that are  TCP logs
 CREATE TABLE tcp_log_messages (

		
		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
	server_queue_size		INTEGER NOT NULL,
	proxy_queue_size		INTEGER NOT NULL
	);
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	
