diff options
Diffstat (limited to 'users/grfn/bbbg/resources/migrations')
6 files changed, 0 insertions, 57 deletions
diff --git a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.down.sql b/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.down.sql deleted file mode 100644 index 69b818a4f4ab..000000000000 --- a/users/grfn/bbbg/resources/migrations/20211212165646-init-schema.down.sql +++ /dev/null @@ -1,14 +0,0 @@ -drop table "public"."user"; - --- ;; - -drop table "public"."event_attendee"; - - --- ;; - -drop table "public"."event"; - --- ;; - -drop table "public"."attendee"; 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() -); diff --git a/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.down.sql b/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.down.sql deleted file mode 100644 index 936abf6c7d19..000000000000 --- a/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.down.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE "attendee_check"; diff --git a/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql b/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql deleted file mode 100644 index 5e82dcb1711c..000000000000 --- a/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE attendee_check ( - "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(), - "attendee_id" UUID NOT NULL REFERENCES attendee ("id"), - "user_id" UUID NOT NULL REFERENCES "public"."user" ("id"), - "last_dose_at" DATE, - "checked_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now() -); diff --git a/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.down.sql b/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.down.sql deleted file mode 100644 index cbee0c00acd9..000000000000 --- a/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.down.sql +++ /dev/null @@ -1 +0,0 @@ -drop index attendee_uniq_meetup_user_id; diff --git a/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.up.sql b/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.up.sql deleted file mode 100644 index 5895cad56bdf..000000000000 --- a/users/grfn/bbbg/resources/migrations/20211224161028-add-attendee-unique-meetup-id.up.sql +++ /dev/null @@ -1,2 +0,0 @@ -create unique index "attendee_uniq_meetup_user_id" on attendee (meetup_user_id); --- ;; |