Query

database.db — events

SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(100) Rename | Drop
title VARCHAR(255) Rename | Drop
begin DATETIME Rename | Drop
end DATETIME Rename | Drop
lastBooking DATETIME Rename | Drop
maxApplicants INT(4) Rename | Drop
bookings INT(4) ✓ Rename | Drop
location VARCHAR(500) ✓ Rename | Drop
description VARCHAR(500) ✓ Rename | Drop
created_at TIMESTAMP ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_events_1 id ✓ SQL
-- no sql found --
 Drop