-- Shoeniverse update, 14 November 2026: help pages (delivery, returns, privacy, terms).
-- Run once in phpMyAdmin: open the shoeniverse database > SQL tab > paste this file > Go.

CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `body` longtext NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 0,
  `position` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO `pages` (`slug`,`title`,`body`,`is_published`,`position`,`created_at`,`updated_at`) VALUES ('delivery','Delivery & pickup','## Pick up at the shop

Collect your order at **Dubai Merchant Mall, Shop F46, Nairobi**. We hold it for you and message you on WhatsApp when it is ready. You can try it on before you leave.

Opening hours: Monday to Friday 9:00 am – 8:00 pm, Saturday 11:00 am – 9:30 pm. Closed on Sundays.

## Delivery in Nairobi

We deliver across Nairobi, usually [the same or the next working day]. The delivery fee is shown at checkout, or confirmed with you on WhatsApp before we send the order.

## Delivery outside Nairobi

We send orders countrywide by [courier or parcel service]. We confirm the fee and the expected arrival day on WhatsApp before dispatch.

## Paying

Pay with M-Pesa at checkout. For pickup orders you can also pay at the shop. Delivery orders are sent once payment is confirmed.

Questions? WhatsApp us on 0740 334 566.',0,1,NOW(),NOW());
INSERT IGNORE INTO `pages` (`slug`,`title`,`body`,`is_published`,`position`,`created_at`,`updated_at`) VALUES ('returns','Returns & exchanges','## Exchanges

Wrong size? Bring the item back within **[7] days** of pickup or delivery and we will exchange it for another size or another item of the same value, if it is in stock.

To be exchanged, items must be unworn, with the original box, tags and receipt or order number.

## Faulty items

If an item has a fault, WhatsApp us a photo within **[48 hours]** of receiving it. We will repair, replace or refund it.

## Refunds

[We do not give cash refunds for change of mind. Refunds for faulty items or for orders we cannot fill are paid back to the M-Pesa number used, within [3] working days.]

## Not exchangeable

Socks, underwear and items bought on clearance [are final sale].

Start an exchange on WhatsApp: 0740 334 566.',0,2,NOW(),NOW());
INSERT IGNORE INTO `pages` (`slug`,`title`,`body`,`is_published`,`position`,`created_at`,`updated_at`) VALUES ('privacy','Privacy policy','This policy explains how Drip World Limited, trading as Shoeniverse, handles your personal data under Kenya’s Data Protection Act, 2019.

## What we collect

When you order, we collect your name, phone number, email address (if you give it), delivery address and order details. M-Pesa sends us the payment confirmation for your order.

## Why we use it

To process and deliver your order, confirm payment, contact you on WhatsApp or by phone about your order, and handle exchanges. We send marketing messages only if you ask for them, for example by joining our drop alerts, and you can stop them at any time.

## Who we share it with

Only with the services needed to complete your order: Safaricom for M-Pesa payments, the delivery service carrying your order, and our website host. We do not sell your data.

## How long we keep it

Order records are kept for [5] years for tax purposes. You can ask us to delete other information sooner.

## Your rights

You can ask to see, correct or delete your personal data, or object to how we use it. Email [shoeniverse.ke@gmail.com] or WhatsApp 0740 334 566.',0,3,NOW(),NOW());
INSERT IGNORE INTO `pages` (`slug`,`title`,`body`,`is_published`,`position`,`created_at`,`updated_at`) VALUES ('terms','Terms of sale','These terms apply to orders placed on this website with Drip World Limited, trading as Shoeniverse, Dubai Merchant Mall, Shop F46, Nairobi.

## Prices and stock

Prices are in Kenya shillings and include VAT where it applies. Items marked “Ask for price” are priced on WhatsApp before you buy. Stock is shared with our shop, so an item can sell out after you order. If it does, we offer another size or item, or refund you in full.

## Your order

Your order is confirmed when payment is received, or, for pay-at-pickup orders, when we confirm it on WhatsApp. Orders not paid or collected within [3] days may be cancelled.

## Delivery, pickup and exchanges

See [Delivery & pickup](/help/delivery) and [Returns & exchanges](/help/returns).

## Contact

WhatsApp or call 0740 334 566, or email [shoeniverse.ke@gmail.com].',0,4,NOW(),NOW());

INSERT INTO `migrations` (`migration`,`batch`)
SELECT n.migration, n.batch FROM (SELECT '2026_11_14_000100_create_pages_table' AS migration, COALESCE(MAX(`batch`),0)+1 AS batch FROM `migrations`) n
WHERE NOT EXISTS (SELECT 1 FROM (SELECT `migration` FROM `migrations`) m WHERE m.`migration` = n.migration);
