sqlines icon indicating copy to clipboard operation
sqlines copied to clipboard

"mediumint(8) unsigned" mysql to oracle non translated

Open gbonazzoli opened this issue 7 years ago • 0 comments

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    |                |
+------------------------+-----------------------------+------+-----+---------+----------------+

gbonazzoli avatar Jun 26 '17 07:06 gbonazzoli