Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: poll_configpoll_config

   Field  Type Collation Attributes Null Default Extra Action
   smallint(5)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(60) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(60) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(40) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(40) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(40) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(40) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   varchar(6) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(7) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(7) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(70) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(7) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   int(9)     No    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   int(4)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   smallint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(5)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop config_id
config_id_2 UNIQUE Edit Drop config_id
base_gif_2 UNIQUE Edit Drop base_gif
lang_2 UNIQUE Edit Drop lang
title_2 UNIQUE Edit Drop title
vote_button_2 UNIQUE Edit Drop vote_button
result_text_2 UNIQUE Edit Drop result_text
total_text_2 UNIQUE Edit Drop total_text
voted_2 UNIQUE Edit Drop voted
send_com_2 UNIQUE Edit Drop send_com
img_height_2 UNIQUE Edit Drop img_height
img_length_2 UNIQUE Edit Drop img_length
table_width_2 UNIQUE Edit Drop table_width
bgcolor_tab_2 UNIQUE Edit Drop bgcolor_tab
bgcolor_fr_2 UNIQUE Edit Drop bgcolor_fr
font_face_2 UNIQUE Edit Drop font_face
font_color_2 UNIQUE Edit Drop font_color
type_2 UNIQUE Edit Drop type
check_ip_2 UNIQUE Edit Drop check_ip
lock_timeout_2 UNIQUE Edit Drop lock_timeout
time_offset_2 UNIQUE Edit Drop time_offset
entry_pp_2 UNIQUE Edit Drop entry_pp
poll_version_2 UNIQUE Edit Drop poll_version
base_url_2 UNIQUE Edit Drop base_url
config_id INDEX None  Edit Drop config_id
base_gif INDEX None  Edit Drop base_gif
lang INDEX None  Edit Drop lang
title INDEX None  Edit Drop title
vote_button INDEX None  Edit Drop vote_button
result_text INDEX None  Edit Drop result_text
total_text INDEX None  Edit Drop total_text
voted INDEX None  Edit Drop voted
send_com INDEX None  Edit Drop send_com
img_height INDEX None  Edit Drop img_height
img_length INDEX None  Edit Drop img_length
table_width INDEX None  Edit Drop table_width
bgcolor_tab INDEX None  Edit Drop bgcolor_tab
bgcolor_fr INDEX None  Edit Drop bgcolor_fr
font_face INDEX None  Edit Drop font_face
font_color INDEX None  Edit Drop font_color
type INDEX None  Edit Drop type
check_ip INDEX None  Edit Drop check_ip
lock_timeout INDEX None  Edit Drop lock_timeout
time_offset INDEX None  Edit Drop time_offset
entry_pp INDEX None  Edit Drop entry_pp
poll_version INDEX None  Edit Drop poll_version
base_url INDEX None  Edit Drop base_url
base_gif_3 FULLTEXT None  Edit Drop base_gif
lang_3 FULLTEXT None  Edit Drop lang
title_3 FULLTEXT None  Edit Drop title
vote_button_3 FULLTEXT None  Edit Drop vote_button
result_text_3 FULLTEXT None  Edit Drop result_text
total_text_3 FULLTEXT None  Edit Drop total_text
voted_3 FULLTEXT None  Edit Drop voted
send_com_3 FULLTEXT None  Edit Drop send_com
table_width_3 FULLTEXT None  Edit Drop table_width
bgcolor_tab_3 FULLTEXT None  Edit Drop bgcolor_tab
bgcolor_fr_3 FULLTEXT None  Edit Drop bgcolor_fr
font_face_3 FULLTEXT None  Edit Drop font_face
font_color_3 FULLTEXT None  Edit Drop font_color
type_3 FULLTEXT None  Edit Drop type
time_offset_3 FULLTEXT None  Edit Drop time_offset
poll_version_3 FULLTEXT None  Edit Drop poll_version
base_url_3 FULLTEXT None  Edit Drop base_url
Create an index on  columns  
 
Space usage: 
Type Usage
Data 228 Bytes
Index 4,096 Bytes
Total 4,324 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 228
Row size  ø 4,324 Bytes
Next Autoindex 2
Creation Oct 09, 2017 at 05:06 AM
Last update Oct 09, 2017 at 05:06 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: