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

const coffeeRunInHouseOrders = sequelize.define(
    "coffee_run_in_house_orders",
    {
        id: {
            type: Sequelize.BIGINT.UNSIGNED,
            primaryKey: true,
            autoIncrement: true,
            allowNull: false,
        },
        user_id: {
            type: Sequelize.BIGINT.UNSIGNED,
        },
        customized_order: {
            type: Sequelize.STRING
        },
        in_house_order_items: {
            type: Sequelize.TEXT('long'),
            allowNull: false
        },
        coffee_run_id: {
            type: Sequelize.STRING,
            allowNull: false
        },
        order_collected_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0,
            comment: '0 = active 1 = collected'
        },
        group_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: false
        },
        created_at: {
            type: Sequelize.INTEGER
        },
        updated_at: {
            type: Sequelize.INTEGER
        },
    },
    {
        tableName: 'coffee_run_in_house_orders',
        timestamps: false,
    }
);



sequelizePaginate.paginate(coffeeRunInHouseOrders);
coffeeRunInHouseOrders.sync();
export default coffeeRunInHouseOrders;