24 lines
585 B
JavaScript
24 lines
585 B
JavaScript
|
|
exports.up = function(knex) {
|
|
return knex.schema
|
|
.createTable('da', async function (table) {
|
|
table.increments('id');
|
|
table.string('DSPShortCode');
|
|
table.string('ertDriveDate');
|
|
table.string('db_fullName');
|
|
table.string('db_employeeID');
|
|
table.string('getStartTime');
|
|
table.string('getEndTime');
|
|
table.string('db_TrainerSelected');
|
|
table.string('getStationCode');
|
|
table.string('db_licenseNumber');
|
|
table.string('db_state');
|
|
})
|
|
|
|
};
|
|
|
|
exports.down = function(knex) {
|
|
return knex.schema
|
|
.dropTable('da')
|
|
};
|