GX-Bug #47096 » OrdersProductsModelNullFix.patch
| src/gambio_installer/sql/products_attributes.sql (revision ) | ||
|---|---|---|
| 6 | 6 |
`options_values_id` int(11) NOT NULL DEFAULT '0', |
| 7 | 7 |
`options_values_price` decimal(15,4) NOT NULL DEFAULT '0.0000', |
| 8 | 8 |
`price_prefix` char(1) NOT NULL DEFAULT '', |
| 9 |
`attributes_model` varchar(64) DEFAULT NULL,
|
|
| 9 |
`attributes_model` varchar(64) DEFAULT '',
|
|
| 10 | 10 |
`attributes_stock` decimal(15,4) DEFAULT NULL, |
| 11 | 11 |
`options_values_weight` decimal(15,4) NOT NULL DEFAULT '0.0000', |
| 12 | 12 |
`weight_prefix` char(1) NOT NULL DEFAULT '', |
| src/gambio_installer/sql/products.sql (revision ) | ||
|---|---|---|
| 4 | 4 |
`products_ean` varchar(128) DEFAULT NULL, |
| 5 | 5 |
`products_quantity` decimal(15,4) NOT NULL DEFAULT '0.0000', |
| 6 | 6 |
`products_shippingtime` int(4) NOT NULL DEFAULT '0', |
| 7 |
`products_model` varchar(64) DEFAULT NULL,
|
|
| 7 |
`products_model` varchar(64) DEFAULT '',
|
|
| 8 | 8 |
`group_permission_0` tinyint(1) NOT NULL DEFAULT '0', |
| 9 | 9 |
`group_permission_1` tinyint(1) NOT NULL DEFAULT '0', |
| 10 | 10 |
`group_permission_2` tinyint(1) NOT NULL DEFAULT '0', |
| src/gambio_installer/sql/orders_products.sql (revision ) | ||
|---|---|---|
| 3 | 3 |
`orders_products_id` int(11) NOT NULL AUTO_INCREMENT, |
| 4 | 4 |
`orders_id` int(11) NOT NULL DEFAULT '0', |
| 5 | 5 |
`products_id` int(11) NOT NULL DEFAULT '0', |
| 6 |
`products_model` varchar(64) DEFAULT NULL,
|
|
| 6 |
`products_model` varchar(64) DEFAULT '',
|
|
| 7 | 7 |
`products_name` varchar(255) NOT NULL DEFAULT '', |
| 8 | 8 |
`products_price` decimal(15,4) NOT NULL DEFAULT '0.0000', |
| 9 | 9 |
`products_discount_made` decimal(4,2) DEFAULT NULL, |