Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yeriepiscesa/25c6f8df455799639efc7795dca62045 to your computer and use it in GitHub Desktop.
Save yeriepiscesa/25c6f8df455799639efc7795dca62045 to your computer and use it in GitHub Desktop.
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