Created
April 20, 2019 03:28
-
-
Save yeriepiscesa/25c6f8df455799639efc7795dca62045 to your computer and use it in GitHub Desktop.
Buat table untuk menampung data - https://solusipress.com/menyimpan-data-contact-form-7-pada-custom-table/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE `wp_123456_contacts` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
`full_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`province_id` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`regency_id` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`district_id` char(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`village_id` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`subject` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`message` text COLLATE utf8mb4_unicode_ci, | |
`ip_address` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`submit_date` datetime DEFAULT NULL, | |
`user_agent` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment