22 lines
558 B
Dart
22 lines
558 B
Dart
/// SQL schema for the servers table
|
|
class ServersTable {
|
|
ServersTable._();
|
|
|
|
static const String tableName = 'servers';
|
|
|
|
/// SQL statement to create the servers table
|
|
static const String createTable = '''
|
|
CREATE TABLE $tableName (
|
|
id TEXT PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
url TEXT NOT NULL,
|
|
username TEXT,
|
|
password TEXT,
|
|
created_at INTEGER NOT NULL,
|
|
last_synced_at INTEGER
|
|
)
|
|
''';
|
|
|
|
/// SQL statement to drop the servers table
|
|
static const String dropTable = 'DROP TABLE IF EXISTS $tableName';
|
|
}
|