wp_directly

Column Definitions

CREATE TABLE Statement

CREATE TABLE $table_templates ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, slug varchar(100) NOT NULL, type varchar(50) NOT NULL DEFAULT 'page', status varchar(20) NOT NULL DEFAULT 'draft', settings longtext, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY type (type), KEY status (status) ) $charset_collate;"; // Elements table (supports unlimited nesting via parent_id) $table_sections = DB::prefix() . 'instinctor_template_sections'; $sql_sections = "CREATE TABLE $table_sections ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, template_id bigint(20) unsigned NOT NULL, parent_id bigint(20) unsigned DEFAULT NULL, element_type varchar(100) NOT NULL, settings longtext, sort_order int(11) NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY template_id (template_id), KEY parent_id (parent_id), KEY sort_order (sort_order) ) $charset_collate;"; // Element templates library $table_element_templates = DB::prefix() . 'instinctor_element_templates'; $sql_element_templates = "CREATE TABLE $table_element_templates ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, type varchar(50) NOT NULL DEFAULT 'section', category varchar(100) DEFAULT NULL, thumbnail varchar(500) DEFAULT NULL, content longtext NOT NULL, is_global tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY type (type), KEY category (category) ) $charset_collate;"; // In WP mode, dbDelta handles schema diffs gracefully. In standalone, that file // doesn't exist — just run CREATE TABLE IF NOT EXISTS directly (DB::get_charset_collate // emits the charset clause so the DDL is safe on both MySQL and MariaDB). if (defined('INSTINCTOR_ENV') && INSTINCTOR_ENV === 'standalone') { DB::query(str_replace('CREATE TABLE ', 'CREATE TABLE IF NOT EXISTS ', $sql_templates));

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_directly`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.