[sql] juanco
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
- -- phpMyAdmin SQL Dump
- -- version 4.6.5.2
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: May 19, 2020 at 03:45 PM
- -- Server version: 10.1.21-MariaDB
- -- PHP Version: 5.6.30
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!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 utf8mb4 */;
- --
- -- Database: `juanco`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `admin`
- --
- CREATE TABLE `admin` (
- `id` INT(11) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `password` VARCHAR(255) NOT NULL,
- `names` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `admin`
- --
- INSERT INTO `admin` (`id`, `username`, `password`, `names`) VALUES
- (1, 'admin', '12345', 'administrator');
- -- --------------------------------------------------------
- --
- -- Table structure for table `answered`
- --
- CREATE TABLE `answered` (
- `id` INT(11) NOT NULL,
- `qid` VARCHAR(255) NOT NULL,
- `answer` VARCHAR(999) NOT NULL,
- `uname` VARCHAR(255) NOT NULL,
- `date_replied` DATE NOT NULL,
- `question` VARCHAR(999) NOT NULL,
- `client` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `answered`
- --
- INSERT INTO `answered` (`id`, `qid`, `answer`, `uname`, `date_replied`, `question`, `client`) VALUES
- (9, 'Qn-122459', 'fine', 'james', '2020-05-05', 'good boy', 'george'),
- (10, 'Qn-519594', 'thanks', 'njeri', '2020-05-06', 'good services', 'ndungu');
- -- --------------------------------------------------------
- --
- -- Table structure for table `clients`
- --
- CREATE TABLE `clients` (
- `id` INT(11) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `password` VARCHAR(255) NOT NULL,
- `names` VARCHAR(255) NOT NULL,
- `nationalid` INT(11) NOT NULL,
- `contact` VARCHAR(20) NOT NULL,
- `location` VARCHAR(255) NOT NULL,
- `email` VARCHAR(255) NOT NULL,
- `status` INT(11) NOT NULL,
- `datereg` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
- `class` INT(10) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `clients`
- --
- INSERT INTO `clients` (`id`, `username`, `password`, `names`, `nationalid`, `contact`, `location`, `email`, `status`, `datereg`, `class`) VALUES
- (1, 'peter', 'peter', 'peter mwangi', 12, '21', 'meru', '', 1, '2005-06-20 04:03:17.000000', 1),
- (5, 'george', 'george', 'george w bush', 69365, '25476767', 'meru ', '[email protected]', 1, '2011-11-19 05:42:19.000000', 1),
- (11, 'ann', '12345', 'ann', 23452185, '724990092', 'Nanyuki', '[email protected]', 1, '2005-06-20 05:27:59.000000', 1),
- (12, 'ndungu', '123456', 'ndungu', 12345678, '752369852', 'Nakuru', '[email protected]', 1, '2005-06-20 06:33:29.000000', 1),
- (13, 'kahara', '123456', 'kahara ', 12354678, '754236151', 'molo', '[email protected]', 1, '2005-06-20 06:33:35.000000', 1),
- (14, 'reuben', '12345', 'reuben', 21356985, '720459426', 'Eldoret', '[email protected]', 1, '2005-06-20 06:33:40.000000', 1),
- (15, 'hakim', 'kimani', 'john thuku', 64523156, '2147483647', 'nyeri', '[email protected]', 1, '2005-06-20 08:18:33.000000', 1),
- (16, 'rena', '123456', 'Rena ', 35184805, '724990092', 'nyandarua ', '[email protected]', 1, '2005-06-20 09:36:42.000000', 1),
- (17, 'Muthami', '123456', 'peter Muthami', 10101010, '741050517', 'Limuru', '[email protected]', 1, '2005-06-20 09:41:17.000000', 1),
- (20, 'Nelson ', 'pass', 'Nelson Muriithi ', 89899888, '0704848484', 'Eldoret ', '[email protected]', 1, '2020-05-16 10:04:04.595692', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `feedback`
- --
- CREATE TABLE `feedback` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- `email` VARCHAR(255) NOT NULL,
- `comment` VARCHAR(999) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `queryid` VARCHAR(255) NOT NULL,
- `status` INT(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `feedback`
- --
- INSERT INTO `feedback` (`id`, `name`, `email`, `comment`, `username`, `queryid`, `status`) VALUES
- -- --------------------------------------------------------
- --
- -- Table structure for table `login_session`
- --
- CREATE TABLE `login_session` (
- `id` INT(11) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `code` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `login_session`
- --
- INSERT INTO `login_session` (`id`, `username`, `code`) VALUES
- (161, 'george', '494391'),
- (162, 'george', 'george'),
- (163, 'george', '30147'),
- (164, 'george', '320847'),
- (165, 'ann', '181478'),
- (166, 'pet', '695232'),
- (167, 'pet', '996436'),
- (168, 'ann', '171716'),
- (169, 'ann', '763511'),
- (170, 'ann', '142600'),
- (171, 'ann', '40912'),
- (172, 'george', '567073'),
- (173, 'pet', '430051'),
- (174, 'ndungu', '576913'),
- (175, 'kahara', '158481'),
- (176, 'reuben', '968816'),
- (177, 'reuben', '400484'),
- (178, 'ndungu', '476177'),
- (179, 'nelson', '952608'),
- (180, 'nelson', '757435'),
- (181, 'nelson', '391698'),
- (182, 'ndungu', '594238'),
- (183, 'reuben', '772730'),
- (184, 'reuben', '456328'),
- (185, 'george', '157768'),
- (186, 'reuben', '351332'),
- (187, 'reuben', '858459'),
- (188, 'ndungu', '669354'),
- (189, 'ndungu', '361553'),
- (190, 'nelson', '928442'),
- (191, 'nelson', '418282'),
- (192, 'kahara', '142065'),
- (193, 'violet', '838230'),
- (194, 'kahara', '309744'),
- (195, 'ndungu', '387475'),
- (196, 'nelson', '323885'),
- (197, 'violet', '679693'),
- (198, 'violet', '563244'),
- (199, 'george', '301430'),
- (200, 'baraka', '905582'),
- (201, 'kahara', '743348'),
- (202, 'baraka', '534978'),
- (203, 'ndungu', '955638'),
- (204, 'ndungu', '655164'),
- (205, 'nelson', '96588'),
- (206, 'Rena ', '282056'),
- (207, 'muthami', '164889'),
- (208, 'muthami', '154802'),
- (209, 'muthami', '885123'),
- (210, 'muthami', '737609'),
- (211, 'nelson', '97180'),
- (212, 'reuben', '2'),
- (213, 'reuben', '2'),
- (214, 'reuben', '2'),
- (215, 'reuben', '2'),
- (216, 'reuben', '2'),
- (217, 'reuben', '2'),
- (218, 'reuben', '2'),
- (219, 'reuben', '2');
- -- --------------------------------------------------------
- --
- -- Table structure for table `orders`
- --
- CREATE TABLE `orders` (
- `id` INT(11) NOT NULL,
- `products` VARCHAR(255) NOT NULL,
- `customer` VARCHAR(255) NOT NULL,
- `description` VARCHAR(999) NOT NULL,
- `code` VARCHAR(255) NOT NULL,
- `price` INT(11) NOT NULL,
- `quantity` INT(11) NOT NULL,
- `costprice` INT(11) NOT NULL,
- `status` INT(11) NOT NULL,
- `date_ordered` VARCHAR(255) NOT NULL,
- `date_delivered` VARCHAR(255) NOT NULL,
- `category` VARCHAR(255) NOT NULL,
- `pic` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `orders`
- --
- INSERT INTO `orders` (`id`, `products`, `customer`, `description`, `code`, `price`, `quantity`, `costprice`, `status`, `date_ordered`, `date_delivered`, `category`, `pic`) VALUES
- (19, 'beef', 'george', 'beef', '935525', 403, 2, 805, 0, '2020-05-05 20:08:53', '', '', ''),
- (20, 'Bestox', 'ann', 'Insecticide', '181478', 2300, 1, 2300, 0, '2020-05-06 08:28:55', '', '', ''),
- (21, 'Domidex ', 'ann', 'Insecticide/ acaricide ', '763511', 920, 3, 2760, 0, '2020-05-06 08:38:42', '', '', ''),
- (22, 'Synergizer', 'ann', 'nutritionous', '763511', 9200, 2, 18400, 0, '2020-05-06 08:39:34', '', '', ''),
- (23, 'Aurora', 'george', 'Post-emergence ', '567073', 575, 5, 2875, 0, '2020-05-06 08:55:52', '', '', ''),
- (24, 'GCMite', 'ndungu', 'Miticide / Insecticide ', '576913', 5750, 3, 17250, 0, '2020-05-06 09:34:30', '', '', ''),
- (25, 'Fosphite 53st', 'kahara', 'Fungicide ', '158481', 5175, 3, 15525, 0, '2020-05-06 09:35:24', '', '', ''),
- (26, 'Wipeout', 'reuben', 'non-selective herbicide ', '400484', 1725, 3, 5175, 0, '2020-05-06 09:36:21', '', '', ''),
- (27, 'GCMite', 'reuben', 'Miticide / Insecticide ', '772730', 5750, 2, 11500, 0, '2020-05-06 10:14:41', '', '', ''),
- (28, 'Aurora', 'george', 'Post-emergence ', '157768', 575, 5, 2875, 0, '2020-05-06 10:22:22', '', '', ''),
- (29, 'Fosphite 53st', 'reuben', 'Fungicide ', '858459', 5175, 3, 15525, 0, '2020-05-06 10:25:30', '', '', ''),
- (30, 'Marshal 250ec', 'ndungu', 'Nematicide', '361553', 3450, 2, 6900, 0, '2020-05-06 10:28:11', '', '', ''),
- (31, 'Marshal 250ec', 'kahara', 'Nematicide', '142065', 3450, 2, 6900, 0, '2020-05-06 10:48:38', '', '', ''),
- (32, 'Marshal 250ec', 'kahara', 'Nematicide', '309744', 3450, 2, 6900, 0, '2020-05-06 10:52:25', '', '', ''),
- (33, 'Marshal 250ec', 'ndungu', 'Nematicide', '387475', 3450, 3, 10350, 0, '2020-05-06 10:54:47', '', '', ''),
- (34, 'Marshal 250ec', 'kahara', 'Nematicide', '743348', 3450, 2, 6900, 0, '2020-05-06 11:23:40', '', '', ''),
- (35, 'Domidex ', 'muthami', 'Insecticide/ acaricide ', '154802', 920, 3, 2760, 0, '2020-05-06 12:43:15', '', '', ''),
- (36, 'Phosgard sl', 'muthami', 'fungal control', '885123', 1150, 6, 6900, 0, '2020-05-06 12:46:22', '', '', ''),
- (37, 'Aurora', 'muthami', 'Post-emergence ', '737609', 575, 2, 1150, 0, '2020-05-06 12:50:33', '', '', '');
- -- --------------------------------------------------------
- --
- -- Table structure for table `paid`
- --
- CREATE TABLE `paid` (
- `id` INT(11) NOT NULL,
- `currentloc` VARCHAR(255) NOT NULL,
- `street` VARCHAR(255) NOT NULL,
- `price` INT(11) NOT NULL,
- `county` VARCHAR(255) NOT NULL,
- `phone` INT(11) NOT NULL,
- `paymode` VARCHAR(255) NOT NULL,
- `codee` VARCHAR(255) NOT NULL,
- `uname` VARCHAR(255) NOT NULL,
- `status` INT(11) NOT NULL,
- `date_paid` VARCHAR(255) NOT NULL,
- `deliverstatus` INT(11) NOT NULL,
- `datedelivered` VARCHAR(255) NOT NULL,
- `staff` VARCHAR(255) DEFAULT NULL,
- `date2deliver` VARCHAR(255) NOT NULL,
- `reason` VARCHAR(500) NOT NULL,
- `paystatus` INT(11) NOT NULL,
- `approvedby` VARCHAR(255) NOT NULL,
- `allocationstatus` INT(16) NOT NULL,
- `dateapproved` DATE NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `paid`
- --
- INSERT INTO `paid` (`id`, `currentloc`, `street`, `price`, `county`, `phone`, `paymode`, `codee`, `uname`, `status`, `date_paid`, `deliverstatus`, `datedelivered`, `staff`, `date2deliver`, `reason`, `paystatus`, `approvedby`, `allocationstatus`, `dateapproved`) VALUES
- (20, 'Mombasa', 'meru ', 2214, 'meru ', 25476767, '', '935525', 'george', 1, '2020-05-04 22:35:27', 1, '', 'john', '', '', 1, 'njeri', 1, '2020-05-06'),
- (21, 'Mombasa', '', 2530, '', 724990092, '', '181478', 'ann', 1, '2020-05-06 08:29:21', 1, '2020-05-06 10:04:51', 'john', '', '', 1, 'james', 1, '2020-05-06'),
- (22, 'Mombasa', '', 23276, '', 724990092, '', '763511', 'ann', 1, '2020-05-06 08:40:02', 0, '', NULL, '', '', 1, '', 0, '0000-00-00'),
- (23, 'Mombasa', 'meru ', 3163, 'meru ', 25476767, '', '567073', 'george', 1, '2020-05-06 08:56:07', 0, '', NULL, '', '', 1, '', 0, '0000-00-00'),
- (24, 'Mombasa', '', 18975, '', 752369852, '', '576913', 'ndungu', 1, '2020-05-06 09:34:46', 0, '', NULL, '', '', 1, '', 0, '0000-00-00'),
- (25, 'Mombasa', '', 17078, '', 754236151, '', '158481', 'kahara', 1, '2020-05-06 09:35:36', 0, '', NULL, '', '', 2, '', 0, '0000-00-00'),
- (26, 'Mombasa', '', 5693, '', 720459426, '', '400484', 'reuben', 1, '2020-05-06 09:36:33', 0, '', NULL, '', '', 0, '', 0, '0000-00-00'),
- (27, 'Mombasa', 'meru ', 3163, 'meru ', 25476767, '', '157768', 'george', 1, '2020-05-06 10:22:48', 1, '2020-05-06 10:47:21', 'john', '', '', 2, 'njeri', 1, '2020-05-06'),
- (28, 'Embu', '', 17078, '', 720459426, '', '858459', 'reuben', 1, '2020-05-06 10:25:48', 1, '2020-05-06 10:44:04', 'john', '', '', 2, 'njeri', 1, '2020-05-06'),
- (29, 'Narok', '', 7590, '', 752369852, '', '361553', 'ndungu', 1, '2020-05-06 10:28:28', 0, '', NULL, '', '', 2, '', 0, '0000-00-00'),
- (30, 'Meru', '', 7590, '', 754236151, '', '142065', 'kahara', 1, '2020-05-06 10:48:57', 0, '', NULL, '', '', 0, '', 0, '0000-00-00'),
- (31, 'Nairobi', '', 7590, '', 754236151, '', '309744', 'kahara', 1, '2020-05-06 10:52:53', 0, '', 'james', '', '', 2, 'njeri', 1, '2020-05-07'),
- (32, 'Nyeri', '', 11385, '', 752369852, '', '387475', 'ndungu', 1, '2020-05-06 10:55:01', 0, '', NULL, '', '', 0, '', 0, '0000-00-00'),
- (33, 'Meru', '', 7590, '', 0, '', '885123', 'muthami', 1, '2020-05-06 12:48:39', 0, '', NULL, '', '', 0, '', 0, '0000-00-00'),
- (34, 'Meru', '', 7590, '', 0, '', '885123', 'muthami', 1, '2020-05-06 12:49:37', 0, '', NULL, '', '', 0, '', 0, '0000-00-00'),
- (35, 'Laikipia', '', 1265, '', 0, '', '737609', 'muthami', 1, '2020-05-06 12:54:51', 1, '2020-05-07 11:13:25', 'john', '', '', 2, 'njeri', 1, '2020-05-06');
- -- --------------------------------------------------------
- --
- -- Table structure for table `payment`
- --
- CREATE TABLE `payment` (
- `id` INT(11) NOT NULL,
- `codes` INT(11) NOT NULL,
- `customer` VARCHAR(255) NOT NULL,
- `sum` INT(11) NOT NULL,
- `total` VARCHAR(255) NOT NULL,
- `transport` VARCHAR(255) NOT NULL,
- `date_paid` VARCHAR(255) NOT NULL,
- `status` INT(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `payment`
- --
- INSERT INTO `payment` (`id`, `codes`, `customer`, `sum`, `total`, `transport`, `date_paid`, `status`) VALUES
- (37, 935525, 'george', 2013, '2213.75', '201.25', '2020-05-04 22:35:08', 1),
- (40, 30147, 'george', 700, '700', '0', '2020-05-06 03:08:03', 0),
- (41, 320847, 'george', 700, '700', '0', '2020-05-06 03:16:49', 0),
- (42, 181478, 'ann', 2300, '2530', '230', '2020-05-06 08:28:55', 1),
- (43, 763511, 'ann', 21160, '23276', '2116', '2020-05-06 08:38:42', 1),
- (44, 567073, 'george', 2875, '3162.5', '287.5', '2020-05-06 08:55:52', 1),
- (45, 576913, 'ndungu', 17250, '18975', '1725', '2020-05-06 09:34:30', 1),
- (46, 158481, 'kahara', 15525, '17077.5', '1552.5', '2020-05-06 09:35:24', 1),
- (47, 400484, 'reuben', 5175, '5692.5', '517.5', '2020-05-06 09:36:22', 0),
- (48, 476177, 'ndungu', 700, '700', '0', '2020-05-06 09:41:05', 0),
- (49, 772730, 'reuben', 11500, '12650', '1150', '2020-05-06 10:14:42', 1),
- (50, 157768, 'george', 2875, '3162.5', '287.5', '2020-05-06 10:22:22', 1),
- (51, 858459, 'reuben', 15525, '17077.5', '1552.5', '2020-05-06 10:25:30', 1),
- (52, 361553, 'ndungu', 6900, '7590', '690', '2020-05-06 10:28:11', 1),
- (53, 142065, 'kahara', 6900, '7590', '690', '2020-05-06 10:48:38', 0),
- (54, 309744, 'kahara', 6900, '7590', '690', '2020-05-06 10:52:25', 1),
- (55, 387475, 'ndungu', 10350, '11385', '1035', '2020-05-06 10:54:47', 0),
- (56, 301430, 'george', 300, '300', '0', '2020-05-06 11:21:53', 0),
- (57, 743348, 'kahara', 6900, '7590', '690', '2020-05-06 11:23:41', 0),
- (58, 655164, 'ndungu', 700, '700', '0', '2020-05-06 11:45:16', 0),
- (59, 154802, 'muthami', 2760, '3036', '276', '2020-05-06 12:43:15', 0),
- (60, 885123, 'muthami', 6900, '7590', '690', '2020-05-06 12:46:22', 0),
- (61, 737609, 'muthami', 1150, '1265', '115', '2020-05-06 12:50:33', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `products`
- --
- CREATE TABLE `products` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- `price` INT(11) NOT NULL,
- `vat` INT(11) NOT NULL,
- `stockable` INT(11) NOT NULL,
- `image` VARCHAR(255) NOT NULL,
- `description` VARCHAR(999) NOT NULL,
- `category` VARCHAR(255) NOT NULL,
- `unitsofm` VARCHAR(255) NOT NULL,
- `cost` DOUBLE NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `products`
- --
- INSERT INTO `products` (`id`, `name`, `price`, `vat`, `stockable`, `image`, `description`, `category`, `unitsofm`, `cost`) VALUES
- (6, 'Bestox', 2000, 300, 0, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202150.png', 'Insecticide', 'service', 'grams', 2300),
- (7, 'GCMite', 5000, 750, 0, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202315.png', 'Miticide / Insecticide ', 'service', 'grams', 5750),
- (8, 'Fosphite 53st', 4500, 675, 2, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202451.png', 'Fungicide ', 'service', 'grams', 5175),
- (9, 'Marshal 250ec', 3000, 450, 1, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202353.png', 'Nematicide', 'service', 'grams', 3450),
- (10, 'Aurora', 500, 75, 488, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202726.png', 'Post-emergence ', 'products', 'grams', 575),
- (11, 'Wipeout', 1500, 225, 2, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202822.png', 'non-selective herbicide ', 'service', 'grams', 1725),
- (12, 'Phosgard sl', 1000, 150, -1, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-202929.png', 'fungal control', 'products', 'ltrs', 1150),
- (13, 'Synergizer', 8000, 1200, 8, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-203008.png', 'nutritionous', 'products', 'ltrs', 9200),
- (14, 'Domidex ', 800, 120, -1, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-203111.png', 'Insecticide/ acaricide ', 'products', 'ltrs', 920),
- (15, 'Metam Sodium', 10000, 1500, 20, 'http://jntechnologies.co.ke/peter/android/images/Screenshot_20200331-203236.png', 'soil fumigant', 'products', 'ltrs', 11500);
- -- --------------------------------------------------------
- --
- -- Table structure for table `purchase_request`
- --
- CREATE TABLE `purchase_request` (
- `id` INT(10) NOT NULL,
- `productId` VARCHAR(10) NOT NULL,
- `quantity` VARCHAR(10) NOT NULL,
- `userid` VARCHAR(10) NOT NULL,
- `cartId` VARCHAR(50) NOT NULL,
- `mpesa` VARCHAR(20) NOT NULL,
- `date_of_purchase` VARCHAR(250) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `purchase_request`
- --
- INSERT INTO `purchase_request` (`id`, `productId`, `quantity`, `userid`, `cartId`, `mpesa`, `date_of_purchase`) VALUES
- (1, '13', '1', '9', '', '', ''),
- (2, '10', '1', '9', '', '', ''),
- (3, '10', '2', '9', '', '', ''),
- (4, '10', '2', '9', '', '', ''),
- (5, '10', '1', '14', '', '', ''),
- (6, '10', '1', '17', '10', '', '2020-05-15'),
- (7, '13', '3', '17', '13', '', '2020-05-15'),
- (8, '10', '1', '17', '17724', '', '2020-05-15'),
- (9, '13', '3', '17', '17724', '', '2020-05-15'),
- (10, '10', '1', '20', '204781', '', '2020-05-16'),
- (11, '8', '1', '20', '203136', 'OV5IFSJNGR', '2020-05-18'),
- (12, '9', '1', '20', '203136', 'OV5IFSJNGR', '2020-05-18');
- -- --------------------------------------------------------
- --
- -- Table structure for table `staff`
- --
- CREATE TABLE `staff` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- `natid` VARCHAR(255) NOT NULL,
- `contact` INT(20) NOT NULL,
- `email` VARCHAR(255) NOT NULL,
- `position` VARCHAR(255) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `password` VARCHAR(255) NOT NULL,
- `location` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `staff`
- --
- INSERT INTO `staff` (`id`, `name`, `natid`, `contact`, `email`, `position`, `username`, `password`, `location`) VALUES
- (7, 'winnie wambui', '987654', 145678, '[email protected]', 'delivery', 'winnie', 'winnie', 'nakuru'),
- -- --------------------------------------------------------
- --
- -- Table structure for table `staffsessions`
- --
- CREATE TABLE `staffsessions` (
- `id` INT(11) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `code` INT(10) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `staffsessions`
- --
- INSERT INTO `staffsessions` (`id`, `username`, `code`) VALUES
- (89, 'kimkam', 238766),
- (90, 'james', 802015),
- (91, 'winnie', 267686),
- (92, 'kimkam', 244866),
- (93, 'kimkam', 121164),
- (94, 'kimkam', 442213),
- (95, 'janet', 791412),
- (96, 'janet', 989660),
- (97, 'james', 115190),
- (98, 'winnie', 947652),
- (99, 'james', 446364),
- (100, 'james', 745495),
- (101, 'kimkam', 289440),
- (102, 'kimkam', 900733),
- (103, 'njeri', 133095),
- (104, 'john', 663178),
- (105, 'kimkam', 283279),
- (106, 'kimkam', 874368),
- (107, 'kimkam', 857469),
- (108, 'kimkam', 775353),
- (109, 'kimkam', 73310),
- (110, 'kimkam', 410552),
- (111, 'kimkam', 273577),
- (112, 'njeri', 116730),
- (113, 'james', 435374),
- (114, 'john', 225738),
- (115, 'njeri', 265591),
- (116, 'njeri', 448086),
- (117, 'njeri', 833906),
- (118, 'john', 770898),
- (119, 'njeri', 481305),
- (120, 'kimkam', 745866),
- (121, 'kimkam', 777552),
- (122, 'kimkam', 699272),
- (123, 'john', 827322),
- (124, 'kimkam', 794622),
- (125, 'njeri', 358747),
- (126, 'janet', 218542),
- (127, 'njeri', 541980),
- (128, 'janet', 887876),
- (129, 'john', 235277),
- (130, 'john', 822006),
- (131, 'john', 667320),
- (132, 'john', 555151),
- (133, 'njeri', 921976),
- (134, 'kimkam', 892132),
- (135, 'njeri', 551950),
- (136, 'john', 799065),
- (137, 'kimkam', 340731),
- (138, 'njeri', 741456),
- (139, 'kimkam', 866065),
- (140, 'kimkam', 81453),
- (141, 'kimkam', 712283),
- (142, 'kimkam', 786079),
- (143, 'njeri', 176446),
- (144, 'john', 401409),
- (145, 'john', 452837),
- (146, 'john', 26360),
- (147, 'njeri', 951580);
- -- --------------------------------------------------------
- --
- -- Table structure for table `vet`
- --
- CREATE TABLE `vet` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- `natid` INT(20) NOT NULL,
- `contact` INT(25) NOT NULL,
- `email` VARCHAR(255) NOT NULL,
- `location` VARCHAR(255) NOT NULL,
- `specialization` VARCHAR(255) NOT NULL,
- `username` VARCHAR(255) NOT NULL,
- `password` VARCHAR(255) NOT NULL,
- `charges` INT(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `vet`
- --
- INSERT INTO `vet` (`id`, `name`, `natid`, `contact`, `email`, `location`, `specialization`, `username`, `password`, `charges`) VALUES
- (5, 'kibaki kiptoo', 35643, 6578652, '[email protected]', 'nakuru', 'drugs', '[email protected]', 'kipkab', 500),
- (6, 'mandela nelson', 879654, 234, '[email protected]', 'nairobi', 'preventive', 'nelson', 'mandela', 700);
- -- --------------------------------------------------------
- --
- -- Table structure for table `vetinary`
- --
- CREATE TABLE `vetinary` (
- `id` INT(11) NOT NULL,
- `vet_name` VARCHAR(255) NOT NULL,
- `client` VARCHAR(255) NOT NULL,
- `categ` VARCHAR(255) NOT NULL,
- `description` VARCHAR(255) NOT NULL,
- `code` VARCHAR(255) NOT NULL,
- `status` INT(11) NOT NULL,
- `date_ordered` DATE NOT NULL,
- `amount` INT(11) NOT NULL,
- `contact` VARCHAR(255) NOT NULL,
- `servicedelivered` INT(11) NOT NULL,
- `datedelivered` DATE NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `vetinary`
- --
- INSERT INTO `vetinary` (`id`, `vet_name`, `client`, `categ`, `description`, `code`, `status`, `date_ordered`, `amount`, `contact`, `servicedelivered`, `datedelivered`) VALUES
- (21, 'Violet Thuku', 'george', 'human', 'gaeus', '695277', 1, '2020-05-04', 4, '25476767', 0, '0000-00-00'),
- (22, 'mwai kamau', 'george', 'clinic', 'fhd', '624779', 1, '2020-05-04', 400, '25476767', 0, '0000-00-00'),
- (23, 'mandela nelson', 'george', 'preventive', '', '30147', 0, '2020-05-06', 0, '', 0, '0000-00-00'),
- (24, 'mandela nelson', 'george', 'preventive', 'artificial insemination', '320847', 1, '2020-05-06', 700, '25476767', 0, '0000-00-00'),
- (25, 'mandela nelson', 'ndungu', 'preventive', 'prevent foot and mouth', '476177', 1, '2020-05-06', 700, '752369852', 0, '0000-00-00'),
- (26, 'barack obama', 'george', 'clinic', 'check up', '301430', 1, '2020-05-06', 300, '25476767', 0, '0000-00-00'),
- (27, 'mandela nelson', 'ndungu', 'preventive', 'prevent foot and month', '655164', 1, '2020-05-06', 700, '752369852', 0, '0000-00-00');
- -- --------------------------------------------------------
- --
- -- Table structure for table `vet_request`
- --
- CREATE TABLE `vet_request` (
- `id` INT(10) NOT NULL,
- `vet_id` INT(20) NOT NULL,
- `user_id` INT(20) NOT NULL,
- `full_names` VARCHAR(50) NOT NULL,
- `phone` VARCHAR(50) NOT NULL,
- `email` VARCHAR(50) NOT NULL,
- `location` VARCHAR(100) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `vet_request`
- --
- INSERT INTO `vet_request` (`id`, `vet_id`, `user_id`, `full_names`, `phone`, `email`, `location`) VALUES
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `admin`
- --
- ALTER TABLE `admin`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `answered`
- --
- ALTER TABLE `answered`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `clients`
- --
- ALTER TABLE `clients`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `feedback`
- --
- ALTER TABLE `feedback`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `login_session`
- --
- ALTER TABLE `login_session`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `orders`
- --
- ALTER TABLE `orders`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `paid`
- --
- ALTER TABLE `paid`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `payment`
- --
- ALTER TABLE `payment`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `products`
- --
- ALTER TABLE `products`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `purchase_request`
- --
- ALTER TABLE `purchase_request`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `staff`
- --
- ALTER TABLE `staff`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `staffsessions`
- --
- ALTER TABLE `staffsessions`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `vet`
- --
- ALTER TABLE `vet`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `vetinary`
- --
- ALTER TABLE `vetinary`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `vet_request`
- --
- ALTER TABLE `vet_request`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `admin`
- --
- ALTER TABLE `admin`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `answered`
- --
- ALTER TABLE `answered`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT for table `clients`
- --
- ALTER TABLE `clients`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
- --
- -- AUTO_INCREMENT for table `feedback`
- --
- ALTER TABLE `feedback`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
- --
- -- AUTO_INCREMENT for table `login_session`
- --
- ALTER TABLE `login_session`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=220;
- --
- -- AUTO_INCREMENT for table `orders`
- --
- ALTER TABLE `orders`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
- --
- -- AUTO_INCREMENT for table `paid`
- --
- ALTER TABLE `paid`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
- --
- -- AUTO_INCREMENT for table `payment`
- --
- ALTER TABLE `payment`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
- --
- -- AUTO_INCREMENT for table `products`
- --
- ALTER TABLE `products`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
- --
- -- AUTO_INCREMENT for table `purchase_request`
- --
- ALTER TABLE `purchase_request`
- MODIFY `id` INT(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
- --
- -- AUTO_INCREMENT for table `staff`
- --
- ALTER TABLE `staff`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT for table `staffsessions`
- --
- ALTER TABLE `staffsessions`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=148;
- --
- -- AUTO_INCREMENT for table `vet`
- --
- ALTER TABLE `vet`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
- --
- -- AUTO_INCREMENT for table `vetinary`
- --
- ALTER TABLE `vetinary`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
- --
- -- AUTO_INCREMENT for table `vet_request`
- --
- ALTER TABLE `vet_request`
- MODIFY `id` INT(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- /*!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 */;
Editor
You can edit this paste and save as new: