{"slug":"instinctor","name":"Instinctor – Bookings, Store, Live Chat and SEO","description":"A complete business platform in one plugin: an animation-grade editor, a store, bookings, live chat and SEO. It replaces a stack of plugins.","author":"Instinctor","active_installs":10,"version":"2.1.08","wp_org_url":"https://wordpress.org/plugins/instinctor/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"directly","full_table_name":"wp_directly","description":"Stores directly data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"template_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"element_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"category","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"thumbnail","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"is_global","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"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));"}],"table_count":1}