Mesbahi-laravel/public/sql/coupons.sql

INSERT INTO `coupons` (
    `id`,
    `code`,
    `language`,
    `description`,
    `image`,
    `type`,
    `amount`,
    `minimum_cart_amount`,
    `active_from`,
    `expire_at`,
    `target`,
    `is_approve`,
    `shop_id`,
    `user_id`,
    `created_at`,
    `updated_at`,
    `deleted_at`
  )
VALUES (
    1,
    'EID2',
    'en',
    NULL,
    '{\"id\": 246, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/246/2x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/246/conversions/2x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    2.00,
    0.00,
    '2021-10-25T07:34:58.000Z',
    '2026-11-30T07:34:58.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 01:37:05',
    '2024-01-14 23:22:15',
    NULL
  ),
  (
    2,
    '4OFF',
    'en',
    NULL,
    '{\"id\": 247, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/247/4x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/247/conversions/4x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    4.00,
    0.00,
    '2021-10-25T07:34:58.000Z',
    '2027-12-31T07:34:58.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 01:37:29',
    '2024-01-14 23:22:12',
    NULL
  ),
  (
    3,
    'RAMADAN5',
    'en',
    NULL,
    '{\"id\": 248, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/248/5x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/248/conversions/5x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    5.00,
    0.00,
    '2021-10-25T07:34:58.000Z',
    '2030-12-31T07:34:58.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 01:39:35',
    '2024-01-14 23:22:09',
    NULL
  ),
  (
    4,
    '6OFF',
    'en',
    NULL,
    '{\"id\": 249, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/249/6x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/249/conversions/6x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    6.00,
    0.00,
    '2021-10-25T07:34:58.000Z',
    '2029-01-31T07:34:58.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 01:40:08',
    '2024-01-14 23:22:07',
    NULL
  ),
  (
    5,
    'SUMMER8',
    'en',
    NULL,
    '{\"id\": 250, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/250/8x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/250/conversions/8x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    8.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2028-12-31T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:35:30',
    '2024-01-14 23:22:03',
    NULL
  ),
  (
    6,
    'WINTER10',
    'en',
    NULL,
    '{\"id\": 251, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/251/10x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/251/conversions/10x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    10.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2026-01-31T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:36:35',
    '2024-01-14 23:22:00',
    NULL
  ),
  (
    7,
    '12OFF',
    'en',
    NULL,
    '{\"id\": 252, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/252/12x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/252/conversions/12x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    12.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2027-11-30T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:37:34',
    '2024-01-14 23:21:57',
    NULL
  ),
  (
    8,
    'SUMMER15',
    'en',
    NULL,
    '{\"id\": 253, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/253/15x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/253/conversions/15x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    15.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2028-02-28T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:38:02',
    '2024-01-14 23:21:52',
    NULL
  ),
  (
    9,
    'CHRISTMAS18',
    'en',
    NULL,
    '{\"id\": 254, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/254/18x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/254/conversions/18x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    18.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2029-12-31T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:39:20',
    '2024-01-14 22:26:16',
    NULL
  ),
  (
    10,
    '20OFF',
    'en',
    NULL,
    '{\"id\": 255, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/255/20x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/255/conversions/20x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    20.00,
    0.00,
    '2021-10-25T12:32:39.000Z',
    '2030-10-25T12:32:39.000Z',
    0,
    1,
    NULL,
    NULL,
    '2021-10-25 06:39:51',
    '2024-01-14 22:26:13',
    NULL
  ),
  (
    11,
    'NEWYEARSALE',
    'en',
    NULL,
    '{\"id\": 255, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/255/20x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/255/conversions/20x2x-thumbnail-thumbnail.jpg\"}',
    'percentage',
    10.00,
    100.00,
    '2024-01-15T04:26:51.000Z',
    '2024-12-31T18:00:00.000Z',
    0,
    1,
    11,
    1,
    '2024-01-14 22:27:14',
    '2024-01-14 22:36:23',
    NULL
  ),
  (
    12,
    'BLACKFRIDAY',
    'en',
    NULL,
    '{\"id\": 254, \"original\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/254/18x2x-thumbnail.jpg\", \"thumbnail\": \"https://chawkbazarlaravel.s3.ap-southeast-1.amazonaws.com/254/conversions/18x2x-thumbnail-thumbnail.jpg\"}',
    'fixed',
    2.00,
    500.00,
    '2024-01-15T04:36:02.519Z',
    '2025-08-31T18:00:00.000Z',
    0,
    1,
    11,
    1,
    '2024-01-14 22:39:20',
    '2024-01-14 22:41:08',
    NULL
  );