mirror of
https://github.com/Tony0410/readlater.git
synced 2026-05-24 13:52:03 +08:00
27963af055
- Save articles via URL or bookmarklet - Clean dark reader with customizable fonts/sizing - Text-to-speech with browser + Kokoro support - Speed control up to 3x - Favorites and archive - SQLite database with Drizzle ORM - Docker deployment ready Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
20 lines
477 B
SQL
20 lines
477 B
SQL
CREATE TABLE `articles` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`url` text NOT NULL,
|
|
`title` text NOT NULL,
|
|
`author` text,
|
|
`site_name` text,
|
|
`excerpt` text,
|
|
`content` text NOT NULL,
|
|
`text_content` text NOT NULL,
|
|
`lead_image` text,
|
|
`word_count` integer DEFAULT 0,
|
|
`reading_progress` integer DEFAULT 0,
|
|
`is_favorite` integer DEFAULT false,
|
|
`is_archived` integer DEFAULT false,
|
|
`tags` text DEFAULT '[]',
|
|
`created_at` integer,
|
|
`updated_at` integer,
|
|
`read_at` integer
|
|
);
|