-- Author: Neville Matthews -- ******************************************************************** -- *** This script deletes all exisiting *** -- *** orders and resets the order number to the value specified. *** -- ******************************************************************** -- NB: Change the AUTO_INCREMENT to the same value for each line. -- Amendments -- 18/01/2018 -- Reduce the size of the order number to 5 Digits, range 10001 to 99999 -- 02/03/2021 -- Added tables hikashop_download and hikashop_history -- TRUNCATE lou_hikashop_order; TRUNCATE lou_hikashop_order_product; TRUNCATE lou_hikashop_download; TRUNCATE lou_hikashop_history; ALTER TABLE lou_hikashop_order AUTO_INCREMENT=10001; ALTER TABLE lou_hikashop_order_product AUTO_INCREMENT=10001; -- NB: Change the AUTO_INCREMENT to the same value for each line. -- The code below this line shows the value of the Auto_INCREMNT field SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'lou' AND TABLE_NAME = 'lou_hikashop_order_product';