Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 722944 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
userid
int(11)
No
auto_increment
username
varchar(255)
utf8_general_ci
Yes
NULL
password
varchar(32)
utf8_general_ci
Yes
NULL
admintype
char(1)
utf8_general_ci
Yes
NULL
listadmintype
char(1)
utf8_general_ci
Yes
NULL
templateadmintype
char(1)
utf8_general_ci
Yes
NULL
segmentadmintype
char(1)
utf8_general_ci
Yes
NULL
status
char(1)
utf8_general_ci
Yes
0
fullname
varchar(255)
utf8_general_ci
Yes
NULL
emailaddress
varchar(100)
utf8_general_ci
Yes
NULL
settings
text
utf8_general_ci
Yes
NULL
editownsettings
char(1)
utf8_general_ci
Yes
1
usertimezone
varchar(10)
utf8_general_ci
Yes
NULL
textfooter
mediumtext
utf8_general_ci
Yes
NULL
htmlfooter
mediumtext
utf8_general_ci
Yes
NULL
maxlists
int(11)
Yes
0
perhour
int(11)
Yes
0
permonth
int(11)
Yes
0
unlimitedmaxemails
char(1)
utf8_general_ci
Yes
0
maxemails
int(11)
Yes
0
infotips
char(1)
utf8_general_ci
Yes
1
smtpserver
varchar(255)
utf8_general_ci
Yes
NULL
smtpusername
varchar(255)
utf8_general_ci
Yes
NULL
smtppassword
varchar(255)
utf8_general_ci
Yes
NULL
smtpport
int(11)
Yes
0
createdate
int(11)
Yes
0
lastloggedin
int(11)
Yes
0
forgotpasscode
varchar(32)
utf8_general_ci
Yes
usewysiwyg
char(1)
utf8_general_ci
Yes
1
xmlapi
char(1)
utf8_general_ci
Yes
0
xmltoken
varchar(40)
utf8_general_ci
Yes
NULL
gettingstarted
int(11)
No
0
Check All
/
Uncheck All
With selected:
Print view
Relation view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
userid
username
password
admintype
listadmintype
templateadmintype
segmentadmintype
status
fullname
emailaddress
settings
editownsettings
usertimezone
textfooter
htmlfooter
maxlists
perhour
permonth
unlimitedmaxemails
maxemails
infotips
smtpserver
smtpusername
smtppassword
smtpport
createdate
lastloggedin
forgotpasscode
usewysiwyg
xmlapi
xmltoken
gettingstarted
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
2
userid
userid_2
UNIQUE
2
userid
userid_3
UNIQUE
2
userid
username_2
UNIQUE
2
username
password_2
UNIQUE
2
password
admintype_2
UNIQUE
2
admintype
listadmintype_2
UNIQUE
2
listadmintype
segmentadmintype_2
UNIQUE
2
segmentadmintype
emailaddress_2
UNIQUE
2
emailaddress
usertimezone_2
UNIQUE
2
usertimezone
createdate_2
UNIQUE
2
createdate
lastloggedin_2
UNIQUE
2
lastloggedin
admintype_3
UNIQUE
2
admintype
listadmintype_4
UNIQUE
2
listadmintype
segmentadmintype_3
UNIQUE
2
segmentadmintype
lastloggedin_3
UNIQUE
2
lastloggedin
usertimezone_4
UNIQUE
2
usertimezone
username_4
UNIQUE
2
username
password_3
UNIQUE
2
password
email_users_logincheck_idx
INDEX
2
username
password
userid
INDEX
2
userid
username
INDEX
2
username
password
INDEX
2
password
admintype
INDEX
2
admintype
listadmintype
INDEX
2
listadmintype
templateadmintype
INDEX
2
templateadmintype
segmentadmintype
INDEX
2
segmentadmintype
status
INDEX
2
status
fullname
INDEX
2
fullname
emailaddress
INDEX
2
emailaddress
editownsettings
INDEX
2
editownsettings
usertimezone
INDEX
2
usertimezone
maxlists
INDEX
2
maxlists
perhour
INDEX
2
perhour
permonth
INDEX
2
permonth
unlimitedmaxemails
INDEX
2
unlimitedmaxemails
maxemails
INDEX
2
maxemails
infotips
INDEX
2
infotips
smtpserver
INDEX
2
smtpserver
smtpusername
INDEX
2
smtpusername
smtppassword
INDEX
2
smtppassword
smtpport
INDEX
2
smtpport
createdate
INDEX
2
createdate
lastloggedin
INDEX
2
lastloggedin
forgotpasscode
INDEX
2
forgotpasscode
usewysiwyg
INDEX
2
usewysiwyg
xmlapi
INDEX
2
xmlapi
xmltoken
INDEX
2
xmltoken
gettingstarted
INDEX
2
gettingstarted
listadmintype_3
INDEX
2
listadmintype
usertimezone_3
INDEX
2
usertimezone
gettingstarted_2
INDEX
2
gettingstarted
smtpport_2
INDEX
2
smtpport
maxlists_2
INDEX
2
maxlists
usewysiwyg_2
INDEX
2
usewysiwyg
xmltoken_2
INDEX
2
xmltoken
lastloggedin_4
INDEX
2
lastloggedin
fullname_2
INDEX
2
fullname
username_3
INDEX
2
username
smtpusername_2
INDEX
2
smtpusername
templateadmintype_2
INDEX
2
templateadmintype
editownsettings_2
INDEX
2
editownsettings
admintype_4
INDEX
2
admintype
maxemails_2
INDEX
2
maxemails
Create an index on
columns
Space usage:
Type
Usage
Data
16,384
Bytes
Index
1,008
KB
Total
1,024
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
3
Creation
May 14, 2024 at 10:31 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_users` ADD INDEX(`admintype`)
userid
username
password
admintype
listadmintype
templateadmintype
segmentadmintype
status
fullname
emailaddress
settings
editownsettings
usertimezone
textfooter
htmlfooter
maxlists
perhour
permonth
unlimitedmaxemails
maxemails
infotips
smtpserver
smtpusername
smtppassword
smtpport
createdate
lastloggedin
forgotpasscode
usewysiwyg
xmlapi
xmltoken
gettingstarted
Show this query here again
Or
Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:
Autodetect
None
"gzipped"
"bzipped"
Character set of the file:
armscii8
ascii
big5
binary
cp1250
cp1251
cp1256
cp1257
cp850
cp852
cp866
cp932
dec8
euckr
gb2312
gbk
geostd8
greek
hebrew
hp8
keybcs2
koi8r
koi8u
latin1
latin2
latin5
latin7
macce
macroman
sjis
swe7
tis620
ucs2
ujis
utf8
Insert data from a textfile into table