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

     1  -- on peut supprimer les anciennes tables
     2  DROP TABLE old_personnes CASCADE;
     3  
     4  DROP TABLE old_aides CASCADE;
     5  
     6  DROP TABLE old_camps CASCADE;
     7  
     8  DROP TABLE old_documents CASCADE;
     9  
    10  DROP TABLE old_dons CASCADE;
    11  
    12  DROP TABLE old_factures CASCADE;
    13  
    14  DROP TABLE old_inscriptions CASCADE;
    15  
    16  DROP TABLE old_paiements CASCADE;
    17  
    18  DROP TABLE old_participants CASCADE;
    19  
    20  DROP TABLE old_structures_aides CASCADE;
    21  
    22  DROP TABLE old_users CASCADE;
    23  
    24  -- ajuste les serials
    25  SELECT
    26      setval(
    27          pg_get_serial_sequence('aides', 'id'),
    28          coalesce(max(id), 0) + 1,
    29          FALSE
    30      )
    31  FROM
    32      aides;
    33  
    34  SELECT
    35      setval(
    36          pg_get_serial_sequence('camps', 'id'),
    37          coalesce(max(id), 0) + 1,
    38          FALSE
    39      )
    40  FROM
    41      camps;
    42  
    43  SELECT
    44      setval(
    45          pg_get_serial_sequence('contraintes', 'id'),
    46          coalesce(max(id), 0) + 1,
    47          FALSE
    48      )
    49  FROM
    50      contraintes;
    51  
    52  SELECT
    53      setval(
    54          pg_get_serial_sequence('documents', 'id'),
    55          coalesce(max(id), 0) + 1,
    56          FALSE
    57      )
    58  FROM
    59      documents;
    60  
    61  SELECT
    62      setval(
    63          pg_get_serial_sequence('dons', 'id'),
    64          coalesce(max(id), 0) + 1,
    65          FALSE
    66      )
    67  FROM
    68      dons;
    69  
    70  SELECT
    71      setval(
    72          pg_get_serial_sequence('equipiers', 'id'),
    73          coalesce(max(id), 0) + 1,
    74          FALSE
    75      )
    76  FROM
    77      equipiers;
    78  
    79  SELECT
    80      setval(
    81          pg_get_serial_sequence('factures', 'id'),
    82          coalesce(max(id), 0) + 1,
    83          FALSE
    84      )
    85  FROM
    86      factures;
    87  
    88  SELECT
    89      setval(
    90          pg_get_serial_sequence('groupes', 'id'),
    91          coalesce(max(id), 0) + 1,
    92          FALSE
    93      )
    94  FROM
    95      groupes;
    96  
    97  SELECT
    98      setval(
    99          pg_get_serial_sequence('messages', 'id'),
   100          coalesce(max(id), 0) + 1,
   101          FALSE
   102      )
   103  FROM
   104      messages;
   105  
   106  SELECT
   107      setval(
   108          pg_get_serial_sequence('paiements', 'id'),
   109          coalesce(max(id), 0) + 1,
   110          FALSE
   111      )
   112  FROM
   113      paiements;
   114  
   115  SELECT
   116      setval(
   117          pg_get_serial_sequence('participants', 'id'),
   118          coalesce(max(id), 0) + 1,
   119          FALSE
   120      )
   121  FROM
   122      participants;
   123  
   124  SELECT
   125      setval(
   126          pg_get_serial_sequence('participantsimples', 'id'),
   127          coalesce(max(id), 0) + 1,
   128          FALSE
   129      )
   130  FROM
   131      participantsimples;
   132  
   133  SELECT
   134      setval(
   135          pg_get_serial_sequence('personnes', 'id'),
   136          coalesce(max(id), 0) + 1,
   137          FALSE
   138      )
   139  FROM
   140      personnes;
   141  
   142  SELECT
   143      setval(
   144          pg_get_serial_sequence('sondages', 'id'),
   145          coalesce(max(id), 0) + 1,
   146          FALSE
   147      )
   148  FROM
   149      sondages;
   150  
   151  SELECT
   152      setval(
   153          pg_get_serial_sequence('structureaides', 'id'),
   154          coalesce(max(id), 0) + 1,
   155          FALSE
   156      )
   157  FROM
   158      structureaides;
   159  
   160  SELECT
   161      setval(
   162          pg_get_serial_sequence('users', 'id'),
   163          coalesce(max(id), 0) + 1,
   164          FALSE
   165      )
   166  FROM
   167      users;
   168  
   169  DROP FUNCTION IF EXISTS m_responsable();
   170  
   171  DROP FUNCTION IF EXISTS m_centre();
   172  
   173  DROP FUNCTION IF EXISTS m_accuse_reception();
   174  
   175  DROP FUNCTION IF EXISTS m_facture();
   176  
   177  DROP FUNCTION IF EXISTS m_documents();
   178  
   179  DROP FUNCTION IF EXISTS m_facture_aquittee();
   180  
   181  DROP FUNCTION IF EXISTS m_attestation_presence();
   182  
   183  DROP FUNCTION IF EXISTS m_sondage();
   184  
   185  DROP FUNCTION IF EXISTS m_inscription();
   186  
   187  DROP FUNCTION IF EXISTS m_place_liberee();
   188  
   189  DROP FUNCTION IF EXISTS d_mail();