text: -- phpMyAdmin SQL Dump
  -- version 4.5.2
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost
  -- Generation Time: Nov 19, 2016 at 11:53 
  -- Server version: 10.1.16-MariaDB
  -- PHP Version: 5.5.38
  
  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: `hosp`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `accountant`
  --
  
  CREATE TABLE `accountant` (
    `accountant_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `accountant`
  --
  
  INSERT INTO `accountant` (`accountant_id`, `name`, `email`, `password`, `address`, `phone`) VALUES
  (1, '', 'accounts@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin`
  --
  
  CREATE TABLE `admin` (
    `admin_id` int(11) NOT NULL,
    `name` longtext COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `admin`
  --
  
  INSERT INTO `admin` (`admin_id`, `name`, `email`, `password`) VALUES
  (1, 'Mr. Admin', 'admin@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'),
  (15, 'chadtims', 'chadwalt04@gmail.com', '37e4b78a0e59885c9b8f2d8266a3827d5b9b5f028b66872adf9c778efb270ba662f09b3d84bdd89c4c542d6c913f5886b7f22480721d1a9b970874e1b992e1411S1NMvULu3HldxY54EFvVVeBYl0MKDHt5bAvE7mFkYw='),
  (14, 'admin@gmail.com', 'chadwalt04@gmail.com', '6db84a25facbedd58d955310530bc45c0385cf422cdad898f309fbaba33d67ea3c568fefc273a375f3f9a1d97e5625a40abc5d94e183652ef78dcc656bacb03bFuDvuykibjRA/wWIblWU6LNx5VdkYAqJAIaaJS3Q9hA=');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `appointment`
  --
  
  CREATE TABLE `appointment` (
    `appointment_id` int(11) NOT NULL,
    `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `doctor_id` int(11) NOT NULL,
    `patient_id` int(11) NOT NULL,
    `status` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `appointment`
  --
  
  INSERT INTO `appointment` (`appointment_id`, `timestamp`, `doctor_id`, `patient_id`, `status`) VALUES
  (1, '1474495500', 1, 1, 'approved');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `bed`
  --
  
  CREATE TABLE `bed` (
    `bed_id` int(11) NOT NULL,
    `bed_number` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `type` longtext NOT NULL COMMENT 'ward,cabin,ICU',
    `status` int(11) NOT NULL DEFAULT '0' COMMENT '0=unalloted;1=alloted',
    `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `bed_allotment`
  --
  
  CREATE TABLE `bed_allotment` (
    `bed_allotment_id` int(11) NOT NULL,
    `bed_id` int(11) NOT NULL,
    `patient_id` int(11) NOT NULL,
    `allotment_timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `discharge_timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blood_bank`
  --
  
  CREATE TABLE `blood_bank` (
    `blood_group_id` int(11) NOT NULL,
    `blood_group` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `status` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blood_donor`
  --
  
  CREATE TABLE `blood_donor` (
    `blood_donor_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `blood_group` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sex` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `age` int(11) NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `last_donation_timestamp` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `blood_donor`
  --
  
  INSERT INTO `blood_donor` (`blood_donor_id`, `name`, `blood_group`, `sex`, `age`, `phone`, `email`, `address`, `last_donation_timestamp`) VALUES
  (1, 'KASIRYE WYCLIFF', 'B+', 'male', 0, '', 'w4wycliff@gmail.com', 'Kampala', 1477000800);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `ci_sessions`
  --
  
  CREATE TABLE `ci_sessions` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
    `data` blob NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `ci_sessions`
  --
  
  INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
  ('005c9594f6d6a7927e4006b1c37faea2ce170593', '::1', 1475158705, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353135383730353b),
  ('042e3671f641d973b164ccd391de61fd3f2ecf43', '::1', 1474987615, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343938373538353b6e757273655f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a353a226e75727365223b),
  ('05cb0e8c4463eef87b9e6abf918cddbb91d3eb6b', '127.0.0.1', 1475547494, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353534373231323b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('084a06849728a4c048707cac3f920d23e198462c', '127.0.0.1', 1475421565, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432313237323b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('0c9a77ecc6d4c67611a9538ce20aa9e14f679593', '::1', 1474832768, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343833323730313b61646d696e5f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a393a224d722e2041646d696e223b6c6f67696e5f747970657c733a353a2261646d696e223b),
  ('0d86f4c2a29c7d326e62ede1d90edd8b5e9cf1dd', '::1', 1475392510, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353339323339323b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('0f82225de94459de5c7de7988948a78b3a9c4741', '127.0.0.1', 1476725499, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437363732353334343b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b61646d696e5f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a393a224d722e2041646d696e223b6c6f67696e5f747970657c733a353a2261646d696e223b),
  ('1455e301961b42bf7d849ceab33dd38868059fca', '127.0.0.1', 1475550690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353535303431373b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('14f359c195887153fe7949724decae1618036d02', '127.0.0.1', 1475422454, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432323232393b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('175f05c4775f3dc3503f99fc79924a0a0e25c056', '127.0.0.1', 1475418880, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353431383833363b6c6173745f706167657c733a34373a22687474703a2f2f6c6f63616c686f73742f686f73706974616c2f696e6465782e7068703f2f6163636f756e74616e74223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('1e3b06ecb6f73f41715af37f7ad6e91e5c606f72', '127.0.0.1', 1475424507, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432343530373b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('1ea2af6cf5998fa7835718c217fe263229e56c7f', '::1', 1475347196, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353334373132393b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('20afb9938a374556c62d20cfdb826acac3bfbb94', '::1', 1475352885, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353335323835323b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('2583e61bb3ad9982fc9f70144d1b73a5785c9de5', '::1', 1475345435, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353334343932323b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('2b5c090ed2af94310f95d853b3c551f48915c888', '::1', 1475329615, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332393537383b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('300d7a904511919fcab7c66bff2cde53dd81fc5e', '127.0.0.1', 1475522969, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353532323936393b),
  ('349afbc7ae13f4abc40ed6a74ba653a0f5dd8fb0', '::1', 1475329690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332393635393b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('3b2edf1de7447b01d5881194ef95e631d36cfad6', '::1', 1475047376, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353034373330383b726563657074696f6e6973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a22726563657074696f6e697374223b),
  ('4216dc7bdaf7233b7fb1e3863b668d906fc399a3', '::1', 1475330132, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332393835313b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('44b5c376e02b95336c8d8a2cd324cbee3d4c961c', '::1', 1475354696, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353335343531363b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('4b8dabf0a1eb60e9fa455cc06f2ac62c894b24c9', '127.0.0.1', 1475423748, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432333731373b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('57389e9a27a7cffbe1d143acc20b66b84fd09776', '127.0.0.1', 1475429638, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432393437323b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('596a17732e2728af2c19fb85080f8ad12bf068dd', '::1', 1474831914, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343833313833393b706861726d61636973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a22706861726d6163697374223b),
  ('59b4323d7f70f35035e48c228e557bc77960aaf7', '127.0.0.1', 1475421198, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432303934303b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('5c904e14e515db4ea6dce671c7b0d5c0653e4433', '127.0.0.1', 1475422677, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432323533353b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('5ed8277679c2afe1f884f58334e4a13a499488ae', '::1', 1475292908, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353239323631353b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('677c53b0488708e894fd014bde5ec37f70e90391', '127.0.0.1', 1475422112, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432313930393b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('6cb151321ea425724f17e116498565fc016ac82a', '127.0.0.1', 1475426699, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432363639393b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('7265fbfba870e31e4e0048e2ab516ba6172bbe02', '::1', 1475295016, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353239353031343b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b),
  ('744cb161113dedcf1f38ca685f6e0253c3655d18', '::1', 1475326442, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332363134353b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b),
  ('7924c83ee424caf8d63f4faa935e62b13ef1286f', '127.0.0.1', 1475551119, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353535303835333b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('79d389f99a138c2977a35c0549993e0a2e955e92', '::1', 1475327603, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332373630333b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('7b20f9a055f15c9dbe014801849fd6cb80d1462c', '127.0.0.1', 1475430201, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432393738333b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('7df0846a0281b64b5da7a9ed854585a1a29e8f8e', '127.0.0.1', 1475424049, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432343034393b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('8401302d2d5f1bd50e7c45fb17377c659d1a08bc', '::1', 1475329428, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332393332303b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('88017c266b190f907d96f9953806feadacc11fdb', '::1', 1475353972, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353335333838313b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b6d6573736167657c733a32393a225465737420526573756c74205361766564205375636365737366756c79223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
  ('88d645fc5fa2158dcad7beaae6312c30c9fb9c1c', '::1', 1475326868, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332363832333b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('8ad62af7842e755ebb9aeb849c086e1128830766', '::1', 1474988484, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343938383437323b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('8b7e4378d99cc7355ae003ce5d14b07a7dd79138', '::1', 1475343449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353334333431313b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('8d71616c07084f6eca7d4d42ef26ef71a8638989', '::1', 1475318235, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353331383231303b6c6173745f706167657c733a37393a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f72697374223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('8ddf2675ffedb88bdc225c0833e964d1e2af3552', '127.0.0.1', 1476178607, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437363137383630373b),
  ('8f516faac9b2d53b14ea066e252dad4f5069459a', '127.0.0.1', 1476724279, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437363732343235393b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b),
  ('90351241ac40c71e7f7e1276560363371e501ebf', '::1', 1475377048, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353337363935313b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('a0cfb4c1489bf61017c4d4df6fe31f8ce9609718', '::1', 1475326792, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332363530333b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('a52f6d77b4d5ea71b02227f586bb2158e11dadd5', '127.0.0.1', 1475549188, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353534393137373b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('a727cfe2f0c6be35b06bd7502acf341aae8114b1', '::1', 1475394115, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353339343131353b),
  ('ad0fdd2909c23663eb4f6dccffc0204ea2d03873', '::1', 1475379232, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353337393233323b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('ae14c83ce6f5fdfb8e1c706a2d11385f91ecf8cc', '::1', 1475378737, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353337383431373b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('ba6e10f2dca9faa01c3fb535354656255b3e46d7', '127.0.0.1', 1476210407, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437363231303430373b),
  ('bd42067cabea0e44684307bc8b828736f8e006dd', '::1', 1475392953, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353339323735313b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('c3beaa9d9f9505e03a53d5c57d32c3f8b6f71253', '::1', 1475377954, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353337373932353b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('c3e03951cf5b6f15b533cd738f06cc2942b2ba01', '127.0.0.1', 1475547815, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353534373831303b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('cabdc4d4f2440db5221366af4a00b91bda0ebf71', '::1', 1475328915, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332383931353b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('cc6adcee57752afc4faa4d2288cbb173dafddb9d', '::1', 1475354260, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353335343138353b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('d085e79fe64991ca90ef74f8484a3a705a13d2b2', '127.0.0.1', 1475427963, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432373433323b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('d2456255c63e0f1d8688c124dda19ac1b2a27e84', '127.0.0.1', 1475421890, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432313539353b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('d2d3df57856418d2dd2888fbc062b70458df5541', '::1', 1475381957, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353338313731373b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b6d6573736167657c733a32393a225465737420526573756c74205361766564205375636365737366756c79223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
  ('d3bd8f3ce716818e462239e3bcc43ce4b5a01c21', '::1', 1475378804, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353337383734343b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('d4ee363868df512384242f3639bcbbce7863170f', '::1', 1475329239, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353332393232303b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('d71cc91bd5e967f8d3a6ad943efb69593d233a94', '::1', 1475346497, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353334363434373b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('d7fb2b14f4204567fd77dfe2714dc6355110c53f', '127.0.0.1', 1475527311, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353532373133363b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('dd831a9ccbee7c7e06c16aaa3825356d132eea8c', '127.0.0.1', 1476725342, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437363732343633303b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b61646d696e5f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a393a224d722e2041646d696e223b6c6f67696e5f747970657c733a353a2261646d696e223b),
  ('e1068ce207f291e93cc4950ec899235889cde986', '::1', 1475047262, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353034363932333b726563657074696f6e6973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a22726563657074696f6e697374223b),
  ('e1f3cbe0eb3514f08d44c23ecc3ce50d51486a0b', '::1', 1475293849, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353239333834383b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b6c6173745f706167657c733a37343a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f70617469656e74223b),
  ('e754050e1307470fab3986bef306894e00d8f090', '::1', 1474988261, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343938383132373b646f63746f725f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a31353a224b415349525945205759434c494646223b6c6f67696e5f747970657c733a363a22646f63746f72223b),
  ('e8a3b79a4d7efdf4db6a6dbae320c415d1d66e0a', '127.0.0.1', 1475548468, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353534383433343b6c6173745f706167657c733a36343a22687474703a2f2f6c6f63616c686f73742f486f73706974616c2f696e6465782e7068703f2f6163636f756e74616e742f70617469656e745f7061796d656e7473223b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('e9a76058e7daee6395fb6db0e4d5b4533926bd07', '127.0.0.1', 1475420754, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353432303539363b6163636f756e74616e745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31303a226163636f756e74616e74223b),
  ('eaa01855aecdc73db958161d02b4989b134cf05f', '::1', 1475319659, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353331393633313b6e757273655f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a353a226e75727365223b),
  ('ef7d7b4108bbf47cff74f94787b432b5e8daed34', '::1', 1475344716, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353334343535303b6c6173745f706167657c733a39323a22687474703a2f2f6c6f63616c686f73742f626179616e6e6f20686f73706974616c206d616e6167656d656e742073797374656d2070726f2f696e6465782e7068703f2f6c61626f7261746f726973742f6d616e6167655f7465737473223b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('f2b8386bdd1601e3b9554067f5fe604558e87f72', '::1', 1475381223, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353338303837323b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('fcbf7fd4debf4bad2b70b8c0a18468d03ddf0b74', '127.0.0.1', 1475418909, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353431383930393b),
  ('ff7b58d3753811172ff74dc2f5d1374d516e840a', '::1', 1475293496, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353239333336313b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b),
  ('ffeebca9ac2c03cdae082a7722760de2dabf7153', '::1', 1475381259, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437353338313232343b6c61626f7261746f726973745f6c6f67696e7c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a303a22223b6c6f67696e5f747970657c733a31323a226c61626f7261746f72697374223b);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `currency`
  --
  
  CREATE TABLE `currency` (
    `currency_id` int(11) NOT NULL,
    `currency_code` longtext COLLATE utf8_unicode_ci NOT NULL,
    `currency_symbol` longtext COLLATE utf8_unicode_ci NOT NULL,
    `currency_name` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `department`
  --
  
  CREATE TABLE `department` (
    `department_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `department`
  --
  
  INSERT INTO `department` (`department_id`, `name`, `description`) VALUES
  (1, 'Doctor', 'Doctor'),
  (2, 'Inventory', 'Store items'),
  (3, 'Store Keeping', 'All tems are avaliable'),
  (9, 'Labs', 'equpiments entrin'),
  (5, 'Medicine', 'Drugs stores n eqip'),
  (8, 'Nurse equipments', 'nurses are dope'),
  (11, 'computer science', 'new department'),
  (10, 'you lab', 'werew'),
  (12, 'Bio tech', 'This includes all lab equipments');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `diagnosis_report`
  --
  
  CREATE TABLE `diagnosis_report` (
    `diagnosis_report_id` int(11) NOT NULL,
    `report_type` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'xray,blood test',
    `document_type` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'text,photo',
    `file_name` longtext COLLATE utf8_unicode_ci NOT NULL,
    `prescription_id` int(11) NOT NULL,
    `description` longtext COLLATE utf8_unicode_ci NOT NULL,
    `timestamp` int(11) NOT NULL,
    `laboratorist_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `doctor`
  --
  
  CREATE TABLE `doctor` (
    `doctor_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `department_id` int(11) NOT NULL,
    `profile` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `doctor`
  --
  
  INSERT INTO `doctor` (`doctor_id`, `name`, `email`, `password`, `address`, `phone`, `department_id`, `profile`) VALUES
  (1, 'KASIRYE WYCLIFF', 'doctor@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '            KAMPALA                                                        ', '0755754728', 1, '                                                                    ');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_template`
  --
  
  CREATE TABLE `email_template` (
    `email_template_id` int(11) NOT NULL,
    `task` longtext COLLATE utf8_unicode_ci NOT NULL,
    `subject` longtext COLLATE utf8_unicode_ci NOT NULL,
    `body` longtext COLLATE utf8_unicode_ci NOT NULL,
    `instruction` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `form_element`
  --
  
  CREATE TABLE `form_element` (
    `form_element_id` int(11) NOT NULL,
    `type` longtext COLLATE utf8_unicode_ci NOT NULL,
    `html` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `invoice`
  --
  
  CREATE TABLE `invoice` (
    `invoice_id` int(11) NOT NULL,
    `invoice_number` longtext COLLATE utf8_unicode_ci NOT NULL,
    `patient_id` int(11) NOT NULL,
    `title` longtext COLLATE utf8_unicode_ci NOT NULL,
    `invoice_entries` longtext COLLATE utf8_unicode_ci NOT NULL,
    `creation_timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `due_timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `status` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'paid or unpaid',
    `vat_percentage` longtext COLLATE utf8_unicode_ci NOT NULL,
    `discount_amount` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `laboratorist`
  --
  
  CREATE TABLE `laboratorist` (
    `laboratorist_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `laboratorist`
  --
  
  INSERT INTO `laboratorist` (`laboratorist_id`, `name`, `email`, `password`, `address`, `phone`) VALUES
  (1, '', 'lab@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `lab_results`
  --
  
  CREATE TABLE `lab_results` (
    `id` int(11) NOT NULL,
    `patient_id` int(11) NOT NULL,
    `lab_test` varchar(15) NOT NULL,
    `test_result` varchar(12) NOT NULL,
    `date_taken` varchar(12) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `lab_results`
  --
  
  INSERT INTO `lab_results` (`id`, `patient_id`, `lab_test`, `test_result`, `date_taken`) VALUES
  (1, 0, 'Malaria', 'Positive', '0000-00-00'),
  (2, 0, 'Hiv ', 'Negative', '0000-00-00'),
  (3, 0, 'Malaria', 'Negative', '0000-00-00'),
  (4, 1, 'Malaria', 'Positive', '2016-10-02'),
  (5, 1, 'Malaria', 'Negative', '02-10-2016');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `lab_tests`
  --
  
  CREATE TABLE `lab_tests` (
    `id` int(11) NOT NULL,
    `name` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `lab_tests`
  --
  
  INSERT INTO `lab_tests` (`id`, `name`) VALUES
  (1, 'Malaria'),
  (2, 'Hiv ');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `language`
  --
  
  CREATE TABLE `language` (
    `phrase_id` int(11) NOT NULL,
    `phrase` longtext COLLATE utf8_unicode_ci NOT NULL,
    `english` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `medicine`
  --
  
  CREATE TABLE `medicine` (
    `id` int(11) NOT NULL,
    `name` varchar(30) NOT NULL,
    `batch_nbr` varchar(30) NOT NULL,
    `category` varchar(30) NOT NULL,
    `type` varchar(30) NOT NULL,
    `mfg_date` date NOT NULL,
    `exp_date` date NOT NULL,
    `supplier` varchar(30) NOT NULL,
    `quantity` int(11) NOT NULL,
    `cost_price` varchar(12) NOT NULL,
    `selling_price` varchar(12) NOT NULL,
    `date_received` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `medicine`
  --
  
  INSERT INTO `medicine` (`id`, `name`, `batch_nbr`, `category`, `type`, `mfg_date`, `exp_date`, `supplier`, `quantity`, `cost_price`, `selling_price`, `date_received`) VALUES
  (1, 'spirit', '3', '2', 'medial', '2016-11-19', '2016-11-24', '2', 3, '700', '60000', '2016-11-26'),
  (3, 'panadol', '3', '2', 'medical', '2016-11-25', '2016-11-30', '2', 7, '30', '4000', '2016-11-26'),
  (4, 'Aspriin', '3', '2', 'mecial', '2016-11-25', '2016-11-30', '2', 3, '5000', '39900', '2016-11-26');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `medicine_category`
  --
  
  CREATE TABLE `medicine_category` (
    `medicine_category_id` int(11) NOT NULL,
    `name` longtext COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `medicine_categorys`
  --
  
  CREATE TABLE `medicine_categorys` (
    `id` int(11) NOT NULL,
    `name` varchar(30) NOT NULL,
    `description` varchar(200) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `medicine_categorys`
  --
  
  INSERT INTO `medicine_categorys` (`id`, `name`, `description`) VALUES
  (2, 'Drugs store', 'all items in the drug store');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `medicine_suppliers`
  --
  
  CREATE TABLE `medicine_suppliers` (
    `id` int(11) NOT NULL,
    `name` varchar(25) NOT NULL,
    `phone` varchar(20) NOT NULL,
    `email` varchar(25) NOT NULL,
    `address` varchar(15) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `medicine_suppliers`
  --
  
  INSERT INTO `medicine_suppliers` (`id`, `name`, `phone`, `email`, `address`) VALUES
  (2, 'Nalunga stellar', '03383883', 'stella@gmail.com', 'ntinda');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `message`
  --
  
  CREATE TABLE `message` (
    `message_id` int(11) NOT NULL,
    `message_thread_code` longtext NOT NULL,
    `message` longtext NOT NULL,
    `sender` longtext NOT NULL,
    `timestamp` longtext NOT NULL,
    `read_status` int(11) NOT NULL DEFAULT '0' COMMENT '0 unread 1 read'
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `message_thread`
  --
  
  CREATE TABLE `message_thread` (
    `message_thread_id` int(11) NOT NULL,
    `message_thread_code` longtext COLLATE utf8_unicode_ci NOT NULL,
    `sender` longtext COLLATE utf8_unicode_ci NOT NULL,
    `reciever` longtext COLLATE utf8_unicode_ci NOT NULL,
    `last_message_timestamp` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `note`
  --
  
  CREATE TABLE `note` (
    `note_id` int(11) NOT NULL,
    `note` longtext COLLATE utf8_unicode_ci NOT NULL,
    `user_type` longtext COLLATE utf8_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `color` longtext COLLATE utf8_unicode_ci NOT NULL,
    `timestamp_create` longtext COLLATE utf8_unicode_ci NOT NULL,
    `timestamp_last_update` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notice`
  --
  
  CREATE TABLE `notice` (
    `notice_id` int(11) NOT NULL,
    `title` longtext COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext COLLATE utf8_unicode_ci NOT NULL,
    `start_timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `end_timestamp` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `notice`
  --
  
  INSERT INTO `notice` (`notice_id`, `title`, `description`, `start_timestamp`, `end_timestamp`) VALUES
  (1, 'Meeting', 'Meeting', '1475359200', '1475359200');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `noticeboard`
  --
  
  CREATE TABLE `noticeboard` (
    `notice_id` int(11) NOT NULL,
    `notice_title` longtext COLLATE utf8_unicode_ci NOT NULL,
    `notice` longtext COLLATE utf8_unicode_ci NOT NULL,
    `create_timestamp` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `nurse`
  --
  
  CREATE TABLE `nurse` (
    `nurse_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `nurse`
  --
  
  INSERT INTO `nurse` (`nurse_id`, `name`, `email`, `password`, `address`, `phone`) VALUES
  (1, '', 'nurse@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `patient`
  --
  
  CREATE TABLE `patient` (
    `patient_id` int(11) NOT NULL,
    `name` longtext COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `address` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `gender` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
    `birth_date` date DEFAULT NULL,
    `age` int(3) DEFAULT NULL,
    `blood_group` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `account_opening_timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `picture` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `patient`
  --
  
  INSERT INTO `patient` (`patient_id`, `name`, `email`, `address`, `phone`, `gender`, `birth_date`, `age`, `blood_group`, `account_opening_timestamp`, `picture`) VALUES
  (3, 'Kasirye Wycliff peeing', 'w4wycliff@outlook.co', 'bunga gaba', '8383838', 'M', '2016-11-16', 10, 'B', '2016-11-09 17:41:49', 'Kasirye_Wycliff_peeing1.png');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `patient_payments`
  --
  
  CREATE TABLE `patient_payments` (
    `id` bigint(20) NOT NULL,
    `patient_id` bigint(20) NOT NULL,
    `payment_date` date NOT NULL,
    `Dr` double NOT NULL DEFAULT '0',
    `Cr` double NOT NULL DEFAULT '0',
    `entry_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `patient_payments`
  --
  
  INSERT INTO `patient_payments` (`id`, `patient_id`, `payment_date`, `Dr`, `Cr`, `entry_id`) VALUES
  (1, 1, '2016-10-02', 120000, 0, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment`
  --
  
  CREATE TABLE `payment` (
    `payment_id` int(11) NOT NULL,
    `type` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'income expense',
    `amount` longtext COLLATE utf8_unicode_ci NOT NULL,
    `title` longtext COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext COLLATE utf8_unicode_ci NOT NULL,
    `payment_method` longtext COLLATE utf8_unicode_ci NOT NULL,
    `invoice_number` longtext COLLATE utf8_unicode_ci NOT NULL,
    `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pharmacist`
  --
  
  CREATE TABLE `pharmacist` (
    `pharmacist_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pharmacist`
  --
  
  INSERT INTO `pharmacist` (`pharmacist_id`, `name`, `email`, `password`, `address`, `phone`) VALUES
  (1, '', 'pharmacy@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `prescription`
  --
  
  CREATE TABLE `prescription` (
    `prescription_id` int(11) NOT NULL,
    `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `doctor_id` int(11) NOT NULL,
    `patient_id` int(11) NOT NULL,
    `case_history` longtext COLLATE utf8_unicode_ci NOT NULL,
    `medication` longtext COLLATE utf8_unicode_ci NOT NULL,
    `note` longtext COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `receptionist`
  --
  
  CREATE TABLE `receptionist` (
    `receptionist_id` int(11) NOT NULL,
    `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `receptionist`
  --
  
  INSERT INTO `receptionist` (`receptionist_id`, `name`, `email`, `password`, `address`, `phone`) VALUES
  (1, '', 'receiption@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `report`
  --
  
  CREATE TABLE `report` (
    `report_id` int(11) NOT NULL,
    `type` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'operation,birth,death',
    `description` longtext COLLATE utf8_unicode_ci NOT NULL,
    `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
    `doctor_id` int(11) NOT NULL,
    `patient_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `settings_id` int(11) NOT NULL,
    `type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `settings`
  --
  
  INSERT INTO `settings` (`settings_id`, `type`, `description`) VALUES
  (1, 'system_name', 'Hospital Management System'),
  (2, 'system_title', 'Hospital Management System'),
  (3, 'address', 'Kampala, Uganda'),
  (4, 'phone', '+8012654159'),
  (5, 'paypal_email', 'payment@creativeitem.com'),
  (6, 'currency', 'Ugx'),
  (7, 'system_email', 'admin@example.com'),
  (8, 'buyer', ''),
  (9, 'purchase_code', ''),
  (11, 'language', 'english'),
  (12, 'text_align', 'left-to-right'),
  (13, 'system_currency_id', '1'),
  (14, 'clickatell_user', '[YOUR CLICKATELL USERNAME]'),
  (15, 'clickatell_password', '[YOUR CLICKATELL PASSWORD]'),
  (16, 'clickatell_api_id', '[YOUR CLICKATELL API ID]');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `full_name` varchar(30) NOT NULL,
    `email` varchar(30) DEFAULT NULL,
    `address` varchar(100) NOT NULL,
    `gender` char(1) NOT NULL,
    `contact` varchar(20) NOT NULL,
    `username` varchar(20) NOT NULL,
    `password` varchar(200) NOT NULL,
    `picture` varchar(50) DEFAULT NULL,
    `positions` varchar(15) NOT NULL,
    `active_status` tinyint(1) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `full_name`, `email`, `address`, `gender`, `contact`, `username`, `password`, `picture`, `positions`, `active_status`) VALUES
  (1, 'Kyadondo Timothy', 'chadwalt@outlook.com', 'Gaba', 'M', '0383838', 'admin', 'bdbd6c27758742e9b42cef320c0aa892cfebaba8161fa582b956ecbabcbaa998631b33a6b8b05120c548d712e648c8f308b42deb7ce7dbbebf93f9c3e5ec77959x+uYl0sFjyUCxDmtD8rrEqT0JQLVOUaJaWm6qasta0=', NULL, 'admin', 0),
  (4, 'mubiru paul', 'jones@gmail.com', 'Monyonyo', 'M', '07383838838', 'paul jones', 'ca3bd2b80ef9263e9580bccc483d5dfd28c0a7e879a6dafaf777fce14d4cfff82e4dab3f4d450cc4f516efd6b7e933809c5dab8078acdaf5aaa8be3057c6982bF+PihhdM/nZt/rZKu3vWQm3o9ifFxvkm3xk+2x8DSTc=', 'mubiru_paul.png', 'accountant', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_entries`
  --
  
  CREATE TABLE `webzash_entries` (
    `id` bigint(18) NOT NULL,
    `tag_id` bigint(18) DEFAULT NULL,
    `entrytype_id` bigint(18) NOT NULL,
    `number` bigint(18) DEFAULT NULL,
    `date` date NOT NULL,
    `dr_total` decimal(25,2) NOT NULL DEFAULT '0.00',
    `cr_total` decimal(25,2) NOT NULL DEFAULT '0.00',
    `narration` varchar(500) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_entryitems`
  --
  
  CREATE TABLE `webzash_entryitems` (
    `id` bigint(18) NOT NULL,
    `entry_id` bigint(18) NOT NULL,
    `ledger_id` bigint(18) NOT NULL,
    `amount` decimal(25,2) NOT NULL DEFAULT '0.00',
    `dc` char(1) COLLATE utf8_unicode_ci NOT NULL,
    `reconciliation_date` date DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_entrytypes`
  --
  
  CREATE TABLE `webzash_entrytypes` (
    `id` bigint(18) NOT NULL,
    `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `base_type` int(2) NOT NULL DEFAULT '0',
    `numbering` int(2) NOT NULL DEFAULT '1',
    `prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `suffix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `zero_padding` int(2) NOT NULL DEFAULT '0',
    `restriction_bankcash` int(2) NOT NULL DEFAULT '1'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `webzash_entrytypes`
  --
  
  INSERT INTO `webzash_entrytypes` (`id`, `label`, `name`, `description`, `base_type`, `numbering`, `prefix`, `suffix`, `zero_padding`, `restriction_bankcash`) VALUES
  (1, 'receipt', 'Receipt', 'Received in Bank account or Cash account', 1, 1, '', '', 0, 2),
  (2, 'payment', 'Payment', 'Payment made from Bank account or Cash account', 1, 1, '', '', 0, 3),
  (3, 'contra', 'Contra', 'Transfer between Bank account and Cash account', 1, 1, '', '', 0, 4),
  (4, 'journal', 'Journal', 'Transfer between Non Bank account and Cash account', 1, 1, '', '', 0, 5);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_groups`
  --
  
  CREATE TABLE `webzash_groups` (
    `id` bigint(18) NOT NULL,
    `parent_id` bigint(18) DEFAULT '0',
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `affects_gross` int(1) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `webzash_groups`
  --
  
  INSERT INTO `webzash_groups` (`id`, `parent_id`, `name`, `code`, `affects_gross`) VALUES
  (1, NULL, 'Assets', NULL, 0),
  (2, NULL, 'Liabilities and Owners Equity', NULL, 0),
  (3, NULL, 'Incomes', NULL, 0),
  (4, NULL, 'Expenses', NULL, 0),
  (5, 1, 'Fixed Assets', NULL, 0),
  (6, 1, 'Current Assets', NULL, 0),
  (7, 1, 'Investments', NULL, 0),
  (8, 2, 'Capital Account', NULL, 0),
  (9, 2, 'Current Liabilities', NULL, 0),
  (10, 2, 'Loans (Liabilities)', NULL, 0),
  (11, 3, 'Direct Incomes', NULL, 1),
  (12, 4, 'Direct Expenses', NULL, 1),
  (13, 3, 'Indirect Incomes', NULL, 0),
  (14, 4, 'Indirect Expenses', NULL, 0),
  (15, 3, 'Sales', NULL, 1),
  (16, 4, 'Purchases', NULL, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_ledgers`
  --
  
  CREATE TABLE `webzash_ledgers` (
    `id` bigint(18) NOT NULL,
    `group_id` bigint(18) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `op_balance` decimal(25,2) NOT NULL DEFAULT '0.00',
    `op_balance_dc` char(1) COLLATE utf8_unicode_ci NOT NULL,
    `type` int(2) NOT NULL DEFAULT '0',
    `reconciliation` int(1) NOT NULL DEFAULT '0',
    `notes` varchar(500) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `webzash_ledgers`
  --
  
  INSERT INTO `webzash_ledgers` (`id`, `group_id`, `name`, `code`, `op_balance`, `op_balance_dc`, `type`, `reconciliation`, `notes`) VALUES
  (1, 6, 'DFCU', NULL, '0.00', 'D', 1, 0, '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_logs`
  --
  
  CREATE TABLE `webzash_logs` (
    `id` bigint(18) NOT NULL,
    `date` datetime NOT NULL,
    `level` int(1) NOT NULL,
    `host_ip` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
    `user` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
    `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `user_agent` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_settings`
  --
  
  CREATE TABLE `webzash_settings` (
    `id` int(1) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `fy_start` date NOT NULL,
    `fy_end` date NOT NULL,
    `currency_symbol` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `currency_format` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `decimal_places` int(2) NOT NULL DEFAULT '2',
    `date_format` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `timezone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `manage_inventory` int(1) NOT NULL DEFAULT '0',
    `account_locked` int(1) NOT NULL DEFAULT '0',
    `email_use_default` int(1) NOT NULL DEFAULT '0',
    `email_protocol` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `email_host` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_port` int(5) NOT NULL,
    `email_tls` int(1) NOT NULL DEFAULT '0',
    `email_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `print_paper_height` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_paper_width` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_margin_top` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_margin_bottom` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_margin_left` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_margin_right` decimal(10,3) NOT NULL DEFAULT '0.000',
    `print_orientation` char(1) COLLATE utf8_unicode_ci NOT NULL,
    `print_page_format` char(1) COLLATE utf8_unicode_ci NOT NULL,
    `database_version` int(10) NOT NULL,
    `settings` blob
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `webzash_settings`
  --
  
  INSERT INTO `webzash_settings` (`id`, `name`, `address`, `email`, `fy_start`, `fy_end`, `currency_symbol`, `currency_format`, `decimal_places`, `date_format`, `timezone`, `manage_inventory`, `account_locked`, `email_use_default`, `email_protocol`, `email_host`, `email_port`, `email_tls`, `email_username`, `email_password`, `email_from`, `print_paper_height`, `print_paper_width`, `print_margin_top`, `print_margin_bottom`, `print_margin_left`, `print_margin_right`, `print_orientation`, `print_page_format`, `database_version`, `settings`) VALUES
  (1, 'Hospital', 'Gaba', 'hospital@gmail.com', '2016-10-02', '2017-10-01', 'UGX', 'none', 2, 'd-M-Y|dd-M-yy', 'UTC', 0, 0, 1, 'Smtp', '', 0, 0, '', '', '', '0.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'P', 'H', 6, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `webzash_tags`
  --
  
  CREATE TABLE `webzash_tags` (
    `id` bigint(18) NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `color` char(6) COLLATE utf8_unicode_ci NOT NULL,
    `background` char(6) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `accountant`
  --
  ALTER TABLE `accountant`
    ADD PRIMARY KEY (`accountant_id`);
  
  --
  -- Indexes for table `admin`
  --
  ALTER TABLE `admin`
    ADD PRIMARY KEY (`admin_id`);
  
  --
  -- Indexes for table `appointment`
  --
  ALTER TABLE `appointment`
    ADD PRIMARY KEY (`appointment_id`);
  
  --
  -- Indexes for table `bed`
  --
  ALTER TABLE `bed`
    ADD PRIMARY KEY (`bed_id`);
  
  --
  -- Indexes for table `bed_allotment`
  --
  ALTER TABLE `bed_allotment`
    ADD PRIMARY KEY (`bed_allotment_id`);
  
  --
  -- Indexes for table `blood_bank`
  --
  ALTER TABLE `blood_bank`
    ADD PRIMARY KEY (`blood_group_id`);
  
  --
  -- Indexes for table `blood_donor`
  --
  ALTER TABLE `blood_donor`
    ADD PRIMARY KEY (`blood_donor_id`);
  
  --
  -- Indexes for table `ci_sessions`
  --
  ALTER TABLE `ci_sessions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `ci_sessions_timestamp` (`timestamp`);
  
  --
  -- Indexes for table `currency`
  --
  ALTER TABLE `currency`
    ADD PRIMARY KEY (`currency_id`);
  
  --
  -- Indexes for table `department`
  --
  ALTER TABLE `department`
    ADD PRIMARY KEY (`department_id`);
  
  --
  -- Indexes for table `diagnosis_report`
  --
  ALTER TABLE `diagnosis_report`
    ADD PRIMARY KEY (`diagnosis_report_id`);
  
  --
  -- Indexes for table `doctor`
  --
  ALTER TABLE `doctor`
    ADD PRIMARY KEY (`doctor_id`);
  
  --
  -- Indexes for table `email_template`
  --
  ALTER TABLE `email_template`
    ADD PRIMARY KEY (`email_template_id`);
  
  --
  -- Indexes for table `form_element`
  --
  ALTER TABLE `form_element`
    ADD PRIMARY KEY (`form_element_id`);
  
  --
  -- Indexes for table `invoice`
  --
  ALTER TABLE `invoice`
    ADD PRIMARY KEY (`invoice_id`);
  
  --
  -- Indexes for table `laboratorist`
  --
  ALTER TABLE `laboratorist`
    ADD PRIMARY KEY (`laboratorist_id`);
  
  --
  -- Indexes for table `lab_results`
  --
  ALTER TABLE `lab_results`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `lab_tests`
  --
  ALTER TABLE `lab_tests`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `language`
  --
  ALTER TABLE `language`
    ADD PRIMARY KEY (`phrase_id`);
  
  --
  -- Indexes for table `medicine`
  --
  ALTER TABLE `medicine`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `medicine_category`
  --
  ALTER TABLE `medicine_category`
    ADD PRIMARY KEY (`medicine_category_id`);
  
  --
  -- Indexes for table `medicine_categorys`
  --
  ALTER TABLE `medicine_categorys`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `medicine_suppliers`
  --
  ALTER TABLE `medicine_suppliers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `message`
  --
  ALTER TABLE `message`
    ADD PRIMARY KEY (`message_id`);
  
  --
  -- Indexes for table `message_thread`
  --
  ALTER TABLE `message_thread`
    ADD PRIMARY KEY (`message_thread_id`);
  
  --
  -- Indexes for table `note`
  --
  ALTER TABLE `note`
    ADD PRIMARY KEY (`note_id`);
  
  --
  -- Indexes for table `notice`
  --
  ALTER TABLE `notice`
    ADD PRIMARY KEY (`notice_id`);
  
  --
  -- Indexes for table `noticeboard`
  --
  ALTER TABLE `noticeboard`
    ADD PRIMARY KEY (`notice_id`);
  
  --
  -- Indexes for table `nurse`
  --
  ALTER TABLE `nurse`
    ADD PRIMARY KEY (`nurse_id`);
  
  --
  -- Indexes for table `patient`
  --
  ALTER TABLE `patient`
    ADD PRIMARY KEY (`patient_id`);
  
  --
  -- Indexes for table `patient_payments`
  --
  ALTER TABLE `patient_payments`
    ADD PRIMARY KEY (`id`),
    ADD KEY `patient_indx` (`patient_id`);
  
  --
  -- Indexes for table `payment`
  --
  ALTER TABLE `payment`
    ADD PRIMARY KEY (`payment_id`);
  
  --
  -- Indexes for table `pharmacist`
  --
  ALTER TABLE `pharmacist`
    ADD PRIMARY KEY (`pharmacist_id`);
  
  --
  -- Indexes for table `prescription`
  --
  ALTER TABLE `prescription`
    ADD PRIMARY KEY (`prescription_id`);
  
  --
  -- Indexes for table `receptionist`
  --
  ALTER TABLE `receptionist`
    ADD PRIMARY KEY (`receptionist_id`);
  
  --
  -- Indexes for table `report`
  --
  ALTER TABLE `report`
    ADD PRIMARY KEY (`report_id`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`settings_id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `webzash_entries`
  --
  ALTER TABLE `webzash_entries`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD KEY `id` (`id`),
    ADD KEY `tag_id` (`tag_id`),
    ADD KEY `entrytype_id` (`entrytype_id`);
  
  --
  -- Indexes for table `webzash_entryitems`
  --
  ALTER TABLE `webzash_entryitems`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD KEY `id` (`id`),
    ADD KEY `entry_id` (`entry_id`),
    ADD KEY `ledger_id` (`ledger_id`);
  
  --
  -- Indexes for table `webzash_entrytypes`
  --
  ALTER TABLE `webzash_entrytypes`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD UNIQUE KEY `label` (`label`),
    ADD KEY `id` (`id`);
  
  --
  -- Indexes for table `webzash_groups`
  --
  ALTER TABLE `webzash_groups`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD UNIQUE KEY `name` (`name`),
    ADD UNIQUE KEY `code` (`code`),
    ADD KEY `id` (`id`),
    ADD KEY `parent_id` (`parent_id`);
  
  --
  -- Indexes for table `webzash_ledgers`
  --
  ALTER TABLE `webzash_ledgers`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD UNIQUE KEY `name` (`name`),
    ADD UNIQUE KEY `code` (`code`),
    ADD KEY `id` (`id`),
    ADD KEY `group_id` (`group_id`);
  
  --
  -- Indexes for table `webzash_logs`
  --
  ALTER TABLE `webzash_logs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD KEY `id` (`id`);
  
  --
  -- Indexes for table `webzash_settings`
  --
  ALTER TABLE `webzash_settings`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD KEY `id` (`id`);
  
  --
  -- Indexes for table `webzash_tags`
  --
  ALTER TABLE `webzash_tags`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_id` (`id`),
    ADD UNIQUE KEY `title` (`title`),
    ADD KEY `id` (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `accountant`
  --
  ALTER TABLE `accountant`
    MODIFY `accountant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `admin`
  --
  ALTER TABLE `admin`
    MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  --
  -- AUTO_INCREMENT for table `appointment`
  --
  ALTER TABLE `appointment`
    MODIFY `appointment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `bed`
  --
  ALTER TABLE `bed`
    MODIFY `bed_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `bed_allotment`
  --
  ALTER TABLE `bed_allotment`
    MODIFY `bed_allotment_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `blood_bank`
  --
  ALTER TABLE `blood_bank`
    MODIFY `blood_group_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `blood_donor`
  --
  ALTER TABLE `blood_donor`
    MODIFY `blood_donor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `currency`
  --
  ALTER TABLE `currency`
    MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `department`
  --
  ALTER TABLE `department`
    MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  --
  -- AUTO_INCREMENT for table `diagnosis_report`
  --
  ALTER TABLE `diagnosis_report`
    MODIFY `diagnosis_report_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `doctor`
  --
  ALTER TABLE `doctor`
    MODIFY `doctor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `email_template`
  --
  ALTER TABLE `email_template`
    MODIFY `email_template_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `form_element`
  --
  ALTER TABLE `form_element`
    MODIFY `form_element_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `invoice`
  --
  ALTER TABLE `invoice`
    MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `laboratorist`
  --
  ALTER TABLE `laboratorist`
    MODIFY `laboratorist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `lab_results`
  --
  ALTER TABLE `lab_results`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `lab_tests`
  --
  ALTER TABLE `lab_tests`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `language`
  --
  ALTER TABLE `language`
    MODIFY `phrase_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `medicine`
  --
  ALTER TABLE `medicine`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `medicine_category`
  --
  ALTER TABLE `medicine_category`
    MODIFY `medicine_category_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `medicine_categorys`
  --
  ALTER TABLE `medicine_categorys`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `medicine_suppliers`
  --
  ALTER TABLE `medicine_suppliers`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `message`
  --
  ALTER TABLE `message`
    MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `message_thread`
  --
  ALTER TABLE `message_thread`
    MODIFY `message_thread_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `note`
  --
  ALTER TABLE `note`
    MODIFY `note_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `notice`
  --
  ALTER TABLE `notice`
    MODIFY `notice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `noticeboard`
  --
  ALTER TABLE `noticeboard`
    MODIFY `notice_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `nurse`
  --
  ALTER TABLE `nurse`
    MODIFY `nurse_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `patient`
  --
  ALTER TABLE `patient`
    MODIFY `patient_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `patient_payments`
  --
  ALTER TABLE `patient_payments`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `payment`
  --
  ALTER TABLE `payment`
    MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `pharmacist`
  --
  ALTER TABLE `pharmacist`
    MODIFY `pharmacist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `prescription`
  --
  ALTER TABLE `prescription`
    MODIFY `prescription_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `receptionist`
  --
  ALTER TABLE `receptionist`
    MODIFY `receptionist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `report`
  --
  ALTER TABLE `report`
    MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `webzash_entries`
  --
  ALTER TABLE `webzash_entries`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `webzash_entryitems`
  --
  ALTER TABLE `webzash_entryitems`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `webzash_entrytypes`
  --
  ALTER TABLE `webzash_entrytypes`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `webzash_groups`
  --
  ALTER TABLE `webzash_groups`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  --
  -- AUTO_INCREMENT for table `webzash_ledgers`
  --
  ALTER TABLE `webzash_ledgers`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `webzash_logs`
  --
  ALTER TABLE `webzash_logs`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `webzash_tags`
  --
  ALTER TABLE `webzash_tags`
    MODIFY `id` bigint(18) NOT NULL AUTO_INCREMENT;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `webzash_entries`
  --
  ALTER TABLE `webzash_entries`
    ADD CONSTRAINT `webzash_entries_fk_check_entrytype_id` FOREIGN KEY (`entrytype_id`) REFERENCES `webzash_entrytypes` (`id`),
    ADD CONSTRAINT `webzash_entries_fk_check_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `webzash_tags` (`id`);
  
  --
  -- Constraints for table `webzash_entryitems`
  --
  ALTER TABLE `webzash_entryitems`
    ADD CONSTRAINT `webzash_entryitems_fk_check_entry_id` FOREIGN KEY (`entry_id`) REFERENCES `webzash_entries` (`id`),
    ADD CONSTRAINT `webzash_entryitems_fk_check_ledger_id` FOREIGN KEY (`ledger_id`) REFERENCES `webzash_ledgers` (`id`);
  
  --
  -- Constraints for table `webzash_groups`
  --
  ALTER TABLE `webzash_groups`
    ADD CONSTRAINT `webzash_groups_fk_check_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `webzash_groups` (`id`);
  
  --
  -- Constraints for table `webzash_ledgers`
  --
  ALTER TABLE `webzash_ledgers`
    ADD CONSTRAINT `webzash_ledgers_fk_check_group_id` FOREIGN KEY (`group_id`) REFERENCES `webzash_groups` (`id`);
  
  /*!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 */;
  