asadsds

CREATE TABLE `userdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `upper_username` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `firstname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `user_type` tinyint(2) NOT NULL DEFAULT '1',
  `gender` varchar(1) COLLATE utf8_unicode_ci NOT NULL COMMENT 'cinsiyet',
  `id_authenticated` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'kullanici kimlik onaylimi',
  `id_auth_date` int(11) NOT NULL DEFAULT '0' COMMENT 'kimlik onayli olma tarihi',
  `birthday` date NOT NULL DEFAULT '0000-00-00' COMMENT 'yyyy-mm-dd',
  `feedback_score` int(11) NOT NULL DEFAULT '0',
  `feedback_count` int(11) NOT NULL DEFAULT '0',
  `feedback_positive_count` int(11) NOT NULL DEFAULT '0',
  `feedback_positive_rate` float NOT NULL DEFAULT '0',
  `feedback_seller_count` int(11) NOT NULL COMMENT 'Satici iken aldigi rating adedi',
  `feedback_description` float NOT NULL DEFAULT '0',
  `feedback_communication` float NOT NULL DEFAULT '0',
  `feedback_cargospeed` float NOT NULL DEFAULT '0',
  `feedback_cargoprice` float NOT NULL DEFAULT '0',
  `secret_question` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'gizli soru',
  `secret_answer` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'gizli soru cevabi',
  `education` smallint(3) NOT NULL DEFAULT '0' COMMENT 'egitim durumu',
  `job` smallint(3) NOT NULL DEFAULT '0',
  `account_balance` double(7,2) NOT NULL DEFAULT '0.00',
  `gsm_authenticated` tinyint(1) NOT NULL DEFAULT '0',
  `gsm_auth_date` int(11) NOT NULL DEFAULT '0',
  `score` double(5,2) NOT NULL DEFAULT '0.00',
  `sms` smallint(6) NOT NULL DEFAULT '0',
  `newsletter` int(11) NOT NULL DEFAULT '1',
  `language` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'tr',
  `birthday_email` int(11) NOT NULL DEFAULT '0',
  `date_joined` int(11) NOT NULL DEFAULT '0',
  `last_online` int(11) NOT NULL DEFAULT '0',
  `ip_address` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `session_online` int(11) NOT NULL DEFAULT '0',
  `auth_method` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=pasif, 1=email, 2=sms, 3=admin',
  `registration_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `photo_last_updated` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `indx_userdata_email` (`email`),
  UNIQUE KEY `indx_upper_username` (`upper_username`),
  KEY `indx_member_date_joined` (`date_joined`),
  KEY `indx_userdata_status` (`status`),
  KEY `indx_user_gsmauth` (`gsm_authenticated`,`gsm_auth_date`),
  KEY `indx_userdata_name` (`firstname`,`lastname`),
  KEY `indx_userdata_username` (`username`),
  KEY `indx_photo_last_updated` (`photo_last_updated`),
  KEY `indx_auth_method_gsm_auth_date` (`auth_method`,`gsm_auth_date`)
) ENGINE=InnoDB AUTO_INCREMENT=23029617 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;