19 lines
640 B
Dart
19 lines
640 B
Dart
/// SQL schema for the series_two_page_mode table
|
|
class SeriesToPageModeTable {
|
|
SeriesToPageModeTable._();
|
|
|
|
static const String tableName = 'series_two_page_mode';
|
|
|
|
/// SQL statement to create the series_two_page_mode table
|
|
static const String createTable = '''
|
|
CREATE TABLE $tableName (
|
|
series_feed_url TEXT PRIMARY KEY,
|
|
two_page_mode TEXT NOT NULL,
|
|
created_at TEXT NOT NULL DEFAULT (datetime('now')),
|
|
last_accessed_at TEXT NOT NULL DEFAULT (datetime('now'))
|
|
)
|
|
''';
|
|
|
|
/// SQL statement to drop the series_two_page_mode table
|
|
static const String dropTable = 'DROP TABLE IF EXISTS $tableName';
|
|
}
|