SQLite format 3   @    ¤   #   "                                                       ¤ .zq   û    û                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Ñ Ö¬ƒGÑ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             D �	2026_09_04_000003_make_product_id_nullable_in_sale_items_table. a	2026_09_04_000002_create_pos_system_tables: y	2026_09_04_000001_add_role_and_username_to_users_table' S	0001_01_01_000002_create_jobs_table( U	0001_01_01_000001_create_cache_table( U	0001_01_01_000000_create_users_table® £ ðåÕÇ£·—                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             	sales   	     !sale_items products!categories	users!migrations   ü B˜ü                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              � ' � 33!	Abasi Gaogao@gmail.com$2y$12$zy7TjA6LVQmgrbE8l/GA6eVR5/nsTR3iRtNaR5q5Q45N8193YIBFW2026-09-04 12:04:082026-09-04 12:04:08abasiuser0782989712�' // � 33!	Muuzaji (Cashier)cashier@mauzo.com$2y$12$4XfTbA2/2tfa5NCp7X/vTeRwqRccm70Ul2FPeCJCBhaTb9PYPS/Da2026-09-04 11:43:172026-09-04 11:43:17cashieruser0787654321�; ?5 � 33!!!	Meneja Mkuu (Super Admin)superadmin@mauzo.com$2y$12$LZl.68R97kxD2KlNGSMl0.3sbLg4ShMwbFNYnRnDAxARymxqagwH62026-09-04 11:43:172026-09-04 11:43:17superadminsuperadmin0712345678
   À ÒÀè                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  'gao@gmail.com/cashier@mauzo.com5	superadmin@mauzo.com                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 . .                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ƒO	]	�W„eGaAkoiXKnaphccT1XdC0PW2lx2ev9oYL1yq23ScS127.0.0.1Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36eyJfdG9rZW4iOiI0MExTRklnbkRWaThyYUlZT0w0VmFScVBYbktMOFhDbWl4dmZiNll1IiwiX2ZsYXNoIjp7Im5ldyI6W10sIm9sZCI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL3Bvc1wvcmVjZWlwdFwvMTgiLCJyb3V0ZSI6InBvcy5yZWNlaXB0In0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjoxfQ==jšìÛ
   Ô Ô                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          +]	GaAkoiXKnaphccT1XdC0PW2lx2ev9oYL1yq23ScS
   ü ü                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  		
   ø ø                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	jšìÛ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
   Ü Üæò                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              	abasicashier!	superadmin   © † š©                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       t +'c33Dawa & Vipodozidawa-vipodoziBidhaa za urembo na mahitaji madogo ya afya2026-09-04 11:43:182026-09-04 11:43:18y ++i33Vifaa vya Usafivifaa-vya-usafiSabuni, shampoo na vifaa vya usafi wa nyumbani2026-09-04 11:43:182026-09-04 11:43:18d [33VinywajivinywajiMaji ya chupa, soda na juisi mbalimbali2026-09-04 11:43:172026-09-04 11:43:17� -)}33Vyakula & Nafakavyakula-nafakaNafaka na vyakula mbalimbali kama unga, mchele na sukari2026-09-04 11:43:172026-09-04 11:43:17x )%o33Mayai & Mifugomayai-mifugoUzalishaji na uuzaji wa mayai na vifaa vya mifugo2026-09-04 11:43:172026-09-04 11:43:17
   ª ªð¼ÐÝ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        'dawa-vipodozi+vifaa-vya-usafivinywaji)vyakula-nafaka%	mayai-mifugo^ Î YÎ8,í!ûµ7
