Skip to content

Instantly share code, notes, and snippets.

CREATE TABLE `yok_bolumler` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fakulteId` varchar(40) NOT NULL,
`universiteId` int(6) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `fakulteHash` (`fakulteId`)
) ENGINE=MyISAM;
INSERT INTO `yok_bolumler` (`id`, `fakulteId`, `universiteId`, `name`) VALUES
@sercey
sercey / pk.sql
Created November 25, 2013 10:12
This file has been truncated, but you can view the full file.
/*
Türkiye'nin il, ilçe , semt, mahalle, posta kodu veritabanı
GÜNCEL : 19.04.2013
Kaynak : PTT
Oluşturan : http://www.twitter.com/tserpico
*/
DROP TABLE IF EXISTS `pk`;
CREATE TABLE `pk` (
`mahalle_id` bigint(10) NOT NULL AUTO_INCREMENT,
We can't make this file beautiful and searchable because it's too large.
"id","parentID","isim","haschild"
23365,0,"Acura",1
93026,23365,"CL",1
93027,93026,"2.2",0
93028,93026,"2.3",0
93029,93026,"3.0",0
23366,23365,"RL",1
93031,23366,"3.5",0
63999,23366,"3.7 VTEC",0
91976,23365,"RSX",1
This file has been truncated, but you can view the full file.
"id","parentID","isim","haschild"
3518,0,"Emlak",1
3613,3518,"Konut",1
16623,3613,"Satılık",1
16633,16623,"Daire",0
152512,16623,"Residence",0
16635,16623,"Müstakil Ev",0
16636,16623,"Villa",0
152456,16623,"Çiftlik Evi",0
152480,16623,"Köşk & Konak",0