create table lmm_bkntc_customers
(
    id            int auto_increment
        primary key,
    user_id       int          null,
    first_name    varchar(50)  null,
    last_name     varchar(50)  null,
    phone_number  varchar(100) null,
    email         varchar(100) null,
    birthdate     date         null,
    notes         varchar(750) null,
    profile_image varchar(50)  null,
    gender        varchar(10)  null,
    tenant_id     int          null,
    created_by    int          null,
    created_at    date         null
)
    collate = utf8mb4_unicode_ci;

create index tenant_id
    on lmm_bkntc_customers (tenant_id);

INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (1, 1, 'Schroeder', 'Kévin', '', 'kevinschroeder.web@gmail.com', null, null, null, null, null, null, '2022-10-23');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (2, 0, 'Dupont', 'Marcel', '+33621001121', 'ksch.dev@gmail.com', null, 'Test test', null, 'male', null, null, '2023-02-02');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (3, null, 'cvbcvb', 'cvbcvb', '', 'cvbcvb@yahoo.fr', null, null, null, null, null, null, null);
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (4, null, 'dsfgdsfgdsfg', 'sdfgsdfgdsfg', '', 'test@gmail.com', null, null, null, null, null, null, '2023-01-15');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (5, null, 'Hhh', 'Hhhh', '', 'Muug@yahoo.fr', null, null, null, null, null, null, null);
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (6, 2, 'Yacine', 'El Gerssifi', '', 'ksch.dev@gmail.com', null, null, null, null, null, null, null);
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (7, 3, 'Kévin', 'Schroeder', '+33687083988', 'noxoor@gmail.com', null, null, null, null, null, null, '2023-05-23');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (8, 4, 'Kévin', 'Schroeder', '+33687083988', 'testingmml@yopmail.com', null, null, null, null, null, null, '2023-05-29');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (9, 5, 'Kévin', 'Schroeder', '+33687083988', 'testkevinweb@yopmail.com', null, null, null, null, null, null, '2023-05-29');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (10, 6, 'Kévin', 'Schroeder', '+33687083988', 'testkevinweb2@yopmail.com', null, null, null, null, null, null, '2023-05-29');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (11, 7, 'Yacine', 'EL GERSSIFI', '+33646241687', 'yel.avocat@gmail.com', null, null, null, null, null, null, '2023-05-31');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (12, 8, 'Yacine', 'EL GERSSIFI', '+33612654789', 'y.elgerssifi@yel-avocat.fr', null, null, null, null, null, null, '2023-05-31');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (13, 9, 'Dupont', 'Jean', '+33646241687', 'cryptomania95100@gmail.com', null, null, null, null, null, null, '2023-06-04');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (14, 10, 'Yacine', 'EL GERSSIFI', '+33646241687', 'y.elgerssifi@yahoo.fr', null, null, null, null, null, null, '2023-06-04');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (15, 11, 'Ddd', 'Shzzjsusj', '+33788166892', 'mustaphaelgerssifi@yahoo.fr', null, null, null, null, null, null, '2023-06-17');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (16, 12, 'Nourddine', 'El gersifi', '+33612345678', 'nourddine.elgersifi@gmail.com', null, null, null, 'male', null, null, '2023-06-17');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (17, 13, 'A', 'A', '+33687083988', 'alexandre.dworkin@mseurope.be', null, null, null, null, null, null, '2023-06-30');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (18, 14, 'Ddd', 'Dddd', '07881668929202', 'Mm@yahoo.fr', null, null, null, null, null, null, '2023-07-22');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (19, 15, 'Myriam', 'El gerssifi ', '+33767473973', 'elgerssifim@gmail.com', null, null, null, null, null, null, '2023-08-07');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (20, 16, 'Prénom', 'Nom', '+33102030405', 'adresse@votreemail.fr', null, null, null, null, null, null, '2023-08-24');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (21, 17, 'Kévin', 'Schroeder', '+33687083988', 'testing-meetmylawyer@yopmail.com', null, null, null, null, null, null, '2023-08-26');
INSERT INTO meet.lmm_bkntc_customers (id, user_id, first_name, last_name, phone_number, email, birthdate, notes, profile_image, gender, tenant_id, created_by, created_at) VALUES (22, 18, 'wdp', 'j', '12345678', 'webdevphp7@gmail.com', null, null, null, null, null, null, '2023-12-05');
