create table lmm_bkntc_services
(
    id                     int auto_increment
        primary key,
    name                   varchar(100)   null,
    price                  decimal(13, 4) null,
    category_id            int            null,
    is_visible             tinyint        null,
    duration               int            null,
    timeslot_length        int            null,
    buffer_before          int            null,
    buffer_after           int            null,
    notes                  text           null,
    image                  varchar(100)   null,
    is_recurring           tinyint        null,
    full_period_type       varchar(30)    null,
    full_period_value      int            null,
    repeat_type            varchar(30)    null,
    recurring_payment_type varchar(40)    null,
    repeat_frequency       int            null,
    is_fix_time            tinyint        null,
    max_capacity           int            null,
    color                  varchar(10)    null,
    deposit_type           varchar(20)    null,
    deposit                decimal(13, 4) null,
    is_active              tinyint(1)     null,
    hide_price             tinyint(1)     null,
    hide_duration          tinyint(1)     null,
    tenant_id              int            null
)
    collate = utf8mb4_unicode_ci;

create index tenant_id
    on lmm_bkntc_services (tenant_id);

INSERT INTO meet.lmm_bkntc_services (id, name, price, category_id, is_visible, duration, timeslot_length, buffer_before, buffer_after, notes, image, is_recurring, full_period_type, full_period_value, repeat_type, recurring_payment_type, repeat_frequency, is_fix_time, max_capacity, color, deposit_type, deposit, is_active, hide_price, hide_duration, tenant_id) VALUES (1, 'Du Lundi au Vendredi', 79.9000, 2, 1, 30, 30, 0, 0, 'entre 9h00 et 19h00.', '', 0, null, 0, null, null, 0, null, 1, '#53d56c', 'percent', 0.0000, 1, 0, 0, null);
INSERT INTO meet.lmm_bkntc_services (id, name, price, category_id, is_visible, duration, timeslot_length, buffer_before, buffer_after, notes, image, is_recurring, full_period_type, full_period_value, repeat_type, recurring_payment_type, repeat_frequency, is_fix_time, max_capacity, color, deposit_type, deposit, is_active, hide_price, hide_duration, tenant_id) VALUES (3, 'Du Lundi au Vendredi‎ㅤ', 99.9000, 2, 1, 30, 30, 0, 0, 'entre 06h00 et 09h00 ou entre 19h00 et 23h00.', '', 0, null, 0, null, null, 0, null, 1, '#53d56c', 'percent', 0.0000, 1, 0, 0, null);
INSERT INTO meet.lmm_bkntc_services (id, name, price, category_id, is_visible, duration, timeslot_length, buffer_before, buffer_after, notes, image, is_recurring, full_period_type, full_period_value, repeat_type, recurring_payment_type, repeat_frequency, is_fix_time, max_capacity, color, deposit_type, deposit, is_active, hide_price, hide_duration, tenant_id) VALUES (4, 'Samedi et Dimanche', 119.9000, 2, 1, 30, 30, 0, 0, 'entre 6h00 et 23h00.', '', 0, null, 0, null, null, 0, null, 1, '#53d56c', 'percent', 0.0000, 1, 0, 0, null);
