import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";

const cafeRequests = sequelize.define(
    "cafe_requests",
    {
        id: {
            type: Sequelize.BIGINT,
            primaryKey: true,
            autoIncrement: true,
            allowNull: false,
        },
        email: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        cafe_name: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        phone: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        cafe_type: {
            type: Sequelize.TINYINT(1),
            comment: '1-mobile cart,0-cafe',
            defaultValue:0
        },
        address: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        postcode: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        latitude: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        longitude: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        website: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        password: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        is_active: {
            type: Sequelize.TINYINT(1),
            comment: '1-Active,0-In-active',
            defaultValue:0
        },
        approved: {
            type: Sequelize.TINYINT(1),
            comment: '1-Approved,0-pending',
            defaultValue:0
        },
        signup_completed: {
            type: Sequelize.TINYINT(1),
            comment: '1-completed,0-pending',
            defaultValue:0
        },
        is_open: {
            type: Sequelize.TINYINT(1),
            comment: '1-open,0-close',
        },
        created_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0
        },
        updated_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0
        }
    },
    {
        tableName: 'cafe_requests',
        timestamps: false,
    }
);
sequelizePaginate.paginate(cafeRequests);
export default cafeRequests;