1
0
Fork 0
mirror of https://github.com/YunoHost-Apps/castopod_ynh.git synced 2024-09-03 18:16:14 +02:00
castopod_ynh/scripts/from_beta_16.sql
2023-01-19 17:25:42 +01:00

11 lines
No EOL
265 B
SQL

SET AUTOCOMMIT = 0;
START TRANSACTION;
ALTER TABLE `cp_settings`
ADD COLUMN context VARCHAR(255) NULL AFTER `type`;
ALTER TABLE cp_podcasts ADD COLUMN published_at DATETIME DEFAULT NULL AFTER
updated_by;
UPDATE cp_podcasts SET published_at = created_at;
COMMIT;