-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 16, 2025 at 12:28 AM
-- Server version: 10.11.11-MariaDB-cll-lve
-- PHP Version: 8.3.15

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: `azsitesh_bisb_azsiteshop`
--

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

--
-- Table structure for table `abone`
--

CREATE TABLE `abone` (
  `id` int(11) NOT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `addim`
--

CREATE TABLE `addim` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `sira` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `linki` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `ad_soyad` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eposta` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sifre` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ilk_giris` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `son_giris` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `logo` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kapak_foto` varchar(555) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `admin` int(11) DEFAULT NULL,
  `normalsifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ip` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ref` int(11) DEFAULT NULL,
  `xidmet` int(11) DEFAULT NULL,
  `rey` int(11) DEFAULT NULL,
  `sehife` int(11) DEFAULT NULL,
  `kom` int(11) DEFAULT NULL,
  `slider` int(11) DEFAULT NULL,
  `menyu` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `blog` int(11) DEFAULT NULL,
  `sayt` int(11) DEFAULT NULL,
  `mehsul` int(11) DEFAULT NULL,
  `elaqe` int(11) DEFAULT NULL,
  `layihe` int(11) DEFAULT NULL,
  `sertifikat` int(11) DEFAULT NULL,
  `paket` int(11) DEFAULT NULL,
  `teklif` int(11) DEFAULT NULL,
  `sifaris` int(11) DEFAULT NULL,
  `foto` int(11) DEFAULT NULL,
  `video` int(11) DEFAULT NULL,
  `sualcavab` int(11) DEFAULT NULL,
  `modul` int(11) DEFAULT NULL,
  `statistika` int(11) DEFAULT NULL,
  `addim` int(11) DEFAULT NULL,
  `haqqimizda` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `ad_soyad`, `eposta`, `sifre`, `ilk_giris`, `son_giris`, `logo`, `kapak_foto`, `admin`, `normalsifre`, `ip`, `ref`, `xidmet`, `rey`, `sehife`, `kom`, `slider`, `menyu`, `lan`, `blog`, `sayt`, `mehsul`, `elaqe`, `layihe`, `sertifikat`, `paket`, `teklif`, `sifaris`, `foto`, `video`, `sualcavab`, `modul`, `statistika`, `addim`, `haqqimizda`) VALUES
(9, 'Admin', 'admin@webmap.az', '$2y$10$.28Qsgkyynh4fDIXDrBOruGWjzLcldS1oi8hlp/uk2EtKAXaMnm0W', '15.09.2020', '15.08.2025', '100.png', '991-.jpg', 0, NULL, '37.114.161.42', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(10, 'Moderator', 'mod@webmap.az', '$2y$10$oYDitjas9eHq1dpLKo5qneB5Gk0C4vxoBvlrU5Tx64b.ND4bPKLVW', '18.05.2025', '28.06.2025', NULL, NULL, 1, NULL, '212.47.145.231', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, NULL, 1, 1, 1, 1, 1, 1, 1, NULL, NULL);

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

--
-- Table structure for table `banka`
--

CREATE TABLE `banka` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banka`
--

INSERT INTO `banka` (`id`, `adi`, `sira`, `aciklama`, `linki`, `veziyyeti`, `resim`, `lan`) VALUES
(21, 'enpara', '1', '<ul>\r\n	<li><strong>Ad Soyad :</strong>&nbsp;UMUT TAMİRCİ</li>\r\n	<li><strong>Para Birimi :</strong>&nbsp;TL</li>\r\n	<li><strong>Hesap No :</strong>&nbsp;0000000000000</li>\r\n	<li><strong>IBAN :&nbsp;</strong>TR00000000000000000000</li>\r\n</ul>\r\n', '#', '0', '968-.png', 21),
(22, 'Papara', '2', '<ul>\r\n	<li><strong>Ad Soyad :</strong>&nbsp;UMUT TAMİRCİ</li>\r\n	<li><strong>Para Birimi :</strong>&nbsp;TL</li>\r\n	<li><strong>Hesap No :</strong>&nbsp;44444444444</li>\r\n	<li><strong>IBAN : TR</strong>44444444444444444444444</li>\r\n</ul>\r\n', '#', '0', '140-.png', 23);

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

--
-- Table structure for table `beadcrumb`
--

CREATE TABLE `beadcrumb` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footersekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `reybolmesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidmetbolmesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sualcavabbolmesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `statistikabolmesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `reyindexsekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `beadcrumb`
--

INSERT INTO `beadcrumb` (`id`, `adi`, `resim`, `footersekli`, `reybolmesekli`, `xidmetbolmesekli`, `sualcavabbolmesekli`, `statistikabolmesekli`, `reyindexsekli`, `veziyyeti`) VALUES
(1, NULL, '211-.webp', '469-_2.webp', '736-_3.webp', '909-_4.webp', '825-_5.webp', '901-_6.webp', '852-haqqimda.webp', NULL);

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

--
-- Table structure for table `blog_rey`
--

CREATE TABLE `blog_rey` (
  `id` int(11) NOT NULL,
  `yorum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `uye` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urun_id` int(11) DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blog_rey`
--

INSERT INTO `blog_rey` (`id`, `yorum`, `uye`, `tarih`, `urun_id`, `veziyyeti`, `email`) VALUES
(12, 'harika bir yazı olmuş teşekkür ederim.', 'umut tamirci', '07.04.2024', 77, '0', 'umuttamirci@gmail.com');

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

--
-- Table structure for table `bolge_kateqoriya`
--

CREATE TABLE `bolge_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `bolge_rey`
--

CREATE TABLE `bolge_rey` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `mesaj` text DEFAULT NULL,
  `bid` int(11) DEFAULT NULL,
  `veziyyeti` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

--
-- Dumping data for table `bolge_rey`
--

INSERT INTO `bolge_rey` (`id`, `adi`, `email`, `mesaj`, `bid`, `veziyyeti`) VALUES
(3, 'wqewqeqewq', 'demo@demo.com', 'wqewqewqeqwewqeq', 17, 0),
(4, 'test', 'demo@demo.com', 'Apple today named eight app and game developers receiving an Apple Design Award, each one selected for being thoughtful and creative. Apple Design Award winners bring distinctive new ideas to life and demonstrate deep mastery of Apple technology. The apps spring up from developers large and small, in every part of the world and provide users with new ways of working, creating, and playing.\r\n\r\n', 17, 0),
(5, 'test', 'demo@demo.com', 'Apple today named eight app and game developers receiving an Apple Design Award, each one selected for being thoughtful and creative. Apple Design Award winners bring distinctive new ideas to life and demonstrate deep mastery of Apple technology. The apps spring up from developers large and small, in every part of the world and provide users with new ways of working, creating, and playing.\r\n\r\n', 17, 1),
(6, 'test', 'demo@demo.com', 'Apple today named eight app and game developers receiving an Apple Design Award, each one selected for being thoughtful and creative. Apple Design Award winners bring distinctive new ideas to life and demonstrate deep mastery of Apple technology. The apps spring up from developers large and small, in every part of the world and provide users with new ways of working, creating, and playing.\r\n\r\n', 17, 1);

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

--
-- Table structure for table `cvs`
--

CREATE TABLE `cvs` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `kategori` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cvs`
--

INSERT INTO `cvs` (`id`, `adi`, `sira`, `aciklama`, `veziyyeti`, `lan`, `kategori`) VALUES
(25, 'Sual 1', 1, '<p>Vivamus at dui sed libero elementum posuere et porttitor leo. Suspendisse vitae tellus a lacus efficitur ornare et non erat. Aenean rutrum in risus nec eleifend. Aliquam dictum dui ante, et tincidunt turpis lobortis vel. In euismod eros vel porta tempor. Pellentesque id tincidunt urna.</p>\r\n', '0', 24, 0),
(26, 'Sual 2', 2, '<p>Vivamus at dui sed libero elementum posuere et porttitor leo. Suspendisse vitae tellus a lacus efficitur ornare et non erat. Aenean rutrum in risus nec eleifend. Aliquam dictum dui ante, et tincidunt turpis lobortis vel. In euismod eros vel porta tempor. Pellentesque id tincidunt urna.</p>\r\n', '0', 24, 0);

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

--
-- Table structure for table `destek`
--

CREATE TABLE `destek` (
  `yid` int(11) DEFAULT NULL,
  `uye` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `konu` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `cevap` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `id` int(11) NOT NULL,
  `ctarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `destek`
--

INSERT INTO `destek` (`yid`, `uye`, `konu`, `mesaj`, `tarih`, `cevap`, `id`, `ctarih`) VALUES
(NULL, '64', 'script aldım indirme linki bozuk', 'merhabalar pastane scriptini aldım ve indirme linki bozuk yardımcı olurmusunuz', '21.09.2022', ' link düzeltildi', 5, '21.09.2022');

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

--
-- Table structure for table `elaqe`
--

CREATE TABLE `elaqe` (
  `id` int(11) NOT NULL,
  `adsoyad` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `konu` varchar(255) NOT NULL,
  `telefon` varchar(50) NOT NULL,
  `mesaj` varchar(300) NOT NULL,
  `sahebir` varchar(255) NOT NULL,
  `saheiki` varchar(255) NOT NULL,
  `saheuc` varchar(255) NOT NULL,
  `sahedort` varchar(255) NOT NULL,
  `tarih` datetime NOT NULL,
  `veziyyeti` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `elaqegelen`
--

CREATE TABLE `elaqegelen` (
  `id` int(11) NOT NULL,
  `adsoyad` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `konu` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hizmet` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sahebir` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `saheiki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `saheuc` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sahedort` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ip` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `elaqegelen`
--

INSERT INTO `elaqegelen` (`id`, `adsoyad`, `konu`, `telefon`, `hizmet`, `email`, `mesaj`, `sahebir`, `saheiki`, `saheuc`, `sahedort`, `tarih`, `ip`) VALUES
(106, 'aSDSDDF', NULL, NULL, NULL, 'info@sayt.com', 'ssssssss', NULL, NULL, NULL, NULL, '2025-07-31 16:16:24', '185.129.0.98'),
(107, 'rerür', NULL, NULL, NULL, 'pureshopoffice@gmail.com', 'ssssssss', NULL, NULL, NULL, NULL, '2025-07-31 16:18:12', '185.129.0.98'),
(108, 'Amid Nurmammadli', NULL, NULL, NULL, 'user@gmail.com', 'eeeeeeeee', NULL, NULL, NULL, NULL, '2025-08-04 13:31:51', '185.129.0.98'),
(109, 'Amid Nurmammadli', NULL, NULL, NULL, 'destek@webyazilimajansi.com', 'edf', NULL, NULL, NULL, NULL, '2025-08-07 15:03:00', '185.129.0.98');

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

--
-- Table structure for table `elaqemelumatlari`
--

CREATE TABLE `elaqemelumatlari` (
  `id` int(11) NOT NULL,
  `telefon1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adres1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adres2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `google_maps` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `whatsapp` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `wp_text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `wp_renk` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `elaqemelumatlari`
--

INSERT INTO `elaqemelumatlari` (`id`, `telefon1`, `telefon2`, `email1`, `email2`, `adres1`, `adres2`, `google_maps`, `whatsapp`, `wp_text`, `wp_renk`) VALUES
(1, '0552571256', '0503900070', 'info@megasgroup.az', '', '8 Noyabr 3- cü mərtəbə', '', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m17!1m12!1m3!1d3039.346819389311!2d49.876735676009154!3d40.379005371445714!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m2!1m1!2zNDDCsDIyJzQ0LjQiTiA0OcKwNTInNDUuNSJF!5e0!3m2!1str!2saz!4v1753266603921!5m2!1str!2saz\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', NULL, NULL, NULL);

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

--
-- Table structure for table `filallar`
--

CREATE TABLE `filallar` (
  `id` int(11) NOT NULL,
  `telefon1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adres` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `maps` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `veziyyeti` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `filallar`
--

INSERT INTO `filallar` (`id`, `telefon1`, `telefon2`, `email1`, `email2`, `adres`, `maps`, `adi`, `lan`, `veziyyeti`) VALUES
(1, '90 212 663 0 444', '', 'istanbul@compasslog.com', '', 'Yeşilköy Mh. Atatürk Cd. EGS Business Park B2 Blok Kat:2 No:139-140 Bakırköy İstanbul', 'https://goo.gl/maps/imu3Bn99ERzfpo7Y6', 'İstanbul', 21, 0),
(2, '90 232 404 7 555', '', 'izmir@compasslog.com', '', 'Akdeniz Mh. Şehit Fethi Bey Cd. 99 Basamak İş Merkezi No:43/109 Konak İzmir', 'https://goo.gl/maps/eYn9bFSphS3S6P416', 'İzmir', 21, 0),
(3, '90 212 663 0 444', '', 'sakarya@compasslog.com', '', 'Arabacıalanı Mh. Mehmet Akif Ersoy Cd. Work Inn İş Merkezi No:33/210 Serdivan Sakarya', 'https://goo.gl/maps/xj8KyHrUWZNDTdPf6', 'Sakarya', 21, 0);

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

--
-- Table structure for table `galeri`
--

CREATE TABLE `galeri` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidmetsekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xebersekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layihesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mehsusekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `kategori` int(11) DEFAULT NULL,
  `xidmet_kateqoriya` int(11) DEFAULT NULL,
  `xeber_kateqoriya` int(11) DEFAULT NULL,
  `layihe_kateqoriya` int(11) DEFAULT NULL,
  `mehsul_kateqoriya` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `haqqimizda`
--

CREATE TABLE `haqqimizda` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `video` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `haqqimizda`
--

INSERT INTO `haqqimizda` (`id`, `adi`, `resim`, `resim2`, `veziyyeti`, `video`, `aciklama`, `footer`) VALUES
(1, NULL, '857-.webp', NULL, NULL, 'https://www.youtube.com/watch?v=PSCy0CYChyA', NULL, NULL);

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

--
-- Table structure for table `icazeler`
--

CREATE TABLE `icazeler` (
  `id` int(11) NOT NULL,
  `mehsul_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kateqoriya_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `statistika_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sertifikat_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `referans_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidmet_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xeber_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sehife_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `slayder_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sualcavab_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `addim_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `haqqimizda_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `qalareya_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `video_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `komanda_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `rey_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `iletisim_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `en` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `bresim_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `siparis_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `musteri_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `destek_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onecikan_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `banner_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `paytr_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `banka_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layihe_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layihe_kateqoriya_veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `katalog_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sube_durum` int(11) DEFAULT NULL,
  `paket_veziyyeti` int(11) DEFAULT NULL,
  `modal_durum` int(11) DEFAULT NULL,
  `abone_durum` int(11) DEFAULT NULL,
  `paymax_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `shopier_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `netgsm_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `iyzico_durum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `icazeler`
--

INSERT INTO `icazeler` (`id`, `mehsul_veziyyeti`, `kateqoriya_veziyyeti`, `statistika_veziyyeti`, `sertifikat_veziyyeti`, `referans_veziyyeti`, `xidmet_veziyyeti`, `xeber_veziyyeti`, `sehife_veziyyeti`, `slayder_veziyyeti`, `sualcavab_veziyyeti`, `addim_veziyyeti`, `haqqimizda_veziyyeti`, `qalareya_veziyyeti`, `video_durum`, `komanda_veziyyeti`, `rey_veziyyeti`, `iletisim_durum`, `en`, `bresim_durum`, `siparis_durum`, `musteri_durum`, `destek_durum`, `onecikan_durum`, `banner_durum`, `paytr_durum`, `banka_durum`, `layihe_veziyyeti`, `layihe_kateqoriya_veziyyeti`, `katalog_durum`, `sube_durum`, `paket_veziyyeti`, `modal_durum`, `abone_durum`, `paymax_durum`, `shopier_durum`, `netgsm_durum`, `iyzico_durum`) VALUES
(1, '0', NULL, '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `istatik`
--

CREATE TABLE `istatik` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `istatik`
--

INSERT INTO `istatik` (`id`, `adi`, `sira`, `aciklama`, `linki`, `veziyyeti`, `resim`, `lan`) VALUES
(1, 'Information Technology', '23', '', '', '0', 'no-img', 24),
(2, 'Technology Consultant', '63', '', '', '0', 'no-img', 24),
(3, 'Technology', '96', '', '', '0', 'no-img', 24);

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

--
-- Table structure for table `katalog`
--

CREATE TABLE `katalog` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `pdf` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `katalog`
--

INSERT INTO `katalog` (`id`, `adi`, `sira`, `aciklama`, `linki`, `veziyyeti`, `resim`, `pdf`, `lan`) VALUES
(21, 'Katalog 1', '1', '', '#', '0', '419-.jpg', '90-.pdf', NULL),
(22, 'Katalog 2', '2', '', '#', '0', '5-.jpg', '450-.pdf', NULL);

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

--
-- Table structure for table `komandamiz`
--

CREATE TABLE `komandamiz` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `komandamiz`
--

INSERT INTO `komandamiz` (`id`, `adi`, `sira`, `resim`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `lan`) VALUES
(1, 'Amid', 1, '317-amid.jpg', NULL, 'IT Manager', '0', '', 'amid', 'komandamiz', '29.07.2025', NULL, 24),
(2, 'Levent', 2, '505-levent.jpg', NULL, 'CEO', '0', '', 'levent', 'komandamiz', '29.07.2025', NULL, 24),
(3, 'Orhan', 2, '443-orhan.jpg', NULL, 'Enginer', '0', '', 'orhan', 'komandamiz', '29.07.2025', NULL, 24);

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

--
-- Table structure for table `lan`
--

CREATE TABLE `lan` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidmetbuton` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xeberbuton` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mehsulbuton` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layihebuton` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `inceleyin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etrafli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `elaqe` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `elaqeforum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hamsinioxu` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hamisinabax` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidmetler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `xidemtleraltmetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hizmet` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `komandamiz` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `komandamizaltmetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layiheler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layiheleraltmetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hamisi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sualcavab` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `istatikler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `gonder` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `blog` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `blogaltmetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `reyler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `reyleraltmetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `banner` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `bizimle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `medya` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urunbilgileri` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `satinal` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sepeteekle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sepetim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urunresmi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urunadi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urunadet` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urunfiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `islem` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `siparisbilgileri` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `siparisitamamla` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `bankahesaplari` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `referanslar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kataloglar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kurumsal` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `galeri` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `video` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `elaqemelumatlari` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sosialmedia` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mehsullar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `anasayfa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hizliiletisim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adsoyad` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `konu` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `alan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `anadil` int(11) DEFAULT NULL,
  `digerbloglar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiketler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `blogyorumlari` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `yorumatabilirsiniz` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `filallar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `teklifal` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kariyer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `calismak` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `departman` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `muhasebe` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `satis` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `pazarlama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `operasyon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onyazi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `haqqimizdametin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footermetin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aboneol` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ekipmanlar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyatteklif` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hizliteklif` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ozgecmis` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `abone_a` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `haqqimizdaadi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `neden` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adres` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `digerhizmetler` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `v_baslik` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `v_link` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `a_madde` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `b_madde` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `c_madde` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `d_madde` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kod` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lan`
--

INSERT INTO `lan` (`id`, `adi`, `sira`, `aciklama`, `linki`, `veziyyeti`, `xidmetbuton`, `xeberbuton`, `mehsulbuton`, `layihebuton`, `resim`, `inceleyin`, `etrafli`, `elaqe`, `elaqeforum`, `hamsinioxu`, `hamisinabax`, `xidmetler`, `xidemtleraltmetin`, `hizmet`, `komandamiz`, `komandamizaltmetin`, `layiheler`, `layiheleraltmetin`, `hamisi`, `sualcavab`, `istatikler`, `gonder`, `blog`, `blogaltmetin`, `reyler`, `reyleraltmetin`, `banner`, `bizimle`, `medya`, `urunbilgileri`, `satinal`, `sepeteekle`, `sepetim`, `urunresmi`, `urunadi`, `urunadet`, `urunfiyat`, `islem`, `siparisbilgileri`, `siparisitamamla`, `bankahesaplari`, `referanslar`, `kataloglar`, `kurumsal`, `galeri`, `video`, `elaqemelumatlari`, `sosialmedia`, `mehsullar`, `anasayfa`, `hizliiletisim`, `adsoyad`, `email`, `telefon`, `konu`, `mesaj`, `alan`, `anadil`, `digerbloglar`, `etiketler`, `blogyorumlari`, `yorumatabilirsiniz`, `filallar`, `teklifal`, `kariyer`, `calismak`, `departman`, `muhasebe`, `satis`, `pazarlama`, `operasyon`, `onyazi`, `haqqimizdametin`, `footermetin`, `aboneol`, `ekipmanlar`, `fiyatteklif`, `hizliteklif`, `ozgecmis`, `abone_a`, `haqqimizdaadi`, `neden`, `adres`, `digerhizmetler`, `v_baslik`, `v_link`, `a_madde`, `b_madde`, `c_madde`, `d_madde`, `resim1`, `resim2`, `kod`) VALUES
(24, 'AZ', '01', '$lan = [];\r\n\r\n//Umumi//\r\n\r\n$lan[\'esassehife\'] = \'Əsas səhifə\';\r\n$lan[\'bize-zeng\'] = \'Bizə zəng edin\';\r\n$lan[\'bize-bir-mesaj-yazin\'] = \'Bizə yazın\';\r\n\r\n//Header//\r\n\r\n$lan[\'header-is-saatlari\'] = \'Həftə içi\';\r\n$lan[\'header-is-saatlari-saat\'] = \'Müştəri xidmətləri\';\r\n$lan[\'header-teklifal\'] = \'TƏKLİF AL\';\r\n\r\n//Elaqe//\r\n\r\n$lan[\'elaqe-telefon\'] = \'Telefon\';\r\n$lan[\'elaqe-teklif-info\'] = \'Ətraflı məlumat üçün\';\r\n$lan[\'elaqe-email\'] = \'Gmail\';\r\n$lan[\'elaqe-teklif-forum\'] = \'Təklif üçün formu doldur\';\r\n$lan[\'elaqe-adres\'] = \'Ünvan\';\r\n$lan[\'form-ad\'] = \'Ad Soyad\';\r\n$lan[\'form-movzu\'] = \'Mövzu\';\r\n$lan[\'form-email\'] = \'Gmail\';\r\n$lan[\'form-telefon\'] = \'Telefon\';\r\n$lan[\'form-mesaj\'] = \'Mesajınız\';\r\n$lan[\'form-gonder\'] = \'Göndər\';\r\n$lan[\'index-forum-elqe\'] = \'Bizlə əlaqə\';\r\n$lan[\'index-forum-basliq\'] = \'İndi zəng et\';\r\n$lan[\'index-indi-zeng\'] = \'Bizimlə əlaqə\';\r\n$lan[\'xidmet-detay-banner\'] = \'Bizlə əlaqə\';\r\n$lan[\'xidmet-detay-basliq-1\'] = \'İndi zəng et\';\r\n$lan[\'xidmet-indi-zeng\'] = \'Bizimlə əlaqə\';\r\n$lan[\'sahebir\'] = \'Sahə 1\';\r\n$lan[\'saheiki\'] = \'Sahə 2\';\r\n$lan[\'saheuc\'] = \'Sahə 3\';\r\n$lan[\'sahedord\'] = \'Sahə 4\';\r\n\r\n//Slayder//\r\n\r\n$lan[\'slider-buton\'] = \'İNCƏLƏYİN\';\r\n$lan[\'slider-buton2\'] = \'ƏTRAFLI\';\r\n\r\n//Komondamiz//\r\n\r\n$lan[\'komandamiz-basliq\'] = \'komandamız\';\r\n$lan[\'komandamiz-alt-basliq\'] = \'Öz sahəsində peşəkar komandamız\';\r\n\r\n//Layhieler//\r\n\r\n$lan[\'layiheler-basliq\'] = \'Layihələr\';\r\n$lan[\'layiheler-altmetin\'] = \'Layihələr alt mətin\';\r\n$lan[\'layiheler-altmetin-2\'] = \'İnşaat sahəsi üzrə daha geniş layihələrimiz\';\r\n$lan[\'layiheler-etrafli\'] = \'Daha ətraflı\';\r\n$lan[\'diger-layiheler\'] = \'Digər Layihələr\';\r\n$lan[\'layiheler-kateqoriya-adi\'] = \'Layihələr\';\r\n$lan[\'layiheler-hamisina-bax\'] = \'Bütün layihələr\';\r\n$lan[\'layiheler-etraflibax\'] = \'Ətraflı bax\';\r\n\r\n//Xeberler//\r\n\r\n$lan[\'diger-blog\'] = \'Digər bloglar\';\r\n$lan[\'xeberler-kateqoriya-adi\'] = \'Xəbərlər\';\r\n$lan[\'xeberler-basliq\'] = \'Bloglar\';\r\n$lan[\'xeberler-link\'] = \'Ətraflı bax\';\r\n$lan[\'xeberler-alt-basliq\'] = \'Hər gün yenilənən məlumatlrımızdan xəbərdar olun\';\r\n\r\n//Mehsullar//\r\n\r\n$lan[\'esassehife-mehsullar\'] = \'Məhsullarımız\';\r\n$lan[\'mehsullar-altmetin\'] = \'Məhsullarımıza baxmaq üçün məhsul kataloqumuza keçid edin\';\r\n$lan[\'mehsullar-etrafli\'] = \'Məhsullarımıza baxmaq üçün məhsul kataloqumuza keçid edin\';\r\n$lan[\'mehsullar-etraflibax\'] = \'Ətraflı bax\';\r\n\r\n\r\n//Xidmetler//\r\n\r\n$lan[\'xidmet-basliq\'] = \'Xidmətlərimiz\';\r\n$lan[\'xidmetler-kateqoriya-adi\'] = \'Xidmətlər\';\r\n$lan[\'diger-xidmetler\'] = \'Digər xidmətlərimiz\';\r\n$lan[\'xidmet-basliq-1\'] = \'Xidmətlər alt mətin\';\r\n$lan[\'xidmet-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'xidmet-etraflibax\'] = \'Ətraflı bax\';\r\n\r\n//Sertifikatlar//\r\n\r\n$lan[\'sertifikat-basliq\'] = \'Sertifikatlarımız\';\r\n$lan[\'sertifikat-kateqoriya-adi\'] = \'Sertifikatlar\';\r\n$lan[\'diger-sertifikat\'] = \'Digər Sertifikatlarımız\';\r\n$lan[\'sertifikat-basliq-1\'] = \'Sertifikatlar alt mətin\';\r\n$lan[\'sertifikat-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'sertifikat-etraflibax\'] = \'Ətraflı bax\';\r\n\r\n//Paketler//\r\n\r\n$lan[\'paketler-basliq\'] = \'Paketlərimiz\';\r\n$lan[\'paketler-kateqoriya-adi\'] = \'Paketlər\';\r\n$lan[\'diger-paketler\'] = \'Digər Paketlərimiz\';\r\n$lan[\'paketler-basliq-1\'] = \'Paketlər alt mətin\';\r\n$lan[\'paketler-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'paketler-etraflibax\'] = \'Ətraflı bax\';\r\n\r\n//Reyler//\r\n\r\n$lan[\'reylerimiz\'] = \'Rəylərimiz\';\r\n$lan[\'bizi-secen-musterilerimiz\'] = \'Bizi seçənlər\';\r\n$lan[\'esassehife-reyler\'] = \'Müştəri rəyləri\';\r\n\r\n//Statistika//\r\n\r\n$lan[\'esas-statistika\'] = \'Rəqəmlərlə biz\';\r\n$lan[\'statistika-altyazi\'] = \'Ölkə üzrə uğur statistik nəticələrimiz\';\r\n$lan[\'statistika-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Sual-Cavab//\r\n\r\n$lan[\'esassehife-cvs\'] = \'Suallar və Cavablar\';\r\n$lan[\'cvs-altyazi\'] = \'Sual cavab alt mətin\';\r\n$lan[\'cvs-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Haqqimizda//\r\n\r\n$lan[\'haqqimizda-qisa-aciqlama\'] = \'Biz kimik ?\';\r\n$lan[\'haqqimizda-ili\'] = \'12\';\r\n$lan[\'haqqimizda-il-yazi\'] = \'İllik\';\r\n$lan[\'haqqimizda-il-yazi2\'] = \'Təcrübəmiz\';\r\n$lan[\'haqqimizda-altmetin\'] = \'Haqqimizda alt metin olacaq\';\r\n$lan[\'haqqimizda-adi\'] = \'HAQQIMIZDA\';\r\n$lan[\'haqqimizda-aciqlama\'] = \'Tikinti sektorunda yenilikçi yanaşmalarımız və peşəkar komandamızla\';\r\n\r\n//adim//\r\n\r\n$lan[\'adim-umumi-basliq\'] = \'Necə işləyirik?\';\r\n$lan[\'adim-umumi-basliq-1\'] = \'3 addımda izləyin\';\r\n$lan[\'adim-1\'] = \'Təcrübələrimiz\';\r\n$lan[\'adim1-aciqlama\'] = \'Açıqlama\';\r\n$lan[\'adim-2\'] = \'Uğurlarımız\';\r\n$lan[\'adim2-aciqlama\'] = \'Açıqlama\';\r\n$lan[\'adim-3\'] = \'İşin təhvili\';\r\n$lan[\'adim3-aciqlama\'] = \'Açıqlama\';\r\n\r\n\r\n//Footer//\r\n\r\n$lan[\'footer-abune\'] = \'Abunə olmaq üçün?\';\r\n$lan[\'footer-abune-altyazi\'] = \'Yeniliklərdən xəbərdar olmaq üçün\';\r\n$lan[\'footer-abune-butonici\'] = \'Gmailınızı yazın\';\r\n$lan[\'footer-telefon\'] = \'Telefon\';\r\n$lan[\'footer-adres\'] = \'Adres\';\r\n$lan[\'footer-sehifeler\'] = \'Səhifələr\';\r\n$lan[\'footer-xidmetler\'] = \'Xidmətlər\';\r\n$lan[\'footer-firma-adi\'] = \'Şirkət adı\';\r\n$lan[\'footer-alt-yazi\'] = \'Şirkətimiz – müasir memarlığın və keyfiyyətli inşaatın yeni ünvanı.\';\r\n\r\n//Whatsapp//\r\n\r\n$lan[\'wapfirmadi\'] = \'Şirkət adi\';\r\n$lan[\'waponline\'] = \'Xətdə\';\r\n$lan[\'waptext\'] = \'Salam, mən Operator sizə necə kömək edə bilərik?\';\r\n$lan[\'wapduyme\'] = \'MESAJ GÖNDƏR\';\r\n$lan[\'wapelan\'] = \'Salam! Saytımıza xoş gəldiniz.\';\r\n$lan[\'wapmusterimesaj\'] = \'Salam, mənə xidmət haqqında məlumat verə bilərsiniz?\';\r\n$lan[\'wapnomre\'] = \'+994552919971\';\r\n', NULL, '0', '', '', '', '', '939-.jpg', '', '', '', '', '', '', '', '', NULL, '', '', 'layihə', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', NULL, NULL, '', NULL, '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', 'Haqqımızda', '', '', '', '', '', '', '', '', '', NULL, NULL, 'az'),
(28, 'EN', '2', '$lan = [];\r\n\r\n//Umumi//\r\n\r\n$lan[\'esassehife\'] = \'Home page\';\r\n$lan[\'bize-zeng\'] = \'Call Us\';\r\n$lan[\'bize-bir-mesaj-yazin\'] = \'Write to Us\';\r\n\r\n//Header//\r\n\r\n$lan[\'header-is-saatlari\'] = \'Weekdays\';\r\n$lan[\'header-is-saatlari-saat\'] = \'Customer Service\';\r\n$lan[\'header-teklifal\'] = \'GET A QUOTE\';\r\n\r\n//Elaqe//\r\n\r\n$lan[\'elaqe-telefon\'] = \'Phone\';\r\n$lan[\'elaqe-teklif-info\'] = \'For more information\';\r\n$lan[\'elaqe-email\'] = \'Gmail\';\r\n$lan[\'elaqe-teklif-forum\'] = \'Fill out the form for a quote\';\r\n$lan[\'elaqe-adres\'] = \'Address\';\r\n$lan[\'form-adsoyad\'] = \'Name Surname\';\r\n$lan[\'form-movzu\'] = \'Subject\';\r\n$lan[\'form-email\'] = \'Gmail\';\r\n$lan[\'form-telefon\'] = \'Phone\';\r\n$lan[\'form-mesaj\'] = \'Your Message\';\r\n$lan[\'form-gonder\'] = \'Send\';\r\n$lan[\'index-forum-elqe\'] = \'Contact Us\';\r\n$lan[\'index-forum-basliq\'] = \'Call Now\';\r\n$lan[\'index-indi-zeng\'] = \'Contact Us\';\r\n$lan[\'xidmet-detay-banner\'] = \'Contact Us\';\r\n$lan[\'xidmet-detay-basliq-1\'] = \'Call Now\';\r\n$lan[\'xidmet-indi-zeng\'] = \'Contact Us\';\r\n\r\n\r\n//Slayder//\r\n\r\n$lan[\'slider-buton\'] = \'EXPLORE\';\r\n$lan[\'slider-buton2\'] = \'DETAILS\';\r\n\r\n//Komondamiz//\r\n\r\n$lan[\'komandamiz-basliq\'] = \'Our Team\';\r\n$lan[\'komandamiz-alt-basliq\'] = \'Our team of professionals in their field\';\r\n\r\n//Layhieler//\r\n\r\n$lan[\'layiheler-basliq\'] = \'Projects\';\r\n$lan[\'layiheler-altmetin\'] = \'Projects subtext\';\r\n$lan[\'layiheler-altmetin-2\'] = \'Our wider projects in the construction sector\';\r\n$lan[\'layiheler-etrafli\'] = \'More details\';\r\n$lan[\'diger-layiheler\'] = \'Other Projects\';\r\n$lan[\'layiheler-kateqoriya-adi\'] = \'Projects\';\r\n$lan[\'layiheler-hamisina-bax\'] = \'View all projects\';\r\n$lan[\'layiheler-etraflibax\'] = \'View details\';\r\n\r\n//Xeberler//\r\n\r\n$lan[\'diger-blog\'] = \'Other blogs\';\r\n$lan[\'xeberler-kateqoriya-adi\'] = \'News\';\r\n$lan[\'xeberler-basliq\'] = \'Blogs\';\r\n$lan[\'xeberler-link\'] = \'View details\';\r\n$lan[\'xeberler-alt-basliq\'] = \'Stay informed with our daily updated information\';\r\n\r\n//Mehsullar//\r\n\r\n$lan[\'esassehife-mehsullar\'] = \'Our Products\';\r\n$lan[\'mehsullar-altmetin\'] = \'To view our products, go to our product catalog\';\r\n$lan[\'mehsullar-etrafli\'] = \'To view our products, go to our product catalog\';\r\n$lan[\'mehsullar-etraflibax\'] = \'View details\';\r\n\r\n\r\n//Xidmetler//\r\n\r\n$lan[\'xidmet-basliq\'] = \'Our Services\';\r\n$lan[\'xidmetler-kateqoriya-adi\'] = \'Services\';\r\n$lan[\'diger-xidmetler\'] = \'Our Other Services\';\r\n$lan[\'xidmet-basliq-1\'] = \'Services subtext\';\r\n$lan[\'xidmet-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'xidmet-etraflibax\'] = \'View details\';\r\n\r\n//Sertifikatlar//\r\n\r\n$lan[\'sertifikat-basliq\'] = \'Our Certificates\';\r\n$lan[\'sertifikat-kateqoriya-adi\'] = \'Certificates\';\r\n$lan[\'diger-sertifikat\'] = \'Our Other Certificates\';\r\n$lan[\'sertifikat-basliq-1\'] = \'Certificates subtext\';\r\n$lan[\'sertifikat-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'sertifikat-etraflibax\'] = \'View details\';\r\n\r\n//Paketler//\r\n\r\n$lan[\'paketler-basliq\'] = \'Our Packages\';\r\n$lan[\'paketler-kateqoriya-adi\'] = \'Packages\';\r\n$lan[\'diger-paketler\'] = \'Our Other Packages\';\r\n$lan[\'paketler-basliq-1\'] = \'Packages subtext\';\r\n$lan[\'paketler-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'paketler-etraflibax\'] = \'View details\';\r\n\r\n//Reyler//\r\n\r\n$lan[\'reylerimiz\'] = \'Our Reviews\';\r\n$lan[\'bizi-secen-musterilerimiz\'] = \'Our Customers Who Chose Us\';\r\n$lan[\'esassehife-reyler\'] = \'Customer Reviews\';\r\n\r\n//Statistika//\r\n\r\n$lan[\'esas-statistika\'] = \'We by the numbers\';\r\n$lan[\'statistika-altyazi\'] = \'Our successful statistical results across the country\';\r\n$lan[\'statistika-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Sual-Cavab//\r\n\r\n$lan[\'esassehife-cvs\'] = \'Questions and Answers\';\r\n$lan[\'cvs-altyazi\'] = \'Q&A subtext\';\r\n$lan[\'cvs-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Haqqimizda//\r\n\r\n$lan[\'haqqimizda-qisa-aciqlama\'] = \'Who are we?\';\r\n$lan[\'haqqimizda-ili\'] = \'12\';\r\n$lan[\'haqqimizda-il-yazi\'] = \'Years\';\r\n$lan[\'haqqimizda-il-yazi2\'] = \'Experience\';\r\n$lan[\'haqqimizda-altmetin\'] = \'About us subtext will be here\';\r\n$lan[\'haqqimizda-adi\'] = \'ABOUT US\';\r\n$lan[\'haqqimizda-aciqlama\'] = \'With our innovative approaches and professional team in the construction sector\';\r\n\r\n//adim//\r\n\r\n$lan[\'adim-umumi-basliq\'] = \'How do we work?\';\r\n$lan[\'adim-umumi-basliq-1\'] = \'Follow in 3 steps\';\r\n$lan[\'adim-1\'] = \'Our Experiences\';\r\n$lan[\'adim1-aciqlama\'] = \'Description\';\r\n$lan[\'adim-2\'] = \'Our Successes\';\r\n$lan[\'adim2-aciqlama\'] = \'Description\';\r\n$lan[\'adim-3\'] = \'Project Handover\';\r\n$lan[\'adim3-aciqlama\'] = \'Description\';\r\n\r\n\r\n//Footer//\r\n\r\n$lan[\'footer-abune\'] = \'To subscribe?\';\r\n$lan[\'footer-abune-altyazi\'] = \'Subscribe to stay updated with news\';\r\n$lan[\'footer-abune-butonici\'] = \'Enter your Gmail\';\r\n$lan[\'footer-telefon\'] = \'Phone\';\r\n$lan[\'footer-adres\'] = \'Address\';\r\n$lan[\'footer-sehifeler\'] = \'Pages\';\r\n$lan[\'footer-xidmetler\'] = \'Services\';\r\n$lan[\'footer-firma-adi\'] = \'Company Name\';\r\n$lan[\'footer-alt-yazi\'] = \'Our company – the new address for modern architecture and quality construction.\';\r\n\r\n//Whatsapp//\r\n\r\n$lan[\'wapfirmadi\'] = \'Company Name\';\r\n$lan[\'waponline\'] = \'Online\';\r\n$lan[\'waptext\'] = \'Hello, I am the operator, how can I help you?\';\r\n$lan[\'wapduyme\'] = \'SEND MESSAGE\';\r\n$lan[\'wapelan\'] = \'Hello! Welcome to our site.\';\r\n$lan[\'wapmusterimesaj\'] = \'Hello, can you give me information about the service?\';\r\n$lan[\'wapnomre\'] = \'+994552919971\';', NULL, '0', NULL, NULL, NULL, NULL, 'no-img', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en'),
(29, 'RU', '3', '$lan = [];\r\n\r\n//Umumi//\r\n\r\n$lan[\'esassehife\'] = \'Главная страница\';\r\n$lan[\'bize-zeng\'] = \'Позвоните нам\';\r\n$lan[\'bize-bir-mesaj-yazin\'] = \'Напишите нам\';\r\n\r\n//Header//\r\n\r\n$lan[\'header-is-saatlari\'] = \'Будние дни\';\r\n$lan[\'header-is-saatlari-saat\'] = \'Обслуживание клиентов\';\r\n$lan[\'header-teklifal\'] = \'ПОЛУЧИТЬ ПРЕДЛОЖЕНИЕ\';\r\n\r\n//Elaqe//\r\n\r\n$lan[\'elaqe-telefon\'] = \'Телефон\';\r\n$lan[\'elaqe-teklif-info\'] = \'Для получения дополнительной информации\';\r\n$lan[\'elaqe-email\'] = \'Gmail\';\r\n$lan[\'elaqe-teklif-forum\'] = \'Заполните форму для предложения\';\r\n$lan[\'elaqe-adres\'] = \'Адрес\';\r\n$lan[\'form-adsoyad\'] = \'Имя Фамилия\';\r\n$lan[\'form-movzu\'] = \'Тема\';\r\n$lan[\'form-email\'] = \'Gmail\';\r\n$lan[\'form-telefon\'] = \'Телефон\';\r\n$lan[\'form-mesaj\'] = \'Ваше сообщение\';\r\n$lan[\'form-gonder\'] = \'Отправить\';\r\n$lan[\'index-forum-elqe\'] = \'Свяжитесь с нами\';\r\n$lan[\'index-forum-basliq\'] = \'Позвоните сейчас\';\r\n$lan[\'index-indi-zeng\'] = \'Свяжитесь с нами\';\r\n$lan[\'xidmet-detay-banner\'] = \'Свяжитесь с нами\';\r\n$lan[\'xidmet-detay-basliq-1\'] = \'Позвоните сейчас\';\r\n$lan[\'xidmet-indi-zeng\'] = \'Свяжитесь с нами\';\r\n\r\n\r\n//Slayder//\r\n\r\n$lan[\'slider-buton\'] = \'ИЗУЧИТЬ\';\r\n$lan[\'slider-buton2\'] = \'ПОДРОБНЕЕ\';\r\n\r\n//Komondamiz//\r\n\r\n$lan[\'komandamiz-basliq\'] = \'Наша команда\';\r\n$lan[\'komandamiz-alt-basliq\'] = \'Наша команда профессионалов в своей области\';\r\n\r\n//Layhieler//\r\n\r\n$lan[\'layiheler-basliq\'] = \'Проекты\';\r\n$lan[\'layiheler-altmetin\'] = \'Подтекст проектов\';\r\n$lan[\'layiheler-altmetin-2\'] = \'Наши более масштабные проекты в строительном секторе\';\r\n$lan[\'layiheler-etrafli\'] = \'Подробнее\';\r\n$lan[\'diger-layiheler\'] = \'Другие проекты\';\r\n$lan[\'layiheler-kateqoriya-adi\'] = \'Проекты\';\r\n$lan[\'layiheler-hamisina-bax\'] = \'Посмотреть все проекты\';\r\n$lan[\'layiheler-etraflibax\'] = \'Подробнее\';\r\n\r\n//Xeberler//\r\n\r\n$lan[\'diger-blog\'] = \'Другие блоги\';\r\n$lan[\'xeberler-kateqoriya-adi\'] = \'Новости\';\r\n$lan[\'xeberler-basliq\'] = \'Блоги\';\r\n$lan[\'xeberler-link\'] = \'Подробнее\';\r\n$lan[\'xeberler-alt-basliq\'] = \'Будьте в курсе наших ежедневно обновляемых новостей\';\r\n\r\n//Mehsullar//\r\n\r\n$lan[\'esassehife-mehsullar\'] = \'Наши продукты\';\r\n$lan[\'mehsullar-altmetin\'] = \'Для просмотра наших продуктов перейдите в наш каталог продуктов\';\r\n$lan[\'mehsullar-etrafli\'] = \'Для просмотра наших продуктов перейдите в наш каталог продуктов\';\r\n$lan[\'mehsullar-etraflibax\'] = \'Подробнее\';\r\n\r\n\r\n//Xidmetler//\r\n\r\n$lan[\'xidmet-basliq\'] = \'Наши услуги\';\r\n$lan[\'xidmetler-kateqoriya-adi\'] = \'Услуги\';\r\n$lan[\'diger-xidmetler\'] = \'Наши другие услуги\';\r\n$lan[\'xidmet-basliq-1\'] = \'Подтекст услуг\';\r\n$lan[\'xidmet-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'xidmet-etraflibax\'] = \'Подробнее\';\r\n\r\n//Sertifikatlar//\r\n\r\n$lan[\'sertifikat-basliq\'] = \'Наши сертификаты\';\r\n$lan[\'sertifikat-kateqoriya-adi\'] = \'Сертификаты\';\r\n$lan[\'diger-sertifikat\'] = \'Наши другие сертификаты\';\r\n$lan[\'sertifikat-basliq-1\'] = \'Подтекст сертификатов\';\r\n$lan[\'sertifikat-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'sertifikat-etraflibax\'] = \'Подробнее\';\r\n\r\n//Paketler//\r\n\r\n$lan[\'paketler-basliq\'] = \'Наши пакеты\';\r\n$lan[\'paketler-kateqoriya-adi\'] = \'Пакеты\';\r\n$lan[\'diger-paketler\'] = \'Наши другие пакеты\';\r\n$lan[\'paketler-basliq-1\'] = \'Подтекст пакетов\';\r\n$lan[\'paketler-basliq-2\'] = \'Duis aute irure dolor in reprehenderit\';\r\n$lan[\'paketler-etraflibax\'] = \'Подробнее\';\r\n\r\n//Reyler//\r\n\r\n$lan[\'reylerimiz\'] = \'Наши отзывы\';\r\n$lan[\'bizi-secen-musterilerimiz\'] = \'Наши клиенты, которые выбрали нас\';\r\n$lan[\'esassehife-reyler\'] = \'Отзывы клиентов\';\r\n\r\n//Statistika//\r\n\r\n$lan[\'esas-statistika\'] = \'Мы в цифрах\';\r\n$lan[\'statistika-altyazi\'] = \'Наши успешные статистические результаты по стране\';\r\n$lan[\'statistika-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Sual-Cavab//\r\n\r\n$lan[\'esassehife-cvs\'] = \'Вопросы и ответы\';\r\n$lan[\'cvs-altyazi\'] = \'Подтекст вопросов и ответов\';\r\n$lan[\'cvs-metin\'] = \'Lorem ipsum dolor sit amet consectetur \';\r\n\r\n//Haqqimizda//\r\n\r\n$lan[\'haqqimizda-qisa-aciqlama\'] = \'Кто мы?\';\r\n$lan[\'haqqimizda-ili\'] = \'12\';\r\n$lan[\'haqqimizda-il-yazi\'] = \'Лет\';\r\n$lan[\'haqqimizda-il-yazi2\'] = \'Опыта\';\r\n$lan[\'haqqimizda-altmetin\'] = \'Здесь будет подтекст о нас\';\r\n$lan[\'haqqimizda-adi\'] = \'О НАС\';\r\n$lan[\'haqqimizda-aciqlama\'] = \'С нашими инновационными подходами и профессиональной командой в строительном секторе\';\r\n\r\n//adim//\r\n\r\n$lan[\'adim-umumi-basliq\'] = \'Как мы работаем?\';\r\n$lan[\'adim-umumi-basliq-1\'] = \'Следуйте 3 шагам\';\r\n$lan[\'adim-1\'] = \'Наш опыт\';\r\n$lan[\'adim1-aciqlama\'] = \'Описание\';\r\n$lan[\'adim-2\'] = \'Наши успехи\';\r\n$lan[\'adim2-aciqlama\'] = \'Описание\';\r\n$lan[\'adim-3\'] = \'Передача работы\';\r\n$lan[\'adim3-aciqlama\'] = \'Описание\';\r\n\r\n\r\n//Footer//\r\n\r\n$lan[\'footer-abune\'] = \'Чтобы подписаться?\';\r\n$lan[\'footer-abune-altyazi\'] = \'Подпишитесь, чтобы быть в курсе новостей\';\r\n$lan[\'footer-abune-butonici\'] = \'Введите свой Gmail\';\r\n$lan[\'footer-telefon\'] = \'Телефон\';\r\n$lan[\'footer-adres\'] = \'Адрес\';\r\n$lan[\'footer-sehifeler\'] = \'Страницы\';\r\n$lan[\'footer-xidmetler\'] = \'Услуги\';\r\n$lan[\'footer-firma-adi\'] = \'Название компании\';\r\n$lan[\'footer-alt-yazi\'] = \'Наша компания – новый адрес современной архитектуры и качественного строительства.\';\r\n\r\n//Whatsapp//\r\n\r\n$lan[\'wapfirmadi\'] = \'Название компании\';\r\n$lan[\'waponline\'] = \'Онлайн\';\r\n$lan[\'waptext\'] = \'Здравствуйте, я оператор, чем могу помочь?\';\r\n$lan[\'wapduyme\'] = \'ОТПРАВИТЬ СООБЩЕНИЕ\';\r\n$lan[\'wapelan\'] = \'Здравствуйте! Добро пожаловать на наш сайт.\';\r\n$lan[\'wapmusterimesaj\'] = \'Здравствуйте, можете ли вы дать мне информацию об услуге?\';\r\n$lan[\'wapnomre\'] = \'+994552919971\';', NULL, '0', NULL, NULL, NULL, NULL, 'no-img', '', NULL, NULL, NULL, '', '', '', NULL, NULL, '', NULL, '', NULL, '', '', '', '', '', NULL, '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', '', NULL, NULL, '', NULL, '', '', '', NULL, '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, 'ru');

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

--
-- Table structure for table `layiheler`
--

CREATE TABLE `layiheler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sehifesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `elaveolunma_tarixi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `bitme_tarixi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `baslama_tarixi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `videolinki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `panel` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `indir` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `stok` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_des` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `layiheler`
--

INSERT INTO `layiheler` (`id`, `adi`, `sira`, `resim`, `sehifesekli`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `elaveolunma_tarixi`, `bitme_tarixi`, `baslama_tarixi`, `guncelleme_tarihi`, `fiyat`, `linki`, `videolinki`, `hit`, `panel`, `indir`, `stok`, `lan`, `title`, `etiket`, `description`, `meta_title`, `meta_des`, `meta_key`) VALUES
(157, 'Xankəndi Kaştan hotel', '1', '588605-xankendi-kastan-hotel.webp', '3656885-xankendi-kastan-hotel.webp', '7', '', '0', '', 'xankendi-kastan-hotel', 'layiheler', '09.07.2025', '20.09.2025', '12.03.2024', '04.08.2025', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', ''),
(158, 'Suqovuşan', '2', '1828565-suqovusan.webp', '5028116-suqovusan.webp', '7', '', '0', '', 'suqovusan', 'layiheler', '09.07.2025', '20.09.2025', '12.03.2024', '04.08.2025', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', ''),
(159, 'Java game klubu', '3', '5350680-java-game-klubu.webp', '7842492-java-game-klubu.webp', '9', '', '0', '', 'java-game-klubu', 'layiheler', '09.07.2025', '', '', '06.08.2025', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', '');

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

--
-- Table structure for table `layihe_kateqoriya`
--

CREATE TABLE `layihe_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `aciklama2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `layihe_kateqoriya`
--

INSERT INTO `layihe_kateqoriya` (`id`, `adi`, `sira`, `resim`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `aciklama2`, `resim2`, `title`, `etiket`, `description`) VALUES
(5, 'Təmir', '1', '2976427-test.png', '0', NULL, '0', '', 'temir', 'layihe_kateqoriya', '08.07.2025', '24.07.2025', NULL, 24, NULL, 'no-img', NULL, NULL, NULL),
(7, 'Dizayn', '2', '1462500-test-2.png', '0', NULL, '0', '', 'dizayn', 'layihe_kateqoriya', '08.07.2025', '24.07.2025', NULL, 24, NULL, 'no-img', NULL, NULL, NULL),
(9, 'Tikinti', '3', 'no-img', '0', NULL, '0', '', 'tikinti', 'layihe_kateqoriya', '08.07.2025', '24.07.2025', NULL, 24, NULL, 'no-img', NULL, NULL, NULL);

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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `id` int(11) NOT NULL,
  `site_mail` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_mail_sifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_mail_host` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_mail_port` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `gonderen_mail` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mail`
--

INSERT INTO `mail` (`id`, `site_mail`, `site_mail_sifre`, `site_mail_host`, `site_mail_port`, `gonderen_mail`) VALUES
(1, 'test@azsiteshop.com', '76150Dima@', 'mail.azsiteshop.com', '465', 'test@azsiteshop.com');

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

--
-- Table structure for table `mail_dogrula`
--

CREATE TABLE `mail_dogrula` (
  `id` int(11) NOT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kod` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mail_dogrula`
--

INSERT INTO `mail_dogrula` (`id`, `email`, `kod`, `veziyyeti`) VALUES
(26, 'enesakcaren@gmail.com', '3659674', '1'),
(27, 'omerryuksel63@gmail.com', '1714378', '0'),
(28, 'mehmetmasa123@gmail.com', '3499543', '0'),
(29, 'roxgrup@gmail.com', '3503463', '0'),
(30, 'cresitc@gmail.com', '1321429', '1'),
(31, 'apocalipsee@hotmail.com', '3807425', '0'),
(32, 'aaa@gmail.com', '1273300', '1'),
(33, 'xxx@gmail.com', '339070', '1'),
(34, 'enes.kucuktas@edittasarim.com', '2539931', '1');

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

--
-- Table structure for table `mehsullar`
--

CREATE TABLE `mehsullar` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `videolinki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `panel` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `indir` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `stok` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `kur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_des` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `mehsul_kateqoriya`
--

CREATE TABLE `mehsul_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mehsul_kateqoriya` text DEFAULT NULL,
  `layihe_kateqoriya` text DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `mehsul_rey`
--

CREATE TABLE `mehsul_rey` (
  `id` int(11) NOT NULL,
  `yorum` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `uye` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urun_id` int(11) DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mehsul_rey`
--

INSERT INTO `mehsul_rey` (`id`, `yorum`, `uye`, `tarih`, `urun_id`, `veziyyeti`) VALUES
(5, 'harika bir script', '64', NULL, 111, '1');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `url` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` int(11) DEFAULT NULL,
  `acilir` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mehsul_kateqoriya` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `layihe_kateqoriya` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sekme` int(11) DEFAULT NULL,
  `footer` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `adi`, `sira`, `url`, `veziyyeti`, `acilir`, `kategori`, `mehsul_kateqoriya`, `layihe_kateqoriya`, `sekme`, `footer`, `lan`) VALUES
(20, 'Əlaqə', 5, 'elaqe', 0, '1', '0', NULL, NULL, 0, 0, 24),
(18, 'Layihələr', 3, 'layiheler', 0, '1', '0', NULL, NULL, 0, 0, 24),
(15, 'Haqqımızda', 1, 'haqqimizda', 0, '1', '0', NULL, NULL, 0, 0, 24),
(16, 'Xidmətlər', 2, 'xidmetler', 0, '0', '0', NULL, NULL, 0, 0, 24),
(77, 'Xəbərlər', 4, 'blog', 0, '1', '0', NULL, NULL, 0, 0, 24),
(78, 'Təmir', 5, 'temir', 0, '0', '16', NULL, NULL, 0, 0, 24),
(79, 'Tikinti', 6, 'tikinti', 0, '0', '16', NULL, NULL, 0, 0, 24),
(80, 'Dizayn', 7, 'dizayn', 0, '0', '16', NULL, NULL, 0, 0, 24),
(81, 'Memarlıq-Layihə', 8, 'memarliq-layihe', 0, '0', '16', NULL, NULL, 0, 0, 24),
(82, 'Mebel', 9, 'mebel', 0, '0', '16', NULL, NULL, 0, 0, 24),
(83, 'Pərdə', 10, 'perde', 0, '0', '16', NULL, NULL, 0, 0, 24);

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

--
-- Table structure for table `modal`
--

CREATE TABLE `modal` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `modal`
--

INSERT INTO `modal` (`id`, `adi`, `resim`, `veziyyeti`) VALUES
(1, '       ', '794-modal.webp', '0');

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

--
-- Table structure for table `netgsm`
--

CREATE TABLE `netgsm` (
  `id` int(11) NOT NULL,
  `no` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `gonderici` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `netgsm`
--

INSERT INTO `netgsm` (`id`, `no`, `sifre`, `gonderici`, `mesaj`, `veziyyeti`) VALUES
(1, '', '', '', 'Tema başarıyla satın alındı, hesabım bölümünden indirebilirsiniz.', 1);

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

--
-- Table structure for table `odeme_secenek`
--

CREATE TABLE `odeme_secenek` (
  `id` int(11) NOT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `odeme_secenek`
--

INSERT INTO `odeme_secenek` (`id`, `tur`) VALUES
(1, 'paymax');

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

--
-- Table structure for table `onecikan`
--

CREATE TABLE `onecikan` (
  `id` int(11) NOT NULL,
  `mehsullar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onecikan`
--

INSERT INTO `onecikan` (`id`, `mehsullar`) VALUES
(1, '117,116,115,111');

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

--
-- Table structure for table `paketler`
--

CREATE TABLE `paketler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `videolinki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `panel` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `indir` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `stok` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `kur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_des` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `paket_kateqoriya`
--

CREATE TABLE `paket_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `sira` text DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `kategori` text DEFAULT NULL,
  `paket_kateqoriya` text DEFAULT NULL,
  `mehsul_kateqoriya` text DEFAULT NULL,
  `layihe_kateqoriya` text DEFAULT NULL,
  `onaciklama` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `seo` text DEFAULT NULL,
  `tur` text DEFAULT NULL,
  `eklenme_tarihi` text DEFAULT NULL,
  `guncelleme_tarihi` text DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `etiket` text DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

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

--
-- Table structure for table `panel`
--

CREATE TABLE `panel` (
  `id` int(11) NOT NULL,
  `p_renk1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `p_renk2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `panel`
--

INSERT INTO `panel` (`id`, `p_renk1`, `p_renk2`) VALUES
(1, '#001c2e', '#001c2e');

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

--
-- Table structure for table `paymax`
--

CREATE TABLE `paymax` (
  `id` int(11) NOT NULL,
  `api_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `api_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `api_magaza` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `api_hash` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paymax`
--

INSERT INTO `paymax` (`id`, `api_user`, `api_key`, `api_magaza`, `api_hash`) VALUES
(1, '', '', '', '');

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

--
-- Table structure for table `paytr`
--

CREATE TABLE `paytr` (
  `id` int(11) NOT NULL,
  `merchand_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `merchand_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `merchand_salt` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paytr`
--

INSERT INTO `paytr` (`id`, `merchand_id`, `merchand_key`, `merchand_salt`) VALUES
(1, '', '', '');

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

--
-- Table structure for table `rapor`
--

CREATE TABLE `rapor` (
  `id` int(11) NOT NULL,
  `mesaj` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urun` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rapor`
--

INSERT INTO `rapor` (`id`, `mesaj`, `urun`, `tarih`) VALUES
(1, 'sitenin demosu çalışmıyor.', 'Teknoloji Scripti V2', '13.07.2022'),
(2, 'Demo Sürümü Çalışmıyor.\r\n', 'Kamera Sistemleri Scripti V1', '27.07.2022'),
(3, '', 'Eticaret Scripti 12 (Mağaza Açma)', '28.07.2022'),
(4, '', 'Kişisel Script V8', '07.08.2022'),
(5, 'yönetim panelleri çalışmıyor.', 'Nakliye Scripti V5', '12.08.2022');

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

--
-- Table structure for table `referanslar`
--

CREATE TABLE `referanslar` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `referanslar`
--

INSERT INTO `referanslar` (`id`, `adi`, `sira`, `aciklama`, `linki`, `veziyyeti`, `resim`, `lan`) VALUES
(33, 'Ref', 1, NULL, NULL, '0', '4488145-ref.webp', 24),
(34, 'Ref', 2, NULL, NULL, '0', '5553089-ref.webp', 24),
(35, 'ref', 3, NULL, NULL, '0', '8348914-ref.webp', 24),
(36, 'ref', 4, NULL, NULL, '0', '7635966-ref.webp', 24);

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

--
-- Table structure for table `reyler`
--

CREATE TABLE `reyler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `reyindexsekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `reyler`
--

INSERT INTO `reyler` (`id`, `adi`, `sira`, `resim`, `reyindexsekli`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `lan`) VALUES
(5, 'Test musteri', 1, '605-test-musteri.webp', NULL, NULL, 'Ceo', '0', '<p>Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;</p>\r\n\r\n<p>Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;Burda test yazi olacaq&nbsp;</p>\r\n', 'test-musteri', 'reyler', '08.07.2025', NULL, 24),
(6, 'test', 2, '939-test.webp', NULL, NULL, 'test', '0', '', 'test', 'reyler', '29.07.2025', NULL, 24);

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

--
-- Table structure for table `sehifeler`
--

CREATE TABLE `sehifeler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sehifeler`
--

INSERT INTO `sehifeler` (`id`, `adi`, `sira`, `resim`, `resim2`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `title`, `description`, `etiket`) VALUES
(26, 'о нас', '1', 'no-img', NULL, NULL, '', '0', '', 'o-nas', 'sehifeler', '30.04.2025', NULL, NULL, 27, NULL, NULL, NULL),
(27, 'About', '01', '533-about.webp', NULL, NULL, 'NAYS Construction – the new address of modern architecture and quality construction.', '0', '<p>With our innovative approaches and professional team in the construction sector, we build not just buildings &ndash; but spaces that create value. We stand out with the attention to detail, engineering precision and aesthetic vision we give to each of our projects.</p>\r\n\r\n<p>Based on years of experience, we have become a trusted partner in the field of residential complexes, commercial facilities and individual buildings. For us, every client is the beginning of joint success.</p>\r\n\r\n<p>NAYS Construction &ndash; a brand that plans for the future and builds on solid foundations.</p>\r\n', 'about', 'sehifeler', '02.05.2025', '02.05.2025', NULL, 26, NULL, NULL, NULL),
(30, 'Haqqımızda', '1', '2426663-haqqimizda.webp', NULL, NULL, 'Biz, Megas inşaat olaraq 2012-ci ildən bu yana tikinti və təmir sahəsində fəaliyyət göstəririk.', '0', '<p><br />\r\n12 ildən &ccedil;ox m&uuml;ddəti əhatə edən fəaliyyətimiz d&ouml;vr&uuml;ndə 1000-dən &ccedil;ox layihə həyata ke&ccedil;irmişik.<br />\r\n&Ouml;lkəmizdəki işlərlə yanaşı, xaricdə də bir &ccedil;ox uğurlu layihələrə imza atmışıq.<br />\r\n<br />\r\nBu illər ərzində şirkətimizin ən b&ouml;y&uuml;k qazancı isə m&uuml;ştərilərimizin g&uuml;vəni və etibarlı tərəfdaşlarımızdır.<br />\r\nMegas İnşaat! Maksimum s&uuml;rət, y&uuml;ksək peşəkarlıq və keyfiyyətin ən sərfəli şərtlərlə təqdim&nbsp;olunduğu&nbsp;&uuml;nvan!<br />\r\n<br />\r\nMegas İnşaatın əsas fəaliyyət istiqaməti<br />\r\n- yaşayış binalarının tikintisi,<br />\r\n- binaların fasad işlərinin g&ouml;r&uuml;lməsi,<br />\r\n- fərdi yaşayış evləri və obyektlərin tikintisi və təmiri,<br />\r\n- mənzillərin təmiri,<br />\r\n-eksteryer, interyer və landşaft dizaynı və tikinti-təmir işləri də daxil olmaqla geniş &ccedil;eşidli xidmətlərdən ibarətdir. Bundan əlavə hər n&ouml;v mebel və pərdələrin təmin edilməsi də xidmətlərimizə daxildir.<br />\r\nMegas İnşaatı se&ccedil;məklə A-dan Z-yə b&uuml;t&uuml;n tikinti işlərinizin həllini&nbsp;se&ccedil;irsiniz!<br />\r\n<br />\r\nMegas İnşaat olaraq, bizim &uuml;&ccedil;&uuml;n ən &ouml;nəmli olan m&uuml;ştərilərimizin məmnunluğudur. Həyata ke&ccedil;irdiyimiz b&uuml;t&uuml;n layihələrdə keyfiyyət və vaxtında təhvil əsas prioritetimizdir. Peşəkar komandamızla hər bir m&uuml;ştərinin tələblərinə fərdi yanaşırıq və onların g&ouml;zləntilərini maksimum səviyyədə qarşılayırıq. Qiymət siyasətimizə gəlincə isə, hər zaman maksimum keyfiyyəti, ən sərfəli şərtlərlə təqdim etməyi hədəfləyirik!<br />\r\nMegas İnşaat! Artıq təmir və tikinti işləriniz &ccedil;ox asan və rahat olmaqla yanaşı, həm də keyfiyyətli və&nbsp;sərfəli&nbsp;olacaq!</p>\r\n', 'haqqimizda', 'sehifeler', '08.07.2025', '23.07.2025', NULL, 24, NULL, NULL, NULL);

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

--
-- Table structure for table `sepet`
--

CREATE TABLE `sepet` (
  `id` int(11) NOT NULL,
  `urun_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ip` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `uye` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adet` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sepet`
--

INSERT INTO `sepet` (`id`, `urun_id`, `ip`, `tarih`, `uye`, `fiyat`, `adet`) VALUES
(263, '111', '31.223.58.11', NULL, NULL, '249', 1),
(262, '116', '176.88.120.243', NULL, NULL, '450', 1),
(261, '117', '176.235.166.218', NULL, NULL, '450', 1),
(260, '117', '176.235.166.218', NULL, NULL, '450', 1),
(259, '111', '176.88.120.243', NULL, NULL, '249', 1);

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

--
-- Table structure for table `sertifikatlar`
--

CREATE TABLE `sertifikatlar` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `sehifesekli` text DEFAULT NULL,
  `kategori` text DEFAULT NULL,
  `onaciklama` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `seo` text DEFAULT NULL,
  `tur` text DEFAULT NULL,
  `elaveolunma_tarixi` text DEFAULT NULL,
  `bitme_tarixi` text DEFAULT NULL,
  `baslama_tarixi` text DEFAULT NULL,
  `guncelleme_tarihi` text DEFAULT NULL,
  `linki` text DEFAULT NULL,
  `videolinki` text DEFAULT NULL,
  `fiyat` text DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `panel` text DEFAULT NULL,
  `indir` text DEFAULT NULL,
  `stok` text DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `etiket` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `meta_title` text DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `meta_key` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

--
-- Dumping data for table `sertifikatlar`
--

INSERT INTO `sertifikatlar` (`id`, `adi`, `sira`, `resim`, `sehifesekli`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `elaveolunma_tarixi`, `bitme_tarixi`, `baslama_tarixi`, `guncelleme_tarihi`, `linki`, `videolinki`, `fiyat`, `hit`, `panel`, `indir`, `stok`, `lan`, `title`, `etiket`, `description`, `meta_title`, `meta_des`, `meta_key`) VALUES
(1, 'test', 1, '4183969-test.webp', 'no-img', '1', 'aaaaaaaaaaa  as ad a  a a   asasasass', '0', '', 'test', 'sertifikatlar', '28.07.2025', '', '', '28.07.2025', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', ''),
(2, 'test 2', 2, '6324664-test-2.webp', 'no-img', '0', 'Elevate Your Achievements Using Premier IT Solutions', '0', '', 'test-2', 'sertifikatlar', '28.07.2025', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', ''),
(3, 'test 3', 3, '6563807-test-3.webp', 'no-img', '0', 'Elevate Your Achievements Using Premier IT Solutions', '0', '', 'test-3', 'sertifikatlar', '28.07.2025', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, NULL, '', '', '');

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

--
-- Table structure for table `sertifikat_kateqoriya`
--

CREATE TABLE `sertifikat_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `sira` text DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `kategori` text DEFAULT NULL,
  `onaciklama` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `seo` text DEFAULT NULL,
  `tur` text DEFAULT NULL,
  `eklenme_tarihi` text DEFAULT NULL,
  `guncelleme_tarihi` text DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `aciklama2` text DEFAULT NULL,
  `resim2` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `etiket` text DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

--
-- Dumping data for table `sertifikat_kateqoriya`
--

INSERT INTO `sertifikat_kateqoriya` (`id`, `adi`, `sira`, `resim`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `aciklama2`, `resim2`, `title`, `etiket`, `description`) VALUES
(1, 'test kateqoriya', '1', 'no-img', '0', NULL, '0', '', 'test-kateqoriya', 'sertifikat_kateqoriya', '28.07.2025', NULL, NULL, 24, NULL, 'no-img', NULL, NULL, NULL);

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

--
-- Table structure for table `shopier`
--

CREATE TABLE `shopier` (
  `id` int(11) NOT NULL,
  `kullanici` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `shopier`
--

INSERT INTO `shopier` (`id`, `kullanici`, `sifre`) VALUES
(1, '', '');

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

--
-- Table structure for table `sifarisler`
--

CREATE TABLE `sifarisler` (
  `id` int(11) NOT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `urun` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eposta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adsoyad` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `uye` int(11) DEFAULT NULL,
  `paytr` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sepetid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `adres` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `icon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `adi`, `sira`, `aciklama`, `onaciklama`, `linki`, `veziyyeti`, `resim`, `resim2`, `lan`, `icon`) VALUES
(41, 'TECHNOLOGY RELETED CONSULTANCY', 1, 'Consectetur adipiscing elit Aenean scelerisque at augue vitae consequat <br> quisque', 'We Convert Concepts Into Technology', 'elaqe', '0', '7859231-layihenizi.webp', 'no-img', 24, 'no-img'),
(49, 'İdeyalarınızı', 2, 'Sizə uyğun, funksional və estetik<br> həllərlə güclü onlayn varlıq qururuq.', 'Həqiqətə çeviririk', 'elaqe', '0', '1481712-ideyalarinizi.webp', 'no-img', 24, 'no-img');

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

--
-- Table structure for table `son_islem`
--

CREATE TABLE `son_islem` (
  `id` int(11) NOT NULL,
  `sayfa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `ip` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `saat` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `sosialmedia`
--

CREATE TABLE `sosialmedia` (
  `id` int(11) NOT NULL,
  `instagram` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `facebook` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `youtube` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linkedin` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `pinterest` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telegram` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `twitter` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `whatsappp` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sosialmedia`
--

INSERT INTO `sosialmedia` (`id`, `instagram`, `facebook`, `youtube`, `linkedin`, `pinterest`, `telegram`, `twitter`, `whatsappp`) VALUES
(1, 'https://instagram.com/', 'https://facebook.com/', 'https://youtube.com/', 'https://linkedin.com/', '', 'https://t.me/', NULL, '994553851155');

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

--
-- Table structure for table `tenzimlemeler`
--

CREATE TABLE `tenzimlemeler` (
  `id` int(11) NOT NULL,
  `site_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_keyword` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `site_author` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `logo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footer_logo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `favicon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footer_copyright` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `renk` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `renk2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `header` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `footer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `p_renk1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `p_renk2` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tenzimlemeler`
--

INSERT INTO `tenzimlemeler` (`id`, `site_title`, `site_description`, `site_keyword`, `site_meta`, `site_author`, `logo`, `footer_logo`, `favicon`, `footer_copyright`, `renk`, `renk2`, `header`, `footer`, `p_renk1`, `p_renk2`) VALUES
(1, 'Megasgroup.az', '', 'Insaat, təmir, tikinti, dizayn, mebel sifarisi', NULL, '', '933-megasgroupdotaz.webp', '477271535-megasgroupdotaz.png', '419845837-cicekbulaqdotaz.png', '', '#265db5', '#0b5ce0', '', '', NULL, NULL);

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

--
-- Table structure for table `urun_img`
--

CREATE TABLE `urun_img` (
  `id` int(11) NOT NULL,
  `urun_id` int(11) DEFAULT NULL,
  `img` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `uyeler`
--

CREATE TABLE `uyeler` (
  `id` int(11) NOT NULL,
  `adsoyad` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `normalsifre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `uyeler`
--

INSERT INTO `uyeler` (`id`, `adsoyad`, `email`, `telefon`, `sifre`, `normalsifre`, `tarih`, `veziyyeti`) VALUES
(64, 'umut tamirci', 'umuttamirci37@gmail.com', '05395965387', 'umutbaba123', NULL, '05/05/2002', NULL);

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `lan` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `xeberler`
--

CREATE TABLE `xeberler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sehifesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_des` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `xeberler`
--

INSERT INTO `xeberler` (`id`, `adi`, `sira`, `resim`, `sehifesekli`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `linki`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `etiket`, `title`, `description`, `meta_title`, `meta_des`, `meta_key`) VALUES
(110, 'Blog', 5, '8981105-blog.webp', '8097962-blog.webp', NULL, 'test', '0', '', 'blog', 'xeberler', '', '07.07.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, '', '', ''),
(111, 'blog2', 2, '1473471-blog2.webp', '7309482-blog2.webp', NULL, '', '0', '', 'blog2', 'xeberler', '', '08.07.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, '', '', ''),
(112, 'blog3', 3, '5823008-blog3.webp', '2127487-blog3.webp', NULL, 'sdfdg sgdfgdf dgdfg dfg ', '0', '<p>&nbsp;dfgdfg df dfg df&nbsp;</p>\r\n', 'blog3', 'xeberler', '', '08.07.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, 'Blog2', 'Test blog yazisi var', 'Bloglar, xəbərlər ');

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

--
-- Table structure for table `xidmetbolgeleri`
--

CREATE TABLE `xidmetbolgeleri` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `xidmetler`
--

CREATE TABLE `xidmetler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `resim` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `sehifesekli` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `resim3` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `veziyyeti` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `eklenme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `guncelleme_tarihi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `etiket` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `icon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `meta_title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_des` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
  `meta_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `xidmetler`
--

INSERT INTO `xidmetler` (`id`, `adi`, `sira`, `resim`, `sehifesekli`, `resim3`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `title`, `description`, `etiket`, `icon`, `meta_title`, `meta_des`, `meta_key`) VALUES
(69, 'Təmir', 1, '8941895-temir.webp', '3137351-temir.webp', NULL, '4', 'MEGAS Group olaraq, sizə yaşayış və iş məkanlarınızda yüksək keyfiyyətli və tam peşəkar təmir xidmətləri təklif edirik. Müasir tələblərə uyğun, həm funksional, həm də estetik baxımdan sizi tam qane edəcək məkanlar yaratmağı qarşımıza məqsəd qoymuşuq.', '0', '<p><strong>MEGAS Group</strong> olaraq, sizə yaşayış və iş məkanlarınızda y&uuml;ksək keyfiyyətli və tam peşəkar <strong>təmir xidmətləri</strong> təklif edirik. M&uuml;asir tələblərə uyğun, həm funksional, həm də estetik baxımdan sizi tam qane edəcək məkanlar yaratmağı qarşımıza məqsəd qoymuşuq.</p>\r\n\r\n<p>İstər k&ouml;hnə tikililərin yenilənməsi, istərsə də yeni obyektlərin daxili təmiri olsun &ndash; təcr&uuml;bəli komandamızla hər layihəyə fərdi yanaşırıq. Layihələndirmədən son mərhələyə qədər olan b&uuml;t&uuml;n işləri &ndash; <strong>s&ouml;k&uuml;nt&uuml;, suvaq, elektrik, santexnika, d&ouml;şəmə, boya-işıqlandırma və dizayn</strong> daxil olmaqla &ndash; bir mərkəzdən idarə edirik.</p>\r\n\r\n<p>Bizim &uuml;st&uuml;nl&uuml;klərimiz:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Keyfiyyətli və sertifikatlı materiallardan istifadə</p>\r\n	</li>\r\n	<li>\r\n	<p>Peşəkar və təcr&uuml;bəli ustalar</p>\r\n	</li>\r\n	<li>\r\n	<p>M&uuml;asir dizayn və funksionallıq</p>\r\n	</li>\r\n	<li>\r\n	<p>M&uuml;ştəri tələblərinə uyğun &ccedil;evik yanaşma</p>\r\n	</li>\r\n	<li>\r\n	<p>İşin vaxtında və zəmanətlə təhvil verilməsi</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>Eviniz, ofisiniz və ya obyektiniz &uuml;&ccedil;&uuml;n rahat, z&ouml;vql&uuml; və dayanıqlı bir məkan axtarırsınızsa, doğru &uuml;nvandasınız.</strong> Təmir işlərinizi bizə etibar edin, siz istirahət edərkən biz işimizi g&ouml;rək.</p>\r\n', 'temir', 'xidmetler', '27.06.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, '228297-temir-icon.webp', '', '', ''),
(70, 'Tikinti', 2, '3733412-tikinti.webp', '3369685-tikinti.webp', NULL, '0', 'MEGAS Group – hər ölçüdə və təyinatda tikinti layihələrinin həyata keçirilməsində sizin etibarlı tərəfdaşınızdır. İllərin təcrübəsinə və güclü mühəndis-usta heyətinə əsaslanaraq yaşayış, kommersiya və ictimai obyektlərin tikintisini yüksək keyfiyyətlə, beynəlxalq standartlara uyğun şəkildə icra edirik.', '0', '<p>Tikinti prosesinə yanaşmamız yalnız inşa etməklə bitmir &ndash; biz <strong>ideyadan reallaşmaya qədər olan b&uuml;t&uuml;n mərhələlərə nəzarət edir və kompleks həllər təqdim edirik.</strong> Layihənin planlaşdırılması, torpaq işləri, b&uuml;n&ouml;vrə, karkas, dam &ouml;rt&uuml;y&uuml;, izolyasiya, fasad və daxili tamamlamalar daxil olmaqla tam tikinti xidmətləri təqdim edirik.</p>\r\n\r\n<h4>Niyə MEGAS Group?</h4>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Peşəkar m&uuml;həndis və texniki heyət</p>\r\n	</li>\r\n	<li>\r\n	<p>G&uuml;vənli, m&ouml;hkəm və dayanıqlı tikinti materialları</p>\r\n	</li>\r\n	<li>\r\n	<p>Tikinti sahəsində m&uuml;asir texnologiya və metodlardan istifadə</p>\r\n	</li>\r\n	<li>\r\n	<p>Qrafikə uyğun s&uuml;rətli və keyfiyyətli icra</p>\r\n	</li>\r\n	<li>\r\n	<p>M&uuml;ştəri ilə şəffaf və qarşılıqlı razılaşmaya əsaslanan əməkdaşlıq</p>\r\n	</li>\r\n	<li>\r\n	<p>Təhvil verilən obyektlərə <strong>tam zəmanət</strong></p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>Eviniz, obyektiniz və ya layihə fikriniz varsa, MEGAS Group sizinlə birlikdə onu ger&ccedil;əyə &ccedil;evirəcək.</strong> Tikinti bizim &uuml;&ccedil;&uuml;n təkcə divar h&ouml;rmək deyil &ndash; bu, etibarın və dəyərin inşasıdır.</p>\r\n', 'tikinti', 'xidmetler', '27.06.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, 'no-img', '', '', ''),
(71, 'Dizayn', 3, '4346462-dizayn.webp', '4447976-dizayn.webp', NULL, '0', 'MEGAS Group olaraq, məkanlarınızı yalnız gözəlləşdirmirik — onlara şəxsiyyət və ruh qatırıq. Peşəkar interyer dizayn xidmətimizlə evlərinizi zövqlü, funksional və komfortlu məkanlara çeviririk.', '0', '<p>Hər m&uuml;ştərinin &ouml;z stilini və ehtiyaclarını nəzərə alaraq fərdi yanaşma tətbiq edirik. İstər minimal, klassik, modern, loft və ya l&uuml;ks tərz istəsəniz də, komandamız sizə uyğun <strong>yaradıcı və texniki cəhətdən d&uuml;zg&uuml;n həllər</strong> təqdim edəcək.</p>\r\n\r\n<h4>Nələri əhatə edir?</h4>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Planlaşdırma və məkan b&ouml;lg&uuml;s&uuml;</p>\r\n	</li>\r\n	<li>\r\n	<p>Rəng palitrası və material se&ccedil;imi</p>\r\n	</li>\r\n	<li>\r\n	<p>Divar, d&ouml;şəmə, tavan dizaynı</p>\r\n	</li>\r\n	<li>\r\n	<p>İşıqlandırma və mebel yerləşimi</p>\r\n	</li>\r\n	<li>\r\n	<p>3D vizualizasiya və layihələndirmə</p>\r\n	</li>\r\n	<li>\r\n	<p>Dizayna uyğun təmir və tətbiq prosesi</p>\r\n	</li>\r\n</ul>\r\n\r\n<h4>&Uuml;st&uuml;nl&uuml;klərimiz:</h4>\r\n\r\n<ul>\r\n	<li>\r\n	<p>M&uuml;ştərinin istəklərinə uyğun <strong>fərdi dizayn konseptləri</strong></p>\r\n	</li>\r\n	<li>\r\n	<p>M&uuml;asir trendlərlə ayaqlaşan yaradıcı yanaşma</p>\r\n	</li>\r\n	<li>\r\n	<p>Texniki baxımdan d&uuml;zg&uuml;n və funksional layihələndirmə</p>\r\n	</li>\r\n	<li>\r\n	<p>Dizayna uyğun y&uuml;ksək keyfiyyətli tətbiq və təmir işləri</p>\r\n	</li>\r\n	<li>\r\n	<p>Zamanında, təmiz və zəmanətli təhvil</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>MEGAS Group &ndash; evinizdəki harmoniyanın memarı.</strong> Siz rahatlığın və estetikliyin dadını &ccedil;ıxarın, biz isə onu sizin &uuml;&ccedil;&uuml;n dizayn edək.</p>\r\n', 'dizayn', 'xidmetler', '27.06.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, 'no-img', '', '', ''),
(72, 'Memarlıq-Layihə', 4, '9353064-memarliq-layihe.webp', '6261367-memarliq-layihe.webp', NULL, '0', 'MEGAS Group olaraq, arxitektura sahəsində sizə funksional, estetik və texniki baxımdan düzgün memarlıq və layihələndirmə xidmətləri təqdim edirik. Hər bir layihəyə müştərinin arzularını, ərazinin imkanlarını və şəhərsalma normalarını nəzərə alaraq fərdi yanaşma tətbiq edirik.', '0', '<p>Layihələndirmə mərhələsi, uğurlu tikinti prosesinin təməlidir. Məhz buna g&ouml;rə də, biz konsepsiyadan icraya qədər b&uuml;t&uuml;n mərhələləri <strong>dərinliklə planlaşdırır, dəqiqliklə işləyirik.</strong></p>\r\n\r\n<h4>Xidmətə daxildir:</h4>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Memarlıq konsepsiyasının hazırlanması</p>\r\n	</li>\r\n	<li>\r\n	<p>Ərazi və funksiya analizləri</p>\r\n	</li>\r\n	<li>\r\n	<p>Plan, fasad, kəsik və 3D vizualizasiya</p>\r\n	</li>\r\n	<li>\r\n	<p>Struktur və konstruktiv həllər</p>\r\n	</li>\r\n	<li>\r\n	<p>İstilik, işıqlandırma və m&uuml;həndis sistemlərinin planlaşdırılması</p>\r\n	</li>\r\n	<li>\r\n	<p>Tikinti &uuml;&ccedil;&uuml;n tam layihə sənədləri və eskizlər</p>\r\n	</li>\r\n</ul>\r\n\r\n<h4>Niyə bizi se&ccedil;məlisiniz?</h4>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Təcr&uuml;bəli memar və m&uuml;həndis heyəti</p>\r\n	</li>\r\n	<li>\r\n	<p>Qanunvericiliyə və tikinti normalarına uyğun layihələndirmə</p>\r\n	</li>\r\n	<li>\r\n	<p>Estetika ilə funksionallığın ideal vəhdəti</p>\r\n	</li>\r\n	<li>\r\n	<p>M&uuml;ştəri ilə daim koordinasiyalı və şəffaf iş prinsipi</p>\r\n	</li>\r\n	<li>\r\n	<p>3D təqdimatlar və real g&ouml;r&uuml;n&uuml;şl&uuml; vizuallaşdırma</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>İstər fərdi ev, istər &ccedil;oxmərtəbəli bina, istərsə də kommersiya obyekti layihəsi olsun &ndash; MEGAS Group sizin arxitektura tərəfdaşınızdır.</strong> Fikirlərinizə forma verək, gələcəyinizi birlikdə inşa edək!</p>\r\n', 'memarliq-layihe', 'xidmetler', '27.06.2025', '04.08.2025', NULL, 24, NULL, NULL, NULL, 'no-img', '', '', '');

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

--
-- Table structure for table `xidmetler2`
--

CREATE TABLE `xidmetler2` (
  `id` int(11) NOT NULL,
  `ad` text DEFAULT NULL,
  `sira` text DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `resim2` text DEFAULT NULL,
  `resim3` text DEFAULT NULL,
  `kategori` text DEFAULT NULL,
  `onaciklama` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `seo` text DEFAULT NULL,
  `tur` text DEFAULT NULL,
  `eklenme_tarihi` text DEFAULT NULL,
  `guncelleme_tarihi` text DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `etiket` text DEFAULT NULL,
  `icon` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

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

--
-- Table structure for table `xidmet_kateqoriya`
--

CREATE TABLE `xidmet_kateqoriya` (
  `id` int(11) NOT NULL,
  `adi` text DEFAULT NULL,
  `sira` text DEFAULT NULL,
  `resim` text DEFAULT NULL,
  `resim2` text DEFAULT NULL,
  `resim3` text DEFAULT NULL,
  `kategori` text DEFAULT NULL,
  `onaciklama` text DEFAULT NULL,
  `veziyyeti` text DEFAULT NULL,
  `aciklama` text DEFAULT NULL,
  `seo` text DEFAULT NULL,
  `tur` text DEFAULT NULL,
  `eklenme_tarihi` text DEFAULT NULL,
  `guncelleme_tarihi` text DEFAULT NULL,
  `hit` int(11) DEFAULT NULL,
  `lan` int(11) DEFAULT NULL,
  `aciklama2` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `etiket` text DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_turkish_ci;

--
-- Dumping data for table `xidmet_kateqoriya`
--

INSERT INTO `xidmet_kateqoriya` (`id`, `adi`, `sira`, `resim`, `resim2`, `resim3`, `kategori`, `onaciklama`, `veziyyeti`, `aciklama`, `seo`, `tur`, `eklenme_tarihi`, `guncelleme_tarihi`, `hit`, `lan`, `aciklama2`, `title`, `etiket`, `description`) VALUES
(4, 'Contact', '2', 'no-img', 'no-img', NULL, '0', NULL, '0', '', 'contact', 'xidmet_kateqoriya', '02.08.2025', NULL, NULL, 24, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `lan`
--
ALTER TABLE `lan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kod` (`kod`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `addim`
--
ALTER TABLE `addim`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `banka`
--
ALTER TABLE `banka`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `beadcrumb`
--
ALTER TABLE `beadcrumb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_rey`
--
ALTER TABLE `blog_rey`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `bolge_kateqoriya`
--
ALTER TABLE `bolge_kateqoriya`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bolge_rey`
--
ALTER TABLE `bolge_rey`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cvs`
--
ALTER TABLE `cvs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `destek`
--
ALTER TABLE `destek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `elaqe`
--
ALTER TABLE `elaqe`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elaqegelen`
--
ALTER TABLE `elaqegelen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `elaqemelumatlari`
--
ALTER TABLE `elaqemelumatlari`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `filallar`
--
ALTER TABLE `filallar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `galeri`
--
ALTER TABLE `galeri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `haqqimizda`
--
ALTER TABLE `haqqimizda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `icazeler`
--
ALTER TABLE `icazeler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `istatik`
--
ALTER TABLE `istatik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `katalog`
--
ALTER TABLE `katalog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `komandamiz`
--
ALTER TABLE `komandamiz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lan`
--
ALTER TABLE `lan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `layiheler`
--
ALTER TABLE `layiheler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=167;

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

--
-- AUTO_INCREMENT for table `mail`
--
ALTER TABLE `mail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mail_dogrula`
--
ALTER TABLE `mail_dogrula`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `mehsullar`
--
ALTER TABLE `mehsullar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `mehsul_kateqoriya`
--
ALTER TABLE `mehsul_kateqoriya`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mehsul_rey`
--
ALTER TABLE `mehsul_rey`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `modal`
--
ALTER TABLE `modal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `netgsm`
--
ALTER TABLE `netgsm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `odeme_secenek`
--
ALTER TABLE `odeme_secenek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `onecikan`
--
ALTER TABLE `onecikan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `paketler`
--
ALTER TABLE `paketler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- AUTO_INCREMENT for table `paket_kateqoriya`
--
ALTER TABLE `paket_kateqoriya`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `panel`
--
ALTER TABLE `panel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `paymax`
--
ALTER TABLE `paymax`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `paytr`
--
ALTER TABLE `paytr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `rapor`
--
ALTER TABLE `rapor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `referanslar`
--
ALTER TABLE `referanslar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `reyler`
--
ALTER TABLE `reyler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `sehifeler`
--
ALTER TABLE `sehifeler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `sepet`
--
ALTER TABLE `sepet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=264;

--
-- AUTO_INCREMENT for table `sertifikatlar`
--
ALTER TABLE `sertifikatlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sertifikat_kateqoriya`
--
ALTER TABLE `sertifikat_kateqoriya`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `shopier`
--
ALTER TABLE `shopier`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sifarisler`
--
ALTER TABLE `sifarisler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=152;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `son_islem`
--
ALTER TABLE `son_islem`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sosialmedia`
--
ALTER TABLE `sosialmedia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tenzimlemeler`
--
ALTER TABLE `tenzimlemeler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `urun_img`
--
ALTER TABLE `urun_img`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=360;

--
-- AUTO_INCREMENT for table `uyeler`
--
ALTER TABLE `uyeler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `xeberler`
--
ALTER TABLE `xeberler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `xidmetbolgeleri`
--
ALTER TABLE `xidmetbolgeleri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `xidmetler`
--
ALTER TABLE `xidmetler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `xidmetler2`
--
ALTER TABLE `xidmetler2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `xidmet_kateqoriya`
--
ALTER TABLE `xidmet_kateqoriya`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;
