Back

Version 3

6/21/2024
import { sqlite } from "https://esm.town/v/std/sqlite";
import { sql } from "npm:drizzle-orm";
import { drizzle } from "npm:drizzle-orm/libsql";
import { integer, sqliteTable, text } from "npm:drizzle-orm/sqlite-core";

await sqlite.execute(`CREATE TABLE owned_games (
id integer PRIMARY KEY NOT NULL,
date text DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
appid integer NOT NULL,
playtime_forever integer NOT NULL,
playtime_windows_forever integer NOT NULL,
playtime_mac_forever integer NOT NULL,
playtime_linux_forever integer NOT NULL,
playtime_deck_forever integer NOT NULL
rtime_last_played integer NOT NULL,
playtime_disconnected integer NOT NULL
);
`);
Updated: June 21, 2024