--
-- Host: localhost    Database: finarheg_monieroar
-- ------------------------------------------------------


--
-- Current Database: `finarheg_monieroar`
--


--
-- Table structure for table `adverts`
--

CREATE TABLE `adverts` (
  `id` char(36) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `shortcode` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `adverts`
--


--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` char(36) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `tags` text NOT NULL,
  `author_id` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `visits` int(11) NOT NULL,
  `unique_visits` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `published_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` char(36) NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `symbol` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `symbol`, `name`, `status`, `created_at`, `updated_at`) VALUES (1,'AED','United Arab Emirates Dirham','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(2,'AFN','Afghan Afghani','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(3,'ALL','Albanian Lek','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(4,'AMD','Armenian Dram','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(5,'ANG','Netherlands Antillean Guilder','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(6,'AOA','Angolan Kwanza','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(7,'ARS','Argentine Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(8,'AUD','Australian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(9,'AWG','Aruban Florin','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(10,'AZN','Azerbaijani Manat','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(11,'BAM','Bosnia-Herzegovina Convertible Mark','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(12,'BBD','Barbadian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(13,'BDT','Bangladeshi Taka','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(14,'BGN','Bulgarian Lev','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(15,'BHD','Bahraini Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(16,'BIF','Burundian Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(17,'BMD','Bermudan Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(18,'BND','Brunei Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(19,'BOB','Bolivian Boliviano','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(20,'BRL','Brazilian Real','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(21,'BSD','Bahamian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(22,'BTC','Bitcoin','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(23,'BTN','Bhutanese Ngultrum','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(24,'BWP','Botswanan Pula','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(25,'BYN','New Belarusian Ruble','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(26,'BYR','Belarusian Ruble','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(27,'BZD','Belize Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(28,'CAD','Canadian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(29,'CDF','Congolese Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(30,'CHF','Swiss Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(31,'CLF','Chilean Unit of Account (UF)','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(32,'CLP','Chilean Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(33,'CNY','Chinese Yuan','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(34,'COP','Colombian Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(35,'CRC','Costa Rican Colón','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(36,'CUC','Cuban Convertible Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(37,'CUP','Cuban Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(38,'CVE','Cape Verdean Escudo','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(39,'CZK','Czech Republic Koruna','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(40,'DJF','Djiboutian Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(41,'DKK','Danish Krone','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(42,'DOP','Dominican Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(43,'DZD','Algerian Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(44,'EGP','Egyptian Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(45,'ERN','Eritrean Nakfa','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(46,'ETB','Ethiopian Birr','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(47,'EUR','Euro','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(48,'FJD','Fijian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(49,'FKP','Falkland Islands Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(50,'GBP','British Pound Sterling','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(51,'GEL','Georgian Lari','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(52,'GGP','Guernsey Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(53,'GHS','Ghanaian Cedi','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(54,'GIP','Gibraltar Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(55,'GMD','Gambian Dalasi','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(56,'GNF','Guinean Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(57,'GTQ','Guatemalan Quetzal','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(58,'GYD','Guyanaese Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(59,'HKD','Hong Kong Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(60,'HNL','Honduran Lempira','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(61,'HRK','Croatian Kuna','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(62,'HTG','Haitian Gourde','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(63,'HUF','Hungarian Forint','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(64,'IDR','Indonesian Rupiah','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(65,'ILS','Israeli New Sheqel','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(66,'IMP','Manx pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(67,'INR','Indian Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(68,'IQD','Iraqi Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(69,'IRR','Iranian Rial','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(70,'ISK','Icelandic Króna','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(71,'JEP','Jersey Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(72,'JMD','Jamaican Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(73,'JOD','Jordanian Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(74,'JPY','Japanese Yen','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(75,'KES','Kenyan Shilling','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(76,'KGS','Kyrgystani Som','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(77,'KHR','Cambodian Riel','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(78,'KMF','Comorian Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(79,'KPW','North Korean Won','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(80,'KRW','South Korean Won','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(81,'KWD','Kuwaiti Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(82,'KYD','Cayman Islands Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(83,'KZT','Kazakhstani Tenge','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(84,'LAK','Laotian Kip','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(85,'LBP','Lebanese Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(86,'LKR','Sri Lankan Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(87,'LRD','Liberian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(88,'LSL','Lesotho Loti','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(89,'LTL','Lithuanian Litas','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(90,'LVL','Latvian Lats','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(91,'LYD','Libyan Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(92,'MAD','Moroccan Dirham','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(93,'MDL','Moldovan Leu','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(94,'MGA','Malagasy Ariary','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(95,'MKD','Macedonian Denar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(96,'MMK','Myanma Kyat','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(97,'MNT','Mongolian Tugrik','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(98,'MOP','Macanese Pataca','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(99,'MRU','Mauritanian Ouguiya','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(100,'MUR','Mauritian Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(101,'MVR','Maldivian Rufiyaa','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(102,'MWK','Malawian Kwacha','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(103,'MXN','Mexican Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(104,'MYR','Malaysian Ringgit','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(105,'MZN','Mozambican Metical','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(106,'NAD','Namibian Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(107,'NGN','Nigerian Naira','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(108,'NIO','Nicaraguan Córdoba','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(109,'NOK','Norwegian Krone','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(110,'NPR','Nepalese Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(111,'NZD','New Zealand Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(112,'OMR','Omani Rial','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(113,'PAB','Panamanian Balboa','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(114,'PEN','Peruvian Nuevo Sol','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(115,'PGK','Papua New Guinean Kina','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(116,'PHP','Philippine Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(117,'PKR','Pakistani Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(118,'PLN','Polish Zloty','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(119,'PYG','Paraguayan Guarani','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(120,'QAR','Qatari Rial','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(121,'RON','Romanian Leu','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(122,'RSD','Serbian Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(123,'RUB','Russian Ruble','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(124,'RWF','Rwandan Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(125,'SAR','Saudi Riyal','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(126,'SBD','Solomon Islands Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(127,'SCR','Seychellois Rupee','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(128,'SDG','South Sudanese Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(129,'SEK','Swedish Krona','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(130,'SGD','Singapore Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(131,'SHP','Saint Helena Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(132,'SLE','Sierra Leonean Leone','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(133,'SLL','Sierra Leonean Leone','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(134,'SOS','Somali Shilling','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(135,'SRD','Surinamese Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(136,'STD','São Tomé and Príncipe Dobra','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(137,'SVC','Salvadoran Colón','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(138,'SYP','Syrian Pound','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(139,'SZL','Swazi Lilangeni','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(140,'THB','Thai Baht','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(141,'TJS','Tajikistani Somoni','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(142,'TMT','Turkmenistani Manat','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(143,'TND','Tunisian Dinar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(144,'TOP','Tongan Paʻanga','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(145,'TRY','Turkish Lira','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(146,'TTD','Trinidad and Tobago Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(147,'TWD','New Taiwan Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(148,'TZS','Tanzanian Shilling','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(149,'UAH','Ukrainian Hryvnia','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(150,'UGX','Ugandan Shilling','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(151,'USD','United States Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(152,'UYU','Uruguayan Peso','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(153,'UZS','Uzbekistan Som','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(154,'VEF','Venezuelan Bolívar Fuerte','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(155,'VES','Sovereign Bolivar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(156,'VND','Vietnamese Dong','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(157,'VUV','Vanuatu Vatu','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(158,'WST','Samoan Tala','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(159,'XAF','CFA Franc BEAC','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(160,'XAG','Silver (troy ounce)','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(161,'XAU','Gold (troy ounce)','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(162,'XCD','East Caribbean Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(163,'XDR','Special Drawing Rights','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(164,'XOF','CFA Franc BCEAO','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(165,'XPF','CFP Franc','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(166,'YER','Yemeni Rial','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(167,'ZAR','South African Rand','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(168,'ZMK','Zambian Kwacha (pre-2013)','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(169,'ZMW','Zambian Kwacha','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45'),(170,'ZWL','Zimbabwean Dollar','ACTIVE','2024-02-29 15:28:45','2024-02-29 15:28:45');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_02_08_105647_create_blocks_contents_tables',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2021_11_12_153947_remove_blocks_contents_tables',1),(7,'2023_11_14_122412_create_currencies_table',1),(8,'2023_11_14_132507_create_rate_alerts_table',1),(9,'2023_11_17_082742_create_messages_table',1),(10,'2023_12_03_211949_create_blogs_table',1),(11,'2023_12_06_054332_create_settings_table',1),(12,'2023_12_07_205323_create_categories_table',1),(13,'2024_01_10_065251_create_pages_table',1),(14,'2024_01_17_134902_create_products_table',1),(15,'2024_01_17_172921_create_purchases_table',1),(16,'2024_01_31_150850_add_field_to_blogs',1),(17,'2024_02_10_071313_add_field_to_categories',1),(18,'2024_02_14_100304_create_adverts_table',1);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` char(36) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `position` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `buy_price` int(11) NOT NULL,
  `sell_price` int(11) NOT NULL,
  `status` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` char(36) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `amount` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--


--
-- Table structure for table `rate_alerts`
--

CREATE TABLE `rate_alerts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `frequency` varchar(255) NOT NULL,
  `send_marketing_info` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rate_alerts`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` char(36) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `slug`, `name`, `value`, `deleted_at`, `created_at`, `updated_at`) VALUES ('9b73e438-e0d5-40f7-bfb5-69897a30e59c','site_title','Site Title','Monieroar',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e117-489c-855d-ad4c5a615e49','site_logo','Site Logo','/logo.png',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e151-40eb-98e1-12d1995e866c','site_email','Site Email Address','info@monieroar.com',NULL,'2024-02-29 15:28:44','2024-03-19 11:28:08'),('9b73e438-e188-498f-9aa2-aeb3cbef6b8c','contact_address','Contact Address','Suite E-16 C-to-C plaza Nkpokiti, Enugu',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e1bd-4925-a154-d42fcf9fbb21','contact_phone','Contact Phone Number','+234 702 517 3531',NULL,'2024-02-29 15:28:44','2024-03-19 11:18:03'),('9b73e438-e1f2-486a-a036-d6bfd4076e38','whatsapp_phone','Whatsapp Phone Number','2347025173531',NULL,'2024-02-29 15:28:44','2024-03-19 11:18:27'),('9b73e438-e229-43d0-bba8-985a83e838d1','site_video','Youtube Video Link','https://',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e25e-496f-bf4e-356f19ac8a17','seo_description','SEO Description','Get the latest currency conversion rates and financial information on the go.',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e293-4231-9b6e-75bd55ebe04c','description','Description','Get the latest currency conversion rates and financial information on the go.',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e2c6-4f52-926a-835d5a5f886e','seo_tags','SEO Tags','Currency Rates, Currency Updates, Currency COnversion',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e2fa-4a48-8aac-83716c576ede','twitter_link','Twitter URL','https://twitter.com/',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e32d-4ab9-aba7-b3e824f364c8','instagram_link','Instagram URL','https://instagram.com/',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e360-48fc-8043-a7a73aab2108','linkedin_link','LinkedIn URL','https://linkedin.com/in/',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e39c-4734-af9b-14d1e88322f9','facebook_link','Facebook URL','https://facebook.com/',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e3d0-4d7e-b539-ae9b799ba0c8','youtube_link','Youtube URL','https://youtube.com/',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44'),('9b73e438-e402-441b-8534-d04cf4a3976f','header_scripts','Header Scripts','<meta name=\"google-site-verification\" content=\"czM4pbaOY7tMsh4hkZ02ESR6AZsL61YOdn4hJ18wICk\" />',NULL,'2024-02-29 15:28:44','2024-03-30 18:50:56'),('9b73e438-e435-499d-8e0b-fb4e43385c65','footer_scripts','Footer Scripts','',NULL,'2024-02-29 15:28:44','2024-02-29 15:28:44');

--
-- Dumping events for database 'finarheg_monieroar'
--

--
-- Dumping routines for database 'finarheg_monieroar'
--


