GX-Bug #46978 » 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, |