this repo has no description
1-- SQLite Schema for Tumble
2-- Translated from MySQL schema in migrations file
3
4-- Migration 001: Initial schema
5CREATE TABLE IF NOT EXISTS image (
6 imageID INTEGER PRIMARY KEY AUTOINCREMENT,
7 timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
8 title TEXT NOT NULL DEFAULT '',
9 link TEXT NOT NULL DEFAULT '',
10 url TEXT NOT NULL,
11 md5sum TEXT NOT NULL DEFAULT ''
12);
13
14CREATE INDEX IF NOT EXISTS idx_image_id ON image(imageID);
15
16CREATE TABLE IF NOT EXISTS ircLink (
17 ircLinkID INTEGER PRIMARY KEY AUTOINCREMENT,
18 timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
19 user TEXT NOT NULL DEFAULT '',
20 title TEXT NOT NULL DEFAULT '',
21 url TEXT NOT NULL,
22 clicks INTEGER NOT NULL DEFAULT 0,
23 content_type TEXT
24);
25
26CREATE INDEX IF NOT EXISTS idx_irclink_id ON ircLink(ircLinkID);
27
28-- Note: SQLite doesn't have native FULLTEXT like MySQL's MyISAM
29-- The tumble::DB::SQLite driver uses LIKE-based search instead
30-- For better performance, consider using FTS5 virtual tables in the future
31
32CREATE TABLE IF NOT EXISTS quote (
33 quoteID INTEGER PRIMARY KEY AUTOINCREMENT,
34 timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
35 quote TEXT NOT NULL DEFAULT '',
36 author TEXT NOT NULL DEFAULT ''
37);
38
39CREATE INDEX IF NOT EXISTS idx_quote_id ON quote(quoteID);
40
41