CREATE TABLE `blacklists`  (

`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,

`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

`type` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

`created_at` timestamp NULL DEFAULT NULL,

`updated_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

package model

​

import (

    "database/sql"

)

​

type Blacklists struct {

    Id        uint         `gorm:"column:id;type:int(10) unsigned;primary_key;AUTO_INCREMENT" json:"id"`

    Email     string       `gorm:"column:email;type:varchar(50);NOT NULL" json:"email"`

    Type      string       `gorm:"column:type;type:varchar(20);NOT NULL" json:"type"`

    CreatedAt sql.NullTime `gorm:"column:created_at;type:timestamp" json:"created_at"`

    UpdatedAt sql.NullTime `gorm:"column:updated_at;type:timestamp" json:"updated_at"`

}

​