File "create_table_publisher.sql"
Full Path: /home/vantageo/public_html/cache/cache/cache/cache/cache/cache/cache/.wp-cli/wp-content/plugins/wp-data-access/admin/repository/create_table_publisher.sql
File size: 2.66 KB
MIME-type: text/plain
Charset: utf-8
CREATE TABLE {wp_prefix}wpda_publisher{wpda_postfix} (
pub_id mediumint(9) NOT NULL AUTO_INCREMENT,
pub_name varchar(100) NOT NULL,
pub_data_source enum('Table','Query', 'CPT') DEFAULT 'Table',
pub_schema_name varchar(64) NOT NULL DEFAULT '',
pub_table_name varchar(64) NOT NULL,
pub_column_names varchar(4096) DEFAULT '*',
pub_cpt varchar(20),
pub_cpt_fields text,
pub_cpt_query text,
pub_cpt_format text,
pub_format text,
pub_query text,
pub_sort_icons enum('default', 'none'),
pub_styles set('default', 'stripe', 'hover', 'order-column', 'row-border', 'compact', 'cell-border')
DEFAULT 'default',
pub_style_premium enum('Yes', 'No') DEFAULT 'No',
pub_style_user varchar(50),
pub_style_color varchar(50) DEFAULT 'default',
pub_style_space tinyint(2) unsigned DEFAULT 10,
pub_style_corner tinyint(2) unsigned DEFAULT 0,
pub_style_modal_width tinyint(2) unsigned DEFAULT 80,
pub_responsive enum('Yes', 'No'),
pub_responsive_popup_title varchar(50),
pub_responsive_cols int unsigned DEFAULT 0,
pub_responsive_type enum('Modal', 'Collapsed', 'Expanded'),
pub_responsive_modal_hyperlinks enum('If not listed', 'Never', 'Always'),
pub_responsive_icon enum('Yes', 'No'),
pub_flat_scrollx enum('Yes', 'No'),
pub_show_advanced_settings tinyint(1) DEFAULT NULL,
pub_default_where varchar(2000) DEFAULT '',
pub_default_orderby varchar(100) DEFAULT '',
pub_table_options_searching char(3) DEFAULT 'on',
pub_table_options_ordering char(3) DEFAULT 'on',
pub_table_options_paging char(3) DEFAULT 'on',
pub_table_options_serverside char(3) DEFAULT 'on',
pub_table_options_nl2br char(3) DEFAULT NULL,
pub_table_options_advanced text,
pub_extentions varchar(2000) DEFAULT '',
PRIMARY KEY (pub_id),
UNIQUE KEY (pub_name)
) {wpda_collate};