NobGit
public imalexnord read

Slot

Calendar-first scheduling powered by Cloudflare Workers and Google Calendar.

Languages

Repository composition by tracked source files.

TypeScript
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
0004_booking_management.sql
ALTER TABLE bookings ADD COLUMN rescheduled_at TEXT;
ALTER TABLE bookings ADD COLUMN reschedule_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE bookings ADD COLUMN proposed_start_time TEXT;
ALTER TABLE bookings ADD COLUMN proposed_end_time TEXT;
ALTER TABLE bookings ADD COLUMN proposed_at TEXT;
ALTER TABLE bookings ADD COLUMN proposal_status TEXT;
ALTER TABLE bookings ADD COLUMN proposal_token_hash TEXT;
ALTER TABLE bookings ADD COLUMN refund_status TEXT NOT NULL DEFAULT 'not_requested';
ALTER TABLE bookings ADD COLUMN stripe_refund_id TEXT;
ALTER TABLE bookings ADD COLUMN refunded_amount INTEGER;
ALTER TABLE bookings ADD COLUMN refunded_at TEXT;

CREATE INDEX IF NOT EXISTS idx_bookings_proposal_token_hash ON bookings(proposal_token_hash);
CREATE INDEX IF NOT EXISTS idx_bookings_refund_status ON bookings(refund_status);