mirror of
https://github.com/jorgev259/soc_site-astro.git
synced 2025-06-29 07:57:41 +00:00
19 lines
1,016 B
SQL
19 lines
1,016 B
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to drop the column `placeholder` on the `albums` table. All the data in the column will be lost.
|
|
- Made the column `status` on table `albums` required. This step will fail if there are existing NULL values in that column.
|
|
- Made the column `headerColor` on table `albums` required. This step will fail if there are existing NULL values in that column.
|
|
|
|
*/
|
|
DELETE FROM `albums` WHERE `status` = "Published";
|
|
UPDATE `albums` SET `status` = "Show" WHERE LOWER(`status`) = "show";
|
|
UPDATE `albums` SET `status` = "Hidden" WHERE LOWER(`status`) = "hidden";
|
|
|
|
-- AlterTable
|
|
ALTER TABLE `albums` DROP COLUMN `placeholder`,
|
|
ADD COLUMN `publishedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
MODIFY `createdAt` DATETIME(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
|
|
MODIFY `updatedAt` DATETIME(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
|
|
MODIFY `status` ENUM('Show', 'Hidden') NOT NULL DEFAULT 'Hidden',
|
|
MODIFY `headerColor` VARCHAR(255) NOT NULL DEFAULT '#ffffff';
|