-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 25, 2019 at 03:56 PM
-- Server version: 5.7.14
-- PHP Version: 5.6.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `shop`
--

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

--
-- Table structure for table `factor`
--

CREATE TABLE `factor` (
  `cod_meli` varchar(10) COLLATE utf8_persian_ci NOT NULL,
  `name` text COLLATE utf8_persian_ci NOT NULL,
  `tel` text COLLATE utf8_persian_ci,
  `mbl_cod` text COLLATE utf8_persian_ci,
  `mbl_name` text COLLATE utf8_persian_ci NOT NULL,
  `mbl_select_cantre` text COLLATE utf8_persian_ci NOT NULL,
  `mbl_select_nafar` text COLLATE utf8_persian_ci,
  `mbl_action_nafar` varchar(100) COLLATE utf8_persian_ci DEFAULT NULL,
  `mbl_select_rang` varchar(200) COLLATE utf8_persian_ci NOT NULL,
  `jens` text COLLATE utf8_persian_ci NOT NULL,
  `data` varchar(300) COLLATE utf8_persian_ci NOT NULL,
  `mbl_price` varchar(100) COLLATE utf8_persian_ci NOT NULL,
  `mbl_select_years` text COLLATE utf8_persian_ci,
  `email` varchar(100) COLLATE utf8_persian_ci DEFAULT NULL,
  `addres` varchar(200) COLLATE utf8_persian_ci DEFAULT NULL,
  `state` text COLLATE utf8_persian_ci NOT NULL,
  `action_state` text COLLATE utf8_persian_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

--
-- Dumping data for table `factor`
--

INSERT INTO `factor` (`cod_meli`, `name`, `tel`, `mbl_cod`, `mbl_name`, `mbl_select_cantre`, `mbl_select_nafar`, `mbl_action_nafar`, `mbl_select_rang`, `jens`, `data`, `mbl_price`, `mbl_select_years`, `email`, `addres`, `state`, `action_state`) VALUES
('1', '1', '1', '6', 'fgfgd', 'e', '1', '1', '1', 'dddddd', 'July 23, 2019,12:50 pm', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'ffds@dfs.com', '4eeeeeeeeeeeeeeeee', '0', 'Ø¯Ø± Ø­Ø§Ù„ Ø¨Ø±Ø±Ø³ÛŒ'),
('2', '2', '2', '7', 'fgfgd', 'e', '2', '2', '2', 'dddddd', 'July 23, 2019,1:12 pm', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'ffds@dfs.com', 'rrrrrrrrrrr', '0', 'Ø¯Ø± Ø­Ø§Ù„ Ø¨Ø±Ø±Ø³ÛŒ'),
('3', '3', '3', 'tt', 'fgfgd', 'e', '1', '3', '12', 'dddddd', 'July 24, 2019,6:16 pm', '133333', '3', 'axzcc@dsfsf.fdgfdg', 'erwrwrwr ', '1', 'Ø¨Ø±Ø±Ø³ÛŒ Ø´Ø¯Ù‡'),
('52552', '1', '11', '7', 'fgfgd', 'e', '12', 'rw', '4', 'dddddd', 'July 23, 2019,2:39 pm', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'ffds@dfs.com', 'erre', '0', 'hiygiuy'),
('34', '8', '11', '7', 'fgfgd', 'e', '12', '12', '4', 'dddddd', 'July 24, 2019,6:17 pm', '35663', '5', 'ffds@dfs.com', '424241 ', '1', 'Ø¨Ø±Ø±Ø³ÛŒ Ø´Ø¯Ù‡'),
('12', '3', '6', '6', 'fgfgd', 'e', 'erw', 's', '3', 'dddddd', 'July 24, 2019,6:56 pm', 'ggg', '3', 'ffds@dfs.com', '43554 ', '1', 'Ø¨Ø±Ø±Ø³ÛŒ Ø´Ø¯Ù‡'),
('6', '6', '6', 'tt', 'fgfgd', 'e', '1', '1', '1', 'dddddd', 'July 24, 2019,12:08 pm', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'wdewd@emil.com', 'uhhhhhhhhhhhhhhhhh', '0', 'hiygiuy'),
('8', '8', '8', '100', 'fgfgd', 'e', '1', '3', '1', 'dddddd', 'July 24, 2019,6:55 pm', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'Ù¾Ø³ Ø§Ø² Ø¨Ø±Ø±Ø³ÛŒ Ø§Ø¹Ù„Ø§Ù… Ù…ÛŒ Ú¯Ø±Ø¯Ø¯', 'axzcc@dsfsf.fdgfdg', 'Ù35Ù53Ù5', '0', 'Ø¯Ø± Ø­Ø§Ù„ Ø¨Ø±Ø±Ø³ÛŒ');

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

--
-- Table structure for table `mbl`
--

CREATE TABLE `mbl` (
  `mbl_cod` text COLLATE utf8_persian_ci NOT NULL,
  `mbl_select_cantre` text COLLATE utf8_persian_ci NOT NULL,
  `jens` text COLLATE utf8_persian_ci NOT NULL,
  `mbl_name` text COLLATE utf8_persian_ci NOT NULL,
  `mbl_price` varchar(200) COLLATE utf8_persian_ci DEFAULT NULL,
  `mbl_img` varchar(200) COLLATE utf8_persian_ci NOT NULL,
  `mbl_textarea` varchar(100) COLLATE utf8_persian_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

--
-- Dumping data for table `mbl`
--

INSERT INTO `mbl` (`mbl_cod`, `mbl_select_cantre`, `jens`, `mbl_name`, `mbl_price`, `mbl_img`, `mbl_textarea`) VALUES
('100', 'e', 'Ù…Ø®Ù…Ù„ÛŒ', 'fgfgd', '6564', 'tulips (7).jpg', 'yttttttttttttttteeeeeeeeee'),
('1', 'iran', 'ÙØ§', 'adf', '12324Ã·43Ã·1', 'tulips (8).jpg', 'ØµØ«'),
('6', 'e', 'Ù…Ø®Ù…Ù„ÛŒ', 'fgfgd', 'ewrwrw', 'tulips (5).jpg', 'wwwwwwwwwwww');

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

--
-- Table structure for table `nazar`
--

CREATE TABLE `nazar` (
  `name` text COLLATE utf8_persian_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_persian_ci NOT NULL,
  `text` varchar(300) COLLATE utf8_persian_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

--
-- Dumping data for table `nazar`
--

INSERT INTO `nazar` (`name`, `email`, `text`) VALUES
('fgdg', 'fdgg', 'fddd'),
('fert', 'ttt', 'tttttt'),
('3qrw', 'rerw', 'rwrw'),
('amir', 'ffds@dfs.com', 'dsfgagreag');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `cod_meli` text COLLATE utf8_persian_ci,
  `name` text COLLATE utf8_persian_ci NOT NULL,
  `txtname` text COLLATE utf8_persian_ci NOT NULL,
  `password` text COLLATE utf8_persian_ci NOT NULL,
  `txtpassword` text COLLATE utf8_persian_ci NOT NULL,
  `tel` text COLLATE utf8_persian_ci,
  `emil` text COLLATE utf8_persian_ci NOT NULL,
  `type` text COLLATE utf8_persian_ci NOT NULL,
  `user_type` text COLLATE utf8_persian_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`cod_meli`, `name`, `txtname`, `password`, `txtpassword`, `tel`, `emil`, `type`, `user_type`) VALUES
('a', 'a', 'a', 'a', 'a', 'a', 'a', '1', 'admin'),
('2', '2', '2', '2', '2', '2', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('6', '6', '6', '6', '6', '6', 'wdewd@emil.com', '0', 'public'),
('1', '1', '1', '1', '1', '1', '1', '1', 'admin'),
('8', '8', '8', '8', '8', '8', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('1', '1', '1', '1', '1', '1', 'dertrewt@dfdsf.com', '0', 'public'),
('12', '12', '12', '12', '12', '12', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('12', '1', 'gfgg', '123', '123', '2', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('52552', '1', '11', '45', '45', '11', 'dertrewt@dfdsf.com', '0', 'public'),
('12', '8', '2', '123', '123', '1', 'wdewd@emil.com', '0', 'public'),
('3', '3', '3', '3', '3', '3', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('3', '3', '3', '3', '3', '3', 'wdewd@emil.com', '0', 'public'),
('52552', '8', '2', '123', '123', '2', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('6', '6', '6', '6', '6', '6', 'axzcc@dsfsf.fdgfdg', '0', 'public'),
('7', '7', '7', '7', '7', '7', 'axzcc@dsfsf.fdgfdg', '0', 'public');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `factor`
--
ALTER TABLE `factor`
  ADD PRIMARY KEY (`cod_meli`);

--
-- Indexes for table `mbl`
--
ALTER TABLE `mbl`
  ADD PRIMARY KEY (`mbl_img`);

/*!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 */;
