USE TESVISCOVENTURES;

CREATE TABLE IF NOT EXISTS static_pages (
  id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  slug VARCHAR(120) NOT NULL UNIQUE,
  title VARCHAR(200) NOT NULL,
  body_html LONGTEXT NOT NULL,
  meta_title VARCHAR(200) NOT NULL DEFAULT '',
  meta_description VARCHAR(300) NOT NULL DEFAULT '',
  is_published TINYINT(1) NOT NULL DEFAULT 1,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS banners (
  id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(120) NOT NULL,
  image_path VARCHAR(255) NOT NULL DEFAULT '',
  link_url VARCHAR(500) NOT NULL DEFAULT '',
  position ENUM('hero','promo','banner','strip') NOT NULL DEFAULT 'hero',
  headline VARCHAR(200) NOT NULL DEFAULT '',
  subheadline VARCHAR(200) NOT NULL DEFAULT '',
  cta_text VARCHAR(80) NOT NULL DEFAULT '',
  sort_order INT NOT NULL DEFAULT 0,
  is_active TINYINT(1) NOT NULL DEFAULT 1,
  starts_at DATETIME NULL,
  ends_at DATETIME NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO static_pages (slug, title, body_html, is_published) VALUES
('about', 'About Us', '<p>We are Elroi Foods.</p>', 1),
('contact', 'Contact Us', '<p>Email: support@elroifoods.example</p>', 1),
('privacy', 'Privacy Policy', '<p>Your privacy matters.</p>', 1),
('terms', 'Terms of Service', '<p>Terms of service.</p>', 1),
('shipping', 'Shipping Policy', '<p>Shipping info.</p>', 1),
('returns', 'Returns Policy', '<p>Returns info.</p>', 1);