-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 18, 2020 at 07:05 PM
-- Server version: 10.1.44-MariaDB
-- PHP Version: 7.2.30

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

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

--
-- Table structure for table `bolumler`
--

CREATE TABLE `bolumler` (
  `id` int(11) NOT NULL,
  `bolum_adi` text COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `bolumler`
--

INSERT INTO `bolumler` (`id`, `bolum_adi`) VALUES
(1, 'SALON'),
(2, 'BAHÇE'),
(3, 'KOMSEPT'),
(4, 'OYUN'),
(5, 'VİP OYUN');

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

--
-- Table structure for table `checkout`
--

CREATE TABLE `checkout` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `income` double NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `gider` double NOT NULL,
  `nakit` double NOT NULL,
  `kredi` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `days`
--

INSERT INTO `days` (`id`, `user_id`, `start`, `end`, `gider`, `nakit`, `kredi`) VALUES
(1, 4, '2020-06-11 20:50:20', '2020-06-12 07:41:48', 0, 0, 0),
(2, 4, '2020-06-12 07:42:01', '2020-06-12 07:42:08', 0, 0, 0),
(3, 4, '2020-06-12 09:01:51', '2020-06-12 09:01:55', 0, 0, 0),
(4, 4, '2020-06-12 09:02:18', '2020-06-13 07:30:53', 0, 2797, 0),
(5, 4, '2020-06-13 07:31:02', NULL, 0, 0, 0);

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `password` varchar(35) DEFAULT NULL,
  `employee_type` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`id`, `name`, `password`, `employee_type`, `user_id`) VALUES
(7, '1', 'c4ca4238a0b923820dcc509a6f75849b', 1, 4),
(9, '2', 'c4ca4238a0b923820dcc509a6f75849b', 2, 4),
(10, '3', '202cb962ac59075b964b07152d234b70', 1, 4),
(11, '4', 'c4ca4238a0b923820dcc509a6f75849b', 3, 4);

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

--
-- Table structure for table `garsonlar`
--

