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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   tinyint(1)     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(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    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    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    Change Drop Primary Index Unique Fulltext
   int(4)     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(11)     No    Change Drop Primary Index Unique Fulltext
   int(4)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    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: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop ad_id
ad_id_2 UNIQUE Edit Drop ad_id
ad_title_2 UNIQUE Edit Drop ad_title
ad_image1_2 UNIQUE Edit Drop ad_image1
ad_image2 UNIQUE Edit Drop ad_image2
ad_options_2 UNIQUE Edit Drop ad_options
ad_views_2 UNIQUE 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 Jun 07, 2018 at 12:28 PM
Last check Jun 07, 2018 at 01:29 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: