DROP TABLE IF EXISTS `fixture`;
CREATE TABLE `fixture` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `user_id` int NOT NULL,
                           `shop_id` int NOT NULL,
                           `name` varchar(150) NOT NULL,
                           `serial_no` varchar(50) NOT NULL,
                           `sale_date` datetime DEFAULT NULL,
                           `insert_dadte` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                           `price` decimal(15,6) NOT NULL,
                           `note` text NOT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;