CREATE TABLE `garsonlar` (
  `id` int(11) NOT NULL,
  `isim` varchar(45) NOT NULL,
  `sifre` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garsonlar`
--

INSERT INTO `garsonlar` (`id`, `isim`, `sifre`) VALUES
(9, 'B İBRAHİM POLAT', '0000');

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

--
-- Table structure for table `genel`
--

CREATE TABLE `genel` (
  `id` int(11) NOT NULL,
  `sifre` varchar(45) NOT NULL,
  `aktar` tinyint(1) NOT NULL DEFAULT '0',
  `printer_state` tinyint(4) NOT NULL DEFAULT '0',
  `cift_tiklama` tinyint(1) NOT NULL,
  `oto_kilit` tinyint(1) NOT NULL,
  `para_ustu` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genel`
--

INSERT INTO `genel` (`id`, `sifre`, `aktar`, `printer_state`, `cift_tiklama`, `oto_kilit`, `para_ustu`) VALUES
(1, 'sifre', 0, 1, 1, 0, 1);

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

--
-- Table structure for table `giderler`
--

CREATE TABLE `giderler` (
  `id` int(11) NOT NULL,
  `aciklama` text NOT NULL,
  `tutar` double NOT NULL,
  `day` int(11) NOT NULL,
  `zaman` datetime NOT NULL,
  `id2` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `kasa`
--

CREATE TABLE `kasa` (
  `id` int(11) NOT NULL,
  `tutar` double NOT NULL,
  `type` tinyint(1) NOT NULL,
  `aciklama` text NOT NULL,
  `zaman` datetime NOT NULL,
  `is_lock` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `kasa`
--

INSERT INTO `kasa` (`id`, `tutar`, `type`, `aciklama`, `zaman`, `is_lock`) VALUES
(1, 0, 0, 'Günsonu (ID:1) Nakit', '2020-06-12 07:41:48', 1),
(2, 0, 1, 'Günsonu (ID:1) Kredi Kartı', '2020-06-12 07:41:48', 1),
(3, 0, 0, 'Günsonu (ID:2) Nakit', '2020-06-12 07:42:08', 1),
(4, 0, 1, 'Günsonu (ID:2) Kredi Kartı', '2020-06-12 07:42:08', 1),
(5, 0, 0, 'Günsonu (ID:3) Nakit', '2020-06-12 09:01:55', 1),
(6, 0, 1, 'Günsonu (ID:3) Kredi Kartı', '2020-06-12 09:01:55', 1),
(7, 2797, 0, 'Günsonu (ID:4) Nakit', '2020-06-13 07:30:53', 1),
(8, 0, 1, 'Günsonu (ID:4) Kredi Kartı', '2020-06-13 07:30:53', 1);

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

--
-- Table structure for table `musteriler`
--

CREATE TABLE `musteriler` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `musteriler_haraketler`
--

CREATE TABLE `musteriler_haraketler` (
  `id` int(11) NOT NULL,
  `mus_id` int(11) NOT NULL,
  `tutar` double NOT NULL,
  `order_id` int(11) NOT NULL,
  `zaman` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mutfak_log`
--

CREATE TABLE `mutfak_log` (
  `id` int(11) NOT NULL,
  `table_name` varchar(40) NOT NULL,
  `tarih` datetime NOT NULL,
  `durum` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mutfak_log_products`
--

CREATE TABLE `mutfak_log_products` (
  `id` int(11) NOT NULL,
  `mutfak_log_id` int(11) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `count` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `date_time` datetime DEFAULT NULL,
  `table_id` int(11) DEFAULT NULL,
  `finish_date_time` datetime DEFAULT NULL,
  `checkout_status` tinyint(1) DEFAULT '0',
  `payment_type` tinyint(4) NOT NULL,
  `aciklama` text NOT NULL,
  `is_sub` tinyint(1) NOT NULL DEFAULT '0',
  `garson_id` tinyint(4) DEFAULT NULL,
  `order_print_state` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id`, `day`, `date_time`, `table_id`, `finish_date_time`, `checkout_status`, `payment_type`, `aciklama`, `is_sub`, `garson_id`, `order_print_state`) VALUES
(5, 5, '2020-06-15 16:57:45', 3, NULL, 0, 0, '', 0, 9, 0),
(4, 5, '2020-06-15 16:52:19', 21, NULL, 0, 0, '', 0, 9, 0),
(6, 5, '2020-06-15 17:00:23', 22, NULL, 0, 0, '', 0, 9, 0),
(7, 5, '2020-06-15 17:10:12', 2, NULL, 0, 0, '', 0, 9, 0),
(10, 5, '2020-06-15 17:41:52', 23, NULL, 0, 0, '', 0, 9, 0),
(11, 5, '2020-06-15 17:42:55', 25, NULL, 0, 0, '', 0, 9, 0),
(12, 5, '2020-06-15 17:43:08', 24, NULL, 0, 0, '', 0, 9, 0),
(13, 5, '2020-06-15 17:49:15', 27, NULL, 0, 0, '', 0, 9, 0),
(14, 5, '2020-06-15 17:50:27', 28, NULL, 0, 0, '', 0, 9, 0),
(15, 5, '2020-06-15 17:51:27', 17, NULL, 0, 0, '', 0, 9, 0),
(16, 5, '2020-06-15 17:55:29', 12, NULL, 0, 0, '', 0, 9, 0),
(17, 5, '2020-06-17 19:27:27', 14, NULL, 0, 0, '', 0, 9, 0),
(20, 5, '2020-06-17 19:38:42', 6, NULL, 0, 0, '', 0, 9, 0),
(19, 5, '2020-06-17 19:29:27', 7, NULL, 0, 0, '', 0, 9, 0),
(21, 5, '2020-06-18 18:23:41', 16, NULL, 0, 0, '', 0, 9, 0),
(22, 5, '2020-06-18 18:27:42', 1, NULL, 0, 0, '', 0, 9, 0);

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

--
-- Table structure for table `order_detail`
--

CREATE TABLE `order_detail` (
  `id` bigint(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `product_price` double DEFAULT NULL,
  `sub_ok` tinyint(1) NOT NULL DEFAULT '0',
  `field1` text NOT NULL,
  `print` tinyint(4) NOT NULL DEFAULT '0',
  `garson_id` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `order_detail`
--

INSERT INTO `order_detail` (`id`, `product_id`, `count`, `order_id`, `product_name`, `product_price`, `sub_ok`, `field1`, `print`, `garson_id`) VALUES
(1, 3, 1, 4, 'RELAX KAHVALTI', 32, 0, '', 3, 9),
(2, 3, 1, 5, 'RELAX KAHVALTI', 32, 0, '', 3, 9),
(3, 24, 1, 4, 'SUCUKLU YUMURTA', 19, 0, '', 3, 9),
(4, 105, 1, 4, 'KAJU', 17, 0, '', 3, 9),
(5, 103, 1, 6, 'CUP PROFITEROL', 17, 0, '', 3, 9),
(6, 59, 1, 10, 'SPAGETTİ BOLOGNESE', 23, 0, '', 3, 9),
(7, 22, 1, 10, 'ÇAKALLI MENEMENİ', 18, 0, '', 3, 9),
(8, 51, 1, 11, 'ŞARKÜTERİDEN', 32, 0, '', 3, 9),
(9, 87, 1, 12, 'MY BACK STEAK', 57, 0, '', 3, 9),
(10, 119, 1, 13, 'PİNEAPPLE', 14, 0, '', 1, 9),
(11, 68, 1, 14, 'KLASİK CAESAR SALATA', 24, 0, '', 3, 9),
(12, 60, 1, 15, 'PENNE DI CARNE', 29, 0, '', 3, 9),
(13, 8, 2, 17, 'DOMATESLİ BİBERLİ TOST', 19, 0, '', 3, 9),
(14, 58, 1, 5, 'FETTUCİNNE ALFREDO', 27, 0, '', 3, 9),
(15, 60, 1, 5, 'PENNE DI CARNE', 29, 0, '', 3, 9),
(16, 12, 1, 5, 'KAŞARLI GÖZLEME', 18, 0, '', 3, 9),
(17, 22, 1, 5, 'ÇAKALLI MENEMENİ', 18, 0, '', 3, 9),
(18, 60, 1, 19, 'PENNE DI CARNE', 29, 0, '', 3, 9),
(19, 51, 1, 5, 'ŞARKÜTERİDEN', 32, 0, '', 3, 9),
(20, 52, 1, 5, 'PİZZA TONNO', 25, 0, '', 3, 9),
(21, 57, 2, 5, 'KAVURMALI CALZONE PİZZA', 35, 0, '', 3, 9),
(22, 57, 9, 5, 'KAVURMALI CALZONE PİZZA', 35, 0, '', 3, 9),
(23, 57, 1, 5, 'KAVURMALI CALZONE PİZZA', 35, 0, '', 3, 9),
(24, 57, 1, 5, 'KAVURMALI CALZONE PİZZA', 35, 0, '', 3, 9),
(25, 20, 1, 20, 'SADE OMLET', 16, 0, '', 3, 9),
(26, 14, 1, 22, 'FÜME ETLİ RULO MEKSİKA OMLET', 20, 0, '', 3, 9);

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

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `carhop` int(11) DEFAULT NULL,
  `adept` int(11) DEFAULT NULL,
  `checkout` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `name`, `carhop`, `adept`, `checkout`) VALUES
(0, 'Yeni Müşteri', 0, 0, 0),
(1, 'Giriş', 2, 1, 1),
(3, 'Gelişmiş', 5, 2, 2),
(4, 'Sınırsız', 999, 999, 999);

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `resim` text NOT NULL,
  `price` double DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `adept_id` int(11) DEFAULT '0',
  `available` int(10) UNSIGNED DEFAULT NULL,
  `stock` int(10) UNSIGNED DEFAULT '0',
  `dis_stock` tinyint(4) NOT NULL DEFAULT '0',
  `printer` tinyint(4) DEFAULT '0',
  `secmeli` varchar(100) DEFAULT NULL,
  `ust_id` int(11) DEFAULT NULL,
  `barcode` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `name`, `resim`, `price`, `group_id`, `adept_id`, `available`, `stock`, `dis_stock`, `printer`, `secmeli`, `ust_id`, `barcode`) VALUES
(2, 'VİZYONUN İLK EVRESİ 2 KİŞİLİK', '', 80, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(3, 'RELAX KAHVALTI', '', 32, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(4, 'VİSİON EKSPRES KAHVALTI', '', 22, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(5, 'KARIŞIK TOST', '', 21, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(6, 'KAŞARLI TOST', '', 18, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(7, 'YEŞİL TOST (Kepek Ekmeği)', '', 19, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(8, 'DOMATESLİ BİBERLİ TOST', '', 19, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(9, 'BAZLAMA EKMEĞİNDE KAVURMALI TOST', '', 23, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(10, 'BAZLAMA EKMEĞİNDE ŞARKÜTERİ TOST', '', 22, 1, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(11, 'KIYMALI GÖZLEME', '', 20, 3, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(12, 'KAŞARLI GÖZLEME', '', 18, 3, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(13, 'BEYAZ PEYNİRLİ GÖZLEME', '', 17, 3, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(14, 'FÜME ETLİ RULO MEKSİKA OMLET', '', 20, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(15, 'KARIŞIK OMLET', '', 18, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(16, 'SUCUKLU KAŞARLI OMLET', '', 17, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(17, 'OTLU FİRİTATA OMLET', '', 17, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(18, 'BEYAZ PEYNİR DOMATESLİ OMLET', '', 17, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(19, 'HAYAL OMLET', '', 17, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(20, 'SADE OMLET', '', 16, 4, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(21, 'BEYAZ PEYNİR DOMATESLİ OMLET - ', '', 16, 4, 0, NULL, 0, 1, 3, NULL, 18, ''),
(22, 'ÇAKALLI MENEMENİ', '', 18, 5, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(23, 'PASTIRMALI YUMURTA', '', 22, 5, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(24, 'SUCUKLU YUMURTA', '', 19, 5, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(25, 'ÇİFTGÖZ YUMURTA', '', 15, 5, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(26, 'CHICKEN TENDERS', '', 20, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(27, 'CHICKEN DORİTOS', '', 21, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(28, 'ABUR CUBUR SEPETİ', '', 26, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(29, 'CHICKEN TEMPURA', '', 20, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(30, 'ÇİN BÖREĞİ', '', 21, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(31, 'SİGARA BÖREĞİ', '', 16, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(32, 'CHEDDAR SOSLU PATATES', '', 18, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(33, 'ELMA DİLİMLİ PATATES TAVA', '', 15, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(34, 'PATATES TAVA', '', 14, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(35, 'ÇORBA', '', 10, 6, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(36, 'WRAP RAPPİN', '', 24, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(37, 'WRAP RODEO', '', 28, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(38, 'KÖFTELİ WRAP', '', 26, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(39, 'HOME MADE BURGER', '', 25, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(40, 'CHEDDAR CHESEE BURGER', '', 27, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(41, 'BBQ BURGER', '', 30, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(42, 'RANÇERO BURGER', '', 27, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(43, 'ALATURKA BURGER', '', 26, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(44, 'CHIKEN CHEDDAR BURGER', '', 23, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(45, 'BAZLAMA EKMEĞİNDE STEAK SANDVİÇ', '', 29, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(46, 'BAZLAMA EKMEĞİNDE TAVUK SANDVİÇ', '', 20, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(47, 'ETLİ QUESADİLLAS', '', 29, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(48, 'TAVUKLU QUESADİLLAS', '', 26, 7, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(49, 'MARGARİTA', '', 20, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(50, 'KAYSERİLİ PİZZA', '', 32, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(51, 'ŞARKÜTERİDEN', '', 32, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(52, 'PİZZA TONNO', '', 25, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(53, 'İSLİMİ İSLİ', '', 32, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(54, 'DÖRT DÖRTLÜK PİZZA', '', 25, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(55, 'KARIŞIK PİZZA', '', 28, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(56, 'KAVURMALI PİZZA', '', 32, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(57, 'KAVURMALI CALZONE PİZZA', '', 35, 8, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(58, 'FETTUCİNNE ALFREDO', '', 27, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(59, 'SPAGETTİ BOLOGNESE', '', 23, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(60, 'PENNE DI CARNE', '', 29, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(61, 'PENNE ARABİATTA', '', 22, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(62, 'ETLİ MAC', '', 22, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(63, 'CHICKEN MAC', '', 30, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(64, 'PASTIRMALI MAC', '', 32, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(65, 'AFFUMICATA MAC', '', 32, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(66, 'CHESE MAC', '', 32, 9, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(67, 'HARDAL SOSLU ILIK BİFTEK SALATA', '', 28, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(68, 'KLASİK CAESAR SALATA', '', 24, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(69, 'ETLİ  CAESAR SALATA', '', 28, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(70, 'IZGARA HELLİM YEŞİL SALATA', '', 24, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(71, 'TON BALIKLI SALATA', '', 24, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(72, 'KARAMELİZE KEÇİ PEYNİRLİ SALATASI', '', 26, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(73, 'ÇITIR ENGİNARLI SALATA', '', 24, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(74, 'GREEN GARDEN SALATA', '', 20, 10, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(75, 'TAVUK TALAŞ', '', 26, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(76, 'TAVUK BUTTAN IZGARA', '', 29, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(77, 'LOISIANA CHICKEN', '', 27, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(78, 'SWEET CHILI SOSLU TAVUK', '', 27, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(79, 'KÖRİLİ TAVUK', '', 27, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(80, 'FISTIK SOSLU TAVUK TALEKS', '', 28, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(81, 'TAVUK KÜLBASTI', '', 26, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(82, 'TAVUK ŞİNİTZEL', '', 27, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(83, 'JANBONLU TAVUK', '', 27, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(84, 'CAFE DE PARİS SOSLU TAVUK', '', 30, 11, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(85, 'CAFE DE PARİS SOSLU ANTRİKOT', '', 55, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(86, 'CIZLAYAN DANA LOKUM', '', 53, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(87, 'MY BACK STEAK', '', 57, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(88, 'ÇITIR SOĞANLI BİFTEK DİLİMLERİ', '', 53, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(89, 'BONFİLE NATUREL', '', 50, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(90, 'CHIMICHURRI SOSLU STEAK', '', 51, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(91, 'ŞANSÖLYE', '', 46, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(92, 'KASAP KÖFTE', '', 28, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(93, 'CHEDDAR SOSLU KASAP KÖFTE', '', 30, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(94, 'YUFKALI KÖFTE', '', 30, 12, 0, NULL, 0, 0, 0, NULL, NULL, ''),
(95, 'SAN SEBASTIAN CHESCAKE', '', 18, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(96, 'CUP PROFITEROL', '', 17, 13, 0, NULL, 0, 0, 0, NULL, NULL, ''),
(97, 'TRAMİSU CUP', '', 17, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(98, 'NUTELLALI WAFFLE', '', 20, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(99, 'MEGA WAFFLE', '', 30, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(100, 'MEYVE TABAĞI (Tek Kişilik)', '', 20, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(101, 'DUBLE MEYVE TABAĞI', '', 35, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(102, 'SERPME KURUYEMİŞ', '', 35, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(103, 'CUP PROFITEROL', '', 17, 13, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(104, 'YUFKALI KÖFTE', '', 30, 12, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(105, 'KAJU', '', 17, 27, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(106, 'ANTEP', '', 15, 27, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(107, 'FINDIK', '', 13, 27, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(108, 'BADEM', '', 13, 27, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(109, 'TUZLU FISTIK', '', 10, 27, 0, NULL, 0, 1, 3, NULL, NULL, ''),
(110, 'RED FRUİTS', '', 14, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(111, 'FİT', '', 15, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(112, 'TROPİCAL', '', 14, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(113, 'MELON', '', 14, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(114, 'LUSCİOUS', '', 14, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(115, 'SOOTHİNG', '', 14, 14, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(116, 'NUGGER', '', 14, 15, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(117, 'OREO', '', 14, 15, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(118, 'MİX', '', 14, 15, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(119, 'PİNEAPPLE', '', 14, 15, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(120, 'SAN FRANCİSCO', '', 17, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(121, 'SANGRİA', '', 17, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(122, 'VİSİON GAZOZ', '', 14, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(123, 'NOJİTO', '', 15, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(124, 'NOJİTO GREEN APPLE', '', 16, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(125, 'NOJİTO STRAWBERRY', '', 16, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(126, 'SÜRAHİ SANGRİA (4 Kişiliktir)', '', 35, 16, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(127, 'MASTİC', '', 15, 18, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(128, 'MUDSLİDE', '', 16, 18, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(129, 'BERRY BERRY', '', 15, 18, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(130, 'CLASSİC FROZEN', '', 14, 18, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(131, 'BUZLU LATTE', '', 13, 19, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(132, 'NUTELLALI BUZLU KAHVE', '', 14, 19, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(133, 'ICE MOCHA', '', 14, 19, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(134, 'BUZLU OREO KAHVE', '', 14, 19, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(135, 'TARÇINLI PORTAKALLI SOĞUK KAHVE', '', 15, 19, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(136, 'YEŞİL ŞİŞE', '', 16, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(137, 'RELAX', '', 15, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(138, 'ANTİOKSİDAN', '', 16, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(139, 'BASİL', '', 15, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(140, 'C +', '', 16, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(141, 'GRİPSAVAR', '', 15, 20, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(142, 'PORTAKAL SUYU', '', 13, 21, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(143, 'NAR SUYU', '', 14, 21, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(144, 'HAVUÇ SUYU', '', 12, 21, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(145, 'ELMA SUYU', '', 12, 21, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(146, 'SADE', '', 9, 22, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(147, 'ÇİLEKLİ', '', 10, 22, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(148, 'KİVİLİ', '', 10, 22, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(149, 'YEŞİL ELMALI', '', 10, 22, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(150, 'YABAN MERSİNİLİ', '', 11, 22, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(151, 'ÇİLEK ICE TEA', '', 9, 23, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(152, 'ŞEFTALİ ICE TEA', '', 9, 23, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(153, 'ANANAS MANGO ICE TEA', '', 9, 23, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(154, 'ÇAY', '', 4, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(155, 'ESPRESSO', '', 12, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(156, 'LATTE', '', 12.5, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(157, 'CAPPICINO', '', 13.5, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(158, 'MACCHIATO', '', 12.5, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(159, 'MOCHA', '', 14, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(160, 'WHITE CHOCOLATE MOCHA', '', 15, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(161, 'HOT CHOCOLATE', '', 13.5, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(162, 'TÜRK KAHVESİ', '', 10, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(163, 'DAMLA SAKIZ TÜRK KAHVESİ', '', 11, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(164, 'DIBEK KAHVESİ', '', 12, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(165, 'FINDIKLI TÜRK KAHVESİ', '', 12, 24, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(166, 'IHLAMUR', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(167, 'ADAÇAYI', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(168, 'NANE LİMON', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(169, 'ELMA, TARÇIN', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(170, 'PAPATYA', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(171, 'KUŞBURNU', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(172, 'YEŞİL ÇAY', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(173, 'MALVA ÇAYI', '', 13, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(174, 'KIŞ ÇAYI', '', 15, 25, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(175, 'SU', '', 3, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(176, 'SODA', '', 4, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(177, 'CHURCILL', '', 5, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(178, 'MEYVELİ SODALAR', '', 5, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(179, 'COLA', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(180, 'FANTA', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(181, 'SPRİTE', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(182, 'ICE TEA', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(183, 'SCHWEPPES', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(184, 'SAN PELIGRINO 330ml', '', 12.5, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(185, 'SAN PELIGRINO 750ml', '', 25, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(186, 'AYRAN', '', 6, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(187, 'PANCARLI AYRAN', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(188, 'FESLEĞENLİ AYRAN', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, ''),
(189, 'NANELİ AYRAN', '', 7, 26, 0, NULL, 0, 1, 1, NULL, NULL, '');

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

--
-- Table structure for table `product_group`
--

CREATE TABLE `product_group` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `resim` text NOT NULL,
  `top_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `rowno` int(10) UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_group`
--

INSERT INTO `product_group` (`id`, `name`, `resim`, `top_id`, `user_id`, `rowno`) VALUES
(1, 'KAHVALTI', '', 0, 4, 0),
(3, 'GÖZLEMELER', '', 0, 4, 1),
(4, 'OMLETLER', '', 0, 4, 2),
(5, 'SAHANLAR', '', 0, 4, 3),
(6, 'ATIŞTIRMALIKLAR', '', 0, 4, 4),
(7, 'SANDVİÇ, BURGER, VRAP', '', 0, 4, 5),
(8, 'PİZZALAR', '', 0, 4, 6),
(9, 'MAKARNALAR', '', 0, 4, 7),
(10, 'SALATALAR', '', 0, 4, 8),
(11, 'BEYAZ ETLER', '', 0, 4, 9),
(12, 'KIRMIZI ETLER', '', 0, 4, 10),
(13, 'TATLILAR', '', 0, 4, 11),
(14, 'SMOOTHİE', '', 0, 4, 13),
(15, 'MİLKSHAKE', '', 0, 4, 14),
(16, 'KOKTEYLLER', '', 0, 4, 15),
(18, 'FROZEN\'LAR', '', 0, 4, 16),
(19, 'SOĞUK KAHVELER', '', 0, 4, 17),
(20, 'DETOX', '', 0, 4, 18),
(21, 'TAZE MEYVE SULARI', '', 0, 4, 19),
(22, 'LİMONATALAR', '', 0, 4, 20),
(23, 'HOME MADE ICE TEA', '', 0, 4, 21),
(24, 'SICAK İÇECEKLER', '', 0, 4, 22),
(25, 'BİTKİ ÇAYLARI', '', 0, 4, 23),
(26, 'SOĞUK İÇECEKLER', '', 0, 4, 24),
(27, 'SEÇME KURUYEMİŞ', '', 0, 4, 12);

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

--
-- Table structure for table `section`
--

CREATE TABLE `section` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `section`
--

INSERT INTO `section` (`id`, `name`, `user_id`) VALUES
(2, 'Bahçe', 3),
(3, 'Giriş Katı', 3),
(7, 'Arka Bahçe', 3),
(11, 'Ana Bölüm', 4);

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `section_id` int(11) NOT NULL,
  `reserv` tinyint(1) NOT NULL,
  `rowno` int(10) NOT NULL,
  `ust_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tables`
--

INSERT INTO `tables` (`id`, `name`, `section_id`, `reserv`, `rowno`, `ust_id`) VALUES
(1, 'MASA 1', 11, 0, 0, 1),
(17, 'MASA 17', 11, 0, 0, 1),
(18, 'MASA 18', 11, 0, 0, 1),
(19, 'MASA 19', 11, 0, 0, 2),
(20, 'MASA 20', 11, 0, 0, 2),
(21, 'OYUN SALONU 1', 11, 0, 0, 2),
(23, 'OYUN SALONU 3', 11, 0, 0, 1),
(30, 'KAMELYA 4', 11, 0, 0, 1);

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

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

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `password` varchar(35) DEFAULT NULL,
  `package` int(11) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `mekan` varchar(70) DEFAULT NULL,
  `tel` varchar(25) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `user` (`id`, `name`, `email`, `password`, `package`, `expiration_date`, `mekan`, `tel`, `is_active`) VALUES
(4, 'MARINA', 'admin', '5dd557c53bf88049fc5eb7590e46f3e6', 1, '2014-12-04', '123456', '', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bolumler`
--
ALTER TABLE `bolumler`
  ADD UNIQUE KEY `id` (`id`);

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

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

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_relation_idx` (`user_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `table_id_relation_idx` (`table_id`);

--
-- Indexes for table `order_detail`
--
ALTER TABLE `order_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id_relation_idx` (`product_id`),
  ADD KEY `order_id_relation_idx` (`order_id`);

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

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `group_id_relation_idx` (`group_id`),
  ADD KEY `adept_id_relation_idx` (`adept_id`);

--
-- Indexes for table `product_group`
--
ALTER TABLE `product_group`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_relation_idx` (`user_id`),
  ADD KEY `top_id_relation_idx` (`top_id`);

--
-- Indexes for table `section`
--
ALTER TABLE `section`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_relation_section` (`user_id`);

--
-- Indexes for table `tables`
--
ALTER TABLE `tables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `section_id_relation_idx` (`section_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_reltion_idx` (`package`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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