12 lines
587 B
SQL
12 lines
587 B
SQL
CREATE TABLE `client_contact` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`clientCode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`label` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`genre` enum('M','Mme','Mlle') COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`nom` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`prenom` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`tel` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|