databases/Apps/Extranet/schema/tabNaf5.sql
2016-10-25 15:54:11 +02:00

11 lines
412 B
SQL
Executable File

CREATE TABLE IF NOT EXISTS `tabNaf5tmp` (
`codNaf5` char(5) NOT NULL DEFAULT '',
`libNaf5` varchar(255) DEFAULT NULL,
`libNaf5en` varchar(255) DEFAULT NULL,
`codNaf4` char(4) DEFAULT NULL,
`codNaf3` char(3) DEFAULT NULL,
`codNaf2` char(2) DEFAULT NULL,
`codNaf1` char(1) DEFAULT NULL,
PRIMARY KEY (`codNaf5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Code NAF rév 3 de 2013 (5 positions)';