ir908yEv

1CREATE TABLE IF NOT EXISTS `account_feature` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `account_id` int(11) NOT NULL,
4  `feature_id` int(11) NOT NULL,
5  `status` int(11) NOT NULL,
6  `is_deleted` int(11) NOT NULL,
7  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
8  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
9  PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
11
12CREATE TABLE IF NOT EXISTS `feature` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `parent_id` int(11) NOT NULL,
15  `name` varchar(255) NOT NULL,
16  `status` int(11) NOT NULL,
17  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
18  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
19  PRIMARY KEY (`id`)
20) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
21
22CREATE TABLE IF NOT EXISTS `file` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `name` varchar(255) NOT NULL,
25  `url` varchar(255) NOT NULL,
26  `metadata` json NOT NULL,
27  `sp_metadata` json NOT NULL,
28  `type` varchar(50) NOT NULL,
29  `extension` varchar(50) NOT NULL,
30  `created_by` int(11) NOT NULL,
31  `status` int(11) NOT NULL,
32  `is_deleted` int(11) NOT NULL DEFAULT '0',
33  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
34  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
35  PRIMARY KEY (`id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
37
38CREATE TABLE IF NOT EXISTS `service_provider_credential` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `account_id` int(11) DEFAULT NULL,
41  `name` varchar(255) NOT NULL,
42  `credential` json NOT NULL,
43  `feature_id` int(11) NOT NULL,
44  `created_by` int(11) NOT NULL,
45  `status` int(11) NOT NULL,
46  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
47  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
48  PRIMARY KEY (`id`)
49) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;