The SQL Code for Postmeta table

  • Resolved 34503895

    (@34503895-1)


    3 months, 3 weeks ago

    Hi, the WP install is from around 2012 and there are currently some issues with the postmeta table. I want to delete the table and re-create it.

    What is the SQL code to create the wp_postmeta table?

Viewing 1 replies (of 1 total)
  • Thread Starter 34503895

    (@34503895-1)

    3 months, 3 weeks ago

    CREATE TABLE pe_postmeta (
    meta_id bigint(20) UNSIGNED NOT NULL,
    post_id bigint(20) UNSIGNED NOT NULL DEFAULT 0,
    meta_key varchar(255) DEFAULT NULL,
    meta_value longtext DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.