Added an index to tt_client_project_binds to guarantee uniqueness.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index 705e664..bc970f7 100644 (file)
--- a/mysql.sql
+++ b/mysql.sql
@@ -342,6 +342,7 @@ CREATE TABLE `tt_client_project_binds` (
 # Indexes for tt_client_project_binds.
 create index client_idx on tt_client_project_binds(client_id);
 create index project_idx on tt_client_project_binds(project_id);
+create unique index client_project_idx on tt_client_project_binds(client_id, project_id);
 
 
 #