CREATE INDEX i_acre_n ON adjcrea (nom);

CREATE INDEX i_bugs_d ON bugs (date);
CREATE INDEX i_bugs_iit ON bugs (id, istopic);
CREATE INDEX i_bugs_rtitd ON bugs (reftopic, istopic, date);
CREATE INDEX i_bugs_iti ON bugs (istopic, id);

CREATE INDEX i_conn_sd ON connection (sorcier, date);
CREATE INDEX i_conn_sc ON connection (sorcier, close);
CREATE INDEX i_conn_ds ON connection (date, sorcier);
CREATE INDEX i_conn_dai ON connection (date, adresseip);
CREATE INDEX i_conn_aids ON connection (adresseip, date, sorcier);

CREATE INDEX i_crea_c  ON creature (cout);
CREATE INDEX i_crea_fe  ON creature (`force`, endurance);
CREATE INDEX i_crea_ef  ON creature (endurance, `force`);
CREATE INDEX i_crea_cn ON creature (controleur, nom);
CREATE INDEX i_crea_ede ON creature (etat, dateengage);
CREATE INDEX i_crea_edc ON creature (etat, datecreation);
CREATE INDEX i_crea_cc ON creature (controleur, cout);
CREATE INDEX i_crea_cesef ON creature (controleur, etat, statut, endurance, `force`);
CREATE UNIQUE INDEX i_crea_ci ON creature (controleur, id);
CREATE UNIQUE INDEX i_crea_ife ON creature (id, `force`, endurance);

CREATE INDEX i_crea_sin ON creature (sorcierid, nom);
CREATE INDEX i_crea_sic ON creature (sorcierid, cout);
CREATE INDEX i_crea_siesef ON creature (sorcierid, etat, statut, endurance, `force`);
CREATE UNIQUE INDEX i_crea_sii ON creature (sorcierid, id);

CREATE UNIQUE INDEX i_faqs_ia ON faq (id, actif);
CREATE INDEX i_faqs_ta ON faq (themefaq, actif);

CREATE INDEX i_frum_a ON forum (auteur);
CREATE INDEX i_frum_dt ON forum (date, istopic);
CREATE INDEX i_frum_t ON forum (reftopic);
CREATE UNIQUE INDEX i_frum_itr ON forum (id, istopic);
CREATE INDEX i_frum_tri ON forum (reftopic, istopic);
CREATE INDEX i_frum_mma ON forum (modere, message(200), auteur);
CREATE INDEX i_frum_ma ON forum (modere, auteur);

CREATE INDEX i_hist_s ON historique (saison);
CREATE INDEX i_hist_pv ON historique (puissance, vie);

CREATE INDEX i_jrnl_d ON journal (date);
CREATE INDEX i_jrnl_cnd ON journal (couleur, numero, date);

CREATE INDEX i_land_ce  ON land     (controleur, etat);
CREATE INDEX i_land_cc  ON land     (controleur, couleur);
CREATE INDEX i_land_ede  ON land     (etat, dateengage);

CREATE INDEX i_lnds_sienti   ON landstatus  (sorcierid, etat, nbterrains, id);
CREATE INDEX i_lnds_edeisint ON landstatus  (etat, dateengage, id, sorcierid, nbterrains);

CREATE INDEX i_lcrea_nc ON lieucrea (nom, couleur);
CREATE INDEX i_lcrea_cn ON lieucrea (couleur, nom);

CREATE INDEX i_mesg_dd ON message (destinataire, date);
CREATE INDEX i_mesg_d ON message (date);
CREATE INDEX i_mesg_dl ON message (destinataire, lu, date);
CREATE INDEX i_mesg_e ON message (expediteur);
CREATE INDEX i_mesg_mte ON message (modere, texte(200), expediteur);
CREATE INDEX i_mesg_me ON message (modere, expediteur);

CREATE INDEX i_news_s ON news (sorcier);

CREATE INDEX i_ncre_nc ON nomcrea (nom, couleur);
CREATE INDEX i_ncre_cn ON nomcrea (couleur, nom);

CREATE INDEX i_rela_c1n1c2n2t ON relation (couleur1, numero1, couleur2, numero2, type);
CREATE INDEX i_rela_c1n1tc2n2dd ON relation (couleur1, numero1, type, couleur2, numero2, datedebut);
CREATE INDEX i_rela_c2n2t ON relation (couleur2, numero2, type);
CREATE INDEX i_rela_tc1n1c2n2 ON relation (type, couleur1, numero1, couleur2, numero2);
CREATE INDEX i_rela_c1n1ddti ON relation (couleur1, numero1, datedebut, type, id);
CREATE INDEX i_rela_c1n1ti ON relation (couleur1, numero1, type, id);

CREATE INDEX i_roya_cn  ON royaume  (couleur, numero);

CREATE INDEX i_sond_c ON sondage (choix);

