Query

database.db — events

+/- table definition

Query 

CREATE TABLE `events`  (
  id VARCHAR(100) NOT NULL UNIQUE,
  title VARCHAR(255) NOT NULL,
  begin DATETIME NOT NULL,
  end DATETIME NOT NULL,
  lastBooking DATETIME NOT NULL,
  maxApplicants INT(4) NOT NULL,
  bookings INT(4),
  location VARCHAR(500),
  description VARCHAR(500),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop