From b4326b9ee78182669f2683770fc8069f9cf2a0b8 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <jacou@melix.net>
Date: Mon, 29 Sep 2008 21:10:57 +0200
Subject: [PATCH] Adds promo 1920 in database.

---
 upgrade/merge-0.0.1/000_1920.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 upgrade/merge-0.0.1/000_1920.sql

diff --git a/upgrade/merge-0.0.1/000_1920.sql b/upgrade/merge-0.0.1/000_1920.sql
new file mode 100644
index 0000000..0e6a0ed
--- /dev/null
+++ b/upgrade/merge-0.0.1/000_1920.sql
@@ -0,0 +1,9 @@
+set @n = 19200001;
+
+INSERT INTO  auth_user_md5 (matricule, matricule_ax, promo, promo_sortie, nom_ini, prenom_ini, perms, nom, prenom)
+     SELECT  @n := @n + 1, id_ancien, promotion_etude, promotion_etude + 3, CONCAT(partic_patro, Nom_patronymique), prenom,
+             'pending', CONCAT(partic_patro, Nom_patronymique), prenom
+       FROM  fusionax_anciens
+      WHERE  promotion_etude = 1920;
+
+-- vim:set syntax=mysql:
-- 
2.1.4