short/sql/migrations/20240129183014_create_url_table.sql

5 lines
258 B
MySQL
Raw Permalink Normal View History

2024-01-29 18:32:01 +00:00
-- Create "urls" table
CREATE TABLE "public"."urls" ("id" serial NOT NULL, "hash" text NOT NULL, "long_url" text NOT NULL, PRIMARY KEY ("id"));
-- Create index "urls_hash_key" to table: "urls"
CREATE UNIQUE INDEX "urls_hash_key" ON "public"."urls" ("hash");