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




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

--
-- Table structure for table `animal`
--

CREATE TABLE IF NOT EXISTS `animal` (
  `sno` int(11) NOT NULL,
  `colour` varchar(30) NOT NULL,
  `bstyle` varchar(15) DEFAULT NULL,
  `br1` varchar(3) DEFAULT NULL,
  `br2` varchar(3) DEFAULT NULL,
  `br3` varchar(3) DEFAULT NULL,
  `emak` varchar(30) DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `Des` varchar(50) DEFAULT NULL,
  `idate` date NOT NULL,
  `state` varchar(20) NOT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `claiment`
--

CREATE TABLE IF NOT EXISTS `claiment` (
  `fname` varchar(30) NOT NULL,
  `lname` varchar(30) NOT NULL,
  `id` varchar(15) NOT NULL,
  `location` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `damage`
--

CREATE TABLE IF NOT EXISTS `damage` (
  `sno` int(11) NOT NULL,
  `dmdate` date NOT NULL,
  `dmtype` varchar(25) NOT NULL,
  `rnames` varchar(50) NOT NULL,
  `loc` varchar(30) NOT NULL,
  `dmrate` varchar(25) DEFAULT NULL,
  `amt` int(11) DEFAULT NULL,
  PRIMARY KEY (`sno`,`dmdate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `died`
--

CREATE TABLE IF NOT EXISTS `died` (
  `sno` int(11) NOT NULL,
  `ddate` date NOT NULL,
  `drsn` varchar(100) NOT NULL,
  `dtype` varchar(15) NOT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `disposal`
--

CREATE TABLE IF NOT EXISTS `disposal` (
  `sno` int(11) NOT NULL,
  `fname` varchar(30) NOT NULL,
  `lname` varchar(30) NOT NULL,
  `id` varchar(15) NOT NULL,
  `adate` date DEFAULT NULL,
  `amnt` decimal(10,0) DEFAULT NULL,
  `recno` varchar(15) NOT NULL,
  `cdate` date DEFAULT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

--
-- Table structure for table `meds`
--

CREATE TABLE IF NOT EXISTS `meds` (
  `sno` int(11) NOT NULL,
  `voff` varchar(50) NOT NULL,
  `disease` varchar(50) NOT NULL,
  `meds` varchar(100) DEFAULT NULL,
  `dstatus` varchar(25) NOT NULL,
  `recom` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mstl`
--

CREATE TABLE IF NOT EXISTS `mstl` (
  `lic` varchar(10) NOT NULL,
  `sd` date NOT NULL,
  `ed` date NOT NULL,
  PRIMARY KEY (`lic`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mstl`
--

INSERT INTO `mstl` (`lic`, `sd`, `ed`) VALUES
('1', '2018-08-13', '2018-12-24');

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

--
-- Table structure for table `pego`
--

CREATE TABLE IF NOT EXISTS `pego` (
  `fname` varchar(30) NOT NULL,
  `lname` varchar(30) NOT NULL,
  `id` varchar(15) NOT NULL,
  `loc` varchar(30) NOT NULL,
  `atype` varchar(25) NOT NULL,
  `tno` int(11) NOT NULL,
  `repdate` date NOT NULL,
  `duration` int(11) NOT NULL,
  `mofficer` varchar(30) NOT NULL,
  PRIMARY KEY (`id`,`repdate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pmaster`
--

CREATE TABLE IF NOT EXISTS `pmaster` (
  `sno` int(11) NOT NULL,
  `id` varchar(15) NOT NULL,
  `hfees` double NOT NULL,
  `susfee` double NOT NULL,
  `recno` varchar(15) NOT NULL,
  `reldate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_login`
--

CREATE TABLE IF NOT EXISTS `tbl_login` (
  `usrname` char(15) CHARACTER SET utf8 NOT NULL,
  `role` varchar(25) CHARACTER SET utf8 NOT NULL,
  `ldate` date DEFAULT NULL,
  PRIMARY KEY (`usrname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_login`
--

INSERT INTO `tbl_login` (`usrname`, `role`, `ldate`) VALUES
('ibaruti', 'sa', '2018-08-20'),
('mgaboalapswe', 'registrar', '2018-08-20');

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

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

CREATE TABLE IF NOT EXISTS `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', 2, '2014-04-24', '2019-09-09');

