You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
bandolier-website/migrations/20220522091823_product.cjs

18 lines
563 B

exports.up = async (knex) => {
await knex.schema.createTable('product', (table) => {
table.increments('id');
table.timestamps(true, true);
table.string("title").notNullable();
table.text("description").notNullable();
table.integer("price");
table.string("currency", 3);
table.string("currency_symbol", 1);
table.boolean("active").default(false);
table.integer('media_id');
table.foreign('media_id').references('id').inTable('media');
});
}
exports.down = async (knex) => {
return knex.schema.dropTable('product');
}