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

START TRANSACTION;



--
-- Database: `dik6258_expert`
--

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

--
-- Table structure for table `belgeler`
--

CREATE TABLE `belgeler` (
  `id` int(11) NOT NULL,
  `dosya_id` text COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` text COLLATE utf8_turkish_ci NOT NULL,
  `belge` text COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `belgeler`
--

INSERT INTO `belgeler` (`id`, `dosya_id`, `aciklama`, `belge`) VALUES
(2, '2', '23423423', 'upload/fg7743'),
(3, '2', '34 4534 53445 345 ', 'upload/ty2550.png');

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

--
-- Table structure for table `dosyalar`
--

CREATE TABLE `dosyalar` (
  `id` int(11) NOT NULL,
  `tur` text COLLATE utf8_turkish_ci NOT NULL,
  `police_id` text COLLATE utf8_turkish_ci NOT NULL,
  `dosya_acilma_tarihi` date NOT NULL,
  `dosya_kapanma_tarihi` date NOT NULL,
  `durum` text COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `dosyalar`
--

INSERT INTO `dosyalar` (`id`, `tur`, `police_id`, `dosya_acilma_tarihi`, `dosya_kapanma_tarihi`, `durum`) VALUES
(2, '798789897', '2', '2018-10-11', '0000-00-00', 'acik'),
(3, '12', '2', '0000-00-00', '0012-12-12', 'acik'),
(4, '22222', '2', '0000-00-00', '1111-11-11', 'acik'),
(5, '23232', '2', '2018-10-13', '2019-10-13', 'acik');

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

--
-- Table structure for table `policeler`
--

CREATE TABLE `policeler` (
  `id` int(11) NOT NULL,
  `kisi_id` int(11) NOT NULL,
  `baslangic` date NOT NULL,
  `bitis` date NOT NULL,
  `tanzim_tarihi` date NOT NULL,
  `urun_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `policeler`
--

INSERT INTO `policeler` (`id`, `kisi_id`, `baslangic`, `bitis`, `tanzim_tarihi`, `urun_id`) VALUES
(2, 3, '2018-10-12', '2018-10-11', '2018-10-11', 1);

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

--
-- Table structure for table `raporlar`
--

CREATE TABLE `raporlar` (
  `id` int(11) NOT NULL,
  `dosya_id` text COLLATE utf8_turkish_ci NOT NULL,
  `toplam_tazminat` text COLLATE utf8_turkish_ci NOT NULL,
  `tahmini_hasar` text COLLATE utf8_turkish_ci NOT NULL,
  `hasar_tarih` date NOT NULL,
  `hasar_saat` time NOT NULL,
  `ihbar_tarihi` date NOT NULL,
  `ekspertiz_talep_tarihi` date NOT NULL,
  `gorus` text COLLATE utf8_turkish_ci NOT NULL,
  `hasar_adresi` text COLLATE utf8_turkish_ci NOT NULL,
  `hasar_il_ilce` text COLLATE utf8_turkish_ci NOT NULL,
  `rucu_imkani` text COLLATE utf8_turkish_ci NOT NULL,
  `rucu_notu` text COLLATE utf8_turkish_ci NOT NULL,
  `rucu_yorumu` text COLLATE utf8_turkish_ci NOT NULL,
  `asistan_hizmeti` text COLLATE utf8_turkish_ci NOT NULL,
  `on_ara_rapor` text COLLATE utf8_turkish_ci NOT NULL,
  `on_ara_rapor_tarih` date NOT NULL,
  `hasar_ilgi_notlar` text COLLATE utf8_turkish_ci NOT NULL,
  `faliyet_konusu` text COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `raporlar`
--

INSERT INTO `raporlar` (`id`, `dosya_id`, `toplam_tazminat`, `tahmini_hasar`, `hasar_tarih`, `hasar_saat`, `ihbar_tarihi`, `ekspertiz_talep_tarihi`, `gorus`, `hasar_adresi`, `hasar_il_ilce`, `rucu_imkani`, `rucu_notu`, `rucu_yorumu`, `asistan_hizmeti`, `on_ara_rapor`, `on_ara_rapor_tarih`, `hasar_ilgi_notlar`, `faliyet_konusu`) VALUES
(1, '', '46546', '46546', '2018-10-12', '00:20:18', '2018-10-14', '2018-10-15', 'hıuyyuyıuyıuy', 'uyıuuyıuyıuyıu', 'ıuyuıyıuuyıuy', 'ıyuıyıuyıuyıuy', 'uyyıuyıu', 'yıuyıuyıuyuuı', 'yıuyıuyıuyıuyu', '', '0000-00-00', 'ıyuyıuyıuyıyıu', ''),
(3, '2', '78789789789', '789798798', '7987-08-09', '19:51:00', '8977-07-09', '0000-00-00', '78989897897', '88797897', '987878979879', '7897878987', '78987789', '897877789', '789787', '', '0000-00-00', '878978789', '78978978978978'),
(4, '5', '12312312', '12412421412', '2018-10-13', '15:23:00', '2018-10-13', '2018-10-13', 'asdasdasdasd', 'qwewqeqweweq', 'qwrqwrqwr', 'wrqwrqwer', 'qqwqwewqew', 'qeqweqwqweq', 'wewqeqweqwe', '', '0000-00-00', 'eeqweweqwe', 'wqewqeqwewq'),
(5, '2', 'qweqweq', 'qw', '2018-10-12', '15:21:00', '2018-10-24', '0001-02-12', 'qweqweqwqe', 'qwewqeqweweq', 'qwq', 'wqw', 'qw', 'qw', 'qw', '', '0000-00-00', 'qweqwe', 'qweq');

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

--
-- Table structure for table `urunler`
--

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

--
-- Dumping data for table `urunler`
--

INSERT INTO `urunler` (`id`, `adi`, `toplam_sigorta_debeli`) VALUES
(1, 'qweqwe23', '1231232323'),
(3, 'uyıuyııu', 'u23432432'),
(4, '', '');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

