|
-- Buat tabel users
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
id SERIAL PRIMARY KEY,
|
|
name VARCHAR(100) NOT NULL
|
|
);
|
|
|
|
-- Tambah data awal
|
|
INSERT INTO users (name) VALUES
|
|
('Maryam'),
|
|
('Rudy'),
|
|
('Julien'),
|
|
('Susan'),
|
|
('Luna'),
|
|
('Adelya'),
|
|
('Aisha'),
|
|
('Bobon'),
|
|
('Citra');
|