16 lines
658 B
JavaScript
16 lines
658 B
JavaScript
|
// Sync metadata from .gnommo_sync.json — tracks push/pull history with gnommo tool.
|
||
|
|
exports.up = (pgm) => {
|
||
|
|
pgm.createTable('project_sync', {
|
||
|
|
id: 'id',
|
||
|
|
project_id: { type: 'integer', notNull: true, unique: true,
|
||
|
|
references: 'videos', onDelete: 'CASCADE' },
|
||
|
|
last_pulled_at: { type: 'timestamptz' },
|
||
|
|
server_updated_at: { type: 'timestamptz' },
|
||
|
|
last_pushed_at: { type: 'timestamptz' },
|
||
|
|
last_handoff_at: { type: 'timestamptz' },
|
||
|
|
video_version: { type: 'integer', notNull: true, default: 0 },
|
||
|
|
});
|
||
|
|
};
|
||
|
|
|
||
|
|
exports.down = (pgm) => { pgm.dropTable('project_sync'); };
|