10 lines
259 B
SQL
10 lines
259 B
SQL
CREATE TABLE IF NOT EXISTS users (
|
|
id SERIAL PRIMARY KEY,
|
|
name VARCHAR(100),
|
|
email VARCHAR(100) UNIQUE
|
|
);
|
|
|
|
INSERT INTO users (name, email) VALUES
|
|
('Alice', 'alice@example.com'),
|
|
('Bob', 'bob@example.com')
|
|
ON CONFLICT (email) DO NOTHING; |