Server: mysql.puroparty.com

Database: puroparty

Table: email_users

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 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 Mar 07, 2024 at 12:27 AM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_users` ADD UNIQUE(`usewysiwyg`)		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