• XSS.stack #1 – первый литературный журнал от юзеров форума

SQL База сайта i-learner.com.hk

Отслеживать
N9XDZ

N9XDZ

(L1) cache
Пользователь
Регистрация
19.08.2020
Сообщения
680
Решения
1
Реакции
846
Гарант сделки
2
Депозит
0.0002
Сайт обучения

Сайт: i-learner.com.hk
Актуальность: 2020-02-28
Строк: 275357
CREATE TABLE `member` (
`member_id` bigint(20) NOT NULL AUTO_INCREMENT,
`member_no` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
`school_id` bigint(20) DEFAULT NULL,
`class_id` bigint(20) NOT NULL DEFAULT '0',
`class_no` int(5) DEFAULT '0',
`buddy_type` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'A',
`buddy_name` varchar(30) CHARACTER SET latin1 DEFAULT 'Bugbug',
`member_type_id` int(11) DEFAULT '1',
`chi_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`eng_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`sex` char(1) CHARACTER SET latin1 DEFAULT NULL,
`age` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`syl` tinyint(4) NOT NULL DEFAULT '1',
`p_level` smallint(1) NOT NULL DEFAULT '1',
`username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`passwd` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
`passwd2` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '20060921',
`create_date` date NOT NULL DEFAULT '0000-00-00',
`g_create_date` date NOT NULL DEFAULT '0000-00-00',
`p_create_date` date NOT NULL DEFAULT '0000-00-00',
`s_create_date` date NOT NULL DEFAULT '0000-00-00',
`sba_create_date` date NOT NULL DEFAULT '0000-00-00',
`ICQ` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
`MSN` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
`email` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
`email2` text COLLATE utf8_unicode_ci,
`phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`phone2` text COLLATE utf8_unicode_ci,
`location` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'H',
`dob` date NOT NULL DEFAULT '0000-00-00',
`fav_book` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
`fav_colour` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
`expiry_date` date NOT NULL DEFAULT '0000-00-00',
`g_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`p_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`s_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`sba_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`reading` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'F',
`grammer` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'F',
`phonics` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'F',
`shakespears` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'F',
`sba` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'F',
`counter` int(11) NOT NULL DEFAULT '0',
`g_counter` bigint(20) NOT NULL DEFAULT '0',
`s_counter` bigint(20) NOT NULL DEFAULT '0',
`p_counter` bigint(20) NOT NULL DEFAULT '0',
`sba_counter` bigint(20) NOT NULL DEFAULT '0',
`demo` char(1) CHARACTER SET latin1 NOT NULL DEFAULT 'N',
`display_type` tinyint(2) NOT NULL DEFAULT '0',
`assessment` int(11) NOT NULL DEFAULT '0',
`server_id` tinyint(4) NOT NULL DEFAULT '2',
`new_coin` int(11) NOT NULL DEFAULT '0',
`trial_day` smallint(3) DEFAULT NULL,
`last_login_time` datetime DEFAULT NULL,
`interface` int(11) NOT NULL DEFAULT '0',
`buddybirth` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`nickname` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`blog_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`login` tinyint(4) NOT NULL DEFAULT '0',
`msg` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`receive_mail` int(11) NOT NULL DEFAULT '0',
`second_level` int(11) NOT NULL DEFAULT '99',
`studentID` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '""',
`dse` int(11) NOT NULL DEFAULT '0',
`dsepackageid` smallint(6) DEFAULT '-1',
`cc` int(11) DEFAULT '0',
`cannotchangepassword` tinyint(1) NOT NULL DEFAULT '0',
`user_default_level` int(11) NOT NULL DEFAULT '0',
`group_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '""',
`temp_mark` int(11) NOT NULL,
`vocab` tinyint(4) DEFAULT '0',
`blog_marking` tinyint(4) NOT NULL DEFAULT '0',
`cross_level1` int(11) NOT NULL DEFAULT '1',
`current_assessment` int(11) DEFAULT '1',
PRIMARY KEY (`member_id`,`member_no`),
KEY `class_id` (`class_id`),
KEY `school_id` (`school_id`),
KEY `member_type_id` (`member_type_id`),
KEY `username` (`username`),
KEY `studentID` (`studentID`),
KEY `passwd` (`passwd`),
KEY `group_name` (`group_name`),
KEY `second_level` (`second_level`),
KEY `cross` (`cc`),
KEY `vocab` (`vocab`)
) ENGINE=MyISAM AUTO_INCREMENT=390562563 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

(390363223,'325065-4750-0416',4750,325065,0,'A','Bugbug',1,'pta12','pta12','M',0,7,1,1,'dlkp_pta12_old','pleasechange','pleasechangeP','2016-09-19','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','','',NULL,'',NULL,'','0000-00-00','','','2017-09-30','0000-00-00','0000-00-00','0000-00-00','0000-00-00','F','F','F','F','F',0,0,0,0,0,'N',0,0,2,0,NULL,NULL,3,'','','',0,'',0,1,'',0,-1,0,0,0,'\"\"',0,0,0,1,1),
(390363221,'325065-4750-0414',4750,325065,0,'A','Bugbug',1,'pta10','pta10','M',0,7,1,1,'dlkp_pta10_old','pleasechange','pleasechangeP','2016-09-19','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','','',NULL,'',NULL,'','0000-00-00','','','2017-09-30','0000-00-00','0000-00-00','0000-00-00','0000-00-00','F','F','F','F','F',0,0,0,0,0,'N',0,0,2,0,NULL,NULL,3,'','','',0,'',0,1,'',0,-1,0,0,0,'\"\"',0,0,0,1,1),
(390363220,'325065-4750-0413',4750,325065,0,'A','Bugbug',1,'pta09','pta09','M',0,7,1,1,'dlkp_pta09_old','pleasechange','pleasechangeP','2016-09-19','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','','',NULL,'',NULL,'','0000-00-00','','','2017-09-30','0000-00-00','0000-00-00','0000-00-00','0000-00-00','F','F','F','F','F',0,0,0,0,0,'N',0,0,2,0,NULL,NULL,3,'','','',0,'',0,1,'',0,-1,0,0,0,'\"\"',0,0,0,1,1),
(390363218,'325065-4750-0411',4750,325065,0,'A','Bugbug',1,'pta07','pta07','M',0,7,1,1,'dlkp_pta07_old','pleasechange','pleasechangeP','2016-09-19','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','','',NULL,'',NULL,'','0000-00-00','','','2017-09-30','0000-00-00','0000-00-00','0000-00-00','0000-00-00','F','F','F','F','F',0,0,0,0,0,'N',0,0,2,0,NULL,NULL,3,'','','',0,'',0,1,'',0,-1,0,0,0,'\"\"',0,0,0,1,1),

 
admin


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх