Autoupgrade - Verify the database after upgrade to V9

Details

Steps

Step Description Expected result
* Go to your Database > [prefixe]_address
* Go to the structure
* The different information of the address database should be displayed
* The “other” value should be “mediumtext”
* Go to your Database > [prefixe]attachment_lang
* Go to the structure
* The different information of the attachment_lang database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]cart_rule
* Go to the structure
* The different information of the cart_rule database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]cart
* Go to the structure
* The different information of the cart database should be displayed
* The “delivery_option” value should be “mediumtext”
* The “gift_message” value should be “mediumtext”
* The “checkout_session_data” value should be “mediumtext”
* Go to your Database > [prefixe]category_lang
* Go to the structure
* The different information of the category_lang database should be displayed
* The “description” value should be “mediumtext”
* The “additional_description” value should be “mediumtext”
* Go to your Database > [prefixe]cms_category_lang
* Go to the structure
* The different information of the cms_category_lang database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]cms_lang
* Go to the structure
* The different information of the cms_lang database should be displayed
* The “content” value should be “longtext”
* Go to your Database > [prefixe]configuration_kpi_lang
* Go to the structure
* The different information of the configuration_kpi_lang database should be displayed
* The “value” value should be “mediumtext”
* Go to your Database > [prefixe]configuration_kpi
* Go to the structure
* The different information of the configuration_kpi database should be displayed
* The “value” value should be “mediumtext”
* Go to your Database > [prefixe]configuration_lang
* Go to the structure
* The different information of the configuration_lang database should be displayed
* The “value” value should be “mediumtext”
* Go to your Database > [prefixe]contact_lang
* Go to the structure
* The different information of the contact_lang database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]customer_message
* Go to the structure
* The different information of the customer_message database should be displayed
* The “message” value should be “mediumtext”
* Go to your Database > [prefixe]customer
* Go to the structure
* The different information of the customer database should be displayed
* The “note” value should be “mediumtext”
* Go to your Database > [prefixe]hook
* Go to the structure
* The different information of the hook database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]import_match
* Go to the structure
* The different information of the import_match database should be displayed
* The “match” value should be “mediumtext”
* Go to your Database > [prefixe]log
* Go to the structure
* The different information of the log database should be displayed
* The “message” value should be “mediumtext”
* Go to your Database > [prefixe]manufacturer_lang
* Go to the structure
* The different information of the manufacturer_lang database should be displayed
* The “description” value should be “mediumtext”
* The “short_description” value should be “mediumtext”
* Go to your Database > [prefixe]message
* Go to the structure
* The different information of the message database should be displayed
* The “message” value should be “mediumtext”
* Go to your Database > [prefixe]order_detail
* Go to the structure
* The different information of the order_detail database should be displayed
* The “product_name” value should be “mediumtext”
* Go to your Database > [prefixe]order_invoice
* Go to the structure
* The different information of the order_invoice database should be displayed
* The “note” value should be “mediumtext”
* The “shop_address” value should be “mediumtext”
* Go to your Database > [prefixe]order_message_lang
* Go to the structure
* The different information of the order_message_lang database should be displayed
* The “message” value should be “mediumtext”
* Go to your Database > [prefixe]order_return
* Go to the structure
* The different information of the order_return database should be displayed
* The “question” value should be “mediumtext”
* Go to your Database > [prefixe]orders
* Go to the structure
* The different information of the orders database should be displayed
* The “gift_message” value should be “mediumtext”
* The “note” value should be “mediumtext”
* Go to your Database > [prefixe]request_sql
* Go to the structure
* The different information of the request_sql database should be displayed
* The “sql” value should be “mediumtext”
* Go to your Database > [prefixe]product_lang
* Go to the structure
* The different information of the product_lang database should be displayed
* The “description” value should be “mediumtext”
* The “descritpion_short” value should be “mediumtext”
* Go to your Database > [prefixe]store_lang
* Go to the structure
* The different information of the store_lang database should be displayed
* The “hours” value should be “mediumtext”
* The “note” value should be “mediumtext”
* Go to your Database > [prefixe]supplier_lang
* Go to the structure
* The different information of the supplier_lang database should be displayed
* The “description” value should be “mediumtext”
* Go to your Database > [prefixe]webservice_account
* Go to the structure
* The different information of the webservice_account database should be displayed
* The “description” value should be “mediumtext”
Go to your Database > [prefixe]_configuration * PS_SSL_ENABLED should be here
* PS_SSL_ENABLED_EVERYWHERE shouldn’t be here 
* PS_VERSION_DB should be 9.0.0
* Go to the structure * The “value” value should be “mediumtext”
* Click on the browse Tab
* Change the PS_Version_DB
* The different information of the configuration database should be displayed
* You should have a notification with “1 row affected”
Go to BO > 1-Click Upgrade * You should have a new line with a cross on the requirement named “The version of PrestaShop does not match the one stored in database […]"
* You should have a red notification " PrestaShop requirements are not satisfied.”
* Return on the database and change the PS_Version_DB
* Return on the BO
* You should have a notification with “1 row affected”
* Al requirement should be good