13 lines
555 B
SQL
13 lines
555 B
SQL
CREATE TABLE IF NOT EXISTS portofolio_testimonials (
|
|
id SERIAL PRIMARY KEY,
|
|
portofolio_section_id INT REFERENCES portofolio_sections(id) ON DELETE CASCADE,
|
|
client_name varchar(150),
|
|
thumbnail varchar(200),
|
|
message text,
|
|
role varchar(100),
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
|
|
deleted_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE INDEX idx_portofolio_testimonials_portofolio_section_id ON portofolio_testimonials(portofolio_section_id); |