| Line 66... |
Line 66... |
| 66 |
flore_fournier_num varchar(30) CHARACTER SET utf8 DEFAULT NULL,
|
66 |
flore_fournier_num varchar(30) CHARACTER SET utf8 DEFAULT NULL,
|
| 67 |
flore_fournier_rem varchar(150) CHARACTER SET utf8 DEFAULT NULL,
|
67 |
flore_fournier_rem varchar(150) CHARACTER SET utf8 DEFAULT NULL,
|
| 68 |
typus varchar(400) CHARACTER SET utf8 DEFAULT NULL,
|
68 |
typus varchar(400) CHARACTER SET utf8 DEFAULT NULL,
|
| 69 |
num_meme_type varchar(10) CHARACTER SET utf8 DEFAULT NULL,
|
69 |
num_meme_type varchar(10) CHARACTER SET utf8 DEFAULT NULL,
|
| 70 |
flore_belge_ed5_page varchar(30) CHARACTER SET utf8 DEFAULT NULL,
|
70 |
flore_belge_ed5_page varchar(30) CHARACTER SET utf8 DEFAULT NULL,
|
| 71 |
KEY idx_num_nom (num_nom),
|
71 |
PRIMARY KEY (num_nom),
|
| 72 |
KEY idx_num_nom_retenu (num_nom_retenu),
|
72 |
KEY num_nom_retenu (num_nom_retenu),
|
| 73 |
KEY idx_rang (rang),
|
73 |
KEY rang (rang),
|
| 74 |
KEY idx_num_tax (num_taxonomique),
|
74 |
KEY num_tax (num_taxonomique),
|
| 75 |
KEY idx_num_tax_sup (num_tax_sup)
|
75 |
KEY num_tax_sup (num_tax_sup)
|
| - |
|
76 |
KEY nom_sci (nom_sci),
|
| - |
|
77 |
KEY basionyme (basionyme)
|
| 76 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
78 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| Line 77... |
Line 79... |
| 77 |
|
79 |
|
| 78 |
CREATE TABLE IF NOT EXISTS bdtfx_meta (
|
80 |
CREATE TABLE IF NOT EXISTS bdtfx_meta (
|
| 79 |
guid varchar(255) NOT NULL DEFAULT 'urn:lsid:tela-botanica.org:#projet:#version',
|
81 |
guid varchar(255) NOT NULL DEFAULT 'urn:lsid:tela-botanica.org:#projet:#version',
|