DROP TABLE IF EXISTS `accounting_definitions`;
CREATE TABLE `accounting_definitions` (
                                          `id` int NOT NULL AUTO_INCREMENT,
                                          `expense_income_id` int NOT NULL,
                                          `amount` decimal(15,4) NOT NULL,
                                          `payment_date` datetime NOT NULL,
                                          `shop_id` int NOT NULL,
                                          `user_id` int NOT NULL,
                                          `mail_notification` varchar(50) NOT NULL,
                                          `sms_notification` varchar(50) NOT NULL,
                                          `mail_not_status` tinyint(1) NOT NULL,
                                          `sms_not_status` tinyint(1) NOT NULL,
                                          `loop` tinyint(1) NOT NULL,
                                          `type` varchar(50) NOT NULL,
                                          `supply_id` int NOT NULL,
                                          `status` tinyint(1) NOT NULL DEFAULT '0',
                                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

