DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
                        `id` int NOT NULL AUTO_INCREMENT,
                        `username` varchar(155) NOT NULL,
                        `full_name` varchar(150) NOT NULL,
                        `firstname` varchar(50) NOT NULL,
                        `lastname` varchar(50) NOT NULL,
                        `email` varchar(155) NOT NULL,
                        `telephone` varchar(15) NOT NULL,
                        `company_name` varchar(50) NOT NULL,
                        `password` varchar(255) NOT NULL,
                        `user_group_id` int NOT NULL,
                        `roles` text NOT NULL COMMENT 'admin,company,customer,staff',
                        `status` tinyint(1) NOT NULL,
                        `date_added` datetime NOT NULL,
                        `shop_id` int NOT NULL DEFAULT '1',
                        `delete_status` tinyint(1) NOT NULL DEFAULT '0',
                        `image` varchar(150) NOT NULL, -- Image sütunu eklendi
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;