import { Knex } from "knex";
 
export async function up(knex: Knex): Promise<void> {
    return knex.schema
        .createTable('Address', function (table) {
            table.increments('id').notNullable().unsigned();
        })
        .createTable('EcommerceOrder', function (table) {
            table.increments('id').notNullable();
            table.timestamp('ordered_at');
            table.string('customer_note');
            table.string('internal_note');
            table.integer('billing_address_id').unique();
            table.integer('delivery_address_id').unique();
        })
        .alterTable('EcommerceOrder', function (table) {
            table.foreign('billing_address_id').references('id').inTable('Address');
        })
        .alterTable('EcommerceOrder', function (table) {
            table.foreign('delivery_address_id').references('id').inTable('Address');
        })
    ;
}
export async function down(knex: Knex): Promise<void> {
    return knex.schema
        .alterTable('EcommerceOrder', function (table) {
            table.dropForeign(['delivery_address_id']);
        })
        .alterTable('EcommerceOrder', function (table) {
            table.dropForeign(['billing_address_id']);
        })
        .dropTable('EcommerceOrder')
        .dropTable('Address')
    ;
}

//Object for database table 
export interface EcommerceOrder
{
    id?: number;
    ordered_at?: number;
    customer_note?: string;
    internal_note?: string;
    billing_address_id?: number;
    delivery_address_id?: number;
}
 
//Array of objects for table 
export type EcommerceOrderArray = Array<EcommerceOrder>;