diff options
| author | Yuval Adam <_@yuv.al> | 2025-06-27 10:10:56 +0200 |
|---|---|---|
| committer | Yuval Adam <_@yuv.al> | 2025-06-27 10:10:56 +0200 |
| commit | 2ad5ce929f6d69c9aaca71573744b30e02ab8bed (patch) | |
| tree | 078cd3b8a968ebfd99e86492abb9564f183ec21a /schema.sql | |
| parent | 0282fb367ecfd3864cf94c27a44961a61e2ff6f2 (diff) | |
Add cloudflare basic impl
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 15 |
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 |
