FM / migrations

/opt/canhelp/packages/db/migrations

Name	Size	Mode	Actions
meta/	-	0755	rm
0000_organic_ultimo.sql	23071	0644	edit dl rm
0001_demonic_vertigo.sql	272	0644	edit dl rm
0002_tricky_wild_child.sql	1116	0644	edit dl rm
0003_absent_carlie_cooper.sql	67	0644	edit dl rm
0004_clean_kid_colt.sql	857	0644	edit dl rm
0005_support_tickets.sql	821	0644	edit dl rm
0006_plan_history.sql	453	0644	edit dl rm
0007_unknown_ricochet.sql	1179	0644	edit dl rm
0008_massive_cable.sql	68	0644	edit dl rm
0009_talented_stepford_cuckoos.sql	372	0644	edit dl rm
0010_gorgeous_ironclad.sql	387	0644	edit dl rm
0011_gifted_nightcrawler.sql	107	0644	edit dl rm
0012_quiet_santa_claus.sql	65	0644	edit dl rm
0013_single_role_unification.sql	732	0644	edit dl rm
0014_jazzy_menace.sql	59	0644	edit dl rm
0015_moaning_nightshade.sql	1736	0644	edit dl rm
0016_gorgeous_maximus.sql	93	0644	edit dl rm
0017_outstanding_daimon_hellstrom.sql	557	0644	edit dl rm
0018_price_list_i18n.sql	2808	0644	edit dl rm
0019_typical_harry_osborn.sql	2417	0644	edit dl rm
0020_simple_queen_noir.sql	190	0644	edit dl rm
0021_specialist_card_publication_status.sql	426	0644	edit dl rm
0022_youthful_brother_voodoo.sql	1594	0644	edit dl rm

Edit: /opt/canhelp/packages/db/migrations/0019_typical_harry_osborn.sql (2417B)

CREATE TABLE "push_tokens" (
	"id" text PRIMARY KEY NOT NULL,
	"user_id" text NOT NULL,
	"token" text NOT NULL,
	"platform" text DEFAULT 'unknown' NOT NULL,
	"locale" varchar(5),
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_el" text;--> statement-breakpoint
ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_en" text;--> statement-breakpoint
ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_ru" text;--> statement-breakpoint
ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_uk" text;--> statement-breakpoint
ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "original_locale" varchar(5) DEFAULT 'el' NOT NULL;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_el" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_en" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_ru" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_uk" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_el" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_en" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_ru" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_uk" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_el" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_en" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_ru" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_uk" text;--> statement-breakpoint
ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "original_locale" varchar(5) DEFAULT 'el' NOT NULL;--> statement-breakpoint
ALTER TABLE "push_tokens" ADD CONSTRAINT "push_tokens_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE UNIQUE INDEX "push_tokens_token_uq" ON "push_tokens" USING btree ("token");

CREATE TABLE "push_tokens" ( "id" text PRIMARY KEY NOT NULL, "user_id" text NOT NULL, "token" text NOT NULL, "platform" text DEFAULT 'unknown' NOT NULL, "locale" varchar(5), "created_at" timestamp DEFAULT now() NOT NULL, "updated_at" timestamp DEFAULT now() NOT NULL ); --> statement-breakpoint ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_el" text;--> statement-breakpoint ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_en" text;--> statement-breakpoint ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_ru" text;--> statement-breakpoint ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "title_uk" text;--> statement-breakpoint ALTER TABLE "price_list_groups" ADD COLUMN IF NOT EXISTS "original_locale" varchar(5) DEFAULT 'el' NOT NULL;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_el" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_en" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_ru" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "name_uk" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_el" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_en" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_ru" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "description_uk" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_el" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_en" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_ru" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "unit_uk" text;--> statement-breakpoint ALTER TABLE "price_list_items" ADD COLUMN IF NOT EXISTS "original_locale" varchar(5) DEFAULT 'el' NOT NULL;--> statement-breakpoint ALTER TABLE "push_tokens" ADD CONSTRAINT "push_tokens_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint CREATE UNIQUE INDEX "push_tokens_token_uq" ON "push_tokens" USING btree ("token");