opencode/services/update/migrations/0002_artifact_time_created.sql

3 lines
146 B
SQL

ALTER TABLE artifact ADD COLUMN time_created INTEGER NOT NULL DEFAULT 0;
UPDATE artifact SET time_created = time_updated WHERE time_created = 0;