-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 21, 2024 at 02:22 PM -- Server version: 10.4.27-MariaDB -- PHP Version: 8.0.25 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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: `will` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(100) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`) VALUES (1, 'jogbu', '$2y$10$icvbHwuqJ/F9xn2EtNui1.6O6NHv2KZapjvfoJAULvM5igXIgMGUy'), (2, 'jesse', '$2y$10$eBQ.Wn3MxlOnLd6MJo/gW.2swgGruXdNFmOKN0ARXn92WyJDoFQoi'), (3, 'marcus', '$2y$10$/9Y9P4d/rbX6Gk7HVtFpZ.pS1aT8hhahbvkdxiAkndS7dXPFQ./tm'), (4, 'mwesigye', '$2y$10$EWCirqOhOYqta39ai9/Fzu.l5fWWNJZ8XR4HE1FMtAOafwZh73YLi'), (5, 'blo', '$2y$10$v6qx8MKlB/8NFClw5XW9JejFvTfcF.BZInZPOSsSBtHiFFRsrIUaW'), (6, 'headie', '$2y$10$kaP8X1nrPznEC/Oxq6iOC.lGnIUTmC8qxTRkpevh/HsGUh0DFUSIW'), (7, 'tra', '$2y$10$Bk/A3do1JAV81gC.M82kpeZvuCxbtkA4jciVSJY9ct4xGnMMKt/8.'), (8, 'phone', '$2y$10$6gxIODLzthMomfrGu7lH7uSeis2pU8h/e5ORix.0TqmbzdhVWIEqy'), (9, 'new', '$2y$10$0b.6fPPuqLBryY8DB1ABTu.40XObCSPXeZc7nqWe7Os4keonMnveW'), (10, 'martinez', '$2y$10$PTQm6UJw95ztoAojbGsGZOh40hbt6Z7uAR3/1UZjyHEbQio3Optdy'), (11, 'samsung', '$2y$10$xpkUyl3RAZYAv5tU50ICMOEPMgBElUaRPadenuijMcTfgOZ1wK9UO'), (12, 'josh', '$2y$10$LRw5Nky16nAthpxdzSDc.OFkFxbBkWz8BW4lLBnW3ghiazaT7nL96'), (13, 'test', '$2y$10$EFX.3Yi5KASdMpsr0HRteOpJNdme2873Rqsk3XuET5YCHYZ0bfw5W'), (14, 'endo', '$2y$10$OQXQmEppxe6RnDIwxf7b8Oia18.cNvbZvU1iEQlPLvZkDcFjHSpW.'); -- -------------------------------------------------------- -- -- Table structure for table `will_info` -- CREATE TABLE `will_info` ( `session_id` int(100) NOT NULL, `user_id` int(11) NOT NULL, `fname` varchar(100) NOT NULL, `lname` varchar(100) NOT NULL, `othername` varchar(100) NOT NULL, `district` varchar(100) NOT NULL, `subcounty` varchar(100) NOT NULL, `age` int(100) NOT NULL, `dob` date NOT NULL, `marital_status` varchar(100) NOT NULL, `spouse_name` varchar(100) NOT NULL, `spouse_age` int(100) NOT NULL, `gender` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contact` int(100) NOT NULL, `childs_name` varchar(100) NOT NULL, `childs_age` varchar(100) NOT NULL, `dependants_name` varchar(100) NOT NULL, `guardians_name` varchar(100) NOT NULL, `guardians_address` varchar(100) NOT NULL, `executor_name` varchar(100) NOT NULL, `heir_name` varchar(100) NOT NULL, `heir_address` varchar(100) NOT NULL, `property_name` varchar(100) NOT NULL, `witness_name` varchar(100) NOT NULL, `witness_address` varchar(100) NOT NULL, `witness_signature` varchar(100) NOT NULL, `dependants_age` int(100) NOT NULL, `distribution_name` varchar(100) NOT NULL, `distribution` varchar(100) NOT NULL, `signature` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `will_info` -- INSERT INTO `will_info` (`session_id`, `user_id`, `fname`, `lname`, `othername`, `district`, `subcounty`, `age`, `dob`, `marital_status`, `spouse_name`, `spouse_age`, `gender`, `email`, `contact`, `childs_name`, `childs_age`, `dependants_name`, `guardians_name`, `guardians_address`, `executor_name`, `heir_name`, `heir_address`, `property_name`, `witness_name`, `witness_address`, `witness_signature`, `dependants_age`, `distribution_name`, `distribution`, `signature`) VALUES (18, 3, 'marcus', 'n77n7n7', 'unyny', 'ynnyn', '', 0, '2024-03-28', 'Single', 'ynyn', 56, 'female', 'jmwesigye@barefootlaw.org', 686, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', '', '', '', '', '', '', 0, '', '', ''), (19, 6, 'grbe', 'rbrb', 'rbbd', 'dcexd', '', 333333, '2024-03-28', 'Single', 'ecece', 0, 'female', 'jessemwesigye@gmail.com', 31231312, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'mwegs', 'cz4c4c4z', 'land,water,bread', 'egss,trewy,mnbty', 'gwen,rewqy,re', '', 0, '', '', ''), (22, 7, 'Jesse', 'Mwesigye', 'Ayebare', 'kyaliwajala', '', 23, '2024-03-01', 'Married', 'Jeny', 24, 'male', 'jayayebare@gmail.com', 779889258, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Jesse', 'jljjj', 'land', 'john', 'muyenga', '', 0, '', '', ''), (23, 8, 'RHino', 'kylo', 'ren', 'kyaliwajala', '', 19, '2024-03-21', 'Married', 'harriet', 19, 'male', 'john@gmail.com', 774242074, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'halo', 'yeonce', 'lando,ware', 'john,winter', 'snow,is coming bro', '', 0, '', '', ''), (24, 9, 'adasdasd', 'asdad', 'dsadad', 'dadsad', '', 12313, '2024-03-21', 'Single', 'fdsfsf', 0, 'male', 'jordanlance67@gmail.com', 779883764, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'willson', 'kampala', 'maisha', 'hehe', 'huleya', '', 0, '', '', ''), (25, 9, 'noln', 'oin', 'oin', 'oin', '', 0, '2200-02-02', 'Single', 'ionjh', 0, 'male', 'ion@ion.com', 0, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'willson', 'kampala', 'maisha', 'hehe', 'huleya', '', 0, '', '', ''), (26, 9, 'fhnrn', 'tbhbtb', 'btthbh', '', 'bthtb', 656, '2024-03-20', 'Married', 'tbty', 0, 'male', 'jayayebare@gmail.com', 35354, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'willson', 'kampala', 'maisha', 'hehe', 'huleya', '', 0, '', '', ''), (27, 9, 'Will', 'I AM', 'Britney', '', 'kole', 656, '2024-03-20', 'Married', 'tish', 23, 'male', 'jayayebare@gmail.com', 35354, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'willson', 'kampala', 'maisha', 'hehe', 'huleya', '', 0, '', '', ''), (28, 10, 'Lisandro', 'Martinez', 'Man u', '', 'kampala', 20, '2024-03-15', 'Married', 'Harisha', 34, 'male', 'jolo@gmail.com', 779889764, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Will', 'kyaliwajaala', 'buildings,shops', 'grealish,doku', 'kampala,masaka', '', 0, '', '', ''), (29, 11, 'Samsung', 'APPLE', 'dashy', '', 'kampala', 23, '2024-03-18', 'Married', 'Shisha', 32, 'male', 'horoje@gmail.com', 779889764, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Hendo', 'dubai', 'land,fish', 'fufuf,carlo', 'cutfctuc,anceloti', '', 0, 'hendo,mason,mount', 'land,ware,air', ''), (30, 12, 'Okalany', 'Daniel', 'J', '', 'Ntinda', 34, '1990-02-26', 'Married', 'Trudy', 30, 'female', 'daniel@barefootlaw.org', 703191342, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Tudy', 'kampala', 'macbook,Evo', 'Sheena', 'kampala', '', 0, 'Trudy,Jesse', 'Macbook,Evo', ''), (31, 13, 'Kobee', 'Mainoo', '', 'Kyambogo', 'Kyaliwajala', 20, '2024-03-20', 'Married', 'Groshy', 24, 'male', 'halo@gmail.com', 779889256, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Ando', 'kenya', 'land,water', 'grajmubende', 'mubzy', '', 0, 'sheher', 'water', ''), (32, 13, 'Groot', 'Hando', '', 'Kyaliwajal', 'Mubende', 20, '2024-03-22', 'Married', 'Mwendy', 22, 'male', 'josh@gmail.com', 779889258, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Ando', 'kenya', 'land,water', 'grajmubende', 'mubzy', '', 0, 'sheher', 'water', ''), (33, 14, 'Endo', 'Frenandez', 'chris', 'kole', 'gulu', 38, '2024-03-13', 'Married', 'Goretti', 34, 'male', 'gloria@gmail.com', 2147483647, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', 'Garner', 'UK', 'Land,Car,Food', 'gloria,Beveryly', 'UK,Hill', '', 0, 'Sheilah,Josh', 'land,water', ''), (34, 0, 'josh', 'vwvwrv', 'bnobjob', 'jobjob', 'bobouu', 80, '0898-09-01', 'Married', 'npknk', 0, 'female', 'joshi@gmail.com', 2147483647, 'efqef', '32', 'afdafaf', 'afafaf', 'affa', 'affaads', '', '', '', '', '', '', 0, '', '', ''), (35, 0, 'wefwefwefw', 'weffwef', 'fwefwef', 'wfefwf', 'wfwfwef', 0, '2024-03-22', 'Married', 'wefwfef', 0, 'male', 'joshi@gmail.com', 2147483647, '', '0', '', '', '', '', '', '', '', '', '', '', 0, '', '', ''), (36, 0, 'yyyyyyyyyyyyyyo', 'vwvwrv', 'vrwrvwv', 'v', 'wvw', 32, '2024-03-25', 'Single', 'revewv', 0, 'male', 'josh@gmail.com', 2147483647, '', '0', '', '', '', '', '', '', '', '', '', '', 0, '', '', ''), (39, 0, 'wvrwvw', 'vwrvw', 'vwrvwvw', 'vwrvwvw', 'vwrwv', 0, '2024-03-14', 'Single', 'vwvwvrw', 0, 'female', 'jesse@gmail.com', 2147483647, '', '0', '', '', '', '', '', '', '', '', '', '', 0, '', '', ''), (40, 0, '', '', '', '', '', 0, '0000-00-00', '', '', 0, '', '', 0, 'gf3wg3g', '23', 'gegeg', 'egegerg23', '24', 'ergegeg', '', '', '', '', '', '', 0, '', '', ''), (41, 0, 'PAstro', 'Ramsey', 'Gordon', 'kampala', 'mubs', 21, '2024-03-20', 'Married', 'Hariiet', 32, 'male', 'josh@gmail.com', 2147483647, 'Gordo', '21', 'foney', 'bubsy', 'canada', 'kenya', 'MAlawi', 'gorosyui', 'land', 'eric', 'boro', '', 0, 'joshla', 'land', ''), (42, 0, 'Padio', 'Bear', 'Greg', 'Kampala', 'Mubende', 21, '2024-03-19', 'Single', 'gred', 21, 'female', 'jolo@gmail.com', 2147483647, 'Borris,Johnson', '12,22', 'greg', 'adada', 'adadad', 'asdad', '', '', '', '', '', '', 0, '', '', ''), (43, 0, 'Okalany', 'Daniel', 'O', 'Kampala', 'UG', 0, '1990-02-26', 'Single', 'O', 12, 'male', '', 703191342, 'D,C', '12', 'O', 'O', 'd@g.com', 'D', '', '', '', '', '', '', 0, '', '', ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `will_info` -- ALTER TABLE `will_info` ADD PRIMARY KEY (`session_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `will_info` -- ALTER TABLE `will_info` MODIFY `session_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; COMMIT; /*!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 */;