sqlines
sqlines copied to clipboard
"mediumint(8) unsigned" mysql to oracle non translated
In Prestashop there are field declared "mediumint(8) unsigned" that are not translated to oracle
desc ps_specific_price;
+------------------------+-----------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------+------+-----+---------+----------------+
| id_specific_price | int(10) unsigned | NO | PRI | NULL | auto_increment |
| id_specific_price_rule | int(11) unsigned | NO | MUL | NULL | |
| id_cart | int(11) unsigned | NO | MUL | NULL | |
| id_product | int(10) unsigned | NO | MUL | NULL | |
| id_shop | int(11) unsigned | NO | MUL | 1 | |
| id_shop_group | int(11) unsigned | NO | | NULL | |
| id_currency | int(10) unsigned | NO | | NULL | |
| id_country | int(10) unsigned | NO | | NULL | |
| id_group | int(10) unsigned | NO | | NULL | |
| id_customer | int(10) unsigned | NO | MUL | NULL | |
| id_product_attribute | int(10) unsigned | NO | MUL | NULL | |
| price | decimal(20,6) | NO | | NULL | |
| from_quantity | mediumint(8) unsigned | NO | MUL | NULL | |
| reduction | decimal(20,6) | NO | | NULL | |
| reduction_tax | tinyint(1) | NO | | 1 | |
| reduction_type | enum('amount','percentage') | NO | | NULL | |
| from | datetime | NO | MUL | NULL | |
| to | datetime | NO | MUL | NULL | |
+------------------------+-----------------------------+------+-----+---------+----------------+