Public
Like
trmnl-lastfm
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
app.get("/db/create", async (c) => {
await sqlite.execute(`create table if not exists lastfm_installations (
uuid varchar(255) PRIMARY KEY not null,
active boolean not null default 0,
lastfm_connected boolean not null default 0,
name varchar(255) null,
first_name varchar(255) null,
last_name varchar(255) null,
email varchar(255) null,
locale varchar(255) null,
time_zone_iana varchar(255) null,
plugin_setting_id INTEGER null,
trmnl_access_token varchar(255) null,
lastfm_session varchar(255) null,
preferences text not null,
uninstalled_at datetime null,
created_at datetime not null default CURRENT_TIMESTAMP,
updated_at datetime not null default CURRENT_TIMESTAMP
)`);
return c.text("ok");
});