ftautosystems.work / 127.0.0.1 / digital_store

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		digital_store admin_login_attempts
id : int(11)
email : varchar(255)
attempts : int(11)
ip_address : varchar(45)
locked_until : datetime
created_at : datetime
updated_at : datetime

v		digital_store ai_blog_generation_logs
id : int(11)
blog_post_id : int(11)
system_prompt : longtext
user_prompt : longtext
image_prompt : text
keywords_data : longtext
primary_keyword : varchar(255)
gpt_input_tokens : int(11)
gpt_output_tokens : int(11)
gpt_cost_usd : decimal(10,6)
dalle_cost_usd : decimal(10,6)
dataforseo_cost_usd : decimal(10,6)
total_cost_usd : decimal(10,6)
gpt_model : varchar(50)
image_model : varchar(50)
raw_response : longtext
created_at : timestamp

v		digital_store ai_blog_logs
id : int(11)
action : varchar(100)
input_tokens : int(11)
output_tokens : int(11)
image_generated : tinyint(1)
cost_usd : decimal(10,6)
model : varchar(50)
success : tinyint(1)
error_message : text
created_at : datetime

v		digital_store ai_blog_queue
id : int(11)
topic : varchar(500)
keywords : varchar(500)
language : varchar(10)
status : enum('pending','processing','completed','failed')
scheduled_at : datetime
processed_at : datetime
blog_post_id : int(11)
error_message : text
created_at : datetime

v		digital_store ai_blog_settings
id : int(11)
setting_key : varchar(100)
setting_value : text
created_at : datetime
updated_at : datetime

v		digital_store ai_generation_history
id : int(10) unsigned
entity_type : enum('product','category')
entity_id : int(10) unsigned
cost_chatgpt : decimal(10,6)
cost_dalle : decimal(10,6)
cost_dataforseo : decimal(10,6)
cost_total : decimal(10,6)
keywords : longtext
keyword_details : longtext
prompts : longtext
model : varchar(50)
languages : longtext
created_at : timestamp

v		digital_store blog_posts
id : int(10) unsigned
user_id : int(10) unsigned
title : varchar(255)
slug : varchar(255)
excerpt : text
content : longtext
featured_image : varchar(255)
featured_image_alt : varchar(500)
featured_image_title : varchar(255)
status : enum('published','draft','scheduled')
ai_generated : tinyint(1)
published_at : timestamp
views : int(11)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
faqs : longtext
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)
internal_links_updated : datetime
lighthouse_score : int(3)
lighthouse_updated_at : datetime
in_sitemap : tinyint(1)

v		digital_store categories
id : int(10) unsigned
parent_id : int(10) unsigned
name : varchar(100)
slug : varchar(100)
description : text
icon : varchar(100)
image : varchar(255)
color : varchar(20)
sort_order : int(11)
status : enum('active','inactive')
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)
in_sitemap : tinyint(1)

v		digital_store category_translations
id : int(10) unsigned
category_id : int(10) unsigned
language_code : varchar(5)
name : varchar(100)
description : text
short_description : text
slug : varchar(255)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)

v		digital_store contacts
id : int(10) unsigned
name : varchar(100)
email : varchar(100)
subject : varchar(255)
message : text
status : enum('new','read','replied','closed')
ip_address : varchar(45)
created_at : timestamp

v		digital_store contact_messages
id : int(11)
name : varchar(100)
email : varchar(255)
subject : varchar(255)
message : text
ip_address : varchar(45)
is_read : tinyint(1)
created_at : timestamp

v		digital_store coupons
id : int(11)
code : varchar(50)
type : enum('percentage','fixed')
value : decimal(10,2)
min_order : decimal(10,2)
min_amount : decimal(10,2)
max_uses : int(11)
used_count : int(11)
expires_at : datetime
status : enum('active','inactive')
created_at : datetime

v		digital_store coupon_rate_limits
ip_hash : varchar(64)
attempts : int(11)
first_attempt : datetime

v		digital_store coupon_usage
id : int(11)
coupon_id : int(11)
user_id : int(11)
order_id : int(11)
used_at : datetime

v		digital_store email_templates
id : int(10) unsigned
name : varchar(100)
subject : varchar(255)
body : longtext
variables : longtext
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp

v		digital_store email_verification_tokens
id : int(10) unsigned
user_id : int(10) unsigned
token : varchar(64)
expires_at : timestamp
created_at : timestamp

