Database: tutorial_addon

Table: additional_domains

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
order_id	int(11)	YES	MUL
domain_name	varchar(255)	NO
added_at	timestamp	YES		current_timestamp()

Table: admin_sessions

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
ip_address	varchar(45)	YES
user_agent	text	YES
login_time	datetime	YES		current_timestamp()

Table: admins

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
username	varchar(50)	NO	UNI
password	varchar(255)	NO
email	varchar(100)	NO
created_at	timestamp	YES		current_timestamp()

Table: credit_requests

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
amount	decimal(10,2)	NO
payment_method_id	int(11)	NO	MUL
trx_id	varchar(100)	YES
sender_number	varchar(50)	YES
status	enum('pending','approved','rejected')	YES		pending
created_at	timestamp	YES		current_timestamp()

Table: credit_transactions

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
order_id	int(11)	YES	MUL
amount	decimal(10,2)	NO
transaction_type	enum('credit','debit')	NO
description	text	YES
created_at	datetime	YES		current_timestamp()

Table: invoices

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
license_id	int(11)	YES
user_id	int(11)	NO	MUL
order_id	int(11)	NO	MUL
invoice_number	varchar(50)	NO	UNI
amount	decimal(10,2)	NO
due_date	date	NO
status	enum('pending','paid','overdue','cancelled')	YES		pending
created_at	timestamp	YES		current_timestamp()
paid_at	timestamp	YES

Table: license_domains

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
license_id	int(11)	NO	MUL
domain_name	varchar(255)	NO
status	enum('active','suspended','terminated')	YES		active
created_at	timestamp	YES		current_timestamp()
updated_at	timestamp	YES			on update current_timestamp()

Table: licenses

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
license_key	varchar(255)	NO	UNI
order_id	int(11)	NO	MUL
user_id	int(11)	NO	MUL
package_name	varchar(150)	YES
customer_name	varchar(150)	YES
customer_email	varchar(150)	YES
status	enum('active','suspended','expired','cancelled')	YES		active
max_domains	int(11)	YES		1
used_domains	int(11)	YES		0
expires_at	datetime	YES
created_at	datetime	YES		current_timestamp()
updated_at	timestamp	YES
package_id	int(11)	YES
allowed_domain	varchar(255)	YES

Table: orders

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
package_id	int(11)	NO	MUL
domain_name	varchar(255)	YES
billing_cycle	enum('monthly','half_yearly','yearly')	YES		monthly
amount	decimal(10,2)	YES		0.00
transaction_id	varchar(255)	YES
sender_number	varchar(50)	YES
license_key	varchar(255)	YES
status	enum('pending','active','suspended','expired','cancelled')	YES		pending
activated_at	datetime	YES
expires_at	datetime	YES
next_due_date	date	YES
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES		current_timestamp()	on update current_timestamp()

Table: packages

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
name	varchar(255)	NO
description	text	YES
monthly_price	decimal(10,2)	NO		0.00
half_yearly_price	decimal(10,2)	NO		0.00
yearly_price	decimal(10,2)	NO		0.00
max_domains	int(11)	NO		1
features	longtext	YES
is_active	tinyint(1)	YES		1
created_at	timestamp	YES		current_timestamp()
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()

Table: payment_logs

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
payment_id	int(11)	NO	MUL
admin_id	int(11)	YES
action	varchar(255)	YES
notes	text	YES
created_at	datetime	YES		current_timestamp()

Table: payment_methods

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
name	varchar(100)	NO
type	enum('mobile','bank','manual','crypto','other')	YES		manual
account_number	varchar(100)	YES
account_name	varchar(100)	YES
instructions	text	YES
status	enum('active','inactive')	YES		active
created_at	datetime	YES		current_timestamp()

Table: payments

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
order_id	int(11)	NO	MUL
payment_method_id	int(11)	NO
payment_method	varchar(100)	NO
transaction_id	varchar(255)	YES
sender_number	varchar(50)	YES
amount	decimal(10,2)	YES		0.00
status	enum('pending','confirmed','failed','refunded')	YES		pending
created_at	datetime	YES		current_timestamp()
confirmed_at	datetime	YES

Table: system_settings

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
smtp_host	varchar(255)	YES
smtp_port	int(11)	YES
smtp_username	varchar(255)	YES
smtp_password	varchar(255)	YES
from_email	varchar(255)	YES
from_name	varchar(255)	YES
encryption	varchar(10)	YES
smtp_auth	tinyint(1)	YES		1

Table: transactions

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
type	enum('credit_add','invoice_payment','refund')	NO
amount	decimal(10,2)	NO
description	text	YES
reference_id	int(11)	YES
created_at	timestamp	YES		current_timestamp()

Table: user_credits

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	UNI
balance	decimal(10,2)	YES		0.00
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()

Table: users

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
username	varchar(50)	NO	UNI
password	varchar(255)	NO
remember_token	varchar(255)	YES
email	varchar(100)	NO	UNI
created_at	timestamp	YES		current_timestamp()
role	enum('admin','user')	YES		user
is_active	tinyint(1)	YES		1
last_login	timestamp	YES
created_by	int(11)	YES
token_expiry	datetime	YES