--
-- Host: localhost    Database: logistics
-- ------------------------------------------------------


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

CREATE TABLE `staff` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `fullName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `staffCategoryID` int(5) NOT NULL,
  `idNumber` int(15) NOT NULL,
  `dob` datetime NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phone1` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `phone2` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `active` int(2) NOT NULL,
  `deleted` int(2) NOT NULL,
  `collection_centerID` int(10) NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `staff` VALUES (1,'Milcah Cherop','milcah','1234567',1,23698754,'1989-05-18 13:37:37','cherop@gmail.com','0789568421','0789562145',1,0,1,'2021-01-06 10:45:32'),(2,'Nicholas Kimani','nic','1234567',1,265987452,'1988-01-06 08:29:30','nic@gmail.com','07854589214','07895412573',1,0,2,'2021-01-06 10:18:38'),(3,'Samuel Kirika','sam','1234567',2,26598857,'1990-01-06 08:24:31','kirika@yahoo.com','0714545879','07458784589',1,0,0,'2021-01-06 13:32:24'),(4,'Sospeter Omondi','sos','123456',3,25458874,'1985-04-18 07:29:20','sospeter@gmail.com','07854578125','0739854217',1,0,0,'2021-01-10 08:24:26'),(5,'Sheila Mwangi','sheila','1234567',4,365422187,'1997-12-24 06:31:00','sheila@gmail.com','0714758748','0725458741',1,0,0,'2021-02-16 08:00:00');


