From 6587749dce1905598c80eb7b1d4f96a62309ba9a Mon Sep 17 00:00:00 2001
From: =?utf8?q?S=C3=A9bastien=20CHAZALLET?= <s.chazallet@gmail.com>
Date: Thu, 15 Nov 2012 13:55:54 +0100
Subject: [PATCH] Modification de la base

---
 data/jeu_essai.db       |  Bin 41984 -> 41984 bytes
 data/scripts/schema.sql |    8 ++++++++
 2 files changed, 8 insertions(+)

diff --git a/data/jeu_essai.db b/data/jeu_essai.db
index ca6418e00043ca45c4236cbc90620c7f4493887b..90fe97561317aab7c476c9b3695881877e6884a8 100644
GIT binary patch
delta 372
zcmZoT!PIbqX@WGP_Cy(HM(vFW3(a|%w=ys@ZDwHF%$&r`xv_C6lR*e0I|HMltFbYo
zM`mtfPGV)Eg1&2BNl{{EUTSV?UWr2S;gv<1sihSPMX80QnZ=X)t);mQO%)6ctqd%z
zOpGRTTCZVYU|{f`*yzs3#r&CpnfWvW^J(U%%(pfR3hZMxVOB&knURZGk}&{iVty$z
zFS9&jKw?p10nnCICZG|#Knww!92i-6sb!W2$gIskf3Id>TFo5C%)GI2E|Xz62P4GW
ij7ZKS<Z&J(k26kY_TK>Vx$neA&q)m|n^^+>1Oou2GG&PX

delta 275
zcmZoT!PIbqX@WGP=0q81M$L^03(a{M7#NtDIT@I@GAA)}ZfyL`G?~+SjhrVVI|HMv
zv9U3uM`mtfPGV)EYhFoFVrE`yZfai1<U3YMlkbOdPl{mSVrIU@!2Fr{Df6w(f+A;_
z)wq}?83PWlEXprs=4F;=3`i_WEC6arW#VC$g&W4W$$^mtVl`R1Jz%<-8JIUS$1yW+
hZ2ZbJnc07XyblK>#NCW=%dok8^8aks%`5?bf&qUPQ0)K!

diff --git a/data/scripts/schema.sql b/data/scripts/schema.sql
index 2a6a0b3..14a9f1f 100644
--- a/data/scripts/schema.sql
+++ b/data/scripts/schema.sql
@@ -125,6 +125,14 @@ BEGIN
 END;
 
 /*
+ * à chaque fois qu'une photographie est rajoutée, le champs contenant la date de mise la gallerie liée est mis à jour
+ */
+CREATE TRIGGER photo_insert_management AFTER UPDATE ON photo
+BEGIN
+    UPDATE gallery SET updated = datetime('now') WHERE id = old.id_gallery;
+END;
+
+/*
  * Gestion du workflow sur une commande: mise à jour de la date de fermeture au changement de statut open vers wait
  */
 CREATE TRIGGER order_form_update_management_closed AFTER UPDATE OF status ON order_form WHEN old.status='open' AND new.status='wait'
-- 
1.7.10.4