13 lines
376 B
SQL
13 lines
376 B
SQL
-- Table Definition ----------------------------------------------
|
|
|
|
CREATE TABLE product
|
|
(
|
|
id BIGSERIAL PRIMARY KEY,
|
|
name text NOT NULL UNIQUE,
|
|
created_at timestamp with time zone,
|
|
updated_at timestamp with time zone
|
|
);
|
|
|
|
-- Indices -------------------------------------------------------
|
|
|
|
CREATE INDEX idx_product_name ON product (name text_ops); |