File "create_table_publisher.sql"

Full Path: /home/vantageo/public_html/wp-admin/.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};