git.annexia.org
/
todo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
poll-bugzilla: Avoid adding new task to multiple tables.
[todo.git]
/
todo-schema.sql
diff --git
a/todo-schema.sql
b/todo-schema.sql
index
eb4492b
..
5c9aeb2
100644
(file)
--- 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,
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),
);
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 (
);
create table colours (