· 9 years ago · Dec 13, 2016, 11:01 AM
1CREATE TABLE IF NOT EXISTS `feel_sms_codes` (
2`code_id` int(11) NOT NULL,
3 `code` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
4 `status` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'active',
5 `expired` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
6 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
7 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
8) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;