1 files changed, 28 insertions, 0 deletions
diff --git a/migrations/20240321225523_init.up.sql b/migrations/20240321225523_init.up.sql
new file mode 100644
index 0000000..f3ee628
--- /dev/null
+++ b/migrations/20240321225523_init.up.sql
@@ -0,0 +1,28 @@
+-- Add up migration script here
+
+CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
+
+CREATE TABLE users (
+	id UUID NOT NULL PRIMARY KEY DEFAULT (uuid_generate_v4()),
+	name VARCHAR(100) NOT NULL,
+	email VARCHAR(255) NOT NULL UNIQUE,
+	password VARCHAR(100) NOT NULL,
+	created_at TIMESTAMP
+	WITH
+		TIME ZONE DEFAULT NOW(),
+		updated_at TIMESTAMP
+	WITH
+		TIME ZONE DEFAULT NOW()
+);
+
+CREATE INDEX users_email_idx ON users (email);
+
+INSERT INTO users (
+	name,
+	email,
+	password
+) VALUES(
+	'Arthur Dent',
+	'adent@hitchhikers.com',
+	'42'
+);