Add ubuntu cloud-init script

.env.example

@@ -1,2 +0,0 @@
-CLOUDFLARE_API_TOKEN=
-NEON_API_KEY=

.github/PULL_REQUEST_TEMPLATE.md

@@ -1,2 +1,28 @@
 ## Description
 <!-- Briefly describe the purpose and scope of your changes -->
+
+## Related Issues
+<!-- List any related issues (e.g., "Closes #123", "Fixes #456") -->
+
+## Type of Change
+
+- [ ] Bug fix (non-breaking change)
+- [ ] New feature (non-breaking change)
+- [ ] Breaking change (fix or feature that changes existing functionality)
+- [ ] Documentation update
+- [ ] Other (please describe):
+
+## Checklist
+
+- [ ] I have updated relevant documentation
+- [ ] My code follows the project's coding style
+- [ ] My changes generate no new warnings/errors
+
+## Notes for Reviewers
+<!-- Point out areas you'd like reviewers to focus on, questions you have, or decisions that need discussion -->
+
+## Screenshots/Demo
+<!-- If applicable, add screenshots or a GIF demo of your changes (especially for UI changes) -->
+
+## Additional Context
+<!-- Add any other context about the pull request here -->

.github/workflows/docs.yml

@@ -1,40 +0,0 @@
-name: Build docs
-
-on:
-  pull_request:
-    paths:
-      - "apps/docs/**"
-      - ".github/workflows/docs.yml"
-  push:
-    branches: [main]
-    paths:
-      - "apps/docs/**"
-      - ".github/workflows/docs.yml"
-
-jobs:
-  deploy-docs:
-    name: Build and deploy docs
-    runs-on: ubuntu-latest
-    defaults:
-      run:
-        working-directory: "apps/docs"
-    steps:
-      - uses: actions/checkout@v4
-      - uses: oven-sh/setup-bun@v1
-        with:
-          bun-version: latest
-      - name: Install dependencies
-        run: bun install
-      - name: Build Project Artifacts
-        run: bun run build
-      - name: Deploy Project Artifacts to Cloudflare
-        uses: cloudflare/wrangler-action@v3
-        with:
-          packageManager: bun
-          apiToken: ${{ secrets.CLOUDFLARE_API_TOKEN }}
-          accountId: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
-          wranglerVersion: "3.93.0"
-          workingDirectory: "apps/docs"
-          command: pages deploy ./dist --project-name=${{ vars.CF_DOCS_PAGES_PROJECT_NAME }} --commit-dirty=true
-        env:
-          CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}

.github/workflows/runner.yml

@@ -7,7 +7,6 @@ on:
         paths:
             - "containers/runner.Containerfile"
             - "packages/scripts/**"
-            - "packages/server/**"
             - ".github/workflows/runner.yml"
     schedule:
         - cron: 7 0 * * 1,3,6 # Regularly to keep that build cache warm
@@ -17,7 +16,6 @@ on:
             - "containers/runner.Containerfile"
             - ".github/workflows/runner.yml"
             - "packages/scripts/**"
-            - "packages/server/**"
         tags:
             - v*.*.*
     release:
@@ -27,7 +25,6 @@ env:
     REGISTRY: ghcr.io
     IMAGE_NAME: nestrilabs/nestri
     BASE_TAG_PREFIX: runner
-    BASE_IMAGE: docker.io/cachyos/cachyos:latest
 
 # This makes our release ci quit prematurely
 # concurrency:
@@ -56,7 +53,7 @@ jobs:
                 swap-size-gb: 20
             - 
               name: Build Docker image
-              uses: docker/build-push-action@v6
+              uses: docker/build-push-action@v5
               with:
                 file: containers/runner.Containerfile
                 context: ./
@@ -108,7 +105,7 @@ jobs:
                 swap-size-gb: 20
             - 
               name: Build Docker image
-              uses: docker/build-push-action@v6
+              uses: docker/build-push-action@v5
               with:
                 file:  containers/runner.Containerfile
                 context: ./
@@ -117,4 +114,3 @@ jobs:
                 labels: ${{ steps.meta.outputs.labels }}
                 cache-from: type=gha,mode=max
                 cache-to: type=gha,mode=max
-                pull: ${{ github.event_name == 'schedule' }} # Pull base image for scheduled builds

.github/workflows/www.yml

@@ -1,40 +0,0 @@
-name: Build www
-
-on:
-  pull_request:
-    paths:
-      - "apps/www/**"
-      - ".github/workflows/www.yml"
-  push:
-    branches: [main]
-    paths:
-      - "apps/www/**"
-      - ".github/workflows/www.yml"
-
-jobs:
-  deploy-www:
-    name: Build and deploy www
-    runs-on: ubuntu-latest
-    defaults:
-      run:
-        working-directory: "apps/www"
-    steps:
-      - uses: actions/checkout@v4
-      - uses: oven-sh/setup-bun@v1
-        with:
-          bun-version: latest
-      - name: Install dependencies
-        run: bun install
-      - name: Build Project Artifacts
-        run: bun run build
-      - name: Deploy Project Artifacts to Cloudflare
-        uses: cloudflare/wrangler-action@v3
-        with:
-          packageManager: bun
-          apiToken: ${{ secrets.CLOUDFLARE_API_TOKEN }}
-          accountId: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
-          wranglerVersion: "3.93.0"
-          workingDirectory: "apps/www"
-          command: pages deploy ./dist --project-name=${{ vars.CF_WWW_PAGES_PROJECT_NAME }} --commit-dirty=true
-        env:
-          CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}

.gitignore

@@ -8,7 +8,6 @@ node_modules
 # Local env files
 .env
 .env.local
-.env.sst
 .env.development.local
 .env.test.local
 .env.production.local

.vscode/extensions.json

@@ -0,0 +1,4 @@
+{
+  "recommendations": ["dbaeumer.vscode-eslint", "unifiedjs.vscode-mdx"],
+  "unwantedRecommendations": []
+}

.vscode/launch.json

@@ -0,0 +1,24 @@
+{
+  // Use IntelliSense to learn about possible attributes.
+  // Hover to view descriptions of existing attributes.
+  // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
+  "version": "0.2.0",
+  "configurations": [
+    {
+      "name": "Launch Chrome",
+      "request": "launch",
+      "type": "chrome",
+      "url": "http://localhost:5173",
+      "webRoot": "${workspaceFolder}"
+    },
+    {
+      "type": "node",
+      "name": "dev.debug",
+      "request": "launch",
+      "skipFiles": ["<node_internals>/**"],
+      "cwd": "${workspaceFolder}",
+      "program": "${workspaceFolder}/node_modules/vite/bin/vite.js",
+      "args": ["--mode", "ssr", "--force"]
+    }
+  ]
+}

.vscode/qwik-city.code-snippets

@@ -0,0 +1,36 @@
+{
+  "onRequest": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "qonRequest",
+    "description": "onRequest function for a route index",
+    "body": [
+      "export const onRequest: RequestHandler = (request) => {",
+      "  $0",
+      "};",
+    ],
+  },
+  "loader$": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "qloader$",
+    "description": "loader$()",
+    "body": ["export const $1 = routeLoader$(() => {", "  $0", "});"],
+  },
+  "action$": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "qaction$",
+    "description": "action$()",
+    "body": ["export const $1 = routeAction$((data) => {", "  $0", "});"],
+  },
+  "Full Page": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "qpage",
+    "description": "Simple page component",
+    "body": [
+      "import { component$ } from '@builder.io/qwik';",
+      "",
+      "export default component$(() => {",
+      "  $0",
+      "});",
+    ],
+  },
+}

.vscode/qwik.code-snippets

@@ -0,0 +1,78 @@
+{
+  "Qwik component (simple)": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "qcomponent$",
+    "description": "Simple Qwik component",
+    "body": [
+      "export const ${1:${TM_FILENAME_BASE/(.*)/${1:/pascalcase}/}} = component$(() => {",
+      "  return <${2:div}>$4</$2>",
+      "});",
+    ],
+  },
+  "Qwik component (props)": {
+    "scope": "typescriptreact",
+    "prefix": "qcomponent$ + props",
+    "description": "Qwik component w/ props",
+    "body": [
+      "export interface ${1:${TM_FILENAME_BASE/(.*)/${1:/pascalcase}/}}Props {",
+      "  $2",
+      "}",
+      "",
+      "export const $1 = component$<$1Props>((props) => {",
+      "  const ${2:count} = useSignal(0);",
+      "  return (",
+      "    <${3:div} on${4:Click}$={(ev) => {$5}}>",
+      "      $6",
+      "    </${3}>",
+      "  );",
+      "});",
+    ],
+  },
+  "Qwik signal": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "quseSignal",
+    "description": "useSignal() declaration",
+    "body": ["const ${1:foo} = useSignal($2);", "$0"],
+  },
+  "Qwik store": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "quseStore",
+    "description": "useStore() declaration",
+    "body": ["const ${1:state} = useStore({", "  $2", "});", "$0"],
+  },
+  "$ hook": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "q$",
+    "description": "$() function hook",
+    "body": ["$(() => {", "  $0", "});", ""],
+  },
+  "useVisibleTask": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "quseVisibleTask",
+    "description": "useVisibleTask$() function hook",
+    "body": ["useVisibleTask$(({ track }) => {", "  $0", "});", ""],
+  },
+  "useTask": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "quseTask$",
+    "description": "useTask$() function hook",
+    "body": [
+      "useTask$(({ track }) => {",
+      "  track(() => $1);",
+      "  $0",
+      "});",
+      "",
+    ],
+  },
+  "useResource": {
+    "scope": "javascriptreact,typescriptreact",
+    "prefix": "quseResource$",
+    "description": "useResource$() declaration",
+    "body": [
+      "const $1 = useResource$(({ track, cleanup }) => {",
+      "  $0",
+      "});",
+      "",
+    ],
+  },
+}

.vscode/settings.json

@@ -1,3 +1,11 @@
 {
-    "typescript.tsdk": "node_modules/typescript/lib"
-}
+  "material-icon-theme.activeIconPack": "qwik",
+  "emmet.includeLanguages": {
+    "typescriptreact": "html"
+  },
+  "emmet.preferences": {
+    // to ensure closing tags are used (e.g. <img/> not just <img> like in HTML)
+    // https://github.com/microsoft/vscode/commit/083bf9020407ea5a91199eb1f0b373859df8d600#diff-88456bc9b7caa2f8126aea0107b4671db0f094961aaf39a7c689f890e23aaaba
+    "output.selfClosingStyle": "xhtml"
+  }
+}

apps/docs/content/4.nestri-internal/1.what-is-this.md

@@ -1,3 +0,0 @@
-# What is this?
-
-This is the part of the docs dedicated for the team working on Nestri

apps/docs/content/4.nestri-internal/2.setup.md

@@ -1,27 +0,0 @@
-# Setup
-
-- Install bun [https://bun.sh/](https://bun.sh/)
-- Generate your Cloudflare token from [here](https://dash.cloudflare.com/profile/api-tokens?permissionGroupKeys=%5B%7B%22key%22%3A%22account_settings%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22dns%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22memberships%22%2C%22type%22%3A%22read%22%7D%2C%7B%22key%22%3A%22user_details%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22workers_kv_storage%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22workers_r2%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22workers_routes%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22workers_scripts%22%2C%22type%22%3A%22edit%22%7D%2C%7B%22key%22%3A%22workers_tail%22%2C%22type%22%3A%22read%22%7D%5D&name=sst&accountId=*&zoneId=all)
-- save it to a `.env` file like this
-```
-CLOUDFLARE_API_TOKEN=xxx
-```
-- Copy this to your `~/.aws/config` file
-```
-[sso-session nestri]
-sso_start_url = https://nestri.awsapps.com/start
-sso_region = us-east-1
-
-[profile nestri-dev]
-sso_session = nestri
-sso_account_id = 535002871375
-sso_role_name = AdministratorAccess
-region = us-east-1
-
-[profile nestri-production]
-sso_session = nestri
-sso_account_id = 209479283398
-sso_role_name = AdministratorAccess
-region = us-east-1
-```
-- You need to login once a day with `bun sso` in root

apps/docs/content/4.nestri-internal/_dir.yml

@@ -1,2 +0,0 @@
-title: 'Nestri Internals'
-icon: heroicons-outline:bookmark-alt

apps/docs/package.json

@@ -4,19 +4,19 @@
   "private": true,
   "scripts": {
     "nestri.dev": "nuxi dev",
-    "build": "nuxi build --preset=cloudflare_pages",
+    "build": "nuxi build",
     "generate": "nuxi generate",
     "preview": "nuxi preview",
     "lint": "eslint ."
   },
   "devDependencies": {
     "@nuxt-themes/docus": "latest",
-    "@nuxt/devtools": "^2.3.2",
+    "@nuxt/devtools": "^1.4.1",
     "@nuxt/eslint-config": "^0.5.6",
     "@nuxt/ui": "^2.19.2",
     "@nuxtjs/plausible": "^1.0.2",
     "@types/node": "^20.16.5",
     "eslint": "^9.10.0",
-    "nuxt": "^3.16.1"
+    "nuxt": "^3.15.4"
   }
 }

apps/www/package.json

@@ -35,16 +35,14 @@
     "@builder.io/qwik": "^1.8.0",
     "@builder.io/qwik-city": "^1.8.0",
     "@builder.io/qwik-react": "0.5.0",
-    "@fontsource-variable/bricolage-grotesque": "^5.0.1",
-    "@fontsource/geist-mono": "^5.1.0",
-    "@fontsource/geist-sans": "^5.1.0",
+    "@fontsource-variable/bricolage-grotesque": "^5.1.1",
     "@fontsource-variable/mona-sans": "^5.0.1",
     "@modular-forms/qwik": "^0.29.0",
     "@nestri/input": "*",
     "@nestri/libmoq": "*",
     "@nestri/sdk": "0.1.0-alpha.14",
     "@nestri/ui": "*",
-    "@openauthjs/openauth": "*",
+    "@openauthjs/openauth": "^0.2.6",
     "@polar-sh/checkout": "^0.1.8",
     "@polar-sh/sdk": "^0.21.1",
     "@qwik-ui/headless": "^0.6.4",
@@ -63,11 +61,10 @@
     "prettier": "3.3.3",
     "react": "18.2.0",
     "react-dom": "18.2.0",
-    "semver": "^7.7.1",
     "typescript": "5.4.5",
     "undici": "*",
     "valibot": "^0.42.1",
-    "vite": "6.0.15",
+    "vite": "5.4.12",
     "vite-tsconfig-paths": "^4.2.1",
     "wrangler": "^3.0.0"
   },

apps/www/src/routes/(public)/index.tsx

