# MySQL-Front Dump 1.22
#
# Host: localhost Database: alisveris
#--------------------------------------------------------
# Server version 4.0.12-nt


#
# Table structure for table 'nitelikdeger'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ nitelikdeger (
  id int(11) NOT NULL auto_increment,
  üst int(11) NOT NULL DEFAULT '0' ,
  adı varchar(64) NOT NULL DEFAULT '' ,
  sıralama int(2) DEFAULT '1' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'nitelikdeger'
#
INSERT INTO nitelikdeger VALUES("1","0","Renk","1");
INSERT INTO nitelikdeger VALUES("2","1","Sarı","1");
INSERT INTO nitelikdeger VALUES("3","1","Kırmızı","1");
INSERT INTO nitelikdeger VALUES("4","1","Yeşil","1");
INSERT INTO nitelikdeger VALUES("5","1","Mavi","1");
INSERT INTO nitelikdeger VALUES("6","0","Boyut","1");
INSERT INTO nitelikdeger VALUES("7","6","Küçük","1");
INSERT INTO nitelikdeger VALUES("8","6","Büyük","1");
INSERT INTO nitelikdeger VALUES("9","6","Orta","1");


#
# Table structure for table 'nitelikler'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ nitelikler (
  id int(11) NOT NULL auto_increment,
  adı varchar(32) NOT NULL DEFAULT '' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'nitelikler'
#


#
# Table structure for table 'taksit'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ taksit (
  id int(3) NOT NULL auto_increment,
  üst int(3) DEFAULT '0' ,
  taksit char(2) ,
  puan char(2) NOT NULL DEFAULT '0' ,
  oran varchar(5) ,
  durum enum('0','1') DEFAULT '1' ,
  adı varchar(20) ,
  resim varchar(20) ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'taksit'
#
INSERT INTO taksit VALUES("1","0","12","1","","1","Akbank","akbank.gif");
INSERT INTO taksit VALUES("2","0","12","1",NULL,"1","Maximum Kart","maximum.gif");
INSERT INTO taksit VALUES("3","1","1","1","0","1","Peşin",NULL);
INSERT INTO taksit VALUES("4","1","2","0","0410","1","2 Ay",NULL);
INSERT INTO taksit VALUES("5","1","3","0","0510","1","3 Ay",NULL);
INSERT INTO taksit VALUES("6","1","4","0","0689","1","4 Ay",NULL);
INSERT INTO taksit VALUES("7","1","5","0","0710","1","5 Ay",NULL);
INSERT INTO taksit VALUES("8","1","6","0","","1","6 Ay",NULL);
INSERT INTO taksit VALUES("9","1","7","0","09,2","1","7 Ay",NULL);
INSERT INTO taksit VALUES("10","1","8","0","10,2","1","8 Ay",NULL);
INSERT INTO taksit VALUES("11","1","9","0","11,23","1","9 Ay",NULL);
INSERT INTO taksit VALUES("12","1","10","0","12,13","1","10 Ay",NULL);
INSERT INTO taksit VALUES("13","1","11","0","13,23","1","11 Ay",NULL);
INSERT INTO taksit VALUES("14","1","12","0","14,6","1","12 Ay",NULL);
INSERT INTO taksit VALUES("15","2","1","2","0","1","Peşin",NULL);
INSERT INTO taksit VALUES("16","2","2","0","0","1","2 Ay",NULL);
INSERT INTO taksit VALUES("17","2","3","0","0","1","3 Ay",NULL);
INSERT INTO taksit VALUES("18","2","4","0","0423","1","4 Ay",NULL);
INSERT INTO taksit VALUES("19","2","5","0","053","1","5 Ay",NULL);
INSERT INTO taksit VALUES("20","2","6","0","06,5","1","6 Ay",NULL);
INSERT INTO taksit VALUES("21","2","7","0","06,9","1","7 Ay",NULL);
INSERT INTO taksit VALUES("22","2","8","0","07,6","1","8 ay",NULL);
INSERT INTO taksit VALUES("23","2","9","0","08,9","1","9 Ay",NULL);
INSERT INTO taksit VALUES("24","2","10","0","09,80","1","10 Ay",NULL);
INSERT INTO taksit VALUES("25","2","11","0","10,22","1","11 Ay",NULL);
INSERT INTO taksit VALUES("26","2","12","0","12,01","1","12 Ay",NULL);
INSERT INTO taksit VALUES("27","0","12","0",NULL,"1","Fortis","fortis.gif");
INSERT INTO taksit VALUES("28","27","1","0","1","1","Peşin",NULL);


#
# Table structure for table 'taksitgrup'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ taksitgrup (
  id int(3) NOT NULL auto_increment,
  üst int(3) DEFAULT '0' ,
  adı varchar(30) ,
  durum enum('0','1') DEFAULT '1' ,
  oge int(3) unsigned ,
  UNIQUE id (id),
  INDEX id_2 (id)
);



#
# Dumping data for table 'taksitgrup'
#
INSERT INTO taksitgrup VALUES("1","0","Tüm Bankalar","1",NULL);
INSERT INTO taksitgrup VALUES("2","0","Akbank ve Maximum","1",NULL);
INSERT INTO taksitgrup VALUES("3","1","Akbank","1","1");
INSERT INTO taksitgrup VALUES("4","1","Isbank","1","2");
INSERT INTO taksitgrup VALUES("5","1","Fortis","1","27");


#
# Table structure for table 'tesodeme'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ tesodeme (
  id int(3) NOT NULL auto_increment,
  tip char(1) ,
  adı varchar(30) ,
  resim varchar(16) ,
  durum enum('0','1') DEFAULT '1' ,
  tutar char(3) ,
  açıklama varchar(255) ,
  sıralama char(2) DEFAULT '1' ,
  ek varchar(150) ,
  UNIQUE id (id)
);



#
# Dumping data for table 'tesodeme'
#
INSERT INTO tesodeme VALUES("1","1","Yurtiçi Kargo","yurticikargo.gif","1","8",NULL,"3",NULL);
INSERT INTO tesodeme VALUES("2","1","Aras Kargo","araskargo.gif","1","8",NULL,"1",NULL);
INSERT INTO tesodeme VALUES("3","1","UPS Kargo","upskargo.gif","1","7",NULL,"2",NULL);
INSERT INTO tesodeme VALUES("4","2","Kurye","","1","2","<br>(Saat 15:00 a kadar yapılan tüm siparişlerde aynı gün teslimat imkanı)","1",NULL);
INSERT INTO tesodeme VALUES("5","4","Kapıda Kredi Kartı ile Ödeme","","1","3",NULL,"2","onclick=\"kp(a1,a2,a4);d(s,\'0\');\"");
INSERT INTO tesodeme VALUES("6","4","Kredi Kartı ile Ödeme",NULL,"1","-5",NULL,"1","onclick=\"kp();d(s,\'0\');\"");
INSERT INTO tesodeme VALUES("7","4","Kredi Kartı ile Taksitli Ödeme",NULL,"1","1",NULL,"3","onclick=\"kp();d(\'taksitler\',\'1\');\"");
INSERT INTO tesodeme VALUES("8","3","Banka Havalesi/EFT",NULL,"1","-3%",NULL,"1","onclick=\"d(s,\'0\');kp();\"");
INSERT INTO tesodeme VALUES("9","3","Kapıda Nakit Ödeme","","1","0",NULL,"2","onclick=\"kp(a3,a2);d(s,\'0\');\"");


#
# Table structure for table 'ürün_nitelikleri'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ ürün_nitelikleri (
  id int(11) NOT NULL auto_increment,
  üst int(11) NOT NULL DEFAULT '0' ,
  nitelikno int(11) NOT NULL DEFAULT '0' ,
  nitdeğerno int(11) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'ürün_nitelikleri'
#
INSERT INTO ürün_nitelikleri VALUES("1","1","1","2");
INSERT INTO ürün_nitelikleri VALUES("2","2","1","3");


#
# Table structure for table 'ürün_seçenek'
#

CREATE TABLE /*!32300 IF NOT EXISTS*/ ürün_seçenek (
  id int(11) NOT NULL auto_increment,
  üst int(11) NOT NULL DEFAULT '0' ,
  seçenek int(11) NOT NULL DEFAULT '0' ,
  değer int(11) NOT NULL DEFAULT '0' ,
  fiyat decimal(15,4) NOT NULL DEFAULT '0.0000' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'ürün_seçenek'
#