mirror of
https://github.com/hanzo-apps/helpdesk-deskline.git
synced 2026-10-30 19:14:59 +00:00
zeekay
9593c89ff6
Vite + React 19 + @hanzo/gui + @hanzo/iam (PKCE) + @hanzo/base. Three views — ticket queue, ticket detail + replies, new ticket — over two org-scoped Base collections (tickets, replies). Split list/detail with severity + status badges and one-tap triage. Forked from hanzo-apps/hanzo-starter; provider stack, vite.config, auth flow, and deploy contract identical.
30 lines
1.3 KiB
SQL
30 lines
1.3 KiB
SQL
-- Hanzo Base schema for Deskline — the `databaseSchema` DDL.
|
|
--
|
|
-- On publish, Hanzo Cloud translates each CREATE TABLE into a Hanzo Base
|
|
-- collection via `provisionBaseFromDDL` (additive + idempotent). Base manages
|
|
-- id/created/updated/owner/org itself, so they are never re-declared here.
|
|
-- Every row is stamped with the verified IAM owner+org and is org-scoped: Base
|
|
-- applies the list/view/create/update/delete rule `@request.auth.org_id = org`,
|
|
-- so a member of your org reads/writes the row and other orgs cannot see it.
|
|
--
|
|
-- Keep this in lockstep with what the app reads/writes
|
|
-- (src/lib/tickets.ts + src/views/queue.tsx · detail.tsx · compose.tsx).
|
|
|
|
-- Support tickets — the rows in the queue.
|
|
CREATE TABLE IF NOT EXISTS tickets (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
subject TEXT NOT NULL,
|
|
body TEXT NOT NULL DEFAULT '',
|
|
status TEXT NOT NULL DEFAULT 'open', -- open | pending | resolved | closed
|
|
priority TEXT NOT NULL DEFAULT 'normal', -- urgent | high | normal | low
|
|
requester TEXT NOT NULL DEFAULT ''
|
|
);
|
|
|
|
-- Replies — the conversation thread on a ticket (replies.ticket = tickets.id).
|
|
CREATE TABLE IF NOT EXISTS replies (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
ticket TEXT NOT NULL,
|
|
body TEXT NOT NULL,
|
|
author TEXT NOT NULL DEFAULT ''
|
|
);
|