-- Adminer 4.8.0 MySQL 8.0.23-0ubuntu0.20.04.1 dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';


CREATE TABLE `members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `firstname` varchar(512) NOT NULL,
  `lastname` varchar(512) NOT NULL,
  `englishname` varchar(1024) NOT NULL,
  `adjcetive` text NOT NULL,
  `fathername` varchar(512) NOT NULL,
  `grandfathername` varchar(512) NOT NULL,
  `mothername` varchar(512) NOT NULL,
  `birthdate` varchar(120) NOT NULL,
  `birthplace` varchar(512) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `socialcondition` varchar(10) NOT NULL,
  `nationality` varchar(1024) NOT NULL,
  `nationality2` varchar(1024) NOT NULL,
  `armyservice` text NOT NULL,
  `id_number` varchar(512) NOT NULL,
  `id_number_2` varchar(512) NOT NULL,
  `social_network` text NOT NULL,
  `non_syrian_num` text NOT NULL,
  `address_city` varchar(1024) NOT NULL,
  `address_country` varchar(1024) NOT NULL,
  `address` text NOT NULL,
  `mobile` varchar(512) NOT NULL,
  `phonenumber` varchar(512) NOT NULL,
  `email` varchar(1024) NOT NULL,
  `linkedIn` varchar(1024) NOT NULL,
  `facebook` varchar(1024) NOT NULL,
  `whatsapp` varchar(1024) NOT NULL,
  `img` text NOT NULL,
  `attach` text NOT NULL,
  `attach2` text NOT NULL,
  `hash` text NOT NULL,
  `approved` varchar(10) NOT NULL,
  `register_date` varchar(120) NOT NULL,
  `membertype` text NOT NULL,
  `membertype_2` text NOT NULL,
  `serialnum` text NOT NULL,
  `memberstatues` text NOT NULL,
  `memberincome` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `members` (`id`, `firstname`, `lastname`, `englishname`, `adjcetive`, `fathername`, `grandfathername`, `mothername`, `birthdate`, `birthplace`, `sex`, `socialcondition`, `nationality`, `nationality2`, `armyservice`, `id_number`, `id_number_2`, `social_network`, `non_syrian_num`, `address_city`, `address_country`, `address`, `mobile`, `phonenumber`, `email`, `linkedIn`, `facebook`, `whatsapp`, `img`, `attach`, `attach2`, `hash`, `approved`, `register_date`, `membertype`, `membertype_2`, `serialnum`, `memberstatues`, `memberincome`) VALUES
(1,	'جورج',	'ماردللي',	'George mardelly',	'مهندس',	'الياس',	'',	'',	'2021-04-07',	'',	'm',	's',	'سوري - Syrian',	'none',	'معفى من خدمة العلم-Exempt from military service',	'',	'',	'',	'',	'حلب-Aleppo',	'سوريا - Syria, Syrian Arab Republic',	'',	'',	'',	'eliemardelly96@gmail.com',	'',	'',	'',	'7Cik8cLXZwPOg5jl.png',	'7Cik8cLXZwPOg5jl.csv',	'7Cik8cLXZwPOg5jl.txt',	'7Cik8cLXZwPOg5jl',	'1',	'2021-04-21 10:51',	'a',	'a',	'547',	'a',	'-');

-- 2021-04-21 10:59:33
