BLOG-97 Remove obsolete migration script for post and label tables (#131 )

### Description > [!WARNING] > Removing `v0.1.0` version of migration from `_sqlx_migrations` table before deploying is require. ### Package Changes _No response_ ### Screenshots _No response_ ### Reference Resolves #97 ### Checklist - [x] A milestone is set - [x] The related issuse has been linked to this branch Reviewed-on: #131 Co-authored-by: SquidSpirit <squid@squidspirit.com> Co-committed-by: SquidSpirit <squid@squidspirit.com>
NO-ISSUE Merged from release/0.3 (#130 )
2025-08-12 22:40:12 +08:00 · 2025-08-12 22:15:25 +08:00
1 changed files with 0 additions and 51 deletions
--- a/backend/migrations/20250505012740_v0.1.1.sql
+++ b/backend/migrations/20250505012740_v0.1.1.sql
@ -1,51 +0,0 @@
 -- Add migration script here
 CREATE TABLE "post" (
    "id" SERIAL PRIMARY KEY NOT NULL,
    "title" TEXT NOT NULL,
    "description" TEXT NOT NULL,
    "preview_image_url" TEXT NOT NULL,
    "content" TEXT NOT NULL,
    "published_time" TIMESTAMP,
    "deleted_time" TIMESTAMP,
    "created_time" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_time" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 CREATE TABLE "label" (
    "id" SERIAL PRIMARY KEY NOT NULL,
    "name" TEXT NOT NULL,
    "color" BIGINT NOT NULL CHECK ("color" >= 0 AND "color" <= 4294967295),
    "deleted_time" TIMESTAMP,
    "created_time" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_time" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 CREATE TABLE "post_label" (
    "post_id" INTEGER NOT NULL,
    "label_id" INTEGER NOT NULL,
    PRIMARY KEY ("post_id", "label_id"),
    FOREIGN KEY ("post_id") REFERENCES "post" ("id") ON DELETE CASCADE,
    FOREIGN KEY ("label_id") REFERENCES "label" ("id") ON DELETE CASCADE
 );
 -- Auto update `updated_time` trigger
 CREATE FUNCTION update_updated_time_column() RETURNS TRIGGER AS $$
 BEGIN
    NEW.updated_time = CURRENT_TIMESTAMP;
    return NEW;
 END;
 $$ LANGUAGE 'plpgsql';
 CREATE TRIGGER "update_post_updated_time"
 BEFORE UPDATE ON "post"
 FOR EACH ROW
 EXECUTE FUNCTION update_updated_time_column();
 CREATE TRIGGER "update_label_updated_time"
 BEFORE UPDATE ON "label"
 FOR EACH ROW
 EXECUTE FUNCTION update_updated_time_column();