7 lines
368 B
SQL
Executable File
7 lines
368 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS `tabFJur` (
|
|
`code` int(4) NOT NULL DEFAULT '0',
|
|
`libelle` varchar(100) DEFAULT NULL COMMENT 'Libellé de la forme juridique',
|
|
`libelleEn` varchar(100) NOT NULL COMMENT 'Traduction Anglaise',
|
|
PRIMARY KEY (`code`),
|
|
FULLTEXT KEY `libelle` (`libelle`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Référentiel des Formes Juridiques'; |