github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/fix/restore_personnes2.sql (about)

     1  -- After this file run
     2  -- pg_dump --table=export_pers --data-only --column-inserts mardi > pers.sql
     3  
     4  DROP TABLE IF EXISTS export_pers;
     5  
     6  CREATE TABLE export_pers (
     7      id,
     8      nom,
     9      prenom,
    10      sexe,
    11      mail,
    12      adresse,
    13      code_postal,
    14      ville,
    15      tels,
    16      version_papier,
    17      pub_hiver,
    18      pub_ete,
    19      echo_rocher,
    20      rang_membre_asso,
    21      quotient_familial,
    22      pays,
    23      ville_naissance,
    24      departement_naissance,
    25      nom_jeune_fille,
    26      date_naissance,
    27      profession,
    28      etudiant,
    29      fonctionnaire,
    30      securite_sociale,
    31      cotisation,
    32      eonews,
    33      contact_groupe,
    34      fiche_sanitaire,
    35      is_temporaire
    36  ) AS
    37  SELECT
    38      id,
    39      coalesce(nom, ''),
    40      coalesce(prenom, ''),
    41      coalesce(sexe, ''),
    42      coalesce(mail, ''),
    43      coalesce(adresse, ''),
    44      coalesce(code_postal, ''),
    45      coalesce(ville, ''),
    46      coalesce(tels, '{}'),
    47      coalesce(version_papier, FALSE),
    48      coalesce(pub_hiver, FALSE),
    49      coalesce(pub_ete, FALSE),
    50      coalesce(echo_rocher, FALSE),
    51      coalesce(rang_membre_asso, ''),
    52      coalesce(quotient_familial, 0),
    53      coalesce(pays, ''),
    54      coalesce(ville_naissance, ''),
    55      coalesce(departement_naissance, ''),
    56      coalesce(nom_jeune_fille, ''),
    57      coalesce(date_naissance, '0001-01-01'),
    58      coalesce(profession, ''),
    59      coalesce(etudiant, FALSE),
    60      coalesce(fonctionnaire, FALSE),
    61      coalesce(securite_sociale, ''),
    62      coalesce(cotisation, '{}'),
    63      coalesce(eonews, FALSE),
    64      coalesce(contact_groupe, '{}'),
    65      coalesce(fiche_sanitaire, '{}'),
    66      coalesce(is_temporaire, FALSE)
    67  FROM
    68      personnes
    69  WHERE
    70      id IN (3344, 3998, 3410, 21, 5832, 5364, 4936, 4608, 8356, 7981, 4340, 65, 3413, 6488, 71, 64, 6322, 79, 5127, 6478, 3920, 104, 6969, 5893, 111, 118, 6111, 162, 189, 5095, 193, 195, 202, 4918, 8244, 211, 214, 209, 3520, 3934, 7488, 245, 6154, 5035, 289, 301, 302, 6490, 3421, 6688, 6179, 3850, 5993, 7051, 4927, 5596, 459, 4720, 7940, 3806, 7030, 475, 479, 481, 488, 490, 489, 4226, 523, 5506, 7018, 4862, 539, 5433, 4607, 5024, 556, 4916, 572, 7572, 575, 577, 576, 579, 7571, 5782, 609, 618, 838, 616, 3986, 613, 617, 5029, 632, 7037, 654, 3431, 6001, 670, 671, 680, 6002, 5701, 684, 689, 3433, 699, 6496, 703, 8397, 724, 7574, 7573, 737, 735, 4564, 6089, 6474, 762, 763, 3186, 8328, 4043, 818, 816, 821, 858, 857, 63, 3439, 7376, 8289, 7966, 903, 6960, 970, 968, 985, 6504, 6730, 6891, 7039, 6082, 1036, 1049, 6336, 4105, 1094, 3447, 6825, 4017, 1168, 1167, 1178, 3286, 1244, 1248, 1241, 1266, 1267, 8439, 1324, 1335, 1336, 3844, 1377, 3455, 7939, 1379, 1390, 3457, 1420, 1424, 1429, 3390, 1451, 5296, 6542, 1531, 3356, 8116, 1594, 1614, 3461, 4815, 5017, 8145, 1644, 1671, 1686, 1780, 1729, 6766, 3465, 1738, 1741, 1747, 1750, 1766, 1778, 1783, 1784, 4621, 1838, 1883, 4921, 5354, 1904, 1916, 3472, 1962, 1985, 1998, 2002, 4821, 2005, 2013, 8151, 6091, 5173, 4686, 2135, 2197, 2238, 4472, 2231, 2279, 7016, 2322, 2315, 3231, 2332, 6658, 2343, 2365, 2407, 2410, 2412, 3687, 2448, 3488, 2484, 2485, 3794, 2473, 6617, 6066, 3696, 7219, 2559, 2604, 2620, 3492, 6592, 2690, 2696, 3707, 8229, 2703, 5096, 2715, 3496, 2725, 2724, 2750, 6519, 2793, 2790, 2797, 8480, 2802, 2804, 3502, 8233, 6457, 2813, 2814, 3999, 2867, 2869, 4426, 3250, 4430, 8300, 5424, 3506, 2975, 3508, 3025, 5039, 5598, 3041, 3046, 5947, 3072, 3093);
    71