Database Queries

Create val
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");
});