-- MyDAC version: 8.4.13
-- MySQL server version: 5.1.44-community
-- MySQL client version: 8.0.0 Direct
-- Script date 04.09.2015 11:40:33
-- ---------------------------------------------------------------------- 
-- Server: localhost
-- Database: data2015

/*!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 latin5 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 
-- User permissions
-- 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;

-- 
-- StoredProc sp_extra
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_extra $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_extra`(
        IN prm INTEGER(11),
        IN _id INTEGER(11),
        IN _personelid INTEGER(11),
        IN _tarih DATE,
        IN _tutar DECIMAL(11,2),
        IN _extraturid INTEGER(11)
    )
BEGIN
    IF prm=0 THEN
    	INSERT INTO pts_extra (personelid,tarih,tutar,extraturid) VALUES (_personelid,_tarih,_tutar,_extraturid);
    ELSE 
    	UPDATE pts_extra SET tarih=_tarih,tutar=_tutar,extraturid=_extraturid WHERE id=_id;
    END IF;
END $$
DELIMITER ;


-- 
-- StoredProc sp_extra_sil
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_extra_sil $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_extra_sil`(IN _id INTEGER(11))
BEGIN
	DELETE FROM pts_extra WHERE id = _id;
END $$
DELIMITER ;


-- 
-- StoredProc sp_giriscikis
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_giriscikis $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_giriscikis`(
        IN prm INTEGER(11),
        IN _id INTEGER(11),
        IN _personelid INTEGER(11),
        IN _giristarihi VARCHAR(11),
        IN _girissaati VARCHAR(11),
        IN _cikistarihi VARCHAR(11),
        IN _cikissaati VARCHAR(11),
        IN _ellegiris VARCHAR(1),
        IN _ellecikis VARCHAR(1)
    )
BEGIN
DECLARE _giristarihi_ DATE;
DECLARE _girissaati_ TIME;
DECLARE _cikistarihi_ DATE;
DECLARE _cikissaati_ TIME;
IF _giristarihi = '' THEN SET _giristarihi_ = NULL; ELSE SET _giristarihi_ = _giristarihi ; END IF;
IF _girissaati = '' THEN SET _girissaati_ = NULL; ELSE SET _girissaati_ = _girissaati ; END IF;
IF _cikistarihi = '' THEN SET _cikistarihi_ = NULL; ELSE SET _cikistarihi_ = _cikistarihi ; END IF;
IF _cikissaati = '' THEN SET _cikissaati_ = NULL; ELSE SET _cikissaati_ = _cikissaati ; END IF;
    IF prm=0 THEN
    	INSERT INTO pts_giriscikis (personelid,giristarihi,girissaati,cikistarihi,cikissaati,ellegiris,ellecikis,islemturu) VALUES (_personelid,_giristarihi_,_girissaati_,_cikistarihi_,_cikissaati_,_ellegiris,_ellecikis,'gc');
    ELSE 
    	UPDATE pts_giriscikis SET giristarihi=_giristarihi_,girissaati=_girissaati_,cikistarihi=_cikistarihi_,cikissaati=_cikissaati_,ellegiris=_ellegiris,ellecikis=_ellecikis WHERE id=_id;
    END IF;
END $$
DELIMITER ;


-- 
-- StoredProc sp_giriscikis1
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_giriscikis1 $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_giriscikis1`(
        IN prm INTEGER(11),
        IN _id INTEGER(11),
        IN _personelid INTEGER(11),
        IN _giristarihi VARCHAR(11),
        IN _girissaati VARCHAR(11),
        IN _cikistarihi VARCHAR(11),
        IN _cikissaati VARCHAR(11),
        IN _ellegiris VARCHAR(1),
        IN _ellecikis VARCHAR(1)
    )
BEGIN
DECLARE _giristarihi_ DATE;
DECLARE _girissaati_ TIME;
DECLARE _cikistarihi_ DATE;
DECLARE _cikissaati_ TIME;
IF _giristarihi = '' THEN SET _giristarihi_ = NULL; ELSE SET _giristarihi_ = _giristarihi ; END IF;
IF _girissaati = '' THEN SET _girissaati_ = NULL; ELSE SET _girissaati_ = _girissaati ; END IF;
IF _cikistarihi = '' THEN SET _cikistarihi_ = NULL; ELSE SET _cikistarihi_ = _cikistarihi ; END IF;
IF _cikissaati = '' THEN SET _cikissaati_ = NULL; ELSE SET _cikissaati_ = _cikissaati ; END IF;
    IF prm=0 THEN
    	INSERT INTO pts_giriscikis1 (personelid,giristarihi,girissaati,cikistarihi,cikissaati,ellegiris,ellecikis,islemturu) VALUES (_personelid,_giristarihi_,_girissaati_,_cikistarihi_,_cikissaati_,_ellegiris,_ellecikis,'gc');
    ELSE 
    	UPDATE pts_giriscikis1 SET giristarihi=_giristarihi_,girissaati=_girissaati_,cikistarihi=_cikistarihi_,cikissaati=_cikissaati_,ellegiris=_ellegiris,ellecikis=_ellecikis WHERE id=_id;
    END IF;
END $$
DELIMITER ;


-- 
-- StoredProc sp_giriscikis1_sil
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_giriscikis1_sil $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_giriscikis1_sil`(
        IN _id INTEGER(11)
    )
BEGIN
	DELETE FROM pts_giriscikis1 WHERE id = _id;
END $$
DELIMITER ;


-- 
-- StoredProc sp_giriscikis_sil
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_giriscikis_sil $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_giriscikis_sil`(IN _id INTEGER(11))
BEGIN
	DELETE FROM pts_giriscikis WHERE id = _id;
END $$
DELIMITER ;


-- 
-- StoredProc sp_gunparametre
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_gunparametre $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_gunparametre`(
        IN _grupid INTEGER(11),
        IN _altgrupid INTEGER(11)
,
        IN _g1 VARCHAR(11),
        IN _g2 VARCHAR(11),
        IN _g3 VARCHAR(11),
        IN _g4 VARCHAR(11),
        IN _g5 VARCHAR(11),
        IN _g6 VARCHAR(11),
        IN _g7 VARCHAR(11),
        IN _apptask VARCHAR(10)
    )
BEGIN
DECLARE SAYI INT DEFAULT 0;

DECLARE _g1_ INT;
DECLARE _g2_ INT;
DECLARE _g3_ INT;
DECLARE _g4_ INT;
DECLARE _g5_ INT;
DECLARE _g6_ INT;
DECLARE _g7_ INT;

IF _g1 = '' THEN SET _g1_ = NULL; ELSE SET _g1_ = _g1 ; END IF;
IF _g2 = '' THEN SET _g2_ = NULL; ELSE SET _g2_ = _g2 ; END IF;
IF _g3 = '' THEN SET _g3_ = NULL; ELSE SET _g3_ = _g3 ; END IF;
IF _g4 = '' THEN SET _g4_ = NULL; ELSE SET _g4_ = _g4 ; END IF;
IF _g5 = '' THEN SET _g5_ = NULL; ELSE SET _g5_ = _g5 ; END IF;
IF _g6 = '' THEN SET _g6_ = NULL; ELSE SET _g6_ = _g6 ; END IF;
IF _g7 = '' THEN SET _g7_ = NULL; ELSE SET _g7_ = _g7 ; END IF;

	SELECT COUNT(altgrupid) INTO SAYI FROM pts_gunparametre WHERE grupid =_grupid and altgrupid =_altgrupid and appTask=_apptask;

    IF SAYI=0 THEN
		INSERT INTO pts_gunparametre (grupid,altgrupid,g1,g2,g3,g4,g5,g6,g7,appTask) VALUES 
      (_grupid,_altgrupid,_g1_,_g2_,_g3_,_g4_,_g5_,_g6_,_g7_,_apptask);
      
   ELSE   
      UPDATE pts_gunparametre SET g1=_g1_,g2=_g2_,g3=_g3_,g4=_g4_,g5=_g5_,g6=_g6_,g7=_g7_,appTask=_apptask WHERE grupid =_grupid and altgrupid=_altgrupid;	

   END IF;
END $$
DELIMITER ;


-- 
-- StoredProc sp_izin
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_izin $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_izin`(
        IN prm INTEGER(11),
        IN _id INTEGER(11),
        IN _personelid INTEGER(11),
        IN _giristarihi VARCHAR(11),
        IN _girissaati VARCHAR(11),
        IN _cikistarihi VARCHAR(11),
        IN _cikissaati VARCHAR(11),
        IN _izintipi VARCHAR(10),
        IN _izinturid INTEGER(11)
    )
BEGIN
DECLARE _giristarihi_ DATE;
DECLARE _girissaati_ TIME;
DECLARE _cikistarihi_ DATE;
DECLARE _cikissaati_ TIME;
IF _giristarihi = '' THEN SET _giristarihi_ = NULL; ELSE SET _giristarihi_ = _giristarihi ; END IF;
IF _girissaati = '' THEN SET _girissaati_ = NULL; ELSE SET _girissaati_ = _girissaati ; END IF;
IF _cikistarihi = '' THEN SET _cikistarihi_ = NULL; ELSE SET _cikistarihi_ = _cikistarihi ; END IF;
IF _cikissaati = '' THEN SET _cikissaati_ = NULL; ELSE SET _cikissaati_ = _cikissaati ; END IF;
    IF prm=0 THEN
    	INSERT INTO pts_giriscikis (personelid,giristarihi,girissaati,cikistarihi,cikissaati,izintipi,izinturid,islemturu) VALUES (_personelid,_giristarihi_,_girissaati_,_cikistarihi_,_cikissaati_,_izintipi,_izinturid,'iz');
    ELSE 
    	UPDATE pts_giriscikis SET giristarihi=_giristarihi_,girissaati=_girissaati_,cikistarihi=_cikistarihi_,cikissaati=_cikissaati_,izintipi=_izintipi,izinturid=_izinturid WHERE id=_id;
    END IF;
END $$
DELIMITER ;


-- 
-- StoredProc sp_izin_sil
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_izin_sil $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_izin_sil`(IN _id INTEGER(11))
BEGIN
	DELETE FROM pts_izin WHERE id = _id;
END $$
DELIMITER ;


-- 
-- StoredProc sp_personel
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_personel $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_personel`(
        IN `islem` SMALLINT,
        IN `_id` BIGINT,
        IN `_kartfc` VARCHAR(3),
        IN `_kartno` VARCHAR(5),
        IN `_kartid` VARCHAR(10),
        IN `_ad` VARCHAR(60) CHARSET latin5,
        IN `_soyad` VARCHAR(60) CHARSET latin5,
        IN `_sicilno` VARCHAR(30),
        IN `_firmaid` VARCHAR(11),
        IN `_grupid` VARCHAR(11),
        IN `_bolumid` VARCHAR(11),
        IN `_gorevid` VARCHAR(11),
        IN `_servisid` VARCHAR(11),
        IN `_bolgeid` VARCHAR(11),
        IN `_durum` VARCHAR(11) CHARSET latin5,
        IN `_isegiristarihi` VARCHAR(11),
        IN `_istencikistarihi` VARCHAR(11),
        IN `_istenayrilmanedeni` LONGTEXT,
        IN `_ucret` VARCHAR(20),
        IN `_brutucret` VARCHAR(20),
        IN `_ucrettipi` VARCHAR(20),
        IN `_yolucreti` VARCHAR(20),
        IN `_yemekucreti` VARCHAR(20),
        IN `_primucreti` VARCHAR(20),
        IN `_evtel` VARCHAR(20),
        IN `_ceptel` VARCHAR(20),
        IN `_istel` VARCHAR(20),
        IN `_egitim` VARCHAR(20) CHARSET latin5,
        IN `_yabancidil` VARCHAR(20) CHARSET latin5,
        IN `_askerlikdurumu` VARCHAR(20) CHARSET latin5,
        IN `_gozluk` VARCHAR(20),
        IN `_sabika` VARCHAR(20),
        IN `_kilo` VARCHAR(20),
        IN `_boy` VARCHAR(20),
        IN `_ayak` VARCHAR(20),
        IN `_pan` VARCHAR(20),
        IN `_medenihali` VARCHAR(20) CHARSET latin5,
        IN `_cocuksayisi` VARCHAR(20),
        IN `_esdurumu` VARCHAR(10) CHARSET latin5,
        IN `_adres` LONGTEXT CHARSET latin5,
        IN `_kimlikno` VARCHAR(30),
        IN `_babaad` VARCHAR(30) CHARSET latin5,
        IN `_annead` VARCHAR(30) CHARSET latin5,
        IN `_dogumyeri` VARCHAR(30) CHARSET latin5,
        IN `_dogumtarihi` VARCHAR(20),
        IN `_kangrubu` VARCHAR(10),
        IN `_uyruk` VARCHAR(20) CHARSET latin5,
        IN `_cinsiyet` VARCHAR(20) CHARSET latin5,
        IN `_nufus_il` VARCHAR(30) CHARSET latin5,
        IN `_nufus_ilce` VARCHAR(30) CHARSET latin5,
        IN `_nufus_mahkoy` VARCHAR(30) CHARSET latin5,
        IN `_nufus_ciltno` VARCHAR(30),
        IN `_nufus_ailesirano` VARCHAR(30),
        IN `_nufus_sirano` VARCHAR(30),
        IN `_sgk_no` VARCHAR(30),
        IN `_sgk_isegiristarihi` VARCHAR(20),
        IN `_banka_subeadi` VARCHAR(60) CHARSET latin5,
        IN `_banka_hesapno` VARCHAR(60) CHARSET latin5,
        IN `_ehliyet_sinif` VARCHAR(20),
        IN `_ehliyet_verililce` VARCHAR(30) CHARSET latin5,
        IN `_ehliyet_belgeno` VARCHAR(30),
        IN `_ehliyet_vertarih` VARCHAR(20),
        IN `_ehliyet_kulcihazprotez` VARCHAR(100) CHARSET latin5,
        IN `_yolucrettipi` VARCHAR(10) CHARSET latin5,
        IN `_yemekucrettipi` VARCHAR(10) CHARSET latin5,
        IN `_primucrettipi` VARCHAR(10) CHARSET latin5,
        IN `_vergino` VARCHAR(10) CHARSET latin5,
        IN `_email` VARCHAR(60) CHARSET latin5,
        IN `_webadres` VARCHAR(150) CHARSET latin5
    )
BEGIN

DECLARE SAYI BIGINT DEFAULT 0;

DECLARE _sicilno_ VARCHAR(30);
DECLARE _isegiristarihi_ DATE;
DECLARE _istencikistarihi_ DATE;
DECLARE _sgk_isegiristarihi_ DATE;
DECLARE _ehliyet_vertarih_ DATE;
DECLARE _dogumtarihi_ DATE;
DECLARE _firmaid_ integer;DECLARE _grupid_ integer;DECLARE _bolumid_ integer;DECLARE _gorevid_ integer;DECLARE _servisid_ integer; DECLARE _bolgeid_ integer;
DECLARE _ucret_ DECIMAL(11,2); DECLARE _brutucret_ DECIMAL(11,2); DECLARE _ucrettipi_ VARCHAR(20); DECLARE _yolucreti_ DECIMAL(11,2); DECLARE _yemekucreti_ DECIMAL(11,2); DECLARE _primucreti_ DECIMAL(11,2);
DECLARE _kilo_ DECIMAL(11,2);DECLARE _boy_ DECIMAL(11,2);DECLARE _ayak_ DECIMAL(11,2);DECLARE _pan_ DECIMAL(11,2);
DECLARE _cocuksayisi_ INT;	
    IF _sicilno = '' THEN  SET _sicilno_= NULL; ELSE SET _sicilno_= _sicilno; END IF;
    IF _isegiristarihi = '' THEN  SET _isegiristarihi_= NULL; ELSE SET _isegiristarihi_= _isegiristarihi; END IF;
	IF _istencikistarihi = '' THEN  SET _istencikistarihi_= NULL; ELSE SET _istencikistarihi_= _istencikistarihi; END IF;
	IF _sgk_isegiristarihi = '' THEN  SET _sgk_isegiristarihi_= NULL; ELSE SET _sgk_isegiristarihi_= _sgk_isegiristarihi; END IF;
	IF _ehliyet_vertarih = '' THEN  SET _ehliyet_vertarih_= NULL; ELSE SET _ehliyet_vertarih_= _ehliyet_vertarih; END IF;
	IF _firmaid = '' THEN  SET _firmaid_= NULL; ELSE SET _firmaid_= _firmaid; END IF;
	IF _grupid = '' THEN  SET _grupid_= NULL; ELSE SET _grupid_= _grupid; END IF;
    IF _servisid = '' THEN  SET _servisid_= NULL; ELSE SET _servisid_= _servisid; END IF;
	IF _bolumid = '' THEN  SET _bolumid_= NULL; ELSE SET _bolumid_= _bolumid; END IF;
	IF _gorevid = '' THEN  SET _gorevid_= NULL; ELSE SET _gorevid_= _gorevid; END IF;
    IF _bolgeid = '' THEN  SET _bolgeid_= NULL; ELSE SET _bolgeid_= _bolgeid; END IF;
	IF _ucret = '' THEN  SET _ucret_= NULL; ELSE SET _ucret_= _ucret; END IF;
	IF _brutucret = '' THEN  SET _brutucret_= NULL; ELSE SET _brutucret_= _brutucret; END IF;
	IF _ucrettipi = '' THEN  SET _ucrettipi_= NULL; ELSE SET _ucrettipi_= _ucrettipi; END IF;
	IF _yolucreti = '' THEN  SET _yolucreti_= NULL; ELSE SET _yolucreti_= _yolucreti; END IF;
	IF _yemekucreti = '' THEN  SET _yemekucreti_= NULL; ELSE SET _yemekucreti_= _yemekucreti; END IF;
	IF _primucreti = '' THEN  SET _primucreti_= NULL; ELSE SET _primucreti_= _primucreti; END IF;
    
    IF _kilo = '' THEN  SET _kilo_= NULL; ELSE SET _kilo_= _kilo; END IF;
    IF _boy = '' THEN  SET _boy_= NULL; ELSE SET _boy_= _boy; END IF;
    IF _ayak = '' THEN  SET _ayak_= NULL; ELSE SET _ayak_= _ayak; END IF;
    IF _pan = '' THEN  SET _pan_= NULL; ELSE SET _pan_= _pan; END IF;
    IF _cocuksayisi = '' THEN  SET _cocuksayisi_= NULL; ELSE SET _cocuksayisi_= _cocuksayisi; END IF;
    IF _dogumtarihi = '' THEN  SET _dogumtarihi_= NULL; ELSE SET _dogumtarihi_= _dogumtarihi; END IF;
    
CASE islem
WHEN 1 THEN 
	INSERT INTO personel (kartfc,kartno,kartid,ad,soyad,sicilno,firmaid,grupid,bolumid,gorevid,servisid,bolgeid,durum,isegiristarihi,istencikistarihi,istenayrilmanedeni,ucret,brutucret,ucrettipi,yolucreti,yemekucreti,primucreti,evtel,ceptel,istel,egitim,yabancidil,askerlikdurumu,gozluk,sabika,kilo,boy,ayak,pan,medenihali,cocuksayisi,esdurumu,
				adres,kimlikno,babaad,annead,dogumyeri,dogumtarihi,kangrubu,uyruk,cinsiyet,nufus_il,nufus_ilce,nufus_mahkoy,
				nufus_ciltno,nufus_ailesirano,nufus_sirano,sgk_no,sgk_isegiristarihi,banka_subeadi,banka_hesapno,
				ehliyet_sinif,ehliyet_verililce,ehliyet_belgeno,ehliyet_vertarih,ehliyet_kulcihazprotez,personelturu,yolucrettipi,yemekucrettipi,primucrettipi,vergino,email,webadres) 
    VALUES 
		(_kartfc,_kartno,_kartid,_ad,_soyad,_sicilno_,_firmaid_,_grupid_,_bolumid_,_gorevid_,_servisid_,_bolgeid_,_durum,_isegiristarihi_,_istencikistarihi_,_istenayrilmanedeni,_ucret_,_brutucret_,_ucrettipi_,_yolucreti_,_yemekucreti_,_primucreti_,_evtel,_ceptel,_istel,_egitim,_yabancidil,_askerlikdurumu,_gozluk,_sabika,_kilo_,_boy_,_ayak_,_pan_,_medenihali,_cocuksayisi_,_esdurumu,
			       _adres,_kimlikno,_babaad,_annead,_dogumyeri,_dogumtarihi_,_kangrubu,_uyruk,_cinsiyet,_nufus_il,_nufus_ilce,_nufus_mahkoy,
      			       _nufus_ciltno,_nufus_ailesirano,_nufus_sirano,_sgk_no,_sgk_isegiristarihi_,_banka_subeadi,_banka_hesapno,
			_ehliyet_sinif,_ehliyet_verililce,_ehliyet_belgeno,_ehliyet_vertarih_,_ehliyet_kulcihazprotez,'personel',_yolucrettipi,_yemekucrettipi,_primucrettipi,_vergino,_email,_webadres);
            
WHEN 2 THEN 
		UPDATE personel SET kartfc=_kartfc,kartno=_kartno,kartid=_kartid,ad=_ad,soyad=_soyad,sicilno=_sicilno_,
   		firmaid=_firmaid_,grupid=_grupid_,bolumid=_bolumid_,gorevid=_gorevid_,servisid=_servisid_,bolgeid=_bolgeid_,
        durum=_durum,isegiristarihi=_isegiristarihi_,istencikistarihi=_istencikistarihi_,istenayrilmanedeni=_istenayrilmanedeni,ucret= _ucret_ ,
        brutucret=_brutucret_,ucrettipi=_ucrettipi_,yolucreti=_yolucreti_,yemekucreti=_yemekucreti_,primucreti=_primucreti_,
        evtel=_evtel,ceptel= _ceptel,istel= _istel, egitim= _egitim,yabancidil= _yabancidil,askerlikdurumu= _askerlikdurumu,gozluk= _gozluk,sabika= _sabika,
   		kilo= _kilo_ ,boy= _boy_ ,ayak= _ayak_ ,pan= _pan_ , medenihali=_medenihali,cocuksayisi=_cocuksayisi_,esdurumu= _esdurumu, adres=_adres,kimlikno= _kimlikno,
   		babaad=_babaad, annead=_annead ,dogumyeri= _dogumyeri ,dogumtarihi= _dogumtarihi_,kangrubu= _kangrubu,uyruk= _uyruk,cinsiyet= _cinsiyet ,nufus_il= _nufus_il ,
   		nufus_ilce =_nufus_ilce ,nufus_mahkoy= _nufus_mahkoy ,nufus_ciltno= _nufus_ciltno,nufus_ailesirano= _nufus_ailesirano ,nufus_sirano= _nufus_sirano ,sgk_no=_sgk_no ,
   		sgk_isegiristarihi=_sgk_isegiristarihi_,banka_subeadi= _banka_subeadi, banka_hesapno=_banka_hesapno ,ehliyet_sinif= _ehliyet_sinif,ehliyet_verililce=_ehliyet_verililce,
   		ehliyet_belgeno=_ehliyet_belgeno,ehliyet_vertarih= _ehliyet_vertarih_,ehliyet_kulcihazprotez=_ehliyet_kulcihazprotez,
        yolucrettipi=_yolucrettipi,yemekucrettipi=_yemekucrettipi,primucrettipi=_primucrettipi,vergino=_vergino,email=_email,webadres=_webadres
   		WHERE id=_id;
        
WHEN 3 THEN DELETE FROM personel WHERE id = _id;
ELSE SELECT 'Hatali Islem';
END CASE;
  
END $$
DELIMITER ;


-- 
-- StoredProc sp_personel_sil
-- 

DELIMITER $$
DROP PROCEDURE IF EXISTS sp_personel_sil $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_personel_sil`(IN `_id` BIGINT)
BEGIN
	DELETE FROM personel WHERE id = _id;
END $$
DELIMITER ;


-- 
-- Table structure for table birim
-- 

DROP TABLE IF EXISTS birim;
CREATE TABLE `birim` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table birim
-- 

-- 
-- Table structure for table bolge
-- 

DROP TABLE IF EXISTS bolge;
CREATE TABLE `bolge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table bolge
-- 

-- 
-- Table structure for table bolum
-- 

DROP TABLE IF EXISTS bolum;
CREATE TABLE `bolum` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table bolum
-- 

-- 
-- Table structure for table der_bolum
-- 

DROP TABLE IF EXISTS der_bolum;
CREATE TABLE `der_bolum` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(20) DEFAULT NULL,
  `ad` varchar(200) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_bolum
-- 

-- 
-- Table structure for table der_brans
-- 

DROP TABLE IF EXISTS der_brans;
CREATE TABLE `der_brans` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_brans
-- 

-- 
-- Table structure for table der_ders
-- 

DROP TABLE IF EXISTS der_ders;
CREATE TABLE `der_ders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_ders
-- 

-- 
-- Table structure for table der_dersane
-- 

DROP TABLE IF EXISTS der_dersane;
CREATE TABLE `der_dersane` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  `adres` longtext,
  `tel` varchar(60) DEFAULT NULL,
  `fax` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_dersane
-- 

-- 
-- Table structure for table der_giris
-- 

DROP TABLE IF EXISTS der_giris;
CREATE TABLE `der_giris` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_giris
-- 

-- 
-- Table structure for table der_grup
-- 

DROP TABLE IF EXISTS der_grup;
CREATE TABLE `der_grup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(200) DEFAULT '0',
  `pztg` time DEFAULT NULL,
  `pztc` time DEFAULT NULL,
  `salg` time DEFAULT NULL,
  `salc` time DEFAULT NULL,
  `carg` time DEFAULT NULL,
  `carc` time DEFAULT NULL,
  `perg` time DEFAULT NULL,
  `perc` time DEFAULT NULL,
  `cumg` time DEFAULT NULL,
  `cumc` time DEFAULT NULL,
  `cmtg` time DEFAULT NULL,
  `cmtc` time DEFAULT NULL,
  `pazg` time DEFAULT NULL,
  `pazc` time DEFAULT NULL,
  `g1` tinyint(1) DEFAULT '0',
  `g2` tinyint(1) DEFAULT '0',
  `g3` tinyint(1) DEFAULT '0',
  `g4` tinyint(1) DEFAULT '0',
  `g5` tinyint(1) DEFAULT '0',
  `g6` tinyint(1) DEFAULT '0',
  `g7` tinyint(1) DEFAULT '0',
  `aciklama` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_grup
-- 

-- 
-- Table structure for table der_sinavnotlari
-- 

DROP TABLE IF EXISTS der_sinavnotlari;
CREATE TABLE `der_sinavnotlari` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `sinavadi` varchar(150) DEFAULT NULL,
  `sayisal` int(11) DEFAULT NULL,
  `sozel` int(11) DEFAULT NULL,
  `esitagirlik` int(11) DEFAULT NULL,
  `yabancidil` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_sinavnotlari
-- 

-- 
-- Table structure for table der_sinif
-- 

DROP TABLE IF EXISTS der_sinif;
CREATE TABLE `der_sinif` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(20) DEFAULT NULL,
  `ad` varchar(200) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_sinif
-- 

-- 
-- Table structure for table der_tempgc
-- 

DROP TABLE IF EXISTS der_tempgc;
CREATE TABLE `der_tempgc` (
  `kartno` varchar(5) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  `soyad` varchar(60) DEFAULT NULL,
  `ogrenci_veliad` varchar(60) DEFAULT NULL,
  `ogrenci_veliceptel` varchar(60) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table der_tempgc
-- 

-- 
-- Table structure for table dil
-- 

DROP TABLE IF EXISTS dil;
CREATE TABLE `dil` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table dil
-- 

-- 
-- Table structure for table egitim
-- 

DROP TABLE IF EXISTS egitim;
CREATE TABLE `egitim` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table egitim
-- 

-- 
-- Table structure for table firma
-- 

DROP TABLE IF EXISTS firma;
CREATE TABLE `firma` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  `adres` longtext,
  `tel` varchar(60) DEFAULT NULL,
  `fax` varchar(60) DEFAULT NULL,
  `vergidaire` varchar(300) DEFAULT NULL,
  `vergino` varchar(60) DEFAULT NULL,
  `sgk_no` varchar(60) DEFAULT NULL,
  `il` varchar(60) DEFAULT NULL,
  `ilce` varchar(60) DEFAULT NULL,
  `yetkili` varchar(100) DEFAULT NULL,
  `yetkiliceptel` varchar(20) DEFAULT NULL,
  `secim` tinyint(1) DEFAULT '0',
  `kontrolno` varchar(20) DEFAULT '0',
  `aracino` varchar(20) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table firma
-- 

LOCK TABLES firma WRITE;
INSERT INTO firma VALUES
 (4,NULL,'Genel','','','','','','',NULL,NULL,NULL,NULL,0,'0','0');
UNLOCK TABLES;

-- 
-- Table structure for table gc_giriscikis
-- 

DROP TABLE IF EXISTS gc_giriscikis;
CREATE TABLE `gc_giriscikis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(5) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  `kapino` int(11) DEFAULT NULL,
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  `giristerminal` varchar(60) DEFAULT NULL,
  `cikisterminal` varchar(60) DEFAULT NULL,
  `kapiterminalkod` varchar(10) DEFAULT NULL,
  `girisyetkiliid` bigint(20) DEFAULT NULL,
  `cikisyetkiliid` bigint(20) DEFAULT NULL,
  `kapiterminalid` int(11) DEFAULT NULL,
  `girissaati1` time DEFAULT NULL,
  `cikissaati1` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gc_giriscikis
-- 

-- 
-- Table structure for table gc_giriscikis1
-- 

DROP TABLE IF EXISTS gc_giriscikis1;
CREATE TABLE `gc_giriscikis1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(5) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  `giristerminal` varchar(60) DEFAULT NULL,
  `cikisterminal` varchar(60) DEFAULT NULL,
  `kapino` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gc_giriscikis1
-- 

-- 
-- Table structure for table gc_giriscikis2
-- 

DROP TABLE IF EXISTS gc_giriscikis2;
CREATE TABLE `gc_giriscikis2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(5) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  `giristerminal` varchar(60) DEFAULT NULL,
  `cikisterminal` varchar(60) DEFAULT NULL,
  `kapino` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gc_giriscikis2
-- 

-- 
-- Table structure for table gecisgrup
-- 

DROP TABLE IF EXISTS gecisgrup;
CREATE TABLE `gecisgrup` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `gecisyetkisi` varchar(20) DEFAULT NULL,
  `surekisitlama` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gecisgrup
-- 

LOCK TABLES gecisgrup WRITE;
INSERT INTO gecisgrup VALUES
 (7,'geçiş grup 1','Normal Gecis',0);
UNLOCK TABLES;

-- 
-- Table structure for table gecisgrupalt
-- 

DROP TABLE IF EXISTS gecisgrupalt;
CREATE TABLE `gecisgrupalt` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gecisgrupid` bigint(20) unsigned NOT NULL,
  `zamanbolgeid` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gecisgrupalt
-- 

LOCK TABLES gecisgrupalt WRITE;
INSERT INTO gecisgrupalt VALUES
 (17,7,1),
 (18,7,2);
UNLOCK TABLES;

-- 
-- Table structure for table gorev
-- 

DROP TABLE IF EXISTS gorev;
CREATE TABLE `gorev` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table gorev
-- 

-- 
-- Table structure for table grup
-- 

DROP TABLE IF EXISTS grup;
CREATE TABLE `grup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `gunluksaat` varchar(6) DEFAULT NULL,
  `donemliksaat` varchar(6) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  `secim` tinyint(1) DEFAULT NULL,
  `mesaidonemliksaat` varchar(6) DEFAULT NULL,
  `donemliksaat1` varchar(6) DEFAULT NULL,
  `htkkullan` tinyint(1) DEFAULT '0',
  `hitkullan` tinyint(1) DEFAULT '0',
  `haftatatilibordroid` int(11) DEFAULT NULL,
  `haftatailibordroid` int(11) DEFAULT NULL,
  `donemhesaptipi` varchar(10) DEFAULT NULL,
  `ucrethesaptipi` varchar(10) DEFAULT NULL,
  `cmtaktarma` tinyint(1) DEFAULT '0',
  `pazaktarma` tinyint(1) DEFAULT '0',
  `httamamla` tinyint(1) DEFAULT '0' COMMENT 'perakende sektoru icin gelmedigi gunlere hafta tatili ver',
  `calisma4izin2` tinyint(1) DEFAULT '0' COMMENT '4 gun calisip 2 gun izin kullananlar',
  `donemtamamlasonramesaiver` tinyint(1) DEFAULT '0' COMMENT 'donemdeki nc yi tamamlar fazlasını kod=2ye mesai verir',
  `terminalgrupkodu` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table grup
-- 

LOCK TABLES grup WRITE;
INSERT INTO grup VALUES
 (11,'MESAİLİ GRUP',NULL,'270:00','gayriresmi',NULL,NULL,NULL,0,0,NULL,NULL,'30gun','saatlik',0,0,0,0,0,NULL),
 (12,'VARDİYALI 3',NULL,'225:00','gayriresmi',NULL,NULL,NULL,0,0,NULL,NULL,'30gun','saatlik',0,0,0,0,0,NULL),
 (13,'VARDİYALI 2',NULL,'240:00','gayriresmi',NULL,NULL,NULL,0,0,NULL,NULL,'30gun','saatlik',0,0,0,0,0,NULL),
 (14,'İDARİ',NULL,'225:00','gayriresmi',NULL,NULL,NULL,0,0,NULL,NULL,'30gun','saatlik',0,0,0,0,0,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table il
-- 

DROP TABLE IF EXISTS il;
CREATE TABLE `il` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` int(11) DEFAULT NULL,
  `ad` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table il
-- 

LOCK TABLES il WRITE;
INSERT INTO il VALUES
 (1,1,'Adana'),
 (2,2,'Adıyaman'),
 (3,3,'Afyon'),
 (4,4,'Ağrı'),
 (5,5,'Amasya'),
 (6,6,'Ankara'),
 (7,7,'Antalya'),
 (8,8,'Artvin'),
 (9,9,'Aydın'),
 (10,10,'Balıkesir'),
 (11,11,'Bilecik'),
 (12,12,'Bingöl'),
 (13,13,'Bitlis'),
 (14,14,'Bolu'),
 (15,15,'Burdur'),
 (16,16,'Bursa'),
 (17,17,'Çanakkale'),
 (18,18,'Çankırı'),
 (19,19,'Çorum'),
 (20,20,'Denizli'),
 (21,21,'Diyarbakır'),
 (22,22,'Edirne'),
 (23,23,'Elazığ'),
 (24,24,'Erzincan'),
 (25,25,'Erzurum'),
 (26,26,'Eskişehir'),
 (27,27,'Gaziantep'),
 (28,28,'Giresun'),
 (29,29,'Gümüşhane'),
 (30,30,'Hakkari'),
 (31,31,'Hatay'),
 (32,32,'Isparta'),
 (33,33,'İçel'),
 (34,34,'İstanbul'),
 (35,35,'İzmir'),
 (36,36,'Kars'),
 (37,37,'Kastamonu'),
 (38,38,'Kayseri'),
 (39,39,'Kırklareli'),
 (40,40,'Kırşehir'),
 (41,41,'Kocaeli'),
 (42,42,'Konya'),
 (43,43,'Kütahya'),
 (44,44,'Malatya'),
 (45,45,'Manisa'),
 (46,46,'K.Maraş'),
 (47,47,'Mardin'),
 (48,48,'Muğla'),
 (49,49,'Muş'),
 (50,50,'Nevşehir'),
 (51,51,'Niğde'),
 (52,52,'Ordu'),
 (53,53,'Rize'),
 (54,54,'Sakarya'),
 (55,55,'Samsun'),
 (56,56,'Siirt'),
 (57,57,'Sinop'),
 (58,58,'Sivas'),
 (59,59,'Tekirdağ'),
 (60,60,'Tokat'),
 (61,61,'Trabzon'),
 (62,62,'Tunceli'),
 (63,63,'Şanlıurfa'),
 (64,64,'Uşak'),
 (65,65,'Van'),
 (66,66,'Yozgat'),
 (67,67,'Zonguldak'),
 (68,68,'Aksaray'),
 (69,69,'Bayburt'),
 (70,70,'Karaman'),
 (71,71,'Kırıkkale'),
 (72,72,'Batman'),
 (73,73,'Şırnak'),
 (74,74,'Bartın'),
 (75,75,'Ardahan'),
 (76,76,'Iğdır'),
 (77,77,'Yalova'),
 (78,78,'Karabük'),
 (79,79,'Kilis'),
 (80,80,'Osmaniye'),
 (81,81,'Düzce');
UNLOCK TABLES;

-- 
-- Table structure for table ilce
-- 

DROP TABLE IF EXISTS ilce;
CREATE TABLE `ilce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ilkod` int(11) DEFAULT NULL,
  `kod` int(11) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=944 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table ilce
-- 

LOCK TABLES ilce WRITE;
INSERT INTO ilce VALUES
 (1,1,0,'MERKEZ'),
 (2,1,20,'ALADAG'),
 (3,1,28,'CEYHAN'),
 (4,1,36,'FEKE'),
 (5,1,40,'IMAMOGLU'),
 (6,1,48,'KARAISALI'),
 (7,1,52,'KARATAS'),
 (8,1,56,'KOZAN'),
 (9,1,64,'POZANTI'),
 (10,1,68,'SAIMBEYLI'),
 (11,1,72,'SEYHAN'),
 (12,1,76,'TUFANBEYLI'),
 (13,1,80,'YUMURTALIK'),
 (14,1,84,'YÜREGIR'),
 (15,2,0,'MERKEZ'),
 (16,2,20,'BESNI'),
 (17,2,25,'ÇELIKHAN'),
 (18,2,30,'GERGER'),
 (19,2,35,'GÖLBASI'),
 (20,2,40,'KAHTA'),
 (21,2,45,'SAMSAT'),
 (22,2,50,'SINCIK'),
 (23,2,55,'TUT'),
 (24,3,0,'MERKEZ'),
 (25,3,20,'BASMAKÇI'),
 (26,3,24,'BAYAT'),
 (27,3,28,'BOLVADIN'),
 (28,3,32,'ÇOBANLAR'),
 (29,3,36,'ÇAY'),
 (30,3,40,'DAZKIRI'),
 (31,3,44,'DINAR'),
 (32,3,48,'EMIRDAG'),
 (33,3,52,'EVCILER'),
 (34,3,56,'HOCALAR'),
 (35,3,60,'IHSANIYE'),
 (36,3,64,'ISCEHISAR'),
 (37,3,68,'KIZILÖREN'),
 (38,3,72,'SANDIKLI'),
 (39,3,76,'SINCANLI'),
 (40,3,80,'SULTANDAGI'),
 (41,3,84,'SUHUT'),
 (42,4,0,'MERKEZ'),
 (43,4,20,'DIYADIN'),
 (44,4,25,'DOGUBEYAZIT'),
 (45,4,30,'ELESKIRT'),
 (46,4,35,'HAMUR'),
 (47,4,40,'PATNOS'),
 (48,4,45,'TASLIÇAY'),
 (49,4,50,'TUTAK'),
 (50,5,0,'MERKEZ'),
 (51,5,20,'GÖYNÜCEK'),
 (52,5,25,'GÜMÜSHACIKÖY'),
 (53,5,30,'HAMAMÖZÜ'),
 (54,5,35,'MERZIFON'),
 (55,5,40,'SULUOVA'),
 (56,5,45,'TASOVA'),
 (57,6,0,'MERKEZ'),
 (58,6,20,'AKYURT'),
 (59,6,23,'ALTINDAG'),
 (60,6,26,'AYAS'),
 (61,6,29,'BALA'),
 (62,6,32,'BEYPAZARI'),
 (63,6,35,'ÇAMLIDERE'),
 (64,6,38,'ÇANKAYA'),
 (65,6,41,'ÇUBUK'),
 (66,6,44,'ELMADAG'),
 (67,6,47,'ETIMESGUT'),
 (68,6,50,'EVREN'),
 (69,6,53,'GÖLBASI'),
 (70,6,56,'GÜDÜL'),
 (71,6,59,'HAYMANA'),
 (72,6,62,'KALECIK'),
 (73,6,65,'KAZAN'),
 (74,6,68,'KEÇIÖREN'),
 (75,6,71,'KIZILCAHAMAM'),
 (76,6,74,'MAMAK'),
 (77,6,77,'NALLIHAN'),
 (78,6,80,'POLATLI'),
 (79,6,83,'SINCAN'),
 (80,6,86,'SEREFLIKOÇ'),
 (81,6,89,'YENIMAHALLE'),
 (82,7,0,'MERKEZ'),
 (83,7,20,'AKSEKI'),
 (84,7,25,'ALANYA'),
 (85,7,28,'DEMRE'),
 (86,7,30,'ELMALI'),
 (87,7,35,'FINIKE'),
 (88,7,40,'GAZIPASA'),
 (89,7,45,'GÜNDOGMUS'),
 (90,7,50,'IBRADI'),
 (91,7,55,'KALE'),
 (92,7,60,'KAS'),
 (93,7,65,'KEMER'),
 (94,7,70,'KORKUTELI'),
 (95,7,75,'KUMLUCA'),
 (96,7,80,'MANAVGAT'),
 (97,7,85,'SERIK'),
 (98,8,0,'MERKEZ'),
 (99,8,20,'ARDANUÇ'),
 (100,8,25,'ARHAVI'),
 (101,8,30,'BORÇKA'),
 (102,8,32,'HOPA'),
 (103,8,35,'MURGUL'),
 (104,8,45,'SAVSAT'),
 (105,8,50,'YUSUFELI'),
 (106,9,0,'MERKEZ'),
 (107,9,20,'BOZDOGAN'),
 (108,9,24,'BUHARKENT'),
 (109,9,28,'ÇINE'),
 (110,9,32,'GERMENCIK'),
 (111,9,36,'INCIRLIOVA'),
 (112,9,40,'KARACASU'),
 (113,9,44,'KARPUZLU'),
 (114,9,48,'KOÇARLI'),
 (115,9,52,'KÖSK'),
 (116,9,56,'KUSADASI'),
 (117,9,60,'KUYUCAK'),
 (118,9,64,'NAZILLI'),
 (119,9,68,'SÖKE'),
 (120,9,72,'SULTANHISAR'),
 (121,9,76,'YENIHISAR'),
 (122,9,80,'YENIPAZAR'),
 (123,10,0,'MERKEZ'),
 (124,10,20,'AYVALIK'),
 (125,10,21,'AKÇAY'),
 (126,10,24,'BALYA'),
 (127,10,28,'BANDIRMA'),
 (128,10,32,'BIGADIÇ'),
 (129,10,36,'BURHANIYE'),
 (130,10,40,'DURSUNBEY'),
 (131,10,44,'EDREMIT'),
 (132,10,48,'ERDEK'),
 (133,10,52,'GÖNEN'),
 (134,10,56,'GÖMEÇ'),
 (135,10,60,'HAVRAN'),
 (136,10,64,'IVRINDI'),
 (137,10,68,'KEPSUT'),
 (138,10,72,'MANYAS'),
 (139,10,76,'MARMARA'),
 (140,10,80,'SAVASTEPE'),
 (141,10,84,'SINDIRGI'),
 (142,10,88,'SUSURLUK'),
 (143,11,0,'MERKEZ'),
 (144,11,20,'BOZÖYÜK'),
 (145,11,25,'GÖLPAZARI'),
 (146,11,30,'INHISAR'),
 (147,11,35,'OSMANELI'),
 (148,11,40,'PAZARYERI'),
 (149,11,45,'SÖGÜT'),
 (150,11,50,'YENIPAZAR'),
 (151,12,0,'MERKEZ'),
 (152,12,20,'ADAKLI'),
 (153,12,25,'GENÇ'),
 (154,12,30,'KARLIOVA'),
 (155,12,35,'KIGI'),
 (156,12,40,'SOLHAN'),
 (157,12,45,'YAYLADERE'),
 (158,12,55,'YEDISU'),
 (159,13,0,'MERKEZ'),
 (160,13,20,'ADILCEVAZ'),
 (161,13,25,'AHLAT'),
 (162,13,30,'GÜROYMAK'),
 (163,13,35,'HIZAN'),
 (164,13,40,'MUTKI'),
 (165,13,45,'TATVAN'),
 (166,14,0,'MERKEZ'),
 (167,14,35,'DÖRTDIVAN'),
 (168,14,45,'GEREDE'),
 (169,14,55,'GÖYNÜK'),
 (170,14,60,'KIBRISCIK'),
 (171,14,65,'MENGEN'),
 (172,14,70,'MUDURNU'),
 (173,14,75,'SEBEN'),
 (174,14,80,'YENIÇAGA'),
 (175,15,0,'MERKEZ'),
 (176,15,20,'ALTINYAYLA'),
 (177,15,25,'AGLASUN'),
 (178,15,30,'BUCAK'),
 (179,15,35,'ÇAVDIR'),
 (180,15,40,'ÇELTIKÇI'),
 (181,15,45,'GÖLHISAR'),
 (182,15,50,'KARAMANLI'),
 (183,15,55,'KEMER'),
 (184,15,60,'TEFENNI'),
 (185,15,65,'YESILOVA'),
 (186,16,0,'MERKEZ'),
 (187,16,24,'BÜYÜKORHAN'),
 (188,16,28,'GEMLIK'),
 (189,16,32,'GÜRSU'),
 (190,16,36,'HARMANCIK'),
 (191,16,40,'INEGÖL'),
 (192,16,44,'IZNIK'),
 (193,16,48,'KARACABEY'),
 (194,16,52,'KELES'),
 (195,16,56,'KESTEL'),
 (196,16,60,'MUDANYA'),
 (197,16,64,'MUSTAFAKEMA'),
 (198,16,68,'NILÜFER'),
 (199,16,72,'ORHANELI'),
 (200,16,76,'ORHANGAZI'),
 (201,16,80,'OSMANGAZI'),
 (202,16,84,'YENISEHIR'),
 (203,16,88,'YILDIRIM'),
 (204,17,0,'MERKEZ'),
 (205,17,25,'AYVACIK'),
 (206,17,30,'BAYRAMIÇ'),
 (207,17,32,'BOZCAADA'),
 (208,17,35,'BIGA'),
 (209,17,40,'ÇAN'),
 (210,17,45,'ECEABAT'),
 (211,17,50,'EZINE'),
 (212,17,55,'GELIBOLU'),
 (213,17,57,'GÖKÇEADA'),
 (214,17,65,'LAPSEKI'),
 (215,17,70,'YENICE'),
 (216,18,0,'MERKEZ'),
 (217,18,25,'ATKARACALAR'),
 (218,18,30,'BAYRAMÖREN'),
 (219,18,35,'ÇERKES'),
 (220,18,40,'ELDIVAN'),
 (221,18,50,'ILGAZ'),
 (222,18,55,'KIZILIRMAK'),
 (223,18,60,'KORGUN'),
 (224,18,65,'KURSUNLU'),
 (225,18,70,'ORTA'),
 (226,18,75,'OVACIK'),
 (227,18,80,'SABANÖZÜ'),
 (228,18,85,'YAPRAKLI'),
 (229,19,0,'MERKEZ'),
 (230,19,25,'ALACA'),
 (231,19,30,'BAYAT'),
 (232,19,35,'BOGAZKALE'),
 (233,19,40,'DODURGA'),
 (234,19,45,'ISKILIP'),
 (235,19,50,'KARGI'),
 (236,19,55,'LAÇIN'),
 (237,19,60,'MECITÖZÜ'),
 (238,19,65,'OGUZLAR'),
 (239,19,70,'ORTAKÖY'),
 (240,19,75,'OSMANCIK'),
 (241,19,80,'SUNGURLU'),
 (242,19,85,'UGURLUDAG'),
 (243,20,0,'MERKEZ'),
 (244,20,23,'ACIPAYAM'),
 (245,20,26,'AKKÖY'),
 (246,20,29,'BABADAG'),
 (247,20,32,'BAKLAN'),
 (248,20,35,'BEKILLI'),
 (249,20,38,'BEYAGAÇ'),
 (250,20,41,'BULDAN'),
 (251,20,44,'BOZKURT'),
 (252,20,47,'ÇAL'),
 (253,20,50,'ÇAMELI'),
 (254,20,53,'ÇARDAK'),
 (255,20,56,'ÇIVRIL'),
 (256,20,59,'GÜNEY'),
 (257,20,62,'HONAZ'),
 (258,20,65,'KALE'),
 (259,20,68,'SARAYKÖY'),
 (260,20,71,'SERINHISAR'),
 (261,20,74,'TAVAS'),
 (262,21,0,'MERKEZ'),
 (263,21,25,'BISMIL'),
 (264,21,30,'ÇERMIK'),
 (265,21,35,'ÇINAR'),
 (266,21,40,'ÇÜNGÜS'),
 (267,21,45,'DICLE'),
 (268,21,50,'EGIL'),
 (269,21,55,'ERGANI'),
 (270,21,60,'HANI'),
 (271,21,65,'HAZRO'),
 (272,21,70,'KOCAKÖY'),
 (273,21,75,'KULP'),
 (274,21,80,'LICE'),
 (275,21,85,'SILVAN'),
 (276,22,0,'MERKEZ'),
 (277,22,25,'ENEZ'),
 (278,22,30,'HAVSA'),
 (279,22,35,'IPSALA'),
 (280,22,40,'KESAN'),
 (281,22,45,'LALAPASA'),
 (282,22,50,'MERIÇ'),
 (283,22,55,'SÜLOGLU'),
 (284,22,60,'UZUNKÖPRÜ'),
 (285,23,0,'MERKEZ'),
 (286,23,25,'AGIN'),
 (287,23,30,'ALACAKAYA'),
 (288,23,35,'ARICAK'),
 (289,23,40,'BASKIL'),
 (290,23,45,'KARAKOÇAN'),
 (291,23,50,'KEBAN'),
 (292,23,55,'KOVANCILAR'),
 (293,23,60,'MADEN'),
 (294,23,65,'PALU'),
 (295,23,70,'SIVRICE'),
 (296,24,0,'MERKEZ'),
 (297,24,25,'ÇAYIRLI'),
 (298,24,30,'ILIÇ'),
 (299,24,35,'KEMAH'),
 (300,24,40,'KEMALIYE'),
 (301,24,45,'OTLUKBELI'),
 (302,24,50,'REFAHIYE'),
 (303,24,55,'TERCAN'),
 (304,24,60,'ÜZÜMLÜ'),
 (305,25,0,'MERKEZ'),
 (306,25,23,'ASKALE'),
 (307,25,26,'ÇAT'),
 (308,25,29,'HINIS'),
 (309,25,32,'HORASAN'),
 (310,25,35,'ILICA'),
 (311,25,38,'ISPIR'),
 (312,25,41,'KARAÇOBAN'),
 (313,25,44,'KARAYAZI'),
 (314,25,47,'KÖPRÜKÖY'),
 (315,25,50,'NARMAN'),
 (316,25,53,'OLTU'),
 (317,25,55,'OLUR'),
 (318,25,58,'PASINLER'),
 (319,25,61,'PAZARYOLU'),
 (320,25,64,'SENKAYA'),
 (321,25,67,'TEKMAN'),
 (322,25,70,'TORTUM'),
 (323,25,73,'UZUNDERE'),
 (324,26,0,'MERKEZ'),
 (325,26,25,'ALPU'),
 (326,26,30,'BEYLIKOVA'),
 (327,26,35,'ÇIFTELER'),
 (328,26,40,'GÜNYÜZÜ'),
 (329,26,45,'HAN'),
 (330,26,50,'INÖNÜ'),
 (331,26,55,'MAHMUDIYE'),
 (332,26,60,'MIHALGAZI'),
 (333,26,65,'MIHALIÇÇIK'),
 (334,26,70,'SARICAKAYA'),
 (335,26,75,'SEYITGAZI'),
 (336,26,80,'SIVRIHISAR'),
 (337,27,0,'MERKEZ'),
 (338,27,25,'ARABAN'),
 (339,27,30,'ISLAHIYE'),
 (340,27,35,'KILIS'),
 (341,27,40,'KARGAMIS'),
 (342,27,45,'NIZIP'),
 (343,27,50,'NURDAGI'),
 (344,27,55,'OGUZELI'),
 (345,27,60,'SAHINBEY'),
 (346,27,65,'SEHITKAMIL'),
 (347,27,70,'YAVUZELI'),
 (348,28,0,'MERKEZ'),
 (349,28,25,'ALUCRA'),
 (350,28,30,'BULANCAK'),
 (351,28,32,'ÇAMOLUK'),
 (352,28,35,'ÇANAKÇI'),
 (353,28,40,'DERELI'),
 (354,28,42,'DOGANKENT'),
 (355,28,45,'ESPIYE'),
 (356,28,50,'EYNESIL'),
 (357,28,55,'GÖRELE'),
 (358,28,60,'GÜCE'),
 (359,28,65,'KESAP'),
 (360,28,70,'PIRAZIZ'),
 (361,28,75,'SEBINKARAHISAR'),
 (362,28,80,'TIREBOLU'),
 (363,28,85,'YAGLIDERE'),
 (364,29,0,'MERKEZ'),
 (365,29,25,'KELKIT'),
 (366,29,30,'KÖSE'),
 (367,29,35,'KÜRTÜN'),
 (368,29,40,'SIRAN'),
 (369,29,45,'TORUL'),
 (370,30,0,'MERKEZ'),
 (371,30,25,'ÇUKURCA'),
 (372,30,30,'SEMDINLI'),
 (373,30,35,'YÜKSEKOVA'),
 (374,31,0,'MERKEZ'),
 (375,31,25,'ALTINÖZÜ'),
 (376,31,30,'BELEN'),
 (377,31,35,'DÖRTYOL'),
 (378,31,40,'ERZIN'),
 (379,31,45,'HASSA'),
 (380,31,50,'ISKENDERUN'),
 (381,31,55,'KIRIKHAN'),
 (382,31,60,'KUMLU'),
 (383,31,65,'REYHANLI'),
 (384,31,70,'SAMANDAGI'),
 (385,31,75,'YAYLADAGI'),
 (386,32,0,'MERKEZ'),
 (387,32,25,'AKSU'),
 (388,32,30,'ATABEY'),
 (389,32,35,'EGIRDIR'),
 (390,32,40,'GELENDOST'),
 (391,32,45,'GÖNEN'),
 (392,32,50,'KEÇIBORLU'),
 (393,32,55,'SENIRKENT'),
 (394,32,60,'SÜTÇÜLER'),
 (395,32,65,'SARKIKARAAG'),
 (396,32,70,'ULUBORLU'),
 (397,32,75,'YENISARBADE'),
 (398,32,80,'YALVAÇ'),
 (399,33,0,'MERKEZ'),
 (400,33,25,'ANAMUR'),
 (401,33,30,'AYDINCIK'),
 (402,33,35,'BOZYAZI'),
 (403,33,40,'ÇAMLIYAYLA'),
 (404,33,45,'ERDEMLI'),
 (405,33,50,'GÜLNAR'),
 (406,33,55,'MUT'),
 (407,33,60,'SILIFKE'),
 (408,33,65,'TARSUS'),
 (409,34,0,'MERKEZ'),
 (410,34,23,'ADALAR'),
 (411,34,24,'AVCILAR'),
 (412,34,25,'BAGCILAR'),
 (413,34,26,'BAKIRKÖY'),
 (414,34,27,'BAHÇELIEVLE'),
 (415,34,29,'BAYRAMPASA'),
 (416,34,32,'BESIKTAS'),
 (417,34,35,'BEYKOZ'),
 (418,34,38,'BEYOGLU'),
 (419,34,41,'BÜYÜKÇEKMECE'),
 (420,34,44,'ÇATALCA'),
 (421,34,47,'EMINÖNÜ'),
 (422,34,50,'EYÜP'),
 (423,34,51,'ESENLER'),
 (424,34,53,'FATIH'),
 (425,34,56,'GAZIOSMANPASA'),
 (426,34,57,'GÜNGÖREN'),
 (427,34,59,'KADIKÖY'),
 (428,34,61,'KAGITHANE'),
 (429,34,64,'KARTAL'),
 (430,34,67,'KÜÇÜKÇEKMECE'),
 (431,34,68,'MALTEPE'),
 (432,34,70,'PENDIK'),
 (433,34,73,'SARIYER'),
 (434,34,76,'SILIVRI'),
 (435,34,77,'SULTANBEYLI'),
 (436,34,79,'SILE'),
 (437,34,81,'SISLI'),
 (438,34,82,'TUZLA'),
 (439,34,84,'ÜMRANIYE'),
 (440,34,87,'ÜSKÜDAR'),
 (441,34,90,'YALOVA'),
 (442,34,93,'ZEYTINBURNU'),
 (443,35,0,'MERKEZ'),
 (444,35,23,'ALIAGA'),
 (445,35,26,'BAYINDIR'),
 (446,35,27,'BALÇOVA'),
 (447,35,29,'BERGAMA'),
 (448,35,32,'BEYDAG'),
 (449,35,35,'BORNOVA'),
 (450,35,37,'BUCA'),
 (451,35,41,'ÇESME'),
 (452,35,42,'ÇIGLI'),
 (453,35,44,'DIKILI'),
 (454,35,47,'FOÇA'),
 (455,35,48,'GAZIEMIR'),
 (456,35,49,'GÜZELBAHÇE'),
 (457,35,50,'KARABURUN'),
 (458,35,53,'KARSIYAKA'),
 (459,35,56,'KEMALPASA'),
 (460,35,59,'KINIK'),
 (461,35,62,'KIRAZ'),
 (462,35,65,'KONAK'),
 (463,35,68,'MENDERES'),
 (464,35,71,'MENEMEN'),
 (465,35,72,'NARLIDERE'),
 (466,35,74,'ÖDEMIS'),
 (467,35,77,'SEFERIHISAR'),
 (468,35,80,'SELÇUK'),
 (469,35,83,'TIRE'),
 (470,35,86,'TORBALI'),
 (471,35,89,'URLA'),
 (472,36,0,'MERKEZ'),
 (473,36,24,'AKYAKA'),
 (474,36,36,'ARPAÇAY'),
 (475,36,44,'DIGOR'),
 (476,36,60,'KAGIZMAN'),
 (477,36,68,'SARIKAMIS'),
 (478,36,72,'SELIM'),
 (479,36,76,'SUSUZ'),
 (480,37,0,'MERKEZ'),
 (481,37,23,'ABANA'),
 (482,37,26,'AGLI'),
 (483,37,29,'ARAÇ'),
 (484,37,32,'AZDAVAY'),
 (485,37,35,'BOZKURT'),
 (486,37,38,'CIDE'),
 (487,37,41,'ÇATALZEYTIN'),
 (488,37,44,'DADAY'),
 (489,37,47,'DEVREKANI'),
 (490,37,50,'DOGANYURT'),
 (491,37,53,'HANÖNÜ'),
 (492,37,56,'IHSANGAZI'),
 (493,37,59,'INEBOLU'),
 (494,37,62,'KÜRE'),
 (495,37,65,'PINARBASI'),
 (496,37,68,'SEYDILER'),
 (497,37,71,'SENPAZAR'),
 (498,37,74,'TASKÖPRÜ'),
 (499,37,77,'TOSYA'),
 (500,38,0,'MERKEZ'),
 (501,38,24,'AKKISLA'),
 (502,38,28,'BÜNYAN'),
 (503,38,32,'DEVELI'),
 (504,38,36,'FELAHIYE'),
 (505,38,40,'HACILAR'),
 (506,38,44,'INCESU'),
 (507,38,48,'KOCASINAN'),
 (508,38,52,'MELIKGAZI'),
 (509,38,56,'ÖZVATAN'),
 (510,38,60,'PINARBASI'),
 (511,38,64,'SARIOGLAN'),
 (512,38,68,'SARIZ'),
 (513,38,72,'TALAS'),
 (514,38,76,'TOMARZA'),
 (515,38,80,'YAHYALI'),
 (516,38,84,'YESILHISAR'),
 (517,39,0,'MERKEZ'),
 (518,39,25,'BABAESKI'),
 (519,39,30,'DEMIRKÖY'),
 (520,39,35,'KOFÇAZ'),
 (521,39,40,'LÜLEBURGAZ'),
 (522,39,45,'PEHLIVANKÖY'),
 (523,39,50,'PINARHISAR'),
 (524,39,55,'VIZE'),
 (525,40,0,'MERKEZ'),
 (526,40,20,'AKÇAKENT'),
 (527,40,25,'AKPINAR'),
 (528,40,27,'BOZTEPE'),
 (529,40,30,'ÇIÇEKDAGI'),
 (530,40,35,'KAMAN'),
 (531,40,40,'MUCUR'),
 (532,41,0,'MERKEZ'),
 (533,41,20,'DARICA'),
 (534,41,25,'GEBZE'),
 (535,41,30,'GÖLCÜK'),
 (536,41,35,'KANDIRA'),
 (537,41,40,'KARAMÜRSEL'),
 (538,41,45,'KÖRFEZ'),
 (539,42,0,'MERKEZ'),
 (540,42,22,'AHIRLI'),
 (541,42,24,'AKÖREN'),
 (542,42,26,'AKSEHIR'),
 (543,42,28,'ALTINEKIN'),
 (544,42,30,'BEYSEHIR'),
 (545,42,32,'BOZKIR'),
 (546,42,34,'DEREBUCAK'),
 (547,42,36,'CIHANBEYLI'),
 (548,42,38,'ÇUMRA'),
 (549,42,40,'ÇELTIK'),
 (550,42,42,'DERBENT'),
 (551,42,44,'DOGANHISAR'),
 (552,42,46,'EMIRGAZI'),
 (553,42,48,'EREGLI'),
 (554,42,50,'GÜNEYSINIR'),
 (555,42,52,'HALKAPINAR'),
 (556,42,54,'HADIM'),
 (557,42,55,'HALKAPINAR'),
 (558,42,56,'HÜYÜK'),
 (559,42,58,'ILGIN'),
 (560,42,60,'KADINHANI'),
 (561,42,62,'KARAPINAR'),
 (562,42,64,'KARATAY'),
 (563,42,66,'KULU'),
 (564,42,68,'MERAM'),
 (565,42,70,'SARAYÖNÜ'),
 (566,42,72,'SELÇUKLU'),
 (567,42,74,'SEYDISEHIR'),
 (568,42,76,'TASKENT'),
 (569,42,78,'TUZLUKÇU'),
 (570,42,80,'YALIHÖYÜK'),
 (571,42,82,'YUNAK'),
 (572,43,0,'MERKEZ'),
 (573,43,25,'ALTINTAS'),
 (574,43,30,'ASLANAPA'),
 (575,43,35,'CAVDARHISAR'),
 (576,43,40,'DOMANIÇ'),
 (577,43,45,'DUMLUPINAR'),
 (578,43,50,'EMET'),
 (579,43,55,'GEDIZ'),
 (580,43,60,'HISARCIK'),
 (581,43,65,'PAZARLAR'),
 (582,43,70,'SIMAV'),
 (583,43,75,'SAPHANE'),
 (584,43,80,'TAVSANLI'),
 (585,44,0,'MERKEZ'),
 (586,44,25,'AKÇADAG'),
 (587,44,30,'ARAPGIR'),
 (588,44,35,'ARGUVAN'),
 (589,44,40,'BATTALGAZI'),
 (590,44,45,'DARENDE'),
 (591,44,50,'DOGANSEHIR'),
 (592,44,55,'DOGANYOL'),
 (593,44,60,'HEKIMHAN'),
 (594,44,65,'KALE'),
 (595,44,70,'KULUNCAK'),
 (596,44,75,'PÖTÜRGE'),
 (597,44,80,'YAZIHAN'),
 (598,44,85,'YESILYURT'),
 (599,45,0,'MERKEZ'),
 (600,45,25,'AHMETLI'),
 (601,45,30,'AKHISAR'),
 (602,45,35,'ALASEHIR'),
 (603,45,40,'DEMIRCI'),
 (604,45,45,'GÖLMARMARA'),
 (605,45,50,'GÖRDES'),
 (606,45,55,'KIRKAGAÇ'),
 (607,45,60,'KÖPRÜBASI'),
 (608,45,65,'KULA'),
 (609,45,70,'SALIHLI'),
 (610,45,75,'SARIGÖL'),
 (611,45,80,'SARUHANLI'),
 (612,45,85,'SELENDI'),
 (613,45,90,'SOMA'),
 (614,45,95,'TURGUTLU'),
 (615,46,0,'MERKEZ'),
 (616,46,25,'AFSIN'),
 (617,46,30,'ANDIRIN'),
 (618,46,35,'ÇAGLAYANCER'),
 (619,46,40,'EKINÖZÜ'),
 (620,46,45,'ELBISTAN'),
 (621,46,50,'GÖKSUN'),
 (622,46,55,'NURHAK'),
 (623,46,60,'PAZARCIK'),
 (624,46,65,'TÜRKOGLU'),
 (625,47,0,'MERKEZ'),
 (626,47,25,'DARGEÇIT'),
 (627,47,30,'DERIK'),
 (628,47,40,'KIZILTEPE'),
 (629,47,45,'MAZIDAGI'),
 (630,47,50,'MIDYAT'),
 (631,47,55,'NUSAYBIN'),
 (632,47,60,'ÖMERLI'),
 (633,47,65,'SAVUR'),
 (634,47,70,'YESILLI'),
 (635,48,0,'MERKEZ'),
 (636,48,25,'BODRUM'),
 (637,48,30,'DALAMAN'),
 (638,48,35,'DATÇA'),
 (639,48,40,'FETHIYE'),
 (640,48,45,'KAVAKLIDERE'),
 (641,48,50,'KÖYCEGIZ'),
 (642,48,55,'MARMARIS'),
 (643,48,60,'MILAS'),
 (644,48,65,'ORTACA'),
 (645,48,70,'ULA'),
 (646,48,75,'YATAGAN'),
 (647,49,0,'MERKEZ'),
 (648,49,25,'BULANIK'),
 (649,49,30,'HASKÖY'),
 (650,49,35,'KORKUT'),
 (651,49,40,'MALAZGIRT'),
 (652,49,45,'VARTO'),
 (653,50,0,'MERKEZ'),
 (654,50,25,'ACIGÖL'),
 (655,50,30,'AVANOS'),
 (656,50,35,'DERINKUYU'),
 (657,50,40,'GÜLSEHIR'),
 (658,50,45,'HACIBEKTAS'),
 (659,50,50,'KOZAKLI'),
 (660,50,55,'ÜRGÜP'),
 (661,51,0,'MERKEZ'),
 (662,51,25,'ALTUNHISAR'),
 (663,51,30,'BOR'),
 (664,51,35,'ÇAMARDI'),
 (665,51,40,'ÇIFTLIK'),
 (666,51,45,'ULUKISLA'),
 (667,52,0,'MERKEZ'),
 (668,52,23,'AKKUS'),
 (669,52,26,'AYBASTI'),
 (670,52,29,'ÇAMAS'),
 (671,52,32,'ÇATALPINAR'),
 (672,52,35,'ÇAYBASI'),
 (673,52,38,'FATSA'),
 (674,52,41,'GÖLKÖY'),
 (675,52,44,'GÖLYALI'),
 (676,52,47,'GÜRGENTEPE'),
 (677,52,50,'IKIZCE'),
 (678,52,53,'KORGAN'),
 (679,52,56,'KABADÜZ'),
 (680,52,59,'KABATAS'),
 (681,52,62,'KUMRU'),
 (682,52,65,'MESUDIYE'),
 (683,52,68,'PERSEMBE'),
 (684,52,71,'ULUBEY'),
 (685,52,74,'ÜNYE'),
 (686,53,0,'MERKEZ'),
 (687,53,25,'ARDESEN'),
 (688,53,30,'ÇAMLIHEMSIN'),
 (689,53,35,'ÇAYELI'),
 (690,53,40,'DEREPAZARI'),
 (691,53,45,'FINDIKLI'),
 (692,53,50,'GÜNEYSU'),
 (693,53,55,'HEMSIN'),
 (694,53,60,'IKIZDERE');
INSERT INTO ilce VALUES
 (695,53,65,'IYIDERE'),
 (696,53,70,'KALKANDERE'),
 (697,53,75,'PAZAR'),
 (698,54,0,'MERKEZ'),
 (699,54,25,'AKYAZI'),
 (700,54,30,'FERIZLI'),
 (701,54,35,'GEYVE'),
 (702,54,40,'HENDEK'),
 (703,54,45,'KARAPÜRÇEK'),
 (704,54,50,'KARASU'),
 (705,54,55,'KAYNARCA'),
 (706,54,60,'KOCAALI'),
 (707,54,65,'PAMUKOVA'),
 (708,54,70,'SAPANCA'),
 (709,54,75,'SÖGÜTLÜ'),
 (710,54,80,'TARAKLI'),
 (711,55,0,'MERKEZ'),
 (712,55,25,'ALAÇAM'),
 (713,55,30,'ASARCIK'),
 (714,55,35,'AYVACIK'),
 (715,55,40,'BAFRA'),
 (716,55,45,'ÇARSAMBA'),
 (717,55,50,'HAVZA'),
 (718,55,55,'KAVAK'),
 (719,55,60,'LADIK'),
 (720,55,65,'19MAYIS'),
 (721,55,70,'SALIPAZARI'),
 (722,55,75,'TEKKEKÖY'),
 (723,55,80,'TERME'),
 (724,55,85,'VEZIRKÖPRÜ'),
 (725,55,90,'YAKAKENT'),
 (726,56,0,'MERKEZ'),
 (727,56,25,'AYDINLAR'),
 (728,56,30,'BAYKAN'),
 (729,56,35,'ERUH'),
 (730,56,42,'KOZLUK'),
 (731,56,45,'KURTALAN'),
 (732,56,50,'PERVARI'),
 (733,56,55,'SIRVAN'),
 (734,57,0,'MERKEZ'),
 (735,57,25,'AYANCIK'),
 (736,57,30,'BOYABAT'),
 (737,57,35,'DIKMEN'),
 (738,57,40,'DURAGAN'),
 (739,57,45,'ERFELEK'),
 (740,57,50,'GERZE'),
 (741,57,55,'SARAYDÜZÜ'),
 (742,57,60,'TÜRKELI'),
 (743,58,0,'MERKEZ'),
 (744,58,24,'AKINCILAR'),
 (745,58,28,'ALTINYAYLA'),
 (746,58,32,'DIVRIGI'),
 (747,58,36,'DOGANSAR'),
 (748,58,40,'GEMEREK'),
 (749,58,44,'GÖLOVA'),
 (750,58,48,'GÜRÜN'),
 (751,58,52,'HAFIK'),
 (752,58,56,'IMRANLI'),
 (753,58,60,'KANGAL'),
 (754,58,64,'KOYULHISAR'),
 (755,58,68,'SUSEHRI'),
 (756,58,72,'SARKISLA'),
 (757,58,76,'ULAS'),
 (758,58,80,'YILDIZELI'),
 (759,58,84,'ZARA'),
 (760,59,0,'MERKEZ'),
 (761,59,25,'ÇERKEZKÖY'),
 (762,59,30,'ÇORLU'),
 (763,59,35,'HAYRABOLU'),
 (764,59,40,'MALKARA'),
 (765,59,45,'MARMARAEREGLI'),
 (766,59,50,'MURATLI'),
 (767,59,55,'SARAY'),
 (768,59,60,'SARKÖY'),
 (769,60,0,'MERKEZ'),
 (770,60,25,'ALMUS'),
 (771,60,30,'ARTOVA'),
 (772,60,35,'BASÇIFTLIK'),
 (773,60,40,'ERBAA'),
 (774,60,45,'NIKSAR'),
 (775,60,50,'PAZAR'),
 (776,60,55,'RESADIYE'),
 (777,60,60,'SULUSARAY'),
 (778,60,65,'TURHAL'),
 (779,60,70,'YESILYURT'),
 (780,60,75,'ZILE'),
 (781,61,0,'MERKEZ'),
 (782,61,24,'AKÇAABAT'),
 (783,61,28,'ARAKLI'),
 (784,61,32,'ARSIN'),
 (785,61,36,'BESIKDÜZÜ'),
 (786,61,40,'ÇARSIBASI'),
 (787,61,44,'ÇAYKARA'),
 (788,61,48,'DERNEKPAZAR'),
 (789,61,52,'DÜZKÖY'),
 (790,61,56,'HAYRAT'),
 (791,61,60,'KÖPRÜBASI'),
 (792,61,64,'MAÇKA'),
 (793,61,68,'OF'),
 (794,61,72,'SÜRMENE'),
 (795,61,76,'SALPAZARI'),
 (796,61,80,'TONYA'),
 (797,61,84,'VAKFIKEBIR'),
 (798,61,88,'YOMRA'),
 (799,62,0,'MERKEZ'),
 (800,62,25,'ÇEMISGEZEK'),
 (801,62,30,'HOZAT'),
 (802,62,35,'MAZGIRT'),
 (803,62,40,'NAZIMIYE'),
 (804,62,45,'OVACIK'),
 (805,62,50,'PERTEK'),
 (806,62,55,'PÜLÜMÜR'),
 (807,63,0,'MERKEZ'),
 (808,63,25,'AKÇAKALE'),
 (809,63,30,'BIRECIK'),
 (810,63,35,'BOZOVA'),
 (811,63,40,'CEYLANPINAR'),
 (812,63,45,'HALFETI'),
 (813,63,50,'HARRAN'),
 (814,63,55,'HILVAN'),
 (815,63,60,'SIVEREK'),
 (816,63,65,'SURUÇ'),
 (817,63,70,'VIRANSEHIR'),
 (818,64,0,'MERKEZ'),
 (819,64,25,'BANAZ'),
 (820,64,30,'ESME'),
 (821,64,35,'KARAHALLI'),
 (822,64,40,'SIVASLI'),
 (823,64,45,'ULUBEY'),
 (824,65,0,'MERKEZ'),
 (825,65,25,'BAHÇESARAY'),
 (826,65,30,'BASKALE'),
 (827,65,35,'ÇALDIRAN'),
 (828,65,40,'ÇATAK'),
 (829,65,45,'EDREMIT'),
 (830,65,50,'ERCIS'),
 (831,65,55,'GEVAS'),
 (832,65,60,'GÜRPINAR'),
 (833,65,65,'MURADIYE'),
 (834,65,70,'ÖZALP'),
 (835,65,75,'SARAY'),
 (836,66,0,'MERKEZ'),
 (837,66,25,'AKDAGMADENI'),
 (838,66,30,'AYDINCIK'),
 (839,66,35,'BOGAZLIYAN'),
 (840,66,40,'ÇANDIR'),
 (841,66,45,'ÇAYIRALAN'),
 (842,66,50,'ÇEKEREK'),
 (843,66,55,'KADISEHRI'),
 (844,66,60,'SARIKAYA'),
 (845,66,65,'SARAYKENT'),
 (846,66,70,'SORGUN'),
 (847,66,75,'SEFAATLI'),
 (848,66,80,'YENIFAKILI'),
 (849,66,85,'YERKÖY'),
 (850,67,0,'MERKEZ'),
 (851,67,24,'ALAPLI'),
 (852,67,36,'ÇAMOLUK'),
 (853,67,38,'ÇAYCUMA'),
 (854,67,44,'DEVREK'),
 (855,67,52,'EFLANI'),
 (856,67,56,'EREGLI'),
 (857,67,60,'GÖKÇEBEY'),
 (858,68,0,'MERKEZ'),
 (859,68,25,'AGAÇÖREN'),
 (860,68,30,'ESKIL'),
 (861,68,35,'GÜLAGAÇ'),
 (862,68,40,'GÜZELYURT'),
 (863,68,45,'ORTAKÖY'),
 (864,68,50,'SARIYAHSI'),
 (865,69,0,'MERKEZ'),
 (866,69,25,'AYDINTEPE'),
 (867,69,30,'DEMIRÖZÜ'),
 (868,70,0,'MERKEZ'),
 (869,70,25,'AYRANCI'),
 (870,70,30,'BASYAYLA'),
 (871,70,35,'ERMENEK'),
 (872,70,40,'KAZIMKARABEKIR'),
 (873,70,45,'SARIVELILER'),
 (874,71,0,'MERKEZ'),
 (875,71,25,'BAHSILI'),
 (876,71,30,'BAGLISEYH'),
 (877,71,35,'ÇELEBI'),
 (878,71,40,'DELICE'),
 (879,71,45,'KARAKEÇILI'),
 (880,71,50,'KESKIN'),
 (881,71,55,'SULAKYURT'),
 (882,71,60,'YAHSIHAN'),
 (883,72,0,'MERKEZ'),
 (884,72,25,'GERCÜS'),
 (885,72,30,'HASANKEYF'),
 (886,72,35,'BESIRI'),
 (887,72,37,'KOZLUK'),
 (888,72,40,'SASON'),
 (889,73,0,'MERKEZ'),
 (890,73,25,'BEYTÜSSEBA'),
 (891,73,30,'ULUDERE'),
 (892,73,35,'CIZRE'),
 (893,73,40,'IDIL'),
 (894,73,45,'SILOPI'),
 (895,73,55,'GÜÇLÜKONAK'),
 (896,74,0,'MERKEZ'),
 (897,74,20,'AMASRA'),
 (898,74,30,'KURUCASILE'),
 (899,74,40,'ULUS'),
 (900,75,0,'MERKEZ'),
 (901,75,30,'ÇILDIR'),
 (902,75,35,'DAMAL'),
 (903,75,50,'GÖLE'),
 (904,75,55,'HANAK'),
 (905,75,75,'POSOF'),
 (906,76,0,'MERKEZ'),
 (907,76,25,'ARALIK'),
 (908,76,50,'KARAKOYUNLU'),
 (909,76,75,'TUZLUCA'),
 (910,77,0,'MERKEZ'),
 (911,77,10,'ALTINOVA'),
 (912,77,15,'ARMUTLU'),
 (913,77,20,'CINARCIK'),
 (914,77,22,'CIFTLIKKOY'),
 (915,77,80,'TERMAL'),
 (916,78,0,'MERKEZ'),
 (917,78,30,'EFLANI'),
 (918,78,33,'ESKIPAZAR'),
 (919,78,50,'OVACIK'),
 (920,78,70,'SAFRANBOLU'),
 (921,78,90,'YENICE'),
 (922,79,0,'MERKEZ'),
 (923,79,30,'ELBEYLI'),
 (924,79,50,'MUSABEYLI'),
 (925,79,60,'POLATELI'),
 (926,80,0,'MERKEZ'),
 (927,80,20,'BAHÇE'),
 (928,80,23,'HASANBEYLI'),
 (929,80,25,'DÜZIÇI'),
 (930,80,30,'KADIRLI'),
 (931,80,45,'SUNBAS'),
 (932,80,50,'TOPRAKKALE'),
 (933,81,0,'MERKEZ'),
 (934,81,20,'AKÇAKOCA'),
 (935,81,25,'CUMAYERI'),
 (936,81,30,'ÇILIMLI'),
 (937,81,35,'GÖLYAKA'),
 (938,81,40,'GÜMÜSOVA'),
 (939,81,45,'KAYNASLI'),
 (940,81,50,'YIGILCA'),
 (941,3,0,'SINANPASA'),
 (942,9,0,'DIDIM'),
 (943,41,0,'DERINCE');
UNLOCK TABLES;

-- 
-- Table structure for table kapiterminal
-- 

DROP TABLE IF EXISTS kapiterminal;
CREATE TABLE `kapiterminal` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(100) DEFAULT '0',
  `tip` varchar(10) DEFAULT NULL,
  `kapino` int(11) DEFAULT NULL,
  `terminalno` varchar(3) DEFAULT NULL,
  `genelmi` tinyint(1) DEFAULT '0',
  `girisip` varchar(30) DEFAULT NULL,
  `cikisip` varchar(30) DEFAULT NULL,
  `girisport` int(11) DEFAULT NULL,
  `cikisport` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kapiterminal
-- 

LOCK TABLES kapiterminal WRITE;
INSERT INTO kapiterminal VALUES
 (1,'1','ANAGİRİŞ',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),
 (2,'2','HAVUZ',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),
 (3,'3','SPORSALONU',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table kapiterminalalt
-- 

DROP TABLE IF EXISTS kapiterminalalt;
CREATE TABLE `kapiterminalalt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(100) DEFAULT '0',
  `tip` varchar(10) DEFAULT NULL,
  `kapino` int(11) DEFAULT NULL,
  `terminalno` varchar(3) DEFAULT NULL,
  `kapiterminalid` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kapiterminalalt
-- 

-- 
-- Table structure for table kapiterminal_yetkisaatleri
-- 

DROP TABLE IF EXISTS kapiterminal_yetkisaatleri;
CREATE TABLE `kapiterminal_yetkisaatleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `kapiterminalkod` int(11) NOT NULL,
  `baslamasaati` time DEFAULT NULL,
  `bitissaati` time DEFAULT NULL,
  `gunlukgecis` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kapiterminal_yetkisaatleri
-- 

-- 
-- Table structure for table kullanici
-- 

DROP TABLE IF EXISTS kullanici;
CREATE TABLE `kullanici` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kullaniciadi` varchar(30) DEFAULT NULL,
  `sifre` varchar(30) DEFAULT NULL,
  `kayittarihi` date DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  `personelid` bigint(20) DEFAULT NULL,
  `yedekalsin` tinyint(1) DEFAULT '1',
  `firmasec` tinyint(1) DEFAULT '1',
  `yedekkonum` tinyint(1) DEFAULT '0' COMMENT '0=local 1=server',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kullanici
-- 

-- 
-- Table structure for table kullanicifirmalar
-- 

DROP TABLE IF EXISTS kullanicifirmalar;
CREATE TABLE `kullanicifirmalar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kullaniciid` int(11) DEFAULT NULL,
  `yetki` tinyint(1) DEFAULT '0',
  `firmaid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kullanicifirmalar
-- 

-- 
-- Table structure for table kullaniciyetkileri
-- 

DROP TABLE IF EXISTS kullaniciyetkileri;
CREATE TABLE `kullaniciyetkileri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kullaniciid` int(11) DEFAULT NULL,
  `yetki` tinyint(1) DEFAULT '0',
  `aciklama` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table kullaniciyetkileri
-- 

-- 
-- Table structure for table mailadres
-- 

DROP TABLE IF EXISTS mailadres;
CREATE TABLE `mailadres` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `isim` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mailsablonid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailadres
-- 

LOCK TABLES mailadres WRITE;
INSERT INTO mailadres VALUES
 (1,'emrah işli','info@elikonguvenlik.com',2);
UNLOCK TABLES;

-- 
-- Table structure for table mailayarlari
-- 

DROP TABLE IF EXISTS mailayarlari;
CREATE TABLE `mailayarlari` (
  `kullanici` varchar(50) DEFAULT NULL,
  `sifre` varchar(30) DEFAULT NULL,
  `host` varchar(50) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `logintipi` varchar(5) DEFAULT NULL,
  `sslmod` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailayarlari
-- 

LOCK TABLES mailayarlari WRITE;
INSERT INTO mailayarlari VALUES
 ('rapor@aktifzaman.com.tr','1397','mail.aktifzaman.com.tr',587,'var',NULL);
UNLOCK TABLES;

-- 
-- Table structure for table mailbolge
-- 

DROP TABLE IF EXISTS mailbolge;
CREATE TABLE `mailbolge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mailsablonid` int(11) NOT NULL,
  `mailadresid` int(11) NOT NULL,
  `bolgeid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailbolge
-- 

-- 
-- Table structure for table mailbolum
-- 

DROP TABLE IF EXISTS mailbolum;
CREATE TABLE `mailbolum` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mailsablonid` int(11) NOT NULL,
  `mailadresid` int(11) NOT NULL,
  `bolumid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailbolum
-- 

-- 
-- Table structure for table mailfirma
-- 

DROP TABLE IF EXISTS mailfirma;
CREATE TABLE `mailfirma` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mailsablonid` int(11) NOT NULL,
  `mailadresid` int(11) NOT NULL,
  `firmaid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailfirma
-- 

LOCK TABLES mailfirma WRITE;
INSERT INTO mailfirma VALUES
 (1,2,1,4);
UNLOCK TABLES;

-- 
-- Table structure for table mailgorev
-- 

DROP TABLE IF EXISTS mailgorev;
CREATE TABLE `mailgorev` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mailsablonid` int(11) NOT NULL,
  `mailadresid` int(11) NOT NULL,
  `gorevid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailgorev
-- 

-- 
-- Table structure for table mailsaatleri
-- 

DROP TABLE IF EXISTS mailsaatleri;
CREATE TABLE `mailsaatleri` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `saat` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailsaatleri
-- 

-- 
-- Table structure for table mailsablon
-- 

DROP TABLE IF EXISTS mailsablon;
CREATE TABLE `mailsablon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(60) DEFAULT '0',
  `gonderileceksaat` varchar(6) DEFAULT NULL,
  `tarihbas` int(11) DEFAULT '0',
  `tarihbit` int(11) DEFAULT '0',
  `gunluk` tinyint(1) DEFAULT '0',
  `haftalik` tinyint(1) DEFAULT '0',
  `aylik` tinyint(1) DEFAULT '0',
  `alan` varchar(30) DEFAULT NULL,
  `rc` int(11) DEFAULT '0',
  `geckalanlaramailgonder` tinyint(1) DEFAULT '0',
  `dogumgunuolanlar` tinyint(1) DEFAULT '0',
  `puantajtur` tinyint(1) DEFAULT '0' COMMENT '0 ise gunluk 1 ise aylik',
  `ayinkaci` smallint(6) DEFAULT NULL,
  `devamsizlaramailgonder` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailsablon
-- 

LOCK TABLES mailsablon WRITE;
INSERT INTO mailsablon VALUES
 (1,'aa','10:00',0,0,0,0,0,'',0,1,0,0,1,1),
 (2,'bb','10:00',0,0,0,0,0,'01-02-09-12-13-14',6,0,0,0,1,0);
UNLOCK TABLES;

-- 
-- Table structure for table mailservis
-- 

DROP TABLE IF EXISTS mailservis;
CREATE TABLE `mailservis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mailsablonid` int(11) NOT NULL,
  `mailadresid` int(11) NOT NULL,
  `servisid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table mailservis
-- 

-- 
-- Table structure for table meslek
-- 

DROP TABLE IF EXISTS meslek;
CREATE TABLE `meslek` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(200) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table meslek
-- 

-- 
-- Table structure for table parakupuru
-- 

DROP TABLE IF EXISTS parakupuru;
CREATE TABLE `parakupuru` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kupur` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table parakupuru
-- 

-- 
-- Table structure for table personel
-- 

DROP TABLE IF EXISTS personel;
CREATE TABLE `personel` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kartfc` varchar(10) NOT NULL DEFAULT '',
  `kartno` varchar(10) NOT NULL DEFAULT '',
  `kartid` varchar(10) NOT NULL DEFAULT '',
  `ad` varchar(60) DEFAULT NULL,
  `soyad` varchar(60) DEFAULT NULL,
  `sicilno` varchar(30) DEFAULT NULL,
  `durum` varchar(10) DEFAULT NULL,
  `firmaid` int(11) DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `bolumid` int(11) DEFAULT NULL,
  `gorevid` int(11) DEFAULT NULL,
  `servisid` int(11) DEFAULT NULL,
  `bolgeid` int(11) DEFAULT NULL,
  `birimid` int(11) DEFAULT NULL,
  `takimid` int(11) DEFAULT NULL,
  `subeid` int(11) DEFAULT NULL,
  `isegiristarihi` date DEFAULT NULL,
  `istencikistarihi` date DEFAULT NULL,
  `istenayrilmanedeni` longtext,
  `ucret` decimal(11,2) DEFAULT NULL,
  `saatucreti` decimal(11,2) DEFAULT NULL,
  `ucrettipi` varchar(20) DEFAULT NULL,
  `ucret_onceki` decimal(11,2) DEFAULT NULL COMMENT 'ucret''e zam yaparsa ilk ucret degerini tutar',
  `primucrettipi` varchar(10) DEFAULT NULL,
  `primucreti` decimal(11,2) DEFAULT NULL COMMENT 'gunluk prim ucreti',
  `yolucrettipi` char(10) DEFAULT NULL,
  `yolucreti` decimal(11,2) DEFAULT NULL COMMENT 'gunluk mu aylık mı',
  `yemekucrettipi` varchar(10) DEFAULT NULL,
  `yemekucreti` decimal(11,2) DEFAULT NULL COMMENT 'gunluk mu aylık mı',
  `resim` longblob,
  `webadres` varchar(150) DEFAULT NULL,
  `vergino` varchar(50) DEFAULT NULL,
  `evtel` varchar(100) DEFAULT NULL,
  `ceptel` varchar(100) DEFAULT NULL,
  `istel` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `egitim` varchar(30) DEFAULT NULL,
  `yabancidil` varchar(30) DEFAULT NULL,
  `askerlikdurumu` varchar(10) DEFAULT NULL,
  `gozluk` varchar(10) DEFAULT NULL,
  `sabika` varchar(10) DEFAULT NULL,
  `kilo` decimal(11,2) DEFAULT NULL,
  `boy` decimal(11,2) DEFAULT NULL,
  `ayak` decimal(11,2) DEFAULT NULL,
  `pan` decimal(11,2) DEFAULT NULL,
  `medenihali` varchar(10) DEFAULT NULL,
  `cocuksayisi` smallint(6) DEFAULT NULL,
  `esdurumu` varchar(15) DEFAULT NULL,
  `adres` longtext,
  `il` varchar(40) DEFAULT NULL,
  `ilce` varchar(60) DEFAULT NULL,
  `ilksoyad` varchar(60) DEFAULT NULL,
  `kimlikno` varchar(30) DEFAULT NULL,
  `babaad` varchar(30) DEFAULT NULL,
  `annead` varchar(30) DEFAULT NULL,
  `dogumyeri` varchar(50) DEFAULT NULL,
  `dogumtarihi` date DEFAULT NULL,
  `kangrubu` varchar(10) DEFAULT NULL,
  `uyruk` varchar(30) DEFAULT NULL,
  `cinsiyet` varchar(5) DEFAULT NULL,
  `nufus_il` varchar(30) DEFAULT NULL,
  `nufus_ilce` varchar(30) DEFAULT NULL,
  `nufus_mahkoy` varchar(30) DEFAULT NULL,
  `nufus_ciltno` varchar(10) DEFAULT NULL,
  `nufus_ailesirano` varchar(10) DEFAULT NULL,
  `nufus_sirano` varchar(10) DEFAULT NULL,
  `banka_subeadi` varchar(200) DEFAULT NULL,
  `banka_hesapno` varchar(30) DEFAULT NULL,
  `ehliyet_sinif` varchar(2) DEFAULT NULL,
  `ehliyet_verililce` varchar(60) DEFAULT NULL,
  `ehliyet_belgeno` varchar(30) DEFAULT NULL,
  `ehliyet_vertarih` date DEFAULT NULL,
  `ehliyet_kulcihazprotez` varchar(100) DEFAULT NULL,
  `personelturu` varchar(10) DEFAULT NULL,
  `aciklama` longtext,
  `gunlukkontor` int(11) DEFAULT NULL,
  `uyedurumu` varchar(20) DEFAULT NULL,
  `uyebaslamatarihi` date DEFAULT NULL,
  `uyebitistarihi` date DEFAULT NULL,
  `odedigitutar` decimal(11,2) DEFAULT NULL,
  `kalantutar` decimal(11,2) DEFAULT NULL,
  `uyebaslamasaati` time DEFAULT NULL,
  `uyebitissaati` time DEFAULT NULL,
  `ogrenci_kayittarihi` date DEFAULT NULL,
  `ogrenci_cikistarihi` date DEFAULT NULL,
  `ogrenci_basariorani` int(11) DEFAULT NULL,
  `ogrenci_grupid` int(11) DEFAULT NULL,
  `ogrenci_bolumid` int(11) DEFAULT NULL,
  `ogrenci_sinifid` int(11) DEFAULT NULL,
  `ogretmen_bransid` varchar(60) DEFAULT NULL,
  `ogretmen_dersid` varchar(100) DEFAULT NULL,
  `ogrenci_alanturu` varchar(20) DEFAULT NULL,
  `ogrenci_geldigiokul` varchar(150) DEFAULT NULL,
  `ogrenci_sinif` varchar(20) DEFAULT NULL,
  `ogrenci_bolum` varchar(50) DEFAULT NULL,
  `ogrenci_okulno` varchar(20) DEFAULT NULL,
  `ogrenci_veliad` varchar(60) DEFAULT NULL,
  `ogrenci_velievtel` varchar(20) DEFAULT NULL,
  `ogrenci_veliistel` varchar(20) DEFAULT NULL,
  `ogrenci_veliceptel` varchar(20) DEFAULT NULL,
  `mesaisaatucreti` decimal(11,2) DEFAULT NULL,
  `ozelucrettipi` char(10) DEFAULT NULL,
  `ozelucret` decimal(11,2) DEFAULT NULL COMMENT 'gunluk mu aylık mı',
  `yetkiid` int(11) DEFAULT NULL,
  `uyetipiid` int(11) DEFAULT NULL,
  `ilkgiristarihi` date DEFAULT NULL,
  `songiristarihi` date DEFAULT NULL,
  `toplamgirissayisi` int(11) DEFAULT NULL,
  `gecisgrupid` int(11) DEFAULT NULL,
  `gecisyetki` varchar(128) DEFAULT NULL,
  `toplamkontor` int(11) DEFAULT NULL,
  `kalankontor` int(11) DEFAULT NULL,
  `isegiristarihi1` date DEFAULT NULL,
  `ucret1` decimal(11,2) DEFAULT NULL,
  `fazlamesaialir` tinyint(1) DEFAULT '1',
  `devamsizlikcezasi` decimal(11,2) DEFAULT NULL,
  `agialir` tinyint(1) DEFAULT '0',
  `nufus_cuzdanverildigiyer` varchar(60) DEFAULT NULL,
  `nufus_cuzdanverilisnedeni` varchar(160) DEFAULT NULL,
  `nufus_cuzdankayitno` varchar(30) DEFAULT NULL,
  `nufus_cuzdanverilistarihi` date DEFAULT NULL,
  `elbisebedenno` varchar(30) DEFAULT NULL,
  `kapiyetki` int(11) DEFAULT NULL,
  `yillikizinonceki` int(11) DEFAULT NULL,
  `saglikraporu1` date DEFAULT NULL,
  `saglikraporu2` date DEFAULT NULL,
  `saglikraporu3` date DEFAULT NULL,
  `ay` int(11) DEFAULT NULL COMMENT 'dogumtarihi icin ay alani',
  `parmaktanimlandi` tinyint(1) DEFAULT '0',
  `sgk_no` varchar(30) DEFAULT NULL,
  `sgk_isegiristarihi` date DEFAULT NULL,
  `sgk_istencikiskodu` varchar(10) DEFAULT NULL,
  `sgk_meslekkodu` varchar(20) DEFAULT NULL,
  `sgk_calismadonemi` varchar(20) DEFAULT NULL,
  `sgk_kapsam` varchar(10) DEFAULT NULL,
  `sgk_ucrettipi` varchar(10) DEFAULT NULL,
  `sgk_hesaptipi` varchar(20) DEFAULT NULL,
  `sgk_issizliksigortakes` tinyint(1) DEFAULT '0',
  `sgk_grubu` varchar(10) DEFAULT 'Normal',
  `sgk_belgeturu` varchar(10) DEFAULT '01',
  `sgk_tabioldugukanun` varchar(10) DEFAULT '00000',
  `sgk_kanunbitistarihi` date DEFAULT NULL,
  `sgk_ozurlulukderecesi` smallint(6) DEFAULT '0',
  `ilkisegiristarihi` date DEFAULT NULL,
  `brutucret` decimal(11,2) DEFAULT NULL,
  `sgk_devredenkgvm` decimal(11,5) DEFAULT NULL,
  `wckesintisiuygula` tinyint(1) DEFAULT '1',
  `sendikadurumu` varchar(30) DEFAULT NULL,
  `meslekid` int(11) DEFAULT NULL COMMENT 'dogumtarihi icin ay alani',
  `sgk_devredenkgvmyil` int(11) DEFAULT NULL,
  `agicocukparasialsin` tinyint(1) DEFAULT '1',
  `terfi1id` int(11) DEFAULT NULL,
  `terfi2id` int(11) DEFAULT NULL,
  `terfi3id` int(11) DEFAULT NULL,
  `terfi4id` int(11) DEFAULT NULL,
  `terfi5id` int(11) DEFAULT NULL,
  `terfi1tarih` date DEFAULT NULL,
  `terfi2tarih` date DEFAULT NULL,
  `terfi3tarih` date DEFAULT NULL,
  `terfi4tarih` date DEFAULT NULL,
  `terfi5tarih` date DEFAULT NULL,
  `ncsaatucreti` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kartno` (`kartno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel
-- 

-- 
-- Table structure for table personeldetay
-- 

DROP TABLE IF EXISTS personeldetay;
CREATE TABLE `personeldetay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(11) NOT NULL,
  `personelid_yakini` varchar(100) DEFAULT NULL,
  `yakinlikderecesi` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personeldetay
-- 

-- 
-- Table structure for table personel_ailefertleri
-- 

DROP TABLE IF EXISTS personel_ailefertleri;
CREATE TABLE `personel_ailefertleri` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `yakinlikderecesi` varchar(10) DEFAULT NULL,
  `sgk_yakinlikderecesi` tinyint(1) DEFAULT '0' COMMENT '0=cocuk 1=es',
  `ad` varchar(100) DEFAULT NULL,
  `soyad` varchar(100) DEFAULT NULL,
  `cinsiyet` varchar(10) DEFAULT NULL,
  `dogumtarihi` date DEFAULT NULL,
  `kimlikno` varchar(20) DEFAULT NULL,
  `agiyetabi` tinyint(1) DEFAULT '0',
  `ucretlimi` tinyint(1) DEFAULT '0',
  `ogrenimdurumu` tinyint(1) DEFAULT '0',
  `kacincicocugu` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel_ailefertleri
-- 

-- 
-- Table structure for table personel_dosya
-- 

DROP TABLE IF EXISTS personel_dosya;
CREATE TABLE `personel_dosya` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(11) NOT NULL,
  `ad` varchar(200) DEFAULT NULL,
  `konum` varchar(600) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel_dosya
-- 

-- 
-- Table structure for table personel_egitim
-- 

DROP TABLE IF EXISTS personel_egitim;
CREATE TABLE `personel_egitim` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `egitimid` int(11) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `aciklama` varchar(500) DEFAULT NULL,
  `sure` int(11) DEFAULT NULL,
  `gecerliliksuresi` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel_egitim
-- 

-- 
-- Table structure for table personel_ucret
-- 

DROP TABLE IF EXISTS personel_ucret;
CREATE TABLE `personel_ucret` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `ucret` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel_ucret
-- 

-- 
-- Table structure for table personel_zimmet
-- 

DROP TABLE IF EXISTS personel_zimmet;
CREATE TABLE `personel_zimmet` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `zimmetbolumid` int(11) DEFAULT NULL,
  `zimmetkategoriid` int(11) DEFAULT NULL,
  `teslimpersonelid` bigint(20) DEFAULT NULL,
  `aciklama` varchar(400) DEFAULT NULL,
  `verilistarihi` date DEFAULT '2000-01-01',
  `verilissaati` time DEFAULT NULL,
  `iadetarihi` date DEFAULT NULL,
  `iadesaati` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table personel_zimmet
-- 

-- 
-- Table structure for table pts_altgrup
-- 

DROP TABLE IF EXISTS pts_altgrup;
CREATE TABLE `pts_altgrup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grupid` int(11) NOT NULL,
  `ad` varchar(100) DEFAULT NULL,
  `gundonumu` varchar(5) DEFAULT NULL,
  `gunbitisi` varchar(5) DEFAULT NULL,
  `gunluksaat` varchar(5) DEFAULT NULL,
  `birsonrakigunesay` tinyint(1) DEFAULT '0',
  `gunluksaat1` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `grupid` (`grupid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_altgrup
-- 

LOCK TABLES pts_altgrup WRITE;
INSERT INTO pts_altgrup VALUES
 (14,11,'MESAİLİ GRUP','07:00','23:59','09:00',0,NULL),
 (15,12,'VARDİYA1','07:00','15:00','07:30',0,NULL),
 (16,12,'VARDİYA2','15:00','23:00','07:30',0,NULL),
 (17,12,'VARDİYA3','23:00','07:00','07:30',1,NULL),
 (18,13,'VARDİYA1','07:00','18:00','08:00',0,NULL),
 (19,14,'İDARİ','07:00','23:59','07:30',0,NULL),
 (20,13,'VARDİYA2','18:00','07:00','08:00',0,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_araplan
-- 

DROP TABLE IF EXISTS pts_araplan;
CREATE TABLE `pts_araplan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bastarih` date DEFAULT NULL,
  `bittarih` date DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `plangrupid` int(11) DEFAULT NULL,
  `plangrupad` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_araplan
-- 

-- 
-- Table structure for table pts_araplanper
-- 

DROP TABLE IF EXISTS pts_araplanper;
CREATE TABLE `pts_araplanper` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `araplanid` bigint(20) DEFAULT NULL,
  `personelid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `araplanid` (`araplanid`),
  CONSTRAINT `pts_araplanper_fk` FOREIGN KEY (`araplanid`) REFERENCES `pts_araplan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_araplanper
-- 

-- 
-- Table structure for table pts_calismaparametre
-- 

DROP TABLE IF EXISTS pts_calismaparametre;
CREATE TABLE `pts_calismaparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `bordroid` int(11) NOT NULL,
  `bordroad` varchar(100) DEFAULT NULL,
  `igs` varchar(5) DEFAULT NULL,
  `dcs` varchar(5) DEFAULT NULL,
  `ggt` varchar(5) DEFAULT NULL,
  `ect` varchar(5) DEFAULT NULL,
  `minimum` varchar(5) DEFAULT NULL,
  `maximum` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_calismaparametre_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_calismaparametre
-- 

LOCK TABLES pts_calismaparametre WRITE;
INSERT INTO pts_calismaparametre VALUES
 (68,48,7,'Normal Çalışma','08:00','18:00','08:15','18:00','00:30',NULL),
 (69,48,8,'% 50 Mesai','18:00','07:00',NULL,NULL,'00:30',NULL),
 (70,49,7,'Normal Çalışma','08:00','13:00','08:10','13:00','00:30',NULL),
 (71,49,8,'% 50 Mesai','13:00','07:00',NULL,NULL,'00:30',NULL),
 (72,50,9,'%100 Mesai','08:00','07:00',NULL,NULL,'00:30',NULL),
 (73,51,7,'Normal Çalışma','08:00','16:00','08:15','16:00','00:30',NULL),
 (74,51,8,'% 50 Mesai','16:00','07:00',NULL,NULL,'00:30',NULL),
 (75,52,9,'%100 Mesai','08:00','07:00',NULL,NULL,'00:30',NULL),
 (76,53,7,'Normal Çalışma','16:00','00:00','16:15','00:00','00:30',NULL),
 (77,53,8,'% 50 Mesai','00:00','15:00',NULL,NULL,'00:30',NULL),
 (78,54,9,'%100 Mesai','16:00','15:00',NULL,NULL,'00:30',NULL),
 (79,55,7,'Normal Çalışma','00:00','08:00','00:15','08:00','00:30',NULL),
 (80,55,8,'% 50 Mesai','08:00','23:00',NULL,NULL,'00:30',NULL),
 (81,56,9,'%100 Mesai','00:00','23:00',NULL,NULL,'00:30',NULL),
 (82,57,7,'Normal Çalışma','08:00','18:00','08:15','19:00','00:30',NULL),
 (83,57,8,'% 50 Mesai','19:00','07:00',NULL,NULL,'00:30',NULL),
 (84,58,7,'Normal Çalışma','08:00','13:00','08:15','13:00','00:30',NULL),
 (85,58,8,'% 50 Mesai','13:00','07:00',NULL,NULL,'00:30',NULL),
 (86,59,9,'%100 Mesai','08:00','07:00',NULL,NULL,'00:30',NULL),
 (87,60,7,'Normal Çalışma','19:00','06:00','19:15','06:00','00:30',NULL),
 (88,60,8,'% 50 Mesai','06:00','18:00',NULL,NULL,'00:30',NULL),
 (89,61,8,'% 50 Mesai','19:00','18:00',NULL,NULL,'00:30',NULL),
 (90,62,9,'%100 Mesai','19:00','18:00',NULL,NULL,'00:30',NULL),
 (91,63,7,'Normal Çalışma','08:00','18:00','08:10','18:00',NULL,NULL),
 (92,64,9,'%100 Mesai','08:00','07:00',NULL,NULL,'00:30',NULL),
 (93,65,9,'%100 Mesai','08:00','07:00',NULL,NULL,'00:30',NULL),
 (94,66,7,'Normal Çalışma','08:00','13:00','08:15','13:00','00:30',NULL),
 (95,66,9,'%100 Mesai','13:00','07:00',NULL,NULL,'00:30',NULL),
 (96,67,8,'% 50 Mesai','08:00','18:00','08:10','18:00','00:30',NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_calismaturleri
-- 

DROP TABLE IF EXISTS pts_calismaturleri;
CREATE TABLE `pts_calismaturleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` smallint(6) DEFAULT NULL,
  `ad` varchar(10) DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  `katsayi` int(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  `hesaptipi` varchar(10) DEFAULT NULL,
  `aktarimkod` smallint(6) DEFAULT NULL,
  `gunluksaat` varchar(5) DEFAULT NULL,
  `kod2` smallint(6) DEFAULT NULL,
  `sgk` varchar(6) DEFAULT 'var',
  `gv` varchar(6) DEFAULT 'var',
  `dv` varchar(6) DEFAULT 'var',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_calismaturleri
-- 

LOCK TABLES pts_calismaturleri WRITE;
INSERT INTO pts_calismaturleri VALUES
 (7,1,'N.Ç','normalcalisma',0,'Normal Çalışma','ucretli',NULL,NULL,1,'var','var','var'),
 (8,2,'%50','fazlamesai',50,'% 50 Mesai','ucretli',NULL,NULL,NULL,'var','var','var'),
 (9,3,'%100','fazlamesai',100,'%100 Mesai','ucretli',NULL,NULL,NULL,'var','var','var'),
 (10,NULL,'H.T','normalcalisma',0,'Hafta Tatili','ucretli',NULL,NULL,NULL,'var','var','var'),
 (11,NULL,'R.T','normalcalisma',0,'Resmi Tatil ve Bayram Tatili','ucretli',NULL,NULL,NULL,'var','var','var');
UNLOCK TABLES;

-- 
-- Table structure for table pts_cezaparametre
-- 

DROP TABLE IF EXISTS pts_cezaparametre;
CREATE TABLE `pts_cezaparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `tip` varchar(3) DEFAULT NULL,
  `tolerans` int(11) DEFAULT NULL,
  `kesinti` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_cezaparametre_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_cezaparametre
-- 

-- 
-- Table structure for table pts_cezaparametre2
-- 

DROP TABLE IF EXISTS pts_cezaparametre2;
CREATE TABLE `pts_cezaparametre2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `geckatsayi` decimal(11,2) DEFAULT NULL,
  `erkkatsayi` decimal(11,2) DEFAULT NULL,
  `ekskatsayi` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_cezaparametre2_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_cezaparametre2
-- 

LOCK TABLES pts_cezaparametre2 WRITE;
INSERT INTO pts_cezaparametre2 VALUES
 (1,56,NULL,NULL,NULL),
 (2,55,NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_digerparametre
-- 

DROP TABLE IF EXISTS pts_digerparametre;
CREATE TABLE `pts_digerparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `devamsizlikceza_saat` varchar(5) DEFAULT NULL,
  `nctamamlasonramesaiver` tinyint(1) DEFAULT '0',
  `eksiksureyoksay` tinyint(1) DEFAULT '0',
  `dvmkesinti_bordroid` int(11) DEFAULT NULL COMMENT 'devamsizlik',
  `geckesinti_bordroid` int(11) DEFAULT NULL COMMENT 'gec kalma',
  `erkkesinti_bordroid` int(11) DEFAULT NULL COMMENT 'erken çıkma',
  `ekskesinti_bordroid` int(11) DEFAULT NULL COMMENT 'eksik süre',
  `gecErkEksCezaKullan` tinyint(1) DEFAULT '0',
  `gunasiri` tinyint(1) DEFAULT '0',
  `birsonrakigunesay` tinyint(1) DEFAULT '0',
  `maxtolerans` varchar(10) DEFAULT NULL COMMENT 'nctamamlasonramesaiver icin',
  `tolerans_saat` varchar(10) DEFAULT NULL,
  `tolerans_fmid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_digerparametre_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_digerparametre
-- 

LOCK TABLES pts_digerparametre WRITE;
INSERT INTO pts_digerparametre VALUES
 (1,56,NULL,0,0,NULL,NULL,NULL,NULL,0,0,1,NULL,NULL,NULL),
 (2,55,NULL,0,0,NULL,NULL,NULL,NULL,0,0,1,NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_donemparametre
-- 

DROP TABLE IF EXISTS pts_donemparametre;
CREATE TABLE `pts_donemparametre` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `grupid` bigint(20) NOT NULL,
  `bastarih` date DEFAULT NULL,
  `bittarih` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `eksikgun` smallint(6) DEFAULT NULL,
  `eksiksaat` varchar(6) DEFAULT NULL,
  `fazlagun` smallint(6) DEFAULT NULL,
  `fazlasaat` varchar(6) DEFAULT NULL,
  `yil` int(11) DEFAULT NULL,
  `gunfarki` smallint(6) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `grupid` (`grupid`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_donemparametre
-- 

LOCK TABLES pts_donemparametre WRITE;
INSERT INTO pts_donemparametre VALUES
 (1,11,'2015-01-01','2015-01-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (2,11,'2015-02-01','2015-02-28',NULL,NULL,2,'18:00',NULL,NULL,2015,28,NULL,NULL),
 (3,11,'2015-03-01','2015-03-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (4,11,'2015-04-01','2015-04-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (5,11,'2015-05-01','2015-05-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (6,11,'2015-06-01','2015-06-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (7,11,'2015-07-01','2015-07-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (8,11,'2015-08-01','2015-08-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (9,11,'2015-09-01','2015-09-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (10,11,'2015-10-01','2015-10-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (11,11,'2015-11-01','2015-11-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (12,11,'2015-12-01','2015-12-31',NULL,NULL,NULL,NULL,1,'09:00',2015,31,NULL,NULL),
 (13,12,'2015-01-01','2015-01-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (14,12,'2015-02-01','2015-02-28',NULL,NULL,2,'15:00',NULL,NULL,2015,28,NULL,NULL),
 (15,12,'2015-03-01','2015-03-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (16,12,'2015-04-01','2015-04-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (17,12,'2015-05-01','2015-05-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (18,12,'2015-06-01','2015-06-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (19,12,'2015-07-01','2015-07-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (20,12,'2015-08-01','2015-08-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (21,12,'2015-09-01','2015-09-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (22,12,'2015-10-01','2015-10-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (23,12,'2015-11-01','2015-11-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (24,12,'2015-12-01','2015-12-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (25,14,'2015-01-01','2015-01-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (26,14,'2015-02-01','2015-02-28',NULL,NULL,2,'15:00',NULL,NULL,2015,28,NULL,NULL),
 (27,14,'2015-03-01','2015-03-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (28,14,'2015-04-01','2015-04-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (29,14,'2015-05-01','2015-05-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (30,14,'2015-06-01','2015-06-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (31,14,'2015-07-01','2015-07-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (32,14,'2015-08-01','2015-08-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (33,14,'2015-09-01','2015-09-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (34,14,'2015-10-01','2015-10-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (35,14,'2015-11-01','2015-11-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (36,14,'2015-12-01','2015-12-31',NULL,NULL,NULL,NULL,1,'07:30',2015,31,NULL,NULL),
 (37,13,'2015-01-01','2015-01-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (38,13,'2015-02-01','2015-02-28',NULL,NULL,2,'16:00',NULL,NULL,2015,28,NULL,NULL),
 (39,13,'2015-03-01','2015-03-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (40,13,'2015-04-01','2015-04-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (41,13,'2015-05-01','2015-05-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (42,13,'2015-06-01','2015-06-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (43,13,'2015-07-01','2015-07-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (44,13,'2015-08-01','2015-08-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (45,13,'2015-09-01','2015-09-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (46,13,'2015-10-01','2015-10-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL),
 (47,13,'2015-11-01','2015-11-30',NULL,NULL,NULL,NULL,NULL,NULL,2015,30,NULL,NULL),
 (48,13,'2015-12-01','2015-12-31',NULL,NULL,NULL,NULL,1,'08:00',2015,31,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_extra
-- 

DROP TABLE IF EXISTS pts_extra;
CREATE TABLE `pts_extra` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  `extraturid` int(11) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_extra
-- 

-- 
-- Table structure for table pts_extra1
-- 

DROP TABLE IF EXISTS pts_extra1;
CREATE TABLE `pts_extra1` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  `extraturid` int(11) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_extra1
-- 

-- 
-- Table structure for table pts_extraturleri
-- 

DROP TABLE IF EXISTS pts_extraturleri;
CREATE TABLE `pts_extraturleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` smallint(6) DEFAULT NULL,
  `ad` varchar(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  `tip` varchar(15) DEFAULT NULL,
  `aktarimkod` smallint(6) DEFAULT NULL,
  `kod2` smallint(6) DEFAULT NULL,
  `sgk` varchar(6) DEFAULT 'var',
  `gv` varchar(6) DEFAULT 'var',
  `dv` varchar(6) DEFAULT 'var',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_extraturleri
-- 

LOCK TABLES pts_extraturleri WRITE;
INSERT INTO pts_extraturleri VALUES
 (5,1,'Avans',NULL,'kesinti',NULL,NULL,'var','var','var'),
 (6,2,'Prim',NULL,'kazanc',NULL,NULL,'var','var','var'),
 (7,3,'Banka',NULL,'kesinti',NULL,NULL,'var','var','var');
UNLOCK TABLES;

-- 
-- Table structure for table pts_gcyuvarlamaparametre
-- 

DROP TABLE IF EXISTS pts_gcyuvarlamaparametre;
CREATE TABLE `pts_gcyuvarlamaparametre` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `baslamasaati` varchar(6) DEFAULT NULL,
  `bitissaati` varchar(6) DEFAULT NULL,
  `yuvarlamasaati` varchar(6) DEFAULT NULL,
  `tip` varchar(10) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  `yuvarlamatolerans` int(11) DEFAULT NULL,
  `yuvarlamagun` varchar(15) DEFAULT NULL,
  `grupid` int(11) NOT NULL,
  `aktarilsinmi` tinyint(1) DEFAULT '1',
  `gecebassaat` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_gcyuvarlamaparametre
-- 

-- 
-- Table structure for table pts_genelayarlar
-- 

DROP TABLE IF EXISTS pts_genelayarlar;
CREATE TABLE `pts_genelayarlar` (
  `agigoster` tinyint(1) DEFAULT '0',
  `yolgoster` tinyint(1) DEFAULT '0',
  `primgoster` tinyint(1) DEFAULT '0',
  `yemekgoster` tinyint(1) DEFAULT '0',
  `wcgoster` tinyint(1) DEFAULT '0',
  `agibruttutar` decimal(11,2) DEFAULT NULL,
  `yuvarlamasaat` int(11) DEFAULT NULL,
  `sgkkullan` tinyint(1) DEFAULT '0',
  `devirkullan` tinyint(1) DEFAULT '0' COMMENT 'odeme islemi kullanılıyorsa, gecen aydan kalan maasi bir sonraki aya devretsin',
  `cikistayedekal` tinyint(1) DEFAULT '0',
  `htkkullan` tinyint(1) DEFAULT '0',
  `hitkullan` tinyint(1) DEFAULT '0',
  `printerindex` smallint(6) DEFAULT NULL,
  `donembaslamatarihi` date DEFAULT NULL,
  `donembitistarihi` date DEFAULT NULL,
  `firmaayri` tinyint(1) DEFAULT '1',
  `gcsaatyuvarla` tinyint(1) DEFAULT '0',
  `appTask` varchar(10) DEFAULT NULL,
  `aktarimpath` longtext,
  `agitipi` tinyint(1) DEFAULT '0',
  `eksikcalisma` tinyint(1) DEFAULT '0',
  `donemfarkigoster` tinyint(1) DEFAULT '0',
  `ucretayri` tinyint(1) DEFAULT '0',
  `data2` varchar(30) DEFAULT NULL,
  `zeminrengi` int(11) DEFAULT NULL,
  `ozelucretgoster` tinyint(1) DEFAULT '0',
  `gunlukgecissayisi` tinyint(1) DEFAULT '0',
  `birimucret` decimal(11,2) DEFAULT NULL,
  `uyeprogrammodu` tinyint(1) DEFAULT '0',
  `saatyuvarlamatipi` tinyint(1) DEFAULT '0',
  `ucretyuvarlamatipi` tinyint(1) DEFAULT '0',
  `saatyon` varchar(1) DEFAULT NULL,
  `ucretyon` varchar(1) DEFAULT NULL,
  `yuvarlamaucret` decimal(11,2) DEFAULT NULL,
  `agi_bayanesdurumu` tinyint(1) DEFAULT '0',
  `cezakesinti` tinyint(1) DEFAULT '0',
  `terminalototipi` tinyint(1) DEFAULT '0',
  `otodakika` int(11) DEFAULT NULL,
  `kartnooto` tinyint(1) DEFAULT '0' COMMENT 'yeni kayitta kartno yu otomatik arttirmak icin',
  `puantajkitle` int(11) DEFAULT NULL,
  `maxmesaisaat` varchar(10) DEFAULT NULL COMMENT 'resmide max mesai saati icin',
  `eksikcalismasubat` tinyint(1) DEFAULT '0' COMMENT 'Subat ayı icin',
  `odemekullan` tinyint(1) DEFAULT '0' COMMENT 'pts_odeme iptal olur kazanckesinti olarak odeme yapmak icin',
  `kisiselbordro` tinyint(1) DEFAULT '0' COMMENT 'dizayn ekrani olan ayrintili kisisel bordroyu aktif yapar',
  `donemaltgrupkullan` tinyint(1) DEFAULT '0' COMMENT 'vardiyali gruplarda altgruplar icin',
  `gclistekapiterminalgoster` tinyint(1) DEFAULT '0',
  `brutucretkullan` tinyint(1) DEFAULT '0',
  `sgkisegiristarihikullan` tinyint(1) DEFAULT '0',
  `yillikmaxmesaisaati` varchar(6) DEFAULT NULL,
  `ncyeekle` tinyint(1) DEFAULT '0',
  `ncgunal` tinyint(1) DEFAULT '0',
  `mesaigoster` tinyint(1) DEFAULT '0',
  `egitimgoster` tinyint(1) DEFAULT '0',
  `dosyagoster` tinyint(1) DEFAULT '0',
  `zimmetgoster` tinyint(1) DEFAULT '0',
  `yemekhane1` tinyint(1) DEFAULT '0',
  `yemekhane2` tinyint(1) DEFAULT '0',
  `giriscikis1` tinyint(1) DEFAULT '0',
  `giriscikis2` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_genelayarlar
-- 

LOCK TABLES pts_genelayarlar WRITE;
INSERT INTO pts_genelayarlar VALUES
 (0,0,0,0,0,886.50,NULL,0,0,1,0,0,NULL,NULL,NULL,0,0,'gayriresmi',NULL,0,0,0,0,NULL,NULL,0,0,NULL,0,0,0,'+','+',NULL,0,0,0,NULL,0,NULL,NULL,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,1,0,0,0),
 (0,0,0,0,0,886.50,NULL,0,0,0,0,0,NULL,NULL,NULL,1,0,'gayriresmi',NULL,0,0,0,0,NULL,NULL,0,0,NULL,0,0,0,'+','+',NULL,0,0,0,NULL,0,NULL,NULL,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0);
UNLOCK TABLES;

-- 
-- Table structure for table pts_giriscikis
-- 

DROP TABLE IF EXISTS pts_giriscikis;
CREATE TABLE `pts_giriscikis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(5) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `izinturid` int(11) DEFAULT NULL,
  `izinsure` varchar(6) DEFAULT NULL,
  `aciklama` varchar(250) DEFAULT NULL,
  `geciptal` tinyint(1) DEFAULT '0',
  `erkiptal` tinyint(1) DEFAULT '0',
  `eksiptal` tinyint(1) DEFAULT '0',
  `mesaiiptal` tinyint(1) DEFAULT '0',
  `kapiterminalid` int(11) DEFAULT NULL,
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  `kapiterminalkod` varchar(10) DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  `iizinsure` int(11) DEFAULT '0',
  `kartno` varchar(10) DEFAULT NULL,
  `girissaati1` time DEFAULT NULL,
  `cikissaati1` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_giriscikis
-- 

-- 
-- Table structure for table pts_giriscikis1
-- 

DROP TABLE IF EXISTS pts_giriscikis1;
CREATE TABLE `pts_giriscikis1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(5) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `izinturid` int(11) DEFAULT NULL,
  `izinsure` varchar(6) DEFAULT NULL,
  `aciklama` varchar(250) DEFAULT NULL,
  `geciptal` tinyint(1) DEFAULT '0',
  `erkiptal` tinyint(1) DEFAULT '0',
  `eksiptal` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_giriscikis1
-- 

-- 
-- Table structure for table pts_gruphit
-- 

DROP TABLE IF EXISTS pts_gruphit;
CREATE TABLE `pts_gruphit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `grupid` int(11) NOT NULL,
  `tip` tinyint(1) DEFAULT NULL,
  `hi1` tinyint(1) DEFAULT NULL,
  `hi2` tinyint(1) DEFAULT NULL,
  `hi3` tinyint(1) DEFAULT NULL,
  `hi4` tinyint(1) DEFAULT NULL,
  `hi5` tinyint(1) DEFAULT NULL,
  `hi6` tinyint(1) DEFAULT NULL,
  `hi7` tinyint(1) DEFAULT NULL,
  `hi8` tinyint(1) DEFAULT NULL,
  `hs1` tinyint(1) DEFAULT NULL,
  `hs2` tinyint(1) DEFAULT NULL,
  `hs3` tinyint(1) DEFAULT NULL,
  `hs4` tinyint(1) DEFAULT NULL,
  `hs5` tinyint(1) DEFAULT NULL,
  `hs6` tinyint(1) DEFAULT NULL,
  `hs7` tinyint(1) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_gruphit
-- 

-- 
-- Table structure for table pts_gruphtk
-- 

DROP TABLE IF EXISTS pts_gruphtk;
CREATE TABLE `pts_gruphtk` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `grupid` int(11) NOT NULL,
  `tip` tinyint(1) DEFAULT NULL,
  `hi1` tinyint(1) DEFAULT NULL,
  `hi2` tinyint(1) DEFAULT NULL,
  `hi3` tinyint(1) DEFAULT NULL,
  `hi4` tinyint(1) DEFAULT NULL,
  `hi5` tinyint(1) DEFAULT NULL,
  `hi6` tinyint(1) DEFAULT NULL,
  `hi7` tinyint(1) DEFAULT NULL,
  `hi8` tinyint(1) DEFAULT NULL,
  `hs1` tinyint(1) DEFAULT NULL,
  `hs2` tinyint(1) DEFAULT NULL,
  `hs3` tinyint(1) DEFAULT NULL,
  `hs4` tinyint(1) DEFAULT NULL,
  `hs5` tinyint(1) DEFAULT NULL,
  `hs6` tinyint(1) DEFAULT NULL,
  `hs7` tinyint(1) DEFAULT NULL,
  `hesaplamatipi` varchar(10) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_gruphtk
-- 

-- 
-- Table structure for table pts_gunparametre
-- 

DROP TABLE IF EXISTS pts_gunparametre;
CREATE TABLE `pts_gunparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grupid` int(11) DEFAULT NULL,
  `altgrupid` int(11) NOT NULL,
  `g1` int(11) DEFAULT NULL,
  `g2` int(11) DEFAULT NULL,
  `g3` int(11) DEFAULT NULL,
  `g4` int(11) DEFAULT NULL,
  `g5` int(11) DEFAULT NULL,
  `g6` int(11) DEFAULT NULL,
  `g7` int(11) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `altgrupid` (`altgrupid`),
  CONSTRAINT `pts_gunparametre_fk` FOREIGN KEY (`altgrupid`) REFERENCES `pts_altgrup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table pts_gunparametre
-- 

LOCK TABLES pts_gunparametre WRITE;
INSERT INTO pts_gunparametre VALUES
 (15,11,14,50,48,48,48,48,48,49,'gayriresmi'),
 (16,12,15,52,51,51,51,51,51,51,'gayriresmi'),
 (17,12,16,54,53,53,53,53,53,53,'gayriresmi'),
 (18,12,17,56,55,55,55,55,55,55,'gayriresmi'),
 (19,13,18,59,57,57,57,57,57,58,'gayriresmi'),
 (20,13,20,62,60,60,60,60,60,61,'gayriresmi'),
 (21,14,19,64,63,63,63,63,63,67,'gayriresmi');
UNLOCK TABLES;

-- 
-- Table structure for table pts_icmal
-- 

DROP TABLE IF EXISTS pts_icmal;
CREATE TABLE `pts_icmal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(10) NOT NULL,
  `bastarih` date DEFAULT NULL,
  `bittarih` date DEFAULT NULL,
  `devamsizlikgun` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat` varchar(6) DEFAULT NULL,
  `devamsizlikucret` decimal(11,2) DEFAULT NULL,
  `geckalmagun` decimal(11,2) DEFAULT NULL,
  `geckalmasaat` varchar(6) DEFAULT NULL,
  `geckalmaucret` decimal(11,2) DEFAULT NULL,
  `erkencikmagun` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat` varchar(6) DEFAULT NULL,
  `erkencikmaucret` decimal(11,2) DEFAULT NULL,
  `eksikcalismagun` decimal(11,2) DEFAULT NULL,
  `eksikcalismasaat` varchar(6) DEFAULT NULL,
  `eksikcalismaucret` decimal(11,2) DEFAULT NULL,
  `devamsizlikgun_ceza` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat_ceza` varchar(6) DEFAULT NULL,
  `devamsizlikucret_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmagun_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmasaat_ceza` varchar(6) DEFAULT NULL,
  `geckalmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmagun_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat_ceza` varchar(6) DEFAULT NULL,
  `erkencikmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `eksikcalismagun_ceza` decimal(11,2) DEFAULT NULL,
  `eksikcalismasaat_ceza` varchar(6) DEFAULT NULL,
  `eksikcalismaucret_ceza` decimal(11,2) DEFAULT NULL,
  `cgun1` decimal(11,2) DEFAULT NULL,
  `csaat1` varchar(6) DEFAULT NULL,
  `cucret1` decimal(11,2) DEFAULT NULL,
  `cgun2` decimal(11,2) DEFAULT NULL,
  `csaat2` varchar(6) DEFAULT NULL,
  `cucret2` decimal(11,2) DEFAULT NULL,
  `cgun3` decimal(11,2) DEFAULT NULL,
  `csaat3` varchar(6) DEFAULT NULL,
  `cucret3` decimal(11,2) DEFAULT NULL,
  `cgun4` decimal(11,2) DEFAULT NULL,
  `csaat4` varchar(6) DEFAULT NULL,
  `cucret4` decimal(11,2) DEFAULT NULL,
  `cgun5` decimal(11,2) DEFAULT NULL,
  `csaat5` varchar(6) DEFAULT NULL,
  `cucret5` decimal(11,2) DEFAULT NULL,
  `cgun6` decimal(11,2) DEFAULT NULL,
  `csaat6` varchar(6) DEFAULT NULL,
  `cucret6` decimal(11,2) DEFAULT NULL,
  `cgun7` decimal(11,2) DEFAULT NULL,
  `csaat7` varchar(6) DEFAULT NULL,
  `cucret7` decimal(11,2) DEFAULT NULL,
  `cgun8` decimal(11,2) DEFAULT NULL,
  `csaat8` varchar(6) DEFAULT NULL,
  `cucret8` decimal(11,2) DEFAULT NULL,
  `cgun9` decimal(11,2) DEFAULT NULL,
  `csaat9` varchar(6) DEFAULT NULL,
  `cucret9` decimal(11,2) DEFAULT NULL,
  `cgun10` decimal(11,2) DEFAULT NULL,
  `csaat10` varchar(6) DEFAULT NULL,
  `cucret10` decimal(11,2) DEFAULT NULL,
  `cgun11` decimal(11,2) DEFAULT NULL,
  `csaat11` varchar(6) DEFAULT NULL,
  `cucret11` decimal(11,2) DEFAULT NULL,
  `cgun12` decimal(11,2) DEFAULT NULL,
  `csaat12` varchar(6) DEFAULT NULL,
  `cucret12` decimal(11,2) DEFAULT NULL,
  `cgun13` decimal(11,2) DEFAULT NULL,
  `csaat13` varchar(6) DEFAULT NULL,
  `cucret13` decimal(11,2) DEFAULT NULL,
  `cgun14` decimal(11,2) DEFAULT NULL,
  `csaat14` varchar(6) DEFAULT NULL,
  `cucret14` decimal(11,2) DEFAULT NULL,
  `cgun15` decimal(11,2) DEFAULT NULL,
  `csaat15` varchar(6) DEFAULT NULL,
  `cucret15` decimal(11,2) DEFAULT NULL,
  `cgun16` decimal(11,2) DEFAULT NULL,
  `csaat16` varchar(6) DEFAULT NULL,
  `cucret16` decimal(11,2) DEFAULT NULL,
  `cgun17` decimal(11,2) DEFAULT NULL,
  `csaat17` varchar(6) DEFAULT NULL,
  `cucret17` decimal(11,2) DEFAULT NULL,
  `cgun18` decimal(11,2) DEFAULT NULL,
  `csaat18` varchar(6) DEFAULT NULL,
  `cucret18` decimal(11,2) DEFAULT NULL,
  `cgun19` decimal(11,2) DEFAULT NULL,
  `csaat19` varchar(6) DEFAULT NULL,
  `cucret19` decimal(11,2) DEFAULT NULL,
  `cgun20` decimal(11,2) DEFAULT NULL,
  `csaat20` varchar(6) DEFAULT NULL,
  `cucret20` decimal(11,2) DEFAULT NULL,
  `cgun21` decimal(11,2) DEFAULT NULL,
  `csaat21` varchar(6) DEFAULT NULL,
  `cucret21` decimal(11,2) DEFAULT NULL,
  `cgun22` decimal(11,2) DEFAULT NULL,
  `csaat22` varchar(6) DEFAULT NULL,
  `cucret22` decimal(11,2) DEFAULT NULL,
  `cgun23` decimal(11,2) DEFAULT NULL,
  `csaat23` varchar(6) DEFAULT NULL,
  `cucret23` decimal(11,2) DEFAULT NULL,
  `cgun24` decimal(11,2) DEFAULT NULL,
  `csaat24` varchar(6) DEFAULT NULL,
  `cucret24` decimal(11,2) DEFAULT NULL,
  `cgun25` decimal(11,2) DEFAULT NULL,
  `csaat25` varchar(6) DEFAULT NULL,
  `cucret25` decimal(11,2) DEFAULT NULL,
  `cgun26` decimal(11,2) DEFAULT NULL,
  `csaat26` varchar(6) DEFAULT NULL,
  `cucret26` decimal(11,2) DEFAULT NULL,
  `cgun27` decimal(11,2) DEFAULT NULL,
  `csaat27` varchar(6) DEFAULT NULL,
  `cucret27` decimal(11,2) DEFAULT NULL,
  `cgun28` decimal(11,2) DEFAULT NULL,
  `csaat28` varchar(6) DEFAULT NULL,
  `cucret28` decimal(11,2) DEFAULT NULL,
  `cgun29` decimal(11,2) DEFAULT NULL,
  `csaat29` varchar(6) DEFAULT NULL,
  `cucret29` decimal(11,2) DEFAULT NULL,
  `cgun30` decimal(11,2) DEFAULT NULL,
  `csaat30` varchar(6) DEFAULT NULL,
  `cucret30` decimal(11,2) DEFAULT NULL,
  `cgun31` decimal(11,2) DEFAULT NULL,
  `csaat31` varchar(6) DEFAULT NULL,
  `cucret31` decimal(11,2) DEFAULT NULL,
  `cgun32` decimal(11,2) DEFAULT NULL,
  `csaat32` varchar(6) DEFAULT NULL,
  `cucret32` decimal(11,2) DEFAULT NULL,
  `igun1` decimal(11,2) DEFAULT NULL,
  `isaat1` varchar(6) DEFAULT NULL,
  `iucret1` decimal(11,2) DEFAULT NULL,
  `igun2` decimal(11,2) DEFAULT NULL,
  `isaat2` varchar(6) DEFAULT NULL,
  `iucret2` decimal(11,2) DEFAULT NULL,
  `igun3` decimal(11,2) DEFAULT NULL,
  `isaat3` varchar(6) DEFAULT NULL,
  `iucret3` decimal(11,2) DEFAULT NULL,
  `igun4` decimal(11,2) DEFAULT NULL,
  `isaat4` varchar(6) DEFAULT NULL,
  `iucret4` decimal(11,2) DEFAULT NULL,
  `igun5` decimal(11,2) DEFAULT NULL,
  `isaat5` varchar(6) DEFAULT NULL,
  `iucret5` decimal(11,2) DEFAULT NULL,
  `igun6` decimal(11,2) DEFAULT NULL,
  `isaat6` varchar(6) DEFAULT NULL,
  `iucret6` decimal(11,2) DEFAULT NULL,
  `igun7` decimal(11,2) DEFAULT NULL,
  `isaat7` varchar(6) DEFAULT NULL,
  `iucret7` decimal(11,2) DEFAULT NULL,
  `igun8` decimal(11,2) DEFAULT NULL,
  `isaat8` varchar(6) DEFAULT NULL,
  `iucret8` decimal(11,2) DEFAULT NULL,
  `igun9` decimal(11,2) DEFAULT NULL,
  `isaat9` varchar(6) DEFAULT NULL,
  `iucret9` decimal(11,2) DEFAULT NULL,
  `igun10` decimal(11,2) DEFAULT NULL,
  `isaat10` varchar(6) DEFAULT NULL,
  `iucret10` decimal(11,2) DEFAULT NULL,
  `igun11` decimal(11,2) DEFAULT NULL,
  `isaat11` varchar(6) DEFAULT NULL,
  `iucret11` decimal(11,2) DEFAULT NULL,
  `igun12` decimal(11,2) DEFAULT NULL,
  `isaat12` varchar(6) DEFAULT NULL,
  `iucret12` decimal(11,2) DEFAULT NULL,
  `igun13` decimal(11,2) DEFAULT NULL,
  `isaat13` varchar(6) DEFAULT NULL,
  `iucret13` decimal(11,2) DEFAULT NULL,
  `igun14` decimal(11,2) DEFAULT NULL,
  `isaat14` varchar(6) DEFAULT NULL,
  `iucret14` decimal(11,2) DEFAULT NULL,
  `igun15` decimal(11,2) DEFAULT NULL,
  `isaat15` varchar(6) DEFAULT NULL,
  `iucret15` decimal(11,2) DEFAULT NULL,
  `igun16` decimal(11,2) DEFAULT NULL,
  `isaat16` varchar(6) DEFAULT NULL,
  `iucret16` decimal(11,2) DEFAULT NULL,
  `igun17` decimal(11,2) DEFAULT NULL,
  `isaat17` varchar(6) DEFAULT NULL,
  `iucret17` decimal(11,2) DEFAULT NULL,
  `igun18` decimal(11,2) DEFAULT NULL,
  `isaat18` varchar(6) DEFAULT NULL,
  `iucret18` decimal(11,2) DEFAULT NULL,
  `igun19` decimal(11,2) DEFAULT NULL,
  `isaat19` varchar(6) DEFAULT NULL,
  `iucret19` decimal(11,2) DEFAULT NULL,
  `igun20` decimal(11,2) DEFAULT NULL,
  `isaat20` varchar(6) DEFAULT NULL,
  `iucret20` decimal(11,2) DEFAULT NULL,
  `igun21` decimal(11,2) DEFAULT NULL,
  `isaat21` varchar(6) DEFAULT NULL,
  `iucret21` decimal(11,2) DEFAULT NULL,
  `igun22` decimal(11,2) DEFAULT NULL,
  `isaat22` varchar(6) DEFAULT NULL,
  `iucret22` decimal(11,2) DEFAULT NULL,
  `igun23` decimal(11,2) DEFAULT NULL,
  `isaat23` varchar(6) DEFAULT NULL,
  `iucret23` decimal(11,2) DEFAULT NULL,
  `igun24` decimal(11,2) DEFAULT NULL,
  `isaat24` varchar(6) DEFAULT NULL,
  `iucret24` decimal(11,2) DEFAULT NULL,
  `igun25` decimal(11,2) DEFAULT NULL,
  `isaat25` varchar(6) DEFAULT NULL,
  `iucret25` decimal(11,2) DEFAULT NULL,
  `igun26` decimal(11,2) DEFAULT NULL,
  `isaat26` varchar(6) DEFAULT NULL,
  `iucret26` decimal(11,2) DEFAULT NULL,
  `igun27` decimal(11,2) DEFAULT NULL,
  `isaat27` varchar(6) DEFAULT NULL,
  `iucret27` decimal(11,2) DEFAULT NULL,
  `igun28` decimal(11,2) DEFAULT NULL,
  `isaat28` varchar(6) DEFAULT NULL,
  `iucret28` decimal(11,2) DEFAULT NULL,
  `igun29` decimal(11,2) DEFAULT NULL,
  `isaat29` varchar(6) DEFAULT NULL,
  `iucret29` decimal(11,2) DEFAULT NULL,
  `igun30` decimal(11,2) DEFAULT NULL,
  `isaat30` varchar(6) DEFAULT NULL,
  `iucret30` decimal(11,2) DEFAULT NULL,
  `igun31` decimal(11,2) DEFAULT NULL,
  `isaat31` varchar(6) DEFAULT NULL,
  `iucret31` decimal(11,2) DEFAULT NULL,
  `igun32` decimal(11,2) DEFAULT NULL,
  `isaat32` varchar(6) DEFAULT NULL,
  `iucret32` decimal(11,2) DEFAULT NULL,
  `extra1` decimal(11,2) DEFAULT NULL,
  `extra2` decimal(11,2) DEFAULT NULL,
  `extra3` decimal(11,2) DEFAULT NULL,
  `extra4` decimal(11,2) DEFAULT NULL,
  `extra5` decimal(11,2) DEFAULT NULL,
  `extra6` decimal(11,2) DEFAULT NULL,
  `extra7` decimal(11,2) DEFAULT NULL,
  `extra8` decimal(11,2) DEFAULT NULL,
  `extra9` decimal(11,2) DEFAULT NULL,
  `extra10` decimal(11,2) DEFAULT NULL,
  `extra11` decimal(11,2) DEFAULT NULL,
  `extra12` decimal(11,2) DEFAULT NULL,
  `extra13` decimal(11,2) DEFAULT NULL,
  `extra14` decimal(11,2) DEFAULT NULL,
  `extra15` decimal(11,2) DEFAULT NULL,
  `extra16` decimal(11,2) DEFAULT NULL,
  `extra17` decimal(11,2) DEFAULT NULL,
  `extra18` decimal(11,2) DEFAULT NULL,
  `extra19` decimal(11,2) DEFAULT NULL,
  `extra20` decimal(11,2) DEFAULT NULL,
  `extra21` decimal(11,2) DEFAULT NULL,
  `extra22` decimal(11,2) DEFAULT NULL,
  `extra23` decimal(11,2) DEFAULT NULL,
  `extra24` decimal(11,2) DEFAULT NULL,
  `extra25` decimal(11,2) DEFAULT NULL,
  `extra26` decimal(11,2) DEFAULT NULL,
  `extra27` decimal(11,2) DEFAULT NULL,
  `extra28` decimal(11,2) DEFAULT NULL,
  `extra29` decimal(11,2) DEFAULT NULL,
  `extra30` decimal(11,2) DEFAULT NULL,
  `extra31` decimal(11,2) DEFAULT NULL,
  `extra32` decimal(11,2) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_icmal
-- 

-- 
-- Table structure for table pts_izin
-- 

DROP TABLE IF EXISTS pts_izin;
CREATE TABLE `pts_izin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `izinturid` int(11) DEFAULT NULL,
  `izinsure` varchar(6) DEFAULT NULL,
  `iizinsure` int(11) DEFAULT '0',
  `aciklama` varchar(250) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `sgk_eksikgunkodu` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_izin
-- 

-- 
-- Table structure for table pts_izinad
-- 

DROP TABLE IF EXISTS pts_izinad;
CREATE TABLE `pts_izinad` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_izinad
-- 

LOCK TABLES pts_izinad WRITE;
INSERT INTO pts_izinad VALUES
 (1,NULL,'Raporlu'),
 (2,NULL,'Görevli'),
 (3,NULL,'Hasta'),
 (4,NULL,'Yıllık İzin'),
 (5,NULL,'Özel');
UNLOCK TABLES;

-- 
-- Table structure for table pts_izinturleri
-- 

DROP TABLE IF EXISTS pts_izinturleri;
CREATE TABLE `pts_izinturleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` smallint(6) DEFAULT NULL,
  `ad` varchar(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  `katsayi` int(11) DEFAULT NULL,
  `aktarimkod` smallint(6) DEFAULT NULL,
  `kod2` smallint(6) DEFAULT NULL,
  `eksikkod` smallint(6) DEFAULT NULL,
  `sgk` varchar(6) DEFAULT 'var',
  `gv` varchar(6) DEFAULT 'var',
  `dv` varchar(6) DEFAULT 'var',
  `izinkod` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_izinturleri
-- 

LOCK TABLES pts_izinturleri WRITE;
INSERT INTO pts_izinturleri VALUES
 (4,1,'Ücr.İ','Ücretli İzin (Normal Çalışma)','ucretli',NULL,NULL,NULL,NULL,'var','var','var',NULL),
 (5,4,'Üsz.İ','Ücretsiz İzin','ucretsiz',NULL,NULL,NULL,NULL,'var','var','var',NULL),
 (6,NULL,'YIL','Yıllık İzin','ucretli',NULL,NULL,NULL,NULL,'var','var','var',NULL),
 (7,NULL,'MZR','Mazeret İzni','ucretsiz',NULL,NULL,NULL,NULL,'var','var','var',NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_kesintiparametre
-- 

DROP TABLE IF EXISTS pts_kesintiparametre;
CREATE TABLE `pts_kesintiparametre` (
  `dvmkesinti_bordroid` int(11) DEFAULT NULL,
  `geckesinti_bordroid` int(11) DEFAULT NULL,
  `erkkesinti_bordroid` int(11) DEFAULT NULL,
  `ekskesinti_bordroid` int(11) DEFAULT NULL,
  `appTask` varchar(10) DEFAULT NULL,
  `uszikesinti_bordroid` int(11) DEFAULT '7',
  `dvmkesinti_bordroid1` int(11) DEFAULT NULL,
  `dvmkesinti_bordroid2` int(11) DEFAULT NULL,
  `dvmkesinti_bordroid3` int(11) DEFAULT NULL,
  `geckesinti_bordroid1` int(11) DEFAULT NULL,
  `geckesinti_bordroid2` int(11) DEFAULT NULL,
  `geckesinti_bordroid3` int(11) DEFAULT NULL,
  `erkkesinti_bordroid1` int(11) DEFAULT NULL,
  `erkkesinti_bordroid2` int(11) DEFAULT NULL,
  `erkkesinti_bordroid3` int(11) DEFAULT NULL,
  `ekskesinti_bordroid1` int(11) DEFAULT NULL,
  `ekskesinti_bordroid2` int(11) DEFAULT NULL,
  `ekskesinti_bordroid3` int(11) DEFAULT NULL,
  `uszikesinti_bordroid1` int(11) DEFAULT NULL,
  `uszikesinti_bordroid2` int(11) DEFAULT NULL,
  `uszikesinti_bordroid3` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_kesintiparametre
-- 

LOCK TABLES pts_kesintiparametre WRITE;
INSERT INTO pts_kesintiparametre VALUES
 (7,7,7,7,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table pts_kisiselplan
-- 

DROP TABLE IF EXISTS pts_kisiselplan;
CREATE TABLE `pts_kisiselplan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tarih` date DEFAULT NULL,
  `personelid` bigint(20) DEFAULT NULL,
  `puantajid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_kisiselplan
-- 

-- 
-- Table structure for table pts_kstalanlar
-- 

DROP TABLE IF EXISTS pts_kstalanlar;
CREATE TABLE `pts_kstalanlar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alanid` int(11) DEFAULT NULL,
  `ad` varchar(20) DEFAULT NULL,
  `yetki` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_kstalanlar
-- 

LOCK TABLES pts_kstalanlar WRITE;
INSERT INTO pts_kstalanlar VALUES
 (21,0,'DVM',1),
 (22,0,'GEC',1),
 (23,0,'ERK',1),
 (24,0,'EKS',1),
 (25,6,'ÜSZ',1),
 (26,7,'ÖZL',0),
 (27,5,'Üsz.İ',0);
UNLOCK TABLES;

-- 
-- Table structure for table pts_mesai
-- 

DROP TABLE IF EXISTS pts_mesai;
CREATE TABLE `pts_mesai` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `isaat` int(11) DEFAULT '0',
  `calismaturid` int(11) DEFAULT NULL,
  `aciklama` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_mesai
-- 

-- 
-- Table structure for table pts_mesaiplani
-- 

DROP TABLE IF EXISTS pts_mesaiplani;
CREATE TABLE `pts_mesaiplani` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `mesai` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_mesaiplani
-- 

-- 
-- Table structure for table pts_molaparametre
-- 

DROP TABLE IF EXISTS pts_molaparametre;
CREATE TABLE `pts_molaparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `ad` varchar(100) DEFAULT NULL,
  `baslamasaati` varchar(5) DEFAULT NULL,
  `bitissaati` varchar(5) DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_molaparametre_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_molaparametre
-- 

LOCK TABLES pts_molaparametre WRITE;
INSERT INTO pts_molaparametre VALUES
 (10,48,'yemek','12:00','13:00','hesapla'),
 (11,51,'YEMEK','12:00','12:30','hesapla'),
 (12,53,'YEMEK','20:00','20:30','hesapla'),
 (13,55,'YEMEK','04:00','04:30','gece+'),
 (14,57,'YEMEK','12:00','14:00','hesapla'),
 (15,60,'yemek','01:00','03:00','hesapla');
UNLOCK TABLES;

-- 
-- Table structure for table pts_odeme
-- 

DROP TABLE IF EXISTS pts_odeme;
CREATE TABLE `pts_odeme` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  `tip` varchar(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_odeme
-- 

-- 
-- Table structure for table pts_ozelplan
-- 

DROP TABLE IF EXISTS pts_ozelplan;
CREATE TABLE `pts_ozelplan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tarih` date DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  `puantajid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_ozelplan
-- 

-- 
-- Table structure for table pts_perraporsablon
-- 

DROP TABLE IF EXISTS pts_perraporsablon;
CREATE TABLE `pts_perraporsablon` (
  `secim` tinyint(1) DEFAULT '0',
  `ad` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_perraporsablon
-- 

LOCK TABLES pts_perraporsablon WRITE;
INSERT INTO pts_perraporsablon VALUES
 (1,'kartno'),
 (1,'ad'),
 (1,'soyad'),
 (1,'kimlikno'),
 (1,'sicilno'),
 (1,'vergino'),
 (0,'sgk_no'),
 (0,'sgk_isegiristarihi'),
 (1,'durum'),
 (1,'ucret'),
 (1,'ucret_onceki'),
 (1,'isegiristarihi'),
 (1,'istencikistarihi'),
 (0,'istenayrilmanedeni'),
 (1,'grupad'),
 (1,'bolumad'),
 (1,'gorevad'),
 (1,'servisad'),
 (1,'bolgead'),
 (1,'firmaad'),
 (0,'birimad'),
 (0,'takimad'),
 (0,'subead'),
 (0,'evtel'),
 (0,'istel'),
 (0,'ceptel'),
 (0,'email'),
 (0,'webadres'),
 (0,'egitim'),
 (0,'yabancidil'),
 (0,'askerlikdurumu'),
 (0,'gozluk'),
 (0,'sabika'),
 (0,'kilo'),
 (0,'boy'),
 (1,'ayak'),
 (0,'elbisebedenno'),
 (0,'medenihali'),
 (0,'cocuksayisi'),
 (0,'esdurumu'),
 (1,'adres'),
 (0,'il'),
 (0,'ilce'),
 (0,'babaad'),
 (0,'annead'),
 (0,'dogumyeri'),
 (1,'dogumtarihi'),
 (0,'kangrubu'),
 (0,'uyruk'),
 (0,'cinsiyet'),
 (0,'nufus_il'),
 (0,'nufus_ilce'),
 (0,'nufus_mahkoy'),
 (0,'nufus_ciltno'),
 (0,'nufus_ailesirano'),
 (0,'nufus_cuzdanverildigiyer'),
 (0,'nufus_cuzdanverilisnedeni'),
 (0,'nufus_cuzdankayitno'),
 (0,'nufus_cuzdanverilistarihi'),
 (0,'banka_subeadi'),
 (0,'banka_hesapno'),
 (0,'ehliyet_sinif'),
 (0,'ehliyet_verililce'),
 (0,'ehliyet_belgeno'),
 (0,'ehliyet_vertarih'),
 (0,'ehliyet_kulcihazprotez');
UNLOCK TABLES;

-- 
-- Table structure for table pts_puantaj
-- 

DROP TABLE IF EXISTS pts_puantaj;
CREATE TABLE `pts_puantaj` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `devamsizlik` varchar(6) DEFAULT NULL,
  `geckalma` varchar(6) DEFAULT NULL,
  `erkencikma` varchar(6) DEFAULT NULL,
  `eksiksure` varchar(6) DEFAULT NULL,
  `devamsizlik_ceza` varchar(6) DEFAULT NULL,
  `geckalma_ceza` varchar(6) DEFAULT NULL,
  `erkencikma_ceza` varchar(6) DEFAULT NULL,
  `eksiksure_ceza` varchar(6) DEFAULT NULL,
  `devamsizlik_net` varchar(6) DEFAULT NULL,
  `geckalma_net` varchar(6) DEFAULT NULL,
  `erkencikma_net` varchar(6) DEFAULT NULL,
  `eksiksure_net` varchar(6) DEFAULT NULL,
  `devamsizlik_dak` int(11) DEFAULT '0',
  `geckalma_dak` int(11) DEFAULT '0',
  `erkencikma_dak` int(11) DEFAULT '0',
  `eksiksure_dak` int(11) DEFAULT '0',
  `devamsizlik_cezadak` int(11) DEFAULT '0',
  `geckalma_cezadak` int(11) DEFAULT '0',
  `erkencikma_cezadak` int(11) DEFAULT '0',
  `eksiksure_cezadak` int(11) DEFAULT '0',
  `devamsizlik_netdak` int(11) DEFAULT '0',
  `geckalma_netdak` int(11) DEFAULT '0',
  `erkencikma_netdak` int(11) DEFAULT '0',
  `eksiksure_netdak` int(11) DEFAULT '0',
  `c1` varchar(6) DEFAULT NULL,
  `c2` varchar(6) DEFAULT NULL,
  `c3` varchar(6) DEFAULT NULL,
  `c4` varchar(6) DEFAULT NULL,
  `c5` varchar(6) DEFAULT NULL,
  `c6` varchar(6) DEFAULT NULL,
  `c7` varchar(6) DEFAULT NULL,
  `c8` varchar(6) DEFAULT NULL,
  `c9` varchar(6) DEFAULT NULL,
  `c10` varchar(6) DEFAULT NULL,
  `c11` varchar(6) DEFAULT NULL,
  `c12` varchar(6) DEFAULT NULL,
  `c13` varchar(6) DEFAULT NULL,
  `c14` varchar(6) DEFAULT NULL,
  `c15` varchar(6) DEFAULT NULL,
  `c16` varchar(6) DEFAULT NULL,
  `c17` varchar(6) DEFAULT NULL,
  `c18` varchar(6) DEFAULT NULL,
  `c19` varchar(6) DEFAULT NULL,
  `c20` varchar(6) DEFAULT NULL,
  `c21` varchar(6) DEFAULT NULL,
  `c22` varchar(6) DEFAULT NULL,
  `c23` varchar(6) DEFAULT NULL,
  `c24` varchar(6) DEFAULT NULL,
  `c25` varchar(6) DEFAULT NULL,
  `c26` varchar(6) DEFAULT NULL,
  `c27` varchar(6) DEFAULT NULL,
  `c28` varchar(6) DEFAULT NULL,
  `c29` varchar(6) DEFAULT NULL,
  `c30` varchar(6) DEFAULT NULL,
  `c31` varchar(6) DEFAULT NULL,
  `c32` varchar(6) DEFAULT NULL,
  `i1` varchar(6) DEFAULT NULL,
  `i2` varchar(6) DEFAULT NULL,
  `i3` varchar(6) DEFAULT NULL,
  `i4` varchar(6) DEFAULT NULL,
  `i5` varchar(6) DEFAULT NULL,
  `i6` varchar(6) DEFAULT NULL,
  `i7` varchar(6) DEFAULT NULL,
  `i8` varchar(6) DEFAULT NULL,
  `i9` varchar(6) DEFAULT NULL,
  `i10` varchar(6) DEFAULT NULL,
  `i11` varchar(6) DEFAULT NULL,
  `i12` varchar(6) DEFAULT NULL,
  `i13` varchar(6) DEFAULT NULL,
  `i14` varchar(6) DEFAULT NULL,
  `i15` varchar(6) DEFAULT NULL,
  `i16` varchar(6) DEFAULT NULL,
  `i17` varchar(6) DEFAULT NULL,
  `i18` varchar(6) DEFAULT NULL,
  `i19` varchar(6) DEFAULT NULL,
  `i20` varchar(6) DEFAULT NULL,
  `i21` varchar(6) DEFAULT NULL,
  `i22` varchar(6) DEFAULT NULL,
  `i23` varchar(6) DEFAULT NULL,
  `i24` varchar(6) DEFAULT NULL,
  `i25` varchar(6) DEFAULT NULL,
  `i26` varchar(6) DEFAULT NULL,
  `i27` varchar(6) DEFAULT NULL,
  `i28` varchar(6) DEFAULT NULL,
  `i29` varchar(6) DEFAULT NULL,
  `i30` varchar(6) DEFAULT NULL,
  `i31` varchar(6) DEFAULT NULL,
  `i32` varchar(6) DEFAULT NULL,
  `cdak1` int(11) DEFAULT '0',
  `cdak2` int(11) DEFAULT '0',
  `cdak3` int(11) DEFAULT '0',
  `cdak4` int(11) DEFAULT '0',
  `cdak5` int(11) DEFAULT '0',
  `cdak6` int(11) DEFAULT '0',
  `cdak7` int(11) DEFAULT '0',
  `cdak8` int(11) DEFAULT '0',
  `cdak9` int(11) DEFAULT '0',
  `cdak10` int(11) DEFAULT '0',
  `cdak11` int(11) DEFAULT '0',
  `cdak12` int(11) DEFAULT '0',
  `cdak13` int(11) DEFAULT '0',
  `cdak14` int(11) DEFAULT '0',
  `cdak15` int(11) DEFAULT '0',
  `cdak16` int(11) DEFAULT '0',
  `cdak17` int(11) DEFAULT '0',
  `cdak18` int(11) DEFAULT '0',
  `cdak19` int(11) DEFAULT '0',
  `cdak20` int(11) DEFAULT '0',
  `cdak21` int(11) DEFAULT '0',
  `cdak22` int(11) DEFAULT '0',
  `cdak23` int(11) DEFAULT '0',
  `cdak24` int(11) DEFAULT '0',
  `cdak25` int(11) DEFAULT '0',
  `cdak26` int(11) DEFAULT '0',
  `cdak27` int(11) DEFAULT '0',
  `cdak28` int(11) DEFAULT '0',
  `cdak29` int(11) DEFAULT '0',
  `cdak30` int(11) DEFAULT '0',
  `cdak31` int(11) DEFAULT '0',
  `cdak32` int(11) DEFAULT '0',
  `idak1` int(11) DEFAULT '0',
  `idak2` int(11) DEFAULT '0',
  `idak3` int(11) DEFAULT '0',
  `idak4` int(11) DEFAULT '0',
  `idak5` int(11) DEFAULT '0',
  `idak6` int(11) DEFAULT '0',
  `idak7` int(11) DEFAULT '0',
  `idak8` int(11) DEFAULT '0',
  `idak9` int(11) DEFAULT '0',
  `idak10` int(11) DEFAULT '0',
  `idak11` int(11) DEFAULT '0',
  `idak12` int(11) DEFAULT '0',
  `toplamsure` varchar(5) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `turid` int(11) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `htk` varchar(6) DEFAULT NULL COMMENT 'hafta tatili kesintisi',
  `hit` varchar(6) DEFAULT NULL COMMENT 'hafta sonu mesaisini haftaiçine tamamlar',
  `puantajid` int(11) DEFAULT NULL,
  `puantajmax` int(11) DEFAULT '0',
  `altgrupid` int(11) DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `gcidgec` bigint(20) DEFAULT NULL COMMENT 'geckalma ya ait giriscikis tablosundaki kaydin id si',
  `gciderk` bigint(20) DEFAULT NULL COMMENT 'erkencikma ya ait giriscikis tablosundaki kaydin id si',
  `gcideks` bigint(20) DEFAULT NULL COMMENT 'eksiksure ye ait giriscikis tablosundaki kaydin id si',
  `gcidmes` bigint(20) DEFAULT NULL,
  `kapiterminalid` int(11) DEFAULT NULL COMMENT 'ilkgiris ve soncikis icin',
  `eksikvar` tinyint(1) DEFAULT '0' COMMENT 'dvm gec erk eks den harhangi bir var ise',
  `giristerminalad` varchar(10) DEFAULT NULL,
  `cikisterminalad` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`,`girissaati`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_puantaj
-- 

-- 
-- Table structure for table pts_puantaj1
-- 

DROP TABLE IF EXISTS pts_puantaj1;
CREATE TABLE `pts_puantaj1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `devamsizlik` varchar(6) DEFAULT NULL,
  `geckalma` varchar(6) DEFAULT NULL,
  `erkencikma` varchar(6) DEFAULT NULL,
  `eksiksure` varchar(6) DEFAULT NULL,
  `devamsizlik_ceza` varchar(6) DEFAULT NULL,
  `geckalma_ceza` varchar(6) DEFAULT NULL,
  `erkencikma_ceza` varchar(6) DEFAULT NULL,
  `eksiksure_ceza` varchar(6) DEFAULT NULL,
  `devamsizlik_net` varchar(6) DEFAULT NULL,
  `geckalma_net` varchar(6) DEFAULT NULL,
  `erkencikma_net` varchar(6) DEFAULT NULL,
  `eksiksure_net` varchar(6) DEFAULT NULL,
  `devamsizlik_dak` int(11) DEFAULT '0',
  `geckalma_dak` int(11) DEFAULT '0',
  `erkencikma_dak` int(11) DEFAULT '0',
  `eksiksure_dak` int(11) DEFAULT '0',
  `devamsizlik_cezadak` int(11) DEFAULT '0',
  `geckalma_cezadak` int(11) DEFAULT '0',
  `erkencikma_cezadak` int(11) DEFAULT '0',
  `eksiksure_cezadak` int(11) DEFAULT '0',
  `devamsizlik_netdak` int(11) DEFAULT '0',
  `geckalma_netdak` int(11) DEFAULT '0',
  `erkencikma_netdak` int(11) DEFAULT '0',
  `eksiksure_netdak` int(11) DEFAULT '0',
  `c1` varchar(6) DEFAULT NULL,
  `c2` varchar(6) DEFAULT NULL,
  `c3` varchar(6) DEFAULT NULL,
  `c4` varchar(6) DEFAULT NULL,
  `c5` varchar(6) DEFAULT NULL,
  `c6` varchar(6) DEFAULT NULL,
  `c7` varchar(6) DEFAULT NULL,
  `c8` varchar(6) DEFAULT NULL,
  `c9` varchar(6) DEFAULT NULL,
  `c10` varchar(6) DEFAULT NULL,
  `c11` varchar(6) DEFAULT NULL,
  `c12` varchar(6) DEFAULT NULL,
  `c13` varchar(6) DEFAULT NULL,
  `c14` varchar(6) DEFAULT NULL,
  `c15` varchar(6) DEFAULT NULL,
  `c16` varchar(6) DEFAULT NULL,
  `c17` varchar(6) DEFAULT NULL,
  `c18` varchar(6) DEFAULT NULL,
  `c19` varchar(6) DEFAULT NULL,
  `c20` varchar(6) DEFAULT NULL,
  `c21` varchar(6) DEFAULT NULL,
  `c22` varchar(6) DEFAULT NULL,
  `c23` varchar(6) DEFAULT NULL,
  `c24` varchar(6) DEFAULT NULL,
  `c25` varchar(6) DEFAULT NULL,
  `c26` varchar(6) DEFAULT NULL,
  `c27` varchar(6) DEFAULT NULL,
  `c28` varchar(6) DEFAULT NULL,
  `c29` varchar(6) DEFAULT NULL,
  `c30` varchar(6) DEFAULT NULL,
  `c31` varchar(6) DEFAULT NULL,
  `c32` varchar(6) DEFAULT NULL,
  `i1` varchar(6) DEFAULT NULL,
  `i2` varchar(6) DEFAULT NULL,
  `i3` varchar(6) DEFAULT NULL,
  `i4` varchar(6) DEFAULT NULL,
  `i5` varchar(6) DEFAULT NULL,
  `i6` varchar(6) DEFAULT NULL,
  `i7` varchar(6) DEFAULT NULL,
  `i8` varchar(6) DEFAULT NULL,
  `i9` varchar(6) DEFAULT NULL,
  `i10` varchar(6) DEFAULT NULL,
  `i11` varchar(6) DEFAULT NULL,
  `i12` varchar(6) DEFAULT NULL,
  `i13` varchar(6) DEFAULT NULL,
  `i14` varchar(6) DEFAULT NULL,
  `i15` varchar(6) DEFAULT NULL,
  `i16` varchar(6) DEFAULT NULL,
  `i17` varchar(6) DEFAULT NULL,
  `i18` varchar(6) DEFAULT NULL,
  `i19` varchar(6) DEFAULT NULL,
  `i20` varchar(6) DEFAULT NULL,
  `i21` varchar(6) DEFAULT NULL,
  `i22` varchar(6) DEFAULT NULL,
  `i23` varchar(6) DEFAULT NULL,
  `i24` varchar(6) DEFAULT NULL,
  `i25` varchar(6) DEFAULT NULL,
  `i26` varchar(6) DEFAULT NULL,
  `i27` varchar(6) DEFAULT NULL,
  `i28` varchar(6) DEFAULT NULL,
  `i29` varchar(6) DEFAULT NULL,
  `i30` varchar(6) DEFAULT NULL,
  `i31` varchar(6) DEFAULT NULL,
  `i32` varchar(6) DEFAULT NULL,
  `cdak1` int(11) DEFAULT '0',
  `cdak2` int(11) DEFAULT '0',
  `cdak3` int(11) DEFAULT '0',
  `cdak4` int(11) DEFAULT '0',
  `cdak5` int(11) DEFAULT '0',
  `cdak6` int(11) DEFAULT '0',
  `cdak7` int(11) DEFAULT '0',
  `cdak8` int(11) DEFAULT '0',
  `cdak9` int(11) DEFAULT '0',
  `cdak10` int(11) DEFAULT '0',
  `cdak11` int(11) DEFAULT '0',
  `cdak12` int(11) DEFAULT '0',
  `cdak13` int(11) DEFAULT '0',
  `cdak14` int(11) DEFAULT '0',
  `cdak15` int(11) DEFAULT '0',
  `cdak16` int(11) DEFAULT '0',
  `cdak17` int(11) DEFAULT '0',
  `cdak18` int(11) DEFAULT '0',
  `cdak19` int(11) DEFAULT '0',
  `cdak20` int(11) DEFAULT '0',
  `cdak21` int(11) DEFAULT '0',
  `cdak22` int(11) DEFAULT '0',
  `cdak23` int(11) DEFAULT '0',
  `cdak24` int(11) DEFAULT '0',
  `cdak25` int(11) DEFAULT '0',
  `cdak26` int(11) DEFAULT '0',
  `cdak27` int(11) DEFAULT '0',
  `cdak28` int(11) DEFAULT '0',
  `cdak29` int(11) DEFAULT '0',
  `cdak30` int(11) DEFAULT '0',
  `cdak31` int(11) DEFAULT '0',
  `cdak32` int(11) DEFAULT '0',
  `idak1` int(11) DEFAULT '0',
  `idak2` int(11) DEFAULT '0',
  `idak3` int(11) DEFAULT '0',
  `idak4` int(11) DEFAULT '0',
  `idak5` int(11) DEFAULT '0',
  `idak6` int(11) DEFAULT '0',
  `idak7` int(11) DEFAULT '0',
  `idak8` int(11) DEFAULT '0',
  `idak9` int(11) DEFAULT '0',
  `idak10` int(11) DEFAULT '0',
  `idak11` int(11) DEFAULT '0',
  `idak12` int(11) DEFAULT '0',
  `toplamsure` varchar(5) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `turid` int(11) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `htk` varchar(6) DEFAULT NULL COMMENT 'hafta tatili kesintisi',
  `hit` varchar(6) DEFAULT NULL COMMENT 'hafta sonu mesaisini haftaiçine tamamlar',
  `puantajid` int(11) DEFAULT NULL,
  `puantajmax` int(11) DEFAULT '0',
  `altgrupid` int(11) DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `gcidgec` bigint(20) DEFAULT NULL,
  `gciderk` bigint(20) DEFAULT NULL,
  `gcideks` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`,`girissaati`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_puantaj1
-- 

-- 
-- Table structure for table pts_puantajparametre
-- 

DROP TABLE IF EXISTS pts_puantajparametre;
CREATE TABLE `pts_puantajparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `saat` char(6) DEFAULT NULL COMMENT 'gunluk sure',
  `appTask` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_puantajparametre
-- 

LOCK TABLES pts_puantajparametre WRITE;
INSERT INTO pts_puantajparametre VALUES
 (48,'MESAİ HAFTAİÇİ','09:00','gayriresmi'),
 (49,'MESAİ CMT','09:00','gayriresmi'),
 (50,'MESAİ PAZ',NULL,'gayriresmi'),
 (51,'3VAR 1-HFTİÇİ','07:30','gayriresmi'),
 (52,'3VAR 1-PAZAR',NULL,'gayriresmi'),
 (53,'3VAR 2-HFTİÇİ','07:30','gayriresmi'),
 (54,'3VAR 2-PAZAR',NULL,'gayriresmi'),
 (55,'3VAR 3-HFTİÇİ','07:30','gayriresmi'),
 (56,'3VAR 3-PAZAR','','gayriresmi'),
 (57,'2VARDİYA1 HFTİÇİ','08:00','gayriresmi'),
 (58,'2VARDİYA1 CMT','08:00','gayriresmi'),
 (59,'2VARDİYA1 PAZAR',NULL,'gayriresmi'),
 (60,'2VARDİYA2 HFTİÇİ','09:00','gayriresmi'),
 (61,'2VARDİYA2 CMT','','gayriresmi'),
 (62,'2VARDİYA2 PAZAR',NULL,'gayriresmi'),
 (63,'İDARİ HFTİÇİ','07:30','gayriresmi'),
 (64,'İDARİ PAZAR',NULL,'gayriresmi'),
 (65,'RESMI TATIL/BAYRAM 09:00',NULL,'gayriresmi'),
 (66,'YARIM GÜN/AREFE 09:00','09:00','gayriresmi'),
 (67,'İDARİ CMT',NULL,'gayriresmi');
UNLOCK TABLES;

-- 
-- Table structure for table pts_puantajtoplam
-- 

DROP TABLE IF EXISTS pts_puantajtoplam;
CREATE TABLE `pts_puantajtoplam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(10) NOT NULL,
  `bastarih` date DEFAULT NULL,
  `bittarih` date DEFAULT NULL,
  `devamsizlikgun` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat` varchar(6) DEFAULT NULL,
  `devamsizlikucret` decimal(11,2) DEFAULT NULL,
  `geckalmagun` decimal(11,2) DEFAULT NULL,
  `geckalmasaat` varchar(6) DEFAULT NULL,
  `geckalmaucret` decimal(11,2) DEFAULT NULL,
  `erkencikmagun` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat` varchar(6) DEFAULT NULL,
  `erkencikmaucret` decimal(11,2) DEFAULT NULL,
  `eksiksuregun` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat` varchar(6) DEFAULT NULL,
  `eksiksureucret` decimal(11,2) DEFAULT NULL,
  `devamsizlikgun_ceza` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat_ceza` varchar(6) DEFAULT NULL,
  `devamsizlikucret_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmagun_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmasaat_ceza` varchar(6) DEFAULT NULL,
  `geckalmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmagun_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat_ceza` varchar(6) DEFAULT NULL,
  `erkencikmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `eksiksuregun_ceza` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat_ceza` varchar(6) DEFAULT NULL,
  `eksiksureucret_ceza` decimal(11,2) DEFAULT NULL,
  `devamsizlikgun_net` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat_net` varchar(6) DEFAULT NULL,
  `devamsizlikucret_net` decimal(11,2) DEFAULT NULL,
  `geckalmagun_net` decimal(11,2) DEFAULT NULL,
  `geckalmasaat_net` varchar(6) DEFAULT NULL,
  `geckalmaucret_net` decimal(11,2) DEFAULT NULL,
  `erkencikmagun_net` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat_net` varchar(6) DEFAULT NULL,
  `erkencikmaucret_net` decimal(11,2) DEFAULT NULL,
  `eksiksuregun_net` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat_net` varchar(6) DEFAULT NULL,
  `eksiksureucret_net` decimal(11,2) DEFAULT NULL,
  `cgun1` decimal(11,2) DEFAULT NULL,
  `csaat1` varchar(6) DEFAULT NULL,
  `cucret1` decimal(11,2) DEFAULT NULL,
  `cgun2` decimal(11,2) DEFAULT NULL,
  `csaat2` varchar(6) DEFAULT NULL,
  `cucret2` decimal(11,2) DEFAULT NULL,
  `cgun3` decimal(11,2) DEFAULT NULL,
  `csaat3` varchar(6) DEFAULT NULL,
  `cucret3` decimal(11,2) DEFAULT NULL,
  `cgun4` decimal(11,2) DEFAULT NULL,
  `csaat4` varchar(6) DEFAULT NULL,
  `cucret4` decimal(11,2) DEFAULT NULL,
  `cgun5` decimal(11,2) DEFAULT NULL,
  `csaat5` varchar(6) DEFAULT NULL,
  `cucret5` decimal(11,2) DEFAULT NULL,
  `cgun6` decimal(11,2) DEFAULT NULL,
  `csaat6` varchar(6) DEFAULT NULL,
  `cucret6` decimal(11,2) DEFAULT NULL,
  `cgun7` decimal(11,2) DEFAULT NULL,
  `csaat7` varchar(6) DEFAULT NULL,
  `cucret7` decimal(11,2) DEFAULT NULL,
  `cgun8` decimal(11,2) DEFAULT NULL,
  `csaat8` varchar(6) DEFAULT NULL,
  `cucret8` decimal(11,2) DEFAULT NULL,
  `cgun9` decimal(11,2) DEFAULT NULL,
  `csaat9` varchar(6) DEFAULT NULL,
  `cucret9` decimal(11,2) DEFAULT NULL,
  `cgun10` decimal(11,2) DEFAULT NULL,
  `csaat10` varchar(6) DEFAULT NULL,
  `cucret10` decimal(11,2) DEFAULT NULL,
  `cgun11` decimal(11,2) DEFAULT NULL,
  `csaat11` varchar(6) DEFAULT NULL,
  `cucret11` decimal(11,2) DEFAULT NULL,
  `cgun12` decimal(11,2) DEFAULT NULL,
  `csaat12` varchar(6) DEFAULT NULL,
  `cucret12` decimal(11,2) DEFAULT NULL,
  `cgun13` decimal(11,2) DEFAULT NULL,
  `csaat13` varchar(6) DEFAULT NULL,
  `cucret13` decimal(11,2) DEFAULT NULL,
  `cgun14` decimal(11,2) DEFAULT NULL,
  `csaat14` varchar(6) DEFAULT NULL,
  `cucret14` decimal(11,2) DEFAULT NULL,
  `cgun15` decimal(11,2) DEFAULT NULL,
  `csaat15` varchar(6) DEFAULT NULL,
  `cucret15` decimal(11,2) DEFAULT NULL,
  `cgun16` decimal(11,2) DEFAULT NULL,
  `csaat16` varchar(6) DEFAULT NULL,
  `cucret16` decimal(11,2) DEFAULT NULL,
  `cgun17` decimal(11,2) DEFAULT NULL,
  `csaat17` varchar(6) DEFAULT NULL,
  `cucret17` decimal(11,2) DEFAULT NULL,
  `cgun18` decimal(11,2) DEFAULT NULL,
  `csaat18` varchar(6) DEFAULT NULL,
  `cucret18` decimal(11,2) DEFAULT NULL,
  `cgun19` decimal(11,2) DEFAULT NULL,
  `csaat19` varchar(6) DEFAULT NULL,
  `cucret19` decimal(11,2) DEFAULT NULL,
  `cgun20` decimal(11,2) DEFAULT NULL,
  `csaat20` varchar(6) DEFAULT NULL,
  `cucret20` decimal(11,2) DEFAULT NULL,
  `cgun21` decimal(11,2) DEFAULT NULL,
  `csaat21` varchar(6) DEFAULT NULL,
  `cucret21` decimal(11,2) DEFAULT NULL,
  `cgun22` decimal(11,2) DEFAULT NULL,
  `csaat22` varchar(6) DEFAULT NULL,
  `cucret22` decimal(11,2) DEFAULT NULL,
  `cgun23` decimal(11,2) DEFAULT NULL,
  `csaat23` varchar(6) DEFAULT NULL,
  `cucret23` decimal(11,2) DEFAULT NULL,
  `cgun24` decimal(11,2) DEFAULT NULL,
  `csaat24` varchar(6) DEFAULT NULL,
  `cucret24` decimal(11,2) DEFAULT NULL,
  `cgun25` decimal(11,2) DEFAULT NULL,
  `csaat25` varchar(6) DEFAULT NULL,
  `cucret25` decimal(11,2) DEFAULT NULL,
  `cgun26` decimal(11,2) DEFAULT NULL,
  `csaat26` varchar(6) DEFAULT NULL,
  `cucret26` decimal(11,2) DEFAULT NULL,
  `cgun27` decimal(11,2) DEFAULT NULL,
  `csaat27` varchar(6) DEFAULT NULL,
  `cucret27` decimal(11,2) DEFAULT NULL,
  `cgun28` decimal(11,2) DEFAULT NULL,
  `csaat28` varchar(6) DEFAULT NULL,
  `cucret28` decimal(11,2) DEFAULT NULL,
  `cgun29` decimal(11,2) DEFAULT NULL,
  `csaat29` varchar(6) DEFAULT NULL,
  `cucret29` decimal(11,2) DEFAULT NULL,
  `cgun30` decimal(11,2) DEFAULT NULL,
  `csaat30` varchar(6) DEFAULT NULL,
  `cucret30` decimal(11,2) DEFAULT NULL,
  `cgun31` decimal(11,2) DEFAULT NULL,
  `csaat31` varchar(6) DEFAULT NULL,
  `cucret31` decimal(11,2) DEFAULT NULL,
  `cgun32` decimal(11,2) DEFAULT NULL,
  `csaat32` varchar(6) DEFAULT NULL,
  `cucret32` decimal(11,2) DEFAULT NULL,
  `igun1` decimal(11,2) DEFAULT NULL,
  `isaat1` varchar(6) DEFAULT NULL,
  `iucret1` decimal(11,2) DEFAULT NULL,
  `igun2` decimal(11,2) DEFAULT NULL,
  `isaat2` varchar(6) DEFAULT NULL,
  `iucret2` decimal(11,2) DEFAULT NULL,
  `igun3` decimal(11,2) DEFAULT NULL,
  `isaat3` varchar(6) DEFAULT NULL,
  `iucret3` decimal(11,2) DEFAULT NULL,
  `igun4` decimal(11,2) DEFAULT NULL,
  `isaat4` varchar(6) DEFAULT NULL,
  `iucret4` decimal(11,2) DEFAULT NULL,
  `igun5` decimal(11,2) DEFAULT NULL,
  `isaat5` varchar(6) DEFAULT NULL,
  `iucret5` decimal(11,2) DEFAULT NULL,
  `igun6` decimal(11,2) DEFAULT NULL,
  `isaat6` varchar(6) DEFAULT NULL,
  `iucret6` decimal(11,2) DEFAULT NULL,
  `igun7` decimal(11,2) DEFAULT NULL,
  `isaat7` varchar(6) DEFAULT NULL,
  `iucret7` decimal(11,2) DEFAULT NULL,
  `igun8` decimal(11,2) DEFAULT NULL,
  `isaat8` varchar(6) DEFAULT NULL,
  `iucret8` decimal(11,2) DEFAULT NULL,
  `igun9` decimal(11,2) DEFAULT NULL,
  `isaat9` varchar(6) DEFAULT NULL,
  `iucret9` decimal(11,2) DEFAULT NULL,
  `igun10` decimal(11,2) DEFAULT NULL,
  `isaat10` varchar(6) DEFAULT NULL,
  `iucret10` decimal(11,2) DEFAULT NULL,
  `igun11` decimal(11,2) DEFAULT NULL,
  `isaat11` varchar(6) DEFAULT NULL,
  `iucret11` decimal(11,2) DEFAULT NULL,
  `igun12` decimal(11,2) DEFAULT NULL,
  `isaat12` varchar(6) DEFAULT NULL,
  `iucret12` decimal(11,2) DEFAULT NULL,
  `igun13` decimal(11,2) DEFAULT NULL,
  `isaat13` varchar(6) DEFAULT NULL,
  `iucret13` decimal(11,2) DEFAULT NULL,
  `igun14` decimal(11,2) DEFAULT NULL,
  `isaat14` varchar(6) DEFAULT NULL,
  `iucret14` decimal(11,2) DEFAULT NULL,
  `igun15` decimal(11,2) DEFAULT NULL,
  `isaat15` varchar(6) DEFAULT NULL,
  `iucret15` decimal(11,2) DEFAULT NULL,
  `igun16` decimal(11,2) DEFAULT NULL,
  `isaat16` varchar(6) DEFAULT NULL,
  `iucret16` decimal(11,2) DEFAULT NULL,
  `igun17` decimal(11,2) DEFAULT NULL,
  `isaat17` varchar(6) DEFAULT NULL,
  `iucret17` decimal(11,2) DEFAULT NULL,
  `igun18` decimal(11,2) DEFAULT NULL,
  `isaat18` varchar(6) DEFAULT NULL,
  `iucret18` decimal(11,2) DEFAULT NULL,
  `igun19` decimal(11,2) DEFAULT NULL,
  `isaat19` varchar(6) DEFAULT NULL,
  `iucret19` decimal(11,2) DEFAULT NULL,
  `igun20` decimal(11,2) DEFAULT NULL,
  `isaat20` varchar(6) DEFAULT NULL,
  `iucret20` decimal(11,2) DEFAULT NULL,
  `igun21` decimal(11,2) DEFAULT NULL,
  `isaat21` varchar(6) DEFAULT NULL,
  `iucret21` decimal(11,2) DEFAULT NULL,
  `igun22` decimal(11,2) DEFAULT NULL,
  `isaat22` varchar(6) DEFAULT NULL,
  `iucret22` decimal(11,2) DEFAULT NULL,
  `igun23` decimal(11,2) DEFAULT NULL,
  `isaat23` varchar(6) DEFAULT NULL,
  `iucret23` decimal(11,2) DEFAULT NULL,
  `igun24` decimal(11,2) DEFAULT NULL,
  `isaat24` varchar(6) DEFAULT NULL,
  `iucret24` decimal(11,2) DEFAULT NULL,
  `igun25` decimal(11,2) DEFAULT NULL,
  `isaat25` varchar(6) DEFAULT NULL,
  `iucret25` decimal(11,2) DEFAULT NULL,
  `igun26` decimal(11,2) DEFAULT NULL,
  `isaat26` varchar(6) DEFAULT NULL,
  `iucret26` decimal(11,2) DEFAULT NULL,
  `igun27` decimal(11,2) DEFAULT NULL,
  `isaat27` varchar(6) DEFAULT NULL,
  `iucret27` decimal(11,2) DEFAULT NULL,
  `igun28` decimal(11,2) DEFAULT NULL,
  `isaat28` varchar(6) DEFAULT NULL,
  `iucret28` decimal(11,2) DEFAULT NULL,
  `igun29` decimal(11,2) DEFAULT NULL,
  `isaat29` varchar(6) DEFAULT NULL,
  `iucret29` decimal(11,2) DEFAULT NULL,
  `igun30` decimal(11,2) DEFAULT NULL,
  `isaat30` varchar(6) DEFAULT NULL,
  `iucret30` decimal(11,2) DEFAULT NULL,
  `igun31` decimal(11,2) DEFAULT NULL,
  `isaat31` varchar(6) DEFAULT NULL,
  `iucret31` decimal(11,2) DEFAULT NULL,
  `igun32` decimal(11,2) DEFAULT NULL,
  `isaat32` varchar(6) DEFAULT NULL,
  `iucret32` decimal(11,2) DEFAULT NULL,
  `eucret1` decimal(11,2) DEFAULT NULL,
  `eucret2` decimal(11,2) DEFAULT NULL,
  `eucret3` decimal(11,2) DEFAULT NULL,
  `eucret4` decimal(11,2) DEFAULT NULL,
  `eucret5` decimal(11,2) DEFAULT NULL,
  `eucret6` decimal(11,2) DEFAULT NULL,
  `eucret7` decimal(11,2) DEFAULT NULL,
  `eucret8` decimal(11,2) DEFAULT NULL,
  `eucret9` decimal(11,2) DEFAULT NULL,
  `eucret10` decimal(11,2) DEFAULT NULL,
  `eucret11` decimal(11,2) DEFAULT NULL,
  `eucret12` decimal(11,2) DEFAULT NULL,
  `eucret13` decimal(11,2) DEFAULT NULL,
  `eucret14` decimal(11,2) DEFAULT NULL,
  `eucret15` decimal(11,2) DEFAULT NULL,
  `eucret16` decimal(11,2) DEFAULT NULL,
  `eucret17` decimal(11,2) DEFAULT NULL,
  `eucret18` decimal(11,2) DEFAULT NULL,
  `eucret19` decimal(11,2) DEFAULT NULL,
  `eucret20` decimal(11,2) DEFAULT NULL,
  `eucret21` decimal(11,2) DEFAULT NULL,
  `eucret22` decimal(11,2) DEFAULT NULL,
  `eucret23` decimal(11,2) DEFAULT NULL,
  `eucret24` decimal(11,2) DEFAULT NULL,
  `eucret25` decimal(11,2) DEFAULT NULL,
  `eucret26` decimal(11,2) DEFAULT NULL,
  `eucret27` decimal(11,2) DEFAULT NULL,
  `eucret28` decimal(11,2) DEFAULT NULL,
  `eucret29` decimal(11,2) DEFAULT NULL,
  `eucret30` decimal(11,2) DEFAULT NULL,
  `eucret31` decimal(11,2) DEFAULT NULL,
  `eucret32` decimal(11,2) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `htkgun` decimal(11,2) DEFAULT NULL,
  `htksaat` varchar(6) DEFAULT NULL,
  `htkucret` decimal(11,2) DEFAULT NULL,
  `hitgun` decimal(11,2) DEFAULT NULL,
  `hitsaat` varchar(6) DEFAULT NULL,
  `hitucret` decimal(11,2) DEFAULT NULL,
  `donemfarkigun` decimal(11,2) DEFAULT NULL,
  `donemfarkisaat` varchar(6) DEFAULT NULL,
  `donemfarkiucret` decimal(11,2) DEFAULT NULL,
  `agiucret` decimal(11,2) DEFAULT NULL,
  `primucret` decimal(11,2) DEFAULT NULL,
  `yolucret` decimal(11,2) DEFAULT NULL,
  `yemekucret` decimal(11,2) DEFAULT NULL,
  `wcsaat` varchar(6) DEFAULT NULL,
  `wcucret` decimal(11,2) DEFAULT NULL,
  `nctoplam` decimal(11,2) DEFAULT NULL,
  `fmtoplam` decimal(11,2) DEFAULT NULL,
  `iztoplam` decimal(11,2) DEFAULT NULL,
  `kktoplam` decimal(11,2) DEFAULT NULL,
  `nchakedis` decimal(11,2) DEFAULT NULL COMMENT 'nctoplam + kktoplam',
  `fmhakedis` decimal(11,2) DEFAULT NULL,
  `ncodenen` decimal(11,2) DEFAULT NULL,
  `fmodenen` decimal(11,2) DEFAULT NULL,
  `nckalan` decimal(11,2) DEFAULT NULL,
  `fmkalan` decimal(11,2) DEFAULT NULL,
  `devir` decimal(11,2) DEFAULT NULL COMMENT 'devir=(maashakedis+mesaihakedis)-(maasodenen+mesaiodenen)  ->gecen ay icin',
  `geneltoplam` decimal(11,2) DEFAULT NULL COMMENT 'eneltoplam=(maashakedis+mesaihakedis+devir)-(maasodenen+mesaiodenen)  ->gecen ay icin',
  `kstsaat` varchar(6) DEFAULT NULL,
  `kstucret` decimal(11,2) DEFAULT NULL,
  `ozelucret` decimal(11,2) DEFAULT NULL,
  `ncgun` decimal(11,2) DEFAULT NULL,
  `ncsaat` varchar(6) DEFAULT NULL,
  `ncucret` decimal(11,2) DEFAULT NULL,
  `geneltoplam1` decimal(11,2) DEFAULT NULL,
  `idonemfarkisaat` int(11) DEFAULT '0',
  `ucret` decimal(11,2) DEFAULT NULL,
  `ncsaatucreti` decimal(11,2) DEFAULT NULL,
  `fm1saatucreti` decimal(11,2) DEFAULT NULL,
  `fm2saatucreti` decimal(11,2) DEFAULT NULL,
  `fm3saatucreti` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`bastarih`,`bittarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_puantajtoplam
-- 

-- 
-- Table structure for table pts_puantajtoplam1
-- 

DROP TABLE IF EXISTS pts_puantajtoplam1;
CREATE TABLE `pts_puantajtoplam1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(10) NOT NULL,
  `bastarih` date DEFAULT NULL,
  `bittarih` date DEFAULT NULL,
  `devamsizlikgun` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat` varchar(6) DEFAULT NULL,
  `devamsizlikucret` decimal(11,2) DEFAULT NULL,
  `geckalmagun` decimal(11,2) DEFAULT NULL,
  `geckalmasaat` varchar(6) DEFAULT NULL,
  `geckalmaucret` decimal(11,2) DEFAULT NULL,
  `erkencikmagun` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat` varchar(6) DEFAULT NULL,
  `erkencikmaucret` decimal(11,2) DEFAULT NULL,
  `eksiksuregun` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat` varchar(6) DEFAULT NULL,
  `eksiksureucret` decimal(11,2) DEFAULT NULL,
  `devamsizlikgun_ceza` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat_ceza` varchar(6) DEFAULT NULL,
  `devamsizlikucret_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmagun_ceza` decimal(11,2) DEFAULT NULL,
  `geckalmasaat_ceza` varchar(6) DEFAULT NULL,
  `geckalmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmagun_ceza` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat_ceza` varchar(6) DEFAULT NULL,
  `erkencikmaucret_ceza` decimal(11,2) DEFAULT NULL,
  `eksiksuregun_ceza` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat_ceza` varchar(6) DEFAULT NULL,
  `eksiksureucret_ceza` decimal(11,2) DEFAULT NULL,
  `devamsizlikgun_net` decimal(11,2) DEFAULT NULL,
  `devamsizliksaat_net` varchar(6) DEFAULT NULL,
  `devamsizlikucret_net` decimal(11,2) DEFAULT NULL,
  `geckalmagun_net` decimal(11,2) DEFAULT NULL,
  `geckalmasaat_net` varchar(6) DEFAULT NULL,
  `geckalmaucret_net` decimal(11,2) DEFAULT NULL,
  `erkencikmagun_net` decimal(11,2) DEFAULT NULL,
  `erkencikmasaat_net` varchar(6) DEFAULT NULL,
  `erkencikmaucret_net` decimal(11,2) DEFAULT NULL,
  `eksiksuregun_net` decimal(11,2) DEFAULT NULL,
  `eksiksuresaat_net` varchar(6) DEFAULT NULL,
  `eksiksureucret_net` decimal(11,2) DEFAULT NULL,
  `cgun1` decimal(11,2) DEFAULT NULL,
  `csaat1` varchar(6) DEFAULT NULL,
  `cucret1` decimal(11,2) DEFAULT NULL,
  `cgun2` decimal(11,2) DEFAULT NULL,
  `csaat2` varchar(6) DEFAULT NULL,
  `cucret2` decimal(11,2) DEFAULT NULL,
  `cgun3` decimal(11,2) DEFAULT NULL,
  `csaat3` varchar(6) DEFAULT NULL,
  `cucret3` decimal(11,2) DEFAULT NULL,
  `cgun4` decimal(11,2) DEFAULT NULL,
  `csaat4` varchar(6) DEFAULT NULL,
  `cucret4` decimal(11,2) DEFAULT NULL,
  `cgun5` decimal(11,2) DEFAULT NULL,
  `csaat5` varchar(6) DEFAULT NULL,
  `cucret5` decimal(11,2) DEFAULT NULL,
  `cgun6` decimal(11,2) DEFAULT NULL,
  `csaat6` varchar(6) DEFAULT NULL,
  `cucret6` decimal(11,2) DEFAULT NULL,
  `cgun7` decimal(11,2) DEFAULT NULL,
  `csaat7` varchar(6) DEFAULT NULL,
  `cucret7` decimal(11,2) DEFAULT NULL,
  `cgun8` decimal(11,2) DEFAULT NULL,
  `csaat8` varchar(6) DEFAULT NULL,
  `cucret8` decimal(11,2) DEFAULT NULL,
  `cgun9` decimal(11,2) DEFAULT NULL,
  `csaat9` varchar(6) DEFAULT NULL,
  `cucret9` decimal(11,2) DEFAULT NULL,
  `cgun10` decimal(11,2) DEFAULT NULL,
  `csaat10` varchar(6) DEFAULT NULL,
  `cucret10` decimal(11,2) DEFAULT NULL,
  `cgun11` decimal(11,2) DEFAULT NULL,
  `csaat11` varchar(6) DEFAULT NULL,
  `cucret11` decimal(11,2) DEFAULT NULL,
  `cgun12` decimal(11,2) DEFAULT NULL,
  `csaat12` varchar(6) DEFAULT NULL,
  `cucret12` decimal(11,2) DEFAULT NULL,
  `cgun13` decimal(11,2) DEFAULT NULL,
  `csaat13` varchar(6) DEFAULT NULL,
  `cucret13` decimal(11,2) DEFAULT NULL,
  `cgun14` decimal(11,2) DEFAULT NULL,
  `csaat14` varchar(6) DEFAULT NULL,
  `cucret14` decimal(11,2) DEFAULT NULL,
  `cgun15` decimal(11,2) DEFAULT NULL,
  `csaat15` varchar(6) DEFAULT NULL,
  `cucret15` decimal(11,2) DEFAULT NULL,
  `cgun16` decimal(11,2) DEFAULT NULL,
  `csaat16` varchar(6) DEFAULT NULL,
  `cucret16` decimal(11,2) DEFAULT NULL,
  `cgun17` decimal(11,2) DEFAULT NULL,
  `csaat17` varchar(6) DEFAULT NULL,
  `cucret17` decimal(11,2) DEFAULT NULL,
  `cgun18` decimal(11,2) DEFAULT NULL,
  `csaat18` varchar(6) DEFAULT NULL,
  `cucret18` decimal(11,2) DEFAULT NULL,
  `cgun19` decimal(11,2) DEFAULT NULL,
  `csaat19` varchar(6) DEFAULT NULL,
  `cucret19` decimal(11,2) DEFAULT NULL,
  `cgun20` decimal(11,2) DEFAULT NULL,
  `csaat20` varchar(6) DEFAULT NULL,
  `cucret20` decimal(11,2) DEFAULT NULL,
  `cgun21` decimal(11,2) DEFAULT NULL,
  `csaat21` varchar(6) DEFAULT NULL,
  `cucret21` decimal(11,2) DEFAULT NULL,
  `cgun22` decimal(11,2) DEFAULT NULL,
  `csaat22` varchar(6) DEFAULT NULL,
  `cucret22` decimal(11,2) DEFAULT NULL,
  `cgun23` decimal(11,2) DEFAULT NULL,
  `csaat23` varchar(6) DEFAULT NULL,
  `cucret23` decimal(11,2) DEFAULT NULL,
  `cgun24` decimal(11,2) DEFAULT NULL,
  `csaat24` varchar(6) DEFAULT NULL,
  `cucret24` decimal(11,2) DEFAULT NULL,
  `cgun25` decimal(11,2) DEFAULT NULL,
  `csaat25` varchar(6) DEFAULT NULL,
  `cucret25` decimal(11,2) DEFAULT NULL,
  `cgun26` decimal(11,2) DEFAULT NULL,
  `csaat26` varchar(6) DEFAULT NULL,
  `cucret26` decimal(11,2) DEFAULT NULL,
  `cgun27` decimal(11,2) DEFAULT NULL,
  `csaat27` varchar(6) DEFAULT NULL,
  `cucret27` decimal(11,2) DEFAULT NULL,
  `cgun28` decimal(11,2) DEFAULT NULL,
  `csaat28` varchar(6) DEFAULT NULL,
  `cucret28` decimal(11,2) DEFAULT NULL,
  `cgun29` decimal(11,2) DEFAULT NULL,
  `csaat29` varchar(6) DEFAULT NULL,
  `cucret29` decimal(11,2) DEFAULT NULL,
  `cgun30` decimal(11,2) DEFAULT NULL,
  `csaat30` varchar(6) DEFAULT NULL,
  `cucret30` decimal(11,2) DEFAULT NULL,
  `cgun31` decimal(11,2) DEFAULT NULL,
  `csaat31` varchar(6) DEFAULT NULL,
  `cucret31` decimal(11,2) DEFAULT NULL,
  `cgun32` decimal(11,2) DEFAULT NULL,
  `csaat32` varchar(6) DEFAULT NULL,
  `cucret32` decimal(11,2) DEFAULT NULL,
  `igun1` decimal(11,2) DEFAULT NULL,
  `isaat1` varchar(6) DEFAULT NULL,
  `iucret1` decimal(11,2) DEFAULT NULL,
  `igun2` decimal(11,2) DEFAULT NULL,
  `isaat2` varchar(6) DEFAULT NULL,
  `iucret2` decimal(11,2) DEFAULT NULL,
  `igun3` decimal(11,2) DEFAULT NULL,
  `isaat3` varchar(6) DEFAULT NULL,
  `iucret3` decimal(11,2) DEFAULT NULL,
  `igun4` decimal(11,2) DEFAULT NULL,
  `isaat4` varchar(6) DEFAULT NULL,
  `iucret4` decimal(11,2) DEFAULT NULL,
  `igun5` decimal(11,2) DEFAULT NULL,
  `isaat5` varchar(6) DEFAULT NULL,
  `iucret5` decimal(11,2) DEFAULT NULL,
  `igun6` decimal(11,2) DEFAULT NULL,
  `isaat6` varchar(6) DEFAULT NULL,
  `iucret6` decimal(11,2) DEFAULT NULL,
  `igun7` decimal(11,2) DEFAULT NULL,
  `isaat7` varchar(6) DEFAULT NULL,
  `iucret7` decimal(11,2) DEFAULT NULL,
  `igun8` decimal(11,2) DEFAULT NULL,
  `isaat8` varchar(6) DEFAULT NULL,
  `iucret8` decimal(11,2) DEFAULT NULL,
  `igun9` decimal(11,2) DEFAULT NULL,
  `isaat9` varchar(6) DEFAULT NULL,
  `iucret9` decimal(11,2) DEFAULT NULL,
  `igun10` decimal(11,2) DEFAULT NULL,
  `isaat10` varchar(6) DEFAULT NULL,
  `iucret10` decimal(11,2) DEFAULT NULL,
  `igun11` decimal(11,2) DEFAULT NULL,
  `isaat11` varchar(6) DEFAULT NULL,
  `iucret11` decimal(11,2) DEFAULT NULL,
  `igun12` decimal(11,2) DEFAULT NULL,
  `isaat12` varchar(6) DEFAULT NULL,
  `iucret12` decimal(11,2) DEFAULT NULL,
  `igun13` decimal(11,2) DEFAULT NULL,
  `isaat13` varchar(6) DEFAULT NULL,
  `iucret13` decimal(11,2) DEFAULT NULL,
  `igun14` decimal(11,2) DEFAULT NULL,
  `isaat14` varchar(6) DEFAULT NULL,
  `iucret14` decimal(11,2) DEFAULT NULL,
  `igun15` decimal(11,2) DEFAULT NULL,
  `isaat15` varchar(6) DEFAULT NULL,
  `iucret15` decimal(11,2) DEFAULT NULL,
  `igun16` decimal(11,2) DEFAULT NULL,
  `isaat16` varchar(6) DEFAULT NULL,
  `iucret16` decimal(11,2) DEFAULT NULL,
  `igun17` decimal(11,2) DEFAULT NULL,
  `isaat17` varchar(6) DEFAULT NULL,
  `iucret17` decimal(11,2) DEFAULT NULL,
  `igun18` decimal(11,2) DEFAULT NULL,
  `isaat18` varchar(6) DEFAULT NULL,
  `iucret18` decimal(11,2) DEFAULT NULL,
  `igun19` decimal(11,2) DEFAULT NULL,
  `isaat19` varchar(6) DEFAULT NULL,
  `iucret19` decimal(11,2) DEFAULT NULL,
  `igun20` decimal(11,2) DEFAULT NULL,
  `isaat20` varchar(6) DEFAULT NULL,
  `iucret20` decimal(11,2) DEFAULT NULL,
  `igun21` decimal(11,2) DEFAULT NULL,
  `isaat21` varchar(6) DEFAULT NULL,
  `iucret21` decimal(11,2) DEFAULT NULL,
  `igun22` decimal(11,2) DEFAULT NULL,
  `isaat22` varchar(6) DEFAULT NULL,
  `iucret22` decimal(11,2) DEFAULT NULL,
  `igun23` decimal(11,2) DEFAULT NULL,
  `isaat23` varchar(6) DEFAULT NULL,
  `iucret23` decimal(11,2) DEFAULT NULL,
  `igun24` decimal(11,2) DEFAULT NULL,
  `isaat24` varchar(6) DEFAULT NULL,
  `iucret24` decimal(11,2) DEFAULT NULL,
  `igun25` decimal(11,2) DEFAULT NULL,
  `isaat25` varchar(6) DEFAULT NULL,
  `iucret25` decimal(11,2) DEFAULT NULL,
  `igun26` decimal(11,2) DEFAULT NULL,
  `isaat26` varchar(6) DEFAULT NULL,
  `iucret26` decimal(11,2) DEFAULT NULL,
  `igun27` decimal(11,2) DEFAULT NULL,
  `isaat27` varchar(6) DEFAULT NULL,
  `iucret27` decimal(11,2) DEFAULT NULL,
  `igun28` decimal(11,2) DEFAULT NULL,
  `isaat28` varchar(6) DEFAULT NULL,
  `iucret28` decimal(11,2) DEFAULT NULL,
  `igun29` decimal(11,2) DEFAULT NULL,
  `isaat29` varchar(6) DEFAULT NULL,
  `iucret29` decimal(11,2) DEFAULT NULL,
  `igun30` decimal(11,2) DEFAULT NULL,
  `isaat30` varchar(6) DEFAULT NULL,
  `iucret30` decimal(11,2) DEFAULT NULL,
  `igun31` decimal(11,2) DEFAULT NULL,
  `isaat31` varchar(6) DEFAULT NULL,
  `iucret31` decimal(11,2) DEFAULT NULL,
  `igun32` decimal(11,2) DEFAULT NULL,
  `isaat32` varchar(6) DEFAULT NULL,
  `iucret32` decimal(11,2) DEFAULT NULL,
  `eucret1` decimal(11,2) DEFAULT NULL,
  `eucret2` decimal(11,2) DEFAULT NULL,
  `eucret3` decimal(11,2) DEFAULT NULL,
  `eucret4` decimal(11,2) DEFAULT NULL,
  `eucret5` decimal(11,2) DEFAULT NULL,
  `eucret6` decimal(11,2) DEFAULT NULL,
  `eucret7` decimal(11,2) DEFAULT NULL,
  `eucret8` decimal(11,2) DEFAULT NULL,
  `eucret9` decimal(11,2) DEFAULT NULL,
  `eucret10` decimal(11,2) DEFAULT NULL,
  `eucret11` decimal(11,2) DEFAULT NULL,
  `eucret12` decimal(11,2) DEFAULT NULL,
  `eucret13` decimal(11,2) DEFAULT NULL,
  `eucret14` decimal(11,2) DEFAULT NULL,
  `eucret15` decimal(11,2) DEFAULT NULL,
  `eucret16` decimal(11,2) DEFAULT NULL,
  `eucret17` decimal(11,2) DEFAULT NULL,
  `eucret18` decimal(11,2) DEFAULT NULL,
  `eucret19` decimal(11,2) DEFAULT NULL,
  `eucret20` decimal(11,2) DEFAULT NULL,
  `eucret21` decimal(11,2) DEFAULT NULL,
  `eucret22` decimal(11,2) DEFAULT NULL,
  `eucret23` decimal(11,2) DEFAULT NULL,
  `eucret24` decimal(11,2) DEFAULT NULL,
  `eucret25` decimal(11,2) DEFAULT NULL,
  `eucret26` decimal(11,2) DEFAULT NULL,
  `eucret27` decimal(11,2) DEFAULT NULL,
  `eucret28` decimal(11,2) DEFAULT NULL,
  `eucret29` decimal(11,2) DEFAULT NULL,
  `eucret30` decimal(11,2) DEFAULT NULL,
  `eucret31` decimal(11,2) DEFAULT NULL,
  `eucret32` decimal(11,2) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `htkgun` decimal(11,2) DEFAULT NULL,
  `htksaat` varchar(6) DEFAULT NULL,
  `htkucret` decimal(11,2) DEFAULT NULL,
  `hitgun` decimal(11,2) DEFAULT NULL,
  `hitsaat` varchar(6) DEFAULT NULL,
  `hitucret` decimal(11,2) DEFAULT NULL,
  `donemfarkigun` decimal(11,2) DEFAULT NULL,
  `donemfarkisaat` varchar(6) DEFAULT NULL,
  `donemfarkiucret` decimal(11,2) DEFAULT NULL,
  `agiucret` decimal(11,2) DEFAULT NULL,
  `primucret` decimal(11,2) DEFAULT NULL,
  `yolucret` decimal(11,2) DEFAULT NULL,
  `yemekucret` decimal(11,2) DEFAULT NULL,
  `wcsaat` varchar(6) DEFAULT NULL,
  `wcucret` decimal(11,2) DEFAULT NULL,
  `nctoplam` decimal(11,2) DEFAULT NULL,
  `fmtoplam` decimal(11,2) DEFAULT NULL,
  `iztoplam` decimal(11,2) DEFAULT NULL,
  `kktoplam` decimal(11,2) DEFAULT NULL,
  `nchakedis` decimal(11,2) DEFAULT NULL COMMENT 'nctoplam + kktoplam',
  `fmhakedis` decimal(11,2) DEFAULT NULL,
  `ncodenen` decimal(11,2) DEFAULT NULL,
  `fmodenen` decimal(11,2) DEFAULT NULL,
  `nckalan` decimal(11,2) DEFAULT NULL,
  `fmkalan` decimal(11,2) DEFAULT NULL,
  `devir` decimal(11,2) DEFAULT NULL COMMENT 'devir=(maashakedis+mesaihakedis)-(maasodenen+mesaiodenen)  ->gecen ay icin',
  `geneltoplam` decimal(11,2) DEFAULT NULL COMMENT 'eneltoplam=(maashakedis+mesaihakedis+devir)-(maasodenen+mesaiodenen)  ->gecen ay icin',
  `kstsaat` varchar(6) DEFAULT NULL,
  `kstucret` decimal(11,2) DEFAULT NULL,
  `ozelucret` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_puantajtoplam1
-- 

-- 
-- Table structure for table pts_raporsablonlari
-- 

DROP TABLE IF EXISTS pts_raporsablonlari;
CREATE TABLE `pts_raporsablonlari` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` int(11) DEFAULT NULL,
  `ad` varchar(150) DEFAULT NULL,
  `nctoplam` tinyint(1) DEFAULT NULL,
  `fmtoplam` tinyint(1) DEFAULT NULL,
  `geneltoplam` tinyint(1) DEFAULT NULL,
  `raportip` varchar(20) DEFAULT NULL,
  `sicilno` tinyint(1) DEFAULT '0',
  `banka_hesapno` tinyint(1) DEFAULT '0',
  `ucret` tinyint(1) DEFAULT '0',
  `sgk_no` tinyint(1) DEFAULT '0',
  `imza` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_raporsablonlari
-- 

LOCK TABLES pts_raporsablonlari WRITE;
INSERT INTO pts_raporsablonlari VALUES
 (1,1,'1-maasbordrosu',1,1,1,NULL,0,0,0,0,0),
 (2,1,'kesintiler',0,0,0,NULL,0,0,0,0,0);
UNLOCK TABLES;

-- 
-- Table structure for table pts_raporsablonlarialt
-- 

DROP TABLE IF EXISTS pts_raporsablonlarialt;
CREATE TABLE `pts_raporsablonlarialt` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sablonid` int(11) DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  `alan` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sablonid` (`sablonid`),
  CONSTRAINT `pts_raporsablonlarialt_fk` FOREIGN KEY (`sablonid`) REFERENCES `pts_raporsablonlari` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_raporsablonlarialt
-- 

LOCK TABLES pts_raporsablonlarialt WRITE;
INSERT INTO pts_raporsablonlarialt VALUES
 (21,2,'izin','011 6'),
 (22,2,'sabit','011 devamsizlik'),
 (23,2,'sabit','011 geckalma'),
 (24,2,'sabit','011 erkencikma'),
 (25,2,'sabit','011 eksiksure'),
 (26,2,'sabit','011 KST'),
 (27,1,'calisma','111 7'),
 (28,1,'calisma','011 8'),
 (29,1,'calisma','011 9'),
 (30,1,'izin','111 4'),
 (31,1,'izin','110 5'),
 (32,1,'extra','5');
UNLOCK TABLES;

-- 
-- Table structure for table pts_resmitatiller
-- 

DROP TABLE IF EXISTS pts_resmitatiller;
CREATE TABLE `pts_resmitatiller` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tarih` date DEFAULT NULL,
  `tatil` varchar(100) DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  `puantajid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_resmitatiller
-- 

LOCK TABLES pts_resmitatiller WRITE;
INSERT INTO pts_resmitatiller VALUES
 (1,'2011-01-01','1 OCAK',11,14,65),
 (2,'2011-04-23','23 NİSAN',11,14,65),
 (3,'2011-05-01','1 MAYIS',11,14,65),
 (4,'2011-05-19','19 MAYIS',11,14,65),
 (5,'2011-08-30','30 AĞUSTOS',11,14,65),
 (6,'2011-10-29','29 EKİM',11,14,65);
UNLOCK TABLES;

-- 
-- Table structure for table pts_tahakkuk
-- 

DROP TABLE IF EXISTS pts_tahakkuk;
CREATE TABLE `pts_tahakkuk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(10) NOT NULL,
  `tarih` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `devamsizlik` varchar(6) DEFAULT NULL,
  `geckalma` varchar(6) DEFAULT NULL,
  `erkencikma` varchar(6) DEFAULT NULL,
  `eksiksure` varchar(6) DEFAULT NULL,
  `devamsizlik_ceza` varchar(6) DEFAULT NULL,
  `geckalma_ceza` varchar(6) DEFAULT NULL,
  `erkencikma_ceza` varchar(6) DEFAULT NULL,
  `eksiksure_ceza` varchar(6) DEFAULT NULL,
  `c1` varchar(6) DEFAULT NULL,
  `c2` varchar(6) DEFAULT NULL,
  `c3` varchar(6) DEFAULT NULL,
  `c4` varchar(6) DEFAULT NULL,
  `c5` varchar(6) DEFAULT NULL,
  `c6` varchar(6) DEFAULT NULL,
  `c7` varchar(6) DEFAULT NULL,
  `c8` varchar(6) DEFAULT NULL,
  `c9` varchar(6) DEFAULT NULL,
  `c10` varchar(6) DEFAULT NULL,
  `c11` varchar(6) DEFAULT NULL,
  `c12` varchar(6) DEFAULT NULL,
  `c13` varchar(6) DEFAULT NULL,
  `c14` varchar(6) DEFAULT NULL,
  `c15` varchar(6) DEFAULT NULL,
  `c16` varchar(6) DEFAULT NULL,
  `c17` varchar(6) DEFAULT NULL,
  `c18` varchar(6) DEFAULT NULL,
  `c19` varchar(6) DEFAULT NULL,
  `c20` varchar(6) DEFAULT NULL,
  `c21` varchar(6) DEFAULT NULL,
  `c22` varchar(6) DEFAULT NULL,
  `c23` varchar(6) DEFAULT NULL,
  `c24` varchar(6) DEFAULT NULL,
  `c25` varchar(6) DEFAULT NULL,
  `c26` varchar(6) DEFAULT NULL,
  `c27` varchar(6) DEFAULT NULL,
  `c28` varchar(6) DEFAULT NULL,
  `c29` varchar(6) DEFAULT NULL,
  `c30` varchar(6) DEFAULT NULL,
  `c31` varchar(6) DEFAULT NULL,
  `c32` varchar(6) DEFAULT NULL,
  `i1` varchar(6) DEFAULT NULL,
  `i2` varchar(6) DEFAULT NULL,
  `i3` varchar(6) DEFAULT NULL,
  `i4` varchar(6) DEFAULT NULL,
  `i5` varchar(6) DEFAULT NULL,
  `i6` varchar(6) DEFAULT NULL,
  `i7` varchar(6) DEFAULT NULL,
  `i8` varchar(6) DEFAULT NULL,
  `i9` varchar(6) DEFAULT NULL,
  `i10` varchar(6) DEFAULT NULL,
  `i11` varchar(6) DEFAULT NULL,
  `i12` varchar(6) DEFAULT NULL,
  `i13` varchar(6) DEFAULT NULL,
  `i14` varchar(6) DEFAULT NULL,
  `i15` varchar(6) DEFAULT NULL,
  `i16` varchar(6) DEFAULT NULL,
  `i17` varchar(6) DEFAULT NULL,
  `i18` varchar(6) DEFAULT NULL,
  `i19` varchar(6) DEFAULT NULL,
  `i20` varchar(6) DEFAULT NULL,
  `i21` varchar(6) DEFAULT NULL,
  `i22` varchar(6) DEFAULT NULL,
  `i23` varchar(6) DEFAULT NULL,
  `i24` varchar(6) DEFAULT NULL,
  `i25` varchar(6) DEFAULT NULL,
  `i26` varchar(6) DEFAULT NULL,
  `i27` varchar(6) DEFAULT NULL,
  `i28` varchar(6) DEFAULT NULL,
  `i29` varchar(6) DEFAULT NULL,
  `i30` varchar(6) DEFAULT NULL,
  `i31` varchar(6) DEFAULT NULL,
  `i32` varchar(6) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `puantajid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_tahakkuk
-- 

-- 
-- Table structure for table pts_takimplan
-- 

DROP TABLE IF EXISTS pts_takimplan;
CREATE TABLE `pts_takimplan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `takimkod` varchar(5) DEFAULT NULL,
  `grupid` int(11) DEFAULT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  `puantajid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_takimplan
-- 

-- 
-- Table structure for table pts_tatilparametre
-- 

DROP TABLE IF EXISTS pts_tatilparametre;
CREATE TABLE `pts_tatilparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `puantajid` int(11) NOT NULL,
  `saat` time DEFAULT NULL,
  `tip` varchar(20) DEFAULT NULL,
  `calismaturid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `puantajid` (`puantajid`),
  CONSTRAINT `pts_tatilparametre_fk` FOREIGN KEY (`puantajid`) REFERENCES `pts_puantajparametre` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_tatilparametre
-- 

LOCK TABLES pts_tatilparametre WRITE;
INSERT INTO pts_tatilparametre VALUES
 (19,49,'04:00:00','calismissaver',7),
 (20,50,'09:00:00','normalver',7),
 (22,62,'08:00:00','normalver',7),
 (23,52,'07:30:00','normalver',7),
 (24,54,'07:30:00','normalver',7),
 (25,56,'07:30:00','normalver',7),
 (26,58,'03:00:00','calismissaver',7),
 (27,59,'08:00:00','normalver',7),
 (28,64,'07:30:00','normalver',7),
 (29,65,'09:00:00','normalver',7),
 (30,66,'04:00:00','calismissaver',7),
 (31,67,'07:30:00','normalver',7);
UNLOCK TABLES;

-- 
-- Table structure for table pts_tempaktarim
-- 

DROP TABLE IF EXISTS pts_tempaktarim;
CREATE TABLE `pts_tempaktarim` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `kartno` varchar(10) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `trmno` varchar(10) DEFAULT NULL,
  `tus` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_tempaktarim
-- 

LOCK TABLES pts_tempaktarim WRITE;
INSERT INTO pts_tempaktarim VALUES
 (33,'00763C2F','2011-09-29','11:52:00','',''),
 (34,'00764F66','2011-09-29','11:52:00','',''),
 (35,'00763C2F','2011-09-29','11:52:00','',''),
 (36,'00764F66','2011-09-29','11:52:00','',''),
 (37,'00763C2F','2011-09-29','11:53:00','','');
UNLOCK TABLES;

-- 
-- Table structure for table pts_tempaktarim2
-- 

DROP TABLE IF EXISTS pts_tempaktarim2;
CREATE TABLE `pts_tempaktarim2` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `kartno` varchar(10) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `trmno` varchar(10) DEFAULT NULL,
  `tus` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_tempaktarim2
-- 

-- 
-- Table structure for table pts_ziyaretci
-- 

DROP TABLE IF EXISTS pts_ziyaretci;
CREATE TABLE `pts_ziyaretci` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kartfc` varchar(5) NOT NULL DEFAULT '',
  `kartno` varchar(10) NOT NULL DEFAULT '',
  `kartid` varchar(10) NOT NULL DEFAULT '',
  `ad` varchar(60) DEFAULT NULL,
  `soyad` varchar(60) DEFAULT NULL,
  `ceptel` varchar(30) DEFAULT NULL,
  `plaka` varchar(30) DEFAULT NULL,
  `firmaad` varchar(500) DEFAULT NULL,
  `aciklama` varchar(500) DEFAULT NULL,
  `personelturu` varchar(10) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kartno` (`kartno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table pts_ziyaretci
-- 

-- 
-- Table structure for table servis
-- 

DROP TABLE IF EXISTS servis;
CREATE TABLE `servis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table servis
-- 

-- 
-- Table structure for table sgkbelgeturleri
-- 

DROP TABLE IF EXISTS sgkbelgeturleri;
CREATE TABLE `sgkbelgeturleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` smallint(6) DEFAULT NULL,
  `tur` varchar(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkbelgeturleri
-- 

LOCK TABLES sgkbelgeturleri WRITE;
INSERT INTO sgkbelgeturleri VALUES
 (1,1,'01','TÜM SİGORTA KOLLARI/YABANCI UYRUKLU'),
 (2,2,'02','SOS.GÜV.DES PRİM BİLDİRGE'),
 (3,3,'03','2098 S.KANUN IŞŞIZ.DAHİL'),
 (4,4,'04','YERALTI SÜREKLİ'),
 (5,5,'05','YERALTI GRUPLU'),
 (6,6,'06','YERÜSTÜ GRUPLU'),
 (7,7,'07','ÇIRAK/STAJYER ÖĞRENCİ'),
 (8,18,'18','GOREV-MALULLUK AYL. AL.'),
 (9,19,'19','CEZA İNFAZ/TUTUKEVİ ÇALIŞ'),
 (10,20,'20','ALMANYA FEDERAL CUM.ÇALIŞ'),
 (11,21,'21','SGS İMZALANMIŞ ÜLKELER'),
 (12,22,'22','MES.LİSESİ ZORUNLU STAJ'),
 (13,23,'23','HARP ML3713/2330 KVS TABİ'),
 (14,24,'24','HARP ML3713/2330 KISA+UZUN'),
 (15,25,'25','4447 İŞS.ALYM.KURSİYER'),
 (16,28,'28','4046 21.MD.İŞ KAYBI TAZM.'),
 (17,29,'29','60 GUN FİİLİ SÜR.ZAM.TABİ'),
 (18,31,'31','HARP MALÜL.3713 VE 2330'),
 (19,32,'32','TSKT 90 GÜN FİİLLİ HİZ.SÜR'),
 (20,34,'34','HARP MAL.3713/2330 90 GUN'),
 (21,35,'35','T.S.K.T ÇALIŞIP 180 GÜN F'),
 (22,37,'37','HARP MAL 3713/2330 G.V.MA'),
 (23,39,'39','BİR.KRAL.İKA.ED İSVİCRE U'),
 (24,41,'41','KAMU İDR.İŞ AKDİ ASKIDA'),
 (25,42,'42','ÇIRAK/ÖĞR.BAKIM.YÜKM.DEĞİL'),
 (26,43,'43','STAJYER BAKIM.YÜKM.DEĞİL'),
 (27,44,'44','İŞKUR KURS.BAK.YÜKM.DEĞİL');
UNLOCK TABLES;

-- 
-- Table structure for table sgkbordroparametreleri
-- 

DROP TABLE IF EXISTS sgkbordroparametreleri;
CREATE TABLE `sgkbordroparametreleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gecerlibaslangictarihi` date DEFAULT NULL,
  `yil` smallint(6) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL,
  `sgkisci` decimal(11,5) DEFAULT NULL COMMENT 'SSK primi işçi payı',
  `sgkisveren` decimal(11,5) DEFAULT NULL COMMENT 'SSK Primi işveren payı',
  `issizlikisci` decimal(11,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işçi payı',
  `issizlikisveren` decimal(11,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işveren payı',
  `gelirvergisi` decimal(11,5) DEFAULT NULL,
  `damgavergisi` decimal(11,5) DEFAULT NULL,
  `tehlikesinifi` decimal(11,5) DEFAULT NULL,
  `brutucretkatsayisi` decimal(11,5) DEFAULT NULL,
  `sgkisci1` decimal(11,5) DEFAULT NULL COMMENT 'SSK primi işçi payı emekli',
  `sgkisveren1` decimal(11,5) DEFAULT NULL COMMENT 'SSK Primi işveren payı emekli',
  `issizlikisci1` decimal(11,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işçi payı emekli',
  `issizlikisveren1` decimal(11,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işveren payı emekli',
  `ozurlulukindirimi1` decimal(11,2) DEFAULT NULL,
  `ozurlulukindirimi2` decimal(11,2) DEFAULT NULL,
  `ozurlulukindirimi3` decimal(11,2) DEFAULT NULL,
  `agibruttutar16buyuk` decimal(11,2) DEFAULT NULL,
  `agibruttutar16kucuk` decimal(11,2) DEFAULT NULL,
  `agibruttutarustsinir` decimal(11,2) DEFAULT NULL,
  `agioranCalisan` decimal(11,2) DEFAULT NULL,
  `agioranEs` decimal(11,2) DEFAULT NULL,
  `agioran2cocuk` decimal(11,2) DEFAULT NULL,
  `agioran3cocuk` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkbordroparametreleri
-- 

-- 
-- Table structure for table sgkgelirvergisidilimleri
-- 

DROP TABLE IF EXISTS sgkgelirvergisidilimleri;
CREATE TABLE `sgkgelirvergisidilimleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gecerlibaslangictarihi` date DEFAULT NULL,
  `yil` smallint(6) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL,
  `sira` int(11) DEFAULT NULL,
  `altsinir` double(15,5) DEFAULT NULL,
  `ustsinir` double(15,5) DEFAULT NULL,
  `oran` decimal(11,5) DEFAULT NULL,
  `tutar` double(15,5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkgelirvergisidilimleri
-- 

-- 
-- Table structure for table sgkgelirvergisioranlari
-- 

DROP TABLE IF EXISTS sgkgelirvergisioranlari;
CREATE TABLE `sgkgelirvergisioranlari` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yil` smallint(6) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL,
  `altsinir` double(15,5) DEFAULT NULL COMMENT 'SSK Primi işveren payı',
  `ustsinir` double(15,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işçi payı',
  `oran` decimal(11,5) DEFAULT NULL COMMENT 'İşsizlik sigortası işveren payı',
  `tutar` double(20,5) DEFAULT NULL,
  `aciklama` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkgelirvergisioranlari
-- 

LOCK TABLES sgkgelirvergisioranlari WRITE;
INSERT INTO sgkgelirvergisioranlari VALUES
 (1,2015,1,0.00000,12000.00000,15.00000,NULL,'1. Dilim'),
 (2,2015,1,12000.01000,29000.00000,20.00000,NULL,'2. Dilim'),
 (3,2015,1,29000.01000,106000.00000,27.00000,NULL,'3. Dilim'),
 (4,2015,1,106000.01000,10000000.00000,35.00000,NULL,'4. Dilim'),
 (5,2015,2,0.00000,12000.00000,15.00000,NULL,'1. Dilim'),
 (6,2015,2,12000.01000,29000.00000,20.00000,NULL,'2. Dilim'),
 (7,2015,2,29000.01000,106000.00000,27.00000,NULL,'3. Dilim'),
 (8,2015,2,106000.01000,10000000.00000,35.00000,NULL,'4. Dilim');
UNLOCK TABLES;

-- 
-- Table structure for table sgkihbarbordrosu
-- 

DROP TABLE IF EXISTS sgkihbarbordrosu;
CREATE TABLE `sgkihbarbordrosu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `yil` smallint(6) DEFAULT NULL,
  `ay` smallint(6) DEFAULT NULL,
  `istencikiskodu` varchar(5) DEFAULT NULL,
  `baslangictarihi` date DEFAULT NULL,
  `bitistarihi` date DEFAULT NULL,
  `toplamgun` int(11) DEFAULT NULL,
  `calisilanyil` int(11) DEFAULT NULL,
  `calisilangun` int(11) DEFAULT NULL,
  `calisilanay` int(11) DEFAULT NULL,
  `tavan` decimal(11,3) DEFAULT NULL COMMENT 'kidemtazminattavani ,ihbarda yok',
  `brutucret` decimal(11,3) DEFAULT NULL,
  `giydirilmisbrutucret` decimal(11,3) DEFAULT NULL COMMENT 'brutucret+yol+yemek+prim+ikramiye',
  `matrah` decimal(11,3) DEFAULT NULL COMMENT 'kidem/ihbar in brutu',
  `gelirvergisi` decimal(11,3) DEFAULT NULL,
  `damgavergisi` decimal(11,3) DEFAULT NULL,
  `net` decimal(11,3) DEFAULT NULL COMMENT 'kidem/ihbar in neti',
  PRIMARY KEY (`id`),
  KEY `Index 2` (`personelid`,`yil`,`ay`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkihbarbordrosu
-- 

-- 
-- Table structure for table sgkiscipayi
-- 

DROP TABLE IF EXISTS sgkiscipayi;
CREATE TABLE `sgkiscipayi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yil` smallint(6) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL,
  `sigortakolu` varchar(200) DEFAULT NULL,
  `normal` decimal(11,5) DEFAULT NULL,
  `emekli` decimal(11,5) DEFAULT NULL,
  `cirak` decimal(11,5) DEFAULT NULL,
  `yabanci` decimal(11,5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkiscipayi
-- 

LOCK TABLES sgkiscipayi WRITE;
INSERT INTO sgkiscipayi VALUES
 (1,2015,1,'Malullük, Yaşlılık ve Ölüm Sigortaları Primi',9.00000,0.00000,0.00000,0.00000),
 (2,2015,1,'Kısa Vadeli Sigorta Kolları Primi',0.00000,0.00000,0.00000,0.00000),
 (3,2015,1,'Genel Sağlık Sigortası Primi',5.00000,0.00000,0.00000,5.00000),
 (4,2015,1,'Sosyal Güvenlik Destek Primi',0.00000,7.50000,0.00000,0.00000),
 (5,2015,1,'İşsizlik Sigortası Primi',1.00000,0.00000,0.00000,0.00000),
 (6,2015,2,'Malullük, Yaşlılık ve Ölüm Sigortaları Primi',9.00000,0.00000,0.00000,0.00000),
 (7,2015,2,'Kısa Vadeli Sigorta Kolları Primi',0.00000,0.00000,0.00000,0.00000),
 (8,2015,2,'Genel Sağlık Sigortası Primi',5.00000,0.00000,0.00000,5.00000),
 (9,2015,2,'Sosyal Güvenlik Destek Primi',0.00000,7.50000,0.00000,0.00000),
 (10,2015,2,'İşsizlik Sigortası Primi',1.00000,0.00000,0.00000,0.00000);
UNLOCK TABLES;

-- 
-- Table structure for table sgkisverenpayi
-- 

DROP TABLE IF EXISTS sgkisverenpayi;
CREATE TABLE `sgkisverenpayi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yil` smallint(6) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL,
  `sigortakolu` varchar(200) DEFAULT NULL,
  `normal` decimal(11,5) DEFAULT NULL,
  `emekli` decimal(11,5) DEFAULT NULL,
  `cirak` decimal(11,5) DEFAULT NULL,
  `yabanci` decimal(11,5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkisverenpayi
-- 

LOCK TABLES sgkisverenpayi WRITE;
INSERT INTO sgkisverenpayi VALUES
 (1,2015,1,'Malullük, Yaşlılık ve Ölüm Sigortaları Primi',11.00000,0.00000,0.00000,0.00000),
 (2,2015,1,'Kısa Vadeli Sigorta Kolları Primi',2.00000,0.00000,0.00000,2.00000),
 (3,2015,1,'Genel Sağlık Sigortası Primi',7.50000,0.00000,0.00000,12.00000),
 (4,2015,1,'Sosyal Güvenlik Destek Primi',0.00000,22.50000,0.00000,0.00000),
 (5,2015,1,'İşsizlik Sigortası Primi',2.00000,0.00000,0.00000,0.00000),
 (6,2015,2,'Malullük, Yaşlılık ve Ölüm Sigortaları Primi',11.00000,0.00000,0.00000,0.00000),
 (7,2015,2,'Kısa Vadeli Sigorta Kolları Primi',2.00000,0.00000,0.00000,2.00000),
 (8,2015,2,'Genel Sağlık Sigortası Primi',7.50000,0.00000,0.00000,12.00000),
 (9,2015,2,'Sosyal Güvenlik Destek Primi',0.00000,22.50000,0.00000,0.00000),
 (10,2015,2,'İşsizlik Sigortası Primi',2.00000,0.00000,0.00000,0.00000);
UNLOCK TABLES;

-- 
-- Table structure for table sgkkanunlar
-- 

DROP TABLE IF EXISTS sgkkanunlar;
CREATE TABLE `sgkkanunlar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kod` smallint(6) DEFAULT NULL,
  `kanun` varchar(10) DEFAULT NULL,
  `aciklama` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkkanunlar
-- 

LOCK TABLES sgkkanunlar WRITE;
INSERT INTO sgkkanunlar VALUES
 (1,0,'00000','Hiçbir kanuna tabi değil'),
 (2,1,'05510','5510 sayılı SGK kanununa tabi '),
 (3,2,'06111','6111 sayılı SGK kanununa tabi'),
 (4,3,'85084','Hazine kanununa (5084) tabi (%80)'),
 (5,4,'05084','Hazine kanununa (5084) tabi (%100)'),
 (6,5,'04325','Olağanüstü hal kanununa tabi'),
 (7,6,'04369','Sendika indirimi kanununa tabi'),
 (8,7,'04382','Sakatlık indirimi kanununa tabi'),
 (9,8,'04747','Borç erteleme kanununa'),
 (10,9,'4747S','Sendikalı borç erteleme kanununa tabi'),
 (11,10,'04857','Sakatlık-Eski hükümlü-Terör kanununa tabi'),
 (12,11,'85350','Hazine kanununa (5350) tabi (%80)'),
 (13,12,'05350','Hazine kanununa (5350) tabi (%100)'),
 (14,13,'85615','Hazine kanununa (5615) tabi (%80)'),
 (15,14,'05615','Hazine kanununa (5615) tabi (%100)'),
 (16,15,'05746','5746 sayılı ARGE faaliyetlerinin desteklenmesi kanununa tabi'),
 (17,16,'14447','5763 sayılı iş kanununa tabi (Sağlam) (%100)'),
 (18,17,'14857','5763 sayılı iş kanununa tabi (Kontenjan dahili özürlü)'),
 (19,18,'54857','5763 sayılı iş kanununa tabi (Kontenjan harici özürlü)'),
 (20,19,'84447','5763 sayılı iş kanununa tabi (Sağlam) (%80)'),
 (21,20,'64447','5763 sayılı iş kanununa tabi (Sağlam) (%60)'),
 (22,21,'44447','5763 sayılı iş kanununa tabi (Sağlam) (%40)'),
 (23,22,'24447','5763 sayılı iş kanununa tabi (Sağlam) (%20)'),
 (24,23,'05921','5921 sayılı SGK kanununa tabi'),
 (25,24,'25510','25510 sayılı SGK kanununa tabi'),
 (26,25,'16322','6322 sayılı SGK kanununa tabi(1..5 inci bölge)'),
 (27,26,'26322','6322 sayılı SGK kanununa tabi(6 nci bölge)'),
 (28,27,'55225','5225 sayılı SGK kültür yatırımı ve girişimi kanununa tabi (Yatırım aşaması)'),
 (29,28,'25225','5225 sayılı SGK kültür yatırımı ve girişimi kanununa tabi (İşletme aşaması)'),
 (30,29,'06486','06486 sayılı SGK kanununa tabi'),
 (31,30,'46486','46486 sayılı SGK kanununa tabi'),
 (32,31,'56486','56486 sayılı SGK kanununa tabi'),
 (33,32,'66486','56486 sayılı SGK kanununa tabi');
UNLOCK TABLES;

-- 
-- Table structure for table sgkkidembordrosu
-- 

DROP TABLE IF EXISTS sgkkidembordrosu;
CREATE TABLE `sgkkidembordrosu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `yil` smallint(6) DEFAULT NULL,
  `ay` smallint(6) DEFAULT NULL,
  `istencikiskodu` varchar(5) DEFAULT NULL,
  `baslangictarihi` date DEFAULT NULL,
  `bitistarihi` date DEFAULT NULL,
  `toplamgun` int(11) DEFAULT NULL,
  `calisilanyil` int(11) DEFAULT NULL,
  `calisilangun` int(11) DEFAULT NULL,
  `calisilanay` int(11) DEFAULT NULL,
  `tavan` decimal(11,3) DEFAULT NULL COMMENT 'kidemtazminattavani ,ihbarda yok',
  `brutucret` decimal(11,3) DEFAULT NULL,
  `giydirilmisbrutucret` decimal(11,3) DEFAULT NULL COMMENT 'brutucret+yol+yemek+prim+ikramiye',
  `matrah` decimal(11,3) DEFAULT NULL COMMENT 'kidem/ihbar in brutu',
  `gelirvergisi` decimal(11,3) DEFAULT NULL,
  `damgavergisi` decimal(11,3) DEFAULT NULL,
  `net` decimal(11,3) DEFAULT NULL COMMENT 'kidem/ihbar in neti',
  PRIMARY KEY (`id`),
  KEY `Index 2` (`personelid`,`yil`,`ay`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkkidembordrosu
-- 

-- 
-- Table structure for table sgkrapor
-- 

DROP TABLE IF EXISTS sgkrapor;
CREATE TABLE `sgkrapor` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tip` varchar(30) DEFAULT NULL,
  `alan` varchar(60) DEFAULT NULL,
  `gun` tinyint(1) DEFAULT '0' COMMENT 'sabitlerde sadece bu gecerli',
  `saat` tinyint(1) DEFAULT '0',
  `ucret` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkrapor
-- 

LOCK TABLES sgkrapor WRITE;
INSERT INTO sgkrapor VALUES
 (1,'sabit','ad',1,0,0),
 (2,'sabit','soyad',1,0,0),
 (3,'sabit','kimlikno',1,0,0),
 (4,'sabit','isegiristarihi',1,0,0),
 (5,'sabit','istencikistarihi',1,0,0),
 (6,'sabit','sgk_belgeturu',1,0,0),
 (7,'sabit','gk_tabioldugukanun',1,0,0),
 (8,'sabit','sgk_ozurlulukderecesi',0,0,0),
 (9,'sabit','sgk_meslekkodu',0,0,0),
 (10,'sabit','sgk_grubu',0,0,0),
 (11,'sabit','sgk_ucrettipi',0,0,0),
 (12,'sabit','sgk_hesaptipi',0,0,0),
 (13,'sabit','ucret',0,0,0),
 (14,'sabit','eksikneden',0,0,0),
 (15,'sabit','sgkgun',0,0,0),
 (16,'sabit','toplamkazanc',0,0,0),
 (17,'sabit','sgkisciprimi',0,0,0),
 (18,'sabit','issizlikisciprimi',0,0,0),
 (19,'sabit','sgkisverenprimi',0,0,0),
 (20,'sabit','issizlikisverenprimi',0,0,0),
 (21,'sabit','sgkisverenmatrahi',0,0,0),
 (22,'sabit','gelirvergisimatrahi',0,0,0),
 (23,'sabit','agioncesigelirvergisi',0,0,0),
 (24,'sabit','gelirvergisi',0,0,0),
 (25,'sabit','kumulatifgelirvergisimatrahi',0,0,0),
 (26,'sabit','damgavergisimatrahi',0,0,0),
 (27,'sabit','damgavergisi',0,0,0),
 (28,'sabit','toplamyasalkesinti',0,0,0),
 (29,'sabit','toplamkesinti',0,0,0),
 (30,'sabit','netucret',0,0,0),
 (31,'sabit','agi',0,0,0),
 (32,'sabit','netodenen',0,0,0),
 (33,'sabit','gvdilimi',0,0,0),
 (34,'sabit','terkin1',0,0,0),
 (35,'sabit','terkin3',0,0,0),
 (36,'sabit','terkin3',0,0,0),
 (37,'kazanc','1',1,1,1),
 (38,'kazanc','2',0,0,0),
 (39,'kazanc','3',0,0,0),
 (40,'kazanc','4',0,0,0),
 (41,'kazanc','5',0,0,0),
 (42,'kazanc','6',0,0,0),
 (43,'kazanc','7',0,0,0),
 (44,'kazanc','8',0,0,0),
 (45,'kazanc','9',0,0,0),
 (46,'kazanc','10',0,0,0),
 (47,'kazanc','11',0,0,0),
 (48,'kazanc','12',0,0,0),
 (49,'kazanc','13',0,0,0),
 (50,'kazanc','14',0,0,0),
 (51,'kazanc','15',0,0,0),
 (52,'kazanc','16',0,0,0),
 (53,'ekkazanc','1',0,0,0),
 (54,'ekkazanc','2',0,0,0),
 (55,'ekkazanc','3',0,0,0),
 (56,'ekkazanc','4',0,0,0),
 (57,'ekkazanc','5',0,0,0),
 (58,'ekkazanc','6',0,0,0),
 (59,'ekkazanc','7',0,0,0),
 (60,'ekkazanc','8',0,0,0),
 (61,'ekkazanc','9',0,0,0),
 (62,'ekkazanc','10',0,0,0),
 (63,'ekkazanc','11',0,0,0),
 (64,'ekkazanc','12',0,0,0),
 (65,'ekkazanc','13',0,0,0),
 (66,'ekkazanc','14',0,0,0),
 (67,'ekkazanc','15',0,0,0),
 (68,'ekkazanc','16',0,0,0),
 (69,'ekodeme','1',0,0,0),
 (70,'ekodeme','2',0,0,0),
 (71,'ekodeme','3',0,0,0),
 (72,'ekodeme','4',0,0,0),
 (73,'ekodeme','5',0,0,0),
 (74,'ekodeme','6',0,0,0),
 (75,'ekodeme','7',0,0,0),
 (76,'ekodeme','8',0,0,0),
 (77,'ekodeme','9',0,0,0),
 (78,'ekodeme','10',0,0,0),
 (79,'ekodeme','11',0,0,0),
 (80,'ekodeme','12',0,0,0),
 (81,'ekodeme','13',0,0,0),
 (82,'ekodeme','14',0,0,0),
 (83,'ekodeme','15',0,0,0),
 (84,'ekodeme','16',0,0,0),
 (85,'ekkesinti','1',0,0,0),
 (86,'ekkesinti','2',0,0,0),
 (87,'ekkesinti','3',0,0,0),
 (88,'ekkesinti','4',0,0,0),
 (89,'ekkesinti','5',0,0,0),
 (90,'ekkesinti','6',0,0,0),
 (91,'ekkesinti','7',0,0,0),
 (92,'ekkesinti','8',0,0,0),
 (93,'ekkesinti','9',0,0,0),
 (94,'ekkesinti','10',0,0,0),
 (95,'ekkesinti','11',0,0,0),
 (96,'ekkesinti','12',0,0,0),
 (97,'ekkesinti','13',0,0,0),
 (98,'ekkesinti','14',0,0,0),
 (99,'ekkesinti','15',0,0,0),
 (100,'ekkesinti','16',0,0,0);
UNLOCK TABLES;

-- 
-- Table structure for table sgkucretbordrosu
-- 

DROP TABLE IF EXISTS sgkucretbordrosu;
CREATE TABLE `sgkucretbordrosu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `yil` smallint(6) DEFAULT NULL,
  `ay` smallint(6) DEFAULT NULL,
  `ngun1` decimal(11,2) DEFAULT NULL,
  `nsaat1` decimal(11,2) DEFAULT NULL,
  `nucret1` decimal(11,3) DEFAULT NULL,
  `ngun2` decimal(11,2) DEFAULT NULL,
  `nsaat2` decimal(11,2) DEFAULT NULL,
  `nucret2` decimal(11,3) DEFAULT NULL,
  `ngun3` decimal(11,2) DEFAULT NULL,
  `nsaat3` decimal(11,2) DEFAULT NULL,
  `nucret3` decimal(11,3) DEFAULT NULL,
  `ngun4` decimal(11,2) DEFAULT NULL,
  `nsaat4` decimal(11,2) DEFAULT NULL,
  `nucret4` decimal(11,3) DEFAULT NULL,
  `ngun5` decimal(11,2) DEFAULT NULL,
  `nsaat5` decimal(11,2) DEFAULT NULL,
  `nucret5` decimal(11,3) DEFAULT NULL,
  `ngun6` decimal(11,2) DEFAULT NULL,
  `nsaat6` decimal(11,2) DEFAULT NULL,
  `nucret6` decimal(11,3) DEFAULT NULL,
  `ngun7` decimal(11,2) DEFAULT NULL,
  `nsaat7` decimal(11,2) DEFAULT NULL,
  `nucret7` decimal(11,3) DEFAULT NULL,
  `ngun8` decimal(11,2) DEFAULT NULL,
  `nsaat8` decimal(11,2) DEFAULT NULL,
  `nucret8` decimal(11,3) DEFAULT NULL,
  `ngun9` decimal(11,2) DEFAULT NULL,
  `nsaat9` decimal(11,2) DEFAULT NULL,
  `nucret9` decimal(11,3) DEFAULT NULL,
  `ngun10` decimal(11,2) DEFAULT NULL,
  `nsaat10` decimal(11,2) DEFAULT NULL,
  `nucret10` decimal(11,3) DEFAULT NULL,
  `ngun11` decimal(11,2) DEFAULT NULL,
  `nsaat11` decimal(11,2) DEFAULT NULL,
  `nucret11` decimal(11,3) DEFAULT NULL,
  `ngun12` decimal(11,2) DEFAULT NULL,
  `nsaat12` decimal(11,2) DEFAULT NULL,
  `nucret12` decimal(11,3) DEFAULT NULL,
  `ngun13` decimal(11,2) DEFAULT NULL,
  `nsaat13` varchar(6) DEFAULT NULL,
  `nucret13` decimal(11,3) DEFAULT NULL,
  `ngun14` decimal(11,2) DEFAULT NULL,
  `nsaat14` decimal(11,2) DEFAULT NULL,
  `nucret14` decimal(11,3) DEFAULT NULL,
  `ngun15` decimal(11,2) DEFAULT NULL,
  `nsaat15` decimal(11,2) DEFAULT NULL,
  `nucret15` decimal(11,3) DEFAULT NULL,
  `ngun16` decimal(11,2) DEFAULT NULL,
  `nsaat16` decimal(11,2) DEFAULT NULL,
  `nucret16` decimal(11,3) DEFAULT NULL,
  `toplamngun` decimal(11,2) DEFAULT NULL,
  `toplamnsaat` decimal(11,2) DEFAULT NULL,
  `toplamnucret` decimal(11,3) DEFAULT NULL,
  `fsaat1` decimal(11,2) DEFAULT NULL,
  `fucret1` decimal(11,3) DEFAULT NULL,
  `fsaat2` decimal(11,2) DEFAULT NULL,
  `fucret2` decimal(11,3) DEFAULT NULL,
  `fsaat3` decimal(11,2) DEFAULT NULL,
  `fucret3` decimal(11,3) DEFAULT NULL,
  `fsaat4` decimal(11,2) DEFAULT NULL,
  `fucret4` decimal(11,3) DEFAULT NULL,
  `fsaat5` decimal(11,2) DEFAULT NULL,
  `fucret5` decimal(11,3) DEFAULT NULL,
  `fsaat6` decimal(11,2) DEFAULT NULL,
  `fucret6` decimal(11,3) DEFAULT NULL,
  `fsaat7` decimal(11,2) DEFAULT NULL,
  `fucret7` decimal(11,3) DEFAULT NULL,
  `fsaat8` decimal(11,2) DEFAULT NULL,
  `fucret8` decimal(11,3) DEFAULT NULL,
  `fsaat9` decimal(11,2) DEFAULT NULL,
  `fucret9` decimal(11,3) DEFAULT NULL,
  `fsaat10` decimal(11,2) DEFAULT NULL,
  `fucret10` decimal(11,3) DEFAULT NULL,
  `fsaat11` decimal(11,2) DEFAULT NULL,
  `fucret11` decimal(11,3) DEFAULT NULL,
  `fsaat12` decimal(11,2) DEFAULT NULL,
  `fucret12` decimal(11,3) DEFAULT NULL,
  `fsaat13` decimal(11,2) DEFAULT NULL,
  `fucret13` decimal(11,3) DEFAULT NULL,
  `fsaat14` decimal(11,2) DEFAULT NULL,
  `fucret14` decimal(11,3) DEFAULT NULL,
  `fsaat15` decimal(11,2) DEFAULT NULL,
  `fucret15` decimal(11,3) DEFAULT NULL,
  `fsaat16` decimal(11,2) DEFAULT NULL,
  `fucret16` decimal(11,3) DEFAULT NULL,
  `toplamfsaat` decimal(11,2) DEFAULT NULL,
  `toplamfucret` decimal(11,3) DEFAULT NULL,
  `egun1` decimal(11,2) DEFAULT NULL,
  `esaat1` decimal(11,2) DEFAULT NULL,
  `eucret1` decimal(11,3) DEFAULT NULL,
  `egun2` decimal(11,2) DEFAULT NULL,
  `esaat2` decimal(11,2) DEFAULT NULL,
  `eucret2` decimal(11,3) DEFAULT NULL,
  `egun3` decimal(11,2) DEFAULT NULL,
  `esaat3` decimal(11,2) DEFAULT NULL,
  `eucret3` decimal(11,3) DEFAULT NULL,
  `egun4` decimal(11,2) DEFAULT NULL,
  `esaat4` decimal(11,2) DEFAULT NULL,
  `eucret4` decimal(11,3) DEFAULT NULL,
  `egun5` decimal(11,2) DEFAULT NULL,
  `esaat5` decimal(11,2) DEFAULT NULL,
  `eucret5` decimal(11,3) DEFAULT NULL,
  `egun6` decimal(11,2) DEFAULT NULL,
  `esaat6` decimal(11,2) DEFAULT NULL,
  `eucret6` decimal(11,3) DEFAULT NULL,
  `egun7` decimal(11,2) DEFAULT NULL,
  `esaat7` decimal(11,2) DEFAULT NULL,
  `eucret7` decimal(11,3) DEFAULT NULL,
  `egun8` decimal(11,2) DEFAULT NULL,
  `esaat8` decimal(11,2) DEFAULT NULL,
  `eucret8` decimal(11,3) DEFAULT NULL,
  `egun9` decimal(11,2) DEFAULT NULL,
  `esaat9` decimal(11,2) DEFAULT NULL,
  `eucret9` decimal(11,3) DEFAULT NULL,
  `egun10` decimal(11,2) DEFAULT NULL,
  `esaat10` decimal(11,2) DEFAULT NULL,
  `eucret10` decimal(11,3) DEFAULT NULL,
  `egun11` decimal(11,2) DEFAULT NULL,
  `esaat11` decimal(11,2) DEFAULT NULL,
  `eucret11` decimal(11,3) DEFAULT NULL,
  `egun12` decimal(11,2) DEFAULT NULL,
  `esaat12` decimal(11,2) DEFAULT NULL,
  `eucret12` decimal(11,3) DEFAULT NULL,
  `egun13` decimal(11,2) DEFAULT NULL,
  `esaat13` varchar(6) DEFAULT NULL,
  `eucret13` decimal(11,3) DEFAULT NULL,
  `egun14` decimal(11,2) DEFAULT NULL,
  `esaat14` decimal(11,2) DEFAULT NULL,
  `eucret14` decimal(11,3) DEFAULT NULL,
  `egun15` decimal(11,2) DEFAULT NULL,
  `esaat15` decimal(11,2) DEFAULT NULL,
  `eucret15` decimal(11,3) DEFAULT NULL,
  `egun16` decimal(11,2) DEFAULT NULL,
  `esaat16` decimal(11,2) DEFAULT NULL,
  `eucret16` decimal(11,3) DEFAULT NULL,
  `toplamegun` decimal(11,2) DEFAULT NULL,
  `toplamesaat` decimal(11,2) DEFAULT NULL,
  `toplameucret` decimal(11,3) DEFAULT NULL,
  `ekodeme1` decimal(11,3) DEFAULT NULL,
  `ekodeme2` decimal(11,3) DEFAULT NULL,
  `ekodeme3` decimal(11,3) DEFAULT NULL,
  `ekodeme4` decimal(11,3) DEFAULT NULL,
  `ekodeme5` decimal(11,3) DEFAULT NULL,
  `ekodeme6` decimal(11,3) DEFAULT NULL,
  `ekodeme7` decimal(11,3) DEFAULT NULL,
  `ekodeme8` decimal(11,3) DEFAULT NULL,
  `ekodeme9` decimal(11,3) DEFAULT NULL,
  `ekodeme10` decimal(11,3) DEFAULT NULL,
  `ekodeme11` decimal(11,3) DEFAULT NULL,
  `ekodeme12` decimal(11,3) DEFAULT NULL,
  `ekodeme13` decimal(11,3) DEFAULT NULL,
  `ekodeme14` decimal(11,3) DEFAULT NULL,
  `ekodeme15` decimal(11,3) DEFAULT NULL,
  `ekodeme16` decimal(11,3) DEFAULT NULL,
  `toplamekodeme` decimal(11,3) DEFAULT NULL,
  `ekkesinti1` decimal(11,3) DEFAULT NULL,
  `ekkesinti2` decimal(11,3) DEFAULT NULL,
  `ekkesinti3` decimal(11,3) DEFAULT NULL,
  `ekkesinti4` decimal(11,3) DEFAULT NULL,
  `ekkesinti5` decimal(11,3) DEFAULT NULL,
  `ekkesinti6` decimal(11,3) DEFAULT NULL,
  `ekkesinti7` decimal(11,3) DEFAULT NULL,
  `ekkesinti8` decimal(11,3) DEFAULT NULL,
  `ekkesinti9` decimal(11,3) DEFAULT NULL,
  `ekkesinti10` decimal(11,3) DEFAULT NULL,
  `ekkesinti11` decimal(11,3) DEFAULT NULL,
  `ekkesinti12` decimal(11,3) DEFAULT NULL,
  `ekkesinti13` decimal(11,3) DEFAULT NULL,
  `ekkesinti14` decimal(11,3) DEFAULT NULL,
  `ekkesinti15` decimal(11,3) DEFAULT NULL,
  `ekkesinti16` decimal(11,3) DEFAULT NULL,
  `toplamekkesinti` decimal(11,3) DEFAULT NULL,
  `sgkgun` smallint(6) DEFAULT NULL,
  `toplamkazanc` decimal(11,3) DEFAULT NULL COMMENT '(SGKicin BRUTKAZANC)topnucret+topfucret+topekodeme',
  `myop_isci` decimal(11,3) DEFAULT NULL,
  `kvskp_isci` decimal(11,3) DEFAULT NULL,
  `gssp_isci` decimal(11,3) DEFAULT NULL,
  `sgdp_isci` decimal(11,3) DEFAULT NULL,
  `sgkisciprimi` decimal(11,3) DEFAULT NULL,
  `issizlikisciprimi` decimal(11,3) DEFAULT NULL,
  `sgkiscimatrahi` decimal(11,3) DEFAULT NULL,
  `myop_isveren` decimal(11,3) DEFAULT NULL,
  `kvskp_isveren` decimal(11,3) DEFAULT NULL,
  `gssp_isveren` decimal(11,3) DEFAULT NULL,
  `sgdp_isveren` decimal(11,3) DEFAULT NULL,
  `sgkisverenprimi` decimal(11,3) DEFAULT NULL,
  `issizlikisverenprimi` decimal(11,3) DEFAULT NULL,
  `sgkisverenmatrahi` decimal(11,3) DEFAULT NULL COMMENT 'sgkmatrahi=pek',
  `gelirvergisimatrahi` decimal(11,3) DEFAULT NULL,
  `agioncesigelirvergisi` decimal(11,3) DEFAULT NULL,
  `gelirvergisi` decimal(11,3) DEFAULT NULL,
  `kumulatifgelirvergisimatrahi` decimal(11,3) DEFAULT NULL,
  `damgavergisimatrahi` decimal(11,3) DEFAULT NULL,
  `damgavergisi` decimal(11,3) DEFAULT NULL,
  `toplamyasalkesinti` decimal(11,3) DEFAULT NULL,
  `toplamkesinti` decimal(11,3) DEFAULT NULL COMMENT 'toplamyasalkesinti+toplamekkesinti',
  `devir` decimal(11,3) DEFAULT NULL,
  `netucret` decimal(11,3) DEFAULT NULL,
  `agi` decimal(11,3) DEFAULT NULL,
  `yuvarlamafarki` decimal(11,3) DEFAULT NULL,
  `netodenen` decimal(11,3) DEFAULT NULL,
  `prim_ikramiye` decimal(11,3) DEFAULT NULL,
  `eksikgun` int(11) DEFAULT NULL COMMENT 'eksikgun=toplamegun',
  `eksikneden` varchar(10) DEFAULT NULL,
  `gvdilimi` varchar(30) DEFAULT NULL,
  `aciklama` varchar(150) DEFAULT NULL,
  `terkin1` decimal(11,3) DEFAULT NULL,
  `terkin2` decimal(11,3) DEFAULT NULL,
  `terkin3` decimal(11,3) DEFAULT NULL,
  `terkin4` decimal(11,3) DEFAULT NULL,
  `terkin5` decimal(11,3) DEFAULT NULL,
  `terkin6` decimal(11,3) DEFAULT NULL,
  `terkin7` decimal(11,3) DEFAULT NULL,
  `terkin8` decimal(11,3) DEFAULT NULL,
  `terkin9` decimal(11,3) DEFAULT NULL,
  `terkin10` decimal(11,3) DEFAULT NULL,
  `terkin11` decimal(11,3) DEFAULT NULL,
  `terkin12` decimal(11,3) DEFAULT NULL,
  `terkin13` decimal(11,3) DEFAULT NULL,
  `terkin14` decimal(11,3) DEFAULT NULL,
  `terkin15` decimal(11,3) DEFAULT NULL,
  `terkin16` decimal(11,3) DEFAULT NULL,
  `terkin17` decimal(11,3) DEFAULT NULL,
  `terkin18` decimal(11,3) DEFAULT NULL,
  `terkin19` decimal(11,3) DEFAULT NULL,
  `terkin20` decimal(11,3) DEFAULT NULL,
  `bucret` decimal(11,2) DEFAULT NULL,
  `nucret` decimal(11,2) DEFAULT NULL,
  `nucretn1` decimal(11,3) DEFAULT NULL,
  `nucretn2` decimal(11,3) DEFAULT NULL,
  `nucretn3` decimal(11,3) DEFAULT NULL,
  `nucretn4` decimal(11,3) DEFAULT NULL,
  `nucretn5` decimal(11,3) DEFAULT NULL,
  `nucretn6` decimal(11,3) DEFAULT NULL,
  `nucretn7` decimal(11,3) DEFAULT NULL,
  `nucretn8` decimal(11,3) DEFAULT NULL,
  `nucretn9` decimal(11,3) DEFAULT NULL,
  `nucretn10` decimal(11,3) DEFAULT NULL,
  `nucretn11` decimal(11,3) DEFAULT NULL,
  `nucretn12` decimal(11,3) DEFAULT NULL,
  `nucretn13` decimal(11,3) DEFAULT NULL,
  `nucretn14` decimal(11,3) DEFAULT NULL,
  `nucretn15` decimal(11,3) DEFAULT NULL,
  `nucretn16` decimal(11,3) DEFAULT NULL,
  `fucretn1` decimal(11,3) DEFAULT NULL,
  `fucretn2` decimal(11,3) DEFAULT NULL,
  `fucretn3` decimal(11,3) DEFAULT NULL,
  `fucretn4` decimal(11,3) DEFAULT NULL,
  `fucretn5` decimal(11,3) DEFAULT NULL,
  `fucretn6` decimal(11,3) DEFAULT NULL,
  `fucretn7` decimal(11,3) DEFAULT NULL,
  `fucretn8` decimal(11,3) DEFAULT NULL,
  `fucretn9` decimal(11,3) DEFAULT NULL,
  `fucretn10` decimal(11,3) DEFAULT NULL,
  `fucretn11` decimal(11,3) DEFAULT NULL,
  `fucretn12` decimal(11,3) DEFAULT NULL,
  `fucretn13` decimal(11,3) DEFAULT NULL,
  `fucretn14` decimal(11,3) DEFAULT NULL,
  `fucretn15` decimal(11,3) DEFAULT NULL,
  `fucretn16` decimal(11,3) DEFAULT NULL,
  `ekodemen1` decimal(11,3) DEFAULT NULL,
  `ekodemen2` decimal(11,3) DEFAULT NULL,
  `ekodemen3` decimal(11,3) DEFAULT NULL,
  `ekodemen4` decimal(11,3) DEFAULT NULL,
  `ekodemen5` decimal(11,3) DEFAULT NULL,
  `ekodemen6` decimal(11,3) DEFAULT NULL,
  `ekodemen7` decimal(11,3) DEFAULT NULL,
  `ekodemen8` decimal(11,3) DEFAULT NULL,
  `ekodemen9` decimal(11,3) DEFAULT NULL,
  `ekodemen10` decimal(11,3) DEFAULT NULL,
  `ekodemen11` decimal(11,3) DEFAULT NULL,
  `ekodemen12` decimal(11,3) DEFAULT NULL,
  `ekodemen13` decimal(11,3) DEFAULT NULL,
  `ekodemen14` decimal(11,3) DEFAULT NULL,
  `ekodemen15` decimal(11,3) DEFAULT NULL,
  `ekodemen16` decimal(11,3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Index 2` (`personelid`,`yil`,`ay`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkucretbordrosu
-- 

-- 
-- Table structure for table sgkyasalparametreler
-- 

DROP TABLE IF EXISTS sgkyasalparametreler;
CREATE TABLE `sgkyasalparametreler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yil` int(11) DEFAULT NULL,
  `donem` smallint(6) DEFAULT NULL COMMENT 'asgariucretbruttutar',
  `asgariucret` decimal(11,3) DEFAULT '0.000' COMMENT '1.donem',
  `sgktabanmatrahi` decimal(11,3) DEFAULT '0.000' COMMENT '1.donem',
  `sgktavanmatrahi` decimal(11,3) DEFAULT '0.000' COMMENT '1.donem',
  `damgavergisiorani` decimal(11,3) DEFAULT '0.000',
  `aylikbildirgedamgavergisitutari` decimal(11,3) DEFAULT '0.000',
  `kidemtazminatitavani` decimal(11,3) DEFAULT '0.000',
  `yemekmuafiyetisgk` decimal(11,3) DEFAULT '0.000',
  `yemekmuafiyetigv` decimal(11,3) DEFAULT '0.000',
  `cocukmuafiyetisgk` decimal(11,3) DEFAULT '0.000',
  `cocukmuafiyetigv` decimal(11,3) DEFAULT '0.000',
  `ailemuafiyetisgk` decimal(11,3) DEFAULT '0.000',
  `sakatlikindirimi1` decimal(11,3) DEFAULT '0.000',
  `sakatlikindirimi2` decimal(11,3) DEFAULT '0.000',
  `sakatlikindirimi3` decimal(11,3) DEFAULT '0.000',
  `agibruttutar` decimal(11,3) DEFAULT '0.000',
  `agibruttutarustsinir` decimal(11,3) DEFAULT '0.000',
  `agioranKendisi` decimal(11,3) DEFAULT '0.000',
  `agioranEsi` decimal(11,3) DEFAULT '0.000',
  `agioran1cocuk` decimal(11,3) DEFAULT '0.000',
  `agioran2cocuk` decimal(11,3) DEFAULT '0.000',
  `agioranDiger` decimal(11,3) DEFAULT '0.000',
  `ogrenci19alti` decimal(11,3) DEFAULT '0.000',
  `ogrenci20ustu` decimal(11,3) DEFAULT '0.000',
  `cirak16yasalti` decimal(11,3) DEFAULT '0.000',
  `cirak16yasustu` decimal(11,3) DEFAULT '0.000',
  `agioran3cocuk` decimal(11,3) DEFAULT '0.000',
  `agioran4cocuk` decimal(11,3) DEFAULT '0.000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sgkyasalparametreler
-- 

LOCK TABLES sgkyasalparametreler WRITE;
INSERT INTO sgkyasalparametreler VALUES
 (1,2015,1,1201.500,1201.500,7809.900,7.590,22.300,3541.370,0.000,13.000,24.030,0.000,120.150,880.000,440.000,200.000,1201.500,153.190,50.000,10.000,7.500,7.500,5.000,0.000,0.000,0.000,0.000,10.000,5.000),
 (2,2015,2,1273.500,1273.500,8277.900,7.590,22.300,3541.370,0.000,13.000,25.470,0.000,127.350,880.000,440.000,200.000,1201.500,153.190,50.000,10.000,7.500,7.500,5.000,0.000,0.000,0.000,0.000,10.000,5.000);
UNLOCK TABLES;

-- 
-- Table structure for table smsayarlari
-- 

DROP TABLE IF EXISTS smsayarlari;
CREATE TABLE `smsayarlari` (
  `kullanici` varchar(20) DEFAULT NULL,
  `sifre` varchar(20) DEFAULT NULL,
  `clientkodu` varchar(20) DEFAULT NULL,
  `gateway` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table smsayarlari
-- 

-- 
-- Table structure for table smsliste
-- 

DROP TABLE IF EXISTS smsliste;
CREATE TABLE `smsliste` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `kartno` varchar(10) DEFAULT NULL,
  `isim` varchar(160) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `durum` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table smsliste
-- 

-- 
-- Table structure for table smsmesajlar
-- 

DROP TABLE IF EXISTS smsmesajlar;
CREATE TABLE `smsmesajlar` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `mesaj` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table smsmesajlar
-- 

-- 
-- Table structure for table sube
-- 

DROP TABLE IF EXISTS sube;
CREATE TABLE `sube` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  `adres` varchar(300) DEFAULT NULL,
  `sicilno` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table sube
-- 

-- 
-- Table structure for table takim
-- 

DROP TABLE IF EXISTS takim;
CREATE TABLE `takim` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table takim
-- 

-- 
-- Table structure for table temponline
-- 

DROP TABLE IF EXISTS temponline;
CREATE TABLE `temponline` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `kartno` varchar(10) DEFAULT NULL,
  `isim` varchar(160) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  `kapiterminalkod` varchar(10) DEFAULT NULL,
  `kapiterminalad` varchar(200) DEFAULT NULL,
  `girisyetkiliid` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table temponline
-- 

-- 
-- Table structure for table temp_uye_giris
-- 

DROP TABLE IF EXISTS temp_uye_giris;
CREATE TABLE `temp_uye_giris` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) DEFAULT NULL,
  `kartno` varchar(5) DEFAULT NULL,
  `isim` varchar(100) DEFAULT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `kapino` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table temp_uye_giris
-- 

-- 
-- Table structure for table temp_yillikizin
-- 

DROP TABLE IF EXISTS temp_yillikizin;
CREATE TABLE `temp_yillikizin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `isim` varchar(60) DEFAULT NULL,
  `isegiristarihi` date DEFAULT NULL,
  `toplamizinhakki` varchar(5) DEFAULT NULL,
  `ocak` varchar(5) DEFAULT NULL,
  `subat` varchar(5) DEFAULT NULL,
  `mart` varchar(5) DEFAULT NULL,
  `nisan` varchar(5) DEFAULT NULL,
  `mayis` varchar(5) DEFAULT NULL,
  `haziran` varchar(5) DEFAULT NULL,
  `temmuz` varchar(5) DEFAULT NULL,
  `agustos` varchar(5) DEFAULT NULL,
  `eylul` varchar(5) DEFAULT NULL,
  `ekim` varchar(5) DEFAULT NULL,
  `kasim` varchar(5) DEFAULT NULL,
  `aralik` varchar(5) DEFAULT NULL,
  `toplamkullanilan` varchar(5) DEFAULT NULL,
  `toplamkalan` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table temp_yillikizin
-- 

-- 
-- Table structure for table terminal
-- 

DROP TABLE IF EXISTS terminal;
CREATE TABLE `terminal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `tolerans` int(11) DEFAULT NULL,
  `tip` varchar(6) DEFAULT NULL,
  `programpath` longtext,
  `aktarimpath` longtext,
  `kartnobas` varchar(3) DEFAULT NULL,
  `kartnohane` varchar(3) DEFAULT NULL,
  `yilbas` varchar(3) DEFAULT NULL,
  `yilhane` varchar(3) DEFAULT NULL,
  `aybas` varchar(3) DEFAULT NULL,
  `ayhane` varchar(3) DEFAULT NULL,
  `gunbas` varchar(3) DEFAULT NULL,
  `gunhane` varchar(3) DEFAULT NULL,
  `saatbas` varchar(3) DEFAULT NULL,
  `saathane` varchar(3) DEFAULT NULL,
  `dakikabas` varchar(3) DEFAULT NULL,
  `dakikahane` varchar(3) DEFAULT NULL,
  `saniyebas` varchar(3) DEFAULT NULL,
  `saniyehane` varchar(3) DEFAULT NULL,
  `tusbas` varchar(3) DEFAULT NULL,
  `tushane` varchar(3) DEFAULT NULL,
  `hesaplamatipi` varchar(6) DEFAULT NULL,
  `wcyenikayittolerans` varchar(6) DEFAULT NULL,
  `grupkodubas` varchar(3) DEFAULT NULL,
  `grupkoduhane` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table terminal
-- 

LOCK TABLES terminal WRITE;
INSERT INTO terminal VALUES
 (1,'1-T5',5,'normal','D:\\WinTime PDKS\\AZPERTRANSFER\\azpertransfer.exe','D:\\WinTime PDKS\\AZPERTRANSFER\\veripdks.txt','1','5','13','4','10','2','7','2','18','2','21','2',NULL,NULL,NULL,NULL,'pdks',NULL,NULL,NULL),
 (2,'2-parite',5,'normal','C:\\Program Files\\PARITE\\PT601E\\TERMETH.exe','C:\\PARITE\\PT601E\\datalar.txt','33','4','19','4','16','2','13','2','25','2','28','2',NULL,NULL,NULL,NULL,'pdks',NULL,NULL,NULL),
 (6,'tr8600e kart',NULL,'normal','C:\\MYSQL PR\\giriscikis\\Personel Giriş-Çıkış\\TR8600E\\TR8600E.exe','C:\\MYSQL PR\\giriscikis\\Personel Giriş-Çıkış\\TR8600E\\veri.txt','01','5','13','4','10','2','7','2','18','2','21','2',NULL,NULL,NULL,NULL,'gc',NULL,NULL,NULL),
 (7,'1',NULL,'normal','D:\\WinTime PDKS\\AZPERTRANSFER\\azpertransfer.exe','D:\\WinTime PDKS\\AZPERTRANSFER\\veriwc.txt',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ymk',NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table terminaller
-- 

DROP TABLE IF EXISTS terminaller;
CREATE TABLE `terminaller` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `Source` varchar(20) DEFAULT NULL,
  `Baudrate_Remote_Port` int(11) DEFAULT NULL,
  `Device_Num` int(11) DEFAULT NULL,
  `CommPassword` varchar(10) DEFAULT NULL,
  `modultipi` varchar(6) DEFAULT NULL,
  `cihaztipi` varchar(15) DEFAULT NULL,
  `aktarimtipi` varchar(5) DEFAULT NULL,
  `serino` varchar(20) DEFAULT NULL,
  `kod` varchar(2) DEFAULT NULL,
  `tip` varchar(10) DEFAULT NULL,
  `secim` tinyint(1) DEFAULT '1',
  `anamakina` tinyint(1) DEFAULT '0' COMMENT 'prmk aktarimi icin',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table terminaller
-- 

LOCK TABLES terminaller WRITE;
INSERT INTO terminaller VALUES
 (1,'term1','192.168.0.46',4370,1,'0','pdks','MagicPass','genel',NULL,NULL,NULL,1,1),
 (2,'anagiriş1 giriş','192.168.0.100',9747,NULL,NULL,'uye',NULL,'giris',NULL,'1',NULL,1,0),
 (3,'anagiriş1 çıkış','192.168.0.101',9747,NULL,NULL,'uye',NULL,'cikis',NULL,'1',NULL,1,0),
 (4,'havuz giriş','192.168.0.105',9747,NULL,NULL,'uye',NULL,'giris',NULL,'1',NULL,1,0),
 (5,'havuz çıkış',NULL,9747,NULL,NULL,'uye',NULL,'cikis',NULL,'2',NULL,1,0);
UNLOCK TABLES;

-- 
-- Table structure for table terminalotosaat
-- 

DROP TABLE IF EXISTS terminalotosaat;
CREATE TABLE `terminalotosaat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `saat` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table terminalotosaat
-- 

-- 
-- Table structure for table terminalparmaksaat
-- 

DROP TABLE IF EXISTS terminalparmaksaat;
CREATE TABLE `terminalparmaksaat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `saat` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table terminalparmaksaat
-- 

-- 
-- Table structure for table terminalpuantajsaat
-- 

DROP TABLE IF EXISTS terminalpuantajsaat;
CREATE TABLE `terminalpuantajsaat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `saat` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table terminalpuantajsaat
-- 

-- 
-- Table structure for table terminaltuslu
-- 

DROP TABLE IF EXISTS terminaltuslu;
CREATE TABLE `terminaltuslu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `terminalid` int(11) NOT NULL,
  `tus` varchar(10) DEFAULT NULL,
  `tustipi` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `terminalid` (`terminalid`),
  CONSTRAINT `terminaltuslu_fk` FOREIGN KEY (`terminalid`) REFERENCES `terminal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table terminaltuslu
-- 

LOCK TABLES terminaltuslu WRITE;
INSERT INTO terminaltuslu VALUES
 (1,1,'01','giris');
UNLOCK TABLES;

-- 
-- Table structure for table textaktarim
-- 

DROP TABLE IF EXISTS textaktarim;
CREATE TABLE `textaktarim` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `programtipi` varchar(10) DEFAULT NULL,
  `pertipi` varchar(10) DEFAULT NULL,
  `saattipi` varchar(10) DEFAULT NULL,
  `textdosya` longtext,
  `varsayilan` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table textaktarim
-- 

LOCK TABLES textaktarim WRITE;
INSERT INTO textaktarim VALUES
 (1,'link','sicilno','saat',NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table textaktarimalt
-- 

DROP TABLE IF EXISTS textaktarimalt;
CREATE TABLE `textaktarimalt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `textaktarimid` int(11) DEFAULT NULL,
  `bordrokod` smallint(6) DEFAULT NULL,
  `bordroad` varchar(20) DEFAULT NULL,
  `bordrotip` varchar(10) DEFAULT NULL,
  `gun` varchar(5) DEFAULT NULL,
  `saat` varchar(5) DEFAULT NULL,
  `ucret` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table textaktarimalt
-- 

LOCK TABLES textaktarimalt WRITE;
INSERT INTO textaktarimalt VALUES
 (1,1,1,'N.Ç','calisma',NULL,NULL,NULL),
 (2,1,2,'%50','calisma',NULL,NULL,NULL),
 (3,1,3,'%100','calisma',NULL,NULL,NULL),
 (4,1,5,'R.T','calisma',NULL,NULL,NULL),
 (5,1,1,'YIL','izin',NULL,NULL,NULL),
 (6,1,2,'HST','izin',NULL,NULL,NULL),
 (7,1,3,'ÜSZ','izin',NULL,NULL,NULL),
 (8,1,4,'ÖZL','izin',NULL,NULL,NULL),
 (9,1,1,'Avans','extra',NULL,NULL,NULL),
 (10,1,2,'Prim','extra',NULL,NULL,NULL),
 (11,1,3,'Banka','extra',NULL,NULL,NULL),
 (12,1,0,'devamsizlik','sabit',NULL,NULL,NULL),
 (13,1,0,'geckalma','sabit',NULL,NULL,NULL),
 (14,1,0,'erkencikma','sabit',NULL,NULL,NULL),
 (15,1,0,'eksiksure','sabit',NULL,NULL,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table uye_bolum
-- 

DROP TABLE IF EXISTS uye_bolum;
CREATE TABLE `uye_bolum` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_bolum
-- 

LOCK TABLES uye_bolum WRITE;
INSERT INTO uye_bolum VALUES
 (1,'bolum1'),
 (2,'bolum2');
UNLOCK TABLES;

-- 
-- Table structure for table uye_dondurma
-- 

DROP TABLE IF EXISTS uye_dondurma;
CREATE TABLE `uye_dondurma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `baslamatarihi` date DEFAULT NULL,
  `bitistarihi` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_dondurma
-- 

-- 
-- Table structure for table uye_giriscikis
-- 

DROP TABLE IF EXISTS uye_giriscikis;
CREATE TABLE `uye_giriscikis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `toplamsure` varchar(15) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `izintipi` varchar(10) DEFAULT NULL,
  `izinturid` int(11) DEFAULT NULL,
  `izinsure` varchar(6) DEFAULT NULL,
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  `aciklama` varchar(250) DEFAULT NULL,
  `geciptal` tinyint(1) DEFAULT '0',
  `erkiptal` tinyint(1) DEFAULT '0',
  `eksiptal` tinyint(1) DEFAULT '0',
  `surefarki` varchar(6) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`giristarihi`,`girissaati`,`cikistarihi`,`cikissaati`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_giriscikis
-- 

-- 
-- Table structure for table uye_grup
-- 

DROP TABLE IF EXISTS uye_grup;
CREATE TABLE `uye_grup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_grup
-- 

-- 
-- Table structure for table uye_iliskilendirme
-- 

DROP TABLE IF EXISTS uye_iliskilendirme;
CREATE TABLE `uye_iliskilendirme` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `personelid1` bigint(20) NOT NULL,
  `isim` varchar(200) DEFAULT NULL,
  `yakinlikderecesi` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_iliskilendirme
-- 

LOCK TABLES uye_iliskilendirme WRITE;
INSERT INTO uye_iliskilendirme VALUES
 (1,3,3,NULL,'aa');
UNLOCK TABLES;

-- 
-- Table structure for table uye_odeme
-- 

DROP TABLE IF EXISTS uye_odeme;
CREATE TABLE `uye_odeme` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  `aciklama` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_odeme
-- 

-- 
-- Table structure for table uye_taksit
-- 

DROP TABLE IF EXISTS uye_taksit;
CREATE TABLE `uye_taksit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  `aciklama` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_taksit
-- 

-- 
-- Table structure for table uye_terminal
-- 

DROP TABLE IF EXISTS uye_terminal;
CREATE TABLE `uye_terminal` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `Source` varchar(20) DEFAULT NULL,
  `Baudrate_Remote_Port` int(11) DEFAULT NULL,
  `Device_Num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_terminal
-- 

LOCK TABLES uye_terminal WRITE;
INSERT INTO uye_terminal VALUES
 (1,'giriş','COM9',115200,1),
 (2,'çıkış','COM9',115200,2);
UNLOCK TABLES;

-- 
-- Table structure for table uye_tipi
-- 

DROP TABLE IF EXISTS uye_tipi;
CREATE TABLE `uye_tipi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_tipi
-- 

LOCK TABLES uye_tipi WRITE;
INSERT INTO uye_tipi VALUES
 (1,'SINIRSIZ'),
 (2,'HAFTAİÇİ 08:00-17:00 SALI,CUMA'),
 (3,'HAFTASONU 16:00-23:00');
UNLOCK TABLES;

-- 
-- Table structure for table uye_tipialt
-- 

DROP TABLE IF EXISTS uye_tipialt;
CREATE TABLE `uye_tipialt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uyetipiid` int(11) NOT NULL,
  `baslamasaati` varchar(5) DEFAULT NULL,
  `bitissaati` varchar(5) DEFAULT NULL,
  `pzt` tinyint(1) DEFAULT '0',
  `sal` tinyint(1) DEFAULT '0',
  `car` tinyint(1) DEFAULT '0',
  `per` tinyint(1) DEFAULT '0',
  `cum` tinyint(1) DEFAULT '0',
  `cmt` tinyint(1) DEFAULT '0',
  `paz` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tipid` (`uyetipiid`),
  CONSTRAINT `uye_tipialt_fk` FOREIGN KEY (`uyetipiid`) REFERENCES `uye_tipi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table uye_tipialt
-- 

LOCK TABLES uye_tipialt WRITE;
INSERT INTO uye_tipialt VALUES
 (1,1,'00:01','23:59',1,1,1,1,1,1,1),
 (2,2,'08:00','17:00',0,1,0,0,1,0,0),
 (3,3,'16:00','23:00',0,0,0,0,0,1,1);
UNLOCK TABLES;

-- 
-- Table structure for table wciptalsaatleri
-- 

DROP TABLE IF EXISTS wciptalsaatleri;
CREATE TABLE `wciptalsaatleri` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `baslamasaati` time DEFAULT NULL,
  `bitissaati` time DEFAULT NULL,
  `secim` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wciptalsaatleri
-- 

-- 
-- Table structure for table wc_ayarlar
-- 

DROP TABLE IF EXISTS wc_ayarlar;
CREATE TABLE `wc_ayarlar` (
  `grupid` int(11) NOT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  `toleranstipi` varchar(10) DEFAULT NULL,
  `tutartipi` varchar(10) DEFAULT NULL,
  `gunluksure` varchar(6) DEFAULT NULL,
  `gunlukgecis` int(11) DEFAULT NULL,
  `sabittutar` decimal(11,2) DEFAULT NULL,
  `ayliksure` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_ayarlar
-- 

-- 
-- Table structure for table wc_giriscikis
-- 

DROP TABLE IF EXISTS wc_giriscikis;
CREATE TABLE `wc_giriscikis` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT NULL,
  `kapiterminalkod` varchar(10) DEFAULT NULL,
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_giriscikis
-- 

-- 
-- Table structure for table wc_mola
-- 

DROP TABLE IF EXISTS wc_mola;
CREATE TABLE `wc_mola` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `baslamasaati` varchar(5) DEFAULT NULL,
  `bitissaati` varchar(5) DEFAULT NULL,
  `g1` tinyint(1) DEFAULT '1',
  `g2` tinyint(1) DEFAULT '1',
  `g3` tinyint(1) DEFAULT '1',
  `g4` tinyint(1) DEFAULT '1',
  `g5` tinyint(1) DEFAULT '1',
  `g6` tinyint(1) DEFAULT '1',
  `g7` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_mola
-- 

-- 
-- Table structure for table wc_molabolum
-- 

DROP TABLE IF EXISTS wc_molabolum;
CREATE TABLE `wc_molabolum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `molaid` int(11) DEFAULT NULL,
  `bolumid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_molabolum
-- 

-- 
-- Table structure for table wc_molaparametre
-- 

DROP TABLE IF EXISTS wc_molaparametre;
CREATE TABLE `wc_molaparametre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grupid` int(11) NOT NULL,
  `altgrupid` int(11) DEFAULT NULL,
  `ad` varchar(100) DEFAULT NULL,
  `baslamasaati` varchar(5) DEFAULT NULL,
  `bitissaati` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_molaparametre
-- 

-- 
-- Table structure for table wc_puantaj
-- 

DROP TABLE IF EXISTS wc_puantaj;
CREATE TABLE `wc_puantaj` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `kullanilansaat` varchar(6) DEFAULT NULL,
  `kesintisaat` varchar(6) DEFAULT NULL,
  `kesintitutar` decimal(11,2) DEFAULT NULL,
  `ikesintisaat` decimal(11,2) DEFAULT NULL,
  `ikullanilansaat` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_puantaj
-- 

-- 
-- Table structure for table wc_puantajtoplam
-- 

DROP TABLE IF EXISTS wc_puantajtoplam;
CREATE TABLE `wc_puantajtoplam` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `tarih` date DEFAULT NULL,
  `kullanilansaat` varchar(6) DEFAULT NULL,
  `kesintisaat` varchar(6) DEFAULT NULL,
  `kesintitutar` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table wc_puantajtoplam
-- 

-- 
-- Table structure for table yetki
-- 

DROP TABLE IF EXISTS yetki;
CREATE TABLE `yetki` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(200) DEFAULT NULL,
  `gunlukgecis` int(11) DEFAULT NULL,
  `kod` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table yetki
-- 

LOCK TABLES yetki WRITE;
INSERT INTO yetki VALUES
 (1,'GÜNLÜK 5 (SAAT ARALIĞI)',NULL,NULL),
 (2,'GÜNLÜK5',5,NULL),
 (3,'GÜNLÜK 1',1,NULL),
 (4,'SINIRSIZ',0,NULL);
UNLOCK TABLES;

-- 
-- Table structure for table yetki_saatleri
-- 

DROP TABLE IF EXISTS yetki_saatleri;
CREATE TABLE `yetki_saatleri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yetkiid` int(11) NOT NULL,
  `baslamasaati` time DEFAULT NULL,
  `bitissaati` time DEFAULT NULL,
  `gunlukgecis` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table yetki_saatleri
-- 

LOCK TABLES yetki_saatleri WRITE;
INSERT INTO yetki_saatleri VALUES
 (1,1,'08:00:00','10:30:00',2),
 (2,1,'11:00:00','15:00:00',1),
 (3,1,'19:00:00','22:00:00',2);
UNLOCK TABLES;

-- 
-- Table structure for table yillikizineklenen
-- 

DROP TABLE IF EXISTS yillikizineklenen;
CREATE TABLE `yillikizineklenen` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) DEFAULT NULL,
  `izinturid` int(11) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `eklenen` int(11) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table yillikizineklenen
-- 

-- 
-- Table structure for table yillikizinkalan
-- 

DROP TABLE IF EXISTS yillikizinkalan;
CREATE TABLE `yillikizinkalan` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) DEFAULT NULL,
  `yil` int(11) DEFAULT NULL,
  `kalan` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table yillikizinkalan
-- 

-- 
-- Table structure for table yillikizinsureleri
-- 

DROP TABLE IF EXISTS yillikizinsureleri;
CREATE TABLE `yillikizinsureleri` (
  `yilbas` int(11) DEFAULT NULL,
  `yilbit` int(11) DEFAULT NULL,
  `hak` int(11) DEFAULT NULL,
  `aciklama` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table yillikizinsureleri
-- 

LOCK TABLES yillikizinsureleri WRITE;
INSERT INTO yillikizinsureleri VALUES
 (1,5,14,'1-5 YIL ARASI CALISANLAR'),
 (6,14,20,'6-14 YIL ARASI CALISANLAR'),
 (15,30,26,'15-30 YIL ARASI CALISANLAR');
UNLOCK TABLES;

-- 
-- Table structure for table ymk_giris
-- 

DROP TABLE IF EXISTS ymk_giris;
CREATE TABLE `ymk_giris` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) DEFAULT NULL,
  `isim` varchar(100) DEFAULT NULL,
  `tarih` date DEFAULT NULL,
  `saat` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`personelid`,`tarih`,`saat`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table ymk_giris
-- 

LOCK TABLES ymk_giris WRITE;
INSERT INTO ymk_giris VALUES
 (22,1,NULL,'2011-10-05','16:08:41'),
 (23,5,NULL,'2011-10-05','16:08:49'),
 (24,7,NULL,'2012-04-12','09:17:45'),
 (25,7,NULL,'2012-04-12','09:17:47'),
 (26,7,NULL,'2012-04-12','09:17:49'),
 (27,7,NULL,'2012-04-12','09:17:51'),
 (28,7,NULL,'2012-04-12','09:17:53'),
 (29,7,NULL,'2012-04-12','09:17:55'),
 (30,7,NULL,'2012-04-12','09:17:57'),
 (31,3,NULL,'2012-04-12','09:18:01'),
 (32,3,NULL,'2012-04-12','09:18:03');
UNLOCK TABLES;

-- 
-- Table structure for table ymk_giriscikis
-- 

DROP TABLE IF EXISTS ymk_giriscikis;
CREATE TABLE `ymk_giriscikis` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personelid` bigint(20) NOT NULL,
  `giristarihi` date DEFAULT NULL,
  `girissaati` time DEFAULT NULL,
  `cikistarihi` date DEFAULT NULL,
  `cikissaati` time DEFAULT NULL,
  `surefarki` varchar(6) DEFAULT NULL,
  `ellegiris` varchar(1) DEFAULT NULL,
  `ellecikis` varchar(1) DEFAULT NULL,
  `aciklama` varchar(60) DEFAULT NULL,
  `islemturu` varchar(2) DEFAULT NULL,
  `kapiterminalkod` varchar(10) DEFAULT NULL,
  `isurefarki` int(11) DEFAULT '0',
  `giristerminal` varchar(60) DEFAULT NULL,
  `cikisterminal` varchar(60) DEFAULT NULL,
  `giristerminalno` varchar(5) DEFAULT NULL,
  `cikisterminalno` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table ymk_giriscikis
-- 

-- 
-- Table structure for table ymk_ogun
-- 

DROP TABLE IF EXISTS ymk_ogun;
CREATE TABLE `ymk_ogun` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  `baslamasaati` time DEFAULT NULL,
  `bitissaati` time DEFAULT NULL,
  `tutar` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personelid` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table ymk_ogun
-- 

-- 
-- Table structure for table zamanbolge
-- 

DROP TABLE IF EXISTS zamanbolge;
CREATE TABLE `zamanbolge` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zamanbolge
-- 

LOCK TABLES zamanbolge WRITE;
INSERT INTO zamanbolge VALUES
 (1,'zaman bölge 1'),
 (2,'zaman bölge 2');
UNLOCK TABLES;

-- 
-- Table structure for table zamanbolgealt
-- 

DROP TABLE IF EXISTS zamanbolgealt;
CREATE TABLE `zamanbolgealt` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zamanbolgeid` bigint(20) unsigned NOT NULL,
  `g1` int(11) DEFAULT NULL,
  `g2` int(11) DEFAULT NULL,
  `g3` int(11) DEFAULT NULL,
  `g4` int(11) DEFAULT NULL,
  `g5` int(11) DEFAULT NULL,
  `g6` int(11) DEFAULT NULL,
  `g7` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zamanbolgealt
-- 

LOCK TABLES zamanbolgealt WRITE;
INSERT INTO zamanbolgealt VALUES
 (1,1,1,1,1,1,1,1,1);
UNLOCK TABLES;

-- 
-- Table structure for table zamankod
-- 

DROP TABLE IF EXISTS zamankod;
CREATE TABLE `zamankod` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zamankod
-- 

LOCK TABLES zamankod WRITE;
INSERT INTO zamankod VALUES
 (1,'zaman kod1');
UNLOCK TABLES;

-- 
-- Table structure for table zamankodalt
-- 

DROP TABLE IF EXISTS zamankodalt;
CREATE TABLE `zamankodalt` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zamankodid` bigint(20) unsigned NOT NULL,
  `saat1` varchar(5) DEFAULT NULL,
  `saat2` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zamankodalt
-- 

LOCK TABLES zamankodalt WRITE;
INSERT INTO zamankodalt VALUES
 (1,1,'09:00','20:00');
UNLOCK TABLES;

-- 
-- Table structure for table zimmetbolum
-- 

DROP TABLE IF EXISTS zimmetbolum;
CREATE TABLE `zimmetbolum` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zimmetbolum
-- 

-- 
-- Table structure for table zimmetkategori
-- 

DROP TABLE IF EXISTS zimmetkategori;
CREATE TABLE `zimmetkategori` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kod` varchar(10) DEFAULT NULL,
  `ad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;

-- 
-- Dumping data for table zimmetkategori
-- 

-- 
-- Table structure for table view_personelisim
-- 

DROP VIEW IF EXISTS view_personelisim;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `view_personelisim` AS select `personel`.`id` AS `id`,concat(`personel`.`ad`,' ',`personel`.`soyad`) AS `isim` from `personel` order by `personel`.`ad`;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 */;
