databases/Metier/schema/facturation.facture_zoneclient.sql
2016-07-01 13:58:43 +02:00

8 lines
371 B
SQL

CREATE TABLE `facture_zoneclient` (
`factId` int(11) NOT NULL,
`lnum` tinyint(2) NOT NULL,
`lvalue` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`lstyle` enum('normal','italic','bold') COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`factId`,`lnum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Info zone client en ligne';