DROP TABLE IF EXISTS `master_users`;
CREATE TABLE `master_users` (
`user_id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password_hash` varchar(255) NOT NULL,
`group_id` int NOT NULL,
`token` varchar(255) NOT NULL,
`token_ts` int UNSIGNED DEFAULT 0,
`comments` varchar(255) DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` int DEFAULT NULL,
`approved_on` timestamp NULL DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_approved` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
DROP TABLE IF EXISTS `registration`;
CREATE TABLE `registration` (
`id` int NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`created_by` int DEFAULT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` int DEFAULT NULL,
`approved_on` timestamp NULL DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_approved` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
`id` int NOT NULL AUTO_INCREMENT,
`registration_id` int NOT NULL DEFAULT 0,
`address` varchar(255) NOT NULL,
`created_by` int DEFAULT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` int DEFAULT NULL,
`approved_on` timestamp NULL DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_approved` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int NOT NULL AUTO_INCREMENT,
`parent_id` int NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL,
`created_by` int DEFAULT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` int DEFAULT NULL,
`approved_on` timestamp NULL DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_approved` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No',
`is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `master_users` WRITE;
/*!40000 ALTER TABLE `master_users` DISABLE KEYS */;
INSERT INTO `master_users` VALUES
(1,'client_1_group_1_user_1','$2y$10$o8hFTjBIXQS.fOED2Ut1ZOCSdDjTnS3lyELI4rWyFEnu4GUyJr3O6',1,'',0,NULL,0,'2023-02-22 04:12:50',NULL,NULL,0,'2023-04-20 16:53:57','Yes','No','No'),
(2,'client_1_group_2_user_1','$2y$10$o8hFTjBIXQS.fOED2Ut1ZOCSdDjTnS3lyELI4rWyFEnu4GUyJr3O6',2,'',0,NULL,0,'2023-02-22 04:12:50',NULL,NULL,0,'2023-04-20 16:53:57','Yes','No','No');
/*!40000 ALTER TABLE `master_users` ENABLE KEYS */;
UNLOCK TABLES;
|