forked from DebaucheryLibrarian/traxxx
37 lines
778 B
JavaScript
37 lines
778 B
JavaScript
|
exports.up = async (knex) => {
|
||
|
|
await knex.schema.createTable('movies_teasers', (table) => {
|
||
|
|
table.integer('movie_id', 16)
|
||
|
|
.notNullable()
|
||
|
|
.references('id')
|
||
|
|
.inTable('movies')
|
||
|
|
.onDelete('cascade');
|
||
|
|
|
||
|
|
table.text('media_id', 21)
|
||
|
|
.notNullable()
|
||
|
|
.references('id')
|
||
|
|
.inTable('media');
|
||
|
|
|
||
|
|
table.unique('movie_id');
|
||
|
|
});
|
||
|
|
|
||
|
|
await knex.schema.createTable('series_teasers', (table) => {
|
||
|
|
table.integer('serie_id', 16)
|
||
|
|
.notNullable()
|
||
|
|
.references('id')
|
||
|
|
.inTable('series')
|
||
|
|
.onDelete('cascade');
|
||
|
|
|
||
|
|
table.text('media_id', 21)
|
||
|
|
.notNullable()
|
||
|
|
.references('id')
|
||
|
|
.inTable('media');
|
||
|
|
|
||
|
|
table.unique('serie_id');
|
||
|
|
});
|
||
|
|
};
|
||
|
|
|
||
|
|
exports.down = async (knex) => {
|
||
|
|
await knex.schema.dropTable('movies_teasers');
|
||
|
|
await knex.schema.dropTable('series_teasers');
|
||
|
|
};
|