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