{"slug":"fast-events","name":"Fast Events","description":"Sell personalized event tickets with PayPal, Stripe, or Mollie, including free Scan App, Tracking App, and Admin App.","author":"fedata","active_installs":20,"version":"3.0.0","wp_org_url":"https://wordpress.org/plugins/fast-events/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"fe_event_coupons","full_table_name":"wp_fe_event_coupons","description":"Stores fe event coupons data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT","nullable":false,"primary_key":true},{"name":"code","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"description","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":false,"primary_key":false},{"name":"type","type":"ENUM('percent','fixed')","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"usage_limit","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"usage_limit_per_user","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"used","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"last_used","type":"DATETIME","nullable":true,"primary_key":false},{"name":"start_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"end_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"events","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"tickets","type":"VARCHAR(256)","nullable":true,"primary_key":false},{"name":"minimum_tickets","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"maximum_tickets","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"minimum_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"maximum_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_coupons ( id BIGINT NOT NULL AUTO_INCREMENT, code VARCHAR(32) NOT NULL, description VARCHAR(100) NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, type ENUM('percent','fixed') NOT NULL DEFAULT 'fixed', amount DECIMAL(10,2) NOT NULL, usage_limit INT UNSIGNED NOT NULL DEFAULT '1', usage_limit_per_user INT UNSIGNED NOT NULL DEFAULT '1', used INT UNSIGNED NOT NULL DEFAULT '0', last_used DATETIME NULL, start_date DATETIME NOT NULL, end_date DATETIME NOT NULL, events VARCHAR(64) NULL, tickets VARCHAR(256) NULL, minimum_tickets INT UNSIGNED NULL, maximum_tickets INT UNSIGNED NULL, minimum_amount DECIMAL(10,2) NULL, maximum_amount DECIMAL(10,2) NULL, email VARCHAR(100) NULL, PRIMARY KEY (id), UNIQUE code_index (code) ) ENGINE"},{"table_name":"fe_event_email_log","full_table_name":"wp_fe_event_email_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT","nullable":false,"primary_key":true},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":false,"primary_key":false},{"name":"provider_id","type":"ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost')","nullable":false,"primary_key":false},{"name":"email_type","type":"ENUM('normal','confirm','free')","nullable":false,"primary_key":false},{"name":"provider_email_id","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"sender_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"receiver_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_subject","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_events","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_email_log ( id BIGINT NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, provider_id ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost') NOT NULL DEFAULT 'local', email_type ENUM('normal','confirm','free') NOT NULL DEFAULT 'normal', provider_email_id VARCHAR(100) NOT NULL, sender_email VARCHAR(100) NOT NULL, receiver_email VARCHAR(100) NOT NULL, email_subject VARCHAR(100) NOT NULL, email_events TEXT NOT NULL, PRIMARY KEY (id), UNIQUE KEY provider_email_id_index (provider_email_id), UNIQUE KEY order_date_index (order_id, date_created) ) ENGINE"},{"table_name":"fe_event_entries","full_table_name":"wp_fe_event_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"qrcode_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"scancode","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"tracking_lap","type":"INT","nullable":false,"primary_key":false},{"name":"scan_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"scan_location","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"scan_level","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_entries ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, qrcode_id BIGINT(20) UNSIGNED NOT NULL, scancode VARCHAR(16) NOT NULL DEFAULT '', tracking_lap INT NOT NULL DEFAULT '0', scan_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, scan_location VARCHAR(32) NOT NULL DEFAULT '', scan_level TINYINT(1) NOT NULL DEFAULT '1', PRIMARY KEY (id), UNIQUE KEY scan_entry (qrcode_id, scancode, tracking_lap) ) ENGINE"},{"table_name":"fe_event_log","full_table_name":"wp_fe_event_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"log_type","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_log ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', log_type VARCHAR(32) NOT NULL DEFAULT '', description TEXT NOT NULL, PRIMARY KEY (id), INDEX date1 (created_at), INDEX date2 (event_id, created_at), INDEX order_idx (order_id) ) ENGINE"},{"table_name":"fe_event_orders","full_table_name":"wp_fe_event_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"uid","type":"CHAR(40)","nullable":false,"primary_key":false},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"event_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"payment_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"custom_status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"input_fields","type":"TEXT","nullable":false,"primary_key":false},{"name":"num_tickets","type":"INT","nullable":false,"primary_key":false},{"name":"total","type":"DECIMAL(10,4)","nullable":false,"primary_key":false},{"name":"discount","type":"DECIMAL(10,4)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_orders ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, uid CHAR(40) NOT NULL DEFAULT '', event_id BIGINT(20) UNSIGNED NOT NULL, event_date DATETIME NULL DEFAULT NULL, payment_id VARCHAR(255) NOT NULL DEFAULT '', payment_status VARCHAR(32) NOT NULL DEFAULT '', custom_status VARCHAR(32) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, name VARCHAR(50) NOT NULL DEFAULT '', email VARCHAR(100) NOT NULL DEFAULT '', input_fields TEXT NOT NULL, num_tickets INT NOT NULL DEFAULT '0', total DECIMAL(10,4) NOT NULL DEFAULT '0.0000', discount DECIMAL(10,4) NOT NULL DEFAULT '0.0000', ip_address VARCHAR(45) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uid (uid(40)), INDEX event_id (event_id), INDEX email (email) ) ENGINE"},{"table_name":"fe_event_qrcodes","full_table_name":"wp_fe_event_qrcodes","description":"Stores fe event qrcodes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"ticket_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"qrcode","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"personalised_input","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"tracking_nonce","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(10,4)","nullable":false,"primary_key":false},{"name":"scan_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"scan_location","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"exit_scan","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_qrcodes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL, event_id BIGINT(20) UNSIGNED NOT NULL, ticket_type VARCHAR(50) NOT NULL DEFAULT '', qrcode VARCHAR(32) NOT NULL DEFAULT '', personalised_input VARCHAR(512) NULL DEFAULT NULL, tracking_nonce VARCHAR(16) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, amount DECIMAL(10,4) NOT NULL DEFAULT '0.0000', scan_date DATETIME NULL DEFAULT NULL, scan_location VARCHAR(32) NOT NULL DEFAULT '', exit_scan TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY order_id (order_id), UNIQUE KEY qrcode (qrcode), INDEX event_id (event_id) ) ENGINE"},{"table_name":"fe_event_seats","full_table_name":"wp_fe_event_seats","description":"Stores fe event seats data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"num_seats","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"last_seat_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"open_seats","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"seat_format","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"seat_config","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"seat_map","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"linked_event","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_seats ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, num_seats INT UNSIGNED NOT NULL DEFAULT '0', last_seat_id INT UNSIGNED NOT NULL DEFAULT '0', open_seats TINYINT(1) NOT NULL DEFAULT '0', seat_format VARCHAR(32) NOT NULL DEFAULT '', seat_config MEDIUMTEXT NOT NULL, seat_map MEDIUMTEXT NOT NULL, linked_event BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id), UNIQUE INDEX event_id (event_id) ) ENGINE"},{"table_name":"fe_event_user_groups","full_table_name":"wp_fe_event_user_groups","description":"Stores fe event user groups data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"num_tickets","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_user_groups ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, name VARCHAR(50) NOT NULL DEFAULT '', email VARCHAR(100) NOT NULL DEFAULT '', num_tickets INT NOT NULL DEFAULT '0', PRIMARY KEY (id), UNIQUE KEY email (event_id,email) ) ENGINE"},{"table_name":"fe_event_webhooks","full_table_name":"wp_fe_event_webhooks","description":"Stores fe event webhooks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"secret","type":"CHAR(40)","nullable":false,"primary_key":false},{"name":"retry_scheme","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"topic","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"pending","type":"INT","nullable":false,"primary_key":false},{"name":"delivered","type":"INT","nullable":false,"primary_key":false},{"name":"retries","type":"INT","nullable":false,"primary_key":false},{"name":"failed","type":"INT","nullable":false,"primary_key":false},{"name":"failure_threshold","type":"INT","nullable":false,"primary_key":false},{"name":"last_success","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"last_retry","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"last_failure","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"date_created","type":"TIMESTAMP","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_event_webhooks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, status TINYINT(1) NOT NULL DEFAULT '0', name VARCHAR(100) NOT NULL DEFAULT '', user_id BIGINT(20) UNSIGNED NOT NULL, url VARCHAR(200) NOT NULL DEFAULT '', secret CHAR(40) NOT NULL DEFAULT '', retry_scheme VARCHAR(50) NOT NULL DEFAULT '', topic VARCHAR(50) NOT NULL DEFAULT '', pending INT NOT NULL DEFAULT '0', delivered INT NOT NULL DEFAULT '0', retries INT NOT NULL DEFAULT '0', failed INT NOT NULL DEFAULT '0', failure_threshold INT NOT NULL DEFAULT '60', last_success TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', last_retry TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', last_failure TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', date_created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE"},{"table_name":"fe_events","full_table_name":"wp_fe_events","description":"Stores fe events data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"start_date","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"end_date","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"event_name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"event_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"event_date_format","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"event_type","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"stock","type":"INT","nullable":false,"primary_key":false},{"name":"sold","type":"INT","nullable":false,"primary_key":false},{"name":"group_type","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"event_group","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"stock_link","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"saas_fee","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"saas_user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"sender_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"sender_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_bcc","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_subject","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_body","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"redirect","type":"VARCHAR(256)","nullable":false,"primary_key":false},{"name":"confirm_bcc","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"confirm_subject","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"confirm_body","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"confirm_redirect","type":"VARCHAR(256)","nullable":false,"primary_key":false},{"name":"emails_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"tickets_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"invoice_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"user_groups_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"recaptcha_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"confirmation_emails_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"confirmation_timeout","type":"INT","nullable":false,"primary_key":false},{"name":"add_dashboard_orders_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"test_payments_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"seats_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"webhooks_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"reload_on_exit_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"tracking_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"coupons_needed","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"terms","type":"VARCHAR(256)","nullable":true,"primary_key":false},{"name":"pdf_info","type":"TEXT","nullable":false,"primary_key":false},{"name":"input_fields","type":"TEXT","nullable":false,"primary_key":false},{"name":"scan_keys","type":"TEXT","nullable":false,"primary_key":false},{"name":"tracking_info","type":"MEDIUMTEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fe_events ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, start_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, end_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, event_name VARCHAR(50) NOT NULL DEFAULT '', event_date TIMESTAMP NULL DEFAULT NULL, event_date_format VARCHAR(32) NOT NULL DEFAULT 'Y-m-d H:i', event_type TINYINT(1) NOT NULL DEFAULT '1', stock INT NOT NULL DEFAULT '0', sold INT NOT NULL DEFAULT '0', group_type TINYINT(1) NOT NULL DEFAULT '0', event_group VARCHAR(16) NOT NULL DEFAULT '', stock_link BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', saas_fee DECIMAL(10,2) NULL DEFAULT NULL, saas_user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', sender_name VARCHAR(100) NOT NULL DEFAULT '', sender_email VARCHAR(100) NOT NULL DEFAULT '', email_bcc VARCHAR(100) NOT NULL DEFAULT '', email_subject VARCHAR(100) NOT NULL DEFAULT '', email_body MEDIUMTEXT NOT NULL, redirect VARCHAR(256) NOT NULL DEFAULT '', confirm_bcc VARCHAR(100) NOT NULL DEFAULT '', confirm_subject VARCHAR(100) NOT NULL DEFAULT '', confirm_body MEDIUMTEXT NOT NULL, confirm_redirect VARCHAR(256) NOT NULL DEFAULT '', emails_needed TINYINT(1) NOT NULL DEFAULT '1', tickets_needed TINYINT(1) NOT NULL DEFAULT '1', invoice_needed TINYINT(1) NOT NULL DEFAULT '1', unique_users_needed TINYINT(1) NOT NULL DEFAULT '0', user_groups_needed TINYINT(1) NOT NULL DEFAULT '0', recaptcha_needed TINYINT(1) NOT NULL DEFAULT '0', confirmation_emails_needed TINYINT(1) NOT NULL DEFAULT '0', confirmation_timeout INT NOT NULL DEFAULT '0', add_dashboard_orders_needed TINYINT(1) NOT NULL DEFAULT '1', test_payments_needed TINYINT(1) NOT NULL DEFAULT '1', seats_needed TINYINT(1) NOT NULL DEFAULT '0', webhooks_needed TINYINT(1) NOT NULL DEFAULT '0', reload_on_exit_needed TINYINT(1) NOT NULL DEFAULT '0', tracking_needed TINYINT(1) NOT NULL DEFAULT '0', coupons_needed TINYINT(1) NOT NULL DEFAULT '0', terms VARCHAR(256) DEFAULT NULL, pdf_info TEXT NOT NULL, input_fields TEXT NOT NULL, scan_keys TEXT NOT NULL, tracking_info MEDIUMTEXT NOT NULL, PRIMARY KEY (id) ) ENGINE"}],"table_count":12}