15 lines
732 B
SQL
15 lines
732 B
SQL
CREATE TABLE `client_adresse` (
|
|
`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,
|
|
`L1` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L2` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L3` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L4` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L5` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L6` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L7` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`L8` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|