@@ -16,8 +16,8 @@ export default component$(() => {
     <div class="w-screen relative">
       <HeroSection client:load>
         <div class="sm:w-full flex gap-3 justify-center pt-4 sm:flex-row flex-col w-auto items-center">
-          <Link href="https://discord.gg/6um5K6jrYj" prefetch={false} class="flex ring-2 ring-primary-500 font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
-            Join our Discord
+          <Link href="/auth/login" prefetch={false} class="flex ring-2 ring-primary-500 font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
+            Get early access
           </Link>
           <Link href="/links/github" prefetch={false} class="sm:flex text-sm sm:text-base hidden font-bricolage items-center gap-2 rounded-full font-semibold text-gray-900/70 dark:text-gray-100/70 bg-white dark:bg-black px-5 py-4 ring-2 ring-gray-300 dark:ring-gray-700 transition-all hover:scale-105 active:scale-95 sm:px-6" >
             <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 20 20" fill="currentColor" aria-hidden="true" class="h-5 w-5 fill-content3-light"><path fill-rule="evenodd" d="M4.25 5.5a.75.75 0 00-.75.75v8.5c0 .414.336.75.75.75h8.5a.75.75 0 00.75-.75v-4a.75.75 0 011.5 0v4A2.25 2.25 0 0112.75 17h-8.5A2.25 2.25 0 012 14.75v-8.5A2.25 2.25 0 014.25 4h5a.75.75 0 010 1.5h-5z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M6.194 12.753a.75.75 0 001.06.053L16.5 4.44v2.81a.75.75 0 001.5 0v-4.5a.75.75 0 00-.75-.75h-4.5a.75.75 0 000 1.5h2.553l-9.056 8.194a.75.75 0 00-.053 1.06z" clip-rule="evenodd"></path></svg>
@@ -570,8 +570,8 @@ export default component$(() => {
       </section>
       <Footer client:load>
         <div class="w-full flex justify-center flex-col items-center gap-3">
-          <Link href="https://discord.gg/6um5K6jrYj" prefetch={false} class="ring-2 ring-primary-500 flex font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
-            Join our Discord
+          <Link href="/auth/login" prefetch={false} class="ring-2 ring-primary-500 flex font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
+            Get early access
           </Link>
           <div class="mt-6 flex w-full items-center justify-center gap-2 text-xs sm:text-sm font-medium text-neutral-600 dark:text-neutral-400">
             <span class="hover:text-primary-500 transition-colors duration-200">

apps/www/src/routes/(public)/pricing/index.tsx

@@ -521,8 +521,8 @@ export default component$(() => {
             </MotionComponent>
             <Footer client:load>
                 <div class="w-full flex justify-center flex-col items-center gap-3">
-                    <Link href="https://discord.gg/6um5K6jrYj" prefetch={false} class="flex font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
-                        Join our Discord
+                    <Link href="/auth/login" prefetch={false} class="flex font-bricolage text-sm sm:text-base rounded-full bg-primary-500 px-5 py-4 font-semibold text-white transition-all hover:scale-105 active:scale-95 sm:px-6" >
+                        Get early access
                     </Link>
                     <div class="mt-6 flex w-full items-center justify-center gap-2 text-xs sm:text-sm font-medium text-neutral-600 dark:text-neutral-400">
                         <span class="hover:text-primary-500 transition-colors duration-200">

cloud/ubuntu-cloud-init.yaml

@@ -0,0 +1,84 @@
+#cloud-config
+# Cloud-init script to install NVIDIA 570 drivers on Ubuntu
+# Tested with TensorDock Ubuntu 22.04 instances
+
+# Install required packages
+packages:
+  - build-essential
+  - linux-headers-generic
+  - dkms
+
+# Our scripts
+write_files:
+  - path: /root/prevent_driver_update.sh
+    encoding: b64
+    permissions: '0755'
+    content: ZHBrZy1xdWVyeSAtVyAtLXNob3dmb3JtYXQ9JyR7UGFja2FnZX0gJHtTdGF0dXN9XG4nIHwgZ3JlcCAtdiBkZWluc3RhbGwgfCBhd2sgJ3sgcHJpbnQgJDEgfScgfCBncmVwIC1FICdudmlkaWEuKi1bMC05XSskJyB8IHhhcmdzIC1yIC1MIDEgc3VkbyBhcHQtbWFyayBob2xk
+  # Blacklist nouveau just in case
+  - path: /etc/modprobe.d/blacklist-nouveau.conf
+    content: |
+      blacklist nouveau
+  # Enable modesetting for NVIDIA drivers
+  - path: /etc/modprobe.d/nvidia.conf
+    content: |
+      options nvidia-drm modeset=1
+  # Main setup script
+  - path: /root/setup_nvidia.sh
+    permissions: '0755'
+    content: |
+      #!/bin/bash
+      echo "Starting Nestri NVIDIA driver setup..."
+
+      echo "Purging old NVIDIA packages..."
+      apt remove --purge -y '*nvidia*'
+      apt autoremove -y
+
+      echo "Unloading conflicting kernel modules..."
+      modprobe -r nouveau 2>/dev/null || true
+      modprobe -r nvidia_drm 2>/dev/null || true
+      modprobe -r nvidia_modeset 2>/dev/null || true
+      modprobe -r nvidia 2>/dev/null || true
+
+      # Update initramfs to apply blacklist
+      update-initramfs -u
+
+      echo "Installing NVIDIA 570 driver..."
+      wget https://us.download.nvidia.com/XFree86/Linux-x86_64/570.86.16/NVIDIA-Linux-x86_64-570.86.16.run -O /root/NVIDIA-Linux-x86_64-570.86.16.run
+      chmod +x /root/NVIDIA-Linux-x86_64-570.86.16.run
+      # Install without building kernel module immediately, then build with DKMS
+      /root/NVIDIA-Linux-x86_64-570.86.16.run --silent --dkms
+      # Clean up
+      rm /root/NVIDIA-Linux-x86_64-570.86.16.run
+
+      # Prevent auto-update from nuking driver
+      echo "Making the new driver held version..."
+      bash /root/prevent_driver_update.sh
+
+      echo "Loading new NVIDIA modules..."
+      modprobe nvidia
+      modprobe nvidia_modeset
+      modprobe nvidia_drm
+
+      # Re-install container toolkit
+      echo "Re-installing NVIDIA container toolkit..."
+      apt install -y nvidia-container-toolkit
+
+      echo "Configuring NVIDIA container toolkit..."
+      nvidia-ctk runtime configure --runtime=docker
+      # Restart Docker only if necessary
+      if ! nvidia-smi > /dev/null 2>&1; then
+        echo "Restarting Docker to apply GPU changes..."
+        systemctl restart docker
+      fi
+
+      echo "Setting up permissions..."
+      chmod 777 /dev/dri/* 2>/dev/null || true
+
+      cd /home/user/ && mkdir -p nestri && chown user:user nestri
+      docker run --security-opt="seccomp=unconfined" --security-opt="apparmor=unconfined" --name=nestri -d --shm-size=6g --runtime=nvidia --gpus=all -e RELAY_URL='https://relay.dathorse.com' -e NESTRI_ROOM=cloudinit123 -e RESOLUTION=1920x1080 -e FRAMERATE=60 -e GST_DEBUG=3 -e NESTRI_PARAMS='--verbose=true --video-codec=h264 --video-bitrate=6000 --video-bitrate-max=8000' -v /home/user/nestri:/home/nestri ghcr.io/datcaptainhorse/nestri-cachyos:latest-v3
+
+      echo "Nestri NVIDIA driver setup complete!"
+
+# Run setup script on first launch
+runcmd:
+  - /root/setup_nvidia.sh

containers/maitred.Containerfile

@@ -1,12 +0,0 @@
-FROM docker.io/golang:1.24-bookworm AS go-build
-WORKDIR /builder
-COPY packages/maitred/ /builder/
-RUN go build
-
-FROM docker.io/golang:1.24-bookworm
-COPY --from=go-build /builder/maitred /maitred/maitred
-WORKDIR /maitred
-
-RUN apt update && apt install -y --no-install-recommends pciutils
-
-ENTRYPOINT ["/maitred/maitred"]

containers/relay.Containerfile

@@ -1,31 +1,20 @@
-FROM docker.io/golang:1.24-alpine AS go-build
+FROM docker.io/golang:1.23-alpine AS go-build
 WORKDIR /builder
 COPY packages/relay/ /builder/
 RUN go build
 
-FROM docker.io/golang:1.24-alpine
+FROM docker.io/golang:1.23-alpine
 COPY --from=go-build /builder/relay /relay/relay
 WORKDIR /relay
 
-# TODO: Switch running layer to just alpine (doesn't need golang dev stack)
-
 # ENV flags
 ENV VERBOSE=false
-ENV DEBUG=false
 ENV ENDPOINT_PORT=8088
-ENV MESH_PORT=8089
 ENV WEBRTC_UDP_START=10000
 ENV WEBRTC_UDP_END=20000
 ENV STUN_SERVER="stun.l.google.com:19302"
-ENV WEBRTC_UDP_MUX=8088
-ENV WEBRTC_NAT_IPS=""
-ENV AUTO_ADD_LOCAL_IP=true
-ENV TLS_CERT=""
-ENV TLS_KEY=""
 
 EXPOSE $ENDPOINT_PORT
-EXPOSE $MESH_PORT
 EXPOSE $WEBRTC_UDP_START-$WEBRTC_UDP_END/udp
-EXPOSE $WEBRTC_UDP_MUX/udp
 
 ENTRYPOINT ["/relay/relay"]

containers/runner.Containerfile

@@ -1,18 +1,10 @@
 # Container build arguments #
 ARG BASE_IMAGE=docker.io/cachyos/cachyos:latest
 
-#******************************************************************************
-# Base Stage - Updates system packages
-#******************************************************************************
-FROM ${BASE_IMAGE} AS base
-
-RUN --mount=type=cache,target=/var/cache/pacman/pkg \
-    pacman --noconfirm -Syu
-
 #******************************************************************************
 # Base Builder Stage - Prepares core build environment
 #******************************************************************************
-FROM base AS base-builder
+FROM ${BASE_IMAGE} AS base-builder
 
 # Environment setup for Rust and Cargo
 ENV CARGO_HOME=/usr/local/cargo \
@@ -22,12 +14,9 @@ ENV CARGO_HOME=/usr/local/cargo \
 
 # Install build essentials and caching tools
 RUN --mount=type=cache,target=/var/cache/pacman/pkg \
-    pacman -Sy --noconfirm mold rustup && \
+    pacman -Sy --noconfirm mold rust && \
     mkdir -p "${ARTIFACTS}"
 
-# Install latest Rust using rustup
-RUN rustup default stable
-
 # Install cargo-chef with proper caching
 RUN --mount=type=cache,target=${CARGO_HOME}/registry \
     cargo install -j $(nproc) cargo-chef cargo-c --locked
@@ -39,8 +28,7 @@ FROM base-builder AS nestri-server-deps
 WORKDIR /builder
 
 # Install build dependencies
-RUN --mount=type=cache,target=/var/cache/pacman/pkg \
-    pacman -Sy --noconfirm meson pkgconf cmake git gcc make \
+RUN pacman -Sy --noconfirm meson pkgconf cmake git gcc make \
     gstreamer gst-plugins-base gst-plugins-good gst-plugin-rswebrtc
 
 #--------------------------------------------------------------------
@@ -85,8 +73,8 @@ RUN --mount=type=cache,target=/var/cache/pacman/pkg \
     pacman -Sy --noconfirm meson pkgconf cmake git gcc make \
     libxkbcommon wayland gstreamer gst-plugins-base gst-plugins-good libinput
 
-# Clone repository
-RUN git clone -b dev-dmabuf https://github.com/DatCaptainHorse/gst-wayland-display.git
+# Clone repository with proper directory structure
+RUN git clone -b dev-dmabuf https://github.com/games-on-whales/gst-wayland-display.git
 
 #--------------------------------------------------------------------
 FROM gst-wayland-deps AS gst-wayland-planner
@@ -119,7 +107,7 @@ RUN --mount=type=cache,target=${CARGO_HOME}/registry \
 #******************************************************************************
 # Final Runtime Stage
 #******************************************************************************
-FROM base AS runtime
+FROM ${BASE_IMAGE} AS runtime
 
 ### System Configuration ###
 RUN sed -i \
@@ -129,33 +117,27 @@ RUN sed -i \
     dirmngr </dev/null > /dev/null 2>&1
 
 ### Package Installation ###
-# Core system components
-RUN --mount=type=cache,target=/var/cache/pacman/pkg \
-    pacman -Sy --needed --noconfirm \
-        vulkan-intel lib32-vulkan-intel vpl-gpu-rt \
-        vulkan-radeon lib32-vulkan-radeon \
-        mesa \
-        steam steam-native-runtime gtk3 lib32-gtk3 \
-        sudo xorg-xwayland seatd libinput gamescope mangohud \
-        libssh2 curl wget \
+RUN pacman --noconfirm -Sy && \
+    # Core system components
+    pacman -S --needed --noconfirm \
+        archlinux-keyring vulkan-intel lib32-vulkan-intel mesa \
+        steam steam-native-runtime \
+        sudo xorg-xwayland labwc wlr-randr mangohud \
         pipewire pipewire-pulse pipewire-alsa wireplumber \
         noto-fonts-cjk supervisor jq chwd lshw pacman-contrib && \
     # GStreamer stack
-    pacman -Sy --needed --noconfirm \
+    pacman -S --needed --noconfirm \
         gstreamer gst-plugins-base gst-plugins-good \
         gst-plugins-bad gst-plugin-pipewire \
-        gst-plugin-webrtchttp gst-plugin-rswebrtc gst-plugin-rsrtp \
-        gst-plugin-va gst-plugin-qsv && \
-    # lib32 GStreamer stack to fix some games with videos
-    pacman -Sy --needed --noconfirm \
-        lib32-gstreamer lib32-gst-plugins-base lib32-gst-plugins-good && \
+        gst-plugin-rswebrtc gst-plugin-rsrtp && \
     # Cleanup
     paccache -rk1 && \
     rm -rf /usr/share/{info,man,doc}/*
 
 ### Application Installation ###
 ARG LUDUSAVI_VERSION="0.28.0"
-RUN curl -fsSL -o ludusavi.tar.gz \
+RUN pacman -Sy --noconfirm --needed curl && \
+    curl -fsSL -o ludusavi.tar.gz \
         "https://github.com/mtkennerly/ludusavi/releases/download/v${LUDUSAVI_VERSION}/ludusavi-v${LUDUSAVI_VERSION}-linux.tar.gz" && \
     tar -xzvf ludusavi.tar.gz && \
     mv ludusavi /usr/bin/ && \
@@ -168,7 +150,8 @@ ENV USER="nestri" \
     USER_PWD="nestri1234" \
     XDG_RUNTIME_DIR=/run/user/1000 \
     HOME=/home/nestri \
-    NVIDIA_DRIVER_CAPABILITIES=all
+    NVIDIA_DRIVER_CAPABILITIES=all \
+    NVIDIA_VISIBLE_DEVICES=all
 
 RUN mkdir -p /home/${USER} && \
     groupadd -g ${GID} ${USER} && \
@@ -189,30 +172,6 @@ RUN mkdir -p /run/dbus && \
         -e '/wants = \[/{s/hooks\.node\.suspend\s*//; s/,\s*\]/]/}' \
         /usr/share/wireplumber/wireplumber.conf
 
-### PipeWire Latency Optimizations (1-5ms instead of 20ms) ###
-RUN mkdir -p /etc/pipewire/pipewire.conf.d && \
-    echo "[audio]\
-    \n  default.clock.rate = 48000\
-    \n  default.clock.quantum = 128\
-    \n  default.clock.min-quantum = 128\
-    \n  default.clock.max-quantum = 256" > /etc/pipewire/pipewire.conf.d/low-latency.conf && \
-    mkdir -p /etc/wireplumber/main.lua.d && \
-    echo 'table.insert(default_nodes.rules, {\
-    \n  matches = { { { "node.name", "matches", ".*" } } },\
-    \n  apply_properties = {\
-    \n    ["audio.format"] = "S16LE",\
-    \n    ["audio.rate"] = 48000,\
-    \n    ["audio.channels"] = 2,\
-    \n    ["api.alsa.period-size"] = 128,\
-    \n    ["api.alsa.headroom"] = 0,\
-    \n    ["session.suspend-timeout-seconds"] = 0\
-    \n  }\
-    \n})' > /etc/wireplumber/main.lua.d/50-low-latency.lua && \
-    echo "default-fragments = 2\
-    \ndefault-fragment-size-msec = 2" >> /etc/pulse/daemon.conf && \
-    echo "load-module module-loopback latency_msec=1" >> /etc/pipewire/pipewire.conf.d/loopback.conf
-
-
 ### Artifacts and Verification ###
 COPY --from=nestri-server-cached-builder /artifacts/nestri-server /usr/bin/
 COPY --from=gst-wayland-cached-builder /artifacts/lib/ /usr/lib/

docker-compose.yml

@@ -0,0 +1 @@
+#FIXME: A simple docker-compose file for running the MoQ relay and the cachyos server

infra/api.ts

@@ -1,94 +1,54 @@
-import { bus } from "./bus";
-import { auth } from "./auth";
+import { authFingerprintKey } from "./auth";
 import { domain } from "./dns";
-import { secret } from "./secret";
-import { cluster } from "./cluster";
-import { postgres } from "./postgres";
+import { secret } from "./secrets"
+// import { party } from "./party"
+import { gpuTaskDefinition, ecsCluster } from "./cluster";
 
-export const apiService = new sst.aws.Service("Api", {
-    cluster,
-    cpu: $app.stage === "production" ? "2 vCPU" : undefined,
-    memory: $app.stage === "production" ? "4 GB" : undefined,
-    link: [
-        bus,
-        auth,
-        postgres,
-        secret.SteamApiKey,
-        secret.PolarSecret,
-        secret.PolarWebhookSecret,
-        secret.NestriFamilyMonthly,
-        secret.NestriFamilyYearly,
-        secret.NestriFreeMonthly,
-        secret.NestriProMonthly,
-        secret.NestriProYearly,
-    ],
-    command: ["bun", "run", "./src/api/index.ts"],
-    image: {
-        dockerfile: "packages/functions/Containerfile",
+export const urls = new sst.Linkable("Urls", {
+    properties: {
+        api: "https://api." + domain,
+        auth: "https://auth." + domain,
     },
-    loadBalancer: {
-        rules: [
-            {
-                listen: "80/http",
-                forward: "3001/http",
-            },
-        ],
-    },
-    dev: {
-        url: "http://localhost:3001",
-        command: "bun dev:api",
-        directory: "packages/functions",
-    },
-    scaling:
-        $app.stage === "production"
-            ? {
-                min: 2,
-                max: 10,
-            }
-            : undefined,
-    // For persisting actor state
-    transform: {
-        taskDefinition: (args) => {
-            const volumes = $output(args.volumes).apply(v => {
-                const next = [...(v || []), {
-                    name: "shared-tmp",
-                    dockerVolumeConfiguration: {
-                        scope: "shared",
-                        driver: "local"
-                    }
-                }];
-
-                return next;
-            })
-
-            // "containerDefinitions" is a JSON string, parse first
-            let containers = $jsonParse(args.containerDefinitions);
-
-            containers = containers.apply((containerDefinitions) => {
-                containerDefinitions[0].mountPoints = [
-                    ...(containerDefinitions[0].mountPoints ?? []),
-                    {
-                        sourceVolume: "shared-tmp",
-                        containerPath: "/tmp"
-                    },
-                ]
-                return containerDefinitions;
-            });
-
-            args.volumes = volumes
-            args.containerDefinitions = $jsonStringify(containers);
-        }
-    }
 });
 
+export const kv = new sst.cloudflare.Kv("CloudflareAuthKV")
 
-export const api = !$dev ? new sst.aws.Router("ApiRoute", {
-    routes: {
-        // I think api.url should work all the same
-        "/*": apiService.nodes.loadBalancer.dnsName,
-    },
-    domain: {
-        name: "api." + domain,
-        dns: sst.cloudflare.dns(),
-    },
-}) : apiService
+export const auth = new sst.cloudflare.Worker("Auth", {
+    link: [
+        kv,
+        urls,
+        authFingerprintKey,
+        secret.InstantAdminToken,
+        secret.InstantAppId,
+        secret.LoopsApiKey,
+        secret.GithubClientID,
+        secret.GithubClientSecret,
+        secret.DiscordClientID,
+        secret.DiscordClientSecret,
+    ],
+    handler: "./packages/functions/src/auth.ts",
+    url: true,
+    domain: "auth." + domain
+});
+
+export const api = new sst.cloudflare.Worker("Api", {
+    link: [
+        urls,
+        ecsCluster,
+        gpuTaskDefinition,
+        authFingerprintKey,
+        secret.LoopsApiKey,
+        secret.InstantAppId,
+        secret.AwsAccessKey,
+        secret.AwsSecretKey,
+        secret.InstantAdminToken,
+    ],
+    url: true,
+    handler: "./packages/functions/src/api/index.ts",
+    domain: "api." + domain
+})
+
+export const outputs = {
+    auth: auth.url,
+    api: api.url
+}

infra/auth.ts

@@ -1,98 +1,12 @@
-import { bus } from "./bus";
-import { domain } from "./dns";
-import { secret } from "./secret";
-import { cluster } from "./cluster";
-import { postgres } from "./postgres";
-
-export const authService = new sst.aws.Service("Auth", {
-    cluster,
-    cpu: $app.stage === "production" ? "1 vCPU" : undefined,
-    memory: $app.stage === "production" ? "2 GB" : undefined,
-    command: ["bun", "run", "./src/auth/index.ts"],
-    link: [
-        bus,
-        postgres,
-        secret.PolarSecret,
-        secret.GithubClientID,
-        secret.DiscordClientID,
-        secret.GithubClientSecret,
-        secret.DiscordClientSecret,
-    ],
-    image: {
-        dockerfile: "packages/functions/Containerfile",
+export const authFingerprintKey = new random.RandomString(
+    "AuthFingerprintKey",
+    {
+        length: 32,
     },
-    environment: {
-        NO_COLOR: "1",
-        STORAGE: "/tmp/persist.json"
-    },
-    loadBalancer: {
-        rules: [
-            {
-                listen: "80/http",
-                forward: "3002/http",
-            },
-        ],
-    },
-    permissions: [
-        {
-            actions: ["ses:SendEmail"],
-            resources: ["*"],
-        },
-    ],
-    dev: {
-        command: "bun dev:auth",
-        directory: "packages/functions",
-        url: "http://localhost:3002",
-    },
-    scaling:
-        $app.stage === "production"
-            ? {
-                min: 2,
-                max: 10,
-            }
-            : undefined,
-    //For temporarily persisting the persist.json
-    transform: {
-        taskDefinition: (args) => {
-            const volumes = $output(args.volumes).apply(v => {
-                const next = [...(v || []), {
-                    name: "shared-tmp",
-                    dockerVolumeConfiguration: {
-                        scope: "shared",
-                        driver: "local"
-                    }
-                }];
+);
 
-                return next;
-            })
-
-            // "containerDefinitions" is a JSON string, parse first
-            let containers = $jsonParse(args.containerDefinitions);
-
-            containers = containers.apply((containerDefinitions) => {
-                containerDefinitions[0].mountPoints = [
-                    ...(containerDefinitions[0].mountPoints ?? []),
-                    {
-                        sourceVolume: "shared-tmp",
-                        containerPath: "/tmp"
-                    }
-                ]
-                return containerDefinitions;
-            });
-
-            args.volumes = volumes
-            args.containerDefinitions = $jsonStringify(containers);
-        }
-    }
-});
-
-export const auth = !$dev ? new sst.aws.Router("AuthRoute", {
-    routes: {
-        // I think auth.url should work all the same
-        "/*": authService.nodes.loadBalancer.dnsName,
+sst.Linkable.wrap(random.RandomString, (resource) => ({
+    properties: {
+        value: resource.result,
     },
-    domain: {
-        name: "auth." + domain,
-        dns: sst.cloudflare.dns(),
-    },
-}) : authService
+}));

infra/bus.ts

@@ -1,70 +0,0 @@
-import { vpc } from "./vpc";
-import { secret } from "./secret";
-import { storage } from "./storage";
-import { postgres } from "./postgres";
-
-export const dlq = new sst.aws.Queue("Dlq");
-
-export const retryQueue = new sst.aws.Queue("RetryQueue");
-
-export const bus = new sst.aws.Bus("Bus");
-
-export const eventSub = bus.subscribe("Event", {
-  vpc,
-  handler: "packages/functions/src/events/index.handler",
-  link: [
-    // email,
-    bus,
-    storage,
-    postgres,
-    retryQueue,
-    secret.PolarSecret,
-    secret.SteamApiKey
-  ],
-  environment: {
-    RETRIES: "2",
-  },
-  memory: "3002 MB",// For faster processing of large(r) images
-  timeout: "10 minutes",
-});
-
-new aws.lambda.FunctionEventInvokeConfig("EventConfig", {
-  functionName: $resolve([eventSub.nodes.function.name]).apply(
-    ([name]) => name,
-  ),
-  maximumRetryAttempts: 1,
-  destinationConfig: {
-    onFailure: {
-      destination: retryQueue.arn,
-    },
-  },
-});
-
-retryQueue.subscribe({
-  vpc,
-  handler: "packages/functions/src/queues/retry.handler",
-  timeout: "30 seconds",
-  environment: {
-    RETRIER_QUEUE_URL: retryQueue.url,
-  },
-  link: [
-    dlq,
-    retryQueue,
-    eventSub.nodes.function,
-  ],
-  permissions: [
-    {
-      actions: ["lambda:GetFunction", "lambda:InvokeFunction"],
-      resources: [
-        $interpolate`arn:aws:lambda:${aws.getRegionOutput().name}:${aws.getCallerIdentityOutput().accountId}:function:*`,
-      ],
-    },
-  ],
-  transform: {
-    function: {
-      deadLetterConfig: {
-        targetArn: dlq.arn,
-      },
-    },
-  },
-});

infra/cluster.ts

@@ -1,6 +1,155 @@
-import { vpc } from "./vpc";
+import { sshKey } from "./ssh";
+import { authFingerprintKey } from "./auth";
 
-export const cluster = new sst.aws.Cluster("Cluster", {
-  vpc,
-  forceUpgrade: "v2"
-});
+export const ecsCluster = new aws.ecs.Cluster("NestriGPUCluster", {
+    name: "NestriGPUCluster",
+});
+
+const ecsInstanceRole = new aws.iam.Role("NestriGPUInstanceRole", {
+    name: "GPUAssumeRoleProd",
+    assumeRolePolicy: JSON.stringify({
+        Version: "2012-10-17",
+        Statement: [{
+            Action: "sts:AssumeRole",
+            Principal: {
+                Service: "ec2.amazonaws.com",
+            },
+            Effect: "Allow",
+            Sid: "",
+        }],
+    }),
+});
+
+new aws.iam.RolePolicyAttachment("NestriGPUInstancePolicyAttachment", {
+    role: ecsInstanceRole.name,
+    policyArn: "arn:aws:iam::aws:policy/service-role/AmazonEC2ContainerServiceforEC2Role",
+});
+
+const ecsInstanceProfile = new aws.iam.InstanceProfile("NestriGPUInstanceProfile", {
+    role: ecsInstanceRole.name,
+});
+
+// const server = new aws.ec2.Instance("NestriGPU", {
+//     instanceType: aws.ec2.InstanceType.G4dn_XLarge,
+//     ami: "ami-046a6af96ef510bb6",//Fedora cloud
+//     keyName: sshKey.keyName,
+//     instanceMarketOptions: {
+//         marketType: "spot",
+//         spotOptions: {
+//             maxPrice: "0.2",
+//             spotInstanceType: "persistent",
+//             instanceInterruptionBehavior: "stop"
+//         },
+//     },
+//     iamInstanceProfile: ecsInstanceProfile,
+// });
+
+const logGroup = new aws.cloudwatch.LogGroup("NestriGPULogGroup", {
+    name: "/ecs/nestri-gpu-prod",
+    retentionInDays: 7,
+});
+
+// Create a Task Definition for the ECS service to test it
+export const gpuTaskDefinition = new aws.ecs.TaskDefinition("NestriGPUTask", {
+    family: "NestriGPUTaskProd",
+    requiresCompatibilities: ["EC2"],
+    volumes: [
+        {
+            name: "host",
+            hostPath: "/mnt/"
+            // efsVolumeConfiguration: {
+            //     fileSystemId: storage.id,
+            //     authorizationConfig: { accessPointId: storage.accessPoint },
+            //     transitEncryption: "ENABLED",
+            // }
+        }
+    ],
+    containerDefinitions: authFingerprintKey.result.apply(v => JSON.stringify([{
+        "essential": true,
+        "name": "nestri",
+        "memory": 1024,
+        "cpu": 200,
+        "gpu": 1,
+        "image": "ghcr.io/nestrilabs/nestri/runner:nightly",
+        "environment": [
+            {
+                "name": "RESOLUTION",
+                "value": "1920x1080"
+            },
+            {
+                "name": "AUTH_FINGERPRINT",
+                "value": v
+            },
+            {
+                "name": "FRAMERATE",
+                "value": "60"
+            },
+            {
+                "name": "NESTRI_ROOM",
+                "value": "aws-testing"
+            },
+            {
+                "name": "RELAY_URL",
+                "value": "https://relay.dathorse.com"
+            },
+            {
+                "name": "NESTRI_PARAMS",
+                "value": "--verbose=true --video-codec=h264 --video-bitrate=4000 --video-bitrate-max=6000 --gpu-card-path=/dev/dri/card0"
+            },
+        ],
+        "mountPoints": [{ "containerPath": "/home/nestri", "sourceVolume": "host" }],
+        "disableNetworking": false,
+        "linuxParameter": {
+            "sharedMemorySize": 5120
+        },
+        "logConfiguration": {
+            "logDriver": "awslogs",
+            "options": {
+                "awslogs-group": "/ecs/nestri-gpu-prod",
+                "awslogs-region": "us-east-1",
+                "awslogs-stream-prefix": "nestri-gpu-task"
+            }
+        }
+    }]))
+});
+
+sst.Linkable.wrap(aws.ecs.TaskDefinition, (resource) => ({
+    properties: {
+        value: resource.arn,
+    },
+}));
+
+sst.Linkable.wrap(aws.ecs.Cluster, (resource) => ({
+    properties: {
+        value: resource.arn,
+    },
+}));
+
+//     userData: $interpolate`#!/bin/bash
+// sudo rm /etc/sysconfig/docker
+// echo DAEMON_MAXFILES=1048576 | sudo tee -a /etc/sysconfig/docker
+// echo DAEMON_PIDFILE_TIMEOUT=10 | sud o tee -a /etc/sysconfig/docker
+// echo OPTIONS="--default-ulimit nofile=32768:65536" | sudo tee -a /etc/sysconfig/docker
+// sudo tee "/etc/docker/daemon.json" > /dev/null <<EOF
+// {
+//     "default-runtime": "nvidia",
+//     "runtimes": {
+//         "nvidia": {
+//             "path": "/usr/bin/nvidia-container-runtime",
+//             "runtimeArgs": []
+//         }
+//     }
+// }
+// EOF
+// sudo systemctl restart docker
+// echo ECS_CLUSTER='${ecsCluster.name}' | sudo tee -a /etc/ecs/ecs.config
+// echo ECS_ENABLE_GPU_SUPPORT=true | sudo tee -a /etc/ecs/ecs.config
+// echo ECS_CONTAINER_STOP_TIMEOUT=3h | sudo tee -a /etc/ecs/ecs.config
+// echo ECS_ENABLE_SPOT_INSTANCE_DRAINING=true | sudo tee -a /etc/ecs/ecs.config
+// `,
+    
+// This is used for requesting a container to be deployed on AWS
+// const queue = new sst.aws.Queue("PartyQueue", { fifo: true });
+
+// queue.subscribe({ handler: "packages/functions/src/party/subscriber.handler", permissions:{}, link:[taskF]})
+// const authRes = $interpolate`${authFingerprintKey.result}`

infra/email.ts

@@ -1,6 +0,0 @@
-import { domain } from "./dns";
-
-export const email = new sst.aws.Email("Email",{
-    sender: domain,
-    dns: sst.cloudflare.dns(),
-})

infra/images.ts

@@ -1,57 +0,0 @@
-import { domain } from "./dns";
-import { storage } from "./storage";
-
-sst.Linkable.wrap(aws.iam.AccessKey, (resource) => ({
-    properties: {
-        key: resource.id,
-        secret: resource.secret,
-    },
-}))
-
-const cache = new sst.cloudflare.Kv("ImageCache");
-
-const bucket = new sst.cloudflare.Bucket("ImageBucket");
-
-const lambdaInvokerUser = new aws.iam.User("ImageIAMUser", {
-    name: `${$app.name}-${$app.stage}-ImageIAMUser`,
-    forceDestroy: true
-});
-
-const imageProcessorFunction = new sst.aws.Function("ImageProcessor",
-    {
-        memory: "1024 MB",
-        link: [storage],
-        timeout: "30 seconds",
-        nodejs: { install: ["sharp"] },
-        handler: "packages/functions/src/images/processor.handler",
-    },
-);
-
-new aws.iam.UserPolicy("InvokeLambdaPolicy", {
-    user: lambdaInvokerUser.name,
-    policy: $output({
-        Version: "2012-10-17",
-        Statement: [
-            {
-                Effect: "Allow",
-                Action: ["lambda:InvokeFunction"],
-                Resource: imageProcessorFunction.arn,
-            },
-        ],
-    }).apply(JSON.stringify),
-});
-
-const accessKey = new aws.iam.AccessKey("ImageInvokerAccessKey", {
-    user: lambdaInvokerUser.name,
-});
-
-export const imageCdn = new sst.cloudflare.Worker("ImageCDN", {
-    url: true,
-    domain: "cdn." + domain,
-    link: [bucket, cache, imageProcessorFunction, accessKey],
-    handler: "packages/functions/src/images/index.ts",
-});
-
-export const outputs = {
-    cdn: imageCdn.url
-}

infra/party.ts

@@ -0,0 +1,33 @@
+// This is for the websocket/MQTT endpoint that helps the API communicate with the container
+// [API] <-> party <-websocket-> container
+// The container is it's own this, and can listen to Websocket connections to start or stop a Steam Game
+
+// import { authFingerprintKey } from "./auth";
+// import { ecsCluster, gpuTaskDefinition } from "./cluster";
+
+// export const party = new sst.aws.Realtime("Party", {
+//     authorizer: "packages/functions/src/party/authorizer.handler"
+// });
+
+// export const partyFn = new sst.aws.Function("NestriPartyFn", {
+//     handler: "packages/functions/src/party/create.handler",
+//     // link: [queue],
+//     link: [authFingerprintKey],
+//     environment: {
+//         TASK_DEFINITION: gpuTaskDefinition.arn,
+//         // AUTH_FINGERPRINT: authFingerprintKey.result,
+//         ECS_CLUSTER: ecsCluster.arn,
+//     },
+//     permissions: [
+//         {
+//             effect: "allow",
+//             actions: ["ecs:RunTask"],
+//             resources: [gpuTaskDefinition.arn]
+//         }
+//     ],
+//     url: true,
+// });
+
+// export const outputs = {
+//     partyFunction: partyFn.url
+// }

infra/postgres.ts

@@ -1,64 +0,0 @@
-import { vpc } from "./vpc";
-
-export const postgres = new sst.aws.Aurora("Database", {
-  vpc,
-  engine: "postgres",
-  scaling: {
-    min: "0 ACU",
-    max: "1 ACU",
-  },
-  transform: {
-    clusterParameterGroup: {
-      parameters: [
-        {
-          name: "rds.logical_replication",
-          value: "1",
-          applyMethod: "pending-reboot",
-        },
-        {
-          name: "max_slot_wal_keep_size",
-          value: "10240",
-          applyMethod: "pending-reboot",
-        },
-        {
-          name: "rds.force_ssl",
-          value: "0",
-          applyMethod: "pending-reboot",
-        },
-        {
-          name: "max_connections",
-          value: "1000",
-          applyMethod: "pending-reboot",
-        },
-      ],
-    },
-  },
-});
-
-
-new sst.x.DevCommand("Studio", {
-  link: [postgres],
-  dev: {
-    command: "bun db:dev studio",
-    directory: "packages/core",
-    autostart: true,
-  },
-});
-
-// const migrator = new sst.aws.Function("DatabaseMigrator", {
-//   handler: "packages/functions/src/migrator.handler",
-//   link: [postgres],
-//   copyFiles: [
-//     {
-//       from: "packages/core/migrations",
-//       to: "./migrations",
-//     },
-//   ],
-// });
-
-// if (!$dev) {
-//   new aws.lambda.Invocation("DatabaseMigratorInvocation", {
-//     input: Date.now().toString(),
-//     functionName: migrator.name,
-//   });
-// }

infra/realtime.ts

@@ -1,9 +0,0 @@
-import { auth } from "./auth";
-import { postgres } from "./postgres";
-
-export const device = new sst.aws.Realtime("Realtime", {
-    authorizer: {
-        link: [auth, postgres],
-        handler: "packages/functions/src/realtime/authorizer.handler"
-    }
-})

infra/relay.ts

@@ -0,0 +1,179 @@
+// const vpc = new sst.aws.Vpc("NestriRelayVpc", { az: 2 })    
+// import { subnet1, subnet2, securityGroup } from "./vpc"
+
+// const taskExecutionRole = new aws.iam.Role('NestriRelayExecutionRole', {
+//     assumeRolePolicy: JSON.stringify({
+//         Version: '2012-10-17',
+//         Statement: [
+//             {
+//                 Effect: 'Allow',
+//                 Principal: {
+//                     Service: 'ecs-tasks.amazonaws.com',
+//                 },
+//                 Action: 'sts:AssumeRole',
+//             },
+//         ],
+//     }),
+// });
+
+// const taskRole = new aws.iam.Role('NestriRelayTaskRole', {
+//     assumeRolePolicy: JSON.stringify({
+//         Version: '2012-10-17',
+//         Statement: [
+//             {
+//                 Effect: 'Allow',
+//                 Principal: {
+//                     Service: 'ecs-tasks.amazonaws.com',
+//                 },
+//                 Action: 'sts:AssumeRole',
+//             },
+//         ],
+//     }),
+// });
+
+// new aws.cloudwatch.LogGroup('NestriRelayLogGroup', {
+//     name: '/ecs/nestri-relay',
+//     retentionInDays: 7,
+// });
+
+// new aws.iam.RolePolicyAttachment('NestriRelayExecutionRoleAttachment', {
+//     policyArn: 'arn:aws:iam::aws:policy/service-role/AmazonECSTaskExecutionRolePolicy',
+//     role: taskRole,
+// });
+
+// const logPolicy = new aws.iam.Policy('NestriRelayLogPolicy', {
+//     policy: JSON.stringify({
+//         Version: '2012-10-17',
+//         Statement: [
+//             {
+//                 Effect: 'Allow',
+//                 Action: ['logs:CreateLogStream', 'logs:PutLogEvents'],
+//                 Resource: 'arn:aws:logs:*:*:*',
+//             },
+//         ],
+//     }),
+// });
+
+// new aws.iam.RolePolicyAttachment('NestriRelayTaskRoleAttachment', {
+//     policyArn: logPolicy.arn,
+//     role: taskExecutionRole,
+// });
+
+// const taskDefinition = new aws.ecs.TaskDefinition("NestriRelayTask", {
+//     family: "NestriRelay",
+//     cpu: "1024",
+//     memory: "2048",
+//     networkMode: "awsvpc",
+//     taskRoleArn: taskRole.arn,
+//     requiresCompatibilities: ["FARGATE"],
+//     executionRoleArn: taskExecutionRole.arn,
+//     containerDefinitions: JSON.stringify([{
+//         name: "nestri-relay",
+//         essential: true,
+//         memory: 2048,
+//         image: "ghcr.io/nestrilabs/nestri/relay:nightly",
+//         portMappings: [
+//             // HTTP port
+//             {
+//                 protocol: "tcp",
+//                 hostPort: 80,
+//                 containerPort: 80,
+//             },
+//             // UDP port range (1,000 ports)
+//             {
+//                 containerPortRange: "10000-11000",
+//                 protocol: "udp",
+//             },
+//         ],
+//         "environment": [
+//             {
+//                 name: "ENDPOINT_PORT",
+//                 value: "80"
+//             },
+//         ],
+//         logConfiguration: {
+//             logDriver: 'awslogs',
+//             options: {
+//                 'awslogs-group': '/ecs/nestri-relay',
+//                 'awslogs-region': 'us-east-1',
+//                 'awslogs-stream-prefix': 'ecs',
+//             },
+//         },
+//     }]),
+// });
+
+// const relayCluster = new aws.ecs.Cluster('NestriRelay');
+
+// new aws.ecs.Service('NestriRelayService', {
+//     name: 'NestriRelayService',
+//     cluster: relayCluster.arn,
+//     desiredCount: 1,
+//     launchType: 'FARGATE',
+//     taskDefinition: taskDefinition.arn,
+//     deploymentCircuitBreaker: {
+//         enable: true,
+//         rollback: true,
+//     },
+//     enableExecuteCommand: true,
+//     networkConfiguration: {
+//         assignPublicIp: true,
+//         subnets: [subnet1.id, subnet2.id],
+//         securityGroups: [securityGroup.id],
+//     },
+// });
+
+//FIXME: I cannot create Global Accelerators (Something to do with Quotas -  Yet my account is fine)
+// const usWest2 = new aws.Provider("GlobalAccelerator", { region: aws.Region.USWest2 })
+
+// const accelerator = new aws.globalaccelerator.Accelerator('Accelerator', {
+//     name: 'NestriRelayAccelerator',
+//     enabled: true,
+//     ipAddressType: 'IPV4',
+// }, { provider: usWest2 });
+
+// const httpListener = new aws.globalaccelerator.Listener('TcpListener', {
+//     acceleratorArn: accelerator.id,
+//     clientAffinity: 'SOURCE_IP',
+//     protocol: 'TCP',
+//     portRanges: [{
+//         fromPort: 80,
+//         toPort: 80,
+//     }],
+// }, { provider: usWest2 });
+
+// const udpListener = new aws.globalaccelerator.Listener('UdpListener', {
+//     acceleratorArn: accelerator.id,
+//     clientAffinity: 'SOURCE_IP',
+//     protocol: 'UDP',
+//     portRanges: [{
+//         fromPort: 10000,
+//         toPort: 11000,
+//     }],
+// }, { provider: usWest2 });
+
+// new aws.globalaccelerator.EndpointGroup('TcpRelay', {
+//     listenerArn: httpListener.id,
+//     // healthCheckPath: '/',
+//     endpointGroupRegion: aws.Region.USEast1,
+//     endpointConfigurations: [{
+//         clientIpPreservationEnabled: true,
+//         endpointId: subnet1.id, //vpc.publicSubnets[0].apply(i => i),
+//         weight: 100,
+//     }],
+// }, { provider: usWest2 });
+
+// new aws.globalaccelerator.EndpointGroup('UdpRelay', {
+//     listenerArn: udpListener.id,
+//     // healthCheckPort: 80,
+//     // healthCheckPath: "/",
+//     endpointGroupRegion: aws.Region.USEast1,
+//     endpointConfigurations: [{
+//         clientIpPreservationEnabled: true,
+//         endpointId: subnet1.id,//vpc.publicSubnets[0].apply(i => i),
+//         weight: 100,
+//     }],
+// }, { provider: usWest2 });
+
+// export const outputs = {
+//     relay: accelerator.dnsName
+// }

infra/secret.ts

@@ -1,18 +0,0 @@
-export const secret = {
-    PolarSecret: new sst.Secret("PolarSecret", process.env.POLAR_API_KEY),
-    SteamApiKey: new sst.Secret("SteamApiKey"),
-    GithubClientID: new sst.Secret("GithubClientID"),
-    DiscordClientID: new sst.Secret("DiscordClientID"),
-    PolarWebhookSecret: new sst.Secret("PolarWebhookSecret"),
-    GithubClientSecret: new sst.Secret("GithubClientSecret"),
-    DiscordClientSecret: new sst.Secret("DiscordClientSecret"),
-    
-    // Pricing
-    NestriFreeMonthly: new sst.Secret("NestriFreeMonthly"),
-    NestriProMonthly: new sst.Secret("NestriProMonthly"),
-    NestriProYearly: new sst.Secret("NestriProYearly"),
-    NestriFamilyMonthly: new sst.Secret("NestriFamilyMonthly"),
-    NestriFamilyYearly: new sst.Secret("NestriFamilyYearly"),
-};
-
-export const allSecrets = Object.values(secret);

infra/secrets.ts

@@ -0,0 +1,13 @@
+export const secret = {
+  LoopsApiKey: new sst.Secret("LoopsApiKey"),
+  InstantAppId: new sst.Secret("InstantAppId"),
+  AwsSecretKey: new sst.Secret("AwsSecretKey"),
+  AwsAccessKey: new sst.Secret("AwsAccessKey"),
+  GithubClientID: new sst.Secret("GithubClientID"),
+  DiscordClientID: new sst.Secret("DiscordClientID"),
+  GithubClientSecret: new sst.Secret("GithubClientSecret"),
+  InstantAdminToken: new sst.Secret("InstantAdminToken"),
+  DiscordClientSecret: new sst.Secret("DiscordClientSecret"),
+  };
+  
+  export const allSecrets = Object.values(secret);

infra/ssh.ts

@@ -0,0 +1,19 @@
+import { resolve } from "path";
+import { writeFileSync } from "fs";
+
+export const privateKey = new tls.PrivateKey("NestriGPUPrivateKey", {
+    algorithm: "RSA",
+    rsaBits: 4096,
+});
+
+// Just in case you want to SSH
+export const sshKey = new aws.ec2.KeyPair("NestriGPUKey", {
+    keyName: "NestriGPUKeyProd",
+    publicKey: privateKey.publicKeyOpenssh
+})
+
+export const keyPath = privateKey.privateKeyOpenssh.apply((key) => {
+    const path = "key_ssh";
+    writeFileSync(path, key, { mode: 0o600 });
+    return resolve(path);
+});

infra/storage.ts

@@ -1 +1,4 @@
-export const storage = new sst.aws.Bucket("Storage");
+// export const vpc = new sst.aws.Vpc("Vpc")
+
+// export const storage = new sst.aws.Efs("GameStorage",{ vpc })
+// // 

infra/vpc.ts

@@ -1,11 +1,103 @@
-import { isPermanentStage } from "./stage";
+// export const vpc = new aws.ec2.Vpc('NestriVpc', {
+//     cidrBlock: '172.16.0.0/16',
+// });
 
-export const vpc = isPermanentStage
-  ? new sst.aws.Vpc("VPC", {
-    az: 2,
-    // For lambdas to work in this VPC
-    nat: "ec2",
-    // For SST tunnel to work
-    bastion: true,
-  })
-  : sst.aws.Vpc.get("VPC", "vpc-0beb1cdc21a725748");
+// export const subnet1 = new aws.ec2.Subnet('NestriSubnet1', {
+//     vpcId: vpc.id,
+//     cidrBlock: '172.16.1.0/24',
+//     // cidrBlock: '110.0.12.0/22',
+//     availabilityZone: 'us-east-1a',
+// });
+
+// export const subnet2 = new aws.ec2.Subnet('NestriSubnet2', {
+//     vpcId: vpc.id,
+//     cidrBlock: '172.16.2.0/24',
+//     // cidrBlock: '10.0.20.0/22',
+//     availabilityZone: 'us-east-1b',
+// });
+
+// const internetGateway = new aws.ec2.InternetGateway('NestriInternetGateway', {
+//     vpcId: vpc.id,
+// });
+
+// const routeTable = new aws.ec2.RouteTable('NestriRouteTable', {
+//     vpcId: vpc.id,
+//     routes: [
+//         {
+//             cidrBlock: '0.0.0.0/0',
+//             gatewayId: internetGateway.id,
+//         },
+//     ],
+// });
+
+// new aws.ec2.RouteTableAssociation('NestriSubnet1RouteTable', {
+//     subnetId: subnet1.id,
+//     routeTableId: routeTable.id,
+// });
+
+// new aws.ec2.RouteTableAssociation('NestriSubnet2RouteTable', {
+//     subnetId: subnet2.id,
+//     routeTableId: routeTable.id,
+// });
+
+// // const vpc = new sst.aws.Vpc("NestriRelayVpc")
+
+// export const securityGroup = new aws.ec2.SecurityGroup("NestriSecurityGroup", {
+//     vpcId: vpc.id,
+//     description: "Managed thru SST",
+//     ingress: [
+//         {
+//             protocol: "tcp",
+//             fromPort: 80,
+//             toPort: 80,
+//             cidrBlocks: ["0.0.0.0/0"],
+//         },
+//         {
+//             protocol: "udp",
+//             fromPort: 10000,
+//             toPort: 20000,
+//             cidrBlocks: ["0.0.0.0/0"],
+//         },
+//     ],
+//     egress: [
+//         {
+//             protocol: "-1",
+//             cidrBlocks: ["0.0.0.0/0"],
+//             fromPort: 0,
+//             toPort: 0
+//         }
+//     ]
+// });
+
+// const loadBalancer = new aws.lb.LoadBalancer('NestriVpcLoadBalancer', {
+//     name: 'NestriVpcLoadBalancer',
+//     internal: false,
+//     securityGroups: [securityGroup.id],
+//     subnets: vpc.publicSubnets
+// });
+
+// const targetGroup = new aws.lb.TargetGroup('NestriVpcTargetGroup', {
+//     name: 'NestriVpcTargetGroup',
+//     port: 80,
+//     protocol: 'HTTP',
+//     targetType: 'ip',
+//     vpcId: vpc.id,
+//     healthCheck: {
+//         path: '/',
+//         protocol: 'HTTP',
+//     },
+// });
+
+// new aws.lb.Listener('NestriVpcLoadBalancerListener', {
+//     loadBalancerArn: loadBalancer.arn,
+//     port: 80,
+//     protocol: 'HTTP',
+//     defaultActions: [
+//         {
+//             type: 'forward',
+//             targetGroupArn: targetGroup.arn,
+//         },
+//     ],
+// });
+
+// // export const subnets = [subnet1, subnet2]

infra/www.ts

@@ -1,23 +0,0 @@
-// This is the website part where people play and connect
-import { api } from "./api";
-import { auth } from "./auth";
-import { zero } from "./zero";
-import { domain } from "./dns";
-
-new sst.aws.StaticSite("Web", {
-    path: "packages/www",
-    build: {
-        output: "./dist",
-        command: "bun run build",
-    },
-    domain: {
-        dns: sst.cloudflare.dns(),
-        name: "console." + domain
-    },
-    environment: {
-        VITE_API_URL: api.url,
-        VITE_STAGE: $app.stage,
-        VITE_AUTH_URL: auth.url,
-        VITE_ZERO_URL: zero.url,
-    },
-})

infra/zero.ts

@@ -1,197 +0,0 @@
-import { vpc } from "./vpc";
-import { auth } from "./auth";
-import { domain } from "./dns";
-import { readFileSync } from "fs";
-import { cluster } from "./cluster";
-import { storage } from "./storage";
-import { postgres } from "./postgres";
-
-// const connectionString = $interpolate`postgresql://${postgres.username}:${postgres.password}@${postgres.host}/${postgres.database}`
-const connectionString = $interpolate`postgresql://${postgres.username}:${postgres.password}@${postgres.host}:${postgres.port}/${postgres.database}`;
-
-const tag = $dev
-    ? `latest`
-    : JSON.parse(
-        readFileSync("./node_modules/@rocicorp/zero/package.json").toString(),
-    ).version.replace("+", "-");
-
-const zeroEnv = {
-    FORCE: "1",
-    NO_COLOR: "1",
-    ZERO_LOG_LEVEL: "info",
-    ZERO_LITESTREAM_LOG_LEVEL: "info",
-    ZERO_UPSTREAM_DB: connectionString,
-    ZERO_IMAGE_URL: `rocicorp/zero:${tag}`,
-    ZERO_CVR_DB: connectionString,
-    ZERO_CHANGE_DB: connectionString,
-    ZERO_REPLICA_FILE: "/tmp/nestri.db",
-    ZERO_LITESTREAM_RESTORE_PARALLELISM: "64",
-    ZERO_APP_ID: $app.stage,
-    ZERO_AUTH_JWKS_URL: $interpolate`${auth.url}/.well-known/jwks.json`,
-    ZERO_INITIAL_SYNC_ROW_BATCH_SIZE: "30000",
-    NODE_OPTIONS: "--max-old-space-size=8192",
-    ...($dev
-        ? {
-        }
-        : {
-            ZERO_LITESTREAM_BACKUP_URL: $interpolate`s3://${storage.name}/zero/0`,
-        }),
-};
-
-// Replication Manager Service
-const replicationManager = !$dev
-    ? new sst.aws.Service(`ZeroReplication`, {
-        cluster,
-        wait: true,
-        ...($app.stage === "production"
-            ? {
-                cpu: "2 vCPU",
-                memory: "4 GB",
-            }
-            : {}),
-        architecture: "arm64",
-        image: zeroEnv.ZERO_IMAGE_URL,
-        link: [storage, postgres],
-        health: {
-            command: ["CMD-SHELL", "curl -f http://localhost:4849/ || exit 1"],
-            interval: "5 seconds",
-            retries: 3,
-            startPeriod: "300 seconds",
-        },
-        environment: {
-            ...zeroEnv,
-            ZERO_CHANGE_MAX_CONNS: "3",
-            ZERO_NUM_SYNC_WORKERS: "0",
-        },
-        logging: {
-            retention: "1 month",
-        },
-        loadBalancer: {
-            public: false,
-            ports: [
-                {
-                    listen: "80/http",
-                    forward: "4849/http",
-                },
-            ],
-        },
-        transform: {
-            loadBalancer: {
-                idleTimeout: 3600,
-            },
-            service: {
-                healthCheckGracePeriodSeconds: 900,
-            },
-        },
-    }) : undefined;
-
-// Permissions deployment
-// const permissions = new sst.aws.Function(
-//     "ZeroPermissions",
-//     {
-//         vpc,
-//         link: [postgres],
-//         handler: "packages/functions/src/zero.handler",
-//         // environment: { ["ZERO_UPSTREAM_DB"]: connectionString },
-//         copyFiles: [{
-//             from: "packages/zero/permissions.sql",
-//             to: "./.permissions.sql"
-//         }],
-//     }
-// );
-
-// if (replicationManager) {
-//     new aws.lambda.Invocation(
-//         "ZeroPermissionsInvocation",
-//         {
-//             input: Date.now().toString(),
-//             functionName: permissions.name,
-//         },
-//         { dependsOn: replicationManager }
-//     );
-//     // new command.local.Command(
-//     //     "ZeroPermission",
-//     //     {
-//     //         dir: process.cwd() + "/packages/zero",
-//     //         environment: {
-//     //             ZERO_UPSTREAM_DB: connectionString,
-//     //         },
-//     //         create: "bun run zero-deploy-permissions",
-//     //         triggers: [Date.now()],
-//     //     },
-//     //     {
-//     //         dependsOn: [replicationManager],
-//     //     },
-//     // );
-// }
-
-export const zero = new sst.aws.Service("Zero", {
-    cluster,
-    image: zeroEnv.ZERO_IMAGE_URL,
-    link: [storage, postgres],
-    architecture: "arm64",
-    ...($app.stage === "production"
-        ? {
-            cpu: "2 vCPU",
-            memory: "4 GB",
-            capacity: "spot"
-        }
-        : {
-            capacity: "spot"
-        }),
-    environment: {
-        ...zeroEnv,
-        ...($dev
-            ? {
-                ZERO_NUM_SYNC_WORKERS: "1",
-            }
-            : {
-                ZERO_CHANGE_STREAMER_URI: replicationManager?.url.apply((val) =>
-                    val.replace("http://", "ws://"),
-                ) ?? "",
-                ZERO_UPSTREAM_MAX_CONNS: "15",
-                ZERO_CVR_MAX_CONNS: "160",
-            }),
-    },
-    health: {
-        retries: 3,
-        command: ["CMD-SHELL", "curl -f http://localhost:4848/ || exit 1"],
-        interval: "5 seconds",
-        startPeriod: "300 seconds",
-    },
-    loadBalancer: {
-        domain: {
-            name: "zero." + domain,
-            dns: sst.cloudflare.dns()
-        },
-        rules: [
-            { listen: "443/https", forward: "4848/http" },
-            { listen: "80/http", forward: "4848/http" },
-        ],
-    },
-    scaling: {
-        min: 1,
-        max: 4,
-    },
-    logging: {
-        retention: "1 month",
-    },
-    transform: {
-        service: {
-            healthCheckGracePeriodSeconds: 900,
-        },
-        // taskDefinition: {
-        //     ephemeralStorage: {
-        //         sizeInGib: 200,
-        //     },
-        // },
-        loadBalancer: {
-            idleTimeout: 3600,
-        },
-    },
-    dev: {
-        command: "bun dev",
-        directory: "packages/zero",
-        url: "http://localhost:4848",
-    },
-});

package.json

@@ -1,43 +1,34 @@
 {
   "name": "nestri",
+  "private": true,
+  "scripts": {
+    "build": "turbo build",
+    "dev": "turbo dev",
+    "sst": "sst dev",
+    "format": "prettier --write \"**/*.{ts,tsx,md}\"",
+    "lint": "turbo lint"
+  },
   "devDependencies": {
     "@cloudflare/workers-types": "4.20240821.1",
     "@pulumi/pulumi": "^3.134.0",
-    "@tsconfig/node22": "^22.0.1",
-    "@types/aws-lambda": "8.10.147",
+    "@types/aws-lambda": "8.10.145",
     "prettier": "^3.2.5",
     "typescript": "^5.4.5"
   },
   "engines": {
     "node": ">=18"
   },
-  "packageManager": "bun@1.2.4",
-  "private": true,
-  "scripts": {
-    "format": "prettier --write \"**/*.{ts,tsx,md}\"",
-    "sso": "aws sso login --sso-session=nestri --no-browser --use-device-code"
-  },
-  "overrides": {
-    "@openauthjs/openauth": "0.4.3",
-    "steam-session": "1.9.3"
-  },
-  "patchedDependencies": {
-    "@macaron-css/solid@1.5.3": "patches/@macaron-css%2Fsolid@1.5.3.patch",
-    "drizzle-orm@0.36.1": "patches/drizzle-orm@0.36.1.patch",
-    "steam-session@1.9.3": "patches/steam-session@1.9.3.patch"
-  },
-  "trustedDependencies": [
-    "core-js-pure",
-    "esbuild",
-    "protobufjs",
-    "workerd"
-  ],
+  "packageManager": "bun@1.1.18",
   "workspaces": [
     "apps/*",
     "packages/*"
   ],
+  "trustedDependencies": [
+    "core-js-pure",
+    "esbuild",
+    "workerd"
+  ],
   "dependencies": {
-    "sharp": "^0.34.2",
-    "sst": "^3.11.21"
+    "sst": "3.6.27"
   }
 }

packages/core/drizzle.config.ts

@@ -1,19 +0,0 @@
-import { Resource } from "sst";
-import { defineConfig } from "drizzle-kit";
-
-const connection = {
-    user: Resource.Database.username,
-    password: Resource.Database.password,
-    host: Resource.Database.host,
-};
-
-export default defineConfig({
-    verbose: true,
-    strict: true,
-    out: "./migrations",
-    dialect: "postgresql",
-    dbCredentials: {
-        url: `postgres://${connection.user}:${connection.password}@${connection.host}/nestri`,
-    },
-    schema: "./src/**/*.sql.ts",
-});

packages/core/instant.perms.ts

@@ -0,0 +1,30 @@
+// Docs: https://www.instantdb.com/docs/permissions
+
+import type { InstantRules } from "@instantdb/core";
+
+const rules = {
+  /**
+   * Welcome to Instant's permission system!
+   * Right now your rules are empty. To start filling them in, check out the docs:
+   * https://www.instantdb.com/docs/permissions
+   *
+   * Here's an example to give you a feel:
+   * posts: {
+   *   allow: {
+   *     view: "true",
+   *     create: "isOwner",
+   *     update: "isOwner",
+   *     delete: "isOwner",
+   *   },
+   *   bind: ["isOwner", "auth.id != null && auth.id == data.ownerId"],
+   * },
+   */
+  // $default: {
+  //   allow: {
+  //     $default: "isOwner"
+  //   },
+  //   bind: ["isOwner", "auth.id != null && auth.id == data.ownerID"],
+  // }
+} satisfies InstantRules;
+
+export default rules;

packages/core/instant.schema.ts

@@ -0,0 +1,123 @@
+import { i } from "@instantdb/core";
+
+const _schema = i.schema({
+  entities: {
+    $users: i.entity({
+      email: i.string().unique().indexed(),
+    }),
+    // machines: i.entity({
+    //   hostname: i.string(),
+    //   fingerprint: i.string().unique().indexed(),
+    //   deletedAt: i.date().optional().indexed(),
+    //   createdAt: i.date()
+    // }),
+    tasks: i.entity({
+      type: i.string(),
+      lastStatus: i.string(),
+      healthStatus: i.string(),
+      startedAt: i.string(),
+      lastUpdated: i.date(),
+      stoppedAt: i.string().optional(),
+      taskID: i.string().unique().indexed()
+    }),
+    instances: i.entity({
+      hostname: i.string(),
+      lastActive: i.date().optional(),
+      createdAt: i.date()
+    }),
+    profiles: i.entity({
+      avatarUrl: i.string().optional(),
+      username: i.string().indexed(),
+      status: i.string().indexed(),
+      updatedAt: i.date().indexed(),
+      createdAt: i.date(),
+      discriminator: i.string().indexed()
+    }),
+    teams: i.entity({
+      name: i.string(),
+      slug: i.string().unique().indexed(),
+      deletedAt: i.date().optional(),//.indexed(),
+      updatedAt: i.date(),
+      createdAt: i.date(),
+    }),
+    // games: i.entity({
+    //   name: i.string(),
+    //   steamID: i.number().unique().indexed(),
+    // }),
+    sessions: i.entity({
+      startedAt: i.date(),
+      endedAt: i.date().optional().indexed(),
+      public: i.boolean().indexed(),
+    }),
+    subscriptions: i.entity({
+      checkoutID: i.string(),
+      canceledAt: i.date(),
+    })
+  },
+  links: {
+    UserSubscriptions: {
+      forward: { on: "subscriptions", has: "one", label: "owner" },
+      reverse: { on: "$users", has: "many", label: "subscriptions" }
+    },
+    UserProfiles: {
+      forward: { on: "profiles", has: "one", label: "owner" },
+      reverse: { on: "$users", has: "one", label: "profile" }
+    },
+    UserTasks: {
+      forward: { on: "tasks", has: "one", label: "owner" },
+      reverse: { on: "$users", has: "many", label: "tasks" }
+    },
+    TaskSessions: {
+      forward: { on: "tasks", has: "many", label: "sessions" },
+      reverse: { on: "sessions", has: "one", label: "task" }
+    },
+    UserSession: {
+      forward: { on: "sessions", has: "one", label: "owner" },
+      reverse: { on: "$users", has: "many", label: "sessions" }
+    },
+    TeamsOwned: {
+      forward: { on: "teams", has: "one", label: "owner" },
+      reverse: { on: "$users", has: "many", label: "teamsOwned" },
+    },
+    TeamsJoined: {
+      forward: { on: "teams", has: "many", label: "members" },
+      reverse: { on: "$users", has: "many", label: "teamsJoined" },
+    },
+    // UserMachines: {
+    //   forward: { on: "machines", has: "one", label: "owner" },
+    //   reverse: { on: "$users", has: "many", label: "machines" }
+    // },
+    // UserGames: {
+    //   forward: { on: "games", has: "many", label: "owners" },
+    //   reverse: { on: "$users", has: "many", label: "games" }
+    // },
+    // TeamInstances: {
+    //   forward: { on: "instances", has: "many", label: "owners" },
+    //   reverse: { on: "teams", has: "many", label: "instances" }
+    // },
+    // MachineSessions: {
+    //   forward: { on: "machines", has: "many", label: "sessions" },
+    //   reverse: { on: "sessions", has: "one", label: "machine" }
+    // },
+    // GamesMachines: {
+    //   forward: { on: "machines", has: "many", label: "games" },
+    //   reverse: { on: "games", has: "many", label: "machines" }
+    // },
+    // GameSessions: {
+    //   forward: { on: "games", has: "many", label: "sessions" },
+    //   reverse: { on: "sessions", has: "one", label: "game" }
+    // },
+    // UserSessions: {
+    //   forward: { on: "sessions", has: "one", label: "owner" },
+    //   reverse: { on: "$users", has: "many", label: "sessions" }
+    // }
+  }
+});
+
+// This helps Typescript display nicer intellisense
+type _AppSchema = typeof _schema;
+interface AppSchema extends _AppSchema { }
+const schema: AppSchema = _schema;
+
+export type { AppSchema };
+export default schema;

packages/core/migrations/0000_flaky_matthew_murdock.sql

@@ -1,39 +0,0 @@
-CREATE TABLE "member" (
-	"id" char(30) NOT NULL,
-	"team_id" char(30) NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"time_seen" timestamp with time zone,
-	"email" varchar(255) NOT NULL,
-	CONSTRAINT "member_team_id_id_pk" PRIMARY KEY("team_id","id")
-);
---> statement-breakpoint
-CREATE TABLE "team" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"name" varchar(255) NOT NULL,
-	"slug" varchar(255) NOT NULL,
-	"plan_type" text NOT NULL
-);
---> statement-breakpoint
-CREATE TABLE "user" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"avatar_url" text,
-	"name" varchar(255) NOT NULL,
-	"discriminator" integer NOT NULL,
-	"email" varchar(255) NOT NULL,
-	"polar_customer_id" varchar(255),
-	"flags" json DEFAULT '{}'::json,
-	CONSTRAINT "user_polar_customer_id_unique" UNIQUE("polar_customer_id")
-);
---> statement-breakpoint
-CREATE INDEX "email_global" ON "member" USING btree ("email");--> statement-breakpoint
-CREATE UNIQUE INDEX "member_email" ON "member" USING btree ("team_id","email");--> statement-breakpoint
-CREATE UNIQUE INDEX "team_slug" ON "team" USING btree ("slug");--> statement-breakpoint
-CREATE UNIQUE INDEX "user_email" ON "user" USING btree ("email");

packages/core/migrations/0001_nifty_sauron.sql

@@ -1,2 +0,0 @@
-DROP INDEX "team_slug";--> statement-breakpoint
-CREATE UNIQUE INDEX "slug" ON "team" USING btree ("slug");

packages/core/migrations/0002_simple_outlaw_kid.sql

@@ -1,17 +0,0 @@
-CREATE TABLE "steam" (
-	"id" char(30) NOT NULL,
-	"user_id" char(30) NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"avatar_url" text NOT NULL,
-	"access_token" text NOT NULL,
-	"email" varchar(255) NOT NULL,
-	"country" varchar(255) NOT NULL,
-	"username" varchar(255) NOT NULL,
-	"persona_name" varchar(255) NOT NULL,
-	CONSTRAINT "steam_user_id_id_pk" PRIMARY KEY("user_id","id")
-);
---> statement-breakpoint
-CREATE INDEX "global_steam_email" ON "steam" USING btree ("email");--> statement-breakpoint
-CREATE UNIQUE INDEX "steam_email" ON "steam" USING btree ("user_id","email");

packages/core/migrations/0002_tiny_toad_men.sql

@@ -1,13 +0,0 @@
-CREATE TABLE "machine" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"country" text NOT NULL,
-	"timezone" text NOT NULL,
-	"location" "point" NOT NULL,
-	"fingerprint" varchar(32) NOT NULL,
-	"country_code" varchar(2) NOT NULL
-);
---> statement-breakpoint
-CREATE UNIQUE INDEX "machine_fingerprint" ON "machine" USING btree ("fingerprint");

packages/core/migrations/0003_first_big_bertha.sql

@@ -1,22 +0,0 @@
-CREATE TABLE "machine" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"country" text NOT NULL,
-	"timezone" text NOT NULL,
-	"location" "point" NOT NULL,
-	"fingerprint" varchar(32) NOT NULL,
-	"country_code" varchar(2) NOT NULL
-);
---> statement-breakpoint
-ALTER TABLE "steam" RENAME COLUMN "country" TO "country_code";--> statement-breakpoint
-DROP INDEX "global_steam_email";--> statement-breakpoint
-ALTER TABLE "steam" ADD COLUMN "time_seen" timestamp with time zone;--> statement-breakpoint
-ALTER TABLE "steam" ADD COLUMN "steam_id" integer NOT NULL;--> statement-breakpoint
-ALTER TABLE "steam" ADD COLUMN "last_game" json NOT NULL;--> statement-breakpoint
-ALTER TABLE "steam" ADD COLUMN "steam_email" varchar(255) NOT NULL;--> statement-breakpoint
-ALTER TABLE "steam" ADD COLUMN "limitation" json NOT NULL;--> statement-breakpoint
-CREATE UNIQUE INDEX "machine_fingerprint" ON "machine" USING btree ("fingerprint");--> statement-breakpoint
-ALTER TABLE "steam" DROP COLUMN "access_token";--> statement-breakpoint
-ALTER TABLE "user" DROP COLUMN "flags";

packages/core/migrations/0004_amused_mattie_franklin.sql

@@ -1,8 +0,0 @@
-ALTER TABLE "steam" RENAME COLUMN "time_seen" TO "last_seen";--> statement-breakpoint
-DROP INDEX "steam_email";--> statement-breakpoint
-ALTER TABLE "steam" DROP CONSTRAINT "steam_user_id_id_pk";--> statement-breakpoint
-ALTER TABLE "steam" ADD PRIMARY KEY ("id");--> statement-breakpoint
-ALTER TABLE "machine" ADD CONSTRAINT "machine_user_id_id_pk" PRIMARY KEY("user_id","id");--> statement-breakpoint
-ALTER TABLE "machine" ADD COLUMN "user_id" char(30);--> statement-breakpoint
-ALTER TABLE "steam" ADD CONSTRAINT "steam_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "steam" DROP COLUMN "email";

packages/core/migrations/0005_aspiring_stature.sql

@@ -1,2 +0,0 @@
-ALTER TABLE "machine" DROP CONSTRAINT "machine_user_id_id_pk";--> statement-breakpoint
-ALTER TABLE "machine" DROP COLUMN "user_id";

packages/core/migrations/0006_worthless_dreadnoughts.sql

@@ -1,2 +0,0 @@
-ALTER TABLE "member" ADD COLUMN "role" text NOT NULL;--> statement-breakpoint
-ALTER TABLE "team" DROP COLUMN "plan_type";

packages/core/migrations/0007_warm_secret_warriors.sql

@@ -1,15 +0,0 @@
-CREATE TABLE "subscription" (
-	"id" char(30) NOT NULL,
-	"user_id" char(30) NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"team_id" char(30) NOT NULL,
-	"standing" text NOT NULL,
-	"plan_type" text NOT NULL,
-	"tokens" integer NOT NULL,
-	"product_id" varchar(255),
-	"subscription_id" varchar(255)
-);
---> statement-breakpoint
-ALTER TABLE "subscription" ADD CONSTRAINT "subscription_team_id_team_id_fk" FOREIGN KEY ("team_id") REFERENCES "public"."team"("id") ON DELETE cascade ON UPDATE no action;

packages/core/migrations/0008_third_mindworm.sql

@@ -1,3 +0,0 @@
-ALTER TABLE "subscription" ADD CONSTRAINT "subscription_id_team_id_pk" PRIMARY KEY("id","team_id");--> statement-breakpoint
-CREATE UNIQUE INDEX "subscription_id" ON "subscription" USING btree ("id");--> statement-breakpoint
-CREATE INDEX "subscription_user_id" ON "subscription" USING btree ("user_id");

packages/core/migrations/0009_luxuriant_wraith.sql

@@ -1,2 +0,0 @@
-CREATE UNIQUE INDEX "steam_id" ON "steam" USING btree ("steam_id");--> statement-breakpoint
-CREATE INDEX "steam_user_id" ON "steam" USING btree ("user_id");

packages/core/migrations/0010_certain_dust.sql

@@ -1,94 +0,0 @@
-CREATE TYPE "public"."member_role" AS ENUM('child', 'adult');--> statement-breakpoint
-CREATE TYPE "public"."steam_status" AS ENUM('online', 'offline', 'dnd', 'playing');--> statement-breakpoint
-CREATE TABLE "steam_account_credentials" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"steam_id" varchar(255) PRIMARY KEY NOT NULL,
-	"refresh_token" text NOT NULL,
-	"expiry" timestamp with time zone NOT NULL,
-	"username" varchar(255) NOT NULL
-);
---> statement-breakpoint
-CREATE TABLE "friends_list" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"steam_id" varchar(255) NOT NULL,
-	"friend_steam_id" varchar(255) NOT NULL,
-	CONSTRAINT "friends_list_steam_id_friend_steam_id_pk" PRIMARY KEY("steam_id","friend_steam_id")
-);
---> statement-breakpoint
-CREATE TABLE "members" (
-	"id" char(30) NOT NULL,
-	"team_id" char(30) NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"user_id" char(30),
-	"steam_id" varchar(255) NOT NULL,
-	"role" "member_role" NOT NULL,
-	CONSTRAINT "members_id_team_id_pk" PRIMARY KEY("id","team_id")
-);
---> statement-breakpoint
-CREATE TABLE "steam_accounts" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"steam_id" varchar(255) PRIMARY KEY NOT NULL,
-	"user_id" char(30),
-	"status" "steam_status" NOT NULL,
-	"last_synced_at" timestamp with time zone NOT NULL,
-	"real_name" varchar(255),
-	"member_since" timestamp with time zone NOT NULL,
-	"name" varchar(255) NOT NULL,
-	"profile_url" varchar(255),
-	"username" varchar(255) NOT NULL,
-	"avatar_hash" varchar(255) NOT NULL,
-	"limitations" json NOT NULL,
-	CONSTRAINT "idx_steam_username" UNIQUE("username")
-);
---> statement-breakpoint
-CREATE TABLE "teams" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"name" varchar(255) NOT NULL,
-	"owner_id" char(30) NOT NULL,
-	"invite_code" varchar(10) NOT NULL,
-	"slug" varchar(255) NOT NULL,
-	"max_members" bigint NOT NULL,
-	CONSTRAINT "idx_team_invite_code" UNIQUE("invite_code")
-);
---> statement-breakpoint
-CREATE TABLE "users" (
-	"id" char(30) PRIMARY KEY NOT NULL,
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"email" varchar(255) NOT NULL,
-	"avatar_url" text,
-	"last_login" timestamp with time zone NOT NULL,
-	"name" varchar(255) NOT NULL,
-	"polar_customer_id" varchar(255),
-	CONSTRAINT "idx_user_email" UNIQUE("email")
-);
---> statement-breakpoint
-DROP TABLE "machine" CASCADE;--> statement-breakpoint
-DROP TABLE "member" CASCADE;--> statement-breakpoint
-DROP TABLE "steam" CASCADE;--> statement-breakpoint
-DROP TABLE "subscription" CASCADE;--> statement-breakpoint
-DROP TABLE "team" CASCADE;--> statement-breakpoint
-DROP TABLE "user" CASCADE;--> statement-breakpoint
-ALTER TABLE "steam_account_credentials" ADD CONSTRAINT "steam_account_credentials_steam_id_steam_accounts_steam_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("steam_id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "friends_list" ADD CONSTRAINT "friends_list_steam_id_steam_accounts_steam_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("steam_id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "friends_list" ADD CONSTRAINT "friends_list_friend_steam_id_steam_accounts_steam_id_fk" FOREIGN KEY ("friend_steam_id") REFERENCES "public"."steam_accounts"("steam_id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "members" ADD CONSTRAINT "members_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "members" ADD CONSTRAINT "members_steam_id_steam_accounts_steam_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("steam_id") ON DELETE cascade ON UPDATE restrict;--> statement-breakpoint
-ALTER TABLE "steam_accounts" ADD CONSTRAINT "steam_accounts_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "teams" ADD CONSTRAINT "teams_owner_id_users_id_fk" FOREIGN KEY ("owner_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "teams" ADD CONSTRAINT "teams_slug_steam_accounts_username_fk" FOREIGN KEY ("slug") REFERENCES "public"."steam_accounts"("username") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-CREATE UNIQUE INDEX "idx_member_steam_id" ON "members" USING btree ("team_id","steam_id");--> statement-breakpoint
-CREATE UNIQUE INDEX "idx_member_user_id" ON "members" USING btree ("team_id","user_id") WHERE "members"."user_id" is not null;--> statement-breakpoint
-CREATE UNIQUE INDEX "idx_team_slug" ON "teams" USING btree ("slug");

packages/core/migrations/0011_simple_azazel.sql

@@ -1,89 +0,0 @@
-CREATE TYPE "public"."compatibility" AS ENUM('high', 'mid', 'low', 'unknown');--> statement-breakpoint
-CREATE TYPE "public"."category_type" AS ENUM('tag', 'genre', 'publisher', 'developer');--> statement-breakpoint
-CREATE TYPE "public"."image_type" AS ENUM('heroArt', 'icon', 'logo', 'superHeroArt', 'poster', 'boxArt', 'screenshot', 'background');--> statement-breakpoint
-CREATE TABLE "base_games" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"id" varchar(255) PRIMARY KEY NOT NULL,
-	"slug" varchar(255) NOT NULL,
-	"name" text NOT NULL,
-	"release_date" timestamp with time zone NOT NULL,
-	"size" json NOT NULL,
-	"description" text NOT NULL,
-	"primary_genre" text NOT NULL,
-	"controller_support" text,
-	"compatibility" "compatibility" DEFAULT 'unknown' NOT NULL,
-	"score" numeric(2, 1) NOT NULL,
-	CONSTRAINT "idx_base_games_slug" UNIQUE("slug")
-);
---> statement-breakpoint
-CREATE TABLE "categories" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"slug" varchar(255) NOT NULL,
-	"type" "category_type" NOT NULL,
-	"name" text NOT NULL,
-	CONSTRAINT "categories_slug_type_pk" PRIMARY KEY("slug","type")
-);
---> statement-breakpoint
-CREATE TABLE "games" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"base_game_id" varchar(255) NOT NULL,
-	"category_slug" varchar(255) NOT NULL,
-	"type" "category_type" NOT NULL,
-	CONSTRAINT "games_base_game_id_category_slug_type_pk" PRIMARY KEY("base_game_id","category_slug","type")
-);
---> statement-breakpoint
-CREATE TABLE "images" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"type" "image_type" NOT NULL,
-	"image_hash" varchar(255) NOT NULL,
-	"base_game_id" varchar(255) NOT NULL,
-	"source_url" text NOT NULL,
-	"position" integer DEFAULT 0 NOT NULL,
-	"file_size" integer NOT NULL,
-	"dimensions" json NOT NULL,
-	"extracted_color" json NOT NULL,
-	CONSTRAINT "images_image_hash_type_base_game_id_position_pk" PRIMARY KEY("image_hash","type","base_game_id","position")
-);
---> statement-breakpoint
-CREATE TABLE "game_libraries" (
-	"time_created" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_updated" timestamp with time zone DEFAULT now() NOT NULL,
-	"time_deleted" timestamp with time zone,
-	"base_game_id" varchar(255) NOT NULL,
-	"owner_id" varchar(255) NOT NULL,
-	CONSTRAINT "game_libraries_base_game_id_owner_id_pk" PRIMARY KEY("base_game_id","owner_id")
-);
---> statement-breakpoint
-ALTER TABLE "steam_accounts" RENAME COLUMN "steam_id" TO "id";--> statement-breakpoint
-ALTER TABLE "steam_account_credentials" DROP CONSTRAINT "steam_account_credentials_steam_id_steam_accounts_steam_id_fk";
---> statement-breakpoint
-ALTER TABLE "friends_list" DROP CONSTRAINT "friends_list_steam_id_steam_accounts_steam_id_fk";
---> statement-breakpoint
-ALTER TABLE "friends_list" DROP CONSTRAINT "friends_list_friend_steam_id_steam_accounts_steam_id_fk";
---> statement-breakpoint
-ALTER TABLE "members" DROP CONSTRAINT "members_steam_id_steam_accounts_steam_id_fk";
---> statement-breakpoint
-ALTER TABLE "games" ADD CONSTRAINT "games_base_game_id_base_games_id_fk" FOREIGN KEY ("base_game_id") REFERENCES "public"."base_games"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "games" ADD CONSTRAINT "games_categories_fkey" FOREIGN KEY ("category_slug","type") REFERENCES "public"."categories"("slug","type") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "images" ADD CONSTRAINT "images_base_game_id_base_games_id_fk" FOREIGN KEY ("base_game_id") REFERENCES "public"."base_games"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD CONSTRAINT "game_libraries_base_game_id_base_games_id_fk" FOREIGN KEY ("base_game_id") REFERENCES "public"."base_games"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD CONSTRAINT "game_libraries_owner_id_steam_accounts_id_fk" FOREIGN KEY ("owner_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-CREATE INDEX "idx_categories_type" ON "categories" USING btree ("type");--> statement-breakpoint
-CREATE INDEX "idx_games_category_slug" ON "games" USING btree ("category_slug");--> statement-breakpoint
-CREATE INDEX "idx_games_category_type" ON "games" USING btree ("type");--> statement-breakpoint
-CREATE INDEX "idx_images_type" ON "images" USING btree ("type");--> statement-breakpoint
-CREATE INDEX "idx_images_game_id" ON "images" USING btree ("base_game_id");--> statement-breakpoint
-CREATE INDEX "idx_game_libraries_owner_id" ON "game_libraries" USING btree ("owner_id");--> statement-breakpoint
-ALTER TABLE "steam_account_credentials" ADD CONSTRAINT "steam_account_credentials_steam_id_steam_accounts_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "friends_list" ADD CONSTRAINT "friends_list_steam_id_steam_accounts_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "friends_list" ADD CONSTRAINT "friends_list_friend_steam_id_steam_accounts_id_fk" FOREIGN KEY ("friend_steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "members" ADD CONSTRAINT "members_steam_id_steam_accounts_id_fk" FOREIGN KEY ("steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE restrict;--> statement-breakpoint
-CREATE INDEX "idx_friends_list_friend_steam_id" ON "friends_list" USING btree ("friend_steam_id");

packages/core/migrations/0012_glorious_jetstream.sql

@@ -1,4 +0,0 @@
-ALTER TABLE "games" DROP CONSTRAINT "games_categories_fkey";
---> statement-breakpoint
-ALTER TABLE "games" ADD CONSTRAINT "games_categories_fkey" FOREIGN KEY ("category_slug","type") REFERENCES "public"."categories"("slug","type") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-CREATE INDEX "idx_games_category_slug_type" ON "games" USING btree ("category_slug","type");

packages/core/migrations/0013_neat_colleen_wing.sql

@@ -1,3 +0,0 @@
-CREATE TYPE "public"."controller_support" AS ENUM('full', 'unknown');--> statement-breakpoint
-ALTER TABLE "base_games" ALTER COLUMN "controller_support" SET DATA TYPE controller_support;--> statement-breakpoint
-ALTER TABLE "base_games" ALTER COLUMN "controller_support" SET NOT NULL;

packages/core/migrations/0014_thin_groot.sql

@@ -1 +0,0 @@
-ALTER TABLE "base_games" ALTER COLUMN "primary_genre" DROP NOT NULL;

packages/core/migrations/0015_handy_giant_man.sql

@@ -1 +0,0 @@
-ALTER TYPE "public"."controller_support" ADD VALUE 'partial' BEFORE 'unknown';

packages/core/migrations/0016_melted_johnny_storm.sql

@@ -1,4 +0,0 @@
-ALTER TABLE "game_libraries" ADD COLUMN "time_acquired" timestamp with time zone NOT NULL;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD COLUMN "last_played" timestamp with time zone NOT NULL;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD COLUMN "total_playtime" integer NOT NULL;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD COLUMN "is_family_shared" boolean NOT NULL;

packages/core/migrations/0017_zippy_nico_minoru.sql

@@ -1,4 +0,0 @@
-ALTER TABLE "public"."images" ALTER COLUMN "type" SET DATA TYPE text;--> statement-breakpoint
-DROP TYPE "public"."image_type";--> statement-breakpoint
-CREATE TYPE "public"."image_type" AS ENUM('heroArt', 'icon', 'logo', 'superHeroArt', 'poster', 'boxArt', 'screenshot', 'backdrop');--> statement-breakpoint
-ALTER TABLE "public"."images" ALTER COLUMN "type" SET DATA TYPE "public"."image_type" USING "type"::"public"."image_type";

packages/core/migrations/0018_solid_enchantress.sql

@@ -1,4 +0,0 @@
-ALTER TABLE "public"."images" ALTER COLUMN "type" SET DATA TYPE text;--> statement-breakpoint
-DROP TYPE "public"."image_type";--> statement-breakpoint
-CREATE TYPE "public"."image_type" AS ENUM('heroArt', 'icon', 'logo', 'banner', 'poster', 'boxArt', 'screenshot', 'backdrop');--> statement-breakpoint
-ALTER TABLE "public"."images" ALTER COLUMN "type" SET DATA TYPE "public"."image_type" USING "type"::"public"."image_type";

packages/core/migrations/0019_charming_namorita.sql

@@ -1,19 +0,0 @@
-/* 
-    Unfortunately in current drizzle-kit version we can't automatically get name for primary key.
-    We are working on making it available!
-
-    Meanwhile you can:
-        1. Check pk name in your database, by running
-            SELECT constraint_name FROM information_schema.table_constraints
-            WHERE table_schema = 'public'
-                AND table_name = 'steam_account_credentials'
-                AND constraint_type = 'PRIMARY KEY';
-        2. Uncomment code below and paste pk name manually
-        
-    Hope to release this update as soon as possible
-*/
-
--- ALTER TABLE "steam_account_credentials" DROP CONSTRAINT "<constraint_name>";--> statement-breakpoint
-ALTER TABLE "images" ALTER COLUMN "source_url" DROP NOT NULL;--> statement-breakpoint
-ALTER TABLE "steam_account_credentials" ADD CONSTRAINT "steam_account_credentials_steam_id_id_pk" PRIMARY KEY("steam_id","id");--> statement-breakpoint
-ALTER TABLE "steam_account_credentials" ADD COLUMN "id" char(30) NOT NULL;

packages/core/migrations/0020_vengeful_wallop.sql

@@ -1,23 +0,0 @@
-ALTER TABLE "steam_account_credentials" DISABLE ROW LEVEL SECURITY;--> statement-breakpoint
-DROP TABLE "steam_account_credentials" CASCADE;--> statement-breakpoint
-ALTER TABLE "game_libraries" RENAME COLUMN "owner_id" TO "owner_steam_id";--> statement-breakpoint
-ALTER TABLE "teams" RENAME COLUMN "owner_id" TO "owner_steam_id";--> statement-breakpoint
-ALTER TABLE "steam_accounts" DROP CONSTRAINT "idx_steam_username";--> statement-breakpoint
-ALTER TABLE "game_libraries" DROP CONSTRAINT "game_libraries_owner_id_steam_accounts_id_fk";
---> statement-breakpoint
-ALTER TABLE "teams" DROP CONSTRAINT "teams_owner_id_users_id_fk";
---> statement-breakpoint
-ALTER TABLE "teams" DROP CONSTRAINT "teams_slug_steam_accounts_username_fk";
---> statement-breakpoint
-DROP INDEX "idx_team_slug";--> statement-breakpoint
-DROP INDEX "idx_game_libraries_owner_id";--> statement-breakpoint
-ALTER TABLE "game_libraries" DROP CONSTRAINT "game_libraries_base_game_id_owner_id_pk";--> statement-breakpoint
-ALTER TABLE "game_libraries" ALTER COLUMN "last_played" DROP NOT NULL;--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD CONSTRAINT "game_libraries_base_game_id_owner_steam_id_pk" PRIMARY KEY("base_game_id","owner_steam_id");--> statement-breakpoint
-ALTER TABLE "game_libraries" ADD CONSTRAINT "game_libraries_owner_steam_id_steam_accounts_id_fk" FOREIGN KEY ("owner_steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "teams" ADD CONSTRAINT "teams_owner_steam_id_steam_accounts_id_fk" FOREIGN KEY ("owner_steam_id") REFERENCES "public"."steam_accounts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-CREATE INDEX "idx_game_libraries_owner_id" ON "game_libraries" USING btree ("owner_steam_id");--> statement-breakpoint
-ALTER TABLE "game_libraries" DROP COLUMN "time_acquired";--> statement-breakpoint
-ALTER TABLE "game_libraries" DROP COLUMN "is_family_shared";--> statement-breakpoint
-ALTER TABLE "steam_accounts" DROP COLUMN "username";--> statement-breakpoint
-ALTER TABLE "teams" DROP COLUMN "slug";

packages/core/migrations/0021_real_skreet.sql

@@ -1,2 +0,0 @@
-ALTER TYPE "public"."category_type" ADD VALUE 'category';--> statement-breakpoint
-ALTER TYPE "public"."category_type" ADD VALUE 'franchise';

packages/core/migrations/0022_clean_living_lightning.sql

@@ -1,6 +0,0 @@
-ALTER TABLE "public"."categories" ALTER COLUMN "type" SET DATA TYPE text;--> statement-breakpoint
-ALTER TABLE "public"."games" ALTER COLUMN "type" SET DATA TYPE text;--> statement-breakpoint
-DROP TYPE "public"."category_type";--> statement-breakpoint
-CREATE TYPE "public"."category_type" AS ENUM('tag', 'genre', 'publisher', 'developer', 'categorie', 'franchise');--> statement-breakpoint
-ALTER TABLE "public"."categories" ALTER COLUMN "type" SET DATA TYPE "public"."category_type" USING "type"::"public"."category_type";--> statement-breakpoint
-ALTER TABLE "public"."games" ALTER COLUMN "type" SET DATA TYPE "public"."category_type" USING "type"::"public"."category_type";

packages/core/migrations/0023_flawless_steel_serpent.sql

@@ -1,2 +0,0 @@
-ALTER TABLE "base_games" ALTER COLUMN "description" DROP NOT NULL;--> statement-breakpoint
-ALTER TABLE "base_games" ADD COLUMN "links" text[];

packages/core/migrations/0024_damp_cerise.sql

@@ -1 +0,0 @@
-ALTER TABLE "base_games" ALTER COLUMN "links" SET DATA TYPE json;

packages/core/migrations/0025_bitter_jack_flag.sql

@@ -1,3 +0,0 @@
-DROP TABLE "members" CASCADE;--> statement-breakpoint
-DROP TABLE "teams" CASCADE;--> statement-breakpoint
-DROP TYPE "public"."member_role";

packages/core/migrations/meta/0000_snapshot.json

@@ -1,294 +0,0 @@
-{
-  "id": "f09034df-208a-42b3-b61f-f842921c6e24",
-  "prevId": "00000000-0000-0000-0000-000000000000",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "team_slug": {
-          "name": "team_slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "flags": {
-          "name": "flags",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": false,
-          "default": "'{}'::json"
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0001_snapshot.json

@@ -1,294 +0,0 @@
-{
-  "id": "6f428226-b5d8-4182-a676-d04f842f9ded",
-  "prevId": "f09034df-208a-42b3-b61f-f842921c6e24",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "flags": {
-          "name": "flags",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": false,
-          "default": "'{}'::json"
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0002_snapshot.json

@@ -1,420 +0,0 @@
-{
-  "id": "227c54d2-b643-48d5-964b-af6fe004369a",
-  "prevId": "6f428226-b5d8-4182-a676-d04f842f9ded",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "access_token": {
-          "name": "access_token",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country": {
-          "name": "country",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "global_steam_email": {
-          "name": "global_steam_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "columns": [
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "steam_user_id_id_pk": {
-          "name": "steam_user_id_id_pk",
-          "columns": [
-            "user_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "flags": {
-          "name": "flags",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": false,
-          "default": "'{}'::json"
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0003_snapshot.json

@@ -1,507 +0,0 @@
-{
-  "id": "eb5d41aa-5f85-4b2d-8633-fc021b211241",
-  "prevId": "227c54d2-b643-48d5-964b-af6fe004369a",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "steam_email": {
-          "name": "steam_email",
-          "columns": [
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "steam_user_id_id_pk": {
-          "name": "steam_user_id_id_pk",
-          "columns": [
-            "user_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0004_snapshot.json

@@ -1,499 +0,0 @@
-{
-  "id": "65574f71-e0d3-4363-9449-394e7c376a30",
-  "prevId": "eb5d41aa-5f85-4b2d-8633-fc021b211241",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "machine_user_id_id_pk": {
-          "name": "machine_user_id_id_pk",
-          "columns": [
-            "user_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0005_snapshot.json

@@ -1,485 +0,0 @@
-{
-  "id": "0b04858c-a7e3-43b6-98a4-1dc2f6f97488",
-  "prevId": "65574f71-e0d3-4363-9449-394e7c376a30",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0006_snapshot.json

@@ -1,485 +0,0 @@
-{
-  "id": "69827225-1351-4709-a9b2-facb0f569215",
-  "prevId": "0b04858c-a7e3-43b6-98a4-1dc2f6f97488",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "role": {
-          "name": "role",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0007_snapshot.json

@@ -1,580 +0,0 @@
-{
-  "id": "fff2b73d-85ab-48bc-86de-69d3caf317f0",
-  "prevId": "69827225-1351-4709-a9b2-facb0f569215",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "role": {
-          "name": "role",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.subscription": {
-      "name": "subscription",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "standing": {
-          "name": "standing",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "tokens": {
-          "name": "tokens",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "product_id": {
-          "name": "product_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "subscription_id": {
-          "name": "subscription_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "subscription_team_id_team_id_fk": {
-          "name": "subscription_team_id_team_id_fk",
-          "tableFrom": "subscription",
-          "tableTo": "team",
-          "columnsFrom": [
-            "team_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0008_snapshot.json

@@ -1,619 +0,0 @@
-{
-  "id": "17b9c14f-ff15-44a5-9aaf-3f3b7dd7d294",
-  "prevId": "fff2b73d-85ab-48bc-86de-69d3caf317f0",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "role": {
-          "name": "role",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.subscription": {
-      "name": "subscription",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "standing": {
-          "name": "standing",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "tokens": {
-          "name": "tokens",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "product_id": {
-          "name": "product_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "subscription_id": {
-          "name": "subscription_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "subscription_id": {
-          "name": "subscription_id",
-          "columns": [
-            {
-              "expression": "id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "subscription_user_id": {
-          "name": "subscription_user_id",
-          "columns": [
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "subscription_team_id_team_id_fk": {
-          "name": "subscription_team_id_team_id_fk",
-          "tableFrom": "subscription",
-          "tableTo": "team",
-          "columnsFrom": [
-            "team_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "subscription_id_team_id_pk": {
-          "name": "subscription_id_team_id_pk",
-          "columns": [
-            "id",
-            "team_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0009_snapshot.json

@@ -1,650 +0,0 @@
-{
-  "id": "1717c769-cee0-4242-bcbb-9538c80d985c",
-  "prevId": "17b9c14f-ff15-44a5-9aaf-3f3b7dd7d294",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.machine": {
-      "name": "machine",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "country": {
-          "name": "country",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "timezone": {
-          "name": "timezone",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "location": {
-          "name": "location",
-          "type": "point",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "fingerprint": {
-          "name": "fingerprint",
-          "type": "varchar(32)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "machine_fingerprint": {
-          "name": "machine_fingerprint",
-          "columns": [
-            {
-              "expression": "fingerprint",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.member": {
-      "name": "member",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "role": {
-          "name": "role",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_seen": {
-          "name": "time_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "email_global": {
-          "name": "email_global",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "member_email": {
-          "name": "member_email",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "member_team_id_id_pk": {
-          "name": "member_team_id_id_pk",
-          "columns": [
-            "team_id",
-            "id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam": {
-      "name": "steam",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_seen": {
-          "name": "last_seen",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_game": {
-          "name": "last_game",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "country_code": {
-          "name": "country_code",
-          "type": "varchar(2)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "steam_email": {
-          "name": "steam_email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "persona_name": {
-          "name": "persona_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitation": {
-          "name": "limitation",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "steam_id": {
-          "name": "steam_id",
-          "columns": [
-            {
-              "expression": "steam_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "steam_user_id": {
-          "name": "steam_user_id",
-          "columns": [
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "steam_user_id_user_id_fk": {
-          "name": "steam_user_id_user_id_fk",
-          "tableFrom": "steam",
-          "tableTo": "user",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.subscription": {
-      "name": "subscription",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "standing": {
-          "name": "standing",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "plan_type": {
-          "name": "plan_type",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "tokens": {
-          "name": "tokens",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "product_id": {
-          "name": "product_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "subscription_id": {
-          "name": "subscription_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "subscription_id": {
-          "name": "subscription_id",
-          "columns": [
-            {
-              "expression": "id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "subscription_user_id": {
-          "name": "subscription_user_id",
-          "columns": [
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "subscription_team_id_team_id_fk": {
-          "name": "subscription_team_id_team_id_fk",
-          "tableFrom": "subscription",
-          "tableTo": "team",
-          "columnsFrom": [
-            "team_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "subscription_id_team_id_pk": {
-          "name": "subscription_id_team_id_pk",
-          "columns": [
-            "id",
-            "team_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.team": {
-      "name": "team",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "slug": {
-          "name": "slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.user": {
-      "name": "user",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "discriminator": {
-          "name": "discriminator",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {
-        "user_email": {
-          "name": "user_email",
-          "columns": [
-            {
-              "expression": "email",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "user_polar_customer_id_unique": {
-          "name": "user_polar_customer_id_unique",
-          "nullsNotDistinct": false,
-          "columns": [
-            "polar_customer_id"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {},
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0010_snapshot.json

@@ -1,651 +0,0 @@
-{
-  "id": "56a4d60a-c062-47e5-a97e-625443411ad8",
-  "prevId": "1717c769-cee0-4242-bcbb-9538c80d985c",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.steam_account_credentials": {
-      "name": "steam_account_credentials",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "varchar(255)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "refresh_token": {
-          "name": "refresh_token",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "expiry": {
-          "name": "expiry",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_account_credentials_steam_id_steam_accounts_steam_id_fk": {
-          "name": "steam_account_credentials_steam_id_steam_accounts_steam_id_fk",
-          "tableFrom": "steam_account_credentials",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "steam_id"
-          ],
-          "columnsTo": [
-            "steam_id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.friends_list": {
-      "name": "friends_list",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "friend_steam_id": {
-          "name": "friend_steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "friends_list_steam_id_steam_accounts_steam_id_fk": {
-          "name": "friends_list_steam_id_steam_accounts_steam_id_fk",
-          "tableFrom": "friends_list",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "steam_id"
-          ],
-          "columnsTo": [
-            "steam_id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "friends_list_friend_steam_id_steam_accounts_steam_id_fk": {
-          "name": "friends_list_friend_steam_id_steam_accounts_steam_id_fk",
-          "tableFrom": "friends_list",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "friend_steam_id"
-          ],
-          "columnsTo": [
-            "steam_id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "friends_list_steam_id_friend_steam_id_pk": {
-          "name": "friends_list_steam_id_friend_steam_id_pk",
-          "columns": [
-            "steam_id",
-            "friend_steam_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.members": {
-      "name": "members",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "team_id": {
-          "name": "team_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "role": {
-          "name": "role",
-          "type": "member_role",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_member_steam_id": {
-          "name": "idx_member_steam_id",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "steam_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "idx_member_user_id": {
-          "name": "idx_member_user_id",
-          "columns": [
-            {
-              "expression": "team_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "user_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "where": "\"members\".\"user_id\" is not null",
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "members_user_id_users_id_fk": {
-          "name": "members_user_id_users_id_fk",
-          "tableFrom": "members",
-          "tableTo": "users",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "members_steam_id_steam_accounts_steam_id_fk": {
-          "name": "members_steam_id_steam_accounts_steam_id_fk",
-          "tableFrom": "members",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "steam_id"
-          ],
-          "columnsTo": [
-            "steam_id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "restrict"
-        }
-      },
-      "compositePrimaryKeys": {
-        "members_id_team_id_pk": {
-          "name": "members_id_team_id_pk",
-          "columns": [
-            "id",
-            "team_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam_accounts": {
-      "name": "steam_accounts",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "varchar(255)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "status": {
-          "name": "status",
-          "type": "steam_status",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_synced_at": {
-          "name": "last_synced_at",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "real_name": {
-          "name": "real_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "member_since": {
-          "name": "member_since",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "profile_url": {
-          "name": "profile_url",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "username": {
-          "name": "username",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_hash": {
-          "name": "avatar_hash",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitations": {
-          "name": "limitations",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_accounts_user_id_users_id_fk": {
-          "name": "steam_accounts_user_id_users_id_fk",
-          "tableFrom": "steam_accounts",
-          "tableTo": "users",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "idx_steam_username": {
-          "name": "idx_steam_username",
-          "nullsNotDistinct": false,
-          "columns": [
-            "username"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.teams": {
-      "name": "teams",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "owner_id": {
-          "name": "owner_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "invite_code": {
-          "name": "invite_code",
-          "type": "varchar(10)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "max_members": {
-          "name": "max_members",
-          "type": "bigint",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_team_slug": {
-          "name": "idx_team_slug",
-          "columns": [
-            {
-              "expression": "slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": true,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "teams_owner_id_users_id_fk": {
-          "name": "teams_owner_id_users_id_fk",
-          "tableFrom": "teams",
-          "tableTo": "users",
-          "columnsFrom": [
-            "owner_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "teams_slug_steam_accounts_username_fk": {
-          "name": "teams_slug_steam_accounts_username_fk",
-          "tableFrom": "teams",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "slug"
-          ],
-          "columnsTo": [
-            "username"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "idx_team_invite_code": {
-          "name": "idx_team_invite_code",
-          "nullsNotDistinct": false,
-          "columns": [
-            "invite_code"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.users": {
-      "name": "users",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "last_login": {
-          "name": "last_login",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "idx_user_email": {
-          "name": "idx_user_email",
-          "nullsNotDistinct": false,
-          "columns": [
-            "email"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {
-    "public.member_role": {
-      "name": "member_role",
-      "schema": "public",
-      "values": [
-        "child",
-        "adult"
-      ]
-    },
-    "public.steam_status": {
-      "name": "steam_status",
-      "schema": "public",
-      "values": [
-        "online",
-        "offline",
-        "dnd",
-        "playing"
-      ]
-    }
-  },
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/0025_snapshot.json

@@ -1,930 +0,0 @@
-{
-  "id": "735d315b-40e1-46c1-814d-0fd3619b65de",
-  "prevId": "d35aa09b-5739-46a5-86f3-3050913dc2f7",
-  "version": "7",
-  "dialect": "postgresql",
-  "tables": {
-    "public.base_games": {
-      "name": "base_games",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "id": {
-          "name": "id",
-          "type": "varchar(255)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "links": {
-          "name": "links",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "description": {
-          "name": "description",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "release_date": {
-          "name": "release_date",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "size": {
-          "name": "size",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "primary_genre": {
-          "name": "primary_genre",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "controller_support": {
-          "name": "controller_support",
-          "type": "controller_support",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "compatibility": {
-          "name": "compatibility",
-          "type": "compatibility",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "'unknown'"
-        },
-        "score": {
-          "name": "score",
-          "type": "numeric(2, 1)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "idx_base_games_slug": {
-          "name": "idx_base_games_slug",
-          "nullsNotDistinct": false,
-          "columns": [
-            "slug"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.categories": {
-      "name": "categories",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "slug": {
-          "name": "slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "type": {
-          "name": "type",
-          "type": "category_type",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_categories_type": {
-          "name": "idx_categories_type",
-          "columns": [
-            {
-              "expression": "type",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {},
-      "compositePrimaryKeys": {
-        "categories_slug_type_pk": {
-          "name": "categories_slug_type_pk",
-          "columns": [
-            "slug",
-            "type"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.friends_list": {
-      "name": "friends_list",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "steam_id": {
-          "name": "steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "friend_steam_id": {
-          "name": "friend_steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_friends_list_friend_steam_id": {
-          "name": "idx_friends_list_friend_steam_id",
-          "columns": [
-            {
-              "expression": "friend_steam_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "friends_list_steam_id_steam_accounts_id_fk": {
-          "name": "friends_list_steam_id_steam_accounts_id_fk",
-          "tableFrom": "friends_list",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "steam_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "friends_list_friend_steam_id_steam_accounts_id_fk": {
-          "name": "friends_list_friend_steam_id_steam_accounts_id_fk",
-          "tableFrom": "friends_list",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "friend_steam_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "friends_list_steam_id_friend_steam_id_pk": {
-          "name": "friends_list_steam_id_friend_steam_id_pk",
-          "columns": [
-            "steam_id",
-            "friend_steam_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.games": {
-      "name": "games",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "base_game_id": {
-          "name": "base_game_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "category_slug": {
-          "name": "category_slug",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "type": {
-          "name": "type",
-          "type": "category_type",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_games_category_slug": {
-          "name": "idx_games_category_slug",
-          "columns": [
-            {
-              "expression": "category_slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "idx_games_category_type": {
-          "name": "idx_games_category_type",
-          "columns": [
-            {
-              "expression": "type",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "idx_games_category_slug_type": {
-          "name": "idx_games_category_slug_type",
-          "columns": [
-            {
-              "expression": "category_slug",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            },
-            {
-              "expression": "type",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "games_base_game_id_base_games_id_fk": {
-          "name": "games_base_game_id_base_games_id_fk",
-          "tableFrom": "games",
-          "tableTo": "base_games",
-          "columnsFrom": [
-            "base_game_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "games_categories_fkey": {
-          "name": "games_categories_fkey",
-          "tableFrom": "games",
-          "tableTo": "categories",
-          "columnsFrom": [
-            "category_slug",
-            "type"
-          ],
-          "columnsTo": [
-            "slug",
-            "type"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "games_base_game_id_category_slug_type_pk": {
-          "name": "games_base_game_id_category_slug_type_pk",
-          "columns": [
-            "base_game_id",
-            "category_slug",
-            "type"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.images": {
-      "name": "images",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "type": {
-          "name": "type",
-          "type": "image_type",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "image_hash": {
-          "name": "image_hash",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "base_game_id": {
-          "name": "base_game_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "source_url": {
-          "name": "source_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "position": {
-          "name": "position",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true,
-          "default": 0
-        },
-        "file_size": {
-          "name": "file_size",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "dimensions": {
-          "name": "dimensions",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "extracted_color": {
-          "name": "extracted_color",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_images_type": {
-          "name": "idx_images_type",
-          "columns": [
-            {
-              "expression": "type",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        },
-        "idx_images_game_id": {
-          "name": "idx_images_game_id",
-          "columns": [
-            {
-              "expression": "base_game_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "images_base_game_id_base_games_id_fk": {
-          "name": "images_base_game_id_base_games_id_fk",
-          "tableFrom": "images",
-          "tableTo": "base_games",
-          "columnsFrom": [
-            "base_game_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "images_image_hash_type_base_game_id_position_pk": {
-          "name": "images_image_hash_type_base_game_id_position_pk",
-          "columns": [
-            "image_hash",
-            "type",
-            "base_game_id",
-            "position"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.game_libraries": {
-      "name": "game_libraries",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "base_game_id": {
-          "name": "base_game_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "owner_steam_id": {
-          "name": "owner_steam_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_played": {
-          "name": "last_played",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "total_playtime": {
-          "name": "total_playtime",
-          "type": "integer",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {
-        "idx_game_libraries_owner_id": {
-          "name": "idx_game_libraries_owner_id",
-          "columns": [
-            {
-              "expression": "owner_steam_id",
-              "isExpression": false,
-              "asc": true,
-              "nulls": "last"
-            }
-          ],
-          "isUnique": false,
-          "concurrently": false,
-          "method": "btree",
-          "with": {}
-        }
-      },
-      "foreignKeys": {
-        "game_libraries_base_game_id_base_games_id_fk": {
-          "name": "game_libraries_base_game_id_base_games_id_fk",
-          "tableFrom": "game_libraries",
-          "tableTo": "base_games",
-          "columnsFrom": [
-            "base_game_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        },
-        "game_libraries_owner_steam_id_steam_accounts_id_fk": {
-          "name": "game_libraries_owner_steam_id_steam_accounts_id_fk",
-          "tableFrom": "game_libraries",
-          "tableTo": "steam_accounts",
-          "columnsFrom": [
-            "owner_steam_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {
-        "game_libraries_base_game_id_owner_steam_id_pk": {
-          "name": "game_libraries_base_game_id_owner_steam_id_pk",
-          "columns": [
-            "base_game_id",
-            "owner_steam_id"
-          ]
-        }
-      },
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.steam_accounts": {
-      "name": "steam_accounts",
-      "schema": "",
-      "columns": {
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "id": {
-          "name": "id",
-          "type": "varchar(255)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "user_id": {
-          "name": "user_id",
-          "type": "char(30)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "status": {
-          "name": "status",
-          "type": "steam_status",
-          "typeSchema": "public",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "last_synced_at": {
-          "name": "last_synced_at",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "real_name": {
-          "name": "real_name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "member_since": {
-          "name": "member_since",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "profile_url": {
-          "name": "profile_url",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "avatar_hash": {
-          "name": "avatar_hash",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "limitations": {
-          "name": "limitations",
-          "type": "json",
-          "primaryKey": false,
-          "notNull": true
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {
-        "steam_accounts_user_id_users_id_fk": {
-          "name": "steam_accounts_user_id_users_id_fk",
-          "tableFrom": "steam_accounts",
-          "tableTo": "users",
-          "columnsFrom": [
-            "user_id"
-          ],
-          "columnsTo": [
-            "id"
-          ],
-          "onDelete": "cascade",
-          "onUpdate": "no action"
-        }
-      },
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {},
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    },
-    "public.users": {
-      "name": "users",
-      "schema": "",
-      "columns": {
-        "id": {
-          "name": "id",
-          "type": "char(30)",
-          "primaryKey": true,
-          "notNull": true
-        },
-        "time_created": {
-          "name": "time_created",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_updated": {
-          "name": "time_updated",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true,
-          "default": "now()"
-        },
-        "time_deleted": {
-          "name": "time_deleted",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "email": {
-          "name": "email",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "avatar_url": {
-          "name": "avatar_url",
-          "type": "text",
-          "primaryKey": false,
-          "notNull": false
-        },
-        "last_login": {
-          "name": "last_login",
-          "type": "timestamp with time zone",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "name": {
-          "name": "name",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": true
-        },
-        "polar_customer_id": {
-          "name": "polar_customer_id",
-          "type": "varchar(255)",
-          "primaryKey": false,
-          "notNull": false
-        }
-      },
-      "indexes": {},
-      "foreignKeys": {},
-      "compositePrimaryKeys": {},
-      "uniqueConstraints": {
-        "idx_user_email": {
-          "name": "idx_user_email",
-          "nullsNotDistinct": false,
-          "columns": [
-            "email"
-          ]
-        }
-      },
-      "policies": {},
-      "checkConstraints": {},
-      "isRLSEnabled": false
-    }
-  },
-  "enums": {
-    "public.compatibility": {
-      "name": "compatibility",
-      "schema": "public",
-      "values": [
-        "high",
-        "mid",
-        "low",
-        "unknown"
-      ]
-    },
-    "public.controller_support": {
-      "name": "controller_support",
-      "schema": "public",
-      "values": [
-        "full",
-        "partial",
-        "unknown"
-      ]
-    },
-    "public.category_type": {
-      "name": "category_type",
-      "schema": "public",
-      "values": [
-        "tag",
-        "genre",
-        "publisher",
-        "developer",
-        "categorie",
-        "franchise"
-      ]
-    },
-    "public.image_type": {
-      "name": "image_type",
-      "schema": "public",
-      "values": [
-        "heroArt",
-        "icon",
-        "logo",
-        "banner",
-        "poster",
-        "boxArt",
-        "screenshot",
-        "backdrop"
-      ]
-    },
-    "public.steam_status": {
-      "name": "steam_status",
-      "schema": "public",
-      "values": [
-        "online",
-        "offline",
-        "dnd",
-        "playing"
-      ]
-    }
-  },
-  "schemas": {},
-  "sequences": {},
-  "roles": {},
-  "policies": {},
-  "views": {},
-  "_meta": {
-    "columns": {},
-    "schemas": {},
-    "tables": {}
-  }
-}

packages/core/migrations/meta/_journal.json

@@ -1,188 +0,0 @@
-{
-  "version": "7",
-  "dialect": "postgresql",
-  "entries": [
-    {
-      "idx": 0,
-      "version": "7",
-      "when": 1741759978256,
-      "tag": "0000_flaky_matthew_murdock",
-      "breakpoints": true
-    },
-    {
-      "idx": 1,
-      "version": "7",
-      "when": 1741955636085,
-      "tag": "0001_nifty_sauron",
-      "breakpoints": true
-    },
-    {
-      "idx": 2,
-      "version": "7",
-      "when": 1743794969007,
-      "tag": "0002_simple_outlaw_kid",
-      "breakpoints": true
-    },
-    {
-      "idx": 3,
-      "version": "7",
-      "when": 1744287542918,
-      "tag": "0003_first_big_bertha",
-      "breakpoints": true
-    },
-    {
-      "idx": 4,
-      "version": "7",
-      "when": 1744614629788,
-      "tag": "0004_amused_mattie_franklin",
-      "breakpoints": true
-    },
-    {
-      "idx": 5,
-      "version": "7",
-      "when": 1744614896792,
-      "tag": "0005_aspiring_stature",
-      "breakpoints": true
-    },
-    {
-      "idx": 6,
-      "version": "7",
-      "when": 1744634229644,
-      "tag": "0006_worthless_dreadnoughts",
-      "breakpoints": true
-    },
-    {
-      "idx": 7,
-      "version": "7",
-      "when": 1744634322996,
-      "tag": "0007_warm_secret_warriors",
-      "breakpoints": true
-    },
-    {
-      "idx": 8,
-      "version": "7",
-      "when": 1744651530530,
-      "tag": "0008_third_mindworm",
-      "breakpoints": true
-    },
-    {
-      "idx": 9,
-      "version": "7",
-      "when": 1744651817581,
-      "tag": "0009_luxuriant_wraith",
-      "breakpoints": true
-    },
-    {
-      "idx": 10,
-      "version": "7",
-      "when": 1746726715456,
-      "tag": "0010_certain_dust",
-      "breakpoints": true
-    },
-    {
-      "idx": 11,
-      "version": "7",
-      "when": 1746904821461,
-      "tag": "0011_simple_azazel",
-      "breakpoints": true
-    },
-    {
-      "idx": 12,
-      "version": "7",
-      "when": 1746905730079,
-      "tag": "0012_glorious_jetstream",
-      "breakpoints": true
-    },
-    {
-      "idx": 13,
-      "version": "7",
-      "when": 1746925065142,
-      "tag": "0013_neat_colleen_wing",
-      "breakpoints": true
-    },
-    {
-      "idx": 14,
-      "version": "7",
-      "when": 1746926498096,
-      "tag": "0014_thin_groot",
-      "breakpoints": true
-    },
-    {
-      "idx": 15,
-      "version": "7",
-      "when": 1746928882281,
-      "tag": "0015_handy_giant_man",
-      "breakpoints": true
-    },
-    {
-      "idx": 16,
-      "version": "7",
-      "when": 1747032794033,
-      "tag": "0016_melted_johnny_storm",
-      "breakpoints": true
-    },
-    {
-      "idx": 17,
-      "version": "7",
-      "when": 1747034424687,
-      "tag": "0017_zippy_nico_minoru",
-      "breakpoints": true
-    },
-    {
-      "idx": 18,
-      "version": "7",
-      "when": 1747073173196,
-      "tag": "0018_solid_enchantress",
-      "breakpoints": true
-    },
-    {
-      "idx": 19,
-      "version": "7",
-      "when": 1747202158003,
-      "tag": "0019_charming_namorita",
-      "breakpoints": true
-    },
-    {
-      "idx": 20,
-      "version": "7",
-      "when": 1747795508868,
-      "tag": "0020_vengeful_wallop",
-      "breakpoints": true
-    },
-    {
-      "idx": 21,
-      "version": "7",
-      "when": 1747975397543,
-      "tag": "0021_real_skreet",
-      "breakpoints": true
-    },
-    {
-      "idx": 22,
-      "version": "7",
-      "when": 1748099972605,
-      "tag": "0022_clean_living_lightning",
-      "breakpoints": true
-    },
-    {
-      "idx": 23,
-      "version": "7",
-      "when": 1748411845939,
-      "tag": "0023_flawless_steel_serpent",
-      "breakpoints": true
-    },
-    {
-      "idx": 24,
-      "version": "7",
-      "when": 1748414049463,
-      "tag": "0024_damp_cerise",
-      "breakpoints": true
-    },
-    {
-      "idx": 25,
-      "version": "7",
-      "when": 1748845818197,
-      "tag": "0025_bitter_jack_flag",
-      "breakpoints": true
-    }
-  ]
-}