cloudaxe-opencode/packages/updates/migrations/0002_artifact_time_created.sql

4 lines
146 B
MySQL
Raw Permalink Normal View History

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