Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: ads_adsads_ads
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
   tinyint(1)     No  0    Change Drop Primary Index Unique Fulltext
   int(5)     No  0    Change Drop Primary Index Unique Fulltext
   int(5)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(10)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No  0.00    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No  0    Change Drop Primary Index Unique Fulltext
   int(4)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No  0    Change Drop Primary Index Unique Fulltext
   int(4)     No  0    Change Drop Primary Index Unique Fulltext
   int(3)     No  0    Change Drop Primary Index Unique Fulltext
   float(6,2)     No  0.00    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) 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: 
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 5  Edit Drop ad_id
ad_id_2 UNIQUE 5  Edit Drop ad_id
ad_title_2 UNIQUE 5  Edit Drop ad_title
ad_image1_2 UNIQUE 5  Edit Drop ad_image1
ad_image2 UNIQUE 5  Edit Drop ad_image2
ad_options_2 UNIQUE 5  Edit Drop ad_options
ad_views_2 UNIQUE 5  Edit Drop ad_views
ad_id INDEX None  Edit Drop ad_id
ad_status INDEX None  Edit Drop ad_status
ad_user_id INDEX None  Edit Drop ad_user_id
ad_category INDEX None  Edit Drop ad_category
ad_date_begin INDEX None  Edit Drop ad_date_begin
ad_date_end INDEX None  Edit Drop ad_date_end
ad_type INDEX None  Edit Drop ad_type
ad_title INDEX None  Edit Drop ad_title
ad_image1 INDEX None  Edit Drop ad_image1
ad_image2_2 INDEX None  Edit Drop ad_image2
ad_image3 INDEX None  Edit Drop ad_image3
ad_image4 INDEX None  Edit Drop ad_image4
ad_image5 INDEX None  Edit Drop ad_image5
ad_options INDEX None  Edit Drop ad_options
ad_optional_1 INDEX None  Edit Drop ad_optional_1
ad_optional_2 INDEX None  Edit Drop ad_optional_2
ad_optional_3 INDEX None  Edit Drop ad_optional_3
ad_optional_4 INDEX None  Edit Drop ad_optional_4
ad_optional_5 INDEX None  Edit Drop ad_optional_5
ad_type_optional1 INDEX None  Edit Drop ad_type_optional1
ad_type_optional2 INDEX None  Edit Drop ad_type_optional2
ad_type_optional3 INDEX None  Edit Drop ad_type_optional3
ad_type_optional4 INDEX None  Edit Drop ad_type_optional4
ad_type_optional5 INDEX None  Edit Drop ad_type_optional5
ad_type_optional6 INDEX None  Edit Drop ad_type_optional6
ad_type_optional7 INDEX None  Edit Drop ad_type_optional7
ad_type_optional8 INDEX None  Edit Drop ad_type_optional8
ad_type_optional9 INDEX None  Edit Drop ad_type_optional9
ad_type_optional10 INDEX None  Edit Drop ad_type_optional10
ad_price INDEX None  Edit Drop ad_price
ad_condition INDEX None  Edit Drop ad_condition
ad_views INDEX None  Edit Drop ad_views
ad_date_begin_2 FULLTEXT None  Edit Drop ad_date_begin
ad_date_end_2 FULLTEXT None  Edit Drop ad_date_end
ad_title_3 FULLTEXT None  Edit Drop ad_title
ad_description FULLTEXT None  Edit Drop ad_description
ad_image1_3 FULLTEXT None  Edit Drop ad_image1
ad_image2_3 FULLTEXT None  Edit Drop ad_image2
ad_image3_2 FULLTEXT None  Edit Drop ad_image3
ad_image4_2 FULLTEXT None  Edit Drop ad_image4
ad_image5_2 FULLTEXT None  Edit Drop ad_image5
ad_optional_1_2 FULLTEXT None  Edit Drop ad_optional_1
ad_optional_2_2 FULLTEXT None  Edit Drop ad_optional_2
ad_optional_3_2 FULLTEXT None  Edit Drop ad_optional_3
ad_optional_4_2 FULLTEXT None  Edit Drop ad_optional_4
ad_optional_5_2 FULLTEXT None  Edit Drop ad_optional_5
ad_type_optional1_2 FULLTEXT None  Edit Drop ad_type_optional1
ad_type_optional2_2 FULLTEXT None  Edit Drop ad_type_optional2
ad_type_optional3_2 FULLTEXT None  Edit Drop ad_type_optional3
ad_type_optional4_2 FULLTEXT None  Edit Drop ad_type_optional4
ad_type_optional5_2 FULLTEXT None  Edit Drop ad_type_optional5
ad_type_optional6_2 FULLTEXT None  Edit Drop ad_type_optional6
ad_type_optional7_2 FULLTEXT None  Edit Drop ad_type_optional7
ad_type_optional8_2 FULLTEXT None  Edit Drop ad_type_optional8
ad_type_optional9_2 FULLTEXT None  Edit Drop ad_type_optional9
ad_type_optional10_2 FULLTEXT None  Edit Drop ad_type_optional10
ad_price_2 FULLTEXT None  Edit Drop ad_price
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,028 Bytes
Index 4,096 Bytes
Total 5,124 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 205
Row size  ø 1,025 Bytes
Next Autoindex 11
Creation Apr 25, 2017 at 04:36 AM
Last update Mar 17, 2024 at 05:52 AM
Last check Mar 17, 2024 at 05:52 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: