MariaDB [instaweb]> DESCRIBE `admins`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | UNI | NULL | | | password | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | remember_token | varchar(100) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `admins`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | UNI | NULL | | | password | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | remember_token | varchar(100) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ad_cooldowns`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | last_watched_at | timestamp | YES | | NULL | | | next_available_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `advertisements`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | page | varchar(191) | YES | | NULL | | | top | text | YES | | NULL | | | mid | text | YES | | NULL | | | bottom | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ai_addon`; +-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | website_addons_id | int(10) unsigned | NO | | 0 | | | addon_name | varchar(191) | NO | | NULL | | | addon_sku | varchar(191) | NO | | NULL | | | add_token | int(11) | YES | | NULL | | | addon_price | double(12,2) | YES | | NULL | | | addon_currency | varchar(191) | YES | | NULL | | +-------------------+------------------+------+-----+---------+-------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ai_description_store`; +-----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | title | varchar(255) | YES | | NULL | | | keyword | varchar(255) | YES | | NULL | | | length | int(10) unsigned | YES | | NULL | | | tone | varchar(255) | YES | | NULL | | | user_is_from | varchar(255) | YES | | NULL | | | generated_description | varchar(2000) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------------+------------------+------+-----+---------+----------------+ 11 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ai_image_store`; DESCRIBE `ai_token_claimed`; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | title | varchar(255) | YES | | NULL | | | keyword | varchar(255) | YES | | NULL | | | type | varchar(255) | YES | | NULL | | | user_is_from | varchar(255) | YES | | NULL | | | generated_image_path | varchar(2000) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ai_token_claimed`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | token_to_add | varchar(255) | YES | | NULL | | | claimed_at | varchar(255) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `analytics`; +--------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | user_agents_updated | datetime | YES | | NULL | | | hit_logs_updated | datetime | YES | | NULL | | | visitor_stats_updated | datetime | YES | | NULL | | | referer_stats_updated | datetime | YES | | NULL | | | social_stats_updated | datetime | YES | | NULL | | | browser_stats_updated | datetime | YES | | NULL | | | os_stats_updated | datetime | YES | | NULL | | | device_stats_updated | datetime | YES | | NULL | | | location_stats_updated | datetime | YES | | NULL | | | query_stats_updated | datetime | YES | | NULL | | | google_analytics_updated | datetime | YES | | NULL | | | add_sitemap_updated | datetime | YES | | NULL | | | create_sitemap_updated | datetime | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------------+------------------+------+-----+---------+----------------+ 19 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `app_feature`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | os | varchar(191) | NO | | NULL | | | app_version_name | varchar(191) | NO | | NULL | | | app_version_code | varchar(191) | NO | | NULL | | | features | varchar(191) | NO | | NULL | | | released_date | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | isCompulsoryUpdate | int(11) | NO | | 0 | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `app_flyer`; +-------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | user_id | int(11) | YES | | NULL | | | event | varchar(191) | YES | | NULL | | | source_name | varchar(191) | YES | | NULL | | | cost_value | int(11) | YES | | NULL | | | pid | varchar(191) | YES | | NULL | | | is_retargeting | varchar(191) | YES | | NULL | | | click_lookback | varchar(191) | YES | | NULL | | | param1 | varchar(191) | YES | | NULL | | | adset | int(11) | YES | | NULL | | | ad | varchar(191) | YES | | NULL | | | channel | varchar(191) | YES | | NULL | | | cost_currency | varchar(191) | YES | | NULL | | | inactivity_window | varchar(191) | YES | | NULL | | | c | varchar(191) | YES | | NULL | | | shortlink | varchar(191) | YES | | NULL | | | custom_data | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------------+--------------+------+-----+---------+----------------+ 20 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `app_pages`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | description | longtext | NO | | NULL | | | title | varchar(191) | NO | MUL | NULL | | | photo | varchar(191) | YES | | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | published | int(11) | NO | | 1 | | | path | varchar(191) | YES | | | | | viewLink | varchar(191) | YES | | | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | viewCount | int(10) unsigned | NO | | 0 | | | meta_title | varchar(150) | YES | | NULL | | | meta_description | varchar(200) | YES | | NULL | | | url_slug | varchar(150) | YES | | NULL | | | keywords | varchar(255) | YES | | NULL | | | is_draft | int(11) | NO | | 0 | | +--------------------+------------------+------+-----+---------+----------------+ 19 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `attributes`; +-----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | attribute_name | varchar(100) | YES | | NULL | | | attribute_description | text | YES | | NULL | | | attribute_datatype | tinyint(4) | YES | | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | deleted | tinyint(4) | NO | | 0 | | +-----------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `automated_email_logs`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | | NULL | | | type | varchar(191) | NO | | NULL | | | value | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `background_images`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | category_id | int(10) unsigned | NO | MUL | NULL | | | file_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `banned_keywords`; +---------------+---------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------------------+-------------------------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | keyword | varchar(191) | NO | UNI | NULL | | | keyword_type | tinyint(2) | NO | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | on update current_timestamp() | | is_india_only | int(11) | YES | | 0 | | +---------------+---------------------+------+-----+---------------------+-------------------------------+ 6 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `blockautomations`; +---------------+---------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------------------+-------------------------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | keyword | varchar(191) | NO | | NULL | | | keyword_type | tinyint(2) unsigned | NO | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | on update current_timestamp() | | is_india_only | int(11) | YES | | 0 | | +---------------+---------------------+------+-----+---------------------+-------------------------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `blocked_ips`; +--------------------+------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------------------+-------------------------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ip_address | varchar(45) | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | reason | text | YES | | NULL | | | created_at | timestamp | YES | | current_timestamp() | | | updated_at | timestamp | YES | | current_timestamp() | on update current_timestamp() | | block_registration | varchar(20) | NO | | 0 | | +--------------------+------------------+------+-----+---------------------+-------------------------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `browser_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | browser | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `business_locations`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | business_id | int(10) unsigned | NO | MUL | NULL | | | title | varchar(191) | YES | | NULL | | | address | varchar(600) | YES | | NULL | | | landmark | varchar(600) | YES | | NULL | | | city_id | int(10) unsigned | YES | MUL | NULL | | | state_id | int(10) unsigned | YES | MUL | NULL | | | country_id | int(10) unsigned | YES | MUL | NULL | | | pincode | varchar(191) | YES | | NULL | | | email | varchar(191) | YES | | NULL | | | phone_code_one | varchar(191) | YES | | NULL | | | phone_one | varchar(191) | YES | | NULL | | | phone_code_two | varchar(191) | YES | | NULL | | | phone_two | varchar(191) | YES | | NULL | | | latitude | varchar(191) | YES | | NULL | | | longitude | varchar(191) | YES | | NULL | | | timings | text | YES | | NULL | | | is_default | tinyint(1) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | show_address | tinyint(1) | YES | | 1 | | | hide_timings | tinyint(1) | NO | | 0 | | | hide_phone | tinyint(1) | YES | | 0 | | | hide_email | tinyint(1) | YES | | 0 | | +----------------+------------------+------+-----+---------+----------------+ 24 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `business_packages`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | business_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `businessdetails`; +--------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | profile_pic | varchar(191) | YES | | NULL | | | primary_email | varchar(191) | YES | | NULL | | | email | varchar(191) | YES | | NULL | | | store_from | varchar(191) | YES | | NULL | | | store_to | varchar(191) | YES | | NULL | | | background_image | varchar(191) | YES | | NULL | | | business_name | varchar(191) | NO | | NULL | | | logo | varchar(191) | YES | | NULL | | | category | varchar(191) | NO | | NULL | | | description | text | YES | | NULL | | | facebook_page_id | varchar(191) | YES | | NULL | | | google_page_id | varchar(191) | YES | | NULL | | | linkedin_page_id | varchar(191) | YES | | NULL | | | city | varchar(191) | YES | | NULL | | | domain | varchar(191) | NO | UNI | NULL | | | country | varchar(191) | YES | | NULL | | | countries_id | int(11) | YES | | NULL | | | g_longtitude | varchar(191) | YES | | NULL | | | g_lattitude | varchar(191) | YES | | NULL | | | phone_code_1 | varchar(191) | YES | | NULL | | | number_1 | varchar(191) | YES | | NULL | | | phone_code_2 | varchar(191) | YES | | NULL | | | number_2 | varchar(191) | YES | | NULL | | | website_link | varchar(400) | YES | | NULL | | | address | longtext | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | logoPath | varchar(191) | YES | | NULL | | | backgroundImagePath | varchar(191) | YES | | NULL | | | sub_locality | varchar(191) | YES | | NULL | | | pincode | varchar(191) | YES | | NULL | | | address_1 | varchar(191) | YES | | NULL | | | state | varchar(191) | YES | | NULL | | | to_meridian | varchar(191) | NO | | pm | | | from_meridian | varchar(191) | NO | | am | | | trial | int(11) | NO | | 0 | | | isMapped | tinyint(1) | NO | | 0 | | | paid_by_affiliate | tinyint(1) | NO | | 0 | | | deleted_at | timestamp | YES | | NULL | | | closed_on | varchar(191) | YES | | NULL | | | created_by | int(10) unsigned | YES | | NULL | | | infrastructure_user_id | varchar(191) | YES | | NULL | | | infrastructure_user_contact_id | varchar(191) | YES | | NULL | | | invoice_id | varchar(191) | YES | MUL | NULL | | | order_id | varchar(191) | YES | MUL | NULL | | | is_charged | int(10) unsigned | YES | | NULL | | | countryCode | varchar(191) | YES | | NULL | | | currency | varchar(191) | YES | | NULL | | | dns_invoice_id | varchar(191) | YES | | NULL | | | dns_order_id | varchar(191) | YES | | NULL | | | dns_created_date | date | YES | | NULL | | | dns_expiry_date | date | YES | | NULL | | | created_via | varchar(191) | YES | | NULL | | | keywords | text | YES | | NULL | | | partner_account_id | int(10) unsigned | YES | MUL | NULL | | | automenu | tinyint(1) | YES | | 1 | | | facebook_link | varchar(400) | YES | | NULL | | | twitter_link | varchar(400) | YES | | NULL | | | youtube_link | varchar(400) | YES | | NULL | | | pinterest_link | varchar(400) | YES | | NULL | | | linkedin_link | varchar(400) | YES | | NULL | | | googleplus_link | varchar(400) | YES | | NULL | | | instagram_link | varchar(400) | YES | | NULL | | | quora_link | varchar(400) | YES | | NULL | | | gst_no | varchar(191) | YES | | NULL | | | year_est | varchar(191) | YES | | NULL | | | no_employees | varchar(191) | YES | | NULL | | | legal_status | varchar(191) | YES | | NULL | | | annual_turnover | varchar(191) | YES | | NULL | | | allowed_locations | int(11) | YES | | 1 | | | lead_assignment_status | varchar(14) | YES | | | | | favicon_path | varchar(300) | YES | | NULL | | | favicon_name | varchar(300) | YES | | NULL | | | meta_title | varchar(150) | YES | | NULL | | | meta_description | varchar(200) | YES | | NULL | | +--------------------------------+------------------+------+-----+---------+----------------+ 77 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `carousel_configs`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | file_id | int(10) unsigned | NO | MUL | NULL | | | has_carousel_link | tinyint(1) | NO | | 0 | | | carousel_link | varchar(191) | YES | | NULL | | | content | text | YES | | NULL | | | has_btn | tinyint(1) | NO | | 0 | | | btn_name | varchar(191) | YES | | NULL | | | btn_url | varchar(191) | YES | | NULL | | | active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `carousel_files`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | file_id | int(10) unsigned | NO | MUL | NULL | | | fb_id | varchar(191) | YES | | NULL | | | status | varchar(191) | YES | | | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `carousels`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | path | varchar(200) | YES | | NULL | | | master | varchar(200) | YES | | NULL | | | desktop | varchar(200) | YES | | NULL | | | tablet | varchar(200) | YES | | NULL | | | mobile | varchar(200) | YES | | NULL | | | has_carousel_link | tinyint(1) | NO | | 0 | | | carousel_link | varchar(191) | YES | | NULL | | | content | text | YES | | NULL | | | has_btn | tinyint(1) | NO | | 0 | | | btn_name | varchar(191) | YES | | NULL | | | btn_url | varchar(191) | YES | | NULL | | | active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 15 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `categories`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | parent_id | int(10) unsigned | YES | MUL | NULL | | | order | int(11) | NO | | 1 | | | name | varchar(191) | NO | | NULL | | | slug | varchar(191) | NO | UNI | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `chartmogul_customers`; +------------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | customer_uuid | varchar(64) | NO | | NULL | | | customer_external_id | varchar(64) | NO | | NULL | | | data_source_identifier | varchar(16) | NO | | NULL | | +------------------------+-------------+------+-----+---------+----------------+ 4 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `cities`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | MUL | NULL | | | state_id | int(10) unsigned | NO | MUL | NULL | | | is_active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `city_stats`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | city | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `click_stats`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | type | varchar(191) | YES | | NULL | | | data_point | date | YES | | NULL | | | clicks | int(10) unsigned | NO | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `client_permissions`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | guard_name | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `client_roles`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | guard_name | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `commission_logs`; +---------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | business_id | int(10) unsigned | NO | MUL | NULL | | | business_name | varchar(191) | NO | | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | packageorder_id | int(10) | NO | | NULL | | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | total_amount | double(16,2) | NO | | 0.00 | | | currency | varchar(191) | NO | | NULL | | | partner_commission_amount | double(16,2) | NO | | 0.00 | | | partner_commission_type | int(10) | NO | | 0 | | | partner_commission_value | double(16,2) | NO | | 0.00 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +---------------------------+------------------+------+-----+---------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `countries`; +---------------------------+------------------+------+-----+--------------------------------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------+------------------+------+-----+--------------------------------------------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | shortname | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | phonecode | int(11) | NO | | NULL | | | currency_name | varchar(191) | YES | | NULL | | | currency_code | varchar(191) | YES | | NULL | | | currency_symbol | varchar(191) | YES | | NULL | | | country_numeric_code | varchar(191) | YES | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | payment_gateway | varchar(191) | NO | | 1:3:4 | | | payment_gateway_title | varchar(191) | NO | | Pay via Card:Pay via E-wallet:Pay via Card | | | alternate_payment_gateway | varchar(191) | NO | | 5:6:7 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +---------------------------+------------------+------+-----+--------------------------------------------+----------------+ 15 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `country_stats`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | country | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `delete_requests`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | token | varchar(191) | NO | | NULL | | | comment | varchar(400) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `delete_subscriptions`; +------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | website_id | int(11) | NO | | NULL | | | token | varchar(191) | YES | | NULL | | | comment | int(11) | YES | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | | | deleted_at | timestamp | YES | | NULL | | +------------+--------------+------+-----+---------------------+----------------+ 7 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `device_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | family | varchar(191) | NO | | NULL | | | brand | varchar(191) | NO | | NULL | | | model | varchar(191) | NO | | NULL | | | type | varchar(191) | NO | | NULL | | | sensitivity | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `discount_codes`; +---------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | code | varchar(191) | NO | | NULL | | | type | varchar(191) | NO | | NULL | | | value | int(10) unsigned | NO | | NULL | | | expiry | varchar(191) | YES | | NULL | | | is_recurring | tinyint(1) | YES | | 0 | | | is_active | tinyint(1) | YES | | 1 | | | on_offer_price | tinyint(1) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | customized_discount_value | varchar(191) | YES | | NULL | | +---------------------------+------------------+------+-----+---------+----------------+ 11 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `discoveries`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | search_query | varchar(191) | NO | | NULL | | | location | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `domain_cloudflare`; +---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | user_key | varchar(191) | YES | | NULL | | | user_api_key | varchar(191) | YES | | NULL | | | cloudflare_username | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | passwrd | varchar(191) | YES | | NULL | | +---------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `domain_configs`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | domain_id | int(10) unsigned | NO | MUL | NULL | | | config | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | domain_expires_on | date | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `domain_promo_codes`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | code | varchar(191) | NO | | NULL | | | tld | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `domains`; +-------------+------------------+------+-----+----------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+----------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | websites | | | status | varchar(191) | NO | | NULL | | | tld | varchar(191) | YES | | co | | | co | varchar(191) | YES | | in | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | full_domain | varchar(191) | YES | MUL | NULL | | | nameservers | text | YES | | NULL | | | zone_id | text | YES | | NULL | | | provider_id | int(10) | YES | | 0 | | | is_free | tinyint(1) | YES | | 0 | | +-------------+------------------+------+-----+----------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_customer_accounts`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | email | varchar(191) | NO | | NULL | | | password | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | 0 | | | remember_token | varchar(191) | YES | | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | email_verified_at | timestamp | YES | | NULL | | | token | varchar(255) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `ecom_customer_addresses`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | c_account_id | int(10) unsigned | NO | MUL | NULL | | | type | varchar(191) | YES | | BILLING | | | address | varchar(191) | YES | | NULL | | | landmark | varchar(191) | YES | | NULL | | | city_id | int(10) unsigned | YES | MUL | NULL | | | state_id | int(10) unsigned | YES | MUL | NULL | | | country_id | int(10) unsigned | YES | MUL | NULL | | | pincode | varchar(191) | YES | | NULL | | | phonecode | varchar(191) | YES | | NULL | | | phone | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_customer_details`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | c_account_id | int(10) unsigned | NO | MUL | NULL | | | c_id | varchar(191) | YES | | NULL | | | name | varchar(191) | YES | | NULL | | | email | varchar(191) | YES | | NULL | | | phonecode | varchar(191) | YES | | NULL | | | phone | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_invoices`; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | ecom_order_id | int(10) unsigned | NO | MUL | NULL | | | invoice_no | int(10) unsigned | NO | | NULL | | | invoice_year | varchar(191) | NO | | NULL | | | path | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +---------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_order_statuses`; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ecom_order_id | int(10) unsigned | NO | MUL | NULL | | | status | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +---------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_orders`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | o_id | varchar(191) | NO | | NULL | | | c_account_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | payment_type | varchar(191) | YES | | NULL | | | currency | varchar(191) | YES | | NULL | | | total_amt | double | YES | | NULL | | | summary | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_payment_settings`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | type | varchar(191) | YES | | NULL | | | value | text | YES | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_settings`; `; +--------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | currency | varchar(191) | YES | | INR | | | has_currency_conversion | tinyint(1) | YES | | 0 | | | has_tax | tinyint(1) | YES | | 0 | | | has_rating | tinyint(1) | YES | | 0 | | | has_review | tinyint(1) | YES | | 0 | | | has_inventory_management | tinyint(1) | NO | | 1 | | | send_invoice | tinyint(1) | NO | | 1 | | | active | tinyint(1) | YES | | 0 | | | is_shipping_on_item_quantities | int(10) | YES | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------------------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_shipping_settings`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | weight_unit | varchar(191) | YES | | NULL | | | dimension_unit | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `ecom_tax_settings`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | label | varchar(191) | YES | | NULL | | | type | varchar(191) | YES | | NULL | | | value | double(15,2) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `email_configs`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | config | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `email_logs`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | YES | MUL | NULL | | | email | varchar(191) | NO | | | | | email_type | varchar(191) | NO | | | | | message | longtext | NO | | NULL | | | statuscode | int(10) unsigned | NO | | 200 | | | response | longtext | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `email_payments`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | type | varchar(191) | NO | | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | token | varchar(250) | NO | | NULL | | | url | varchar(300) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `email_verification_push_schedules`; +-------------------+---------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------------------------------+------+-----+---------+----------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | user_id | bigint(20) unsigned | NO | MUL | NULL | | | notification_type | varchar(60) | NO | MUL | NULL | | | job_id | varchar(120) | NO | UNI | NULL | | | scheduled_time | timestamp | YES | MUL | NULL | | | executed_at | timestamp | YES | | NULL | | | status | enum('pending','sent','cancelled','failed') | NO | MUL | pending | | | payload | longtext | YES | | NULL | | | execution_result | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+---------------------------------------------+------+-----+---------+----------------+ 11 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `enquiries`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | email | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | phone | varchar(191) | YES | | NULL | | | product_id | int(10) unsigned | YES | MUL | NULL | | | message | longtext | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `event_offers`; DESCRIBE `facebook_import_auths`; +---------------------+---------------------------+------+-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+---------------------------+------+-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | title | varchar(20) | YES | | Special Offer | | | offer_text_line_1 | varchar(20) | YES | | Pay For 1 MONTH | | | offer_text_line_2 | varchar(20) | YES | | GET | | | offer_text_line_3 | varchar(20) | YES | | 1 MONTH Free | | | btn_conf | varchar(500) | YES | | {"text": "Buy Now","link": "subscriptions.fetch"} | | | offer_element_style | varchar(1000) | YES | | {"primary_color": "#A78700","secondary_color": "#FFFFFF","popup": {"background_color": "#f9e0b0","background_image": "/dashboard/img/offer2.png"},"banner": {"background_color": "#f9e0b0","background_image": "/img/ecommerce-promo-banner-bg.png"}} | | | offer_start | datetime | YES | | NULL | | | offer_end | datetime | YES | | NULL | | | is_popup | tinyint(1) | YES | | 1 | | | is_banner | tinyint(1) | YES | | 1 | | | popup_show_after | int(11) | YES | | 30 | | | country_condition | enum('include','exclude') | YES | | include | | | in_countries | varchar(500) | YES | | * | | | is_active | tinyint(1) | YES | | 1 | | | discount_code_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | current_timestamp() | | | updated_at | timestamp | YES | | current_timestamp() | on update current_timestamp() | | deleted_at | timestamp | YES | | NULL | | +---------------------+---------------------------+------+-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ 19 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `facebook_import_auths`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | YES | | NULL | | | email | varchar(191) | YES | | NULL | | | provider_id | varchar(191) | YES | | NULL | | | token | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `facebook_pages`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | provider_id | varchar(191) | NO | | NULL | | | page_id | varchar(191) | NO | | NULL | | | page_token | longtext | NO | | NULL | | | permissions | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | category | varchar(191) | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 11 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `failed_jobs`; +------------+---------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------------------+----------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | connection | text | NO | | NULL | | | queue | text | NO | | NULL | | | payload | longtext | NO | | NULL | | | exception | longtext | NO | | NULL | | | failed_at | timestamp | NO | | current_timestamp() | | +------------+---------------------+------+-----+---------------------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `files`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | type | int(11) | NO | | NULL | | | mime | varchar(191) | NO | | NULL | | | original_name | varchar(191) | NO | | NULL | | | filename | varchar(191) | NO | | NULL | | | size | int(10) unsigned | NO | | NULL | | | description | longtext | YES | | NULL | | | created_by | int(10) unsigned | NO | | NULL | | | path | varchar(191) | YES | | NULL | | | status | varchar(191) | YES | | | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | url | varchar(191) | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 16 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `google_payment`; +-----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | google_payment_object | text | YES | | NULL | | | expiry_date | datetime | YES | | NULL | | | token | varchar(300) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `hit_logs`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | ip | varchar(45) | NO | | NULL | | | referer | text | YES | | NULL | | | source | varchar(191) | NO | | NULL | | | url | longtext | NO | MUL | NULL | | | header | text | YES | | NULL | | | query | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | user_agent | text | YES | | NULL | | | city | varchar(191) | YES | | NULL | | | country | varchar(191) | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 15 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `hit_logs_1`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | ip | varchar(45) | NO | | NULL | | | referer | text | YES | | NULL | | | source | varchar(191) | NO | | NULL | | | url | longtext | NO | MUL | NULL | | | header | text | YES | | NULL | | | query | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | user_agent | text | YES | | NULL | | | city | varchar(191) | YES | | NULL | | | country | varchar(191) | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 15 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `hit_logs_ext`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | hit_log_id | int(10) unsigned | YES | MUL | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | searched_query | varchar(255) | NO | | | | | city | varchar(191) | NO | | | | | country | varchar(191) | NO | | | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `integration_services`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | code | varchar(191) | YES | | NULL | | | name | varchar(191) | NO | | NULL | | | description | text | YES | | NULL | | | url | varchar(191) | YES | | NULL | | | logo | varchar(191) | YES | | NULL | | | file_name | varchar(191) | YES | | NULL | | | fields | text | YES | | NULL | | | help_url | varchar(500) | YES | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | is_trial | tinyint(1) | NO | | 0 | | +-------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `invoices`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | code | varchar(191) | NO | | NULL | | | invoice_no | int(10) unsigned | YES | | NULL | | | invoice_year | varchar(191) | YES | | NULL | | | business_id | int(10) unsigned | NO | MUL | NULL | | | packageorder_id | int(10) unsigned | NO | MUL | NULL | | | payment_id | varchar(191) | NO | | NULL | | | payment_request_id | varchar(191) | NO | | NULL | | | payment_method | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `jobs`; +--------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+----------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | queue | varchar(191) | NO | MUL | NULL | | | payload | longtext | NO | | NULL | | | attempts | tinyint(3) unsigned | NO | | NULL | | | reserved_at | int(10) unsigned | YES | | NULL | | | available_at | int(10) unsigned | NO | | NULL | | | created_at | int(10) unsigned | NO | | NULL | | +--------------+---------------------+------+-----+---------+----------------+ 7 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `languages`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | YES | | NULL | | | code | varchar(191) | YES | | NULL | | | active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `line_items`; +-----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | packageorder_id | int(10) unsigned | NO | MUL | NULL | | | type | varchar(191) | NO | | NULL | | | label | varchar(191) | NO | | NULL | | | value | int(11) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `local_pricings`; +---------------+------------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+------------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | country_id | int(10) unsigned | NO | MUL | NULL | | | currency_rate | decimal(15,8) | NO | | 1.00000000 | | | is_active | tinyint(1) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +---------------+------------------+------+-----+------------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `location_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | city | varchar(191) | YES | | NULL | | | country | varchar(191) | YES | | NULL | | | count | int(10) unsigned | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `manage_tooltip`; +--------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | dashboard_tooltip | varchar(20) | NO | | 0 | | | package_list_tooltip | varchar(20) | NO | | 0 | | | summary_screen_tooltip | varchar(20) | NO | | 0 | | | update_manage_tooltip | varchar(20) | NO | | 0 | | | update_category_tooltip | varchar(20) | NO | | 0 | | | product_category_tooltip | varchar(20) | NO | | 0 | | | product_list_tooltip | varchar(20) | NO | | 0 | | | product_attribute_tooltip | varchar(20) | NO | | 0 | | | product_shipping_tooltip | varchar(20) | NO | | 0 | | | product_ecommerce_tooltip | varchar(20) | NO | | 0 | | | media_list_tooltip | varchar(20) | NO | | 0 | | | page_list_tooltip | varchar(20) | NO | | 0 | | | template_list_tooltip | varchar(20) | NO | | 0 | | | extra_section_list_tooltip | varchar(20) | NO | | 0 | | | extra_sub_section_list_tooltip | varchar(20) | NO | | 0 | | | slider_list_tooltip | varchar(20) | NO | | 0 | | | subscribes_list_tooltip | varchar(20) | NO | | 0 | | | general_enquiries_list_tooltip | varchar(20) | NO | | 0 | | | order_enquiries_list_tooltip | varchar(20) | NO | | 0 | | | integration_list_tooltip | varchar(20) | NO | | 0 | | | reward_ads_tooltip | varchar(20) | NO | | 0 | | | menu_screen_tooltip | varchar(20) | NO | | 0 | | | ecommerce_general_info | varchar(20) | NO | | 0 | | | ecommerce_tax_info | varchar(20) | NO | | 0 | | | ecommerce_payment_info | varchar(20) | NO | | 0 | | | ecommerce_shipping_info | varchar(20) | NO | | 0 | | | customization_update_info | varchar(20) | NO | | 0 | | | customization_product_info | varchar(20) | NO | | 0 | | | customization_media_info | varchar(20) | NO | | 0 | | | customization_search_info | varchar(20) | NO | | 0 | | | customization_sitemap_info | varchar(20) | NO | | 0 | | | customization_footer_info | varchar(20) | NO | | 0 | | | customization_style_info | varchar(20) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | seo_tab_tooltip | varchar(20) | NO | | 0 | | | ai_content_history | varchar(20) | NO | | 0 | | | ai_image_history | varchar(20) | NO | | 0 | | | ai_page_tooltip | varchar(20) | NO | | 0 | | | ai_page_package | varchar(20) | NO | | 0 | | +--------------------------------+------------------+------+-----+---------+----------------+ 43 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `media`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fb_id | varchar(191) | YES | | NULL | | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | url | varchar(191) | YES | MUL | NULL | | | type | int(11) | NO | | NULL | | | title | varchar(191) | YES | | NULL | | | description | longtext | YES | | NULL | | | has_btn | tinyint(1) | NO | | 0 | | | btn_name | varchar(191) | YES | | NULL | | | btn_url | varchar(191) | YES | | NULL | | | keywords | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | path | varchar(191) | YES | | NULL | | | published | int(11) | NO | | 1 | | | deleted_at | timestamp | YES | | NULL | | | viewLink | varchar(191) | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | viewCount | int(10) unsigned | NO | | 0 | | | is_draft | int(11) | NO | | 0 | | +--------------------+------------------+------+-----+---------+----------------+ 21 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `media_files`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | media_id | int(10) unsigned | NO | MUL | NULL | | | files_id | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `media_seo`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | meta_title | varchar(190) | YES | | NULL | | | meta_description | varchar(255) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | meta_keyword | varchar(255) | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `media_seo_tags`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | seo_tags_id | int(10) unsigned | NO | MUL | NULL | | | media_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `media_social`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | media_id | int(10) unsigned | NO | MUL | NULL | | | fb_id | varchar(191) | YES | | NULL | | | pin_id | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `migrations`; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | migration | varchar(191) | NO | | NULL | | | batch | int(11) | NO | | NULL | | +-----------+------------------+------+-----+---------+----------------+ 3 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `model_has_permissions`; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | permission_id | int(10) unsigned | NO | PRI | NULL | | | model_id | int(10) unsigned | NO | PRI | NULL | | | model_type | varchar(191) | NO | | NULL | | +---------------+------------------+------+-----+---------+-------+ 3 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `model_has_roles`; +------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+-------+ | role_id | int(10) unsigned | NO | PRI | NULL | | | model_id | int(10) unsigned | NO | PRI | NULL | | | model_type | varchar(191) | NO | | NULL | | +------------+------------------+------+-----+---------+-------+ 3 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `mojo_payment_details`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | buyer_email | varchar(191) | NO | | NULL | | | buyer_name | varchar(191) | NO | | NULL | | | buyer_phone | varchar(191) | NO | | NULL | | | currency | varchar(191) | NO | | NULL | | | amount | varchar(191) | NO | | NULL | | | fees | varchar(191) | NO | | NULL | | | longurl | varchar(191) | NO | | NULL | | | payment_id | varchar(191) | NO | | NULL | | | payment_request_id | varchar(191) | NO | | NULL | | | purpose | varchar(191) | NO | | NULL | | | shorturl | varchar(191) | YES | | NULL | | | request_status | varchar(191) | NO | | NULL | | | payment_status | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 17 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `mojo_refund_details`; DESCRIBE `notifications`; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | refund_id | varchar(191) | NO | | NULL | | | payment_id | varchar(191) | NO | | NULL | | | status | varchar(191) | NO | | NULL | | | type | varchar(191) | NO | | NULL | | | body | varchar(191) | NO | | NULL | | | refund_amount | varchar(191) | NO | | NULL | | | total_amount | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +---------------+------------------+------+-----+---------+----------------+ 11 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `notifications`; +-----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------+-------+ | id | char(36) | NO | PRI | NULL | | | type | varchar(191) | NO | | NULL | | | notifiable_id | int(10) unsigned | NO | MUL | NULL | | | notifiable_type | varchar(191) | NO | | NULL | | | data | text | NO | | NULL | | | read_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------+------------------+------+-----+---------+-------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `orders`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | product_id | int(10) unsigned | YES | MUL | NULL | | | quantity | int(10) unsigned | YES | | 1 | | | unit | varchar(191) | YES | | NULL | | | email | varchar(191) | NO | | NULL | | | phone | varchar(191) | YES | | NULL | | | message | longtext | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | name | varchar(191) | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `organic_search_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | YES | MUL | NULL | | | keyword | longtext | NO | | NULL | | | hostname | varchar(191) | NO | | | | | dateForDatapoint | datetime | YES | | NULL | | | organic_searches | int(10) unsigned | NO | | 0 | | | sessions | int(10) unsigned | NO | | 0 | | | hits | int(10) unsigned | NO | | 0 | | | is_processed | int(10) unsigned | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `os_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | os | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `package_categories`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | code | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `package_orders`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | business_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | status | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `package_types`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `packages`; DESCRIBE `packages_country_data`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | category_id | int(10) unsigned | NO | MUL | NULL | | | code | varchar(191) | NO | MUL | NULL | | | title | varchar(191) | NO | | NULL | | | description | text | NO | | NULL | | | features | text | YES | | NULL | | | packagetype_id | int(10) unsigned | NO | MUL | NULL | | | is_trial | tinyint(1) | NO | MUL | 0 | | | expiry | int(10) unsigned | YES | MUL | NULL | | | currency | varchar(191) | YES | | NULL | | | price | int(10) unsigned | YES | MUL | NULL | | | prices | text | YES | | NULL | | | billing_type | varchar(191) | YES | MUL | NULL | | | billing_period | int(10) unsigned | YES | MUL | NULL | | | introductory_price | int(10) unsigned | YES | | NULL | | | has_offer | tinyint(1) | NO | | 0 | | | offer_price | int(10) unsigned | YES | | NULL | | | offer_billing_type | varchar(191) | YES | | NULL | | | offer_expires | varchar(191) | YES | | NULL | | | grace_period | int(10) unsigned | YES | | NULL | | | has_tax | tinyint(1) | NO | MUL | 1 | | | is_default | tinyint(1) | NO | MUL | 0 | | | is_active | tinyint(1) | NO | MUL | 1 | | | publish | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 27 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `packages_country_data`; +-----------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | currency_code | varchar(191) | YES | | NULL | | | country_code | varchar(191) | YES | | NULL | | | currency_symbol | varchar(191) | YES | | NULL | | | amount | int(11) | YES | | NULL | | | package_id | smallint(6) | YES | | NULL | | | offer | tinyint(4) | YES | | 0 | | | created_at | timestamp | YES | | current_timestamp() | | | updated_at | timestamp | YES | | current_timestamp() | | | deleted_at | timestamp | YES | | NULL | | +-----------------+--------------+------+-----+---------------------+----------------+ 10 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `packages_discountcodes`; +------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | package_id | int(10) unsigned | NO | PRI | NULL | | | discount_code_id | int(10) unsigned | NO | PRI | NULL | | +------------------+------------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `packages_rules`; +------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+-------+ | package_id | int(10) unsigned | NO | PRI | NULL | | | rule_id | int(10) unsigned | NO | PRI | NULL | | +------------+------------------+------+-----+---------+-------+ 2 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `page_files`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | pages_id | int(10) unsigned | NO | MUL | NULL | | | files_id | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `page_stats`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | stats | longtext | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `pages`; +------------------+---------------------------+------+-----+----------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------------+------+-----+----------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | author_id | int(11) | NO | | NULL | | | title | varchar(191) | NO | | NULL | | | excerpt | text | YES | | NULL | | | body | text | YES | | NULL | | | image | varchar(191) | YES | | NULL | | | slug | varchar(191) | NO | UNI | NULL | | | meta_description | text | YES | | NULL | | | meta_keywords | text | YES | | NULL | | | status | enum('ACTIVE','INACTIVE') | NO | | INACTIVE | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +------------------+---------------------------+------+-----+----------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `pages_seo_tags`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | seo_tags_id | int(10) unsigned | NO | MUL | NULL | | | pages_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_accounts`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | email | varchar(191) | NO | UNI | NULL | | | password | varchar(191) | NO | | NULL | | | saved_psd | varchar(191) | YES | | NULL | | | is_active | tinyint(1) | NO | | 0 | | | website_id | int(10) | YES | | NULL | | | remember_token | varchar(100) | YES | | NULL | | | email_verified_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_details`; +---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | parent | int(10) unsigned | YES | MUL | NULL | | | code | varchar(191) | NO | UNI | NULL | | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | | NULL | | | phone | varchar(191) | NO | | NULL | | | company_name | varchar(191) | NO | | NULL | | | gstin | varchar(191) | YES | | NULL | | | uidai | varchar(191) | YES | | NULL | | | address | varchar(191) | YES | | NULL | | | sublocality | varchar(191) | YES | | NULL | | | city_id | int(10) unsigned | YES | MUL | NULL | | | state_id | int(10) unsigned | YES | MUL | NULL | | | country_id | int(10) unsigned | YES | MUL | NULL | | | pincode | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | account_holder_name | varchar(191) | YES | | | | | paypal_email | varchar(191) | YES | | NULL | | | account_number | varchar(191) | YES | | | | | bank_name | varchar(191) | YES | | | | | ifsc_code | varchar(191) | YES | | | | | swift_code | varchar(191) | YES | | | | | micr_code | varchar(191) | YES | | | | +---------------------+------------------+------+-----+---------+----------------+ 25 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `partner_license_histories`; +------------------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | type | enum('ADD','DEDUCT') | NO | | NULL | | | licenses | decimal(16,2) | YES | | 0.00 | | | grace_licenses | decimal(16,2) | YES | | 0.00 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | licenses_credits | int(10) unsigned | YES | | 0 | | | grace_licenses_credits | int(10) unsigned | YES | | 0 | | +------------------------+----------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_license_usages`; +---------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | license_used | decimal(16,2) | YES | | 0.00 | | | amount_paid | int(10) unsigned | YES | | NULL | | | amount_balance | int(10) unsigned | YES | | NULL | | | payment_proof_image | varchar(1000) | YES | | NULL | | | comment | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | licenses_credits_utilized | int(10) unsigned | YES | | 0 | | +---------------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `partner_licenses`; DESCRIBE `partner_payout_logs`; +--------------------------------+------------------+------+-----+-----------------------------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------+------------------+------+-----+-----------------------------------------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | licenses | decimal(16,2) | YES | | 0.00 | | | grace_licenses | decimal(16,2) | YES | | 0.00 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | licenses_credits | int(10) unsigned | YES | | 0 | | | grace_licenses_credits | int(10) unsigned | YES | | 0 | | | is_domain_purchase_included | tinyint(4) | YES | | 0 | | | revenue_sharing_rule | varchar(191) | YES | | 0:30-0:30,0:30-0:30,0:30-0:30,0:30-0:30 | | | revenue_outstanding | double(16,2) | YES | | 0.00 | | | revenue_commission_outstanding | double(16,2) | YES | | 0.00 | | | last_payout_on | datetime | YES | | NULL | | +--------------------------------+------------------+------+-----+-----------------------------------------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_payout_logs`; +------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+------------------+------+-----+---------+----------------+ | partner_payout_logs_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_account_id | int(10) unsigned | NO | MUL | NULL | | | date | datetime | YES | | NULL | | | currency | varchar(191) | YES | | INR | | | amount | double(16,2) | NO | | 0.00 | | | amount_commission | double(16,2) | NO | | 0.00 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_requests`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | type | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | company_name | varchar(191) | YES | | NULL | | | email | varchar(191) | NO | | NULL | | | phone | varchar(191) | NO | | 123 | | | gstin | varchar(191) | YES | | NULL | | | uidai | varchar(191) | YES | | NULL | | | city_id | int(10) unsigned | NO | MUL | NULL | | | status | varchar(191) | YES | | NULL | | | comment | text | YES | | NULL | | | is_accepted | tinyint(1) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partner_web_lead_mgmt_settings_map`; +---------------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------------------+------------------+------+-----+---------+----------------+ | partner_web_lead_mgmt_settings_map_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | partner_id | int(10) unsigned | NO | MUL | NULL | | | lattitude | varchar(191) | YES | | NULL | | | longitude | varchar(191) | YES | | NULL | | | cities_id | int(10) unsigned | YES | MUL | NULL | | | states_id | int(10) unsigned | YES | MUL | NULL | | | countries_id | int(10) unsigned | YES | MUL | NULL | | | role_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +---------------------------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partners_discountcodes`; +--------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+-------+ | partner_account_id | int(10) unsigned | NO | PRI | NULL | | | discount_code_id | int(10) unsigned | NO | PRI | NULL | | +--------------------+------------------+------+-----+---------+-------+ 2 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `partners_permissions`; +--------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+-------+ | partner_account_id | int(10) unsigned | NO | PRI | NULL | | | permission_id | int(10) unsigned | NO | PRI | NULL | | +--------------------+------------------+------+-----+---------+-------+ 2 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partners_roles`; +--------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+-------+ | partner_account_id | int(10) unsigned | NO | PRI | NULL | | | role_id | int(10) unsigned | NO | PRI | NULL | | +--------------------+------------------+------+-----+---------+-------+ 2 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `partners_website_lead_map`; +------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+------------------+------+-----+---------+----------------+ | partners_website_lead_map_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | partner_accounts_id | int(10) unsigned | NO | MUL | NULL | | | users_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------------------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `password_resets`; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | email | varchar(191) | NO | MUL | NULL | | | token | varchar(191) | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+--------------+------+-----+---------+-------+ 4 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `permissions`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | slug | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `pinterest_boards`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | board_id | varchar(191) | NO | | NULL | | | board_name | varchar(191) | NO | | NULL | | | board_url | varchar(191) | NO | | NULL | | | privacy | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `plans`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | description | longtext | NO | | NULL | | | plan_name | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `popups`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | YES | | NULL | | | content | text | YES | | NULL | | | has_btn | tinyint(1) | NO | | 0 | | | btn_name | varchar(191) | YES | | NULL | | | btn_url | varchar(191) | YES | | NULL | | | delay | int(10) unsigned | NO | | 5 | | | active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `posts`; +------------------+-------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------------------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | author_id | int(11) | NO | | NULL | | | category_id | int(11) | YES | | NULL | | | title | varchar(191) | NO | | NULL | | | seo_title | varchar(191) | YES | | NULL | | | excerpt | text | NO | | NULL | | | body | text | NO | | NULL | | | image | varchar(191) | YES | | NULL | | | slug | varchar(191) | NO | UNI | NULL | | | meta_description | text | NO | | NULL | | | meta_keywords | text | NO | | NULL | | | status | enum('PUBLISHED','DRAFT','PENDING') | NO | | DRAFT | | | featured | tinyint(1) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+-------------------------------------+------+-----+---------+----------------+ 17 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_attribute_values`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | product_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | attribute_id | int(11) | NO | MUL | NULL | | | type | tinyint(4) | NO | | NULL | | | value | varchar(100) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_blockautomations`; +---------------+---------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------------------+-------------------------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | keyword | varchar(191) | NO | | NULL | | | keyword_type | tinyint(2) unsigned | NO | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | on update current_timestamp() | | is_india_only | int(11) | YES | | 0 | | +---------------+---------------------+------+-----+---------------------+-------------------------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_categories`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | NO | | NULL | | | cover | varchar(191) | YES | | NULL | | | filter_attribute | varchar(50) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_files`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | products_id | int(10) unsigned | NO | MUL | NULL | | | files_id | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `product_seo`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | meta_title | varchar(190) | YES | | NULL | | | meta_description | varchar(255) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | meta_keyword | varchar(255) | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_seo_tags`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | seo_tags_id | int(10) unsigned | NO | MUL | NULL | | | products_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_social`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | product_id | int(10) unsigned | NO | MUL | NULL | | | fb_id | varchar(191) | YES | | NULL | | | pin_id | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `product_variation_combination`; +-----------------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------------------+------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | product_id | int(10) unsigned | NO | MUL | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | product_attributes_id_value_combination | varchar(50) | YES | | NULL | | | attributes_values | varchar(50) | YES | | NULL | | | price | int(11) | YES | | NULL | | | discount_type | tinyint(4) | YES | | NULL | | | discount | int(11) | YES | | NULL | | | discount_rule_id | int(11) | YES | | NULL | | | image | varchar(100) | YES | | NULL | | | path | varchar(100) | YES | | NULL | | | stock_count | int(11) | YES | | NULL | | | sku | varchar(50) | YES | | NULL | | | is_default | int(11) | YES | | NULL | | | fullfillment_message | text | YES | | NULL | | | fullfillment_type | tinyint(4) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------------------------------+------------------+------+-----+---------+----------------+ 19 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `products`; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fb_id | varchar(191) | YES | | NULL | | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | NO | | NULL | | | description | longtext | YES | | NULL | | | currency | varchar(191) | NO | MUL | NULL | | | price | decimal(20,2) | YES | | 0.00 | | | discount | decimal(20,2) | YES | | 0.00 | | | link | varchar(191) | YES | | NULL | | | priority | int(11) | YES | | NULL | | | daysToGetShipped | int(11) | YES | | NULL | | | availability | int(11) | YES | | NULL | | | freeShipping | int(11) | YES | | NULL | | | path | varchar(191) | YES | | NULL | | | image | varchar(191) | YES | | NULL | | | demoVideo | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | discountType | int(11) | YES | | NULL | | | cashOnDelivery | int(11) | YES | | NULL | | | viewLink | varchar(191) | YES | | NULL | | | listed | int(11) | NO | | 1 | | | shipping_charges | decimal(20,2) | YES | | 0.00 | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | shareOnSocial | int(11) | NO | | 0 | | | viewCount | int(10) unsigned | NO | | 0 | | | type | varchar(191) | YES | | NULL | | | condition | varchar(191) | YES | | NULL | | | category_id | int(10) unsigned | YES | MUL | NULL | | | sku | varchar(191) | YES | | NULL | | | fixed_price | decimal(20,2) | YES | | 0.00 | | | price_range_start | decimal(20,2) | YES | | 0.00 | | | price_range_end | decimal(20,2) | YES | | 0.00 | | | min_order_quantity | int(10) unsigned | YES | | NULL | | | unit | varchar(191) | YES | | NULL | | | stock_count | int(10) unsigned | YES | | NULL | | | btn_one_label | varchar(191) | YES | | NULL | | | btn_one_url | text | YES | | NULL | | | btn_two_label | varchar(191) | YES | | NULL | | | btn_two_url | text | YES | | NULL | | | default_btn_label | varchar(191) | YES | | NULL | | | keywords | text | YES | | NULL | | | return_policy | text | YES | | NULL | | | product_note | text | YES | | NULL | | | terms_and_conditions | text | YES | | NULL | | | has_variation | tinyint(4) | YES | | NULL | | | minimum_price | int(11) | YES | | NULL | | | maximum_price | int(11) | YES | | NULL | | | discounted_price_min | int(11) | YES | | NULL | | | discounted_price_max | int(11) | YES | | NULL | | | shipping_rules | varchar(60) | YES | | NULL | | | fulfillment_message | text | YES | | NULL | | | meta_title | varchar(150) | YES | | NULL | | | meta_description | varchar(200) | YES | | NULL | | | url_slug | varchar(150) | YES | | NULL | | | is_draft | int(11) | NO | | 0 | | +----------------------+------------------+------+-----+---------+----------------+ 58 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `referrer_stats`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | source | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `reseller_emails`; +--------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | domain_id | int(10) unsigned | NO | MUL | NULL | | | domain_name | varchar(255) | NO | | NULL | | | email_primary | varchar(255) | NO | UNI | NULL | |DE SCRIBE `re| email_secondary | varchar(255) | YES | UNI | NULL | | wards_ad_| passwd | varchar(255) | NO | | NULL | | cooldown| email_primary_verified | tinyint(1) | NO | | 0 | | `; | email_secondary_verified | tinyint(1) | NO | | 0 | | | web_mail_url | varchar(255) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `rewards_ad_cooldown`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | last_watched_at | timestamp | YES | | NULL | | | next_available_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `roles`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | slug | varchar(191) | NO | | NULL | | | name | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `roles_permissions`; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | role_id | int(10) unsigned | NO | PRI | NULL | | | permission_id | int(10) unsigned | NO | PRI | NULL | | +---------------+------------------+------+-----+---------+-------+ 2 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `rules`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | key | varchar(191) | NO | | NULL | | | value | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `search_stats`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | YES | MUL | NULL | | | searched_query | longtext | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `section`; +---------------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | website_id | int(10) | NO | | NULL | | | page_id | int(11) | YES | | NULL | | | section_title | varchar(100) | YES | | NULL | | | section_description | varchar(255) | YES | | NULL | | | section_cta_label | varchar(25) | YES | | NULL | | | section_cta_link | varchar(100) | YES | | NULL | | | max_allowed_items | int(11) | YES | | NULL | | | background | varchar(16) | YES | | NULL | | | text_colour | varchar(16) | YES | | NULL | | | display_order | int(11) | YES | | NULL | | | section_type | varchar(25) | NO | | NULL | | | created_at | datetime | NO | | current_timestamp() | | | updated_at | datetime | NO | | current_timestamp() | | | deleted_at | datetime | YES | | NULL | | +---------------------+--------------+------+-----+---------------------+----------------+ 15 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `sections_items`; +------------+-------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | item_name | varchar(20) | YES | | NULL | | | section_id | int(11) | NO | | NULL | | | data | text | YES | | NULL | | | created_at | datetime | NO | | current_timestamp() | | | updated_at | datetime | NO | | current_timestamp() | | +------------+-------------+------+-----+---------------------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `seo_tags`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | tags | varchar(191) | NO | UNI | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | status | varchar(191) | YES | | | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `shareacesses`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | website_name | varchar(191) | NO | | NULL | | | hasAccess | tinyint(1) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +--------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `shipping_rules`; DESCRIBE `site_menus`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | title | varchar(60) | YES | | NULL | | | ship_to | varchar(100) | YES | | NULL | | | service_name | varchar(60) | YES | | NULL | | | number_of_days | int(11) | YES | | NULL | | | cost | int(11) | YES | | NULL | | | cod | tinyint(4) | YES | | NULL | | | free_shipping | tinyint(4) | YES | | NULL | | | website_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | deleted | tinyint(4) | NO | | 0 | | +----------------+------------------+------+-----+---------+----------------+ 13 rows in set (0.008 sec) MariaDB [instaweb]> DESCRIBE `site_menus`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | label | varchar(100) | NO | | NULL | | | menu | varchar(100) | NO | | NULL | | | is_submenu | tinyint(1) | NO | | 0 | | | parent_menu_id | int(11) | YES | | NULL | | | url | varchar(191) | NO | | NULL | | | sequence | int(11) | NO | | NULL | | | status | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `sitemaps`; DESCRIBE `sms_logs`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | url | longtext | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | priority | int(11) | NO | | NULL | | | frequency | int(10) unsigned | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | url_hash | varchar(191) | YES | MUL | NULL | | +------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `sms_logs`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | YES | MUL | NULL | | | week | int(10) unsigned | NO | | 0 | | | mobile | varchar(191) | NO | | | | | message | longtext | NO | | NULL | | | statuscode | int(10) unsigned | NO | | 200 | | | response | longtext | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `social_auths`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | provider | varchar(191) | NO | | NULL | | | provider_id | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | token | longtext | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | tokenSecret | varchar(191) | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `social_stats`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | source | varchar(191) | NO | | NULL | | | count | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 9 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `states`; DESCRIBE `subdomain_redirect`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | country_id | int(10) unsigned | NO | MUL | NULL | | | is_active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `subdomain_redirect`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | source | int(10) unsigned | NO | MUL | NULL | | | redirect | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `subdomain_websites`; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | subdomains_id | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +---------------+------------------+------+-----+---------+----------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `subdomains`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | domains_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | NO | MUL | @ | | | status | varchar(191) | NO | | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `subscribers`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | email | varchar(191) | NO | | NULL | | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | enquiry_id | int(10) unsigned | YES | MUL | NULL | | | product_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `sync_test2`; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.007 sec) MariaDB [instaweb]> DESCRIBE `sysconfig`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | type | varchar(191) | NO | MUL | NULL | | | value | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `taxes`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | country_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | NO | | NULL | | | value | int(10) unsigned | NO | | NULL | | | is_active | tinyint(1) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `template_customizations`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | key | varchar(191) | NO | MUL | NULL | | | value | longtext | YES | | NULL | | | data | longtext | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `templates`; +-----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | machine_name | varchar(191) | YES | | NULL | | | category_id | int(10) unsigned | YES | MUL | NULL | | | display_name | varchar(191) | NO | | | | | screenshot | int(10) unsigned | NO | MUL | NULL | | | css_folder_name | varchar(191) | NO | | css | | | js_folder_name | varchar(191) | NO | | js | | | isDefault | int(11) | NO | | 0 | | | is_private | tinyint(1) | NO | | 0 | | | default_style | varchar(255) | YES | | NULL | | +-----------------+------------------+------+-----+---------+----------------+ 14 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `transaction_logs`; +--------------------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------------+------------------+------+-----+---------+----------------+ | transaction_logs_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | invoices_id | int(10) unsigned | NO | MUL | NULL | | | order_id | varchar(191) | YES | | NULL | | | subscription_id | varchar(191) | YES | | NULL | | | invoice_number | varchar(191) | YES | | NULL | | | invoice_date | datetime | YES | | NULL | | | renewal_status | tinyint(4) | YES | | 0 | | | renewed_on | datetime | YES | | NULL | | | business_name | varchar(191) | YES | | NULL | | | user_tax_id | varchar(191) | YES | | NULL | | | package_details | varchar(191) | YES | | NULL | | | subscription_units | int(10) unsigned | NO | | NULL | | | payment_medium | varchar(191) | YES | | NULL | | | transaction_type | tinyint(4) | YES | | 0 | | | price | double(16,2) | NO | | 0.00 | | | price_addons | double(16,2) | NO | | 0.00 | | | total_tax_amount | double(16,2) | NO | | 0.00 | | | igst_amount | double(16,2) | NO | | 0.00 | | | cgst_amount | double(16,2) | NO | | 0.00 | | | sgst_amount | double(16,2) | NO | | 0.00 | | | additional_tax_amount | double(16,2) | NO | | 0.00 | | | total_amount | double(16,2) | NO | | 0.00 | | | transaction_currency | varchar(191) | YES | | NULL | | | total_amount_in_tran_curr | double(16,2) | NO | | 0.00 | | | coupon_code | varchar(191) | YES | | NULL | | | additional_offer | varchar(191) | YES | | NULL | | | email_id | varchar(191) | YES | | NULL | | | phone_number | varchar(191) | YES | | NULL | | | city_id | int(10) unsigned | YES | | NULL | | | state_id | int(10) unsigned | YES | | NULL | | | country_id | int(10) unsigned | YES | | NULL | | | payment_info | text | YES | | NULL | | | start_date | datetime | NO | | NULL | | | end_date | datetime | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | partner_account_id | int(10) unsigned | YES | | NULL | | | partner_commission_amount | double(16,2) | YES | | 0.00 | | | partner_commission_amount_ptner_curr | double(16,2) | YES | | 0.00 | | +--------------------------------------+------------------+------+-----+---------+----------------+ 43 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `unmap_requests`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | domain_id | int(10) unsigned | NO | MUL | NULL | | | token | varchar(191) | NO | | NULL | | | comment | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `update_categories`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | name | varchar(191) | NO | | NULL | | | url_slug | varchar(255) | YES | | NULL | | | cover | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `update_category`; DESCRIBE `updates`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | update_id | int(10) unsigned | NO | MUL | NULL | | | category_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.008 sec) MariaDB [instaweb]> DESCRIBE `updates`; +----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fb_id | varchar(191) | YES | | NULL | | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | image | varchar(191) | YES | | NULL | | | doc_path | varchar(191) | YES | | NULL | | | description | longtext | NO | | NULL | | | title | longtext | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | imagePath | varchar(191) | YES | | NULL | | | location | longtext | YES | | NULL | | | sendToAll | int(11) | NO | | 0 | | | is_pinned | tinyint(1) | NO | | 0 | | | viewLink | varchar(191) | YES | | NULL | | | backup_viewlink | varchar(255) | YES | | NULL | | | youtube_url | varchar(191) | NO | | | | | published | int(11) | NO | | 1 | | | deleted_at | timestamp | YES | | NULL | | | shareOnSocial | varchar(191) | NO | | 0 | | | website_id | int(10) unsigned | YES | MUL | NULL | | | viewCount | int(10) unsigned | NO | | 0 | | | is_event | tinyint(3) unsigned | YES | | 0 | | | start_date_time | varchar(191) | YES | | NULL | | | end_date_time | varchar(191) | YES | | NULL | | | lat | varchar(191) | YES | | NULL | | | lng | varchar(191) | YES | | NULL | | | has_button | tinyint(3) unsigned | YES | | 0 | | | custom_btn_label | varchar(191) | YES | | NULL | | | custom_btn_url | varchar(191) | YES | | NULL | | | keywords | text | YES | | NULL | | | business_location_id | int(10) unsigned | YES | MUL | NULL | | | is_schedule | int(11) | NO | | 0 | | | when_live | timestamp | YES | | NULL | | | schedule_timezone | varchar(20) | YES | | GMT | | | is_draft | int(11) | NO | | 0 | | | when_live1 | timestamp | YES | | NULL | | | meta_title | varchar(150) | YES | | NULL | | | meta_description | varchar(200) | YES | | NULL | | | url_slug | varchar(150) | YES | | NULL | | +----------------------+---------------------+------+-----+---------+----------------+ 40 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `updates_blockautomations`; +---------------+---------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------------------+-------------------------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | keyword | varchar(191) | NO | | NULL | | | keyword_type | tinyint(2) unsigned | NO | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | on update current_timestamp() | | is_india_only | int(11) | YES | | 0 | | +---------------+---------------------+------+-----+---------------------+-------------------------------+ 6 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `updates_seo`; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | |D ESCRIB| meta_title | varchar(190) | YES | | NULL | | E `u| meta_description | varchar(255) | YES | | NULL | | pdat| created_at | timestamp | YES | | NULL | | es_s| updated_at | timestamp | YES | | NULL | | ocia| deleted_at | timestamp | YES | | NULL | | l`;| meta_keyword | varchar(255) | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `updates_social`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | update_id | int(10) unsigned | NO | MUL | NULL | | | fb_id | varchar(191) | YES | | NULL | | | pin_id | varchar(191) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `upgrade_requests`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | planIdRquested | int(11) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `user_agent`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | hitlog_id | int(10) unsigned | NO | MUL | NULL | | | browser_family | varchar(191) | NO | | NULL | | | browser_version | varchar(191) | NO | | NULL | | | os_family | varchar(191) | NO | | NULL | | | os_version | varchar(191) | NO | | NULL | | | device_family | varchar(191) | NO | | NULL | | | device_brand | varchar(191) | NO | | NULL | | | device_model | varchar(191) | NO | | NULL | | | device_type | varchar(191) | NO | | NULL | | | device_sensitivity | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 15 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `user_devices`; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | uid | int(10) unsigned | NO | MUL | NULL | | | deviceTypeId | int(10) unsigned | NO | MUL | NULL | | | modelNo | varchar(191) | NO | | NULL | | | serialNo | varchar(191) | NO | | NULL | | | os | varchar(191) | NO | | NULL | | | osVersion | varchar(191) | NO | | NULL | | | appVersion | varchar(191) | YES | | NULL | | | token | varchar(191) | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `users`; +---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | role_id | int(11) | YES | | NULL | | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | UNI | NULL | | | avatar | varchar(191) | YES | | NULL | | | password | varchar(191) | YES | | NULL | | | phonecode | varchar(191) | YES | | NULL | | | phone | varchar(191) | YES | UNI | NULL | | | advert_name | varchar(191) | YES | | NULL | | | isSocial | int(11) | NO | | 0 | | | isActive | int(11) | NO | | 1 | | | emailVerified | tinyint(1) | NO | | 0 | | | phoneVerified | tinyint(1) | NO | | 0 | | | registeredVia | varchar(191) | YES | | NULL | | | registrationMedia | varchar(191) | YES | | NULL | | | otp | int(11) | YES | | NULL | | | email_otp | smallint(6) | YES | | NULL | | | token | varchar(191) | YES | | NULL | | | status | int(10) unsigned | NO | | 1 | | | photo | varchar(191) | YES | | NULL | | | remember_token | varchar(100) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | title | varchar(191) | YES | | NULL | | | auto_applied_coupon | varchar(191) | YES | | NULL | | | partner_account_id | int(10) unsigned | YES | MUL | NULL | | | register_ip | varchar(191) | YES | | NULL | | | last_login_ip | varchar(191) | YES | | NULL | | | lat_lon | varchar(191) | YES | | NULL | | | verified_phone | varchar(20) | YES | | NULL | | | phone_verified_at | timestamp | YES | | NULL | | | bounce_email | tinyint(1) | YES | | 0 | | +---------------------+------------------+------+-----+---------+----------------+ 33 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `users_old`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | role_id | int(11) | YES | | NULL | | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | UNI | NULL | | | avatar | varchar(191) | YES | | NULL | | | password | varchar(191) | YES | | NULL | | | phone | varchar(191) | YES | UNI | NULL | | | isSocial | int(11) | NO | | 0 | | | isActive | int(11) | NO | | 1 | | | token | varchar(191) | YES | | NULL | | | status | int(10) unsigned | NO | | 1 | | | photo | varchar(191) | YES | | NULL | | | remember_token | varchar(100) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | title | varchar(191) | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ 17 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `users_older`; +----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | id | int(10) unsigned | NO | | NULL | | | role_id | int(11) | YES | | NULL | | | name | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | | NULL | | | avatar | varchar(191) | YES | | NULL | | | password | varchar(191) | YES | | NULL | | | phone | varchar(191) | YES | | NULL | | | isSocial | int(11) | NO | | 0 | | | isActive | int(11) | NO | | 1 | | | token | varchar(191) | YES | | NULL | | | status | int(10) unsigned | NO | | 1 | | | photo | varchar(191) | YES | | NULL | | | remember_token | varchar(100) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | title | varchar(191) | YES | | NULL | | +----------------+------------------+------+-----+---------+-------+ 17 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `visitor_stats_day`; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | businessdetails_id | int(10) unsigned | YES | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | new_users | int(10) unsigned | NO | | NULL | | | unique_users | int(10) unsigned | NO | | NULL | | | no_of_hits | int(10) unsigned | NO | | NULL | | | dateForDatapoint | datetime | NO | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `wallet_transaction_logs`; +----------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------------+------------------+------+-----+---------+----------------+ | wallet_transaction_logs_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | websites_id | int(10) unsigned | NO | MUL | NULL | | | date | datetime | YES | | NULL | | | transaction_type | tinyint(4) | YES | | 0 | | | source | varchar(191) | YES | | NULL | | | amount | double(16,2) | NO | | 0.00 | | | wallet_balance | double(16,2) | NO | | 0.00 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `webpost_files`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | webpost_id | int(10) unsigned | NO | MUL | NULL | | | files_id | int(10) unsigned | NO | MUL | NULL | | | deleted_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `webposts_seo_tags`; +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | deleted_at | timestamp | YES | | NULL | | | seo_tags_id | int(10) unsigned | NO | MUL | NULL | | | updates_id | int(10) unsigned | NO | MUL | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | website_id | int(10) unsigned | YES | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `website_addons`; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | website_addons_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | addon_name | varchar(191) | NO | | NULL | | | addon_sku | varchar(191) | NO | | NULL | | | addon_price | double(12,2) | YES | | NULL | | | addon_currency | varchar(191) | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 5 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `website_addons_purchases`; +-----------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+------------------+------+-----+---------+----------------+ | website_addons_purchases_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_addons_sku | varchar(191) | NO | | NULL | | | websites_id | int(10) unsigned | NO | MUL | NULL | | | started_at | datetime | NO | | NULL | | | ends_at | datetime | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +-----------------------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `website_ai_addons_purchase`; +----------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------------+------------------+------+-----+---------+----------------+ | website_addons_purchase_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_addons_sku | varchar(191) | NO | | NULL | | | websites_id | int(10) unsigned | NO | MUL | NULL | | | purchased_at | timestamp | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `website_integrations`; +------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | integration_service_id | int(10) unsigned | NO | MUL | NULL | | | identifier | varchar(191) | NO | | NULL | | | is_active | tinyint(1) | NO | | 1 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +------------------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `websites`; +--------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | templates_id | int(10) unsigned | NO | MUL | NULL | | | custom_text | text | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | | businessdetails_id | int(10) unsigned | NO | MUL | NULL | | | ai_token | varchar(200) | NO | | 5 | | | robots_exists | int(10) unsigned | YES | | NULL | | | active_subscription_plan | int(10) unsigned | YES | | NULL | | | subscription_expires_on | datetime | YES | | NULL | | | subscription_id | varchar(191) | YES | | NULL | | | last_payment_medium | varchar(191) | YES | | NULL | | | language_code | varchar(191) | YES | | en | | | wallet_balance | double(16,2) | NO | | 100.00 | | | maintenance_mode | int(10) | NO | | 0 | | | partner_account_id | int(10) | YES | | NULL | | | is_blocked | tinyint(1) | YES | | 0 | | | blocked_reason | varchar(500) | YES | | NULL | | | blocked_at | varchar(100) | YES | | NULL | | +--------------------------+------------------+------+-----+---------+----------------+ 20 rows in set (0.003 sec) MariaDB [instaweb]> DESCRIBE `websites_carousels`; +-------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+-------+ | website_id | int(10) unsigned | NO | PRI | NULL | | | carousel_id | int(10) unsigned | NO | PRI | NULL | | +-------------+------------------+------+-----+---------+-------+ 2 rows in set (0.002 sec) MariaDB [instaweb]> DESCRIBE `websites_packages`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | package_id | int(10) unsigned | NO | MUL | NULL | | | start_date | datetime | NO | | NULL | | | end_date | datetime | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.004 sec) MariaDB [instaweb]> DESCRIBE `zoho_config`; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | website_id | int(10) unsigned | NO | MUL | NULL | | | domain_id | int(10) unsigned | NO | MUL | NULL | | | domainName | varchar(191) | YES | | NULL | | | zoid | varchar(191) | YES | | NULL | | | superAdmin | varchar(191) | YES | | NULL | | | uri | varchar(191) | YES | | NULL | | | passwd | varchar(191) | YES | | NULL | | | isVerified | int(11) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.005 sec) MariaDB [instaweb]> DESCRIBE `zoho_emails`; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | zoho_config_id | int(10) unsigned | NO | MUL | NULL | | | zuid | int(10) unsigned | NO | | NULL | | | accountId | varchar(191) | NO | | NULL | | | email | varchar(191) | NO | | NULL | | | passwd | varchar(191) | NO | | NULL | | | authtoken | text | NO | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | | deleted_at | timestamp | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+