Untitled

 avatar
unknown
plain_text
a month ago
1.9 kB
4
Indexable
create table payment_methods
(
    id             bigint unsigned auto_increment
        primary key,
    name_en        varchar(191)                not null,
    name_ar        varchar(191)                not null,
    description_en text                        null,
    description_ar text                        null,
    status         enum ('active', 'inactive') not null,
    sendername     tinyint(1) default 0        not null,
    icon           varchar(191)                null,
    created_at     timestamp                   null,
    updated_at     timestamp                   null,
    constraint payment_methods_name_ar_unique
        unique (name_ar),
    constraint payment_methods_name_en_unique
        unique (name_en)
)
    collate = utf8mb4_unicode_ci;

INSERT INTO orbitasa.payment_methods (id, name_en, name_ar, description_en, description_ar, status, sendername, icon, created_at, updated_at) VALUES (1, 'Electronic card payment', 'الدفع بالبطاقات الائتمانية', 'Electronic card payment', 'يمكنك الدفع عن طريق الدفع بالبطاقات الائتمانية أو عن طريق Apple Pay', 'active', 1, '/home/forge/app.mobile.net.sa/releases/20230708133309/public/payment-methods/7S8k0QpVDmgcD6WZ89uHlqvYp.png', '2023-07-08 16:36:59', '2023-07-08 16:36:59');
INSERT INTO orbitasa.payment_methods (id, name_en, name_ar, description_en, description_ar, status, sendername, icon, created_at, updated_at) VALUES (2, 'PayPal', 'PayPal', 'PayPal', 'PayPal', 'active', 0, '/home/forge/app.mobile.net.sa/releases/20230713125423/public/payment-methods/NYX2ljC7bTqBhP10rQAecEfx2.png', '2023-07-13 18:46:07', '2023-09-23 12:22:03');
INSERT INTO orbitasa.payment_methods (id, name_en, name_ar, description_en, description_ar, status, sendername, icon, created_at, updated_at) VALUES (3, 'STC', 'STC', 'STC', 'STC', 'active', 1, null, '2023-09-19 14:13:02', '2023-09-30 11:48:33');
Leave a Comment