DROP TABLE IF EXISTS `currency`;
CREATE TABLE `currency` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `title` varchar(32) NOT NULL,
                            `code` varchar(32) NOT NULL,
                            `symbol_left` varchar(12) NOT NULL,
                            `symbol` varchar(5) NOT NULL,
                            `symbol_position` varchar(10) NOT NULL COMMENT 'left, right',
                            `symbol_right` varchar(12) NOT NULL,
                            `decimal_place` char(11) NOT NULL DEFAULT '2',
                            `value` double NOT NULL,
                            `price_buying` decimal(15,6) NOT NULL DEFAULT '1.000000',
                            `price_selling` decimal(15,6) NOT NULL DEFAULT '1.000000',
                            `status` tinyint(1) NOT NULL,
                            `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                            `date_edit` datetime DEFAULT NULL,
                            `shop_id` int NOT NULL DEFAULT '1',
                            `sort_order` int NOT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;