SWAMPy

✎ CARVE FLESH

EDITING: seeds.sql

-- Flora and Creations — Seed Data
-- Run AFTER schema.sql has been executed.
-- Passwords are placeholder bcrypt hashes; change the admin password on first login.

SET NAMES utf8mb4;

-- ──────────────────────────────────────────────────────────────
-- Delivery Zones
-- ──────────────────────────────────────────────────────────────
INSERT INTO delivery_zones (area_name, fee) VALUES
    ('Jahi', 3000),
    ('Jabi', 3000),
    ('Utako', 3000),
    ('Wuye', 3000),
    ('Gwarimpa', 3000),
    ('Katampe', 3000),
    ('Central Area', 3000),
    ('Wuse', 4000),
    ('Garki', 4000),
    ('Mpape', 4000),
    ('Kaura', 4000),
    ('Life Camp', 4000),
    ('Asokoro', 5000),
    ('Guzape', 5000),
    ('Kubwa', 5000),
    ('Dawaki', 5000),
    ('Aso', 5000),
    ('Gudu', 6000),
    ('Kabusa', 6000),
    ('Apo', 6000),
    ('Lokogoma', 6000),
    ('Lugbe', 6000),
    ('Airport Junction', 6000);

-- ──────────────────────────────────────────────────────────────
-- Categories — Product Types
-- ──────────────────────────────────────────────────────────────
INSERT INTO categories (name, type, slug) VALUES
    ('Bouquets',        'product_type', 'bouquets'),
    ('Teddy Bears',     'product_type', 'teddy-bears'),
    ('Fruit Wine',      'product_type', 'fruit-wine'),
    ('Chocolates',      'product_type', 'chocolates'),
    ('Vases',           'product_type', 'vases'),
    ('Picture Frames',  'product_type', 'picture-frames'),
    ('Cards',           'product_type', 'cards'),
    ('Cookies',         'product_type', 'cookies'),
    ('Cakes',           'product_type', 'cakes');

-- ──────────────────────────────────────────────────────────────
-- Categories — Occasions
-- ──────────────────────────────────────────────────────────────
INSERT INTO categories (name, type, slug) VALUES
    ('Birthday',         'occasion', 'birthday'),
    ('Anniversary',      'occasion', 'anniversary'),
    ('Event Table Flowers','occasion','event-table-flowers'),
    ('Sympathy',         'occasion', 'sympathy'),
    ('Congratulatory',   'occasion', 'congratulatory'),
    ('Proposal',         'occasion', 'proposal'),
    ('Picnic',           'occasion', 'picnic');

-- ──────────────────────────────────────────────────────────────
-- Add-Ons
-- ──────────────────────────────────────────────────────────────
INSERT INTO add_ons (name, price, type, active) VALUES
    ('Fruit Wine',      5000,  'default',    1),
    ('Gift Card',       1000,  'gift_card',  1),
    ('Teddy Bear',      8000,  'default',    1),
    ('Chocolates',      4000,  'default',    1),
    ('Cookies',         3000,  'default',    1),
    ('Cake',            12000, 'default',    1),
    ('Vase Upgrade',    2000,  'default',    1);

-- ──────────────────────────────────────────────────────────────
-- Admin User (password hash = bcrypt of "Admin@1234")
-- ──────────────────────────────────────────────────────────────
INSERT INTO users (name, email, phone, password_hash, role) VALUES
    ('Admin', 'admin@floracreations.com', '07031677165', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin');

-- ──────────────────────────────────────────────────────────────
-- Settings
-- ──────────────────────────────────────────────────────────────
INSERT INTO settings (setting_key, setting_value, group_name) VALUES
    ('bank_account_name',  'Flora and Creations Ltd',      'bank_details'),
    ('bank_name',          'Zenith Bank',                  'bank_details'),
    ('bank_account_number','0123456789',                   'bank_details'),
    ('phone_whatsapp_1',   '07031677165',                  'contact'),
    ('phone_whatsapp_2',   '08037033240',                  'contact'),
    ('business_address',   'Wuse Zone 5, Abuja, Nigeria',  'contact'),
    ('facebook_url',       'https://facebook.com/floracreations',  'social'),
    ('instagram_url',      'https://instagram.com/floracreations','social'),
    ('whatsapp_number',    '2347031677165',                'contact'),
    ('min_order_days',     '1',                            'order_settings'),
    ('max_order_days',     '14',                           'order_settings');

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📁 migrations/	DIR	—	2026-07-15 09:38
📄 schema.sql	SQL	18.1 KB	2026-07-15 09:17	EDIT
📄 seeds.sql	SQL	5.5 KB	2026-07-15 09:17	EDIT