5 lines
275 B
SQL
5 lines
275 B
SQL
-- Create "users" table
|
|
CREATE TABLE "users" ("id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, "name" character varying NOT NULL, PRIMARY KEY ("id"));
|
|
-- Create index "unique_name" to table: "users"
|
|
CREATE UNIQUE INDEX "unique_name" ON "users" ((lower((name)::text)));
|