(22726,'yo','Guarantee_Period','Akoko Idaniloju',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22727,'yo','OpeningStock','Iṣura Ibẹrẹ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22728,'yo','Warranty_Guarantee_Tracking','Titele Atilẹyin & Idaniloju',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22729,'yo','PaymentOption','Aṣayan Isanwo',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22730,'yo','AddAnotherPaymentOption','Fi Aṣayan Isanwo Mii kun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22731,'yo','PopularTendered','Owo ti o wọpọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22732,'yo','clear','Ko',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22733,'yo','Pay','San',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22734,'yo','Payment','Isanwo',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22735,'yo','TotalPaidExceedsGrandTotalForMultiPayment','Iye ti a san ju apapọ lapapọ lọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22736,'yo','TotalPaying','Lapapọ Ti n San',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22737,'yo','ChangeReturn','Iyokù',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22738,'yo','AmountPaying','Iye ti a n san',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22739,'yo','Appearance_Settings','Eto Iboju',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22740,'yo','app_name','Orukọ App',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22741,'yo','page_title_suffix','Asẹ oju-iwe',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22742,'yo','ChangeFavicon','Yi Favicon pada',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22743,'yo','Languages','Awọn Ede',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22744,'yo','Translations','Itumọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22745,'yo','Translations for','Itumọ fun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22746,'yo','Back','Pada',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22747,'yo','Save All Changes','Fipamọ Gbogbo Awọn Ayipada',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22748,'yo','Add New','Fi Tuntun kun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22749,'yo','Add New Translation','Fi Itumọ Tuntun kun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22750,'yo','Save','Fipamọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22751,'yo','Delete','Paarẹ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22752,'yo','Showing','Nfi han',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22753,'yo','Translation added','Itumọ ti fi kun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22754,'yo','Failed to add translation','Ko le fi itumọ kun',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22755,'yo','Translation updated','Itumọ ti ni imudojuiwọn',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22756,'yo','Failed to update','Ko le ṣe imudojuiwọn',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22757,'yo','No changes to save','Ko si ayipada lati fipamọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22758,'yo','Notice','Ikilọ',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22759,'yo','All changes saved successfully','Gbogbo ayipada ti fipamọ ni aṣeyọri',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22760,'yo','Bulk save failed','Fipamọ lọpọ kọja',0,'2025-06-18 01:52:27.000000','2025-06-18 01:52:27.000000'),(22761,'yo','Please reload the page after saving translations to apply the changes.','Jọwọ tun oju-iwe naa ṣe lẹẹkansi lẹhin fipamọ itumọ lati lo awọn ayipada.',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22762,'yo','Action_Blocked','Iṣe ti dina',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22763,'yo','You_cannot_delete_the_default_language','O ko le paarẹ ede aiyipada',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22764,'yo','Flag','Aami ilẹ̀',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22765,'yo','Locale','Akọtọ ede',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22766,'yo','Update Language','Imudojuiwọn Ede',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22767,'yo','Add Language','Fi Ede kun',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22768,'yo','Send_Email','Firanṣẹ Imeeli',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22769,'yo','Send_SMS','Firanṣẹ SMS',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22770,'yo','total_sales','Apapọ Tita',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22771,'yo','Opening_Stock','Iṣura Ibẹrẹ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22772,'yo','Subscription_Product','Ọja Iforukọsilẹ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22773,'yo','Subscriptions','Iforukọsilẹ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22774,'yo','Billing_Cycle','Iyipo Isanwo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22775,'yo','total_cycles','Apapọ Awọn Iyipo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22776,'yo','remaining_cycles','Awọn Iyipo To Ku',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22777,'yo','next_billing_date','Ọjọ Isanwo Tó Kàn',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22778,'yo','Failed_to_update_subscription_status','Ṣiṣeeṣe lati ṣe imudojuiwọn ipo iforukọsilẹ kuna',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22779,'yo','Subscription_status_updated_successfully','Ipo iforukọsilẹ ti ni imudojuiwọn ni aṣeyọri',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22780,'yo','Create_Susbscription','Ṣẹda Iforukọsilẹ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22781,'yo','Price_Per_Cycle','Iye fun Kọọkan Iyipo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22782,'yo','Price_Per_Unit','Iye fun Ẹyọkan',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22783,'yo','Active','Nṣiṣe lọwọ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22784,'yo','Canceled','Ti Fagile',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22785,'yo','Completed','Ti Pari',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22786,'yo','Subscription_details','Alaye Iforukọsilẹ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22787,'yo','Dynamic_Appearance','Ìfarahan Aláyọ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22788,'yo','Payment_Methods','Ọna Isanwo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22789,'yo','You_cant_edit_or_remove_default_payment_choices','O ko le ṣe atunṣe tabi yọ awọn aṣayan isanwo aiyipada kuro',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22790,'yo','Enter_Payment_Method','Tẹ Ọna Isanwo sii',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22791,'yo','Sales_by_Category','Tita gẹgẹ bí Ẹ̀ka',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22792,'yo','Sales_by_Brand','Tita gẹgẹ bí Ami',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22793,'yo','Error_Logs','Ìkọ̀wé Àṣìṣe',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22794,'yo','Occurred_At','Ó ṣẹlẹ̀ ní',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22795,'yo','Context','Akopọ',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22796,'yo','Report_Transactions','Jabọ Awọn Iṣowo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22797,'yo','Payment_Method','Ọna Isanwo',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22798,'yo','Customer_Provider','Onibara/Olupese',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000'),(22799,'yo','Sale_Purchase_Ref','Ìtọ́kasí Tita/Ra',0,'2025-06-18 01:52:28.000000','2025-06-18 01:52:28.000000');

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(192) NOT NULL,
  `ShortName` varchar(192) NOT NULL,
  `base_unit` int(11) DEFAULT NULL,
  `operator` char(192) DEFAULT '*',
  `operator_value` double DEFAULT '1',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `base_unit` (`base_unit`),
  CONSTRAINT `base_unit` FOREIGN KEY (`base_unit`) REFERENCES `units` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `units`
--


--
-- Table structure for table `user_warehouse`
--

CREATE TABLE `user_warehouse` (
  `user_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  KEY `user_warehouse_user_id` (`user_id`),
  KEY `user_warehouse_warehouse_id` (`warehouse_id`),
  CONSTRAINT `user_warehouse_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `user_warehouse_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_warehouse`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(191) NOT NULL,
  `lastname` varchar(191) NOT NULL,
  `username` varchar(192) NOT NULL,
  `email` varchar(192) NOT NULL,
  `password` varchar(191) NOT NULL,
  `avatar` varchar(191) DEFAULT NULL,
  `phone` varchar(192) NOT NULL,
  `role_id` int(11) NOT NULL,
  `statut` tinyint(1) NOT NULL DEFAULT '1',
  `is_all_warehouses` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'William','Castillo','William Castillo','admin@example.com','$2y$10$IFj6SwqC0Sxrsiv4YkCt.OJv1UV4mZrWuyLoRG7qt47mseP9mJ58u','no_avatar.png','0123456789',1,1,1,NULL,NULL,NULL),(2,'alislamiah','pos','admin','info@alislamiah.com','$2y$10$aVcD3tp2uptbOm26WygiT.ACikz3XCEvf.xMZDG5V8DB5QmYnlxCa','no_avatar.png','01515262987',2,1,1,'2025-06-18 16:30:08.000000','2025-06-18 16:30:08.000000',NULL);

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(192) NOT NULL,
  `city` varchar(192) DEFAULT NULL,
  `mobile` varchar(192) DEFAULT NULL,
  `zip` varchar(192) DEFAULT NULL,
  `email` varchar(192) DEFAULT NULL,
  `country` varchar(192) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` VALUES (1,'Default Warehouse',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


