Unlisted
Like
1
trmnl-spotify
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.
Viewing readonly version of main branch: v56View latest version
app.get("/db/create", async (c) => {
await sqlite.execute(`create table if not exists installations (
id INTEGER PRIMARY KEY AUTOINCREMENT not null,
active boolean not null default 0,
deleted boolean not null default 0,
name varchar(255) not null,
first_name varchar(255) not null,
last_name varchar(255) not null,
email varchar(255) not null,
locale varchar(255) not null,
time_zone_iana varchar(255) not null,
plugin_setting_id INTEGER not null,
uuid varchar(255) not null,
access_token varchar(255) not null,
created_at datetime not null default CURRENT_TIMESTAMP,
updated_at datetime not null default CURRENT_TIMESTAMP,
uninstalled_at datetime null
)`);
return c.text("ok");
});