X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=todo-schema.sql;h=5c9aeb28a89f858b487d105e89e1097f6d53b36e;hb=d17685b95a06a12bbdf3ce049049c7d667b384e3;hp=eb4492b425db89c8ef8cb094c46e2534c8f36974;hpb=d45f03595626c22ba0029fb059df9d19bd7e6158;p=todo.git

diff --git a/todo-schema.sql b/todo-schema.sql
index eb4492b..5c9aeb2 100644
--- a/todo-schema.sql
+++ b/todo-schema.sql
@@ -49,12 +49,14 @@ create table retired (
 create table tags (
     id serial not null primary key,
     name text not null,
-    colour text not null references colours (colour)
+    colour text not null references colours (colour),
+    unique (name)
 );
 
 create table tags_tasks (
     tagid integer not null references tags (id),
-    taskid integer not null references tasks (id)
+    taskid integer not null references tasks (id),
+    unique (tagid, taskid)
 );
 
 create table colours (