| 1 |
|
| 2 |
|
| 3 |
|
| 4 |
CREATE TABLE labels ( |
| 5 |
id UUID PRIMARY KEY DEFAULT gen_random_uuid(), |
| 6 |
slug VARCHAR(100) NOT NULL UNIQUE, |
| 7 |
display_name VARCHAR(100) NOT NULL, |
| 8 |
definition TEXT NOT NULL, |
| 9 |
examples TEXT NOT NULL DEFAULT '', |
| 10 |
nonexamples TEXT NOT NULL DEFAULT '', |
| 11 |
sort_order INT NOT NULL DEFAULT 0, |
| 12 |
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW() |
| 13 |
); |
| 14 |
|
| 15 |
CREATE TABLE project_labels ( |
| 16 |
project_id UUID NOT NULL REFERENCES projects(id) ON DELETE CASCADE, |
| 17 |
label_id UUID NOT NULL REFERENCES labels(id) ON DELETE CASCADE, |
| 18 |
confirmed_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), |
| 19 |
PRIMARY KEY (project_id, label_id) |
| 20 |
); |
| 21 |
|
| 22 |
CREATE INDEX idx_project_labels_label_id ON project_labels(label_id); |
| 23 |
|
| 24 |
|
| 25 |
INSERT INTO labels (slug, display_name, definition, examples, nonexamples, sort_order) VALUES |
| 26 |
('drm-free', 'DRM-Free', 'All content is delivered without digital rights management restrictions. Buyers own what they purchase with no usage limits, device locks, or online check-ins.', 'Direct file downloads, unrestricted MP3/FLAC, DRM-free PDF/EPUB', 'Streaming-only access, license key activation limits, cloud-locked content', 1), |
| 27 |
('lifetime-warranty', 'Lifetime Warranty', 'The creator commits to fixing bugs and compatibility issues for the lifetime of the product. Does not require adding new features, only maintaining what was sold.', 'Bug fixes for sold software, compatibility patches for new OS versions', 'Free major version upgrades, unlimited feature requests, guaranteed response times', 2), |
| 28 |
('no-llms-used', 'No LLMs Used', 'No large language models or generative AI were used in creating this content. All writing, code, art, and audio are human-made.', 'Hand-written code, human-composed music, hand-drawn illustrations', 'AI-assisted code completion, AI-generated placeholder text later edited, AI upscaling', 3), |
| 29 |
('no-tracking', 'No Tracking', 'No analytics, telemetry, or user behavior tracking of any kind. No data is collected about how buyers use the product.', 'Fully offline software, static websites with no analytics, local-only apps', 'Anonymous usage stats, crash reporting, feature flag systems that phone home', 4), |
| 30 |
('ad-free', 'Ad-Free', 'The product contains no advertisements, sponsored content, or affiliate links. Revenue comes entirely from direct sales.', 'Clean podcast episodes, ad-free articles, software with no upsell banners', 'Sponsored segments, affiliate links in show notes, in-app purchase prompts', 5), |
| 31 |
('offline-capable', 'Offline-Capable', 'The product works fully without an internet connection after initial download or setup. No features are gated behind online access.', 'Desktop apps that work offline, downloadable reference guides, local-first software', 'Web apps that cache some data, apps that need login to unlock features, streaming services with download', 6), |
| 32 |
('source-available', 'Source Available', 'The complete source code is available for inspection. Users can read, audit, and learn from the code. Does not require a specific open-source license.', 'Public git repository, source included with purchase, published build scripts', 'Obfuscated source, decompilable binaries, API documentation only', 7), |
| 33 |
('no-subscription', 'No Subscription', 'One-time purchase only. No recurring fees, no expiring access, no subscription upsells. Pay once, own forever.', 'Buy-once software, permanent course access, one-time font license', 'Annual license renewals, subscription tiers, time-limited access codes', 8), |
| 34 |
('solo-dev', 'Solo Dev', 'Made entirely by one person. No employees, contractors, or outsourced work. One human, start to finish.', 'One-person indie games, solo musician albums, single-author books', 'Small team projects credited to one person, freelancer-assisted work, label/publisher backed', 9), |
| 35 |
('accessible', 'Accessible', 'Designed with accessibility in mind. Meets WCAG 2.1 AA or equivalent standards where applicable. Includes alt text, keyboard navigation, screen reader support, and sufficient contrast.', 'Keyboard-navigable apps, captioned videos, screen-reader-tested websites', 'Decorative alt text only, partial keyboard support, untested with assistive technology', 10); |
| 36 |
|