Changeset 3331


Ignore:
Timestamp:
Dec 5, 2013, 2:10:32 PM (6 years ago)
Author:
nosdeputes
Message:

fix dump QEs creator

File:
1 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/bin/createQEdump.php

    r2032 r3331  
    2828  `nom_circo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    2929  `num_circo` smallint(2) UNSIGNED DEFAULT NULL,
    30   `site_web` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
     30  `sites_web` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    3131  `debut_mandat` date DEFAULT NULL,
    3232  `fin_mandat` date DEFAULT NULL,
     
    6161) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;');
    6262
    63 $bdd->query('INSERT INTO `'.$DBTABLE.'` SELECT qe.id, pa.slug, pa.nom, pa.sexe, pa.nom_circo, pa.num_circo, pa.site_web, pa.debut_mandat, pa.fin_mandat, pa.place_hemicycle, pa.url_an, pa.profession, pa.groupe_acronyme,  qe.source, qe.legislature, qe.numero, qe.date, qe.date_cloture, qe.ministere, qe.themes, qe.question, qe.reponse, qe.motif_retrait
     63$bdd->query('INSERT INTO `'.$DBTABLE.'` SELECT qe.id, pa.slug, pa.nom, pa.sexe, pa.nom_circo, pa.num_circo, pa.sites_web, pa.debut_mandat, pa.fin_mandat, pa.place_hemicycle, pa.url_an, pa.profession, pa.groupe_acronyme,  qe.source, qe.legislature, qe.numero, qe.date, qe.date_cloture, qe.ministere, qe.themes, qe.question, qe.reponse, qe.motif_retrait
    6464FROM `question_ecrite` qe
    6565LEFT JOIN `parlementaire` pa
Note: See TracChangeset for help on using the changeset viewer.