Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

Ignore whitespace Rev 336 → Rev 337

/trunk/docs/projets/bdtfx/bdd/bdtfx_v1_01.sql
68,11 → 68,13
typus varchar(400) CHARACTER SET utf8 DEFAULT NULL,
num_meme_type varchar(10) CHARACTER SET utf8 DEFAULT NULL,
flore_belge_ed5_page varchar(30) CHARACTER SET utf8 DEFAULT NULL,
KEY idx_num_nom (num_nom),
KEY idx_num_nom_retenu (num_nom_retenu),
KEY idx_rang (rang),
KEY idx_num_tax (num_taxonomique),
KEY idx_num_tax_sup (num_tax_sup)
PRIMARY KEY (num_nom),
KEY num_nom_retenu (num_nom_retenu),
KEY rang (rang),
KEY num_tax (num_taxonomique),
KEY num_tax_sup (num_tax_sup)
KEY nom_sci (nom_sci),
KEY basionyme (basionyme)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
CREATE TABLE IF NOT EXISTS bdtfx_meta (