35 lines
1.2 KiB
SQL
35 lines
1.2 KiB
SQL
CREATE TABLE u3c3 (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
category TEXT,
|
|
title TEXT,
|
|
url TEXT UNIQUE,
|
|
torrent_url TEXT,
|
|
magnet_url TEXT,
|
|
size_text TEXT,
|
|
size_gb REAL,
|
|
update_date TEXT,
|
|
created_at TEXT DEFAULT (datetime('now', 'localtime')),
|
|
updated_at TEXT DEFAULT (datetime('now', 'localtime'))
|
|
);
|
|
CREATE TABLE sqlite_sequence(name,seq);
|
|
CREATE TABLE sis (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
plate_name TEXT,
|
|
title TEXT,
|
|
url TEXT UNIQUE,
|
|
size_text TEXT,
|
|
size_gb REAL,
|
|
update_date TEXT,
|
|
created_at TEXT DEFAULT (datetime('now', 'localtime')),
|
|
updated_at TEXT DEFAULT (datetime('now', 'localtime'))
|
|
);
|
|
CREATE TABLE pbox_studios (
|
|
id INTEGER PRIMARY KEY,
|
|
label_id INTEGER,
|
|
name TEXT,
|
|
description TEXT,
|
|
thumbnail TEXT,
|
|
scene_count INTEGER,
|
|
created_at TIMESTAMP
|
|
);
|