-- http://www.phpmyadmin.net
-- 


-- 
-- Database: `ckraal`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `acart`
-- 

CREATE TABLE `acart` (
  `pid` int(11) NOT NULL,
  `cid` varchar(20) NOT NULL,
  `bid` varchar(30) NOT NULL,
  `atype` varchar(30) NOT NULL,
  `qty` varchar(10) NOT NULL,
  `price` varchar(30) NOT NULL,
  `rdate` date default NULL,
  `conf` varchar(20) default NULL,
  PRIMARY KEY  (`pid`,`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `acart`
-- 

INSERT INTO `acart` (`pid`, `cid`, `bid`, `atype`, `qty`, `price`, `rdate`, `conf`) VALUES 
(3, '102589', 'GCC/002/GWS', '1', '2', '6000', '2021-08-18', 'No'),
(9, '45230', 'GCC/002/GWS', '1', '1', '4800', '2021-08-19', 'No'),
(10, '10256452', 'GCC/002/GWS', '4', '6', '12000', '2021-08-18', 'Yes'),
(12, '10256452', 'GCC/002/GWS', '9', '5', '100', '2021-08-18', 'Cancelled'),
(21, '66789103', 'LTC/BMC/002', '1', '5', '4200', '2021-08-21', 'No'),
(22, '66789103', 'LTC/BMC/002', '3', '3', '15000', '2021-08-21', 'No');

-- --------------------------------------------------------

-- 
-- Table structure for table `amaster`
-- 

CREATE TABLE `amaster` (
  `ano` int(11) NOT NULL,
  `atype` varchar(50) NOT NULL,
  `Descr` varchar(50) default NULL,
  PRIMARY KEY  (`atype`),
  UNIQUE KEY `ano` (`ano`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `amaster`
-- 

INSERT INTO `amaster` (`ano`, `atype`, `Descr`) VALUES 
(11, 'Cats', 'Dikatse'),
(1, 'Cattle', 'Kgomo'),
(9, 'Chickens', 'Dikoko'),
(7, 'Dog', 'Ntcha'),
(2, 'Donkeys', 'Tonki'),
(10, 'Duck', 'Pidipidi'),
(3, 'Goat', 'Pudi'),
(5, 'Horse', 'Pitse'),
(8, 'Mule', 'Mmoulo'),
(6, 'Pig', 'Kolobe'),
(4, 'Sheep', 'Nku');

-- --------------------------------------------------------

-- 
-- Table structure for table `aregister`
-- 

CREATE TABLE `aregister` (
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `cid` varchar(30) NOT NULL default '',
  `contact` int(11) NOT NULL,
  `breeder` varchar(100) NOT NULL default '',
  `loc` varchar(50) NOT NULL,
  `rdate` date NOT NULL,
  `zone` varchar(10) NOT NULL,
  PRIMARY KEY  (`cid`,`breeder`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `aregister`
-- 

INSERT INTO `aregister` (`fname`, `lname`, `cid`, `contact`, `breeder`, `loc`, `rdate`, `zone`) VALUES 
('Tefho', 'Masekamela', '2301230', 71633251, 'TLK/002/STUD', 'Shoshong', '2021-09-03', 'C10'),
('City Boikanyo', 'Gaboalapswe', '74562130', 74521301, '006789', 'Mahalapye', '2021-08-31', 'C10');

-- --------------------------------------------------------

-- 
-- Table structure for table `bsales`
-- 

CREATE TABLE `bsales` (
  `bid` int(11) NOT NULL auto_increment,
  `tno` varchar(30) default NULL,
  `sttype` int(3) NOT NULL,
  `breed` varchar(100) NOT NULL,
  `descr` varchar(200) default NULL,
  `sex` varchar(10) default NULL,
  `age` varchar(30) default NULL,
  `qty` tinyint(4) NOT NULL,
  `price` varchar(15) NOT NULL,
  `sdate` date default NULL,
  `img1` varchar(250) default NULL,
  `img2` varchar(250) default NULL,
  `img3` varchar(250) default NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `bsales`
-- 

INSERT INTO `bsales` (`bid`, `tno`, `sttype`, `breed`, `descr`, `sex`, `age`, `qty`, `price`, `sdate`, `img1`, `img2`, `img3`) VALUES 
(1, '006789', 1, 'Brahman Bulls', 'Powana tse tharo tsa di brahmans', 'Male', '2-3 Years', 3, '17000', '2021-08-20', '', '', ''),
(2, '006789', 1, 'Brahman Heifers', 'Maroba a mabraman', 'Male', '2-3 Years', 5, '10500', '2021-08-18', '', '', ''),
(4, '006789', 1, 'Brahman Bulls', '2 brahman bulls', 'Male', '1-2 Years', 2, '13000', '2021-08-17', '', '', ''),
(5, '006789', 4, 'Doppers', 'Dphelehu tse tharo', 'Male', '6-12 Months', 3, '3000', '2021-09-25', 'AIG.PNG', '', ''),
(6, 'TLK/002/STUD', 1, 'Brahman Bulls', '3 brahman bulls', 'Male', '2-3 Years', 3, '15000', '2021-09-04', 'cow.png', '', ''),
(7, 'TLK/002/STUD', 1, 'Sherillen', 'Powena tsa di sherillin tse tharo', 'Male', '2-3 Years', 3, '15000', '2021-09-30', 'cow.png', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `btype`
-- 

CREATE TABLE `btype` (
  `tno` tinyint(4) NOT NULL,
  `btype` varchar(30) NOT NULL,
  PRIMARY KEY  (`tno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `btype`
-- 

INSERT INTO `btype` (`tno`, `btype`) VALUES 
(1, 'Meller'),
(2, 'Butchery'),
(3, 'Abattoir'),
(4, 'Feedlot'),
(5, 'Wholesaler'),
(6, 'Individual'),
(7, 'Exporter'),
(8, 'Gorvenment Dept-Limid'),
(9, 'Local Authority/Council'),
(10, 'All Public');

-- --------------------------------------------------------

-- 
-- Table structure for table `buyer`
-- 

CREATE TABLE `buyer` (
  `bname` varchar(100) NOT NULL,
  `btype` tinyint(4) NOT NULL,
  `cid` varchar(50) default NULL,
  `adres` varchar(100) default NULL,
  `contact` int(11) NOT NULL,
  `loc` varchar(50) default NULL,
  `zone` varchar(20) NOT NULL,
  `rdate` date NOT NULL,
  `renew` date NOT NULL,
  `email` varchar(100) default NULL,
  `cmode` varchar(20) default NULL,
  `uname` varchar(100) default NULL,
  `pwd` varchar(100) default NULL,
  `ap` tinyint(4) NOT NULL,
  `price` varchar(50) default NULL,
  PRIMARY KEY  (`bname`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `buyer`
-- 

INSERT INTO `buyer` (`bname`, `btype`, `cid`, `adres`, `contact`, `loc`, `zone`, `rdate`, `renew`, `email`, `cmode`, `uname`, `pwd`, `ap`, `price`) VALUES 
('Botswana Meet Commission, BMC Lobatse', 3, 'LTC/BMC/002', 'Bag 789,\r\nLobatse', 53345621, 'Lobatse', 'J11', '2021-08-21', '2022-08-21', 'procurement@bmc.co.bw', 'Both', 'procurement@bmc.co.bw', 'ec14d481cbc59840247253b785bfacd5', 1, ''),
('Bul-OT (LTD) Ltd', 2, 'NEDC/001/BULOT', 'P.O.Box 8, Masunga', 71633489, 'Masunga', 'B5', '2021-04-10', '2022-04-10', 'mgaboalapswe@yahoo.com', 'Both', 'mgaboalapswe@yahoo.com', 'ec14d481cbc59840247253b785bfacd5', 1, ''),
('Comet Pty Ltd', 7, 'GCC/C019/2021', 'Bag 2024, Toromoja', 76231542, 'Toromoja', 'B4b', '2021-07-21', '1970-01-01', 'comet@yahoo.com', 'Both', 'comet@yahoo.com', '76231542', 1, ''),
('Fensol Holdings(pty) ltd', 1, 'PAL/202103/F', 'Bag 001, Malaka', 71456231, 'Malaka', 'C9', '2021-07-21', '2022-07-21', 'fensolh@gmail.com', 'Both', 'fensolh@gmail.com', '71456231', 1, ''),
('Gradeware Solutions PTY LTD', 3, 'GCC/002/GWS', 'Box 2883, Gaborone', 71633489, 'Gaborone', 'M11', '0000-00-00', '2022-05-31', 'mgaboalapswe@gmail.com', NULL, 'mgaboalapswe@gmail.com', 'ec14d481cbc59840247253b785bfacd5', 1, ''),
('Naumi & Sons (pty) ltd', 4, 'SER/02/2021', 'Bag 00154, Paje', 71854890, 'Paje', 'C8', '2021-07-21', '2022-07-21', 'nsons@yahoo.com', 'Both', 'nsons@yahoo.com', '', 1, ''),
('Oodi Abottor', 3, 'KDC/001/OODIA', 'Bag 001', 72451023, 'Oodi', 'F11', '2021-07-21', '2022-07-21', 'oodiabottor@gmail.com', 'Both', 'oodiabottor@gmail.com', '72451023', 1, ''),
('Quinn & Sons (pty) ltd', 2, 'MHL/202102/03B', 'Box 10,\r\nMahalapye', 75632141, 'Mahalapye', 'C10', '2021-06-10', '2022-06-10', '', 'E-mail', 'Quinn & Sons (pty) ltd', '75632141', 1, ''),
('ROI PTY LTD', 4, 'PAA/002/ROI', 'P/Bag 0012,\r\nGabs', 72189455, 'Palapye', 'C9', '2021-07-21', '2022-07-21', 'roi@gmail.com', 'Both', 'roi@gmail.com', '', 1, '');

-- --------------------------------------------------------

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `id` int(11) NOT NULL auto_increment,
  `categoryName` varchar(255) default NULL,
  `categoryDescription` longtext,
  `creationDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `updationDate` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `category`
-- 

INSERT INTO `category` (`id`, `categoryName`, `categoryDescription`, `creationDate`, `updationDate`) VALUES 
(3, 'Cattle', 'Cattle Breed', '2017-01-24 21:17:37', '30-01-2017 12:22:24 AM'),
(4, 'Small Stock', 'Goats,Sheep,Pigs', '2017-01-24 21:19:32', ''),
(5, 'Poultry', 'Chicken, Ducks, Guinea fowls', '2017-01-24 21:19:54', ''),
(6, 'Domestic Animals', 'Dogs, Cats, Pets', '2017-02-20 21:18:52', ''),
(7, 'Horse|Donkeys|Mule', 'Dipitse, Ditonki le Dimmulo', '2021-07-18 22:33:46', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `cbuyer`
-- 

CREATE TABLE `cbuyer` (
  `sbname` varchar(100) NOT NULL,
  `regno` varchar(50) NOT NULL,
  `contacts` varchar(50) NOT NULL,
  `padres` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `atype` varchar(100) NOT NULL,
  `zone` varchar(15) NOT NULL,
  `loc` varchar(100) NOT NULL,
  `rdate` date NOT NULL,
  `auth` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `renwd` date NOT NULL,
  PRIMARY KEY  (`regno`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `cbuyer`
-- 

INSERT INTO `cbuyer` (`sbname`, `regno`, `contacts`, `padres`, `email`, `atype`, `zone`, `loc`, `rdate`, `auth`, `status`, `renwd`) VALUES 
('Botswana Public', '100', '100', 'Public', 'Public', 'Public', 'All', 'Botswana', '2021-07-03', '100', 1, '2045-07-31'),
('Botswana Agricultural Marketing Board, BAMB', 'BAMB/MAH/2021', '72365456', 'Bag 0034,\r\nMahalapye', 'bambmahalapye@yahoo.com', 'Buyer', 'C10', 'Mahalapye', '2021-06-27', 'ec14d481cbc59840247253b785bfacd5', 1, '2022-06-27'),
('Banyana Farm', 'BF/CR002/2021', '5345786/71633567', 'Box 2023,\r\nBorolong', 'banyanaf@info.com', 'Supplier', 'K11', 'Barolong', '2021-06-27', 'ec14d481cbc59840247253b785bfacd5', 1, '2022-06-27'),
('Bruce Farming Associate', 'BRU/001/PAL', '75623145', 'Bag 2013,\r\nPalapye', 'brucefarm@gmail.com', 'Distributor', 'C9', 'Palapye', '2021-08-10', 'ec14d481cbc59840247253b785bfacd5', 1, '2022-08-10'),
('Pandamatenge Farming', 'ChDC/PT/002', '716542310', 'Bag 0234,\r\nKasane', 'panda@gmail.com', 'Supplier', 'P1', 'Pandamatenge ', '2021-07-21', 'ChDC/PT/002', 1, '2022-07-21'),
('Motlhathedi farmings', 'MF12/OK', '71633487', 'Box 2883,\r\nGaborone', 'mgaboalapswe@yahoo.com', 'Supplier', 'C6', 'Masunga', '2021-07-21', 'MF12/OK', 1, '2022-07-21');

-- --------------------------------------------------------

-- 
-- Table structure for table `ccart`
-- 

CREATE TABLE `ccart` (
  `pid` int(11) NOT NULL,
  `cid` varchar(20) NOT NULL,
  `bid` varchar(30) NOT NULL,
  `ctype` varchar(30) NOT NULL,
  `qty` varchar(10) NOT NULL,
  `price` varchar(30) NOT NULL,
  `rdate` date default NULL,
  `conf` varchar(20) default NULL,
  PRIMARY KEY  (`pid`,`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ccart`
-- 

INSERT INTO `ccart` (`pid`, `cid`, `bid`, `ctype`, `qty`, `price`, `rdate`, `conf`) VALUES 
(2, '222222222', 'BAMB/MAH/2021', '5', '2', '250', '2021-08-08', 'Cancelled'),
(4, '8562312', 'BAMB/MAH/2021', '3', '2', '320', '2021-08-11', 'No'),
(5, '8562312', 'BAMB/MAH/2021', '4', '4', '350', '2021-07-31', 'Yes'),
(8, '888888888', 'BAMB/MAH/2021', '2', '10', '250', '2021-08-07', 'Yes');

-- --------------------------------------------------------

-- 
-- Table structure for table `cmaster`
-- 

CREATE TABLE `cmaster` (
  `cno` tinyint(4) NOT NULL auto_increment,
  `ctype` varchar(100) NOT NULL,
  `Descr` varchar(100) default NULL,
  PRIMARY KEY  (`cno`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `cmaster`
-- 

INSERT INTO `cmaster` (`cno`, `ctype`, `Descr`) VALUES 
(1, 'Sorghum', 'Mabele'),
(2, 'Tswana Beans', 'Dinawa'),
(3, 'Jugo Beans', 'Ditloo'),
(4, 'GroundNuts', 'Manoko'),
(5, 'White Maize', 'Mmedi'),
(6, 'Sunflower', 'Sanefolawa'),
(7, 'Black Eye Beans', 'Dinawa'),
(8, 'Sugar Beans', 'Dinawa'),
(9, 'Yellow Maize', 'Mmedi'),
(10, 'Millet', 'Mellet'),
(11, 'Tepary Beans', 'Dinawa'),
(12, 'White Harricots', 'Harricots');

-- --------------------------------------------------------

-- 
-- Table structure for table `csales`
-- 

CREATE TABLE `csales` (
  `pid` int(11) NOT NULL auto_increment,
  `cid` varchar(20) NOT NULL,
  `btype` varchar(30) NOT NULL,
  `bname` varchar(100) NOT NULL,
  `ctype` varchar(5) NOT NULL,
  `breed` varchar(50) NOT NULL,
  `cdesc` varchar(250) default NULL,
  `qty` int(11) NOT NULL,
  `price` varchar(50) default NULL,
  `rdate` date NOT NULL,
  `img1` varchar(250) default NULL,
  PRIMARY KEY  (`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `csales`
-- 

INSERT INTO `csales` (`pid`, `cid`, `btype`, `bname`, `ctype`, `breed`, `cdesc`, `qty`, `price`, `rdate`, `img1`) VALUES 
(1, '10256452', 'Public', 'Public', '6', 'Sunflower', '10 bags of Sunflower', 10, 'P150 bag', '2021-07-03', 'pic'),
(2, '222222222', 'Buyer', 'BAMB/MAH/2021', '5', 'Yellow maize', 'Kgetsi tsa mmedi o mo yellow', 3, '300', '2021-07-28', '1'),
(3, '8562312', 'Supplier', 'BF/CR002/2021', '1', 'Segaolane', 'Kgwetsi tsa segaolane', 7, '350', '2021-07-28', '1'),
(4, '8562312', 'Buyer', 'BAMB/MAH/2021', '3', 'Ditloo tsa setswana', 'Kgwetsi ya ditloo tse tharo', 2, '750', '2021-07-26', '1'),
(5, '8562312', 'Buyer', 'BAMB/MAH/2021', '4', 'Manoko a setswana', 'Kgetsi tsa manoko tse 5', 1, '540', '2021-07-30', '1'),
(6, '333333333', 'Supplier', 'BF/CR002/2021', '1', 'Segaolane', 'Kgetsi tse 10 tsa segaolane', 10, '300', '2021-08-05', '1'),
(7, '111111111', 'Supplier', 'BF/CR002/2021', '2', 'Dinawa tsa mogwe o kgotsheng', 'Dikgetsi tsa dinawa tse 10', 10, '350', '2021-08-05', '1'),
(8, '888888888', 'Buyer', 'BAMB/MAH/2021', '2', 'Black eye', 'Dikgetsi tsa di black eye dile 20', 10, '270', '2021-08-07', '1');

-- --------------------------------------------------------

-- 
-- Table structure for table `cseller`
-- 

CREATE TABLE `cseller` (
  `seller` varchar(20) NOT NULL,
  `cid` varchar(20) NOT NULL,
  `contact` varchar(30) default NULL,
  `padres` varchar(200) default NULL,
  `loc` varchar(70) default NULL,
  `zone` varchar(15) default NULL,
  `rdate` date NOT NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `cseller`
-- 

INSERT INTO `cseller` (`seller`, `cid`, `contact`, `padres`, `loc`, `zone`, `rdate`) VALUES 
('Maipelo Salakae', '10256452', '74521301', NULL, 'Shoshong', 'C10', '0000-00-00'),
('Goitseone Railana', '111111111', '71236541', 'Bag 109,\r\nMolelole', 'Molepolole', 'I11', '2021-08-05'),
('Bathaping Morongwa', '222222222', '75123214', 'Box 10,\r\nKanye', 'Mabutsane', 'J11', '2021-07-28'),
('Maitumelo Mosweunyan', '333333333', '75412310', 'Box 3762,\r\nBobonong', 'Bobonong', 'C7', '2021-08-05'),
('Gaonakala Kesepe', '741231021', '74123654', 'Box 20023,\r\nBobonong', 'Bobonong', 'C7', '2021-07-26'),
('Reginah Sebaga', '8562312', '75143025', 'P.O.Box 765,\r\nMahalapye', 'Mahalapye', 'C10', '2021-07-03'),
('Naledi Noko', '888888888', '74568912', 'Bag 0027,\r\nFrancistown', 'Francistown', 'C6', '2021-08-07');

-- --------------------------------------------------------

-- 
-- Table structure for table `dead`
-- 

CREATE TABLE `dead` (
  `acolour` varchar(30) NOT NULL,
  `bstyle` varchar(15) default NULL,
  `b1c1` varchar(1) default NULL,
  `b1c2` varchar(1) default NULL,
  `b1c3` varchar(1) default NULL,
  `b1c4` varchar(1) default NULL,
  `emark` varchar(30) default NULL,
  `etag` varchar(11) default NULL,
  `atype` varchar(20) NOT NULL,
  `loc` varchar(50) default NULL,
  `reporter` varchar(100) default NULL,
  `contact` int(11) NOT NULL,
  `rdate` date NOT NULL,
  `dcode` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `dead`
-- 

INSERT INTO `dead` (`acolour`, `bstyle`, `b1c1`, `b1c2`, `b1c3`, `b1c4`, `emark`, `etag`, `atype`, `loc`, `reporter`, `contact`, `rdate`, `dcode`) VALUES 
('Puswana', 'Flat', 'T', 'L', '4', '', 'Lesifi', '', '2', 'Otse', 'Naiko Boshe', 72123456, '2020-11-12', 'SEDC'),
('Ntsho', 'Square', 'F', 'U', 'F', 'W', 'Thako ya phala', '', '1', 'Mo tseleng ya Nata gweta', 'Nshimbi Naipa', 72312456, '2020-11-13', 'STC'),
('Tshumu', 'N/A', '', '', '', '', 'NA', '789', '5', 'Mmadinare Turn', 'Gaope', 7756452, '2020-11-13', 'SPTC');

-- --------------------------------------------------------

-- 
-- Table structure for table `dikotsi`
-- 

CREATE TABLE `dikotsi` (
  `names` varchar(100) NOT NULL,
  `pnumber` varchar(20) NOT NULL,
  `contact` int(8) NOT NULL,
  `adate` date NOT NULL,
  `atype` varchar(25) NOT NULL,
  `etag` int(15) NOT NULL,
  `btype` varchar(20) NOT NULL,
  `b1c1` varchar(1) default NULL,
  `b1c2` varchar(1) default NULL,
  `b1c3` varchar(1) default NULL,
  `b1c4` varchar(1) default NULL,
  PRIMARY KEY  (`pnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `dikotsi`
-- 

INSERT INTO `dikotsi` (`names`, `pnumber`, `contact`, `adate`, `atype`, `etag`, `btype`, `b1c1`, `b1c2`, `b1c3`, `b1c4`) VALUES 
('Mojabane Nalefhu', 'B 345 HBZ', 72345678, '2020-08-04', 'Donkeys', 77245, 'N/A', '', '', '', ''),
('James Hubona', 'B 361 AJV', 75859242, '2020-08-18', 'Cattle', 456123, 'Triangle-Up', 'u', 's', 'j', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `district`
-- 

CREATE TABLE `district` (
  `dcode` varchar(10) NOT NULL,
  `dname` varchar(100) NOT NULL,
  `contact` int(7) default NULL,
  `district` varchar(100) default NULL,
  PRIMARY KEY  (`dname`),
  UNIQUE KEY `dcode` (`dcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `district`
-- 

INSERT INTO `district` (`dcode`, `dname`, `contact`, `district`) VALUES 
('BSDC', 'Bobonong Sub District Council', 4601230, 'Bobonong Sub District'),
('CDC', 'Central District Council', 4630411, 'Central District'),
('CSDC', 'Charleshill Sub District Council', 6592057, 'Charleshill Sub District'),
('CHDC', 'Chobe District Council', 6250275, 'Chobe District'),
('FCC', 'Francistown City Council', 2412183, 'Francistown'),
('GCC', 'Gaborone City Council', 3953525, 'Gaborone'),
('GDC', 'Ghanzi District Council', 6596211, 'Ghanzi District'),
('GESDC', 'Ghanzi East Sub District Council', 6595141, 'Ghanzi East Sub District'),
('GoSDC', 'Goodhope Sub District Council', 5404157, 'Goodhope Sub District'),
('GSDC', 'Gumare Sub district Council', 6874040, 'Gumare Sub district'),
('HSDC', 'Hukuntsi Sub District Council', 6510256, 'Hukuntsi Sub District'),
('JTC', 'Jwaneng Town Council', 5880303, 'Jwaneng Town'),
('KGDC', 'Kgalagadi District Council', 6540255, 'Kgalagadi District'),
('KGADC', 'Kgatleng District Council', 5777411, 'Kgatleng District'),
('KwDC', 'Kweneng District Council', 5920201, 'Kweneng District'),
('LeSDC', 'Lentsweletau Sub District Council', 5915122, 'Lentsweletau Sub District'),
('LetSDC', 'Letlhakane Sub District Council', 2978278, 'Letlhakane Sub District '),
('LSDC', 'Letlhakeng Subdistrict Council', 5943013, 'Letlhakeng Sub district'),
('LTC', 'Lobatse Town Council ', 5305800, 'Lobatse Town'),
('MabSDC', 'Mabutsane Sub District Council', 5889219, 'Mabutsane Sub'),
('MSDC', 'Mahalapye Sub district Council', 4713323, 'Mahalapye Sub District'),
('MAA', 'Maun Administrative Authority', 6861729, 'Maun Administrative'),
('MTSDC', 'Mogoditshane-Thamaga Sub-District', 3105615, 'Mogoditshane-Thamaga Sub-District'),
('MoshSDC', 'Moshupa Sub District Council', 5449270, 'Moshupa Sub District'),
('NEDC', 'North East District Council', 2489242, 'North East District'),
('NWDC', 'North West District Council', 6860241, 'North West District'),
('PAA', 'Palapye Administrative Authority', 4921092, 'Palapye Administrative'),
('SPTC', 'Selibe Phikwe Town Council', 2610570, 'Selibe Phikwe Town'),
('SAA', 'Serowe Administrative Authority', 4630411, 'Serowe Administrative/Central'),
('SEDC', 'South East District Council', 5390671, 'South East District'),
('SDC', 'Southern District  Council', 5440651, NULL),
('STC', 'Sowa Town Council', 6213440, NULL),
('TLSDC', 'Tlokweng Sub Distrcit Council', 3654123, NULL),
('TnTSDC', 'Tonota Sub District Council', 2484248, NULL),
('TuSDC', 'Tutume Sub District Council', 2987232, NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `dthekiso`
-- 

CREATE TABLE `dthekiso` (
  `id` int(11) NOT NULL auto_increment,
  `kid` varchar(20) NOT NULL,
  `btype` varchar(30) NOT NULL,
  `bname` varchar(100) NOT NULL,
  `atype` varchar(5) NOT NULL,
  `category` int(11) NOT NULL,
  `breed` varchar(50) default NULL,
  `sex` varchar(10) default NULL,
  `age` varchar(50) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `qty` int(11) NOT NULL,
  `rdate` date NOT NULL,
  `ptag` varchar(50) NOT NULL,
  `price` varchar(15) default NULL,
  `astatus` tinyint(4) default NULL,
  `image1` varchar(250) default NULL,
  `image2` varchar(250) default NULL,
  `image3` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `dthekiso`
-- 

INSERT INTO `dthekiso` (`id`, `kid`, `btype`, `bname`, `atype`, `category`, `breed`, `sex`, `age`, `desc`, `qty`, `rdate`, `ptag`, `price`, `astatus`, `image1`, `image2`, `image3`) VALUES 
(15, '77777777', '10', 'Public', '9', 5, 'TSWANA CHECKENS', 'Both', '6-12 Months', 'KOKO TSA SETSWANA', 5, '2021-07-18', '100', '100', 1, '', '', ''),
(16, '102356', '10', 'Public', '9', 5, 'Succex Broillers', 'Both', '6-12 Months', 'Broiller checkens', 10, '2021-07-18', '150', '150', 1, '', '', ''),
(17, '45698', '10', 'Public', '10', 5, 'Dipidipidi', 'Both', '6-12 Months', 'Ducks for sale', 5, '2021-07-18', '250', '250', 1, '', '', ''),
(18, '88888888', '10', 'Public', '9', 5, 'Tswana', 'Both', '6-12 Months', 'Dikoko tsa setswana for seshabo', 15, '2021-07-22', '70', '70', 1, '', '', ''),
(19, '96102312', '10', 'Public', '7', 6, 'Pitbull', 'Male', '2-3 Years', 'Black and Brown pitbulls', 2, '2021-08-18', '2500', '2500', 1, '', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `kraal`
-- 

CREATE TABLE `kraal` (
  `kno` varchar(15) NOT NULL,
  `kname` varchar(30) NOT NULL,
  `loc` varchar(30) NOT NULL,
  `dcode` varchar(10) default NULL,
  PRIMARY KEY  (`kno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `kraal`
-- 

INSERT INTO `kraal` (`kno`, `kname`, `loc`, `dcode`) VALUES 
('1', 'Serilatlholo', 'Letlhakane', 'KDC'),
('2', 'Kwenabodiba', 'Molepolole', 'KDC'),
('3', 'Metsimotlhaba', 'Mogoditsane', 'KDC');

-- --------------------------------------------------------

-- 
-- Table structure for table `lsupply`
-- 

CREATE TABLE `lsupply` (
  `spid` int(11) NOT NULL auto_increment,
  `supid` varchar(50) NOT NULL,
  `btype` varchar(30) NOT NULL,
  `bname` varchar(100) NOT NULL,
  `atype` varchar(5) NOT NULL,
  `breed` varchar(50) NOT NULL,
  `desc` varchar(250) default NULL,
  `qty` int(11) NOT NULL,
  `price` varchar(50) default NULL,
  `rdate` date NOT NULL,
  `img1` varchar(250) default NULL,
  PRIMARY KEY  (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `lsupply`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `matimela`
-- 

CREATE TABLE `matimela` (
  `sno` int(11) NOT NULL,
  `acolour` varchar(30) NOT NULL,
  `bstyle` varchar(15) default NULL,
  `b1c1` varchar(1) default NULL,
  `b1c2` varchar(1) default NULL,
  `b1c3` varchar(1) default NULL,
  `b1c4` varchar(1) default NULL,
  `bstyle2` varchar(15) default NULL,
  `b2c1` varchar(1) default NULL,
  `b2c2` varchar(1) default NULL,
  `b2c3` varchar(1) default NULL,
  `b2c4` varchar(1) default NULL,
  `dbrand` varchar(4) default NULL,
  `emark` varchar(30) default NULL,
  `atype` varchar(20) NOT NULL,
  `adesc` varchar(50) default NULL,
  `sex` varchar(1) default NULL,
  `kno` varchar(100) default NULL,
  `idate` date NOT NULL,
  `dcode` varchar(20) NOT NULL,
  PRIMARY KEY  (`sno`,`dcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `matimela`
-- 

INSERT INTO `matimela` (`sno`, `acolour`, `bstyle`, `b1c1`, `b1c2`, `b1c3`, `b1c4`, `bstyle2`, `b2c1`, `b2c2`, `b2c3`, `b2c4`, `dbrand`, `emark`, `atype`, `adesc`, `sex`, `kno`, `idate`, `dcode`) VALUES 
(1, 'Phatshwana', 'Square', 'B', 'N', '4', 'S', 'NULL', 'N', 'N', 'N', 'N', '', 'Lephaga', '1', 'Namane e namagadi ', 'F', 'Tsetsejwe', '2020-05-31', 'BSDC'),
(5, 'Kwebu', 'Flat', 'R', '7', '5', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'Lesusu', '1', 'Poo e dinaka', 'M', 'Molalatau', '2020-04-30', 'BSDC'),
(6, 'Khunou', 'Square', 'F', 'J', 'R', 'J', 'Null', 'N', 'N', 'N', 'N', '', 'Sekei', '1', 'pholwana e bongolo', 'M', 'Molalatau', '2020-05-01', 'BSDC'),
(7, 'Tshetha', 'Triangle-Down', '2', 'V', 'J', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'Lephaga', '2', 'Tonki e tshetlha', 'M', 'Tsetsejwe', '2020-05-02', 'BSDC'),
(8, 'Puswa', 'Triangle-Up', 'T', 'S', '9', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'n/a', '8', 'Mmoulo o mo puswa', 'M', 'Mathathane', '2020-05-03', 'BSDC'),
(8, 'Thaba', 'Flat', 'T', 'L', '6', '', '', '', '', '', '', '', 'N/A', '5', 'Thaba e bontsho', 'M', 'Metsimotlhaba', '2020-04-13', 'KwDC'),
(9, 'Naana', 'N/A', 'n', 'n', 'n', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'Lekekete', '3', 'Pudi e naana le bosweu', 'F', 'Tsetsejwe', '2020-03-04', 'BSDC'),
(10, 'Ngolo', 'Flat', 'T', 'J', '5', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'Thako ya phala', '1', 'Pholo e ngolo', 'M', 'Bobonong', '2020-01-05', 'BSDC'),
(10, 'Thokwana', 'N/A', 'N', 'N', '', '', '', '', '', '', '', '', 'Motoka', '4', 'Thokwana e lebante mo kotlase', 'F', 'Metsimotlhaba', '2019-08-17', 'KwDC'),
(11, 'Phatshwana', 'N/A', 'N', 'N', 'n', 'N', 'Null', 'N', 'N', 'N', 'N', '', 'Sekei', '4', 'Nku e phatshwana', 'F', 'Molalatau', '2020-05-06', 'BSDC'),
(11, 'Ntso', 'Triangle-Down', '9', 'L', 'P', '', '', '', '', '', '', '', 'Motoka', '2', 'Pheke e ntsho, e sebola kaha mojeng', 'M', 'Metsimotlhaba', '2019-12-09', 'KwDC'),
(12, 'Kotswana', 'Square', 'K', 'L', '7', '2', 'Null', 'N', 'N', 'N', 'N', '', 'Lesusu', '1', 'Kgomo e Kotswana', 'F', 'Kobojango', '2020-06-07', 'BSDC'),
(12, 'Tshweu', 'N/A', 'N', 'N', '', '', '', '', '', '', '', '', 'N/A', '7', 'Ntsa e tshweu e dibata di rokwa', 'M', 'Serilatlholo', '2020-04-23', 'KwDC'),
(13, 'Kotswana', 'N/A', 'N', 'N', '', '', '', '', '', '', '', '', 'N/A', '6', 'Kotswana e dibatabata', 'F', 'Metsimotlhaba', '2020-04-22', 'KwDC'),
(14, 'Naana', 'Triangle-Up', 'T', 'L', '9', '', 'N/A', '', '', '', '', '', 'Lephaga', '1', 'Naana e boswaana. E dinaka', 'F', 'Metsimotlhaba', '2020-04-18', 'KwDC'),
(16, 'Nkgwe', 'Triangle-Up', '2', 'V', 'J', '', 'Square', 'F', 'J', 'R', 'J', '', 'Sekei', '1', 'Nkgwe e dinaka, e tshipi di pedi', 'M', 'Kwenabodiba', '2020-05-27', 'KwDC'),
(17, 'Thaba', 'Vertical', 'Z', 'T', '6', '', 'N/A', '', '', '', '', '', 'N/A', '8', 'Thaba e bosumu', 'M', 'Kwenabodiba', '2021-04-10', 'KwDC');

-- --------------------------------------------------------

-- 
-- Table structure for table `mpatise`
-- 

CREATE TABLE `mpatise` (
  `fname` varchar(100) NOT NULL,
  `contact` varchar(8) NOT NULL,
  `btype1` varchar(15) default NULL,
  `b1c1` varchar(1) NOT NULL default '',
  `b1c2` varchar(1) NOT NULL default '',
  `b1c3` varchar(1) NOT NULL default '',
  `b1c4` varchar(1) NOT NULL default '',
  `etag` varchar(50) NOT NULL default '',
  `rdate` date default NULL,
  `sms` tinyint(4) default NULL,
  `app` tinyint(4) default NULL,
  `aproval` tinyint(1) default NULL,
  `pterm` varchar(15) default NULL,
  `pmonth` smallint(6) default NULL,
  `renew` date default NULL,
  `zone` varchar(10) default NULL,
  `scode` int(11) default NULL,
  PRIMARY KEY  (`b1c1`,`b1c2`,`b1c3`,`etag`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `mpatise`
-- 

INSERT INTO `mpatise` (`fname`, `contact`, `btype1`, `b1c1`, `b1c2`, `b1c3`, `b1c4`, `etag`, `rdate`, `sms`, `app`, `aproval`, `pterm`, `pmonth`, `renew`, `zone`, `scode`) VALUES 
('Baleseng Janamo', '75859242', 'etag', '', '', '', '', '75859242', '2020-10-24', 1, 1, 1, 'anual', 12, '2021-11-15', 'C10', 2079),
('Bagele Motlhatlhedi Gaboalapswe', '71470172', 'Triangle-Down', '7', 'D', '3', '', '', '2020-10-01', 1, 1, 1, NULL, NULL, '2021-11-11', 'C10', 2002),
('Dimpho', '71633489', 'Triangle-Up', '9', 'L', 'T', '', '', '2020-11-22', 1, 1, 1, 'anual', 12, '2021-11-22', '', 0),
('Sebataladi Lebadi', '72369548', 'Triangle-Up', '9', 'P', 'M', '', '', '2020-09-19', 1, 1, 1, NULL, NULL, '2021-09-19', '', 0),
('Moiseraela Kabelo-manowe', '76732542', 'Vertical', 'A', 'F', 'O', '', '', '2020-10-18', 1, 1, 0, NULL, NULL, '2021-10-18', 'C7', 2053),
('Gonaamang Ofhithile', '71491341', 'Square', 'A', 'O', '6', 'D', '', '2020-10-21', 1, 1, 0, NULL, NULL, '2021-10-21', 'C10', 2066),
('Isiah Baruti', '72241902', 'Square', 'F', 'J', 'R', 'J', '', '2020-09-21', 1, 1, 1, NULL, NULL, '2021-09-21', 'C9', 2004),
('Motlhatlhedi Tefo', '71633489', 'Square', 'F', 'U', 'F', 'W', '', '2020-09-19', 1, 1, 1, NULL, NULL, '2021-09-19', 'C10', 2003),
('Rantaleng Gaboalapswe', '71633489', 'Flat', 'G', '9', '9', '', '', '2020-10-12', 1, 1, 1, NULL, NULL, '2021-10-12', 'C10', 2001),
('Dipula Tefo', '75859242', 'Triangle-Up', 'G', 'U', 'U', '', '', '2020-09-19', 1, 0, 1, NULL, NULL, '2021-09-19', '', 0),
('Katlego Keitumetse', '71973463', 'Square', 'K', '1', '9', 'C', '', '2020-10-26', 1, 1, 0, NULL, NULL, '2021-10-26', 'C10', 2092),
('Olekantse Mmika', '76463832', 'Flat', 'P', 'E', 'S', '', '', '2020-10-17', 1, 1, 1, NULL, NULL, '2021-10-17', 'C7', 2040),
('Ndiyapo Raphael Kufigwa', '71633489', 'Square', 'T', 'I', 'F', 'G', '', '2020-11-16', 1, 1, 1, 'Monthly', 3, '2021-04-24', 'C6', 2118);

-- --------------------------------------------------------

-- 
-- Table structure for table `ocart`
-- 

CREATE TABLE `ocart` (
  `oid` int(11) NOT NULL,
  `supid` varchar(20) NOT NULL,
  `bid` varchar(30) NOT NULL,
  `ctype` varchar(30) NOT NULL,
  `qty` varchar(10) NOT NULL,
  `Grade` varchar(50) NOT NULL,
  `rdate` date default NULL,
  `conf` varchar(5) default NULL,
  PRIMARY KEY  (`oid`,`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `ocart`
-- 

INSERT INTO `ocart` (`oid`, `supid`, `bid`, `ctype`, `qty`, `Grade`, `rdate`, `conf`) VALUES 
(9, 'BF/CR002/2021', 'BAMB/MAH/2021', '1', '5', 'Grade 12', '2021-08-05', 'Yes'),
(12, 'BF/CR002/2021', 'BAMB/MAH/2021', '5', '20', 'Grade 2', '2021-08-07', 'No');

-- --------------------------------------------------------

-- 
-- Table structure for table `orders`
-- 

CREATE TABLE `orders` (
  `id` int(11) NOT NULL auto_increment,
  `userId` varchar(20) default NULL,
  `productId` varchar(255) default NULL,
  `quantity` int(11) default NULL,
  `orderDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `paymentMethod` varchar(50) default NULL,
  `orderStatus` varchar(55) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- 
-- Dumping data for table `orders`
-- 

INSERT INTO `orders` (`id`, `userId`, `productId`, `quantity`, `orderDate`, `paymentMethod`, `orderStatus`) VALUES 
(1, '1', '3', 1, '2017-03-07 21:32:57', 'COD', NULL),
(3, '1', '4', 1, '2017-03-10 21:43:04', 'Debit / Credit card', 'Delivered'),
(4, '1', '17', 1, '2017-03-08 18:14:17', 'COD', 'in Process'),
(5, '1', '3', 1, '2017-03-08 21:21:38', 'COD', NULL),
(6, '1', '4', 1, '2017-03-08 21:21:38', 'COD', NULL),
(7, '4', '2', 1, '2021-06-07 10:48:55', 'Debit / Credit card', NULL),
(8, '4', '16', 1, '2021-06-07 10:48:55', 'Debit / Credit card', NULL),
(9, '4', '20', 1, '2021-06-07 10:48:55', 'Debit / Credit card', NULL),
(10, '4', '4', 1, '2021-06-07 20:14:38', NULL, NULL),
(11, '4', '18', 1, '2021-06-07 20:14:38', NULL, NULL),
(12, 'C00675433', '36', 3, '2021-06-10 13:12:35', 'Internet Banking', NULL),
(13, 'C00675433', '37', 1, '2021-06-10 13:12:35', 'Internet Banking', NULL),
(14, 'C00675433', '36', 1, '2021-06-10 14:04:10', 'Internet Banking', NULL),
(15, 'C00675433', '37', 1, '2021-06-10 14:04:10', 'Internet Banking', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `pdistrict`
-- 

CREATE TABLE `pdistrict` (
  `dcode` varchar(10) NOT NULL,
  `dname` varchar(100) NOT NULL,
  `contact` int(7) default NULL,
  PRIMARY KEY  (`dname`),
  UNIQUE KEY `dcode` (`dcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `pdistrict`
-- 

INSERT INTO `pdistrict` (`dcode`, `dname`, `contact`) VALUES 
('MH01', 'Mahalapye', 4612183),
('SH02', 'Shohong', 4260013);

-- --------------------------------------------------------

-- 
-- Table structure for table `pkraal`
-- 

CREATE TABLE `pkraal` (
  `sno` int(11) NOT NULL,
  `acolour` varchar(100) NOT NULL,
  `bstyle` varchar(15) default NULL,
  `b1c1` varchar(1) default NULL,
  `b1c2` varchar(1) default NULL,
  `b1c3` varchar(1) default NULL,
  `b1c4` varchar(1) default NULL,
  `emark` varchar(30) default NULL,
  `etag` varchar(11) default NULL,
  `atype` varchar(20) NOT NULL,
  `loc` varchar(50) default NULL,
  `reporter` varchar(100) default NULL,
  `contact` int(11) NOT NULL,
  `rdate` date NOT NULL,
  `dcode` varchar(20) NOT NULL,
  `claimed` tinyint(4) default '0',
  PRIMARY KEY  (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `pkraal`
-- 

INSERT INTO `pkraal` (`sno`, `acolour`, `bstyle`, `b1c1`, `b1c2`, `b1c3`, `b1c4`, `emark`, `etag`, `atype`, `loc`, `reporter`, `contact`, `rdate`, `dcode`, `claimed`) VALUES 
(1, 'Tshetlha', 'Triangle-Down', '7', 'D', '3', '', 'Motoka mo mojeng', NULL, '2', 'Serilathole', 'Dipula Tefho', 73734600, '0000-00-00', 'KDC', 0),
(2, 'Tshunyana', 'Flat', 'T', 'L', '6', '', 'Lesifi', NULL, '1', 'Shoshong/Segompo', 'Gaketshabe Mosweunyane', 71234567, '2020-05-21', 'MSDC', 0),
(3, 'Nkgwe', 'Triangle-Up', '2', 'v', 'j', '', 'sekei', NULL, '1', 'Molepolole/serinane', 'Modisa', 72456789, '2020-05-30', 'KDC', 0),
(4, 'Puswa', 'Flat', 'R', 'D', '6', '', 'Motoka', NULL, '2', 'Kobajango', 'Keaja Nawa', 76456134, '2020-05-30', 'BSDC', 0),
(5, 'tshumu', 'Triangle-Down', 'w', 's', 'p', '', 'lesifi', NULL, '5', 'Letlhakeng', 'Sebala Dikola', 7145627, '2020-08-01', 'KDC', 1),
(6, 'Nala', 'Triangle-Down', 'W', 'S', 'P', '', '7234', NULL, '1', 'Sirelatlhola', 'Neo Mabe', 72345678, '2020-08-12', 'LSDC', 0),
(7, 'Kwebu', 'Triangle-Down', 'P', '3', '7', '', 'lephaga', NULL, '5', 'serelane', 'Naupe Seoka', 7245876, '2020-08-12', 'LSDC', 0),
(8, 'Tshumu', 'Triangle-Up', '2', 'V', 'J', '', 'Sekei', NULL, '1', 'Ngwapa', 'Inock Radibe', 7123456, '2020-08-15', 'PLA', 0),
(9, 'Thumu', 'Flat', 'T', '4', 'L', '', 'Lesifi', NULL, '1', 'Lenganeng', 'Nametso James', 73734600, '2020-08-27', 'TLSDC', 0),
(10, 'Tshunyana', 'Square', 'T', 'A', 'L', 'S', 'Motlhalawakgama', NULL, '1', 'Bordergate', 'Kentsa Kole', 777777, '2020-08-27', 'TLSDC', 0),
(11, 'tshetlha', 'Flat', 'Y', 'D', 'F', '', 'lesusu', NULL, '2', 'Mmamogofu', 'Neo', 7546622, '2020-08-27', 'TLSDC', 0),
(12, 'Kwebu', 'Triangle-Up', 'G', 'U', 'U', '', 'Lephaga', NULL, '8', 'Bonwapitse', 'Nametso Jabane', 71879012, '2020-09-20', 'MSDC', 0),
(13, 'Nala', 'Triangle-Up', '9', 'P', 'M', '', 'Motoka', '98769', '1', 'Border gate', 'Johnson James', 71325462, '2020-09-24', 'TLSDC', 0),
(14, 'Nala', 'Square', 'F', 'J', 'R', 'J', 'Sekei', '6789', '1', 'Bonwapitse', 'Zee Motlhatlhedi', 71633489, '2020-09-25', 'PLA', 0),
(15, 'Kgweba', 'Square', 'F', 'U', 'F', 'W', 'Lephaga', '456', '5', 'Konowa', 'Dipula', 712365489, '2020-09-25', 'MSDC', 0),
(16, 'Puswa', 'Triangle-Up', 'G', 'U', 'U', '', 'leswuswu', '0', '2', 'Tobela', 'Nkamo Gaonale', 71633489, '2020-09-25', 'MSDC', 0),
(17, 'Puswa', 'Square', 'F', 'J', 'R', 'J', 'Lesifi', '5412', '2', 'Bonwapitse', 'Owen Wazha', 71633489, '2020-09-26', 'MSDC', 0),
(18, 'HH', 'Square', 'F', 'U', 'F', 'W', 'JJ', '0', '1', 'TOBELA', 'sEBATAKGOMO', 73734600, '2020-09-28', 'MSDC', 0),
(19, 'HH', 'Square', 'F', 'U', 'F', 'W', 'JJ', '0', '1', 'TOBELA', 'sEBATAKGOMO', 73734600, '2020-09-28', 'MSDC', 0),
(20, 'Ntsho', 'Triangle-Up', 'G', 'U', 'U', '', 'na', '0', '8', 'Moiyabana', 'Moalo', 71470172, '2020-09-28', 'PLA', 0),
(21, 'Ntsho', 'Triangle-Up', 'G', 'U', 'U', '', 'na', '0', '8', 'Moiyabana', 'Moalo', 71470172, '2020-09-28', 'PLA', 0),
(22, 'N', 'Square', 'F', 'U', 'F', 'W', 'ALA', '0', '1', 'Mahibitswane', 'Boshobaka', 75456123, '2020-09-28', 'MSDC', 0),
(23, 'Nala', 'Square', 'F', 'U', 'F', 'W', 'Lephaga', '123', '1', 'Dikabeya', 'Kokona Maika', 73734600, '2020-10-02', 'PLA', 0),
(24, 'Nala', '', '', '', '', '', 'Lesifi Le sekei', '456', '3', 'Motokwe', 'Maide Lekula', 71225361, '2020-11-03', 'KDC', 0),
(25, 'Ntsho', 'Flat', 'N', '6', 'P', '', 'N/A', '', '2', 'Motseleleng ya serowe/Orapa', 'Shima Olekile', 75456321, '2020-11-04', 'LSDC', 0),
(26, 'Ntsho', 'Flat', 'N', '6', 'P', '', 'N/A', '', '2', 'Motseleleng ya serowe/Orapa', 'Shima Olekile', 75456321, '2020-11-04', 'LSDC', 0),
(27, 'Ntsho', 'Flat', 'N', '6', 'P', '', 'N/A', '', '2', 'Motseleleng ya serowe/Orapa', 'Shima Olekile', 75456321, '2020-11-04', 'LSDC', 0),
(28, 'Puswa', 'Flat', 'N', '6', 'P', '', 'leswuswu', '', '2', 'Mo tseleng ya Serowe', 'Shima', 75632145, '2020-11-04', 'LSDC', 0),
(29, 'Ntsho', 'Triangle-Up', 'T', 'L', '6', '', 'lesusu', '', '1', 'Otse', 'Naibo Selo', 7789070, '2020-11-12', 'SEDC', 0),
(30, 'nala jwa bosweu', 'Triangle-Up', 'P', 'M', '7', '', 'Motoka', '', '2', 'konowa', 'bopha', 77521072, '2021-04-06', 'MSDC', 0),
(31, 'Kgomo e tubana e na le namae e sa tshubiwang', 'N/A', '', '', '', '', 'NA', '15592602', '1', 'Sojwe', 'D.Mokgethi', 71302685, '2021-06-12', 'KwDC', 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `sbreeder`
-- 

CREATE TABLE `sbreeder` (
  `sbname` varchar(100) NOT NULL,
  `regno` varchar(50) NOT NULL,
  `contacts` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `stype` varchar(100) NOT NULL,
  `zone` varchar(15) NOT NULL,
  `loc` varchar(100) NOT NULL,
  `rdate` date NOT NULL,
  `auth` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `renwd` date NOT NULL,
  PRIMARY KEY  (`regno`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `email_2` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `sbreeder`
-- 

INSERT INTO `sbreeder` (`sbname`, `regno`, `contacts`, `email`, `stype`, `zone`, `loc`, `rdate`, `auth`, `status`, `renwd`) VALUES 
('Mpho Mafela breeding services', '006789', '7456230', 'mgaboalapswe@yahoo.com', 'Dog Breeding', 'M11', 'Tsholofelo East/Broudhurst', '2021-06-19', 'ec14d481cbc59840247253b785bfacd5', 1, '2022-06-19'),
('Stockenhem Stud breeders', 'TLK/002/STUD', '71634567', 'stockenhem@gmail.com', 'Cattle Breeding', 'M11', 'Tlokweng', '2021-07-22', 'ec14d481cbc59840247253b785bfacd5', 1, '2022-07-22');

-- --------------------------------------------------------

-- 
-- Table structure for table `secode`
-- 

CREATE TABLE `secode` (
  `secure` varchar(15) NOT NULL,
  `scode` int(11) NOT NULL,
  PRIMARY KEY  (`secure`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `secode`
-- 

INSERT INTO `secode` (`secure`, `scode`) VALUES 
('secnumber', 2118);

-- --------------------------------------------------------

-- 
-- Table structure for table `seller`
-- 

CREATE TABLE `seller` (
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `cid` varchar(30) NOT NULL default '',
  `contact` int(11) NOT NULL,
  `kid` varchar(20) NOT NULL,
  `loc` varchar(50) NOT NULL,
  `rdate` date NOT NULL,
  `zone` varchar(10) NOT NULL,
  PRIMARY KEY  (`cid`,`kid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `seller`
-- 

INSERT INTO `seller` (`fname`, `lname`, `cid`, `contact`, `kid`, `loc`, `rdate`, `zone`) VALUES 
('Mothabana', 'Sekoko', '102356', 71633456, '45230', 'Ikongwe/Shoshong', '2021-07-18', 'C10'),
('Balebetse', 'Badisa', '10256452', 77234567, '10256452', 'zoroga', '2021-07-18', 'B4b'),
('Dipula', 'Phokoje', '102589', 71463745, '102589', 'Shoshong/Thupane', '2021-02-08', 'C10'),
('Isiah', 'Baruti', '1356', 72241902, '1356', 'Ngwapa 2', '2021-05-17', 'C9'),
('James Seriba', 'Nthobatsang', '152', 77861230, '152', 'Moiyabana', '2021-05-14', 'C8'),
('Seelo', 'Jacob', '45698', 7689098, '45698', 'Sojwe', '2021-07-18', 'I11'),
('Masautha', 'Baohentse', '557456', 77562310, '557456', 'Kodibeleng/Dinwane', '2021-05-25', 'C10'),
('Monamati', 'Letsebe', '66789103', 77102365, '66789103', 'Lebung', '2021-08-21', 'C7'),
('Semanje', 'Setso', '68906724', 75143025, '10256452', 'Shoshong', '2021-07-04', 'C10'),
('Emanuel', 'Maite', '77777777', 71235698, '77777777', 'Malaka', '2021-07-18', 'C9'),
('Semanje', 'Setso', '78456213', 2147483647, '033021', 'tHUPANE', '2021-06-13', 'C10'),
('Mhiko', 'Padpad', '78945', 75461230, '78945', 'Borolong', '2021-05-25', 'C6'),
('Game', 'Kanokang', '8562312', 71324568, '8562312', 'Tonota', '2021-08-24', 'C7'),
('Thomas', 'Keithoke', '88888888', 771023, '88888888', 'Sebina/marobela', '2021-07-22', 'C6'),
('Sebokolodi', 'Siamang', '96102312', 74561230, '96102312', 'Makalamabedi', '2021-08-11', 'A2d');

-- --------------------------------------------------------

-- 
-- Table structure for table `stockp`
-- 

CREATE TABLE `stockp` (
  `stid` int(11) NOT NULL auto_increment,
  `cid` varchar(20) NOT NULL,
  `btype` varchar(30) NOT NULL,
  `bname` varchar(100) NOT NULL,
  `ctype` varchar(5) NOT NULL,
  `grade` varchar(50) NOT NULL,
  `cdesc` varchar(250) default NULL,
  `qty` int(11) NOT NULL,
  `price` varchar(50) default NULL,
  `rdate` date NOT NULL,
  `img1` varchar(250) default NULL,
  PRIMARY KEY  (`stid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `stockp`
-- 

INSERT INTO `stockp` (`stid`, `cid`, `btype`, `bname`, `ctype`, `grade`, `cdesc`, `qty`, `price`, `rdate`, `img1`) VALUES 
(9, 'BF/CR002/2021', 'Public', 'Public', '1', 'Grade 12', 'Mabele a masweu a kone, 12 tones', 7, '300', '2021-08-05', '1'),
(10, 'ChDC/PT/002', 'Public', 'Public', '4', 'Grade 4', 'Dikgetsi tsa manoko, 800 tones', 800, '450', '2021-08-05', '1'),
(11, 'ChDC/PT/002', 'Public', 'Public', '1', 'Grade 1', 'Mabele a mahibidu, 900 tones', 900, '200', '2021-08-05', '1'),
(12, 'BF/CR002/2021', 'Public', 'Public', '5', 'Grade 2', 'Mmedi o mosweu, 100 tonnes', 100, '500', '2021-08-07', '1');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_mstl`
-- 

CREATE TABLE `tbl_mstl` (
  `lic` varchar(10) NOT NULL,
  `lno` smallint(11) NOT NULL default '0',
  `stdate` date NOT NULL,
  `endate` date NOT NULL,
  PRIMARY KEY  (`lno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `tbl_mstl`
-- 

INSERT INTO `tbl_mstl` (`lic`, `lno`, `stdate`, `endate`) VALUES 
('SEDC', 3, '2014-04-24', '2021-12-15');

-- --------------------------------------------------------

-- 
-- Table structure for table `thekiso`
-- 

CREATE TABLE `thekiso` (
  `id` int(11) NOT NULL auto_increment,
  `kid` varchar(20) NOT NULL,
  `btype` varchar(30) NOT NULL,
  `bname` varchar(100) NOT NULL,
  `atype` varchar(5) NOT NULL,
  `category` int(11) NOT NULL,
  `breed` varchar(50) default NULL,
  `sex` varchar(10) default NULL,
  `age` varchar(50) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `etag` varchar(15) default NULL,
  `qty` int(11) NOT NULL,
  `rdate` date NOT NULL,
  `ptag` varchar(50) NOT NULL,
  `price` varchar(15) default NULL,
  `image1` varchar(250) default NULL,
  `image2` varchar(250) default NULL,
  `image3` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `thekiso`
-- 

INSERT INTO `thekiso` (`id`, `kid`, `btype`, `bname`, `atype`, `category`, `breed`, `sex`, `age`, `desc`, `etag`, `qty`, `rdate`, `ptag`, `price`, `image1`, `image2`, `image3`) VALUES 
(1, '102589', '2', 'Bul-OT (LTD) Ltd', '1', 3, 'simmental', 'Male', '2-3 Years', 'zero tooth', NULL, 4, '2021-06-23', '4500-5000', '4800', 'cattle1.jpg', 'Simmental-bull.jpg', 'cattle4.jpg'),
(2, '1356', '10', 'Public', '3', 4, 'Saanen', 'Female', '3-4 Years', 'three years old', NULL, 5, '2021-06-23', '1000-1500', '1200', 'goat2.jpg', 'goat3.jpg', 'goat.jpg'),
(3, '102589', '10', 'Public', '1', 3, 'Brahman', 'Male', '2-3 Years', 'two years', NULL, 3, '2021-06-23', '5000 OR Greater', '6000', 'brahman.jpg', 'charolais.jpg', 'pholo.jpg'),
(4, '1356', '2', 'Bul-OT (LTD) Ltd', '1', 3, 'Tswana', 'Male', '2-3 Years', 'Zero tooth', NULL, 2, '2021-06-28', '4500-5000', '4200', 'tswana heifer.jpg', 'cattle4.jpg', 'livestock.jpg'),
(5, '102589', '2', 'Bul-OT (LTD) Ltd', '1', 3, 'Tswana', 'Male', '2-3 Years', 'zero tooth', NULL, 4, '2021-06-30', '4500-5000', '4700', 'dipholo.jpg', 'pholo.jpg', 'tswana.jpg'),
(6, '1356', '2', 'zee investment', '1', 3, 'Brahman', 'Male', '2-3 Years', 'Mealolelo ya dipholwana tse di dingwaga tse pedi, they are pure brahmans', NULL, 5, '2021-07-01', '5000 OR Greater', '5500', 'brahman2.jpg', 'brahman3.jpg', 'brahman4.jpg'),
(7, '102589', '2', 'zee investment', '1', 3, 'Red Brahman', 'Male', '2-3 Years', 'Ke dipholwana tse ngwaga tse pedi, Zero tooth', NULL, 10, '2021-07-01', '5000 OR Greater', '5700', 'redbrahman2.jpg', 'redbrahman.jpg', 'redbrahman3.jpg'),
(8, '557456', '2', 'zee investment', '1', 3, 'charolois', 'Male', '2-3 Years', 'Still young with zero tooth', NULL, 2, '2021-07-03', '4500-5000', '4400', 'charolais.jpg', 'Simmental-bull.jpg', 'charolais.jpg'),
(9, '45230', '3', 'Gradeware Solutions PTY LTD', '1', 3, 'Brahman', 'Male', '3-4 Years', 'Powana ya brahman ya zero tooth', NULL, 1, '2021-07-18', '4000-4500', '4800', 'brahman3.jpg', '', ''),
(10, '10256452', '10', 'Public', '4', 4, 'Doppers', 'Both', '3-4 Years', 'Dinku tsa di Dopper, tse di tonaynana di le 4, le tse di namagadi dile 8', NULL, 6, '2021-07-18', '5000 OR Greater', '12000', 'goat.jpg', '', ''),
(12, '10256452', '10', 'Public', '9', 5, 'Tswana', 'Both', '1-2 Years', 'Dikoko tsa setswana tse 10 for sale', NULL, 10, '2021-07-18', '100', '100', '', '', ''),
(13, '45698', '10', 'Public', '11', 6, 'Katse ya Setswana', 'Male', '6-10 Years', 'Dikatse', NULL, 2, '2021-07-18', '50', '50', '', '', ''),
(14, '45230', '10', 'Public', '1', 3, 'Semintal Bull', 'Male', '2-3 Years', 'Semental for sales', NULL, 1, '2021-07-18', '5000 OR Greater', '15000', 'AI.PNG', '', ''),
(15, '152', '10', 'Public', '5', 7, 'Tswana', 'Male', '2-3 Years', 'Pitse e tshumu, e katile.. ready for use', NULL, 1, '2021-07-18', '4500-5000', '4200', 'studb.PNG', '', ''),
(16, '45698', '2', 'Quinn & Sons (pty) ltd', '1', 3, 'Tswana', 'Yes', '1-2 Years', '3 zero tooths', NULL, 3, '2021-07-24', '4000-4500', '4300', 'cattle4.jpg', '', ''),
(17, '45698', '4', 'Naumi & Sons (pty) ltd', '3', 4, 'Boer Goat', 'Yes', '2-3 Years', 'Diphoko tse tharo', '2001/5523', 3, '2021-07-24', '3500-4000', '3100', 'goat3.jpg', '', ''),
(18, '96102312', '10', 'Public', '1', 3, 'Sherillen', 'Yes', '2-3 Years', 'Powana tse tharo', '3001/1020', 3, '2021-08-11', '5000 OR Greater', '6500', 'AI.PNG', '', ''),
(19, '77777777', '3', 'Gradeware Solutions PTY LTD', '3', 4, 'Boer', 'Yes', '1-2 Years', 'Dipholwana tse 3 tsa dipudi', '1540/2001', 3, '2021-08-21', '3000-3500', '3350', 'goat.jpeg', '', ''),
(20, '77777777', '3', 'Oodi Abottor', '1', 3, 'Bonsmara', 'Yes', '2-3 Years', 'Dipholwana tsa ma zero tooth di le 5', '1050/2315', 5, '2021-08-21', '4000-4500', '4300', 'cow.png', '', ''),
(21, '66789103', '3', 'Botswana Meet Commission, BMC Lobatse', '1', 3, 'Tswana', 'Yes', '3-4 Years', 'Dipholwana tse 10 tsa ma zero tooth', '1102/2365', 10, '2021-08-21', '4000-4500', '4200', 'cow.png', '', ''),
(22, '66789103', '3', 'Botswana Meet Commission, BMC Lobatse', '3', 4, 'Tswana', 'Yes', '2-3 Years', 'Dipholwana tsa dipudi tse 5', '1230/2055', 5, '2021-08-21', '1500-2000', '15000', 'goat.jpeg', 'sheep.png', ''),
(23, '8562312', '3', 'Gradeware Solutions PTY LTD', '4', 4, 'Meet Master', 'Yes', '3-4 Years', 'dipholwana tsa nama di le 4', '1023/4560', 4, '2021-08-24', '4500-5000', '4000', 'sheep.png', 'goat.jpeg', ''),
(24, '8562312', '3', 'Botswana Meet Commission, BMC Lobatse', '3', 4, 'Kalahari Red', 'No', '4-5 Years', 'Pholo tsa dipudi for sales, di 8', '', 8, '2021-08-24', '4500-5000', '4000', 'goat.jpeg', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `tractor`
-- 

CREATE TABLE `tractor` (
  `owner` varchar(100) NOT NULL,
  `oid` varchar(30) NOT NULL,
  `contact` varchar(30) NOT NULL,
  `padres` varchar(100) default NULL,
  `loc` varchar(50) NOT NULL,
  `zone` varchar(10) NOT NULL,
  `tmodel` varchar(100) NOT NULL,
  `plateno` varchar(30) NOT NULL,
  `price` varchar(10) default NULL,
  `astatus` varchar(30) NOT NULL,
  `rdate` date NOT NULL,
  `rnd` date default NULL,
  `decl` tinyint(4) default NULL,
  PRIMARY KEY  (`plateno`,`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `tractor`
-- 

INSERT INTO `tractor` (`owner`, `oid`, `contact`, `padres`, `loc`, `zone`, `tmodel`, `plateno`, `price`, `astatus`, `rdate`, `rnd`, `decl`) VALUES 
('Olerato Bongani', '45123652', '74521301', 'Bag 01,\r\nFtown', 'Masunga', 'NEDC', 'Blue Morghun, HJ', 'B723ABZ', '200', '1', '2021-07-16', '2022-07-16', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `truck`
-- 

CREATE TABLE `truck` (
  `owner` varchar(100) NOT NULL,
  `contact` varchar(30) NOT NULL,
  `loc` varchar(50) NOT NULL,
  `zone` varchar(10) NOT NULL,
  `ttype` varchar(30) NOT NULL,
  `plateno` varchar(30) NOT NULL,
  `tpurpose` varchar(50) default NULL,
  `tcap` varchar(50) NOT NULL,
  `astatus` varchar(30) NOT NULL,
  `pwd` varchar(100) default NULL,
  `rdate` date NOT NULL,
  `rnd` date default NULL,
  PRIMARY KEY  (`plateno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `truck`
-- 

INSERT INTO `truck` (`owner`, `contact`, `loc`, `zone`, `ttype`, `plateno`, `tpurpose`, `tcap`, `astatus`, `pwd`, `rdate`, `rnd`) VALUES 
('Raletsia Alefeng', '75854521/74561230', 'Mopipi', 'B4b', 'Trailer Only', 'B 124 AFR', NULL, '28 Cattles', 'provisional', 'B 124 AFR', '2021-05-23', '2022-05-23'),
('Tobetsa Seile', '74562130', 'Malaka', 'C9', 'J5 Truck', 'B 765 BDZ', NULL, '10 Cattle', 'provisional', 'B 765 BDZ', '2021-05-24', '2022-05-24'),
('Quinn Keithoke', '74561234', 'Shoshong', 'C10', 'J5 Truck', 'B723ABZ', 'Cattle', '10 cattles/horses', 'provisional', 'B723ABZ', '2021-07-12', '2021-07-12');

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `SID` int(11) NOT NULL auto_increment,
  `uname` char(20) character set utf8 NOT NULL,
  `pwd` varchar(100) character set utf8 NOT NULL,
  `dcode` varchar(25) character set utf8 NOT NULL,
  `role` varchar(20) default NULL,
  `fname` char(20) character set utf8 default NULL,
  `lname` char(20) character set utf8 default NULL,
  `user_status` varchar(20) NOT NULL default 'active',
  PRIMARY KEY  (`SID`,`dcode`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40124 ;

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

INSERT INTO `users` (`SID`, `uname`, `pwd`, `dcode`, `role`, `fname`, `lname`, `user_status`) VALUES 
(1, 'nkufigwa', 'ec14d481cbc59840247253b785bfacd5', 'GWS', 'Accounts', 'Ndyapo', 'Kufigwa', 'Active'),
(6, 'tmorapedi', 'ec14d481cbc59840247253b785bfacd5', 'GWS', 'Accounts', 'Tootina', 'Morapedi', 'Active'),
(10, 'ibaruti', 'ec14d481cbc59840247253b785bfacd5', 'MLG_HQ', 'sa', 'Isiah', 'Baruti', 'active'),
(251, 'gnakedi', 'ec14d481cbc59840247253b785bfacd5', 'PLA', 'LA_registrar', 'Gladys', 'Nakedi', 'Active'),
(781, 'rtsae', 'ec14d481cbc59840247253b785bfacd5', 'TLSDC', 'LA_registrar', 'Richard', 'Tsae', 'Active'),
(1020, 'mgaboalapswe', 'ec14d481cbc59840247253b785bfacd5', ' GWS', 'sa', 'Motlhatlhedi', 'Gaboalapswe', 'Active'),
(1120, 'mmetsemebedi', 'ec14d481cbc59840247253b785bfacd5', 'KwDC', 'LA_registrar', 'Mothusi', 'Metsemebedi', 'Active'),
(1230, 'lseepo', 'ec14d481cbc59840247253b785bfacd5', 'BPS_HQ', 'sa', 'Lelani', 'Seepo', 'active'),
(1230, 'knkwe', 'ec14d481cbc59840247253b785bfacd5', 'MSDC', 'LA_registrar', 'Kelebogile', 'Nkwe', 'Active'),
(2345, 'msekobolo', 'ec14d481cbc59840247253b785bfacd5', 'BSDC', 'LA_registrar', 'Monate', 'Sekobolo', 'Active'),
(3201, 'jbosigo', 'ec14d481cbc59840247253b785bfacd5', 'PLA', 'LA_registrar', 'John', 'Bosigo', 'Active'),
(6001, 'smakocha', 'ec14d481cbc59840247253b785bfacd5', 'BPS_HQ', 'Director', 'Senei', 'Makocha', 'active'),
(40123, 'pseshoka', 'ec14d481cbc59840247253b785bfacd5', ' MLG_HQ', 'HQ_Registrar', 'Phillip', 'Seshoka', 'Active');

-- --------------------------------------------------------

-- 
-- Table structure for table `vet`
-- 

CREATE TABLE `vet` (
  `pname` varchar(100) NOT NULL,
  `pnumber` varchar(30) NOT NULL,
  `contact` varchar(30) NOT NULL,
  `email` varchar(100) default NULL,
  `ptype` varchar(100) NOT NULL,
  `dservice` varchar(200) NOT NULL,
  `loc` varchar(50) NOT NULL,
  `zone` varchar(10) NOT NULL,
  `rdate` date NOT NULL,
  `astatus` varchar(10) NOT NULL,
  `pwd` varchar(70) NOT NULL,
  `rnwd` date NOT NULL,
  PRIMARY KEY  (`pnumber`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `email_2` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `vet`
-- 

INSERT INTO `vet` (`pname`, `pnumber`, `contact`, `email`, `ptype`, `dservice`, `loc`, `zone`, `rdate`, `astatus`, `pwd`, `rnwd`) VALUES 
('Dr Kelebe Veterinarial services', 'GCC/001/VET', '74745612', 'dkvservices@yahoo.com', 'Veterinary Practitioners', 'Veterinarian services and food supplies', 'Palapye', 'C9', '2021-07-25', 'provisiona', 'GCC/001/VET', '2022-07-25'),
('Royal Oshi Mongale', 'VET/020/2021', '74562130', NULL, 'Veterinary Practitioners', 'Ralephalo, animal medical supplies, feed, mokenti, AI', 'Shoshong', 'C10', '2021-05-28', '1', 'VET/020/2021', '2022-05-28');

-- --------------------------------------------------------

-- 
-- Table structure for table `zone`
-- 

CREATE TABLE `zone` (
  `zcode` varchar(10) NOT NULL,
  `zname` varchar(100) NOT NULL,
  PRIMARY KEY  (`zcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `zone`
-- 

INSERT INTO `zone` (`zcode`, `zname`) VALUES 
('A16', 'Okavango Delta'),
('A2a', 'Shakawe/Mohembo/Seronga'),
('A2b', 'Nxamasere/Sepopa/Tsodilo/Chukumucha'),
('A2c', 'Ikoga/Gumare/Nxauxau/Quagwa/Nokaneng/Habu/Tsau'),
('A2d', 'Kareng/Sehithwa/Maun/Makalamabedi'),
('B3a', 'Ngwasha'),
('B3b', 'Nata/Gweta'),
('B4a', 'Makalamabedi/Rakops'),
('B4b', 'Mopipi/Mokoboxane Setata'),
('B5', 'Letlhakane'),
('C10', 'Mahalapye/Shoshong'),
('C17', 'Mashatu'),
('C3c', 'Sowa/Semowana/Maitengwe'),
('C6', 'Francistown'),
('C7', 'Selebi Phikwe/Tonota'),
('C8', 'Serowe'),
('C9', 'Palapye'),
('D6', 'Tati Concession'),
('E10', 'Southern Tuli Block'),
('E7', 'Northern Tuli Block'),
('E9', 'Central Tuli Block'),
('F11', 'Kgatleng'),
('G11', 'South East/Balete'),
('H11', 'Tlokweng'),
('I11', 'Kweneng'),
('J11', 'Ngwaketse'),
('K11', 'Barolong Farms'),
('L11', 'Lobatse'),
('M11', 'Gaborone'),
('N13', 'Kgalagadi'),
('O12', 'Ghantsi'),
('P1', 'Chobe');