CREATE UNIQUE INDEX i_sorc_na  ON sorcier  (nom, activation);
CREATE INDEX i_sorc_pa  ON sorcier  (puissance, activation);
CREATE INDEX i_sorc_cn  ON sorcier  (couleur, numero);
CREATE INDEX i_sorc_ia  ON sorcier  (immunise, activation);
CREATE INDEX i_sorc_nca  ON sorcier  (nom, codeactivation);
CREATE INDEX i_sorc_ncna ON sorcier (nom, couleur, numero, activation);
CREATE INDEX i_sorc_v ON sorcier (vote);
CREATE INDEX i_sorc_cnar ON sorcier (couleur, numero, activation, estroi);
CREATE INDEX i_sorc_e ON sorcier (email);
CREATE INDEX i_sorc_cnaip ON sorcier (couleur, numero, activation, immunise, puissance);
CREATE INDEX i_sorc_ciapn ON sorcier (couleur, immunise, activation, puissance, nom);
CREATE INDEX i_sorc_an ON sorcier (admin, nom);
CREATE INDEX i_sorc_cnan ON sorcier (couleur, numero, activation, nom);
CREATE INDEX i_sorc_ap ON sorcier (activation, puissance);
CREATE INDEX i_sorc_cap ON sorcier (couleur, activation, puissance);
CREATE INDEX i_sorc_cnap ON sorcier (couleur, numero, activation, puissance);
CREATE INDEX i_sorc_l ON sorcier (login);
CREATE INDEX i_sorc_adi ON sorcier (activation, dateinscription);
CREATE INDEX i_sorc_er ON sorcier (estroi);

CREATE UNIQUE INDEX i_sorc_sia  ON sorcier  (id, activation);
CREATE INDEX i_sorc_sica  ON sorcier  (id, codeactivation);
CREATE INDEX i_sorc_sicna ON sorcier (id, couleur, numero, activation);
CREATE INDEX i_sorc_ciapsi ON sorcier (couleur, immunise, activation, puissance, id);
CREATE INDEX i_sorc_asi ON sorcier (admin, id);
CREATE INDEX i_sorc_cnasi ON sorcier (couleur, numero, activation, id);


CREATE INDEX i_sor1_c ON sorts1 (controleur);
CREATE INDEX i_sor1_sid ON sorts1 (sortid);
CREATE INDEX i_sor1_csi ON sorts1 (controleur, sortid);
CREATE INDEX i_sor1_csidc ON sorts1 (controleur, sortid, datecreation);

CREATE INDEX i_eff1_cce ON sortseffet1 (controleur, cibleid, effetid);
CREATE INDEX i_eff1_ei ON sortseffet1 (effetid);

CREATE INDEX i_efft_di ON sortseffet (declenchement, id);
CREATE UNIQUE INDEX i_efft_si ON sortseffet (sortid);
CREATE INDEX i_efft_isi ON sortseffet (id, sortid);

CREATE INDEX i_stmp_csici ON sortstemp (controleur, sortid, cibleid);

CREATE INDEX i_stso_nc ON statsorts (nom, couleur);

CREATE INDEX i_tfaq_a ON themefaq (actif);
CREATE INDEX i_tfaq_ia ON themefaq (id, actif);

CREATE INDEX i_wrng_t ON warnings (type);

CREATE INDEX i_wrn1_s ON warnings1 (sorcier);


OPTIMIZE TABLE adjcrea;
OPTIMIZE TABLE bugs;
OPTIMIZE TABLE connection;
OPTIMIZE TABLE creature;
OPTIMIZE TABLE faq;
OPTIMIZE TABLE forum;
OPTIMIZE TABLE historique;
OPTIMIZE TABLE journal;
OPTIMIZE TABLE land;
OPTIMIZE TABLE liencreaturecapacite;
OPTIMIZE TABLE lieucrea;
OPTIMIZE TABLE message;
OPTIMIZE TABLE news;
OPTIMIZE TABLE nomcrea;
OPTIMIZE TABLE projet;
OPTIMIZE TABLE relation;
OPTIMIZE TABLE royaume;
OPTIMIZE TABLE sondage;
OPTIMIZE TABLE sondageold;
OPTIMIZE TABLE sorcier;
OPTIMIZE TABLE sorts1;
OPTIMIZE TABLE sortseffet;
OPTIMIZE TABLE sortseffet1;
OPTIMIZE TABLE sortstemp;
OPTIMIZE TABLE statsorts;
OPTIMIZE TABLE themefaq;
OPTIMIZE TABLE warnings;
OPTIMIZE TABLE warnings1;
OPTIMIZE TABLE moderation;

ANALYZE TABLE adjcrea;
ANALYZE TABLE bugs;
ANALYZE TABLE connection;
ANALYZE TABLE creature;
ANALYZE TABLE faq;
ANALYZE TABLE forum;
ANALYZE TABLE historique;
ANALYZE TABLE journal;
ANALYZE TABLE land;
ANALYZE TABLE liencreaturecapacite;
ANALYZE TABLE lieucrea;
ANALYZE TABLE message;
ANALYZE TABLE news;
ANALYZE TABLE nomcrea;
ANALYZE TABLE projet;
ANALYZE TABLE relation;
ANALYZE TABLE royaume;
ANALYZE TABLE sondage;
ANALYZE TABLE sondageold;
ANALYZE TABLE sorcier;
ANALYZE TABLE sorts1;
ANALYZE TABLE sortseffet;
ANALYZE TABLE sortseffet1;
ANALYZE TABLE sortstemp;
ANALYZE TABLE statsorts;
ANALYZE TABLE themefaq;
ANALYZE TABLE warnings;
ANALYZE TABLE warnings1;
ANALYZE TABLE moderation;