Skip to content

Instantly share code, notes, and snippets.

@riza
Created December 27, 2015 19:07
Show Gist options
  • Save riza/690de6f9e2416f5c4324 to your computer and use it in GitHub Desktop.
Save riza/690de6f9e2416f5c4324 to your computer and use it in GitHub Desktop.
-- phpMyAdmin SQL Dump
-- version 4.4.9
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 27 Ara 2015, 21:07:33
-- Sunucu sürümü: 5.5.42
-- PHP Sürümü: 5.6.10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Veritabanı: `okul`
--
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `cities`
--
CREATE TABLE `cities` (
`id` int(10) unsigned NOT NULL,
`city` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Tablo döküm verisi `cities`
--
INSERT INTO `cities` (`id`, `city`, `created_at`, `updated_at`) VALUES
(1, 'Adana', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(2, 'Adıyaman', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(3, 'Afyonkarahisar', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(4, 'Ağrı', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(5, 'Aksaray', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(6, 'Amasya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(7, 'Ankara', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(8, 'Antalya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(9, 'Ardahan', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(10, 'Artvin', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(11, 'Aydın', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(12, 'Balıkesir', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(13, 'Bartın', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(14, 'Batman', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(15, 'Bayburt', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(16, 'Bilecik', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(17, 'Bingöl', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(18, 'Bitlis', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(19, 'Bolu', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(20, 'Burdur', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(21, 'Bursa', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(22, 'Çanakkale', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(23, 'Çankırı', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(24, 'Çorum', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(25, 'Denizli', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(26, 'Diyarbakır', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(27, 'Düzce', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(28, 'Edirne', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(29, 'Elazığ', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(30, 'Erzincan', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(31, 'Erzurum', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(32, 'Eskişehir', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(33, 'Gaziantep', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(34, 'Giresun', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(35, 'Gümüşhane', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(36, 'Hakkari', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(37, 'Hatay', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(38, 'Iğdır', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(39, 'Isparta', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(40, 'İstanbul', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(41, 'İzmir', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(42, 'Kahramanmaraş', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(43, 'Karabük', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(44, 'Karaman', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(45, 'Kars', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(46, 'Kastamonu', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(47, 'Kayseri', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(48, 'Kırıkkale', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(49, 'Kırklareli', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(50, 'Kırşehir', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(51, 'Kilis', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(52, 'Kocaeli', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(53, 'Konya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(54, 'Kütahya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(55, 'Malatya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(56, 'Manisa', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(57, 'Mardin', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(58, 'Mersin', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(59, 'Muğla', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(60, 'Muş', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(61, 'Nevşehir', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(62, 'Niğde', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(63, 'Ordu', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(64, 'Osmaniye', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(65, 'Rize', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(66, 'Sakarya', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(67, 'Samsun', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(68, 'Siirt', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(69, 'Sinop', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(70, 'Sivas', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(71, 'Şanlıurfa', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(72, 'Şırnak', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(73, 'Tekirdağ', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(74, 'Tokat', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(75, 'Trabzon', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(76, 'Tunceli', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(77, 'Uşak', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(78, 'Van', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(79, 'Yalova', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(80, 'Yozgat', '2015-12-24 22:05:50', '2015-12-24 22:05:50'),
(81, 'Zonguldak', '2015-12-24 22:05:50', '2015-12-24 22:05:50');
--
-- Dökümü yapılmış tablolar için indeksler
--
--
-- Tablo için indeksler `cities`
--
ALTER TABLE `cities`
ADD PRIMARY KEY (`id`);
--
-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
--
--
-- Tablo için AUTO_INCREMENT değeri `cities`
--
ALTER TABLE `cities`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=82;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment