Server: mysql.puroparty.com

Database: puroparty

Table: email_forms

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	formid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		Yes	NULL
	design	varchar(255)	utf8_general_ci		Yes	NULL
	formhtml	longtext	utf8_general_ci		Yes	NULL
	chooseformat	varchar(2)	utf8_general_ci		Yes	NULL
	changeformat	char(1)	utf8_general_ci		Yes	0
	sendthanks	char(1)	utf8_general_ci		Yes	0
	requireconfirm	char(1)	utf8_general_ci		Yes	0
	ownerid	int(11)			Yes	0
	formtype	char(1)	utf8_general_ci		Yes	NULL
	createdate	int(11)			Yes	0
	contactform	char(1)	utf8_general_ci		Yes	0
	usecaptcha	char(1)	utf8_general_ci		Yes	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 formid name design formhtml chooseformat changeformat sendthanks requireconfirm ownerid formtype createdate contactform usecaptcha

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 3  formid formid_2 UNIQUE 3  formid formid_3 UNIQUE 3  formid formid_6 UNIQUE 3  formid formid_7 UNIQUE 3  formid name_2 UNIQUE 3  name design_2 UNIQUE 3  design createdate_2 UNIQUE 3  createdate createdate_3 UNIQUE 3  createdate name_3 UNIQUE 3  name design_4 UNIQUE 3  design name_6 UNIQUE 3  name design_6 UNIQUE 3  design name_7 UNIQUE 3  name design_8 UNIQUE 3  design createdate_6 UNIQUE 3  createdate name_9 UNIQUE 3  name design_9 UNIQUE 3  design formid INDEX 3  formid name INDEX 3  name design INDEX 3  design chooseformat INDEX 3  chooseformat changeformat INDEX 3  changeformat sendthanks INDEX 3  sendthanks requireconfirm INDEX 3  requireconfirm ownerid INDEX 3  ownerid formtype INDEX 3  formtype createdate INDEX 3  createdate contactform INDEX 3  contactform usecaptcha INDEX 3  usecaptcha design_3 INDEX 3  design usecaptcha_2 INDEX 3  usecaptcha formtype_2 INDEX 3  formtype createdate_4 INDEX 3  createdate formid_4 INDEX 3  formid requireconfirm_2 INDEX 3  requireconfirm ownerid_2 INDEX 3  ownerid chooseformat_2 INDEX 3  chooseformat changeformat_2 INDEX 3  changeformat sendthanks_2 INDEX 3  sendthanks name_4 INDEX 3  name contactform_2 INDEX 3  contactform ownerid_3 INDEX 3  ownerid formid_5 INDEX 3  formid name_5 INDEX 3  name design_5 INDEX 3  design chooseformat_3 INDEX 3  chooseformat changeformat_3 INDEX 3  changeformat sendthanks_3 INDEX 3  sendthanks requireconfirm_3 INDEX 3  requireconfirm design_7 INDEX 3  design formtype_3 INDEX 3  formtype chooseformat_4 INDEX 3  chooseformat requireconfirm_4 INDEX 3  requireconfirm ownerid_4 INDEX 3  ownerid createdate_5 INDEX 3  createdate usecaptcha_3 INDEX 3  usecaptcha formid_8 INDEX 3  formid name_8 INDEX 3  name contactform_3 INDEX 3  contactform changeformat_4 INDEX 3  changeformat sendthanks_4 INDEX 3  sendthanks requireconfirm_5 INDEX 3  requireconfirm formtype_4 INDEX 3  formtype 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 4 Creation Mar 07, 2024 at 02:01 AM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_forms` WHERE 1		formid name design formhtml chooseformat changeformat sendthanks requireconfirm ownerid formtype createdate contactform usecaptcha
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