z
	3	Ú²®Yö¿ŽÖ^› ë w o                                                                                                                                                                                                                                                                                                                                                                                                                ƒ…ytableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "username" varchar, "role" varchar not null default 'user', "phone" varchar, "is_active" tinyint(1) not null default '1')› x                                                                                                                    �5e#�oindexfailed_jobs_connection_queue_failed_at_indexfailed_jobsCREATE INDEX "failed_jobs_connection_queue_failed_at_index" on "failed_jobs" ("connection", "queue", "failed_at")‚.##„#tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" varchar not null, "queue" varchar not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)5I# indexsqlite_autoindex_job_batches_1job_batches‚`##…tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))S-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")‚ƒetablejobsjobsCREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)E#�#indexcache_locks_expiration_indexcache_locksCREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration")�$##‚tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I# indexsqlite_autoindex_cache_locks_1cache_locksg9�indexcache_expiration_indexcacheCREATE INDEX "cache_expiration_index" on "cache" ("expiration")��}tablecachecacheCREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key")))= indexsqlite_autoindex_cache_1cache|
E�#indexsessions_last_activity_indexsessionsCREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j	9�indexsessions_user_id_indexsessions
CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�WƒtablesessionssessionsCREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/C indexsqlite_autoindex_sessions_1sessions	�>77‚tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokensa1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")   l                                                                                                        P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!‚tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null)X 		­Mï�/Ïk¬Fè˜                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       M 33sukari1234567	Ä¸ Èactive2026-09-04 12:31:532026-09-04 14:16:13   @                                                            N 33mchele98888975"Ä.à Æactive2026-09-04 13:57:382026-09-04 14:22:10\ 533Maziwa ya Asas 500ml20260010x È
active2026-09-04 13:35:582026-09-04 14:16:13d E33Dawa ya Mswaki Colgate 100ml20260009	Ä¬ ¿active2026-09-04 13:35:582026-09-04 16:06:59Z 133Sabuni ya Omo 500g20260008˜
ð È
active2026-09-04 13:35:582026-09-04 14:16:13a ?33Maji ya Kunywa Uhai 500ml20260007^X Çactive2026-09-04 13:35:582026-09-04 16:06:59b A33Mafuta ya Kupikia Korie 1L20260006Pd Åactive2026-09-04 13:35:582026-09-04 16:06:59^ 933Unga wa Ngano Azam 2kg20260005Ø” Â
active2026-09-04 13:35:582026-09-04 14:49:37^ 933Mchele Super Kyela 1kg20260004	Ä€ Å
active2026-09-04 13:35:582026-09-04 14:22:10^ 933Sukari 1kg (Kilombero)20260003
ðH Èactive2026-09-04 13:35:582026-09-04 14:16:13\ 	733Tray ya Mayai (Kubwa)20260002%.à Èactive2026-09-04 13:35:582026-09-04 14:16:13^ 	;33Tray ya Mayai (Kawaida)20260001@' È
active2026-09-04 13:35:582026-09-04 14:16:13P 33cocacola89766454ôX Äactive2026-09-04 12:32:592026-09-04 14:49:37 ( 	B °D
a	íãnÀB¦Ž                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |C�+indexsales_invoice_number_uniquesales!CREATE UNIQUE INDEX "sales_invoice_number_unique" on "sales" ("invoice_number")…+Š5tablesalessales CREATE TABLE "sales" ("id" integer primary key autoincrement not null, "invoice_number" varchar not null, "user_id" integer not null, "customer_name" varchar, "customer_phone" varchar, "subtotal" numeric not null default '0', "tax_amount" numeric not null default '0', "discount_amount" numeric not null default '0', "total_amount" numeric not null default '0', "paid_amount" numeric not null default '0', "change_amount" numeric not null default '0', "payment_method" varchar not null default 'cash', "payment_status" varchar not null default 'paid', "notes" text, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id"))s;�indexproducts_barcode_uniqueproductsCREATE UNIQUE INDEX "products_barcode_unique" on "products" ("barcode")„‡atableproductsproductsCREATE TABLE "products" ("id" integer primary key autoincrement not null, "category_id" integer, "name" varchar not null, "barcode" varchar, "cost_price" numeric not null default '0', "selling_price" numeric not null default '0', "stock_quantity" integer not null default '0', "alert_quantity" integer not null default '5', "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, foreign key("category_id") references "categories"("id") on delete set null)r9!�indexcategories_slug_uniquecategoriesCREATE UNIQUE INDEX "categories_slug_unique" on "categories" ("slug")�`!!ƒtablecategoriescategoriesCREATE TABLE "categories" ("id" integer primary key autoincrement not null, "name" varchar not null, "slug" varchar not null, "description" text, "created_at" datetime, "updated_at" datetime)j7�indexusers_username_uniqueusersCREATE UNIQUE INDEX "users_username_unique" on "users" ("username")v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")  ~                                                                                                                                                                                                                                                                                                                                                                                          „W !!ˆytablesale_itemssale_items#CREATE TABLE "sale_items" ("id" integer primary key autoincrement not null, "sale_id" integer not null, "product_id" integer, "product_name" varchar not null, "quantity" integer not null, "cost_price" numeric not null default ('0'), "unit_price" numeric not null default ('0'), "subtotal" numeric not null default ('0'), "profit" numeric not null default ('0'), "created_at" datetime, "updated_at" datetime, foreign key("sale_id") references sales("id") on delete cascade on update no action, foreign key("product_id") references "products"("id") on delete set null)
   X ôÚÍÀ³¦™ŒreçX                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      9888897520260010202600092026000820260007202600062026000520260004202600032026000220260001897664541234567   	� §Oó•9Ý�%Ék³W
û
 
?	å	�                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 V /	   33INV-20260904-0018777cashpaid2026-09-04 16:06:592026-09-04 16:06:59X /   33INV-20260904-00176°6°6°mpesapaid2026-09-04 16:03:552026-09-04 16:03:55_ /	  33INV-20260904-0016shabany>Ð6L6Lcashpaid2026-09-04 14:49:372026-09-04 14:49:37Y /   33INV-20260904-0015[ÌèWäWäcashpaid2026-09-04 14:24:372026-09-04 14:24:37Z /   33INV-20260904-0014 ·ü ·ü ·ücashpaid2026-09-04 14:22:102026-09-04 14:22:10Z /   33INV-20260904-0013``]Àcashpartial2026-09-04 14:08:342026-09-04 14:08:34] /   33INV-20260904-0012 ‘P ‘P „Ðcashpartial2026-09-04 14:06:282026-09-04 14:06:28W /   33INV-20260904-0011pppcashpaid2026-09-04 14:03:442026-09-04 14:03:44\
 /   33INV-20260904-0010pô||cashpaid2026-09-04 14:02:012026-09-04 14:02:01Z	 /   33INV-20260904-0009H H H cashpaid2026-09-04 13:59:522026-09-04 13:59:52Z /   33INV-20260904-0008FPFP”cashpartial2026-09-04 13:54:342026-09-04 13:54:34Z /   33INV-20260904-0007ppôcashpartial2026-09-04 13:50:572026-09-04 13:50:57Z /   33INV-20260904-0006.à.à¸cashpartial2026-09-04 13:49:402026-09-04 13:49:40Z /   33INV-20260904-0005u0u0¸cashpartial2026-09-04 13:49:012026-09-04 13:49:01\ /   33INV-20260904-0004 À0 À0@cashpartial2026-09-04 13:48:072026-09-04 13:48:07Z /   33INV-20260904-0003d|'”cashpaid2026-09-04 13:44:212026-09-04 13:44:21V /	   33INV-20260904-0002XXXcashpaid2026-09-04 12:37:562026-09-04 12:37:56W /   33INV-20260904-0001¸¸¸cashpaid2026-09-04 12:15:062026-09-04 12:15:06
   u ëÕ¿©“}gQ;%ùãÍ·¡‹u                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         /INV-20260904-0018/INV-20260904-0017/INV-20260904-0016/INV-20260904-0015/INV-20260904-0014/INV-20260904-0013/INV-20260904-0012/INV-20260904-0011/INV-20260904-0010
/INV-20260904-0009	/INV-20260904-0008/INV-20260904-0007/INV-20260904-0006/INV-20260904-0005/INV-20260904-0004/INV-20260904-0003/INV-20260904-0002/	INV-20260904-0001                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    È ¾y&Ò�H«V»`°\
¯
Y
	±	l	'Ò}"Ét-ÒwÈ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                U  ?	33Maji ya Kunywa Uhai 500ml^XX ú2026-09-04 16:06:592026-09-04 16:06:59V A	33Mafuta ya Kupikia Korie 1LPdd2026-09-04 16:06:592026-09-04 16:06:59Y E33Dawa ya Mswaki Colgate 100ml	Ä¬XÐ2026-09-04 16:06:592026-09-04 16:06:59Y E33Dawa ya Mswaki Colgate 100ml	Ä¬6° 2026-09-04 16:03:552026-09-04 16:03:55E 33cocacolaôX	`�2026-09-04 14:49:372026-09-04 14:49:37S 933Unga wa Ngano Azam 2kgØ”4¼42026-09-04 14:49:372026-09-04 14:49:37W A33Mafuta ya Kupikia Korie 1LPd2È
(2026-09-04 14:24:372026-09-04 14:24:37Y E33Dawa ya Mswaki Colgate 100ml	Ä¬)¸2026-09-04 14:24:372026-09-04 14:24:37S 933Unga wa Ngano Azam 2kgØ”4¼42026-09-04 14:22:102026-09-04 14:22:10S 933Mchele Super Kyela 1kg	Ä€%€42026-09-04 14:22:102026-09-04 14:22:10C 33mchele"Ä.à]À82026-09-04 14:22:102026-09-04 14:22:10C 	33cocacolaôXXd2026-09-04 14:08:342026-09-04 14:08:34R 733Tray ya Mayai (Kubwa)%.à]Àˆ2026-09-04 14:08:342026-09-04 14:08:34R 9	33Mchele Super Kyela 1kg	Ä€€¼2026-09-04 14:06:282026-09-04 14:06:28T 933Sukari 1kg (Kilombero)

ðH „Ðp2026-09-04 14:06:282026-09-04 14:06:28V ?33Maji ya Kunywa Uhai 500ml
^Xp	Ä2026-09-04 14:03:442026-09-04 14:03:44S ;	33
Tray ya Mayai (Kawaida)@''Ð2026-09-04 14:02:012026-09-04 14:02:01R 9	33
Sukari 1kg (Kilombero)
ðHHX2026-09-04 14:02:012026-09-04 14:02:01U ?	33
Maji ya Kunywa Uhai 500ml^XX ú2026-09-04 14:02:012026-09-04 14:02:01W A33
Mafuta ya Kupikia Korie 1LPd2È
(2026-09-04 14:02:012026-09-04 14:02:01Y E33
Dawa ya Mswaki Colgate 100ml	Ä¬XÐ2026-09-04 14:02:012026-09-04 14:02:01S 733
Tray ya Mayai (Kubwa)%.à Œ L2026-09-04 14:02:012026-09-04 14:02:01D
 33	mchele"Ä.àH TÄ2026-09-04 13:59:522026-09-04 13:59:52S	 933Unga wa Ngano Azam 2kgØ”FP
ð2026-09-04 13:54:342026-09-04 13:54:34V ?33Maji ya Kunywa Uhai 500ml
^Xp	Ä2026-09-04 13:50:572026-09-04 13:50:57C 33sukari	Ä¸.àÐ2026-09-04 13:49:402026-09-04 13:49:40C 33sukari
	Ä¸u0ˆ2026-09-04 13:49:012026-09-04 13:49:01C 	33cocacolaôXXd2026-09-04 13:48:072026-09-04 13:48:07R 533Maziwa ya Asas 500mlx ½Ø*02026-09-04 13:48:072026-09-04 13:48:07Q 533Maziwa ya Asas 500mlx°2026-09-04 13:44:212026-09-04 13:44:21C 	33cocacolaôXXd2026-09-04 12:37:562026-09-04 12:37:56@ 	 	33sukariÐ¸¸è2026-09-04 12:15:062026-09-04 12:30:06