9 lines
461 B
SQL
9 lines
461 B
SQL
CREATE TABLE `contrat_articles` (
|
|
`code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`value` decimal(10,2) DEFAULT NULL,
|
|
`valueFormat` enum('montant','percent') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`code`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Liste des codes articles';
|