horoli
e358e24436
Import the 2026-10-09 source release, Fastify/SQLite backend, restored source assets, and analytics-enabled server build. Replace files from the previous release while retaining the existing repository history. Make builds portable across Windows and Linux, configure local startup, normalize Windows static asset paths, and fix test fixture cleanup and file URL handling. Exclude local environment settings, databases, dependencies, validation output, and TypeScript build cache from version control. Validation: npm ci, static and server builds, 106 arrival tests, and actual local HTTP checks passed. The full suite passed 467 of 470 tests; three tests still require QA fixtures omitted from the supplied release, documented in README-서버실행.md.
13 lines
356 B
SQL
13 lines
356 B
SQL
CREATE TABLE visitors_daily (
|
|
visitor_id TEXT NOT NULL,
|
|
visit_date TEXT NOT NULL,
|
|
first_seen_at TEXT NOT NULL,
|
|
last_seen_at TEXT NOT NULL,
|
|
PRIMARY KEY (visitor_id, visit_date)
|
|
);
|
|
CREATE INDEX visitors_daily_visit_date ON visitors_daily (visit_date);
|
|
CREATE TABLE arrivals (
|
|
dog_id TEXT PRIMARY KEY NOT NULL,
|
|
first_arrived_at TEXT NOT NULL
|
|
);
|