-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 04, 2025 at 05:30 AM -- Server version: 10.11.14-MariaDB -- PHP Version: 8.3.23 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: `dalemari_pzaz` -- -- -------------------------------------------------------- -- -- 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', '', 'malik', '123456', 'masif', 'malikmasif@hotmail.com', '0332-2527187', '0332-2527187', '--', 'Malik', '', 'vlcc.JPG', 'vlcc-BrandLogo.jpg', 'www.youtube.com', 'This is test new message', 'Smart Webbers', 'Programmer', 'Web Developer', 'http://www.smartwebbers.com', '', '', '', '', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-04-08', 1), (2, 'Malik', '', 'malik', '123456', 'asc', 'malikmasif@hotmail.com', '0332-2527187', '0332-2527187', '--', 'Asif', '', 'Jaguar-BrandLogo.jpg', 'vlcc.JPG', 'www.youtube.com', 'This is new test by developer for digital card', 'Pfane', 'Programmer', 'Web Developer', 'http://www.smartwebbers.com', '', '', '', '', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-04-10', 1), (3, 'Malik', '', 'malikmasif', '123456', 'afia', 'malikmasif@hotmail.com', '0332-2527187', '0332-2527187', '--', 'Afia', '', 'M.Micallef-BrandLogo.jpg', 'Nero-BrandLogo.jpg', 'www.youtube.com', 'This is new test by developer for digital card', 'Smart Webbers', 'Programmer', 'Web Developer', 'http://www.smartwebbers.com', '', '', '', '', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-04-10', 1), (4, 'Muhammad', '', 'muhammad', '123456', 'muhammad', 'malikmasif@hotmail.com', '0332-2527187', '0332-2527187', '--', 'Muhammad', '', 'vlcc.JPG', 'vlcc-BrandLogo.jpg', 'https://www.youtube.com/embed/WsptdUFthWI', 'This is new test by developer for digital card', 'Smart Webbers', 'Programmer', 'Web Developer', 'http://www.smartwebbers.com', '1618084216.vcf', '', '', '', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-04-10', 1), (5, '', '', 'bmwservice', '123456', 'bwservice', 'dale@pfane.com', '0766903531', '0766903531', '--', 'Dale Marion', 'dale111.jpg', '13_IMG-0149_a.jpg', 'bmw-logo-2020-grey.png', 'https://youtu.be/uTiiWwvPiDo', 'This should be my short description of my page', 'My Car Service', 'President', 'CEO', 'http://www.pzaz.me', '1618250610.vcf', 'https://www.facebook.com', 'https://www.twitter.com', 'https://www.youtube.com', '', '', 'Home Address', '43 Strada Principal', 'Iaz', 'Salaj', 'Romania', NULL, 'Work Address', '34 Strada 1 December', 'Simleu Silvaniei', 'Salaj', 'Romania', NULL, '2021-04-12', 1), (6, '', '', '', '', 'muhammads', '', '', '', '--', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', NULL, '2021-04-13', 1), (7, 'Dale Scott Marion', '', 'DaleMarion', '123qweasdW#ER$F%', 'pfane-dale', 'dale@pfane.com', '+40766903531', '+0766903531', '--', 'Dale Scott Marion', '11dale.jpg', '111111.jpg', 'pfanelogo.png', 'https://youtu.be/dHALb90frr0', 'Pfane Environmental Association is the world leader in Environmental Technologies for the e-waste industry', 'Pfane Environmental Association', 'President', 'CEO', '', 'vcard.vcf', 'https://www.facebook.com/pfaneorg', 'https://www.youtube.com/channel/UCm7Qw3Of1ctNjGzsTFtVSeg', 'https://www.linkedin.com/company/pfane-environmental-association', '', '', 'Home Office', '43 Strada Principal', 'Iaz', 'Salaj', 'Romania', '', 'Main Office', '34 Strada 1 Decembrie', 'Simleu Silvaniei', 'Salaj', 'Romania', '', '2021-04-20', 1), (8, 'Brett Faber', '', 'brettfaber', '1234567890', 'iqfinance-brett', 'brett@iqlend.ca', '6137943302', '', '--', 'Brett Faber', 'JUSTP.png', '20210504_143008_1.gif', 'pzaz-logo2.png', 'https://www.youtube.com/watch?v=MIuH5_dG_RY', 'Building a better financial future for you!', 'IQFinance', '', '', '', 'vcard.vcf', 'facebook.com', 'youtube.com', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', NULL, '2021-04-28', 1), (9, 'Amanda Miller', '', 'AMiller', '123456', 'orca-amanda', 'amanda.miller@theorcaclub.com', '+15168546969', '+18766598854', '--', 'Amanda Miller', '1this.png', '123orcame.png', 'Orca-Logo.png', 'https://youtu.be/U0Sh0lGWhFA', 'Welcome to The Pink Orca. Nevada\'s hottest Gentlemens Club. We aim to please.', 'The Pink Orca', 'Owner', 'Cortesian', 'https://thepinkorca.com', '1619847502.vcf', 'https://www.facebook.com/pinkorca', 'https://www.youtube.com/pinkorca', '', 'https://www.twitter.com/pinkorca', 'https://www.instagram.com/pinkorca', 'Home', 'PRIVATE', 'PRIVATE', 'PRIVATE', 'United States', NULL, 'Club Address', '8269 Pussy Avanue', 'Las Vegas', 'NV', 'USA', NULL, '2021-04-30', 1), (10, 'Malik Muhammad Asif', '', 'mmasif', '12345678', 'mmasif', 'malikmasif@hotmail.com', '0332-2527187', '0332-2527187', '--', 'Smartwebbers', '667552182402.jpeg', '667553502490.JPG', 'vlcc.JPG', 'https://youtu.be/dHALb90frr0', 'This is new test by malik for issue in \'save', 'Smart Webbers', 'Programmer', 'Web Developer', 'http://www.smartwebbers.com', '1619841876.vcf', 'https://www.facebook.com', 'https://www.youtube.com', 'https://www.linkedinn.com', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-05-01', 1), (11, 'Malik Asif Awan', '', 'malikm', '123456', 'malik', 'malikmasif@hotmail.com', '033225555557', '03322527187', '--', 'Malik Asif', '667553502490.JPG', '667553447487.jpg', 'Nero-BrandLogo.jpg', 'https://youtu.be/Q0uiA1oInYI', 'this is my final test\' about the save issue in it this is new @test \'dont use this', 'Smartwebbers', 'Programmer', 'Web Developer', '', '1619847082.vcf', 'https://ww.facebook.com/', 'https://www.youtube.com/', 'https://ww.linkedinn.com/', '', '', '315', 'Lane 3 ', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '3148', 'Lane 7', 'Islamabad', 'Islamabad', 'Pakistan', NULL, '2021-05-01', 1), (12, 'Malik Muhammad Asif', '', 'asifawan', '123456', 'asif', 'malikmasif@hotmail.com', '0322-2342182', '0332-2527189', '--', 'Smartwebbers', '13_IMG-0149_a.jpg', 'dale111.jpg', 'cardlogoh.png', 'https://youtu.be/dHALb90frr0', 'This is new test by developer for digital card', 'Pfane', 'Programmer', 'Web Developer', '', 'vcard.vcf', 'https://www.facebook.com', 'https://www.youtube.com', 'https://www.linkedinn.com', '', '', '315', 'Lane 3', 'Rawalpindi', 'Punjab', 'Pakistan', NULL, '318', 'Lane 7', 'Islamabad', 'Punjab', 'Pakistan', NULL, '2021-05-04', 1), (13, 'Sanda Marion', '', 'SandaMarion', '123qweasdW#ER$F%', 'pfanesanda', 'sanda@pfane.com', '+40766505922', '+40766505922', '--', 'Sanda Marion', '165151094_10225490141429822_4126946503201792945_n.jpg', '13_IMG-0149_a.jpg', 'cardlogoh.png', 'https://youtu.be/dHALb90frr0?list=TLGGDFN3gx0VEmYxMDA1MjAyMQ', 'Vice President', 'Pfane Scientific SRL', 'Vice President', 'Executive', 'https://www.pfane.org', 'vcard.vcf', '', '', '', '', '', 'Home Office', '43 Strada Principal', 'Iaz', 'Salaj', 'Romania', '457272', 'Work', '34 Str 1 Decembrie ', 'Simleu Silvaniei', 'Salaj', 'Romania', '453320', '2021-05-10', 1), (14, 'Vlad Abrudan', '', 'Vladbmw', '123456', 'bmwvlad', 'vlad.abrudan@automobilebavaria.ro', '+40730827475', '0730827475', '--', '', '', '', '', '', '', 'Automobile Bavaria ', 'Sales Representative', 'Sales', 'bmw-cluj.ro', 'vcard.vcf', '', '', '', '', '', '', '', '', '', '', '', 'Automobile Bavaria', 'Avram Iancu 396-398', 'Floresti', 'Cluj', 'Romania', '407353', '2021-05-12', 1), (15, 'Eric Schultze', '', 'ericschultze', '123123123', 'ericschultze', 'eric@pfane.com', '+1 (917) 992-5370', '+1 (917) 992-5370', '--', 'Pfane Electronics Refining', '5baf5c26-f9df-4a25-8e73-cb582d8cb756.jpg', '3e8ee918513fa00903693c1b32074e7f88ecd37f0c02db12dffe9acafa5cae79023e25041fd7df4d268d02c021d499d04702415af8c2a19d954a8b_1280.jpg', 'PfaneLogoFinal.png', 'https://youtu.be/UJKDQzs65CQ', 'Pfane is a fully circular electronics recycling and refining facility. R4 certified and carbon negative.', 'Pfane Electronics Refining', 'Chief Operations Officer', 'COO', 'https://www.pfane.com', 'vcard.vcf', '', '', '', '', '', '', '', '', '', '', '', 'Pfane Gouverneur', '606 County Route 11', 'Gouverneur', 'New York', 'United States', '13642', '2022-03-11', 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=16; 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 */;