-- MySQL dump 10.13  Distrib 5.7.26, for Win64 (x86_64)
--
-- Host: localhost    Database: shop
-- ------------------------------------------------------
-- Server version	5.7.26

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `backups`
--

DROP TABLE IF EXISTS `backups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `backups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bupdate` date DEFAULT NULL,
  `entrydate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backups`
--

LOCK TABLES `backups` WRITE;
/*!40000 ALTER TABLE `backups` DISABLE KEYS */;
INSERT INTO `backups` VALUES (1,'2019-09-19','2019-09-19 13:23:01'),(2,'2019-09-20','2019-09-20 08:19:13');
/*!40000 ALTER TABLE `backups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `business_settings`
--

DROP TABLE IF EXISTS `business_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_settings` (
  `name` varchar(100) DEFAULT NULL,
  `contact` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business_settings`
--

LOCK TABLES `business_settings` WRITE;
/*!40000 ALTER TABLE `business_settings` DISABLE KEYS */;
INSERT INTO `business_settings` VALUES ('Edson Enterprises Limited','0774362710','Info@edsonenterpises.info','Kyanja',1);
/*!40000 ALTER TABLE `business_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `developer`
--

DROP TABLE IF EXISTS `developer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `developer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `developer_name` varchar(255) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `developer`
--

LOCK TABLES `developer` WRITE;
/*!40000 ALTER TABLE `developer` DISABLE KEYS */;
INSERT INTO `developer` VALUES (1,'Nugsoft Technologies Limited','+265 777844758','ceo@nugsoft.com');
/*!40000 ALTER TABLE `developer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_categories`
--

DROP TABLE IF EXISTS `expense_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryName` varchar(100) DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `date_created` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category Name` (`categoryName`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_categories`
--

LOCK TABLES `expense_categories` WRITE;
/*!40000 ALTER TABLE `expense_categories` DISABLE KEYS */;
INSERT INTO `expense_categories` VALUES (1,'Furniture','1','2019/09/09'),(2,'Food','1','2019/09/09'),(3,'Utilities','1','2019/09/09'),(4,'Salaries','1','2019/09/09'),(5,'transport','1','2019/09/09'),(7,'airtime','1','2019/09/09');
/*!40000 ALTER TABLE `expense_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `expense_by` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `date_created` varchar(100) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
INSERT INTO `expenses` VALUES (1,3,'paid electricity bill',5000,1,'2019-09-09','2019-09-09 08:50:00am',1),(2,2,'edson bough lunch',2000,1,'2019-09-09','2019-09-09 08:53:11am',1),(3,1,'bought chairs',20000,2,'2019-09-09','2019-09-09 08:54:31am',1),(4,3,'Paid water bill',4000,3,'2019-09-09','2019-09-09 08:58:28am',1);
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `getstock`
--

DROP TABLE IF EXISTS `getstock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `getstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unitprice` int(11) DEFAULT NULL,
  `supplier` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `getstock`
--

LOCK TABLES `getstock` WRITE;
/*!40000 ALTER TABLE `getstock` DISABLE KEYS */;
/*!40000 ALTER TABLE `getstock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `activity` varchar(300) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logs`
--

LOCK TABLES `logs` WRITE;
/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
INSERT INTO `logs` VALUES (1,5,'Added a new User Edson Tumwine as an admin','2019-09-07 11:20:41'),(2,1,'logged into the system','2019-09-07 11:21:06'),(3,1,'Added a new Unit Bottles with a symbol bottles','2019-09-07 11:27:47'),(4,1,'Added a new product Nile','2019-09-07 11:28:59'),(5,1,'Added a new product Wine','2019-09-07 11:29:51'),(6,1,'Editted product Wine from (Wine, 0, 4000) to (Wine, 0, 15000)','2019-09-07 11:30:12'),(7,1,'Added a new supllier Edson Tumwine with a contact: 774367210 and email: ed@gmail.com','2019-09-07 11:31:15'),(8,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 10000<br> product quantity: 24<br> total_price: 240000<br> product supplier: 1','2019-09-07 11:32:01'),(9,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 30<br> total_price: 120000<br> product supplier: 1','2019-09-07 11:32:33'),(10,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 3500<br> product quantity: 24<br> total_price: 84000<br> product supplier: 1','2019-09-07 11:33:10'),(11,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 2000<br> product quantity: 30<br> total_price: 60000<br> product supplier: 1','2019-09-07 11:33:56'),(12,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 4000<br> product quantity: 5000<br> total_price: 20000000<br> product supplier: 1','2019-09-07 11:36:36'),(13,2,'Tried to login but failed','2019-09-07 11:55:52'),(14,2,'Tried to login but failed','2019-09-07 11:55:56'),(15,1,'logged into the system','2019-09-07 11:56:08'),(16,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 1','2019-09-07 11:57:24'),(17,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 2000<br> product quantity: 10<br> total_price: 20000<br> product supplier: 1','2019-09-07 12:13:58'),(18,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 10000<br> product quantity: 5<br> total_price: 50000<br> product supplier: 1','2019-09-07 12:13:58'),(19,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 15000<br> product quantity: 10<br> total_price: 150000<br> product supplier: 1','2019-09-07 12:15:33'),(20,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 4<br> total_price: 16000<br> product supplier: 1','2019-09-07 12:23:27'),(21,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 3<br> total_price: 12000<br> product supplier: 1','2019-09-07 12:23:45'),(22,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 4000<br> product quantity: 4<br> total_price: 16000<br> product supplier: 1','2019-09-07 12:24:01'),(23,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 2<br> total_price: 8000<br> product supplier: 1','2019-09-07 12:25:04'),(24,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 1<br> total_price: 4000<br> product supplier: 1','2019-09-07 12:26:58'),(25,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 4000<br> product quantity: 4<br> total_price: 16000<br> product supplier: 1','2019-09-07 12:29:16'),(26,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 2<br> total_price: 8000<br> product supplier: 1','2019-09-07 12:31:03'),(27,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 1','2019-09-07 12:31:31'),(28,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 1','2019-09-07 12:31:55'),(29,1,'Paid   shs  70000 to  1','2019-09-07 12:42:20'),(30,1,'Added a new product Club 250mls','2019-09-07 13:13:17'),(31,1,' Purchased product with details<br> product Name: Club 250mls<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 1','2019-09-07 13:14:08'),(32,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 10000<br> product quantity: 3<br> total_price: 30000<br> product supplier: 1','2019-09-07 13:14:08'),(33,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 3000<br> product quantity: 4<br> total_price: 12000<br> product supplier: 1','2019-09-07 13:14:08'),(34,1,' Added a new Staff<br>\n    <b>Full Names: </b>Dan<br>\n    <b>Code: </b>412235<br>\n    <b>Role: </b>2','2019-09-07 14:08:03'),(35,1,'Sold 1 items at Ushs.4000','2019-09-07 14:08:20'),(36,1,'Sold 1 items at Ushs.15000','2019-09-07 14:08:58'),(37,1,'Sold 2 items at Ushs.6000','2019-09-07 14:10:01'),(38,1,'logged into the system','2019-09-07 15:06:39'),(39,1,'Sold 3 items at Ushs.45000','2019-09-07 15:07:08'),(40,1,'logged into the system','2019-09-09 05:14:31'),(41,2,'Tried to login but failed','2019-09-09 05:45:36'),(42,1,'logged into the system','2019-09-09 05:45:48'),(43,1,'Added a new Expense category: Furniture','2019-09-09 05:47:55'),(44,1,'Added a new Expense category: Food','2019-09-09 05:48:17'),(45,1,'Added a new Expense category: Utilities','2019-09-09 05:48:41'),(46,1,'Made an expense of<br>\n  <b>Amount: </b>5000<br>\n  <b>Category: </b>3<br>\n  <hr>\n  <b>Description: </b>paid electricity bill;\n\n  ','2019-09-09 05:50:00'),(47,1,'Added a new User William as an attendant','2019-09-09 05:51:29'),(48,1,'Added a new User Dan Mac as an attendant','2019-09-09 05:52:09'),(49,1,'Made an expense of<br>\n  <b>Amount: </b>2000<br>\n  <b>Category: </b>2<br>\n  <hr>\n  <b>Description: </b>edson bough lunch;\n\n  ','2019-09-09 05:53:11'),(50,1,'Loggedout of the system','2019-09-09 05:53:36'),(51,2,'logged into the system','2019-09-09 05:53:50'),(52,2,'Made an expense of<br>\n  <b>Amount: </b>20000<br>\n  <b>Category: </b>1<br>\n  <hr>\n  <b>Description: </b>bought chairs;\n\n  ','2019-09-09 05:54:31'),(53,2,'Sold 1 items at Ushs.15000','2019-09-09 05:55:11'),(54,2,'Loggedout of the system','2019-09-09 05:57:20'),(55,3,'logged into the system','2019-09-09 05:57:31'),(56,3,'Made an expense of<br>\n  <b>Amount: </b>4000<br>\n  <b>Category: </b>3<br>\n  <hr>\n  <b>Description: </b>Paid water bill;\n\n  ','2019-09-09 05:58:28'),(57,3,' Added a new Staff<br>\n    <b>Full Names: </b>Oscar<br>\n    <b>Code: </b>484921<br>\n    <b>Role: </b>2','2019-09-09 05:59:39'),(58,3,'Loggedout of the system','2019-09-09 06:00:16'),(59,2,'Tried to login but failed','2019-09-09 06:00:25'),(60,1,'logged into the system','2019-09-09 06:00:34'),(61,1,'Added a new Expense category: Salaries','2019-09-09 07:44:53'),(62,1,'Added a new Expense category: transport','2019-09-09 07:51:08'),(63,1,'Added a new Expense category: airtime','2019-09-09 07:52:47'),(64,1,'Sold 1 items at Ushs.4000','2019-09-09 08:54:12'),(65,1,'Sold 1 items at Ushs.15000','2019-09-09 08:54:42'),(66,1,'Sold 1 items at Ushs.4000','2019-09-09 08:55:14'),(67,1,'Sold 1 items at Ushs.4000','2019-09-09 08:57:25'),(68,1,'Sold 1 items at Ushs.4000','2019-09-09 08:57:48'),(69,1,'Sold 1 items at Ushs.4000','2019-09-09 09:00:32'),(70,1,'Sold 1 items at Ushs.4000','2019-09-09 09:01:32'),(71,1,'Sold 1 items at Ushs.4000','2019-09-09 09:01:59'),(72,1,'Sold 1 items at Ushs.4000','2019-09-09 09:02:46'),(73,1,'Updated Business Details from<br> <b>Business Name:</b>Edson<br><b>Contact</b> <br><b> Email:</b><br><b> Address:</b>) <p>\n\n  to <p>\n  <b>Business Name:</b>Edson Enterprises Limited<br><b>Contact</b> 0774362710<br><b> Email:</b>Info@edsonenterpises.info<br><b> Address:</b>Kyanja)','2019-09-09 09:38:03'),(74,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 1','2019-09-09 10:57:33'),(75,1,'Sold 1 items at Ushs.15000','2019-09-09 11:00:21'),(76,1,'Loggedout of the system','2019-09-09 11:37:48'),(77,48,'Loggedout of the system','2019-09-11 06:03:28'),(78,1,'logged into the system','2019-09-11 06:05:17'),(79,1,'logged into the system','2019-09-11 06:07:07'),(80,1,'Loggedout of the system','2019-09-11 06:07:31'),(81,1,'logged into the system','2019-09-11 06:08:40'),(82,1,'Loggedout of the system','2019-09-11 06:08:43'),(83,1,'logged into the system','2019-09-11 06:12:05'),(84,0,'Loggedout of the system','2019-09-11 06:12:36'),(85,2,'Tried to login but failed','2019-09-11 06:13:38'),(86,1,'logged into the system','2019-09-11 06:13:45'),(87,3,'logged into the system','2019-09-11 06:14:08'),(88,3,'Loggedout of the system','2019-09-11 06:14:15'),(89,1,'logged into the system','2019-09-11 06:15:23'),(90,1,'logged into the system','2019-09-11 06:16:02'),(91,1,'Loggedout of the system','2019-09-11 06:19:30'),(92,1,'logged into the system','2019-09-11 06:20:14'),(93,1,'Loggedout of the system','2019-09-11 06:20:31'),(94,3,'logged into the system','2019-09-11 06:26:03'),(95,3,'Loggedout of the system','2019-09-11 06:41:00'),(96,1,'logged into the system','2019-09-11 09:47:35'),(97,1,'Deleted User Dan Mac','2019-09-11 10:09:41'),(98,1,' Added a new Staff<br>\n    <b>Full Names: </b><br>\n    <b>Code: </b><br>\n    <b>Role: </b>','2019-09-11 12:46:38'),(99,1,' Edited a  Staff<br>\n    <b>Full Names: </b>Oscar<br>\n   \n    <b>Role: </b>2','2019-09-11 12:47:55'),(100,1,'Returned User Edson Tumwine','2019-09-11 13:10:32'),(101,1,'Suspended User Edson Tumwine','2019-09-11 13:10:52'),(102,1,'Returned User Edson Tumwine','2019-09-11 13:10:55'),(103,1,'Suspended User William','2019-09-11 13:10:58'),(104,1,'Returned User William','2019-09-11 13:11:01'),(105,1,'Deleted User William','2019-09-11 13:11:09'),(106,1,'Added a new supllier Edson Tumwine with a contact: 774367210 and email: ed@gmail.com','2019-09-12 06:23:48'),(107,1,'Added a new supllier Mac Dan with a contact: 785654334 and email: mac@gmail.com','2019-09-12 06:45:15'),(108,1,'Sold 12 items at Ushs.48000','2019-09-12 10:32:53'),(109,1,'Sold 13 items at Ushs.52000','2019-09-12 10:36:24'),(110,1,'Sold 1 items at Ushs.4000','2019-09-12 10:41:03'),(111,1,'Sold 1 items at Ushs.4000','2019-09-12 11:14:32'),(112,1,'Sold 1 items at Ushs.4000','2019-09-12 11:16:19'),(113,1,'Sold 1 items at Ushs.15000','2019-09-12 11:19:18'),(114,1,'Sold 4 items at Ushs.38000','2019-09-12 11:20:34'),(115,1,'Sold 4 items at Ushs.13000','2019-09-12 11:33:05'),(116,1,'Suspended User Edson Tumwine','2019-09-12 11:43:14'),(117,1,'Returned User Edson Tumwine','2019-09-12 11:43:22'),(118,1,'Added a new supllier Man Made Money with a contact: 774367210 and email: ed@gmail.com','2019-09-12 12:41:19'),(119,1,'Sold 5 items at Ushs.31000','2019-09-13 12:20:44'),(120,1,'Sold 11 items at Ushs.99000','2019-09-13 12:21:15'),(121,1,'Sold 3 items at Ushs.23000','2019-09-13 12:34:17'),(122,1,'Added a new User Asiimwe Daudi as an admin','2019-09-14 06:44:57'),(123,1,' Purchased product with details<br> product Name: Wine<br> product Unit price: 4000<br> product quantity: 60<br> total_price: 240000<br> product supplier: 1','2019-09-14 07:17:55'),(124,1,'Loggedout of the system','2019-09-16 05:05:04'),(125,2,'logged into the system','2019-09-16 05:05:25'),(126,2,'Loggedout of the system','2019-09-16 05:07:14'),(127,1,'logged into the system','2019-09-16 05:07:27'),(128,1,'Added a payement of receipt number: 111909132<br>\n   <b>Amount: </b>90000<br>\n   <b>New Balance: </b>0','2019-09-16 06:01:26'),(129,1,'logged into the system','2019-09-16 07:33:13'),(130,1,'Sold 1 items at Ushs.4000','2019-09-16 07:53:02'),(131,1,'Added a payement of receipt number: 31909133<br>\n   <b>Amount: </b>10000<br>\n   <b>New Balance: </b>10000','2019-09-16 09:44:05'),(132,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 2<br> total_price: 8000<br> product supplier: 1','2019-09-16 09:48:22'),(133,1,'Paid   shs  6000 to  Man Made Money','2019-09-16 12:39:31'),(134,1,'Paid   shs  1000 to  Man Made Money','2019-09-16 12:40:04'),(135,1,'Paid   shs  1000 to  Man Made Money','2019-09-16 12:40:24'),(136,1,'Paid   shs  1000 to  Man Made Money','2019-09-16 12:56:35'),(137,1,'Paid   shs  9000 to  Man Made Money','2019-09-16 13:00:20'),(138,1,'Loggedout of the system','2019-09-17 05:15:42'),(139,2,'logged into the system','2019-09-17 05:15:54'),(140,2,'Loggedout of the system','2019-09-17 05:23:16'),(141,1,'logged into the system','2019-09-17 05:23:27'),(142,1,'Paid   shs  150000 to  Man Made Money','2019-09-17 06:09:00'),(143,1,'Paid   shs  8000 to  Man Made Money','2019-09-17 06:20:39'),(144,1,'Sold 1 items at Ushs.4000','2019-09-17 06:21:21'),(145,1,' Purchased product with details<br> product Name: Club 250mls<br> product Unit price: 4000<br> product quantity: 70<br> total_price: 280000<br> product supplier: 1','2019-09-17 06:25:30'),(146,1,'Sold 19 items at Ushs.57000','2019-09-17 06:25:55'),(147,1,' Purchased product with details<br> product Name: Club 250mls<br> product Unit price: 4000<br> product quantity: 4<br> total_price: 16000<br> product supplier: 2','2019-09-17 06:38:36'),(148,1,' Purchased product with details<br> product Name: Nile<br> product Unit price: 4000<br> product quantity: 4<br> total_price: 16000<br> product supplier: 2','2019-09-17 06:46:10'),(149,1,'Added a payement of receipt number: 31909133<br>\n   <b>Amount: </b>10000<br>\n   <b>New Balance: </b>0','2019-09-17 06:50:56'),(150,1,'Sold 5 items at Ushs.20000','2019-09-17 06:55:41'),(151,1,'Added a payement of receipt number: 51909177<br>\n   <b>Amount: </b>1000<br>\n   <b>New Balance: </b>17000','2019-09-17 06:56:12'),(152,1,'Added a payement of receipt number: 51909177<br>\n   <b>Amount: </b>17000<br>\n   <b>New Balance: </b>0','2019-09-17 07:23:48'),(153,1,'Added a new product BELL LAGER','2019-09-17 07:25:51'),(154,1,' Purchased product with details<br> product Name: BELL LAGER<br> product Unit price: 2000<br> product quantity: 3<br> total_price: 6000<br> product supplier: 2','2019-09-17 07:26:26'),(155,1,'Sold 1 items at Ushs.3000','2019-09-17 07:26:56'),(156,2,'Tried to login but failed','2019-09-17 07:36:52'),(157,2,'Tried to login but failed','2019-09-17 07:37:01'),(158,1,'logged into the system','2019-09-17 07:37:17'),(159,1,'logged into the system','2019-09-18 07:07:53'),(160,1,'Added a new product Category Bar','2019-09-18 08:59:45'),(161,1,'Added a new product Category Kitchen','2019-09-18 09:00:19'),(162,1,'Edited Category Bar','2019-09-18 09:25:03'),(163,1,'Edited Category Kitchen','2019-09-18 09:25:24'),(164,1,'Added a new product Category Others','2019-09-18 09:31:36'),(165,1,'Added a new product Category Shop','2019-09-18 09:34:56'),(166,1,'Edited Category Video Hall','2019-09-18 09:35:35'),(167,1,'Added a new product Bread 1kg','2019-09-18 09:37:13'),(168,1,'Loggedout of the system','2019-09-18 09:41:46'),(169,1,'logged into the system','2019-09-18 09:42:20'),(170,1,'Loggedout of the system','2019-09-18 10:01:37'),(171,1,'logged into the system','2019-09-18 10:04:04'),(172,1,'Loggedout of the system','2019-09-18 11:16:35'),(173,2,'Tried to login but failed','2019-09-18 11:16:44'),(174,2,'Tried to login but failed','2019-09-18 11:17:46'),(175,2,'logged into the system','2019-09-18 11:17:58'),(176,2,'Loggedout of the system','2019-09-18 11:22:12'),(177,1,'logged into the system','2019-09-18 11:22:21'),(178,1,'Loggedout of the system','2019-09-18 11:22:57'),(179,2,'logged into the system','2019-09-18 11:23:08'),(180,2,'Sold 10 items at Ushs.150000','2019-09-19 08:50:52'),(181,2,'Loggedout of the system','2019-09-19 09:14:38'),(182,1,'logged into the system','2019-09-19 09:14:54'),(183,1,'Loggedout of the system','2019-09-19 10:21:32'),(184,1,'logged into the system','2019-09-19 10:24:57'),(185,1,'Loggedout of the system','2019-09-19 11:19:10'),(186,1,'logged into the system','2019-09-20 05:19:23'),(187,1,'Loggedout of the system','2019-09-20 06:30:45'),(188,1,'logged into the system','2019-09-20 06:42:40'),(189,1,'Loggedout of the system','2019-09-20 06:46:54'),(190,2,'Tried to login but failed','2019-09-20 06:54:21'),(191,2,'Tried to login but failed','2019-09-20 06:54:21'),(192,2,'Tried to login but failed','2019-09-20 06:55:16'),(193,2,'Tried to login but failed','2019-09-20 06:55:23'),(194,2,'Tried to login but failed','2019-09-20 06:55:24'),(195,2,'Tried to login but failed','2019-09-20 06:58:56'),(196,1,'logged into the system','2019-09-20 06:59:27'),(197,1,'Loggedout of the system','2019-09-20 07:19:51'),(198,2,'logged into the system','2019-09-20 07:20:12'),(199,2,'Loggedout of the system','2019-09-20 07:36:28'),(200,1,'logged into the system','2019-09-20 07:40:43'),(201,1,'Added a new User Systems Admin as an admin','2019-09-20 07:42:16'),(202,1,'Editted User William from (William, William, attendant, 0777767210) to (William, William, attendant, 0777767210)','2019-09-20 07:43:07'),(203,1,'Editted User William from (William, William, attendant, 0777767210) to (William, William, attendant, 0777767210)','2019-09-20 07:43:23'),(204,1,'Editted User Asiimwe Daudi from (Asiimwe Daudi, daudi, admin, 0778367210) to (Asiimwe Daudi, daudi, attendant, 0778367210)','2019-09-20 07:45:55'),(205,1,'Suspended User Edson Tumwine','2019-09-20 08:08:58'),(206,1,'Returned User Edson Tumwine','2019-09-20 08:09:01'),(207,2,'Tried to login but failed','2019-09-26 18:28:10'),(208,4,'logged into the system','2019-09-26 18:28:19'),(209,4,'Loggedout of the system','2019-09-26 18:39:31'),(210,4,'logged into the system','2019-09-26 18:39:39');
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shortmessage` varchar(100) DEFAULT NULL,
  `fullmessage` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `AddedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (5,' is getting out of Stock',' is getting out of Stock, the quantity remaining is, please restock',0,'2019-09-12 10:32:53'),(3,'i love you','i love you very much',0,'2019-09-12 07:56:57'),(6,'Product  is getting out of Stock','Product  is getting out of Stock, the quantity remaining is, please restock',0,'2019-09-12 10:36:43'),(7,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 67 , please restock',0,'2019-09-12 11:20:34'),(8,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 66 , please restock',0,'2019-09-12 11:20:34'),(9,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 65 , please restock',0,'2019-09-12 11:33:05'),(10,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 61 , please restock',0,'2019-09-13 12:20:45'),(11,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 55 , please restock',0,'2019-09-13 12:21:15'),(12,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 53 , please restock',0,'2019-09-13 12:34:17'),(13,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 52 , please restock',0,'2019-09-16 07:53:02'),(14,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 53 , please restock',1,'2019-09-17 06:21:21'),(15,'Product Nile is getting out of Stock','Product Nile is getting out of Stock, the quantity remaining is 52 , please restock',1,'2019-09-17 06:55:41');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_logs`
--

DROP TABLE IF EXISTS `payment_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `amount_paid` int(11) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_logs`
--

LOCK TABLES `payment_logs` WRITE;
/*!40000 ALTER TABLE `payment_logs` DISABLE KEYS */;
INSERT INTO `payment_logs` VALUES (1,1,4000,0,1,'2019-09-07 14:08:21'),(2,2,15000,0,1,'2019-09-07 14:08:58'),(3,3,6000,0,1,'2019-09-07 14:10:01'),(4,4,45000,0,1,'2019-09-07 15:07:08'),(5,5,15000,0,2,'2019-09-09 05:55:11'),(6,6,4000,0,1,'2019-09-09 08:54:13'),(7,99,15000,0,1,'2019-09-09 08:54:43'),(8,8,4000,0,1,'2019-09-09 08:55:15'),(9,9,4000,0,1,'2019-09-09 08:57:26'),(10,10,4000,0,1,'2019-09-09 08:57:48'),(11,11,4000,0,1,'2019-09-09 09:00:33'),(12,12,4000,0,1,'2019-09-09 09:01:32'),(13,13,4000,0,1,'2019-09-09 09:02:00'),(14,14,4000,0,1,'2019-09-09 09:02:46'),(15,15,15000,0,1,'2019-09-09 11:00:22'),(16,16,48000,0,1,'2019-09-12 10:32:53'),(17,17,52000,0,1,'2019-09-12 10:36:25'),(18,18,4000,0,1,'2019-09-12 10:41:03'),(19,19,4000,0,1,'2019-09-12 11:14:33'),(20,20,4000,0,1,'2019-09-12 11:16:19'),(21,21,15000,0,1,'2019-09-12 11:19:18'),(22,22,38000,0,1,'2019-09-12 11:20:35'),(23,23,3000,10000,1,'2019-09-12 11:33:06'),(24,1,31000,0,1,'2019-09-13 12:20:45'),(25,2,9000,90000,1,'2019-09-13 12:21:16'),(26,3,3000,20000,1,'2019-09-13 12:34:18'),(27,2,90000,0,1,'2019-09-16 09:01:26'),(28,4,4000,0,1,'2019-09-16 07:53:03'),(29,3,10000,10000,1,'2019-09-16 12:44:05'),(30,5,4000,0,1,'2019-09-17 06:21:21'),(31,6,57000,0,1,'2019-09-17 06:25:55'),(32,3,10000,0,1,'2019-09-17 09:50:57'),(33,7,2000,18000,1,'2019-09-17 06:55:41'),(34,7,1000,17000,1,'2019-09-17 09:56:13'),(35,7,17000,0,1,'2019-09-17 10:23:49'),(36,8,3000,0,1,'2019-09-17 07:26:56'),(37,9,150000,0,2,'2019-09-19 08:50:52');
/*!40000 ALTER TABLE `payment_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_categories`
--

DROP TABLE IF EXISTS `product_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_categories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_categories`
--

LOCK TABLES `product_categories` WRITE;
/*!40000 ALTER TABLE `product_categories` DISABLE KEYS */;
INSERT INTO `product_categories` VALUES (1,'Bar',' product sold in a bars',1,'2019-09-18 11:59:45',1),(2,'Kitchen',' products from the kitchen',1,'2019-09-18 12:00:19',1),(3,'Video Hall',' products',1,'2019-09-18 12:31:36',1),(4,'Shop','Shop products',1,'2019-09-18 12:34:56',1);
/*!40000 ALTER TABLE `product_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) DEFAULT '0',
  `product_name` varchar(20) DEFAULT NULL,
  `product_code` varchar(10) DEFAULT NULL,
  `quantity` int(11) DEFAULT '0',
  `price` float DEFAULT NULL,
  `ProductImage` varchar(1000) DEFAULT NULL,
  `Units` varchar(10) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,1,'Nile','1234',52,4000,'../uploads/products/','1',1,1,'2019-09-07 11:28:59'),(2,1,'Wine','3241',540,15000,'../uploads/products/','1',1,1,'2019-09-07 11:29:51'),(3,1,'Club 250mls','6657564',55,3000,'../uploads/products/','1',1,1,'2019-09-07 13:13:17'),(4,1,'BELL LAGER','234355',2,3000,'../uploads/products/','1',1,1,'2019-09-17 07:25:51'),(5,4,'Bread 1kg','443445353',0,4000,'../uploads/products/','0',1,1,'2019-09-18 09:37:13');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_payments`
--

DROP TABLE IF EXISTS `purchase_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_id` int(11) DEFAULT NULL,
  `amount_paid` int(11) DEFAULT NULL,
  `voucher_no` varchar(50) DEFAULT NULL,
  `year` varchar(5) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `voucher` int(11) DEFAULT NULL,
  `AddedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `AddedBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_payments`
--

LOCK TABLES `purchase_payments` WRITE;
/*!40000 ALTER TABLE `purchase_payments` DISABLE KEYS */;
INSERT INTO `purchase_payments` VALUES (1,1,240000,'2019090001','2019',9,1,'2019-09-07 14:32:01',1),(2,2,120000,'2019090002','2019',9,2,'2019-09-07 14:32:33',1),(3,3,84000,'2019090003','2019',9,3,'2019-09-07 14:33:10',1),(4,4,60000,'2019090004','2019',9,4,'2019-09-07 14:33:56',1),(5,5,20000000,'2019090005','2019',9,5,'2019-09-07 14:36:35',1),(6,6,6000,'2019090006','2019',9,6,'2019-09-07 14:57:24',1),(7,11,16000,'2019090007','2019',9,7,'2019-09-07 15:24:01',1),(8,13,4000,'2019090008','2019',9,8,'2019-09-07 15:26:58',1),(9,14,16000,'2019090009','2019',9,9,'2019-09-07 15:29:16',1),(10,15,8000,'2019090010','2019',9,10,'2019-09-07 15:31:03',1),(11,16,6000,'2019090011','2019',9,11,'2019-09-07 15:31:31',1),(12,7,70000,'2019090012','2019',9,12,'2019-09-07 15:42:20',1),(13,18,48000,'2019090013','2019',9,13,'2019-09-07 16:14:08',1),(14,19,6000,'2019090014','2019',9,14,'2019-09-09 13:57:33',1),(15,20,240000,'2019090015','2019',9,15,'2019-09-14 10:17:54',1),(16,21,8000,'2019090016','2019',9,16,'2019-09-16 12:48:22',1),(17,17,6000,'2019090017','2019',9,17,'2019-09-16 15:39:31',1),(18,10,1000,'2019090018','2019',9,18,'2019-09-16 15:40:04',1),(19,10,1000,'2019090019','2019',9,19,'2019-09-16 15:40:24',1),(20,10,1000,'2019090020','2019',9,20,'2019-09-16 15:56:35',1),(21,10,9000,'2019090021','2019',9,21,'2019-09-16 16:00:20',1),(22,8,150000,'2019090022','2019',9,22,'2019-09-17 09:09:01',1),(23,12,8000,'2019090023','2019',9,23,'2019-09-17 09:20:39',1),(24,22,280000,'2019090024','2019',9,24,'2019-09-17 09:25:29',1),(25,23,16000,'2019090025','2019',9,25,'2019-09-17 09:38:36',1),(26,24,16000,'2019090026','2019',9,26,'2019-09-17 09:46:10',1),(27,25,6000,'2019090027','2019',9,27,'2019-09-17 10:26:25',1);
/*!40000 ALTER TABLE `purchase_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_totals`
--

DROP TABLE IF EXISTS `purchase_totals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_totals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quantity` int(11) DEFAULT NULL,
  `total_price` int(11) DEFAULT NULL,
  `paid` int(11) NOT NULL DEFAULT '0',
  `AddedOn` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_totals`
--

LOCK TABLES `purchase_totals` WRITE;
/*!40000 ALTER TABLE `purchase_totals` DISABLE KEYS */;
INSERT INTO `purchase_totals` VALUES (1,24,240000,240000,'2019-09-07 11:32:01'),(2,30,120000,120000,'2019-09-07 11:32:33'),(3,24,84000,84000,'2019-09-07 11:33:10'),(4,30,60000,60000,'2019-09-07 11:33:56'),(5,5000,20000000,20000000,'2019-09-07 11:36:35'),(6,3,6000,6000,'2019-09-07 11:57:24'),(7,15,70000,70000,'2019-09-07 12:13:57'),(8,10,150000,150000,'2019-09-07 12:15:32'),(9,4,16000,0,'2019-09-07 12:22:56'),(10,3,12000,12000,'2019-09-07 12:23:45'),(11,4,16000,16000,'2019-09-07 12:24:01'),(12,2,8000,8000,'2019-09-07 12:25:04'),(13,1,4000,4000,'2019-09-07 12:26:58'),(14,4,16000,16000,'2019-09-07 12:29:16'),(15,2,8000,8000,'2019-09-07 12:31:03'),(16,3,6000,6000,'2019-09-07 12:31:31'),(17,3,6000,6000,'2019-09-07 12:31:54'),(18,10,48000,48000,'2019-09-07 13:14:08'),(19,3,6000,6000,'2019-09-09 10:57:33'),(20,60,240000,240000,'2019-09-14 07:17:54'),(21,2,8000,8000,'2019-09-16 09:48:22'),(22,70,280000,280000,'2019-09-17 06:25:29'),(23,4,16000,16000,'2019-09-17 06:38:36'),(24,4,16000,16000,'2019-09-17 06:46:10'),(25,3,6000,6000,'2019-09-17 07:26:25');
/*!40000 ALTER TABLE `purchase_totals` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT '0',
  `unit_price` int(11) DEFAULT '0',
  `total_price` int(11) DEFAULT '0',
  `purchase_date` date DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `AddedBy` int(11) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `supplier` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `purchases` WRITE;
/*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
INSERT INTO `purchases` VALUES (1,2,24,10000,240000,NULL,1,1,'2019-09-07 11:32:01','1'),(2,1,30,4000,120000,NULL,2,1,'2019-09-07 11:32:33','1'),(3,1,24,3500,84000,NULL,3,1,'2019-09-07 11:33:10','1'),(4,1,30,2000,60000,NULL,4,1,'2019-09-07 11:33:56','1'),(5,2,5000,4000,20000000,NULL,5,1,'2019-09-07 11:36:36','1'),(6,2,3,2000,6000,NULL,6,1,'2019-09-07 11:57:24','1'),(7,1,10,2000,20000,NULL,7,1,'2019-09-07 12:13:58','1'),(8,2,5,10000,50000,NULL,7,1,'2019-09-07 12:13:58','1'),(9,2,10,15000,150000,NULL,8,1,'2019-09-07 12:15:33','1'),(10,1,4,4000,16000,NULL,9,1,'2019-09-07 12:23:27','1'),(11,1,3,4000,12000,NULL,10,1,'2019-09-07 12:23:45','1'),(12,2,4,4000,16000,NULL,11,1,'2019-09-07 12:24:01','1'),(13,1,2,4000,8000,NULL,12,1,'2019-09-07 12:25:04','1'),(14,1,1,4000,4000,NULL,13,1,'2019-09-07 12:26:58','1'),(15,2,4,4000,16000,NULL,14,1,'2019-09-07 12:29:16','1'),(16,1,2,4000,8000,NULL,15,1,'2019-09-07 12:31:03','1'),(17,1,3,2000,6000,NULL,16,1,'2019-09-07 12:31:31','1'),(18,1,3,2000,6000,NULL,17,1,'2019-09-07 12:31:55','1'),(19,3,3,2000,6000,NULL,18,1,'2019-09-07 13:14:08','1'),(20,2,3,10000,30000,NULL,18,1,'2019-09-07 13:14:08','1'),(21,1,4,3000,12000,NULL,18,1,'2019-09-07 13:14:08','1'),(22,2,3,2000,6000,NULL,19,1,'2019-09-09 10:57:33','1'),(23,2,60,4000,240000,NULL,20,1,'2019-09-14 07:17:55','1'),(24,1,2,4000,8000,NULL,21,1,'2019-09-16 09:48:22','1'),(25,3,70,4000,280000,NULL,22,1,'2019-09-17 06:25:30','1'),(26,3,4,4000,16000,NULL,23,1,'2019-09-17 06:38:36','2'),(27,1,4,4000,16000,NULL,24,1,'2019-09-17 06:46:10','2'),(28,4,3,2000,6000,NULL,25,1,'2019-09-17 07:26:26','2');
/*!40000 ALTER TABLE `purchases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `returns_out`
--

DROP TABLE IF EXISTS `returns_out`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `returns_out` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `Reason` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `returns_out`
--

LOCK TABLES `returns_out` WRITE;
/*!40000 ALTER TABLE `returns_out` DISABLE KEYS */;
/*!40000 ALTER TABLE `returns_out` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quatity` int(11) DEFAULT NULL,
  `total_price` int(11) DEFAULT NULL,
  `paid` int(11) NOT NULL DEFAULT '0',
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `staff` int(11) DEFAULT NULL,
  `receipt_no` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `receipt_no` (`receipt_no`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales`
--

LOCK TABLES `sales` WRITE;
/*!40000 ALTER TABLE `sales` DISABLE KEYS */;
INSERT INTO `sales` VALUES (1,5,31000,31000,'2019-09-13 12:20:44',412235,51909131),(2,11,99000,99000,'2019-09-13 12:21:15',412235,111909132),(3,3,23000,23000,'2019-09-13 12:34:17',412235,31909133),(4,1,4000,4000,'2019-09-16 07:53:02',412235,11909164),(5,1,4000,4000,'2019-09-17 06:21:21',412235,11909175),(6,19,57000,57000,'2019-09-17 06:25:55',412235,191909176),(7,5,20000,20000,'2019-09-17 06:55:41',412235,51909177),(8,1,3000,3000,'2019-09-17 07:26:56',412235,11909178),(9,10,150000,150000,'2019-09-19 08:50:51',412235,101909199);
/*!40000 ALTER TABLE `sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales_details`
--

DROP TABLE IF EXISTS `sales_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sales_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `buying_price` float NOT NULL DEFAULT '0',
  `selling_price` int(11) NOT NULL DEFAULT '0',
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales_details`
--

LOCK TABLES `sales_details` WRITE;
/*!40000 ALTER TABLE `sales_details` DISABLE KEYS */;
INSERT INTO `sales_details` VALUES (1,1,4,103.914,4000,'2019-09-13 12:20:45',1,1),(2,2,1,11.988,4000,'2019-09-13 12:20:45',1,1),(3,1,6,103.914,4000,'2019-09-13 12:21:15',1,2),(4,2,5,11.988,4000,'2019-09-13 12:21:15',1,2),(5,1,2,103.914,4000,'2019-09-13 12:34:17',1,3),(6,2,1,11.988,4000,'2019-09-13 12:34:17',1,3),(7,1,1,103.914,4000,'2019-09-16 07:53:02',1,4),(8,1,1,150.072,4000,'2019-09-17 06:21:21',1,5),(9,3,19,4028.57,3000,'2019-09-17 06:25:55',1,6),(10,1,5,283.335,4000,'2019-09-17 06:55:41',1,7),(11,4,1,2000,3000,'2019-09-17 07:26:56',1,8),(12,2,10,436.385,4000,'2019-09-19 08:50:52',2,9);
/*!40000 ALTER TABLE `sales_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(100) DEFAULT NULL,
  `staff_code` varchar(100) DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  `suspend` int(11) NOT NULL DEFAULT '1',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `staff_code` (`staff_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1,'Dan','412235',2,1,1),(2,'Oscar','484921',2,0,1);
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_roles`
--

DROP TABLE IF EXISTS `staff_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_roles`
--

LOCK TABLES `staff_roles` WRITE;
/*!40000 ALTER TABLE `staff_roles` DISABLE KEYS */;
INSERT INTO `staff_roles` VALUES (1,'cook','for cooking'),(2,'waiter','for the bar');
/*!40000 ALTER TABLE `staff_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stock`
--

DROP TABLE IF EXISTS `stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(100) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `Actual_quantity` int(11) DEFAULT NULL,
  `buying_price` float DEFAULT NULL,
  `selling_price` int(11) DEFAULT '0',
  `supplier` varchar(100) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `min_quantity` int(11) DEFAULT '0',
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stock`
--

LOCK TABLES `stock` WRITE;
/*!40000 ALTER TABLE `stock` DISABLE KEYS */;
INSERT INTO `stock` VALUES (1,'1',52,0,283.335,4000,NULL,1,95,1,'2019-09-07 11:29:00'),(2,'2',540,0,436.385,4000,NULL,1,NULL,1,'2019-09-07 11:29:52'),(3,'3',55,0,364.156,3000,NULL,1,NULL,1,'2019-09-07 13:13:18'),(4,'4',2,NULL,2000,3000,NULL,1,0,1,'2019-09-17 07:25:52'),(5,'5',NULL,NULL,NULL,4000,NULL,1,0,1,'2019-09-18 09:37:14');
/*!40000 ALTER TABLE `stock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suppliers`
--

DROP TABLE IF EXISTS `suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppliers` (
  `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `contact` int(12) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `credit_limit` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `suspend` int(11) NOT NULL DEFAULT '1',
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suppliers`
--

LOCK TABLES `suppliers` WRITE;
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
INSERT INTO `suppliers` VALUES (1,'Man Made Money',774367210,'Kampala','ed@gmail.com',10000,1,1,1,'2019-09-07 11:31:15'),(2,'Mac Dan',785654334,'Kampala','mac@gmail.com',100000,1,1,1,'2019-09-12 06:45:15');
/*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `temp`
--

DROP TABLE IF EXISTS `temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `staff` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temp`
--

LOCK TABLES `temp` WRITE;
/*!40000 ALTER TABLE `temp` DISABLE KEYS */;
/*!40000 ALTER TABLE `temp` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `units` (
  `UnitID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(30) DEFAULT NULL,
  `Symbol` varchar(10) DEFAULT NULL,
  `AddedBy` int(11) DEFAULT NULL,
  `AddedOn` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '1',
  PRIMARY KEY (`UnitID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `units` WRITE;
/*!40000 ALTER TABLE `units` DISABLE KEYS */;
INSERT INTO `units` VALUES (1,'Bottles','bottles',1,'2019-09-07 11:27:47',1);
/*!40000 ALTER TABLE `units` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `user_name` varchar(10) NOT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `password` varchar(200) NOT NULL,
  `role` varchar(10) NOT NULL,
  `suspend` int(11) NOT NULL DEFAULT '1',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `contact` (`contact`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Edson Tumwine','Edson','0774367210','4b953cf2c56b18481176cf33aca7f42a','admin',1,1),(2,'William','William','0777767210','18218139eec55d83cf82679934e5cd75','attendant',1,1),(4,'Asiimwe Daudi','daudi','0778367210','6efcf5453db324a4006fa783621e58ab','admin',1,1),(5,'Systems Admin','pos','0774567210','5e0bdcbddccca4d66d74ba8c1cee1a68','admin',1,1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-09-26 11:39:51
