





CREATE TABLE `site_statistics` (
  `id` int(11) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `country` varchar(100) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `referer` text DEFAULT NULL,
  `search_query` varchar(500) DEFAULT NULL,
  `page_url` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `stat_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

