Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: photopost_admlogphotopost_admlog
An index has been added on id (Query took 0.0101 sec)
SQL-query: 
ALTER TABLE `photopost_admlog` ADD UNIQUE (
`id`
)
 [Edit] [Create PHP Code]

StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(20)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(35) 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 4  Edit Drop id
id_2 UNIQUE 4  Edit Drop id
datestamp_2 UNIQUE 4  Edit Drop datestamp
datestamp_3 UNIQUE 4  Edit Drop datestamp
id_4 UNIQUE 4  Edit Drop id
datestamp_5 UNIQUE 4  Edit Drop datestamp
id_6 UNIQUE 4  Edit Drop id
datestamp_7 UNIQUE 4  Edit Drop datestamp
id_8 UNIQUE 4  Edit Drop id
datestamp_9 UNIQUE 4  Edit Drop datestamp
id_11 UNIQUE 4  Edit Drop id
datestamp_11 UNIQUE 4  Edit Drop datestamp
id_12 UNIQUE 4  Edit Drop id
id INDEX None  Edit Drop id
adminuser INDEX None  Edit Drop adminuser
description INDEX None  Edit Drop description
datestamp INDEX None  Edit Drop datestamp
ip INDEX None  Edit Drop ip
description_3 INDEX None  Edit Drop description
adminuser_3 INDEX None  Edit Drop adminuser
id_3 INDEX None  Edit Drop id
ip_4 INDEX None  Edit Drop ip
datestamp_4 INDEX None  Edit Drop datestamp
adminuser_5 INDEX None  Edit Drop adminuser
id_5 INDEX None  Edit Drop id
ip_6 INDEX None  Edit Drop ip
datestamp_6 INDEX None  Edit Drop datestamp
description_6 INDEX None  Edit Drop description
description_7 INDEX None  Edit Drop description
id_7 INDEX None  Edit Drop id
adminuser_8 INDEX None  Edit Drop adminuser
ip_8 INDEX None  Edit Drop ip
datestamp_8 INDEX None  Edit Drop datestamp
id_9 INDEX None  Edit Drop id
description_9 INDEX None  Edit Drop description
adminuser_10 INDEX None  Edit Drop adminuser
id_10 INDEX None  Edit Drop id
adminuser_11 INDEX None  Edit Drop adminuser
description_10 INDEX None  Edit Drop description
datestamp_10 INDEX None  Edit Drop datestamp
ip_10 INDEX None  Edit Drop ip
ip_12 INDEX None  Edit Drop ip
datestamp_12 INDEX None  Edit Drop datestamp
adminuser_2 FULLTEXT None  Edit Drop adminuser
description_2 FULLTEXT None  Edit Drop description
ip_2 FULLTEXT None  Edit Drop ip
adminuser_4 FULLTEXT None  Edit Drop adminuser
ip_3 FULLTEXT None  Edit Drop ip
description_4 FULLTEXT None  Edit Drop description
ip_5 FULLTEXT None  Edit Drop ip
description_5 FULLTEXT None  Edit Drop description
adminuser_6 FULLTEXT None  Edit Drop adminuser
adminuser_7 FULLTEXT None  Edit Drop adminuser
ip_7 FULLTEXT None  Edit Drop ip
description_8 FULLTEXT None  Edit Drop description
adminuser_9 FULLTEXT None  Edit Drop adminuser
ip_9 FULLTEXT None  Edit Drop ip
adminuser_12 FULLTEXT None  Edit Drop adminuser
description_11 FULLTEXT None  Edit Drop description
ip_11 FULLTEXT None  Edit Drop ip
Create an index on  columns  
 
Space usage: 
Type Usage
Data 240 Bytes
Index 64,512 Bytes
Total 64,752 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 4
Row length ø 60
Row size  ø 16,188 Bytes
Next Autoindex 5
Creation Apr 24, 2018 at 10:59 PM
Last update Apr 24, 2018 at 10:59 PM
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: