/* SQLyog Trial - MySQL GUI v8.22 MySQL - 5.0.51a-24+lenny2+spu1 : Database - hosting ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`hosting` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `hosting`; /*Table structure for table `fb_billing_profiles` */ DROP TABLE IF EXISTS `fb_billing_profiles`; CREATE TABLE `fb_billing_profiles` ( `id` mediumint(9) NOT NULL auto_increment, `customer_id` mediumint(9) default NULL, `name` varchar(30) default NULL, `details` mediumtext, `default_profile` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `fb_billing_profiles` */ insert into `fb_billing_profiles`(`id`,`customer_id`,`name`,`details`,`default_profile`) values (1,28,'Ev','{\"ad\":\"asdasda\",\"tckno\":\"36919119811\",\"adres\":\"PK 766\",\"semt\":\"Lefkosa\",\"sehir\":\"KKTC\",\"postakodu\":\"99990\",\"ulke\":\"Tu00fcrkiye\",\"tel1\":\"+11.111 111-1111\",\"tel2\":\"+22.222 222-2222\",\"tip\":\"b\"}',0); /*Table structure for table `fb_cart` */ DROP TABLE IF EXISTS `fb_cart`; CREATE TABLE `fb_cart` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` smallint(6) unsigned default NULL, `type` varchar(20) default NULL, `details` mediumtext, `price` double(5,2) unsigned default NULL, `status` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8; /*Data for the table `fb_cart` */ insert into `fb_cart`(`id`,`customer_id`,`type`,`details`,`price`,`status`) values (1,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(2,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(3,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(4,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(5,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(6,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(7,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}',15.13,-5),(8,28,'domainrenew','{\"domain\":\"sontestler-10.org\",\"year\":\"3\"}',45.39,-5),(9,28,'domain','{\"domain\":\"tugrultest-11.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(10,28,'domainrenew','{\"domain\":\"tugrultest-11.org\",\"year\":\"1\"}',15.13,-5),(11,28,'hosting','{\"package\":\"4\",\"domain\":\"sontestler-10.org\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(56,28,'hosting','{\"package\":\"4\",\"domain\":\"tugrultest-11.org\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(13,28,'hosting','{\"package\":\"4\",\"domain\":\"tugrultest-12.com\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(14,28,'hosting','{\"package\":\"4\",\"domain\":\"tugrul.org\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(15,28,'hosting','{\"package\":\"4\",\"domain\":\"test1.com\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(16,28,'hosting','{\"package\":\"4\",\"domain\":\"deneme01.com\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(17,28,'hosting','{\"package\":\"4\",\"domain\":\"deneme03.com\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(18,28,'hosting','{\"package\":\"4\",\"domain\":\"deneme04.com\",\"platform\":\"Linux\",\"period\":\"1\"}',3.03,-5),(19,28,'domain','{\"domain\":\"tugrultest-12.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(20,28,'domain','{\"domain\":\"tugrultest-13.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(21,28,'domain','{\"domain\":\"havaletest.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(22,28,'domain','{\"domain\":\"denemedomaini.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(23,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(24,28,'vps','{\"package\":\"0\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"\",\"memory\":\"\",\"period\":\"1\"}',0.00,-5),(25,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(26,28,'vps','{\"package\":\"0\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"\",\"memory\":\"\",\"period\":\"1\"}',0.00,-5),(27,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(28,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(29,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(30,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(33,28,'domain','{\"domain\":\"deneme.net\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(34,28,'domain','{\"domain\":\"deneme.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(42,28,'domain','{\"domain\":\"asd.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transhelp\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(36,28,'domain','{\"domain\":\"asd.net\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(44,28,'domain','{\"domain\":\"bilimvefelsefemetinleri.net\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"F32HD412D34F12D34\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(40,28,'domain','{\"domain\":\"tugrul.net\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transhelp\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(43,28,'domain','{\"domain\":\"tugrul.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"UTF32T4YF1234T\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(45,28,'domain','{\"domain\":\"deneme04.com\",\"private\":\"0\",\"wp\":\"1\",\"transfer\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',0.00,-5),(46,28,'domain','{\"domain\":\"deneme04.com\",\"private\":\"0\",\"wp\":\"1\",\"transfer\":\"1\",\"transcode\":\"\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',0.00,-5),(47,28,'domain','{\"domain\":\"deneme04.com\",\"private\":\"0\",\"wp\":\"1\",\"transfer\":\"1\",\"transhelp\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',10.00,-5),(48,28,'domain','{\"domain\":\"deneme04.com\",\"private\":\"0\",\"wp\":\"1\",\"transfer\":\"1\",\"transhelp\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',10.00,-5),(49,28,'domain','{\"domain\":\"deneme04.com\",\"private\":0,\"wp\":\"1\",\"transfer\":\"1\",\"transhelp\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(50,28,'domain','{\"domain\":\"deneme04.com\",\"private\":\"0\",\"wp\":\"1\",\"transfer\":\"1\",\"transcode\":\"GHFJ324GHF1324\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(52,28,'domain','{\"domain\":\"onuronuk.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(53,28,'domain','{\"domain\":\"onuronuk.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',15.13,-5),(54,28,'vps','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(55,28,'vps','{\"package\":\"1\",\"rootPass\":\"yenisifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}',15.13,-5),(58,28,'hosting','{\"package\":\"5\",\"domain\":\"yenidomain.com\",\"platform\":\"Linux\",\"period\":\"1\"}',4.54,-5),(59,28,'hosting','{\"package\":\"5\",\"domain\":\"yenidomain.net\",\"platform\":\"Linux\",\"period\":\"1\"}',4.54,-5); /*Table structure for table `fb_config` */ DROP TABLE IF EXISTS `fb_config`; CREATE TABLE `fb_config` ( `id` smallint(6) unsigned NOT NULL auto_increment, `config` varchar(20) default NULL, `value` text, `last_update` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `key` (`config`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*Data for the table `fb_config` */ insert into `fb_config`(`id`,`config`,`value`,`last_update`) values (1,'dolarkuru','1.5130','2009-12-24 17:38:14'),(2,'onlinenic_order_id','128','2010-01-26 11:05:09'),(3,NULL,NULL,'2010-02-04 13:29:45'),(4,NULL,NULL,'2010-02-04 13:29:46'),(5,NULL,NULL,'2010-02-04 13:29:48'); /*Table structure for table `fb_config_bank_accounts` */ DROP TABLE IF EXISTS `fb_config_bank_accounts`; CREATE TABLE `fb_config_bank_accounts` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `sube` varchar(100) NOT NULL, `hesap` varchar(100) NOT NULL, `iban` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `hesap` (`hesap`), UNIQUE KEY `iban` (`iban`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `fb_config_bank_accounts` */ insert into `fb_config_bank_accounts`(`id`,`sube`,`hesap`,`iban`) values (1,'İş Bankası Lefkoşa Şubesi','6800-1073283','TR0628237604891263980612390561290358629365912365'); /*Table structure for table `fb_config_countries` */ DROP TABLE IF EXISTS `fb_config_countries`; CREATE TABLE `fb_config_countries` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `country` varchar(100) collate utf8_unicode_ci NOT NULL, `code` char(2) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `country` (`country`) ) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*Data for the table `fb_config_countries` */ insert into `fb_config_countries`(`id`,`country`,`code`) values (1,'Amerika Birleşik Devletleri',''),(2,'Afganistan',''),(3,'Almanya',''),(4,'Angola',''),(5,'Antigua',''),(6,'Arjantin',''),(7,'Arnavutluk',''),(8,'Aruba',''),(9,'Avustralya',''),(10,'Avusturya',''),(11,'Azerbaycan',''),(12,'Bahamalar',''),(13,'Bahreyn',''),(14,'Bangladeş',''),(15,'Barbados',''),(16,'Belçika',''),(17,'Belize',''),(18,'Benin',''),(19,'Bermuda',''),(20,'Beyaz Rusya',''),(21,'Butan',''),(22,'Birleşik Arap Emirlikleri',''),(23,'Bolivya',''),(24,'Bosna Hersek',''),(25,'Botsvana',''),(26,'Brezilya',''),(27,'Bruney',''),(28,'Bulgaristan',''),(29,'Burkina Faso',''),(30,'Burma Myanmar Burindi',''),(31,'Cape Verde',''),(32,'Cayman Adaları',''),(33,'Cezayir',''),(34,'Cibuti',''),(35,'Cook Adaları',''),(36,'Çad',''),(37,'Çek Cumhuriyeti',''),(38,'Çin',''),(39,'Danimarka',''),(40,'Dominik Cumhuriyeti',''),(41,'Ekvador',''),(42,'Ekvator Ginesi',''),(43,'Elsavador',''),(44,'Endonezya',''),(45,'Ermenistan',''),(46,'Estonya',''),(47,'Etyopya',''),(48,'Fas',''),(49,'Fiji',''),(50,'Fildişi Kıyısı',''),(51,'Filipinler',''),(52,'Finlandiya',''),(53,'Fransa',''),(54,'Fransız Guyanası',''),(55,'Cabon',''),(56,'Gambiya',''),(57,'Gana',''),(58,'Gine',''),(59,'Gine - Bissau',''),(60,'Guatemala',''),(61,'Guyana',''),(62,'Güney Afrika',''),(63,'Gürcistan',''),(64,'Haiti',''),(65,'Hırvatistan',''),(66,'Hindistan',''),(67,'Hollanda',''),(68,'Hollanda Antilleri',''),(69,'Honduras',''),(70,'Hong Kong',''),(71,'Irak',''),(72,'İngiltere',''),(73,'İran',''),(74,'İrlanda Cumhuriyeti',''),(75,'İspanya',''),(76,'İsrail',''),(77,'İsveç',''),(78,'İsviçre',''),(79,'İtalya',''),(80,'İzlanda',''),(81,'Jamaika',''),(82,'Japonya',''),(83,'Kamboçya',''),(84,'Kamerun',''),(85,'Kanada',''),(86,'Katar',''),(87,'Kazakistan',''),(88,'Kenya',''),(89,'Kıbrıs Rum Kesimi',''),(90,'Kırgısiztan',''),(91,'Kiribati',''),(92,'Kolombiya',''),(93,'Komor Adaları',''),(94,'Kongo',''),(95,'Kore, Güney',''),(96,'Kore, Kuzey',''),(97,'Kosta Rika',''),(98,'Kuveyt',''),(99,'Küba',''),(100,'Lesotho',''),(101,'Letonya',''),(102,'Liberya',''),(103,'Libya',''),(104,'Liechtenstayn',''),(105,'Litvanya',''),(106,'Lübnan',''),(107,'Lüksemburg',''),(108,'Makao',''),(109,'Macaristan',''),(110,'Madagaskar',''),(111,'Makedonya',''),(112,'Malavi',''),(113,'Malezya',''),(114,'Maldiv Adaları',''),(115,'Mali',''),(116,'Malta',''),(117,'Meksika',''),(118,'Mısır',''),(119,'Moldovya',''),(120,'Monako',''),(121,'Moritanya',''),(122,'Mozambik',''),(123,'Namibya',''),(124,'Nauru',''),(125,'Nepal',''),(126,'Nijer',''),(127,'Nijerya',''),(128,'Norveç',''),(129,'Orta Afrika Cumhuriyeti',''),(130,'Özbekistan',''),(131,'Pakistan',''),(132,'Panama',''),(133,'Papua - Yeni Gine',''),(134,'Paraguay',''),(135,'Peru',''),(136,'Polonya',''),(137,'Portekiz',''),(138,'Reunion',''),(139,'Romanya',''),(140,'Ruanda',''),(141,'Rusya',''),(142,'Samoa, Batı',''),(143,'Samoa, Doğu',''),(144,'Sao Tome & Principe',''),(145,'Senegal',''),(146,'Seyşeller',''),(147,'Sırbistan & Karadağ',''),(148,'Sierra Leone',''),(149,'Singapur',''),(150,'Slovakya',''),(151,'Slovenya',''),(152,'Solomon Adaları',''),(153,'Somali',''),(154,'Sri Lanka',''),(155,'Surinam',''),(156,'Suriye',''),(157,'Suudi Arabistan',''),(158,'Svaziland',''),(159,'Şili',''),(160,'Tacikistan',''),(161,'Tanzanya',''),(162,'Tayland',''),(163,'Tayvan',''),(164,'Togo',''),(165,'Tonga',''),(166,'Tunus',''),(167,'Tuvalu',''),(168,'Türkiye','TR'),(169,'Türkmenistan',''),(170,'Uganda',''),(171,'Ukrayna',''),(172,'Umman',''),(173,'Uruguay',''),(174,'Ürdün',''),(175,'Venezuela',''),(176,'Vietnam',''),(177,'Yemen',''),(178,'Yeni Kaledonya',''),(179,'Yeni Zelanda',''),(180,'Yugoslavya',''),(181,'Yunanistan',''),(182,'Zaire',''),(183,'Zambiya',''),(184,'Zimbabve',''); /*Table structure for table `fb_configuration` */ DROP TABLE IF EXISTS `fb_configuration`; CREATE TABLE `fb_configuration` ( `id` tinyint(2) unsigned NOT NULL auto_increment, `config` varchar(20) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `key` (`config`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `fb_configuration` */ insert into `fb_configuration`(`id`,`config`,`value`) values (1,'kdv','18'); /*Table structure for table `fb_coupons` */ DROP TABLE IF EXISTS `fb_coupons`; CREATE TABLE `fb_coupons` ( `id` int(11) NOT NULL auto_increment, `code` varchar(16) collate utf8_turkish_ci NOT NULL, `till_valid` datetime NOT NULL, `type` enum('percentage','direct') collate utf8_turkish_ci NOT NULL, `amount` varchar(5) collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_coupons` */ /*Table structure for table `fb_customer_profiles` */ DROP TABLE IF EXISTS `fb_customer_profiles`; CREATE TABLE `fb_customer_profiles` ( `id` int(11) NOT NULL auto_increment, `ns1` varchar(32) collate utf8_turkish_ci NOT NULL, `ns2` varchar(32) collate utf8_turkish_ci NOT NULL, `customer_id` int(11) NOT NULL, `registrant_account` longtext collate utf8_turkish_ci NOT NULL, `admin_contact_account` longtext collate utf8_turkish_ci NOT NULL, `technical_contact_account` longtext collate utf8_turkish_ci NOT NULL, `billing_contact_account` longtext collate utf8_turkish_ci NOT NULL, `status` enum('1','0') collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_customer_profiles` */ /*Table structure for table `fb_customers` */ DROP TABLE IF EXISTS `fb_customers`; CREATE TABLE `fb_customers` ( `id` int(11) NOT NULL auto_increment, `username` varchar(64) collate utf8_turkish_ci NOT NULL, `password` varchar(64) collate utf8_turkish_ci NOT NULL, `email` varchar(64) collate utf8_turkish_ci NOT NULL, `first_name` varchar(16) collate utf8_turkish_ci NOT NULL, `last_name` varchar(16) collate utf8_turkish_ci NOT NULL, `adres` text collate utf8_turkish_ci NOT NULL, `phone` varchar(16) collate utf8_turkish_ci default NULL, `phone_gsm` varchar(16) collate utf8_turkish_ci default NULL, `fax` varchar(16) collate utf8_turkish_ci default NULL, `registration_date` datetime NOT NULL, `status` enum('active','passive') collate utf8_turkish_ci NOT NULL, `verify_hash` char(32) collate utf8_turkish_ci NOT NULL, `reset_hash` char(32) collate utf8_turkish_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AVG_ROW_LENGTH=131; /*Data for the table `fb_customers` */ insert into `fb_customers`(`id`,`username`,`password`,`email`,`first_name`,`last_name`,`adres`,`phone`,`phone_gsm`,`fax`,`registration_date`,`status`,`verify_hash`,`reset_hash`) values (27,'admin','200820e3227815ed1756a6b531e7e0d2','mrlmz@hotmail.com','omer','olmez','adres','(222) 222-22-22','(222) 222-22-22','(111) 111-11-11','0000-00-00 00:00:00','active','',NULL),(28,'tugrul','200820e3227815ed1756a6b531e7e0d2','duran.tugrul@gmail.com','Tuğrul','Duran','PK 766. Lefkoşa\nKKTC\nMersin 10','+90.392 223-7688','+90.533 868-9029','+90.392 223-7699','2009-12-23 16:19:20','active','6a5bac0ccc60294a2bb916c5d377bd60','728aca4a1b4361016e5b59ef5b1e0e57'),(29,'ispirto','e10adc3949ba59abbe56e057f20f883e','info@oktaykilic.com','Oktay','Kılıç','',NULL,NULL,NULL,'2009-12-23 17:40:53','active','72f6fc4ba6af05c9ac06ca55f90a50a7',NULL),(41,'onuronuk','162d4a168efc0bf025bec759003336e9','onur_onuk@hotmail.com','onur','onuk','',NULL,NULL,NULL,'2009-12-26 12:14:55','active','21ea13f2d975c0ff589eab6b2156e422','e02df624a893cd24aa284ae66af2039a'),(42,'onur','e10adc3949ba59abbe56e057f20f883e','onuronuk@gmail.com','onur','onuk','',NULL,NULL,NULL,'2009-12-26 12:22:55','active','ac86f8bcc57d4e3a4fba8bd26a169d80','75b8c612cfda6c919a23b9df15d688b9'),(44,'bukowski','25d55ad283aa400af464c76d713c07ad','oktay@fikir.com.tr','Oktay','Kılıç','',NULL,NULL,NULL,'2009-12-29 16:35:02','active','8f57ec86ca77a89720a56333ab06426b',NULL),(45,'ozan','3b719480d31ec7532c8e5d6c3ef1b4b0','legendary-@windowslive.com','Ozan','ONUK','',NULL,NULL,NULL,'2010-01-27 23:29:54','active','3bddb1f83d67261878d505edabf6e54d','267bf78313cc40387db9fa61f0925e9e'); /*Table structure for table `fb_dns` */ DROP TABLE IF EXISTS `fb_dns`; CREATE TABLE `fb_dns` ( `id` int(10) unsigned NOT NULL auto_increment, `domain` varchar(200) NOT NULL, `host` varchar(30) NOT NULL, `type` enum('a','ptr','ns','mx','cname','txt','srv') NOT NULL, `value` tinytext NOT NULL, `mxparam` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*Data for the table `fb_dns` */ /*Table structure for table `fb_hosting_categories` */ DROP TABLE IF EXISTS `fb_hosting_categories`; CREATE TABLE `fb_hosting_categories` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `cat_name` varchar(30) default NULL, `desc` mediumtext, `platform` enum('Linux','Windows') default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*Data for the table `fb_hosting_categories` */ insert into `fb_hosting_categories`(`id`,`cat_name`,`desc`,`platform`) values (1,'Bireysel Çözümler','Küçük ihtiyaçlarınız için Bireysel Web Hosting ile ister Windows ister Linux platformları üzerinde hizmetimizden yararlanabilirsiniz.','Linux'),(3,'Kurumsal Çözümler','Orta ve büyük ihtiyaçlarınız için Kurumsal Web Hosting ile ister Windows ister Linux platformları üzerinde hizmetimizden yararlanabilirsiniz.','Linux'),(5,'Bayi Çözümleri','Bayi paketimiz birden fazla alan adı barındıran, hem Windows 2003 hem de Linux tabanlı web hosting ihtiyaçlarını tek bir kontrol panel üzerinden sorunsuz sağlamak isteyen kullanıcılar için hazırladığımız bir ürünümüzdür.','Linux'); /*Table structure for table `fb_hosting_details` */ DROP TABLE IF EXISTS `fb_hosting_details`; CREATE TABLE `fb_hosting_details` ( `id` smallint(6) NOT NULL auto_increment, `package_id` smallint(6) default NULL, `platform` enum('l','w') default NULL, `disk_space` smallint(6) unsigned NOT NULL, `traffic` smallint(6) unsigned NOT NULL, `pop3` tinyint(4) unsigned NOT NULL, `db` tinyint(4) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*Data for the table `fb_hosting_details` */ insert into `fb_hosting_details`(`id`,`package_id`,`platform`,`disk_space`,`traffic`,`pop3`,`db`) values (1,4,'l',100,100,1,1),(2,5,'l',200,500,3,1),(3,6,'l',500,1500,10,2),(4,7,'l',1500,5000,100,3); /*Table structure for table `fb_hosting_packages` */ DROP TABLE IF EXISTS `fb_hosting_packages`; CREATE TABLE `fb_hosting_packages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(64) collate utf8_turkish_ci NOT NULL, `category` tinyint(4) NOT NULL default '0', `price_1` double(5,2) NOT NULL, `price_3` double(5,2) NOT NULL, `price_6` double(5,2) NOT NULL, `price_12` double(5,2) NOT NULL, `platform` enum('Windows','Linux') collate utf8_turkish_ci NOT NULL, `details` text collate utf8_turkish_ci NOT NULL, `package_code` varchar(10) collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AVG_ROW_LENGTH=57; /*Data for the table `fb_hosting_packages` */ insert into `fb_hosting_packages`(`id`,`name`,`category`,`price_1`,`price_3`,`price_6`,`price_12`,`platform`,`details`,`package_code`) values (4,'Eko Paket',1,2.00,6.00,12.00,20.00,'Linux','{\"platform\":\"linux\",\"disk_space\":\"100\",\"traffic\":\"1000\",\"pop3\":\"1\",\"db\":\"1\"}','bronz'),(5,'Standart Paket',1,3.00,9.00,18.00,30.00,'Linux','{\"platform\":\"linux\",\"disk_space\":\"250\",\"traffic\":\"3000\",\"pop3\":\"3\",\"db\":\"1\"}',''),(6,'Profesyonel Paket',1,4.00,12.00,20.00,40.00,'Windows','{\"platform\":\"linux\",\"disk_space\":\"100\",\"traffic\":\"1000\",\"pop3\":\"1\",\"db\":\"1\"}',''),(7,'Extra Paket',1,5.00,15.00,30.00,50.00,'Linux','{\"platform\":\"linux\",\"disk_space\":\"1000\",\"traffic\":\"10000\",\"pop3\":\"10\",\"db\":\"2\"}',''); /*Table structure for table `fb_hosting_usernames` */ DROP TABLE IF EXISTS `fb_hosting_usernames`; CREATE TABLE `fb_hosting_usernames` ( `id` int(10) unsigned NOT NULL auto_increment, `customer_id` int(11) NOT NULL, `username` varchar(8) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*Data for the table `fb_hosting_usernames` */ insert into `fb_hosting_usernames`(`id`,`customer_id`,`username`) values (1,28,'tugrulor'),(2,28,'tugrul01'),(3,28,'tugrul02'),(4,28,'tugrul03'),(5,28,'tugrul04'),(6,28,'tugrul05'),(7,28,'tugrul06'),(8,28,'tugrul07'),(9,28,'tugrul08'),(10,28,'tugrul09'),(11,28,'tugrul10'),(12,28,'tugrul11'),(13,28,'tugrulco'),(14,28,'tugrulne'),(15,28,'denemece'),(16,28,'deneme01'),(17,28,'deneme02'),(18,28,'deneme03'),(19,28,'deneme04'),(20,28,'deneme05'),(21,28,'yenidoma'),(22,28,'yenido01'); /*Table structure for table `fb_inttrans` */ DROP TABLE IF EXISTS `fb_inttrans`; CREATE TABLE `fb_inttrans` ( `id` smallint(5) unsigned NOT NULL auto_increment, `domain` varchar(200) NOT NULL, `from` mediumint(8) unsigned NOT NULL, `to` mediumint(8) unsigned NOT NULL, `code` varchar(20) NOT NULL, `status` tinyint(1) NOT NULL default '0', `request_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*Data for the table `fb_inttrans` */ insert into `fb_inttrans`(`id`,`domain`,`from`,`to`,`code`,`status`,`request_date`) values (1,'sontestler-10.org',28,28,'NZJ2IZ918V',1,'0000-00-00 00:00:00'),(2,'tugrultest-11.org',28,28,'UVOIO4QX0R',1,'2010-02-14 15:09:55'),(3,'sontestler-10.org',28,41,'6UPVUYDJCQ',1,'2010-02-14 15:32:39'),(4,'tugrultest-11.org',28,41,'KVJ91IQT31',1,'2010-02-14 15:47:00'),(5,'sontestler-10.org',41,28,'KQC2C3MIZC',1,'2010-02-14 15:52:14'),(6,'tugrultest-13.org',28,41,'4F0HHKGJRS',1,'2010-02-14 15:54:12'); /*Table structure for table `fb_orders` */ DROP TABLE IF EXISTS `fb_orders`; CREATE TABLE `fb_orders` ( `id` int(11) NOT NULL auto_increment, `customer_id` int(11) unsigned NOT NULL, `order_details` text NOT NULL, `payment_details` text NOT NULL, `price` double(6,2) unsigned NOT NULL, `billing_profile` int(11) unsigned NOT NULL, `order_time` datetime NOT NULL, `order_ip` varchar(20) NOT NULL, `order_status` tinyint(1) NOT NULL, `payment_status` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=utf8; /*Data for the table `fb_orders` */ insert into `fb_orders`(`id`,`customer_id`,`order_details`,`payment_details`,`price`,`billing_profile`,`order_time`,`order_ip`,`order_status`,`payment_status`) values (1,28,'{\"domain\":[{\"domain\":\"denemedomaini.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"deneme.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"h\",\"account\":\"1\"}',30.00,1,'2010-02-08 17:20:35','127.0.0.1',0,0),(2,28,'{\"domain\":[{\"domain\":\"denemedomaini.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-09 09:39:08','127.0.0.1',1,1),(3,28,'{\"domain\":[{\"domain\":\"denemedomaini.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini2.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini2.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"denemedomaini2.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini23.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini23.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini23.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":2}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',140.00,1,'2010-02-10 10:20:45','127.0.0.1',1,1),(4,28,'{\"domain\":[{\"domain\":\"ukafgkasfg.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"ukafgkasfg.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"ukafgkasfg.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',90.00,1,'2010-02-10 10:34:14','127.0.0.1',1,1),(5,28,'{\"domain\":[{\"domain\":\"denemedomaini4.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"denemedomaini4.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"denemedomaini4.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":4}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',100.00,1,'2010-02-10 10:37:33','127.0.0.1',1,1),(6,28,'{\"domain\":[{\"domain\":\"test001.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3},{\"domain\":\"test002.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"test002.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',90.00,1,'2010-02-10 10:41:09','127.0.0.1',1,1),(7,28,'{\"domain\":[{\"domain\":\"tugrultest1.org\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":2},{\"domain\":\"tugrultest1.net\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3},{\"domain\":\"tugrultest1.com\",\"private\":\"0\",\"wp\":\"1\",\"ns1\":\"ns1.tier6.org\",\"ns2\":\"ns2.tier6.org\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',100.00,1,'2010-02-10 10:44:50','127.0.0.1',1,1),(8,28,'{\"domain\":[{\"domain\":\"tugrultest-1.net\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":2},{\"domain\":\"tugrultest-1.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":1},{\"domain\":\"tugrultest-1.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',80.00,1,'2010-02-10 12:07:13','127.0.0.1',1,1),(9,28,'{\"domain\":[{\"domain\":\"tugrultest-2.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"tugrultest-2.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"tugrultest-2.net\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',90.00,1,'2010-02-10 13:07:15','127.0.0.1',1,1),(10,28,'{\"domain\":[{\"domain\":\"tugrultest-2.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"tugrultest-2.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5},{\"domain\":\"tugrultest-2.net\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',90.00,1,'2010-02-10 13:09:08','127.0.0.1',1,1),(11,28,'{\"domain\":[{\"domain\":\"tugrultest-3.net\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',30.00,1,'2010-02-10 13:44:45','127.0.0.1',1,1),(12,28,'{\"domain\":[{\"domain\":\"tugrultest-5.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 14:35:17','127.0.0.1',1,1),(13,28,'{\"domain\":[{\"domain\":\"sontestler-1.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"sontestler-1.net\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"sontestler-1.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":5}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',70.00,1,'2010-02-10 15:48:37','127.0.0.1',1,1),(14,28,'{\"domain\":[{\"domain\":\"sontestler-2.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":3}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',30.00,1,'2010-02-10 15:52:35','127.0.0.1',1,1),(15,28,'{\"domain\":[{\"domain\":\"sontestler-3.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 15:54:12','127.0.0.1',1,1),(16,28,'{\"domain\":[{\"domain\":\"sontestler-4.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 15:55:51','127.0.0.1',1,1),(17,28,'{\"domain\":[{\"domain\":\"sontestler-5.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"},{\"domain\":\"sontestler-5.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',20.00,1,'2010-02-10 15:57:03','127.0.0.1',1,1),(18,28,'{\"domain\":[{\"domain\":\"sontestler-6.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 15:58:45','127.0.0.1',1,1),(19,28,'{\"domain\":[{\"domain\":\"sontestler-7.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 16:00:13','127.0.0.1',1,1),(20,28,'{\"domain\":[{\"domain\":\"sontestler-8.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 16:02:09','127.0.0.1',1,1),(21,28,'{\"domain\":[{\"domain\":\"sontestler-9.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 16:03:24','127.0.0.1',1,1),(22,28,'{\"domain\":[{\"domain\":\"sontestler-10.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-10 16:06:21','127.0.0.1',1,1),(23,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"JqG7WKVSVz\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"platform\":\"Linux\",\"period\":\"6\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 19:45:10','127.0.0.1',1,1),(24,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"kPCtg5Jprm\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"512\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 19:51:30','127.0.0.1',1,1),(25,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"cd7j7fqV11\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 19:53:30','127.0.0.1',1,1),(26,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"rim2IR50JG\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 19:59:00','127.0.0.1',1,1),(27,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"pastora\",\"host\":\"__auto\",\"ns1\":\"__auto\",\"ns2\":\"__auto\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"h\",\"account\":\"1\"}',0.00,1,'2010-02-10 20:12:11','217.131.133.73',0,0),(28,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"hedehodo\",\"host\":\"__auto\",\"ns1\":\"__auto\",\"ns2\":\"__auto\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 20:18:09','217.131.133.73',1,1),(29,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"6X5eb69vwF\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 20:32:21','127.0.0.1',1,1),(30,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 20:36:12','127.0.0.1',1,1),(31,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 20:38:50','127.0.0.1',1,1),(32,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-10 20:40:15','127.0.0.1',1,1),(33,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"3\"}],\"domainpriv\":[{\"domain\":\"sontestler-10.org\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:08:36','127.0.0.1',1,1),(34,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:08:38','127.0.0.1',1,1),(35,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:14:36','127.0.0.1',1,1),(36,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:17:46','127.0.0.1',1,1),(37,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:18:09','127.0.0.1',1,1),(38,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:18:14','127.0.0.1',1,1),(39,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:18:52','127.0.0.1',1,1),(40,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:20:21','127.0.0.1',1,1),(41,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:21:07','127.0.0.1',1,1),(42,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:21:20','127.0.0.1',1,1),(43,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:23:37','127.0.0.1',1,1),(44,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 14:36:37','127.0.0.1',1,1),(45,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"sontestler-10.org\",\"year\":\"3\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 15:22:06','127.0.0.1',1,1),(46,28,'{\"domain\":[{\"domain\":\"tugrultest-11.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-11 15:25:12','127.0.0.1',1,1),(47,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[{\"domain\":\"tugrultest-11.org\",\"year\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-11 15:26:17','127.0.0.1',1,1),(48,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"sontestler-10.org\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-11 15:28:33','127.0.0.1',1,1),(49,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"tugrultest-11.org\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:08:13','127.0.0.1',1,1),(50,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"tugrultest-12.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:11:54','127.0.0.1',1,1),(51,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"tugrul.org\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:49:30','127.0.0.1',1,1),(52,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"test1.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:51:44','127.0.0.1',1,1),(53,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"deneme01.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:52:09','127.0.0.1',1,1),(54,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"deneme03.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 09:52:27','127.0.0.1',1,1),(55,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"deneme04.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-13 10:57:04','127.0.0.1',1,1),(56,28,'{\"domain\":[{\"domain\":\"tugrultest-12.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-13 11:02:03','127.0.0.1',1,1),(57,28,'{\"domain\":[{\"domain\":\"tugrultest-13.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-13 11:15:06','127.0.0.1',1,1),(58,28,'{\"domain\":[{\"domain\":\"havaletest.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"h\",\"account\":\"1\"}',10.00,1,'2010-02-13 11:52:13','127.0.0.1',0,0),(59,28,'{\"domain\":[{\"domain\":\"denemedomaini.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-13 16:12:41','127.0.0.1',1,1),(60,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-13 23:01:00','92.63.1.17',1,1),(61,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-13 23:08:59','92.63.1.17',1,1),(62,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-13 23:23:20','92.63.1.17',1,1),(63,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-13 23:51:35','92.63.1.17',1,1),(64,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-14 00:30:12','92.63.1.17',1,1),(65,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"win2003\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-14 00:38:26','92.63.1.17',1,1),(66,28,'{\"domain\":[{\"domain\":\"tugrul.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 12:36:30','127.0.0.1',1,1),(67,28,'{\"domain\":[{\"domain\":\"tugrul.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"32HF4K1J2F34J1234\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 13:00:13','127.0.0.1',1,1),(68,28,'{\"domain\":[{\"domain\":\"asd.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transhelp\":\"1\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 13:07:51','127.0.0.1',1,1),(69,28,'{\"domain\":[{\"domain\":\"tugrul.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"UTF32T4YF1234T\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 13:08:23','127.0.0.1',1,1),(70,28,'{\"domain\":[{\"domain\":\"bilimvefelsefemetinleri.net\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"F32HD412D34F12D34\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 13:10:20','127.0.0.1',1,1),(71,28,'{\"domain\":[{\"domain\":\"onuronuk.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"h\",\"account\":\"1\"}',10.00,1,'2010-02-14 21:53:41','89.149.228.190',0,0),(72,28,'{\"domain\":[{\"domain\":\"onuronuk.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 21:57:40','89.149.228.190',1,1),(73,28,'{\"domain\":[{\"domain\":\"onuronuk.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',10.00,1,'2010-02-14 22:01:24','89.149.228.190',1,1),(74,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-15 00:25:52','92.63.1.17',1,1),(75,28,'{\"domain\":[],\"hosting\":[],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[],\"vps\":[{\"package\":\"1\",\"rootPass\":\"yenisifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',0.00,1,'2010-02-15 00:59:48','92.63.1.17',1,1),(76,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"tugrultest-11.org\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-15 16:08:26','127.0.0.1',1,1),(77,28,'{\"domain\":[],\"hosting\":[{\"package\":\"4\",\"domain\":\"yenidomain.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',2.00,1,'2010-02-15 16:09:15','127.0.0.1',1,1),(78,28,'{\"domain\":[],\"hosting\":[{\"package\":\"5\",\"domain\":\"yenidomain.com\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',3.00,1,'2010-02-15 16:09:50','127.0.0.1',1,1),(79,28,'{\"domain\":[],\"hosting\":[{\"package\":\"5\",\"domain\":\"yenidomain.net\",\"platform\":\"Linux\",\"period\":\"1\"}],\"ssl\":[],\"domainpriv\":[],\"domainrenew\":[]}','{\"payment_type\":\"k\",\"name\":\"\",\"type\":\"1\",\"number\":\"\",\"cvv\":\"\",\"expdate\":\"1/09\"}',3.00,1,'2010-02-15 16:10:14','127.0.0.1',1,1); /*Table structure for table `fb_payments` */ DROP TABLE IF EXISTS `fb_payments`; CREATE TABLE `fb_payments` ( `id` int(11) NOT NULL auto_increment, `order_id` int(2) unsigned NOT NULL, `customer_id` int(11) unsigned NOT NULL, `type` enum('k','h','p') collate utf8_turkish_ci NOT NULL COMMENT 'kredi karti / havale / paypal', `amount` varchar(5) collate utf8_turkish_ci NOT NULL, `discount` varchar(5) collate utf8_turkish_ci NOT NULL, `coupon_id` int(11) NOT NULL, `tax` varchar(5) collate utf8_turkish_ci NOT NULL, `total_amount` varchar(5) collate utf8_turkish_ci NOT NULL, `date` datetime NOT NULL, `member_id` int(11) NOT NULL, `status` int(1) NOT NULL, `details` longtext collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_payments` */ insert into `fb_payments`(`id`,`order_id`,`customer_id`,`type`,`amount`,`discount`,`coupon_id`,`tax`,`total_amount`,`date`,`member_id`,`status`,`details`) values (1,1,28,'h','30','',0,'18','','2010-02-08 17:20:35',0,0,''),(2,2,28,'k','10','',0,'18','','2010-02-09 09:39:08',0,1,''),(3,3,28,'k','140','',0,'18','','2010-02-10 10:20:45',0,1,''),(4,4,28,'k','90','',0,'18','','2010-02-10 10:34:14',0,1,''),(5,5,28,'k','100','',0,'18','','2010-02-10 10:37:33',0,1,''),(6,6,28,'k','90','',0,'18','','2010-02-10 10:41:09',0,1,''),(7,7,28,'k','100','',0,'18','','2010-02-10 10:44:50',0,1,''),(8,8,28,'k','80','',0,'18','','2010-02-10 12:07:13',0,1,''),(9,9,28,'k','90','',0,'18','','2010-02-10 13:07:15',0,1,''),(10,10,28,'k','90','',0,'18','','2010-02-10 13:09:08',0,1,''),(11,11,28,'k','30','',0,'18','','2010-02-10 13:44:45',0,1,''),(12,12,28,'k','10','',0,'18','','2010-02-10 14:35:17',0,1,''),(13,13,28,'k','70','',0,'18','','2010-02-10 15:48:37',0,1,''),(14,14,28,'k','30','',0,'18','','2010-02-10 15:52:35',0,1,''),(15,15,28,'k','10','',0,'18','','2010-02-10 15:54:12',0,1,''),(16,16,28,'k','10','',0,'18','','2010-02-10 15:55:51',0,1,''),(17,17,28,'k','20','',0,'18','','2010-02-10 15:57:03',0,1,''),(18,18,28,'k','10','',0,'18','','2010-02-10 15:58:45',0,1,''),(19,19,28,'k','10','',0,'18','','2010-02-10 16:00:13',0,1,''),(20,20,28,'k','10','',0,'18','','2010-02-10 16:02:10',0,1,''),(21,21,28,'k','10','',0,'18','','2010-02-10 16:03:24',0,1,''),(22,22,28,'k','10','',0,'18','','2010-02-10 16:06:22',0,1,''),(23,23,28,'k','0','',0,'18','','2010-02-10 19:45:10',0,1,''),(24,24,28,'k','0','',0,'18','','2010-02-10 19:51:30',0,1,''),(25,25,28,'k','0','',0,'18','','2010-02-10 19:53:30',0,1,''),(26,26,28,'k','0','',0,'18','','2010-02-10 19:59:00',0,1,''),(27,27,28,'h','0','',0,'18','','2010-02-10 20:12:11',0,0,''),(28,28,28,'k','0','',0,'18','','2010-02-10 20:18:09',0,1,''),(29,29,28,'k','0','',0,'18','','2010-02-10 20:32:21',0,1,''),(30,30,28,'k','0','',0,'18','','2010-02-10 20:36:12',0,1,''),(31,31,28,'k','0','',0,'18','','2010-02-10 20:38:50',0,1,''),(32,32,28,'k','0','',0,'18','','2010-02-10 20:40:15',0,1,''),(33,33,28,'k','0','',0,'18','','2010-02-11 14:08:36',0,1,''),(34,34,28,'k','0','',0,'18','','2010-02-11 14:08:38',0,1,''),(35,35,28,'k','0','',0,'18','','2010-02-11 14:14:36',0,1,''),(36,36,28,'k','0','',0,'18','','2010-02-11 14:17:46',0,1,''),(37,37,28,'k','0','',0,'18','','2010-02-11 14:18:09',0,1,''),(38,38,28,'k','0','',0,'18','','2010-02-11 14:18:14',0,1,''),(39,39,28,'k','0','',0,'18','','2010-02-11 14:18:52',0,1,''),(40,40,28,'k','0','',0,'18','','2010-02-11 14:20:21',0,1,''),(41,41,28,'k','0','',0,'18','','2010-02-11 14:21:07',0,1,''),(42,42,28,'k','0','',0,'18','','2010-02-11 14:21:20',0,1,''),(43,43,28,'k','0','',0,'18','','2010-02-11 14:23:37',0,1,''),(44,44,28,'k','0','',0,'18','','2010-02-11 14:36:37',0,1,''),(45,45,28,'k','0','',0,'18','','2010-02-11 15:22:06',0,1,''),(46,46,28,'k','10','',0,'18','','2010-02-11 15:25:12',0,1,''),(47,47,28,'k','0','',0,'18','','2010-02-11 15:26:17',0,1,''),(48,48,28,'k','2','',0,'18','','2010-02-11 15:28:33',0,1,''),(49,49,28,'k','2','',0,'18','','2010-02-13 09:08:13',0,1,''),(50,50,28,'k','2','',0,'18','','2010-02-13 09:11:54',0,1,''),(51,51,28,'k','2','',0,'18','','2010-02-13 09:49:30',0,1,''),(52,52,28,'k','2','',0,'18','','2010-02-13 09:51:44',0,1,''),(53,53,28,'k','2','',0,'18','','2010-02-13 09:52:09',0,1,''),(54,54,28,'k','2','',0,'18','','2010-02-13 09:52:27',0,1,''),(55,55,28,'k','2','',0,'18','','2010-02-13 10:57:04',0,1,''),(56,56,28,'k','10','',0,'18','','2010-02-13 11:02:03',0,1,''),(57,57,28,'k','10','',0,'18','','2010-02-13 11:15:06',0,1,''),(58,58,28,'h','10','',0,'18','','2010-02-13 11:52:13',0,0,''),(59,59,28,'k','10','',0,'18','','2010-02-13 16:12:41',0,1,''),(60,60,28,'k','0','',0,'18','','2010-02-13 23:01:00',0,1,''),(61,61,28,'k','0','',0,'18','','2010-02-13 23:08:59',0,1,''),(62,62,28,'k','0','',0,'18','','2010-02-13 23:23:20',0,1,''),(63,63,28,'k','0','',0,'18','','2010-02-13 23:51:35',0,1,''),(64,64,28,'k','0','',0,'18','','2010-02-14 00:30:12',0,1,''),(65,65,28,'k','0','',0,'18','','2010-02-14 00:38:26',0,1,''),(66,66,28,'k','10','',0,'18','','2010-02-14 12:36:30',0,1,''),(67,67,28,'k','10','',0,'18','','2010-02-14 13:00:13',0,1,''),(68,68,28,'k','10','',0,'18','','2010-02-14 13:07:51',0,1,''),(69,69,28,'k','10','',0,'18','','2010-02-14 13:08:23',0,1,''),(70,70,28,'k','10','',0,'18','','2010-02-14 13:10:20',0,1,''),(71,71,28,'h','15.13','',0,'18','','2010-02-14 21:53:41',0,0,''),(72,72,28,'k','15.13','',0,'18','','2010-02-14 21:57:40',0,1,''),(73,73,28,'k','15.13','',0,'18','','2010-02-14 22:01:24',0,1,''),(74,74,28,'k','0','',0,'18','','2010-02-15 00:25:52',0,1,''),(75,75,28,'k','0','',0,'18','','2010-02-15 00:59:48',0,1,''),(76,76,28,'k','3.03','',0,'18','','2010-02-15 16:08:26',0,1,''),(77,77,28,'k','3.03','',0,'18','','2010-02-15 16:09:15',0,1,''),(78,78,28,'k','4.54','',0,'18','','2010-02-15 16:09:50',0,1,''),(79,79,28,'k','4.54','',0,'18','','2010-02-15 16:10:14',0,1,''); /*Table structure for table `fb_registrars` */ DROP TABLE IF EXISTS `fb_registrars`; CREATE TABLE `fb_registrars` ( `id` int(11) NOT NULL auto_increment, `name` varchar(16) collate utf8_turkish_ci NOT NULL, `code` varchar(16) collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_registrars` */ /*Table structure for table `fb_servers` */ DROP TABLE IF EXISTS `fb_servers`; CREATE TABLE `fb_servers` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) collate utf8_turkish_ci NOT NULL, `ip` varchar(20) collate utf8_turkish_ci NOT NULL, `ns1` varchar(32) collate utf8_turkish_ci NOT NULL, `ns2` varchar(32) collate utf8_turkish_ci NOT NULL, `platform` enum('windows','linux') collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_servers` */ /*Table structure for table `fb_services` */ DROP TABLE IF EXISTS `fb_services`; CREATE TABLE `fb_services` ( `id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL, `type` enum('domain','hosting','ssl','server','vps') NOT NULL, `domain` varchar(100) NOT NULL, `details` longtext character set utf8 collate utf8_turkish_ci NOT NULL, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `package_id` int(11) NOT NULL, `domain_owned` enum('local','remote') character set utf8 collate utf8_turkish_ci NOT NULL, `payment_cycle` int(12) NOT NULL, `status` enum('aktif','pasif') character set utf8 collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`), KEY `member_id` (`customer_id`,`package_id`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=104; /*Data for the table `fb_services` */ insert into `fb_services`(`id`,`customer_id`,`type`,`domain`,`details`,`start_date`,`end_date`,`package_id`,`domain_owned`,`payment_cycle`,`status`) values (14,28,'domain','tugrultest-13.org','{\"domain\":\"tugrultest-13.org\",\"whois_profile\":\"2\",\"locked\":1,\"auto_renew\":1,\"private\":\"0\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"pw\":\"a4c869591b\"}','2010-02-13 11:15:24','2011-02-13 11:15:24',0,'local',0,'aktif'),(11,28,'domain','deneme04.com','','2010-02-13 10:57:12','0000-00-00 00:00:00',0,'remote',0,'aktif'),(12,28,'hosting','deneme04.com','{\"domain\":\"deneme04.com\",\"package\":\"4\"}','2010-02-13 10:57:12','2010-03-13 10:57:12',0,'local',0,'aktif'),(13,28,'domain','tugrultest-12.org','{\"domain\":\"tugrultest-12.org\",\"whois_profile\":\"2\",\"locked\":0,\"auto_renew\":1,\"private\":\"0\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"pw\":\"b8baef657a\"}','2010-02-13 11:02:19','2011-02-13 11:02:19',0,'local',0,'aktif'),(9,28,'hosting','tugrul.org','{\"domain\":\"tugrul.org\",\"package\":\"4\"}','2010-02-13 09:49:35','0000-00-00 00:00:00',0,'local',0,'aktif'),(10,28,'hosting','deneme03.com','{\"domain\":\"deneme03.com\",\"package\":\"4\"}','2010-02-13 09:52:31','2010-03-13 09:52:31',0,'local',0,'aktif'),(8,28,'domain','tugrultest-11.org','{\"domain\":\"tugrultest-11.org\",\"whois_profile\":\"2\",\"locked\":1,\"auto_renew\":1,\"private\":\"0\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"pw\":\"58e6c892c0\"}','2010-02-11 15:25:26','2012-02-11 15:25:26',0,'local',0,'aktif'),(7,28,'domain','sontestler-10.org','{\"domain\":\"sontestler-10.org\",\"whois_profile\":\"1\",\"locked\":0,\"auto_renew\":1,\"private\":\"0\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"pw\":\"c076a73776\",\"wp\":\"1\"}','2010-02-10 16:06:42','2011-02-10 16:06:42',0,'local',0,'aktif'),(17,28,'domain','onuronuk.org','{\"domain\":\"onuronuk.org\",\"whois_profile\":\"2\",\"locked\":0,\"auto_renew\":1,\"private\":\"0\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"pw\":\"d627c0dca5\"}','2010-02-14 22:02:05','2011-02-14 22:02:05',0,'local',0,'aktif'),(16,28,'vps','192.168.1.211','{\"vps_id\":12,\"period\":1}','2010-02-14 00:40:47','2010-03-14 00:40:47',0,'local',0,'aktif'),(18,28,'vps','192.168.1.212','{\"vps_id\":13,\"period\":1}','2010-02-15 00:27:07','2010-03-15 00:27:07',0,'local',0,'aktif'),(19,28,'vps','192.168.1.213','{\"vps_id\":14,\"period\":1}','2010-02-15 01:01:11','2010-03-15 01:01:11',0,'local',0,'aktif'),(20,28,'hosting','tugrul.org','[]','2010-02-15 15:48:06','2010-03-15 15:48:06',0,'local',0,'aktif'),(21,28,'hosting','tugrul.org','{\"username\":\"tugrul02\"}','2010-02-15 15:48:49','2010-03-15 15:48:49',0,'local',0,'aktif'),(22,28,'hosting','tugrul.org','{\"username\":\"tugrul02\"}','2010-02-15 15:48:51','2010-03-15 15:48:51',0,'local',0,'aktif'),(23,28,'hosting','tugrul.org','{\"username\":\"tugrul02\"}','2010-02-15 15:49:05','2010-03-15 15:49:05',0,'local',0,'aktif'),(24,28,'hosting','tugrul.org','{\"username\":\"tugrul03\"}','2010-02-15 15:49:06','2010-03-15 15:49:06',0,'local',0,'aktif'),(25,28,'hosting','tugrul.org','{\"username\":\"tugrul04\"}','2010-02-15 15:49:06','2010-03-15 15:49:06',0,'local',0,'aktif'),(26,28,'hosting','tugrul.org','{\"username\":\"tugrul05\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(27,28,'hosting','tugrul.org','{\"username\":\"tugrul06\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(28,28,'hosting','tugrul.org','{\"username\":\"tugrul07\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(29,28,'hosting','tugrul.org','{\"username\":\"tugrul08\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(30,28,'hosting','tugrul.org','{\"username\":\"tugrul09\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(31,28,'hosting','tugrul.org','{\"username\":\"tugrul10\"}','2010-02-15 15:49:07','2010-03-15 15:49:07',0,'local',0,'aktif'),(32,28,'hosting','tugrul.org','{\"username\":\"tugrul11\"}','2010-02-15 15:49:26','2010-03-15 15:49:26',0,'local',0,'aktif'),(33,28,'hosting','tugrul.com','{\"username\":\"tugrulco\"}','2010-02-15 15:49:26','2010-03-15 15:49:26',0,'local',0,'aktif'),(34,28,'hosting','tugrul.net','{\"username\":\"tugrulne\"}','2010-02-15 15:49:26','2010-03-15 15:49:26',0,'local',0,'aktif'),(35,28,'hosting','denemece.org','{\"username\":\"denemece\"}','2010-02-15 15:49:54','2010-03-15 15:49:54',0,'local',0,'aktif'),(36,28,'hosting','denemece.com','{\"username\":\"deneme01\"}','2010-02-15 15:49:54','2010-03-15 15:49:54',0,'local',0,'aktif'),(37,28,'hosting','denemece.net','{\"username\":\"deneme02\"}','2010-02-15 15:49:54','2010-03-15 15:49:54',0,'local',0,'aktif'),(38,28,'hosting','denemece.org','{\"username\":\"deneme03\"}','2010-02-15 15:50:04','2010-03-15 15:50:04',0,'local',0,'aktif'),(39,28,'hosting','denemece.com','{\"username\":\"deneme04\"}','2010-02-15 15:50:04','2010-03-15 15:50:04',0,'local',0,'aktif'),(40,28,'hosting','denemece.net','{\"username\":\"deneme05\"}','2010-02-15 15:50:04','2010-03-15 15:50:04',0,'local',0,'aktif'),(41,28,'domain','yenidomain.com','','2010-02-15 16:09:22','0000-00-00 00:00:00',0,'remote',0,'aktif'),(42,28,'hosting','yenidomain.com','{\"domain\":\"yenidomain.com\",\"username\":\"yenidoma\",\"package\":\"4\"}','2010-02-15 16:09:22','2010-03-15 16:09:22',0,'local',0,'aktif'),(43,28,'domain','yenidomain.net','','2010-02-15 16:10:18','0000-00-00 00:00:00',0,'remote',0,'aktif'),(44,28,'hosting','yenidomain.net','{\"domain\":\"yenidomain.net\",\"username\":\"yenido01\",\"package\":\"5\"}','2010-02-15 16:10:18','2010-03-15 16:10:18',0,'local',0,'aktif'); /*Table structure for table `fb_ssl_packages` */ DROP TABLE IF EXISTS `fb_ssl_packages`; CREATE TABLE `fb_ssl_packages` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `name` varchar(30) default NULL, `details` mediumtext, `price` tinyint(1) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `fb_ssl_packages` */ insert into `fb_ssl_packages`(`id`,`name`,`details`,`price`) values (1,'Test SSL Package','hede hüdü\r\n',100),(2,'Test Pack 2','asodaskd\r\n',127); /*Table structure for table `fb_support` */ DROP TABLE IF EXISTS `fb_support`; CREATE TABLE `fb_support` ( `id` int(11) unsigned NOT NULL auto_increment, `ticketid` varchar(20) default NULL, `customer_id` mediumint(9) unsigned default NULL, `subject` varchar(50) default NULL, `department` tinyint(4) unsigned default NULL, `service` varchar(20) default NULL, `message` text, `status` tinyint(1) default '0', `attachments` varchar(20) default NULL, `timesent` datetime default NULL, `directory` smallint(6) unsigned default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=54; /*Data for the table `fb_support` */ insert into `fb_support`(`id`,`ticketid`,`customer_id`,`subject`,`department`,`service`,`message`,`status`,`attachments`,`timesent`,`directory`) values (1,'WEB.01-0001',28,'Hosting Paket Yükseltme',1,NULL,'Musteri ID: 28\nHosting ID: 12\nYeni Paket ID: 6',1,'','2010-02-14 23:04:49',0),(2,'WEB.01-0002',28,'Hosting Paket Yükseltme',1,NULL,'Musteri ID: 28\nHosting ID: 12\nYeni Paket ID: 6',2,'','2010-02-14 23:05:45',0),(3,'WEB.01-0003',28,'Hosting Paket Yükseltme',1,NULL,'Musteri ID: 28\nHosting ID: 9\nYeni Paket ID: 5',1,'','2010-02-14 23:14:41',0),(4,'WEB.01-0004',28,'Alan Adı Değişikliği',1,NULL,'Musteri ID: 28\nHosting ID: 12\nYeni Alan Adı: tugrul.org',1,'','2010-02-14 23:25:24',1),(5,'WEB.01-0005',28,'Hosting Hizmeti İptali',1,NULL,'Musteri ID: 28\nHosting ID: undefined',2,'','2010-02-14 23:50:23',0),(6,'WEB.01-0006',28,'Hosting Paket Yükseltme',1,NULL,'Musteri ID: 28\nHosting ID: 12\nYeni Paket ID: 5',1,'','2010-02-15 02:17:46',0),(15,'DIG.07-0001',28,'E-Posta Değişikliği',7,NULL,'Musteri ID: 28\nYeni mail: tugrul@tugrul.org',1,'','2010-02-15 17:07:33',0),(13,'WEB.01-0005',28,NULL,NULL,NULL,'asdasd',2,NULL,'2010-02-15 15:12:03',0),(14,'WEB.01-0005',28,NULL,NULL,NULL,'adfsadfasdf',2,NULL,'2010-02-15 15:12:46',0),(16,'DIG.07-0002',28,'E-Posta Değişikliği',7,NULL,'Musteri ID: 28\nYeni mail: tugrul@tugrul.org',1,'','2010-02-15 17:08:13',0); /*Table structure for table `fb_support_attachments` */ DROP TABLE IF EXISTS `fb_support_attachments`; CREATE TABLE `fb_support_attachments` ( `id` int(11) unsigned NOT NULL auto_increment, `supportid` int(11) unsigned default NULL, `mime` varchar(30) default NULL, `size` int(11) unsigned default NULL, `name` varchar(100) default NULL, `path` varchar(250) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*Data for the table `fb_support_attachments` */ /*Table structure for table `fb_support_departments` */ DROP TABLE IF EXISTS `fb_support_departments`; CREATE TABLE `fb_support_departments` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `name` varchar(30) default NULL, `head` tinyint(4) default NULL, `idPrefix` varchar(3) default NULL, `service_type` varchar(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `idPrefix` (`idPrefix`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=25; /*Data for the table `fb_support_departments` */ insert into `fb_support_departments`(`id`,`name`,`head`,`idPrefix`,`service_type`) values (1,'Web Hosting',2,'WEB','hosting'),(2,'VPS',2,'VPS','vps'),(3,'Dedicated Server',2,'DES','server'),(4,'Domain',2,'DOM','domain'),(5,'Muhasebe',3,'MUH',''),(6,'SSL',2,'SSL','ssl'),(7,'Diğer',3,'DIG',''); /*Table structure for table `fb_support_directories` */ DROP TABLE IF EXISTS `fb_support_directories`; CREATE TABLE `fb_support_directories` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` int(11) unsigned NOT NULL, `name` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*Data for the table `fb_support_directories` */ /*Table structure for table `fb_support_staff` */ DROP TABLE IF EXISTS `fb_support_staff`; CREATE TABLE `fb_support_staff` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `name` varchar(50) default NULL, `email` varchar(200) default NULL, `department` varchar(20) default NULL, `about` tinytext, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `fb_support_staff` */ insert into `fb_support_staff`(`id`,`name`,`email`,`department`,`about`) values (1,'Tuğrul Duran','duran.tugrul@gmail.com','1,2,3,4','Web programcısı'),(2,'Mehmet Köse','mehmet.kose@gmail.com','1,2,3,4','Sistem yöneticisi'),(3,'Oktay Kılıç','info@oktaykilic.com','1,2,3,4,5','O bir yönetici\r\nO bir programcı\r\nO bir tasarımcı\r\nO bir beyin\r\nO bir herşey'); /*Table structure for table `fb_system_crons` */ DROP TABLE IF EXISTS `fb_system_crons`; CREATE TABLE `fb_system_crons` ( `id` int(11) NOT NULL auto_increment, `customer_id` mediumint(9) unsigned NOT NULL, `process` varchar(100) collate utf8_turkish_ci NOT NULL, `start_time` datetime NOT NULL, `add_time` datetime NOT NULL, `details` text collate utf8_turkish_ci NOT NULL, `process_status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AVG_ROW_LENGTH=156; /*Data for the table `fb_system_crons` */ insert into `fb_system_crons`(`id`,`customer_id`,`process`,`start_time`,`add_time`,`details`,`process_status`) values (1,28,'vps:reboot','0000-00-00 00:00:00','2010-02-14 01:26:46','{\"vpsId\":\"12\"}',-1),(2,28,'vps:reboot','0000-00-00 00:00:00','2010-02-14 01:27:39','{\"vpsId\":\"12\"}',1),(3,28,'vps:destroy','0000-00-00 00:00:00','2010-02-14 01:47:57','{\"vpsId\":\"12\"}',1),(8,28,'domain:transfer','0000-00-00 00:00:00','2010-02-14 13:10:20','{\"domain\":\"denemedomaini.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"F32HD412D34F12D34\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',-5),(7,28,'domain:transfer','0000-00-00 00:00:00','2010-02-14 13:08:23','{\"domain\":\"tugrul.org\",\"private\":\"0\",\"wp\":\"0\",\"ns1\":\"\",\"ns2\":\"\",\"transfer\":\"1\",\"transcode\":\"UTF32T4YF1234T\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',-5),(9,28,'domain:unlock','0000-00-00 00:00:00','2010-02-14 13:10:45','{\"domain\":\"denemedomaini.org\"}',1),(10,28,'domain:inttrans','0000-00-00 00:00:00','2010-02-14 14:18:41','{\"domain\":\"sontestler-10.org\",\"code\":\"WTBJMZ63QC\",\"mail\":\"duran.tugrul@gmail.com\"}',0),(11,28,'domain:inttrans','0000-00-00 00:00:00','2010-02-14 14:21:20','{\"domain\":\"sontestler-10.org\",\"code\":\"KRKI4WKJTN\",\"mail\":\"asd\"}',0),(12,28,'domain:remove','0000-00-00 00:00:00','2010-02-14 21:33:44','{\"domain\":\"denemedomaini.org\"}',1),(13,28,'domain:remove','0000-00-00 00:00:00','2010-02-14 21:33:46','{\"domain\":\"denemedomaini.org\"}',-5),(14,28,'domain:remove','0000-00-00 00:00:00','2010-02-14 21:34:51','{\"domain\":\"denemedomaini.org\"}',-5),(15,28,'domain:remove','0000-00-00 00:00:00','2010-02-14 21:41:41','{\"domain\":\"sontestler-10.org\"}',-5),(16,28,'domain:unlock','0000-00-00 00:00:00','2010-02-14 21:45:28','{\"domain\":\"sontestler-10.org\"}',1),(17,28,'domain:lock','0000-00-00 00:00:00','2010-02-14 21:46:58','{\"domain\":\"sontestler-10.org\"}',1),(18,28,'domain:unlock','0000-00-00 00:00:00','2010-02-14 21:48:22','{\"domain\":\"sontestler-10.org\"}',1),(19,28,'domain:unlock','0000-00-00 00:00:00','2010-02-14 21:48:44','{\"domain\":\"sontestler-10.org\"}',-5),(20,28,'domain:create','0000-00-00 00:00:00','2010-02-14 21:57:40','{\"domain\":\"onuronuk.com\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',-5),(21,28,'domain:create','0000-00-00 00:00:00','2010-02-14 22:01:24','{\"domain\":\"onuronuk.org\",\"private\":\"0\",\"wp\":\"2\",\"ns1\":\"ns1.webizyum.com\",\"ns2\":\"ns2.webizyum.com\",\"transfer\":\"0\",\"arenew\":\"1\",\"locked\":\"1\",\"year\":\"1\"}',1),(22,28,'domain:unlock','0000-00-00 00:00:00','2010-02-14 22:03:02','{\"domain\":\"onuronuk.org\"}',1),(23,28,'domain:remove','0000-00-00 00:00:00','2010-02-14 22:04:52','{\"domain\":\"onuronuk.org\"}',-5),(24,28,'vps:create','0000-00-00 00:00:00','2010-02-15 00:25:52','{\"package\":\"1\",\"rootPass\":\"sifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}',1),(25,28,'vps:create','0000-00-00 00:00:00','2010-02-15 00:59:48','{\"package\":\"1\",\"rootPass\":\"yenisifre\",\"host\":\"\",\"ns1\":\"\",\"ns2\":\"\",\"system\":\"centos\",\"memory\":\"524288\",\"period\":\"1\"}',1),(26,28,'hosting:create','0000-00-00 00:00:00','2010-02-15 16:08:26','{\"package\":\"4\",\"domain\":\"tugrultest-11.org\",\"platform\":\"Linux\",\"period\":\"1\"}',-5),(27,28,'hosting:create','0000-00-00 00:00:00','2010-02-15 16:09:15','{\"package\":\"4\",\"domain\":\"yenidomain.com\",\"platform\":\"Linux\",\"period\":\"1\"}',1),(28,28,'hosting:create','0000-00-00 00:00:00','2010-02-15 16:09:50','{\"package\":\"5\",\"domain\":\"yenidomain.com\",\"platform\":\"Linux\",\"period\":\"1\"}',-5),(29,28,'hosting:create','0000-00-00 00:00:00','2010-02-15 16:10:14','{\"package\":\"5\",\"domain\":\"yenidomain.net\",\"platform\":\"Linux\",\"period\":\"1\"}',1); /*Table structure for table `fb_tlds` */ DROP TABLE IF EXISTS `fb_tlds`; CREATE TABLE `fb_tlds` ( `id` int(11) NOT NULL auto_increment, `tld` varchar(8) collate utf8_turkish_ci NOT NULL, `price` varchar(5) collate utf8_turkish_ci NOT NULL, `registrar_id` int(11) NOT NULL, `default` tinyint(1) NOT NULL default '0', `disabled` tinyint(1) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; /*Data for the table `fb_tlds` */ insert into `fb_tlds`(`id`,`tld`,`price`,`registrar_id`,`default`,`disabled`) values (1,'com','10',0,1,0),(2,'net','10',0,1,0),(3,'org','10',0,1,0),(5,'biz','13',0,0,0),(6,'us.com','27',0,0,0),(7,'us','6',0,0,0),(8,'cn','65',0,0,0); /*Table structure for table `fb_vps_ip` */ DROP TABLE IF EXISTS `fb_vps_ip`; CREATE TABLE `fb_vps_ip` ( `id` smallint(5) unsigned NOT NULL auto_increment, `ip` varchar(15) NOT NULL, `vps_id` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; /*Data for the table `fb_vps_ip` */ insert into `fb_vps_ip`(`id`,`ip`,`vps_id`) values (1,'192.168.1.205',1),(2,'192.168.1.206',2),(3,'192.168.1.207',6),(4,'192.168.1.208',7),(5,'192.168.1.209',8),(6,'192.168.1.210',9),(7,'192.168.1.211',12),(8,'192.168.1.212',13),(9,'192.168.1.213',14),(10,'192.168.1.214',0),(11,'192.168.1.215',0),(12,'192.168.1.216',0),(13,'192.168.1.217',0),(14,'192.168.1.218',0),(15,'192.168.1.219',0),(16,'192.168.1.220',0); /*Table structure for table `fb_vps_packages` */ DROP TABLE IF EXISTS `fb_vps_packages`; CREATE TABLE `fb_vps_packages` ( `id` tinyint(4) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL, `platform` enum('Linux','Windows') NOT NULL, `details` mediumtext NOT NULL, `price_1` tinyint(4) unsigned NOT NULL, `price_3` tinyint(4) unsigned NOT NULL, `price_6` tinyint(4) unsigned NOT NULL, `price_12` tinyint(4) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=40; /*Data for the table `fb_vps_packages` */ insert into `fb_vps_packages`(`id`,`name`,`platform`,`details`,`price_1`,`price_3`,`price_6`,`price_12`) values (1,'VPS 1','Windows','{\"disk\":\"10\",\"memory\":\"524288\",\"system\":\"centos\"}',10,28,54,100); /*Table structure for table `fb_vpss` */ DROP TABLE IF EXISTS `fb_vpss`; CREATE TABLE `fb_vpss` ( `id` smallint(6) unsigned NOT NULL auto_increment, `customer_id` smallint(6) NOT NULL, `vps_id` tinyint(4) unsigned NOT NULL, `ip` varchar(15) NOT NULL, `mac_addr` char(17) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; /*Data for the table `fb_vpss` */ insert into `fb_vpss`(`id`,`customer_id`,`vps_id`,`ip`,`mac_addr`,`status`) values (1,28,1,'','',1),(2,28,2,'192.168.0.206','1:1:1:!:!:!',1),(3,28,3,' ','',1),(4,28,4,' ','',1),(5,28,5,' ','',1),(6,28,6,'','',1),(7,28,7,'','',1),(8,28,8,'','',1),(9,28,9,'','',1),(10,28,10,'','',1),(11,28,11,'','',1),(12,28,12,'','',1),(13,28,13,'','',1),(14,28,14,'','',1); /*Table structure for table `fb_whois_profiles` */ DROP TABLE IF EXISTS `fb_whois_profiles`; CREATE TABLE `fb_whois_profiles` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` int(11) unsigned default NULL, `profile_name` varchar(30) default NULL, `default_select` tinyint(1) NOT NULL default '0', `admin_name` varchar(50) default NULL, `admin_addr1` varchar(100) default NULL, `admin_addr2` varchar(100) default NULL, `admin_addr3` varchar(100) default NULL, `admin_city` varchar(100) default NULL, `admin_state` varchar(100) default NULL, `admin_postal` varchar(100) default NULL, `admin_country` varchar(100) default NULL, `admin_phone` varchar(100) default NULL, `admin_fax` varchar(100) default NULL, `tech_name` varchar(50) default NULL, `admin_email` varchar(100) default NULL, `tech_addr1` varchar(100) default NULL, `tech_addr2` varchar(100) default NULL, `tech_addr3` varchar(100) default NULL, `tech_city` varchar(100) default NULL, `tech_state` varchar(100) default NULL, `tech_postal` varchar(100) default NULL, `tech_country` varchar(100) default NULL, `tech_phone` varchar(100) default NULL, `tech_fax` varchar(100) default NULL, `tech_email` varchar(100) default NULL, `billing_name` varchar(50) default NULL, `billing_addr1` varchar(100) default NULL, `billing_addr2` varchar(100) default NULL, `billing_addr3` varchar(100) default NULL, `billing_city` varchar(100) default NULL, `billing_state` varchar(100) default NULL, `billing_postal` varchar(100) default NULL, `billing_country` varchar(100) default NULL, `billing_phone` varchar(100) default NULL, `billing_fax` varchar(100) default NULL, `billing_email` varchar(100) default NULL, `ns1` varchar(50) default NULL, `ns2` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=301; /*Data for the table `fb_whois_profiles` */ insert into `fb_whois_profiles`(`id`,`customer_id`,`profile_name`,`default_select`,`admin_name`,`admin_addr1`,`admin_addr2`,`admin_addr3`,`admin_city`,`admin_state`,`admin_postal`,`admin_country`,`admin_phone`,`admin_fax`,`tech_name`,`admin_email`,`tech_addr1`,`tech_addr2`,`tech_addr3`,`tech_city`,`tech_state`,`tech_postal`,`tech_country`,`tech_phone`,`tech_fax`,`tech_email`,`billing_name`,`billing_addr1`,`billing_addr2`,`billing_addr3`,`billing_city`,`billing_state`,`billing_postal`,`billing_country`,`billing_phone`,`billing_fax`,`billing_email`,`ns1`,`ns2`) values (1,28,'Genel Profil',0,'Tugrul Duran','P.K. 766','','','Lefkosa','KKTC','99990','TR','+90.533 868-9029','+90.533 868-9029','Tugrul Duran','duran.tugrul@gmail.com','P.K. 766','','','Lefkosa','KKTC','99990','TR','+90.533 868-9029','+90.533 868-9029','duran.tugrul@gmail.com','Tugrul Duran','P.K. 766','','','Lefkosa','KKTC','99990','TR','+90.533 868-9029','+90.533 868-9029','duran.tugrul@gmail.com','ns1.tier6.org','ns2.tier6.org'),(2,28,'İkinci Profil',1,'Tugrul Duran','P.K. 766','ıupgpuıG','','Lefkosa','KKTC','99990','Türkiye','+22.222 222-2222','+33.333 333-3333','Tugrul Duran','duran.tugrul@gmail.com','P.K. 766','ıupgpuıG','','Lefkosa','KKTC','99990','Türkiye','+22.222 222-2222','+33.333 333-3333','duran.tugrul@gmail.com','Tugrul Duran','P.K. 766','ıupgpuıG','','Lefkosa','KKTC','99990','Türkiye','+22.222 222-2222','+33.333 333-3333','duran.tugrul@gmail.com','ns1.webizyum.com','ns2.webizyum.com'),(9,28,'Test 5',0,'Tugrul Duran','Test Sok. Deneme Apt No: 22','','','Lefkosa','KKTC','99990','','+11.111 111-1111','+22.222 222-2222','Tugrul Duran','duran.tugrul@tmail.gom','Test Sok. Deneme Apt No: 22','','','Lefkosa','KKTC','99990','','+11.111 111-1111','+22.222 222-2222','duran.tugrul@tmail.gom','Tugrul Duran','Test Sok. Deneme Apt No: 22','','','Lefkosa','KKTC','99990','','+11.111 111-1111','+22.222 222-2222','duran.tugrul@tmail.gom','ns1.webizyum.com','ns2.webizyum.com'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;