CREATE TABLE `rooms101_rtsdev`.`tbl_users`  (
                                               `id` int(0) NOT NULL AUTO_INCREMENT,
                                               `user_name` varchar(180) NOT NULL,
                                               `roles` json NOT NULL,
                                               `password` varchar(255) NULL,
                                               `first_name` varchar(40) NULL,
                                               `last_name` varchar(40) NULL,
                                               `phone` varchar(21) NULL,
                                               `access` int NULL,
                                               `department` int NULL,
                                               `last_pass` datetime NULL,
                                               `ipaddess` varchar(180) NULL,
                                               `login_date` datetime(0) NULL,
                                               `active` int(1) NULL,
                                               `commissionPercentage` decimal(8, 6) NULL,
                                               `email` varchar(180) NULL,
                                               PRIMARY KEY (`id`)
);
