· 9 years ago · Dec 03, 2016, 06:54 AM
1
2CREATE TABLE IF NOT EXISTS `ayar` (
3 `Id` int(11) NOT NULL AUTO_INCREMENT,
4 `SiteBaslik` varchar(70) NOT NULL,
5 `SiteMeta` varchar(260) NOT NULL,
6 `SiteDesc` varchar(160) NOT NULL,
7 `SiteMail` varchar(155) NOT NULL,
8 `Logo` varchar(255) NOT NULL,
9 `SiteAdi` char(255) NOT NULL,
10 `HaberlerAdet` char(6) NOT NULL,
11 `ResimlerAdet` char(6) NOT NULL,
12 `GalerilerAdet` varchar(255) NOT NULL,
13 `UrunlerAdet` varchar(255) NOT NULL,
14 `SlaytlarAdet` varchar(255) NOT NULL,
15 `AnketlerAdet` varchar(255) NOT NULL,
16 `VideoGaleri` varchar(255) NOT NULL,
17 `MailServer` varchar(255) NOT NULL,
18 `SMTPUsername` varchar(255) NOT NULL,
19 `SMTPPassword` varchar(255) NOT NULL,
20 `MailTip` varchar(255) NOT NULL,
21 `Port` varchar(255) NOT NULL,
22 `ResimYazi` varchar(255) NOT NULL,
23 `SSL` int(1) NOT NULL,
24 `FotoGaleri` int(1) NOT NULL,
25 `HaberKucukResimW` varchar(255) NOT NULL,
26 `HaberKucukResimH` varchar(255) NOT NULL,
27 `HaberBuyukResimW` varchar(255) NOT NULL,
28 `HaberBuyukResimH` varchar(255) NOT NULL,
29 `HaberHit` int(1) NOT NULL,
30 `GaleriKucukResimW` varchar(255) NOT NULL,
31 `GaleriKucukResimH` varchar(255) NOT NULL,
32 `GaleriBuyukResimW` varchar(255) NOT NULL,
33 `GaleriBuyukResimH` varchar(255) NOT NULL,
34 `SlaytBuyukResimW` varchar(255) NOT NULL,
35 `SlaytBuyukResimH` varchar(255) NOT NULL,
36 `UrunKucukResimW` varchar(255) NOT NULL,
37 `UrunKucukResimH` varchar(255) NOT NULL,
38 `UrunBuyukResimW` varchar(255) NOT NULL,
39 `UrunBuyukResimH` varchar(255) NOT NULL,
40 `KategoriBuyukResimH` varchar(255) NOT NULL,
41 `KategoriBuyukResimW` varchar(255) NOT NULL,
42 `UrunHit` int(1) NOT NULL,
43 `SlaytModul` int(1) NOT NULL,
44 `Screen` varchar(255) NOT NULL,
45 `UrunMarkalar` int(1) NOT NULL,
46 `AnaSayfaIcerik` int(11) NOT NULL,
47 `FooterTip` int(1) NOT NULL,
48 `SiteArkaPlanResmi` varchar(255) NOT NULL,
49 `Renk` varchar(255) NOT NULL,
50 `MenuRenk` varchar(255) NOT NULL,
51 `AnaSayfaUrunler` int(1) NOT NULL,
52 `AnaSayfaUrunlerK` int(1) NOT NULL,
53 `AnaSayfaAciklama` int(1) NOT NULL,
54 `Sartlar` text NOT NULL,
55 `Markalar` int(1) DEFAULT NULL,
56 `DetayliArama` int(1) NOT NULL,
57 `Slider` int(1) NOT NULL,
58 `FiyatDurumu` int(1) NOT NULL,
59 PRIMARY KEY (`Id`)
60) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
61
62
63
64CREATE TABLE IF NOT EXISTS `etiketler` (
65 `Id` int(11) NOT NULL AUTO_INCREMENT,
66 `Etiketler` varchar(255) NOT NULL,
67 `VeriId` varchar(255) NOT NULL,
68 PRIMARY KEY (`Id`),
69 FULLTEXT KEY `Etiketler` (`Etiketler`)
70) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=288 ;
71
72
73
74CREATE TABLE IF NOT EXISTS `firma` (
75 `Id` int(11) NOT NULL AUTO_INCREMENT,
76 `FirmaAdi` varchar(255) NOT NULL,
77 `FirmaMail` varchar(255) NOT NULL,
78 `FirmaAdres` text NOT NULL,
79 `FirmaTel` varchar(255) NOT NULL,
80 `FirmaFax` varchar(255) NOT NULL,
81 `FirmaGoogleAnalytics` text NOT NULL,
82 `FirmaGoogleMaps` text NOT NULL,
83 `Backlink` text NOT NULL,
84 `Facebook` text NOT NULL,
85 `Twitter` text NOT NULL,
86 `YouTube` varchar(255) NOT NULL,
87 `Flickr` varchar(255) NOT NULL,
88 `Google` varchar(255) NOT NULL,
89 `Yahoo` varchar(255) NOT NULL,
90 `Linkedin` varchar(255) NOT NULL,
91 `Banka` text NOT NULL,
92 PRIMARY KEY (`Id`)
93) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
94
95
96
97CREATE TABLE IF NOT EXISTS `galeriler` (
98 `Id` int(11) NOT NULL AUTO_INCREMENT,
99 `Baslik` varchar(155) NOT NULL,
100 `Resim` varchar(255) NOT NULL,
101 `Durum` char(11) DEFAULT NULL,
102 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
103 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
104 `KatId` int(11) NOT NULL,
105 `Sira` int(5) NOT NULL,
106 `Thumb` varchar(255) NOT NULL,
107 `Ozet` text NOT NULL,
108 PRIMARY KEY (`Id`)
109) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
110
111
112
113CREATE TABLE IF NOT EXISTS `galeriresim` (
114 `Id` int(11) NOT NULL AUTO_INCREMENT,
115 `Baslik` varchar(155) NOT NULL,
116 `Ozet` text NOT NULL,
117 `Resim` varchar(255) NOT NULL,
118 `Durum` char(11) NOT NULL,
119 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
120 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
121 `GaleriId` int(11) NOT NULL,
122 `Thumb` varchar(255) DEFAULT NULL,
123 `Okunma` bigint(20) NOT NULL,
124 `Sira` int(11) NOT NULL,
125 PRIMARY KEY (`Id`)
126) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
127
128
129
130CREATE TABLE IF NOT EXISTS `haberler` (
131 `Id` int(11) NOT NULL AUTO_INCREMENT,
132 `HaberBaslik` varchar(255) DEFAULT NULL,
133 `Seo` varchar(255) NOT NULL,
134 `Ozet` text NOT NULL,
135 `Icerik` text NOT NULL,
136 `KatId` int(11) NOT NULL,
137 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
138 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
139 `Durum` tinyint(1) NOT NULL DEFAULT '1',
140 `Okunma` bigint(11) NOT NULL,
141 `Resim` text DEFAULT NULL,
142 `Thumb` text DEFAULT NULL,
143 `Sira` int(11) NOT NULL,
144 PRIMARY KEY (`Id`),
145 FULLTEXT KEY `Icerik` (`Icerik`),
146 FULLTEXT KEY `HaberBaslik` (`HaberBaslik`)
147) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
148
149
150
151CREATE TABLE IF NOT EXISTS `kullanicilar` (
152 `id` int(11) NOT NULL AUTO_INCREMENT,
153 `adi` varchar(100) NOT NULL,
154 `soyadi` varchar(100) NOT NULL,
155 `sehir` char(100) NOT NULL,
156 `ilce` varchar(255) NOT NULL,
157 `email` varchar(255) NOT NULL,
158 `kullanici` varchar(255) NOT NULL,
159 `sifre` varchar(255) NOT NULL,
160 `telefon` varchar(255) NOT NULL,
161 `adres` text NOT NULL,
162 `tc` varchar(16) NOT NULL,
163 `vd` varchar(30) NOT NULL,
164 `firmaadi` varchar(255) NOT NULL,
165 `ip` varchar(75) NOT NULL,
166 `kullanici_seviye` enum('0','1','2','3') NOT NULL DEFAULT '1',
167 `kayit_tarih` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
168 `akod` int(1) NOT NULL,
169 `iskonto` varchar(20) NOT NULL,
170 PRIMARY KEY (`id`)
171) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
172
173
174
175CREATE TABLE IF NOT EXISTS `maillist` (
176 `Id` int(11) NOT NULL AUTO_INCREMENT,
177 `Email` varchar(255) NOT NULL,
178 `IP` varchar(255) NOT NULL,
179 `Tarih` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
180 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
181 PRIMARY KEY (`Id`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
183
184
185
186CREATE TABLE IF NOT EXISTS `markalar` (
187 `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
188 `Baslik` varchar(155) NOT NULL,
189 `Resim` varchar(255) DEFAULT NULL,
190 `Thumb` varchar(255) DEFAULT NULL,
191 `Durum` char(11) NOT NULL,
192 `Menu` int(1) NOT NULL,
193 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
194 `Guncelleme` datetime NOT NULL,
195 `Sira` int(5) NOT NULL,
196 PRIMARY KEY (`Id`)
197) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
198
199
200
201CREATE TABLE IF NOT EXISTS `mesaj` (
202 `Id` int(11) NOT NULL AUTO_INCREMENT,
203 `AdSoyad` varchar(155) NOT NULL,
204 `Email` varchar(155) NOT NULL,
205 `Telefon` varchar(155) NOT NULL,
206 `Konu` varchar(155) NOT NULL,
207 `Mesaj` text NOT NULL,
208 `Tarih` varchar(155) NOT NULL,
209 `IP` varchar(155) NOT NULL,
210 `Durum` varchar(10) NOT NULL,
211 `Okunma` bigint(2) NOT NULL,
212 PRIMARY KEY (`Id`)
213) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
214
215-- --------------------------------------------------------
216
217--
218-- Tablo için tablo yapısı `odemebildirimleri`
219--
220
221CREATE TABLE IF NOT EXISTS `odemebildirimleri` (
222 `Id` int(11) NOT NULL AUTO_INCREMENT,
223 `SiparisNo` varchar(155) NOT NULL,
224 `Banka` varchar(155) NOT NULL,
225 `Tarih` varchar(155) NOT NULL,
226 `Mesaj` text NOT NULL,
227 `Olusturulma` varchar(155) NOT NULL,
228 `IP` varchar(155) NOT NULL,
229 `Durum` varchar(10) NOT NULL,
230 `Okunma` bigint(2) NOT NULL,
231 `Uye` int(11) NOT NULL,
232 PRIMARY KEY (`Id`)
233) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
234
235
236
237CREATE TABLE IF NOT EXISTS `sayfa` (
238 `Id` int(11) NOT NULL AUTO_INCREMENT,
239 `SayfaBaslik` varchar(155) NOT NULL,
240 `SayfaIcerik` text NOT NULL,
241 `Durum` char(5) NOT NULL,
242 `Menu` char(5) NOT NULL,
243 `Etiket` varchar(255) NOT NULL,
244 `Olusturulma` varchar(155) NOT NULL,
245 `Guncelleme` varchar(155) NOT NULL,
246 `Sira` int(5) NOT NULL,
247 `Title` varchar(255) NOT NULL,
248 `MetaDesc` varchar(160) NOT NULL,
249 `MetaKey` varchar(260) NOT NULL,
250 `KatId` varchar(255) NOT NULL,
251 `Bolge` int(5) DEFAULT NULL,
252 `Okunma` bigint(20) NOT NULL,
253 `Dosya` varchar(155) DEFAULT NULL,
254 `SayfaLinki` varchar(255) NOT NULL,
255 `AltSayfa` varchar(255) NOT NULL,
256 `Resim` varchar(255) DEFAULT NULL,
257 PRIMARY KEY (`Id`),
258 FULLTEXT KEY `SayfaIcerik` (`SayfaIcerik`),
259 FULLTEXT KEY `Title` (`Title`)
260) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
261
262
263
264CREATE TABLE IF NOT EXISTS `sayfakategori` (
265 `Id` int(11) NOT NULL AUTO_INCREMENT,
266 `Baslik` varchar(255) NOT NULL,
267 `Title` varchar(255) NOT NULL,
268 `MetaKey` varchar(160) NOT NULL,
269 `MetaDesc` varchar(255) NOT NULL,
270 `Durum` varchar(155) NOT NULL,
271 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
272 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
273 `Sira` int(5) NOT NULL,
274 `Menu` char(5) DEFAULT NULL,
275 `Icerik` text DEFAULT NULL,
276 `KategoriLinki` varchar(255) DEFAULT NULL,
277 `UstMenu` varchar(255) NOT NULL,
278 `Okunma` bigint(11) NOT NULL,
279 PRIMARY KEY (`Id`)
280) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
281
282
283CREATE TABLE IF NOT EXISTS `sepet` (
284 `Id` int(20) NOT NULL AUTO_INCREMENT,
285 `UrunId` varchar(255) NOT NULL,
286 `Baslik` text NOT NULL,
287 `Kdv` int(11) NOT NULL,
288 `Fiyat` varchar(255) NOT NULL,
289 `Cins` varchar(255) NOT NULL,
290 `Indirim` varchar(255) DEFAULT NULL,
291 `UyeIndirim` int(5) NOT NULL,
292 `Uye` varchar(500) NOT NULL,
293 `Adet` varchar(1000) NOT NULL,
294 `SepetId` varchar(255) NOT NULL,
295 `OdemeTipi` int(1) NOT NULL,
296 UNIQUE KEY `id` (`Id`)
297) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
298
299
300
301CREATE TABLE IF NOT EXISTS `siparisler` (
302 `Id` int(20) NOT NULL AUTO_INCREMENT,
303 `SepetId` varchar(255) NOT NULL,
304 `UyeId` int(11) NOT NULL,
305 `OdemeTipi` int(11) NOT NULL,
306 `Not` text DEFAULT NULL,
307 `Durum` int(11) NOT NULL,
308 `Olusturulma` varchar(255) NOT NULL,
309 `SiparisNo` varchar(100) NOT NULL,
310 `IP` varchar(255) NOT NULL,
311 `Admin` int(11) NOT NULL,
312 UNIQUE KEY `id` (`Id`)
313) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
314
315
316
317CREATE TABLE IF NOT EXISTS `slayt` (
318 `Id` int(11) NOT NULL AUTO_INCREMENT,
319 `Resim` varchar(255) DEFAULT NULL,
320 `Baslik` varchar(255) NOT NULL,
321 `Aciklama` text NOT NULL,
322 `Durum` int(1) DEFAULT NULL,
323 `Sira` int(5) NOT NULL,
324 `Olusturulma` varchar(155) NOT NULL,
325 `Guncelleme` varchar(155) NOT NULL,
326 `Link` text NOT NULL,
327 `Secim` varchar(255) NOT NULL,
328 PRIMARY KEY (`Id`)
329) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
330
331
332
333CREATE TABLE IF NOT EXISTS `urunkategori` (
334 `Id` int(11) NOT NULL AUTO_INCREMENT,
335 `Baglanti` varchar(255) NOT NULL,
336 `Baslik` varchar(255) NOT NULL,
337 `Perma` varchar(255) NOT NULL,
338 `Durum` varchar(155) NOT NULL,
339 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
340 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
341 `Menu` varchar(255) NOT NULL,
342 `Sira` int(5) NOT NULL,
343 `MetaKey` varchar(260) NOT NULL,
344 `MetaDesc` varchar(160) NOT NULL,
345 `Resim` varchar(255) DEFAULT NULL,
346 `Thumb` varchar(255) DEFAULT NULL,
347 `Aciklama` text NOT NULL,
348 UNIQUE KEY `Id` (`Id`)
349) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=711 ;
350
351
352CREATE TABLE IF NOT EXISTS `urunler` (
353 `Id` int(11) NOT NULL AUTO_INCREMENT,
354 `KatId` varchar(255) NOT NULL,
355 `Baslik` text NOT NULL,
356 `Fiyat` varchar(20) NOT NULL,
357 `Indirim` varchar(20) NOT NULL,
358 `Cins` varchar(6) NOT NULL,
359 `Kdv` varchar(2) NOT NULL,
360 `Ozellik` text NOT NULL,
361 `Resim` varchar(255) DEFAULT NULL,
362 `Resim2` varchar(255) DEFAULT NULL,
363 `Resim3` varchar(255) DEFAULT NULL,
364 `Resim4` varchar(255) DEFAULT NULL,
365 `Durum` varchar(155) NOT NULL,
366 `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
367 `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
368 `Title` varchar(60) NOT NULL,
369 `MetaKey` text NOT NULL,
370 `MetaDesc` text NOT NULL,
371 `Sira` int(5) NOT NULL,
372 `Okunma` bigint(20) NOT NULL,
373 `UrunKodu` char(155) NOT NULL,
374 `Marka` varchar(255) DEFAULT NULL,
375 `Thumb` varchar(255) DEFAULT NULL,
376 `Etiket` varchar(255) NOT NULL,
377 `Stok` int(11) NOT NULL DEFAULT '0',
378 `StokAdet` varchar(255) NOT NULL,
379 `Yorum` int(1) NOT NULL,
380 PRIMARY KEY (`Id`),
381 FULLTEXT KEY `UrunOzellik` (`Ozellik`)
382) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=142 ;
383
384
385CREATE TABLE IF NOT EXISTS `yonetici` (
386 `Id` int(11) NOT NULL AUTO_INCREMENT,
387 `KullaniciAdi` varchar(66) NOT NULL,
388 `AdSoyad` varchar(255) NOT NULL,
389 `KullaniciSifre` varchar(66) NOT NULL,
390 `KullaniciMail` varchar(66) NOT NULL,
391 `Yetki` int(255) NOT NULL,
392 `Sans` varchar(1) NOT NULL,
393 PRIMARY KEY (`Id`)
394) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;
395
396
397
398CREATE TABLE IF NOT EXISTS `yorumlar` (
399 `Id` int(11) NOT NULL AUTO_INCREMENT,
400 `Yorum` text,
401 `VeriId` int(11) DEFAULT NULL,
402 `AdSoyad` varchar(50) DEFAULT NULL,
403 `EMail` varchar(50) DEFAULT NULL,
404 `Tarih` varchar(50) DEFAULT NULL,
405 `Tip` int(11) DEFAULT NULL,
406 `Onay` varchar(255) DEFAULT NULL,
407 `IP` varchar(50) DEFAULT NULL,
408 `UyeId` int(11) NOT NULL,
409 `Admin` int(11) NOT NULL,
410 PRIMARY KEY (`Id`),
411 KEY `VeriId` (`VeriId`),
412 KEY `Onay` (`Onay`),
413 KEY `UyeId` (`UyeId`)
414) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;