Skip to content

Instantly share code, notes, and snippets.

@ntwb

ntwb/utf8mb4-netweb_com_au_db.txt Secret

Created January 8, 2015 22:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ntwb/00918b2f625281853502 to your computer and use it in GitHub Desktop.
Save ntwb/00918b2f625281853502 to your computer and use it in GitHub Desktop.
Download ZIP
netweb_com_au_db UTF8MB4
Raw
utf8mb4-netweb_com_au_db.txt
+---------------+--------------------------+-------------------------------+-----------------------+-------------+------------+--------------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | IS_NULLABLE | DATA_TYPE | COLLATION_NAME |
+---------------+--------------------------+-------------------------------+-----------------------+-------------+------------+--------------------+
| def | netweb_com_au_db | nw_commentmeta | meta_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_commentmeta | comment_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_commentmeta | meta_key | YES | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_commentmeta | meta_value | YES | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_ID | NO | bigint | NULL |
| def | netweb_com_au_db | nw_comments | comment_post_ID | NO | bigint | NULL |
| def | netweb_com_au_db | nw_comments | comment_author | NO | tinytext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_author_email | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_author_url | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_author_IP | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_date | NO | datetime | NULL |
| def | netweb_com_au_db | nw_comments | comment_date_gmt | NO | datetime | NULL |
| def | netweb_com_au_db | nw_comments | comment_content | NO | text | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_karma | NO | int | NULL |
| def | netweb_com_au_db | nw_comments | comment_approved | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_agent | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_type | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_comments | comment_parent | NO | bigint | NULL |
| def | netweb_com_au_db | nw_comments | user_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_links | link_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_links | link_url | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_name | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_image | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_target | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_description | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_visible | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_owner | NO | bigint | NULL |
| def | netweb_com_au_db | nw_links | link_rating | NO | int | NULL |
| def | netweb_com_au_db | nw_links | link_updated | NO | datetime | NULL |
| def | netweb_com_au_db | nw_links | link_rel | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_notes | NO | mediumtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_links | link_rss | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_options | option_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_options | option_name | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_options | option_value | NO | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_options | autoload | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_postmeta | meta_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_postmeta | post_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_postmeta | meta_key | YES | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_postmeta | meta_value | YES | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | ID | NO | bigint | NULL |
| def | netweb_com_au_db | nw_posts | post_author | NO | bigint | NULL |
| def | netweb_com_au_db | nw_posts | post_date | NO | datetime | NULL |
| def | netweb_com_au_db | nw_posts | post_date_gmt | NO | datetime | NULL |
| def | netweb_com_au_db | nw_posts | post_content | NO | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_title | NO | text | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_excerpt | NO | text | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_status | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | comment_status | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | ping_status | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_password | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_name | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | to_ping | NO | text | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | pinged | NO | text | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_modified | NO | datetime | NULL |
| def | netweb_com_au_db | nw_posts | post_modified_gmt | NO | datetime | NULL |
| def | netweb_com_au_db | nw_posts | post_content_filtered | NO | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_parent | NO | bigint | NULL |
| def | netweb_com_au_db | nw_posts | guid | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | menu_order | NO | int | NULL |
| def | netweb_com_au_db | nw_posts | post_type | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | post_mime_type | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_posts | comment_count | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_relationships | object_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_relationships | term_taxonomy_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_relationships | term_order | NO | int | NULL |
| def | netweb_com_au_db | nw_term_taxonomy | term_taxonomy_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_taxonomy | term_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_taxonomy | taxonomy | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_term_taxonomy | description | NO | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_term_taxonomy | parent | NO | bigint | NULL |
| def | netweb_com_au_db | nw_term_taxonomy | count | NO | bigint | NULL |
| def | netweb_com_au_db | nw_terms | term_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_terms | name | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_terms | slug | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_terms | term_group | NO | bigint | NULL |
| def | netweb_com_au_db | nw_usermeta | umeta_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_usermeta | user_id | NO | bigint | NULL |
| def | netweb_com_au_db | nw_usermeta | meta_key | YES | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_usermeta | meta_value | YES | longtext | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | ID | NO | bigint | NULL |
| def | netweb_com_au_db | nw_users | user_login | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_pass | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_nicename | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_email | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_url | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_registered | NO | datetime | NULL |
| def | netweb_com_au_db | nw_users | user_activation_key | NO | varchar | utf8mb4_unicode_ci |
| def | netweb_com_au_db | nw_users | user_status | NO | int | NULL |
| def | netweb_com_au_db | nw_users | display_name | NO | varchar | utf8mb4_unicode_ci |
+---------------+--------------------------+-------------------------------+-----------------------+-------------+------------+--------------------+
90 rows in set (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment