Serkan Ceylan sercey
sercey
/ Alışveriş Kategori Veritabanı
Created
November 18, 2013 11:42
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "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 |
sercey
/ vasita.csv
Created
November 18, 2013 12:13
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| 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, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |