Changeset 91094a4 in Klonkt for src/config/database.js

Timestamp:

06/19/2026 01:09:15 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

37edecd

Parents:

2e247e4

Message:

Download-for-email (premium feature #2)

Fan leaves their email -> receives the file; address is added to the mailing list
(source 'download', single opt-in so the download is not behind a confirm barrier).
Reuses SubscriberService (#1).

• DB: audio_tracks.downloadable (default 0).
• admin-audio: per-track no-JS toggle (POST /admin/audio/:id/downloadable) + ⬇ button in the admin list (premium-gated); downloadable also in the /api/:id whitelist.
• routes/download.js (premium-gated): GET /downloads (list), GET /download/:id (capture page), POST /download/:id (save email + session grant), GET /download/:id/bestand (serves attachment from storage/audio, 15-min session window, path-traversal guards).
• views: pages/downloads.ejs + pages/download.ejs (form/ready, auto-start download).
• admin dashboard: ⬇ Downloads link (premium, non-hub).

node --check passed. Nothing else reuses this; #8 notify reuses subscribers.

Co-Authored-By: Claude <noreply@…>

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -87 +87 @@
   ensureColumn('posts', 'view_count', 'INTEGER DEFAULT 0');         // weergaven per post
   ensureColumn('audio_tracks', 'play_count', 'INTEGER DEFAULT 0');  // plays per track
+  ensureColumn('audio_tracks', 'downloadable', 'INTEGER DEFAULT 0'); // download-voor-email (premium #2)
 
   // Playlists (v9 feature) — first-class entity. CREATE IF NOT EXISTS is