Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id_specific_price_rule | int(10) unsigned | NO | PRI | auto_increment | |
| name | varchar(255) | NO | |||
| id_shop | int(11) unsigned | NO | MUL | 1 | |
| id_currency | int(10) unsigned | NO | |||
| id_country | int(10) unsigned | NO | |||
| id_group | int(10) unsigned | NO | |||
| from_quantity | mediumint(8) unsigned | NO | |||
| price | decimal(20,6) | YES | |||
| reduction | decimal(20,6) | NO | |||
| reduction_tax | tinyint(1) | NO | 1 | ||
| reduction_type | enum('amount','percentage') | NO | |||
| from | datetime | NO | |||
| to | datetime | NO |