-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `abhaf_bilingual`
--

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

--
-- Table structure for table `abha_users`
--

CREATE TABLE `abha_users` (
  `user_id` int(11) NOT NULL,
  `first_name` varchar(256) DEFAULT NULL,
  `last_name` varchar(256) DEFAULT NULL,
  `password` varchar(256) DEFAULT NULL,
  `email_id` varchar(256) DEFAULT NULL,
  `mobile` bigint(20) DEFAULT NULL,
  `place` varchar(256) DEFAULT NULL,
  `address` varchar(512) DEFAULT NULL,
  `register_date` datetime DEFAULT NULL COMMENT 'join date',
  `pass_reset_link` varchar(50) DEFAULT NULL,
  `activate_key` varchar(50) DEFAULT NULL,
  `user_type` smallint(6) DEFAULT '1' COMMENT '0 - admin, 1 - user',
  `file_name` text,
  `ftype` varchar(20) DEFAULT NULL,
  `fsize` float DEFAULT NULL,
  `status` smallint(1) DEFAULT NULL COMMENT '1-active, 0-inactive',
  `last_active` datetime DEFAULT NULL COMMENT 'last login datetime',
  `joined_status` smallint(6) DEFAULT '0' COMMENT '1-active, 0-inactive',
  `pass_reset_date` datetime DEFAULT NULL,
  `is_pass_reseted` smallint(6) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `abha_users`
--

INSERT INTO `abha_users` (`user_id`, `first_name`, `last_name`, `password`, `email_id`, `mobile`, `place`, `address`, `register_date`, `pass_reset_link`, `activate_key`, `user_type`, `file_name`, `ftype`, `fsize`, `status`, `last_active`, `joined_status`, `pass_reset_date`, `is_pass_reseted`) VALUES
(1, 'The Al-Attiyah International Foundation ', NULL, '6d9ff949640422493f3db836c3035c64', 'info@abhafoundation.org', NULL, NULL, NULL, '2017-07-04 15:16:10', NULL, NULL, 0, 'logo_v3_3_0.png', 'png', 37.67, 1, '2017-07-11 12:47:39', 1, NULL, 0),
(168, 'mthwayyib', NULL, 'a7b7e4b27722574c611fe91476a50238', 'mthwayyib@abhafoundation.org', NULL, NULL, NULL, '2022-08-21 10:52:18', NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, 0, NULL, 0),
(169, 'hussain', NULL, '227e072d131ba77451d8f27ab9afdfb7', 'huss.nada@gmail.com', NULL, NULL, NULL, '2022-08-21 10:55:21', NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, 0, NULL, 0),
(170, 'asfar', NULL, 'fb87582825f9d28a8d42c5e5e5e8b23d', 'akhan@abhafoundation.org', NULL, NULL, NULL, '2022-08-21 10:57:57', NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, 0, NULL, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abha_users`
--
ALTER TABLE `abha_users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abha_users`
--
ALTER TABLE `abha_users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;
COMMIT;

