about summary refs log tree commit diff
path: root/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
diff options
context:
space:
mode:
authorAspen Smith <grfn@gws.fyi>2024-02-12T03·00-0500
committerclbot <clbot@tvl.fyi>2024-02-14T19·37+0000
commit82ecd61f5c699cf3af6c4eadf47a1c52b1d696c6 (patch)
tree429c5e078528000591742ec3211bc768ae913a78 /users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
parent0ba476a4266015f278f18d74094299de74a5a111 (diff)
chore(users): grfn -> aspen r/7511
Change-Id: I6c6847fac56f0a9a1a2209792e00a3aec5e672b9
Reviewed-on: https://cl.tvl.fyi/c/depot/+/10809
Autosubmit: aspen <root@gws.fyi>
Reviewed-by: sterni <sternenseemann@systemli.org>
Tested-by: BuildkiteCI
Reviewed-by: lukegb <lukegb@tvl.fyi>
Diffstat (limited to 'users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql')
-rw-r--r--users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql32
1 files changed, 0 insertions, 32 deletions
diff --git a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql b/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
deleted file mode 100644
index 9718d84748ae..000000000000
--- a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.up.sql
+++ /dev/null
@@ -1,32 +0,0 @@
-CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
--- ;;
-CREATE TABLE "attendee" (
-    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
-    "meetup_name" TEXT NOT NULL,
-    "discord_name" TEXT,
-    "meetup_user_id" TEXT,
-    "organizer_notes" TEXT NOT NULL DEFAULT '',
-    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
-);
--- ;;
-CREATE TABLE "event" (
-    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
-    "date" DATE NOT NULL,
-    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
-);
--- ;;
-CREATE TABLE "event_attendee" (
-    "event_id" UUID NOT NULL REFERENCES "event" ("id"),
-    "attendee_id" UUID NOT NULL REFERENCES "attendee" ("id"),
-    "rsvpd_attending" BOOL,
-    "attended" BOOL,
-    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
-    PRIMARY KEY ("event_id", "attendee_id")
-);
--- ;;
-CREATE TABLE "user" (
-    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
-    "username" TEXT NOT NULL,
-    "discord_user_id" TEXT NOT NULL,
-    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
-);