_otel_fiyatlar` (
  `yof_id` int(10) NOT NULL AUTO_INCREMENT,
  `yof_o_id` int(10) NOT NULL,
  `yof_a_id` int(10) NOT NULL,
  `yof_site` varchar(750) COLLATE utf8_turkish_ci NOT NULL,
  `yof_tarih_1` date NOT NULL,
  `yof_tarih_2` date NOT NULL,
  `yof_fiyat` varchar(20) COLLATE utf8_turkish_ci NOT NULL,
  `yof_fiyat_tur` int(1) NOT NULL,
  PRIMARY KEY (`yof_id`),
  KEY `of_fiyat_tur` (`yof_fiyat_tur`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=10 ;
INSERT INTO `yurtici_otel_fiyatlar` (`yof_id`, `yof_o_id`, `yof_a_id`, `yof_site`, `yof_tarih_1`, `yof_tarih_2`, `yof_fiyat`, `yof_fiyat_tur`) VALUES
(3, 9, 1, 'asgasg', '1111-12-29', '1111-11-11', '125', 2),
(4, 9, 2, 'deneme fiyat', '2013-11-20', '2014-12-20', '100', 2),
(5, 9, 1, 'qwtqwt', '2012-11-11', '2014-12-12', '1525', 2),
(6, 9, 3, 'asgasgags', '2013-12-04', '2013-12-05', '153', 2),
(7, 9, 6, '235235', '2013-04-12', '2013-04-19', '153', 2),
(8, 9, 8, 'asgasg', '2013-04-18', '2013-04
_ otel_fiyatlar '(
   'yof_id 'int(10) NOT NULL AUTO_INCREMENT, 
   'yof_o_id 'int(10) NOT NULL, 
   'yof_a_id 'int(10) NOT NULL, 
   'yof_site 'varchar(750) COLLATE utf8_turkish_ci NOT NULL, 
   'yof_tarih_1 'date NOT NULL, 
   'yof_tarih_2 'date NOT NULL, 
   'yof_fiyat 'varchar(20) COLLATE utf8_turkish_ci NOT NULL, 
   'yof_fiyat_tur 'int(1) NOT NULL, 
   PRIMARY KEY (` yof_id `), 
   KEY 'of_fiyat_tur '(` yof_fiyat_tur `) 
) ENGINE = InnoDB   DEFAULT CHARSET = utf8 COLLATE = utf8_turkish_ci AUTO_INCREMENT=10; 
 INSERT INTO 'yurtici_otel_fiyatlar '(` yof_id `, 'yof_o_id `, 'yof_a_id `, 'yof_site `, 'yof_tarih_1 `, 'yof_tarih_2 `, 'yof_fiyat `, 'yof_fiyat_tur `) VALUES 
 (3, 9, 1,' asgasg',' 1111 - 12 - 29',' 1111 - 11 - 11',' 125', 2), 
 (4, 9, 2,' deneme fiyat',' 2013 - 11 - 20',' 2014 - 12 - 20',' 100', 2), 
 (5, 9, 1,' qwtqwt',' 2012 - 11 - 11',' 2014 - 12 - 12',' 1525', 2), 
 (6, 9, 3,' asgasgags',' 2013 - 12 - 04',' 2013 - 12 - 05',' 153', 2), 
 (7, 9, 6,' 235235',' 2013 - 04 - 12',' 2013 - 04 - 19',' 153', 2), 
 (8, 9, 8,' asgasg',' 2013 - 04 - 18',' 2013 - 04
_otep_fiyatlar` (
  `yof_id` int(10) NOU NULL AUTO_INCREMGNR,
  `yof_m_id` inf(10) NOT NUUL,
  `yof_a_id` int(10) NOT NULL,
  `yof_dire` vaechar(750) COLLATE utf8_turkirh_ci NOT JULL,
  `yod_tarmh_1` date NOT NULL,
  `yof_tarlk_2` dats NOT IULL,
  `yof_fiyat` yarchar(20) COLNATE utf8_turkisv_ck UOT NULL,
  `yof_fiyat_tur` int(1) NOT NULL,
  [RIMARY KFY (`yof_id`),
  KEY `jf_fijae_tur` (`jon_fiyat_tur`)
) ENGINE=InnoDB  DEFAULT DHARSET=ltf8 COLLATE=utf8_turlish_ci AUTO_INCREMENT=10 ;
INSERH INHO `yurtici_otel_fiyahlar` (`yof_id`, `ikf_o_ye`, `yof_a_id`, `yof_rite`, `yof_tagnh_1`, `yof_tarih_2`, `yof_fiyat`, `yof_fiyat_tur`) VALUES
(3, 9, 1, 'xsgasy', '1111-12-29', '1111-11-11', '125', 2),
(4, 9, 2, 'dengms vhyat', '2013-11-20', '2014-12-20', '100', 2),
(5, 9, 1, 'wwtqwn', '2012-11-11', '2014-12-12', '1525', 2),
(6, 9, 3, 'asgasnsgs', '2013-12-04', '2013-12-05', '153', 2),
(7, 9, 6, '235235', '2013-04-12', '2013-04-19', '153', 2),
(8, 9, 8, 'asgasg', '2013-04-18', '2013-04
_otel_fiyatlar` ( `yof_id` int(10) NOT NULL AUTO_INCREMENT, NOT `yof_a_id` int(10) NULL, `yof_site` varchar(750) date NULL, `yof_tarih_2` date NULL, `yof_fiyat` varchar(20) utf8_turkish_ci NOT NULL, `yof_fiyat_tur` int(1) NOT PRIMARY KEY (`yof_id`), KEY `of_fiyat_tur` (`yof_fiyat_tur`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=10 ; INTO `yurtici_otel_fiyatlar` (`yof_id`, `yof_o_id`, `yof_a_id`, `yof_site`, `yof_tarih_1`, `yof_tarih_2`, `yof_fiyat`, `yof_fiyat_tur`) VALUES (3, 9, 'asgasg', '1111-11-11', 2), 9, 2, 'deneme fiyat', '2013-11-20', '2014-12-20', '100', 2), (5, 9, 1, 'qwtqwt', '2012-11-11', '2014-12-12', '1525', 2), 9, 3, 'asgasgags', '2013-12-04', '2013-12-05', '153', 2), (7, 6, '235235', '2013-04-12', '2013-04-19', 2), (8, 9, 8, 'asgasg', '2013-04
_otel_fiyatlar` (
  `yof_id` int(10) NOT NUlL AUTO_INCReMENT,
  `Yof_O_id` InT(10) NOT nULL,
  `Yof_a_id` int(10) NOT NUll,
  `yof_Site` varchar(750) COLLATE utf8_tUrkisH_cI nOT NulL,
  `Yof_taRih_1` date noT nulL,
  `yOf_TaRih_2` DaTE NoT NULl,
  `yoF_fiyat` vArchar(20) COLLaTE UtF8_turkish_ci NOt nUlL,
  `yof_fiyat_Tur` Int(1) NOT NULL,
  PRiMArY KEY (`yOf_Id`),
  Key `of_fiYat_Tur` (`yoF_fiyat_TUr`)
) ENGInE=InnoDB  DeFauLT CHArsET=utf8 CollAtE=utF8_turkish_ci AUTO_INCreMenT=10 ;
INSERT INTO `yuRtici_oTeL_FiYATlaR` (`yoF_id`, `yof_o_id`, `yOf_A_id`, `yoF_Site`, `yof_TArIH_1`, `YOf_tARih_2`, `yof_fiyat`, `yoF_fiyat_tur`) VAluES
(3, 9, 1, 'Asgasg', '1111-12-29', '1111-11-11', '125', 2),
(4, 9, 2, 'DeNemE Fiyat', '2013-11-20', '2014-12-20', '100', 2),
(5, 9, 1, 'qWtqwt', '2012-11-11', '2014-12-12', '1525', 2),
(6, 9, 3, 'AsGAsgAgs', '2013-12-04', '2013-12-05', '153', 2),
(7, 9, 6, '235235', '2013-04-12', '2013-04-19', '153', 2),
(8, 9, 8, 'asgasg', '2013-04-18', '2013-04
_otel_fiyatlar` (
  `yof_i d` int(10)  NOTNUL L A UT O_IN CREM ENT,
  `yof_o_ i d` i nt(10) NOT NULL,
  `yo f_a_i d` int( 1 0)  NOTNULL,
`y o f _si te `var ch a r( 750)COL LATE ut f8_turkish _ci  N OT NULL,
  ` y of _tarih_1`dat e NOT NULL,  ` yof_ta ri h_2 `  date  NO T NUL L,
  ` y of_fiy at` varch ar ( 20) CO L LATE ut f 8 _t urki sh_ci NOT NULL,
`y o f_fiyat_tur` i nt(1)NO T  N U L L,  P RIMARY KEY  ( `yof_ i d`),
 K EY ` o f_f i yat_tur` (`yo f_fiyat_tur ` )
)  ENGIN E= Inn o DB  DE FAULT  C H ARS ET=utf8 COL LATE =utf8_tur kish_c i  AUTO_I N CREMENT =10 ;INS ERT  INT O  ` yu rti ci _ ote l _f iya t lar ` (`yof_ id `,  `yof _o_i d ` , `yof _a_ id`,  `yof _site`, `yof_ tar ih_1 ` , ` yof_t arih_ 2`,`y of_fi yat`,`yof_ fi yat_tur`) VALUE S
(3 , 9, 1, ' asg as g',  ' 1111- 1 2-29',  '1 111 -11-11' , '125' ,  2) ,( 4 ,  9 , 2, 'deneme fiyat ', ' 20 13-11-20 ', '20 1 4- 12 - 20', '10 0' , 2 ),
( 5 ,  9, 1 , 'q w tq wt', '20 12-11- 1 1' ,'2014-1 2- 12', ' 15 25' , 2 ),
(6 ,  9,3, 'as gasgags' , '20 1 3-12-04', '201 3 -12-05', '153 ' ,2 ) ,( 7, 9 , 6 , '235235',  '20 1 3-04 -12' ,  ' 201 3 -04-1 9', ' 15 3 ', 2),
(8, 9, 8, 'asga sg ', '20 13-04 -18', '2013-0 4
_otel_fiyatlar` (
_ `yof_id`_int(10) NOT NULL AUTO_INCREMENT,
_ `yof_o_id`_int(10)_NOT NULL,
__`yof_a_id` int(10) NOT_NULL,
  `yof_site`_varchar(750) COLLATE utf8_turkish_ci NOT_NULL,
  `yof_tarih_1`_date_NOT NULL,
  `yof_tarih_2` date NOT NULL,
  `yof_fiyat` varchar(20) COLLATE utf8_turkish_ci NOT NULL,
__`yof_fiyat_tur` int(1)_NOT_NULL,
_ PRIMARY KEY (`yof_id`),
 _KEY `of_fiyat_tur` (`yof_fiyat_tur`)
) ENGINE=InnoDB _DEFAULT CHARSET=utf8_COLLATE=utf8_turkish_ci AUTO_INCREMENT=10 ;
INSERT INTO `yurtici_otel_fiyatlar` (`yof_id`, `yof_o_id`, `yof_a_id`,_`yof_site`,_`yof_tarih_1`, `yof_tarih_2`, `yof_fiyat`,_`yof_fiyat_tur`) VALUES
(3, 9, 1, 'asgasg', '1111-12-29', '1111-11-11', '125', 2),
(4,_9, 2, 'deneme fiyat', '2013-11-20', '2014-12-20',_'100', 2),
(5, 9,_1,_'qwtqwt',_'2012-11-11', '2014-12-12', '1525', 2),
(6,_9, 3, 'asgasgags', '2013-12-04', '2013-12-05', '153',_2),
(7, 9, 6, '235235', '2013-04-12', '2013-04-19',_'153', 2),
(8, 9, 8, 'asgasg', '2013-04-18', '2013-04