Query

database.db — reservations

SQL

CREATE TABLE `reservations`  (
  uuid VARCHAR(100) NOT NULL UNIQUE,
  event VARCHAR(100) NOT NULL,
  memberID VARCHAR(3) NOT NULL,
  firstName VARCHAR(100) NOT NULL,
  lastName VARCHAR(100) NOT NULL,
  email VARCHAR(100) NOT NULL,
  persons VARCHAR(255) NOT NULL,
  bookings VARCHAR(3) NOT NULL,
  validated TIMESTAMP,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `status` TEXT NOT NULL DEFAULT '[]'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
uuid VARCHAR(100) Rename | Drop
event VARCHAR(100) Rename | Drop
memberID VARCHAR(3) Rename | Drop
firstName VARCHAR(100) Rename | Drop
lastName VARCHAR(100) Rename | Drop
email VARCHAR(100) Rename | Drop
persons VARCHAR(255) Rename | Drop
bookings VARCHAR(3) Rename | Drop
validated TIMESTAMP ✓ Rename | Drop
created_at TIMESTAMP ✓ Rename | Drop
status TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_reservations_1 uuid ✓ SQL
-- no sql found --
 Drop