Zipledim olmadı, bu arada database boyutu ufak 12,7 KB
database'nin tamamına aşağıdan bakabilirsiniz....sorun nedir? nasıl halledebilirim?
CREATE TABLE aktivite_katilanlar (
id int(10) unsigned NOT NULL auto_increment,
aktivite_id int(10) default NULL,
katilan_id int(10) default NULL,
sayi char(2) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'aktiviteler'
#
CREATE TABLE aktiviteler (
id int(10) unsigned NOT NULL auto_increment,
gonderen int(10) default NULL,
baslik varchar(255) default NULL,
tarih date default NULL,
saat1 char(2) default NULL,
saat2 char(2) default NULL,
mekan varchar(255) default NULL,
ucret varchar(200) default NULL,
bilgi text,
yetki int(1) default NULL,
flyer varchar(40) default NULL,
durum int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'arkadaslar'
#
CREATE TABLE arkadaslar (
id int(10) unsigned NOT NULL auto_increment,
yourid int(10) default NULL,
fid int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'arkadaslar'
#
INSERT INTO arkadaslar VALUES("2", "3", "1");
INSERT INTO arkadaslar VALUES("5", "3", "1");
#
# Table structure for table 'banner'
#
CREATE TABLE banner (
id int(10) unsigned NOT NULL auto_increment,
src varchar(225) default NULL,
url varchar(225) default NULL,
alt varchar(225) default NULL,
goruntuleme int(10) default NULL,
tiklama int(10) default NULL,
tarih date default NULL,
k_cpm int(10) default NULL,
cpm int(10) default NULL,
yer int(1) default NULL,
durum int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'banner'
#
INSERT INTO banner VALUES("1", "0000000001_000000000000000069521.swf", "", "", "304", "0", "2003-09-19", "1", "0", "1", "1");
INSERT INTO banner VALUES("2", "01.jpg", "http://www.sevgiliye.com", "Sevgiliye.com", "0", "0", "2004-12-01", "1", "0", "2", "1");
INSERT INTO banner VALUES("3", "serbestkosebanner.gif", "http://www.comepus.com", "Copepus::....", "0", "0", "2004-12-01", "1", "0", "3", "1");
#
# Table structure for table 'carpildiklarim'
#
CREATE TABLE carpildiklarim (
id int(10) unsigned NOT NULL auto_increment,
yourid int(10) default NULL,
fid int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'carpildiklarim'
#
#
# Table structure for table 'davet'
#
CREATE TABLE davet (
id int(10) unsigned NOT NULL auto_increment,
edenid int(10) default NULL,
email varchar(150) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
CREATE TABLE forum (
id int(10) unsigned NOT NULL auto_increment,
iid int(10) default NULL,
konu varchar(255) default NULL,
mesaj text,
kategori int(10) default NULL,
kimden int(10) default NULL,
est int(1) default NULL,
kilit int(1) default '1',
kural int(1) default NULL,
tarih date default NULL,
zaman time default NULL,
durum int(1) default '1',
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
CREATE TABLE forumkategori (
id int(10) unsigned NOT NULL auto_increment,
kategori varchar(255) default NULL,
ac varchar(255) default NULL,
durum int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'forumkategori'
#
INSERT INTO forumkategori VALUES("1", "Kampüs", "haydi kampüslüler buraya !!!", "1");
INSERT INTO forumkategori VALUES("2", "Müzik", NULL, "1");
INSERT INTO forumkategori VALUES("3", "Sanat", NULL, "1");
INSERT INTO forumkategori VALUES("4", "Sinema", NULL, "1");
INSERT INTO forumkategori VALUES("5", "Spor", NULL, "1");
#
# Table structure for table 'gonderilenler'
#
CREATE TABLE gonderilenler (
id int(10) unsigned NOT NULL auto_increment,
uyeid int(10) default NULL,
konu varchar(255) default NULL,
mesaj text,
durum int(1) default NULL,
yer int(1) default NULL,
tarih date default NULL,
zaman time default NULL,
gonderen int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'gonderilenler'
#
#
# Table structure for table 'haberler'
#
CREATE TABLE haberler (
id int(10) unsigned NOT NULL auto_increment,
iid int(10) default NULL,
konu varchar(100) default NULL,
haber text,
tarih date default NULL,
saat time default NULL,
durum int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'haberler'
#
INSERT INTO haberler VALUES("13", "3", "yeni haber", "haber", "2005-02-11", "23:34:44", "1");
#
# Table structure for table 'istekler'
#
CREATE TABLE istekler (
id int(10) unsigned NOT NULL auto_increment,
iid int(10) default NULL,
konu varchar(60) default NULL,
haber text,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'istekler'
#
#
# Table structure for table 'mesajlar'
#
CREATE TABLE mesajlar (
id int(10) unsigned NOT NULL auto_increment,
uyeid int(10) default NULL,
konu varchar(255) default NULL,
mesaj text,
durum int(1) default NULL,
yer int(1) default NULL,
tarih date default NULL,
zaman time default NULL,
gonderen int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'online'
#
CREATE TABLE online (
id int(10) unsigned NOT NULL auto_increment,
ziyaretci varchar(100) default NULL,
zaman int(11) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'online2'
#
CREATE TABLE online2 (
id int(10) unsigned NOT NULL auto_increment,
kullanici varchar(225) NOT NULL default '',
iid int(10) default NULL,
zaman int(11) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'rapor'
#
CREATE TABLE rapor (
id int(10) unsigned NOT NULL auto_increment,
yourid int(10) default NULL,
fid int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'resim'
#
CREATE TABLE resim (
id int(10) unsigned NOT NULL auto_increment,
iid int(10) default NULL,
resim varchar(40) default NULL,
durum int(1) default NULL,
onay int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'resim'
#
INSERT INTO resim VALUES("1", "1", "11021305481.jpg", "1", "1");
#
# Table structure for table 'sehir'
#
CREATE TABLE sehir (
id int(10) unsigned NOT NULL auto_increment,
sehir varchar(150) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'sehir'
#
INSERT INTO sehir VALUES("1", "Adana");
INSERT INTO sehir VALUES("2", "Adıyaman");
INSERT INTO sehir VALUES("3", "Afyon");
INSERT INTO sehir VALUES("4", "Ağrı");
INSERT INTO sehir VALUES("5", "Amasya");
INSERT INTO sehir VALUES("6", "Ankara");
INSERT INTO sehir VALUES("7", "Antalya");
INSERT INTO sehir VALUES("8", "Artvin");
INSERT INTO sehir VALUES("9", "Aydın");
INSERT INTO sehir VALUES("10", "Balıkesir");
INSERT INTO sehir VALUES("11", "Bilecik");
INSERT INTO sehir VALUES("12", "Bingöl");
INSERT INTO sehir VALUES("13", "Bitlis");
INSERT INTO sehir VALUES("14", "Bolu");
INSERT INTO sehir VALUES("15", "Burdur");
INSERT INTO sehir VALUES("16", "Bursa");
INSERT INTO sehir VALUES("17", "Çanakkale");
INSERT INTO sehir VALUES("18", "Çankırı");
INSERT INTO sehir VALUES("19", "Çorum");
INSERT INTO sehir VALUES("20", "Denizli");
INSERT INTO sehir VALUES("21", "Diyarbakır");
INSERT INTO sehir VALUES("22", "Edirne");
INSERT INTO sehir VALUES("23", "Elazığ");
INSERT INTO sehir VALUES("24", "Erzincan");
INSERT INTO sehir VALUES("25", "Erzurum");
INSERT INTO sehir VALUES("26", "Eskişehir");
INSERT INTO sehir VALUES("27", "Gaziantep");
INSERT INTO sehir VALUES("28", "Giresun");
INSERT INTO sehir VALUES("29", "Gümüşhane");
INSERT INTO sehir VALUES("30", "Hakkari");
INSERT INTO sehir VALUES("31", "Hatay");
INSERT INTO sehir VALUES("32", "Isparta");
INSERT INTO sehir VALUES("33", "Içel(Mersin)");
INSERT INTO sehir VALUES("34", "Istanbul");
INSERT INTO sehir VALUES("35", "Izmir");
INSERT INTO sehir VALUES("36", "Kars");
INSERT INTO sehir VALUES("37", "Kastamonu");
INSERT INTO sehir VALUES("38", "Kayseri");
INSERT INTO sehir VALUES("39", "Kırklareli");
INSERT INTO sehir VALUES("40", "Kırşehir");
INSERT INTO sehir VALUES("41", "Kocaeli");
INSERT INTO sehir VALUES("42", "Konya");
INSERT INTO sehir VALUES("43", "Kütahya");
INSERT INTO sehir VALUES("44", "Malatya");
INSERT INTO sehir VALUES("45", "Manisa");
INSERT INTO sehir VALUES("46", "Maraş");
INSERT INTO sehir VALUES("47", "Mardin");
INSERT INTO sehir VALUES("48", "Muğla");
INSERT INTO sehir VALUES("49", "Muş");
INSERT INTO sehir VALUES("50", "Nevşehir");
INSERT INTO sehir VALUES("51", "Niğde");
INSERT INTO sehir VALUES("52", "Ordu");
INSERT INTO sehir VALUES("53", "Rize");
INSERT INTO sehir VALUES("54", "Sakarya");
INSERT INTO sehir VALUES("55", "Samsun");
INSERT INTO sehir VALUES("56", "Siirt");
INSERT INTO sehir VALUES("57", "Sinop");
INSERT INTO sehir VALUES("58", "Sivas");
INSERT INTO sehir VALUES("59", "Tekirdağ");
INSERT INTO sehir VALUES("60", "Tokat");
INSERT INTO sehir VALUES("61", "Trabzon");
INSERT INTO sehir VALUES("62", "Tunceli");
INSERT INTO sehir VALUES("63", "Urfa");
INSERT INTO sehir VALUES("64", "Uşak");
INSERT INTO sehir VALUES("65", "Van");
INSERT INTO sehir VALUES("66", "Yozgat");
INSERT INTO sehir VALUES("67", "Zonguldak");
INSERT INTO sehir VALUES("68", "Aksaray");
INSERT INTO sehir VALUES("69", "Bayburt");
INSERT INTO sehir VALUES("70", "Karaman");
INSERT INTO sehir VALUES("71", "Kırıkkale");
INSERT INTO sehir VALUES("72", "Batman");
INSERT INTO sehir VALUES("73", "Sırnak");
INSERT INTO sehir VALUES("74", "Bartın");
INSERT INTO sehir VALUES("75", "Ardahan");
INSERT INTO sehir VALUES("76", "Iğdır");
INSERT INTO sehir VALUES("77", "Yalova");
INSERT INTO sehir VALUES("78", "Karabük");
INSERT INTO sehir VALUES("79", "Kilis");
INSERT INTO sehir VALUES("80", "Osmaniye");
INSERT INTO sehir VALUES("81", "Duzce");
#
# Table structure for table 'talepler'
#
CREATE TABLE talepler (
id int(10) unsigned NOT NULL auto_increment,
yourid int(10) default NULL,
fid int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Table structure for table 'ulke'
#
CREATE TABLE ulke (
id int(10) unsigned NOT NULL auto_increment,
ulke varchar(150) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'ulke'
#
INSERT INTO ulke VALUES("1", "ABD");
INSERT INTO ulke VALUES("2", "İngiltere");
INSERT INTO ulke VALUES("3", "Fransa");
INSERT INTO ulke VALUES("4", "Almanya");
INSERT INTO ulke VALUES("5", "İtalya");
INSERT INTO ulke VALUES("6", "İspanya");
INSERT INTO ulke VALUES("7", "Hollanda");
INSERT INTO ulke VALUES("8", "Belçika");
INSERT INTO ulke VALUES("9", "Rusya");
INSERT INTO ulke VALUES("10", "Avustralya");
INSERT INTO ulke VALUES("11", "Türkiye");
INSERT INTO ulke VALUES("12", "Diğer");
#
# Table structure for table 'users'
#
CREATE TABLE users (
id int(10) unsigned NOT NULL auto_increment,
login varchar(20) default NULL,
password varchar(20) default NULL,
ad varchar(150) default NULL,
soyad varchar(150) default NULL,
email varchar(150) default NULL,
cins int(1) default NULL,
dogum date default NULL,
postakodu varchar(5) default NULL,
sehir varchar(10) default NULL,
ulke varchar(10) default '1',
mesaj int(1) default NULL,
medeni int(1) default NULL,
meslek varchar(150) default NULL,
hakkinizda text,
statu varchar(10) default NULL,
resim int(1) default NULL,
tarih date default NULL,
online int(1) default NULL,
online_zaman int(11) default NULL,
sonziyaret date default NULL,
sonziyaret2 time default NULL,
durum int(1) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'users'
#
INSERT INTO users VALUES("1", "admin", "admin", "", "", "info@xkare.com", "1", "", "", "1", "", "0", "1", "", "", "", "0", "2004-11-24", "2", "1111010324", "2005-03-16", "23:58:44", "9");
#
# Table structure for table 'yasaklilar'
#
CREATE TABLE yasaklilar (
id int(10) unsigned NOT NULL auto_increment,
yourid tinyint(10) default NULL,
fid int(10) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;
#
# Dumping data for table 'yasaklilar'
#
INSERT INTO yasaklilar VALUES("1", "1", "3");Pc de yüklü olanlar ;phpMyAdmin - 2.10.2 Sunucu sürümü: 5.0.45-community-nt-log MySQL istemci sürümü: 5.0.37 Kullanılan PHP uzantıları: mysqlŞimdiden teşekkürler..
