· 8 years ago · Feb 22, 2018, 10:50 AM
1DROP TABLE IF EXISTS `tbl_request_logs`;
2CREATE TABLE `tbl_request_logs` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `request_headers` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `request_method` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
6 `request_body` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 `api` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
8 `request_uri` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
9 `created_date` datetime NOT NULL,
10 `response_body` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
11 `user_agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
12 PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;