public
imalexnord
read
Slot
Calendar-first scheduling powered by Cloudflare Workers and Google Calendar.
Languages
Repository composition by tracked source files.
TypeScript
79%
CSS
19%
SQL
2%
HTML
0%
Create file
Wiki Documentation
Clone
https://nobgit.com/user/imalexnord/slot.git
ssh://[email protected]:2222/user/imalexnord/slot.git
Trace
migrations/0002_cancellation_and_availability_blocks.sql
Trace helps you understand code history line by line. See who changed each line, when it changed, and which commit introduced it.
Author
Date
Commit
Line
Code
1
ALTER TABLE bookings ADD COLUMN cancelled_at TEXT;
2
ALTER TABLE bookings ADD COLUMN updated_at TEXT;
3
ALTER TABLE bookings ADD COLUMN calendar_provider TEXT NOT NULL DEFAULT 'google';
4
ALTER TABLE bookings ADD COLUMN calendar_sync_status TEXT NOT NULL DEFAULT 'synced';
5
ALTER TABLE bookings ADD COLUMN calendar_sync_error TEXT;
6
ALTER TABLE bookings ADD COLUMN calendar_sync_updated_at TEXT;
8
CREATE TABLE IF NOT EXISTS recurring_unavailable_periods (
9
id TEXT PRIMARY KEY,
10
weekdays TEXT NOT NULL,
11
start_time TEXT NOT NULL,
12
end_time TEXT NOT NULL,
13
label TEXT,
14
created_at TEXT NOT NULL DEFAULT (datetime('now')),
15
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
16
);
18
CREATE TABLE IF NOT EXISTS availability_blocks (
19
id TEXT PRIMARY KEY,
20
date TEXT NOT NULL,
21
start_time TEXT,
22
end_time TEXT,
23
all_day INTEGER NOT NULL DEFAULT 0,
24
label TEXT,
25
created_at TEXT NOT NULL DEFAULT (datetime('now')),
26
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
27
);
29
CREATE INDEX IF NOT EXISTS idx_recurring_unavailable_periods_weekdays ON recurring_unavailable_periods(weekdays);
30
CREATE INDEX IF NOT EXISTS idx_availability_blocks_date ON availability_blocks(date);
31
CREATE INDEX IF NOT EXISTS idx_bookings_sync_status ON bookings(calendar_sync_status);