13 lines
383 B
SQL
13 lines
383 B
SQL
-- CREATE DATABASE "secnex_PRD";
|
|
|
|
CREATE SCHEMA IF NOT EXISTS "support";
|
|
|
|
CREATE TABLE IF NOT EXISTS "public"."user" (
|
|
"id" SERIAL PRIMARY KEY,
|
|
"name" VARCHAR(255) NOT NULL,
|
|
"email" VARCHAR(255) NOT NULL,
|
|
"password" VARCHAR(255) NOT NULL,
|
|
"created_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updated_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|