CREATE TABLE "launcher_apps" (
  "id" TEXT NOT NULL,
  "app_key" TEXT NOT NULL,
  "display_name" TEXT NOT NULL,
  "description" TEXT NOT NULL,
  "subtitle" TEXT,
  "detail_url" TEXT,
  "video_path" TEXT,
  "icon_key" TEXT NOT NULL,
  "launch_url" TEXT,
  "dev_app_path" TEXT,
  "exec_path" TEXT,
  "sort_order" INTEGER NOT NULL DEFAULT 0,
  "is_enabled" BOOLEAN NOT NULL DEFAULT true,
  "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" TIMESTAMP(3) NOT NULL,

  CONSTRAINT "launcher_apps_pkey" PRIMARY KEY ("id")
);

CREATE UNIQUE INDEX "launcher_apps_app_key_key" ON "launcher_apps"("app_key");
CREATE INDEX "launcher_apps_is_enabled_sort_order_idx" ON "launcher_apps"("is_enabled", "sort_order");