11 lines
319 B
SQL
11 lines
319 B
SQL
CREATE TABLE IF NOT EXISTS analytics (
|
|
id TEXT PRIMARY KEY NOT NULL,
|
|
placeId INTEGER NOT NULL,
|
|
revision INTEGER NOT NULL,
|
|
startupTime INTEGER NOT NULL,
|
|
serverDuration INTEGER NOT NULL DEFAULT 0,
|
|
endTime INTEGER DEFAULT NULL,
|
|
shutdownReason TEXT DEFAULT NULL,
|
|
allPlayers BLOB ,
|
|
heartbeatCheck INTEGER NOT NULL
|
|
) |