summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorYuval Adam <_@yuv.al>2025-06-27 10:10:56 +0200
committerYuval Adam <_@yuv.al>2025-06-27 10:10:56 +0200
commit2ad5ce929f6d69c9aaca71573744b30e02ab8bed (patch)
tree078cd3b8a968ebfd99e86492abb9564f183ec21a /schema.sql
parent0282fb367ecfd3864cf94c27a44961a61e2ff6f2 (diff)
Add cloudflare basic impl
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..15bdacb
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,15 @@
+-- Create a simple tasks table for our POC
+CREATE TABLE IF NOT EXISTS tasks (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ title TEXT NOT NULL,
+ description TEXT,
+ completed BOOLEAN DEFAULT FALSE,
+ created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+ updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
+);
+
+-- Insert some sample data
+INSERT INTO tasks (title, description) VALUES
+ ('Set up Cloudflare Workers', 'Configure the worker environment'),
+ ('Create D1 database', 'Set up the database schema'),
+ ('Build API endpoints', 'Create REST API for tasks'); \ No newline at end of file