v		digital_store index_queue
id : int(11)
url : varchar(500)
url_type : enum('blog','product','page')
post_id : int(11)
status : enum('pending','submitted','indexed','failed')
priority : int(11)
submit_attempts : int(11)
last_attempt_at : datetime
indexed_at : datetime
created_at : datetime

v		digital_store invoices
id : int(11)
order_id : int(11)
invoice_number : varchar(50)
invoice_data : text
uyumsoft_uuid : varchar(100)
status : enum('pending','created','sent','cancelled')
created_at : datetime

v		digital_store keyword_research
id : int(11)
keyword : varchar(255)
language_code : varchar(10)
location_code : int(11)
search_volume : int(11)
competition : decimal(5,4)
cpc : decimal(10,2)
keyword_difficulty : int(11)
trend_data : longtext
source : varchar(50)
used_in_blog : tinyint(1)
last_updated : datetime
created_at : datetime
competition_level : varchar(20)

v		digital_store languages
id : int(11)
code : varchar(5)
name : varchar(50)
native_name : varchar(50)
flag_image : varchar(255)
flag_emoji : varchar(10)
is_active : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		digital_store lighthouse_cache
id : int(11)
url_hash : varchar(32)
url : varchar(500)
data : longtext
score : int(3)
created_at : datetime

v		digital_store login_attempts
id : int(11)
email : varchar(255)
attempts : int(11)
ip_address : varchar(45)
locked_until : datetime
created_at : datetime
updated_at : datetime

v		digital_store oauth_connections
id : int(10) unsigned
user_id : int(10) unsigned
provider : enum('google','facebook')
provider_id : varchar(255)
provider_email : varchar(255)
access_token : text
refresh_token : text
token_expires_at : timestamp
created_at : timestamp
updated_at : timestamp

v		digital_store orders
id : int(10) unsigned
order_number : varchar(50)
user_id : int(10) unsigned
email : varchar(100)
phone : varchar(20)
subtotal : decimal(10,2)
discount : decimal(10,2)
coupon_code : varchar(50)
total : decimal(10,2)
currency : varchar(3)
payment_method : varchar(50)
payment_id : varchar(255)
payment_url : varchar(500)
payment_status : enum('pending','completed','failed','refunded')
order_status : enum('pending','processing','completed','cancelled')
notes : text
admin_notes : text
ip_address : varchar(45)
user_agent : text
completed_at : timestamp
created_at : timestamp
updated_at : timestamp

v		digital_store order_deliveries
id : int(10) unsigned
order_id : int(10) unsigned
order_item_id : int(10) unsigned
delivery_type : enum('topup','account','instant','manual')
customer_input : longtext
delivery_data : text
smm_panel_id : int(11)
delivery_format : text
status : enum('pending','processing','delivered','failed')
delivered_at : timestamp
notes : text
created_at : timestamp
updated_at : timestamp

v		digital_store order_items
id : int(10) unsigned
order_id : int(10) unsigned
product_id : int(10) unsigned
product_name : varchar(255)
quantity : int(11)
price : decimal(10,2)
total : decimal(10,2)
delivered_data : text
delivered_at : timestamp
created_at : timestamp
customer_input : longtext
delivery_status : enum('pending','processing','delivered','failed')
delivery_data : text
delivery_type : varchar(50)

v		digital_store pages
id : int(10) unsigned
slug : varchar(100)
title : varchar(255)
content : longtext
status : enum('published','draft')
seo_title : varchar(255)
seo_description : text
created_at : timestamp
updated_at : timestamp
seo_keywords : varchar(255)
sort_order : int(11)
show_in_header : tinyint(1)
show_in_footer : tinyint(1)
no_index : tinyint(1)

v		digital_store password_reset_tokens
id : int(10) unsigned
user_id : int(10) unsigned
token : varchar(64)
expires_at : timestamp
used_at : timestamp
created_at : timestamp

