11 lines
475 B
SQL
11 lines
475 B
SQL
CREATE TABLE "users" (
|
|
"id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "users_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
|
|
"socialClub" varchar(255) NOT NULL,
|
|
"email" varchar(255) NOT NULL,
|
|
"login" varchar(255) NOT NULL,
|
|
"password" varchar(255) NOT NULL,
|
|
CONSTRAINT "users_socialClub_unique" UNIQUE("socialClub"),
|
|
CONSTRAINT "users_email_unique" UNIQUE("email"),
|
|
CONSTRAINT "users_login_unique" UNIQUE("login")
|
|
);
|