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

START TRANSACTION;



--
-- 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;

