Print view - phpMyAdmin 4.8.4

ci_sessions

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	varchar(40)	No	0
ip_address	varchar(45)	No	0
data	text	No
timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

class_coment

Column	Type	Null	Default	Links to	Comments	MIME
content_id (Primary)	int(11)	No
generated_time	int(11)	No
content	longtext	No
content_by	int(11)	No
published	int(11)	No	0
class_id	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	content_id	0	A	No

class_gid

Column	Type	Null	Default	Links to	Comments	MIME
clgid (Primary)	int(11)	No
class_id	int(11)	No
gid	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	clgid	0	A	No

live_class

Column	Type	Null	Default	Links to	Comments	MIME
class_id (Primary)	int(11)	No
class_name	varchar(1000)	No
initiated_by	int(11)	No
initiated_time	int(11)	No
closed_time	int(11)	No
content	longtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	class_id	0	A	No

savsoft_answers

Column	Type	Null	Default	Links to	Comments	MIME
aid (Primary)	int(11)	No
qid	int(11)	No
q_option	text	No
uid	int(11)	No
score_u	float	No	0
rid	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	aid	8	A	No

savsoft_category

Column	Type	Null	Default	Links to	Comments	MIME
cid (Primary)	int(11)	No
category_name	varchar(1000)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cid	1	A	No

savsoft_feed

Column	Type	Null	Default	Links to	Comments	MIME
quiz_id	int(11)	No
user_id	int(11)	No
feed1	int(11)	No
feed2	int(11)	No
feed3	int(11)	No
feed4	int(11)	No
feed5	int(11)	No
feed6	int(11)	No
feed7	int(11)	No
feed8	int(11)	No
description1	varchar(100)	No
description2	varchar(100)	No
description3	varchar(100)	No

savsoft_group

Column	Type	Null	Default	Links to	Comments	MIME
gid (Primary)	int(11)	No
group_name	varchar(1000)	No
price	float	No
valid_for_days	int(11)	No	0
description	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	gid	3	A	No

savsoft_level

Column	Type	Null	Default	Links to	Comments	MIME
lid (Primary)	int(11)	No
level_name	varchar(1000)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	lid	2	A	No

savsoft_notification

Column	Type	Null	Default	Links to	Comments	MIME
nid (Primary)	int(11)	No
notification_date	timestamp	No	CURRENT_TIMESTAMP
title	varchar(100)	Yes	NULL
message	varchar(1000)	Yes	NULL
click_action	varchar(100)	Yes	NULL
notification_to	varchar(1000)	Yes	NULL
response	text	Yes	NULL
uid	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	nid	0	A	No

savsoft_options

Column	Type	Null	Default	Links to	Comments	MIME
oid (Primary)	int(11)	No
qid	int(11)	No
q_option	text	No
q_option_match	varchar(1000)	Yes	NULL
score	float	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	oid	13	A	No

savsoft_payment

Column	Type	Null	Default	Links to	Comments	MIME
pid (Primary)	int(11)	No
uid	int(11)	No
gid	int(11)	No
amount	float	No
paid_date	int(11)	No
payment_gateway	varchar(100)	No	Paypal
payment_status	varchar(100)	No	Pending
transaction_id	varchar(1000)	No
other_data	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	pid	0	A	No

savsoft_qbank

Column	Type	Null	Default	Links to	Comments	MIME
qid (Primary)	int(11)	No
question_type	varchar(100)	No	Multiple Choice Single Answer
question	text	No
description	text	No
cid	int(11)	No
lid	int(11)	No
no_time_served	int(11)	No	0
no_time_corrected	int(11)	No	0
no_time_incorrected	int(11)	No	0
no_time_unattempted	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	qid	5	A	No

savsoft_qcl

Column	Type	Null	Default	Links to	Comments	MIME
qcl_id (Primary)	int(11)	No
quid	int(11)	No
cid	int(11)	No
lid	int(11)	No
noq	int(11)	No
i_correct	text	No
i_incorrect	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	qcl_id	4	A	No

savsoft_quiz

Column	Type	Null	Default	Links to	Comments	MIME
quid (Primary)	int(11)	No
quiz_name	varchar(1000)	No
description	text	No
start_date	int(11)	No
end_date	int(11)	No
gids	text	No
qids	text	No
noq	int(11)	No
correct_score	text	No
incorrect_score	text	No
ip_address	text	No
duration	int(11)	No	10
maximum_attempts	int(11)	No	1
pass_percentage	float	No	50
view_answer	int(11)	No	1
camera_req	int(11)	No	1
question_selection	int(11)	No	1
gen_certificate	int(11)	No	0
certificate_text	text	Yes	NULL
with_login	int(11)	No	1
quiz_template	varchar(100)	No	Default

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	quid	1	A	No

savsoft_result

Column	Type	Null	Default	Links to	Comments	MIME
rid (Primary)	int(11)	No
quid	int(11)	No
uid	int(11)	No
result_status	varchar(100)	No	Open
start_time	int(11)	No
end_time	int(11)	No
categories	text	No
category_range	text	No
r_qids	text	No
individual_time	text	No
total_time	int(11)	No	0
score_obtained	float	No	0
percentage_obtained	float	No	0
attempted_ip	varchar(100)	No
score_individual	text	No
photo	varchar(100)	No
manual_valuation	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rid	1	A	No

savsoft_users

Column	Type	Null	Default	Links to	Comments	MIME
uid (Primary)	int(11)	No
password	varchar(1000)	No
email	varchar(100)	Yes	NULL
first_name	varchar(100)	Yes	NULL
last_name	varchar(100)	Yes	NULL
contact_no	varchar(1000)	Yes	NULL
connection_key	varchar(1000)	Yes	NULL
gid	int(11)	No	1
su	int(11)	No	0
subscription_expired	int(11)	No	0
verify_code	int(11)	No	0
wp_user	varchar(100)	Yes	NULL
registered_date	timestamp	No	CURRENT_TIMESTAMP
photo	varchar(1000)	Yes	NULL
user_status	varchar(100)	No	Active
web_token	varchar(1000)	Yes	NULL
android_token	varchar(1000)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	uid	2	A	No

Open new phpMyAdmin window

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.