Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: ads_couponsads_coupons
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)
SQL-query: 
SELECT *
FROM `ads_coupons`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   float(6,2)     No  0.00    Change Drop Primary Index Unique Fulltext
   date     No  0000-00-00    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     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 coupon_id
coupon_id_2 UNIQUE Edit Drop coupon_id
coupon_code_2 UNIQUE Edit Drop coupon_code
coupon_percent_2 UNIQUE Edit Drop coupon_percent
coupon_amount_2 UNIQUE Edit Drop coupon_amount
coupon_expires_2 UNIQUE Edit Drop coupon_expires
coupon_uses_2 UNIQUE Edit Drop coupon_uses
coupon_restrict_2 UNIQUE Edit Drop coupon_restrict
coupon_type_2 UNIQUE Edit Drop coupon_type
coupon_id_4 UNIQUE Edit Drop coupon_id
coupon_code_5 UNIQUE Edit Drop coupon_code
coupon_percent_4 UNIQUE Edit Drop coupon_percent
coupon_amount_4 UNIQUE Edit Drop coupon_amount
coupon_expires_4 UNIQUE Edit Drop coupon_expires
coupon_uses_4 UNIQUE Edit Drop coupon_uses
coupon_restrict_4 UNIQUE Edit Drop coupon_restrict
coupon_type_4 UNIQUE Edit Drop coupon_type
coupon_restrict_5 UNIQUE Edit Drop coupon_restrict
coupon_id_5 UNIQUE Edit Drop coupon_id
coupon_expires_6 UNIQUE Edit Drop coupon_expires
coupon_percent_6 UNIQUE Edit Drop coupon_percent
coupon_amount_5 UNIQUE Edit Drop coupon_amount
coupon_code_9 UNIQUE Edit Drop coupon_code
coupon_uses_6 UNIQUE Edit Drop coupon_uses
coupon_type_6 UNIQUE Edit Drop coupon_type
coupon_expires_7 UNIQUE Edit Drop coupon_expires
coupon_id_8 UNIQUE Edit Drop coupon_id
coupon_restrict_8 UNIQUE Edit Drop coupon_restrict
coupon_code_12 UNIQUE Edit Drop coupon_code
coupon_id INDEX None  Edit Drop coupon_id
coupon_code INDEX None  Edit Drop coupon_code
coupon_percent INDEX None  Edit Drop coupon_percent
coupon_amount INDEX None  Edit Drop coupon_amount
coupon_expires INDEX None  Edit Drop coupon_expires
coupon_uses INDEX None  Edit Drop coupon_uses
coupon_restrict INDEX None  Edit Drop coupon_restrict
coupon_type INDEX None  Edit Drop coupon_type
coupon_id_3 INDEX None  Edit Drop coupon_id
coupon_code_4 INDEX None  Edit Drop coupon_code
coupon_percent_3 INDEX None  Edit Drop coupon_percent
coupon_amount_3 INDEX None  Edit Drop coupon_amount
coupon_expires_3 INDEX None  Edit Drop coupon_expires
coupon_uses_3 INDEX None  Edit Drop coupon_uses
coupon_restrict_3 INDEX None  Edit Drop coupon_restrict
coupon_type_3 INDEX None  Edit Drop coupon_type
coupon_uses_5 INDEX None  Edit Drop coupon_uses
coupon_type_5 INDEX None  Edit Drop coupon_type
coupon_restrict_6 INDEX None  Edit Drop coupon_restrict
coupon_expires_5 INDEX None  Edit Drop coupon_expires
coupon_percent_5 INDEX None  Edit Drop coupon_percent
coupon_code_7 INDEX None  Edit Drop coupon_code
coupon_id_6 INDEX None  Edit Drop coupon_id
coupon_amount_6 INDEX None  Edit Drop coupon_amount
coupon_code_10 INDEX None  Edit Drop coupon_code
coupon_id_7 INDEX None  Edit Drop coupon_id
coupon_percent_7 INDEX None  Edit Drop coupon_percent
coupon_expires_8 INDEX None  Edit Drop coupon_expires
coupon_uses_7 INDEX None  Edit Drop coupon_uses
coupon_restrict_7 INDEX None  Edit Drop coupon_restrict
coupon_type_7 INDEX None  Edit Drop coupon_type
coupon_code_3 FULLTEXT None  Edit Drop coupon_code
coupon_code_6 FULLTEXT None  Edit Drop coupon_code
coupon_code_8 FULLTEXT None  Edit Drop coupon_code
coupon_code_11 FULLTEXT None  Edit Drop coupon_code
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Feb 17, 2018 at 04:32 PM
Last update Apr 08, 2018 at 03:33 PM
Last check Apr 08, 2018 at 03:33 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: