[Noalyss-commit] [noalyss] 01/05: Task #1118 - Partage de notes via le Pense-bête #1118 , Share todo list with other user, create table

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 62218c72deddd5d3e5abe9255312fe2a7c7a0720
Author: Dany De Bontridder <address@hidden>
Date:   Sun May 17 17:27:24 2015 +0200

    Task #1118 - Partage de notes via le Pense-bête
    #1118 , Share todo list with other user, create table
---
 sql/upgrade.sql |   14 +++++++++++++-
 1 files changed, 13 insertions(+), 1 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index b1886b1..0203ef8 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1 +1,13 @@
-update action set ac_description = 'Effacer un document de la comptabilité ou 
du suivi' where ac_id=1020;
\ No newline at end of file
+update action set ac_description = 'Effacer un document de la comptabilité ou 
du suivi' where ac_id=1020;
+
+
+CREATE TABLE todo_list_shared (id  serial primary key, todo_list_id int4 NOT 
NULL, use_login int4 NOT NULL, CONSTRAINT unique_todo_list_id_login 
+    UNIQUE (todo_list_id, use_login));
+
+ALTER TABLE todo_list_shared ADD CONSTRAINT fk_todo_list_shared_todo_list 
FOREIGN KEY (todo_list_id) REFERENCES todo_list (tl_id);
+
+comment on table todo_list_shared is 'Note of todo list shared with other 
users';
+comment on column todo_list_shared.todo_list_id is 'fk to todo_list';
+comment on column todo_list_shared.use_login is 'user login';
+
+