-- ============================================================================
-- QuickCatalog — Required Default Data
-- ----------------------------------------------------------------------------
-- The base schema (base-schema-raw.sql) only contains table STRUCTURE, no
-- rows. But this application isn't fully "empty-state safe" — a handful of
-- tables need at least one row to exist before the app will even load
-- correctly. This file provides exactly that minimum, nothing more.
--
-- CONFIRMED REQUIRED (tested against a real fresh-schema database):
--   `setting` — the whole app reads "SELECT * FROM setting WHERE id=1"
--                on nearly every page. Without this row, most pages error.
--   `stock`   — the admin product form's Stock Status dropdown reads its
--                options from this table. Without rows here, admins can
--                only ever set "In Stock" (which needs no row at all —
--                it's the default when stock_status is NULL/0).
--
-- StoreProvisioner's seed_settings step runs AFTER this file and overwrites
-- brand_name/contact_email with the real store owner's details — the
-- placeholder values below only need to satisfy NOT NULL constraints for
-- the brief moment before that happens.
-- ============================================================================

INSERT INTO `setting`
    (`id`, `brand_name`, `description`, `address`, `city`, `country`, `pincode`,
     `phone_num`, `company_profile`, `universal_button`, `instagram_icon`, `tax`)
VALUES
    (1, 'My Store', 'Welcome to my store', '', '', 'India', '',
     '', '', '', '', '');

INSERT INTO `stock` (`id`, `short_code`, `label`) VALUES
    (1, 'out_of_stock', 'Out Of Stock'),
    (2, 'limited_stock', 'Limited Stock');