api/database/migrations/1756124105948_create_meals_table.ts
2025-08-25 19:12:28 +02:00

18 lines
464 B
TypeScript

import { BaseSchema } from '@adonisjs/lucid/schema'
export default class extends BaseSchema {
protected tableName = 'meals'
async up() {
this.schema.createTable(this.tableName, (table) => {
table.increments('id')
table.date('date').notNullable()
table.integer('type').notNullable() // 0 = lunch, 1 = dinner
table.boolean('submittable').defaultTo(false)
})
}
async down() {
this.schema.dropTable(this.tableName)
}
}