CREATE TABLE `email_configuration` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `type` CHAR(11) NOT NULL COMMENT '[x_report] , [z_report] , [week_report]' , `email` VARCHAR(255) NOT NULL , `added_by` INT(11) NOT NULL , `date_added` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` CHAR(1) NOT NULL DEFAULT 'A' COMMENT '[A]ctive , [D]isabled , [R]emoved' , PRIMARY KEY (`id`), INDEX (`type`), INDEX (`added_by`), INDEX (`status`)) ENGINE = InnoDB;

- 20210624 -
CREATE TABLE `autoload_configuration` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `short` VARCHAR(255) NOT NULL , `name` VARCHAR(255) NOT NULL , `value` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
INSERT INTO `autoload_configuration` (`id`, `short`, `name`, `value`) VALUES
(1, 'TEST', 'Environment Settings', 'TRUE'),
(2, 'BACKOFFICE_URL', 'Backoffice URL', 'http://localhost/sample_accounting/en/sidsApi/?'),
(3, 'BACKOFFICE_ACCOUNTS_URL', 'BACKOFFICE_ACCOUNTS_URL', 'http://localhost/sample_accounting/'),
(4, 'BACKOFFICE_ACCOUNTS_URL_S', 'BACKOFFICE_ACCOUNTS_URL_S', 'http://localhost/sample_accounting/'),
(5, 'PRINTER_DEFAULT_ZONE', 'Default Printer', '1'),
(6, 'HTTP_PATH', 'Pos Folder', '/sample_pos');

- 20210625 - 
ALTER TABLE `t` ADD `with_pin` CHAR(3) NOT NULL DEFAULT 'NO' COMMENT '[YES] , [NO]' AFTER `sort`, ADD INDEX (`with_pin`);

- 20210628 -
ALTER TABLE `configuration` ADD `sort_order` INT(11) NOT NULL DEFAULT '1' AFTER `val`;
INSERT INTO `configuration` (`id`, `short`, `name`, `kind`, `val`) VALUES (NULL, 'store_code', 'STORE CODE', '2', 'sample_store_1');

UPDATE `configuration` SET `name` = 'Store Name' WHERE `configuration`.`id` = 1;
UPDATE `configuration` SET `sort_order` = '2' WHERE `configuration`.`id` = 1;
UPDATE `configuration` SET `sort_order` = '3' WHERE `configuration`.`id` = 12;
UPDATE `configuration` SET `sort_order` = '4' WHERE `configuration`.`id` = 13;
UPDATE `configuration` SET `sort_order` = '5' WHERE `configuration`.`id` = 4;
UPDATE `configuration` SET `sort_order` = '6' WHERE `configuration`.`id` = 11;
UPDATE `configuration` SET `sort_order` = '7' WHERE `configuration`.`id` = 3;
UPDATE `configuration` SET `sort_order` = '8' WHERE `configuration`.`id` = 2;
UPDATE `configuration` SET `sort_order` = '9' WHERE `configuration`.`id` = 14;
UPDATE `configuration` SET `sort_order` = '10' WHERE `configuration`.`id` = 8;
UPDATE `configuration` SET `sort_order` = '11' WHERE `configuration`.`id` = 9;
UPDATE `configuration` SET `sort_order` = '12' WHERE `configuration`.`id` = 10;
UPDATE `configuration` SET `sort_order` = '13' WHERE `configuration`.`id` = 7;
UPDATE `configuration` SET `sort_order` = '0' WHERE `configuration`.`id` = 6;
UPDATE `configuration` SET `sort_order` = '0' WHERE `configuration`.`id` = 5;

ALTER TABLE `configuration` ADD `type` CHAR(15) NOT NULL AFTER `sort_order`;
UPDATE `configuration` SET `type` = 'ticket' WHERE `configuration`.`id` IN (8,9,10);
UPDATE `configuration` SET `type` = 'image' WHERE `configuration`.`id` IN (5,6);
UPDATE `configuration` SET `type` = 'store_details' WHERE `configuration`.`type` = '' AND `configuration`.`id` != '7';

INSERT INTO `configuration` (`id`, `short`, `name`, `kind`, `val`, `sort_order`, `type`) VALUES (NULL, 'register_number', 'CASH REGISTER NUMBER', '2', '1', '10', 'store_details');

- 20210701 -
TRUNCATE `section`;