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

START TRANSACTION;



--
-- Database: `dalemari_cards`
--

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `foldername` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `workphone` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `birthday` varchar(255) NOT NULL,
  `displayname` varchar(255) NOT NULL,
  `profile` varchar(255) NOT NULL,
  `coverimage` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `jobtitle` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `vcffile` varchar(255) NOT NULL,
  `social1` varchar(255) NOT NULL,
  `social2` varchar(255) NOT NULL,
  `social3` varchar(255) NOT NULL,
  `social4` varchar(255) NOT NULL,
  `social5` varchar(255) NOT NULL,
  `hhouse` varchar(255) NOT NULL,
  `hstreet` varchar(255) NOT NULL,
  `hcity` varchar(255) NOT NULL,
  `hstate` varchar(255) NOT NULL,
  `hcountry` varchar(255) NOT NULL,
  `hzipcode` varchar(255) DEFAULT NULL,
  `whouse` varchar(255) NOT NULL,
  `wstreet` varchar(255) NOT NULL,
  `wcity` varchar(255) NOT NULL,
  `wstate` varchar(255) NOT NULL,
  `wcountry` varchar(255) NOT NULL,
  `wzipcode` varchar(255) DEFAULT NULL,
  `sysdate` date NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `users` (`id`, `firstname`, `lastname`, `username`, `password`, `foldername`, `email`, `workphone`, `mobile`, `birthday`, `displayname`, `profile`, `coverimage`, `logo`, `youtube`, `details`, `company`, `jobtitle`, `role`, `website`, `vcffile`, `social1`, `social2`, `social3`, `social4`, `social5`, `hhouse`, `hstreet`, `hcity`, `hstate`, `hcountry`, `hzipcode`, `whouse`, `wstreet`, `wcity`, `wstate`, `wcountry`, `wzipcode`, `sysdate`, `status`) VALUES
(1, 'Malik Asif', '', 'malik', '123456', 'malik', 'malikmasif@hotmail.com', '03322527187', '03322527187', '--', 'Malik Muhammad Asif', 'dale111.jpg', '13_IMG-0149_a.jpg', 'cardlogoh.png', '', 'This is develoepr page for testing', 'Pfane', 'Malik Asif', 'Developer', 'https://www.pfane.com', 'vcard.vcf', 'https://facebook.com', '', 'https://linkedinn.com', '', 'https://instagram.com', '19-Rabia Bungalows', 'Near DHA Phase I', 'Rawalpindi', 'Punjab', 'Pakistan', '46600', '19-Rabia Bungalows', 'Near DHA Phase I', 'Rawalpindi', 'Punjab', 'Pakistan', '46600', '2022-09-16', 1),
(2, 'Dale Scott Marion ', '', 'Marion', '123ASDqwe', 'dale', 'dale@pfane.com', '+40766903531', '+40766903531', '--', 'Pfane Electronics Refining', 'IMG-20220916-WA0017.jpg', 'IMG-20220916-WA0018.jpg', 'IMG-20220916-WA0019.jpg', 'https://youtu.be/UJKDQzs65CQ', 'Specializing in the fully circular recycling of electronic manufacturing waste byproducts', 'Pfane Electronics Refining', '', 'Founder', 'https:/www.pfane.com', 'vcard.vcf', 'https://www.facebook.com/PfaneInc/', '', 'https://www.linkedin.com/in/dalescottmarion/', '', '', 'Home', '', 'Iaz', 'Salaj', 'Romania', '457272', 'Pfane Romania Office', '1 Georghe Lazar', 'Simleu Silvanie', 'Salaj', 'Romania', '453800', '2022-09-16', 1),
(3, 'Nauman Kureshy', '', 'NaumanK', '123qweasd', 'nauman', 'nkureshy@pfane.com', '+1 (416) 788-0487', '+1 (416) 788-0487', '--', 'Nauman Kureshy', '1551648942697.jpg', '3e8ee918513fa00903693c1b32074e7f88ecd37f0c02db12dffe9acafa5cae79023e25041fd7df4d268d02c021d499d04702415af8c2a19d954a8b_1280.jpg', 'PfaneElectronicsRefining.png', 'https://youtu.be/hHQfZa1oxrQ', 'Vice President', 'Pfane ', 'Pfane Gouverneur LLC', 'Vice President', 'https://www.pfane.com', 'vcard.vcf', 'https://www.facebook.com/PfaneInc', '', 'https://www.linkedin.com/company/51705005/admin/', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2022-10-20', 1),
(4, 'WIlliam Banham', '', 'WilliamB', '123qweasd', 'bill', 'billbanham@pfane.com', '+1 (647) 248-6303', '+1 (647) 248-6303', '--', 'William Banham', 'BILL.jpeg', '18a73f7968e228816bcf93030e7fab428f704aa1cdc42e0de9e4a0160f11e001093d92fd12964e1b261fafafb8e91453cc472c87898360b53f5a78_1280.jpg', 'PfaneElectronicsRefining.png', 'https://youtu.be/hHQfZa1oxrQ', 'President / CEO', 'Pfane ', 'Pfane Gouverneur LLC', 'President CEO', 'https://www.pfane.com', 'vcard.vcf', 'https://www.facebook.com/PfaneInc', '', 'https://www.linkedin.com/company/pfane-environmental-association/?viewAsMember=true', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2022-10-20', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