v		digital_store products
id : int(10) unsigned
category_id : int(10) unsigned
user_id : int(10) unsigned
name : varchar(255)
slug : varchar(255)
short_description : varchar(500)
description : text
price : decimal(10,2)
sale_price : decimal(10,2)
min_quantity : int(11)
max_quantity : int(11)
stock : int(11)
sold : int(11)
image : varchar(255)
images : longtext
delivery_type : enum('instant','manual','account','api','topup','dc_boost')
delivery_data : text
required_fields : longtext
delivery_format : text
delivery_time : varchar(100)
smm_service_id : int(11)
smm_panel_id : int(11)
smm_platform : varchar(50)
status : enum('active','inactive','draft')
sort_order : int(11)
featured : tinyint(1)
rating : decimal(2,1)
reviews_count : int(11)
views : int(11)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
features : text
meta_title : varchar(255)
meta_description : text
meta_keywords : varchar(500)
no_index : tinyint(1)
in_sitemap : tinyint(1)

v		digital_store product_images
id : int(11)
product_id : int(11)
image_path : varchar(255)
sort_order : int(11)
created_at : datetime

v		digital_store product_stock
id : int(11)
product_id : int(11)
stock_data : text
is_sold : tinyint(1)
order_id : int(11)
order_item_id : int(11)
sold_at : datetime
created_at : datetime
notes : text

v		digital_store product_translations
id : int(10) unsigned
product_id : int(10) unsigned
language_code : varchar(5)
name : varchar(255)
short_description : varchar(500)
description : text
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)

v		digital_store product_variants
id : int(11)
product_id : int(11)
name : varchar(100)
price : decimal(10,2)
stock : int(11)
status : enum('active','inactive')
sort_order : int(11)
created_at : datetime

v		digital_store reviews
id : int(10) unsigned
product_id : int(10) unsigned
user_id : int(10) unsigned
order_id : int(10) unsigned
rating : tinyint(1)
comment : text
status : enum('pending','approved','rejected')
created_at : timestamp
updated_at : timestamp

v		digital_store settings
id : int(10) unsigned
key : varchar(100)
value : text
type : varchar(50)
group : varchar(50)
updated_at : timestamp

v		digital_store sitemap_pings
id : int(11)
ping_type : enum('google','bing')
success : tinyint(1)
response_code : int(11)
created_at : datetime

v		digital_store site_settings
id : int(10) unsigned
setting_key : varchar(100)
setting_value : longtext
setting_type : enum('text','textarea','number','boolean','json','image','color')
setting_group : varchar(50)
setting_label : varchar(255)
setting_description : text
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		digital_store smm_order_logs
id : int(11)
order_item_id : int(11)
smm_order_id : int(11)
smm_panel_id : int(11)
status : varchar(50)
error_message : text
response_data : longtext
created_at : datetime

v		digital_store smm_panels
id : int(11)
name : varchar(100)
slug : varchar(100)
api_url : varchar(500)
api_key : varchar(500)
status : enum('active','inactive')
is_default : tinyint(1)
balance : decimal(10,2)
currency : varchar(10)
last_sync_at : datetime
notes : text
created_at : datetime
updated_at : datetime

v		digital_store tickets
id : int(11)
ticket_number : varchar(20)
user_id : int(11)
guest_email : varchar(255)
guest_name : varchar(100)
subject : varchar(255)
category : enum('general','order','payment','technical','refund','other')
priority : enum('low','medium','high','urgent')
status : enum('open','in_progress','answered','closed')
order_id : int(11)
created_at : timestamp
updated_at : timestamp
closed_at : timestamp

v		digital_store ticket_attachments
id : int(11)
ticket_id : int(11)
reply_id : int(11)
filename : varchar(255)
original_name : varchar(255)
file_type : varchar(100)
file_size : int(11)
created_at : timestamp

v		digital_store ticket_replies
id : int(11)
ticket_id : int(11)
user_id : int(11)
admin_id : int(11)
is_admin : tinyint(1)
message : text
created_at : timestamp

v		digital_store transactions
id : int(10) unsigned
user_id : int(10) unsigned
type : enum('deposit','withdrawal','purchase','refund','bonus','transfer')
amount : decimal(10,2)
balance_after : decimal(10,2)
description : varchar(255)
reference_id : int(10) unsigned
reference_type : varchar(50)
status : enum('pending','completed','failed')
created_at : timestamp

v		digital_store users
id : int(10) unsigned
username : varchar(50)
email : varchar(100)
password : varchar(255)
name : varchar(100)
phone : varchar(20)
avatar : varchar(255)
role : enum('admin','user','seller')
balance : decimal(10,2)
status : enum('active','inactive','banned')
email_verified_at : timestamp
remember_token : varchar(100)
last_login_at : timestamp
last_login_ip : varchar(45)
created_at : timestamp
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update