Update AX id for X < 2011, M < 2012, D < 2013.

diff --git a/upgrade/1.1.13/01_upgradeAXid.sql b/upgrade/1.1.13/01_upgradeAXid.sql
new file mode 100644 (file)
index 0000000..82a725c
--- /dev/null
+++ b/upgrade/1.1.13/01_upgradeAXid.sql
@@ -0,0 +1,30 @@
+UPDATE profiles SET ax_id = 19560277 WHERE pid = 48088;
+UPDATE profiles SET ax_id = 19560276 WHERE pid = 48089;
+UPDATE profiles SET ax_id = 19730178 WHERE pid = 48100;
+UPDATE profiles SET ax_id = 19820322 WHERE pid = 48114;
+UPDATE profiles SET ax_id = '2003D045' WHERE pid = 46823;
+UPDATE profiles SET ax_id = '2004D001' WHERE pid = 46824;
+UPDATE profiles SET ax_id = '2007D007' WHERE pid = 46825;
+UPDATE profiles SET ax_id = '2007D016' WHERE pid = 46826;
+UPDATE profiles SET ax_id = '2007D017' WHERE pid = 46827;
+UPDATE profiles SET ax_id = '2007D025' WHERE pid = 46828;
+UPDATE profiles SET ax_id = '2007D030' WHERE pid = 46829;
+UPDATE profiles SET ax_id = '2007D045' WHERE pid = 46830;
+UPDATE profiles SET ax_id = '2007D050' WHERE pid = 46831;
+UPDATE profiles SET ax_id = '2008D063' WHERE pid = 46832;
+UPDATE profiles SET ax_id = '2008D023' WHERE pid = 46833;
+UPDATE profiles SET ax_id = '2008D055' WHERE pid = 46834;
+UPDATE profiles SET ax_id = '2009D506' WHERE pid = 46425;
+UPDATE profiles SET ax_id = '2009D050' WHERE pid = 46836;
+UPDATE profiles SET ax_id = '2009D202' WHERE pid = 46837;
+UPDATE profiles SET ax_id = '2009D378' WHERE pid = 46838;
+UPDATE profiles SET ax_id = '2009D504' WHERE pid = 46034;
+UPDATE profiles SET ax_id = '2009D503' WHERE pid = 46303;
+UPDATE profiles SET ax_id = '2010D009' WHERE pid = 46311;
+UPDATE profiles SET ax_id = '2012D098' WHERE pid = 46317;
+UPDATE profiles SET ax_id = '2012D099' WHERE pid = 46362;
+UPDATE profiles SET ax_id = '2012D100' WHERE pid = 46365;
+UPDATE profiles SET ax_id = '2010D089' WHERE pid = 46374;
+UPDATE profiles SET ax_id = '2009M142' WHERE pid = 44940;
+UPDATE profiles SET ax_id = '2009M143' WHERE pid = 44942;
+UPDATE profiles SET ax_id = '2009M144' WHERE pid = 44943;