From 2ad5ce929f6d69c9aaca71573744b30e02ab8bed Mon Sep 17 00:00:00 2001 From: Yuval Adam <_@yuv.al> Date: Fri, 27 Jun 2025 10:10:56 +0200 Subject: Add cloudflare basic impl --- schema.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 schema.sql (limited to 'schema.sql') 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 -- cgit v1.3.1