CREATE TABLE IF NOT EXISTS player_join_notice_state (
player_id TEXT PRIMARY KEY,
first_seen_at INTEGER NOT NULL,
last_seen_at INTEGER NOT NULL,
last_daily_date TEXT
);
CREATE INDEX IF NOT EXISTS player_join_notice_last_seen_idx
ON player_join_notice_state(last_seen_at);
CREATE TABLE IF NOT EXISTS player_join_notice_state (
player_id TEXT PRIMARY KEY,
first_seen_at INTEGER NOT NULL,
last_seen_at INTEGER NOT NULL,
last_daily_date TEXT
);
CREATE INDEX IF NOT EXISTS player_join_notice_last_seen_idx
ON player_join_notice_state(last_seen_at);