5 lines
310 B
SQL
5 lines
310 B
SQL
DROP TABLE IF EXISTS jo.etablissements_old;
|
|
RENAME TABLE jo.etablissements TO jo.etablissements_old;
|
|
RENAME TABLE jo.etablissements_tmp TO jo.etablissements;
|
|
ALTER TABLE jo.etablissements_old ADD INDEX(source, siege, actif, adr_dep, capital, cj, ape_entrep, ape_etab, age_entrep, teff_entrep, teff_etab, tca);
|