/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50725 Source Host : 127.0.0.1:3306 Source Schema : db_information_table Target Server Type : MySQL Target Server Version : 50725 File Encoding : 65001 Date: 06/06/2019 10:59:19 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_info_list -- ---------------------------- DROP TABLE IF EXISTS `tb_info_list`; CREATE TABLE `tb_info_list` ( `id` bigint(20) NOT NULL, `type` varchar(64) COLLATE utf8mb4_bin NOT NULL, `name` varchar(64) COLLATE utf8mb4_bin NOT NULL, `phone` varchar(11) COLLATE utf8mb4_bin NOT NULL, `email` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL, `remark` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL, `created` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; SET FOREIGN_KEY_CHECKS = 1;